时间: 2023-03-11 10:25:59,061 线程ID: 28 日志级别: 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 [##5b022df603f642dbae9dde2049eec730] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:25:59,498 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##d131badba9974c449a937b01e51d9e2c] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:25:59,501 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5b022df603f642dbae9dde2049eec730] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d131badba9974c449a937b01e51d9e2c] 时间: 2023-03-11 10:25:59,566 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##04b08fba1f6f46c5ba0bb97d1a086b20 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:25:59,568 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##04b08fba1f6f46c5ba0bb97d1a086b20 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:25:59,569 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##04b08fba1f6f46c5ba0bb97d1a086b20 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:25:59,596 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##04b08fba1f6f46c5ba0bb97d1a086b20 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:25:59,599 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##04b08fba1f6f46c5ba0bb97d1a086b20 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:25:59,602 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5b022df603f642dbae9dde2049eec730] (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 [##2b1afea7fc4c4acea09266a1f3aebfc9] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:25:59,615 线程ID: 28 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##5b022df603f642dbae9dde2049eec730 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:26:06,004 线程ID: 17 日志级别: 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 [##cf36a831098e40fca8e2d3012c54f1b7] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:26:06,435 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##967a8162c55f4b31945548ce490515e6] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:26:06,437 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cf36a831098e40fca8e2d3012c54f1b7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##967a8162c55f4b31945548ce490515e6] 时间: 2023-03-11 10:26:06,500 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8a7a7040c6e040abba690df1540f753c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:26:06,502 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8a7a7040c6e040abba690df1540f753c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:26:06,503 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8a7a7040c6e040abba690df1540f753c a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:26:06,531 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8a7a7040c6e040abba690df1540f753c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:26:06,532 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8a7a7040c6e040abba690df1540f753c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:26:06,536 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cf36a831098e40fca8e2d3012c54f1b7] (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 [##c3761cc306ed432caef418e5d86764f5] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:26:06,539 线程ID: 17 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##cf36a831098e40fca8e2d3012c54f1b7 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:26:08,113 线程ID: 37 日志级别: 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 [##a33475d7819a465db72f3f318b9931dc] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:26:08,517 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0c63d7884bb34eb783f0c71db5f5a4c0] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:26:08,517 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a33475d7819a465db72f3f318b9931dc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0c63d7884bb34eb783f0c71db5f5a4c0] 时间: 2023-03-11 10:26:08,582 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6288821368604581b62487857484b909 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:26:08,585 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6288821368604581b62487857484b909 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:26:08,586 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6288821368604581b62487857484b909 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:26:08,613 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6288821368604581b62487857484b909 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:26:08,615 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6288821368604581b62487857484b909 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:26:08,619 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a33475d7819a465db72f3f318b9931dc] (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 [##6d678ee33606493b9199d79621e05c69] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:26:08,622 线程ID: 37 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##a33475d7819a465db72f3f318b9931dc A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:26:10,248 线程ID: 31 日志级别: 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 [##e6c3de2e9ca7427fbc20cf13fbc6228d] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:26:10,675 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f372cdeaeb344bfaa2223ba0c2608861] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:26:10,677 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e6c3de2e9ca7427fbc20cf13fbc6228d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f372cdeaeb344bfaa2223ba0c2608861] 时间: 2023-03-11 10:26:10,743 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##25464b585f634db59f926aebf35ad47e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:26:10,745 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##25464b585f634db59f926aebf35ad47e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:26:10,747 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##25464b585f634db59f926aebf35ad47e a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:26:10,776 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##25464b585f634db59f926aebf35ad47e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:26:10,777 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##25464b585f634db59f926aebf35ad47e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:26:10,780 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e6c3de2e9ca7427fbc20cf13fbc6228d] (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 [##79e6064e88d54e32a3a67212c3b2b313] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:26:10,783 线程ID: 31 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##e6c3de2e9ca7427fbc20cf13fbc6228d A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:26:12,467 线程ID: 73 日志级别: 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 [##36ddddc6b476495cba1c69fade11be2f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:26:12,855 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8d972e1640aa4551b05b8a7b6edcdeed] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:26:12,857 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##36ddddc6b476495cba1c69fade11be2f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8d972e1640aa4551b05b8a7b6edcdeed] 时间: 2023-03-11 10:26:12,920 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1535119fe7b647cd9d10ba81da29b176 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:26:12,923 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1535119fe7b647cd9d10ba81da29b176 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:26:12,924 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1535119fe7b647cd9d10ba81da29b176 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:26:12,951 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1535119fe7b647cd9d10ba81da29b176 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:26:12,953 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1535119fe7b647cd9d10ba81da29b176 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:26:12,956 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##36ddddc6b476495cba1c69fade11be2f] (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 [##3c02c37a43de43d8ac68aff3ff2e8303] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:26:12,959 线程ID: 73 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##36ddddc6b476495cba1c69fade11be2f A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:26:42,789 线程ID: 36 日志级别: 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 [##5de9242de6374bdf9899958f8151013c] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:26:43,195 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##bfcb64d20cba4ac48f9dc355fadf10a4] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:26:43,197 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5de9242de6374bdf9899958f8151013c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bfcb64d20cba4ac48f9dc355fadf10a4] 时间: 2023-03-11 10:26:43,261 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##05630abbe08b409d9ae3da7d4fd0d0e0 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:26:43,263 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##05630abbe08b409d9ae3da7d4fd0d0e0 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:26:43,265 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##05630abbe08b409d9ae3da7d4fd0d0e0 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:26:43,291 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##05630abbe08b409d9ae3da7d4fd0d0e0 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:26:43,292 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##05630abbe08b409d9ae3da7d4fd0d0e0 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:26:43,296 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5de9242de6374bdf9899958f8151013c] (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 [##e00b8195406742a6815f27dedf907bff] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:26:43,299 线程ID: 36 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##5de9242de6374bdf9899958f8151013c A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:39:27,590 线程ID: 19 日志级别: 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 [##d0cb7a00fb7b45aba3069ab6cece8340] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:39:28,007 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ba0273706c3045a5a7cc4dc5d51d93e8] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:39:28,009 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d0cb7a00fb7b45aba3069ab6cece8340] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ba0273706c3045a5a7cc4dc5d51d93e8] 时间: 2023-03-11 10:39:28,079 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##bf099f89ee8c47c4b3438047c4ecf2fb a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:39:28,081 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bf099f89ee8c47c4b3438047c4ecf2fb SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:39:28,082 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##bf099f89ee8c47c4b3438047c4ecf2fb a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:39:28,111 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bf099f89ee8c47c4b3438047c4ecf2fb SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:39:28,113 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bf099f89ee8c47c4b3438047c4ecf2fb SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:39:28,116 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d0cb7a00fb7b45aba3069ab6cece8340] (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 [##7dafed7b1353496a84793e4d72a6e31e] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:39:28,119 线程ID: 19 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##d0cb7a00fb7b45aba3069ab6cece8340 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:39:31,911 线程ID: 11 日志级别: 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 [##fd89a12037354213b459be0ab0abcdff] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 10:39:32,706 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2dff03fde6b142978b4f45b625415980] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 10:39:32,714 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fd89a12037354213b459be0ab0abcdff] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2dff03fde6b142978b4f45b625415980] 时间: 2023-03-11 10:39:32,789 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##dd3e15b36fc24962b528d7cafa71268b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-03-11 10:39:32,798 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dd3e15b36fc24962b528d7cafa71268b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-03-11 10:39:32,803 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##dd3e15b36fc24962b528d7cafa71268b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2023-03-11 10:39:32,842 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dd3e15b36fc24962b528d7cafa71268b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-03-11 10:39:32,844 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dd3e15b36fc24962b528d7cafa71268b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-03-11 10:39:32,851 线程ID: 11 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fd89a12037354213b459be0ab0abcdff] (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 [##e9a2b8c79ed044abaa72bb0fe8b4fb06] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-03-11 10:39:32,861 线程ID: 11 日志级别: 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.[aeff9957-1657-4d9c-af39-55444c2ee12f] FROM ##fd89a12037354213b459be0ab0abcdff A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-03-11 10:49:24,642 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##92ce9a267e9d46728aa1c58eae765dbe] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 10:49:24,651 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##92ce9a267e9d46728aa1c58eae765dbe] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##92ce9a267e9d46728aa1c58eae765dbe] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 10:49:24,659 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##92ce9a267e9d46728aa1c58eae765dbe] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 10:49:24,666 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##92ce9a267e9d46728aa1c58eae765dbe] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 10:49:24,674 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##92ce9a267e9d46728aa1c58eae765dbe A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##92ce9a267e9d46728aa1c58eae765dbe WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##dfcf6f37bf1f451f85afdc1d30da5249] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 10:49:24,758 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##92ce9a267e9d46728aa1c58eae765dbe A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##92ce9a267e9d46728aa1c58eae765dbe WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##dfcf6f37bf1f451f85afdc1d30da5249] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 10:49:24,855 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##92ce9a267e9d46728aa1c58eae765dbe A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##92ce9a267e9d46728aa1c58eae765dbe WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##dfcf6f37bf1f451f85afdc1d30da5249] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:49:24,994 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##92ce9a267e9d46728aa1c58eae765dbe A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##92ce9a267e9d46728aa1c58eae765dbe WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##dfcf6f37bf1f451f85afdc1d30da5249] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:49:25,355 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##92ce9a267e9d46728aa1c58eae765dbe A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##92ce9a267e9d46728aa1c58eae765dbe C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##dfcf6f37bf1f451f85afdc1d30da5249] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:49:25,659 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##92ce9a267e9d46728aa1c58eae765dbe SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 10:49:25,662 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##92ce9a267e9d46728aa1c58eae765dbe] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##92ce9a267e9d46728aa1c58eae765dbe] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:49:25,698 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[49f30a26-0ba3-48ca-b2e7-5d8fa45a5c86] FROM [##92ce9a267e9d46728aa1c58eae765dbe] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 10:57:03,107 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d9b5e70a5b40408bb2820e169f3b2be5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 10:57:03,114 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d9b5e70a5b40408bb2820e169f3b2be5] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##d9b5e70a5b40408bb2820e169f3b2be5] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 10:57:03,120 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##d9b5e70a5b40408bb2820e169f3b2be5] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 10:57:03,127 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##d9b5e70a5b40408bb2820e169f3b2be5] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 10:57:03,136 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##d9b5e70a5b40408bb2820e169f3b2be5 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##d9b5e70a5b40408bb2820e169f3b2be5 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##ae538022ff7d41ea94b43d7ae3409e85] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 10:57:03,217 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##d9b5e70a5b40408bb2820e169f3b2be5 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##d9b5e70a5b40408bb2820e169f3b2be5 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##ae538022ff7d41ea94b43d7ae3409e85] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 10:57:03,301 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##d9b5e70a5b40408bb2820e169f3b2be5 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##d9b5e70a5b40408bb2820e169f3b2be5 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##ae538022ff7d41ea94b43d7ae3409e85] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:57:03,434 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##d9b5e70a5b40408bb2820e169f3b2be5 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##d9b5e70a5b40408bb2820e169f3b2be5 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##ae538022ff7d41ea94b43d7ae3409e85] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:57:03,785 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##d9b5e70a5b40408bb2820e169f3b2be5 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##d9b5e70a5b40408bb2820e169f3b2be5 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##ae538022ff7d41ea94b43d7ae3409e85] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:57:04,072 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d9b5e70a5b40408bb2820e169f3b2be5 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 10:57:04,074 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##d9b5e70a5b40408bb2820e169f3b2be5] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##d9b5e70a5b40408bb2820e169f3b2be5] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 10:57:04,111 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[8d333844-a750-4d67-9804-4b7f6c769f53] FROM [##d9b5e70a5b40408bb2820e169f3b2be5] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 11:09:51,134 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##857efb9cf8ea4c6294d29d40a4888352 FROM CheckGoods b,CheckDetail c 时间: 2023-03-11 11:09:51,137 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##857efb9cf8ea4c6294d29d40a4888352 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##9772e26194224a43a5291801fc994a5c WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##806278a2bc1047de9a4bcd75d6abfa47 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2023-02-11' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:09:51,191 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##857efb9cf8ea4c6294d29d40a4888352 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##9772e26194224a43a5291801fc994a5c WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##806278a2bc1047de9a4bcd75d6abfa47 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2023-02-11' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:09:51,237 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[01bde791-e57c-4610-83a8-24a6f884b3b7] FROM ##857efb9cf8ea4c6294d29d40a4888352 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-11 11:10:15,239 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##da05a8fc76f143828415aa0c227a94f3 FROM CheckGoods b,CheckDetail c 时间: 2023-03-11 11:10:15,241 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##da05a8fc76f143828415aa0c227a94f3 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##d8dfb21a12fa4f579c6d295acbf3c17b WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##73dded09aaf441d8853e21cef4a2e611 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2022-10-01' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:10:15,316 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##da05a8fc76f143828415aa0c227a94f3 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##d8dfb21a12fa4f579c6d295acbf3c17b WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##73dded09aaf441d8853e21cef4a2e611 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2022-10-01' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:10:15,358 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[01bde791-e57c-4610-83a8-24a6f884b3b7] FROM ##da05a8fc76f143828415aa0c227a94f3 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-11 11:10:18,066 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##281c3b8051d14db6aeb70f951349e361 FROM CheckGoods b,CheckDetail c 时间: 2023-03-11 11:10:18,069 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##281c3b8051d14db6aeb70f951349e361 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##d35ff5eb191a4e829e7a94a757a9167b WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##8b41831a69de48729f2db29a20f0de08 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2022-10-01' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:10:18,141 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##281c3b8051d14db6aeb70f951349e361 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##d35ff5eb191a4e829e7a94a757a9167b WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##8b41831a69de48729f2db29a20f0de08 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2022-10-01' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:10:18,183 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[01bde791-e57c-4610-83a8-24a6f884b3b7] FROM ##281c3b8051d14db6aeb70f951349e361 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-11 11:10:30,124 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 B.Goods_No, C.ColorID, C.Long , B.Quantity AS 自营#数量, B.DiscountPrice*B.Quantity AS 自营#生意额 , B.Quantity AS 加盟#数量, B.DiscountPrice*B.Quantity AS 加盟#生意额 , B.Quantity AS 合计#数量, B.DiscountPrice*B.Quantity AS 合计#生意额 INTO ##bbcdeec056874dd6b078056f2d7e11c5 FROM CheckGoods b,CheckDetail c 时间: 2023-03-11 11:10:30,126 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##bbcdeec056874dd6b078056f2d7e11c5 (Goods_No, ColorID, Long, 自营#数量, 自营#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [Check] A INNER JOIN CheckGoods B ON A.CheckID=B.CheckID INNER JOIN CheckDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##ca48fd68e23346c78a9387ad508b9b81 WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##2199335bcb36459d8305d8e5af928778 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:10:30,229 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##bbcdeec056874dd6b078056f2d7e11c5 (Goods_No, ColorID, Long, 加盟#数量, 加盟#生意额, 合计#数量, 合计#生意额) SELECT B.Goods_No, C.ColorID, C.Long , SUM(ISNULL(C.[S1], 0)) AS Quantity, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS Amount , SUM(ISNULL(C.[S1], 0)) AS TotalQty, SUM((ISNULL(C.[S1], 0))*B.DiscountPrice) AS TotalAmt FROM [CheckL] A INNER JOIN CheckLGoods B ON A.CheckID=B.CheckID INNER JOIN CheckLDetail C ON B.CheckGoodsID=C.CheckGoodsID WHERE A.Posted=1 AND ISNULL(A.RetailOrderID,'') = '' AND EXISTS (SELECT 1 FROM ##ca48fd68e23346c78a9387ad508b9b81 WHERE Customer_ID=A.Customer_ID) AND EXISTS (SELECT 1 FROM ##2199335bcb36459d8305d8e5af928778 WHERE Goods_No=B.Goods_No) AND A.CheckDate >= '2021-09-01' AND A.CheckDate <= '2023-03-11' GROUP BY B.Goods_No, C.ColorID, C.Long 时间: 2023-03-11 11:10:30,270 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], A.Long AS [内长], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] , SUM(自营#数量) AS 自营#数量, SUM(自营#生意额) AS 自营#生意额 , SUM(加盟#数量) AS 加盟#数量, SUM(加盟#生意额) AS 加盟#生意额 , SUM(合计#数量) AS 合计#数量, SUM(合计#生意额) AS 合计#生意额 INTO tempdb.dbo.[01bde791-e57c-4610-83a8-24a6f884b3b7] FROM ##bbcdeec056874dd6b078056f2d7e11c5 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID GROUP BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, A.Long, GS.UnitPrice, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2023-03-11 13:45:27,598 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##61be2de721e9425c853dec5e063e903c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 13:45:27,605 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##61be2de721e9425c853dec5e063e903c] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##61be2de721e9425c853dec5e063e903c] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 13:45:27,611 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##61be2de721e9425c853dec5e063e903c] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:45:27,618 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##61be2de721e9425c853dec5e063e903c] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:45:27,626 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##61be2de721e9425c853dec5e063e903c A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##61be2de721e9425c853dec5e063e903c WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##2afe649e689e4edaa5f960d6fe81aa0d] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 13:45:27,701 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##61be2de721e9425c853dec5e063e903c A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##61be2de721e9425c853dec5e063e903c WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##2afe649e689e4edaa5f960d6fe81aa0d] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 13:45:27,777 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##61be2de721e9425c853dec5e063e903c A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##61be2de721e9425c853dec5e063e903c WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##2afe649e689e4edaa5f960d6fe81aa0d] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:45:27,905 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##61be2de721e9425c853dec5e063e903c A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##61be2de721e9425c853dec5e063e903c WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##2afe649e689e4edaa5f960d6fe81aa0d] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:45:28,240 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##61be2de721e9425c853dec5e063e903c A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##61be2de721e9425c853dec5e063e903c C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##2afe649e689e4edaa5f960d6fe81aa0d] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:45:28,518 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61be2de721e9425c853dec5e063e903c SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 13:45:28,519 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##61be2de721e9425c853dec5e063e903c] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##61be2de721e9425c853dec5e063e903c] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:45:28,558 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[f8c38b6f-dde8-469e-a63c-c54ad0f0f4d6] FROM [##61be2de721e9425c853dec5e063e903c] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 13:56:57,522 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##df69e1cf5d4743c4b5e6402ac40db834] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 13:56:57,528 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##df69e1cf5d4743c4b5e6402ac40db834] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##df69e1cf5d4743c4b5e6402ac40db834] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 13:56:57,534 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##df69e1cf5d4743c4b5e6402ac40db834] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:56:57,538 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##df69e1cf5d4743c4b5e6402ac40db834] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:56:57,541 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##df69e1cf5d4743c4b5e6402ac40db834 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##df69e1cf5d4743c4b5e6402ac40db834 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##e61f7af693924d5f8eb64dba1aa9b6d0] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 13:56:57,599 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##df69e1cf5d4743c4b5e6402ac40db834 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##df69e1cf5d4743c4b5e6402ac40db834 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##e61f7af693924d5f8eb64dba1aa9b6d0] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 13:56:57,657 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##df69e1cf5d4743c4b5e6402ac40db834 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##df69e1cf5d4743c4b5e6402ac40db834 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##e61f7af693924d5f8eb64dba1aa9b6d0] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:56:57,794 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##df69e1cf5d4743c4b5e6402ac40db834 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##df69e1cf5d4743c4b5e6402ac40db834 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##e61f7af693924d5f8eb64dba1aa9b6d0] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:56:58,324 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##df69e1cf5d4743c4b5e6402ac40db834 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##df69e1cf5d4743c4b5e6402ac40db834 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##e61f7af693924d5f8eb64dba1aa9b6d0] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:56:58,719 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##df69e1cf5d4743c4b5e6402ac40db834 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 13:56:58,721 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##df69e1cf5d4743c4b5e6402ac40db834] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##df69e1cf5d4743c4b5e6402ac40db834] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:56:58,758 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[3806bb32-6541-4d4a-845d-1adc97b3f747] FROM [##df69e1cf5d4743c4b5e6402ac40db834] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 13:56:59,430 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##be56e80208d74208ae89ce84b46c7856] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 13:56:59,435 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##be56e80208d74208ae89ce84b46c7856] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##be56e80208d74208ae89ce84b46c7856] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 13:56:59,441 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##be56e80208d74208ae89ce84b46c7856] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:56:59,445 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##be56e80208d74208ae89ce84b46c7856] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:56:59,449 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##be56e80208d74208ae89ce84b46c7856 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##be56e80208d74208ae89ce84b46c7856 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##c585c0cf65b5454ca667d8db1ea61a34] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 13:56:59,508 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##be56e80208d74208ae89ce84b46c7856 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##be56e80208d74208ae89ce84b46c7856 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##c585c0cf65b5454ca667d8db1ea61a34] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 13:56:59,566 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##be56e80208d74208ae89ce84b46c7856 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##be56e80208d74208ae89ce84b46c7856 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##c585c0cf65b5454ca667d8db1ea61a34] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:56:59,700 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##be56e80208d74208ae89ce84b46c7856 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##be56e80208d74208ae89ce84b46c7856 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##c585c0cf65b5454ca667d8db1ea61a34] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:57:00,208 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##be56e80208d74208ae89ce84b46c7856 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##be56e80208d74208ae89ce84b46c7856 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##c585c0cf65b5454ca667d8db1ea61a34] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:57:00,598 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##be56e80208d74208ae89ce84b46c7856 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 13:57:00,599 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##be56e80208d74208ae89ce84b46c7856] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##be56e80208d74208ae89ce84b46c7856] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:57:00,638 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[7a774fc5-ad23-42a8-bc53-e979dde568b5] FROM [##be56e80208d74208ae89ce84b46c7856] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 13:59:32,791 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##2546a0369ef846a3aa034bb36a9ec90d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 13:59:32,798 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##2546a0369ef846a3aa034bb36a9ec90d] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##2546a0369ef846a3aa034bb36a9ec90d] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 13:59:32,805 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##2546a0369ef846a3aa034bb36a9ec90d] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:59:32,812 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##2546a0369ef846a3aa034bb36a9ec90d] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:59:32,822 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##2546a0369ef846a3aa034bb36a9ec90d A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##2546a0369ef846a3aa034bb36a9ec90d WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##f2f39e012147435f8ccd06b40c4d9cff] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 13:59:32,905 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##2546a0369ef846a3aa034bb36a9ec90d A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##2546a0369ef846a3aa034bb36a9ec90d WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##f2f39e012147435f8ccd06b40c4d9cff] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 13:59:32,990 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##2546a0369ef846a3aa034bb36a9ec90d A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##2546a0369ef846a3aa034bb36a9ec90d WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##f2f39e012147435f8ccd06b40c4d9cff] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:33,133 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##2546a0369ef846a3aa034bb36a9ec90d A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##2546a0369ef846a3aa034bb36a9ec90d WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##f2f39e012147435f8ccd06b40c4d9cff] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:33,497 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##2546a0369ef846a3aa034bb36a9ec90d A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##2546a0369ef846a3aa034bb36a9ec90d C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##f2f39e012147435f8ccd06b40c4d9cff] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:33,790 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2546a0369ef846a3aa034bb36a9ec90d SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 13:59:33,792 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##2546a0369ef846a3aa034bb36a9ec90d] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##2546a0369ef846a3aa034bb36a9ec90d] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:33,830 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[495d3038-f01d-4ef5-9fad-e5d3176aefee] FROM [##2546a0369ef846a3aa034bb36a9ec90d] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 13:59:36,329 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##dd8152969a9140b4a5417405408f2527] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-03-11 13:59:36,337 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##dd8152969a9140b4a5417405408f2527] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##dd8152969a9140b4a5417405408f2527] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-03-11 13:59:36,344 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##dd8152969a9140b4a5417405408f2527] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:59:36,352 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##dd8152969a9140b4a5417405408f2527] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-03-11 13:59:36,360 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##dd8152969a9140b4a5417405408f2527 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##dd8152969a9140b4a5417405408f2527 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##445fe87e0e36470db2b70df088e771f4] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-03-11 13:59:36,442 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##dd8152969a9140b4a5417405408f2527 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##dd8152969a9140b4a5417405408f2527 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##445fe87e0e36470db2b70df088e771f4] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-03-11 13:59:36,524 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##dd8152969a9140b4a5417405408f2527 A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##dd8152969a9140b4a5417405408f2527 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##445fe87e0e36470db2b70df088e771f4] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:36,663 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##dd8152969a9140b4a5417405408f2527 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##dd8152969a9140b4a5417405408f2527 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##445fe87e0e36470db2b70df088e771f4] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:37,028 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##dd8152969a9140b4a5417405408f2527 A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##dd8152969a9140b4a5417405408f2527 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##445fe87e0e36470db2b70df088e771f4] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:37,324 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dd8152969a9140b4a5417405408f2527 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-03-11 13:59:37,326 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##dd8152969a9140b4a5417405408f2527] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##dd8152969a9140b4a5417405408f2527] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-03-11 13:59:37,365 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[495d3038-f01d-4ef5-9fad-e5d3176aefee] FROM [##dd8152969a9140b4a5417405408f2527] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-03-11 13:59:44,323 线程ID: 87 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[845457ff-18bd-4e6b-b993-6a8dbd21a1d8] FROM Customer A INNER JOIN [##365a3eb9cbf647f7a6d81781e09031c4] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2023-03-11 13:59:51,712 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[fbb5525f-8ad8-46f3-861f-dabdc7eddef2] FROM Customer A INNER JOIN [##6629fd58e69d4122aa27977dd56b1681] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2023-03-11 14:14:54,830 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[61ef4b78-555b-42ec-b820-76cc88492628] FROM [##f87aa4fcf8984db6b62b8891677b0a73] ORDER BY Goods_no 时间: 2023-03-11 14:15:47,104 线程ID: 53 日志级别: 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 [##9f9f1e7b6df14eccb2bf2f8f8f1bf7fc] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 14:15:47,503 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##df920505d6ca41268636a8168bb6727e] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 14:15:47,504 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9f9f1e7b6df14eccb2bf2f8f8f1bf7fc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##df920505d6ca41268636a8168bb6727e] 时间: 2023-03-11 14:15:47,506 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[c1a4c8fa-68c5-4526-8c4d-03e90f89f25b] FROM ##9f9f1e7b6df14eccb2bf2f8f8f1bf7fc A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2023-03-11 14:17:00,937 线程ID: 19 日志级别: 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 [##9f2f7293a45b451ba5e5bd5208f7c13a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 14:17:01,321 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7b773d0df4734357bfcbb15bc94706b2] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 14:17:01,323 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9f2f7293a45b451ba5e5bd5208f7c13a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7b773d0df4734357bfcbb15bc94706b2] 时间: 2023-03-11 14:17:01,324 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[c1a4c8fa-68c5-4526-8c4d-03e90f89f25b] FROM ##9f2f7293a45b451ba5e5bd5208f7c13a A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2023-03-11 14:18:55,161 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##d3ff372ca9b44744a94ff1b7f5cc63c5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 14:18:55,569 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5da81a6c83e740a7bdda782fa48d2938] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 14:18:55,571 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d3ff372ca9b44744a94ff1b7f5cc63c5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5da81a6c83e740a7bdda782fa48d2938] 时间: 2023-03-11 14:18:55,573 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[c1a4c8fa-68c5-4526-8c4d-03e90f89f25b] FROM ##d3ff372ca9b44744a94ff1b7f5cc63c5 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 时间: 2023-03-11 14:28:41,041 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a44903f5d50a413fa52f9964a0f4382a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2023-03-11 14:28:41,047 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##a44903f5d50a413fa52f9964a0f4382a] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##a44903f5d50a413fa52f9964a0f4382a WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##4ee313dfac7b4503a704537822728aad] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2023-03-11 14:28:41,392 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[80b554f9-0617-45bf-8930-86830b27e4d5] FROM [##a44903f5d50a413fa52f9964a0f4382a] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2023-03-11 14:28:51,046 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[bdae33b0-e263-4190-aafb-19f5c7cea7d7] FROM Customer A INNER JOIN [##57ffbf2059d34be6910fdbeac9ac808c] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2023-03-11 14:33:58,752 线程ID: 91 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[61ef4b78-555b-42ec-b820-76cc88492628] FROM [##ffbba1c53d574262936c6a6c61444f42] ORDER BY Goods_no 时间: 2023-03-11 14:34:12,022 线程ID: 93 日志级别: 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 [##98994633037a4f688b5531367da2bab7] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-03-11 14:34:12,404 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fea88dd01b9e4eb89a6489db30154d2e] where 2=2 and ISNULL(S1,0)=0 时间: 2023-03-11 14:34:12,405 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##98994633037a4f688b5531367da2bab7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fea88dd01b9e4eb89a6489db30154d2e] 时间: 2023-03-11 14:34:12,407 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[c1a4c8fa-68c5-4526-8c4d-03e90f89f25b] FROM ##98994633037a4f688b5531367da2bab7 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No