ID,
ORG_ID,
PROVINCE,
ACCUNT_PRP,
ACCUNT_MTTR,
ACCUNT_MPRP,
ACCUNT_NAME,
AD_CODE,
AD_NAME,
LOC,
ACCUNT_ITEM,
ACCUNT_KIND,
ACCUNT_TM,
ACCUNT_STAT,
NOTE,
PERS_ID,
INTM,
UPTM,
UNIT_NAME,
DATA_STAT
#{id},
#{orgId},
#{province},
#{accuntPrp},
#{accuntMttr},
#{accuntMprp},
#{accuntName},
#{adCode},
#{adName},
#{loc},
#{accuntItem},
#{accuntKind},
#{accuntTm},
#{accuntStat},
#{note},
#{persId},
#{intm},
#{uptm},
#{unitName},
#{dataStat}
and ORG_ID = #{orgId}
and DATE_FORMAT(ACCUNT_TM,'%Y') = #{year}
and PROVINCE like '%${province}%'
and ACCUNT_PRP = #{accuntPrp}
and ACCUNT_MTTR = #{accuntMttr}
and ACCUNT_MPRP = #{accuntMprp}
and ACCUNT_NAME = #{accuntName}
and UNIT_NAME = #{unitName}
and AD_CODE = #{adCode}
and AD_NAME like '%${adName}%'
and LOC = #{loc}
and ACCUNT_ITEM = #{accuntItem}
and ACCUNT_KIND like '%${accuntKind}%'
and ACCUNT_TM = #{accuntTm}
and ACCUNT_STAT = #{accuntStat}
and NOTE = #{note}
and PERS_ID = #{persId}
and INTM = #{intm}
and UPTM = #{uptm}
and DATA_STAT ='0'
insert into BIS_INSP_ACCUNT(
)
values (
)
update BIS_INSP_ACCUNT set DATA_STAT='9' where ID = #{id}
delete from BIS_INSP_ACCUNT
update BIS_INSP_ACCUNT set flag_valid = 0 where ID = #{id}
update BIS_INSP_ACCUNT
ORG_ID = #{orgId},
PROVINCE = #{province},
ACCUNT_PRP = #{accuntPrp},
ACCUNT_MTTR = #{accuntMttr},
ACCUNT_MPRP = #{accuntMprp},
ACCUNT_NAME = #{accuntName},
AD_CODE = #{adCode},
AD_NAME = #{adName},
LOC = #{loc},
ACCUNT_ITEM = #{accuntItem},
ACCUNT_KIND = #{accuntKind},
ACCUNT_TM = #{accuntTm},
ACCUNT_STAT = #{accuntStat},
NOTE = #{note},
PERS_ID = #{persId},
INTM = #{intm},
UPTM = #{uptm},
DATA_STAT = #{dataStat},
ID = #{id}
update BIS_INSP_ACCUNT
ORG_ID = #{orgId},
PROVINCE = #{province},
ACCUNT_PRP = #{accuntPrp},
ACCUNT_MTTR = #{accuntMttr},
ACCUNT_MPRP = #{accuntMprp},
ACCUNT_NAME = #{accuntName},
AD_CODE = #{adCode},
AD_NAME = #{adName},
LOC = #{loc},
ACCUNT_ITEM = #{accuntItem},
ACCUNT_KIND = #{accuntKind},
ACCUNT_TM = #{accuntTm},
ACCUNT_STAT = #{accuntStat},
NOTE = #{note},
PERS_ID = #{persId},
INTM = #{intm},
UPTM = #{uptm},
DATA_STAT = #{dataStat},