PROJID, DATAVERSION, TRANSACT_USER, TRANSACT_TIME, HANDLESTART, TRANSACT_DESCRIBE, TRANSACT_RESULT, RESULT_CODE, REMARK, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, ELECTRONIC_RECORDS, RESULTS_TIME, HANDER_DEPTNAME, HANDER_DEPTID, AREACODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ select from pre_transact where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} delete from pre_transact where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} insert into pre_transact (PROJID, DATAVERSION, TRANSACT_USER, TRANSACT_TIME, HANDLESTART, TRANSACT_DESCRIBE, TRANSACT_RESULT, RESULT_CODE, REMARK, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, ELECTRONIC_RECORDS, RESULTS_TIME, HANDER_DEPTNAME, HANDER_DEPTID, AREACODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ ) values (#{PROJID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{TRANSACT_USER,jdbcType=VARCHAR}, #{TRANSACT_TIME,jdbcType=TIMESTAMP}, #{HANDLESTART,jdbcType=VARCHAR}, #{TRANSACT_DESCRIBE,jdbcType=VARCHAR}, #{TRANSACT_RESULT,jdbcType=VARCHAR}, #{RESULT_CODE,jdbcType=VARCHAR}, #{REMARK,jdbcType=VARCHAR}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=LONGVARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{ELECTRONIC_RECORDS,jdbcType=LONGVARCHAR}, #{RESULTS_TIME,jdbcType=VARCHAR}, #{HANDER_DEPTNAME,jdbcType=VARCHAR}, #{HANDER_DEPTID,jdbcType=VARCHAR}, #{AREACODE,jdbcType=VARCHAR}, #{JH_SJC_DXP,jdbcType=TIMESTAMP}, #{JH_SJZT,jdbcType=CHAR}, #{JH_SCJG,jdbcType=CHAR}, #{JH_SCJGMC,jdbcType=VARCHAR}, #{JH_MBJG,jdbcType=VARCHAR}, #{JH_YCBJ,jdbcType=VARCHAR} ) insert into pre_transact PROJID, DATAVERSION, TRANSACT_USER, TRANSACT_TIME, HANDLESTART, TRANSACT_DESCRIBE, TRANSACT_RESULT, RESULT_CODE, REMARK, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, ELECTRONIC_RECORDS, RESULTS_TIME, HANDER_DEPTNAME, HANDER_DEPTID, AREACODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ, #{PROJID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{TRANSACT_USER,jdbcType=VARCHAR}, #{TRANSACT_TIME,jdbcType=TIMESTAMP}, #{HANDLESTART,jdbcType=VARCHAR}, #{TRANSACT_DESCRIBE,jdbcType=VARCHAR}, #{TRANSACT_RESULT,jdbcType=VARCHAR}, #{RESULT_CODE,jdbcType=VARCHAR}, #{REMARK,jdbcType=VARCHAR}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=LONGVARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{ELECTRONIC_RECORDS,jdbcType=LONGVARCHAR}, #{RESULTS_TIME,jdbcType=VARCHAR}, #{HANDER_DEPTNAME,jdbcType=VARCHAR}, #{HANDER_DEPTID,jdbcType=VARCHAR}, #{AREACODE,jdbcType=VARCHAR}, #{JH_SJC_DXP,jdbcType=TIMESTAMP}, #{JH_SJZT,jdbcType=CHAR}, #{JH_SCJG,jdbcType=CHAR}, #{JH_SCJGMC,jdbcType=VARCHAR}, #{JH_MBJG,jdbcType=VARCHAR}, #{JH_YCBJ,jdbcType=VARCHAR}, update pre_transact TRANSACT_USER = #{TRANSACT_USER,jdbcType=VARCHAR}, TRANSACT_TIME = #{TRANSACT_TIME,jdbcType=TIMESTAMP}, HANDLESTART = #{HANDLESTART,jdbcType=VARCHAR}, TRANSACT_DESCRIBE = #{TRANSACT_DESCRIBE,jdbcType=VARCHAR}, TRANSACT_RESULT = #{TRANSACT_RESULT,jdbcType=VARCHAR}, RESULT_CODE = #{RESULT_CODE,jdbcType=VARCHAR}, REMARK = #{REMARK,jdbcType=VARCHAR}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=LONGVARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, ELECTRONIC_RECORDS = #{ELECTRONIC_RECORDS,jdbcType=LONGVARCHAR}, RESULTS_TIME = #{RESULTS_TIME,jdbcType=VARCHAR}, HANDER_DEPTNAME = #{HANDER_DEPTNAME,jdbcType=VARCHAR}, HANDER_DEPTID = #{HANDER_DEPTID,jdbcType=VARCHAR}, AREACODE = #{AREACODE,jdbcType=VARCHAR}, JH_SJC_DXP = #{JH_SJC_DXP,jdbcType=TIMESTAMP}, JH_SJZT = #{JH_SJZT,jdbcType=CHAR}, JH_SCJG = #{JH_SCJG,jdbcType=CHAR}, JH_SCJGMC = #{JH_SCJGMC,jdbcType=VARCHAR}, JH_MBJG = #{JH_MBJG,jdbcType=VARCHAR}, JH_YCBJ = #{JH_YCBJ,jdbcType=VARCHAR}, where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} update pre_transact set TRANSACT_USER = #{TRANSACT_USER,jdbcType=VARCHAR}, TRANSACT_TIME = #{TRANSACT_TIME,jdbcType=TIMESTAMP}, HANDLESTART = #{HANDLESTART,jdbcType=VARCHAR}, TRANSACT_DESCRIBE = #{TRANSACT_DESCRIBE,jdbcType=VARCHAR}, TRANSACT_RESULT = #{TRANSACT_RESULT,jdbcType=VARCHAR}, RESULT_CODE = #{RESULT_CODE,jdbcType=VARCHAR}, REMARK = #{REMARK,jdbcType=VARCHAR}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=LONGVARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, ELECTRONIC_RECORDS = #{ELECTRONIC_RECORDS,jdbcType=LONGVARCHAR}, RESULTS_TIME = #{RESULTS_TIME,jdbcType=VARCHAR}, HANDER_DEPTNAME = #{HANDER_DEPTNAME,jdbcType=VARCHAR}, HANDER_DEPTID = #{HANDER_DEPTID,jdbcType=VARCHAR}, AREACODE = #{AREACODE,jdbcType=VARCHAR}, JH_SJC_DXP = #{JH_SJC_DXP,jdbcType=TIMESTAMP}, JH_SJZT = #{JH_SJZT,jdbcType=CHAR}, JH_SCJG = #{JH_SCJG,jdbcType=CHAR}, JH_SCJGMC = #{JH_SCJGMC,jdbcType=VARCHAR}, JH_MBJG = #{JH_MBJG,jdbcType=VARCHAR}, JH_YCBJ = #{JH_YCBJ,jdbcType=VARCHAR} where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER}