时间: 2021-09-10 11:04:16,848 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##cf8bf14faa8b434a816b0039b5dbc5f9] ORDER BY Goods_no 时间: 2021-09-10 11:04:21,902 线程ID: 80 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##c90d465a79ef4677aeeb1e4b4c54ec60] ORDER BY Goods_no 时间: 2021-09-10 11:04:22,571 线程ID: 85 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##a74b177d488e4f498b78c495a1f40b8f] ORDER BY Goods_no 时间: 2021-09-10 11:04:23,263 线程ID: 77 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##150be87bb79a4971b844392199a50233] ORDER BY Goods_no 时间: 2021-09-10 11:05:55,907 线程ID: 85 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##d732741f86984a1996afca451654a0ac] ORDER BY Goods_no 时间: 2021-09-10 11:05:56,617 线程ID: 82 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##7a334111ad1a47bfac7a40113fd5a5d9] ORDER BY Goods_no 时间: 2021-09-10 11:10:20,332 线程ID: 81 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##87e351dbf21b4ba7841e3d4d71707daa] ORDER BY Goods_no 时间: 2021-09-10 11:10:39,988 线程ID: 76 日志级别: 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 [##02fe4e97fdbd4342817be29af3f9aa24] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 11:10:40,318 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ef10254d1bc24941bb687e39557f267a] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 11:10:40,320 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##02fe4e97fdbd4342817be29af3f9aa24] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ef10254d1bc24941bb687e39557f267a] 时间: 2021-09-10 11:10:40,376 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6c023d4655cc4956911fcc5dbe0544fe a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 11:10:40,378 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c023d4655cc4956911fcc5dbe0544fe SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 11:10:40,382 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6c023d4655cc4956911fcc5dbe0544fe 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-09-10 11:10:40,410 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c023d4655cc4956911fcc5dbe0544fe SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 11:10:40,412 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c023d4655cc4956911fcc5dbe0544fe SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 11:10:40,415 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##02fe4e97fdbd4342817be29af3f9aa24] (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 [##08313ffbf3b543f0bb364cb9b52054ce] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 11:10:40,440 线程ID: 76 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##02fe4e97fdbd4342817be29af3f9aa24 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:44:17,476 线程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 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 [##56b1b63af8474549a73a7cf45192082f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:44:17,805 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##6cc4c1fe42834b8dae142cd4debe9000] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:44:17,806 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##56b1b63af8474549a73a7cf45192082f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6cc4c1fe42834b8dae142cd4debe9000] 时间: 2021-09-10 13:44:17,857 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##629063a8b7b8420abab3269d1e4b2ebf a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:44:17,860 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##629063a8b7b8420abab3269d1e4b2ebf SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:44:17,863 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##629063a8b7b8420abab3269d1e4b2ebf 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-09-10 13:44:17,891 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##629063a8b7b8420abab3269d1e4b2ebf SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:44:17,892 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##629063a8b7b8420abab3269d1e4b2ebf SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:44:17,895 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##56b1b63af8474549a73a7cf45192082f] (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 [##caf96d2859fe49c29fc59a3820bfe053] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:44:17,900 线程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 [项目名称], GS.Pattern AS [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##56b1b63af8474549a73a7cf45192082f 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:44:42,915 线程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 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 [##ccfdf840423c466594a46e9e93bb2307] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:44:43,245 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1d5571cf848649208362c4eff576ed5a] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:44:43,247 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ccfdf840423c466594a46e9e93bb2307] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1d5571cf848649208362c4eff576ed5a] 时间: 2021-09-10 13:44:43,296 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##64f2916406d0467b94030c86e8746098 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:44:43,298 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##64f2916406d0467b94030c86e8746098 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:44:43,301 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##64f2916406d0467b94030c86e8746098 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-09-10 13:44:43,330 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##64f2916406d0467b94030c86e8746098 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:44:43,331 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##64f2916406d0467b94030c86e8746098 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:44:43,334 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ccfdf840423c466594a46e9e93bb2307] (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 [##d944c0726b774a01906f53367e13bf7c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:44:43,339 线程ID: 61 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##ccfdf840423c466594a46e9e93bb2307 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:44:52,008 线程ID: 79 日志级别: 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 [##bc5d9ba5349b4a64b51c607e1aefc1f0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:44:52,381 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##db6c153dfa044fc9a516a88be6b4f533] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:44:52,383 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc5d9ba5349b4a64b51c607e1aefc1f0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##db6c153dfa044fc9a516a88be6b4f533] 时间: 2021-09-10 13:44:52,436 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8f79b30ad75a4f2893fd6de7011336d5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:44:52,439 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8f79b30ad75a4f2893fd6de7011336d5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:44:52,442 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8f79b30ad75a4f2893fd6de7011336d5 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-09-10 13:44:52,472 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8f79b30ad75a4f2893fd6de7011336d5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:44:52,474 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8f79b30ad75a4f2893fd6de7011336d5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:44:52,478 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc5d9ba5349b4a64b51c607e1aefc1f0] (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 [##bae4c7fe5bef400e81e25fb12754ecb6] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:44:52,482 线程ID: 79 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##bc5d9ba5349b4a64b51c607e1aefc1f0 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:47:36,127 线程ID: 40 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##bafeca207c0e479bbc5b4543016fa3a1] ORDER BY Goods_no 时间: 2021-09-10 13:47:46,035 线程ID: 39 日志级别: 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 [##99b6d81072874360877247998bd80b85] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:47:46,406 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##198c36d6a87d47e58e36d7536d60a794] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:47:46,408 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##99b6d81072874360877247998bd80b85] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##198c36d6a87d47e58e36d7536d60a794] 时间: 2021-09-10 13:47:46,463 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##388c19e4064f4197ae4da2a5acd0be92 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:47:46,466 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##388c19e4064f4197ae4da2a5acd0be92 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:47:46,469 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##388c19e4064f4197ae4da2a5acd0be92 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-09-10 13:47:46,500 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##388c19e4064f4197ae4da2a5acd0be92 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:47:46,502 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##388c19e4064f4197ae4da2a5acd0be92 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:47:46,505 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##99b6d81072874360877247998bd80b85] (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 [##d4904f77148b40f682d5858b18631c73] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:47:46,511 线程ID: 39 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##99b6d81072874360877247998bd80b85 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:48:21,872 线程ID: 79 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##092fcef5937b4ab4b1b26eb23164d994] ORDER BY Goods_no 时间: 2021-09-10 13:48:51,728 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##ede8b80cc023427c83c696b235686445] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:48:52,065 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0b512db9018b465aa0c2fc7d92ac73c7] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:48:52,065 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ede8b80cc023427c83c696b235686445] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0b512db9018b465aa0c2fc7d92ac73c7] 时间: 2021-09-10 13:48:52,117 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3465d5e6a8744fe097ad365389a95032 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:48:52,120 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3465d5e6a8744fe097ad365389a95032 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:48:52,123 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3465d5e6a8744fe097ad365389a95032 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-09-10 13:48:52,151 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3465d5e6a8744fe097ad365389a95032 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:48:52,153 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3465d5e6a8744fe097ad365389a95032 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:48:52,156 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ede8b80cc023427c83c696b235686445] (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 [##02473d53b69045aa82c90c4a920049a4] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:48:52,161 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Pattern AS [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##ede8b80cc023427c83c696b235686445 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:49:53,599 线程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 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 [##ea5cda85bcf84cde8ba2ed16bfe3188b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:49:53,927 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##210060e7024645688689255ab3ce9df2] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:49:53,928 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ea5cda85bcf84cde8ba2ed16bfe3188b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##210060e7024645688689255ab3ce9df2] 时间: 2021-09-10 13:49:53,994 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4b133c5e64e8497d9fd33d8651ca2819 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:49:53,996 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4b133c5e64e8497d9fd33d8651ca2819 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:49:53,999 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4b133c5e64e8497d9fd33d8651ca2819 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-09-10 13:49:54,028 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4b133c5e64e8497d9fd33d8651ca2819 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:49:54,029 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4b133c5e64e8497d9fd33d8651ca2819 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:49:54,032 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ea5cda85bcf84cde8ba2ed16bfe3188b] (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 [##b0bfbe4a0d294179a927739a77ebc04c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:49:54,038 线程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 [项目名称], GS.Pattern AS [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##ea5cda85bcf84cde8ba2ed16bfe3188b 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:55:53,469 线程ID: 61 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##74bfee9f3aae424cba51b98a636bd87b] ORDER BY Goods_no 时间: 2021-09-10 13:59:22,509 线程ID: 40 日志级别: 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 [##64d31a94c97d48d392f39986bde47783] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:59:22,855 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7a1bedd5646447caa15863d1268d08f3] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:59:22,857 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##64d31a94c97d48d392f39986bde47783] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7a1bedd5646447caa15863d1268d08f3] 时间: 2021-09-10 13:59:22,929 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##61351c473fee45e8b0b65bc396b7469e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:59:22,932 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61351c473fee45e8b0b65bc396b7469e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:59:22,935 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##61351c473fee45e8b0b65bc396b7469e 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-09-10 13:59:22,969 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61351c473fee45e8b0b65bc396b7469e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:59:22,971 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61351c473fee45e8b0b65bc396b7469e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:59:22,974 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##64d31a94c97d48d392f39986bde47783] (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 [##d71700467be74469a311af7d94b14a11] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:59:22,980 线程ID: 40 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##64d31a94c97d48d392f39986bde47783 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, GS.Category 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, GS.Category 时间: 2021-09-10 13:59:35,938 线程ID: 79 日志级别: 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 [##ebe19b417664421eae6f1bf6efa42e90] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 13:59:36,331 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a298314e82894597b45cf46c7e862523] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 13:59:36,333 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ebe19b417664421eae6f1bf6efa42e90] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a298314e82894597b45cf46c7e862523] 时间: 2021-09-10 13:59:36,436 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2b90b067f8154aeab6ec13ab1e6b4741 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 13:59:36,438 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b90b067f8154aeab6ec13ab1e6b4741 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 13:59:36,442 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2b90b067f8154aeab6ec13ab1e6b4741 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-09-10 13:59:36,474 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b90b067f8154aeab6ec13ab1e6b4741 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 13:59:36,476 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2b90b067f8154aeab6ec13ab1e6b4741 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 13:59:36,479 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ebe19b417664421eae6f1bf6efa42e90] (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 [##5afa65f2b92e4b468ace3d9a34ba4bdc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 13:59:36,483 线程ID: 79 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##ebe19b417664421eae6f1bf6efa42e90 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:00:03,118 线程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 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 [##0c0e2abb0a534c7799b81006b9b07b51] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:00:03,476 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##778489b4fc4849dc9c85faf676016edf] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:00:03,478 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0c0e2abb0a534c7799b81006b9b07b51] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##778489b4fc4849dc9c85faf676016edf] 时间: 2021-09-10 14:00:03,553 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##067d2db5fd874430871bbef98473c1e5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:00:03,556 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##067d2db5fd874430871bbef98473c1e5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:00:03,557 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##067d2db5fd874430871bbef98473c1e5 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-09-10 14:00:03,588 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##067d2db5fd874430871bbef98473c1e5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:00:03,590 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##067d2db5fd874430871bbef98473c1e5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:00:03,593 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0c0e2abb0a534c7799b81006b9b07b51] (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 [##19954e12630247f4811f9677fd05c02a] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:00:03,598 线程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 [项目名称], GS.Pattern AS [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##0c0e2abb0a534c7799b81006b9b07b51 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:00:12,383 线程ID: 78 日志级别: 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 [##3e69cc573ee24bf8b27852f8e9b84e9b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:00:12,760 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1f44b14bd8e8457bb6766cbd0511e51e] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:00:12,761 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3e69cc573ee24bf8b27852f8e9b84e9b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1f44b14bd8e8457bb6766cbd0511e51e] 时间: 2021-09-10 14:00:12,853 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a9e14d261147455f9c59814190173118 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:00:12,855 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9e14d261147455f9c59814190173118 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:00:12,857 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a9e14d261147455f9c59814190173118 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-09-10 14:00:12,888 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9e14d261147455f9c59814190173118 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:00:12,889 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a9e14d261147455f9c59814190173118 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:00:12,892 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3e69cc573ee24bf8b27852f8e9b84e9b] (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 [##0da6bca2378c45e7be899aa5a6da43dd] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:00:12,896 线程ID: 78 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##3e69cc573ee24bf8b27852f8e9b84e9b 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:00:35,079 线程ID: 79 日志级别: 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 [##5340dca5e90440b1b7e8fc855ea2ee13] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:00:35,444 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3b6701a6d01a4bff90a859e55e649e3d] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:00:35,445 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5340dca5e90440b1b7e8fc855ea2ee13] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3b6701a6d01a4bff90a859e55e649e3d] 时间: 2021-09-10 14:00:35,524 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f3fe5ec81c2846eabf0f7959e46b4566 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:00:35,527 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f3fe5ec81c2846eabf0f7959e46b4566 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:00:35,531 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f3fe5ec81c2846eabf0f7959e46b4566 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-09-10 14:00:35,562 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f3fe5ec81c2846eabf0f7959e46b4566 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:00:35,564 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f3fe5ec81c2846eabf0f7959e46b4566 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:00:35,566 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5340dca5e90440b1b7e8fc855ea2ee13] (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 [##2a0835ee04bd44fcb431baef546df373] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:00:35,572 线程ID: 79 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##5340dca5e90440b1b7e8fc855ea2ee13 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:01:00,925 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##75cae33a10c049789219103611d50fa2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:01:01,299 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##33187130a01e412fa6a15f8ad5737552] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:01:01,300 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##75cae33a10c049789219103611d50fa2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##33187130a01e412fa6a15f8ad5737552] 时间: 2021-09-10 14:01:01,378 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6c485c1f9a734a47a4fe357ebee0cae6 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:01:01,382 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c485c1f9a734a47a4fe357ebee0cae6 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:01:01,385 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6c485c1f9a734a47a4fe357ebee0cae6 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-09-10 14:01:01,417 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c485c1f9a734a47a4fe357ebee0cae6 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:01:01,419 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6c485c1f9a734a47a4fe357ebee0cae6 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:01:01,422 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##75cae33a10c049789219103611d50fa2] (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 [##9755e91bdc5d40bcaab4ee23351e3d45] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:01:01,428 线程ID: 65 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##75cae33a10c049789219103611d50fa2 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:01:35,247 线程ID: 39 日志级别: 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 [##173142a588514dff9a4c6e863329a8a9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:01:35,597 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##cdadb34d342d4b24aaef9be19d3a31b8] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:01:35,598 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##173142a588514dff9a4c6e863329a8a9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##cdadb34d342d4b24aaef9be19d3a31b8] 时间: 2021-09-10 14:01:35,667 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ba77e1e2480248a3855a2df606ea6c41 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:01:35,670 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ba77e1e2480248a3855a2df606ea6c41 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:01:35,673 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ba77e1e2480248a3855a2df606ea6c41 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-09-10 14:01:35,705 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ba77e1e2480248a3855a2df606ea6c41 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:01:35,706 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ba77e1e2480248a3855a2df606ea6c41 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:01:35,710 线程ID: 39 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##173142a588514dff9a4c6e863329a8a9] (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 [##4c0a2eb3a43f49afa81e58cab109235e] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:01:35,716 线程ID: 39 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##173142a588514dff9a4c6e863329a8a9 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:01:57,258 线程ID: 79 日志级别: 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 [##162541e95e88414a881a088fb110a09e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:01:57,608 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4d749e3b12ad41baaadb70fd6bd2d91f] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:01:57,610 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##162541e95e88414a881a088fb110a09e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4d749e3b12ad41baaadb70fd6bd2d91f] 时间: 2021-09-10 14:01:57,694 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##269b1488594c4685ac01fe74ffa3940e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:01:57,697 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##269b1488594c4685ac01fe74ffa3940e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:01:57,701 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##269b1488594c4685ac01fe74ffa3940e 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-09-10 14:01:57,737 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##269b1488594c4685ac01fe74ffa3940e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:01:57,739 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##269b1488594c4685ac01fe74ffa3940e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:01:57,743 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##162541e95e88414a881a088fb110a09e] (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 [##7230b1a2bf4844799bc831932d676d43] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:01:57,749 线程ID: 79 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##162541e95e88414a881a088fb110a09e 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:02:14,811 线程ID: 78 日志级别: 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 [##37f7d4263a304e1c956cf04f8b02b708] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:02:15,155 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##61d2f824552b45a78b61b501b5222b1a] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:02:15,157 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##37f7d4263a304e1c956cf04f8b02b708] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##61d2f824552b45a78b61b501b5222b1a] 时间: 2021-09-10 14:02:15,228 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##739b6295e718474e87c88ece6a933b96 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:02:15,230 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##739b6295e718474e87c88ece6a933b96 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:02:15,231 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##739b6295e718474e87c88ece6a933b96 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-09-10 14:02:15,263 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##739b6295e718474e87c88ece6a933b96 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:02:15,265 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##739b6295e718474e87c88ece6a933b96 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:02:15,268 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##37f7d4263a304e1c956cf04f8b02b708] (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 [##e0077c089c544b97ad2537baf64c4114] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:02:15,272 线程ID: 78 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##37f7d4263a304e1c956cf04f8b02b708 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:02:31,603 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##9ed4fa24dc754d2ca907542a45edeb97] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:02:31,947 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8dadd9cf612b427991b3f68220668a2a] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:02:31,949 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9ed4fa24dc754d2ca907542a45edeb97] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8dadd9cf612b427991b3f68220668a2a] 时间: 2021-09-10 14:02:32,021 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f5032818c48343faaa572a4d596ce941 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:02:32,024 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f5032818c48343faaa572a4d596ce941 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:02:32,028 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f5032818c48343faaa572a4d596ce941 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-09-10 14:02:32,061 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f5032818c48343faaa572a4d596ce941 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:02:32,063 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f5032818c48343faaa572a4d596ce941 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:02:32,067 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9ed4fa24dc754d2ca907542a45edeb97] (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 [##b0f2a6660af948ff9ea664554fb76705] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:02:32,072 线程ID: 65 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##9ed4fa24dc754d2ca907542a45edeb97 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:02:47,479 线程ID: 40 日志级别: 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 [##79e82b1dad7a4c398ef4c89c3831620e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:02:47,798 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##94ff2c1b7b1a4d9b911c347e449657bd] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:02:47,799 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##79e82b1dad7a4c398ef4c89c3831620e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##94ff2c1b7b1a4d9b911c347e449657bd] 时间: 2021-09-10 14:02:47,860 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b97ae99fe33a4a6db08ea70ea57743ed a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:02:47,863 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b97ae99fe33a4a6db08ea70ea57743ed SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:02:47,866 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b97ae99fe33a4a6db08ea70ea57743ed 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-09-10 14:02:47,895 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b97ae99fe33a4a6db08ea70ea57743ed SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:02:47,896 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b97ae99fe33a4a6db08ea70ea57743ed SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:02:47,900 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##79e82b1dad7a4c398ef4c89c3831620e] (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 [##28c32ab687b9418db96c6c204515caa6] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:02:47,905 线程ID: 40 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##79e82b1dad7a4c398ef4c89c3831620e 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:03:04,115 线程ID: 78 日志级别: 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 [##c68985c841f54e00b5c794441fb074fb] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:03:04,439 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##04769627e0cd476ea433464997dc0aa7] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:03:04,441 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c68985c841f54e00b5c794441fb074fb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##04769627e0cd476ea433464997dc0aa7] 时间: 2021-09-10 14:03:04,504 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f0f042f33a8347a6b51f9926f62ee4fe a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:03:04,506 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0f042f33a8347a6b51f9926f62ee4fe SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:03:04,509 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f0f042f33a8347a6b51f9926f62ee4fe 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-09-10 14:03:04,539 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0f042f33a8347a6b51f9926f62ee4fe SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:03:04,540 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0f042f33a8347a6b51f9926f62ee4fe SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:03:04,543 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c68985c841f54e00b5c794441fb074fb] (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 [##0480615e598841079cc335ef413ffacc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:03:04,548 线程ID: 78 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##c68985c841f54e00b5c794441fb074fb 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:03:38,819 线程ID: 78 日志级别: 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 [##bd36a431af574661a03dd525bff85917] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:03:39,144 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##720fe4e3a8b64405905be030a9a51f84] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:03:39,146 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bd36a431af574661a03dd525bff85917] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##720fe4e3a8b64405905be030a9a51f84] 时间: 2021-09-10 14:03:39,209 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e22ccef6fb8248f48a9fba226da1999c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:03:39,212 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e22ccef6fb8248f48a9fba226da1999c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:03:39,215 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e22ccef6fb8248f48a9fba226da1999c 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-09-10 14:03:39,246 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e22ccef6fb8248f48a9fba226da1999c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:03:39,247 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e22ccef6fb8248f48a9fba226da1999c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:03:39,251 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bd36a431af574661a03dd525bff85917] (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 [##cf550012ed1e4d1f84ea42ba0f0c0701] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:03:39,257 线程ID: 78 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##bd36a431af574661a03dd525bff85917 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:03:55,907 线程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 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 [##4ec2be3b38c443bf9252f41ac2c0229b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:03:56,222 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8c17bc98be2543d6826d665bf9789e16] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:03:56,223 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4ec2be3b38c443bf9252f41ac2c0229b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8c17bc98be2543d6826d665bf9789e16] 时间: 2021-09-10 14:03:56,287 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##af754e68ee1447b6969f89f61b072342 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:03:56,289 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##af754e68ee1447b6969f89f61b072342 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:03:56,291 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##af754e68ee1447b6969f89f61b072342 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-09-10 14:03:56,317 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##af754e68ee1447b6969f89f61b072342 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:03:56,318 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##af754e68ee1447b6969f89f61b072342 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:03:56,321 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##4ec2be3b38c443bf9252f41ac2c0229b] (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 [##4cfd72a8007e43c5835a7636703ac5bc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:03:56,325 线程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 [项目名称], GS.Pattern AS [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##4ec2be3b38c443bf9252f41ac2c0229b 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:56:09,152 线程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 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 [##111863489c5c4536990ad66ab234f829] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:56:09,490 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8b64203a053b4fd3ad5e68146f93b5ea] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:56:09,492 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##111863489c5c4536990ad66ab234f829] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8b64203a053b4fd3ad5e68146f93b5ea] 时间: 2021-09-10 14:56:09,567 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3fe6ba8246804eda95dd2758ddaad8aa a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:56:09,570 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3fe6ba8246804eda95dd2758ddaad8aa SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:56:09,572 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3fe6ba8246804eda95dd2758ddaad8aa 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-09-10 14:56:09,603 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3fe6ba8246804eda95dd2758ddaad8aa SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:56:09,604 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3fe6ba8246804eda95dd2758ddaad8aa SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:56:09,607 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##111863489c5c4536990ad66ab234f829] (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 [##bfb225fc935f4106bf6ee434f8825811] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:56:09,612 线程ID: 74 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##111863489c5c4536990ad66ab234f829 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, GS.Category 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, GS.Category 时间: 2021-09-10 14:56:29,628 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##9ddbefb60bed403b92f54d68d4cc9331] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 14:56:29,939 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8b1799295cca4f29babfd2ce80378fd9] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 14:56:29,941 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9ddbefb60bed403b92f54d68d4cc9331] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8b1799295cca4f29babfd2ce80378fd9] 时间: 2021-09-10 14:56:30,007 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##af732baf899844bda5feca1049a262bb a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 14:56:30,010 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##af732baf899844bda5feca1049a262bb SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 14:56:30,013 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##af732baf899844bda5feca1049a262bb 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-09-10 14:56:30,042 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##af732baf899844bda5feca1049a262bb SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 14:56:30,044 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##af732baf899844bda5feca1049a262bb SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 14:56:30,047 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9ddbefb60bed403b92f54d68d4cc9331] (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 [##54b6f876b9e845aa94c1b66bd280af8c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 14:56:30,051 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Pattern AS [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##9ddbefb60bed403b92f54d68d4cc9331 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, GS.Category 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, GS.Category 时间: 2021-09-10 17:30:40,560 线程ID: 18 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##d44bff4926bb421c9d9d22641588681e] ORDER BY Goods_no 时间: 2021-09-10 17:30:49,491 线程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 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 [##bc4e06ac5eda42c484ae4c67363beb1e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 17:30:49,848 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2ac19e12ef6d4e6d839be3dd76d3ffca] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 17:30:49,850 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc4e06ac5eda42c484ae4c67363beb1e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2ac19e12ef6d4e6d839be3dd76d3ffca] 时间: 2021-09-10 17:30:49,922 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##57e7cba0bb07478ca7365034d95fb10d a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 17:30:49,924 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##57e7cba0bb07478ca7365034d95fb10d SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 17:30:49,927 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##57e7cba0bb07478ca7365034d95fb10d 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-09-10 17:30:49,959 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##57e7cba0bb07478ca7365034d95fb10d SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 17:30:49,960 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##57e7cba0bb07478ca7365034d95fb10d SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 17:30:49,964 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bc4e06ac5eda42c484ae4c67363beb1e] (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 [##88fb624ea08348d3a7eac1845cac6566] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 17:30:49,969 线程ID: 29 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##bc4e06ac5eda42c484ae4c67363beb1e 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, GS.Category 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, GS.Category 时间: 2021-09-10 17:31:06,070 线程ID: 46 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##c63833d7eba34d6f864b44392269b6d7] ORDER BY Goods_no 时间: 2021-09-10 17:31:13,665 线程ID: 46 日志级别: 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 [##0ae731a165cd494399b14f7f713d3a19] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-09-10 17:31:13,980 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3bdf8c296b0a436aa2c57710539beafb] where 2=2 and ISNULL(S1,0)=0 时间: 2021-09-10 17:31:13,982 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ae731a165cd494399b14f7f713d3a19] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3bdf8c296b0a436aa2c57710539beafb] 时间: 2021-09-10 17:31:14,048 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c8efe1143e3241ddb3223fb56cea47b1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-09-10 17:31:14,051 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c8efe1143e3241ddb3223fb56cea47b1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-09-10 17:31:14,054 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c8efe1143e3241ddb3223fb56cea47b1 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-09-10 17:31:14,085 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c8efe1143e3241ddb3223fb56cea47b1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-09-10 17:31:14,086 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c8efe1143e3241ddb3223fb56cea47b1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-09-10 17:31:14,089 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ae731a165cd494399b14f7f713d3a19] (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 [##12b0a962ce234c62bcdc18e1360f0795] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-09-10 17:31:14,094 线程ID: 46 日志级别: 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 [款型], GS.Category AS [类别] INTO tempdb.dbo.[a1e931b4-99af-434a-9b05-fbb0c874355e] FROM ##0ae731a165cd494399b14f7f713d3a19 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, GS.Category 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, GS.Category 时间: 2021-09-10 17:31:37,450 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##e82a01e0376e419bb56c8d5cff395016] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-09-10 17:31:37,611 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e82a01e0376e419bb56c8d5cff395016] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##7ce01e463823436abf8b46c113b0fd96] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-09-10 17:31:37,616 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e82a01e0376e419bb56c8d5cff395016] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2021-09-10 17:31:48,357 线程ID: 15 日志级别: 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.[ffd27388-1648-40d6-80d7-3b0523b6ad5b] FROM [##72b59aed86464fc79c98107afcd0e79e] ORDER BY Goods_no 时间: 2021-09-10 17:32:02,279 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##c3adccaaf76e4c3f9f9aaf117116e796] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-09-10 17:32:02,456 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c3adccaaf76e4c3f9f9aaf117116e796] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##ce357a8c483a4f3899856456269f3626] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-09-10 17:32:02,459 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##c3adccaaf76e4c3f9f9aaf117116e796] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2021-09-10 17:32:04,979 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##d86c13bc55e44201a46263cf8920bb9a] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-09-10 17:32:05,153 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d86c13bc55e44201a46263cf8920bb9a] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##590187a2138e425e8e95440feedd99fc] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-09-10 17:32:05,155 线程ID: 44 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d86c13bc55e44201a46263cf8920bb9a] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2021-09-10 17:32:13,421 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##e22d0aab9c7a4f0ebda427d9863ebe91] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-09-10 17:32:13,592 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e22d0aab9c7a4f0ebda427d9863ebe91] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##132515da05e74b67a1870d3f70b54199] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-09-10 17:32:13,594 线程ID: 29 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e22d0aab9c7a4f0ebda427d9863ebe91] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2021-09-10 17:32:14,606 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##5801b0ce1fd547cfb90435016b0d497e] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-09-10 17:32:14,778 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5801b0ce1fd547cfb90435016b0d497e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##61a6589ba7614cdc9a2a72e6de6870f6] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-09-10 17:32:14,781 线程ID: 45 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##5801b0ce1fd547cfb90435016b0d497e] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2021-09-10 17:32:47,847 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##132782985a624c94b72faec696ff0e1c] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-09-10 17:32:48,077 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##132782985a624c94b72faec696ff0e1c] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##7fe3995224f142ff9e94efce960ea938] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-09-10 17:32:48,080 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##132782985a624c94b72faec696ff0e1c] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0)