第一步:更新sn_code表
update sn_code set sn_code.estate = 0 ,sn_code.updateTime = sn_code.createTime from transit_code join sn_code on transit_code.code = sn_code.code and transit_code.fileID = sn_code.fileID where transit_code.batchNo = '***批号'

第二步:更新sn_record表
update sn_record set sn_record.freeAmount = sn_record.amount from (select id,(select count(*) from sn_code where fileID = a.id and estate = 0) as num from sn_record as a ) as a join sn_record on a.id = sn_record.id

第三步:删除trasit_code表关联数据
delete from transit_code where batchNo  = '***批号'

第四步:删除produce_order_request表关联数据
delete from produce_order_request where batchNo  = '***批号'

第五步L删除produce_order表的数据
delete from produce_order where batchNo  = '***批号'