DEAD_CAP,
FLCO_CAP,
NOTE,
COLL_TIME,
UPD_TIME,
REC_PERS,
ENG_REIN_FORCE_GUID,
GUID,
P_GUID,
ENG_NAME,
ENG_GUID,
IMPO_GRAD,
APPR_BUDG,
START_DATE,
COMP_DATE,
ENG_STAT,
ORG_GUID,
OFLP_CODE,
IF_REIN_FORCE,
PROJ_GUID,
STAT,
RES_CODE,
CEN_LONG,
CEN_LAT,
RES_LOC,
RV_GUID,
AD_GUID,
ENG_GRAD,
ENG_SCAL,
DAM_TYPE_MAT,
DAM_TYPE_STR,
DAM_SIZE_HIG,
DAM_SIZE_LEN,
DAM_CRE_ELV,
DES_FL_STAND,
FL_LOW_LIM_LEV,
FL_LOW_LIM_LEV_START,
FL_LOW_LIM_LEV_END,
DES_FL_STAG,
MAIN_FL_TYPE,
DEAD_LEV,
TOT_CAP
#{deadCap},
#{flcoCap},
#{note},
#{collTime},
#{updTime},
#{recPers},
#{engReinForceGuid},
#{guid},
#{pGuid},
#{engName},
#{engGuid},
#{impoGrad},
#{apprBudg},
#{startDate},
#{compDate},
#{engStat},
#{orgGuid},
#{oflpCode},
#{ifReinForce},
#{projGuid},
#{stat},
#{resCode},
#{cenLong},
#{cenLat},
#{resLoc},
#{rvGuid},
#{adGuid},
#{engGrad},
#{engScal},
#{damTypeMat},
#{damTypeStr},
#{damSizeHig},
#{damSizeLen},
#{damCreElv},
#{desFlStand},
#{flLowLimLev},
#{flLowLimLevStart},
#{flLowLimLevEnd},
#{desFlStag},
#{mainFlType},
#{deadLev},
#{totCap}
and FLCO_CAP = #{flcoCap}
and NOTE = #{note}
and COLL_TIME = #{collTime}
and UPD_TIME = #{updTime}
and REC_PERS = #{recPers}
and ENG_REIN_FORCE_GUID = #{engReinForceGuid}
and GUID = #{guid}
and P_GUID = #{pGuid}
and ENG_NAME = #{engName}
and ENG_GUID = #{engGuid}
and IMPO_GRAD = #{impoGrad}
and APPR_BUDG = #{apprBudg}
and START_DATE = #{startDate}
and COMP_DATE = #{compDate}
and ENG_STAT = #{engStat}
and ORG_GUID = #{orgGuid}
and OFLP_CODE = #{oflpCode}
and IF_REIN_FORCE = #{ifReinForce}
and PROJ_GUID = #{projGuid}
and STAT = #{stat}
and RES_CODE = #{resCode}
and CEN_LONG = #{cenLong}
and CEN_LAT = #{cenLat}
and RES_LOC = #{resLoc}
and RV_GUID = #{rvGuid}
and AD_GUID = #{adGuid}
and ENG_GRAD = #{engGrad}
and ENG_SCAL = #{engScal}
and DAM_TYPE_MAT = #{damTypeMat}
and DAM_TYPE_STR = #{damTypeStr}
and DAM_SIZE_HIG = #{damSizeHig}
and DAM_SIZE_LEN = #{damSizeLen}
and DAM_CRE_ELV = #{damCreElv}
and DES_FL_STAND = #{desFlStand}
and FL_LOW_LIM_LEV = #{flLowLimLev}
and FL_LOW_LIM_LEV_START = #{flLowLimLevStart}
and FL_LOW_LIM_LEV_END = #{flLowLimLevEnd}
and DES_FL_STAG = #{desFlStag}
and MAIN_FL_TYPE = #{mainFlType}
and DEAD_LEV = #{deadLev}
and TOT_CAP = #{totCap}
insert into ATT_ENG_RES( )
values ( )
delete from ATT_ENG_RES where ID = #{id}
delete from ATT_ENG_RES
update ATT_ENG_RES set flag_valid = 0 where ID = #{id}
update ATT_ENG_RES
FLCO_CAP = #{flcoCap},
NOTE = #{note},
COLL_TIME = #{collTime},
UPD_TIME = #{updTime},
REC_PERS = #{recPers},
ENG_REIN_FORCE_GUID = #{engReinForceGuid},
GUID = #{guid},
P_GUID = #{pGuid},
ENG_NAME = #{engName},
ENG_GUID = #{engGuid},
IMPO_GRAD = #{impoGrad},
APPR_BUDG = #{apprBudg},
START_DATE = #{startDate},
COMP_DATE = #{compDate},
ENG_STAT = #{engStat},
ORG_GUID = #{orgGuid},
OFLP_CODE = #{oflpCode},
IF_REIN_FORCE = #{ifReinForce},
PROJ_GUID = #{projGuid},
STAT = #{stat},
RES_CODE = #{resCode},
CEN_LONG = #{cenLong},
CEN_LAT = #{cenLat},
RES_LOC = #{resLoc},
RV_GUID = #{rvGuid},
AD_GUID = #{adGuid},
ENG_GRAD = #{engGrad},
ENG_SCAL = #{engScal},
DAM_TYPE_MAT = #{damTypeMat},
DAM_TYPE_STR = #{damTypeStr},
DAM_SIZE_HIG = #{damSizeHig},
DAM_SIZE_LEN = #{damSizeLen},
DAM_CRE_ELV = #{damCreElv},
DES_FL_STAND = #{desFlStand},
FL_LOW_LIM_LEV = #{flLowLimLev},
FL_LOW_LIM_LEV_START = #{flLowLimLevStart},
FL_LOW_LIM_LEV_END = #{flLowLimLevEnd},
DES_FL_STAG = #{desFlStag},
MAIN_FL_TYPE = #{mainFlType},
DEAD_LEV = #{deadLev},
TOT_CAP = #{totCap},
ID = #{id}
update ATT_ENG_RES
FLCO_CAP = #{flcoCap},
NOTE = #{note},
COLL_TIME = #{collTime},
UPD_TIME = #{updTime},
REC_PERS = #{recPers},
ENG_REIN_FORCE_GUID = #{engReinForceGuid},
GUID = #{guid},
P_GUID = #{pGuid},
ENG_NAME = #{engName},
ENG_GUID = #{engGuid},
IMPO_GRAD = #{impoGrad},
APPR_BUDG = #{apprBudg},
START_DATE = #{startDate},
COMP_DATE = #{compDate},
ENG_STAT = #{engStat},
ORG_GUID = #{orgGuid},
OFLP_CODE = #{oflpCode},
IF_REIN_FORCE = #{ifReinForce},
PROJ_GUID = #{projGuid},
STAT = #{stat},
RES_CODE = #{resCode},
CEN_LONG = #{cenLong},
CEN_LAT = #{cenLat},
RES_LOC = #{resLoc},
RV_GUID = #{rvGuid},
AD_GUID = #{adGuid},
ENG_GRAD = #{engGrad},
ENG_SCAL = #{engScal},
DAM_TYPE_MAT = #{damTypeMat},
DAM_TYPE_STR = #{damTypeStr},
DAM_SIZE_HIG = #{damSizeHig},
DAM_SIZE_LEN = #{damSizeLen},
DAM_CRE_ELV = #{damCreElv},
DES_FL_STAND = #{desFlStand},
FL_LOW_LIM_LEV = #{flLowLimLev},
FL_LOW_LIM_LEV_START = #{flLowLimLevStart},
FL_LOW_LIM_LEV_END = #{flLowLimLevEnd},
DES_FL_STAG = #{desFlStag},
MAIN_FL_TYPE = #{mainFlType},
DEAD_LEV = #{deadLev},
TOT_CAP = #{totCap},
and o.ad_code=#{province}
and o.ad_code is null