时间: 2022-11-08 11:17:39,342 线程ID: 101 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##8a3d9d1cf0df40dea104c7f6c129ce13] ORDER BY Goods_no 时间: 2022-11-08 11:19:39,442 线程ID: 104 日志级别: 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 [##f51f2af6b7d34b218ebe6b45a7dd3e3e] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 11:19:39,696 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f51f2af6b7d34b218ebe6b45a7dd3e3e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##1ff309711d8f4a53bf3eace614a161d1] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:19:39,982 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f51f2af6b7d34b218ebe6b45a7dd3e3e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##b7de5bfc59ed437588e1e16eb75d606e] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:19:40,811 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f51f2af6b7d34b218ebe6b45a7dd3e3e] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##7d2114a9142b479ba043596459117574] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:19:40,830 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##f51f2af6b7d34b218ebe6b45a7dd3e3e] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 11:19:40,834 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f51f2af6b7d34b218ebe6b45a7dd3e3e SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 11:21:54,690 线程ID: 14 日志级别: 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 [##7b1a5882afe6411c8778f788b8bd3c29] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-11-08 11:21:55,054 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##09072027a90a4721bfac1fcea433254a] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-08 11:21:55,056 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7b1a5882afe6411c8778f788b8bd3c29] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##09072027a90a4721bfac1fcea433254a] 时间: 2022-11-08 11:21:55,114 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##817d41b4fe1146769b7061e9cbb2fde4 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-08 11:21:55,117 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##817d41b4fe1146769b7061e9cbb2fde4 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-08 11:21:55,119 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##817d41b4fe1146769b7061e9cbb2fde4 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-08 11:21:55,151 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##817d41b4fe1146769b7061e9cbb2fde4 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-08 11:21:55,153 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##817d41b4fe1146769b7061e9cbb2fde4 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-08 11:21:55,156 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7b1a5882afe6411c8778f788b8bd3c29] (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 [##5b91ae44acbf4f45a4324a70549a3806] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-11-08 11:21:55,163 线程ID: 14 日志级别: 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 ##232672ce8f9d4469a8210dd8c40c4e7a 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 [##43e364b174f149649d2b86a72c209461] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##5f5203ec6295403499349a5693b7dcf3] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >='2022/10/9' AND CheckDate <='2022-11-08' 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-08 11:21:55,189 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##232672ce8f9d4469a8210dd8c40c4e7a a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-08 11:21:55,191 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##232672ce8f9d4469a8210dd8c40c4e7a SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-08 11:21:55,194 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##232672ce8f9d4469a8210dd8c40c4e7a 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-08 11:21:55,226 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##232672ce8f9d4469a8210dd8c40c4e7a SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-08 11:21:55,228 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##232672ce8f9d4469a8210dd8c40c4e7a SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-08 11:21:55,231 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b1a5882afe6411c8778f788b8bd3c29(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##7e8a1875470d4c5dbd870112a5012cd1 WHERE CheckDate BETWEEN '2022/11/2' AND '2022-11-08 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##7b1a5882afe6411c8778f788b8bd3c29(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##7e8a1875470d4c5dbd870112a5012cd1 WHERE CheckDate BETWEEN '2022/10/25' AND '2022-11-08 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##7b1a5882afe6411c8778f788b8bd3c29(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##7e8a1875470d4c5dbd870112a5012cd1 WHERE CheckDate BETWEEN '2022/10/10' AND '2022-11-08 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-08 11:21:55,479 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f06ddf34ec9b4135836d32b66e33f9cb] where 2=2 and ISNULL(S1,0)=0 时间: 2022-11-08 11:21:55,481 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7b1a5882afe6411c8778f788b8bd3c29] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f06ddf34ec9b4135836d32b66e33f9cb] 时间: 2022-11-08 11:21:55,603 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7b1a5882afe6411c8778f788b8bd3c29] (Customer_ID, Goods_No, ColorID, Long, 批发在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, (ISNULL([S1], 0)) FROM [##dbf0a22b5b4f450daf419038cc175d6e] 时间: 2022-11-08 11:21:55,679 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7b1a5882afe6411c8778f788b8bd3c29] (Customer_ID, Goods_No, ColorID, Long , 调拨在途#数量) SELECT TinShop, Goods_No, ColorID, Long, (ISNULL([S1], 0)) FROM [##b6d9a20db3324e568cb19095513fc462] 时间: 2022-11-08 11:21:55,682 线程ID: 14 日志级别: 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 ##42473bf35a2c459597708a47e4c265f1 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 [##43e364b174f149649d2b86a72c209461] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##5f5203ec6295403499349a5693b7dcf3] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_id,B.Goods_No, C.ColorID, C.Long 时间: 2022-11-08 11:21:55,761 线程ID: 14 日志级别: 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 ##57c71f13e52e4a1fb65197640c562d57 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 [##43e364b174f149649d2b86a72c209461] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##5f5203ec6295403499349a5693b7dcf3] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-08 11:21:55,832 线程ID: 14 日志级别: 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 ##eda73694aef44cba9bf4454033c0a3cd 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 [##43e364b174f149649d2b86a72c209461] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##5f5203ec6295403499349a5693b7dcf3] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-11-08' 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-08 11:21:55,875 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eda73694aef44cba9bf4454033c0a3cd a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-11-08 11:21:55,879 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eda73694aef44cba9bf4454033c0a3cd SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-11-08 11:21:55,885 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##eda73694aef44cba9bf4454033c0a3cd 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-08 11:21:55,921 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eda73694aef44cba9bf4454033c0a3cd SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-11-08 11:21:55,924 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##eda73694aef44cba9bf4454033c0a3cd SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-11-08 11:21:55,928 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7b1a5882afe6411c8778f788b8bd3c29(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##1dbb1248e3f147258f6747365c308ff1 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-11-08 11:21:55,935 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long, max(A.DeliveryID) as DeliveryID INTO ##8a3745046f444d138d394ae42811c830 FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##42473bf35a2c459597708a47e4c265f1 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-08 11:21:55,958 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long, A.Mode, SUM(b.Quantity) as Quantity INTO ##7541adecf21a45ffa07277c781e016d4 FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##8a3745046f444d138d394ae42811c830 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 [##43e364b174f149649d2b86a72c209461] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##5f5203ec6295403499349a5693b7dcf3] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_ID, B.Goods_No, A.Mode, C.ColorID, C.Long 时间: 2022-11-08 11:21:56,113 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.Tin_Date) AS MaxLoadInDate INTO ##7375546c33cf494eb6937ad2886306f7 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 [##43e364b174f149649d2b86a72c209461] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##5f5203ec6295403499349a5693b7dcf3] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-08 11:21:56,186 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.CheckDate) AS MaxCheckDate INTO ##c850f7d0d18842be85213eacc79fa2d7 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 [##43e364b174f149649d2b86a72c209461] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##5f5203ec6295403499349a5693b7dcf3] WHERE Goods_No = B.Goods_No) GROUP BY a.Customer_ID, b.Goods_No, C.ColorID, C.Long 时间: 2022-11-08 11:21:56,273 线程ID: 14 日志级别: 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.[f9cb781b-f847-4cda-9a9b-cf18242b7075] FROM ##7b1a5882afe6411c8778f788b8bd3c29 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 ##42473bf35a2c459597708a47e4c265f1 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 ##7541adecf21a45ffa07277c781e016d4 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 ##57c71f13e52e4a1fb65197640c562d57 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 ##7375546c33cf494eb6937ad2886306f7 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 ##c850f7d0d18842be85213eacc79fa2d7 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-08 11:25:43,997 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##f78995f5d36940129283359851bf368a] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##f78995f5d36940129283359851bf368a] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##f78995f5d36940129283359851bf368a] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##f78995f5d36940129283359851bf368a] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##f78995f5d36940129283359851bf368a] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##f78995f5d36940129283359851bf368a] 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 [##f78995f5d36940129283359851bf368a] 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 [##f78995f5d36940129283359851bf368a] 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 [##f78995f5d36940129283359851bf368a] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 11:25:44,107 线程ID: 114 日志级别: 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.[40df2850-62df-427d-a23f-09a22511720a] FROM [##f78995f5d36940129283359851bf368a] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-08 11:26:50,138 线程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 [##992be2aade5a4e3c890ad98db53d6ab7] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 11:26:50,353 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##992be2aade5a4e3c890ad98db53d6ab7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##ca2356d2eee8452a8d4a26b494609683] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:26:50,635 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##992be2aade5a4e3c890ad98db53d6ab7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##20b5a0e48139413a80daf0a82db808a1] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:26:51,235 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##992be2aade5a4e3c890ad98db53d6ab7] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##4018c4e3d83449fca7d9496ee8b901a1] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:26:51,238 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##992be2aade5a4e3c890ad98db53d6ab7] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 11:26:51,240 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##992be2aade5a4e3c890ad98db53d6ab7 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 11:27:34,695 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##57f53f5bb31744ac8a05e834e7903299] ORDER BY Goods_no 时间: 2022-11-08 11:27:37,828 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##cb64aec91c894caf95c43afb65fc178b] ORDER BY Goods_no 时间: 2022-11-08 11:27:51,722 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##3bc3c192eb3c49e5b2cd82df3d202711] ORDER BY Goods_no 时间: 2022-11-08 11:44:17,706 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##aac2e11744e948b093cecad06b9a7a62] 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 [##aac2e11744e948b093cecad06b9a7a62] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-08 11:44:17,736 线程ID: 89 日志级别: 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.[1290a6e5-fd61-46f1-8637-b2b9daf89c34] FROM [##aac2e11744e948b093cecad06b9a7a62] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-08 11:44:37,420 线程ID: 14 日志级别: 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 [##d54922605f8e4875878ebba984008f9d] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 11:44:37,650 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d54922605f8e4875878ebba984008f9d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##d49bd6495c664f07814e129619b07fac] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:44:37,924 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d54922605f8e4875878ebba984008f9d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##1c683c10339048e0b73567e6720f0262] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:44:38,548 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d54922605f8e4875878ebba984008f9d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##2ce023ae26c943dd8159287485694676] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:44:38,552 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d54922605f8e4875878ebba984008f9d] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 11:44:38,553 线程ID: 14 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d54922605f8e4875878ebba984008f9d SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 11:46:48,931 线程ID: 104 日志级别: 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 [##16396f6f9505415bb53409d977652a5d] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 11:46:49,158 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##16396f6f9505415bb53409d977652a5d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##0002fd2143ef496b9f8c96140d559e2d] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:46:49,429 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##16396f6f9505415bb53409d977652a5d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##9ba1d8b7bea44a9d80cb089fef47e936] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:46:50,020 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##16396f6f9505415bb53409d977652a5d] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##bc46a900a621466699465bccd0b723ef] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:46:50,023 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##16396f6f9505415bb53409d977652a5d] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 11:46:50,024 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##16396f6f9505415bb53409d977652a5d SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 11:49:25,100 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##1a84ea2a4b22422db7953cc8988e2355] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##1a84ea2a4b22422db7953cc8988e2355] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##f11c7c8de1364dd1bf6c5a7f62a6e3e8] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##1a84ea2a4b22422db7953cc8988e2355] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##1a84ea2a4b22422db7953cc8988e2355] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##f11c7c8de1364dd1bf6c5a7f62a6e3e8] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##1a84ea2a4b22422db7953cc8988e2355] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##1a84ea2a4b22422db7953cc8988e2355] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##f11c7c8de1364dd1bf6c5a7f62a6e3e8] WHERE Goods_No = A.Goods_No) 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 [##1a84ea2a4b22422db7953cc8988e2355] 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 AND EXISTS (SELECT 1 FROM [##f11c7c8de1364dd1bf6c5a7f62a6e3e8] WHERE Goods_No = R.Goods_No) 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 [##1a84ea2a4b22422db7953cc8988e2355] 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 [##1a84ea2a4b22422db7953cc8988e2355] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##f11c7c8de1364dd1bf6c5a7f62a6e3e8] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 11:49:25,818 线程ID: 30 日志级别: 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.[8f20a9b4-cad0-46e1-8e39-215f87026e4b] FROM [##1a84ea2a4b22422db7953cc8988e2355] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-08 11:49:26,203 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##25fb3fea51a24655a93554d6ede29806] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##25fb3fea51a24655a93554d6ede29806] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##7d92780bd8a8438ab3afad8ba984b71a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0) FROM [##25fb3fea51a24655a93554d6ede29806] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##25fb3fea51a24655a93554d6ede29806] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##7d92780bd8a8438ab3afad8ba984b71a] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0) FROM [##25fb3fea51a24655a93554d6ede29806] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##25fb3fea51a24655a93554d6ede29806] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##7d92780bd8a8438ab3afad8ba984b71a] WHERE Goods_No = A.Goods_No) 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 [##25fb3fea51a24655a93554d6ede29806] 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 AND EXISTS (SELECT 1 FROM [##7d92780bd8a8438ab3afad8ba984b71a] WHERE Goods_No = R.Goods_No) 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 [##25fb3fea51a24655a93554d6ede29806] 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 [##25fb3fea51a24655a93554d6ede29806] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##7d92780bd8a8438ab3afad8ba984b71a] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 11:49:26,923 线程ID: 23 日志级别: 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.[5e126dbc-02a2-4fb0-b1db-cac2ced1c3cc] FROM [##25fb3fea51a24655a93554d6ede29806] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-08 11:50:40,028 线程ID: 89 日志级别: 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 [##bbbd090486af4004904fae2fe6553a81] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 11:50:40,246 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bbbd090486af4004904fae2fe6553a81] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##c2042bcac50247bda712c39491af0c56] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:50:40,513 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bbbd090486af4004904fae2fe6553a81] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##9ca90b5c263c418cb71d7a0f093d0b7b] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:50:41,107 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bbbd090486af4004904fae2fe6553a81] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##b41c88164a454329bd8037fc53e21580] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:50:41,111 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bbbd090486af4004904fae2fe6553a81] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 11:50:41,112 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##bbbd090486af4004904fae2fe6553a81 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 11:51:45,443 线程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 [##a0929fe829bd473089de495e916b85ab] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 11:51:45,662 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a0929fe829bd473089de495e916b85ab] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##d7871c23935d49d18291f21c0d90380f] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:51:45,943 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a0929fe829bd473089de495e916b85ab] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##fa5bed07ea8e4a45bc78baf0a30ddd91] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:51:46,546 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a0929fe829bd473089de495e916b85ab] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##85cd1690b5a146c88ce0e704a4babc19] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 11:51:46,550 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##a0929fe829bd473089de495e916b85ab] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 11:51:46,551 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a0929fe829bd473089de495e916b85ab SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 12:02:58,443 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##4527cb8bff874f8da211bd8708889c5d] ORDER BY Goods_no 时间: 2022-11-08 12:03:07,772 线程ID: 14 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##18310090db43407895a056e6c8ab2cb9] ORDER BY Goods_no 时间: 2022-11-08 12:05:25,044 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##080ab8b049bb4d91bba8d1e6023ccafa] ORDER BY Goods_no 时间: 2022-11-08 12:05:30,469 线程ID: 101 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##0e6fb8e2197241b9ab1b52fcf377e9ad] ORDER BY Goods_no 时间: 2022-11-08 12:11:36,223 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##0647eea021614e9c941975be30936aec] ORDER BY Goods_no 时间: 2022-11-08 12:11:40,350 线程ID: 104 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##5c21de24a60243df94053876238b1bfa] ORDER BY Goods_no 时间: 2022-11-08 12:11:46,197 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##ceb50b9a02a848029364cbead8f0823b] ORDER BY Goods_no 时间: 2022-11-08 12:13:22,118 线程ID: 14 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##c9d17ed82f4f4b8e9cabcc47b8f8129e] ORDER BY Goods_no 时间: 2022-11-08 12:13:27,638 线程ID: 101 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##29d9b851a50e4323ae7cacfed35ac484] ORDER BY Goods_no 时间: 2022-11-08 12:22:55,046 线程ID: 89 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##9b2323b3950e4350856fe6c02b387e8d] ORDER BY Goods_no 时间: 2022-11-08 12:23:29,932 线程ID: 100 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##87ae55b8a31447fbbd78535e8031e5ec] ORDER BY Goods_no 时间: 2022-11-08 12:24:19,447 线程ID: 87 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##b5546717c42a441686e14b169af0314a] ORDER BY Goods_no 时间: 2022-11-08 12:27:00,521 线程ID: 104 日志级别: 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.[a3abf5c0-332c-42d0-8c93-da521bc2bfa9] FROM [##ff2f6e1b732f4d6894a20c96754e0487] ORDER BY Goods_no 时间: 2022-11-08 12:48:52,576 线程ID: 70 日志级别: 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 [##f1aa39e147014533b6ca05fe69c8d027] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2022-11-08 12:48:52,800 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f1aa39e147014533b6ca05fe69c8d027] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##f113d79919de41aea03d1886586c2e9d] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 12:48:53,072 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f1aa39e147014533b6ca05fe69c8d027] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [在途库存#S1], 在途库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##ca51478cefa84db18d978132c107bf2b] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 12:48:53,675 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f1aa39e147014533b6ca05fe69c8d027] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [可用库存#S1], 可用库存#数量) SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0)) FROM [##c83d522a35e84b408efcf3d71e325fa1] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2022-11-08 12:48:53,677 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##f1aa39e147014533b6ca05fe69c8d027] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-11-08 12:48:53,679 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f1aa39e147014533b6ca05fe69c8d027 SET 占用数#数量 = ISNULL(库存#数量,0) - ISNULL(可用库存#数量, 0), [占用数#S1] = ISNULL([库存#S1], 0) - ISNULL([可用库存#S1], 0) 时间: 2022-11-08 12:56:15,335 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##f899398321924340b31caf60a9ab2d3c] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##f899398321924340b31caf60a9ab2d3c] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##aec9606ccda44828956dbb4d3559d527] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 12:56:15,507 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##f899398321924340b31caf60a9ab2d3c] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##f899398321924340b31caf60a9ab2d3c] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##aec9606ccda44828956dbb4d3559d527] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 12:56:15,668 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##f899398321924340b31caf60a9ab2d3c] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##f899398321924340b31caf60a9ab2d3c] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##aec9606ccda44828956dbb4d3559d527] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 12:56:15,838 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##f899398321924340b31caf60a9ab2d3c] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##f899398321924340b31caf60a9ab2d3c] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##aec9606ccda44828956dbb4d3559d527] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-08 12:56:16,006 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##f899398321924340b31caf60a9ab2d3c] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##f899398321924340b31caf60a9ab2d3c] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##aec9606ccda44828956dbb4d3559d527] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2022-11-08 12:56:16,179 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##f899398321924340b31caf60a9ab2d3c A 时间: 2022-11-08 12:56:16,182 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[c5c7d055-e168-4c94-972b-e5b0cc822ba5] FROM [##f899398321924340b31caf60a9ab2d3c] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-08 12:56:31,225 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##cd86c9a8d60a4478950f0259f880f412] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptSSGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID LEFT JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No WHERE EXISTS( SELECT 1 FROM [##cd86c9a8d60a4478950f0259f880f412] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##637b91f21da24e778564e27fe2404c86] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 12:56:31,414 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##cd86c9a8d60a4478950f0259f880f412] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReceiptGoods A INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID WHERE EXISTS( SELECT 1 FROM [##cd86c9a8d60a4478950f0259f880f412] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##637b91f21da24e778564e27fe2404c86] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2022-11-08 12:56:31,580 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##cd86c9a8d60a4478950f0259f880f412] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM DealeReturnGoods A INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID WHERE EXISTS( SELECT 1 FROM [##cd86c9a8d60a4478950f0259f880f412] WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##637b91f21da24e778564e27fe2404c86] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 12:56:31,739 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##cd86c9a8d60a4478950f0259f880f412] A INNER JOIN ( SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM RenoticeGoods A INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID WHERE EXISTS( SELECT 1 FROM [##cd86c9a8d60a4478950f0259f880f412] WHERE A.RenoticeID = RenoticeID ) AND EXISTS (SELECT 1 FROM [##637b91f21da24e778564e27fe2404c86] WHERE Goods_No = A.Goods_No) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2022-11-08 12:56:31,884 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##cd86c9a8d60a4478950f0259f880f412] A INNER JOIN ( SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM PuReturnGoods A INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID WHERE EXISTS( SELECT 1 FROM [##cd86c9a8d60a4478950f0259f880f412] WHERE A.PuReturnID = PuReturnID ) AND EXISTS (SELECT 1 FROM [##637b91f21da24e778564e27fe2404c86] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2022-11-08 12:56:32,026 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##cd86c9a8d60a4478950f0259f880f412 A 时间: 2022-11-08 12:56:32,029 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号], BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], PriceType [价格类型], Quantity AS [数量], DpAmount AS [吊牌额], BalanceAmount AS [结算额], PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数], OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus AS [业务状态#退货状态], JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核名称],PostedDate AS [单据状态#审核日期], PrintFlag AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[c5c7d055-e168-4c94-972b-e5b0cc822ba5] FROM [##cd86c9a8d60a4478950f0259f880f412] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2022-11-08 15:04:51,860 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##832d7af6be9f43b3a03e8d6677265e8e] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-08 15:04:51,875 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##832d7af6be9f43b3a03e8d6677265e8e] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##832d7af6be9f43b3a03e8d6677265e8e].DealereturnID = DealereturnID) 时间: 2022-11-08 15:04:51,897 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##832d7af6be9f43b3a03e8d6677265e8e] 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 [##832d7af6be9f43b3a03e8d6677265e8e] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-08 15:04:51,910 线程ID: 15 日志级别: 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 [##832d7af6be9f43b3a03e8d6677265e8e] 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 ##832d7af6be9f43b3a03e8d6677265e8e WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##c7be87f9118248bfa6d22141738ae029] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 15:04:52,055 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##832d7af6be9f43b3a03e8d6677265e8e] SET ReceiveQuantity = B.Quantity FROM [##832d7af6be9f43b3a03e8d6677265e8e] 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 ##832d7af6be9f43b3a03e8d6677265e8e WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##c7be87f9118248bfa6d22141738ae029] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 15:04:52,335 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##832d7af6be9f43b3a03e8d6677265e8e] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-08 15:04:52,339 线程ID: 15 日志级别: 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.[bb7a7fa6-52c9-4b31-b847-48231ee7a3fa] FROM [##832d7af6be9f43b3a03e8d6677265e8e] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-08 15:22:28,319 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##0a0f44a551524b20993bac1343ff1d27] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-08 15:22:28,325 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0a0f44a551524b20993bac1343ff1d27] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##0a0f44a551524b20993bac1343ff1d27].DealereturnID = DealereturnID) 时间: 2022-11-08 15:22:28,331 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0a0f44a551524b20993bac1343ff1d27] 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 [##0a0f44a551524b20993bac1343ff1d27] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-08 15:22:28,341 线程ID: 60 日志级别: 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 [##0a0f44a551524b20993bac1343ff1d27] 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 ##0a0f44a551524b20993bac1343ff1d27 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##649c1d76e88d4529ba770b86fc834fb9] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 15:22:28,518 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0a0f44a551524b20993bac1343ff1d27] SET ReceiveQuantity = B.Quantity FROM [##0a0f44a551524b20993bac1343ff1d27] 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 ##0a0f44a551524b20993bac1343ff1d27 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##649c1d76e88d4529ba770b86fc834fb9] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 15:22:28,930 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##0a0f44a551524b20993bac1343ff1d27] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-08 15:22:28,933 线程ID: 60 日志级别: 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.[420356bf-9219-4f53-ad26-62d468f3456a] FROM [##0a0f44a551524b20993bac1343ff1d27] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-08 15:22:29,298 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d295eb7d2ad848c3a0a9b8efa7f32cb8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2022-11-08 15:22:29,305 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d295eb7d2ad848c3a0a9b8efa7f32cb8] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##d295eb7d2ad848c3a0a9b8efa7f32cb8].DealereturnID = DealereturnID) 时间: 2022-11-08 15:22:29,312 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d295eb7d2ad848c3a0a9b8efa7f32cb8] 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 [##d295eb7d2ad848c3a0a9b8efa7f32cb8] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2022-11-08 15:22:29,323 线程ID: 94 日志级别: 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 [##d295eb7d2ad848c3a0a9b8efa7f32cb8] 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 ##d295eb7d2ad848c3a0a9b8efa7f32cb8 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##d931b1bb481b4e9ca08585cc2e327b94] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 15:22:29,504 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d295eb7d2ad848c3a0a9b8efa7f32cb8] SET ReceiveQuantity = B.Quantity FROM [##d295eb7d2ad848c3a0a9b8efa7f32cb8] 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 ##d295eb7d2ad848c3a0a9b8efa7f32cb8 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##d931b1bb481b4e9ca08585cc2e327b94] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2022-11-08 15:22:29,920 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d295eb7d2ad848c3a0a9b8efa7f32cb8] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2022-11-08 15:22:29,923 线程ID: 94 日志级别: 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.[2383a01b-8618-4cb2-b76b-ee0a3cb0f2c4] FROM [##d295eb7d2ad848c3a0a9b8efa7f32cb8] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2022-11-08 18:00:39,273 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##28b6a3232dea448083519df3ddae7bb8] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2022-11-08 18:00:39,281 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##28b6a3232dea448083519df3ddae7bb8] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##28b6a3232dea448083519df3ddae7bb8] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2022-11-08 18:00:39,287 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##28b6a3232dea448083519df3ddae7bb8] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-08 18:00:39,292 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##28b6a3232dea448083519df3ddae7bb8] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2022-11-08 18:00:39,296 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##28b6a3232dea448083519df3ddae7bb8 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##28b6a3232dea448083519df3ddae7bb8 WHERE A.SortingID = SortingID ) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2022-11-08 18:00:39,310 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##28b6a3232dea448083519df3ddae7bb8 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##28b6a3232dea448083519df3ddae7bb8 WHERE A.OrderID = OrderID ) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2022-11-08 18:00:39,322 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##28b6a3232dea448083519df3ddae7bb8 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 ##28b6a3232dea448083519df3ddae7bb8 WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-08 18:00:39,357 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##28b6a3232dea448083519df3ddae7bb8 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 ##28b6a3232dea448083519df3ddae7bb8 WHERE B.DeliveryID = DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-08 18:00:39,463 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##28b6a3232dea448083519df3ddae7bb8 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 ##28b6a3232dea448083519df3ddae7bb8 C WHERE B.DeliveryID = C.DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-08 18:00:39,532 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##28b6a3232dea448083519df3ddae7bb8 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2022-11-08 18:00:39,533 线程ID: 15 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##28b6a3232dea448083519df3ddae7bb8] 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 [##28b6a3232dea448083519df3ddae7bb8] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-08 18:00:39,571 线程ID: 15 日志级别: 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.[c664658b-7ff1-49b6-8eb6-960455253916] FROM [##28b6a3232dea448083519df3ddae7bb8] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2022-11-08 18:25:25,466 线程ID: 102 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##904c3fa294f14a1c8bb6ea7ab547412e] 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 [##904c3fa294f14a1c8bb6ea7ab547412e] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2022-11-08 18:25:25,493 线程ID: 102 日志级别: 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.[4f65191c-8e25-42ef-b7a3-88c8e667aef1] FROM [##904c3fa294f14a1c8bb6ea7ab547412e] ORDER BY Delivery_Date DESC, DeliveryID ASC