PROJID, DATAVERSION, ACCEPT_MAN, ACCEPT_TIME, PROMISEVALUE, PROMISETYPE, PROMISE_ETIME, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, HANDER_DEPTNAME, DOCUMENT_CODE, HANDER_DEPTID, AREACODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ select from pre_accept where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} delete from pre_accept where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} insert into pre_accept (PROJID, DATAVERSION, ACCEPT_MAN, ACCEPT_TIME, PROMISEVALUE, PROMISETYPE, PROMISE_ETIME, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, HANDER_DEPTNAME, DOCUMENT_CODE, HANDER_DEPTID, AREACODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ ) values (#{PROJID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{ACCEPT_MAN,jdbcType=VARCHAR}, #{ACCEPT_TIME,jdbcType=TIMESTAMP}, #{PROMISEVALUE,jdbcType=VARCHAR}, #{PROMISETYPE,jdbcType=VARCHAR}, #{PROMISE_ETIME,jdbcType=TIMESTAMP}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=LONGVARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{HANDER_DEPTNAME,jdbcType=VARCHAR}, #{DOCUMENT_CODE,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_accept PROJID, DATAVERSION, ACCEPT_MAN, ACCEPT_TIME, PROMISEVALUE, PROMISETYPE, PROMISE_ETIME, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, HANDER_DEPTNAME, DOCUMENT_CODE, HANDER_DEPTID, AREACODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ, #{PROJID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{ACCEPT_MAN,jdbcType=VARCHAR}, #{ACCEPT_TIME,jdbcType=TIMESTAMP}, #{PROMISEVALUE,jdbcType=VARCHAR}, #{PROMISETYPE,jdbcType=VARCHAR}, #{PROMISE_ETIME,jdbcType=TIMESTAMP}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=LONGVARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{HANDER_DEPTNAME,jdbcType=VARCHAR}, #{DOCUMENT_CODE,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_accept ACCEPT_MAN = #{ACCEPT_MAN,jdbcType=VARCHAR}, ACCEPT_TIME = #{ACCEPT_TIME,jdbcType=TIMESTAMP}, PROMISEVALUE = #{PROMISEVALUE,jdbcType=VARCHAR}, PROMISETYPE = #{PROMISETYPE,jdbcType=VARCHAR}, PROMISE_ETIME = #{PROMISE_ETIME,jdbcType=TIMESTAMP}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=LONGVARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, HANDER_DEPTNAME = #{HANDER_DEPTNAME,jdbcType=VARCHAR}, DOCUMENT_CODE = #{DOCUMENT_CODE,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_accept set ACCEPT_MAN = #{ACCEPT_MAN,jdbcType=VARCHAR}, ACCEPT_TIME = #{ACCEPT_TIME,jdbcType=TIMESTAMP}, PROMISEVALUE = #{PROMISEVALUE,jdbcType=VARCHAR}, PROMISETYPE = #{PROMISETYPE,jdbcType=VARCHAR}, PROMISE_ETIME = #{PROMISE_ETIME,jdbcType=TIMESTAMP}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=LONGVARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, HANDER_DEPTNAME = #{HANDER_DEPTNAME,jdbcType=VARCHAR}, DOCUMENT_CODE = #{DOCUMENT_CODE,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} select from pre_apasinfo where PROJID=#{projid,jdbcType=VARCHAR}