时间: 2024-11-25 10:03:07,993 线程ID: 21 日志级别: 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 [##1b595e1d424d400d9a24e9576345bafa] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 10:03:08,524 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##947cff43ec594cefb54df3cb6c5044f2] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 10:03:08,527 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1b595e1d424d400d9a24e9576345bafa] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##947cff43ec594cefb54df3cb6c5044f2] 时间: 2024-11-25 10:03:08,618 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3f4ca13240374135b5fb3f19b8b09144 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 10:03:08,620 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3f4ca13240374135b5fb3f19b8b09144 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 10:03:08,622 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3f4ca13240374135b5fb3f19b8b09144 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-11-25 10:03:08,676 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3f4ca13240374135b5fb3f19b8b09144 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 10:03:08,678 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3f4ca13240374135b5fb3f19b8b09144 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 10:03:08,682 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1b595e1d424d400d9a24e9576345bafa] (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 [##13e9cc41f61042d6b9fe6699a0fd7e6b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 10:03:08,702 线程ID: 21 日志级别: 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.[2e0e67b9-fc80-42fa-afa3-29ea14b6dcb6] FROM ##1b595e1d424d400d9a24e9576345bafa 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-11-25 11:40:50,267 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Warehouse_No, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , CAST(C.[S1] AS INT) AS [期初库存#S1], CAST(NULL AS INT) AS [期初库存#数量] , CAST(C.[S1] AS INT) AS [厂家来货#S1], CAST(NULL AS INT) AS [厂家来货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [厂家来货#金额] , CAST(C.[S1] AS INT) AS [采购退货#S1], CAST(NULL AS INT) AS [采购退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [采购退货#金额] , CAST(C.[S1] AS INT) AS [净收货#S1], CAST(NULL AS INT) AS [净收货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [净收货#金额] , CAST(C.[S1] AS INT) AS [仓库调出#S1], CAST(NULL AS INT) AS [仓库调出#数量] , CAST(C.[S1] AS INT) AS [仓库调入#S1], CAST(NULL AS INT) AS [仓库调入#数量] , CAST(C.[S1] AS INT) AS [仓库损益#S1], CAST(NULL AS INT) AS [仓库损益#数量] , CAST(C.[S1] AS INT) AS [仓库出货#批发#线上#S1], CAST(NULL AS INT) AS [仓库出货#批发#线上#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#批发#线上#金额] , CAST(C.[S1] AS INT) AS [仓库出货#批发#线下#S1], CAST(NULL AS INT) AS [仓库出货#批发#线下#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#批发#线下#金额] , CAST(C.[S1] AS INT) AS [仓库出货#零售#线上#S1], CAST(NULL AS INT) AS [仓库出货#零售#线上#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#零售#线上#金额] , CAST(C.[S1] AS INT) AS [仓库出货#零售#线下#S1], CAST(NULL AS INT) AS [仓库出货#零售#线下#数量], CAST(NULL AS NUMERIC(15, 2)) AS [仓库出货#零售#线下#金额] , CAST(C.[S1] AS INT) AS [累计出货#S1], CAST(NULL AS INT) AS [累计出货#数量] , CAST(C.[S1] AS INT) AS [收退货#批发#S1], CAST(NULL AS INT) AS [收退货#批发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [收退货#批发#金额] , CAST(C.[S1] AS INT) AS [收退货#零售#S1], CAST(NULL AS INT) AS [收退货#零售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [收退货#零售#金额] , CAST(C.[S1] AS INT) AS [包装#拆分#S1], CAST(NULL AS INT) AS [包装#拆分#数量] , CAST(C.[S1] AS INT) AS [包装#组成#S1], CAST(NULL AS INT) AS [包装#组成#数量] , CAST(C.[S1] AS INT) AS [期末库存#S1], CAST(NULL AS INT) AS [期末库存#数量] , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS [在途库存#数量] , CAST(NULL AS Datetime) AS [首次入库日期] , CAST(NULL AS Datetime) AS [末次入库日期] , CAST(NULL AS Datetime) AS [首次出货日期] , CAST(NULL AS Datetime) AS [末次出货日期] , CAST(NULL AS Datetime) AS [第一次到货日期] INTO [##e2be1d4520ff41b9954e16a7453ce2b3] FROM Warehouse A, Barcode B, DeliveryDetail C 时间: 2024-11-25 11:40:50,545 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9e693a2d209649588c42f3b9e2a99c30] 时间: 2024-11-25 11:40:50,630 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [厂家来货#S1], 厂家来货#数量, 厂家来货#金额, 首次入库日期, 末次入库日期) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次入库日期, 末次入库日期 FROM [##bea47a64e73743859ff9ecb872bc0719] 时间: 2024-11-25 11:40:50,762 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, 第一次到货日期) SELECT Warehouse_No, Goods_No, ColorID, Long, 第一次到货日期 FROM [##391b22424dce4908b82cc7f7c58fc9db] 时间: 2024-11-25 11:40:50,811 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [采购退货#S1], 采购退货#数量, 采购退货#金额) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##379cd38a572749358166a65407f7bd3e] 时间: 2024-11-25 11:40:50,899 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库调入#S1], 仓库调入#数量) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e5e511a0c63041668390407c499190ef] 时间: 2024-11-25 11:40:50,999 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [收退货#批发#S1], [收退货#批发#数量], [收退货#批发#金额]) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##72349ebb987048c4b8aac548af2a1f8c] 时间: 2024-11-25 11:40:51,085 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [收退货#零售#S1], [收退货#零售#数量], [收退货#零售#金额]) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##41aa4689564143058c57e57070844a61] 时间: 2024-11-25 11:40:51,205 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#批发#线上#S1], [仓库出货#批发#线上#数量], [仓库出货#批发#线上#金额], 首次出货日期, 末次出货日期) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期 FROM [##2dc8fdaf33b248df980d7d2b48884fd5] 时间: 2024-11-25 11:40:51,347 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#批发#线下#S1], [仓库出货#批发#线下#数量], [仓库出货#批发#线下#金额], 首次出货日期, 末次出货日期) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期 FROM [##20428feecbaf42ef84d498a857b8e32a] 时间: 2024-11-25 11:40:51,443 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#零售#线上#S1], [仓库出货#零售#线上#数量], [仓库出货#零售#线上#金额], 首次出货日期, 末次出货日期) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期 FROM [##b74084b8b0ce4cca9afb7c05fa499bb4] 时间: 2024-11-25 11:40:51,543 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库出货#零售#线下#S1], [仓库出货#零售#线下#数量], [仓库出货#零售#线下#金额], 首次出货日期, 末次出货日期) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount, 首次出货日期, 末次出货日期 FROM [##9e3d2425a1444b5b992577c145731353] 时间: 2024-11-25 11:40:51,637 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [累计出货#S1], [累计出货#数量]) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##87a613e1157246ea85ec0f2c7a984721] 时间: 2024-11-25 11:40:51,752 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库调出#S1], 仓库调出#数量) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d4d5698eb7c641609eb6f75eb28e275c] 时间: 2024-11-25 11:40:51,864 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [仓库损益#S1], 仓库损益#数量) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b1949a7a38024aefab1db2a84c5e30d0] 时间: 2024-11-25 11:40:51,908 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [包装#拆分#S1], 包装#拆分#数量) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2a9a899228c54eb8905b6d7df0ed65e4] 时间: 2024-11-25 11:40:51,950 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [包装#组成#S1], 包装#组成#数量) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3da22eaff9ae4361a4db512cde06425d] 时间: 2024-11-25 11:40:52,723 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2be1d4520ff41b9954e16a7453ce2b3] (Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], [在途库存#数量]) SELECT Warehouse_No, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c46e6f466157438096d8e69d71e04a91] 时间: 2024-11-25 11:40:52,742 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e2be1d4520ff41b9954e16a7453ce2b3] SET 净收货#数量 = ISNULL(厂家来货#数量,0) - ISNULL(采购退货#数量,0), 净收货#金额 = ISNULL(厂家来货#金额,0) - ISNULL(采购退货#金额,0), [净收货#S1] = ISNULL([厂家来货#S1], 0) - ISNULL([采购退货#S1], 0) 时间: 2024-11-25 11:40:52,745 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e2be1d4520ff41b9954e16a7453ce2b3] SET 期末库存#数量 = ISNULL(期初库存#数量,0) + ISNULL(厂家来货#数量,0) + ISNULL(仓库调入#数量,0) + ISNULL(收退货#批发#数量,0) + ISNULL(收退货#零售#数量,0) - ISNULL(仓库出货#批发#线上#数量,0) - ISNULL(仓库出货#批发#线下#数量,0) - ISNULL(仓库出货#零售#线上#数量,0) - ISNULL(仓库出货#零售#线下#数量,0) - ISNULL(仓库调出#数量,0) - ISNULL(采购退货#数量,0) - ISNULL(仓库损益#数量,0) - ISNULL(包装#拆分#数量,0) + ISNULL(包装#组成#数量,0), [期末库存#S1] = ISNULL([期初库存#S1], 0) + ISNULL(厂家来货#S1,0) + ISNULL(仓库调入#S1,0) + ISNULL(收退货#批发#S1,0) + ISNULL(收退货#零售#S1,0) - ISNULL(仓库出货#批发#线上#S1,0) - ISNULL(仓库出货#批发#线下#S1,0) - ISNULL(仓库出货#零售#线上#S1,0) - ISNULL(仓库出货#零售#线下#S1,0) - ISNULL(仓库调出#S1,0) - ISNULL(采购退货#S1,0) - ISNULL(仓库损益#S1,0) - ISNULL(包装#拆分#S1,0) + ISNULL(包装#组成#S1,0) 时间: 2024-11-25 11:40:52,749 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Warehouse_No AS [仓库编号], W.Warehouse_Na AS [仓库名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Long AS [内长], SUM([期初库存#S1]) AS [期初库存#S1], SUM([期初库存#数量]) AS [期初库存#数量], SUM([期初库存#数量] * GS.UnitPrice) AS [期初库存#吊牌额], SUM([厂家来货#S1]) AS [厂家来货#S1], SUM([厂家来货#数量]) AS [厂家来货#数量], SUM([厂家来货#数量] * GS.UnitPrice) AS [厂家来货#吊牌额], SUM([厂家来货#金额]) AS [厂家来货#金额], SUM([采购退货#S1]) AS [采购退货#S1], SUM([采购退货#数量]) AS [采购退货#数量], SUM([采购退货#数量] * GS.UnitPrice) AS [采购退货#吊牌额], SUM([采购退货#金额]) AS [采购退货#金额], SUM([净收货#S1]) AS [净收货#S1], SUM([净收货#数量]) AS [净收货#数量], SUM([净收货#数量] * GS.UnitPrice) AS [净收货#吊牌额], SUM([净收货#金额]) AS [净收货#金额], SUM([仓库调出#S1]) AS [仓库调出#S1], SUM([仓库调出#数量]) AS [仓库调出#数量], SUM([仓库调出#数量] * GS.UnitPrice) AS [仓库调出#吊牌额], SUM([仓库调入#S1]) AS [仓库调入#S1], SUM([仓库调入#数量]) AS [仓库调入#数量], SUM([仓库调入#数量] * GS.UnitPrice) AS [仓库调入#吊牌额], SUM([仓库损益#S1]) AS [仓库损益#S1], SUM([仓库损益#数量]) AS [仓库损益#数量], SUM([仓库损益#数量] * GS.UnitPrice) AS [仓库损益#吊牌额], SUM([仓库出货#批发#线上#S1]) AS [仓库出货#批发#线上#S1], SUM([仓库出货#批发#线上#数量]) AS [仓库出货#批发#线上#数量], SUM([仓库出货#批发#线上#数量] * GS.UnitPrice) AS [仓库出货#批发#线上#吊牌额], SUM([仓库出货#批发#线上#金额]) AS [仓库出货#批发#线上#金额], SUM([仓库出货#批发#线下#S1]) AS [仓库出货#批发#线下#S1], SUM([仓库出货#批发#线下#数量]) AS [仓库出货#批发#线下#数量], SUM([仓库出货#批发#线下#数量] * GS.UnitPrice) AS [仓库出货#批发#线下#吊牌额], SUM([仓库出货#批发#线下#金额]) AS [仓库出货#批发#线下#金额], SUM([仓库出货#零售#线上#S1]) AS [仓库出货#零售#线上#S1], SUM([仓库出货#零售#线上#数量]) AS [仓库出货#零售#线上#数量], SUM([仓库出货#零售#线上#数量] * GS.UnitPrice) AS [仓库出货#零售#线上#吊牌额], SUM([仓库出货#零售#线上#金额]) AS [仓库出货#零售#线上#金额], SUM([仓库出货#零售#线下#S1]) AS [仓库出货#零售#线下#S1], SUM([仓库出货#零售#线下#数量]) AS [仓库出货#零售#线下#数量], SUM([仓库出货#零售#线下#数量] * GS.UnitPrice) AS [仓库出货#零售#线下#吊牌额], SUM([仓库出货#零售#线下#金额]) AS [仓库出货#零售#线下#金额], SUM([累计出货#S1]) AS [累计出货#S1], SUM([累计出货#数量]) AS [累计出货#数量], SUM([累计出货#数量] * GS.UnitPrice) AS [累计出货#吊牌额], SUM([收退货#批发#S1]) AS [收退货#批发#S1], SUM([收退货#批发#数量]) AS [收退货#批发#数量], SUM([收退货#批发#数量] * GS.UnitPrice) AS [收退货#批发#吊牌额], SUM([收退货#批发#金额]) AS [收退货#批发#金额], SUM([收退货#零售#S1]) AS [收退货#零售#S1], SUM([收退货#零售#数量]) AS [收退货#零售#数量], SUM([收退货#零售#数量] * GS.UnitPrice) AS [收退货#零售#吊牌额], SUM([收退货#零售#金额]) AS [收退货#零售#金额], SUM([包装#拆分#S1]) AS [包装#拆分#S1], SUM([包装#拆分#数量]) AS [包装#拆分#数量], SUM([包装#拆分#数量] * GS.UnitPrice) AS [包装#拆分#吊牌额], SUM([包装#组成#S1]) AS [包装#组成#S1], SUM([包装#组成#数量]) AS [包装#组成#数量], SUM([包装#组成#数量] * GS.UnitPrice) AS [包装#组成#吊牌额], SUM([期末库存#S1]) AS [期末库存#S1], SUM([期末库存#数量]) AS [期末库存#数量], SUM([期末库存#数量] * GS.UnitPrice) AS [期末库存#吊牌额], SUM([在途库存#S1]) AS [在途库存#S1], SUM([在途库存#数量]) AS [在途库存#数量], SUM([在途库存#数量] * GS.UnitPrice) AS [在途库存#吊牌额], ISNULL(SUM([期末库存#数量]),0)+ ISNULL(SUM([在途库存#数量]),0) AS [库存合计], convert(varchar,min(首次入库日期),23) + '--' + convert(varchar,min(末次入库日期),23) AS [入库时间段], convert(varchar,min(首次出货日期),23) + '--' + convert(varchar,min(末次出货日期),23) AS [发货时间段], convert(varchar,min(第一次到货日期),23) AS [第一次到货日期], GS.UnitPrice AS [吊牌价], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[9142ed97-e8e6-434e-a306-a6fdaa132724] FROM [##e2be1d4520ff41b9954e16a7453ce2b3] A INNER JOIN Warehouse W ON A.Warehouse_No = W.Warehouse_No INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID GROUP BY A.Warehouse_No, W.Warehouse_Na, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Long, GS.UnitPrice HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([厂家来货#S1]), 0) <> 0) OR (ISNULL(SUM([采购退货#S1]), 0) <> 0) OR (ISNULL(SUM([仓库调出#S1]), 0) <> 0) OR (ISNULL(SUM([仓库调入#S1]), 0) <> 0) OR (ISNULL(SUM([仓库损益#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#批发#线上#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#批发#线下#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#零售#线上#S1]), 0) <> 0) OR (ISNULL(SUM([仓库出货#零售#线下#S1]), 0) <> 0) OR (ISNULL(SUM([累计出货#S1]), 0) <> 0) OR (ISNULL(SUM([收退货#批发#S1]), 0) <> 0) OR (ISNULL(SUM([收退货#零售#S1]), 0) <> 0) OR (ISNULL(SUM([包装#拆分#S1]), 0) <> 0) OR (ISNULL(SUM([包装#组成#S1]), 0) <> 0) OR (ISNULL(SUM([在途库存#S1]), 0) <> 0) ORDER BY A.Warehouse_No, W.Warehouse_Na, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Long, GS.UnitPrice 时间: 2024-11-25 11:46:59,874 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##3707f60337a447ff804b8d2fa29d5487] FROM [##5cd40f858cfe43e2b8c4e648bc66cee3] 时间: 2024-11-25 11:46:59,879 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No INTO [##7bb2ded634064e76ac3a72b1c784af1c] FROM [##5cd40f858cfe43e2b8c4e648bc66cee3] 时间: 2024-11-25 11:46:59,947 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET UnitPrice = ISNULL(B.Price, GDP.DpPriceByRetail) FROM [##5cd40f858cfe43e2b8c4e648bc66cee3] A LEFT JOIN [##bc1ce25326bb49f581af17f2f03ecb86] B ON A.Customer_ID = B.Customer_ID AND A.Goods_No = B.Goods_No INNER JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No 时间: 2024-11-25 11:46:59,956 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##e4aa9d63d42e43f6846743db017e7235] FROM [##5cd40f858cfe43e2b8c4e648bc66cee3] 时间: 2024-11-25 11:46:59,958 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No, [ColorID] AS ColorID INTO [##adcbdc98b9234f91b64ce70a6b7d5547] FROM [##5cd40f858cfe43e2b8c4e648bc66cee3] 时间: 2024-11-25 11:47:00,013 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET UnitPrice = B.Price FROM [##5cd40f858cfe43e2b8c4e648bc66cee3] A INNER JOIN [##d43f555c2d91429dabc4646d522e7758] B ON A.CUSTOMER_ID = B.Customer_ID AND A.Goods_No = B.Goods_No AND A.ColorID = B.ColorID 时间: 2024-11-25 11:47:00,019 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.DealeReturnID AS [单号], A.Manual_ID AS [手工单号], CONVERT(VARCHAR(10), A.Return_Date, 120) AS [单据日期], A.Warehouse_No AS [仓库编号], W.Warehouse_Na AS [仓库名称], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.RenoticeID AS [退货通知单], A.Name AS [营业员], CONVERT(VARCHAR(20), A.Input_Date, 120) AS [录入日期], A.Operator AS [制单人], RO.UserName AS [制单人名称], A.Posted AS [审核], CONVERT(VARCHAR(20), A.PostedDate, 120) AS [审核日期], A.PostUser AS [审核人], RP.UserName AS [审核人名称], A.JiZhang AS [记账], CONVERT(VARCHAR(20), A.JiZhangDate, 120) AS [记账日期], A.JiZhangOperator AS [记账人], RJ.UserName AS [记账人名称], A.SaleMan AS [业务员], CAST(A.Remark AS VarChar(MAX)) AS [备注], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Explain AS [说明], A.Long AS [内长], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量], GDP.DpPriceByRetail AS [渠道吊牌价], SUM(A.Quantity * GDP.DpPriceByRetail) AS [渠道吊牌额], A.UnitPrice AS [零售价], SUM(A.Quantity * ISNULL(A.[UnitPrice],0) ) AS [零售额], A.BalancePrice AS [结算价], SUM(A.Quantity * ISNULL(A.[BalancePrice],0) ) AS [结算额], CONVERT(Numeric(18,4),CASE WHEN IsNULL(SUM(GDP.DpPriceByRetail),0)<>0 THEN IsNull(SUM(A.BalancePrice),0)/IsNull(SUM(GDP.DpPriceByRetail),0) ELSE 0 END) AS [结算折扣], SPA.Consignee AS [发货信息-收货人], SPA.Mobile AS [发货信息-电话], SPA.TransportCompany AS [发货信息-货运公司], SPA.PaymentMode AS [发货信息-付款方式], SPA.TransportNo AS [发货信息-物流单号], SPA.ConsigneeAddress AS [发货信息-收货地址], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[eb722974-bcdf-41d2-84f5-2ee0bfa3f185] FROM ##5cd40f858cfe43e2b8c4e648bc66cee3 A INNER JOIN Goods GS on GS.Goods_No=a.Goods_No INNER JOIN Warehouse W on W.Warehouse_No=A.Warehouse_No INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN ShopReturnAddress SPA ON SPA.DealereturnID = A.DealereturnID LEFT JOIN [Right] RO ON A.Operator = RO.UserNo LEFT JOIN [Right] RP ON A.PostUser = RP.UserNo LEFT JOIN [Right] RJ ON A.JiZhangOperator = RJ.UserNo LEFT JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No GROUP BY A.DealeReturnID, A.Manual_ID, CONVERT(VARCHAR(10), A.Return_Date, 120), A.Warehouse_No, W.Warehouse_Na, A.Customer_ID, CT.Abbrev, A.RenoticeID, A.Name, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Operator, RO.UserName, A.Posted, CONVERT(VARCHAR(20), A.PostedDate, 120), A.PostUser, RP.UserName, A.JiZhang, CONVERT(VARCHAR(20), A.JiZhangDate, 120), A.JiZhangOperator, RJ.UserName, A.SaleMan, CAST(A.Remark AS VarChar(MAX)), A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Explain, A.Long, GDP.DpPriceByRetail, A.UnitPrice, A.BalancePrice, SPA.Consignee, SPA.Mobile, SPA.TransportCompany, SPA.PaymentMode, SPA.TransportNo, SPA.ConsigneeAddress ORDER BY A.DealeReturnID, A.Manual_ID, CONVERT(VARCHAR(10), A.Return_Date, 120), A.Warehouse_No, W.Warehouse_Na, A.Customer_ID, CT.Abbrev, A.RenoticeID, A.Name, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Operator, RO.UserName, A.Posted, CONVERT(VARCHAR(20), A.PostedDate, 120), A.PostUser, RP.UserName, A.JiZhang, CONVERT(VARCHAR(20), A.JiZhangDate, 120), A.JiZhangOperator, RJ.UserName, A.SaleMan, CAST(A.Remark AS VarChar(MAX)), A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Explain, A.Long, GDP.DpPriceByRetail, A.UnitPrice, A.BalancePrice, SPA.Consignee, SPA.Mobile, SPA.TransportCompany, SPA.PaymentMode, SPA.TransportNo, SPA.ConsigneeAddress 时间: 2024-11-25 11:47:07,301 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##e43e96042d4c4e2ca37f39562ae33851] FROM [##32a1c963f992490d9b29fc8286dda867] 时间: 2024-11-25 11:47:07,304 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No INTO [##ef1cf92364bd497aa1908640bfa0804a] FROM [##32a1c963f992490d9b29fc8286dda867] 时间: 2024-11-25 11:47:07,365 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET UnitPrice = ISNULL(B.Price, GDP.DpPriceByRetail) FROM [##32a1c963f992490d9b29fc8286dda867] A LEFT JOIN [##7a68a29378fa4609ab0bb4d79334a625] B ON A.Customer_ID = B.Customer_ID AND A.Goods_No = B.Goods_No INNER JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No 时间: 2024-11-25 11:47:07,374 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##c50e7d48b59b4721a5183c1c30fabe76] FROM [##32a1c963f992490d9b29fc8286dda867] 时间: 2024-11-25 11:47:07,377 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No, [ColorID] AS ColorID INTO [##cb4cdefbcb44419db8627603ce86bf06] FROM [##32a1c963f992490d9b29fc8286dda867] 时间: 2024-11-25 11:47:07,422 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET UnitPrice = B.Price FROM [##32a1c963f992490d9b29fc8286dda867] A INNER JOIN [##f1469c9813714521bdcc2a6279b8c432] B ON A.CUSTOMER_ID = B.Customer_ID AND A.Goods_No = B.Goods_No AND A.ColorID = B.ColorID 时间: 2024-11-25 11:47:07,427 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.DealeReturnID AS [单号], A.Manual_ID AS [手工单号], CONVERT(VARCHAR(10), A.Return_Date, 120) AS [单据日期], A.Warehouse_No AS [仓库编号], W.Warehouse_Na AS [仓库名称], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.RenoticeID AS [退货通知单], A.Name AS [营业员], CONVERT(VARCHAR(20), A.Input_Date, 120) AS [录入日期], A.Operator AS [制单人], RO.UserName AS [制单人名称], A.Posted AS [审核], CONVERT(VARCHAR(20), A.PostedDate, 120) AS [审核日期], A.PostUser AS [审核人], RP.UserName AS [审核人名称], A.JiZhang AS [记账], CONVERT(VARCHAR(20), A.JiZhangDate, 120) AS [记账日期], A.JiZhangOperator AS [记账人], RJ.UserName AS [记账人名称], A.SaleMan AS [业务员], CAST(A.Remark AS VarChar(MAX)) AS [备注], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Explain AS [说明], A.Long AS [内长], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量], GDP.DpPriceByRetail AS [渠道吊牌价], SUM(A.Quantity * GDP.DpPriceByRetail) AS [渠道吊牌额], A.UnitPrice AS [零售价], SUM(A.Quantity * ISNULL(A.[UnitPrice],0) ) AS [零售额], A.BalancePrice AS [结算价], SUM(A.Quantity * ISNULL(A.[BalancePrice],0) ) AS [结算额], CONVERT(Numeric(18,4),CASE WHEN IsNULL(SUM(GDP.DpPriceByRetail),0)<>0 THEN IsNull(SUM(A.BalancePrice),0)/IsNull(SUM(GDP.DpPriceByRetail),0) ELSE 0 END) AS [结算折扣], SPA.Consignee AS [发货信息-收货人], SPA.Mobile AS [发货信息-电话], SPA.TransportCompany AS [发货信息-货运公司], SPA.PaymentMode AS [发货信息-付款方式], SPA.TransportNo AS [发货信息-物流单号], SPA.ConsigneeAddress AS [发货信息-收货地址], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[eb722974-bcdf-41d2-84f5-2ee0bfa3f185] FROM ##32a1c963f992490d9b29fc8286dda867 A INNER JOIN Goods GS on GS.Goods_No=a.Goods_No INNER JOIN Warehouse W on W.Warehouse_No=A.Warehouse_No INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN ShopReturnAddress SPA ON SPA.DealereturnID = A.DealereturnID LEFT JOIN [Right] RO ON A.Operator = RO.UserNo LEFT JOIN [Right] RP ON A.PostUser = RP.UserNo LEFT JOIN [Right] RJ ON A.JiZhangOperator = RJ.UserNo LEFT JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No GROUP BY A.DealeReturnID, A.Manual_ID, CONVERT(VARCHAR(10), A.Return_Date, 120), A.Warehouse_No, W.Warehouse_Na, A.Customer_ID, CT.Abbrev, A.RenoticeID, A.Name, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Operator, RO.UserName, A.Posted, CONVERT(VARCHAR(20), A.PostedDate, 120), A.PostUser, RP.UserName, A.JiZhang, CONVERT(VARCHAR(20), A.JiZhangDate, 120), A.JiZhangOperator, RJ.UserName, A.SaleMan, CAST(A.Remark AS VarChar(MAX)), A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Explain, A.Long, GDP.DpPriceByRetail, A.UnitPrice, A.BalancePrice, SPA.Consignee, SPA.Mobile, SPA.TransportCompany, SPA.PaymentMode, SPA.TransportNo, SPA.ConsigneeAddress ORDER BY A.DealeReturnID, A.Manual_ID, CONVERT(VARCHAR(10), A.Return_Date, 120), A.Warehouse_No, W.Warehouse_Na, A.Customer_ID, CT.Abbrev, A.RenoticeID, A.Name, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Operator, RO.UserName, A.Posted, CONVERT(VARCHAR(20), A.PostedDate, 120), A.PostUser, RP.UserName, A.JiZhang, CONVERT(VARCHAR(20), A.JiZhangDate, 120), A.JiZhangOperator, RJ.UserName, A.SaleMan, CAST(A.Remark AS VarChar(MAX)), A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Explain, A.Long, GDP.DpPriceByRetail, A.UnitPrice, A.BalancePrice, SPA.Consignee, SPA.Mobile, SPA.TransportCompany, SPA.PaymentMode, SPA.TransportNo, SPA.ConsigneeAddress 时间: 2024-11-25 11:47:27,599 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##bc5a4aa2ab3541e0b10772b39c74c875] FROM [##487d60a983e34f25ac15a656f7ba3196] 时间: 2024-11-25 11:47:27,602 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No INTO [##bb4f42cc56364e41adccc18871d3d641] FROM [##487d60a983e34f25ac15a656f7ba3196] 时间: 2024-11-25 11:47:27,674 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET UnitPrice = ISNULL(B.Price, GDP.DpPriceByRetail) FROM [##487d60a983e34f25ac15a656f7ba3196] A LEFT JOIN [##fc81da8034694b7a97a85a8281fede55] B ON A.Customer_ID = B.Customer_ID AND A.Goods_No = B.Goods_No INNER JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No 时间: 2024-11-25 11:47:27,685 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##47c36479eeff48a5940d36b48d7f6ad0] FROM [##487d60a983e34f25ac15a656f7ba3196] 时间: 2024-11-25 11:47:27,687 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No, [ColorID] AS ColorID INTO [##f67f019354cc4de78fd7d7951124f7d0] FROM [##487d60a983e34f25ac15a656f7ba3196] 时间: 2024-11-25 11:47:27,734 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET UnitPrice = B.Price FROM [##487d60a983e34f25ac15a656f7ba3196] A INNER JOIN [##7e6ded7de29a445eb261fb4bdd41320d] B ON A.CUSTOMER_ID = B.Customer_ID AND A.Goods_No = B.Goods_No AND A.ColorID = B.ColorID 时间: 2024-11-25 11:47:27,740 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.DealeReturnID AS [单号], A.Manual_ID AS [手工单号], CONVERT(VARCHAR(10), A.Return_Date, 120) AS [单据日期], A.Warehouse_No AS [仓库编号], W.Warehouse_Na AS [仓库名称], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.RenoticeID AS [退货通知单], A.Name AS [营业员], CONVERT(VARCHAR(20), A.Input_Date, 120) AS [录入日期], A.Operator AS [制单人], RO.UserName AS [制单人名称], A.Posted AS [审核], CONVERT(VARCHAR(20), A.PostedDate, 120) AS [审核日期], A.PostUser AS [审核人], RP.UserName AS [审核人名称], A.JiZhang AS [记账], CONVERT(VARCHAR(20), A.JiZhangDate, 120) AS [记账日期], A.JiZhangOperator AS [记账人], RJ.UserName AS [记账人名称], A.SaleMan AS [业务员], CAST(A.Remark AS VarChar(MAX)) AS [备注], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Explain AS [说明], A.Long AS [内长], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量], GDP.DpPriceByRetail AS [渠道吊牌价], SUM(A.Quantity * GDP.DpPriceByRetail) AS [渠道吊牌额], A.UnitPrice AS [零售价], SUM(A.Quantity * ISNULL(A.[UnitPrice],0) ) AS [零售额], A.BalancePrice AS [结算价], SUM(A.Quantity * ISNULL(A.[BalancePrice],0) ) AS [结算额], CONVERT(Numeric(18,4),CASE WHEN IsNULL(SUM(GDP.DpPriceByRetail),0)<>0 THEN IsNull(SUM(A.BalancePrice),0)/IsNull(SUM(GDP.DpPriceByRetail),0) ELSE 0 END) AS [结算折扣], SPA.Consignee AS [发货信息-收货人], SPA.Mobile AS [发货信息-电话], SPA.TransportCompany AS [发货信息-货运公司], SPA.PaymentMode AS [发货信息-付款方式], SPA.TransportNo AS [发货信息-物流单号], SPA.ConsigneeAddress AS [发货信息-收货地址], CAST(NULL AS IMAGE) AS [图片], W.Address AS [仓库地址], W.Tele AS [仓库电话], W.Zipcode AS [仓库邮编], W.KeyMan AS [仓库联系人], W.E_mail AS [仓库电子邮件], W.Fax AS [仓库传真], W.Region AS [仓库区域], W.AllowMinusStock AS [仓库是否允许负库存], W.Tag AS [仓库是否为虚拟仓], W.Company_ID AS [仓库公司编号], dbo.GetCompanyAbvByID(W.Company_ID) AS [仓库公司简称], dbo.GetCompanyNameByID(W.Company_ID) AS [仓库公司名称], W.ChannelID AS [仓库上级渠道], W.AccountCustomer_ID AS [仓库应收归集户口], W.Custom1 AS [仓库自定义1], W.Custom2 AS [仓库自定义2], W.Custom3 AS [仓库自定义3], W.Custom4 AS [仓库自定义4], W.Custom5 AS [仓库自定义5], W.Custom6 AS [仓库自定义6], W.Custom7 AS [仓库自定义7], W.Custom8 AS [仓库自定义8], W.Custom9 AS [仓库自定义9], W.Custom10 AS [仓库自定义10], W.Custom11 AS [仓库自定义11], W.Custom12 AS [仓库自定义12], W.Custom13 AS [仓库自定义13], W.Custom14 AS [仓库自定义14], W.Custom15 AS [仓库自定义15], W.Custom16 AS [仓库自定义16], W.Custom17 AS [仓库自定义17], W.Custom18 AS [仓库自定义18], W.Custom19 AS [仓库自定义19], W.Custom20 AS [仓库自定义20], GS.HelpRemember AS [助记码], GS.Brand AS [品牌], GS.Category AS [类别], GS.Category2 AS [二级类别], GS.Range AS [系列], GS.Pattern AS [款型], GS.Item AS [项目], GS.Authorisation AS [授权], GS.Sex AS [性别], GS.Season AS [季节], GS.Year AS [年份], GS.Property AS [属性], GS.XingZhi AS [性质], GS.Unit AS [单位], CONVERT(VARCHAR(10),GS.NewOld,120) AS [上货日期], GS.Designer AS [设计师], GS.Material AS [面料], GS.Material1 AS [面料1], GS.Material2 AS [面料2], GS.Material3 AS [面料3], GS.InsideMaterial AS [里料成份], GS.FillMaterial AS [填充成份], GS.GoodsDate AS [货期], GS.ReturnCycle AS [回货周期], GS.EstimatedDeliveryDate AS [过季时间], GS.Manufacturer AS [厂家编号], GS.ProducingArea AS [产地], GS.Executestandard AS [执行标准], GS.Reserve1 AS [折扣类别], GS.Reserve2 AS [换货类别], GS.Reserve3 AS [客户], GS.Reserve4 AS [保留字段4], GS.SafeCategory AS [安全类别], GS.ListingBand AS [上市波段], GS.Size_class AS [尺码类别], GS.SizeTypeID AS [号型编号], GS.Input_Date AS [货品录入日期], GS.Definition1 AS [新品日期], GS.Definition2 AS [自定义2], GS.Definition3 AS [自定义3], GS.Definition4 AS [自定义4], GS.Definition5 AS [自定义5], GS.Definition6 AS [自定义6], GS.Definition7 AS [自定义7], GS.Definition8 AS [自定义8], GS.Definition9 AS [自定义9], GS.Definition10 AS [自定义10], GS.Definition11 AS [自定义11], GS.Definition12 AS [自定义12], GS.Definition13 AS [自定义13], GS.Definition14 AS [自定义14], GS.Definition15 AS [自定义15], GS.Definition16 AS [自定义16], GS.Definition17 AS [自定义17], GS.Definition18 AS [自定义18], GS.Definition19 AS [自定义19], GS.Definition20 AS [自定义20], GS.GoodsRemark AS [货品备注], GS.WholeSalePrice AS [进货价], dbo.[GetPriceSegmentByPrice](GS.UnitPrice) AS [价格段], GS.UnitPrice AS [吊牌价], GS.DpPrice2 AS [吊牌价2], GS.DpPrice3 AS [吊牌价3], GS.DpPrice4 AS [吊牌价4], GS.DpPrice5 AS [吊牌价5], GS.DpPrice6 AS [吊牌价6], GS.DpPrice7 AS [吊牌价7], GS.DpPrice8 AS [吊牌价8], GS.DpPrice9 AS [吊牌价9], GS.DpPrice10 AS [吊牌价10], GS.DpPrice11 AS [吊牌价11], GS.DpPrice12 AS [吊牌价12] INTO tempdb.dbo.[eb722974-bcdf-41d2-84f5-2ee0bfa3f185] FROM ##487d60a983e34f25ac15a656f7ba3196 A INNER JOIN Goods GS on GS.Goods_No=a.Goods_No INNER JOIN Warehouse W on W.Warehouse_No=A.Warehouse_No INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID LEFT JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN ShopReturnAddress SPA ON SPA.DealereturnID = A.DealereturnID LEFT JOIN [Right] RO ON A.Operator = RO.UserNo LEFT JOIN [Right] RP ON A.PostUser = RP.UserNo LEFT JOIN [Right] RJ ON A.JiZhangOperator = RJ.UserNo LEFT JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No GROUP BY A.DealeReturnID, A.Manual_ID, CONVERT(VARCHAR(10), A.Return_Date, 120), A.Warehouse_No, W.Warehouse_Na, A.Customer_ID, CT.Abbrev, A.RenoticeID, A.Name, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Operator, RO.UserName, A.Posted, CONVERT(VARCHAR(20), A.PostedDate, 120), A.PostUser, RP.UserName, A.JiZhang, CONVERT(VARCHAR(20), A.JiZhangDate, 120), A.JiZhangOperator, RJ.UserName, A.SaleMan, CAST(A.Remark AS VarChar(MAX)), A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Explain, A.Long, GDP.DpPriceByRetail, A.UnitPrice, A.BalancePrice, SPA.Consignee, SPA.Mobile, SPA.TransportCompany, SPA.PaymentMode, SPA.TransportNo, SPA.ConsigneeAddress, W.Address, W.Tele, W.Zipcode, W.KeyMan, W.E_mail, W.Fax, W.Region, W.AllowMinusStock, W.Tag, W.Company_ID, dbo.GetCompanyAbvByID(W.Company_ID), dbo.GetCompanyNameByID(W.Company_ID), W.ChannelID, W.AccountCustomer_ID, W.Custom1, W.Custom2, W.Custom3, W.Custom4, W.Custom5, W.Custom6, W.Custom7, W.Custom8, W.Custom9, W.Custom10, W.Custom11, W.Custom12, W.Custom13, W.Custom14, W.Custom15, W.Custom16, W.Custom17, W.Custom18, W.Custom19, W.Custom20, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.UnitPrice, GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 ORDER BY A.DealeReturnID, A.Manual_ID, CONVERT(VARCHAR(10), A.Return_Date, 120), A.Warehouse_No, W.Warehouse_Na, A.Customer_ID, CT.Abbrev, A.RenoticeID, A.Name, CONVERT(VARCHAR(20), A.Input_Date, 120), A.Operator, RO.UserName, A.Posted, CONVERT(VARCHAR(20), A.PostedDate, 120), A.PostUser, RP.UserName, A.JiZhang, CONVERT(VARCHAR(20), A.JiZhangDate, 120), A.JiZhangOperator, RJ.UserName, A.SaleMan, CAST(A.Remark AS VarChar(MAX)), A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Explain, A.Long, GDP.DpPriceByRetail, A.UnitPrice, A.BalancePrice, SPA.Consignee, SPA.Mobile, SPA.TransportCompany, SPA.PaymentMode, SPA.TransportNo, SPA.ConsigneeAddress, W.Address, W.Tele, W.Zipcode, W.KeyMan, W.E_mail, W.Fax, W.Region, W.AllowMinusStock, W.Tag, W.Company_ID, dbo.GetCompanyAbvByID(W.Company_ID), dbo.GetCompanyNameByID(W.Company_ID), W.ChannelID, W.AccountCustomer_ID, W.Custom1, W.Custom2, W.Custom3, W.Custom4, W.Custom5, W.Custom6, W.Custom7, W.Custom8, W.Custom9, W.Custom10, W.Custom11, W.Custom12, W.Custom13, W.Custom14, W.Custom15, W.Custom16, W.Custom17, W.Custom18, W.Custom19, W.Custom20, GS.HelpRemember, GS.Brand, GS.Category, GS.Category2, GS.Range, GS.Pattern, GS.Item, GS.Authorisation, GS.Sex, GS.Season, GS.Year, GS.Property, GS.XingZhi, GS.Unit, CONVERT(VARCHAR(10),GS.NewOld,120), GS.Designer, GS.Material, GS.Material1, GS.Material2, GS.Material3, GS.InsideMaterial, GS.FillMaterial, GS.GoodsDate, GS.ReturnCycle, GS.EstimatedDeliveryDate, GS.Manufacturer, GS.ProducingArea, GS.Executestandard, GS.Reserve1, GS.Reserve2, GS.Reserve3, GS.Reserve4, GS.SafeCategory, GS.ListingBand, GS.Size_class, GS.SizeTypeID, GS.Input_Date, GS.Definition1, GS.Definition2, GS.Definition3, GS.Definition4, GS.Definition5, GS.Definition6, GS.Definition7, GS.Definition8, GS.Definition9, GS.Definition10, GS.Definition11, GS.Definition12, GS.Definition13, GS.Definition14, GS.Definition15, GS.Definition16, GS.Definition17, GS.Definition18, GS.Definition19, GS.Definition20, GS.GoodsRemark, GS.WholeSalePrice, dbo.[GetPriceSegmentByPrice](GS.UnitPrice), GS.UnitPrice, GS.DpPrice2, GS.DpPrice3, GS.DpPrice4, GS.DpPrice5, GS.DpPrice6, GS.DpPrice7, GS.DpPrice8, GS.DpPrice9, GS.DpPrice10, GS.DpPrice11, GS.DpPrice12 时间: 2024-11-25 11:49:56,720 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##2b2dd925b7894943ac2f70c36f96564e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 11:49:57,149 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2e178c963ca14ccc8b62c2c1838259e1] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 11:49:57,151 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b2dd925b7894943ac2f70c36f96564e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2e178c963ca14ccc8b62c2c1838259e1] 时间: 2024-11-25 11:49:57,213 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b2c51caeab684bd1b9404a9a07e8aed1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 11:49:57,215 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b2c51caeab684bd1b9404a9a07e8aed1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 11:49:57,217 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b2c51caeab684bd1b9404a9a07e8aed1 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-11-25 11:49:57,246 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b2c51caeab684bd1b9404a9a07e8aed1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 11:49:57,247 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b2c51caeab684bd1b9404a9a07e8aed1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 11:49:57,251 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b2dd925b7894943ac2f70c36f96564e] (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 [##59ddd6e3d1ec4967bba624954c88f5e7] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 11:49:57,255 线程ID: 72 日志级别: 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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##2b2dd925b7894943ac2f70c36f96564e 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-11-25 12:11:17,460 线程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 [##861aaeef6baa40448618097c6f62e40c] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 12:11:17,937 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1661cf8eefaf4340b937ca6b27fc616a] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 12:11:17,939 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##861aaeef6baa40448618097c6f62e40c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1661cf8eefaf4340b937ca6b27fc616a] 时间: 2024-11-25 12:11:18,010 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c396ed10c0a94b9aaa5a7c273548b2ac a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 12:11:18,014 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c396ed10c0a94b9aaa5a7c273548b2ac SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 12:11:18,018 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c396ed10c0a94b9aaa5a7c273548b2ac 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-11-25 12:11:18,056 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c396ed10c0a94b9aaa5a7c273548b2ac SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 12:11:18,057 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c396ed10c0a94b9aaa5a7c273548b2ac SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 12:11:18,061 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##861aaeef6baa40448618097c6f62e40c] (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 [##8896bdee42b541b7a517761d48e0e3cb] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 12:11:18,067 线程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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##861aaeef6baa40448618097c6f62e40c 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-11-25 12:34:24,220 线程ID: 26 日志级别: 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 [##bf7bb85431234cfd931d3348627dbc9f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 12:34:24,648 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##b16b36692ab6413087bf0c6a4b8849ad] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 12:34:24,650 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bf7bb85431234cfd931d3348627dbc9f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b16b36692ab6413087bf0c6a4b8849ad] 时间: 2024-11-25 12:34:24,713 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##30917ce6fd874547b59b3ffdd074af4c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 12:34:24,715 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##30917ce6fd874547b59b3ffdd074af4c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 12:34:24,717 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##30917ce6fd874547b59b3ffdd074af4c 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-11-25 12:34:24,746 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##30917ce6fd874547b59b3ffdd074af4c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 12:34:24,747 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##30917ce6fd874547b59b3ffdd074af4c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 12:34:24,751 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bf7bb85431234cfd931d3348627dbc9f] (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 [##27d4f87c5a564af6a0f7040e944b3d9a] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 12:34:24,755 线程ID: 26 日志级别: 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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##bf7bb85431234cfd931d3348627dbc9f 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-11-25 12:37:15,201 线程ID: 26 日志级别: 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 [##0ca1f57b01e743c0803a23d26db90d20] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 12:37:15,629 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9a2c13e480004de7a14ada6c122c72fb] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 12:37:15,631 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ca1f57b01e743c0803a23d26db90d20] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9a2c13e480004de7a14ada6c122c72fb] 时间: 2024-11-25 12:37:15,696 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8d5730c5ca134886895009d992c3efff a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 12:37:15,699 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8d5730c5ca134886895009d992c3efff SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 12:37:15,701 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8d5730c5ca134886895009d992c3efff 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-11-25 12:37:15,736 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8d5730c5ca134886895009d992c3efff SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 12:37:15,738 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8d5730c5ca134886895009d992c3efff SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 12:37:15,742 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ca1f57b01e743c0803a23d26db90d20] (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 [##64c7372eab414ed585edc3f97f37e6c8] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 12:37:15,746 线程ID: 26 日志级别: 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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##0ca1f57b01e743c0803a23d26db90d20 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-11-25 12:44:32,617 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##3f6cac51aec543c4951c605a6e37e3eb] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 12:44:33,026 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##b25b3ca42f544f6ca4e313facbb34009] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 12:44:33,028 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3f6cac51aec543c4951c605a6e37e3eb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b25b3ca42f544f6ca4e313facbb34009] 时间: 2024-11-25 12:44:33,086 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##856dbbb166e349be8fc79cc8183ff71c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 12:44:33,089 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##856dbbb166e349be8fc79cc8183ff71c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 12:44:33,093 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##856dbbb166e349be8fc79cc8183ff71c 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-11-25 12:44:33,127 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##856dbbb166e349be8fc79cc8183ff71c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 12:44:33,129 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##856dbbb166e349be8fc79cc8183ff71c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 12:44:33,133 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3f6cac51aec543c4951c605a6e37e3eb] (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 [##a1ea2123d087431196d52da60c972990] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 12:44:33,140 线程ID: 62 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[d4bfadc1-14fd-4257-a4e6-7a2e8aa115d1] FROM ##3f6cac51aec543c4951c605a6e37e3eb 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-11-25 15:03:29,222 线程ID: 67 日志级别: 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 [##bfb962af97864f45a59baee1eb63c709] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:03:29,644 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3b090a073b9e4846b0483d145ed581b1] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:03:29,646 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bfb962af97864f45a59baee1eb63c709] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3b090a073b9e4846b0483d145ed581b1] 时间: 2024-11-25 15:03:29,711 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8030b11980aa48ac942e64de72d1c584 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:03:29,713 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8030b11980aa48ac942e64de72d1c584 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:03:29,716 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8030b11980aa48ac942e64de72d1c584 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-11-25 15:03:29,749 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8030b11980aa48ac942e64de72d1c584 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:03:29,751 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8030b11980aa48ac942e64de72d1c584 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:03:29,755 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bfb962af97864f45a59baee1eb63c709] (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 [##f759aaab7f374cbbbdd4e02d846ef795] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:03:29,761 线程ID: 67 日志级别: 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.[2e0e67b9-fc80-42fa-afa3-29ea14b6dcb6] FROM ##bfb962af97864f45a59baee1eb63c709 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-11-25 15:08:09,609 线程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 [##25408c8bf58c47628da9d0d5616eed18] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:08:10,035 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##032704e0bf68457fb0a894e0de371bb5] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:08:10,038 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##25408c8bf58c47628da9d0d5616eed18] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##032704e0bf68457fb0a894e0de371bb5] 时间: 2024-11-25 15:08:10,104 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##54262705dc7240f9ae0dc2a39c8ef026 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:08:10,106 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##54262705dc7240f9ae0dc2a39c8ef026 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:08:10,107 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##54262705dc7240f9ae0dc2a39c8ef026 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-11-25 15:08:10,141 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##54262705dc7240f9ae0dc2a39c8ef026 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:08:10,143 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##54262705dc7240f9ae0dc2a39c8ef026 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:08:10,147 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##25408c8bf58c47628da9d0d5616eed18] (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 [##64712d5b13fd46d9bd5d382024282c99] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:08:10,151 线程ID: 22 日志级别: 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.[2e0e67b9-fc80-42fa-afa3-29ea14b6dcb6] FROM ##25408c8bf58c47628da9d0d5616eed18 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-11-25 15:19:09,948 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##8cbb0e97baf846a788de777f11ff5d20] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:19:10,390 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7582de1649fa4d89ad8a5b069580e177] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:19:10,392 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8cbb0e97baf846a788de777f11ff5d20] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7582de1649fa4d89ad8a5b069580e177] 时间: 2024-11-25 15:19:10,484 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9a64279ca2bd4034b9c480315dab2eab a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:19:10,487 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9a64279ca2bd4034b9c480315dab2eab SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:19:10,492 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9a64279ca2bd4034b9c480315dab2eab 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-11-25 15:19:10,531 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9a64279ca2bd4034b9c480315dab2eab SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:19:10,533 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9a64279ca2bd4034b9c480315dab2eab SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:19:10,538 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8cbb0e97baf846a788de777f11ff5d20] (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 [##ec05cbe8084640cfa406a784db789e29] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:19:10,546 线程ID: 7 日志级别: 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.[2e0e67b9-fc80-42fa-afa3-29ea14b6dcb6] FROM ##8cbb0e97baf846a788de777f11ff5d20 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-11-25 15:26:52,528 线程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 [##5fcff418444c486f8f64a018e48fd3a7] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:26:52,944 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##e752e22777334ce792aac1d91ec4879c] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:26:52,946 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5fcff418444c486f8f64a018e48fd3a7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e752e22777334ce792aac1d91ec4879c] 时间: 2024-11-25 15:26:53,007 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cdb56d4748df46c3bc9de08fbd659b8a a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:26:53,010 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cdb56d4748df46c3bc9de08fbd659b8a SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:26:53,013 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##cdb56d4748df46c3bc9de08fbd659b8a 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-11-25 15:26:53,045 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cdb56d4748df46c3bc9de08fbd659b8a SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:26:53,046 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cdb56d4748df46c3bc9de08fbd659b8a SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:26:53,049 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5fcff418444c486f8f64a018e48fd3a7] (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 [##5f0fde23adb04784a2d085059a00c710] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:26:53,056 线程ID: 22 日志级别: 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.[2e0e67b9-fc80-42fa-afa3-29ea14b6dcb6] FROM ##5fcff418444c486f8f64a018e48fd3a7 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-11-25 15:38:22,699 线程ID: 10 日志级别: 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 [##f26678fff7ea4ac0bd47ee097201dae9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:38:23,128 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##36b37f888bc14c5a8345e225e49446a6] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:38:23,130 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f26678fff7ea4ac0bd47ee097201dae9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##36b37f888bc14c5a8345e225e49446a6] 时间: 2024-11-25 15:38:23,192 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1795b5388e6d4b5abdd0f6485ae095e9 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:38:23,195 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1795b5388e6d4b5abdd0f6485ae095e9 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:38:23,198 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1795b5388e6d4b5abdd0f6485ae095e9 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-11-25 15:38:23,227 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1795b5388e6d4b5abdd0f6485ae095e9 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:38:23,230 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1795b5388e6d4b5abdd0f6485ae095e9 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:38:23,233 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f26678fff7ea4ac0bd47ee097201dae9] (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 [##c238f8777a07420ba398418fc2dc3edf] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:38:23,237 线程ID: 10 日志级别: 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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##f26678fff7ea4ac0bd47ee097201dae9 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-11-25 15:38:48,765 线程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 [##3a15f585ed8f460390ef48c2979a55ca] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:38:49,210 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##e1fbb5f9cecd4cb691f760d9f3c925e8] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:38:49,213 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3a15f585ed8f460390ef48c2979a55ca] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e1fbb5f9cecd4cb691f760d9f3c925e8] 时间: 2024-11-25 15:38:49,288 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6abd790331124d13897503ee59810f96 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:38:49,291 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6abd790331124d13897503ee59810f96 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:38:49,295 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6abd790331124d13897503ee59810f96 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-11-25 15:38:49,333 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6abd790331124d13897503ee59810f96 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:38:49,335 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6abd790331124d13897503ee59810f96 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:38:49,340 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3a15f585ed8f460390ef48c2979a55ca] (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 [##63ea474f35444c1bb13c650e23d01277] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:38:49,348 线程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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##3a15f585ed8f460390ef48c2979a55ca 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-11-25 15:54:31,491 线程ID: 21 日志级别: 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 [##a8072d9e9f8348bd9ff78d6889aa2a39] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:54:31,964 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##e5ecd3cf1e9a420bbda00f7148061f94] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:54:31,967 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8072d9e9f8348bd9ff78d6889aa2a39] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e5ecd3cf1e9a420bbda00f7148061f94] 时间: 2024-11-25 15:54:32,033 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e269b3531aee4b628291ca32ed9825dc a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:54:32,035 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e269b3531aee4b628291ca32ed9825dc SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:54:32,037 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e269b3531aee4b628291ca32ed9825dc 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-11-25 15:54:32,067 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e269b3531aee4b628291ca32ed9825dc SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:54:32,069 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e269b3531aee4b628291ca32ed9825dc SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:54:32,073 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a8072d9e9f8348bd9ff78d6889aa2a39] (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 [##91b270033dd8412abc8f1483c56b7c5c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:54:32,078 线程ID: 21 日志级别: 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.[6c80df76-de49-425c-990e-cedf953a648a] FROM ##a8072d9e9f8348bd9ff78d6889aa2a39 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-11-25 15:59:30,869 线程ID: 20 日志级别: 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 [##c95aea183b4243fd965bfb0c823605e5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 15:59:31,319 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##993d74bef00242bbbb668d29af609587] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 15:59:31,321 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c95aea183b4243fd965bfb0c823605e5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##993d74bef00242bbbb668d29af609587] 时间: 2024-11-25 15:59:31,381 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##18b0dc0d54644b66916fcdef42c536f2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 15:59:31,385 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##18b0dc0d54644b66916fcdef42c536f2 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 15:59:31,387 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##18b0dc0d54644b66916fcdef42c536f2 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-11-25 15:59:31,418 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##18b0dc0d54644b66916fcdef42c536f2 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 15:59:31,420 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##18b0dc0d54644b66916fcdef42c536f2 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 15:59:31,423 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c95aea183b4243fd965bfb0c823605e5] (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 [##7cd4dc8249d647f2ab642fc767816b63] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 15:59:31,427 线程ID: 20 日志级别: 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.[6c80df76-de49-425c-990e-cedf953a648a] FROM ##c95aea183b4243fd965bfb0c823605e5 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-11-25 16:00:04,380 线程ID: 20 日志级别: 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 [##22fead2f28f546799d07a544e07cb698] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 16:00:04,806 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##13ab9d90400a4ebd96244440cff4b249] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 16:00:04,808 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22fead2f28f546799d07a544e07cb698] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##13ab9d90400a4ebd96244440cff4b249] 时间: 2024-11-25 16:00:04,874 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##252f4e483e764ef8bebd99637b710688 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 16:00:04,876 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##252f4e483e764ef8bebd99637b710688 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 16:00:04,878 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##252f4e483e764ef8bebd99637b710688 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-11-25 16:00:04,904 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##252f4e483e764ef8bebd99637b710688 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 16:00:04,906 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##252f4e483e764ef8bebd99637b710688 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 16:00:04,910 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22fead2f28f546799d07a544e07cb698] (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 [##1352a9df30ce43dba2309d7d3bbb58bc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 16:00:04,914 线程ID: 20 日志级别: 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.[6c80df76-de49-425c-990e-cedf953a648a] FROM ##22fead2f28f546799d07a544e07cb698 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-11-25 16:20:46,122 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##cbdfb345124a49d7884ab58debbbb073] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 16:20:46,525 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ea407c81e769470dab41ed3e5af573ab] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 16:20:46,527 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbdfb345124a49d7884ab58debbbb073] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ea407c81e769470dab41ed3e5af573ab] 时间: 2024-11-25 16:20:46,595 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e7736a159da54f22b917920ba8fd8902 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 16:20:46,597 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e7736a159da54f22b917920ba8fd8902 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 16:20:46,602 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e7736a159da54f22b917920ba8fd8902 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-11-25 16:20:46,634 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e7736a159da54f22b917920ba8fd8902 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 16:20:46,636 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e7736a159da54f22b917920ba8fd8902 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 16:20:46,640 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbdfb345124a49d7884ab58debbbb073] (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 [##0ef6876c5f8a46b4be8b79661fe7d293] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 16:20:46,646 线程ID: 74 日志级别: 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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##cbdfb345124a49d7884ab58debbbb073 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-11-25 16:37:31,582 线程ID: 47 日志级别: 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 [##cb12d15771614e498e8f65e6bf11f2a7] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 16:37:32,001 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fe3ee5d8ff67460d9e29d8305c89e9aa] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 16:37:32,003 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cb12d15771614e498e8f65e6bf11f2a7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fe3ee5d8ff67460d9e29d8305c89e9aa] 时间: 2024-11-25 16:37:32,072 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a345ffd41d0d499d9442896723914342 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 16:37:32,075 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a345ffd41d0d499d9442896723914342 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 16:37:32,079 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a345ffd41d0d499d9442896723914342 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-11-25 16:37:32,119 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a345ffd41d0d499d9442896723914342 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 16:37:32,121 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a345ffd41d0d499d9442896723914342 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 16:37:32,125 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cb12d15771614e498e8f65e6bf11f2a7] (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 [##054b15462c5c432ab565aa68be670f84] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 16:37:32,131 线程ID: 47 日志级别: 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.[15162b2c-c008-4d72-97aa-c4ffe7a898b8] FROM ##cb12d15771614e498e8f65e6bf11f2a7 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-11-25 19:06:43,040 线程ID: 81 日志级别: 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 [##9d7d97d9864c447599c8e6d1f9815242] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 19:06:43,461 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a355a7178fbf4bdfa2dada3d7dedfde2] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 19:06:43,463 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d7d97d9864c447599c8e6d1f9815242] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a355a7178fbf4bdfa2dada3d7dedfde2] 时间: 2024-11-25 19:06:43,530 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a2e610bfaf0f4c16b66befd9c5e54861 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 19:06:43,533 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a2e610bfaf0f4c16b66befd9c5e54861 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 19:06:43,536 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a2e610bfaf0f4c16b66befd9c5e54861 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-11-25 19:06:43,569 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a2e610bfaf0f4c16b66befd9c5e54861 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 19:06:43,572 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a2e610bfaf0f4c16b66befd9c5e54861 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 19:06:43,575 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d7d97d9864c447599c8e6d1f9815242] (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 [##212d08b41c7c499098f72b52e24946b3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 19:06:43,581 线程ID: 81 日志级别: 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 [渠道库存] INTO tempdb.dbo.[fcb563e2-eeb0-4dc1-90d2-5af76f8a4488] FROM ##9d7d97d9864c447599c8e6d1f9815242 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-11-25 19:36:12,822 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##3d08afcc155c4759bcbd78c2a0fb818d] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 19:36:13,274 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0b48c922c0294dfa99381de463771b03] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 19:36:13,277 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3d08afcc155c4759bcbd78c2a0fb818d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0b48c922c0294dfa99381de463771b03] 时间: 2024-11-25 19:36:13,346 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##873bf7ff52a04259938691f2e816aa14 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 19:36:13,350 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##873bf7ff52a04259938691f2e816aa14 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 19:36:13,354 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##873bf7ff52a04259938691f2e816aa14 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-11-25 19:36:13,386 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##873bf7ff52a04259938691f2e816aa14 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 19:36:13,389 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##873bf7ff52a04259938691f2e816aa14 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 19:36:13,392 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3d08afcc155c4759bcbd78c2a0fb818d] (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 [##4fc9911aa2134af5b6f3f8518cf2d0d6] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 19:36:13,399 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存] INTO tempdb.dbo.[fcb563e2-eeb0-4dc1-90d2-5af76f8a4488] FROM ##3d08afcc155c4759bcbd78c2a0fb818d 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-11-25 19:39:19,629 线程ID: 30 日志级别: 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 [##7e1d5f94d55c4ef18524c65f162a268b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 19:39:20,045 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0bcdd00082a143c888763ba951fa2731] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 19:39:20,047 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7e1d5f94d55c4ef18524c65f162a268b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0bcdd00082a143c888763ba951fa2731] 时间: 2024-11-25 19:39:20,132 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7b9d924569ef44f0b88f5f2116b2a2f6 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 19:39:20,135 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7b9d924569ef44f0b88f5f2116b2a2f6 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 19:39:20,140 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7b9d924569ef44f0b88f5f2116b2a2f6 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-11-25 19:39:20,177 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7b9d924569ef44f0b88f5f2116b2a2f6 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 19:39:20,179 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7b9d924569ef44f0b88f5f2116b2a2f6 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 19:39:20,183 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7e1d5f94d55c4ef18524c65f162a268b] (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 [##a464b4f4f0e84ff59a441615f7e8f3c6] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 19:39:20,190 线程ID: 30 日志级别: 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 [渠道库存] INTO tempdb.dbo.[fcb563e2-eeb0-4dc1-90d2-5af76f8a4488] FROM ##7e1d5f94d55c4ef18524c65f162a268b 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-11-25 21:05:05,102 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##341df32ce4324070b8f7fc6e6d55381b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2024-11-25 21:05:05,522 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##101307f0fff441aeb41959cf0939540c] where 2=2 and ISNULL(S1,0)=0 时间: 2024-11-25 21:05:05,524 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##341df32ce4324070b8f7fc6e6d55381b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##101307f0fff441aeb41959cf0939540c] 时间: 2024-11-25 21:05:05,592 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f0c9cda43c1347b5a555e80b7a5e912a a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2024-11-25 21:05:05,594 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0c9cda43c1347b5a555e80b7a5e912a SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2024-11-25 21:05:05,597 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f0c9cda43c1347b5a555e80b7a5e912a 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-11-25 21:05:05,631 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0c9cda43c1347b5a555e80b7a5e912a SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2024-11-25 21:05:05,633 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0c9cda43c1347b5a555e80b7a5e912a SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2024-11-25 21:05:05,636 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##341df32ce4324070b8f7fc6e6d55381b] (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 [##d5c2b0dc02fd484295cf3a9e7ce39cc3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2024-11-25 21:05:05,642 线程ID: 60 日志级别: 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.[234b16f7-034f-4902-9864-4614159e9c4d] FROM ##341df32ce4324070b8f7fc6e6d55381b 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