时间: 2025-04-06 11:11:05,677 线程ID: 25 日志级别: 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 [##fc75aa9392b44454b89f3eefc2442775] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 11:11:06,246 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c4114c8aece74687b90f82523efcf815] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 11:11:06,247 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fc75aa9392b44454b89f3eefc2442775] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c4114c8aece74687b90f82523efcf815] 时间: 2025-04-06 11:11:06,315 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f34cc8ccef2e44ee8f6e64a0d47d2a1d a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 11:11:06,322 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f34cc8ccef2e44ee8f6e64a0d47d2a1d SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 11:11:06,324 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f34cc8ccef2e44ee8f6e64a0d47d2a1d 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 = '退货' 时间: 2025-04-06 11:11:06,353 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f34cc8ccef2e44ee8f6e64a0d47d2a1d SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 11:11:06,355 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f34cc8ccef2e44ee8f6e64a0d47d2a1d SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 11:11:06,361 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fc75aa9392b44454b89f3eefc2442775] (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 [##78b610b3e94a444fa54fe2c5f0b4fb20] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 11:11:06,366 线程ID: 25 日志级别: 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.[1405aa4d-197e-49c5-ad93-05786dffc76c] FROM ##fc75aa9392b44454b89f3eefc2442775 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 时间: 2025-04-06 12:15:13,370 线程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 [##6c145a162db74a72a48cae0644b70dd4] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 12:15:13,792 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0486f358827a4a079b890c3f70b22dd9] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 12:15:13,794 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6c145a162db74a72a48cae0644b70dd4] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0486f358827a4a079b890c3f70b22dd9] 时间: 2025-04-06 12:15:13,850 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9e2d4f2352814579a3a2eebc543f26f5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 12:15:13,852 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9e2d4f2352814579a3a2eebc543f26f5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 12:15:13,854 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9e2d4f2352814579a3a2eebc543f26f5 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 = '退货' 时间: 2025-04-06 12:15:13,883 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9e2d4f2352814579a3a2eebc543f26f5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 12:15:13,885 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9e2d4f2352814579a3a2eebc543f26f5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 12:15:13,888 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6c145a162db74a72a48cae0644b70dd4] (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 [##40f675b0c2c34c108d79ee0e0d04be2b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 12:15:13,894 线程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 [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[d5afe491-9e8a-4362-b750-076ca5134483] FROM ##6c145a162db74a72a48cae0644b70dd4 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, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2025-04-06 15:52:40,200 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##93be3c11f0044d30b5fcdf1946d61e0a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 15:52:40,673 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##647512162ddc42c08dcc07e88ba58994] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 15:52:40,675 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##93be3c11f0044d30b5fcdf1946d61e0a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##647512162ddc42c08dcc07e88ba58994] 时间: 2025-04-06 15:52:40,740 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2a9be10a8b4d424d811b82de6f40d4d4 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 15:52:40,743 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2a9be10a8b4d424d811b82de6f40d4d4 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 15:52:40,746 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2a9be10a8b4d424d811b82de6f40d4d4 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 = '退货' 时间: 2025-04-06 15:52:40,781 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2a9be10a8b4d424d811b82de6f40d4d4 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 15:52:40,783 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2a9be10a8b4d424d811b82de6f40d4d4 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 15:52:40,783 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##93be3c11f0044d30b5fcdf1946d61e0a] (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 [##95864dee073c45a2b9fa984bd7cd3205] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 15:52:40,783 线程ID: 77 日志级别: 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.[f66251f7-6a6c-42d4-941c-6d8735c69d29] FROM ##93be3c11f0044d30b5fcdf1946d61e0a 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 时间: 2025-04-06 15:53:06,509 线程ID: 72 日志级别: 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 [##9a706e64c36244caa09a67cf26863d74] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 15:53:06,935 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1ee8fdca6b0a478cb4afac6e460019f3] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 15:53:06,937 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9a706e64c36244caa09a67cf26863d74] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1ee8fdca6b0a478cb4afac6e460019f3] 时间: 2025-04-06 15:53:06,993 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5093b7aa248140ea9a5ccc0b91d04ed1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 15:53:06,995 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5093b7aa248140ea9a5ccc0b91d04ed1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 15:53:06,998 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5093b7aa248140ea9a5ccc0b91d04ed1 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 = '退货' 时间: 2025-04-06 15:53:07,027 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5093b7aa248140ea9a5ccc0b91d04ed1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 15:53:07,029 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5093b7aa248140ea9a5ccc0b91d04ed1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 15:53:07,033 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9a706e64c36244caa09a67cf26863d74] (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 [##ef754ad3755a4535b391a2f086e9de25] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 15:53:07,037 线程ID: 72 日志级别: 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.[f66251f7-6a6c-42d4-941c-6d8735c69d29] FROM ##9a706e64c36244caa09a67cf26863d74 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 时间: 2025-04-06 17:22:21,540 线程ID: 41 日志级别: 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 [##47e24c4a7a414ac6b392692290138982] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 17:22:21,974 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4a60e6c73da2454d8081f2135cc60406] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 17:22:21,976 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##47e24c4a7a414ac6b392692290138982] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4a60e6c73da2454d8081f2135cc60406] 时间: 2025-04-06 17:22:22,040 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f4a34bc8098d4be18f8dcde00011d9ef a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 17:22:22,044 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4a34bc8098d4be18f8dcde00011d9ef SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 17:22:22,046 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f4a34bc8098d4be18f8dcde00011d9ef 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 = '退货' 时间: 2025-04-06 17:22:22,082 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4a34bc8098d4be18f8dcde00011d9ef SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 17:22:22,083 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4a34bc8098d4be18f8dcde00011d9ef SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 17:22:22,088 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##47e24c4a7a414ac6b392692290138982] (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 [##ae06cc218ce449009d89e7e424a43866] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 17:22:22,105 线程ID: 41 日志级别: 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.[2ecb4901-12a5-4d09-b958-0696d75ee16e] FROM ##47e24c4a7a414ac6b392692290138982 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 时间: 2025-04-06 17:33:16,132 线程ID: 32 日志级别: 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 [##f1e1b45d9bde44eeb821a67d3c514cfd] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 17:33:16,555 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4963e4f164e14c2e86dcbb8231872906] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 17:33:16,561 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f1e1b45d9bde44eeb821a67d3c514cfd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4963e4f164e14c2e86dcbb8231872906] 时间: 2025-04-06 17:33:16,630 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a8d0f22ff3dd4d44a933829932911750 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 17:33:16,634 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8d0f22ff3dd4d44a933829932911750 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 17:33:16,640 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a8d0f22ff3dd4d44a933829932911750 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 = '退货' 时间: 2025-04-06 17:33:16,675 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8d0f22ff3dd4d44a933829932911750 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 17:33:16,678 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8d0f22ff3dd4d44a933829932911750 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 17:33:16,682 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f1e1b45d9bde44eeb821a67d3c514cfd] (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 [##1c4932da05b74e2bafb87239088c2e7a] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 17:33:16,686 线程ID: 32 日志级别: 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.[2ecb4901-12a5-4d09-b958-0696d75ee16e] FROM ##f1e1b45d9bde44eeb821a67d3c514cfd 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 时间: 2025-04-06 17:33:36,843 线程ID: 32 日志级别: 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 [##3d42f24ac6a142ae80ce694ea7874c7a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 17:33:37,216 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##280001dd68484901a95e087ad162e6f5] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 17:33:37,218 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3d42f24ac6a142ae80ce694ea7874c7a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##280001dd68484901a95e087ad162e6f5] 时间: 2025-04-06 17:33:37,286 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##14a0efa2e71a47d0a66e2b8391f349a4 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 17:33:37,288 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##14a0efa2e71a47d0a66e2b8391f349a4 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 17:33:37,291 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##14a0efa2e71a47d0a66e2b8391f349a4 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 = '退货' 时间: 2025-04-06 17:33:37,322 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##14a0efa2e71a47d0a66e2b8391f349a4 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 17:33:37,324 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##14a0efa2e71a47d0a66e2b8391f349a4 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 17:33:37,327 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3d42f24ac6a142ae80ce694ea7874c7a] (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 [##1c6ddf9e58e9402685ddced6e3f87866] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 17:33:37,336 线程ID: 32 日志级别: 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.[2ecb4901-12a5-4d09-b958-0696d75ee16e] FROM ##3d42f24ac6a142ae80ce694ea7874c7a 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 时间: 2025-04-06 17:33:54,455 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##1bb0ae98334d4587bc3f015c439450e8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 17:33:54,866 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8e48bc7d7dc64cc7b5ac299ed4fb03b4] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 17:33:54,868 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1bb0ae98334d4587bc3f015c439450e8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8e48bc7d7dc64cc7b5ac299ed4fb03b4] 时间: 2025-04-06 17:33:54,925 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6a11d517b1ea4a6cab9b1f8de0c39dc3 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 17:33:54,927 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6a11d517b1ea4a6cab9b1f8de0c39dc3 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 17:33:54,931 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6a11d517b1ea4a6cab9b1f8de0c39dc3 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 = '退货' 时间: 2025-04-06 17:33:54,962 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6a11d517b1ea4a6cab9b1f8de0c39dc3 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 17:33:54,964 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6a11d517b1ea4a6cab9b1f8de0c39dc3 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 17:33:54,967 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1bb0ae98334d4587bc3f015c439450e8] (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 [##2916529b8607478fb28e2aeba8efe1f3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 17:33:54,974 线程ID: 27 日志级别: 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.[2ecb4901-12a5-4d09-b958-0696d75ee16e] FROM ##1bb0ae98334d4587bc3f015c439450e8 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 时间: 2025-04-06 17:41:17,690 线程ID: 18 日志级别: 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 [##92393cbecfdb4e2eae306756e0bdabde] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 17:41:18,089 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##71b8fa211df04929a785e4e5855358b7] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 17:41:18,091 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##92393cbecfdb4e2eae306756e0bdabde] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##71b8fa211df04929a785e4e5855358b7] 时间: 2025-04-06 17:41:18,147 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c55537b15ea44294a11de2c5e1d55190 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 17:41:18,150 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c55537b15ea44294a11de2c5e1d55190 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 17:41:18,154 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c55537b15ea44294a11de2c5e1d55190 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 = '退货' 时间: 2025-04-06 17:41:18,182 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c55537b15ea44294a11de2c5e1d55190 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 17:41:18,183 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c55537b15ea44294a11de2c5e1d55190 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 17:41:18,188 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##92393cbecfdb4e2eae306756e0bdabde] (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 [##be22e7a6d4d64d08bad2a3533789860d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 17:41:18,194 线程ID: 18 日志级别: 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.[439a7ef7-9175-464d-aec6-53f7369dc999] FROM ##92393cbecfdb4e2eae306756e0bdabde 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 时间: 2025-04-06 17:55:29,062 线程ID: 52 日志级别: 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 [##54953dce19f14d8699529a2fb3adc2f9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 17:55:29,492 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##569066f718304fe291e5c6719b8ebaea] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 17:55:29,494 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##54953dce19f14d8699529a2fb3adc2f9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##569066f718304fe291e5c6719b8ebaea] 时间: 2025-04-06 17:55:29,555 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##603a1c54287940f5ae39fae39faa008a a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 17:55:29,557 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##603a1c54287940f5ae39fae39faa008a SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 17:55:29,559 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##603a1c54287940f5ae39fae39faa008a 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 = '退货' 时间: 2025-04-06 17:55:29,587 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##603a1c54287940f5ae39fae39faa008a SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 17:55:29,590 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##603a1c54287940f5ae39fae39faa008a SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 17:55:29,593 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##54953dce19f14d8699529a2fb3adc2f9] (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 [##4d8bedb5b0fe4468b61fc8981f5597f9] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 17:55:29,608 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[d5afe491-9e8a-4362-b750-076ca5134483] FROM ##54953dce19f14d8699529a2fb3adc2f9 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, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2025-04-06 19:34:47,545 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##3c378fe0aa3049cf95b946cd86cd745e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:34:47,993 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3c378fe0aa3049cf95b946cd86cd745e] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a3e22dbc511c4261a52556df20d63437] 时间: 2025-04-06 19:34:48,068 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3c378fe0aa3049cf95b946cd86cd745e] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##b9d58f5847624e68aea83676fd030ec2] 时间: 2025-04-06 19:34:48,117 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3c378fe0aa3049cf95b946cd86cd745e] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##70b7076e3b9f438db4311e9cefc53bb3] 时间: 2025-04-06 19:34:48,201 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3c378fe0aa3049cf95b946cd86cd745e] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##a008cd93f1c84e75b10e7f851b9c7208] 时间: 2025-04-06 19:34:48,208 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##3c378fe0aa3049cf95b946cd86cd745e Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##3c378fe0aa3049cf95b946cd86cd745e] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) 时间: 2025-04-06 19:35:02,424 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##715389e3a4084b1aaec6e337725391dc] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:35:02,832 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##715389e3a4084b1aaec6e337725391dc] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d5dfa7160eb441529107e321dd8aa105] 时间: 2025-04-06 19:35:02,894 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##715389e3a4084b1aaec6e337725391dc] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##4708a6e34a074a8fa32dc48acd6e01ea] 时间: 2025-04-06 19:35:02,944 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##715389e3a4084b1aaec6e337725391dc] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##8ed2f689ad3c4e25882cc52d68801d91] 时间: 2025-04-06 19:35:03,023 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##715389e3a4084b1aaec6e337725391dc] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##c86d2a567c2642f48b8fdc0cb81c62e1] 时间: 2025-04-06 19:35:03,083 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##715389e3a4084b1aaec6e337725391dc] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##e34eea23789849eeab8b8a95067c743b] 时间: 2025-04-06 19:35:03,117 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##715389e3a4084b1aaec6e337725391dc] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##2b3d126702c94b1d8bd162cdfa372d96] 时间: 2025-04-06 19:35:03,120 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##715389e3a4084b1aaec6e337725391dc Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##715389e3a4084b1aaec6e337725391dc] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY GS.Goods_Name, A.Goods_No HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY GS.Goods_Name, A.Goods_No 时间: 2025-04-06 19:35:04,235 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:35:04,652 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##86cfcfa611b54a4ca074a5244c36666b] 时间: 2025-04-06 19:35:04,709 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##d75ad1b38e6d4fb8b47eaa77c336bdee] 时间: 2025-04-06 19:35:04,765 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##124b7d97971d4849b02c25e814c4e24f] 时间: 2025-04-06 19:35:04,849 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##0c946b9043ef48959423343e7bbb013c] 时间: 2025-04-06 19:35:04,909 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##b078382e984e41bbbfc53d1726d519c0] 时间: 2025-04-06 19:35:04,947 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3cffcc37c1ec4dc69cc3eed3932144d2] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##64110f04f8904e5d9aee149795e0f7c0] 时间: 2025-04-06 19:35:04,950 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##3cffcc37c1ec4dc69cc3eed3932144d2 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##3cffcc37c1ec4dc69cc3eed3932144d2] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY GS.Goods_Name, A.Goods_No HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY GS.Goods_Name, A.Goods_No 时间: 2025-04-06 19:35:17,394 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##d078c548136841098b4c9340fb7cb8ea] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:35:17,805 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d078c548136841098b4c9340fb7cb8ea] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8e93d5621a4b42c0a489bffa88f77d5a] 时间: 2025-04-06 19:35:17,861 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d078c548136841098b4c9340fb7cb8ea] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##2730747e1b09401cb04a74602bc7ef2c] 时间: 2025-04-06 19:35:17,913 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d078c548136841098b4c9340fb7cb8ea] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##4fa2c3f9cdb54f2d8e8e423680255f0d] 时间: 2025-04-06 19:35:18,000 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d078c548136841098b4c9340fb7cb8ea] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##b860ce0a60f9419482fe6c2854c3d62d] 时间: 2025-04-06 19:35:18,061 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d078c548136841098b4c9340fb7cb8ea] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##3f09885b87124e78a7bbf6574ac42990] 时间: 2025-04-06 19:35:18,099 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d078c548136841098b4c9340fb7cb8ea] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##86ed40e5d64c4765a58413cae947d43e] 时间: 2025-04-06 19:35:18,103 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##d078c548136841098b4c9340fb7cb8ea Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货], A.Customer_ID AS [渠道编号], SD.Tin_Date AS [到店日期] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##d078c548136841098b4c9340fb7cb8ea] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date 时间: 2025-04-06 19:35:19,126 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##075054e214f44fd8b1e55b8ac7bcc67c] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:35:19,546 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##075054e214f44fd8b1e55b8ac7bcc67c] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6b50d1394977407491a085344b6282e8] 时间: 2025-04-06 19:35:19,602 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##075054e214f44fd8b1e55b8ac7bcc67c] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##7d433011d2714973be01fa0f68bef091] 时间: 2025-04-06 19:35:19,655 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##075054e214f44fd8b1e55b8ac7bcc67c] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##8aa9b8f903364440a4443d05f0da47ea] 时间: 2025-04-06 19:35:19,736 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##075054e214f44fd8b1e55b8ac7bcc67c] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##d318bb64a5d84cc39fc008558940f93e] 时间: 2025-04-06 19:35:19,795 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##075054e214f44fd8b1e55b8ac7bcc67c] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##68b348cc31c742479db91b583dfa1588] 时间: 2025-04-06 19:35:19,833 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##075054e214f44fd8b1e55b8ac7bcc67c] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##f67f8c415b0d4aea8483869125f2e85d] 时间: 2025-04-06 19:35:19,837 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##075054e214f44fd8b1e55b8ac7bcc67c Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货], A.Customer_ID AS [渠道编号], SD.Tin_Date AS [到店日期] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##075054e214f44fd8b1e55b8ac7bcc67c] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date 时间: 2025-04-06 19:35:24,907 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##a9a9f29b4fff433c9b67dacd3b87d624] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:35:26,134 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a9f29b4fff433c9b67dacd3b87d624] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0a70eaa14f3845d790d4f9e4482bc5d3] 时间: 2025-04-06 19:35:26,267 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a9f29b4fff433c9b67dacd3b87d624] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##d4f6249fb2324ce29f13e60f51ab5134] 时间: 2025-04-06 19:35:26,359 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a9f29b4fff433c9b67dacd3b87d624] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##4a5a59bf216a408ca905190c5c4a4235] 时间: 2025-04-06 19:35:26,433 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a9f29b4fff433c9b67dacd3b87d624] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##aada83f50378459d8682aea1d7edac7e] 时间: 2025-04-06 19:35:26,498 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a9f29b4fff433c9b67dacd3b87d624] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##e603d1f5ff6f46098fc544990d5702b5] 时间: 2025-04-06 19:35:26,540 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a9f29b4fff433c9b67dacd3b87d624] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##541b66aa087b41acb1cb2d62acbfdad3] 时间: 2025-04-06 19:35:26,544 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##a9a9f29b4fff433c9b67dacd3b87d624 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货], A.Customer_ID AS [渠道编号], SD.Tin_Date AS [到店日期] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##a9a9f29b4fff433c9b67dacd3b87d624] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date 时间: 2025-04-06 19:38:43,571 线程ID: 62 日志级别: 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 [##2413300acf964dc3ac61b1ee8f1a9b86] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 19:38:43,957 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c7c887aea24f4b0d82aad2476654e633] where 2=2 and ISNULL(S1,0)=0 时间: 2025-04-06 19:38:43,958 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2413300acf964dc3ac61b1ee8f1a9b86] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c7c887aea24f4b0d82aad2476654e633] 时间: 2025-04-06 19:38:44,017 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1bd55faf2a85488ebcfddc68db0b998e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2025-04-06 19:38:44,019 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1bd55faf2a85488ebcfddc68db0b998e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2025-04-06 19:38:44,021 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1bd55faf2a85488ebcfddc68db0b998e 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 = '退货' 时间: 2025-04-06 19:38:44,053 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1bd55faf2a85488ebcfddc68db0b998e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2025-04-06 19:38:44,055 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1bd55faf2a85488ebcfddc68db0b998e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2025-04-06 19:38:44,059 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2413300acf964dc3ac61b1ee8f1a9b86] (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 [##835881c316d5451cb1c354587d21b683] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2025-04-06 19:38:44,064 线程ID: 62 日志级别: 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.[f66251f7-6a6c-42d4-941c-6d8735c69d29] FROM ##2413300acf964dc3ac61b1ee8f1a9b86 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 时间: 2025-04-06 22:39:26,151 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##bc708941488a48a2821a683cbd74bbc5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2025-04-06 22:39:26,608 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc708941488a48a2821a683cbd74bbc5] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4d310b94f0c74a5a8d1a8fbf046753f5] 时间: 2025-04-06 22:39:26,666 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc708941488a48a2821a683cbd74bbc5] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##6ac16396f6dd49b38c4b44f5662be04a] 时间: 2025-04-06 22:39:26,718 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc708941488a48a2821a683cbd74bbc5] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##9f6063aaf84743898194cd499f5df60c] 时间: 2025-04-06 22:39:26,801 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc708941488a48a2821a683cbd74bbc5] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##9a3ca2a9cb5e46c69b45f72419beb39a] 时间: 2025-04-06 22:39:26,858 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc708941488a48a2821a683cbd74bbc5] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##e37f5b9452c94bce9734d10331008695] 时间: 2025-04-06 22:39:26,899 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc708941488a48a2821a683cbd74bbc5] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##6be28981bf9348a1be8ffd92a74acba9] 时间: 2025-04-06 22:39:26,903 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##bc708941488a48a2821a683cbd74bbc5 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, SUM([期初库存#数量]) AS [期初库存], SUM([渠道采购退货#数量]) AS [渠道采购退货], SUM([渠道采购收货#数量]) AS [渠道采购收货], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货], A.Customer_ID AS [渠道编号], SD.Tin_Date AS [到店日期] INTO tempdb.dbo.[f02086ed-8525-4e85-89b3-4f502d39c157] FROM [##bc708941488a48a2821a683cbd74bbc5] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No GROUP BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) ORDER BY GS.Goods_Name, A.Goods_No, A.Customer_ID, SD.Tin_Date