PROJID, DATAVERSION, PROJPWD, SERVICECODE, SERVICEVERSION, SERVICENAME, PROJECTNAME, INFOTYPE, BUS_TYPE, REL_BUS_ID, APPLYNAME, APPLY_CARDTYPE, APPLY_CARDNUMBER, CONTACTMAN, CONTACTMAN_CARDTYPE, CONTACTMAN_CARDNUMBER, TELPHONE, POSTCODE, ADDRESS, LEGALMAN, DEPTID, DEPTNAME, APPLYFROM, APPLY_TYPE, BUS_MODE, BUS_MODE_DESC, IS_MANUBRIUM, APPLY_PROPERTIY, RECEIVETIME, ACCEPT_TIME, PROMISEE_TIME, TRANSACT_TIME, HANDLESTATE, BELONGTO, AREACODE, DATASTATE, BELONGSYSTEM, EXTEND, SYNC_STATUS, RECEIVE_USEID, RECEIVE_NAME, CREATE_TIME, SS_ORGCODE, QL_KIND, FLOW_XML, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ select from pre_apasinfo where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} delete from pre_apasinfo where PROJID = #{PROJID,jdbcType=VARCHAR} and DATAVERSION = #{DATAVERSION,jdbcType=INTEGER} insert into pre_apasinfo (PROJID, DATAVERSION, PROJPWD, SERVICECODE, SERVICEVERSION, SERVICENAME, PROJECTNAME, INFOTYPE, BUS_TYPE, REL_BUS_ID, APPLYNAME, APPLY_CARDTYPE, APPLY_CARDNUMBER, CONTACTMAN, CONTACTMAN_CARDTYPE, CONTACTMAN_CARDNUMBER, TELPHONE, POSTCODE, ADDRESS, LEGALMAN, DEPTID, DEPTNAME, APPLYFROM, APPLY_TYPE, BUS_MODE, BUS_MODE_DESC, IS_MANUBRIUM, APPLY_PROPERTIY, RECEIVETIME, ACCEPT_TIME, PROMISEE_TIME, TRANSACT_TIME, HANDLESTATE, BELONGTO, AREACODE, DATASTATE, BELONGSYSTEM, EXTEND, SYNC_STATUS, RECEIVE_USEID, RECEIVE_NAME, CREATE_TIME, SS_ORGCODE, QL_KIND, FLOW_XML, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ ) values (#{PROJID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{PROJPWD,jdbcType=VARCHAR}, #{SERVICECODE,jdbcType=VARCHAR}, #{SERVICEVERSION,jdbcType=INTEGER}, #{SERVICENAME,jdbcType=VARCHAR}, #{PROJECTNAME,jdbcType=VARCHAR}, #{INFOTYPE,jdbcType=VARCHAR}, #{BUS_TYPE,jdbcType=VARCHAR}, #{REL_BUS_ID,jdbcType=VARCHAR}, #{APPLYNAME,jdbcType=VARCHAR}, #{APPLY_CARDTYPE,jdbcType=VARCHAR}, #{APPLY_CARDNUMBER,jdbcType=VARCHAR}, #{CONTACTMAN,jdbcType=VARCHAR}, #{CONTACTMAN_CARDTYPE,jdbcType=VARCHAR}, #{CONTACTMAN_CARDNUMBER,jdbcType=VARCHAR}, #{TELPHONE,jdbcType=VARCHAR}, #{POSTCODE,jdbcType=VARCHAR}, #{ADDRESS,jdbcType=VARCHAR}, #{LEGALMAN,jdbcType=VARCHAR}, #{DEPTID,jdbcType=VARCHAR}, #{DEPTNAME,jdbcType=VARCHAR}, #{APPLYFROM,jdbcType=VARCHAR}, #{APPLY_TYPE,jdbcType=VARCHAR}, #{BUS_MODE,jdbcType=VARCHAR}, #{BUS_MODE_DESC,jdbcType=VARCHAR}, #{IS_MANUBRIUM,jdbcType=VARCHAR}, #{APPLY_PROPERTIY,jdbcType=VARCHAR}, #{RECEIVETIME,jdbcType=TIMESTAMP}, #{ACCEPT_TIME,jdbcType=TIMESTAMP}, #{PROMISEE_TIME,jdbcType=TIMESTAMP}, #{TRANSACT_TIME,jdbcType=TIMESTAMP}, #{HANDLESTATE,jdbcType=VARCHAR}, #{BELONGTO,jdbcType=VARCHAR}, #{AREACODE,jdbcType=VARCHAR}, #{DATASTATE,jdbcType=VARCHAR}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=VARCHAR}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{RECEIVE_USEID,jdbcType=VARCHAR}, #{RECEIVE_NAME,jdbcType=VARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SS_ORGCODE,jdbcType=VARCHAR}, #{QL_KIND,jdbcType=VARCHAR}, #{FLOW_XML,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_apasinfo PROJID, DATAVERSION, PROJPWD, SERVICECODE, SERVICEVERSION, SERVICENAME, PROJECTNAME, INFOTYPE, BUS_TYPE, REL_BUS_ID, APPLYNAME, APPLY_CARDTYPE, APPLY_CARDNUMBER, CONTACTMAN, CONTACTMAN_CARDTYPE, CONTACTMAN_CARDNUMBER, TELPHONE, POSTCODE, ADDRESS, LEGALMAN, DEPTID, DEPTNAME, APPLYFROM, APPLY_TYPE, BUS_MODE, BUS_MODE_DESC, IS_MANUBRIUM, APPLY_PROPERTIY, RECEIVETIME, ACCEPT_TIME, PROMISEE_TIME, TRANSACT_TIME, HANDLESTATE, BELONGTO, AREACODE, DATASTATE, BELONGSYSTEM, EXTEND, SYNC_STATUS, RECEIVE_USEID, RECEIVE_NAME, CREATE_TIME, SS_ORGCODE, QL_KIND, FLOW_XML, JH_SJC_DXP, JH_SJZT, JH_SCJG, JH_SCJGMC, JH_MBJG, JH_YCBJ, #{PROJID,jdbcType=VARCHAR}, #{DATAVERSION,jdbcType=INTEGER}, #{PROJPWD,jdbcType=VARCHAR}, #{SERVICECODE,jdbcType=VARCHAR}, #{SERVICEVERSION,jdbcType=INTEGER}, #{SERVICENAME,jdbcType=VARCHAR}, #{PROJECTNAME,jdbcType=VARCHAR}, #{INFOTYPE,jdbcType=VARCHAR}, #{BUS_TYPE,jdbcType=VARCHAR}, #{REL_BUS_ID,jdbcType=VARCHAR}, #{APPLYNAME,jdbcType=VARCHAR}, #{APPLY_CARDTYPE,jdbcType=VARCHAR}, #{APPLY_CARDNUMBER,jdbcType=VARCHAR}, #{CONTACTMAN,jdbcType=VARCHAR}, #{CONTACTMAN_CARDTYPE,jdbcType=VARCHAR}, #{CONTACTMAN_CARDNUMBER,jdbcType=VARCHAR}, #{TELPHONE,jdbcType=VARCHAR}, #{POSTCODE,jdbcType=VARCHAR}, #{ADDRESS,jdbcType=VARCHAR}, #{LEGALMAN,jdbcType=VARCHAR}, #{DEPTID,jdbcType=VARCHAR}, #{DEPTNAME,jdbcType=VARCHAR}, #{APPLYFROM,jdbcType=VARCHAR}, #{APPLY_TYPE,jdbcType=VARCHAR}, #{BUS_MODE,jdbcType=VARCHAR}, #{BUS_MODE_DESC,jdbcType=VARCHAR}, #{IS_MANUBRIUM,jdbcType=VARCHAR}, #{APPLY_PROPERTIY,jdbcType=VARCHAR}, #{RECEIVETIME,jdbcType=TIMESTAMP}, #{ACCEPT_TIME,jdbcType=TIMESTAMP}, #{PROMISEE_TIME,jdbcType=TIMESTAMP}, #{TRANSACT_TIME,jdbcType=TIMESTAMP}, #{HANDLESTATE,jdbcType=VARCHAR}, #{BELONGTO,jdbcType=VARCHAR}, #{AREACODE,jdbcType=VARCHAR}, #{DATASTATE,jdbcType=VARCHAR}, #{BELONGSYSTEM,jdbcType=VARCHAR}, #{EXTEND,jdbcType=VARCHAR}, #{SYNC_STATUS,jdbcType=VARCHAR}, #{RECEIVE_USEID,jdbcType=VARCHAR}, #{RECEIVE_NAME,jdbcType=VARCHAR}, #{CREATE_TIME,jdbcType=TIMESTAMP}, #{SS_ORGCODE,jdbcType=VARCHAR}, #{QL_KIND,jdbcType=VARCHAR}, #{FLOW_XML,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_apasinfo PROJPWD = #{PROJPWD,jdbcType=VARCHAR}, SERVICECODE = #{SERVICECODE,jdbcType=VARCHAR}, SERVICEVERSION = #{SERVICEVERSION,jdbcType=INTEGER}, SERVICENAME = #{SERVICENAME,jdbcType=VARCHAR}, PROJECTNAME = #{PROJECTNAME,jdbcType=VARCHAR}, INFOTYPE = #{INFOTYPE,jdbcType=VARCHAR}, BUS_TYPE = #{BUS_TYPE,jdbcType=VARCHAR}, REL_BUS_ID = #{REL_BUS_ID,jdbcType=VARCHAR}, APPLYNAME = #{APPLYNAME,jdbcType=VARCHAR}, APPLY_CARDTYPE = #{APPLY_CARDTYPE,jdbcType=VARCHAR}, APPLY_CARDNUMBER = #{APPLY_CARDNUMBER,jdbcType=VARCHAR}, CONTACTMAN = #{CONTACTMAN,jdbcType=VARCHAR}, CONTACTMAN_CARDTYPE = #{CONTACTMAN_CARDTYPE,jdbcType=VARCHAR}, CONTACTMAN_CARDNUMBER = #{CONTACTMAN_CARDNUMBER,jdbcType=VARCHAR}, TELPHONE = #{TELPHONE,jdbcType=VARCHAR}, POSTCODE = #{POSTCODE,jdbcType=VARCHAR}, ADDRESS = #{ADDRESS,jdbcType=VARCHAR}, LEGALMAN = #{LEGALMAN,jdbcType=VARCHAR}, DEPTID = #{DEPTID,jdbcType=VARCHAR}, DEPTNAME = #{DEPTNAME,jdbcType=VARCHAR}, APPLYFROM = #{APPLYFROM,jdbcType=VARCHAR}, APPLY_TYPE = #{APPLY_TYPE,jdbcType=VARCHAR}, BUS_MODE = #{BUS_MODE,jdbcType=VARCHAR}, BUS_MODE_DESC = #{BUS_MODE_DESC,jdbcType=VARCHAR}, IS_MANUBRIUM = #{IS_MANUBRIUM,jdbcType=VARCHAR}, APPLY_PROPERTIY = #{APPLY_PROPERTIY,jdbcType=VARCHAR}, RECEIVETIME = #{RECEIVETIME,jdbcType=TIMESTAMP}, ACCEPT_TIME = #{ACCEPT_TIME,jdbcType=TIMESTAMP}, PROMISEE_TIME = #{PROMISEE_TIME,jdbcType=TIMESTAMP}, TRANSACT_TIME = #{TRANSACT_TIME,jdbcType=TIMESTAMP}, HANDLESTATE = #{HANDLESTATE,jdbcType=VARCHAR}, BELONGTO = #{BELONGTO,jdbcType=VARCHAR}, AREACODE = #{AREACODE,jdbcType=VARCHAR}, DATASTATE = #{DATASTATE,jdbcType=VARCHAR}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=VARCHAR}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, RECEIVE_USEID = #{RECEIVE_USEID,jdbcType=VARCHAR}, RECEIVE_NAME = #{RECEIVE_NAME,jdbcType=VARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SS_ORGCODE = #{SS_ORGCODE,jdbcType=VARCHAR}, QL_KIND = #{QL_KIND,jdbcType=VARCHAR}, FLOW_XML = #{FLOW_XML,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_apasinfo set PROJPWD = #{PROJPWD,jdbcType=VARCHAR}, SERVICECODE = #{SERVICECODE,jdbcType=VARCHAR}, SERVICEVERSION = #{SERVICEVERSION,jdbcType=INTEGER}, SERVICENAME = #{SERVICENAME,jdbcType=VARCHAR}, PROJECTNAME = #{PROJECTNAME,jdbcType=VARCHAR}, INFOTYPE = #{INFOTYPE,jdbcType=VARCHAR}, BUS_TYPE = #{BUS_TYPE,jdbcType=VARCHAR}, REL_BUS_ID = #{REL_BUS_ID,jdbcType=VARCHAR}, APPLYNAME = #{APPLYNAME,jdbcType=VARCHAR}, APPLY_CARDTYPE = #{APPLY_CARDTYPE,jdbcType=VARCHAR}, APPLY_CARDNUMBER = #{APPLY_CARDNUMBER,jdbcType=VARCHAR}, CONTACTMAN = #{CONTACTMAN,jdbcType=VARCHAR}, CONTACTMAN_CARDTYPE = #{CONTACTMAN_CARDTYPE,jdbcType=VARCHAR}, CONTACTMAN_CARDNUMBER = #{CONTACTMAN_CARDNUMBER,jdbcType=VARCHAR}, TELPHONE = #{TELPHONE,jdbcType=VARCHAR}, POSTCODE = #{POSTCODE,jdbcType=VARCHAR}, ADDRESS = #{ADDRESS,jdbcType=VARCHAR}, LEGALMAN = #{LEGALMAN,jdbcType=VARCHAR}, DEPTID = #{DEPTID,jdbcType=VARCHAR}, DEPTNAME = #{DEPTNAME,jdbcType=VARCHAR}, APPLYFROM = #{APPLYFROM,jdbcType=VARCHAR}, APPLY_TYPE = #{APPLY_TYPE,jdbcType=VARCHAR}, BUS_MODE = #{BUS_MODE,jdbcType=VARCHAR}, BUS_MODE_DESC = #{BUS_MODE_DESC,jdbcType=VARCHAR}, IS_MANUBRIUM = #{IS_MANUBRIUM,jdbcType=VARCHAR}, APPLY_PROPERTIY = #{APPLY_PROPERTIY,jdbcType=VARCHAR}, RECEIVETIME = #{RECEIVETIME,jdbcType=TIMESTAMP}, ACCEPT_TIME = #{ACCEPT_TIME,jdbcType=TIMESTAMP}, PROMISEE_TIME = #{PROMISEE_TIME,jdbcType=TIMESTAMP}, TRANSACT_TIME = #{TRANSACT_TIME,jdbcType=TIMESTAMP}, HANDLESTATE = #{HANDLESTATE,jdbcType=VARCHAR}, BELONGTO = #{BELONGTO,jdbcType=VARCHAR}, AREACODE = #{AREACODE,jdbcType=VARCHAR}, DATASTATE = #{DATASTATE,jdbcType=VARCHAR}, BELONGSYSTEM = #{BELONGSYSTEM,jdbcType=VARCHAR}, EXTEND = #{EXTEND,jdbcType=VARCHAR}, SYNC_STATUS = #{SYNC_STATUS,jdbcType=VARCHAR}, RECEIVE_USEID = #{RECEIVE_USEID,jdbcType=VARCHAR}, RECEIVE_NAME = #{RECEIVE_NAME,jdbcType=VARCHAR}, CREATE_TIME = #{CREATE_TIME,jdbcType=TIMESTAMP}, SS_ORGCODE = #{SS_ORGCODE,jdbcType=VARCHAR}, QL_KIND = #{QL_KIND,jdbcType=VARCHAR}, FLOW_XML = #{FLOW_XML,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_apasinfo set HANDLESTATE=#{HANDLESTATE,jdbcType=VARCHAR} where PROJID=#{PROJID,jdbcType=VARCHAR} select from pre_apasinfo where PROJID=#{PROJID,jdbcType=VARCHAR}