T+13.0 委外订单和生产订单选BOM一闪而过

T+13.0 委外订单和生产订单BOM选择BOM一闪而过，偶尔会有几个，属性都没有问题。已经打了13.0最新补丁

请把数据备份好，执行最后一次发布的补丁，然后执行语句：

 SELECT* INTO AA_BOM_bak_20201030 FROM dbo.AA_BOM SELECT* INTO AA_BOMChild_bak_20201030 FROM dbo.AA_BOMChild --1.物料清单表头多计量存货错误计量单位调整 UPDATE dbo.AA_BOM SET idunit = u3.id FROM dbo.AA_BOM bom LEFT JOIN dbo.AA_Inventory inv ON bom.idinventory = inv.id LEFT JOIN dbo.AA_Unit u1 ON bom.idunit = u1.id LEFT JOIN dbo.AA_Unit u2 ON bom.idunit2 = u2.id LEFT JOIN dbo.AA_Unit u3 ON u3.idunitgroup = inv.idunitgroup AND u1.name = u3.name WHERE inv.isSingleUnit = 0 AND ISNULL(u1.idunitgroup,0) != ISNULL(inv.idunitgroup,0) --2.物料清单表头多计量存货错误计量单位2调整 UPDATE dbo.AA_BOM SET idunit2 = u3.id FROM dbo.AA_BOM bom LEFT JOIN dbo.AA_Inventory inv ON bom.idinventory = inv.id LEFT JOIN dbo.AA_Unit u1 ON bom.idunit = u1.id LEFT JOIN dbo.AA_Unit u2 ON bom.idunit2 = u2.id LEFT JOIN dbo.AA_Unit u3 ON u3.idunitgroup = inv.idunitgroup AND u2.name = u3.name WHERE inv.isSingleUnit = 0 AND ISNULL(u2.idunitgroup,0) != ISNULL(inv.idunitgroup,0) --3.物料清单明细多计量存货错误计量单位调整 UPDATE dbo.AA_BOMChild SET idunit = u3.id FROM dbo.AA_BOMChild child LEFT JOIN dbo.AA_Inventory inv ON child.idinventory = inv.id LEFT JOIN dbo.AA_Unit u1 ON child.idunit = u1.id LEFT JOIN dbo.AA_Unit u2 ON child.idunit2 = u2.id LEFT JOIN dbo.AA_Unit u3 ON u3.idunitgroup = inv.idunitgroup AND u1.name = u3.name WHERE inv.isSingleUnit = 0 AND ISNULL(u1.idunitgroup,0) != ISNULL(inv.idunitgroup,0) --4.物料清单明细多计量存货错误计量单位2调整 UPDATE dbo.AA_BOMChild SET idunit2 = u3.id FROM dbo.AA_BOMChild child LEFT JOIN dbo.AA_Inventory inv ON child.idinventory = inv.id LEFT JOIN dbo.AA_Unit u1 ON child.idunit = u1.id LEFT JOIN dbo.AA_Unit u2 ON child.idunit2 = u2.id LEFT JOIN dbo.AA_Unit u3 ON u3.idunitgroup = inv.idunitgroup AND u2.name = u3.name WHERE inv.isSingleUnit = 0 AND ISNULL(u2.idunitgroup,0) != ISNULL(inv.idunitgroup,0)