UNID, DATAVERSION, PROJID, `ACTION`, NODE_NAME, `NAME`, OPINION, START_TIME, END_TIME, REMARK, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, NEXT_NODE_NAME, HANDER_DEPTNAME, HANDER_DEPTID, AREACODE, PHASE_NAME, PHASE_CODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ select from pre_node where UNID = #{UNID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} delete from pre_node where UNID = #{UNID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} insert into pre_node (UNID, DATAVERSION, PROJID, `ACTION`, NODE_NAME, `NAME`, OPINION, START_TIME, END_TIME, REMARK, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, NEXT_NODE_NAME, HANDER_DEPTNAME, HANDER_DEPTID, AREACODE, PHASE_NAME, PHASE_CODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ) values (#{UNID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{PROJID,jdbcType=VARCHAR}, #{ACTION,jdbcType=VARCHAR}, #{NODE_NAME,jdbcType=VARCHAR}, #{NAME,jdbcType=VARCHAR}, #{OPINION,jdbcType=VARCHAR}, #{START_TIME,jdbcType=TIMESTAMP}, #{END_TIME,jdbcType=TIMESTAMP}, #{REMARK,jdbcType=VARCHAR}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=LONGVARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{NEXT_NODE_NAME,jdbcType=VARCHAR}, #{HANDER_DEPTNAME,jdbcType=VARCHAR}, #{HANDER_DEPTID,jdbcType=VARCHAR}, #{AREACODE,jdbcType=VARCHAR}, #{PHASE_NAME,jdbcType=VARCHAR}, #{PHASE_CODE,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_node UNID, DATAVERSION, PROJID, `ACTION`, NODE_NAME, `NAME`, OPINION, START_TIME, END_TIME, REMARK, BELONGSYSTEM, EXTEND, CREATE_TIME, SYNC_STATUS, NEXT_NODE_NAME, HANDER_DEPTNAME, HANDER_DEPTID, AREACODE, PHASE_NAME, PHASE_CODE, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ, #{UNID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{PROJID,jdbcType=VARCHAR}, #{ACTION,jdbcType=VARCHAR}, #{NODE_NAME,jdbcType=VARCHAR}, #{NAME,jdbcType=VARCHAR}, #{OPINION,jdbcType=VARCHAR}, #{START_TIME,jdbcType=TIMESTAMP}, #{END_TIME,jdbcType=TIMESTAMP}, #{REMARK,jdbcType=VARCHAR}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=LONGVARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{NEXT_NODE_NAME,jdbcType=VARCHAR}, #{HANDER_DEPTNAME,jdbcType=VARCHAR}, #{HANDER_DEPTID,jdbcType=VARCHAR}, #{AREACODE,jdbcType=VARCHAR}, #{PHASE_NAME,jdbcType=VARCHAR}, #{PHASE_CODE,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_node PROJID = #{PROJID,jdbcType=VARCHAR}, `ACTION` = #{ACTION,jdbcType=VARCHAR}, NODE_NAME = #{NODE_NAME,jdbcType=VARCHAR}, `NAME` = #{NAME,jdbcType=VARCHAR}, OPINION = #{OPINION,jdbcType=VARCHAR}, START_TIME = #{START_TIME,jdbcType=TIMESTAMP}, END_TIME = #{END_TIME,jdbcType=TIMESTAMP}, REMARK = #{REMARK,jdbcType=VARCHAR}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=LONGVARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, NEXT_NODE_NAME = #{NEXT_NODE_NAME,jdbcType=VARCHAR}, HANDER_DEPTNAME = #{HANDER_DEPTNAME,jdbcType=VARCHAR}, HANDER_DEPTID = #{HANDER_DEPTID,jdbcType=VARCHAR}, AREACODE = #{AREACODE,jdbcType=VARCHAR}, PHASE_NAME = #{PHASE_NAME,jdbcType=VARCHAR}, PHASE_CODE = #{PHASE_CODE,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 UNID = #{UNID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} update pre_node set PROJID = #{PROJID,jdbcType=VARCHAR}, `ACTION` = #{ACTION,jdbcType=VARCHAR}, NODE_NAME = #{NODE_NAME,jdbcType=VARCHAR}, `NAME` = #{NAME,jdbcType=VARCHAR}, OPINION = #{OPINION,jdbcType=VARCHAR}, START_TIME = #{START_TIME,jdbcType=TIMESTAMP}, END_TIME = #{END_TIME,jdbcType=TIMESTAMP}, REMARK = #{REMARK,jdbcType=VARCHAR}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=LONGVARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, NEXT_NODE_NAME = #{NEXT_NODE_NAME,jdbcType=VARCHAR}, HANDER_DEPTNAME = #{HANDER_DEPTNAME,jdbcType=VARCHAR}, HANDER_DEPTID = #{HANDER_DEPTID,jdbcType=VARCHAR}, AREACODE = #{AREACODE,jdbcType=VARCHAR}, PHASE_NAME = #{PHASE_NAME,jdbcType=VARCHAR}, PHASE_CODE = #{PHASE_CODE,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 UNID = #{UNID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER}