时间: 2021-11-03 11:10:22,004 线程ID: 83 日志级别: 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 [##c976270668264c7e8dec5f721b9385e1] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-11-03 11:10:22,385 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2801a79639cb48748dacf8cc666d092f] where 2=2 and ISNULL(S1,0)=0 时间: 2021-11-03 11:10:22,387 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c976270668264c7e8dec5f721b9385e1] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2801a79639cb48748dacf8cc666d092f] 时间: 2021-11-03 11:10:22,475 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##40c32e9c15744650971182ffcfaffd60 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-11-03 11:10:22,477 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##40c32e9c15744650971182ffcfaffd60 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-11-03 11:10:22,481 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##40c32e9c15744650971182ffcfaffd60 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-11-03 11:10:22,512 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##40c32e9c15744650971182ffcfaffd60 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-11-03 11:10:22,514 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##40c32e9c15744650971182ffcfaffd60 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-11-03 11:10:22,518 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c976270668264c7e8dec5f721b9385e1] (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 [##1711d32f0dc84d738451b4933b67d3a4] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-11-03 11:10:22,529 线程ID: 83 日志级别: 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.[4bbd00ae-5403-4138-a955-85faefc4da74] FROM ##c976270668264c7e8dec5f721b9385e1 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-11-03 11:12:26,002 线程ID: 114 日志级别: 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 [##c72265b140954a9fa274e43a210c5579] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-11-03 11:12:26,396 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##18ef5d5707b948348a63e610cc9fa8a4] where 2=2 and ISNULL(S1,0)=0 时间: 2021-11-03 11:12:26,399 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c72265b140954a9fa274e43a210c5579] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##18ef5d5707b948348a63e610cc9fa8a4] 时间: 2021-11-03 11:12:26,495 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7c4fdf9c878e4f848abfae989e669938 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-11-03 11:12:26,498 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7c4fdf9c878e4f848abfae989e669938 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-11-03 11:12:26,502 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##7c4fdf9c878e4f848abfae989e669938 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-11-03 11:12:26,540 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7c4fdf9c878e4f848abfae989e669938 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-11-03 11:12:26,543 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7c4fdf9c878e4f848abfae989e669938 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-11-03 11:12:26,547 线程ID: 114 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c72265b140954a9fa274e43a210c5579] (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 [##6f065f063ea541ccb4b50d8c4dc72907] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-11-03 11:12:26,554 线程ID: 114 日志级别: 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.[4bbd00ae-5403-4138-a955-85faefc4da74] FROM ##c72265b140954a9fa274e43a210c5579 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-11-03 11:41:09,995 线程ID: 18 日志级别: 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 [##bbe207dac9694188833d1d802a196194] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-11-03 11:41:10,400 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##091b5673248d4645a59d6d8e8fb4abf0] where 2=2 and ISNULL(S1,0)=0 时间: 2021-11-03 11:41:10,402 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bbe207dac9694188833d1d802a196194] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##091b5673248d4645a59d6d8e8fb4abf0] 时间: 2021-11-03 11:41:10,498 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9883e07a432c4ad59c81175d8bfd3522 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-11-03 11:41:10,500 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9883e07a432c4ad59c81175d8bfd3522 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-11-03 11:41:10,504 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9883e07a432c4ad59c81175d8bfd3522 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-11-03 11:41:10,542 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9883e07a432c4ad59c81175d8bfd3522 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-11-03 11:41:10,543 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9883e07a432c4ad59c81175d8bfd3522 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-11-03 11:41:10,546 线程ID: 18 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##bbe207dac9694188833d1d802a196194] (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 [##a0cbb271774e46008135fe8336dcdbed] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-11-03 11:41:10,552 线程ID: 18 日志级别: 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.[4bbd00ae-5403-4138-a955-85faefc4da74] FROM ##bbe207dac9694188833d1d802a196194 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-11-03 11:43:49,594 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##44416a076c8741ffba7a5342a4f64e25] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2021-11-03 11:43:49,598 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##44416a076c8741ffba7a5342a4f64e25] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##44416a076c8741ffba7a5342a4f64e25] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2021-11-03 11:43:49,603 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##44416a076c8741ffba7a5342a4f64e25] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 11:43:49,608 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##44416a076c8741ffba7a5342a4f64e25] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 11:43:49,612 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##44416a076c8741ffba7a5342a4f64e25 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##44416a076c8741ffba7a5342a4f64e25 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##545386b8048948ad8d00d230e8b841f6] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2021-11-03 11:43:49,657 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##44416a076c8741ffba7a5342a4f64e25 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##44416a076c8741ffba7a5342a4f64e25 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##545386b8048948ad8d00d230e8b841f6] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2021-11-03 11:43:49,700 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##44416a076c8741ffba7a5342a4f64e25 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 ##44416a076c8741ffba7a5342a4f64e25 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##545386b8048948ad8d00d230e8b841f6] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 11:43:49,785 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##44416a076c8741ffba7a5342a4f64e25 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 ##44416a076c8741ffba7a5342a4f64e25 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##545386b8048948ad8d00d230e8b841f6] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 11:43:49,994 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##44416a076c8741ffba7a5342a4f64e25 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 ##44416a076c8741ffba7a5342a4f64e25 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##545386b8048948ad8d00d230e8b841f6] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 11:43:50,153 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##44416a076c8741ffba7a5342a4f64e25 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2021-11-03 11:43:50,154 线程ID: 81 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##44416a076c8741ffba7a5342a4f64e25] 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 [##44416a076c8741ffba7a5342a4f64e25] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 11:43:50,190 线程ID: 81 日志级别: 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.[78878116-0415-4c4a-bad7-4ffaa8cc3d1e] FROM [##44416a076c8741ffba7a5342a4f64e25] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2021-11-03 11:58:42,494 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##bc010fdbba144cc694054db62247d405] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo ) 时间: 2021-11-03 11:58:42,499 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc010fdbba144cc694054db62247d405] SET IsForWay = 1 WHERE NOT Exists( SELECT ShopToutID FROM ShopTin WHERE 1 = 1 AND [##bc010fdbba144cc694054db62247d405].ShopToutID = ShopToutID) 时间: 2021-11-03 11:58:42,503 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc010fdbba144cc694054db62247d405] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##bc010fdbba144cc694054db62247d405] A INNER JOIN ShopTin B ON A.ShopToutID = B.ShopToutID WHERE 1 = 1 时间: 2021-11-03 11:58:42,510 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM [##bc010fdbba144cc694054db62247d405] A INNER JOIN ( SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount FROM [ShopToutGoods] A INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##bc010fdbba144cc694054db62247d405 WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##33c69fe6196e4390b582e96d42bc3033] WHERE Goods_No = A.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2021-11-03 11:58:42,656 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) FROM [##bc010fdbba144cc694054db62247d405] A INNER JOIN ( SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity FROM ShopTin A INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID WHERE EXISTS( SELECT 1 FROM [##bc010fdbba144cc694054db62247d405] WHERE A.ShopToutID = ShopToutID ) AND EXISTS (SELECT 1 FROM [##33c69fe6196e4390b582e96d42bc3033] WHERE Goods_No = B.Goods_No) GROUP BY A.ShopToutID ) B ON A.ShopToutID = B.ShopToutID 时间: 2021-11-03 11:58:42,851 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##bc010fdbba144cc694054db62247d405] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 时间: 2021-11-03 11:58:42,856 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期] , ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号] , TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[8a353605-89be-404b-9f15-0da904e97a96] FROM [##bc010fdbba144cc694054db62247d405] ORDER BY Tout_Date DESC, ShopToutID ASC 时间: 2021-11-03 12:29:27,743 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##204bca3127c94a26b1015fba6b816910] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2021-11-03 12:29:27,747 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##204bca3127c94a26b1015fba6b816910] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##204bca3127c94a26b1015fba6b816910] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2021-11-03 12:29:27,752 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##204bca3127c94a26b1015fba6b816910] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 12:29:27,756 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##204bca3127c94a26b1015fba6b816910] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 12:29:27,760 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##204bca3127c94a26b1015fba6b816910 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##204bca3127c94a26b1015fba6b816910 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##ee939af1a1804274bba8d702262bbd67] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2021-11-03 12:29:27,809 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##204bca3127c94a26b1015fba6b816910 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##204bca3127c94a26b1015fba6b816910 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##ee939af1a1804274bba8d702262bbd67] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2021-11-03 12:29:27,856 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##204bca3127c94a26b1015fba6b816910 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 ##204bca3127c94a26b1015fba6b816910 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##ee939af1a1804274bba8d702262bbd67] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:29:27,943 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##204bca3127c94a26b1015fba6b816910 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 ##204bca3127c94a26b1015fba6b816910 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##ee939af1a1804274bba8d702262bbd67] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:29:28,162 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##204bca3127c94a26b1015fba6b816910 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 ##204bca3127c94a26b1015fba6b816910 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##ee939af1a1804274bba8d702262bbd67] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:29:28,324 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##204bca3127c94a26b1015fba6b816910 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2021-11-03 12:29:28,326 线程ID: 77 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##204bca3127c94a26b1015fba6b816910] 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 [##204bca3127c94a26b1015fba6b816910] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:29:28,364 线程ID: 77 日志级别: 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.[78878116-0415-4c4a-bad7-4ffaa8cc3d1e] FROM [##204bca3127c94a26b1015fba6b816910] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2021-11-03 12:30:24,450 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##7634da63bac742b5ba09801806fe2ad1] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2021-11-03 12:30:24,455 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##7634da63bac742b5ba09801806fe2ad1] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##7634da63bac742b5ba09801806fe2ad1] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2021-11-03 12:30:24,461 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##7634da63bac742b5ba09801806fe2ad1] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 12:30:24,465 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##7634da63bac742b5ba09801806fe2ad1] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 12:30:24,469 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##7634da63bac742b5ba09801806fe2ad1 A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##7634da63bac742b5ba09801806fe2ad1 WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##a0bda6ac3b34426aa44343a7e3e375f7] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2021-11-03 12:30:24,514 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##7634da63bac742b5ba09801806fe2ad1 A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##7634da63bac742b5ba09801806fe2ad1 WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##a0bda6ac3b34426aa44343a7e3e375f7] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2021-11-03 12:30:24,559 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##7634da63bac742b5ba09801806fe2ad1 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 ##7634da63bac742b5ba09801806fe2ad1 WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##a0bda6ac3b34426aa44343a7e3e375f7] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:30:24,647 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##7634da63bac742b5ba09801806fe2ad1 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 ##7634da63bac742b5ba09801806fe2ad1 WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##a0bda6ac3b34426aa44343a7e3e375f7] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:30:24,862 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##7634da63bac742b5ba09801806fe2ad1 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 ##7634da63bac742b5ba09801806fe2ad1 C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##a0bda6ac3b34426aa44343a7e3e375f7] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:30:25,029 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##7634da63bac742b5ba09801806fe2ad1 SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2021-11-03 12:30:25,030 线程ID: 80 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##7634da63bac742b5ba09801806fe2ad1] 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 [##7634da63bac742b5ba09801806fe2ad1] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 12:30:25,066 线程ID: 80 日志级别: 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.[78878116-0415-4c4a-bad7-4ffaa8cc3d1e] FROM [##7634da63bac742b5ba09801806fe2ad1] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2021-11-03 12:46:07,132 线程ID: 18 日志级别: 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.[4d178762-680e-4060-98c4-09b28fe0b7c0] FROM [##659b5b78aa224ae2b025df43f0f90586] ORDER BY Goods_no 时间: 2021-11-03 14:37:47,068 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##248bcdb72c5d41d5a4908b6dfe9932fa] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'Wout' AND A.DeliveryID = BillNo ) 时间: 2021-11-03 14:37:47,072 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##248bcdb72c5d41d5a4908b6dfe9932fa] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END FROM [##248bcdb72c5d41d5a4908b6dfe9932fa] A INNER JOIN ShopTin B ON A.DeliveryID = B.DeliveryID WHERE 1 = 1 时间: 2021-11-03 14:37:47,078 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 0 FROM [##248bcdb72c5d41d5a4908b6dfe9932fa] A WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 14:37:47,084 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET IsInStock = 1 FROM [##248bcdb72c5d41d5a4908b6dfe9932fa] A WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 时间: 2021-11-03 14:37:47,089 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0) FROM ##248bcdb72c5d41d5a4908b6dfe9932fa A INNER JOIN ( SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity FROM SortingGoods A WHERE EXISTS( SELECT 1 FROM ##248bcdb72c5d41d5a4908b6dfe9932fa WHERE A.SortingID = SortingID ) AND EXISTS (SELECT 1 FROM [##5338f346486c4692ada762ca1f18caa8] WHERE Goods_No = A.Goods_No) GROUP BY A.SortingID ) B ON A.SortingID = B.SortingID 时间: 2021-11-03 14:37:47,133 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0) FROM ##248bcdb72c5d41d5a4908b6dfe9932fa A INNER JOIN ( SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity FROM OrderGoods A WHERE EXISTS( SELECT 1 FROM ##248bcdb72c5d41d5a4908b6dfe9932fa WHERE A.OrderID = OrderID ) AND EXISTS (SELECT 1 FROM [##5338f346486c4692ada762ca1f18caa8] WHERE Goods_No = A.Goods_No) GROUP BY A.OrderID ) B ON A.OrderID = B.OrderID 时间: 2021-11-03 14:37:47,181 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0) FROM ##248bcdb72c5d41d5a4908b6dfe9932fa 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 ##248bcdb72c5d41d5a4908b6dfe9932fa WHERE A.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##5338f346486c4692ada762ca1f18caa8] WHERE Goods_No = A.Goods_No) GROUP BY A.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 14:37:47,270 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0) FROM ##248bcdb72c5d41d5a4908b6dfe9932fa 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 ##248bcdb72c5d41d5a4908b6dfe9932fa WHERE B.DeliveryID = DeliveryID ) AND EXISTS (SELECT 1 FROM [##5338f346486c4692ada762ca1f18caa8] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 14:37:47,482 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0) FROM ##248bcdb72c5d41d5a4908b6dfe9932fa 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 ##248bcdb72c5d41d5a4908b6dfe9932fa C WHERE B.DeliveryID = C.DeliveryID ) AND EXISTS (SELECT 1 FROM [##5338f346486c4692ada762ca1f18caa8] WHERE Goods_No = A.Goods_No) GROUP BY B.DeliveryID ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 14:37:47,644 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##248bcdb72c5d41d5a4908b6dfe9932fa SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0) 时间: 2021-11-03 14:37:47,646 线程ID: 104 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET BoxCount = ISNULL(B.BoxCount,0) FROM [##248bcdb72c5d41d5a4908b6dfe9932fa] 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 [##248bcdb72c5d41d5a4908b6dfe9932fa] WHERE A.AccBillNo = DeliveryID ) GROUP BY A.AccBillNo ) B ON A.DeliveryID = B.DeliveryID 时间: 2021-11-03 14:37:47,680 线程ID: 104 日志级别: 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.[78878116-0415-4c4a-bad7-4ffaa8cc3d1e] FROM [##248bcdb72c5d41d5a4908b6dfe9932fa] ORDER BY Delivery_Date DESC, DeliveryID ASC 时间: 2021-11-03 15:40:39,840 线程ID: 9 日志级别: 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 [##213e48c4827c45019167d3789a005693] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-11-03 15:40:40,126 线程ID: 9 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##213e48c4827c45019167d3789a005693] (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 [##c1ff864010414e4ba5694d6abf2d0678] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-11-03 15:41:31,855 线程ID: 13 日志级别: 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 [##55540808edc5417b905d7840a83bdfbd] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-11-03 15:41:32,072 线程ID: 13 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##55540808edc5417b905d7840a83bdfbd] (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 [##83f154b9d88a4b6ba99e12d098cbc450] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-11-03 15:42:25,496 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##b4293ab2584544cbbb553a31d172d671] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo ) 时间: 2021-11-03 15:42:25,502 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##b4293ab2584544cbbb553a31d172d671] SET IsForWay = 1 WHERE NOT Exists( SELECT DealereturnID FROM Pureceipt WHERE Type = 3 AND [##b4293ab2584544cbbb553a31d172d671].DealereturnID = DealereturnID) 时间: 2021-11-03 15:42:25,508 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##b4293ab2584544cbbb553a31d172d671] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END FROM [##b4293ab2584544cbbb553a31d172d671] A INNER JOIN Pureceipt B ON A.DealereturnID = B.DealereturnID WHERE B.Type = 3 时间: 2021-11-03 15:42:25,514 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0), BalanceAmount = ISNULL(B.BalanceAmount,0) FROM [##b4293ab2584544cbbb553a31d172d671] A INNER JOIN ( SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount, SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount , SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0)) BalanceAmount FROM [DealeReturnGoods] A INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID LEFT JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID WHERE EXISTS( SELECT 1 FROM ##b4293ab2584544cbbb553a31d172d671 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##f8d1070e21164507b9e5238ee1e575ba] WHERE Goods_No = A.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-11-03 15:42:25,672 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##b4293ab2584544cbbb553a31d172d671] SET ReceiveQuantity = B.Quantity FROM [##b4293ab2584544cbbb553a31d172d671] A INNER JOIN ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity FROM Pureceipt A INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID WHERE EXISTS( SELECT 1 FROM ##b4293ab2584544cbbb553a31d172d671 WHERE A.DealereturnID = DealereturnID ) AND EXISTS (SELECT 1 FROM [##f8d1070e21164507b9e5238ee1e575ba] WHERE Goods_No = C.Goods_No) GROUP BY A.DealereturnID ) B ON A.DealereturnID = B.DealereturnID 时间: 2021-11-03 15:42:25,795 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##b4293ab2584544cbbb553a31d172d671] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 时间: 2021-11-03 15:42:25,811 线程ID: 19 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期] , rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号] , Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量] , DpAmount AS [吊牌额] , Amount AS [零售额] , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数] , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库] , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期] , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期] , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期] , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注] INTO tempdb.dbo.[60b4585c-9985-45f2-a6d6-64b4815841ba] FROM [##b4293ab2584544cbbb553a31d172d671] ORDER BY Return_Date DESC, DealereturnID ASC 时间: 2021-11-03 18:08:56,229 线程ID: 67 日志级别: 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 [##64dd382b98394f839a54d761ef6374a7] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-11-03 18:08:56,426 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##64dd382b98394f839a54d761ef6374a7] (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 [##4e91f9f0af5a4e79b2ee86c0cf7f0e43] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-11-03 20:13:27,633 线程ID: 12 日志级别: 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 [##82f590c8e4bc498997eabf2144235f62] FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W 时间: 2021-11-03 20:13:27,832 线程ID: 12 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##82f590c8e4bc498997eabf2144235f62] (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 [##ad328a2b29b24455995c4e1e76838045] A INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No 时间: 2021-11-03 20:29:13,555 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: select top 0 cast('' as varchar(50)) as 发生日期, CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 , cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号, cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号, cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色, cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS 数量 INTO ##d3fb228a40964e2a93776734f2eb1bc3 from Goods 时间: 2021-11-03 20:29:13,568 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型, CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no where a.type=1 and a.posted=1 and a.tinshop = 'z008' and b.goods_No = '2021150' and a.tin_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,584 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop where a.type=2 and a.posted=1 and a.tinshop = 'z008' and b.goods_No = '2021150' and a.tin_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,599 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明, c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量] from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.type=3 and a.posted=1 and a.tinshop = 'z008' and b.goods_No = '2021150' and a.tin_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,616 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No where a.posted=1 AND (ISNULL(a.Type,'')='' OR a.Type=1) and a.customer_ID = 'z008' and b.goods_No = '2021150' and a.return_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid, a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,648 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Supply s ON s.Supply_No = a.Supply_No where a.posted=1 AND (a.Type=2) and a.customer_ID = 'z008' and b.goods_No = '2021150' and a.return_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,662 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID, a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注, b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity] into ##5effe81259094d53b26f51c0614dd40f from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID where a.posted=1 AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0) and a.customer_ID = 'z008' and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理') and b.goods_No = '2021150' and a.Checkdate < '2021/11/4 0:00:00' group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate, b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,689 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.零售订单号='' FROM ##5effe81259094d53b26f51c0614dd40f A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2)) 时间: 2021-11-03 20:29:13,695 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long, SUM(c.[S1]) AS [S1], sum(Quantity) FROM ##5effe81259094d53b26f51c0614dd40f c GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long 时间: 2021-11-03 20:29:13,712 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位, cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号, goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop where a.posted=1 and a.toutshop = 'z008' and b.goods_No = '2021150' and a.tout_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long, a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,727 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##d3fb228a40964e2a93776734f2eb1bc3 select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称, a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(-c.[S1]) AS [S1], (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量] from balance as a left join balancegoods as b on a.balanceid=b.balanceid left join balancedetail as c on b.balancegoodsid=c.balancegoodsid left join goods on b.goods_no=goods.goods_no left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id where a.posted=1 and a.type=2 and a.customer_ID = 'z008' and b.goods_No = '2021150' and a.balance_date < '2021/11/4 0:00:00' group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id, ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max)) 时间: 2021-11-03 20:29:13,742 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d3fb228a40964e2a93776734f2eb1bc3 SET 销售类型=ISNULL(销售类型,'') 时间: 2021-11-03 20:29:13,743 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.销售类型=b.SaleType FROM ##d3fb228a40964e2a93776734f2eb1bc3 a INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR) WHERE a.单据类型 IN('店铺零售','加盟店铺零售') 时间: 2021-11-03 20:29:13,748 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d3fb228a40964e2a93776734f2eb1bc3 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> '' 时间: 2021-11-03 20:29:13,750 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d3fb228a40964e2a93776734f2eb1bc3 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 销售类型 NOT IN ('预售自提','预售直发','线上发货') 时间: 2021-11-03 20:29:13,751 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: DELETE a FROM ##d3fb228a40964e2a93776734f2eb1bc3 a WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提') 时间: 2021-11-03 20:29:13,753 线程ID: 36 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , CONVERT(VARCHAR(10), a.发生日期, 120) AS [发生日期], a.数量 AS [数量], a.操作类型 AS [操作类型], a.单据类型 AS [单据类型], a.对应单位 AS [对应单位], a.对应单位简称 AS [对应单位简称], a.手工单号 AS [手工单号], a.单号 AS [单号], a.备注 AS [备注], a.销售类型 AS [销售类型], a.零售订单号 AS [零售订单号], a.预售零售订单号 AS [预售零售订单号], a.货号 AS [货号], a.品名 AS [品名], a.颜色 AS [颜色], a.颜色说明 AS [颜色说明], a.内长 AS [内长], ISNULL(a.[S1], 0) AS [S1], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[bb526f8e-88e0-4b6b-b9c5-5c5d8d10cd9a] FROM ##d3fb228a40964e2a93776734f2eb1bc3 A INNER JOIN Goods g ON a.货号 = g.Goods_No