T+13.0 委外訂單和生產(chǎn)訂單BOM選擇BOM一閃而過，偶爾會(huì)有幾個(gè)，屬性都沒有問題。已經(jīng)打了13.0最新補(bǔ)丁

請(qǐng)把數(shù)據(jù)備份好，執(zhí)行最后一次發(fā)布的補(bǔ)丁，然后執(zhí)行語句：

 SELECT* INTO AA_BOM_bak_20201030 FROM dbo.AA_BOM SELECT* INTO AA_BOMChild_bak_20201030 FROM dbo.AA_BOMChild --1.物料清單表頭多計(jì)量存貨錯(cuò)誤計(jì)量單位調(diào)整 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.物料清單表頭多計(jì)量存貨錯(cuò)誤計(jì)量單位2調(diào)整 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.物料清單明細(xì)多計(jì)量存貨錯(cuò)誤計(jì)量單位調(diào)整 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.物料清單明細(xì)多計(jì)量存貨錯(cuò)誤計(jì)量單位2調(diào)整 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)