select a.CREATED ,a.ITEM_AUDITSTATUS as AUDITSTATUS, a.ITEM_REGION as REGION, a.ITEM_SEVICEPERMITTYPE, a.ITEM_FORM_NAME, a.ITEM_OFFICEPOLICEADDRESS, a.ITEM_OFFICEPOLICEADDRESSID, a.ITEM_OFFICEPOLICEIDINDEX, a.ITEM_COMPANYNAME, a.ITEM_COMPANYTYPE, a.ITEM_ADDRESS, a.ITEM_ZIPCODE, a.ITEM_PHONE, a.ITEM_PROPERTYRIGHTS, a.ITEM_HOUSINGAREA, a.ITEM_MANAGERNUMS, a.ITEM_TECHNICIANNUMS, a.ITEM_REGISTEREDCAPITAL, a.ITEM_CARNUMS, a.ITEM_GUNNUMS, a.ITEM_BUSINESSSCOPE, a.ITEM_LEGALNAME, a.ITEM_LEGALCARDNUMBER, a.ITEM_LEGALPHONE, a.ITEM_DOMAIN_ID, a.ITEM_TEMPLATERARFILE, a.ITEM_PERMIT, a.ITEM_REJECTREASON, a.ID, a.ITEM_BACKGROUNDSTATUS,b.ITEM_SHAREHOLDER,b.ITEM_DOCUMENTID, b.ITEM_SHAREHOLDERTYPE,b.ITEM_DOCUMENTTYPE,b.ITEM_CAPITALCONTRIBUTION,b.ITEM_STOCKPROPORTION,b.ITEM_ADDRESS,b.ITEM_DOMAIN_ID,b.ITEM_NATIONALITY,b.ITEM_NATION,b.ITEM_HOUSEHOLD,b.ITEM_TOPID, b.id as CID,b.created as bcreated,b.formid,b.applicationid,b.lastmodified,c.id as PID,c.item_NAME as PNAME,c.item_DOCUMENTID as PDOCUMENTID, c.created as PCreated,c.item_SEX as PSEX,c.item_DOCUMENTTYPE as PDOCUMENTTYPE,c.item_JOBTYPE as PJOBTYPE, c.item_ISVETERAN as PISVETERAN,c.item_NATION as PNATION,c.item_HOUSEHOLD as PHOUSEHOLD,c.item_EDUCATION as PEDUCATION,c.item_SKILLLEVEL as PSKILLLEVEL, c.item_PHONE as PPHONE,c.item_ADDRESS as PADDRESS,c.item_DEPTNAME as PDEPTNAME,c.item_DOMAIN_ID as PDOMAIN_ID,c.item_TOPID as PTOPID from securityflow.tlk_securitysevicek a left join securityflow.tlk_companypermitshareholder b on b.item_topid=a.id left join tlk_CompanyPermitManagementLayer c on c.item_topid=a.id a.ID in #{id} where ID = #{id} insert into securityflow.tlk_securitysevicek PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHORDEPTID, AUTHOR_DEPT_INDEX, AUTHOR_USER_INDEX, CREATED, FORMID, SUBFORMIDS, INITIATOR, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_REGION, ITEM_SEVICEPERMITTYPE, ITEM_FORM_NAME, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_COMPANYTYPE, ITEM_ADDRESS, ITEM_ZIPCODE, ITEM_PHONE, ITEM_PROPERTYRIGHTS, ITEM_HOUSINGAREA, ITEM_MANAGERNUMS, ITEM_TECHNICIANNUMS, ITEM_REGISTEREDCAPITAL, ITEM_CARNUMS, ITEM_GUNNUMS, ITEM_BUSINESSSCOPE, ITEM_LEGALNAME, ITEM_LEGALCARDNUMBER, ITEM_LEGALPHONE, ITEM_DOMAIN_ID, ITEM_TEMPLATERARFILE, ITEM_PERMIT, ITEM_REJECTREASON, ID, ITEM_ss, ITEM_BACKGROUNDSTATUS, #{parent}, #{lastmodified}, #{formname}, #{state}, #{audituser}, #{auditdate}, #{author}, #{authordeptid}, #{authorDeptIndex}, #{authorUserIndex}, #{created}, #{formid}, #{subformids}, #{initiator}, #{istmp}, #{versions}, #{applicationid}, #{stateint}, #{statelabel}, #{auditornames}, #{lastflowoperation}, #{lastmodifier}, #{domainid}, #{auditorlist}, #{coauditorlist}, #{statelabelinfo}, #{prevauditnode}, #{prevaudituser}, #{optionitem}, #{sign}, #{kinggridsignature}, '3', #{tlkformname}, #{region}, #{sevicepermittype}, #{formName}, #{officepoliceaddress}, #{officepoliceaddressid}, #{officepoliceidindex}, #{companyname}, #{companytype}, #{address}, #{zipcode}, #{phone}, #{propertyrights}, #{housingarea}, #{managernums}, #{techniciannums}, #{registeredcapital}, #{carnums}, #{gunnums}, #{businessscope}, #{legalname}, #{legalcardnumber}, #{legalphone}, #{domainId}, #{templaterarfile}, #{permit}, #{rejectreason}, #{id}, #{ss}, #{backgroundstatus}, insert into securityflow.tlk_companypermitshareholder LASTMODIFIED, CREATED, FORMID, APPLICATIONID, DOMAINID, ITEM_SHAREHOLDER, ITEM_DOCUMENTID, ITEM_SHAREHOLDERTYPE, ITEM_DOCUMENTTYPE, ITEM_CAPITALCONTRIBUTION, ITEM_STOCKPROPORTION, ITEM_ADDRESS, ITEM_DOMAIN_ID, ITEM_SEX, ITEM_NATION, ITEM_NATIONALITY, ITEM_HOUSEHOLD, ID, ITEM_TOPID, #{lastmodified}, #{created}, #{formid}, #{applicationid}, #{domainid}, #{shareHolder}, #{DOCUMENTID}, #{SHAREHOLDERTYPE}, #{DOCUMENTTYPE}, #{CAPITALCONTRIBUTION}, #{STOCKPROPORTION}, #{ADDRESS}, #{DOMAIN_ID}, #{SEX}, #{NATION}, #{NATIONALITY}, #{HOUSEHOLD}, #{id}, #{TOPID}, insert into securityflow.tlk_CompanyPermitManagementLayer LASTMODIFIED, CREATED, FORMID, APPLICATIONID, DOMAINID, ITEM_NAME, ITEM_SEX, ITEM_DOCUMENTID, ITEM_JOBTYPE, ITEM_DOCUMENTTYPE, ITEM_ISVETERAN, ITEM_NATION, ITEM_HOUSEHOLD, ITEM_EDUCATION, ITEM_SKILLLEVEL, ITEM_PHONE, ITEM_ADDRESS, ID, ITEM_DEPTNAME, ITEM_TOPID, #{lastmodified}, #{created}, #{formid}, #{applicationid}, #{domainid}, #{NAME}, #{SEX}, #{DOCUMENTID}, #{JOBTYPE}, #{DOCUMENTTYPE}, #{ISVETERAN}, #{NATION}, #{HOUSEHOLD}, #{EDUCATION}, #{SKILLLEVEL}, #{PHONE}, #{ADDRESS}, #{id}, #{DEPTNAME}, #{TOPID}, update securityflow.tlk_securitysevicek PARENT = #{parent}, LASTMODIFIED = #{lastmodified}, FORMNAME = #{formname}, STATE = #{state}, AUDITUSER = #{audituser}, AUDITDATE = #{auditdate}, AUTHOR = #{author}, AUTHORDEPTID = #{authordeptid}, AUTHOR_DEPT_INDEX = #{authorDeptIndex}, AUTHOR_USER_INDEX = #{authorUserIndex}, CREATED = #{created}, FORMID = #{formid}, SUBFORMIDS = #{subformids}, INITIATOR = #{initiator}, ISTMP = #{istmp}, VERSIONS = #{versions}, APPLICATIONID = #{applicationid}, STATEINT = #{stateint}, STATELABEL = #{statelabel}, AUDITORNAMES = #{auditornames}, LASTFLOWOPERATION = #{lastflowoperation}, LASTMODIFIER = #{lastmodifier}, DOMAINID = #{domainid}, AUDITORLIST = #{auditorlist}, COAUDITORLIST = #{coauditorlist}, STATELABELINFO = #{statelabelinfo}, PREVAUDITNODE = #{prevauditnode}, PREVAUDITUSER = #{prevaudituser}, OPTIONITEM = #{optionitem}, SIGN = #{sign}, KINGGRIDSIGNATURE = #{kinggridsignature}, ITEM_AUDITSTATUS = #{auditstatus}, ITEM_TLKFORMNAME = #{tlkformname}, ITEM_REGION = #{region}, ITEM_SEVICEPERMITTYPE = #{sevicepermittype}, ITEM_FORM_NAME = #{formName}, ITEM_OFFICEPOLICEADDRESS = #{officepoliceaddress}, ITEM_OFFICEPOLICEADDRESSID = #{officepoliceaddressid}, ITEM_OFFICEPOLICEIDINDEX = #{officepoliceidindex}, ITEM_COMPANYNAME = #{companyname}, ITEM_COMPANYTYPE = #{companytype}, ITEM_ADDRESS = #{address}, ITEM_ZIPCODE = #{zipcode}, ITEM_PHONE = #{phone}, ITEM_PROPERTYRIGHTS = #{propertyrights}, ITEM_HOUSINGAREA = #{housingarea}, ITEM_MANAGERNUMS = #{managernums}, ITEM_TECHNICIANNUMS = #{techniciannums}, ITEM_REGISTEREDCAPITAL = #{registeredcapital}, ITEM_CARNUMS = #{carnums}, ITEM_GUNNUMS = #{gunnums}, ITEM_BUSINESSSCOPE = #{businessscope}, ITEM_LEGALNAME = #{legalname}, ITEM_LEGALCARDNUMBER = #{legalcardnumber}, ITEM_LEGALPHONE = #{legalphone}, ITEM_DOMAIN_ID = #{domainId}, ITEM_TEMPLATERARFILE = #{templaterarfile}, ITEM_PERMIT = #{permit}, ITEM_REJECTREASON = #{rejectreason}, ITEM_ss = #{ss}, ITEM_BACKGROUNDSTATUS = #{backgroundstatus}, where ID = #{id} delete from securityflow.tlk_securitysevicek where ID = #{id} delete from securityflow.tlk_securitysevicek where ID in #{id}