时间: 2022-11-25 11:43:50,227 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##3ad184e123a34b98bd9a7fbaa6ac8797] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##3ad184e123a34b98bd9a7fbaa6ac8797] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##3ad184e123a34b98bd9a7fbaa6ac8797] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##3ad184e123a34b98bd9a7fbaa6ac8797] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##3ad184e123a34b98bd9a7fbaa6ac8797] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 11:43:50,687 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##70cc1ff754344bf9aeb9eddd6eeb36fe] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 11:45:33,424 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##2f46f02625c34300a047ae5d72d6dc0f] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-25 11:45:33,679 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2f46f02625c34300a047ae5d72d6dc0f] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##d26cec95854145b3b084d3ae6d34a12f] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-25 11:46:47,677 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##fd58fca41ed9434e9e1f12a39a30bba7] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##fd58fca41ed9434e9e1f12a39a30bba7] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##f5f678a2b4a3434ba7f965255414f1a3] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 11:46:47,864 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##fd58fca41ed9434e9e1f12a39a30bba7] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##fd58fca41ed9434e9e1f12a39a30bba7] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##f5f678a2b4a3434ba7f965255414f1a3] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 11:46:48,014 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##fd58fca41ed9434e9e1f12a39a30bba7] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##fd58fca41ed9434e9e1f12a39a30bba7] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##f5f678a2b4a3434ba7f965255414f1a3] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-25 11:46:48,156 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##fd58fca41ed9434e9e1f12a39a30bba7] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##fd58fca41ed9434e9e1f12a39a30bba7] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##f5f678a2b4a3434ba7f965255414f1a3] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-25 11:46:48,288 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##fd58fca41ed9434e9e1f12a39a30bba7] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##fd58fca41ed9434e9e1f12a39a30bba7] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##f5f678a2b4a3434ba7f965255414f1a3] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2022-11-25 11:46:48,414 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##fd58fca41ed9434e9e1f12a39a30bba7 A 时间: 2022-11-25 11:46:48,416 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[44582245-8ca5-40cc-a72d-2ce23fba45e1] FROM [##fd58fca41ed9434e9e1f12a39a30bba7] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 11:46:57,358 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##36fbc99b14ad4e268a5619e29f2211b5] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##36fbc99b14ad4e268a5619e29f2211b5] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a9139048c7c54cb4831d4005acdad33a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 11:46:57,528 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##36fbc99b14ad4e268a5619e29f2211b5] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##36fbc99b14ad4e268a5619e29f2211b5] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a9139048c7c54cb4831d4005acdad33a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 11:46:57,693 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##36fbc99b14ad4e268a5619e29f2211b5] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##36fbc99b14ad4e268a5619e29f2211b5] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##a9139048c7c54cb4831d4005acdad33a] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-25 11:46:57,852 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##36fbc99b14ad4e268a5619e29f2211b5] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##36fbc99b14ad4e268a5619e29f2211b5] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##a9139048c7c54cb4831d4005acdad33a] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-25 11:46:58,024 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##36fbc99b14ad4e268a5619e29f2211b5] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##36fbc99b14ad4e268a5619e29f2211b5] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##a9139048c7c54cb4831d4005acdad33a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2022-11-25 11:46:58,194 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##36fbc99b14ad4e268a5619e29f2211b5 A 时间: 2022-11-25 11:46:58,197 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[44582245-8ca5-40cc-a72d-2ce23fba45e1] FROM [##36fbc99b14ad4e268a5619e29f2211b5] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 11:48:14,290 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##a1b095619c79416ca00b762432a7b3ab] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 11:48:14,624 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##be6d3e6325474935836a4d5f0cf1b50b] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 11:48:14,626 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a1b095619c79416ca00b762432a7b3ab] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##be6d3e6325474935836a4d5f0cf1b50b] 时间: 2022-11-25 11:48:14,628 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##c178e5b6d5d24e9e8bfa397416c550eb FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##6b42924bd2b0414b811a79f30131112c] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##1480db224ea74fdb9a15d502b45ec6a7] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 11:48:14,690 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##370acc207eea4161b94ba21b0886fcc3 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##6b42924bd2b0414b811a79f30131112c] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##1480db224ea74fdb9a15d502b45ec6a7] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 11:48:14,727 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##370acc207eea4161b94ba21b0886fcc3 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 11:48:14,730 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##370acc207eea4161b94ba21b0886fcc3 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 11:48:14,733 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##370acc207eea4161b94ba21b0886fcc3 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 11:48:14,765 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##370acc207eea4161b94ba21b0886fcc3 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 11:48:14,767 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##370acc207eea4161b94ba21b0886fcc3 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 11:48:14,770 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a1b095619c79416ca00b762432a7b3ab(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##c22cdf01df864e139854bdb3eecc5f8c GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 11:48:14,775 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##a1b095619c79416ca00b762432a7b3ab A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##c178e5b6d5d24e9e8bfa397416c550eb T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2022-11-25 11:48:17,655 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##dcefc1d939e8477c9bfc8c6f63972aeb] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 11:48:17,991 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##42221154593f4d64a3adaee75cce01ec] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 11:48:17,992 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dcefc1d939e8477c9bfc8c6f63972aeb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##42221154593f4d64a3adaee75cce01ec] 时间: 2022-11-25 11:48:17,994 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##791c4aa7ba994328b7d99b5b27a3f8b2 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##9716e6b549ef472a9f3cc62e42c5450e] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##44334ebed5e546b08deb8b644e4bc9f8] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 11:48:18,051 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##0f590f73880a4984940436cf7ad21959 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##9716e6b549ef472a9f3cc62e42c5450e] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##44334ebed5e546b08deb8b644e4bc9f8] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 11:48:18,088 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0f590f73880a4984940436cf7ad21959 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 11:48:18,091 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f590f73880a4984940436cf7ad21959 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 11:48:18,094 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0f590f73880a4984940436cf7ad21959 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 11:48:18,126 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f590f73880a4984940436cf7ad21959 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 11:48:18,129 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f590f73880a4984940436cf7ad21959 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 11:48:18,133 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##dcefc1d939e8477c9bfc8c6f63972aeb(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e399acc1d4344ee38399b08397ebcbad GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 11:48:18,139 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##dcefc1d939e8477c9bfc8c6f63972aeb A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##791c4aa7ba994328b7d99b5b27a3f8b2 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2022-11-25 11:48:26,163 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##bfb87aaa056343bf9b5bfa8db26386a0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 11:48:26,496 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2a02a11e73844baa87a9dd2358ffa117] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 11:48:26,497 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bfb87aaa056343bf9b5bfa8db26386a0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2a02a11e73844baa87a9dd2358ffa117] 时间: 2022-11-25 11:48:26,498 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##1d98579cb79e43088e5f64f599e4e2bf FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##df0eaccaab764f3a9496286ba07ddb3b] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##337e709528ec4e2da8e39b4f18072efb] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 11:48:26,565 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##5454321dc85f4897a2fe834869a19407 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##df0eaccaab764f3a9496286ba07ddb3b] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##337e709528ec4e2da8e39b4f18072efb] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 11:48:26,605 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5454321dc85f4897a2fe834869a19407 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 11:48:26,608 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5454321dc85f4897a2fe834869a19407 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 11:48:26,611 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5454321dc85f4897a2fe834869a19407 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 11:48:26,645 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5454321dc85f4897a2fe834869a19407 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 11:48:26,648 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5454321dc85f4897a2fe834869a19407 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 11:48:26,653 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##bfb87aaa056343bf9b5bfa8db26386a0(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##0098c1fdb3d549eba801fb2c9eaafca7 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 11:48:26,659 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##bfb87aaa056343bf9b5bfa8db26386a0 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##1d98579cb79e43088e5f64f599e4e2bf T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 11:49:38,114 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##abb31dbc57534d4891b77021aef07b77] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 11:49:38,447 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##66716b2ed035423c9ec0089e887cb27e] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 11:49:38,449 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##abb31dbc57534d4891b77021aef07b77] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##66716b2ed035423c9ec0089e887cb27e] 时间: 2022-11-25 11:49:38,450 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##7b27f85876c345628f8db738dc0a2930 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##7adb3f9ec99b4a9b8504709f66fea3db] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##87e747f024b446de965bf7c5e37fd848] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 11:49:38,511 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##5668fb6d51cf4e589f0c726d12277707 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##7adb3f9ec99b4a9b8504709f66fea3db] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##87e747f024b446de965bf7c5e37fd848] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 11:49:38,545 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5668fb6d51cf4e589f0c726d12277707 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 11:49:38,547 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5668fb6d51cf4e589f0c726d12277707 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 11:49:38,550 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5668fb6d51cf4e589f0c726d12277707 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 11:49:38,582 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5668fb6d51cf4e589f0c726d12277707 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 11:49:38,583 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5668fb6d51cf4e589f0c726d12277707 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 11:49:38,586 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##abb31dbc57534d4891b77021aef07b77(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##a01592e1d0b147cfb28120f076869055 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 11:49:38,592 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##abb31dbc57534d4891b77021aef07b77 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##7b27f85876c345628f8db738dc0a2930 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 11:49:47,419 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##6121b56494d646b58e2a3a6aae59f367] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 11:49:47,747 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9d7abe2040b3428eb9ed1c86dbcd2958] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 11:49:47,748 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6121b56494d646b58e2a3a6aae59f367] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9d7abe2040b3428eb9ed1c86dbcd2958] 时间: 2022-11-25 11:49:47,749 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##1ca806498720454f856a4264575d5dee FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##ffae14085f954f82bef4010fcca95edd] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##f9ff2de3025c449b8e04ca5cb041bcc2] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 11:49:47,807 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##ee835b61a0ed46aaa8807ebc339db87b FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##ffae14085f954f82bef4010fcca95edd] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##f9ff2de3025c449b8e04ca5cb041bcc2] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 11:49:47,842 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ee835b61a0ed46aaa8807ebc339db87b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 11:49:47,844 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ee835b61a0ed46aaa8807ebc339db87b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 11:49:47,847 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ee835b61a0ed46aaa8807ebc339db87b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 11:49:47,877 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ee835b61a0ed46aaa8807ebc339db87b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 11:49:47,878 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ee835b61a0ed46aaa8807ebc339db87b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 11:49:47,881 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##6121b56494d646b58e2a3a6aae59f367(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##1822480155f64eff9ea64d9ac4124663 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 11:49:47,887 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##6121b56494d646b58e2a3a6aae59f367 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##1ca806498720454f856a4264575d5dee T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 12:02:51,049 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##d951279236a14f70a19bc0ae15ceafd7] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-25 12:02:51,257 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d951279236a14f70a19bc0ae15ceafd7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##0fe1f51c614b41839766701c7d5cf34d] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-25 12:02:57,492 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##e14ecde6b41e4bee934bdc0e9dcf1279] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 12:02:57,827 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##dbdc11cec0444eaab54e420d6994f685] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 12:02:57,829 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e14ecde6b41e4bee934bdc0e9dcf1279] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##dbdc11cec0444eaab54e420d6994f685] 时间: 2022-11-25 12:02:57,830 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##8117b95f66b04113bd08c6c10b47a021 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##e2a4b75349074d7e99b0739d00a7c4ff] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##bf924ab1b4954e7bb6386b8b770d9616] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 12:02:57,889 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##5d2a7320c7f44b9db8553e7cf0ef9a05 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##e2a4b75349074d7e99b0739d00a7c4ff] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##bf924ab1b4954e7bb6386b8b770d9616] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 12:02:57,925 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5d2a7320c7f44b9db8553e7cf0ef9a05 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 12:02:57,928 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5d2a7320c7f44b9db8553e7cf0ef9a05 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 12:02:57,931 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5d2a7320c7f44b9db8553e7cf0ef9a05 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 12:02:57,965 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5d2a7320c7f44b9db8553e7cf0ef9a05 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 12:02:57,967 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5d2a7320c7f44b9db8553e7cf0ef9a05 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 12:02:57,971 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e14ecde6b41e4bee934bdc0e9dcf1279(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##a362fde9e57442cfa36ade0e62f27726 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 12:02:57,975 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##e14ecde6b41e4bee934bdc0e9dcf1279 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##8117b95f66b04113bd08c6c10b47a021 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 12:03:33,991 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##29111c6e63904835981360c4d4d1b6f2] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##29111c6e63904835981360c4d4d1b6f2] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##29111c6e63904835981360c4d4d1b6f2] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##29111c6e63904835981360c4d4d1b6f2] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##29111c6e63904835981360c4d4d1b6f2] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:03:34,544 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##e669d0fb723e4f9b914f24c1fa2be2c7] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:03:46,737 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##cb92909d3ea94658a3905c3dde6d65b6] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##cb92909d3ea94658a3905c3dde6d65b6] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##5ebe559050e34b50bc6722ae2310a52b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:03:46,887 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##cb92909d3ea94658a3905c3dde6d65b6] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##cb92909d3ea94658a3905c3dde6d65b6] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##5ebe559050e34b50bc6722ae2310a52b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:03:47,027 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##cb92909d3ea94658a3905c3dde6d65b6] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##cb92909d3ea94658a3905c3dde6d65b6] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##5ebe559050e34b50bc6722ae2310a52b] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-25 12:03:47,174 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##cb92909d3ea94658a3905c3dde6d65b6] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##cb92909d3ea94658a3905c3dde6d65b6] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##5ebe559050e34b50bc6722ae2310a52b] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-25 12:03:47,330 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##cb92909d3ea94658a3905c3dde6d65b6] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##cb92909d3ea94658a3905c3dde6d65b6] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##5ebe559050e34b50bc6722ae2310a52b] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2022-11-25 12:03:47,483 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##cb92909d3ea94658a3905c3dde6d65b6 A 时间: 2022-11-25 12:03:47,486 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[44582245-8ca5-40cc-a72d-2ce23fba45e1] FROM [##cb92909d3ea94658a3905c3dde6d65b6] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:10:49,903 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##6655954f56cf4041af534afd758fd634] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##6655954f56cf4041af534afd758fd634] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##7f36859461974d7c8d6f5f8482c3bce1] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##6655954f56cf4041af534afd758fd634] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##6655954f56cf4041af534afd758fd634] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##7f36859461974d7c8d6f5f8482c3bce1] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##6655954f56cf4041af534afd758fd634] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##6655954f56cf4041af534afd758fd634] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##7f36859461974d7c8d6f5f8482c3bce1] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##6655954f56cf4041af534afd758fd634] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##7f36859461974d7c8d6f5f8482c3bce1] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##6655954f56cf4041af534afd758fd634] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##6655954f56cf4041af534afd758fd634] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##7f36859461974d7c8d6f5f8482c3bce1] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:10:50,662 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[2a29f9ec-2e52-4ef0-b914-44a42de63555] FROM [##6655954f56cf4041af534afd758fd634] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:10:51,021 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##85b5f6c1aa61494f9d880316f2b55875] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##85b5f6c1aa61494f9d880316f2b55875] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a76ff05654924e90b4bb57f45b8a6b07] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##85b5f6c1aa61494f9d880316f2b55875] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##85b5f6c1aa61494f9d880316f2b55875] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##a76ff05654924e90b4bb57f45b8a6b07] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##85b5f6c1aa61494f9d880316f2b55875] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##85b5f6c1aa61494f9d880316f2b55875] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##a76ff05654924e90b4bb57f45b8a6b07] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##85b5f6c1aa61494f9d880316f2b55875] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##a76ff05654924e90b4bb57f45b8a6b07] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##85b5f6c1aa61494f9d880316f2b55875] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##85b5f6c1aa61494f9d880316f2b55875] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##a76ff05654924e90b4bb57f45b8a6b07] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:10:51,714 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[7c78fb2d-51ee-442c-a658-bc7648d4964e] FROM [##85b5f6c1aa61494f9d880316f2b55875] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:10:58,426 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##36db2a9d18fa40a89874a6bd07658ca9] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##36db2a9d18fa40a89874a6bd07658ca9] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##700790e251b144f2affd11ae0b7564f8] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##36db2a9d18fa40a89874a6bd07658ca9] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##36db2a9d18fa40a89874a6bd07658ca9] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##700790e251b144f2affd11ae0b7564f8] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##36db2a9d18fa40a89874a6bd07658ca9] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##36db2a9d18fa40a89874a6bd07658ca9] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##700790e251b144f2affd11ae0b7564f8] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##36db2a9d18fa40a89874a6bd07658ca9] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##700790e251b144f2affd11ae0b7564f8] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##36db2a9d18fa40a89874a6bd07658ca9] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##36db2a9d18fa40a89874a6bd07658ca9] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##700790e251b144f2affd11ae0b7564f8] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:10:59,136 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[1f2e771d-cddb-49ac-9071-b728be7f858f] FROM [##36db2a9d18fa40a89874a6bd07658ca9] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:10:59,492 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##cc2087ec69b146be84c8f8b0482b321e] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##cc2087ec69b146be84c8f8b0482b321e] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##9bc715b8eb8542aaa758be668a972530] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##cc2087ec69b146be84c8f8b0482b321e] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##cc2087ec69b146be84c8f8b0482b321e] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##9bc715b8eb8542aaa758be668a972530] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##cc2087ec69b146be84c8f8b0482b321e] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##cc2087ec69b146be84c8f8b0482b321e] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##9bc715b8eb8542aaa758be668a972530] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##cc2087ec69b146be84c8f8b0482b321e] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##9bc715b8eb8542aaa758be668a972530] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##cc2087ec69b146be84c8f8b0482b321e] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##cc2087ec69b146be84c8f8b0482b321e] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##9bc715b8eb8542aaa758be668a972530] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:11:00,187 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[d732429a-3587-40b3-9710-95f85154a947] FROM [##cc2087ec69b146be84c8f8b0482b321e] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:11:38,355 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##1b8d886fabb74e67822ed114dba3f19e] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##1b8d886fabb74e67822ed114dba3f19e] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##2c0e4459ea424dbc91dac1e6bcc33509] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##1b8d886fabb74e67822ed114dba3f19e] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##1b8d886fabb74e67822ed114dba3f19e] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##2c0e4459ea424dbc91dac1e6bcc33509] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##1b8d886fabb74e67822ed114dba3f19e] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##1b8d886fabb74e67822ed114dba3f19e] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##2c0e4459ea424dbc91dac1e6bcc33509] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##1b8d886fabb74e67822ed114dba3f19e] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##2c0e4459ea424dbc91dac1e6bcc33509] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##1b8d886fabb74e67822ed114dba3f19e] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##1b8d886fabb74e67822ed114dba3f19e] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##2c0e4459ea424dbc91dac1e6bcc33509] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:11:39,028 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[603b2980-d244-48cc-8438-1a0f6aecebbd] FROM [##1b8d886fabb74e67822ed114dba3f19e] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:11:39,376 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##0fd6249c6942440180aa292efeafd746] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##0fd6249c6942440180aa292efeafd746] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##5a6248f85e244189a3f060f8260652df] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##0fd6249c6942440180aa292efeafd746] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##0fd6249c6942440180aa292efeafd746] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##5a6248f85e244189a3f060f8260652df] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##0fd6249c6942440180aa292efeafd746] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##0fd6249c6942440180aa292efeafd746] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##5a6248f85e244189a3f060f8260652df] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##0fd6249c6942440180aa292efeafd746] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##5a6248f85e244189a3f060f8260652df] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##0fd6249c6942440180aa292efeafd746] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##0fd6249c6942440180aa292efeafd746] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##5a6248f85e244189a3f060f8260652df] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:11:40,061 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[c53b0faa-8dbe-431a-8f56-1f7bca252ce3] FROM [##0fd6249c6942440180aa292efeafd746] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:11:54,498 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##03e58d72546f41da9c75c765978b3ab8] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##03e58d72546f41da9c75c765978b3ab8] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6c1a381c8a944bd8977115f20b932ffb] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##03e58d72546f41da9c75c765978b3ab8] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##03e58d72546f41da9c75c765978b3ab8] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##6c1a381c8a944bd8977115f20b932ffb] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##03e58d72546f41da9c75c765978b3ab8] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##03e58d72546f41da9c75c765978b3ab8] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##6c1a381c8a944bd8977115f20b932ffb] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##03e58d72546f41da9c75c765978b3ab8] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##6c1a381c8a944bd8977115f20b932ffb] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##03e58d72546f41da9c75c765978b3ab8] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##03e58d72546f41da9c75c765978b3ab8] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6c1a381c8a944bd8977115f20b932ffb] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:11:55,223 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[eba1978b-c676-422a-942d-569c5650c06f] FROM [##03e58d72546f41da9c75c765978b3ab8] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:11:55,587 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##50e539702b17494eac0837d44f5eb2ce] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##50e539702b17494eac0837d44f5eb2ce] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##53c8396ccb4741e4b8fd0703ade16841] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##50e539702b17494eac0837d44f5eb2ce] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##50e539702b17494eac0837d44f5eb2ce] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##53c8396ccb4741e4b8fd0703ade16841] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##50e539702b17494eac0837d44f5eb2ce] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##50e539702b17494eac0837d44f5eb2ce] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##53c8396ccb4741e4b8fd0703ade16841] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##50e539702b17494eac0837d44f5eb2ce] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##53c8396ccb4741e4b8fd0703ade16841] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##50e539702b17494eac0837d44f5eb2ce] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##50e539702b17494eac0837d44f5eb2ce] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##53c8396ccb4741e4b8fd0703ade16841] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:11:56,307 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[e971ee08-c1a8-4b0f-b7c6-2483a792e36c] FROM [##50e539702b17494eac0837d44f5eb2ce] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:12:35,144 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c90ab11b65664802adb4775f162f0d4b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##c90ab11b65664802adb4775f162f0d4b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6ea1dcda2ff54b6bb25d42b3ee3a5854] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##c90ab11b65664802adb4775f162f0d4b] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##c90ab11b65664802adb4775f162f0d4b] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##6ea1dcda2ff54b6bb25d42b3ee3a5854] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##c90ab11b65664802adb4775f162f0d4b] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##c90ab11b65664802adb4775f162f0d4b] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##6ea1dcda2ff54b6bb25d42b3ee3a5854] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##c90ab11b65664802adb4775f162f0d4b] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##6ea1dcda2ff54b6bb25d42b3ee3a5854] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##c90ab11b65664802adb4775f162f0d4b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##c90ab11b65664802adb4775f162f0d4b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##6ea1dcda2ff54b6bb25d42b3ee3a5854] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:12:35,674 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##c90ab11b65664802adb4775f162f0d4b] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:13:19,041 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##f85b2afe2e27472abaa52dea1cf0a5f2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 12:13:19,363 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##d50f64c2d4fb456085d6ba06e398ccfb] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 12:13:19,365 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f85b2afe2e27472abaa52dea1cf0a5f2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d50f64c2d4fb456085d6ba06e398ccfb] 时间: 2022-11-25 12:13:19,367 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##993d6f91690a438f851e221c35ab454a FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##c12baec16ef749f0a72215da0c6dd8cd] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##5bc5fff9e80544d9bc7739211635f929] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 12:13:19,423 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##4b981cbc3d054d1baf326d6cdb6d8631 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##c12baec16ef749f0a72215da0c6dd8cd] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##5bc5fff9e80544d9bc7739211635f929] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 12:13:19,459 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4b981cbc3d054d1baf326d6cdb6d8631 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 12:13:19,461 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4b981cbc3d054d1baf326d6cdb6d8631 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 12:13:19,465 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4b981cbc3d054d1baf326d6cdb6d8631 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 12:13:19,495 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4b981cbc3d054d1baf326d6cdb6d8631 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 12:13:19,497 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4b981cbc3d054d1baf326d6cdb6d8631 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 12:13:19,500 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##f85b2afe2e27472abaa52dea1cf0a5f2(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##194a26f7ceb949e19435122e76798bf7 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 12:13:19,505 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##f85b2afe2e27472abaa52dea1cf0a5f2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##993d6f91690a438f851e221c35ab454a T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 12:13:23,625 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##c1959260a3d54924b27a2fcb36f34de0] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-25 12:13:23,831 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c1959260a3d54924b27a2fcb36f34de0] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##d9692184873f4e7da5e45e287e2bbbe5] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-25 12:49:40,076 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##87e40a81a9a64b6f9652288812c8a7e4] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##87e40a81a9a64b6f9652288812c8a7e4] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##091e392514f54beda5c4aa911c62415f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##87e40a81a9a64b6f9652288812c8a7e4] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##87e40a81a9a64b6f9652288812c8a7e4] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##091e392514f54beda5c4aa911c62415f] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##87e40a81a9a64b6f9652288812c8a7e4] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##87e40a81a9a64b6f9652288812c8a7e4] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##091e392514f54beda5c4aa911c62415f] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##87e40a81a9a64b6f9652288812c8a7e4] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##091e392514f54beda5c4aa911c62415f] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##87e40a81a9a64b6f9652288812c8a7e4] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##87e40a81a9a64b6f9652288812c8a7e4] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##091e392514f54beda5c4aa911c62415f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:49:40,611 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##87e40a81a9a64b6f9652288812c8a7e4] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:50:41,096 线程ID: 13 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c0be9a9f90a44bb4bed77d190828c9f3] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##c0be9a9f90a44bb4bed77d190828c9f3] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##2be7994bcb594d969966675333ceacfe] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##c0be9a9f90a44bb4bed77d190828c9f3] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##c0be9a9f90a44bb4bed77d190828c9f3] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##2be7994bcb594d969966675333ceacfe] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##c0be9a9f90a44bb4bed77d190828c9f3] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##c0be9a9f90a44bb4bed77d190828c9f3] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##2be7994bcb594d969966675333ceacfe] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##c0be9a9f90a44bb4bed77d190828c9f3] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##2be7994bcb594d969966675333ceacfe] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##c0be9a9f90a44bb4bed77d190828c9f3] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##c0be9a9f90a44bb4bed77d190828c9f3] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##2be7994bcb594d969966675333ceacfe] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:50:41,850 线程ID: 13 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[3fc3d758-1699-48f1-afe5-856c22f5ee1e] FROM [##c0be9a9f90a44bb4bed77d190828c9f3] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:50:42,219 线程ID: 13 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##4169a624133543c6885f162b546dd0bb] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##4169a624133543c6885f162b546dd0bb] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##72b42d7020064374ae032d91cf184fad] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##4169a624133543c6885f162b546dd0bb] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##4169a624133543c6885f162b546dd0bb] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##72b42d7020064374ae032d91cf184fad] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##4169a624133543c6885f162b546dd0bb] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##4169a624133543c6885f162b546dd0bb] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##72b42d7020064374ae032d91cf184fad] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##4169a624133543c6885f162b546dd0bb] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##72b42d7020064374ae032d91cf184fad] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##4169a624133543c6885f162b546dd0bb] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##4169a624133543c6885f162b546dd0bb] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##72b42d7020064374ae032d91cf184fad] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:50:43,067 线程ID: 13 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[0e148b3f-13d8-4f61-a3c8-8ca4743cd8c9] FROM [##4169a624133543c6885f162b546dd0bb] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:51:22,344 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##4c6ce79556d044bb908ea96a533a2060] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##4c6ce79556d044bb908ea96a533a2060] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##ab494ac288e34c90a6899ad2ef2e659e] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##4c6ce79556d044bb908ea96a533a2060] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##4c6ce79556d044bb908ea96a533a2060] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##ab494ac288e34c90a6899ad2ef2e659e] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##4c6ce79556d044bb908ea96a533a2060] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##4c6ce79556d044bb908ea96a533a2060] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##ab494ac288e34c90a6899ad2ef2e659e] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##4c6ce79556d044bb908ea96a533a2060] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##ab494ac288e34c90a6899ad2ef2e659e] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##4c6ce79556d044bb908ea96a533a2060] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##4c6ce79556d044bb908ea96a533a2060] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##ab494ac288e34c90a6899ad2ef2e659e] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:51:22,867 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##4c6ce79556d044bb908ea96a533a2060] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:51:56,409 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##de0db0c8342e43acaa80d02125299d6b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##de0db0c8342e43acaa80d02125299d6b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##5145f1e25b5041e3be9faf884b7e01d1] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##de0db0c8342e43acaa80d02125299d6b] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##de0db0c8342e43acaa80d02125299d6b] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##5145f1e25b5041e3be9faf884b7e01d1] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##de0db0c8342e43acaa80d02125299d6b] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##de0db0c8342e43acaa80d02125299d6b] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##5145f1e25b5041e3be9faf884b7e01d1] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##de0db0c8342e43acaa80d02125299d6b] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##5145f1e25b5041e3be9faf884b7e01d1] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##de0db0c8342e43acaa80d02125299d6b] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##de0db0c8342e43acaa80d02125299d6b] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##5145f1e25b5041e3be9faf884b7e01d1] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 12:51:56,945 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##de0db0c8342e43acaa80d02125299d6b] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 12:52:53,012 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##9299be9ed0e94d768c89eb5a52ab6eeb] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-25 12:52:53,244 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9299be9ed0e94d768c89eb5a52ab6eeb] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##463b54666d9c414ab7d028bcb67707c1] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-25 13:03:41,697 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##4e890143438e468c99dff128044307e7] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 13:03:42,035 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##d4516150ad7c496aa8d78363160a57de] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 13:03:42,037 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4e890143438e468c99dff128044307e7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d4516150ad7c496aa8d78363160a57de] 时间: 2022-11-25 13:03:42,038 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##43595e2544ab49bf8dde5bb5784e25db FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##578a38b2579e43808b516a8dcf90defc] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##9fb3243366d24f918b6283fff1c226aa] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 13:03:42,098 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##09850e20a7e6421db1059c9f8f286646 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##578a38b2579e43808b516a8dcf90defc] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##9fb3243366d24f918b6283fff1c226aa] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 13:03:42,133 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##09850e20a7e6421db1059c9f8f286646 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 13:03:42,136 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##09850e20a7e6421db1059c9f8f286646 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 13:03:42,139 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##09850e20a7e6421db1059c9f8f286646 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 13:03:42,169 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##09850e20a7e6421db1059c9f8f286646 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 13:03:42,170 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##09850e20a7e6421db1059c9f8f286646 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 13:03:42,173 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##4e890143438e468c99dff128044307e7(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##1642fc85829d434d9ecf5642950144b0 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 13:03:42,179 线程ID: 5 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##4e890143438e468c99dff128044307e7 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##43595e2544ab49bf8dde5bb5784e25db T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 13:09:11,081 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##f0184e241b2e4591b710cf8aa0f67fc4] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##f0184e241b2e4591b710cf8aa0f67fc4] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##04c52c6a31204207be951a2ddb4560b5] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##f0184e241b2e4591b710cf8aa0f67fc4] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##f0184e241b2e4591b710cf8aa0f67fc4] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##04c52c6a31204207be951a2ddb4560b5] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##f0184e241b2e4591b710cf8aa0f67fc4] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##f0184e241b2e4591b710cf8aa0f67fc4] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##04c52c6a31204207be951a2ddb4560b5] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##f0184e241b2e4591b710cf8aa0f67fc4] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##04c52c6a31204207be951a2ddb4560b5] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##f0184e241b2e4591b710cf8aa0f67fc4] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##f0184e241b2e4591b710cf8aa0f67fc4] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##04c52c6a31204207be951a2ddb4560b5] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 13:09:11,555 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##f0184e241b2e4591b710cf8aa0f67fc4] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 13:58:58,445 线程ID: 58 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[3a1eb6a7-e90b-41b2-9cf7-2be00f689e94] FROM [##df6b5df85c734bab83b86d0b20ae486e] ORDER BY Goods_no 时间: 2022-11-25 13:59:11,655 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##f47e7e0e211247c4b44ed36e9d653eb2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 13:59:12,011 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##68373cdbe2cb4791b4bb914126dcd343] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 13:59:12,012 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f47e7e0e211247c4b44ed36e9d653eb2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##68373cdbe2cb4791b4bb914126dcd343] 时间: 2022-11-25 13:59:12,014 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##402f5f28962441fca20b0c7befee49e7 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##e43d0ddf05e8411ea7b11ab09fbb53f2] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##ada2f988b2024abf9d6b1c297b0bc348] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 13:59:12,074 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##fd32260c1b8545b5b9d7fa788b70472b FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##e43d0ddf05e8411ea7b11ab09fbb53f2] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##ada2f988b2024abf9d6b1c297b0bc348] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 13:59:12,108 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fd32260c1b8545b5b9d7fa788b70472b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 13:59:12,110 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd32260c1b8545b5b9d7fa788b70472b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 13:59:12,114 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fd32260c1b8545b5b9d7fa788b70472b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 13:59:12,142 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd32260c1b8545b5b9d7fa788b70472b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 13:59:12,144 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd32260c1b8545b5b9d7fa788b70472b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 13:59:12,148 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##f47e7e0e211247c4b44ed36e9d653eb2(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##0043901e256a47fcb85c6a496a9c855f GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 13:59:12,154 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##f47e7e0e211247c4b44ed36e9d653eb2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##402f5f28962441fca20b0c7befee49e7 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 15:13:13,445 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##d385103c7c514a59a6c380d69900efd1] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-25 15:13:13,663 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d385103c7c514a59a6c380d69900efd1] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##b6ec4eec15df46eabe911f4de30b39ea] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-25 15:13:19,948 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##5e7b0785c7a548e08f718d2a75615d17] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##5e7b0785c7a548e08f718d2a75615d17] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##d7d301d42a3e4bc58867137a1a114e64] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##5e7b0785c7a548e08f718d2a75615d17] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##5e7b0785c7a548e08f718d2a75615d17] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##d7d301d42a3e4bc58867137a1a114e64] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##5e7b0785c7a548e08f718d2a75615d17] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##5e7b0785c7a548e08f718d2a75615d17] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##d7d301d42a3e4bc58867137a1a114e64] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##5e7b0785c7a548e08f718d2a75615d17] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##d7d301d42a3e4bc58867137a1a114e64] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##5e7b0785c7a548e08f718d2a75615d17] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##5e7b0785c7a548e08f718d2a75615d17] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##d7d301d42a3e4bc58867137a1a114e64] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-25 15:13:20,494 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[55553c98-c475-4300-aa2e-34d9d3a9065a] FROM [##5e7b0785c7a548e08f718d2a75615d17] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-25 15:15:48,515 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##009f67d1befb42d79c66a82933374a4c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2022-11-25 15:15:48,523 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##009f67d1befb42d79c66a82933374a4c] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##009f67d1befb42d79c66a82933374a4c] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2022-11-25 15:15:48,528 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##009f67d1befb42d79c66a82933374a4c] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-25 15:15:48,532 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##009f67d1befb42d79c66a82933374a4c] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-25 15:15:48,535 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##009f67d1befb42d79c66a82933374a4c A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##009f67d1befb42d79c66a82933374a4c WHERE A.SortingID = SortingID ) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2022-11-25 15:15:48,547 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##009f67d1befb42d79c66a82933374a4c A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##009f67d1befb42d79c66a82933374a4c WHERE A.OrderID = OrderID ) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2022-11-25 15:15:48,562 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##009f67d1befb42d79c66a82933374a4c A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##009f67d1befb42d79c66a82933374a4c WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:15:48,594 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##009f67d1befb42d79c66a82933374a4c A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##009f67d1befb42d79c66a82933374a4c WHERE B.DeliveryID = DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:15:48,707 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##009f67d1befb42d79c66a82933374a4c A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##009f67d1befb42d79c66a82933374a4c C WHERE B.DeliveryID = C.DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:15:48,774 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##009f67d1befb42d79c66a82933374a4c SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2022-11-25 15:15:48,776 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##009f67d1befb42d79c66a82933374a4c] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##009f67d1befb42d79c66a82933374a4c] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:15:48,814 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[3a3d61b9-0b42-4e84-a7f4-747ec383b597] FROM [##009f67d1befb42d79c66a82933374a4c] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-25 15:30:09,491 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##876702cde7de4291bad89b96760fb827] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 15:30:09,844 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##d6e52758117c4600be590bbf6a07f274] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 15:30:09,846 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##876702cde7de4291bad89b96760fb827] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d6e52758117c4600be590bbf6a07f274] 时间: 2022-11-25 15:30:09,847 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##4a892fed34194777aeee399b1cf42a1f FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##c3aa37b06c604876a04307484ad93fce] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##a4683d1d45a042429124a97032f75351] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-25 15:30:09,911 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##6c584978a7a443acacf829e78009eeda FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##c3aa37b06c604876a04307484ad93fce] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##a4683d1d45a042429124a97032f75351] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-25' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-25 15:30:09,947 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6c584978a7a443acacf829e78009eeda a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 15:30:09,949 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c584978a7a443acacf829e78009eeda SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 15:30:09,952 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6c584978a7a443acacf829e78009eeda a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 15:30:09,982 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c584978a7a443acacf829e78009eeda SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 15:30:09,984 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c584978a7a443acacf829e78009eeda SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 15:30:09,987 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##876702cde7de4291bad89b96760fb827(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##acdf9ca8b04447be9ef2ba604d7e1c44 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-25 15:30:09,992 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[d058a106-75d3-4717-b5b4-58204c0631c4] FROM ##876702cde7de4291bad89b96760fb827 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No LEFT JOIN ##4a892fed34194777aeee399b1cf42a1f T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2022-11-25 15:31:46,688 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0494561056dc4a22965750b3d7b77584] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2022-11-25 15:31:46,694 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0494561056dc4a22965750b3d7b77584] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##0494561056dc4a22965750b3d7b77584] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2022-11-25 15:31:46,700 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##0494561056dc4a22965750b3d7b77584] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-25 15:31:46,704 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##0494561056dc4a22965750b3d7b77584] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-25 15:31:46,710 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##0494561056dc4a22965750b3d7b77584 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##0494561056dc4a22965750b3d7b77584 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##0a1965d21a0f4d62a9597efdb03d0580] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2022-11-25 15:31:46,766 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##0494561056dc4a22965750b3d7b77584 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##0494561056dc4a22965750b3d7b77584 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##0a1965d21a0f4d62a9597efdb03d0580] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2022-11-25 15:31:46,823 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##0494561056dc4a22965750b3d7b77584 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##0494561056dc4a22965750b3d7b77584 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##0a1965d21a0f4d62a9597efdb03d0580] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:31:46,935 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##0494561056dc4a22965750b3d7b77584 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##0494561056dc4a22965750b3d7b77584 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##0a1965d21a0f4d62a9597efdb03d0580] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:31:47,476 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##0494561056dc4a22965750b3d7b77584 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##0494561056dc4a22965750b3d7b77584 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##0a1965d21a0f4d62a9597efdb03d0580] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:31:47,858 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0494561056dc4a22965750b3d7b77584 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2022-11-25 15:31:47,859 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##0494561056dc4a22965750b3d7b77584] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##0494561056dc4a22965750b3d7b77584] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-25 15:31:47,896 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[3a3d61b9-0b42-4e84-a7f4-747ec383b597] FROM [##0494561056dc4a22965750b3d7b77584] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-25 16:44:44,396 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[db93c1d6-5dff-436b-8e1c-a8d3f0023b4c] FROM [##0f5e576c1f5944f6ae13b892e001527d] ORDER BY Goods_no 时间: 2022-11-25 16:44:49,794 线程ID: 96 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[db93c1d6-5dff-436b-8e1c-a8d3f0023b4c] FROM [##a919f54373ab47b89fc315c7d5cbe395] ORDER BY Goods_no 时间: 2022-11-25 16:45:36,965 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[db93c1d6-5dff-436b-8e1c-a8d3f0023b4c] FROM [##faa8594102a94ac3a2df48fd5871e864] ORDER BY Goods_no 时间: 2022-11-25 16:46:10,426 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##ed459ab23a1049da83ddda59c5c6f7d8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-25 16:46:10,762 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##709575c65d00410188460f45c70dc169] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-25 16:46:10,764 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ed459ab23a1049da83ddda59c5c6f7d8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##709575c65d00410188460f45c70dc169] 时间: 2022-11-25 16:46:10,821 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2fa574f4409743e9bc02f04793dd9554 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-25 16:46:10,824 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2fa574f4409743e9bc02f04793dd9554 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-25 16:46:10,827 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2fa574f4409743e9bc02f04793dd9554 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-11-25 16:46:10,859 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2fa574f4409743e9bc02f04793dd9554 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-25 16:46:10,861 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2fa574f4409743e9bc02f04793dd9554 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-25 16:46:10,864 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ed459ab23a1049da83ddda59c5c6f7d8] (Customer_ID,Goods_No, ColorID, Long, [销售#S1], 销售#数量, 销售#金额) SELECT Customer_ID, Goods_No, ColorID, Long, SUM([S1]) AS [S1], SUM(ISNULL([S1], 0)),SUM((ISNULL([S1], 0)) * DiscountPrice) as Amount FROM [##e215304b787f4c9d834dedbd6071d90f] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-11-25 16:46:10,868 线程ID: 90 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[72bfcbe2-c3e3-40ec-a9a2-fac5ed0f8d7f] FROM ##ed459ab23a1049da83ddda59c5c6f7d8 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END