select PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHOR_DEPT_INDEX, CREATED, FORMID, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ID, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_ADDRESS, ITEM_LOGINNUM, ITEM_RECORDDATE, ITEM_CANCELDATE, ITEM_SERVICEAREA, ITEM_LEGALNAME, ITEM_LEGALSEX, ITEM_LEGALPHONE, ITEM_LEGALCARDNUMBER, ITEM_CANCELAPPLYFILE, ITEM_REGION, ITEM_REJECTREASON, ITEM_DOMAIN_ID, ITEM_PERMIT, AUTHORDEPTID, AUTHOR_USER_INDEX, SUBFORMIDS, INITIATOR, ITEM_EVIDENCE_PICTURE, ITEM_LEGALCARDFRONT_PICTURE, ITEM_LEGALCARDBACK_PICTURE, ITEM_EVIDENCEPIC, ITEM_LEGALCARDPICFRONT, ITEM_法人身份证背面 from securityflow.tlk_revoke ID in #{id} where ID = #{id} insert into securityflow.tlk_revoke PARENT, LASTMODIFIED, FORMNAME, STATE, AUDITUSER, AUDITDATE, AUTHOR, AUTHOR_DEPT_INDEX, CREATED, FORMID, ISTMP, VERSIONS, APPLICATIONID, STATEINT, STATELABEL, AUDITORNAMES, LASTFLOWOPERATION, LASTMODIFIER, DOMAINID, AUDITORLIST, COAUDITORLIST, STATELABELINFO, PREVAUDITNODE, PREVAUDITUSER, OPTIONITEM, SIGN, KINGGRIDSIGNATURE, ID, ITEM_AUDITSTATUS, ITEM_TLKFORMNAME, ITEM_OFFICEPOLICEADDRESS, ITEM_OFFICEPOLICEADDRESSID, ITEM_OFFICEPOLICEIDINDEX, ITEM_COMPANYNAME, ITEM_ADDRESS, ITEM_LOGINNUM, ITEM_RECORDDATE, ITEM_CANCELDATE, ITEM_SERVICEAREA, ITEM_LEGALNAME, ITEM_LEGALSEX, ITEM_LEGALPHONE, ITEM_LEGALCARDNUMBER, ITEM_CANCELAPPLYFILE, ITEM_REGION, ITEM_REJECTREASON, ITEM_DOMAIN_ID, ITEM_PERMIT, AUTHORDEPTID, AUTHOR_USER_INDEX, SUBFORMIDS, INITIATOR, ITEM_EVIDENCE_PICTURE, ITEM_LEGALCARDFRONT_PICTURE, ITEM_LEGALCARDBACK_PICTURE, ITEM_EVIDENCEPIC, ITEM_LEGALCARDPICFRONT, ITEM_法人身份证背面, #{parent}, #{lastmodified}, #{formname}, #{state}, #{audituser}, #{auditdate}, #{author}, #{authorDeptIndex}, #{created}, #{formid}, #{istmp}, #{versions}, #{applicationid}, #{stateint}, #{statelabel}, #{auditornames}, #{lastflowoperation}, #{lastmodifier}, #{domainid}, #{auditorlist}, #{coauditorlist}, #{statelabelinfo}, #{prevauditnode}, #{prevaudituser}, #{optionitem}, #{sign}, #{kinggridsignature}, #{id}, '3', #{tlkformname}, #{officepoliceaddress}, #{officepoliceaddressid}, #{officepoliceidindex}, #{companyname}, #{address}, #{loginnum}, #{recorddate}, #{canceldate}, #{servicearea}, #{legalname}, #{legalsex}, #{legalphone}, #{legalcardnumber}, #{cancelapplyfile}, #{region}, #{rejectreason}, #{domainId}, #{permit}, #{authordeptid}, #{authorUserIndex}, #{subformids}, #{initiator}, #{evidencePicture}, #{legalcardfrontPicture}, #{legalcardbackPicture}, #{evidencepic}, #{legalcardpicfront}, #{法人身份证背面}, update securityflow.tlk_revoke PARENT = #{parent}, LASTMODIFIED = #{lastmodified}, FORMNAME = #{formname}, STATE = #{state}, AUDITUSER = #{audituser}, AUDITDATE = #{auditdate}, AUTHOR = #{author}, AUTHOR_DEPT_INDEX = #{authorDeptIndex}, CREATED = #{created}, FORMID = #{formid}, 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_OFFICEPOLICEADDRESS = #{officepoliceaddress}, ITEM_OFFICEPOLICEADDRESSID = #{officepoliceaddressid}, ITEM_OFFICEPOLICEIDINDEX = #{officepoliceidindex}, ITEM_COMPANYNAME = #{companyname}, ITEM_ADDRESS = #{address}, ITEM_LOGINNUM = #{loginnum}, ITEM_RECORDDATE = #{recorddate}, ITEM_CANCELDATE = #{canceldate}, ITEM_SERVICEAREA = #{servicearea}, ITEM_LEGALNAME = #{legalname}, ITEM_LEGALSEX = #{legalsex}, ITEM_LEGALPHONE = #{legalphone}, ITEM_LEGALCARDNUMBER = #{legalcardnumber}, ITEM_CANCELAPPLYFILE = #{cancelapplyfile}, ITEM_REGION = #{region}, ITEM_REJECTREASON = #{rejectreason}, ITEM_DOMAIN_ID = #{domainId}, ITEM_PERMIT = #{permit}, AUTHORDEPTID = #{authordeptid}, AUTHOR_USER_INDEX = #{authorUserIndex}, SUBFORMIDS = #{subformids}, INITIATOR = #{initiator}, ITEM_EVIDENCE_PICTURE = #{evidencePicture}, ITEM_LEGALCARDFRONT_PICTURE = #{legalcardfrontPicture}, ITEM_LEGALCARDBACK_PICTURE = #{legalcardbackPicture}, ITEM_EVIDENCEPIC = #{evidencepic}, ITEM_LEGALCARDPICFRONT = #{legalcardpicfront}, ITEM_法人身份证背面 = #{法人身份证背面}, where ID = #{id} delete from securityflow.tlk_revoke where ID = #{id} delete from securityflow.tlk_revoke where ID in #{id}