时间: 2022-03-30 10:29:17,054 线程ID: 139 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[04cd6a37-9ea1-4fab-8f09-677a83040d54] FROM [##35949ade13c74deebd11cd38bc9e7f59] ORDER BY Goods_no 时间: 2022-03-30 10:29:33,950 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##9d03eb4d1ee84ccea8e27b361ba2e154] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 10:29:34,322 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9a3c411412554bfb942b36386ae9e79b] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 10:29:34,323 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d03eb4d1ee84ccea8e27b361ba2e154] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9a3c411412554bfb942b36386ae9e79b] 时间: 2022-03-30 10:29:34,400 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0fb36c1073294efbbbc06f38c92b7ba8 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 10:29:34,402 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0fb36c1073294efbbbc06f38c92b7ba8 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 10:29:34,405 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0fb36c1073294efbbbc06f38c92b7ba8 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 = '退货' 时间: 2022-03-30 10:29:34,435 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0fb36c1073294efbbbc06f38c92b7ba8 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 10:29:34,437 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0fb36c1073294efbbbc06f38c92b7ba8 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 10:29:34,441 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d03eb4d1ee84ccea8e27b361ba2e154] (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 [##2f965078eceb44b2b766249f67db245d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 10:29:34,958 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4cd92e42d99e45b59a9bf181d5c66b4e] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 10:29:34,962 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##9d03eb4d1ee84ccea8e27b361ba2e154] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4cd92e42d99e45b59a9bf181d5c66b4e] 时间: 2022-03-30 10:29:34,965 线程ID: 7 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途] INTO tempdb.dbo.[53826217-2cd4-4b7e-9195-f888b8764c72] FROM ##9d03eb4d1ee84ccea8e27b361ba2e154 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2022-03-30 10:41:03,922 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##8bb89d2a40a34f2db1efd99a07d1f051] ORDER BY Goods_no 时间: 2022-03-30 10:41:07,233 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##672ccf8716e74959a97c4296b83d0754] ORDER BY Goods_no 时间: 2022-03-30 10:41:21,192 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##f987203b3084401a98753f2299d1d648] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 10:41:21,558 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9238a7efae6a4dfca0097150b8574f59] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 10:41:21,560 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f987203b3084401a98753f2299d1d648] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9238a7efae6a4dfca0097150b8574f59] 时间: 2022-03-30 10:41:21,615 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##564ed8764cf444eea2e058887377cc0b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 10:41:21,617 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##564ed8764cf444eea2e058887377cc0b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 10:41:21,619 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##564ed8764cf444eea2e058887377cc0b 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 = '退货' 时间: 2022-03-30 10:41:21,648 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##564ed8764cf444eea2e058887377cc0b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 10:41:21,649 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##564ed8764cf444eea2e058887377cc0b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 10:41:21,653 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f987203b3084401a98753f2299d1d648] (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 [##09ea54c9e52f416a9b02aa669d8ea064] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 10:41:21,657 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##f987203b3084401a98753f2299d1d648 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 10:41:52,091 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##00c204118d1d4b1d9453000302608a7a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 10:41:52,458 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3efffb3324194171912bb5ad951d9e8b] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 10:41:52,460 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##00c204118d1d4b1d9453000302608a7a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3efffb3324194171912bb5ad951d9e8b] 时间: 2022-03-30 10:41:52,513 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e3e96bf71805480f83aa04b1d4ca28ae a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 10:41:52,515 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e3e96bf71805480f83aa04b1d4ca28ae SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 10:41:52,518 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e3e96bf71805480f83aa04b1d4ca28ae 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 = '退货' 时间: 2022-03-30 10:41:52,548 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e3e96bf71805480f83aa04b1d4ca28ae SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 10:41:52,549 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e3e96bf71805480f83aa04b1d4ca28ae SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 10:41:52,551 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##00c204118d1d4b1d9453000302608a7a] (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 [##cd7c38d210d44be8810d2bd02a939fa3] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 10:41:52,556 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##00c204118d1d4b1d9453000302608a7a A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 10:55:54,560 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##ed1fdfebffb94e5683b709e193899fdc] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2022-03-30 10:55:54,563 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##ed1fdfebffb94e5683b709e193899fdc] 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 ##ed1fdfebffb94e5683b709e193899fdc WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##ecbd2ea3bdda4465927ab322c27331ad] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2022-03-30 10:55:54,779 线程ID: 14 日志级别: 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.[e97a553f-9d97-4177-925e-709388f47b8e] FROM [##ed1fdfebffb94e5683b709e193899fdc] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2022-03-30 10:57:05,491 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##f43ec87c269844cba01642ff4de06927] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2022-03-30 10:57:05,494 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##f43ec87c269844cba01642ff4de06927] 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 ##f43ec87c269844cba01642ff4de06927 WHERE A.BalanceID = BalanceID ) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2022-03-30 10:57:05,549 线程ID: 14 日志级别: 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.[160782b1-8a93-4e4e-8858-eadd098658dd] FROM [##f43ec87c269844cba01642ff4de06927] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2022-03-30 10:58:04,737 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5b37c8d341414ef194c56f1241a878c5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 10:58:04,745 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##5b37c8d341414ef194c56f1241a878c5] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##5b37c8d341414ef194c56f1241a878c5 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##04add1088e2f4f4396deaa3613f0a755] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 10:58:04,896 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##5b37c8d341414ef194c56f1241a878c5] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 10:58:48,920 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##55090ba74a9f4e6d9d349fe6a8dd1888] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 10:58:48,923 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##55090ba74a9f4e6d9d349fe6a8dd1888] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##55090ba74a9f4e6d9d349fe6a8dd1888 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##655f15564b0648ec8ec88b5744b83df9] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 10:58:49,038 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##55090ba74a9f4e6d9d349fe6a8dd1888] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 10:58:54,629 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##148449c085e44c458e6e813ea4d1f10b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 10:58:54,634 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##148449c085e44c458e6e813ea4d1f10b] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##148449c085e44c458e6e813ea4d1f10b WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##6c5b5568c69c4ad88e2074f7defc312e] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 10:58:54,787 线程ID: 73 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##148449c085e44c458e6e813ea4d1f10b] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:10:10,354 线程ID: 96 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##982c00db484142de950717f4f9e51a12] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:10:10,359 线程ID: 96 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##982c00db484142de950717f4f9e51a12] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##982c00db484142de950717f4f9e51a12 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##9e711b8c765d4851b30e04f7915bfa23] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:10:10,508 线程ID: 96 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[92e80565-a1a9-4f56-a9a0-f1d3abd16186] FROM [##982c00db484142de950717f4f9e51a12] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:10:10,859 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##fc344161bdb9438e822243809a5817f6] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:10:10,865 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##fc344161bdb9438e822243809a5817f6] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##fc344161bdb9438e822243809a5817f6 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##54f3de1f4b3d4f7e942a8a2e964ddac4] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:10:11,018 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[86872f14-8900-472c-b26b-387fd4523eee] FROM [##fc344161bdb9438e822243809a5817f6] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:18:02,951 线程ID: 151 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##72731f9eee56436fab6bbc514d798b34] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:18:02,956 线程ID: 151 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##72731f9eee56436fab6bbc514d798b34] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##72731f9eee56436fab6bbc514d798b34 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##6f46ede95f18477db978d44c7c3889ad] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:18:03,102 线程ID: 151 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##72731f9eee56436fab6bbc514d798b34] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:24:21,978 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##87b4a163b70f45299e744203fa922cc5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:24:21,982 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##87b4a163b70f45299e744203fa922cc5] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##87b4a163b70f45299e744203fa922cc5 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##09d3ab8d465a40debd3828bf093a3c19] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:24:22,130 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##87b4a163b70f45299e744203fa922cc5] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:28:10,209 线程ID: 146 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d2b61bb08c26484b8f3615ca6b04011b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:28:10,213 线程ID: 146 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d2b61bb08c26484b8f3615ca6b04011b] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##d2b61bb08c26484b8f3615ca6b04011b WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##bfe996ae59234addb5412e2ccb6e1843] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:28:10,359 线程ID: 146 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##d2b61bb08c26484b8f3615ca6b04011b] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:36:37,115 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##b6373adc02b94284ac535c1a71f23f7b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:36:37,120 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##b6373adc02b94284ac535c1a71f23f7b] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##b6373adc02b94284ac535c1a71f23f7b WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##92d7ef43af6e4a36a6705c2716dadfd8] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:36:37,260 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##b6373adc02b94284ac535c1a71f23f7b] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:36:38,181 线程ID: 101 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6e420053703141c5931a022ae681c131] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:36:38,185 线程ID: 101 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##6e420053703141c5931a022ae681c131] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##6e420053703141c5931a022ae681c131 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##d81ea818806348ee8eaeed79aacb4808] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:36:38,332 线程ID: 101 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##6e420053703141c5931a022ae681c131] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:42:55,281 线程ID: 143 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##01c461b9f2594f018773956367617667] ORDER BY Goods_no 时间: 2022-03-30 11:45:45,313 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##8ba5898c725640b6853d320fb018ed14] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:45:45,319 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##8ba5898c725640b6853d320fb018ed14] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##8ba5898c725640b6853d320fb018ed14 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##e4b8d052a19046729757d242c8708871] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:45:45,471 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##8ba5898c725640b6853d320fb018ed14] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:45:46,450 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##902be2f68adb4522bb10ac8c4c0268a9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:45:46,456 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##902be2f68adb4522bb10ac8c4c0268a9] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##902be2f68adb4522bb10ac8c4c0268a9 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##8e3fc1d5c61d40cbb1026cc3205db4d1] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:45:46,607 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##902be2f68adb4522bb10ac8c4c0268a9] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:45:47,516 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##b3cdf84e7eea43778f509a15a158beb9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:45:47,521 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##b3cdf84e7eea43778f509a15a158beb9] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##b3cdf84e7eea43778f509a15a158beb9 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##57ec78111c5b4d6d80991832471bcc60] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:45:47,670 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##b3cdf84e7eea43778f509a15a158beb9] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:45:57,215 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##2aa91366530244ac815314612e6bef6d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:45:57,220 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##2aa91366530244ac815314612e6bef6d] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##2aa91366530244ac815314612e6bef6d WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##0761009ec8674187a5fb91f310b14b40] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:45:57,384 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[615d6704-6799-423c-b8d2-28a57a94d810] FROM [##2aa91366530244ac815314612e6bef6d] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:48:07,798 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##44d1e7ecfa2e4875b0b7b5e7683640cb] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:48:07,802 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##44d1e7ecfa2e4875b0b7b5e7683640cb] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##44d1e7ecfa2e4875b0b7b5e7683640cb WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##01bec107ff714cf8817be92be34b1e06] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:48:07,963 线程ID: 93 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[819f87c7-dd26-4e8e-bfb0-225beff6f33e] FROM [##44d1e7ecfa2e4875b0b7b5e7683640cb] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:48:08,749 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##84116f50968749bb8660d7f767d9ebfb] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:48:08,753 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##84116f50968749bb8660d7f767d9ebfb] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##84116f50968749bb8660d7f767d9ebfb WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##4fe31218b6ac4152a9cfaed15e4ca2ab] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:48:08,916 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[819f87c7-dd26-4e8e-bfb0-225beff6f33e] FROM [##84116f50968749bb8660d7f767d9ebfb] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 11:48:09,708 线程ID: 139 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##bb73662872a14558bf8ba17a51972d5a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 11:48:09,712 线程ID: 139 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##bb73662872a14558bf8ba17a51972d5a] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##bb73662872a14558bf8ba17a51972d5a WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##cc6e900a5b1b4706a7f075a7facf5062] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 11:48:09,869 线程ID: 139 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[819f87c7-dd26-4e8e-bfb0-225beff6f33e] FROM [##bb73662872a14558bf8ba17a51972d5a] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:39,983 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##230a6b8bed6f4ca49a64505832e0fcf2] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:40,027 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##230a6b8bed6f4ca49a64505832e0fcf2] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##230a6b8bed6f4ca49a64505832e0fcf2 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##14cee8c063b84fec92ee2d4f16e2ac9a] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:40,141 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##230a6b8bed6f4ca49a64505832e0fcf2] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:44,560 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6fe28d37977743b8b92f72b72043b935] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:44,563 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##6fe28d37977743b8b92f72b72043b935] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##6fe28d37977743b8b92f72b72043b935 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##f5ef9448ced04628a240eee85a281978] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:44,677 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##6fe28d37977743b8b92f72b72043b935] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:46,659 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d6abd935ddbb40bda2109fb23af601e9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:46,662 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d6abd935ddbb40bda2109fb23af601e9] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##d6abd935ddbb40bda2109fb23af601e9 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##223f9cd7dae442fdafa879b533864f5b] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:46,782 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##d6abd935ddbb40bda2109fb23af601e9] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:47,463 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5696c74accb540c4ac1207696669f57c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:47,465 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##5696c74accb540c4ac1207696669f57c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##5696c74accb540c4ac1207696669f57c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##1640bc5daff24d669244415cd1ff6141] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:47,582 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##5696c74accb540c4ac1207696669f57c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:47,759 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##af537e46b24f4ebfa0795eb8ce95c7c4] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:47,762 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##af537e46b24f4ebfa0795eb8ce95c7c4] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##af537e46b24f4ebfa0795eb8ce95c7c4 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##491b1bbbf18a4f61ac0bd3e211dd959b] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:47,878 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##af537e46b24f4ebfa0795eb8ce95c7c4] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:48,052 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##46400b34514e4c569a80c1a1e14ff543] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:48,054 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##46400b34514e4c569a80c1a1e14ff543] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##46400b34514e4c569a80c1a1e14ff543 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##54b71ddae07b4956909a42dc5e50e8ed] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:48,168 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##46400b34514e4c569a80c1a1e14ff543] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:48,573 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##700ba8be6def4467ba08e9034392c345] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:48,576 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##700ba8be6def4467ba08e9034392c345] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##700ba8be6def4467ba08e9034392c345 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##7e0c5023ca434ed6ade4655017309b68] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:48,691 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##700ba8be6def4467ba08e9034392c345] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:54,275 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1b5da383cae942f7a1cf00a38edb2845] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:54,277 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##1b5da383cae942f7a1cf00a38edb2845] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##1b5da383cae942f7a1cf00a38edb2845 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##48e2e3e984474b69ba5914ce56b13151] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:54,387 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##1b5da383cae942f7a1cf00a38edb2845] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:55,350 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##81f0d59dc0d04433b3d65dbc5dc1edf8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:55,355 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##81f0d59dc0d04433b3d65dbc5dc1edf8] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##81f0d59dc0d04433b3d65dbc5dc1edf8 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##72a6d31c3ee74de09e6119389164bc01] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:55,483 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##81f0d59dc0d04433b3d65dbc5dc1edf8] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:14:57,591 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1981c880de2440daaa53dea4853901f6] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:14:57,593 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##1981c880de2440daaa53dea4853901f6] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##1981c880de2440daaa53dea4853901f6 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##b55be24182b8485382ec0967f170ae6d] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:14:57,709 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##1981c880de2440daaa53dea4853901f6] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:16:58,500 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##7e83383306d9402c9e5f6dbe8a63e26c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:16:58,505 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##7e83383306d9402c9e5f6dbe8a63e26c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##7e83383306d9402c9e5f6dbe8a63e26c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##8f4fa3e6050746c6ba2f5444089f417e] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:16:58,656 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[483c8c8e-4e99-4261-a9ae-14340493e39d] FROM [##7e83383306d9402c9e5f6dbe8a63e26c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:23:25,020 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##dea6d8e3b63a43cbb2d2362dbfda6d42] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:23:25,023 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##dea6d8e3b63a43cbb2d2362dbfda6d42] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##dea6d8e3b63a43cbb2d2362dbfda6d42 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##79ecbc3b4bf7450383c62eced3e37bfb] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:23:25,140 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##dea6d8e3b63a43cbb2d2362dbfda6d42] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 12:23:30,269 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##4150277609fa41eb8de5944de4bd370a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 12:23:30,271 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##4150277609fa41eb8de5944de4bd370a] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##4150277609fa41eb8de5944de4bd370a WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##6a038501e7234db3805af473727ecb49] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 12:23:30,386 线程ID: 22 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##4150277609fa41eb8de5944de4bd370a] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:22,753 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##ba0abe1167964458988931d26309e19f] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:22,756 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##ba0abe1167964458988931d26309e19f] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##ba0abe1167964458988931d26309e19f WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##f62dd2a43a0b4ce6a9768bba77c6c7ef] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:22,869 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##ba0abe1167964458988931d26309e19f] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:23,051 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c100830fcd624a11a62fbb33762cb51e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:23,054 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c100830fcd624a11a62fbb33762cb51e] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##c100830fcd624a11a62fbb33762cb51e WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##1252b775184a47bfa733f64eabcec950] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:23,168 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##c100830fcd624a11a62fbb33762cb51e] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:27,184 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##4f636bead6c14b3abb674dd595710951] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:27,188 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##4f636bead6c14b3abb674dd595710951] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##4f636bead6c14b3abb674dd595710951 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##4abed73d3a3948ccbc3c7305d919075a] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:27,303 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##4f636bead6c14b3abb674dd595710951] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:27,476 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a9ae07d9304a47afae4905829da3631d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:27,479 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##a9ae07d9304a47afae4905829da3631d] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##a9ae07d9304a47afae4905829da3631d WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##133f51b715f84ee09d6625a79b92a10d] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:27,593 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##a9ae07d9304a47afae4905829da3631d] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:28,806 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##091aeeb9dcfe4eb89fb3d8a81fdc59cf] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:28,809 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##091aeeb9dcfe4eb89fb3d8a81fdc59cf] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##091aeeb9dcfe4eb89fb3d8a81fdc59cf WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##7c0a2014a820406ba8854980887cda4a] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:28,925 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##091aeeb9dcfe4eb89fb3d8a81fdc59cf] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:32,751 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##7d50bb9246604b77b18a39b7189e4f7a] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:32,754 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##7d50bb9246604b77b18a39b7189e4f7a] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##7d50bb9246604b77b18a39b7189e4f7a WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##8af8fb7ab1f64361969f04a8da55132b] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:32,870 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##7d50bb9246604b77b18a39b7189e4f7a] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:06:44,348 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##4c5cf7d6de444087a487fb1223867bf7] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:06:44,351 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##4c5cf7d6de444087a487fb1223867bf7] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##4c5cf7d6de444087a487fb1223867bf7 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##92427e20105d42af896e561455db2358] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:06:44,465 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##4c5cf7d6de444087a487fb1223867bf7] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:01,915 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##552e6d61b8f14f92bb7372862ddd0608] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:01,918 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##552e6d61b8f14f92bb7372862ddd0608] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##552e6d61b8f14f92bb7372862ddd0608 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##f3715a382230484dac1039fc569b90b8] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:02,034 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##552e6d61b8f14f92bb7372862ddd0608] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:02,511 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##9c8ba949b5ad46d992ab665ceda88e5c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:02,514 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##9c8ba949b5ad46d992ab665ceda88e5c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##9c8ba949b5ad46d992ab665ceda88e5c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##efccd1c36b4d45cb816966a745903861] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:02,630 线程ID: 52 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##9c8ba949b5ad46d992ab665ceda88e5c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:02,818 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##29e645fe5ad04d7faec437faf17198e2] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:02,821 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##29e645fe5ad04d7faec437faf17198e2] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##29e645fe5ad04d7faec437faf17198e2 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##8d7834f53bd34805b75bd802916c3f68] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:02,937 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##29e645fe5ad04d7faec437faf17198e2] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:03,109 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##fc870764838544d58d08f11b34151f66] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:03,112 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##fc870764838544d58d08f11b34151f66] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##fc870764838544d58d08f11b34151f66 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##26dffcdc7c4641d691c4b1d78e3b1299] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:03,229 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##fc870764838544d58d08f11b34151f66] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:03,414 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e2dcbaca2e7545b99788fcfc7f9bb851] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:03,417 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##e2dcbaca2e7545b99788fcfc7f9bb851] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##e2dcbaca2e7545b99788fcfc7f9bb851 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##43077ce26248454597a2e97420622701] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:03,534 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##e2dcbaca2e7545b99788fcfc7f9bb851] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:03,709 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##8b96fecde8c44a37b8c9e0a4f077c7cb] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:03,713 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##8b96fecde8c44a37b8c9e0a4f077c7cb] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##8b96fecde8c44a37b8c9e0a4f077c7cb WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##459273f2fb084b3daea624cc71439a93] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:03,831 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##8b96fecde8c44a37b8c9e0a4f077c7cb] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:42,609 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##59d6ec85918b45128424d319cff7e7ca] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:42,612 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##59d6ec85918b45128424d319cff7e7ca] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##59d6ec85918b45128424d319cff7e7ca WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##49594631d65e4a358607cf870b6e3e3f] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:42,732 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##59d6ec85918b45128424d319cff7e7ca] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:44,707 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##b513d6e1e4d249ce98d7971332e681ae] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:44,711 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##b513d6e1e4d249ce98d7971332e681ae] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##b513d6e1e4d249ce98d7971332e681ae WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##6c3de0eb1362439189a2f3af60125a4b] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:44,828 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##b513d6e1e4d249ce98d7971332e681ae] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:45,899 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##91d97f8539664a248fa765f257844126] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:45,902 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##91d97f8539664a248fa765f257844126] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##91d97f8539664a248fa765f257844126 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##921cfcbb6d95459f8fc308ec7597919e] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:46,025 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##91d97f8539664a248fa765f257844126] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:47,279 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d4dbc78c9cb543cd98b5ec32ddd7b326] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:47,282 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##d4dbc78c9cb543cd98b5ec32ddd7b326] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##d4dbc78c9cb543cd98b5ec32ddd7b326 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##9975b642f781458dab6c18cdc4b5b470] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:47,407 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##d4dbc78c9cb543cd98b5ec32ddd7b326] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:56,625 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##215663c9facb437281e1aae84da815f4] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:56,629 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##215663c9facb437281e1aae84da815f4] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##215663c9facb437281e1aae84da815f4 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##345a06bdb453422db3042cf9ff227ec6] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:56,754 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##215663c9facb437281e1aae84da815f4] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:07:57,152 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##b7b3dd5add564ef58de998e28acb3d7c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:07:57,156 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##b7b3dd5add564ef58de998e28acb3d7c] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##b7b3dd5add564ef58de998e28acb3d7c WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##ede974aeeeed4babbb1f219aadb794f9] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:07:57,275 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##b7b3dd5add564ef58de998e28acb3d7c] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:08:07,857 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##92bbfb7efd574297adecc5f7b1848b79] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:08:07,863 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##92bbfb7efd574297adecc5f7b1848b79] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##92bbfb7efd574297adecc5f7b1848b79 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##c272cdbcfec54ce5ad237a5a4ac93842] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:08:08,021 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##92bbfb7efd574297adecc5f7b1848b79] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:40:20,108 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##943416472d654e309bb9f05f08635693] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:40:20,114 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##943416472d654e309bb9f05f08635693] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##943416472d654e309bb9f05f08635693 WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##3cbb15d632dd479db5b08a585d63293c] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:40:20,264 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##943416472d654e309bb9f05f08635693] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:40:22,042 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##af52b812e4b54c5c98e97ff26659831d] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2022-03-30 13:40:22,048 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##af52b812e4b54c5c98e97ff26659831d] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##af52b812e4b54c5c98e97ff26659831d WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##64a239e5819a44eca4875c1a3ac73f8f] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2022-03-30 13:40:22,200 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号] , PdStock_Date AS [盘点日期], PdTimes 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.[52659f36-d8c6-4081-a9d4-f262f76fbd70] FROM [##af52b812e4b54c5c98e97ff26659831d] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2022-03-30 13:41:44,257 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##f4a5101078654b0784649a9fb2454c07] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2022-03-30 13:41:44,263 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##f4a5101078654b0784649a9fb2454c07] 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 ##f4a5101078654b0784649a9fb2454c07 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##1904da661bda40b99923d12fa9854c40] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2022-03-30 13:41:44,473 线程ID: 8 日志级别: 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.[e97a553f-9d97-4177-925e-709388f47b8e] FROM [##f4a5101078654b0784649a9fb2454c07] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2022-03-30 13:44:02,354 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a82c0f5b193446dab4f2ae19718b8420] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2022-03-30 13:44:02,357 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##a82c0f5b193446dab4f2ae19718b8420] 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 ##a82c0f5b193446dab4f2ae19718b8420 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##37a9afc03fa34c14981f550a6b39d1ee] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2022-03-30 13:44:02,569 线程ID: 34 日志级别: 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.[e97a553f-9d97-4177-925e-709388f47b8e] FROM [##a82c0f5b193446dab4f2ae19718b8420] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2022-03-30 14:18:37,529 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##20048441f4494af7abd83bee083ae372] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2022-03-30 14:18:37,533 线程ID: 24 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##20048441f4494af7abd83bee083ae372] 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 ##20048441f4494af7abd83bee083ae372 WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##314cf587b62a467a938b6ed7de6f89f3] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2022-03-30 14:18:37,717 线程ID: 24 日志级别: 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.[e97a553f-9d97-4177-925e-709388f47b8e] FROM [##20048441f4494af7abd83bee083ae372] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2022-03-30 14:24:28,025 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##153725557db74889817895f768813cb4] ORDER BY Goods_no 时间: 2022-03-30 14:24:42,526 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##78a77db708a04247a0ac1a2ddb29d8e0] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 14:24:42,968 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7742dc8b2fe34e32b111d7ce7e1800b5] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 14:24:42,971 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##78a77db708a04247a0ac1a2ddb29d8e0] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7742dc8b2fe34e32b111d7ce7e1800b5] 时间: 2022-03-30 14:24:43,032 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9c17f4eb4e2640828ce1d66944737afa a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 14:24:43,035 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9c17f4eb4e2640828ce1d66944737afa SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 14:24:43,039 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9c17f4eb4e2640828ce1d66944737afa 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 = '退货' 时间: 2022-03-30 14:24:43,074 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9c17f4eb4e2640828ce1d66944737afa SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 14:24:43,076 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9c17f4eb4e2640828ce1d66944737afa SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 14:24:43,080 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##78a77db708a04247a0ac1a2ddb29d8e0] (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 [##6da42b581a8d484294f08037ce6851b8] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 14:24:43,094 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##78a77db708a04247a0ac1a2ddb29d8e0 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 14:25:07,899 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##e3b4fe37dc70460f8e7054dfdb14497d] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 14:25:08,310 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##b6d39f87419f4f2ca40ce10f6f9f4172] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 14:25:08,313 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e3b4fe37dc70460f8e7054dfdb14497d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##b6d39f87419f4f2ca40ce10f6f9f4172] 时间: 2022-03-30 14:25:08,366 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c3d0f98a59cf4a19b52621b84e066281 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 14:25:08,368 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c3d0f98a59cf4a19b52621b84e066281 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 14:25:08,372 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c3d0f98a59cf4a19b52621b84e066281 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 = '退货' 时间: 2022-03-30 14:25:08,408 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c3d0f98a59cf4a19b52621b84e066281 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 14:25:08,410 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c3d0f98a59cf4a19b52621b84e066281 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 14:25:08,414 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e3b4fe37dc70460f8e7054dfdb14497d] (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 [##f9d26c7a24ef4c01b49840c806198169] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 14:25:08,420 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##e3b4fe37dc70460f8e7054dfdb14497d A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 14:42:44,020 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##1e6cb1da0041400598a71265ec8a32e4] ORDER BY Goods_no 时间: 2022-03-30 14:43:00,568 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##07215ac22eb04f00b121a02dfc67eb22] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 14:43:00,900 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##dc9f827159dc47e6854ea13f8eb45892] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 14:43:00,901 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##07215ac22eb04f00b121a02dfc67eb22] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##dc9f827159dc47e6854ea13f8eb45892] 时间: 2022-03-30 14:43:00,951 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f0e4221d93924ab49a5bfb5c18d7f355 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 14:43:00,954 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0e4221d93924ab49a5bfb5c18d7f355 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 14:43:00,957 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f0e4221d93924ab49a5bfb5c18d7f355 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 = '退货' 时间: 2022-03-30 14:43:00,990 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0e4221d93924ab49a5bfb5c18d7f355 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 14:43:00,991 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f0e4221d93924ab49a5bfb5c18d7f355 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 14:43:00,995 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##07215ac22eb04f00b121a02dfc67eb22] (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 [##743685c47e3f4fae9f6386e0e2a14178] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 14:43:01,000 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##07215ac22eb04f00b121a02dfc67eb22 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 14:43:25,106 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##00304f8288c240668e6d670274215457] ORDER BY Goods_no 时间: 2022-03-30 14:43:26,182 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##ab02658c47a54992a7876438d65362ec] ORDER BY Goods_no 时间: 2022-03-30 14:43:39,388 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##cbb0128de55849cc84ef689f1a4bdb11] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 14:43:39,704 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##e31556a08e4d427e98c541ea4f4a71f5] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 14:43:39,705 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbb0128de55849cc84ef689f1a4bdb11] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e31556a08e4d427e98c541ea4f4a71f5] 时间: 2022-03-30 14:43:39,756 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##252a4e7b28d44f6eafd9e2757168ed5a a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 14:43:39,758 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##252a4e7b28d44f6eafd9e2757168ed5a SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 14:43:39,759 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##252a4e7b28d44f6eafd9e2757168ed5a 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 = '退货' 时间: 2022-03-30 14:43:39,789 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##252a4e7b28d44f6eafd9e2757168ed5a SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 14:43:39,791 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##252a4e7b28d44f6eafd9e2757168ed5a SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 14:43:39,794 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbb0128de55849cc84ef689f1a4bdb11] (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 [##d652c8a990034bf3abe8b9a7079841d7] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 14:43:39,798 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##cbb0128de55849cc84ef689f1a4bdb11 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 16:43:26,445 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##5298ae2ccef0453ea77e8e2cb8088bd9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2022-03-30 16:43:26,471 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##5298ae2ccef0453ea77e8e2cb8088bd9] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##5298ae2ccef0453ea77e8e2cb8088bd9] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2022-03-30 16:43:26,478 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##5298ae2ccef0453ea77e8e2cb8088bd9] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2022-03-30 16:43:26,486 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##5298ae2ccef0453ea77e8e2cb8088bd9] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2022-03-30 16:43:26,495 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##30b8661e070a44568e022e110e3eaa08] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2022-03-30 16:43:26,599 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##30b8661e070a44568e022e110e3eaa08] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2022-03-30 16:43:26,705 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 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 ##5298ae2ccef0453ea77e8e2cb8088bd9 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##30b8661e070a44568e022e110e3eaa08] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-03-30 16:43:26,825 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 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 ##5298ae2ccef0453ea77e8e2cb8088bd9 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##30b8661e070a44568e022e110e3eaa08] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-03-30 16:43:27,170 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##5298ae2ccef0453ea77e8e2cb8088bd9 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 ##5298ae2ccef0453ea77e8e2cb8088bd9 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##30b8661e070a44568e022e110e3eaa08] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-03-30 16:43:27,525 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5298ae2ccef0453ea77e8e2cb8088bd9 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2022-03-30 16:43:27,527 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##5298ae2ccef0453ea77e8e2cb8088bd9] 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 [##5298ae2ccef0453ea77e8e2cb8088bd9] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-03-30 16:43:27,561 线程ID: 25 日志级别: 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.[ff8f21b0-ae76-4f2f-8970-0d6f99915324] FROM [##5298ae2ccef0453ea77e8e2cb8088bd9] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-03-30 16:48:47,473 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##9a622836fef84d8db227ef1ace4885b3] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##9a622836fef84d8db227ef1ace4885b3] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-03-30 16:48:47,542 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##9a622836fef84d8db227ef1ace4885b3] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##9a622836fef84d8db227ef1ace4885b3] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-03-30 16:48:47,608 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##9a622836fef84d8db227ef1ace4885b3] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##9a622836fef84d8db227ef1ace4885b3] WHERE A.DealereturnID = DealereturnID ) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-03-30 16:48:47,672 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##9a622836fef84d8db227ef1ace4885b3] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##9a622836fef84d8db227ef1ace4885b3] WHERE A.RenoticeID = RenoticeID ) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-03-30 16:48:47,707 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##9a622836fef84d8db227ef1ace4885b3] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##9a622836fef84d8db227ef1ace4885b3] WHERE A.PuReturnID = PuReturnID ) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2022-03-30 16:48:47,742 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##9a622836fef84d8db227ef1ace4885b3 A 时间: 2022-03-30 16:48:47,746 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[0105961e-20a0-438c-a4aa-1b3dcdefadc8] FROM [##9a622836fef84d8db227ef1ace4885b3] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-03-30 17:09:04,786 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[934cc7c5-dc26-4bf0-9dc0-0459089da242] FROM [##15f7611262724e5885b083aec54192c3] ORDER BY Goods_no 时间: 2022-03-30 17:09:17,101 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##c8c34d8db45a4a1eb29607ffd558a024] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-03-30 17:09:17,451 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##feebb645aa374651abc8a20c5167092f] where 2=2 and ISNULL(S1,0)=0 时间: 2022-03-30 17:09:17,453 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c8c34d8db45a4a1eb29607ffd558a024] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##feebb645aa374651abc8a20c5167092f] 时间: 2022-03-30 17:09:17,505 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##41c07b663bc34ffc880da7bd841103cf a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-03-30 17:09:17,507 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##41c07b663bc34ffc880da7bd841103cf SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-03-30 17:09:17,509 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##41c07b663bc34ffc880da7bd841103cf 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 = '退货' 时间: 2022-03-30 17:09:17,537 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##41c07b663bc34ffc880da7bd841103cf SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-03-30 17:09:17,539 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##41c07b663bc34ffc880da7bd841103cf SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-03-30 17:09:17,542 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c8c34d8db45a4a1eb29607ffd558a024] (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 [##a3ac072c19c2400cba10cfe45b3cd05c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-03-30 17:09:17,545 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[349bf80a-efb2-42f1-9602-6d749747ffa0] FROM ##c8c34d8db45a4a1eb29607ffd558a024 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, A.ColorID 时间: 2022-03-30 17:40:15,625 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##80be59f8e7c0432bb8a12adbbbbe072d] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##80be59f8e7c0432bb8a12adbbbbe072d] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##80be59f8e7c0432bb8a12adbbbbe072d] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##80be59f8e7c0432bb8a12adbbbbe072d] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##80be59f8e7c0432bb8a12adbbbbe072d] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##80be59f8e7c0432bb8a12adbbbbe072d] WHERE A.Purchase_ID = Purchase_ID ) GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0) FROM [##80be59f8e7c0432bb8a12adbbbbe072d] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity FROM PuReceipt A INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID WHERE 1 = 1 AND A.[Type] = 1 GROUP BY A.Purchase_ID ) B ON A.Purchase_ID = B.Purchase_ID UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0) FROM [##80be59f8e7c0432bb8a12adbbbbe072d] A INNER JOIN ( SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No WHERE EXISTS( SELECT 1 FROM [##80be59f8e7c0432bb8a12adbbbbe072d] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-03-30 17:40:15,734 线程ID: 47 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式], rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], BillAmount AS [采购额], PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异], DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[4456f03c-e6bc-4700-b2bc-b18a80319b05] FROM [##80be59f8e7c0432bb8a12adbbbbe072d] ORDER BY Receipt_Date DESC, PureceiptID ASC