001- [步骤]
001+ 问题一：
002- SELECT pdbd.SupplierID,
002+ [步骤]
003-        CONVERT(BIGINT, Sum(wppl.PutInNum))                                                                                   AS PutTotalNum,       Sum(wppl.PutInNum * ( Isnull(pdbd.ActualProductPrice, 0) + Isnull(pdbd.UnitShipFee, 0) - Isnull(pdbd.UnitMinus, 0) )) AS PutTotalAmountFROM   dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) wppl       LEFT JOIN dbo.RB_Procurement_Detail_BuyList_Detail (NOLOCK) pdbd         ON pdbd.CustomerID = wppl.CustomerID            AND pdbd.DetailID = wppl.DetailID            AND pdbd.SKU = wppl.SKU            AND pdbd.ListNo = wppl.ListNo       LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb         ON pdb.ListNo = pdbd.ListNo            AND pdb.P_Code = pdbd.P_Code            AND pdb.CustomerID = pdb.CustomerIDWHERE  wppl.CustomerID = @customerId       AND wppl.ListNo IS NOT NULL       AND pdb.ProcPayType IS NOT NULL       AND wppl.ListNo <> '' 0GROUP  BY pdbd.SupplierID; 
003+ SELECT pdbd.SupplierID,
004- [结果]
004+ CONVERT(BIGINT, Sum(wppl.PutInNum)) AS PutTotalNum, Sum(wppl.PutInNum * ( Isnull(pdbd.ActualProductPrice, 0) + Isnull(pdbd.UnitShipFee, 0) - Isnull(pdbd.UnitMinus, 0) )) AS PutTotalAmountFROM dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) wppl LEFT JOIN dbo.RB_Procurement_Detail_BuyList_Detail (NOLOCK) pdbd ON pdbd.CustomerID = wppl.CustomerID AND pdbd.DetailID = wppl.DetailID AND pdbd.SKU = wppl.SKU AND pdbd.ListNo = wppl.ListNo LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb ON pdb.ListNo = pdbd.ListNo AND pdb.P_Code = pdbd.P_Code AND pdb.CustomerID = pdb.CustomerIDWHERE wppl.CustomerID = @customerId AND wppl.ListNo IS NOT NULL AND pdb.ProcPayType IS NOT NULL AND wppl.ListNo <> '' 0GROUP BY pdbd.SupplierID;
005- [期望] 1.改善SQL 提醒性能，增加一些必要的逻辑。2。是否可以考虑读库查询
005+ [结果]
006-
006+ [期望] 1.改善SQL 提醒性能，增加一些必要的逻辑。2。是否可以考虑读库查询
007+
008+ 问题二：自动冲账服务优化
009+

001- <p>[步骤]</p>
001+ <p>问题一：</p>
002- SELECT pdbd.SupplierID,<br />
002+ <p>[步骤]</p>
003-        CONVERT(BIGINT, Sum(wppl.PutInNum))                                                                                   AS PutTotalNum,<br />       Sum(wppl.PutInNum * ( Isnull(pdbd.ActualProductPrice, 0) + Isnull(pdbd.UnitShipFee, 0) - Isnull(pdbd.UnitMinus, 0) )) AS PutTotalAmount<br />FROM   dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) wppl<br />       LEFT JOIN dbo.RB_Procurement_Detail_BuyList_Detail (NOLOCK) pdbd<br />         ON pdbd.CustomerID = wppl.CustomerID<br />            AND pdbd.DetailID = wppl.DetailID<br />            AND pdbd.SKU = wppl.SKU<br />            AND pdbd.ListNo = wppl.ListNo<br />       LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb<br />         ON pdb.ListNo = pdbd.ListNo<br />            AND pdb.P_Code = pdbd.P_Code<br />            AND pdb.CustomerID = pdb.CustomerID<br />WHERE  wppl.CustomerID = @customerId<br />       AND wppl.ListNo IS NOT NULL<br />       AND pdb.ProcPayType IS NOT NULL<br />       AND wppl.ListNo &lt;&gt; ''<br /> 0<br />GROUP  BY pdbd.SupplierID; <br /><div><br /></div>
003+ SELECT pdbd.SupplierID,<br />
004- <br /><p>[结果]</p>
004+ CONVERT(BIGINT, Sum(wppl.PutInNum)) AS PutTotalNum,<br /> Sum(wppl.PutInNum * ( Isnull(pdbd.ActualProductPrice, 0) + Isnull(pdbd.UnitShipFee, 0) - Isnull(pdbd.UnitMinus, 0) )) AS PutTotalAmount<br />FROM dbo.RB_WareHouse_Product_PutIn_Log (NOLOCK) wppl<br /> LEFT JOIN dbo.RB_Procurement_Detail_BuyList_Detail (NOLOCK) pdbd<br /> ON pdbd.CustomerID = wppl.CustomerID<br /> AND pdbd.DetailID = wppl.DetailID<br /> AND pdbd.SKU = wppl.SKU<br /> AND pdbd.ListNo = wppl.ListNo<br /> LEFT JOIN dbo.RB_Procurement_Detail_BuyList (NOLOCK) pdb<br /> ON pdb.ListNo = pdbd.ListNo<br /> AND pdb.P_Code = pdbd.P_Code<br /> AND pdb.CustomerID = pdb.CustomerID<br />WHERE wppl.CustomerID = @customerId<br /> AND wppl.ListNo IS NOT NULL<br /> AND pdb.ProcPayType IS NOT NULL<br /> AND wppl.ListNo &lt;&gt; ''<br /> 0<br />GROUP BY pdbd.SupplierID; <br /><div><br /></div>
005- <br /><p>[期望] 1.改善SQL 提醒性能，增加一些必要的逻辑。2。是否可以考虑读库查询</p>
005+ <br /><p>[结果]</p>
006- <br />
006+ <br /><p>[期望] 1.改善SQL 提醒性能，增加一些必要的逻辑。2。是否可以考虑读库查询</p>
007+ <p><br /></p>
008+ <p>问题二：自动冲账服务优化</p>
009+ <br />

001- 问题一：
001+ 功能一：
008- 问题二：自动冲账服务优化
008+ 功能二：自动冲账服务优化
009-
009+
010+ 功能三：SKU仿牌国家提供API接口
011+

001- <p>问题一：</p>
001+ <p>功能一：</p>
008- <p>问题二：自动冲账服务优化</p>
008+ <p>功能二：自动冲账服务优化</p>
009- <br />
009+ <p><br /></p>
010+ <p>功能三：SKU<span>仿牌</span>国家提供API接口</p>
011+ <br />

011-
011+
012+ 功能四：采购异常节点待领取优化
013+

011- <br />
011+ <p><br /></p>
012+ <p>功能四：采购异常节点待领取优化</p>
013+ <br />