时间: 2021-12-24 13:38:37,704 线程ID: 110 日志级别: 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.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3] FROM [##d97d8e4e9f364a51aaff3bb93a6f3164] ORDER BY Goods_no 时间: 2021-12-24 13:38:44,060 线程ID: 114 日志级别: 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.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3] FROM [##7bc85207e5a045e894f58dd4d2846544] ORDER BY Goods_no 时间: 2021-12-24 13:39:05,328 线程ID: 113 日志级别: 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 [##2e1d29cd219f4f9089c548712e5df6ff] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 13:39:05,684 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##bbd4cbd2136c453f8542baaa1d021e9c] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 13:39:05,685 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2e1d29cd219f4f9089c548712e5df6ff] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bbd4cbd2136c453f8542baaa1d021e9c] 时间: 2021-12-24 13:39:05,687 线程ID: 113 日志级别: 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 ##048d5d09cf2c45bcb8aa1d3ad5448dbc 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 [##deeaf4fbd03444488a3c9229e2381a46] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##ddfa664a0d4f436fa369ea338827db55] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 13:39:05,758 线程ID: 113 日志级别: 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 ##73776c4ab0a84fdb99e6d5ee538371b5 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 [##deeaf4fbd03444488a3c9229e2381a46] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##ddfa664a0d4f436fa369ea338827db55] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-23' 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 时间: 2021-12-24 13:39:05,798 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##73776c4ab0a84fdb99e6d5ee538371b5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 13:39:05,801 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##73776c4ab0a84fdb99e6d5ee538371b5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 13:39:05,806 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##73776c4ab0a84fdb99e6d5ee538371b5 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-12-24 13:39:05,838 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##73776c4ab0a84fdb99e6d5ee538371b5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 13:39:05,840 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##73776c4ab0a84fdb99e6d5ee538371b5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 13:39:05,843 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2e1d29cd219f4f9089c548712e5df6ff(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##04ec1f4481e64a50a9b9385500f3fbc6 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 13:39:05,848 线程ID: 113 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##2e1d29cd219f4f9089c548712e5df6ff 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 ##048d5d09cf2c45bcb8aa1d3ad5448dbc 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 13:43:06,271 线程ID: 67 日志级别: 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 [##5590b22d1d0748d68af92d3a6e275642] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 13:43:06,653 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##58c744d8cc9e407d82c9c1a81eead62d] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 13:43:06,655 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5590b22d1d0748d68af92d3a6e275642] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##58c744d8cc9e407d82c9c1a81eead62d] 时间: 2021-12-24 13:43:06,657 线程ID: 67 日志级别: 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 ##2908232ecf9d4571a634fc80e5c97eb7 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 [##6ebbedc79fa048d1860c6880489f809d] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##433734ffa9614e11a348bdacd9ec685b] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 13:43:06,728 线程ID: 67 日志级别: 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 ##f7c131fcf40e4343b3ff7839d770ffaa 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 [##6ebbedc79fa048d1860c6880489f809d] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##433734ffa9614e11a348bdacd9ec685b] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 13:43:06,769 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f7c131fcf40e4343b3ff7839d770ffaa a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 13:43:06,772 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f7c131fcf40e4343b3ff7839d770ffaa SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 13:43:06,775 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f7c131fcf40e4343b3ff7839d770ffaa 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-12-24 13:43:06,809 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f7c131fcf40e4343b3ff7839d770ffaa SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 13:43:06,810 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f7c131fcf40e4343b3ff7839d770ffaa SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 13:43:06,814 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5590b22d1d0748d68af92d3a6e275642(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##d875bac6ceee448e9a1a8e1230dde7d2 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 13:43:06,819 线程ID: 67 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##5590b22d1d0748d68af92d3a6e275642 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 ##2908232ecf9d4571a634fc80e5c97eb7 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:01:47,908 线程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.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3] FROM [##70a8a992479b42e9b0d747b27e3b1dad] ORDER BY Goods_no 时间: 2021-12-24 14:02:08,414 线程ID: 72 日志级别: 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 [##ccfa4b4bd9c84f09a54deb6e137f01ef] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:02:08,749 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##6114b407ca6942e8af189e904d1d3900] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:02:08,751 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ccfa4b4bd9c84f09a54deb6e137f01ef] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##6114b407ca6942e8af189e904d1d3900] 时间: 2021-12-24 14:02:08,753 线程ID: 72 日志级别: 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 ##d7d09fc8658d4e10a36320039a9f3d96 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 [##7fd2daa55a314081abac855781e10af5] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##9a553d152b1449abb46d76b5292b5d0a] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:02:08,812 线程ID: 72 日志级别: 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 ##057eed6b608d45cd9c9815bd3a963bae 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 [##7fd2daa55a314081abac855781e10af5] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##9a553d152b1449abb46d76b5292b5d0a] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:02:08,845 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##057eed6b608d45cd9c9815bd3a963bae a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:02:08,847 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##057eed6b608d45cd9c9815bd3a963bae SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:02:08,851 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##057eed6b608d45cd9c9815bd3a963bae 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-12-24 14:02:08,877 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##057eed6b608d45cd9c9815bd3a963bae SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:02:08,878 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##057eed6b608d45cd9c9815bd3a963bae SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:02:08,881 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##ccfa4b4bd9c84f09a54deb6e137f01ef(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##f5b7e0d44fec4002bf458438cb7f40a0 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:02:08,885 线程ID: 72 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##ccfa4b4bd9c84f09a54deb6e137f01ef 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 ##d7d09fc8658d4e10a36320039a9f3d96 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:03:07,051 线程ID: 71 日志级别: 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 [##268d77dd7a8c4155bf87ca2210aa6965] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:03:07,366 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5ce262a9808e4f4c8f006ec2659cbb50] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:03:07,368 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##268d77dd7a8c4155bf87ca2210aa6965] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5ce262a9808e4f4c8f006ec2659cbb50] 时间: 2021-12-24 14:03:07,369 线程ID: 71 日志级别: 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 ##febfc2494ec64a9d84d023aacb02841d 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 [##cd3fc678a9644eb6b960ab748f7b5d41] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##094a1e660c5d48168cbdbe5a8c8165c4] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:03:07,430 线程ID: 71 日志级别: 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 ##93d7caadf8d640cca28142ee0f477559 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 [##cd3fc678a9644eb6b960ab748f7b5d41] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##094a1e660c5d48168cbdbe5a8c8165c4] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:03:07,462 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##93d7caadf8d640cca28142ee0f477559 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:03:07,464 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##93d7caadf8d640cca28142ee0f477559 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:03:07,467 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##93d7caadf8d640cca28142ee0f477559 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-12-24 14:03:07,492 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##93d7caadf8d640cca28142ee0f477559 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:03:07,493 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##93d7caadf8d640cca28142ee0f477559 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:03:07,496 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##268d77dd7a8c4155bf87ca2210aa6965(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##26c5c07ec92f4cfa8d7ad03234076329 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:03:07,501 线程ID: 71 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##268d77dd7a8c4155bf87ca2210aa6965 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 ##febfc2494ec64a9d84d023aacb02841d 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:12:37,783 线程ID: 92 日志级别: 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.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3] FROM [##aa9054c01c03430d82c54abd4a88f0f0] ORDER BY Goods_no 时间: 2021-12-24 14:12:58,070 线程ID: 92 日志级别: 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 [##42ebcd78dff14490b1b29113a394574d] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:12:58,434 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##89248085dddc4b60ba0efd174bfea24e] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:12:58,435 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##42ebcd78dff14490b1b29113a394574d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##89248085dddc4b60ba0efd174bfea24e] 时间: 2021-12-24 14:12:58,437 线程ID: 92 日志级别: 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 ##82b005ad7e13414fb94ae70f311cd950 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 [##7d36544778d94a308e75530d3997451f] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##b5ca5d6a4acb4c5eaca0afce837104b5] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:12:58,504 线程ID: 92 日志级别: 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 ##71faf02d9144476dadd1a30eae944f72 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 [##7d36544778d94a308e75530d3997451f] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##b5ca5d6a4acb4c5eaca0afce837104b5] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:12:58,543 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##71faf02d9144476dadd1a30eae944f72 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:12:58,544 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##71faf02d9144476dadd1a30eae944f72 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:12:58,548 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##71faf02d9144476dadd1a30eae944f72 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-12-24 14:12:58,581 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##71faf02d9144476dadd1a30eae944f72 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:12:58,583 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##71faf02d9144476dadd1a30eae944f72 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:12:58,586 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##42ebcd78dff14490b1b29113a394574d(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##4336d11f14334ac594f58e496cfe379b GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:12:58,591 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##42ebcd78dff14490b1b29113a394574d 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 ##82b005ad7e13414fb94ae70f311cd950 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:13:47,948 线程ID: 41 日志级别: 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 [##a403488275eb49f1904a9aeaae4bb319] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:13:48,250 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c03c7d7c48f440f4976ff4b2ae9baa86] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:13:48,251 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a403488275eb49f1904a9aeaae4bb319] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c03c7d7c48f440f4976ff4b2ae9baa86] 时间: 2021-12-24 14:13:48,252 线程ID: 41 日志级别: 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 ##1f789c5147dc4237af1bb439d340cff1 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 [##5885b88beefe473797a5bb17d8c95320] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##6ddadca3cf024d59a85e91e4df27be0d] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:13:48,312 线程ID: 41 日志级别: 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 ##2d37b5efedf94e5e8117433c3c680644 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 [##5885b88beefe473797a5bb17d8c95320] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##6ddadca3cf024d59a85e91e4df27be0d] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:13:48,343 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2d37b5efedf94e5e8117433c3c680644 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:13:48,346 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2d37b5efedf94e5e8117433c3c680644 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:13:48,348 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2d37b5efedf94e5e8117433c3c680644 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-12-24 14:13:48,377 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2d37b5efedf94e5e8117433c3c680644 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:13:48,378 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2d37b5efedf94e5e8117433c3c680644 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:13:48,381 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##a403488275eb49f1904a9aeaae4bb319(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e203bd9f667c4d13b450ec3a8148ef21 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:13:48,384 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##a403488275eb49f1904a9aeaae4bb319 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 ##1f789c5147dc4237af1bb439d340cff1 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:14:15,611 线程ID: 33 日志级别: 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 [##2249d4a5d8e14b4b862d9d2a3e0fc3bc] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:14:15,945 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##8a86f9ede13c4c9d9b90792908aba860] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:14:15,947 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2249d4a5d8e14b4b862d9d2a3e0fc3bc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##8a86f9ede13c4c9d9b90792908aba860] 时间: 2021-12-24 14:14:15,949 线程ID: 33 日志级别: 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 ##d3b134aef9f34e2aa0d9d1e0be254a78 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 [##dc58c244a3a94214aed449704ae98d9d] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##c8609fe3ece04140a14a918154f2d56d] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:14:16,012 线程ID: 33 日志级别: 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 ##d5f134a2f54140c182a5993d8b3202d8 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 [##dc58c244a3a94214aed449704ae98d9d] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##c8609fe3ece04140a14a918154f2d56d] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:14:16,047 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d5f134a2f54140c182a5993d8b3202d8 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:14:16,048 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5f134a2f54140c182a5993d8b3202d8 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:14:16,051 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d5f134a2f54140c182a5993d8b3202d8 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-12-24 14:14:16,083 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5f134a2f54140c182a5993d8b3202d8 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:14:16,085 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d5f134a2f54140c182a5993d8b3202d8 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:14:16,088 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##2249d4a5d8e14b4b862d9d2a3e0fc3bc(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##46c39bcb8ac742c8a6b2bf6fffcfac72 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:14:16,092 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##2249d4a5d8e14b4b862d9d2a3e0fc3bc 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 ##d3b134aef9f34e2aa0d9d1e0be254a78 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:15:13,351 线程ID: 99 日志级别: 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 [##267cc28d90d8479cb99627216a8cd0ad] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:15:13,686 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5db9dfa8f24b49d7a67416b3ac296c14] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:15:13,687 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##267cc28d90d8479cb99627216a8cd0ad] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5db9dfa8f24b49d7a67416b3ac296c14] 时间: 2021-12-24 14:15:13,689 线程ID: 99 日志级别: 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 ##6496d561678041758824eb40581664bf 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 [##08172cbc55cd4d638fb6c7a653be3935] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##af4eee88734f4501a06702b06fd646c0] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:15:13,750 线程ID: 99 日志级别: 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 ##c619c502c5f84834ad686ce6801ccf45 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 [##08172cbc55cd4d638fb6c7a653be3935] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##af4eee88734f4501a06702b06fd646c0] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:15:13,785 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c619c502c5f84834ad686ce6801ccf45 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:15:13,788 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c619c502c5f84834ad686ce6801ccf45 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:15:13,791 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c619c502c5f84834ad686ce6801ccf45 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-12-24 14:15:13,822 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c619c502c5f84834ad686ce6801ccf45 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:15:13,824 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c619c502c5f84834ad686ce6801ccf45 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:15:13,827 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##267cc28d90d8479cb99627216a8cd0ad(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##3b0e659dce524e41952c6b2fcef15b9b GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:15:13,834 线程ID: 99 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##267cc28d90d8479cb99627216a8cd0ad 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 ##6496d561678041758824eb40581664bf 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:16:15,067 线程ID: 41 日志级别: 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 [##b925b431183b4653ade7b8f359b223af] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:16:15,362 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fccd8c48073a48c782a481be37718a9e] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:16:15,363 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b925b431183b4653ade7b8f359b223af] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fccd8c48073a48c782a481be37718a9e] 时间: 2021-12-24 14:16:15,365 线程ID: 41 日志级别: 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 ##257fadfb85374f9dbec849d910805666 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 [##37a55ea326364f8fa333e6a5d6fc3107] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##8bf52ebba8ff4f7093df18b79cfbad45] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:16:15,418 线程ID: 41 日志级别: 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 ##9879255ec48a4fcc8dfc22509f401ba3 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 [##37a55ea326364f8fa333e6a5d6fc3107] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##8bf52ebba8ff4f7093df18b79cfbad45] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:16:15,449 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9879255ec48a4fcc8dfc22509f401ba3 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:16:15,451 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9879255ec48a4fcc8dfc22509f401ba3 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:16:15,453 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##9879255ec48a4fcc8dfc22509f401ba3 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-12-24 14:16:15,481 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9879255ec48a4fcc8dfc22509f401ba3 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:16:15,483 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9879255ec48a4fcc8dfc22509f401ba3 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:16:15,486 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##b925b431183b4653ade7b8f359b223af(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##3277fd2ef7504802ac1162402548a86a GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:16:15,489 线程ID: 41 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##b925b431183b4653ade7b8f359b223af 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 ##257fadfb85374f9dbec849d910805666 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 14:16:31,981 线程ID: 92 日志级别: 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 [##7789592647c54944b83b0fddf0105824] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 14:16:32,339 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##87febbe329944987848a4ad224ebb8c1] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 14:16:32,340 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##7789592647c54944b83b0fddf0105824] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##87febbe329944987848a4ad224ebb8c1] 时间: 2021-12-24 14:16:32,342 线程ID: 92 日志级别: 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 ##d10050ef5d6444fda4240fd0d710fdab 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 [##f25d0bd473ac43b28399679ac25b4338] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##acb6025fc61f4ffc8e134b7b8d3675d0] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 14:16:32,408 线程ID: 92 日志级别: 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 ##c17dad4d4a5746bd89a27467886cdfb2 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 [##f25d0bd473ac43b28399679ac25b4338] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##acb6025fc61f4ffc8e134b7b8d3675d0] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 14:16:32,445 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c17dad4d4a5746bd89a27467886cdfb2 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 14:16:32,448 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c17dad4d4a5746bd89a27467886cdfb2 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 14:16:32,451 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c17dad4d4a5746bd89a27467886cdfb2 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-12-24 14:16:32,483 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c17dad4d4a5746bd89a27467886cdfb2 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 14:16:32,485 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c17dad4d4a5746bd89a27467886cdfb2 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 14:16:32,488 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##7789592647c54944b83b0fddf0105824(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##8a76d91baafe424ebfe36b2eefb90d5b GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 14:16:32,493 线程ID: 92 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##7789592647c54944b83b0fddf0105824 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 ##d10050ef5d6444fda4240fd0d710fdab 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 15:04:48,006 线程ID: 20 日志级别: 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 [##6828854c1095446290de6bd5afd02af4] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-12-24 15:04:48,438 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2c66644ead1a4983b70c691608f59383] where 2=2 and ISNULL(S1,0)=0 时间: 2021-12-24 15:04:48,441 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##6828854c1095446290de6bd5afd02af4] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2c66644ead1a4983b70c691608f59383] 时间: 2021-12-24 15:04:48,442 线程ID: 20 日志级别: 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 ##631e626d0a1f406c8b9d484c2bb1f5ed 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 [##c169d181441140a2a35408118c56d373] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##3c7a0494c38e4dc2aa2340e478a6bb84] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2021-12-24 15:04:48,513 线程ID: 20 日志级别: 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 ##ac83aff7e7e9436685b750f8e01c68d1 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 [##c169d181441140a2a35408118c56d373] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##3c7a0494c38e4dc2aa2340e478a6bb84] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2021-12-24' 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 时间: 2021-12-24 15:04:48,551 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ac83aff7e7e9436685b750f8e01c68d1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-12-24 15:04:48,553 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac83aff7e7e9436685b750f8e01c68d1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-12-24 15:04:48,556 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ac83aff7e7e9436685b750f8e01c68d1 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-12-24 15:04:48,588 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac83aff7e7e9436685b750f8e01c68d1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-12-24 15:04:48,590 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ac83aff7e7e9436685b750f8e01c68d1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-12-24 15:04:48,593 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##6828854c1095446290de6bd5afd02af4(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##a6aa712c796644b2a38222031cf8bd5d GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2021-12-24 15:04:48,606 线程ID: 20 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], GS.Goods_Name AS [货品名称], A.Goods_No AS [货号], SUM([渠道库存#数量]) AS [渠道库存], SUM(A.[AllDayCheckQuantity]) AS [累销数量], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[1f5bece3-4c8a-4780-96f3-a6bbc983b9dd] FROM ##6828854c1095446290de6bd5afd02af4 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 ##631e626d0a1f406c8b9d484c2bb1f5ed 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, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Goods_Name, A.Goods_No 时间: 2021-12-24 15:09:11,452 线程ID: 15 日志级别: 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.[5d0367c6-e9e8-40b6-99a6-3084c80e38e3] FROM [##e6da314982b7416ba6855b8b5e054c33] ORDER BY Goods_no