时间: 2022-11-05 11:50:13,563 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##7c1c5b9b12aa4a949a53a8279715584a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-05 11:50:13,947 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##207e411db11b488e8eb976e7ced4a589] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-05 11:50:13,949 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7c1c5b9b12aa4a949a53a8279715584a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##207e411db11b488e8eb976e7ced4a589] 时间: 2022-11-05 11:50:14,016 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##001b1610ba4042c6a9a388faddef0a0c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 11:50:14,018 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##001b1610ba4042c6a9a388faddef0a0c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 11:50:14,020 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##001b1610ba4042c6a9a388faddef0a0c 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-11-05 11:50:14,048 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##001b1610ba4042c6a9a388faddef0a0c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 11:50:14,050 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##001b1610ba4042c6a9a388faddef0a0c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 11:50:14,054 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7c1c5b9b12aa4a949a53a8279715584a] (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 [##05687707ada34cb7951c0af3537ec41e] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-11-05 11:50:14,060 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##f5b97d1cf1464ab89d2e6c5f423e7866 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##cc07938ab7be4b1a93d8865b1b3f56ac] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##c325e366fb9743ecbf9df636cdcd3bc4] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >='2022/10/6' AND CheckDate <='2022-11-05' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-05 11:50:14,086 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f5b97d1cf1464ab89d2e6c5f423e7866 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 11:50:14,087 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f5b97d1cf1464ab89d2e6c5f423e7866 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 11:50:14,089 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f5b97d1cf1464ab89d2e6c5f423e7866 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-11-05 11:50:14,119 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f5b97d1cf1464ab89d2e6c5f423e7866 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 11:50:14,120 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f5b97d1cf1464ab89d2e6c5f423e7866 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 11:50:14,123 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7c1c5b9b12aa4a949a53a8279715584a(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##6782de05185f46e392f0391037467c1f WHERE CheckDate BETWEEN '2022/10/30' AND '2022-11-05 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##7c1c5b9b12aa4a949a53a8279715584a(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##6782de05185f46e392f0391037467c1f WHERE CheckDate BETWEEN '2022/10/22' AND '2022-11-05 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##7c1c5b9b12aa4a949a53a8279715584a(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##6782de05185f46e392f0391037467c1f WHERE CheckDate BETWEEN '2022/10/7' AND '2022-11-05 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-05 11:50:14,365 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##04407f2292374cd898b8bb8f9110656b] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-05 11:50:14,366 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7c1c5b9b12aa4a949a53a8279715584a] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##04407f2292374cd898b8bb8f9110656b] 时间: 2022-11-05 11:50:14,470 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7c1c5b9b12aa4a949a53a8279715584a] (Customer_ID, Goods_No, ColorID, Long, 批发在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, (ISNULL([S1], 0)) FROM [##8156a86e9aa94e21ab8cd04f36226490] 时间: 2022-11-05 11:50:14,532 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7c1c5b9b12aa4a949a53a8279715584a] (Customer_ID, Goods_No, ColorID, Long , 调拨在途#数量) SELECT TinShop, Goods_No, ColorID, Long, (ISNULL([S1], 0)) FROM [##63e1212a34ca4f8496295c9d450598ef] 时间: 2022-11-05 11:50:14,534 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_id, B.Goods_No, C.ColorID, C.Long , MIN(a.Delivery_Date) as MinDeliveryDate , MAX(a.Delivery_Date) as MaxDeliveryDate INTO ##6dbfaf41e23b4ba1ac319c99249c149e FROM Delivery a INNER JOIN DeliveryGoods b on A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID WHERE A.Type IN (1,2) AND A.Posted=1 AND EXISTS (SELECT 1 FROM [##cc07938ab7be4b1a93d8865b1b3f56ac] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##c325e366fb9743ecbf9df636cdcd3bc4] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_id,B.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 11:50:14,603 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##572b20cbdac94d26b2d67fea4fc088a9 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##cc07938ab7be4b1a93d8865b1b3f56ac] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##c325e366fb9743ecbf9df636cdcd3bc4] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 11:50:14,667 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##84f9a45056964b04807ec7c8eb2c3d4c FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##cc07938ab7be4b1a93d8865b1b3f56ac] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##c325e366fb9743ecbf9df636cdcd3bc4] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-05' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-05 11:50:14,705 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##84f9a45056964b04807ec7c8eb2c3d4c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 11:50:14,707 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##84f9a45056964b04807ec7c8eb2c3d4c SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 11:50:14,711 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##84f9a45056964b04807ec7c8eb2c3d4c 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-11-05 11:50:14,743 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##84f9a45056964b04807ec7c8eb2c3d4c SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 11:50:14,745 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##84f9a45056964b04807ec7c8eb2c3d4c SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 11:50:14,748 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7c1c5b9b12aa4a949a53a8279715584a(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##b8bc22c42c0743438a6497b365e75df2 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-05 11:50:14,753 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long, max(A.DeliveryID) as DeliveryID INTO ##f4ed517460a440b49a0078af24500f3c FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##6dbfaf41e23b4ba1ac319c99249c149e T ON T.Customer_id = A.Customer_id AND T.Goods_No=b.Goods_No AND T.MaxDeliveryDate = A.Delivery_Date WHERE A.Type in (1,2) AND A.Posted=1 GROUP BY A.Customer_ID,b.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 11:50:14,775 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long, A.Mode, SUM(b.Quantity) as Quantity INTO ##5844d5eeab0947abaec18c53dcd459cb FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##f4ed517460a440b49a0078af24500f3c T ON T.Customer_ID = A.Customer_ID AND T.Goods_No=b.Goods_No AND T.DeliveryID = A.DeliveryID AND T.ColorID = C.ColorID AND T.Long = C.Long WHERE 1=1 AND EXISTS (SELECT 1 FROM [##cc07938ab7be4b1a93d8865b1b3f56ac] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##c325e366fb9743ecbf9df636cdcd3bc4] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_ID, B.Goods_No, A.Mode, C.ColorID, C.Long 时间: 2022-11-05 11:50:14,904 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.Tin_Date) AS MaxLoadInDate INTO ##7b7ca904c9de4373b48153363b1da1bb FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND Type = 2 AND EXISTS (SELECT 1 FROM [##cc07938ab7be4b1a93d8865b1b3f56ac] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##c325e366fb9743ecbf9df636cdcd3bc4] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 11:50:14,971 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.CheckDate) AS MaxCheckDate INTO ##a3d622c4c2af4ed5b7a6f34a13071096 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##cc07938ab7be4b1a93d8865b1b3f56ac] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##c325e366fb9743ecbf9df636cdcd3bc4] WHERE Goods_No = B.Goods_No) GROUP BY a.Customer_ID, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 11:50:15,051 线程ID: 23 日志级别: 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 [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Long AS [内长], GS.UnitPrice AS [吊牌价], SUM(A.[批发在途#数量]) AS [配发在途#数量], SUM(A.[调拨在途#数量]) AS [调拨在途#数量], DATEDIFF ( day, MIN(T9.MinShopTinDate),getdate()) as 在店天数, CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CONVERT(VARCHAR(10), MIN(T5.MinDeliveryDate), 120) AS [最早发货日期], CONVERT(VARCHAR(10), MAX(T5.MaxDeliveryDate), 120) AS [最后发货日期], CONVERT(VARCHAR(10), MIN(T9.MinShopTinDate), 120) AS [最早收货日期], CONVERT(VARCHAR(10), MIN(T9.MaxShopTinDate), 120) AS [最后收货日期], T6.Mode AS [最后发货方式], MAX(T6.Quantity) AS [最后发货数量], MAX(T7.MaxLoadInDate) AS [最后调入日期], MAX(T8.MaxCheckDate) AS [最后销售日期], SUM(A.[7DayCheckQuantity]) AS [1周销售数量], SUM(A.[7DayCheckAmount]) AS [1周销售生意额], SUM(A.[15DayCheckQuantity]) AS [2周销售数量(15天)], SUM(A.[15DayCheckAmount]) AS [2周销售生意额(15天)], SUM(A.[30DayCheckQuantity]) AS [月销售数量], SUM(A.[30DayCheckAmount]) AS [月销售生意额], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM(A.[AllDayCheckAmount]) AS [累销售生意额], SUM([渠道库存#S1]) AS [渠道库存#S1], SUM([渠道库存#数量]) AS [渠道库存#数量], SUM([渠道库存#数量] * GS.UnitPrice) AS [渠道库存#吊牌额], SUM([销售#S1]) AS [销售#S1], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([销售#数量] * GS.UnitPrice) AS [销售#吊牌额], SUM([渠道在途#S1]) AS [渠道在途#S1], SUM([渠道在途#数量]) AS [渠道在途#数量], SUM([渠道在途#数量] * GS.UnitPrice) AS [渠道在途#吊牌额], ISNULL(SUM([渠道库存#S1]), 0) + ISNULL(SUM([渠道在途#S1]), 0) AS [渠道库存(含在途)#S1], ISNULL(SUM([渠道库存#数量]),0)+ISNULL(SUM([渠道在途#数量]),0) AS [渠道库存(含在途)#数量], (ISNULL(SUM(ISNULL([渠道库存#数量],0) * ISNULL(GS.UnitPrice,0)),0) + ISNULL(SUM(ISNULL([渠道在途#数量], 0) * ISNULL(GS.UnitPrice,0)),0)) AS [渠道库存(含在途)#吊牌额], CASE WHEN SUM(A.销售#数量*GS.UnitPrice)=0 THEN NULL ELSE CAST(SUM(A.销售#金额)/SUM(A.销售#数量*GS.UnitPrice) AS NUMERIC(29,2)) END AS [平均折扣], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[bc9308be-7a9e-4ac5-be81-ad3fd43e9730] FROM ##7c1c5b9b12aa4a949a53a8279715584a 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 LEFT JOIN ##6dbfaf41e23b4ba1ac319c99249c149e T5 ON A.Goods_No = T5.Goods_No AND A.Customer_ID = T5.Customer_ID AND T5.ColorID=A.ColorID AND T5.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##5844d5eeab0947abaec18c53dcd459cb T6 ON A.Goods_No = T6.Goods_No AND A.Customer_ID = T6.Customer_ID AND ISNULL(A.ItemType,0) = 0 AND T6.ColorID=A.ColorID AND T6.Long=A.Long LEFT JOIN ##572b20cbdac94d26b2d67fea4fc088a9 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##7b7ca904c9de4373b48153363b1da1bb T7 ON A.Goods_No = T7.Goods_No AND A.Customer_ID = T7.Customer_ID AND T7.ColorID=A.ColorID AND T7.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##a3d622c4c2af4ed5b7a6f34a13071096 T8 ON A.Goods_No = T8.Goods_No AND A.Customer_ID = T8.Customer_ID AND T8.ColorID=A.ColorID AND T8.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID 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, VGC.Color, DC.ColorGroup, A.Long, GS.UnitPrice, T6.Mode 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, VGC.Color, DC.ColorGroup, A.Long, GS.UnitPrice, T6.Mode 时间: 2022-11-05 12:00:59,133 线程ID: 11 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##f404893393804b13bdea08ef14879215] ORDER BY Goods_no 时间: 2022-11-05 12:06:08,380 线程ID: 7 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##5d23d72d187243f2b77540bdc308c286] ORDER BY Goods_no 时间: 2022-11-05 12:08:55,554 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##9ad90702519245538fdb45cd19726d1a] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##9ad90702519245538fdb45cd19726d1a] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 12:08:55,582 线程ID: 17 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[6e911371-226e-44d7-9a1e-e85e3f0552ff] FROM [##9ad90702519245538fdb45cd19726d1a] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-05 13:07:31,984 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] 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 [##185c1ebbc6d84ad1adb775b1eb430b8c] 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 [##185c1ebbc6d84ad1adb775b1eb430b8c] 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 [##185c1ebbc6d84ad1adb775b1eb430b8c] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-05 13:07:32,090 线程ID: 75 日志级别: 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.[83cd9b5f-e7c8-451f-b741-5524f157217b] FROM [##185c1ebbc6d84ad1adb775b1eb430b8c] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-05 13:22:16,911 线程ID: 76 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##821e09c0bf634bb9a93a0d82bb756b14] ORDER BY Goods_no 时间: 2022-11-05 13:22:23,217 线程ID: 33 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##40bccb99f55549ca8595b64aa05d2d57] ORDER BY Goods_no 时间: 2022-11-05 13:22:29,009 线程ID: 78 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##7458e2ddff0445ac803108cbdd93a0cd] ORDER BY Goods_no 时间: 2022-11-05 13:22:35,060 线程ID: 33 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##a142d5f46d634026a24430669a7d846d] ORDER BY Goods_no 时间: 2022-11-05 13:22:37,287 线程ID: 33 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##2d997c41ec2445719ed4517d9daacc1d] ORDER BY Goods_no 时间: 2022-11-05 13:22:37,980 线程ID: 56 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##5d8fa31aad9e4774a8c6981ec8f36f2b] ORDER BY Goods_no 时间: 2022-11-05 13:22:55,917 线程ID: 76 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##254f9bd76b0b4f548387a845f3ab8719] ORDER BY Goods_no 时间: 2022-11-05 13:24:13,458 线程ID: 56 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##a283c912064f4de798a19be2f0868af0] ORDER BY Goods_no 时间: 2022-11-05 13:24:52,902 线程ID: 75 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##a75e9fbd1cec4be28dc7d1b83c4e8857] ORDER BY Goods_no 时间: 2022-11-05 13:25:40,282 线程ID: 56 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##c37f4d8e9c4447bf9f7383cb519ecae3] ORDER BY Goods_no 时间: 2022-11-05 14:13:18,243 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##cdea6bca976543a2a57482d0bf532f8e] ORDER BY Goods_no 时间: 2022-11-05 14:16:36,425 线程ID: 56 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##f1af1350a6e44841ae785e6da51b9e46] ORDER BY Goods_no 时间: 2022-11-05 14:16:41,461 线程ID: 27 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##aa87c5feddc5414dbe97dfcc93661725] ORDER BY Goods_no 时间: 2022-11-05 14:18:41,670 线程ID: 11 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##f4a6c804bcd34351abcc4ea8ac26ff8f] ORDER BY Goods_no 时间: 2022-11-05 14:18:46,134 线程ID: 19 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##4444da7ff9ae4ee7b65d8ee8eb85d248] ORDER BY Goods_no 时间: 2022-11-05 14:18:50,163 线程ID: 19 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##4255e2e2b4414d56b5d5533e207f9081] ORDER BY Goods_no 时间: 2022-11-05 14:19:36,265 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##2fc7d225046c49c2b684a3b4ae21e267] ORDER BY Goods_no 时间: 2022-11-05 14:20:09,080 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##1707cabd341c44e3a76f857d3d3a3a58] ORDER BY Goods_no 时间: 2022-11-05 14:20:15,196 线程ID: 11 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##b24faf1f53644d37a4cfd9ab9329c5c3] ORDER BY Goods_no 时间: 2022-11-05 14:20:25,550 线程ID: 11 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##730913aa4002400394e6ee30cdf073cd] ORDER BY Goods_no 时间: 2022-11-05 14:25:11,207 线程ID: 32 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##757061d19f0c47b38d5ac5b8d9b4341f] ORDER BY Goods_no 时间: 2022-11-05 14:25:16,895 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##d2e53d755adb48a682895ae8b7665344] ORDER BY Goods_no 时间: 2022-11-05 14:25:21,787 线程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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##a41ae8aa61224a479e00d71e56b85de1] ORDER BY Goods_no 时间: 2022-11-05 14:26:30,388 线程ID: 23 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##d52bdeb10a4b4aa18d065f15efa9f151] ORDER BY Goods_no 时间: 2022-11-05 14:28:11,708 线程ID: 8 日志级别: 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 [##49806ed04d804f5c89a0e1ef4db2337b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-05 14:28:12,083 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5f97b482a7804e51a941633b904ba550] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-05 14:28:12,084 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##49806ed04d804f5c89a0e1ef4db2337b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5f97b482a7804e51a941633b904ba550] 时间: 2022-11-05 14:28:12,145 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e2ba6043a5cd448580c60122a9701c2e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 14:28:12,146 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e2ba6043a5cd448580c60122a9701c2e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 14:28:12,148 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e2ba6043a5cd448580c60122a9701c2e 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-11-05 14:28:12,176 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e2ba6043a5cd448580c60122a9701c2e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 14:28:12,177 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e2ba6043a5cd448580c60122a9701c2e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 14:28:12,180 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##49806ed04d804f5c89a0e1ef4db2337b] (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 [##a886705003db44148992b2d7e532f733] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-11-05 14:28:12,426 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f2f737b747a04b2faae41cd1c34e4984] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-05 14:28:12,428 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##49806ed04d804f5c89a0e1ef4db2337b] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f2f737b747a04b2faae41cd1c34e4984] 时间: 2022-11-05 14:28:12,430 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##8b9be16400d5498db9d3445ac41af3a1 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##0b2244e9cdb94c59994a243c553ef478] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##f5759969d6e24507be6c99685b9714df] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 14:28:12,494 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##4dac7da24b164ee68cf41351c36e1c35 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##0b2244e9cdb94c59994a243c553ef478] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##f5759969d6e24507be6c99685b9714df] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-05' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-05 14:28:12,532 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4dac7da24b164ee68cf41351c36e1c35 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 14:28:12,534 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4dac7da24b164ee68cf41351c36e1c35 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 14:28:12,535 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4dac7da24b164ee68cf41351c36e1c35 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-11-05 14:28:12,564 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4dac7da24b164ee68cf41351c36e1c35 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 14:28:12,566 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4dac7da24b164ee68cf41351c36e1c35 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 14:28:12,568 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##49806ed04d804f5c89a0e1ef4db2337b(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##94cfad953fe8476aa03dfb063cf36700 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-05 14:28:12,572 线程ID: 8 日志级别: 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 [货号], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途], SUM(A.[AllDayCheckQuantity]) AS [累销数量], GS.Range AS [系列] INTO tempdb.dbo.[3c14963f-a64b-4f65-a850-04ecb3bea11c] FROM ##49806ed04d804f5c89a0e1ef4db2337b 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 LEFT JOIN ##8b9be16400d5498db9d3445ac41af3a1 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 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.Range 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.Range 时间: 2022-11-05 14:28:35,421 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##2b11a51cddd24b5e8de17a1386b016b5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-05 14:28:35,805 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##35133c7a7a91461aa411acd530239acd] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-05 14:28:35,807 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b11a51cddd24b5e8de17a1386b016b5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##35133c7a7a91461aa411acd530239acd] 时间: 2022-11-05 14:28:35,872 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##61ccb71c324b43779cae9cd9d05d80d2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 14:28:35,874 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61ccb71c324b43779cae9cd9d05d80d2 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 14:28:35,875 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##61ccb71c324b43779cae9cd9d05d80d2 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-11-05 14:28:35,906 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61ccb71c324b43779cae9cd9d05d80d2 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 14:28:35,908 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##61ccb71c324b43779cae9cd9d05d80d2 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 14:28:35,911 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b11a51cddd24b5e8de17a1386b016b5] (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 [##75f7e6e5ff284c208f3e709424b13248] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-11-05 14:28:36,154 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8e0a5c4c5f27430195846167e13a6273] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-05 14:28:36,157 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2b11a51cddd24b5e8de17a1386b016b5] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8e0a5c4c5f27430195846167e13a6273] 时间: 2022-11-05 14:28:36,158 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##e189c1e6fb734ac3bec98a325d341299 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##7b4bd65a2c1a44bba749e3131d9d8203] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##c8582aee071c45048a93988e2ac581d8] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-05 14:28:36,230 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##b4d5cd4378074ac3adf073a6ebf132d6 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID INNER JOIN [##7b4bd65a2c1a44bba749e3131d9d8203] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##c8582aee071c45048a93988e2ac581d8] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-05' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-11-05 14:28:36,265 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b4d5cd4378074ac3adf073a6ebf132d6 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-05 14:28:36,267 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b4d5cd4378074ac3adf073a6ebf132d6 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-05 14:28:36,272 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b4d5cd4378074ac3adf073a6ebf132d6 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-11-05 14:28:36,307 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b4d5cd4378074ac3adf073a6ebf132d6 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-05 14:28:36,308 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b4d5cd4378074ac3adf073a6ebf132d6 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-05 14:28:36,312 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2b11a51cddd24b5e8de17a1386b016b5(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##f7a3b070dddc47319de99f87842e69b5 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-05 14:28:36,317 线程ID: 21 日志级别: 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 [货号], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途], SUM(A.[AllDayCheckQuantity]) AS [累销数量], GS.Range AS [系列] INTO tempdb.dbo.[3c14963f-a64b-4f65-a850-04ecb3bea11c] FROM ##2b11a51cddd24b5e8de17a1386b016b5 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 LEFT JOIN ##e189c1e6fb734ac3bec98a325d341299 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 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.Range 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.Range 时间: 2022-11-05 14:29:51,366 线程ID: 8 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##76e5eae57ebf4cae85aa43676511b0cb] ORDER BY Goods_no 时间: 2022-11-05 14:30:18,672 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##4a840fd1c3af418f96e7fe839ef53c16] ORDER BY Goods_no 时间: 2022-11-05 14:53:17,362 线程ID: 36 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##389d91d495544c1bbe2b5556abd1e43d] ORDER BY Goods_no 时间: 2022-11-05 14:55:37,576 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##045b3eb16d894f0c86d00f55ee739bd8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2022-11-05 14:55:37,582 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##045b3eb16d894f0c86d00f55ee739bd8] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##045b3eb16d894f0c86d00f55ee739bd8] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2022-11-05 14:55:37,588 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##045b3eb16d894f0c86d00f55ee739bd8] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-05 14:55:37,592 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##045b3eb16d894f0c86d00f55ee739bd8] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-05 14:55:37,595 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##045b3eb16d894f0c86d00f55ee739bd8 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##045b3eb16d894f0c86d00f55ee739bd8 WHERE A.SortingID = SortingID ) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2022-11-05 14:55:37,608 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##045b3eb16d894f0c86d00f55ee739bd8 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##045b3eb16d894f0c86d00f55ee739bd8 WHERE A.OrderID = OrderID ) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2022-11-05 14:55:37,620 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##045b3eb16d894f0c86d00f55ee739bd8 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 ##045b3eb16d894f0c86d00f55ee739bd8 WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 14:55:37,652 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##045b3eb16d894f0c86d00f55ee739bd8 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 ##045b3eb16d894f0c86d00f55ee739bd8 WHERE B.DeliveryID = DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 14:55:37,759 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##045b3eb16d894f0c86d00f55ee739bd8 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 ##045b3eb16d894f0c86d00f55ee739bd8 C WHERE B.DeliveryID = C.DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 14:55:37,823 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##045b3eb16d894f0c86d00f55ee739bd8 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2022-11-05 14:55:37,825 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##045b3eb16d894f0c86d00f55ee739bd8] 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 [##045b3eb16d894f0c86d00f55ee739bd8] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 14:55:37,861 线程ID: 21 日志级别: 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.[66daed6b-61e8-4ec0-84fd-a6d9fedb9540] FROM [##045b3eb16d894f0c86d00f55ee739bd8] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-05 14:59:20,760 线程ID: 74 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##42d5a428d61f4759b2b3a6d8d156285e] ORDER BY Goods_no 时间: 2022-11-05 15:00:56,793 线程ID: 68 日志级别: 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.[e55cfc20-f184-4687-9285-1e607f3bfe67] FROM [##a453b165ecda488190374bbefec4c368] ORDER BY Goods_no 时间: 2022-11-05 15:18:06,262 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##1aa48d3d7d95400fa86d19f1cb0dda78] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-05 15:18:41,765 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##74a8499d0c8048bbb48d531acb707e9b] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-05 15:18:42,995 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##8ec040f1707d462b83f3cab97373b256] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-05 15:24:27,985 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e120ecb9ba5349f2ae93c21b6ec3261d] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##e120ecb9ba5349f2ae93c21b6ec3261d] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##cea3aabf3d634e40b6baa84111ef86e4] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 15:24:28,071 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[6e911371-226e-44d7-9a1e-e85e3f0552ff] FROM [##e120ecb9ba5349f2ae93c21b6ec3261d] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-05 15:29:01,790 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##10fcf3cbb03f46c29fa5d59ea6fc8669] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##10fcf3cbb03f46c29fa5d59ea6fc8669] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##97431c846eaa4d278acba3f80a069ef6] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:29:01,878 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[2052b3a8-bccf-4760-810c-8c284fad0497] FROM [##10fcf3cbb03f46c29fa5d59ea6fc8669] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:29:02,211 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##4998fdcc08974e67ad42c36d6eceed71] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##4998fdcc08974e67ad42c36d6eceed71] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##b2fee49f91684030a2be525b27fc20a5] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:29:02,295 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[a043e8f2-f8ed-4e1f-b79c-5ed89aadd3e1] FROM [##4998fdcc08974e67ad42c36d6eceed71] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:29:35,741 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##13579da4da154f269b497de0c6e50340] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##13579da4da154f269b497de0c6e50340] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##1a86fd9f88064fe6bcf7e2fc70b44d5a] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:29:35,820 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[240176f5-4cba-41d0-8a60-ec6404ead477] FROM [##13579da4da154f269b497de0c6e50340] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:29:36,140 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##58a07fc44d304aef80cf7a655eae1041] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##58a07fc44d304aef80cf7a655eae1041] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##249605fdfe734c1cafc96df33ad69538] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:29:36,218 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[24dbdb6a-e272-4579-bd6d-b3142116516f] FROM [##58a07fc44d304aef80cf7a655eae1041] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:29:51,808 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##5c4d9023cf36413e8c0b95206034a6bb] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##5c4d9023cf36413e8c0b95206034a6bb] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##02632c80a260455c99f4150788b659ae] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:29:51,887 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[8dfd2360-4e34-4e6c-80ca-1f3838a1ae28] FROM [##5c4d9023cf36413e8c0b95206034a6bb] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:29:52,199 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##31a125f260ac4cdaaf1c8eadd95e814a] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##31a125f260ac4cdaaf1c8eadd95e814a] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##332d6cb80c44415eb704117af4d01020] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:29:52,281 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[30b9d59f-e4ec-4b5e-aeb6-8b88c7893628] FROM [##31a125f260ac4cdaaf1c8eadd95e814a] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:30:51,101 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##bf2034f929314062a9d53dce4a056fcd] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##bf2034f929314062a9d53dce4a056fcd] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##df1c0613e2eb4381b6837ed93f6bedb3] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:30:51,181 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[82d1c4c1-ef02-4159-98b9-34b0ad8622e8] FROM [##bf2034f929314062a9d53dce4a056fcd] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:30:51,510 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##2e184b7a623941b0a04c315b0c4f1a78] A INNER JOIN ( SELECT A.ApplyOutID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount , SUM(ISNULL(A.Quantity,0) * ISNULL(G.UnitPrice,0)) As DpAmount FROM ApplyOutGoods A LEFT JOIN Goods G ON A.Goods_No=G.Goods_No WHERE EXISTS( SELECT 1 FROM [##2e184b7a623941b0a04c315b0c4f1a78] WHERE A.ApplyOutID = ApplyOutID ) AND EXISTS (SELECT 1 FROM [##729820617a3a4c419a2572c0f936e7b0] WHERE Goods_No = A.Goods_No) GROUP BY A.ApplyOutID ) B ON A.ApplyOutID = B.ApplyOutID 时间: 2022-11-05 15:30:51,592 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期], rtrim(ToutWarehouse_no) AS [调出仓库编号], ToutWarehouse_Na AS [调出仓库名称], rtrim(TinWarehouse_no) AS [调入仓库编号], TinWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[3130b8bb-716a-4b0c-bb58-0ffb3518f7ae] FROM [##2e184b7a623941b0a04c315b0c4f1a78] ORDER BY Esti_Date DESC, ApplyOutID ASC 时间: 2022-11-05 15:32:53,434 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##7b18de28b77d402998b9e733b27ba8b2] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##7b18de28b77d402998b9e733b27ba8b2] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##e43cf7282bb24e8895f05b09b90d6882] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 15:32:53,547 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[3e41d073-215d-41c8-b53e-7c7786f16f9d] FROM [##7b18de28b77d402998b9e733b27ba8b2] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-05 15:32:53,954 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##caee294bd5f34e62b636b84801b1f7d5] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount, SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount FROM DeliveryGoods A LEFT JOIN Goods G ON A.Goods_No = G.Goods_No WHERE EXISTS( SELECT 1 FROM [##caee294bd5f34e62b636b84801b1f7d5] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##9547a9176403469881749102f76af572] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-05 15:32:54,073 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], Quantity AS [数量], DpAmount AS [吊牌额], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[ae6e607e-eda6-4b54-a530-66305d69801a] FROM [##caee294bd5f34e62b636b84801b1f7d5] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-05 15:36:43,597 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##978dfcaeb54141ddb85cecbe2a6d8279] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:36:43,605 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##978dfcaeb54141ddb85cecbe2a6d8279] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##978dfcaeb54141ddb85cecbe2a6d8279].ShopToutID = ShopToutID) 时间: 2022-11-05 15:36:43,610 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##978dfcaeb54141ddb85cecbe2a6d8279] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##978dfcaeb54141ddb85cecbe2a6d8279] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:36:43,617 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##978dfcaeb54141ddb85cecbe2a6d8279] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##978dfcaeb54141ddb85cecbe2a6d8279 WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##fb79f9977141405bb89f4e64b6703167] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:36:43,804 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##978dfcaeb54141ddb85cecbe2a6d8279] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##978dfcaeb54141ddb85cecbe2a6d8279] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##fb79f9977141405bb89f4e64b6703167] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:36:44,158 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##978dfcaeb54141ddb85cecbe2a6d8279] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:36:44,161 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[bf300bdf-054e-4e39-b675-2160b935188f] FROM [##978dfcaeb54141ddb85cecbe2a6d8279] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:36:48,226 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##927cb1f99f84406482411c0887465603] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:36:48,232 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##927cb1f99f84406482411c0887465603] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##927cb1f99f84406482411c0887465603].ShopToutID = ShopToutID) 时间: 2022-11-05 15:36:48,237 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##927cb1f99f84406482411c0887465603] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##927cb1f99f84406482411c0887465603] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:36:48,243 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##927cb1f99f84406482411c0887465603] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##927cb1f99f84406482411c0887465603 WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##56b9bda8803643c982b8b377a82a3c6f] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:36:48,397 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##927cb1f99f84406482411c0887465603] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##927cb1f99f84406482411c0887465603] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##56b9bda8803643c982b8b377a82a3c6f] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:36:48,745 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##927cb1f99f84406482411c0887465603] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:36:48,748 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[bf300bdf-054e-4e39-b675-2160b935188f] FROM [##927cb1f99f84406482411c0887465603] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:37:48,910 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##07e2c810cae54b2a85afc741b3965876] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:37:48,915 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##07e2c810cae54b2a85afc741b3965876] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##07e2c810cae54b2a85afc741b3965876].ShopToutID = ShopToutID) 时间: 2022-11-05 15:37:48,918 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##07e2c810cae54b2a85afc741b3965876] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##07e2c810cae54b2a85afc741b3965876] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:37:48,923 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##07e2c810cae54b2a85afc741b3965876] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##07e2c810cae54b2a85afc741b3965876 WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##545331b567ad4c0aaf4a2dc61d87c1a7] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:37:49,098 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##07e2c810cae54b2a85afc741b3965876] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##07e2c810cae54b2a85afc741b3965876] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##545331b567ad4c0aaf4a2dc61d87c1a7] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:37:49,533 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##07e2c810cae54b2a85afc741b3965876] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:37:49,537 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[f2da0a6a-fc8a-4bd0-942b-ceac4473de71] FROM [##07e2c810cae54b2a85afc741b3965876] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:37:49,860 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##8b8644a2e7744a1b99fc6bcbb2e2522e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:37:49,865 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##8b8644a2e7744a1b99fc6bcbb2e2522e] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##8b8644a2e7744a1b99fc6bcbb2e2522e].ShopToutID = ShopToutID) 时间: 2022-11-05 15:37:49,869 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##8b8644a2e7744a1b99fc6bcbb2e2522e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##8b8644a2e7744a1b99fc6bcbb2e2522e] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:37:49,875 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##8b8644a2e7744a1b99fc6bcbb2e2522e] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##8b8644a2e7744a1b99fc6bcbb2e2522e WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##3063ad3726e74ea2b75ea217e2d52e8f] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:37:50,048 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##8b8644a2e7744a1b99fc6bcbb2e2522e] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##8b8644a2e7744a1b99fc6bcbb2e2522e] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##3063ad3726e74ea2b75ea217e2d52e8f] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:37:50,494 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##8b8644a2e7744a1b99fc6bcbb2e2522e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:37:50,497 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[d5b2598f-3aa6-4bdd-a560-30567834ab3b] FROM [##8b8644a2e7744a1b99fc6bcbb2e2522e] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:38:23,771 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##4292a455d3394d4fa2312aedbc1da40e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:38:23,783 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4292a455d3394d4fa2312aedbc1da40e] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##4292a455d3394d4fa2312aedbc1da40e].DealereturnID = DealereturnID) 时间: 2022-11-05 15:38:23,812 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4292a455d3394d4fa2312aedbc1da40e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##4292a455d3394d4fa2312aedbc1da40e] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:38:23,831 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##4292a455d3394d4fa2312aedbc1da40e] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##4292a455d3394d4fa2312aedbc1da40e WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##db557f166f994b8486c6514a0409aea2] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:23,988 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4292a455d3394d4fa2312aedbc1da40e] SET ReceiveQuantity = B.Quantity FROM [##4292a455d3394d4fa2312aedbc1da40e] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##4292a455d3394d4fa2312aedbc1da40e WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##db557f166f994b8486c6514a0409aea2] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:24,267 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4292a455d3394d4fa2312aedbc1da40e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:38:24,270 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[04400f1b-18c3-4825-a2dc-7202d182b37a] FROM [##4292a455d3394d4fa2312aedbc1da40e] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:38:24,667 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##729e3ea5d68b49e08cd110016b97d32c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:38:24,677 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##729e3ea5d68b49e08cd110016b97d32c] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##729e3ea5d68b49e08cd110016b97d32c].DealereturnID = DealereturnID) 时间: 2022-11-05 15:38:24,697 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##729e3ea5d68b49e08cd110016b97d32c] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##729e3ea5d68b49e08cd110016b97d32c] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:38:24,718 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##729e3ea5d68b49e08cd110016b97d32c] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##729e3ea5d68b49e08cd110016b97d32c WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##0f0be6dd9b8a4eb1a525f4afcd041b61] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:24,869 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##729e3ea5d68b49e08cd110016b97d32c] SET ReceiveQuantity = B.Quantity FROM [##729e3ea5d68b49e08cd110016b97d32c] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##729e3ea5d68b49e08cd110016b97d32c WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##0f0be6dd9b8a4eb1a525f4afcd041b61] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:25,151 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##729e3ea5d68b49e08cd110016b97d32c] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:38:25,154 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[1452b0b3-ebde-4e0b-8951-a586feb02137] FROM [##729e3ea5d68b49e08cd110016b97d32c] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:38:39,055 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##049d813c69384affbd53f445d55b71af] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:38:39,061 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##049d813c69384affbd53f445d55b71af] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##049d813c69384affbd53f445d55b71af].DealereturnID = DealereturnID) 时间: 2022-11-05 15:38:39,072 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##049d813c69384affbd53f445d55b71af] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##049d813c69384affbd53f445d55b71af] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:38:39,072 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##049d813c69384affbd53f445d55b71af] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##049d813c69384affbd53f445d55b71af WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##59e882e36559406a9baa731f1565e12f] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:39,271 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##049d813c69384affbd53f445d55b71af] SET ReceiveQuantity = B.Quantity FROM [##049d813c69384affbd53f445d55b71af] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##049d813c69384affbd53f445d55b71af WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##59e882e36559406a9baa731f1565e12f] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:39,703 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##049d813c69384affbd53f445d55b71af] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:38:39,706 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[8f93be73-0810-43bd-8239-d6f2c926d63f] FROM [##049d813c69384affbd53f445d55b71af] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:38:40,083 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##9657d70c85af45759984644b112cfe92] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:38:40,090 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9657d70c85af45759984644b112cfe92] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##9657d70c85af45759984644b112cfe92].DealereturnID = DealereturnID) 时间: 2022-11-05 15:38:40,096 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9657d70c85af45759984644b112cfe92] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##9657d70c85af45759984644b112cfe92] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:38:40,109 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##9657d70c85af45759984644b112cfe92] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##9657d70c85af45759984644b112cfe92 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##19d9547f7f47409f8c3ced13b546f2e4] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:40,315 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9657d70c85af45759984644b112cfe92] SET ReceiveQuantity = B.Quantity FROM [##9657d70c85af45759984644b112cfe92] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##9657d70c85af45759984644b112cfe92 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##19d9547f7f47409f8c3ced13b546f2e4] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:38:40,743 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9657d70c85af45759984644b112cfe92] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:38:40,747 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[61812350-7e72-4081-bfba-fc4f88c2a44c] FROM [##9657d70c85af45759984644b112cfe92] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:39:04,967 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##bc3d193d94834c1395708956b5a3e5d1] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:39:04,973 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc3d193d94834c1395708956b5a3e5d1] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##bc3d193d94834c1395708956b5a3e5d1].DealereturnID = DealereturnID) 时间: 2022-11-05 15:39:04,982 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc3d193d94834c1395708956b5a3e5d1] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##bc3d193d94834c1395708956b5a3e5d1] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:39:04,995 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##bc3d193d94834c1395708956b5a3e5d1] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##bc3d193d94834c1395708956b5a3e5d1 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##9cf4be2b4cbb403aba59431674aac745] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:39:05,188 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc3d193d94834c1395708956b5a3e5d1] SET ReceiveQuantity = B.Quantity FROM [##bc3d193d94834c1395708956b5a3e5d1] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##bc3d193d94834c1395708956b5a3e5d1 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##9cf4be2b4cbb403aba59431674aac745] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:39:05,616 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc3d193d94834c1395708956b5a3e5d1] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:39:05,619 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[73fa6495-429a-40c4-952a-0ce19f7ccf63] FROM [##bc3d193d94834c1395708956b5a3e5d1] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:39:06,000 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##9b9610bebe614eba8d3bea10c209d96e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:39:06,005 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9b9610bebe614eba8d3bea10c209d96e] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##9b9610bebe614eba8d3bea10c209d96e].DealereturnID = DealereturnID) 时间: 2022-11-05 15:39:06,014 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9b9610bebe614eba8d3bea10c209d96e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##9b9610bebe614eba8d3bea10c209d96e] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:39:06,026 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##9b9610bebe614eba8d3bea10c209d96e] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##9b9610bebe614eba8d3bea10c209d96e WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##5784154d92e042c4929e726cd5949eae] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:39:06,207 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9b9610bebe614eba8d3bea10c209d96e] SET ReceiveQuantity = B.Quantity FROM [##9b9610bebe614eba8d3bea10c209d96e] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##9b9610bebe614eba8d3bea10c209d96e WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##5784154d92e042c4929e726cd5949eae] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:39:06,645 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##9b9610bebe614eba8d3bea10c209d96e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:39:06,649 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[953d700c-4f15-42e9-8ec0-7b099a79ac6c] FROM [##9b9610bebe614eba8d3bea10c209d96e] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:40:42,437 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##705505d3664f4a989095c63eceaac1fc] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:40:42,442 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##705505d3664f4a989095c63eceaac1fc] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##705505d3664f4a989095c63eceaac1fc].ShopToutID = ShopToutID) 时间: 2022-11-05 15:40:42,446 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##705505d3664f4a989095c63eceaac1fc] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##705505d3664f4a989095c63eceaac1fc] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:40:42,452 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##705505d3664f4a989095c63eceaac1fc] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##705505d3664f4a989095c63eceaac1fc WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##d66b0eadae4847a5b894a0dc4b1ec267] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:40:42,621 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##705505d3664f4a989095c63eceaac1fc] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##705505d3664f4a989095c63eceaac1fc] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##d66b0eadae4847a5b894a0dc4b1ec267] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:40:43,043 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##705505d3664f4a989095c63eceaac1fc] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:40:43,047 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[470b6246-492b-4f63-9243-39af3c348062] FROM [##705505d3664f4a989095c63eceaac1fc] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:40:43,422 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6dc744b99b6047e297d50dec90c1e55e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:40:43,427 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##6dc744b99b6047e297d50dec90c1e55e] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##6dc744b99b6047e297d50dec90c1e55e].ShopToutID = ShopToutID) 时间: 2022-11-05 15:40:43,432 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##6dc744b99b6047e297d50dec90c1e55e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##6dc744b99b6047e297d50dec90c1e55e] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:40:43,436 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##6dc744b99b6047e297d50dec90c1e55e] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##6dc744b99b6047e297d50dec90c1e55e WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##06caa109b822475bbbb372a6404e92df] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:40:43,658 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##6dc744b99b6047e297d50dec90c1e55e] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##6dc744b99b6047e297d50dec90c1e55e] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##06caa109b822475bbbb372a6404e92df] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:40:44,135 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##6dc744b99b6047e297d50dec90c1e55e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:40:44,138 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[bf3b40a9-29ce-4a6a-a3d1-9b1f0c3d3a32] FROM [##6dc744b99b6047e297d50dec90c1e55e] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:41:47,031 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##dfd26359e2d44a32be745799d3ca18d9] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:41:47,035 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##dfd26359e2d44a32be745799d3ca18d9] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##dfd26359e2d44a32be745799d3ca18d9].DealereturnID = DealereturnID) 时间: 2022-11-05 15:41:47,041 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##dfd26359e2d44a32be745799d3ca18d9] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##dfd26359e2d44a32be745799d3ca18d9] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:41:47,050 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##dfd26359e2d44a32be745799d3ca18d9] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##dfd26359e2d44a32be745799d3ca18d9 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##ff241a13ffa04af48b96cc32ccb4585b] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:41:47,222 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##dfd26359e2d44a32be745799d3ca18d9] SET ReceiveQuantity = B.Quantity FROM [##dfd26359e2d44a32be745799d3ca18d9] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##dfd26359e2d44a32be745799d3ca18d9 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##ff241a13ffa04af48b96cc32ccb4585b] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:41:47,627 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##dfd26359e2d44a32be745799d3ca18d9] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:41:47,630 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[c4674439-0ea4-4adb-a1c2-e5cd5813df24] FROM [##dfd26359e2d44a32be745799d3ca18d9] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:41:47,979 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##3b12a9e5111c49899390853b884caa52] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-05 15:41:47,983 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##3b12a9e5111c49899390853b884caa52] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##3b12a9e5111c49899390853b884caa52].DealereturnID = DealereturnID) 时间: 2022-11-05 15:41:47,989 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##3b12a9e5111c49899390853b884caa52] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##3b12a9e5111c49899390853b884caa52] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-05 15:41:47,999 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##3b12a9e5111c49899390853b884caa52] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##3b12a9e5111c49899390853b884caa52 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##17e1286f252a4d928da2e9ed7872005c] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:41:48,176 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##3b12a9e5111c49899390853b884caa52] SET ReceiveQuantity = B.Quantity FROM [##3b12a9e5111c49899390853b884caa52] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##3b12a9e5111c49899390853b884caa52 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##17e1286f252a4d928da2e9ed7872005c] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-05 15:41:48,579 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##3b12a9e5111c49899390853b884caa52] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-05 15:41:48,582 线程ID: 74 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[556bdb69-16a5-43af-a4a4-c8bbd2cd10a2] FROM [##3b12a9e5111c49899390853b884caa52] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-05 15:45:14,566 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##c6f94e38902c43a58d7fe6a399543790] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopApplyOut' AND A.ShopApplyOutID = BillNo ) 时间: 2022-11-05 15:45:14,572 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##c6f94e38902c43a58d7fe6a399543790] A INNER JOIN ( SELECT A.ShopApplyOutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopApplyOutGoods] A INNER JOIN ShopApplyOut B ON A.ShopApplyOutID = B.ShopApplyOutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##c6f94e38902c43a58d7fe6a399543790 WHERE A.ShopApplyOutID = ShopApplyOutID ) AND EXISTS (SELECT 1 FROM [##846d10ec5d1f4ab3a6d518d446b47cc5] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopApplyOutID ) B ON A.ShopApplyOutID = B.ShopApplyOutID 时间: 2022-11-05 15:45:14,747 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[60e34d3d-fa72-45cb-8ec0-a2d7c9e9acb5] FROM [##c6f94e38902c43a58d7fe6a399543790] ORDER BY Esti_Date DESC, ShopApplyOutID ASC 时间: 2022-11-05 15:45:15,055 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6c65b22cfa6e422c8b43e97868452fa1] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopApplyOut' AND A.ShopApplyOutID = BillNo ) 时间: 2022-11-05 15:45:15,059 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##6c65b22cfa6e422c8b43e97868452fa1] A INNER JOIN ( SELECT A.ShopApplyOutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopApplyOutGoods] A INNER JOIN ShopApplyOut B ON A.ShopApplyOutID = B.ShopApplyOutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##6c65b22cfa6e422c8b43e97868452fa1 WHERE A.ShopApplyOutID = ShopApplyOutID ) AND EXISTS (SELECT 1 FROM [##ba1bf2c45baf4d46b6671bc6b35701d3] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopApplyOutID ) B ON A.ShopApplyOutID = B.ShopApplyOutID 时间: 2022-11-05 15:45:15,231 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopApplyOutID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期] , rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[a4a31211-45db-4230-8bfb-ed9cfebdcc59] FROM [##6c65b22cfa6e422c8b43e97868452fa1] ORDER BY Esti_Date DESC, ShopApplyOutID ASC 时间: 2022-11-05 15:45:28,951 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##a03e4cfdf2cb4f828c85da36a29d4cf3] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Renotice' AND A.RenoticeID = BillNo ) 时间: 2022-11-05 15:45:28,963 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = B.Quantity, DpAmount = B.DpAmount, BalanceAmount = B.BalanceAmount FROM [##a03e4cfdf2cb4f828c85da36a29d4cf3] A INNER JOIN ( SELECT A.RenoticeID, SUM( ISNULL(B.Quantity,0)) As Quantity , SUM( ISNULL(B.Quantity,0) * ISNULL(C.DpPriceByBatch,0)) As DpAmount , SUM( ISNULL(B.Quantity,0) * ISNULL(B.BalancePrice,0)) As BalanceAmount FROM [##a03e4cfdf2cb4f828c85da36a29d4cf3] A INNER JOIN RenoticeGoods B ON A.RenoticeID = B.RenoticeID LEFT JOIN vGoodsDpPrice C ON A.Customer_ID = C.Customer_ID AND B.Goods_No = C.Goods_No WHERE 1=1 AND EXISTS (SELECT 1 FROM [##17d3dfe4d7324030bab35330353b397d] WHERE Goods_No = B.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-05 15:45:29,016 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.DealereturnID = B.DealereturnID FROM ##a03e4cfdf2cb4f828c85da36a29d4cf3 A INNER JOIN Dealereturn B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-05 15:45:29,023 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RenoticeID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期] , ReturnType AS [退货类型], PriceType AS [价格类型], DealereturnID AS [退货单号], RetailOrderID AS [零售订单号] , EOrderID AS [线上订单号], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Waster AS [业务状态#次品], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[748586b6-2586-4ac4-9470-511b0404a6f6] FROM [##a03e4cfdf2cb4f828c85da36a29d4cf3] ORDER BY Esti_Date DESC, RenoticeID ASC 时间: 2022-11-05 15:45:29,348 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##1b4b0c76dc144bcba6d8622ac96942ad] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Renotice' AND A.RenoticeID = BillNo ) 时间: 2022-11-05 15:45:29,352 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = B.Quantity, DpAmount = B.DpAmount, BalanceAmount = B.BalanceAmount FROM [##1b4b0c76dc144bcba6d8622ac96942ad] A INNER JOIN ( SELECT A.RenoticeID, SUM( ISNULL(B.Quantity,0)) As Quantity , SUM( ISNULL(B.Quantity,0) * ISNULL(C.DpPriceByBatch,0)) As DpAmount , SUM( ISNULL(B.Quantity,0) * ISNULL(B.BalancePrice,0)) As BalanceAmount FROM [##1b4b0c76dc144bcba6d8622ac96942ad] A INNER JOIN RenoticeGoods B ON A.RenoticeID = B.RenoticeID LEFT JOIN vGoodsDpPrice C ON A.Customer_ID = C.Customer_ID AND B.Goods_No = C.Goods_No WHERE 1=1 AND EXISTS (SELECT 1 FROM [##6e202b2a2f874e7b8eea47df2391dfaf] WHERE Goods_No = B.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-05 15:45:29,404 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.DealereturnID = B.DealereturnID FROM ##1b4b0c76dc144bcba6d8622ac96942ad A INNER JOIN Dealereturn B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-05 15:45:29,411 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RenoticeID AS [单号], Manual_ID AS [手工单号], Esti_Date AS [日期] , ReturnType AS [退货类型], PriceType AS [价格类型], DealereturnID AS [退货单号], RetailOrderID AS [零售订单号] , EOrderID AS [线上订单号], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量] , DpAmount AS [吊牌额] , Waster AS [业务状态#次品], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[921b441b-b90b-4fb1-9653-4cdac0d94111] FROM [##1b4b0c76dc144bcba6d8622ac96942ad] ORDER BY Esti_Date DESC, RenoticeID ASC 时间: 2022-11-05 15:47:04,197 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##838a930949264867a45f9f233fb04081] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:47:04,202 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##838a930949264867a45f9f233fb04081] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##838a930949264867a45f9f233fb04081].ShopToutID = ShopToutID) 时间: 2022-11-05 15:47:04,206 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##838a930949264867a45f9f233fb04081] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##838a930949264867a45f9f233fb04081] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:47:04,218 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##838a930949264867a45f9f233fb04081] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##838a930949264867a45f9f233fb04081 WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##2607fd7c6b5c46cfa9213af60cafeabc] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:47:04,394 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##838a930949264867a45f9f233fb04081] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##838a930949264867a45f9f233fb04081] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##2607fd7c6b5c46cfa9213af60cafeabc] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:47:04,826 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##838a930949264867a45f9f233fb04081] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:47:04,829 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[392a49b9-2410-4421-8456-00d487711707] FROM [##838a930949264867a45f9f233fb04081] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:47:05,183 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##6b1e3d17ec0241449e005dfbbb4b0673] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2022-11-05 15:47:05,187 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##6b1e3d17ec0241449e005dfbbb4b0673] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##6b1e3d17ec0241449e005dfbbb4b0673].ShopToutID = ShopToutID) 时间: 2022-11-05 15:47:05,191 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##6b1e3d17ec0241449e005dfbbb4b0673] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##6b1e3d17ec0241449e005dfbbb4b0673] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2022-11-05 15:47:05,197 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##6b1e3d17ec0241449e005dfbbb4b0673] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##6b1e3d17ec0241449e005dfbbb4b0673 WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##18a71fb9963d4700b6330e73fc4e784d] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:47:05,370 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##6b1e3d17ec0241449e005dfbbb4b0673] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##6b1e3d17ec0241449e005dfbbb4b0673] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##18a71fb9963d4700b6330e73fc4e784d] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2022-11-05 15:47:05,802 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##6b1e3d17ec0241449e005dfbbb4b0673] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2022-11-05 15:47:05,805 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[f145fd39-0622-4af9-8a20-7b0f0a79c639] FROM [##6b1e3d17ec0241449e005dfbbb4b0673] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2022-11-05 15:52:58,383 线程ID: 8 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.Long , CAST(C.[S1] AS INT) AS [库存#S1], CAST(NULL AS INT) AS 库存#数量 , CAST(C.[S1] AS INT) AS [在途库存#S1], CAST(NULL AS INT) AS 在途库存#数量 , CAST(C.[S1] AS INT) AS [库存合计#S1], CAST(NULL AS INT) AS 库存合计#数量 , CAST(C.[S1] AS INT) AS [可用库存#S1], CAST(NULL AS INT) AS 可用库存#数量 , CAST(C.[S1] AS INT) AS [占用数#S1], CAST(NULL AS INT) AS 占用数#数量 INTO [##a0706f08b35748eb9a0f85fb46faa82c] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-05 16:02:08,292 线程ID: 36 日志级别: 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.[14967b57-631a-4319-885b-5407b0c40b87] FROM [##5a62c6f82364429981f453a8ecd802fe] ORDER BY Goods_no 时间: 2022-11-05 16:03:04,548 线程ID: 74 日志级别: 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.[14967b57-631a-4319-885b-5407b0c40b87] FROM [##9df222ef2f234f80917b00c040376e58] ORDER BY Goods_no 时间: 2022-11-05 16:03:06,659 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[14967b57-631a-4319-885b-5407b0c40b87] FROM [##bece9bfc30a447ad846cfaddb1967afe] ORDER BY Goods_no 时间: 2022-11-05 16:03:11,463 线程ID: 36 日志级别: 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.[14967b57-631a-4319-885b-5407b0c40b87] FROM [##0198e5125c764f9f954edf1885eb0d0f] ORDER BY Goods_no 时间: 2022-11-05 16:03:21,237 线程ID: 68 日志级别: 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.[14967b57-631a-4319-885b-5407b0c40b87] FROM [##035a424025b944339f9aed17fb24322b] ORDER BY Goods_no 时间: 2022-11-05 16:11:12,016 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] 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 [##c93c3ee6882b4ddcb5490f779c9b6ed4] 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 [##c93c3ee6882b4ddcb5490f779c9b6ed4] 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 [##c93c3ee6882b4ddcb5490f779c9b6ed4] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-05 16:11:12,125 线程ID: 36 日志级别: 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.[f1f18ccd-2e99-48e9-b2db-75fafc9e3407] FROM [##c93c3ee6882b4ddcb5490f779c9b6ed4] ORDER BY Receipt_Date DESC, PureceiptID ASC