通过查询完工报告获取 完工报告的ID
select * from MO_CompleteRpt where DocNo='完工报告单号'
删除序列号 关联的完工报告ID
delete u from Sn_SnBeUsed u inner join Sn_SnMaster sn on u.SnMaster=sn.ID where u.Document_EntityID=完工报告ID
通过查询完工报告获取 完工报告的ID
select * from MO_CompleteRpt where DocNo='完工报告单号'
删除序列号 关联的完工报告ID
delete u from Sn_SnBeUsed u inner join Sn_SnMaster sn on u.SnMaster=sn.ID where u.Document_EntityID=完工报告ID