时间: 2021-10-09 10:53:40,723 线程ID: 104 日志级别: 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 [##3dc07a690a1b474884a556c20a7db4e0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 10:53:41,075 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##262276ab018a4ea0881ed50f72c2dc2d] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 10:53:41,077 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3dc07a690a1b474884a556c20a7db4e0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##262276ab018a4ea0881ed50f72c2dc2d] 时间: 2021-10-09 10:53:41,145 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e73e854903104b7a8fcc74394bb50d6b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 10:53:41,148 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e73e854903104b7a8fcc74394bb50d6b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 10:53:41,151 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e73e854903104b7a8fcc74394bb50d6b 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-10-09 10:53:41,182 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e73e854903104b7a8fcc74394bb50d6b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 10:53:41,183 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e73e854903104b7a8fcc74394bb50d6b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 10:53:41,187 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3dc07a690a1b474884a556c20a7db4e0] (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 [##5d71acb1acfc42f9b854224e593c0f24] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 10:53:41,201 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[1fb4ea67-5fe5-4f68-a030-735f84df354b] FROM ##3dc07a690a1b474884a556c20a7db4e0 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-10-09 10:54:24,245 线程ID: 106 日志级别: 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.[6de323dd-f180-4d67-8e4c-1c29a3b60c05] FROM [##9b4230db49634fa581d59c891eb3eaff] ORDER BY Goods_no 时间: 2021-10-09 10:54:28,839 线程ID: 86 日志级别: 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.[6de323dd-f180-4d67-8e4c-1c29a3b60c05] FROM [##394747d77eeb488fa70a0f5d438fe1f8] ORDER BY Goods_no 时间: 2021-10-09 10:54:29,462 线程ID: 100 日志级别: 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.[6de323dd-f180-4d67-8e4c-1c29a3b60c05] FROM [##e5dd2821b37f40849d4012a2f922a8b4] ORDER BY Goods_no 时间: 2021-10-09 10:55:45,572 线程ID: 104 日志级别: 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 [##42fc41f9598f42e48b3985ae3297aec2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 10:55:45,924 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##045effb4842a4296b1cfbc5fa6049238] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 10:55:45,925 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##42fc41f9598f42e48b3985ae3297aec2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##045effb4842a4296b1cfbc5fa6049238] 时间: 2021-10-09 10:55:45,991 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7941138ab84a4dc4ab9bef7e2ae3e977 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 10:55:45,994 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7941138ab84a4dc4ab9bef7e2ae3e977 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 10:55:45,997 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7941138ab84a4dc4ab9bef7e2ae3e977 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-10-09 10:55:46,032 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7941138ab84a4dc4ab9bef7e2ae3e977 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 10:55:46,034 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7941138ab84a4dc4ab9bef7e2ae3e977 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 10:55:46,036 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##42fc41f9598f42e48b3985ae3297aec2] (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 [##e5adcea479f14c188a687fca63b02f7f] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 10:55:46,042 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[1fb4ea67-5fe5-4f68-a030-735f84df354b] FROM ##42fc41f9598f42e48b3985ae3297aec2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-10-09 10:56:09,299 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##9dd0b6201d4543f2828441e1ec2992b2] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 10:56:09,635 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4b508999a6aa4ed485d55655b270f2bb] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 10:56:09,637 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9dd0b6201d4543f2828441e1ec2992b2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4b508999a6aa4ed485d55655b270f2bb] 时间: 2021-10-09 10:56:09,705 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c169c425e6fd476ca3f1bcdae0803320 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 10:56:09,707 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c169c425e6fd476ca3f1bcdae0803320 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 10:56:09,710 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c169c425e6fd476ca3f1bcdae0803320 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-10-09 10:56:09,742 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c169c425e6fd476ca3f1bcdae0803320 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 10:56:09,744 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c169c425e6fd476ca3f1bcdae0803320 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 10:56:09,748 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9dd0b6201d4543f2828441e1ec2992b2] (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 [##976e4b0e8b624effb9d03d3eea309db3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 10:56:09,753 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[1fb4ea67-5fe5-4f68-a030-735f84df354b] FROM ##9dd0b6201d4543f2828441e1ec2992b2 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-10-09 10:57:10,557 线程ID: 102 日志级别: 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 [##ffe94faf71574d66a04635cb81f6e320] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 10:57:10,903 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##efbc7acd426144c6b9089c29a2d9511d] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 10:57:10,905 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ffe94faf71574d66a04635cb81f6e320] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##efbc7acd426144c6b9089c29a2d9511d] 时间: 2021-10-09 10:57:10,970 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eb35a7e10b144ad2bf4b5cde34ee1a42 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 10:57:10,973 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb35a7e10b144ad2bf4b5cde34ee1a42 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 10:57:10,977 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eb35a7e10b144ad2bf4b5cde34ee1a42 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-10-09 10:57:11,009 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb35a7e10b144ad2bf4b5cde34ee1a42 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 10:57:11,010 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eb35a7e10b144ad2bf4b5cde34ee1a42 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 10:57:11,013 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ffe94faf71574d66a04635cb81f6e320] (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 [##8bd5533a0c6f4882871263f5fc3632ef] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 10:57:11,019 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[1fb4ea67-5fe5-4f68-a030-735f84df354b] FROM ##ffe94faf71574d66a04635cb81f6e320 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-10-09 11:32:34,924 线程ID: 103 日志级别: 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 [##51f12e9b86c74596b68802edfb0c6e5a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 11:32:35,258 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4e6ed6788c044cd39e6e1782d27b3570] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 11:32:35,260 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##51f12e9b86c74596b68802edfb0c6e5a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4e6ed6788c044cd39e6e1782d27b3570] 时间: 2021-10-09 11:32:35,324 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a789a5a10c694bf8ad6ff7d6128b9915 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 11:32:35,325 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a789a5a10c694bf8ad6ff7d6128b9915 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 11:32:35,329 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a789a5a10c694bf8ad6ff7d6128b9915 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-10-09 11:32:35,359 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a789a5a10c694bf8ad6ff7d6128b9915 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 11:32:35,360 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a789a5a10c694bf8ad6ff7d6128b9915 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 11:32:35,363 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##51f12e9b86c74596b68802edfb0c6e5a] (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 [##cc665a18139746f78d34f7ff1aed3679] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 11:32:35,368 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[1fb4ea67-5fe5-4f68-a030-735f84df354b] FROM ##51f12e9b86c74596b68802edfb0c6e5a A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-10-09 11:40:40,903 线程ID: 100 日志级别: 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 [##42b92996c9f54d21a6ffa56713c35f47] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 11:40:41,242 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0a24dc0eced4415da4bb5f5940b5af77] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 11:40:41,244 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##42b92996c9f54d21a6ffa56713c35f47] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0a24dc0eced4415da4bb5f5940b5af77] 时间: 2021-10-09 11:40:41,307 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6fd25a2a41a4405692c8ce7b0f28db9f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 11:40:41,310 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6fd25a2a41a4405692c8ce7b0f28db9f SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 11:40:41,313 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##6fd25a2a41a4405692c8ce7b0f28db9f 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-10-09 11:40:41,345 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6fd25a2a41a4405692c8ce7b0f28db9f SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 11:40:41,346 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##6fd25a2a41a4405692c8ce7b0f28db9f SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 11:40:41,349 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##42b92996c9f54d21a6ffa56713c35f47] (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 [##a57bdda397c141b3bb7228f80369ff2c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 11:40:41,355 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[1fb4ea67-5fe5-4f68-a030-735f84df354b] FROM ##42b92996c9f54d21a6ffa56713c35f47 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-10-09 11:41:02,703 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[bf62225e-e420-4ec8-a898-e352276fbb19] FROM Customer A INNER JOIN [##0829997a63594e94b1fa252fe40ac29f] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2021-10-09 11:42:06,140 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##cc911146e9774dfba92b8fbef00ebbda] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2021-10-09 11:42:06,156 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##cc911146e9774dfba92b8fbef00ebbda] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##cc911146e9774dfba92b8fbef00ebbda] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2021-10-09 11:42:06,163 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##cc911146e9774dfba92b8fbef00ebbda] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END FROM [##cc911146e9774dfba92b8fbef00ebbda] A WHERE 1 = 1 时间: 2021-10-09 11:42:06,166 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##cc911146e9774dfba92b8fbef00ebbda A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##cc911146e9774dfba92b8fbef00ebbda WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##4e0a3120c7664b6c9212a99d3ee232ba] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2021-10-09 11:42:06,226 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##cc911146e9774dfba92b8fbef00ebbda A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##cc911146e9774dfba92b8fbef00ebbda WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##4e0a3120c7664b6c9212a99d3ee232ba] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2021-10-09 11:42:06,290 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##cc911146e9774dfba92b8fbef00ebbda A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount FROM DeliveryGoods A LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM ##cc911146e9774dfba92b8fbef00ebbda WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##4e0a3120c7664b6c9212a99d3ee232ba] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-10-09 11:42:06,423 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##cc911146e9774dfba92b8fbef00ebbda A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##cc911146e9774dfba92b8fbef00ebbda WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##4e0a3120c7664b6c9212a99d3ee232ba] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-10-09 11:42:06,935 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##cc911146e9774dfba92b8fbef00ebbda A INNER JOIN ( SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM ##cc911146e9774dfba92b8fbef00ebbda C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##4e0a3120c7664b6c9212a99d3ee232ba] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-10-09 11:42:07,165 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##cc911146e9774dfba92b8fbef00ebbda SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2021-10-09 11:42:07,167 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##cc911146e9774dfba92b8fbef00ebbda] A INNER JOIN ( SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo WHERE A.AccBillType = 'WareDelivery' AND EXISTS( SELECT 1 FROM [##cc911146e9774dfba92b8fbef00ebbda] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-10-09 11:42:07,205 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号] , Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号] , CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号] , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [结算额] , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数] , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数] , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[d496694a-e617-4154-9fec-21b5a78bf986] FROM [##cc911146e9774dfba92b8fbef00ebbda] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2021-10-09 12:01:55,948 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##54f97df6c96d4f35b49aa67d07b45121] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:01:55,956 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##54f97df6c96d4f35b49aa67d07b45121] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##54f97df6c96d4f35b49aa67d07b45121] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##2d20071c3f1846e2b679cdbc765e8730] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:01:56,090 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##54f97df6c96d4f35b49aa67d07b45121] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##54f97df6c96d4f35b49aa67d07b45121] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##2d20071c3f1846e2b679cdbc765e8730] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:01:56,195 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##54f97df6c96d4f35b49aa67d07b45121] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##54f97df6c96d4f35b49aa67d07b45121 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##2d20071c3f1846e2b679cdbc765e8730] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:01:56,393 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##54f97df6c96d4f35b49aa67d07b45121] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:01:56,395 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##54f97df6c96d4f35b49aa67d07b45121] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:02:16,033 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##32efd9e075614457a8605419c00e7dc0] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:02:16,038 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##32efd9e075614457a8605419c00e7dc0] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##32efd9e075614457a8605419c00e7dc0] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##9d6d80a3b6b34755805a00fa5bdb47b0] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:02:16,195 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##32efd9e075614457a8605419c00e7dc0] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##32efd9e075614457a8605419c00e7dc0] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##9d6d80a3b6b34755805a00fa5bdb47b0] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:02:16,353 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##32efd9e075614457a8605419c00e7dc0] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##32efd9e075614457a8605419c00e7dc0 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##9d6d80a3b6b34755805a00fa5bdb47b0] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:02:16,592 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##32efd9e075614457a8605419c00e7dc0] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:02:16,594 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##32efd9e075614457a8605419c00e7dc0] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:03:29,598 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##48cc4f537ef34a29aeafd61512f7125d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:03:29,602 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##48cc4f537ef34a29aeafd61512f7125d] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##48cc4f537ef34a29aeafd61512f7125d] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##4725e9c4b26b40fab9cc47c87b69526e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:03:29,720 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##48cc4f537ef34a29aeafd61512f7125d] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##48cc4f537ef34a29aeafd61512f7125d] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##4725e9c4b26b40fab9cc47c87b69526e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:03:29,841 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##48cc4f537ef34a29aeafd61512f7125d] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##48cc4f537ef34a29aeafd61512f7125d WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##4725e9c4b26b40fab9cc47c87b69526e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:03:30,062 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##48cc4f537ef34a29aeafd61512f7125d] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:03:30,065 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##48cc4f537ef34a29aeafd61512f7125d] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:04:39,243 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##587fdabe254643d19593d0c2b2fed94b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:04:39,247 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##587fdabe254643d19593d0c2b2fed94b] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##587fdabe254643d19593d0c2b2fed94b] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##7db61293bd9a453ba38361915555c887] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:04:39,381 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##587fdabe254643d19593d0c2b2fed94b] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##587fdabe254643d19593d0c2b2fed94b] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##7db61293bd9a453ba38361915555c887] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:04:39,510 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##587fdabe254643d19593d0c2b2fed94b] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##587fdabe254643d19593d0c2b2fed94b WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##7db61293bd9a453ba38361915555c887] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:04:39,733 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##587fdabe254643d19593d0c2b2fed94b] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:04:39,735 线程ID: 86 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##587fdabe254643d19593d0c2b2fed94b] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:04:59,482 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##49358c63f1b44a28b6c946fd0c7e660e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:04:59,486 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##49358c63f1b44a28b6c946fd0c7e660e] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##49358c63f1b44a28b6c946fd0c7e660e] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##fd741dc224264f448e03b5654a3a69b9] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:04:59,624 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##49358c63f1b44a28b6c946fd0c7e660e] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##49358c63f1b44a28b6c946fd0c7e660e] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##fd741dc224264f448e03b5654a3a69b9] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:04:59,749 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##49358c63f1b44a28b6c946fd0c7e660e] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##49358c63f1b44a28b6c946fd0c7e660e WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##fd741dc224264f448e03b5654a3a69b9] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:04:59,964 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##49358c63f1b44a28b6c946fd0c7e660e] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:04:59,966 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##49358c63f1b44a28b6c946fd0c7e660e] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:01,143 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##cd412a0b31d544bab4e15df15a28036b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:01,146 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##cd412a0b31d544bab4e15df15a28036b] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##cd412a0b31d544bab4e15df15a28036b] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##0f11fc3a91bb447c979805aadf8cc6a4] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:01,286 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##cd412a0b31d544bab4e15df15a28036b] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##cd412a0b31d544bab4e15df15a28036b] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##0f11fc3a91bb447c979805aadf8cc6a4] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:01,415 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##cd412a0b31d544bab4e15df15a28036b] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##cd412a0b31d544bab4e15df15a28036b WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##0f11fc3a91bb447c979805aadf8cc6a4] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:01,632 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##cd412a0b31d544bab4e15df15a28036b] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:01,634 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##cd412a0b31d544bab4e15df15a28036b] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:51,114 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##69b29c10325d4a51836fe19f0f799534] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:51,117 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##69b29c10325d4a51836fe19f0f799534] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##69b29c10325d4a51836fe19f0f799534] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##dc8d30934bda45b89c54e0baf20fef3d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:51,209 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##69b29c10325d4a51836fe19f0f799534] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##69b29c10325d4a51836fe19f0f799534] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##dc8d30934bda45b89c54e0baf20fef3d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:51,305 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##69b29c10325d4a51836fe19f0f799534] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##69b29c10325d4a51836fe19f0f799534 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##dc8d30934bda45b89c54e0baf20fef3d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:51,482 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##69b29c10325d4a51836fe19f0f799534] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:51,485 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##69b29c10325d4a51836fe19f0f799534] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:52,556 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:52,560 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##024649a3fb824acf92a6864f9a0fbc2e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:52,654 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##024649a3fb824acf92a6864f9a0fbc2e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:52,749 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##0c64d3a1950d4a35ad1991dd02f3b18c WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##024649a3fb824acf92a6864f9a0fbc2e] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:52,926 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0c64d3a1950d4a35ad1991dd02f3b18c] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:52,928 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##0c64d3a1950d4a35ad1991dd02f3b18c] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:53,184 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##ef6004ca530048b2818fab2c62ed1452] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:53,188 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##ef6004ca530048b2818fab2c62ed1452] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##ef6004ca530048b2818fab2c62ed1452] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##948f5ed56fc04cf192c20365783de5a1] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:53,282 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##ef6004ca530048b2818fab2c62ed1452] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##ef6004ca530048b2818fab2c62ed1452] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##948f5ed56fc04cf192c20365783de5a1] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:53,376 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##ef6004ca530048b2818fab2c62ed1452] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##ef6004ca530048b2818fab2c62ed1452 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##948f5ed56fc04cf192c20365783de5a1] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:53,549 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##ef6004ca530048b2818fab2c62ed1452] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:53,552 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##ef6004ca530048b2818fab2c62ed1452] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:53,772 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##84aad6ebab3c45ccb9986d73ab002880] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:53,775 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##84aad6ebab3c45ccb9986d73ab002880] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##84aad6ebab3c45ccb9986d73ab002880] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##97b7b9df77964f9a9f854f743b85fcc8] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:53,868 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##84aad6ebab3c45ccb9986d73ab002880] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##84aad6ebab3c45ccb9986d73ab002880] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##97b7b9df77964f9a9f854f743b85fcc8] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:53,960 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##84aad6ebab3c45ccb9986d73ab002880] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##84aad6ebab3c45ccb9986d73ab002880 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##97b7b9df77964f9a9f854f743b85fcc8] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:54,134 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##84aad6ebab3c45ccb9986d73ab002880] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:54,136 线程ID: 105 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##84aad6ebab3c45ccb9986d73ab002880] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:54,383 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##ac4ab62eb372424e853ba9f038f8b66a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:54,386 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##ac4ab62eb372424e853ba9f038f8b66a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##ac4ab62eb372424e853ba9f038f8b66a] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##253e8f03867c4ff581e03f522ece1a2a] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:54,478 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##ac4ab62eb372424e853ba9f038f8b66a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##ac4ab62eb372424e853ba9f038f8b66a] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##253e8f03867c4ff581e03f522ece1a2a] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:54,574 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##ac4ab62eb372424e853ba9f038f8b66a] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##ac4ab62eb372424e853ba9f038f8b66a WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##253e8f03867c4ff581e03f522ece1a2a] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:54,749 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##ac4ab62eb372424e853ba9f038f8b66a] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:54,753 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##ac4ab62eb372424e853ba9f038f8b66a] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 12:05:54,977 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo ) 时间: 2021-10-09 12:05:54,981 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinSSGoods] A WHERE EXISTS( SELECT 1 FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##56e3f3a74d89401da67538454818bff5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:55,073 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0) FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [ShopTinGoods] A WHERE EXISTS( SELECT 1 FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##56e3f3a74d89401da67538454818bff5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:55,214 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] A INNER JOIN ( SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopTinSSGoods] A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##74f6c574c2cc4fc2a73d4f0370720fa2 WHERE A.ShopTinID = ShopTinID ) AND EXISTS (SELECT 1 FROM [##56e3f3a74d89401da67538454818bff5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopTinID ) B ON A.ShopTinID = B.ShopTinID 时间: 2021-10-09 12:05:55,395 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##74f6c574c2cc4fc2a73d4f0370720fa2] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 时间: 2021-10-09 12:05:55,398 线程ID: 103 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期] , DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号] , TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[11803424-e5b9-4f83-9393-cc96795add63] FROM [##74f6c574c2cc4fc2a73d4f0370720fa2] ORDER BY Tin_Date DESC, ShopTinID ASC 时间: 2021-10-09 13:56:24,808 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##3ef96f88dddd43989ea1992e67fb6339] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-10-09 13:56:24,816 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##3ef96f88dddd43989ea1992e67fb6339] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##3ef96f88dddd43989ea1992e67fb6339 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##3c55be99f1094c7283ef41c48de10dcc] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-10-09 13:56:24,986 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[4e245fb9-599c-4abe-95e0-d9dde448336b] FROM [##3ef96f88dddd43989ea1992e67fb6339] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-10-09 13:58:58,728 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5d6c886839f648a89ba59ac862429463] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-10-09 13:58:58,732 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##5d6c886839f648a89ba59ac862429463] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##5d6c886839f648a89ba59ac862429463 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##97ef0a80e5694af5abb1b6a1bbf017d3] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-10-09 13:58:58,870 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[fa5b949e-25c3-4c3f-af3f-ca7d8d4b5eff] FROM [##5d6c886839f648a89ba59ac862429463] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-10-09 13:59:52,900 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##11922d3616694c689ee0a0fba2e9bb65] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-10-09 13:59:52,904 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##11922d3616694c689ee0a0fba2e9bb65] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##11922d3616694c689ee0a0fba2e9bb65 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##f4bbd1b7e776436480a19b0d92b3ec20] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-10-09 13:59:53,044 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[fdf2355e-15cd-4b0f-9999-daa7787d1418] FROM [##11922d3616694c689ee0a0fba2e9bb65] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-10-09 14:07:37,076 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[244a5c64-d49b-4b79-830b-64ee26a9be46] FROM Customer A INNER JOIN [##20bcdf1dc3964e16b49f27d98759a322] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2021-10-09 14:10:10,920 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##2d2d55ea399c49f9aff4c3dc7301a4f2] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2021-10-09 14:10:10,925 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##2d2d55ea399c49f9aff4c3dc7301a4f2] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##2d2d55ea399c49f9aff4c3dc7301a4f2 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##1780b0de55cf48c2bf6f165c264daa7a] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2021-10-09 14:10:11,205 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[a7233f4c-3a62-415c-aafa-06632e32b46f] FROM [##2d2d55ea399c49f9aff4c3dc7301a4f2] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2021-10-09 14:47:25,669 线程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 [##3e1c4af27f6046f19fa03d8ec2e747d8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 14:47:26,295 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##b70edfbf807f43e08bd40aa591ab67a8] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 14:47:26,300 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3e1c4af27f6046f19fa03d8ec2e747d8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b70edfbf807f43e08bd40aa591ab67a8] 时间: 2021-10-09 14:47:26,400 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##dbe4cadaaf9e4c0cbe33e2bd04f0eecd a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 14:47:26,408 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dbe4cadaaf9e4c0cbe33e2bd04f0eecd SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 14:47:26,414 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##dbe4cadaaf9e4c0cbe33e2bd04f0eecd 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-10-09 14:47:26,448 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dbe4cadaaf9e4c0cbe33e2bd04f0eecd SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 14:47:26,450 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##dbe4cadaaf9e4c0cbe33e2bd04f0eecd SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 14:47:26,475 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3e1c4af27f6046f19fa03d8ec2e747d8] (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 [##d3c6bbad14574d4a9e96893185a040a3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 14:47:26,485 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存] INTO tempdb.dbo.[f4334b5c-7257-446c-842f-855aebdb22d7] FROM ##3e1c4af27f6046f19fa03d8ec2e747d8 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice ORDER BY CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice 时间: 2021-10-09 14:48:07,192 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##9d55cbb8d8c9411cabc3929eb72b5a33] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 14:48:07,772 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##89efe5b0de25455d92f10d5c9083bd5b] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 14:48:07,778 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d55cbb8d8c9411cabc3929eb72b5a33] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##89efe5b0de25455d92f10d5c9083bd5b] 时间: 2021-10-09 14:48:07,872 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0f26601b38334dd09124d2a9752f8a12 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 14:48:07,879 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f26601b38334dd09124d2a9752f8a12 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 14:48:07,884 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0f26601b38334dd09124d2a9752f8a12 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-10-09 14:48:07,917 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f26601b38334dd09124d2a9752f8a12 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 14:48:07,918 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0f26601b38334dd09124d2a9752f8a12 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 14:48:07,926 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d55cbb8d8c9411cabc3929eb72b5a33] (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 [##9ebc9b49a8ec4a2c98cac35edbb2bbfd] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 14:48:07,936 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Category AS [类别], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存] INTO tempdb.dbo.[f4334b5c-7257-446c-842f-855aebdb22d7] FROM ##9d55cbb8d8c9411cabc3929eb72b5a33 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.Category, GS.Range, GS.UnitPrice ORDER BY CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.Category, GS.Range, GS.UnitPrice 时间: 2021-10-09 14:48:48,876 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##74dd5e3010d44bd29556a5a215049d6f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-10-09 14:48:49,500 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##606ae06d0c914af98acc8f0f2cfdb798] where 2=2 and ISNULL(S1,0)=0 时间: 2021-10-09 14:48:49,507 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##74dd5e3010d44bd29556a5a215049d6f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##606ae06d0c914af98acc8f0f2cfdb798] 时间: 2021-10-09 14:48:49,604 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##738efe9d6d554b4795a2ad49f9571d84 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-10-09 14:48:49,612 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##738efe9d6d554b4795a2ad49f9571d84 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-10-09 14:48:49,618 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##738efe9d6d554b4795a2ad49f9571d84 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-10-09 14:48:49,655 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##738efe9d6d554b4795a2ad49f9571d84 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-10-09 14:48:49,657 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##738efe9d6d554b4795a2ad49f9571d84 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-10-09 14:48:49,664 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##74dd5e3010d44bd29556a5a215049d6f] (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 [##e84a246024954b16a952222f59c2c70d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-10-09 14:48:49,676 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Category AS [类别], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存] INTO tempdb.dbo.[f4334b5c-7257-446c-842f-855aebdb22d7] FROM ##74dd5e3010d44bd29556a5a215049d6f 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.Category, GS.Range, GS.UnitPrice ORDER BY A.Goods_No, GS.Goods_Name, GS.Category, GS.Range, GS.UnitPrice