时间: 2023-02-14 10:21:36,338 线程ID: 61 日志级别: 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.[b926494a-6843-44b7-8e90-693ed2b1ca13] FROM [##7d28ce9931db4056adf24f523ec086f0] ORDER BY Goods_no 时间: 2023-02-14 10:22:08,700 线程ID: 50 日志级别: 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 [##094ce1f30ca643b09ddcf48555a3d814] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 10:22:09,071 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ead4589e6fa34f26ad4c9856300c06ed] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 10:22:09,073 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##094ce1f30ca643b09ddcf48555a3d814] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ead4589e6fa34f26ad4c9856300c06ed] 时间: 2023-02-14 10:22:09,077 线程ID: 50 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##094ce1f30ca643b09ddcf48555a3d814 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 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 时间: 2023-02-14 10:22:26,862 线程ID: 61 日志级别: 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 [##d79ce995e62343b1be82b05fbc3cb188] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 10:22:27,100 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d79ce995e62343b1be82b05fbc3cb188] (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 [##a49d5091de5c4ba79c3a2892e17fc36b] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:22:27,439 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d79ce995e62343b1be82b05fbc3cb188] (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 [##e73767b1772e4dbeaf4e046ff3fa85e8] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:22:28,049 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d79ce995e62343b1be82b05fbc3cb188] (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 [##6f5fa3a1372f4e4b964169c602675e7a] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:22:28,052 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d79ce995e62343b1be82b05fbc3cb188] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 10:23:03,862 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##9bcc21519957424e9b0a3314ddbac768] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##9bcc21519957424e9b0a3314ddbac768] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##42324ef48f304b13b04c1410ab956f24] 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 [##9bcc21519957424e9b0a3314ddbac768] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##9bcc21519957424e9b0a3314ddbac768] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##42324ef48f304b13b04c1410ab956f24] 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 [##9bcc21519957424e9b0a3314ddbac768] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##9bcc21519957424e9b0a3314ddbac768] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##42324ef48f304b13b04c1410ab956f24] 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 [##9bcc21519957424e9b0a3314ddbac768] 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 [##42324ef48f304b13b04c1410ab956f24] 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 [##9bcc21519957424e9b0a3314ddbac768] 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 [##9bcc21519957424e9b0a3314ddbac768] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##42324ef48f304b13b04c1410ab956f24] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-02-14 10:23:04,421 线程ID: 117 日志级别: 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.[632c49d2-caf5-4593-9a9e-2983d6b55b42] FROM [##9bcc21519957424e9b0a3314ddbac768] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-02-14 10:23:18,752 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##3ed8c83882624967b05dd25e44d96206] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##3ed8c83882624967b05dd25e44d96206] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##db5085d42451439e8718802178fc0ce0] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 10:23:18,826 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##3ed8c83882624967b05dd25e44d96206] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 10:46:54,783 线程ID: 50 日志级别: 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 [##173f6277a72b474aa5801d0e368ef6db] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 10:46:55,174 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##de7a946b3bea4850ba02a2c6851d6061] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 10:46:55,176 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##173f6277a72b474aa5801d0e368ef6db] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##de7a946b3bea4850ba02a2c6851d6061] 时间: 2023-02-14 10:46:55,178 线程ID: 50 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##173f6277a72b474aa5801d0e368ef6db 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 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 时间: 2023-02-14 10:47:21,499 线程ID: 123 日志级别: 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 [##e501f061798342ea9306e49f158b1e06] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 10:47:21,871 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##87793565c7164659a6e6f1de71e915d4] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 10:47:21,872 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e501f061798342ea9306e49f158b1e06] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##87793565c7164659a6e6f1de71e915d4] 时间: 2023-02-14 10:47:21,874 线程ID: 123 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##e501f061798342ea9306e49f158b1e06 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 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 时间: 2023-02-14 10:47:26,607 线程ID: 117 日志级别: 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 [##5e878f9ef9bd49289333500f8f786a62] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 10:47:26,827 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5e878f9ef9bd49289333500f8f786a62] (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 [##100647b4f92e4ad19715917e8e094e34] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:47:27,147 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5e878f9ef9bd49289333500f8f786a62] (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 [##7e8c0054f32d43349c83ad0f8bb1df6a] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:47:27,759 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5e878f9ef9bd49289333500f8f786a62] (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 [##e32f6dc9bb1c4328b42d6e082ef07595] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:47:27,762 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##5e878f9ef9bd49289333500f8f786a62] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 10:53:10,248 线程ID: 61 日志级别: 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 [##12eb5264d0584a43be5b6eef14e146ad] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 10:53:10,635 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##583459889a0c4680bcabcc0315eee6f1] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 10:53:10,638 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##12eb5264d0584a43be5b6eef14e146ad] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##583459889a0c4680bcabcc0315eee6f1] 时间: 2023-02-14 10:53:10,640 线程ID: 61 日志级别: 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 ##05c8f0233c064df7a2c06eb4e5f95541 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 [##7e6744c4f72442c692a90e500598c7a3] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##9e3dc543eee04947b7c30ac2cc15d41e] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-14 10:53:10,699 线程ID: 61 日志级别: 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 ##47aa84e626754b0d97b68e381efaac7d 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 [##7e6744c4f72442c692a90e500598c7a3] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##9e3dc543eee04947b7c30ac2cc15d41e] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-14' 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 时间: 2023-02-14 10:53:10,738 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##47aa84e626754b0d97b68e381efaac7d a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 10:53:10,741 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##47aa84e626754b0d97b68e381efaac7d SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 10:53:10,745 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##47aa84e626754b0d97b68e381efaac7d 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 = '退货' 时间: 2023-02-14 10:53:10,778 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##47aa84e626754b0d97b68e381efaac7d SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 10:53:10,779 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##47aa84e626754b0d97b68e381efaac7d SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 10:53:10,782 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##12eb5264d0584a43be5b6eef14e146ad(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##127d56adcc514d59941d8ec2c743d731 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-14 10:53:10,788 线程ID: 61 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##12eb5264d0584a43be5b6eef14e146ad 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 ##05c8f0233c064df7a2c06eb4e5f95541 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 时间: 2023-02-14 10:53:25,153 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##049dd17ee5d744188d9dd93d5169c454] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##049dd17ee5d744188d9dd93d5169c454] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##a1dcac5fd18244f2b4592fda9ede6f72] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 10:53:25,232 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##049dd17ee5d744188d9dd93d5169c454] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 10:53:52,875 线程ID: 123 日志级别: 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 [##b508c0ccc92e4780a3293d7cde2f4c65] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 10:53:53,266 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##349b5264d4dc44c28ed0e71328d9dcbf] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 10:53:53,267 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b508c0ccc92e4780a3293d7cde2f4c65] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##349b5264d4dc44c28ed0e71328d9dcbf] 时间: 2023-02-14 10:53:53,269 线程ID: 123 日志级别: 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 ##10827fddfbdf4ff0abe5e41b0cf67553 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 [##2e24d83b3e1e479287648bb724d5882e] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##b4e3c387af5e4461a7fc03f742168ddb] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-14 10:53:53,332 线程ID: 123 日志级别: 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 ##104fb674cb3b47c699ac061e0672bcdf 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 [##2e24d83b3e1e479287648bb724d5882e] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##b4e3c387af5e4461a7fc03f742168ddb] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-14' 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 时间: 2023-02-14 10:53:53,367 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##104fb674cb3b47c699ac061e0672bcdf a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 10:53:53,369 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##104fb674cb3b47c699ac061e0672bcdf SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 10:53:53,374 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##104fb674cb3b47c699ac061e0672bcdf 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 = '退货' 时间: 2023-02-14 10:53:53,404 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##104fb674cb3b47c699ac061e0672bcdf SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 10:53:53,406 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##104fb674cb3b47c699ac061e0672bcdf SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 10:53:53,409 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##b508c0ccc92e4780a3293d7cde2f4c65(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##a978b35916f446b0887b17c497a6f6a3 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-14 10:53:53,414 线程ID: 123 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##b508c0ccc92e4780a3293d7cde2f4c65 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 ##10827fddfbdf4ff0abe5e41b0cf67553 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 时间: 2023-02-14 10:54:13,840 线程ID: 50 日志级别: 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 [##3dc94c351c034d1090070b366682c52c] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 10:54:14,066 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3dc94c351c034d1090070b366682c52c] (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 [##e595ef178448456ea8e0e7e237b08a41] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:54:14,390 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3dc94c351c034d1090070b366682c52c] (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 [##9bbce2690c0b46579e709a0d1a1fc0bc] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:54:15,024 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3dc94c351c034d1090070b366682c52c] (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 [##50e846a59b104c0bb69a7d065c3e7346] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 10:54:15,028 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##3dc94c351c034d1090070b366682c52c] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 12:55:39,416 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5215ff104a7d43ccbb293abbffbb10b5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-14 12:55:39,424 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##5215ff104a7d43ccbb293abbffbb10b5] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##5215ff104a7d43ccbb293abbffbb10b5] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-14 12:55:39,431 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##5215ff104a7d43ccbb293abbffbb10b5] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-14 12:55:39,436 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##5215ff104a7d43ccbb293abbffbb10b5] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-14 12:55:39,439 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##5215ff104a7d43ccbb293abbffbb10b5 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##5215ff104a7d43ccbb293abbffbb10b5 WHERE A.SortingID = SortingID ) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-14 12:55:39,451 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##5215ff104a7d43ccbb293abbffbb10b5 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##5215ff104a7d43ccbb293abbffbb10b5 WHERE A.OrderID = OrderID ) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-14 12:55:39,466 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##5215ff104a7d43ccbb293abbffbb10b5 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 ##5215ff104a7d43ccbb293abbffbb10b5 WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 12:55:39,506 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##5215ff104a7d43ccbb293abbffbb10b5 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 ##5215ff104a7d43ccbb293abbffbb10b5 WHERE B.DeliveryID = DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 12:55:39,615 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##5215ff104a7d43ccbb293abbffbb10b5 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 ##5215ff104a7d43ccbb293abbffbb10b5 C WHERE B.DeliveryID = C.DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 12:55:39,681 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5215ff104a7d43ccbb293abbffbb10b5 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-14 12:55:39,683 线程ID: 116 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##5215ff104a7d43ccbb293abbffbb10b5] 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 [##5215ff104a7d43ccbb293abbffbb10b5] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 12:55:39,720 线程ID: 116 日志级别: 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.[678f6b3a-1c5d-47d1-8205-5235c33dc9f9] FROM [##5215ff104a7d43ccbb293abbffbb10b5] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 13:00:41,485 线程ID: 117 日志级别: 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 [##e90bd3ad5f274d1dab75df351921ecfa] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 13:00:41,703 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e90bd3ad5f274d1dab75df351921ecfa] (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 [##820bc67c61954611a85db98a37679bff] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:00:42,043 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e90bd3ad5f274d1dab75df351921ecfa] (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 [##b0f076968c8741beb8009508b53f2949] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:00:42,712 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e90bd3ad5f274d1dab75df351921ecfa] (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 [##1e99a68b93c64350a16d545659ac2cc5] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:00:42,715 线程ID: 117 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e90bd3ad5f274d1dab75df351921ecfa] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 13:01:00,228 线程ID: 40 日志级别: 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 [##c8caae6d6ea4497681e22c694fdf05f6] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 13:01:00,427 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c8caae6d6ea4497681e22c694fdf05f6] (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 [##89361874b4f444c4bd0e2cc97eac12c0] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:01:00,739 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c8caae6d6ea4497681e22c694fdf05f6] (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 [##b7caf6a7a14a40e28000fa85ef816d42] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:01:01,325 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c8caae6d6ea4497681e22c694fdf05f6] (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 [##d8ea9ef3c43a403aa04d71f0ef08c59d] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:01:01,328 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##c8caae6d6ea4497681e22c694fdf05f6] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 13:01:38,867 线程ID: 123 日志级别: 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 [##afef3b50c80443889fb8fdb679a7d2df] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 13:01:39,087 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##afef3b50c80443889fb8fdb679a7d2df] (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 [##af5d47feb8ec4b03ac0987824be5c4bf] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:01:39,410 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##afef3b50c80443889fb8fdb679a7d2df] (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 [##2e949ac5ee664519971043b4a3214886] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:01:40,011 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##afef3b50c80443889fb8fdb679a7d2df] (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 [##db8b82aec4784225ad8598d135e92cb4] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:01:40,014 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##afef3b50c80443889fb8fdb679a7d2df] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 13:03:00,788 线程ID: 120 日志级别: 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 [##ff00d6b03b5942d4b41be460dd3c5e6b] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 13:03:00,996 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff00d6b03b5942d4b41be460dd3c5e6b] (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 [##401f1a606cd04081b764a599eab1526c] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:01,314 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff00d6b03b5942d4b41be460dd3c5e6b] (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 [##4517625062b44925bf7e750de692b34c] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:01,900 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff00d6b03b5942d4b41be460dd3c5e6b] (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 [##78517f67e3fa47cab3ac2a085f01ad30] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:01,903 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##ff00d6b03b5942d4b41be460dd3c5e6b] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 13:03:27,367 线程ID: 40 日志级别: 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 [##ff6d1e6dc3e14b0583bfea4bf113c8c6] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 13:03:27,584 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff6d1e6dc3e14b0583bfea4bf113c8c6] (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 [##1585b0535ec34568a1eabe986cc6be8a] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:27,960 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff6d1e6dc3e14b0583bfea4bf113c8c6] (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 [##2b460d30024f428e9399066e7771623d] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:28,552 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff6d1e6dc3e14b0583bfea4bf113c8c6] (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 [##f2c87960aa704b969f247bbdce1eb5c9] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:28,555 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##ff6d1e6dc3e14b0583bfea4bf113c8c6] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 13:03:36,711 线程ID: 123 日志级别: 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 [##b5cbaca870f947c2ad52145482e845cf] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-14 13:03:36,925 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b5cbaca870f947c2ad52145482e845cf] (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 [##57649c27c6e7402591ec5de3a9b4a556] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:37,518 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b5cbaca870f947c2ad52145482e845cf] (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 [##1441aa0dcf184f8f80c76f8348e9168c] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-14 13:03:37,521 线程ID: 123 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##b5cbaca870f947c2ad52145482e845cf] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-14 13:04:02,245 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##ca828890c4c54c5993b61ff30f498f59] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##ca828890c4c54c5993b61ff30f498f59] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##1f6380199de442fcb327a187d28c6db9] 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 [##ca828890c4c54c5993b61ff30f498f59] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##ca828890c4c54c5993b61ff30f498f59] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##1f6380199de442fcb327a187d28c6db9] 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 [##ca828890c4c54c5993b61ff30f498f59] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##ca828890c4c54c5993b61ff30f498f59] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##1f6380199de442fcb327a187d28c6db9] 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 [##ca828890c4c54c5993b61ff30f498f59] 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 [##1f6380199de442fcb327a187d28c6db9] 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 [##ca828890c4c54c5993b61ff30f498f59] 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 [##ca828890c4c54c5993b61ff30f498f59] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##1f6380199de442fcb327a187d28c6db9] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-02-14 13:04:02,773 线程ID: 50 日志级别: 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.[632c49d2-caf5-4593-9a9e-2983d6b55b42] FROM [##ca828890c4c54c5993b61ff30f498f59] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-02-14 13:08:25,160 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##94aadbd28e2743e798e93edb67fc4336] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##94aadbd28e2743e798e93edb67fc4336] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##cf5e994a75954c07b5254c7f8de28ccc] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 13:08:25,342 线程ID: 120 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##94aadbd28e2743e798e93edb67fc4336] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 16:05:12,760 线程ID: 24 日志级别: 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.[a5f59db1-d57b-482b-aaa4-89ebcb5fadd2] FROM [##cf46eb8c5176434c939466c313cb4b3e] ORDER BY Goods_no 时间: 2023-02-14 16:05:25,350 线程ID: 9 日志级别: 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 [##56bfdc6149c14daaa2fb4d18c241c576] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 16:05:25,738 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##16e692029874426caf812df3d6a5ee94] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 16:05:25,740 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##56bfdc6149c14daaa2fb4d18c241c576] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##16e692029874426caf812df3d6a5ee94] 时间: 2023-02-14 16:05:25,743 线程ID: 9 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[96231c7d-2d11-41ba-9e57-0fec58bd3d66] FROM ##56bfdc6149c14daaa2fb4d18c241c576 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 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 时间: 2023-02-14 16:05:38,296 线程ID: 45 日志级别: 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 [##f20d455062224ceb92e8e7b9511046a9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 16:05:38,686 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##916075bc744e46ea8f2a07741fb2ca75] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 16:05:38,688 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f20d455062224ceb92e8e7b9511046a9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##916075bc744e46ea8f2a07741fb2ca75] 时间: 2023-02-14 16:05:38,691 线程ID: 45 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[96231c7d-2d11-41ba-9e57-0fec58bd3d66] FROM ##f20d455062224ceb92e8e7b9511046a9 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 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 时间: 2023-02-14 16:05:42,300 线程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 [##1a2a478f385b4cfea10d733e43c52a59] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 16:05:42,691 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fb2ab06c03074930afedb061a0761f1c] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 16:05:42,692 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1a2a478f385b4cfea10d733e43c52a59] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fb2ab06c03074930afedb061a0761f1c] 时间: 2023-02-14 16:05:42,695 线程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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[96231c7d-2d11-41ba-9e57-0fec58bd3d66] FROM ##1a2a478f385b4cfea10d733e43c52a59 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 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 时间: 2023-02-14 16:05:50,350 线程ID: 45 日志级别: 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 [##cf92819d156e429295d4d057d884aab9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 16:05:50,734 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c50322d9cc4f44309c71b586530ae241] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 16:05:50,738 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cf92819d156e429295d4d057d884aab9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c50322d9cc4f44309c71b586530ae241] 时间: 2023-02-14 16:05:50,739 线程ID: 45 日志级别: 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 ##2b5db678cfd74ad4ae66d6c2a153e9d6 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 [##16ebca220d5643d5a64ad0f08120cc8f] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##89f1f26b26254b4c977d9767f9ecf346] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-14 16:05:50,801 线程ID: 45 日志级别: 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 ##d9ca0b4072594eabb7ea5f94ac83404f 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 [##16ebca220d5643d5a64ad0f08120cc8f] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##89f1f26b26254b4c977d9767f9ecf346] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-12' 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 时间: 2023-02-14 16:05:50,837 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d9ca0b4072594eabb7ea5f94ac83404f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 16:05:50,839 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9ca0b4072594eabb7ea5f94ac83404f SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 16:05:50,843 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d9ca0b4072594eabb7ea5f94ac83404f 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 = '退货' 时间: 2023-02-14 16:05:50,875 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9ca0b4072594eabb7ea5f94ac83404f SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 16:05:50,877 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9ca0b4072594eabb7ea5f94ac83404f SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 16:05:50,880 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##cf92819d156e429295d4d057d884aab9(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##9b8a63cb65704eb0b537d82a69278a85 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-14 16:05:50,886 线程ID: 45 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量] INTO tempdb.dbo.[96231c7d-2d11-41ba-9e57-0fec58bd3d66] FROM ##cf92819d156e429295d4d057d884aab9 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 ##2b5db678cfd74ad4ae66d6c2a153e9d6 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 时间: 2023-02-14 16:06:35,572 线程ID: 24 日志级别: 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 [##e67f5af6ff8e4539a91a7851de72f1ea] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 16:06:36,002 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##377c1ccf081f47ea9bc36208247b864b] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 16:06:36,007 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e67f5af6ff8e4539a91a7851de72f1ea] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##377c1ccf081f47ea9bc36208247b864b] 时间: 2023-02-14 16:06:36,009 线程ID: 24 日志级别: 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 ##5fad684f59594e88821df14449413d84 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 [##485655d49cd54e1ba5afa01a3571fbb7] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##5d344a401d8448e5b3ec39d9ac13a318] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-14 16:06:36,074 线程ID: 24 日志级别: 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 ##a9a2faa5edaa4f02a49c7ce30f9346a5 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 [##485655d49cd54e1ba5afa01a3571fbb7] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##5d344a401d8448e5b3ec39d9ac13a318] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-12' 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 时间: 2023-02-14 16:06:36,111 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a9a2faa5edaa4f02a49c7ce30f9346a5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 16:06:36,114 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9a2faa5edaa4f02a49c7ce30f9346a5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 16:06:36,117 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a9a2faa5edaa4f02a49c7ce30f9346a5 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 = '退货' 时间: 2023-02-14 16:06:36,151 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9a2faa5edaa4f02a49c7ce30f9346a5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 16:06:36,153 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9a2faa5edaa4f02a49c7ce30f9346a5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 16:06:36,156 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e67f5af6ff8e4539a91a7851de72f1ea(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##bfe70019a8a84eb7bf2f277eddd8ea09 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-14 16:06:36,162 线程ID: 24 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量] INTO tempdb.dbo.[96231c7d-2d11-41ba-9e57-0fec58bd3d66] FROM ##e67f5af6ff8e4539a91a7851de72f1ea 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 ##5fad684f59594e88821df14449413d84 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 时间: 2023-02-14 16:57:58,536 线程ID: 18 日志级别: 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.[123bc1b5-4b59-408e-9291-fd34aab74195] FROM [##aef033092ccf4d33b3740552786cdf34] ORDER BY Goods_no 时间: 2023-02-14 16:58:05,885 线程ID: 74 日志级别: 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 [##4acd58570a7b4a3484f047b9c1338418] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 16:58:06,272 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a790f182fc8a48caac68c91a80081a4d] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 16:58:06,275 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4acd58570a7b4a3484f047b9c1338418] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a790f182fc8a48caac68c91a80081a4d] 时间: 2023-02-14 16:58:06,329 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##560de8245b2a4fef9e569ea399052f2e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 16:58:06,331 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##560de8245b2a4fef9e569ea399052f2e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 16:58:06,335 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##560de8245b2a4fef9e569ea399052f2e 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 = '退货' 时间: 2023-02-14 16:58:06,368 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##560de8245b2a4fef9e569ea399052f2e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 16:58:06,370 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##560de8245b2a4fef9e569ea399052f2e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 16:58:06,373 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4acd58570a7b4a3484f047b9c1338418] (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 [##7a68dbef0f97485499b0c2ceb957450a] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-02-14 16:58:06,379 线程ID: 74 日志级别: 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.[4ed3efdb-5d0a-44bd-aea3-adfe20b95ec8] FROM ##4acd58570a7b4a3484f047b9c1338418 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 时间: 2023-02-14 17:35:20,579 线程ID: 54 日志级别: 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.[b926494a-6843-44b7-8e90-693ed2b1ca13] FROM [##725885e9c55244f88d78f5df4551addf] ORDER BY Goods_no 时间: 2023-02-14 17:35:36,670 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##e8532e85dddb42859c8cc1789f5d71fd] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##e8532e85dddb42859c8cc1789f5d71fd] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##46f84d75ae7f499eb2ccb45f3229f654] 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 [##e8532e85dddb42859c8cc1789f5d71fd] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##e8532e85dddb42859c8cc1789f5d71fd] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##46f84d75ae7f499eb2ccb45f3229f654] 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 [##e8532e85dddb42859c8cc1789f5d71fd] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##e8532e85dddb42859c8cc1789f5d71fd] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##46f84d75ae7f499eb2ccb45f3229f654] 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 [##e8532e85dddb42859c8cc1789f5d71fd] 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 [##46f84d75ae7f499eb2ccb45f3229f654] 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 [##e8532e85dddb42859c8cc1789f5d71fd] 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 [##e8532e85dddb42859c8cc1789f5d71fd] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##46f84d75ae7f499eb2ccb45f3229f654] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-02-14 17:35:37,155 线程ID: 60 日志级别: 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.[632c49d2-caf5-4593-9a9e-2983d6b55b42] FROM [##e8532e85dddb42859c8cc1789f5d71fd] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-02-14 17:38:50,485 线程ID: 60 日志级别: 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 [##7b7424525f614c5798cdfddcb75ea796] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 17:38:50,872 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4fbffc5912ad495cbb8256e1d865a09b] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 17:38:50,874 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7b7424525f614c5798cdfddcb75ea796] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4fbffc5912ad495cbb8256e1d865a09b] 时间: 2023-02-14 17:38:50,875 线程ID: 60 日志级别: 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 ##7711a46d05f54b9fa6264b2aa892362d 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 [##43845942c57e46959c321fea8cb0f581] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##900bc53e951e4950be84c5c192a634c2] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-14 17:38:50,938 线程ID: 60 日志级别: 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 ##fdac846d2efa4c40943f5fb67b1ec794 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 [##43845942c57e46959c321fea8cb0f581] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##900bc53e951e4950be84c5c192a634c2] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-14' 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 时间: 2023-02-14 17:38:50,975 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fdac846d2efa4c40943f5fb67b1ec794 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 17:38:50,977 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fdac846d2efa4c40943f5fb67b1ec794 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 17:38:50,981 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fdac846d2efa4c40943f5fb67b1ec794 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 = '退货' 时间: 2023-02-14 17:38:51,013 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fdac846d2efa4c40943f5fb67b1ec794 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 17:38:51,015 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fdac846d2efa4c40943f5fb67b1ec794 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 17:38:51,018 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b7424525f614c5798cdfddcb75ea796(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##71a4330f4b7944e39c44edb1a98c5425 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-14 17:38:51,023 线程ID: 60 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##7b7424525f614c5798cdfddcb75ea796 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 ##7711a46d05f54b9fa6264b2aa892362d 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 时间: 2023-02-14 17:39:05,137 线程ID: 60 日志级别: 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 [##822766e2124b4a678a33c7a508c12e52] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 17:39:05,523 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1041875303b8418e8a26e6777f4c97dd] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 17:39:05,525 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##822766e2124b4a678a33c7a508c12e52] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1041875303b8418e8a26e6777f4c97dd] 时间: 2023-02-14 17:39:05,527 线程ID: 60 日志级别: 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 ##ce4c847b5a9a4ef5b62b15d65ecd9db7 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 [##78b69261121a443f8080a7b0d6bf6263] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##a6097b57d9d041a2b3a4db7aa3fa9f93] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-14 17:39:05,591 线程ID: 60 日志级别: 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 ##2411b4ddf5ab4f7ca98eb2a6e55bdee4 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 [##78b69261121a443f8080a7b0d6bf6263] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##a6097b57d9d041a2b3a4db7aa3fa9f93] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-14' 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 时间: 2023-02-14 17:39:05,626 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2411b4ddf5ab4f7ca98eb2a6e55bdee4 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 17:39:05,628 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2411b4ddf5ab4f7ca98eb2a6e55bdee4 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 17:39:05,631 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2411b4ddf5ab4f7ca98eb2a6e55bdee4 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 = '退货' 时间: 2023-02-14 17:39:05,663 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2411b4ddf5ab4f7ca98eb2a6e55bdee4 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 17:39:05,665 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2411b4ddf5ab4f7ca98eb2a6e55bdee4 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 17:39:05,670 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##822766e2124b4a678a33c7a508c12e52(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##c27270e0a91844e1b07606cc35edda5f GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-14 17:39:05,676 线程ID: 60 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##822766e2124b4a678a33c7a508c12e52 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 ##ce4c847b5a9a4ef5b62b15d65ecd9db7 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 时间: 2023-02-14 17:39:24,736 线程ID: 23 日志级别: 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 [##6814207a2d784154b4f5db854b8eabe2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-14 17:39:25,153 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##048ba7f0d22c41ccb78b818213b8f5c6] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-14 17:39:25,155 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6814207a2d784154b4f5db854b8eabe2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##048ba7f0d22c41ccb78b818213b8f5c6] 时间: 2023-02-14 17:39:25,211 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ac5fc74d70f448a9a598ee789c8005ff a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-14 17:39:25,213 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac5fc74d70f448a9a598ee789c8005ff SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-14 17:39:25,216 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ac5fc74d70f448a9a598ee789c8005ff 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 = '退货' 时间: 2023-02-14 17:39:25,247 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac5fc74d70f448a9a598ee789c8005ff SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-14 17:39:25,248 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac5fc74d70f448a9a598ee789c8005ff SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-14 17:39:25,251 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6814207a2d784154b4f5db854b8eabe2] (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 [##05c31b7ef95f47f99a4aacaa72c9bd4b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-02-14 17:39:25,257 线程ID: 23 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[eb67fd54-78fc-4c22-9280-765bd6fcf6e8] FROM ##6814207a2d784154b4f5db854b8eabe2 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 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 时间: 2023-02-14 17:41:31,236 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##17b1edc5cec249ba99baeffc885e8c55] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##17b1edc5cec249ba99baeffc885e8c55] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##e4bcac95b91d4309805327103744419a] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 17:41:31,326 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##17b1edc5cec249ba99baeffc885e8c55] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 17:41:43,971 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##6f76b7c91b88457aada13317c1ccdd6c] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##6f76b7c91b88457aada13317c1ccdd6c] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##3b78088194b54d5bbdeeb2f15652202a] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 17:41:44,056 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##6f76b7c91b88457aada13317c1ccdd6c] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 17:42:09,385 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##a6a2179230a84a0f837c69dce1b86f99] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##a6a2179230a84a0f837c69dce1b86f99] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##3a07a8ac12d44ac1b31bb1f70d35ea50] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 17:42:09,472 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##a6a2179230a84a0f837c69dce1b86f99] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-14 17:42:42,452 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##c8fd369b323b4c9d83cea4cc9031d644] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##c8fd369b323b4c9d83cea4cc9031d644] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##a50de8b65da94cfc856e74bd10c45089] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-14 17:42:42,533 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[904dcfc0-fad2-4aab-a1bf-270086983f45] FROM [##c8fd369b323b4c9d83cea4cc9031d644] ORDER BY Delivery_Date DESC, DeliveryID ASC