时间: 2024-01-23 10:04:36,380 线程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 [##342d22cdb6f1477b9b4c792ae2f49c32] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 10:04:36,813 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##26567c16e20049678f30921de943070e] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 10:04:36,817 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##342d22cdb6f1477b9b4c792ae2f49c32] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##26567c16e20049678f30921de943070e] 时间: 2024-01-23 10:04:36,878 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eaabe627201c4a8a8ea0942711d28dab a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 10:04:36,881 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eaabe627201c4a8a8ea0942711d28dab SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 10:04:36,883 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eaabe627201c4a8a8ea0942711d28dab 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 = '退货' 时间: 2024-01-23 10:04:36,915 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eaabe627201c4a8a8ea0942711d28dab SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 10:04:36,917 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eaabe627201c4a8a8ea0942711d28dab SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 10:04:36,922 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##342d22cdb6f1477b9b4c792ae2f49c32] (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 [##6c012257813d42ef9bd81c412f5b24c8] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 10:04:36,937 线程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 [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[b6c3ef32-a50e-461d-a896-2de52c1de090] FROM ##342d22cdb6f1477b9b4c792ae2f49c32 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 10:18:43,106 线程ID: 29 日志级别: 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 [##ebb8493391ae434ab572fd08822be9f8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 10:18:43,579 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a948af46d5b0492aa332e1e6472a7227] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 10:18:43,581 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ebb8493391ae434ab572fd08822be9f8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a948af46d5b0492aa332e1e6472a7227] 时间: 2024-01-23 10:18:43,641 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1d2f30910f0741e386bae2887f73266b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 10:18:43,644 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1d2f30910f0741e386bae2887f73266b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 10:18:43,649 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1d2f30910f0741e386bae2887f73266b 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 = '退货' 时间: 2024-01-23 10:18:43,686 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1d2f30910f0741e386bae2887f73266b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 10:18:43,688 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1d2f30910f0741e386bae2887f73266b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 10:18:43,692 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ebb8493391ae434ab572fd08822be9f8] (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 [##974d9a2a1c7b4b69b4349e1abd664d48] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 10:18:43,698 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[b6c3ef32-a50e-461d-a896-2de52c1de090] FROM ##ebb8493391ae434ab572fd08822be9f8 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 10:24:05,081 线程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 [##af3b3881e0424f6494e3778c4df396b5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 10:24:05,496 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a7e807134ece43178eb532e4858b774f] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 10:24:05,498 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##af3b3881e0424f6494e3778c4df396b5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a7e807134ece43178eb532e4858b774f] 时间: 2024-01-23 10:24:05,552 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##52ecee44f45d459199eef7ebbd9bdb58 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 10:24:05,554 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##52ecee44f45d459199eef7ebbd9bdb58 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 10:24:05,556 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##52ecee44f45d459199eef7ebbd9bdb58 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 = '退货' 时间: 2024-01-23 10:24:05,588 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##52ecee44f45d459199eef7ebbd9bdb58 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 10:24:05,590 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##52ecee44f45d459199eef7ebbd9bdb58 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 10:24:05,593 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##af3b3881e0424f6494e3778c4df396b5] (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 [##1bbfcf2ed5d7437fb3e11d5bcb50c8d8] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 10:24:05,597 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[6e0ac4a1-1955-4341-97c7-63bef0c31496] FROM ##af3b3881e0424f6494e3778c4df396b5 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 10:26:53,870 线程ID: 14 日志级别: 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 [##2d0d3480aac74240af843467735b2a65] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 10:26:54,278 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##024581500e9149f8ba4176ea74ea2912] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 10:26:54,280 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2d0d3480aac74240af843467735b2a65] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##024581500e9149f8ba4176ea74ea2912] 时间: 2024-01-23 10:26:54,334 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ec1168fcab654b23bfdd020221f11b71 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 10:26:54,339 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ec1168fcab654b23bfdd020221f11b71 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 10:26:54,340 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ec1168fcab654b23bfdd020221f11b71 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 = '退货' 时间: 2024-01-23 10:26:54,368 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ec1168fcab654b23bfdd020221f11b71 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 10:26:54,370 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ec1168fcab654b23bfdd020221f11b71 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 10:26:54,372 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2d0d3480aac74240af843467735b2a65] (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 [##fe00b17a90d742e2b23b73eb940db21d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 10:26:54,376 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[b6c3ef32-a50e-461d-a896-2de52c1de090] FROM ##2d0d3480aac74240af843467735b2a65 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 10:38:30,558 线程ID: 16 日志级别: 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 [##96abe9192ef3434d8486f043b2e09837] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 10:38:30,951 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##326021fa8b8549a782d16182311db0f3] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 10:38:30,954 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##96abe9192ef3434d8486f043b2e09837] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##326021fa8b8549a782d16182311db0f3] 时间: 2024-01-23 10:38:31,007 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cbb0c3cd2dce423395813a4afbdc3afe a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 10:38:31,009 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cbb0c3cd2dce423395813a4afbdc3afe SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 10:38:31,011 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cbb0c3cd2dce423395813a4afbdc3afe 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 = '退货' 时间: 2024-01-23 10:38:31,042 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cbb0c3cd2dce423395813a4afbdc3afe SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 10:38:31,043 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cbb0c3cd2dce423395813a4afbdc3afe SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 10:38:31,047 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##96abe9192ef3434d8486f043b2e09837] (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 [##b477f67805e64f9f91fede3ee1ad5c42] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 10:38:31,051 线程ID: 16 日志级别: 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.[30457255-bb9a-40d8-bb2b-ac955789d877] FROM ##96abe9192ef3434d8486f043b2e09837 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 时间: 2024-01-23 11:06:15,752 线程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 [##bc24a3a74bfc4c89b979daf326514c7f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 11:06:16,165 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9538ee28d4894d228c43b6a57e1ddf2a] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 11:06:16,167 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc24a3a74bfc4c89b979daf326514c7f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9538ee28d4894d228c43b6a57e1ddf2a] 时间: 2024-01-23 11:06:16,219 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cd3a7fa0ade14a2d9dd8d84bc4e54020 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 11:06:16,221 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cd3a7fa0ade14a2d9dd8d84bc4e54020 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 11:06:16,223 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cd3a7fa0ade14a2d9dd8d84bc4e54020 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 = '退货' 时间: 2024-01-23 11:06:16,251 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cd3a7fa0ade14a2d9dd8d84bc4e54020 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 11:06:16,253 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cd3a7fa0ade14a2d9dd8d84bc4e54020 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 11:06:16,256 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc24a3a74bfc4c89b979daf326514c7f] (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 [##a8d5bb21eebc49ed8211250acec7b490] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 11:06:16,261 线程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.[30457255-bb9a-40d8-bb2b-ac955789d877] FROM ##bc24a3a74bfc4c89b979daf326514c7f 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 时间: 2024-01-23 11:06:41,341 线程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 [##a6aeea113c8b439888280015b6109434] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 11:06:41,745 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4952f1c3fe584bc8a91b9074f9e64a8f] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 11:06:41,747 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a6aeea113c8b439888280015b6109434] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4952f1c3fe584bc8a91b9074f9e64a8f] 时间: 2024-01-23 11:06:41,814 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6220f20282244db9bf733ad45317c3af a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 11:06:41,814 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6220f20282244db9bf733ad45317c3af SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 11:06:41,814 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6220f20282244db9bf733ad45317c3af 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 = '退货' 时间: 2024-01-23 11:06:41,853 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6220f20282244db9bf733ad45317c3af SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 11:06:41,855 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6220f20282244db9bf733ad45317c3af SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 11:06:41,860 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a6aeea113c8b439888280015b6109434] (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 [##a00012238d67405bb0f6cb5ca6c8262f] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 11:06:41,864 线程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.[30457255-bb9a-40d8-bb2b-ac955789d877] FROM ##a6aeea113c8b439888280015b6109434 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 时间: 2024-01-23 13:02:29,734 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 Vip,CAST(0 AS INT) [合计#消费数],CAST(0 AS DECIMAL(18,2)) [合计#消费额],CAST(0 AS DECIMAL(18,2)) [合计#积分],CAST(0 AS DECIMAL(18,2)) 当前积分 ,CAST(0 AS INT) [1月#消费数],CAST(0 AS DECIMAL(18,2)) [1月#消费额],CAST(0 AS DECIMAL(18,2)) [1月#积分] ,CAST(0 AS INT) [2月#消费数],CAST(0 AS DECIMAL(18,2)) [2月#消费额],CAST(0 AS DECIMAL(18,2)) [2月#积分] ,CAST(0 AS INT) [3月#消费数],CAST(0 AS DECIMAL(18,2)) [3月#消费额],CAST(0 AS DECIMAL(18,2)) [3月#积分] ,CAST(0 AS INT) [4月#消费数],CAST(0 AS DECIMAL(18,2)) [4月#消费额],CAST(0 AS DECIMAL(18,2)) [4月#积分] ,CAST(0 AS INT) [5月#消费数],CAST(0 AS DECIMAL(18,2)) [5月#消费额],CAST(0 AS DECIMAL(18,2)) [5月#积分] ,CAST(0 AS INT) [6月#消费数],CAST(0 AS DECIMAL(18,2)) [6月#消费额],CAST(0 AS DECIMAL(18,2)) [6月#积分] ,CAST(0 AS INT) [7月#消费数],CAST(0 AS DECIMAL(18,2)) [7月#消费额],CAST(0 AS DECIMAL(18,2)) [7月#积分] ,CAST(0 AS INT) [8月#消费数],CAST(0 AS DECIMAL(18,2)) [8月#消费额],CAST(0 AS DECIMAL(18,2)) [8月#积分] ,CAST(0 AS INT) [9月#消费数],CAST(0 AS DECIMAL(18,2)) [9月#消费额],CAST(0 AS DECIMAL(18,2)) [9月#积分] ,CAST(0 AS INT) [10月#消费数],CAST(0 AS DECIMAL(18,2)) [10月#消费额],CAST(0 AS DECIMAL(18,2)) [10月#积分] ,CAST(0 AS INT) [11月#消费数],CAST(0 AS DECIMAL(18,2)) [11月#消费额],CAST(0 AS DECIMAL(18,2)) [11月#积分] ,CAST(0 AS INT) [12月#消费数],CAST(0 AS DECIMAL(18,2)) [12月#消费额],CAST(0 AS DECIMAL(18,2)) [12月#积分] INTO [##2cb01f6161414e1085253c91edcfa35d] FROM CustomerVip 时间: 2024-01-23 13:02:29,764 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[1月#消费数],[1月#消费额],[1月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=1 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:29,802 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[2月#消费数],[2月#消费额],[2月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=2 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:29,835 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[3月#消费数],[3月#消费额],[3月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=3 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:29,867 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[4月#消费数],[4月#消费额],[4月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=4 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:29,902 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[5月#消费数],[5月#消费额],[5月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=5 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:29,935 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[6月#消费数],[6月#消费额],[6月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=6 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:29,969 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[7月#消费数],[7月#消费额],[7月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=7 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:30,003 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[8月#消费数],[8月#消费额],[8月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=8 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:30,036 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[9月#消费数],[9月#消费额],[9月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=9 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:30,099 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[10月#消费数],[10月#消费额],[10月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=10 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:30,132 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[11月#消费数],[11月#消费额],[11月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=11 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:30,164 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2cb01f6161414e1085253c91edcfa35d] (Vip,[12月#消费数],[12月#消费额],[12月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##e720ee3e86064115bc15ad5d97e38466] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=12 AND DATEPART(YEAR,a.CheckDate)=2024 GROUP BY a.Vip_Card 时间: 2024-01-23 13:02:30,200 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT a.VIP AS [VIP卡号], VIP.Name AS [Vip姓名], SUM([1月#消费数]) [1月#消费数],SUM([1月#消费额]) [1月#消费额],SUM([1月#积分]) [1月#积分] , MIN(当前积分) AS [当前积分], SUM([合计#消费数]) [合计#消费数], SUM([合计#消费额]) [合计#消费额], SUM([合计#积分]) [合计#积分] INTO [##95c61e13c3564711baa691a691207f29] FROM [##2cb01f6161414e1085253c91edcfa35d] a INNER JOIN CustomerVip VIP ON a.Vip=VIP.Vip LEFT JOIN Customer C1 on C1.Customer_ID=VIP.Customer_ID LEFT JOIN Customer C3 on C3.Customer_ID=VIP.Customer_ID LEFT JOIN Customer C2 on C2.Customer_ID=VIP.OriginalCustomer WHERE 1 = 1 GROUP BY a.VIP, VIP.Name ORDER BY a.VIP, VIP.Name 时间: 2024-01-23 13:02:30,211 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT VIP卡号 Vip INTO ##5b42b6cfc5f747a1b0a6634b3373ff9d FROM ##95c61e13c3564711baa691a691207f29 时间: 2024-01-23 13:02:30,214 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXECUTE p_VipGetIntegral @VipTable = ##5b42b6cfc5f747a1b0a6634b3373ff9d ,@DataTable = ##90c57628842d4aaf89d690e15647d79b 时间: 2024-01-23 13:02:30,474 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.当前积分=B.IntegralAmount FROM [##95c61e13c3564711baa691a691207f29] A INNER JOIN [##90c57628842d4aaf89d690e15647d79b] B ON A.VIP卡号 = B.Vip 时间: 2024-01-23 13:38:23,290 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip AS [卡号] , CAST(NULL AS DECIMAL(30,2)) AS [期初积分] , CAST(NULL AS DECIMAL(30,2)) AS [本期积分] , CAST(NULL AS DECIMAL(30,2)) AS [消费积分] , CAST(NULL AS DECIMAL(30,2)) AS [抵减积分] , CAST(NULL AS DECIMAL(30,2)) AS [金额充值赠送] , CAST(NULL AS DECIMAL(30,2)) AS [增提积分] , CAST(NULL AS DECIMAL(30,2)) AS [积分换购] , CAST(NULL AS DECIMAL(30,2)) AS [积分转入] , CAST(NULL AS DECIMAL(30,2)) AS [积分转出] , CAST(NULL AS DECIMAL(30,2)) AS [零售订单积分] , CAST(NULL AS DECIMAL(30,2)) AS [可用积分] , CAST(NULL AS DECIMAL(30,2)) AS [累计积分] , CAST(NULL AS DECIMAL(30,2)) AS [当前积分] INTO [##d1a2f14b9bb04b678190cc309c61a10b] FROM CustomerVip A 时间: 2024-01-23 13:38:23,294 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##4f355ec48cd94e01a3e516841adcdc7a', @EndDate = '2023/12/31', @DataTable = '##459a094b186345ddaadc706566d1ba2c' 时间: 2024-01-23 13:38:23,709 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [期初积分]) SELECT A.VIP, SUM(A.IntegralAmount) FROM ##459a094b186345ddaadc706566d1ba2c A GROUP BY A.VIP 时间: 2024-01-23 13:38:23,726 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [金额充值赠送]) SELECT A.Vip, SUM(A.Integral) FROM VIPAddValue A WHERE A.Posted = 1 AND A.VipAddValue_Date>='2024/1/1' AND A.VipAddValue_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:38:23,736 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT Vip INTO ##7438d80b5383463aa883720328b52e0f FROM ##4f355ec48cd94e01a3e516841adcdc7a 时间: 2024-01-23 13:38:23,740 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##7438d80b5383463aa883720328b52e0f', @DataTable = '##956483ef14cb4f248913c17fa17e9074', @IsUsabeIntegral = 1 时间: 2024-01-23 13:38:24,150 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [可用积分], [当前积分]) SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral) FROM ##956483ef14cb4f248913c17fa17e9074 A GROUP BY A.VIP 时间: 2024-01-23 13:38:24,168 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [消费积分]) SELECT A.Vip_Card, SUM(A.IntegralAmount) FROM [vn_Check] A WHERE A.Posted = 1 AND A.CheckDate>='2024/1/1' AND A.CheckDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2024-01-23 13:38:24,214 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [增提积分]) SELECT A.VIP, SUM(A.Integral) FROM [VIPAddIntegral] A WHERE A.Posted = 1 AND A.VipAddIntegral_Date>='2024/1/1' AND A.VipAddIntegral_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.VIP) GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date 时间: 2024-01-23 13:38:24,228 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [积分换购]) SELECT A.VIP, SUM(A.Amount) FROM [VipIntegralExchange] A WHERE A.Posted = 1 AND A.ExchangeDate>='2024/1/1' AND A.ExchangeDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:38:24,238 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [抵减积分]) SELECT A.Vip_Card, SUM(B.Integral) FROM [vn_Check] A INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId WHERE A.Posted = 1 AND A.CheckDate>='2024/1/1' AND A.CheckDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2024-01-23 13:38:24,311 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [积分转入]) SELECT A.TurnInCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2024/1/1' AND A.IntegralTurnCard_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.TurnInCard) GROUP BY A.TurnInCard 时间: 2024-01-23 13:38:24,320 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [积分转出]) SELECT A.TurnOutCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2024/1/1' AND A.IntegralTurnCard_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.TurnOutCard) GROUP BY A.TurnOutCard 时间: 2024-01-23 13:38:24,328 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d1a2f14b9bb04b678190cc309c61a10b ([卡号], [零售订单积分]) SELECT A.VIP, SUM(A.Integral) FROM [KS2_RetailOrderIntegral] A WHERE 1 = 1 AND A.InputTime>='2024/1/1' AND A.InputTime<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:38:24,342 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d1a2f14b9bb04b678190cc309c61a10b SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) 时间: 2024-01-23 13:38:24,355 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d1a2f14b9bb04b678190cc309c61a10b SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0) 时间: 2024-01-23 13:38:24,372 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip , CAST(NULL AS VARCHAR(10)) AS [首次消费日期] , CAST(NULL AS VARCHAR(10)) AS [最后消费日期] , CAST(NULL AS VARCHAR(50)) AS [最后消费渠道] , CAST(NULL AS DECIMAL(30,2)) AS [消费金额] , CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额] , CAST(NULL AS NVARCHAR(50)) AS [活跃度] , CAST(NULL AS INT) AS [活跃度2] INTO [##108e9b747d524500914112b0666e932a] FROM CustomerVip A 时间: 2024-01-23 13:38:24,374 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##108e9b747d524500914112b0666e932a(Vip,活跃度) SELECT A.Vip,'深度休眠' FROM ##4f355ec48cd94e01a3e516841adcdc7a A INNER JOIN CustomerVip B ON A.Vip = B.Vip WHERE EXISTS(SELECT 1 FROM ##56e906c58ce340a5982b1230cdf78f3c C WHERE B.Customer_ID = C.Customer_ID) 时间: 2024-01-23 13:38:24,414 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteData AS ( SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate FROM vn_check a WHERE ISNULL(A.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a B WHERE a.VIP_Card = B.Vip) GROUP BY a.VIP_Card ) UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120) ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120) FROM ##108e9b747d524500914112b0666e932a A INNER JOIN cteData B ON A.Vip = B.VIP 时间: 2024-01-23 13:38:24,580 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE Vip = a.VIP_Card ) AND a.CheckDate>'2023/12/31' and a.CheckDate<'2024/1/24' GROUP BY a.VIP_Card ) UPDATE A SET A.消费金额 = B.Amount FROM ##108e9b747d524500914112b0666e932a A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2024-01-23 13:38:24,636 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a WHERE Vip = a.VIP_Card ) GROUP BY a.VIP_Card ) UPDATE A SET A.累计消费金额 = B.Amount FROM ##108e9b747d524500914112b0666e932a A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2024-01-23 13:38:24,791 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteLastSale AS ( SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate FROM vn_Check a WHERE ISNULL(a.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##4f355ec48cd94e01a3e516841adcdc7a B WHERE a.VIP_Card = B.Vip) GROUP BY a.Customer_ID, a.VIP_Card ) ,cteMax AS ( SELECT Vip, MAX(CheckDate) AS CheckDate FROM cteLastSale GROUP BY Vip ) ,cteSet AS ( SELECT A.* FROM cteLastSale A WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate) ) UPDATE A SET A.最后消费渠道 = C.Abbrev FROM ##108e9b747d524500914112b0666e932a A INNER JOIN cteSet B ON A.Vip = B.Vip INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 时间: 2024-01-23 13:38:25,251 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.Vip = A.Vip ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE()) FROM ##108e9b747d524500914112b0666e932a A WHERE ISNULL(A.最后消费日期,'') != '' 时间: 2024-01-23 13:38:25,274 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '活跃' FROM ##108e9b747d524500914112b0666e932a A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) <= 90 时间: 2024-01-23 13:38:25,283 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '较活跃' FROM ##108e9b747d524500914112b0666e932a A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 90 AND CAST(A.活跃度2 AS INT) < 180 时间: 2024-01-23 13:38:25,290 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '警戒' FROM ##108e9b747d524500914112b0666e932a A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 180 AND CAST(A.活跃度2 AS INT) < 365 时间: 2024-01-23 13:38:25,298 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '休眠' FROM ##108e9b747d524500914112b0666e932a A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 365 AND CAST(A.活跃度2 AS INT) < 730 时间: 2024-01-23 13:38:25,306 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '深度休眠' FROM ##108e9b747d524500914112b0666e932a A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 730 时间: 2024-01-23 13:38:25,312 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.消费金额 AS [消费金额], B.累计消费金额 AS [累计消费金额], B.活跃度 AS [活跃度], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] INTO tempdb.dbo.[91ca86a6-b7af-4ebf-bff6-e1da909f0882] FROM [##4f355ec48cd94e01a3e516841adcdc7a] Vip LEFT JOIN [##d1a2f14b9bb04b678190cc309c61a10b] A ON Vip.VIP=A.[卡号] LEFT JOIN [##108e9b747d524500914112b0666e932a] B ON Vip.VIP=B.Vip LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID GROUP BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 HAVING 1=1 ORDER BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 时间: 2024-01-23 13:43:08,892 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip AS [卡号] , CAST(NULL AS DECIMAL(30,2)) AS [期初积分] , CAST(NULL AS DECIMAL(30,2)) AS [本期积分] , CAST(NULL AS DECIMAL(30,2)) AS [消费积分] , CAST(NULL AS DECIMAL(30,2)) AS [抵减积分] , CAST(NULL AS DECIMAL(30,2)) AS [金额充值赠送] , CAST(NULL AS DECIMAL(30,2)) AS [增提积分] , CAST(NULL AS DECIMAL(30,2)) AS [积分换购] , CAST(NULL AS DECIMAL(30,2)) AS [积分转入] , CAST(NULL AS DECIMAL(30,2)) AS [积分转出] , CAST(NULL AS DECIMAL(30,2)) AS [零售订单积分] , CAST(NULL AS DECIMAL(30,2)) AS [可用积分] , CAST(NULL AS DECIMAL(30,2)) AS [累计积分] , CAST(NULL AS DECIMAL(30,2)) AS [当前积分] INTO [##5a2493de19ec4210842189ce78197f9b] FROM CustomerVip A 时间: 2024-01-23 13:43:08,895 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##d3548c5e6d7f4b17bd1cf85b71b11b26', @EndDate = '2023/12/31', @DataTable = '##4a126c8fc6f14306924d0f358355ef70' 时间: 2024-01-23 13:43:09,064 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [期初积分]) SELECT A.VIP, SUM(A.IntegralAmount) FROM ##4a126c8fc6f14306924d0f358355ef70 A GROUP BY A.VIP 时间: 2024-01-23 13:43:09,067 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [金额充值赠送]) SELECT A.Vip, SUM(A.Integral) FROM VIPAddValue A WHERE A.Posted = 1 AND A.VipAddValue_Date>='2024/1/1' AND A.VipAddValue_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:43:09,073 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT Vip INTO ##0eb8dfca2a8645ea8ace998cf78f444b FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 时间: 2024-01-23 13:43:09,075 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##0eb8dfca2a8645ea8ace998cf78f444b', @DataTable = '##9bd4820db11f41da9e408ddfe00dfeec', @IsUsabeIntegral = 1 时间: 2024-01-23 13:43:09,278 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [可用积分], [当前积分]) SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral) FROM ##9bd4820db11f41da9e408ddfe00dfeec A GROUP BY A.VIP 时间: 2024-01-23 13:43:09,281 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [消费积分]) SELECT A.Vip_Card, SUM(A.IntegralAmount) FROM [vn_Check] A WHERE A.Posted = 1 AND A.CheckDate>='2024/1/1' AND A.CheckDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2024-01-23 13:43:09,308 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [增提积分]) SELECT A.VIP, SUM(A.Integral) FROM [VIPAddIntegral] A WHERE A.Posted = 1 AND A.VipAddIntegral_Date>='2024/1/1' AND A.VipAddIntegral_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.VIP) GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date 时间: 2024-01-23 13:43:09,316 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [积分换购]) SELECT A.VIP, SUM(A.Amount) FROM [VipIntegralExchange] A WHERE A.Posted = 1 AND A.ExchangeDate>='2024/1/1' AND A.ExchangeDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:43:09,322 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [抵减积分]) SELECT A.Vip_Card, SUM(B.Integral) FROM [vn_Check] A INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId WHERE A.Posted = 1 AND A.CheckDate>='2024/1/1' AND A.CheckDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2024-01-23 13:43:09,375 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [积分转入]) SELECT A.TurnInCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2024/1/1' AND A.IntegralTurnCard_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.TurnInCard) GROUP BY A.TurnInCard 时间: 2024-01-23 13:43:09,382 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [积分转出]) SELECT A.TurnOutCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2024/1/1' AND A.IntegralTurnCard_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.TurnOutCard) GROUP BY A.TurnOutCard 时间: 2024-01-23 13:43:09,390 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5a2493de19ec4210842189ce78197f9b ([卡号], [零售订单积分]) SELECT A.VIP, SUM(A.Integral) FROM [KS2_RetailOrderIntegral] A WHERE 1 = 1 AND A.InputTime>='2024/1/1' AND A.InputTime<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:43:09,397 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5a2493de19ec4210842189ce78197f9b SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) 时间: 2024-01-23 13:43:09,398 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5a2493de19ec4210842189ce78197f9b SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0) 时间: 2024-01-23 13:43:09,400 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip , CAST(NULL AS VARCHAR(10)) AS [首次消费日期] , CAST(NULL AS VARCHAR(10)) AS [最后消费日期] , CAST(NULL AS VARCHAR(50)) AS [最后消费渠道] , CAST(NULL AS DECIMAL(30,2)) AS [消费金额] , CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额] , CAST(NULL AS NVARCHAR(50)) AS [活跃度] , CAST(NULL AS INT) AS [活跃度2] INTO [##f7592fb7e5f342388ec77efa401686cb] FROM CustomerVip A 时间: 2024-01-23 13:43:09,403 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##f7592fb7e5f342388ec77efa401686cb(Vip,活跃度) SELECT A.Vip,'深度休眠' FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 A INNER JOIN CustomerVip B ON A.Vip = B.Vip WHERE EXISTS(SELECT 1 FROM ##18d48e3614704fda981672f9e934cb83 C WHERE B.Customer_ID = C.Customer_ID) 时间: 2024-01-23 13:43:09,410 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteData AS ( SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate FROM vn_check a WHERE ISNULL(A.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 B WHERE a.VIP_Card = B.Vip) GROUP BY a.VIP_Card ) UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120) ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120) FROM ##f7592fb7e5f342388ec77efa401686cb A INNER JOIN cteData B ON A.Vip = B.VIP 时间: 2024-01-23 13:43:09,492 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE Vip = a.VIP_Card ) AND a.CheckDate>'2023/12/31' and a.CheckDate<'2024/1/24' GROUP BY a.VIP_Card ) UPDATE A SET A.消费金额 = B.Amount FROM ##f7592fb7e5f342388ec77efa401686cb A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2024-01-23 13:43:09,552 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 WHERE Vip = a.VIP_Card ) GROUP BY a.VIP_Card ) UPDATE A SET A.累计消费金额 = B.Amount FROM ##f7592fb7e5f342388ec77efa401686cb A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2024-01-23 13:43:09,637 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteLastSale AS ( SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate FROM vn_Check a WHERE ISNULL(a.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##d3548c5e6d7f4b17bd1cf85b71b11b26 B WHERE a.VIP_Card = B.Vip) GROUP BY a.Customer_ID, a.VIP_Card ) ,cteMax AS ( SELECT Vip, MAX(CheckDate) AS CheckDate FROM cteLastSale GROUP BY Vip ) ,cteSet AS ( SELECT A.* FROM cteLastSale A WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate) ) UPDATE A SET A.最后消费渠道 = C.Abbrev FROM ##f7592fb7e5f342388ec77efa401686cb A INNER JOIN cteSet B ON A.Vip = B.Vip INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 时间: 2024-01-23 13:43:10,098 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.Vip = A.Vip ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE()) FROM ##f7592fb7e5f342388ec77efa401686cb A WHERE ISNULL(A.最后消费日期,'') != '' 时间: 2024-01-23 13:43:10,101 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '活跃' FROM ##f7592fb7e5f342388ec77efa401686cb A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) <= 90 时间: 2024-01-23 13:43:10,103 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '较活跃' FROM ##f7592fb7e5f342388ec77efa401686cb A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 90 AND CAST(A.活跃度2 AS INT) < 180 时间: 2024-01-23 13:43:10,105 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '警戒' FROM ##f7592fb7e5f342388ec77efa401686cb A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 180 AND CAST(A.活跃度2 AS INT) < 365 时间: 2024-01-23 13:43:10,106 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '休眠' FROM ##f7592fb7e5f342388ec77efa401686cb A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 365 AND CAST(A.活跃度2 AS INT) < 730 时间: 2024-01-23 13:43:10,108 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '深度休眠' FROM ##f7592fb7e5f342388ec77efa401686cb A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 730 时间: 2024-01-23 13:43:10,109 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.消费金额 AS [消费金额], B.累计消费金额 AS [累计消费金额], B.活跃度 AS [活跃度], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] INTO tempdb.dbo.[91ca86a6-b7af-4ebf-bff6-e1da909f0882] FROM [##d3548c5e6d7f4b17bd1cf85b71b11b26] Vip LEFT JOIN [##5a2493de19ec4210842189ce78197f9b] A ON Vip.VIP=A.[卡号] LEFT JOIN [##f7592fb7e5f342388ec77efa401686cb] B ON Vip.VIP=B.Vip LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID GROUP BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 HAVING 1=1 ORDER BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 时间: 2024-01-23 13:50:49,944 线程ID: 14 日志级别: 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 [##93f883e154c842b7997e0a6c8d2f85af] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 13:50:50,357 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##01a1aa067e4a4a09bda4149053319f52] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 13:50:50,358 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##93f883e154c842b7997e0a6c8d2f85af] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##01a1aa067e4a4a09bda4149053319f52] 时间: 2024-01-23 13:50:50,442 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fe20c54e2bfc48deaffee39c08e7dd9a a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 13:50:50,444 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fe20c54e2bfc48deaffee39c08e7dd9a SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 13:50:50,446 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fe20c54e2bfc48deaffee39c08e7dd9a 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 = '退货' 时间: 2024-01-23 13:50:50,474 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fe20c54e2bfc48deaffee39c08e7dd9a SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 13:50:50,476 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fe20c54e2bfc48deaffee39c08e7dd9a SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 13:50:50,480 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##93f883e154c842b7997e0a6c8d2f85af] (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 [##d8cffedae7aa4af2b5af3ffbff607aab] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 13:50:50,484 线程ID: 14 日志级别: 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.[30457255-bb9a-40d8-bb2b-ac955789d877] FROM ##93f883e154c842b7997e0a6c8d2f85af 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 时间: 2024-01-23 13:50:56,182 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##a37b7cafff1842f494c8184bc9ed3189] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 13:50:56,596 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##64c0cbde88b74f21aa23b394e4f9ebe9] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 13:50:56,597 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a37b7cafff1842f494c8184bc9ed3189] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##64c0cbde88b74f21aa23b394e4f9ebe9] 时间: 2024-01-23 13:50:56,685 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3cf214e9b1fc46b890862558166e061e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 13:50:56,688 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3cf214e9b1fc46b890862558166e061e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 13:50:56,690 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3cf214e9b1fc46b890862558166e061e 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 = '退货' 时间: 2024-01-23 13:50:56,724 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3cf214e9b1fc46b890862558166e061e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 13:50:56,726 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3cf214e9b1fc46b890862558166e061e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 13:50:56,730 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a37b7cafff1842f494c8184bc9ed3189] (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 [##393c9720694f4c4e9844e56e181d5860] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 13:50:56,735 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[30457255-bb9a-40d8-bb2b-ac955789d877] FROM ##a37b7cafff1842f494c8184bc9ed3189 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 时间: 2024-01-23 13:55:09,370 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip AS [卡号] , CAST(NULL AS DECIMAL(30,2)) AS [期初积分] , CAST(NULL AS DECIMAL(30,2)) AS [本期积分] , CAST(NULL AS DECIMAL(30,2)) AS [消费积分] , CAST(NULL AS DECIMAL(30,2)) AS [抵减积分] , CAST(NULL AS DECIMAL(30,2)) AS [金额充值赠送] , CAST(NULL AS DECIMAL(30,2)) AS [增提积分] , CAST(NULL AS DECIMAL(30,2)) AS [积分换购] , CAST(NULL AS DECIMAL(30,2)) AS [积分转入] , CAST(NULL AS DECIMAL(30,2)) AS [积分转出] , CAST(NULL AS DECIMAL(30,2)) AS [零售订单积分] , CAST(NULL AS DECIMAL(30,2)) AS [可用积分] , CAST(NULL AS DECIMAL(30,2)) AS [累计积分] , CAST(NULL AS DECIMAL(30,2)) AS [当前积分] INTO [##72c58b425ae64fd2b1e8f4924a378c78] FROM CustomerVip A 时间: 2024-01-23 13:55:09,372 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##2eb7a7173ccd4d549f01b38ca113bae7', @EndDate = '2019/12/31', @DataTable = '##d56539fab28241b98b7f00342daee006' 时间: 2024-01-23 13:55:09,657 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [期初积分]) SELECT A.VIP, SUM(A.IntegralAmount) FROM ##d56539fab28241b98b7f00342daee006 A GROUP BY A.VIP 时间: 2024-01-23 13:55:09,659 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [金额充值赠送]) SELECT A.Vip, SUM(A.Integral) FROM VIPAddValue A WHERE A.Posted = 1 AND A.VipAddValue_Date>='2020/1/1' AND A.VipAddValue_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:55:09,670 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT Vip INTO ##8190f6fd6bdf4e4e9a90756206ae53da FROM ##2eb7a7173ccd4d549f01b38ca113bae7 时间: 2024-01-23 13:55:09,676 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXEC p_VipGetIntegral @VipTable = '##8190f6fd6bdf4e4e9a90756206ae53da', @DataTable = '##67d66b24bebc4b0695ebe357deb39dc7', @IsUsabeIntegral = 1 时间: 2024-01-23 13:55:10,086 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [可用积分], [当前积分]) SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral) FROM ##67d66b24bebc4b0695ebe357deb39dc7 A GROUP BY A.VIP 时间: 2024-01-23 13:55:10,102 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [消费积分]) SELECT A.Vip_Card, SUM(A.IntegralAmount) FROM [vn_Check] A WHERE A.Posted = 1 AND A.CheckDate>='2020/1/1' AND A.CheckDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2024-01-23 13:55:10,239 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [增提积分]) SELECT A.VIP, SUM(A.Integral) FROM [VIPAddIntegral] A WHERE A.Posted = 1 AND A.VipAddIntegral_Date>='2020/1/1' AND A.VipAddIntegral_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.VIP) GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date 时间: 2024-01-23 13:55:10,280 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [积分换购]) SELECT A.VIP, SUM(A.Amount) FROM [VipIntegralExchange] A WHERE A.Posted = 1 AND A.ExchangeDate>='2020/1/1' AND A.ExchangeDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:55:10,289 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [抵减积分]) SELECT A.Vip_Card, SUM(B.Integral) FROM [vn_Check] A INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId WHERE A.Posted = 1 AND A.CheckDate>='2020/1/1' AND A.CheckDate<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.Vip_Card) GROUP BY A.Vip_Card 时间: 2024-01-23 13:55:10,366 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [积分转入]) SELECT A.TurnInCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2020/1/1' AND A.IntegralTurnCard_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.TurnInCard) GROUP BY A.TurnInCard 时间: 2024-01-23 13:55:10,375 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [积分转出]) SELECT A.TurnOutCard, SUM(A.TurnInIntegral) FROM [IntegralTurnCard] A WHERE A.Posted = 1 AND A.IntegralTurnCard_Date>='2020/1/1' AND A.IntegralTurnCard_Date<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.TurnOutCard) GROUP BY A.TurnOutCard 时间: 2024-01-23 13:55:10,383 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##72c58b425ae64fd2b1e8f4924a378c78 ([卡号], [零售订单积分]) SELECT A.VIP, SUM(A.Integral) FROM [KS2_RetailOrderIntegral] A WHERE 1 = 1 AND A.InputTime>='2020/1/1' AND A.InputTime<='2024/1/23 23:59:59' AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE VIP=A.VIP) GROUP BY A.VIP 时间: 2024-01-23 13:55:10,395 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##72c58b425ae64fd2b1e8f4924a378c78 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) 时间: 2024-01-23 13:55:10,410 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##72c58b425ae64fd2b1e8f4924a378c78 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0) 时间: 2024-01-23 13:55:10,424 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Vip , CAST(NULL AS VARCHAR(10)) AS [首次消费日期] , CAST(NULL AS VARCHAR(10)) AS [最后消费日期] , CAST(NULL AS VARCHAR(50)) AS [最后消费渠道] , CAST(NULL AS DECIMAL(30,2)) AS [消费金额] , CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额] , CAST(NULL AS NVARCHAR(50)) AS [活跃度] , CAST(NULL AS INT) AS [活跃度2] INTO [##8f164d46b4ce49bd8554b2079d119b9b] FROM CustomerVip A 时间: 2024-01-23 13:55:10,427 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##8f164d46b4ce49bd8554b2079d119b9b(Vip,活跃度) SELECT A.Vip,'深度休眠' FROM ##2eb7a7173ccd4d549f01b38ca113bae7 A INNER JOIN CustomerVip B ON A.Vip = B.Vip WHERE EXISTS(SELECT 1 FROM ##5da661a39e544879b159d7bfd7720580 C WHERE B.Customer_ID = C.Customer_ID) 时间: 2024-01-23 13:55:10,457 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteData AS ( SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate FROM vn_check a WHERE ISNULL(A.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 B WHERE a.VIP_Card = B.Vip) GROUP BY a.VIP_Card ) UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120) ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120) FROM ##8f164d46b4ce49bd8554b2079d119b9b A INNER JOIN cteData B ON A.Vip = B.VIP 时间: 2024-01-23 13:55:10,625 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE Vip = a.VIP_Card ) AND a.CheckDate>'2019/12/31' and a.CheckDate<'2024/1/24' GROUP BY a.VIP_Card ) UPDATE A SET A.消费金额 = B.Amount FROM ##8f164d46b4ce49bd8554b2079d119b9b A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2024-01-23 13:55:10,776 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteSaleData AS ( SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount FROM vn_check a INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID WHERE a.Posted = 1 AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 WHERE Vip = a.VIP_Card ) GROUP BY a.VIP_Card ) UPDATE A SET A.累计消费金额 = B.Amount FROM ##8f164d46b4ce49bd8554b2079d119b9b A INNER JOIN cteSaleData B ON A.Vip = B.Vip 时间: 2024-01-23 13:55:10,922 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;WITH cteLastSale AS ( SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate FROM vn_Check a WHERE ISNULL(a.Posted,0) = 1 AND EXISTS(SELECT 1 FROM ##2eb7a7173ccd4d549f01b38ca113bae7 B WHERE a.VIP_Card = B.Vip) GROUP BY a.Customer_ID, a.VIP_Card ) ,cteMax AS ( SELECT Vip, MAX(CheckDate) AS CheckDate FROM cteLastSale GROUP BY Vip ) ,cteSet AS ( SELECT A.* FROM cteLastSale A WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate) ) UPDATE A SET A.最后消费渠道 = C.Abbrev FROM ##8f164d46b4ce49bd8554b2079d119b9b A INNER JOIN cteSet B ON A.Vip = B.Vip INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 时间: 2024-01-23 13:55:11,403 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.Vip = A.Vip ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE()) FROM ##8f164d46b4ce49bd8554b2079d119b9b A WHERE ISNULL(A.最后消费日期,'') != '' 时间: 2024-01-23 13:55:11,426 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '活跃' FROM ##8f164d46b4ce49bd8554b2079d119b9b A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) <= 90 时间: 2024-01-23 13:55:11,434 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '较活跃' FROM ##8f164d46b4ce49bd8554b2079d119b9b A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 90 AND CAST(A.活跃度2 AS INT) < 180 时间: 2024-01-23 13:55:11,440 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '警戒' FROM ##8f164d46b4ce49bd8554b2079d119b9b A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 180 AND CAST(A.活跃度2 AS INT) < 365 时间: 2024-01-23 13:55:11,448 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '休眠' FROM ##8f164d46b4ce49bd8554b2079d119b9b A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 365 AND CAST(A.活跃度2 AS INT) < 730 时间: 2024-01-23 13:55:11,458 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.活跃度 = '深度休眠' FROM ##8f164d46b4ce49bd8554b2079d119b9b A WHERE ISNULL(A.最后消费日期,'') != '' AND CAST(A.活跃度2 AS INT) >= 730 时间: 2024-01-23 13:55:11,463 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.消费金额 AS [消费金额], B.累计消费金额 AS [累计消费金额], B.活跃度 AS [活跃度], SUM(期初积分) AS [期初积分], SUM(消费积分) AS [销售积分#消费积分], SUM(增提积分) AS [销售积分#增提积分], SUM(抵减积分) AS [销售积分#抵减积分], SUM(积分换购) AS [销售积分#积分换购], SUM(金额充值赠送) AS [销售积分#金额充值赠送], SUM(本期积分) AS [销售积分#本期积分], SUM(积分转入) AS [积分转入], SUM(积分转出) AS [积分转出], SUM(零售订单积分) AS [零售订单积分], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], CASE WHEN ISNULL(SUM([累计积分]),0) = 0 THEN 0 ELSE CAST(SUM([本期积分]) / SUM([累计积分]) AS NUMERIC(18,2)) END AS [占比], SUM(当前积分) AS [当前积分] INTO tempdb.dbo.[a1a3c41a-6906-4603-ab93-a6594eadf4c0] FROM [##2eb7a7173ccd4d549f01b38ca113bae7] Vip LEFT JOIN [##72c58b425ae64fd2b1e8f4924a378c78] A ON Vip.VIP=A.[卡号] LEFT JOIN [##8f164d46b4ce49bd8554b2079d119b9b] B ON Vip.VIP=B.Vip LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID GROUP BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 HAVING 1=1 ORDER BY Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.消费金额, B.累计消费金额, B.活跃度 时间: 2024-01-23 14:21:08,524 线程ID: 80 日志级别: 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 [##0afc649062264fe1a0f5eeb6f55bb01b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 14:21:08,958 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##73b1fd0d76384a39a2e56ce6f08e5af7] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 14:21:08,960 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0afc649062264fe1a0f5eeb6f55bb01b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##73b1fd0d76384a39a2e56ce6f08e5af7] 时间: 2024-01-23 14:21:09,022 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d98b340374274c41a4d0535e1fd900f3 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 14:21:09,024 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d98b340374274c41a4d0535e1fd900f3 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 14:21:09,026 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d98b340374274c41a4d0535e1fd900f3 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 = '退货' 时间: 2024-01-23 14:21:09,059 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d98b340374274c41a4d0535e1fd900f3 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 14:21:09,062 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d98b340374274c41a4d0535e1fd900f3 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 14:21:09,065 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0afc649062264fe1a0f5eeb6f55bb01b] (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 [##0ad1a564d645463cbfe4d071f07f52cc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 14:21:09,070 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[e095fff6-6ec9-43cc-b35c-0503775ea563] FROM ##0afc649062264fe1a0f5eeb6f55bb01b A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 14:55:08,274 线程ID: 38 日志级别: 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 [##e4a4609a300c4323b9ba2e60b3d65753] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 14:55:08,685 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##52c42578e68b477c9f31d2542162feb5] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 14:55:08,687 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e4a4609a300c4323b9ba2e60b3d65753] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##52c42578e68b477c9f31d2542162feb5] 时间: 2024-01-23 14:55:08,751 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ac85dd095c3b4ca69e85399487630bad a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 14:55:08,753 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac85dd095c3b4ca69e85399487630bad SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 14:55:08,756 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ac85dd095c3b4ca69e85399487630bad 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 = '退货' 时间: 2024-01-23 14:55:08,793 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac85dd095c3b4ca69e85399487630bad SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 14:55:08,795 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac85dd095c3b4ca69e85399487630bad SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 14:55:08,799 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e4a4609a300c4323b9ba2e60b3d65753] (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 [##c470be35cb294e09a53bf7367cd52247] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 14:55:08,803 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##e4a4609a300c4323b9ba2e60b3d65753 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 14:56:24,237 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##1f7050e3b1d04c399b90e0fb99e0ef63] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 14:56:24,620 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c0bde7fa55644e6eabc037c049857e05] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 14:56:24,622 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1f7050e3b1d04c399b90e0fb99e0ef63] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c0bde7fa55644e6eabc037c049857e05] 时间: 2024-01-23 14:56:24,681 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9e1acea2e37f48afa27c96367e743e93 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 14:56:24,683 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9e1acea2e37f48afa27c96367e743e93 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 14:56:24,685 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9e1acea2e37f48afa27c96367e743e93 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 = '退货' 时间: 2024-01-23 14:56:24,722 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9e1acea2e37f48afa27c96367e743e93 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 14:56:24,724 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9e1acea2e37f48afa27c96367e743e93 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 14:56:24,729 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1f7050e3b1d04c399b90e0fb99e0ef63] (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 [##fb57b656a8ba475fa1c8d1e2b5af1724] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 14:56:24,734 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##1f7050e3b1d04c399b90e0fb99e0ef63 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 14:56:30,403 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##a9a8a531492746ed95cbf017194d660c] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 14:56:30,755 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4043b6a5a2f9413c9f53441f0ac5305f] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 14:56:30,756 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a8a531492746ed95cbf017194d660c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4043b6a5a2f9413c9f53441f0ac5305f] 时间: 2024-01-23 14:56:30,816 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##71ebcfd6c8fa426d8b45db354638aad3 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 14:56:30,818 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##71ebcfd6c8fa426d8b45db354638aad3 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 14:56:30,819 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##71ebcfd6c8fa426d8b45db354638aad3 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 = '退货' 时间: 2024-01-23 14:56:30,849 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##71ebcfd6c8fa426d8b45db354638aad3 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 14:56:30,851 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##71ebcfd6c8fa426d8b45db354638aad3 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 14:56:30,854 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a9a8a531492746ed95cbf017194d660c] (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 [##c4a36fffe7c54163819e764f8b42cd57] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 14:56:30,858 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##a9a8a531492746ed95cbf017194d660c A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 14:56:31,596 线程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 [##15837c85f7e7421db2ac37f8d3a71dd8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 14:56:31,990 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3e67f03535554f9d9866086c1c60204f] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 14:56:31,991 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##15837c85f7e7421db2ac37f8d3a71dd8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3e67f03535554f9d9866086c1c60204f] 时间: 2024-01-23 14:56:32,063 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b49e195030c34e23a33169fe9803dd0c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 14:56:32,065 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b49e195030c34e23a33169fe9803dd0c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 14:56:32,066 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b49e195030c34e23a33169fe9803dd0c 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 = '退货' 时间: 2024-01-23 14:56:32,098 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b49e195030c34e23a33169fe9803dd0c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 14:56:32,100 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b49e195030c34e23a33169fe9803dd0c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 14:56:32,105 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##15837c85f7e7421db2ac37f8d3a71dd8] (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 [##1db1a6a95d3442aea94ff05c26c0eb72] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 14:56:32,109 线程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.[79929a35-dd66-4364-a78e-182952d1650f] FROM ##15837c85f7e7421db2ac37f8d3a71dd8 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 时间: 2024-01-23 14:57:09,476 线程ID: 84 日志级别: 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 [##bcb3a3f57d914e8fa1a79c881d62e45b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 14:57:09,863 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##bd5f3bb98c464b51afbfce541dad9a98] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 14:57:09,866 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bcb3a3f57d914e8fa1a79c881d62e45b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bd5f3bb98c464b51afbfce541dad9a98] 时间: 2024-01-23 14:57:09,946 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4e899e8bf530483aa29b7e6643b805b6 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 14:57:09,948 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4e899e8bf530483aa29b7e6643b805b6 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 14:57:09,950 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4e899e8bf530483aa29b7e6643b805b6 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 = '退货' 时间: 2024-01-23 14:57:09,979 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4e899e8bf530483aa29b7e6643b805b6 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 14:57:09,981 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4e899e8bf530483aa29b7e6643b805b6 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 14:57:09,985 线程ID: 84 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bcb3a3f57d914e8fa1a79c881d62e45b] (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 [##211b7488de254feea91802130315949d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 14:57:09,989 线程ID: 84 日志级别: 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.[79929a35-dd66-4364-a78e-182952d1650f] FROM ##bcb3a3f57d914e8fa1a79c881d62e45b 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 时间: 2024-01-23 15:02:39,842 线程ID: 31 日志级别: 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.[5bed8d98-1da6-4c9c-b010-ad9adcee1210] FROM [##c53a15a8975042bea84d5e7ee9c02d24] ORDER BY Goods_no 时间: 2024-01-23 15:02:46,407 线程ID: 31 日志级别: 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.[5bed8d98-1da6-4c9c-b010-ad9adcee1210] FROM [##2dceddf480724e61afc5867ec89d76bf] ORDER BY Goods_no 时间: 2024-01-23 15:02:58,452 线程ID: 82 日志级别: 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.[5bed8d98-1da6-4c9c-b010-ad9adcee1210] FROM [##c7d1903af7f6438eba61cb3777f9fc8e] ORDER BY Goods_no 时间: 2024-01-23 15:05:36,205 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##8a0624a9bf86423eac71320fb109b333] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 15:05:36,623 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##6a1c49d94e8c4b5691a6d38e73e3219b] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 15:05:36,625 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8a0624a9bf86423eac71320fb109b333] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6a1c49d94e8c4b5691a6d38e73e3219b] 时间: 2024-01-23 15:05:36,684 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##67d803aedba94a5698e77ef0836ced5f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 15:05:36,686 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##67d803aedba94a5698e77ef0836ced5f SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 15:05:36,688 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##67d803aedba94a5698e77ef0836ced5f 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 = '退货' 时间: 2024-01-23 15:05:36,716 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##67d803aedba94a5698e77ef0836ced5f SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 15:05:36,718 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##67d803aedba94a5698e77ef0836ced5f SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 15:05:36,721 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8a0624a9bf86423eac71320fb109b333] (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 [##a2c52186e6bf4a0a948b48ef78f2c040] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 15:05:36,725 线程ID: 82 日志级别: 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.[79929a35-dd66-4364-a78e-182952d1650f] FROM ##8a0624a9bf86423eac71320fb109b333 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 时间: 2024-01-23 15:46:46,920 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##c7edf06b2c144def9d2c447961af3075] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 15:46:47,424 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##384eba0032c4496d984074eb7e035695] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 15:46:47,426 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c7edf06b2c144def9d2c447961af3075] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##384eba0032c4496d984074eb7e035695] 时间: 2024-01-23 15:46:47,484 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6d4380b0dfc04586bf8bbe607ed6e98b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 15:46:47,486 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6d4380b0dfc04586bf8bbe607ed6e98b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 15:46:47,490 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6d4380b0dfc04586bf8bbe607ed6e98b 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 = '退货' 时间: 2024-01-23 15:46:47,526 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6d4380b0dfc04586bf8bbe607ed6e98b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 15:46:47,528 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6d4380b0dfc04586bf8bbe607ed6e98b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 15:46:47,532 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c7edf06b2c144def9d2c447961af3075] (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 [##ba97cae238f54ca9a11b4aadfb811a18] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 15:46:47,538 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##c7edf06b2c144def9d2c447961af3075 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 15:53:36,452 线程ID: 22 日志级别: 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 [##cce62b07ffac47a88307bada59a10bfd] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 15:53:36,838 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##dbcb7e53a51f4e93bd0d16f193c1d8a7] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 15:53:36,840 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cce62b07ffac47a88307bada59a10bfd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##dbcb7e53a51f4e93bd0d16f193c1d8a7] 时间: 2024-01-23 15:53:36,893 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6ac4bed751324030a64355ebd6a58a71 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 15:53:36,895 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6ac4bed751324030a64355ebd6a58a71 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 15:53:36,898 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6ac4bed751324030a64355ebd6a58a71 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 = '退货' 时间: 2024-01-23 15:53:36,927 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6ac4bed751324030a64355ebd6a58a71 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 15:53:36,928 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6ac4bed751324030a64355ebd6a58a71 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 15:53:36,932 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cce62b07ffac47a88307bada59a10bfd] (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 [##752e62a0c0294462889439184b01c1c3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 15:53:36,937 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##cce62b07ffac47a88307bada59a10bfd A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 16:23:30,883 线程ID: 82 日志级别: 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.[be5edae2-4eca-447e-ab56-b916b9657d48] FROM [##0b70f341283f4550b91637730636f47c] ORDER BY Goods_no 时间: 2024-01-23 16:25:59,866 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##99abd663c8f4408796796396ea612275] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##99abd663c8f4408796796396ea612275] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##540c74e7399845159c814106abb0a166] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##99abd663c8f4408796796396ea612275] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##99abd663c8f4408796796396ea612275] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##540c74e7399845159c814106abb0a166] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##99abd663c8f4408796796396ea612275] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##99abd663c8f4408796796396ea612275] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##540c74e7399845159c814106abb0a166] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##99abd663c8f4408796796396ea612275] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##540c74e7399845159c814106abb0a166] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##99abd663c8f4408796796396ea612275] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##99abd663c8f4408796796396ea612275] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##540c74e7399845159c814106abb0a166] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2024-01-23 16:26:00,487 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[10d8872b-f29b-4093-bdbf-7778a2151786] FROM [##99abd663c8f4408796796396ea612275] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2024-01-23 16:26:15,565 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##13e77559d61e4d7fb121d8731a4783c2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 16:26:15,971 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1baf949d55c14b7481382b4aadce7781] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 16:26:15,973 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##13e77559d61e4d7fb121d8731a4783c2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1baf949d55c14b7481382b4aadce7781] 时间: 2024-01-23 16:26:16,030 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##62107ed82f7e4a0cb2bbd9fe8fe9edb8 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 16:26:16,033 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##62107ed82f7e4a0cb2bbd9fe8fe9edb8 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 16:26:16,038 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##62107ed82f7e4a0cb2bbd9fe8fe9edb8 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 = '退货' 时间: 2024-01-23 16:26:16,076 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##62107ed82f7e4a0cb2bbd9fe8fe9edb8 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 16:26:16,078 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##62107ed82f7e4a0cb2bbd9fe8fe9edb8 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 16:26:16,081 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##13e77559d61e4d7fb121d8731a4783c2] (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 [##74e8cb6090d14a3685351c7c2f173875] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 16:26:16,088 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[dea8088b-261f-4c44-970b-0684524e27b2] FROM ##13e77559d61e4d7fb121d8731a4783c2 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 W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.UnitPrice ORDER BY CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.UnitPrice 时间: 2024-01-23 16:27:10,090 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##2ff5b6b41fd04a36a89fdff43132eb13] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 16:27:10,579 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##e73302bc2829458e82909f9e73391a5b] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 16:27:10,581 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2ff5b6b41fd04a36a89fdff43132eb13] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e73302bc2829458e82909f9e73391a5b] 时间: 2024-01-23 16:27:10,663 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f4368f007a7d44c6bab9900de994d3d5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 16:27:10,666 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4368f007a7d44c6bab9900de994d3d5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 16:27:10,669 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f4368f007a7d44c6bab9900de994d3d5 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 = '退货' 时间: 2024-01-23 16:27:10,706 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4368f007a7d44c6bab9900de994d3d5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 16:27:10,708 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4368f007a7d44c6bab9900de994d3d5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 16:27:10,711 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2ff5b6b41fd04a36a89fdff43132eb13] (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 [##81959ecfb08c44f39665bfb3c00173bb] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 16:27:10,717 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[dea8088b-261f-4c44-970b-0684524e27b2] FROM ##2ff5b6b41fd04a36a89fdff43132eb13 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 W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.UnitPrice ORDER BY CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.UnitPrice 时间: 2024-01-23 16:30:05,063 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##68a8e1bc4bea438195c4f0c29f651dc0] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##68a8e1bc4bea438195c4f0c29f651dc0] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##959b926ed9694020bfd28bf342744ae9] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##68a8e1bc4bea438195c4f0c29f651dc0] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##68a8e1bc4bea438195c4f0c29f651dc0] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##959b926ed9694020bfd28bf342744ae9] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##68a8e1bc4bea438195c4f0c29f651dc0] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##68a8e1bc4bea438195c4f0c29f651dc0] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##959b926ed9694020bfd28bf342744ae9] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##68a8e1bc4bea438195c4f0c29f651dc0] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##959b926ed9694020bfd28bf342744ae9] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##68a8e1bc4bea438195c4f0c29f651dc0] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##68a8e1bc4bea438195c4f0c29f651dc0] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##959b926ed9694020bfd28bf342744ae9] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2024-01-23 16:30:05,640 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[10d8872b-f29b-4093-bdbf-7778a2151786] FROM [##68a8e1bc4bea438195c4f0c29f651dc0] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2024-01-23 16:30:51,410 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##f114e284a1a4421087b78d931b65b923] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##f114e284a1a4421087b78d931b65b923] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##9c2e2d0e8545443192b0008045bb4f5f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##f114e284a1a4421087b78d931b65b923] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##f114e284a1a4421087b78d931b65b923] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##9c2e2d0e8545443192b0008045bb4f5f] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##f114e284a1a4421087b78d931b65b923] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##f114e284a1a4421087b78d931b65b923] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##9c2e2d0e8545443192b0008045bb4f5f] WHERE Goods_No = A.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##f114e284a1a4421087b78d931b65b923] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 AND EXISTS (SELECT 1 FROM [##9c2e2d0e8545443192b0008045bb4f5f] WHERE Goods_No = R.Goods_No) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##f114e284a1a4421087b78d931b65b923] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##f114e284a1a4421087b78d931b65b923] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##9c2e2d0e8545443192b0008045bb4f5f] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2024-01-23 16:30:51,961 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[10d8872b-f29b-4093-bdbf-7778a2151786] FROM [##f114e284a1a4421087b78d931b65b923] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2024-01-23 17:33:23,774 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##4e22ac72a0cf4557979f745e0e6fa808] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 17:33:24,206 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##b7ae090424164bde84acbbc984c01bdb] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 17:33:24,208 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4e22ac72a0cf4557979f745e0e6fa808] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b7ae090424164bde84acbbc984c01bdb] 时间: 2024-01-23 17:33:24,274 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d5f55c957d264abdab53ef4122d0ff95 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 17:33:24,276 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5f55c957d264abdab53ef4122d0ff95 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 17:33:24,278 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d5f55c957d264abdab53ef4122d0ff95 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 = '退货' 时间: 2024-01-23 17:33:24,310 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5f55c957d264abdab53ef4122d0ff95 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 17:33:24,312 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5f55c957d264abdab53ef4122d0ff95 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 17:33:24,316 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4e22ac72a0cf4557979f745e0e6fa808] (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 [##33f2cc37e5f84b8f97391d13a29c689d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 17:33:24,321 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[b6c3ef32-a50e-461d-a896-2de52c1de090] FROM ##4e22ac72a0cf4557979f745e0e6fa808 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 18:21:54,711 线程ID: 22 日志级别: 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 [##b02f76d1ba4f4418bbb1455be0086f96] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 18:21:55,139 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a91c5aeb9756486b9991fb3490aafe2c] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 18:21:55,140 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b02f76d1ba4f4418bbb1455be0086f96] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a91c5aeb9756486b9991fb3490aafe2c] 时间: 2024-01-23 18:21:55,205 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5284865afb0945eca1116c0c3b6c42f9 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 18:21:55,207 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5284865afb0945eca1116c0c3b6c42f9 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 18:21:55,209 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5284865afb0945eca1116c0c3b6c42f9 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 = '退货' 时间: 2024-01-23 18:21:55,239 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5284865afb0945eca1116c0c3b6c42f9 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 18:21:55,241 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5284865afb0945eca1116c0c3b6c42f9 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 18:21:55,244 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b02f76d1ba4f4418bbb1455be0086f96] (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 [##114724e9477e44a9873141806ca5df50] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 18:21:55,249 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##b02f76d1ba4f4418bbb1455be0086f96 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 18:21:58,429 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##b12cbe5872244019a5434aeaa9ed3456] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 18:21:58,807 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fdebeac1b70e49aa8d98805c0428af1e] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 18:21:58,808 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b12cbe5872244019a5434aeaa9ed3456] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fdebeac1b70e49aa8d98805c0428af1e] 时间: 2024-01-23 18:21:58,865 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2928111083f94c3dbe610dfbc7b95d04 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 18:21:58,868 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2928111083f94c3dbe610dfbc7b95d04 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 18:21:58,870 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2928111083f94c3dbe610dfbc7b95d04 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 = '退货' 时间: 2024-01-23 18:21:58,900 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2928111083f94c3dbe610dfbc7b95d04 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 18:21:58,902 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2928111083f94c3dbe610dfbc7b95d04 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 18:21:58,906 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b12cbe5872244019a5434aeaa9ed3456] (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 [##64bace54a0624f2a95e50afca139f987] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 18:21:58,911 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[45376952-3953-40c3-a5a4-dd5ea88e6563] FROM ##b12cbe5872244019a5434aeaa9ed3456 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 18:25:07,990 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, VIP AS [卡号], Name AS [姓名], VipGrade AS [等级] ,MobileTel AS [手机], Sex AS [性别] ,BirthDate AS [出生日期], BegainDate AS [发卡日期], [Status] AS [状态] ,Customer_ID AS [发卡渠道], Abbrev AS [发卡渠道简称] ,Flag AS [作废], Posted AS [审核] INTO tempdb.dbo.[c6e4f3ee-87f7-47a6-8a34-c623e4b7cb84] FROM [##47d4000bd4824f219f53ac96ee6ad951] ORDER BY VIP 时间: 2024-01-23 18:25:11,541 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, VIP AS [卡号], Name AS [姓名], VipGrade AS [等级] ,MobileTel AS [手机], Sex AS [性别] ,BirthDate AS [出生日期], BegainDate AS [发卡日期], [Status] AS [状态] ,Customer_ID AS [发卡渠道], Abbrev AS [发卡渠道简称] ,Flag AS [作废], Posted AS [审核] INTO tempdb.dbo.[c6e4f3ee-87f7-47a6-8a34-c623e4b7cb84] FROM [##c44a18dee65c452baf7cc2dd24f14ab3] ORDER BY VIP 时间: 2024-01-23 19:10:32,059 线程ID: 59 日志级别: 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 [##8c8ff70bba6e4f7f865e43753facee47] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 19:10:32,593 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ee483630e38b4884bc37d609fa42441f] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 19:10:32,595 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8c8ff70bba6e4f7f865e43753facee47] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ee483630e38b4884bc37d609fa42441f] 时间: 2024-01-23 19:10:32,656 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##678604698047494baed9d26c9eafde63 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 19:10:32,658 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##678604698047494baed9d26c9eafde63 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 19:10:32,661 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##678604698047494baed9d26c9eafde63 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 = '退货' 时间: 2024-01-23 19:10:32,692 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##678604698047494baed9d26c9eafde63 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 19:10:32,694 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##678604698047494baed9d26c9eafde63 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 19:10:32,698 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8c8ff70bba6e4f7f865e43753facee47] (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 [##96e1c97a57904ee8887e8b97795f50c4] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 19:10:32,702 线程ID: 59 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[b94560bf-25b7-4af1-b850-3771c6d19b2c] FROM ##8c8ff70bba6e4f7f865e43753facee47 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2024-01-23 19:20:44,624 线程ID: 88 日志级别: 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 [##43056fff4f51494e862a1ef5ab6321ce] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-01-23 19:20:45,042 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a70c70b28497449fad1428dddfba1e20] where 2=2 and ISNULL(S1,0)=0 时间: 2024-01-23 19:20:45,045 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##43056fff4f51494e862a1ef5ab6321ce] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a70c70b28497449fad1428dddfba1e20] 时间: 2024-01-23 19:20:45,105 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8a9a7dc1cf4e4e8caafd654b045a6969 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-01-23 19:20:45,107 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8a9a7dc1cf4e4e8caafd654b045a6969 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-01-23 19:20:45,110 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8a9a7dc1cf4e4e8caafd654b045a6969 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 = '退货' 时间: 2024-01-23 19:20:45,137 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8a9a7dc1cf4e4e8caafd654b045a6969 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-01-23 19:20:45,139 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8a9a7dc1cf4e4e8caafd654b045a6969 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-01-23 19:20:45,143 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##43056fff4f51494e862a1ef5ab6321ce] (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 [##966d018d91244eb99468ace191a89f7f] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-01-23 19:20:45,148 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量] INTO tempdb.dbo.[b94560bf-25b7-4af1-b850-3771c6d19b2c] FROM ##43056fff4f51494e862a1ef5ab6321ce A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name