时间: 2023-02-13 14:17:08,043 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[71d528d4-03c6-456d-95f8-62104b5b023c] FROM [##4d7f5d238fd14b828db2b7eed5cc83f1] ORDER BY Goods_no 时间: 2023-02-13 14:17:48,062 线程ID: 16 日志级别: 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 [##eacb650fdb774e36bcda46b81789becf] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 14:17:48,456 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##603404ca2a044c5b8ec9a5ee7ee600e6] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 14:17:48,458 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##eacb650fdb774e36bcda46b81789becf] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##603404ca2a044c5b8ec9a5ee7ee600e6] 时间: 2023-02-13 14:17:48,460 线程ID: 16 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[9d1d355a-e47c-412b-a4df-f125c8b1bbea] FROM ##eacb650fdb774e36bcda46b81789becf A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 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 时间: 2023-02-13 14:18:20,300 线程ID: 43 日志级别: 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 [##f9a377c366e14db98ca3f5eb42d84bb0] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 14:18:20,520 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f9a377c366e14db98ca3f5eb42d84bb0] (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 [##cce152d3517949788cd83a25c462e8fc] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 14:18:20,870 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f9a377c366e14db98ca3f5eb42d84bb0] (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 [##f80be5231b9c4de8a2e4f15695dcd866] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 14:18:20,876 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##f9a377c366e14db98ca3f5eb42d84bb0] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 14:19:25,852 线程ID: 51 日志级别: 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.[71d528d4-03c6-456d-95f8-62104b5b023c] FROM [##11de819bcafd452a8e71211ae9a4e4f7] ORDER BY Goods_no 时间: 2023-02-13 14:57:51,404 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##514624bb36f946d19fd6b338ef7c3477] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 14:57:51,830 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1b627de569f44a7393436953eae7f357] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 14:57:51,832 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##514624bb36f946d19fd6b338ef7c3477] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1b627de569f44a7393436953eae7f357] 时间: 2023-02-13 14:57:51,893 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fb9ae8dd166a471b9d029cc8499fa963 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-13 14:57:51,895 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fb9ae8dd166a471b9d029cc8499fa963 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-13 14:57:51,897 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fb9ae8dd166a471b9d029cc8499fa963 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 = '退货' 时间: 2023-02-13 14:57:51,924 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fb9ae8dd166a471b9d029cc8499fa963 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-13 14:57:51,926 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fb9ae8dd166a471b9d029cc8499fa963 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-13 14:57:51,929 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##514624bb36f946d19fd6b338ef7c3477] (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 [##38516e715d694ad0a6b988dafd062c97] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-02-13 14:57:51,933 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[4ed3efdb-5d0a-44bd-aea3-adfe20b95ec8] FROM ##514624bb36f946d19fd6b338ef7c3477 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2023-02-13 15:11:07,120 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##e7410ead7d094a63a1abe282c192258c] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CBalance' AND A.BalanceID = BillNo ) 时间: 2023-02-13 15:11:07,125 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e7410ead7d094a63a1abe282c192258c] A INNER JOIN ( SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount FROM [BalanceGoods] A INNER JOIN Goods B ON A.Goods_No = B.Goods_No WHERE EXISTS( SELECT 1 FROM ##e7410ead7d094a63a1abe282c192258c WHERE A.BalanceID = BalanceID ) AND EXISTS (SELECT 1 FROM [##7dcb495310ed4c22854c259bfa0eccff] WHERE Goods_No = A.Goods_No) GROUP BY A.BalanceID ) B ON A.BalanceID = B.BalanceID 时间: 2023-02-13 15:11:07,422 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期] , rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称] , Quantity AS [数量] , DpAmount AS [吊牌额] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Remark AS [备注] INTO tempdb.dbo.[3a9c9871-13e1-4b6c-9b20-f436fa9d17c8] FROM [##e7410ead7d094a63a1abe282c192258c] ORDER BY Balance_Date DESC, BalanceID ASC 时间: 2023-02-13 15:19:02,414 线程ID: 70 日志级别: 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.[71d528d4-03c6-456d-95f8-62104b5b023c] FROM [##5653c3e279cc454a8e4e9a348acca388] ORDER BY Goods_no 时间: 2023-02-13 15:19:13,361 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[71d528d4-03c6-456d-95f8-62104b5b023c] FROM [##aa3ab0de8a8d4f0e8b1b3619ef35e359] ORDER BY Goods_no 时间: 2023-02-13 15:20:15,159 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##79c2c5a92db049e9b9366d4129d6b008] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-13 15:20:15,167 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##79c2c5a92db049e9b9366d4129d6b008] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##79c2c5a92db049e9b9366d4129d6b008] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-13 15:20:15,173 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##79c2c5a92db049e9b9366d4129d6b008] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 15:20:15,176 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##79c2c5a92db049e9b9366d4129d6b008] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 15:20:15,180 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##79c2c5a92db049e9b9366d4129d6b008 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##79c2c5a92db049e9b9366d4129d6b008 WHERE A.SortingID = SortingID ) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-13 15:20:15,192 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##79c2c5a92db049e9b9366d4129d6b008 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##79c2c5a92db049e9b9366d4129d6b008 WHERE A.OrderID = OrderID ) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-13 15:20:15,204 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##79c2c5a92db049e9b9366d4129d6b008 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 ##79c2c5a92db049e9b9366d4129d6b008 WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:20:15,241 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##79c2c5a92db049e9b9366d4129d6b008 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 ##79c2c5a92db049e9b9366d4129d6b008 WHERE B.DeliveryID = DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:20:15,371 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##79c2c5a92db049e9b9366d4129d6b008 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 ##79c2c5a92db049e9b9366d4129d6b008 C WHERE B.DeliveryID = C.DeliveryID ) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:20:15,444 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##79c2c5a92db049e9b9366d4129d6b008 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-13 15:20:15,445 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##79c2c5a92db049e9b9366d4129d6b008] 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 [##79c2c5a92db049e9b9366d4129d6b008] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:20:15,482 线程ID: 94 日志级别: 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.[963174f7-1d3f-4aa1-8175-fd5b78897958] FROM [##79c2c5a92db049e9b9366d4129d6b008] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 15:26:38,785 线程ID: 51 日志级别: 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 [##79dc030b34344ac6b764d1dd37ddd02f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 15:26:39,201 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##26238f6251a14961a4589184e106baa3] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 15:26:39,204 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##79dc030b34344ac6b764d1dd37ddd02f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##26238f6251a14961a4589184e106baa3] 时间: 2023-02-13 15:26:39,217 线程ID: 51 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[9d1d355a-e47c-412b-a4df-f125c8b1bbea] FROM ##79dc030b34344ac6b764d1dd37ddd02f A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 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 时间: 2023-02-13 15:27:04,251 线程ID: 10 日志级别: 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.[71d528d4-03c6-456d-95f8-62104b5b023c] FROM [##a111741b6d334c1386021e1b8143555a] ORDER BY Goods_no 时间: 2023-02-13 15:27:17,195 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS 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 [##946ad152c1c648c485fe6828e74a24bc] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 15:27:17,531 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##65adc487d6364c258ae6b033a910e02e] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 15:27:17,533 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##946ad152c1c648c485fe6828e74a24bc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##65adc487d6364c258ae6b033a910e02e] 时间: 2023-02-13 15:27:17,535 线程ID: 76 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[9d1d355a-e47c-412b-a4df-f125c8b1bbea] FROM ##946ad152c1c648c485fe6828e74a24bc A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 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 时间: 2023-02-13 15:27:24,175 线程ID: 79 日志级别: 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 [##e2ed88f46e6245ebaad5080de7182d2d] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 15:27:24,379 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2ed88f46e6245ebaad5080de7182d2d] (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 [##d6c8af8aee204d46a848314dc0b12601] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 15:27:24,711 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e2ed88f46e6245ebaad5080de7182d2d] (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 [##2dcf9e5decef4bc78079ff89e1a40683] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 15:27:24,714 线程ID: 79 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##e2ed88f46e6245ebaad5080de7182d2d] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 15:29:07,930 线程ID: 70 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##d80c68fc50624ea68c3a408e0bd3fb0f] 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 [##d80c68fc50624ea68c3a408e0bd3fb0f] WHERE A.DeliveryID = DeliveryID ) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:29:07,959 线程ID: 70 日志级别: 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.[cea67f87-de3b-472d-b597-8a84ee05b08b] FROM [##d80c68fc50624ea68c3a408e0bd3fb0f] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 15:29:23,237 线程ID: 85 日志级别: 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 [##49b62174bfd2431281fe5aab4ca60a13] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 15:29:23,436 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##49b62174bfd2431281fe5aab4ca60a13] (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 [##7c0aa1fd51874b33b81d6266d80bb713] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 15:29:23,767 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##49b62174bfd2431281fe5aab4ca60a13] (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 [##0517f23b36134bf9a9b81973582c56ec] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 15:29:23,771 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##49b62174bfd2431281fe5aab4ca60a13] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 15:30:06,845 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##e9481dafa72f4c50bb292d36a7abf9bb] A INNER JOIN ( SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity FROM PuReceiptGoods A WHERE EXISTS( SELECT 1 FROM [##e9481dafa72f4c50bb292d36a7abf9bb] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##fa161bbfe7324edb8977838659e40ff6] 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 [##e9481dafa72f4c50bb292d36a7abf9bb] A INNER JOIN ( SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity FROM DeliveryGoods A WHERE EXISTS( SELECT 1 FROM [##e9481dafa72f4c50bb292d36a7abf9bb] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##fa161bbfe7324edb8977838659e40ff6] 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 [##e9481dafa72f4c50bb292d36a7abf9bb] A INNER JOIN ( SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity FROM PurchaseGoods A WHERE EXISTS( SELECT 1 FROM [##e9481dafa72f4c50bb292d36a7abf9bb] WHERE A.Purchase_ID = Purchase_ID ) AND EXISTS (SELECT 1 FROM [##fa161bbfe7324edb8977838659e40ff6] 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 [##e9481dafa72f4c50bb292d36a7abf9bb] 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 [##fa161bbfe7324edb8977838659e40ff6] 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 [##e9481dafa72f4c50bb292d36a7abf9bb] 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 [##e9481dafa72f4c50bb292d36a7abf9bb] WHERE A.PuReceiptID = PuReceiptID ) AND EXISTS (SELECT 1 FROM [##fa161bbfe7324edb8977838659e40ff6] WHERE Goods_No = A.Goods_No) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-02-13 15:30:07,324 线程ID: 43 日志级别: 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.[fe9b7205-f121-44dd-973a-97d2e4361741] FROM [##e9481dafa72f4c50bb292d36a7abf9bb] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-02-13 15:31:23,301 线程ID: 16 日志级别: 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 [##e8e87f190e9b418ab3bbe0a7cc483798] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 15:31:23,652 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f48c50237b554615bd22cbdf6793c23f] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 15:31:23,654 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e8e87f190e9b418ab3bbe0a7cc483798] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f48c50237b554615bd22cbdf6793c23f] 时间: 2023-02-13 15:31:23,656 线程ID: 16 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[9d1d355a-e47c-412b-a4df-f125c8b1bbea] FROM ##e8e87f190e9b418ab3bbe0a7cc483798 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No 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 时间: 2023-02-13 15:31:36,030 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##aebda8831de14e3ca887d9fc3dcaba8b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 15:31:36,409 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##6e2919850c394761b7cdbc5a1501102d] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 15:31:36,412 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##aebda8831de14e3ca887d9fc3dcaba8b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6e2919850c394761b7cdbc5a1501102d] 时间: 2023-02-13 15:31:36,497 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7fc3911d3891400eab9f7c96bc978726 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-13 15:31:36,500 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7fc3911d3891400eab9f7c96bc978726 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-13 15:31:36,502 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7fc3911d3891400eab9f7c96bc978726 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 = '退货' 时间: 2023-02-13 15:31:36,536 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7fc3911d3891400eab9f7c96bc978726 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-13 15:31:36,539 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7fc3911d3891400eab9f7c96bc978726 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-13 15:31:36,542 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##aebda8831de14e3ca887d9fc3dcaba8b] (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 [##ef84c966bd9d4ae1b242dc5bd5f04bcd] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-02-13 15:31:36,549 线程ID: 10 日志级别: 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 ##5a19e1695c3c43c9958ea754aac0785a 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 [##da31c5a2b95b4a83815dbf09a657d77d] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##3f432e50fafc4f338b6d9d6d75fee1f1] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-13 15:31:36,618 线程ID: 10 日志级别: 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 ##65a5d632b79c45fea306c55434eb25a1 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 [##da31c5a2b95b4a83815dbf09a657d77d] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##3f432e50fafc4f338b6d9d6d75fee1f1] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-13' 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 时间: 2023-02-13 15:31:36,650 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##65a5d632b79c45fea306c55434eb25a1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-13 15:31:36,654 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##65a5d632b79c45fea306c55434eb25a1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-13 15:31:36,657 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##65a5d632b79c45fea306c55434eb25a1 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 = '退货' 时间: 2023-02-13 15:31:36,686 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##65a5d632b79c45fea306c55434eb25a1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-13 15:31:36,688 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##65a5d632b79c45fea306c55434eb25a1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-13 15:31:36,691 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##aebda8831de14e3ca887d9fc3dcaba8b(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##9e3aadf50b8b4ea393f9333258abed02 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-13 15:31:36,696 线程ID: 10 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[9d1d355a-e47c-412b-a4df-f125c8b1bbea] FROM ##aebda8831de14e3ca887d9fc3dcaba8b 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 ##5a19e1695c3c43c9958ea754aac0785a 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 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 时间: 2023-02-13 15:34:16,013 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##e2493da71d3247958d9bedb3078a7144] 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 [##e2493da71d3247958d9bedb3078a7144] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-02-13 15:34:16,074 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OldQuantity = ISNULL(B.Quantity,0) FROM [##e2493da71d3247958d9bedb3078a7144] 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 [##e2493da71d3247958d9bedb3078a7144] WHERE A.PuReceiptID = PuReceiptID ) GROUP BY A.PuReceiptID ) B ON A.PuReceiptID = B.PuReceiptID 时间: 2023-02-13 15:34:16,138 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0) FROM [##e2493da71d3247958d9bedb3078a7144] 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 [##e2493da71d3247958d9bedb3078a7144] WHERE A.DealereturnID = DealereturnID ) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2023-02-13 15:34:16,209 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0) FROM [##e2493da71d3247958d9bedb3078a7144] 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 [##e2493da71d3247958d9bedb3078a7144] WHERE A.RenoticeID = RenoticeID ) GROUP BY A.RenoticeID ) B ON A.RenoticeID = B.RenoticeID 时间: 2023-02-13 15:34:16,242 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0) FROM [##e2493da71d3247958d9bedb3078a7144] 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 [##e2493da71d3247958d9bedb3078a7144] WHERE A.PuReturnID = PuReturnID ) GROUP BY A.PuReturnID ) B ON A.PuReturnID = B.PuReturnID 时间: 2023-02-13 15:34:16,277 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0) FROM ##e2493da71d3247958d9bedb3078a7144 A 时间: 2023-02-13 15:34:16,280 线程ID: 16 日志级别: 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.[dabc6470-c7c3-4652-b73a-3d8caa4920a3] FROM [##e2493da71d3247958d9bedb3078a7144] ORDER BY Receipt_Date DESC, PureceiptID ASC 时间: 2023-02-13 15:56:30,469 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##4abee9f508b24ca4be1a7bcc5579f011] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-13 15:56:30,476 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4abee9f508b24ca4be1a7bcc5579f011] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##4abee9f508b24ca4be1a7bcc5579f011] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-13 15:56:30,477 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##4abee9f508b24ca4be1a7bcc5579f011] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 15:56:30,492 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##4abee9f508b24ca4be1a7bcc5579f011] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 15:56:30,494 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##4abee9f508b24ca4be1a7bcc5579f011 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##4abee9f508b24ca4be1a7bcc5579f011 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##328cdf9e6f70435db8dfa11a2797a9f7] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-13 15:56:30,587 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##4abee9f508b24ca4be1a7bcc5579f011 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##4abee9f508b24ca4be1a7bcc5579f011 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##328cdf9e6f70435db8dfa11a2797a9f7] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-13 15:56:30,671 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##4abee9f508b24ca4be1a7bcc5579f011 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 ##4abee9f508b24ca4be1a7bcc5579f011 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##328cdf9e6f70435db8dfa11a2797a9f7] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:56:30,796 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##4abee9f508b24ca4be1a7bcc5579f011 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 ##4abee9f508b24ca4be1a7bcc5579f011 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##328cdf9e6f70435db8dfa11a2797a9f7] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:56:31,222 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##4abee9f508b24ca4be1a7bcc5579f011 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 ##4abee9f508b24ca4be1a7bcc5579f011 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##328cdf9e6f70435db8dfa11a2797a9f7] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:56:31,530 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4abee9f508b24ca4be1a7bcc5579f011 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-13 15:56:31,532 线程ID: 76 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##4abee9f508b24ca4be1a7bcc5579f011] 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 [##4abee9f508b24ca4be1a7bcc5579f011] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 15:56:31,567 线程ID: 76 日志级别: 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.[feb8226c-8958-48a4-9574-7f5fc54a42ab] FROM [##4abee9f508b24ca4be1a7bcc5579f011] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 16:13:38,770 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##67361f11094543c580eb2d8f39cfd1c5] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-13 16:13:38,777 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##67361f11094543c580eb2d8f39cfd1c5] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##67361f11094543c580eb2d8f39cfd1c5] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-13 16:13:38,783 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##67361f11094543c580eb2d8f39cfd1c5] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:13:38,791 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##67361f11094543c580eb2d8f39cfd1c5] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:13:38,799 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##67361f11094543c580eb2d8f39cfd1c5 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##67361f11094543c580eb2d8f39cfd1c5 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##32283c07c9f142f998b0c2386fabace2] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-13 16:13:38,883 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##67361f11094543c580eb2d8f39cfd1c5 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##67361f11094543c580eb2d8f39cfd1c5 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##32283c07c9f142f998b0c2386fabace2] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-13 16:13:38,970 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##67361f11094543c580eb2d8f39cfd1c5 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 ##67361f11094543c580eb2d8f39cfd1c5 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##32283c07c9f142f998b0c2386fabace2] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:13:39,097 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##67361f11094543c580eb2d8f39cfd1c5 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 ##67361f11094543c580eb2d8f39cfd1c5 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##32283c07c9f142f998b0c2386fabace2] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:13:39,527 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##67361f11094543c580eb2d8f39cfd1c5 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 ##67361f11094543c580eb2d8f39cfd1c5 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##32283c07c9f142f998b0c2386fabace2] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:13:39,844 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##67361f11094543c580eb2d8f39cfd1c5 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-13 16:13:39,846 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##67361f11094543c580eb2d8f39cfd1c5] 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 [##67361f11094543c580eb2d8f39cfd1c5] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:13:39,881 线程ID: 16 日志级别: 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.[76e22ca8-7d48-4011-a7c6-76d276d8a43c] FROM [##67361f11094543c580eb2d8f39cfd1c5] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 16:14:11,744 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##79be280336134c8e8d103894f18d9c70] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-13 16:14:11,749 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##79be280336134c8e8d103894f18d9c70] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##79be280336134c8e8d103894f18d9c70] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-13 16:14:11,755 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##79be280336134c8e8d103894f18d9c70] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:14:11,759 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##79be280336134c8e8d103894f18d9c70] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:14:11,763 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##79be280336134c8e8d103894f18d9c70 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##79be280336134c8e8d103894f18d9c70 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##2ff3ad1f0d2b4c74b616e9997e2c57ec] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-13 16:14:11,820 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##79be280336134c8e8d103894f18d9c70 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##79be280336134c8e8d103894f18d9c70 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##2ff3ad1f0d2b4c74b616e9997e2c57ec] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-13 16:14:11,878 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##79be280336134c8e8d103894f18d9c70 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 ##79be280336134c8e8d103894f18d9c70 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##2ff3ad1f0d2b4c74b616e9997e2c57ec] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:12,013 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##79be280336134c8e8d103894f18d9c70 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 ##79be280336134c8e8d103894f18d9c70 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##2ff3ad1f0d2b4c74b616e9997e2c57ec] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:12,518 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##79be280336134c8e8d103894f18d9c70 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 ##79be280336134c8e8d103894f18d9c70 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##2ff3ad1f0d2b4c74b616e9997e2c57ec] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:12,898 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##79be280336134c8e8d103894f18d9c70 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-13 16:14:12,899 线程ID: 43 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##79be280336134c8e8d103894f18d9c70] 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 [##79be280336134c8e8d103894f18d9c70] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:12,936 线程ID: 43 日志级别: 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.[fa4fb0fc-076f-4aae-be23-e763ccb3eaac] FROM [##79be280336134c8e8d103894f18d9c70] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 16:14:13,337 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##d62bfe65778f4abdaa8ec38c6338a6ec] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-13 16:14:13,342 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##d62bfe65778f4abdaa8ec38c6338a6ec] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##d62bfe65778f4abdaa8ec38c6338a6ec] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-13 16:14:13,347 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##d62bfe65778f4abdaa8ec38c6338a6ec] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:14:13,352 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##d62bfe65778f4abdaa8ec38c6338a6ec] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:14:13,357 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##d62bfe65778f4abdaa8ec38c6338a6ec A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##d62bfe65778f4abdaa8ec38c6338a6ec WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##737c2557964947009af118fe39e100b9] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-13 16:14:13,414 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##d62bfe65778f4abdaa8ec38c6338a6ec A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##d62bfe65778f4abdaa8ec38c6338a6ec WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##737c2557964947009af118fe39e100b9] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-13 16:14:13,474 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##d62bfe65778f4abdaa8ec38c6338a6ec 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 ##d62bfe65778f4abdaa8ec38c6338a6ec WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##737c2557964947009af118fe39e100b9] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:13,609 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##d62bfe65778f4abdaa8ec38c6338a6ec 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 ##d62bfe65778f4abdaa8ec38c6338a6ec WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##737c2557964947009af118fe39e100b9] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:14,119 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##d62bfe65778f4abdaa8ec38c6338a6ec 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 ##d62bfe65778f4abdaa8ec38c6338a6ec C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##737c2557964947009af118fe39e100b9] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:14,532 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d62bfe65778f4abdaa8ec38c6338a6ec SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-13 16:14:14,533 线程ID: 85 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##d62bfe65778f4abdaa8ec38c6338a6ec] 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 [##d62bfe65778f4abdaa8ec38c6338a6ec] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:14:14,572 线程ID: 85 日志级别: 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.[33d9b453-1351-4bed-887d-ad378ee3d1f0] FROM [##d62bfe65778f4abdaa8ec38c6338a6ec] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 16:15:31,296 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##80be92442f6041838242c41293e4aa12] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2023-02-13 16:15:31,305 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##80be92442f6041838242c41293e4aa12] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##80be92442f6041838242c41293e4aa12] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2023-02-13 16:15:31,312 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##80be92442f6041838242c41293e4aa12] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:15:31,321 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##80be92442f6041838242c41293e4aa12] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2023-02-13 16:15:31,331 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##80be92442f6041838242c41293e4aa12 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##80be92442f6041838242c41293e4aa12 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##66d11986c90a4bc4be2bc4f07a438677] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2023-02-13 16:15:31,430 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##80be92442f6041838242c41293e4aa12 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##80be92442f6041838242c41293e4aa12 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##66d11986c90a4bc4be2bc4f07a438677] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2023-02-13 16:15:31,516 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##80be92442f6041838242c41293e4aa12 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 ##80be92442f6041838242c41293e4aa12 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##66d11986c90a4bc4be2bc4f07a438677] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:15:31,642 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##80be92442f6041838242c41293e4aa12 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 ##80be92442f6041838242c41293e4aa12 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##66d11986c90a4bc4be2bc4f07a438677] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:15:32,076 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##80be92442f6041838242c41293e4aa12 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 ##80be92442f6041838242c41293e4aa12 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##66d11986c90a4bc4be2bc4f07a438677] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:15:32,389 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##80be92442f6041838242c41293e4aa12 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2023-02-13 16:15:32,392 线程ID: 51 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##80be92442f6041838242c41293e4aa12] 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 [##80be92442f6041838242c41293e4aa12] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 16:15:32,428 线程ID: 51 日志级别: 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.[76e22ca8-7d48-4011-a7c6-76d276d8a43c] FROM [##80be92442f6041838242c41293e4aa12] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2023-02-13 16:18:19,172 线程ID: 16 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[e92c82a3-cbdd-4b53-a248-78c42fffd30d] FROM Customer A INNER JOIN [##57dbd44297eb4bd6bb2c47ba62a42c42] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2023-02-13 16:18:26,042 线程ID: 94 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称] ,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式] ,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额] ,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣] ,[Group] [组], Company_ID [公司编号], SaleMan [业务员] ,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别] INTO tempdb.dbo.[68bf4ba0-275a-4c9e-8224-af21f0ccf5a4] FROM Customer A INNER JOIN [##368eea9b62a547f19299570fe65e2d5f] B ON A.Customer_ID = B.Customer_ID ORDER BY A.Customer_ID 时间: 2023-02-13 18:12:14,554 线程ID: 25 日志级别: 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 [##eaff671f6aaa41068d47ba4c7e39ac80] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 18:12:14,802 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##eaff671f6aaa41068d47ba4c7e39ac80] (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 [##97ece3c1eadf4c5dbcda46528a65b9e5] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:12:15,124 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##eaff671f6aaa41068d47ba4c7e39ac80] (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 [##a4771ff5f46c4420afbc233f1be84f25] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:12:15,134 线程ID: 25 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##eaff671f6aaa41068d47ba4c7e39ac80] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 18:12:31,878 线程ID: 28 日志级别: 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 [##e393a32c98624699a5d3cbf928567d4b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2023-02-13 18:12:32,233 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ba571b8f40cf4d49b2b82eb983d1da08] where 2=2 and ISNULL(S1,0)=0 时间: 2023-02-13 18:12:32,235 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e393a32c98624699a5d3cbf928567d4b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ba571b8f40cf4d49b2b82eb983d1da08] 时间: 2023-02-13 18:12:32,313 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4d01ec455e774b6ebf64419f42a32cb8 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-13 18:12:32,316 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4d01ec455e774b6ebf64419f42a32cb8 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-13 18:12:32,319 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##4d01ec455e774b6ebf64419f42a32cb8 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 = '退货' 时间: 2023-02-13 18:12:32,347 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4d01ec455e774b6ebf64419f42a32cb8 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-13 18:12:32,349 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##4d01ec455e774b6ebf64419f42a32cb8 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-13 18:12:32,353 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##e393a32c98624699a5d3cbf928567d4b] (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 [##737fd85e55984b22ac96dc61b8ddd2b8] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2023-02-13 18:12:32,358 线程ID: 28 日志级别: 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 ##3edf7d1eb32e4402bac3ae2d64888526 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 [##4d675b3923e74a29921dd9740de8dd10] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##2144e89d64714328a461ad566ab83e5c] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2023-02-13 18:12:32,417 线程ID: 28 日志级别: 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 ##fd5b34a6299943aba278d17084ae1edc 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 [##4d675b3923e74a29921dd9740de8dd10] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##2144e89d64714328a461ad566ab83e5c] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2023-02-13' 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 时间: 2023-02-13 18:12:32,452 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fd5b34a6299943aba278d17084ae1edc a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2023-02-13 18:12:32,455 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd5b34a6299943aba278d17084ae1edc SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2023-02-13 18:12:32,457 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fd5b34a6299943aba278d17084ae1edc 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 = '退货' 时间: 2023-02-13 18:12:32,488 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd5b34a6299943aba278d17084ae1edc SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2023-02-13 18:12:32,490 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fd5b34a6299943aba278d17084ae1edc SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2023-02-13 18:12:32,493 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##e393a32c98624699a5d3cbf928567d4b(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##8a56ec5b05dc42f7b2b7e25f189e37fd GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2023-02-13 18:12:32,502 线程ID: 28 日志级别: 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 [渠道库存], CAST(NULL AS IMAGE) AS [图片], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([销售#数量]) AS [销售] INTO tempdb.dbo.[9d1d355a-e47c-412b-a4df-f125c8b1bbea] FROM ##e393a32c98624699a5d3cbf928567d4b 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 ##3edf7d1eb32e4402bac3ae2d64888526 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 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 时间: 2023-02-13 18:12:39,568 线程ID: 30 日志级别: 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 [##404dca489ea243119186056bf3227981] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 18:12:39,807 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##404dca489ea243119186056bf3227981] (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 [##be611211cdc24fc794a95cc130b26e37] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:12:40,132 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##404dca489ea243119186056bf3227981] (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 [##900966381fc24ddf84253e4d7f15445d] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:12:40,136 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##404dca489ea243119186056bf3227981] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 18:13:39,404 线程ID: 31 日志级别: 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 [##8ef5b09f54694049bf49514a9ae9f9d0] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 18:13:39,610 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8ef5b09f54694049bf49514a9ae9f9d0] (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 [##2e857dd9becf4fbb86ead07915a1c493] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:13:39,915 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8ef5b09f54694049bf49514a9ae9f9d0] (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 [##97a8ed868dfb460e86a64996b08096f2] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:13:39,918 线程ID: 31 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##8ef5b09f54694049bf49514a9ae9f9d0] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 18:13:55,008 线程ID: 40 日志级别: 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 [##f2ea8de7c8a6497787e5507f766e9a7d] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 18:13:55,227 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f2ea8de7c8a6497787e5507f766e9a7d] (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 [##9511873b28684bba9e2cf9882c437f4a] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:13:55,567 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f2ea8de7c8a6497787e5507f766e9a7d] (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 [##bfba97a2b0a24d6c96e94dc3b4c10d08] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2023-02-13 18:13:55,570 线程ID: 40 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##f2ea8de7c8a6497787e5507f766e9a7d] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 18:17:02,978 线程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.[71d528d4-03c6-456d-95f8-62104b5b023c] FROM [##d66ce0d6ddd147e1accbd3a74aafc579] ORDER BY Goods_no 时间: 2023-02-13 18:28:49,229 线程ID: 35 日志级别: 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 [##4d88b4541494445d86bd30d6124bda39] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2023-02-13 18:28:49,232 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##4d88b4541494445d86bd30d6124bda39] SET 库存合计#数量 = ISNULL(库存#数量,0) + ISNULL(在途库存#数量,0) 时间: 2023-02-13 18:28:59,698 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##db971c6e02ac48308f3e1964109a6cb2] 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 [##db971c6e02ac48308f3e1964109a6cb2] WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##b71cfd63739a40ccb37612dc20b649c7] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2023-02-13 18:28:59,870 线程ID: 34 日志级别: 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.[cea67f87-de3b-472d-b597-8a84ee05b08b] FROM [##db971c6e02ac48308f3e1964109a6cb2] ORDER BY Delivery_Date DESC, DeliveryID ASC