时间: 2021-05-26 11:21:17,067 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[4a320f5e-b918-41e9-8b06-81c3bcec23db] FROM [##f8c0d5245b634fa8bc9a63731175d10b] ORDER BY Goods_no 时间: 2021-05-26 11:21:33,054 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##03c6988e3a5041e9829c7b2cece4f88e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-05-26 11:21:33,391 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0ecd631791234aa985c6dc7a9f5772c9] where 2=2 and ISNULL(S1,0)=0 时间: 2021-05-26 11:21:33,393 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##03c6988e3a5041e9829c7b2cece4f88e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0ecd631791234aa985c6dc7a9f5772c9] 时间: 2021-05-26 11:21:33,479 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a8fac6c929c74f488cc64f8e20f26399 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 11:21:33,482 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8fac6c929c74f488cc64f8e20f26399 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-05-26 11:21:33,484 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a8fac6c929c74f488cc64f8e20f26399 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 = '退货' 时间: 2021-05-26 11:21:33,522 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8fac6c929c74f488cc64f8e20f26399 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-05-26 11:21:33,524 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8fac6c929c74f488cc64f8e20f26399 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-05-26 11:21:33,528 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##03c6988e3a5041e9829c7b2cece4f88e] (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 [##0b05357a0bb84558818c752a595fcfa1] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-05-26 11:21:33,540 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Pattern AS [款型] INTO tempdb.dbo.[e478cd1b-7c97-4e95-963d-c726578f44b5] FROM ##03c6988e3a5041e9829c7b2cece4f88e 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, GS.Pattern 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, GS.Pattern 时间: 2021-05-26 11:21:42,858 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##14d0370de3af4b1bbdf4c3a20173ca60] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-05-26 11:21:43,200 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9a7b87f017f9490ba6a6f7c61ffb30f4] where 2=2 and ISNULL(S1,0)=0 时间: 2021-05-26 11:21:43,202 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##14d0370de3af4b1bbdf4c3a20173ca60] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9a7b87f017f9490ba6a6f7c61ffb30f4] 时间: 2021-05-26 11:21:43,283 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7105c1c3a2b74036afcb476a42ae4e68 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 11:21:43,287 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7105c1c3a2b74036afcb476a42ae4e68 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-05-26 11:21:43,292 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7105c1c3a2b74036afcb476a42ae4e68 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 = '退货' 时间: 2021-05-26 11:21:43,325 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7105c1c3a2b74036afcb476a42ae4e68 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-05-26 11:21:43,327 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7105c1c3a2b74036afcb476a42ae4e68 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-05-26 11:21:43,330 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##14d0370de3af4b1bbdf4c3a20173ca60] (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 [##7cd2686f24b4428a90042d8f5f584b48] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-05-26 11:21:43,336 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Pattern AS [款型] INTO tempdb.dbo.[e478cd1b-7c97-4e95-963d-c726578f44b5] FROM ##14d0370de3af4b1bbdf4c3a20173ca60 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, GS.Pattern 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, GS.Pattern 时间: 2021-05-26 11:22:00,634 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##1860eced7635458c926edc52cf5cff45] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-05-26 11:22:00,959 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##847c91161def4c7ab2df0fe6a019ca73] where 2=2 and ISNULL(S1,0)=0 时间: 2021-05-26 11:22:00,962 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1860eced7635458c926edc52cf5cff45] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##847c91161def4c7ab2df0fe6a019ca73] 时间: 2021-05-26 11:22:01,040 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7e2d3d516f5d4dd7870f16977a4da8e9 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 11:22:01,043 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7e2d3d516f5d4dd7870f16977a4da8e9 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-05-26 11:22:01,047 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7e2d3d516f5d4dd7870f16977a4da8e9 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 = '退货' 时间: 2021-05-26 11:22:01,081 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7e2d3d516f5d4dd7870f16977a4da8e9 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-05-26 11:22:01,083 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7e2d3d516f5d4dd7870f16977a4da8e9 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-05-26 11:22:01,088 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1860eced7635458c926edc52cf5cff45] (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 [##42c51342a8c643119da2c42a0f380e58] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-05-26 11:22:01,094 线程ID: 50 日志级别: 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 [项目名称], GS.Pattern AS [款型] INTO tempdb.dbo.[e478cd1b-7c97-4e95-963d-c726578f44b5] FROM ##1860eced7635458c926edc52cf5cff45 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, GS.Pattern 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, GS.Pattern 时间: 2021-05-26 14:08:17,906 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[4a320f5e-b918-41e9-8b06-81c3bcec23db] FROM [##aad2d58ca18349c79cfa2fb75aec8cca] ORDER BY Goods_no 时间: 2021-05-26 14:08:32,583 线程ID: 86 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##d27be29024a046e897b58a905c83e05f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-05-26 14:08:32,908 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a7cf861472e04d4fa1dc4d00c4f1a3b1] where 2=2 and ISNULL(S1,0)=0 时间: 2021-05-26 14:08:32,909 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d27be29024a046e897b58a905c83e05f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a7cf861472e04d4fa1dc4d00c4f1a3b1] 时间: 2021-05-26 14:08:32,978 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2505f700697441a49af924fb649964f9 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 14:08:32,980 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2505f700697441a49af924fb649964f9 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-05-26 14:08:32,982 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2505f700697441a49af924fb649964f9 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 = '退货' 时间: 2021-05-26 14:08:33,011 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2505f700697441a49af924fb649964f9 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-05-26 14:08:33,012 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2505f700697441a49af924fb649964f9 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-05-26 14:08:33,015 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d27be29024a046e897b58a905c83e05f] (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 [##6e72eb7bde9443ddafa765edce116dd8] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-05-26 14:08:33,019 线程ID: 86 日志级别: 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 [项目名称], GS.Pattern AS [款型] INTO tempdb.dbo.[e478cd1b-7c97-4e95-963d-c726578f44b5] FROM ##d27be29024a046e897b58a905c83e05f 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, GS.Pattern 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, GS.Pattern 时间: 2021-05-26 14:08:55,960 线程ID: 133 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##5f356e1a321542a3980f1cf9acf374b0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-05-26 14:08:56,390 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9f2c0a17ae2f45919bf3b5a6c499e7b6] where 2=2 and ISNULL(S1,0)=0 时间: 2021-05-26 14:08:56,392 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5f356e1a321542a3980f1cf9acf374b0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9f2c0a17ae2f45919bf3b5a6c499e7b6] 时间: 2021-05-26 14:08:56,472 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e0f4c4e0050e4ef99602fca1568833fe a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 14:08:56,475 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e0f4c4e0050e4ef99602fca1568833fe SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-05-26 14:08:56,478 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e0f4c4e0050e4ef99602fca1568833fe 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 = '退货' 时间: 2021-05-26 14:08:56,514 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e0f4c4e0050e4ef99602fca1568833fe SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-05-26 14:08:56,516 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e0f4c4e0050e4ef99602fca1568833fe SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-05-26 14:08:56,519 线程ID: 133 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5f356e1a321542a3980f1cf9acf374b0] (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 [##744733f4db3e461487716fdca0a82e80] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-05-26 14:08:56,526 线程ID: 133 日志级别: 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 [项目名称], GS.Pattern AS [款型] INTO tempdb.dbo.[e478cd1b-7c97-4e95-963d-c726578f44b5] FROM ##5f356e1a321542a3980f1cf9acf374b0 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, GS.Pattern 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, GS.Pattern 时间: 2021-05-26 14:37:03,667 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##d45f5ffffe0c4d2b9ecf693af047b5dd ADD 销售类型 VARCHAR(50) 时间: 2021-05-26 14:37:03,673 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##d45f5ffffe0c4d2b9ecf693af047b5dd a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 14:37:03,700 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d45f5ffffe0c4d2b9ecf693af047b5dd SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-05-26 14:37:03,715 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##d45f5ffffe0c4d2b9ecf693af047b5dd 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-05-26 14:37:03,761 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d45f5ffffe0c4d2b9ecf693af047b5dd SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-05-26 14:37:03,764 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d45f5ffffe0c4d2b9ecf693af047b5dd SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-05-26 14:37:03,789 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##d45f5ffffe0c4d2b9ecf693af047b5dd ADD NewCheckID VARCHAR(50) 时间: 2021-05-26 14:37:03,790 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.NewCheckID = A.CheckID FROM [##d45f5ffffe0c4d2b9ecf693af047b5dd] A INNER JOIN ( SELECT C.CheckID, SUM(C.Quantity) Quantity FROM [##d45f5ffffe0c4d2b9ecf693af047b5dd] C GROUP BY C.CheckID ) B ON A.CheckID = B.CheckID WHERE (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) >= 2 OR (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) <= -2 时间: 2021-05-26 14:37:03,822 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckID , CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='退货' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN - COUNT(DISTINCT A.CHECKID) WHEN COUNT(DISTINCT CASE WHEN A.Status='赠送' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN 0 ELSE CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='销售' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN COUNT(DISTINCT A.CHECKID) ELSE CASE WHEN SUM(A.Quantity)>0 THEN COUNT(DISTINCT A.CHECKID) ELSE 0 END END END CheckCount , CAST(0 AS INT) IsMultiCheck INTO ##029973986547456e84371a8560a76c01 FROM ##d45f5ffffe0c4d2b9ecf693af047b5dd A GROUP BY A.CheckID 时间: 2021-05-26 14:37:03,888 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET IsMultiCheck = 1 FROM ##029973986547456e84371a8560a76c01 a WHERE (SELECT Count(NewCheckID) FROM ##d45f5ffffe0c4d2b9ecf693af047b5dd WHERE a.CheckID = NewCheckID) > 1 时间: 2021-05-26 14:37:04,044 线程ID: 88 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##d45f5ffffe0c4d2b9ecf693af047b5dd 时间: 2021-05-26 14:37:26,818 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##92cf8f94b49040cbadfdd416da1a2523 ADD 销售类型 VARCHAR(50) 时间: 2021-05-26 14:37:26,820 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##92cf8f94b49040cbadfdd416da1a2523 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 14:37:26,856 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##92cf8f94b49040cbadfdd416da1a2523 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-05-26 14:37:26,873 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##92cf8f94b49040cbadfdd416da1a2523 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-05-26 14:37:26,929 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##92cf8f94b49040cbadfdd416da1a2523 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-05-26 14:37:26,933 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##92cf8f94b49040cbadfdd416da1a2523 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-05-26 14:37:26,959 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##92cf8f94b49040cbadfdd416da1a2523 ADD NewCheckID VARCHAR(50) 时间: 2021-05-26 14:37:26,962 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.NewCheckID = A.CheckID FROM [##92cf8f94b49040cbadfdd416da1a2523] A INNER JOIN ( SELECT C.CheckID, SUM(C.Quantity) Quantity FROM [##92cf8f94b49040cbadfdd416da1a2523] C GROUP BY C.CheckID ) B ON A.CheckID = B.CheckID WHERE (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) >= 2 OR (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) <= -2 时间: 2021-05-26 14:37:26,999 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckID , CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='退货' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN - COUNT(DISTINCT A.CHECKID) WHEN COUNT(DISTINCT CASE WHEN A.Status='赠送' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN 0 ELSE CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='销售' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN COUNT(DISTINCT A.CHECKID) ELSE CASE WHEN SUM(A.Quantity)>0 THEN COUNT(DISTINCT A.CHECKID) ELSE 0 END END END CheckCount , CAST(0 AS INT) IsMultiCheck INTO ##b78af3ab304c413193afc65ddf7fa5d9 FROM ##92cf8f94b49040cbadfdd416da1a2523 A GROUP BY A.CheckID 时间: 2021-05-26 14:37:27,061 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET IsMultiCheck = 1 FROM ##b78af3ab304c413193afc65ddf7fa5d9 a WHERE (SELECT Count(NewCheckID) FROM ##92cf8f94b49040cbadfdd416da1a2523 WHERE a.CheckID = NewCheckID) > 1 时间: 2021-05-26 14:37:27,204 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##92cf8f94b49040cbadfdd416da1a2523 时间: 2021-05-26 14:38:03,919 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##80747a2319ba4688acf957799d2aa0a3 ADD 销售类型 VARCHAR(50) 时间: 2021-05-26 14:38:03,921 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##80747a2319ba4688acf957799d2aa0a3 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 14:38:03,947 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80747a2319ba4688acf957799d2aa0a3 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-05-26 14:38:03,962 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##80747a2319ba4688acf957799d2aa0a3 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-05-26 14:38:04,009 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80747a2319ba4688acf957799d2aa0a3 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-05-26 14:38:04,013 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80747a2319ba4688acf957799d2aa0a3 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-05-26 14:38:04,035 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##80747a2319ba4688acf957799d2aa0a3 ADD NewCheckID VARCHAR(50) 时间: 2021-05-26 14:38:04,037 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.NewCheckID = A.CheckID FROM [##80747a2319ba4688acf957799d2aa0a3] A INNER JOIN ( SELECT C.CheckID, SUM(C.Quantity) Quantity FROM [##80747a2319ba4688acf957799d2aa0a3] C GROUP BY C.CheckID ) B ON A.CheckID = B.CheckID WHERE (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) >= 2 OR (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) <= -2 时间: 2021-05-26 14:38:04,070 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckID , CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='退货' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN - COUNT(DISTINCT A.CHECKID) WHEN COUNT(DISTINCT CASE WHEN A.Status='赠送' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN 0 ELSE CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='销售' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN COUNT(DISTINCT A.CHECKID) ELSE CASE WHEN SUM(A.Quantity)>0 THEN COUNT(DISTINCT A.CHECKID) ELSE 0 END END END CheckCount , CAST(0 AS INT) IsMultiCheck INTO ##05436264dae94b39a06164d0e2ca62e1 FROM ##80747a2319ba4688acf957799d2aa0a3 A GROUP BY A.CheckID 时间: 2021-05-26 14:38:04,136 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET IsMultiCheck = 1 FROM ##05436264dae94b39a06164d0e2ca62e1 a WHERE (SELECT Count(NewCheckID) FROM ##80747a2319ba4688acf957799d2aa0a3 WHERE a.CheckID = NewCheckID) > 1 时间: 2021-05-26 14:38:04,291 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##80747a2319ba4688acf957799d2aa0a3 时间: 2021-05-26 14:38:51,818 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##df21c6f323b646bf9146b905b56deae7 ADD 销售类型 VARCHAR(50) 时间: 2021-05-26 14:38:51,820 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##df21c6f323b646bf9146b905b56deae7 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-05-26 14:38:51,848 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##df21c6f323b646bf9146b905b56deae7 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-05-26 14:38:51,863 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##df21c6f323b646bf9146b905b56deae7 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-05-26 14:38:51,913 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##df21c6f323b646bf9146b905b56deae7 SET 销售类型='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') AND Status = '退货' 时间: 2021-05-26 14:38:51,916 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##df21c6f323b646bf9146b905b56deae7 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-05-26 14:38:51,940 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ALTER TABLE ##df21c6f323b646bf9146b905b56deae7 ADD NewCheckID VARCHAR(50) 时间: 2021-05-26 14:38:51,942 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.NewCheckID = A.CheckID FROM [##df21c6f323b646bf9146b905b56deae7] A INNER JOIN ( SELECT C.CheckID, SUM(C.Quantity) Quantity FROM [##df21c6f323b646bf9146b905b56deae7] C GROUP BY C.CheckID ) B ON A.CheckID = B.CheckID WHERE (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) >= 2 OR (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) <= -2 时间: 2021-05-26 14:38:51,975 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.CheckID , CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='退货' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN - COUNT(DISTINCT A.CHECKID) WHEN COUNT(DISTINCT CASE WHEN A.Status='赠送' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN 0 ELSE CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='销售' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 THEN COUNT(DISTINCT A.CHECKID) ELSE CASE WHEN SUM(A.Quantity)>0 THEN COUNT(DISTINCT A.CHECKID) ELSE 0 END END END CheckCount , CAST(0 AS INT) IsMultiCheck INTO ##e1253434bffc4d3e9758edf299efc866 FROM ##df21c6f323b646bf9146b905b56deae7 A GROUP BY A.CheckID 时间: 2021-05-26 14:38:52,039 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET IsMultiCheck = 1 FROM ##e1253434bffc4d3e9758edf299efc866 a WHERE (SELECT Count(NewCheckID) FROM ##df21c6f323b646bf9146b905b56deae7 WHERE a.CheckID = NewCheckID) > 1 时间: 2021-05-26 14:38:52,199 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: P_DropTable ##df21c6f323b646bf9146b905b56deae7 时间: 2021-05-26 15:33:34,403 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[4a320f5e-b918-41e9-8b06-81c3bcec23db] FROM [##81af4ae6024145b9af5766bc52a6a7c1] ORDER BY Goods_no