时间: 2022-10-14 10:45:14,329 线程ID: 81 日志级别: 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.[3cec2500-ae7a-4526-8990-7f370c0da549] FROM [##722307d7cbea43d4bb59c6372e50b7c5] ORDER BY Goods_no 时间: 2022-10-14 10:47:08,400 线程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 [##c21fdd507731438fa38ad98842d781cb] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 10:47:08,845 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a3fd6c465ab54d5fab51059ce39be92a] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 10:47:08,847 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c21fdd507731438fa38ad98842d781cb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a3fd6c465ab54d5fab51059ce39be92a] 时间: 2022-10-14 10:47:08,922 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##10b64c0aa46e407b90b58b4e60b37af4 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 10:47:08,926 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##10b64c0aa46e407b90b58b4e60b37af4 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 10:47:08,932 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##10b64c0aa46e407b90b58b4e60b37af4 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 10:47:08,968 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##10b64c0aa46e407b90b58b4e60b37af4 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 10:47:08,971 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##10b64c0aa46e407b90b58b4e60b37af4 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 10:47:08,976 线程ID: 83 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c21fdd507731438fa38ad98842d781cb] (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 [##1e580f0790ea4d0eacbcc422aad03c9e] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 10:47:08,984 线程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.[21fe0a22-6ff5-4efe-9ddf-fa5e4e8d0012] FROM ##c21fdd507731438fa38ad98842d781cb 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 时间: 2022-10-14 10:54:22,965 线程ID: 102 日志级别: 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.[89401300-c4aa-4efd-854f-8d7b8a599eaf] FROM [##80069aec68904615a03c529c65a781f2] ORDER BY Goods_no 时间: 2022-10-14 10:54:25,946 线程ID: 83 日志级别: 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.[89401300-c4aa-4efd-854f-8d7b8a599eaf] FROM [##a90f6f2c315f45e889bacf597587cbc7] ORDER BY Goods_no 时间: 2022-10-14 10:55:22,482 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[89401300-c4aa-4efd-854f-8d7b8a599eaf] FROM [##7a0f504cd8ad4f3999763de67dcce733] ORDER BY Goods_no 时间: 2022-10-14 10:56:28,693 线程ID: 65 日志级别: 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 [##b6d969b00bf2461399d5a57cad3a21e9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 10:56:29,153 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9d117242ec0d48deacba86db81ff6eb8] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 10:56:29,154 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b6d969b00bf2461399d5a57cad3a21e9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9d117242ec0d48deacba86db81ff6eb8] 时间: 2022-10-14 10:56:29,210 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fb00fd57c42f4cefacbd84ba994bde65 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 10:56:29,213 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fb00fd57c42f4cefacbd84ba994bde65 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 10:56:29,215 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fb00fd57c42f4cefacbd84ba994bde65 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 10:56:29,249 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fb00fd57c42f4cefacbd84ba994bde65 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 10:56:29,250 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fb00fd57c42f4cefacbd84ba994bde65 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 10:56:29,253 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##b6d969b00bf2461399d5a57cad3a21e9] (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 [##e11ae8575e314758a2401021810be5fc] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 10:56:29,258 线程ID: 65 日志级别: 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.[a85f7129-e779-4acf-9458-b2de735a0afc] FROM ##b6d969b00bf2461399d5a57cad3a21e9 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 时间: 2022-10-14 10:58:00,640 线程ID: 30 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[18c1873b-378f-4ca2-9086-03af0e346985] FROM [##9888c6920f2e4b9196bd31eb9af7e2d7] ORDER BY Goods_no 时间: 2022-10-14 11:22:29,075 线程ID: 27 日志级别: 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 [##db43dc7e533d4a6c902997050459d599] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 11:22:29,678 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1ac3c1a763d64d1ca2b82fe908fbb9ab] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 11:22:29,680 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##db43dc7e533d4a6c902997050459d599] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1ac3c1a763d64d1ca2b82fe908fbb9ab] 时间: 2022-10-14 11:22:29,733 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##680d44a8331b477292820143a9608b44 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 11:22:29,737 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##680d44a8331b477292820143a9608b44 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 11:22:29,741 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##680d44a8331b477292820143a9608b44 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 11:22:29,773 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##680d44a8331b477292820143a9608b44 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 11:22:29,775 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##680d44a8331b477292820143a9608b44 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 11:22:29,778 线程ID: 27 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##db43dc7e533d4a6c902997050459d599] (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 [##3c9c3520f38943fb866a48f7ef7f30e7] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 11:22:29,783 线程ID: 27 日志级别: 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.[b2463bea-116e-472f-be98-43257a44e00f] FROM ##db43dc7e533d4a6c902997050459d599 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 时间: 2022-10-14 12:02:53,392 线程ID: 41 日志级别: 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.[9a7c0368-a120-47c7-9f41-31c872d06b34] FROM [##85f8fab5330b4753a21e6835f6a0b992] ORDER BY Goods_no 时间: 2022-10-14 12:02:55,710 线程ID: 83 日志级别: 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.[9a7c0368-a120-47c7-9f41-31c872d06b34] FROM [##a326ffe9210b45d6b59ba2d2cf80fc1e] ORDER BY Goods_no 时间: 2022-10-14 12:02:57,858 线程ID: 102 日志级别: 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.[9a7c0368-a120-47c7-9f41-31c872d06b34] FROM [##76e69864d2974db3a21c320c6b323c22] ORDER BY Goods_no 时间: 2022-10-14 12:04:03,596 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[9a7c0368-a120-47c7-9f41-31c872d06b34] FROM [##5944070a7dfc4d83a4dae474122176b1] ORDER BY Goods_no 时间: 2022-10-14 12:04:05,878 线程ID: 44 日志级别: 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.[9a7c0368-a120-47c7-9f41-31c872d06b34] FROM [##1f475acfdb664bcfbeb88f9c1f958891] ORDER BY Goods_no 时间: 2022-10-14 12:08:35,638 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 A.Customer_ID, B.Goods_No, C.ColorID, C.Long, CAST(NULL AS VARCHAR(50)) AS Size , 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 NUMERIC(15, 2)) AS [渠道采购收货#金额] , CAST(C.[S1] AS INT) AS [渠道采购退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道收货#金额] , CAST(C.[S1] AS INT) AS [渠道退货#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道调出#金额] , CAST(C.[S1] AS INT) AS [渠道调入#S1], 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(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#正常销售#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售直发#S1], CAST(NULL AS INT) AS [渠道销售#预售直发#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售直发#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#预售自提#S1], CAST(NULL AS INT) AS [渠道销售#预售自提#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#预售自提#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上发货#S1], CAST(NULL AS INT) AS [渠道销售#线上发货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上发货#结算额] , CAST(C.[S1] AS INT) AS [渠道销售#线上退货#S1], CAST(NULL AS INT) AS [渠道销售#线上退货#数量], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#零售额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#生意额], CAST(NULL AS NUMERIC(15, 2)) AS [渠道销售#线上退货#结算额] , CAST(C.[S1] AS INT) AS [累计销售#S1], CAST(NULL AS INT) AS [累计销售#数量],CAST(NULL AS NUMERIC(15, 2)) 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(NULL AS Datetime) AS [第一次到货日期] INTO [##2c61e6233f70436aa6461068ccf3b2c9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 12:08:35,921 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [期初库存#S1], [期初库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1d2aaba85ba54d918254b4a357a92f26] 时间: 2022-10-14 12:08:36,000 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道采购收货#S1], 渠道采购收货#数量, 渠道采购收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##e29736d44018417f961b0df030c765f8] 时间: 2022-10-14 12:08:36,083 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道采购退货#S1], 渠道采购退货#数量, 渠道采购退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##b0c1ced23c9f4307bce846879d714bdf] 时间: 2022-10-14 12:08:36,181 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道收货#S1], 渠道收货#数量, 渠道收货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##64b690e02ad84d46ac44aa09ea0798be] 时间: 2022-10-14 12:08:36,265 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, 第一次到货日期) SELECT Customer_ID, Goods_No, ColorID, Long, 第一次到货日期 FROM [##4cd4743e88c64bc1bf5e70312228daa6] 时间: 2022-10-14 12:08:36,369 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道退货#S1], 渠道退货#数量, 渠道退货#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##e5d8575ae7164e71b392d3e267e24da6] 时间: 2022-10-14 12:08:36,466 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道调出#S1], 渠道调出#数量, 渠道调出#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##5e45c032ff4e4ff0a9465d402e067654] 时间: 2022-10-14 12:08:36,583 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道调入#S1], 渠道调入#数量, 渠道调入#金额) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), Amount FROM [##a54f8e22fb3340fdb83857cf302a8693] 时间: 2022-10-14 12:08:36,680 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道损益#S1], 渠道损益#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f33fc7abd7ba4af8bb4b7ff3c687dff0] 时间: 2022-10-14 12:08:36,801 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#正常销售#S1], [渠道销售#正常销售#数量], [渠道销售#正常销售#生意额], [渠道销售#正常销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##ee4d6278b9f6484c956dce422d772fae] 时间: 2022-10-14 12:08:36,873 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售直发#S1], [渠道销售#预售直发#数量], [渠道销售#预售直发#生意额], [渠道销售#预售直发#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##fb7a9ef7c350472cada1df5cb815c71d] 时间: 2022-10-14 12:08:36,930 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#预售自提#S1], [渠道销售#预售自提#数量], [渠道销售#预售自提#生意额], [渠道销售#预售自提#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##cecf951c50f847e9994d2492ed0d0745] 时间: 2022-10-14 12:08:36,988 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上发货#S1], [渠道销售#线上发货#数量], [渠道销售#线上发货#生意额], [渠道销售#线上发货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##16fbb61ed53b447d8afc982f378f3ee2] 时间: 2022-10-14 12:08:37,036 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [渠道销售#线上退货#S1], [渠道销售#线上退货#数量], [渠道销售#线上退货#生意额], [渠道销售#线上退货#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##df021389a46c423a847ab6a97ecbb0de] 时间: 2022-10-14 12:08:37,124 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [累计销售#S1], [累计销售#数量],[累计销售#生意额], [累计销售#结算额]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)), DiscountAmount, BalanceAmount FROM [##03e3da3c196148b1ac60ef7ea62e53b0] 时间: 2022-10-14 12:08:37,413 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2c61e6233f70436aa6461068ccf3b2c9] (Customer_ID, Goods_No, ColorID, Long, [在途库存#S1], [在途库存#数量]) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##df7ba26920fa4e0ab2930133b1a94f62] 时间: 2022-10-14 12:08:37,429 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##2c61e6233f70436aa6461068ccf3b2c9] SET 期末库存#数量 = ISNULL(期初库存#数量,0) + ISNULL(渠道采购收货#数量,0) - ISNULL(渠道采购退货#数量,0) + ISNULL(渠道收货#数量,0) - ISNULL(渠道退货#数量,0) - ISNULL(渠道调出#数量,0) + ISNULL(渠道调入#数量,0) - ISNULL(渠道损益#数量,0) - ISNULL(渠道销售#正常销售#数量,0) - ISNULL(渠道销售#线上发货#数量,0) - ISNULL(渠道销售#线上退货#数量,0), [期末库存#S1] = ISNULL([期初库存#S1], 0) + ISNULL(渠道采购收货#S1,0) - ISNULL(渠道采购退货#S1,0) + ISNULL(渠道收货#S1,0) - ISNULL(渠道退货#S1,0) - ISNULL(渠道调出#S1,0) + ISNULL(渠道调入#S1,0) - ISNULL(渠道损益#S1,0) - ISNULL(渠道销售#正常销售#S1,0) - ISNULL(渠道销售#线上发货#S1,0) - ISNULL(渠道销售#线上退货#S1,0) 时间: 2022-10-14 12:08:37,433 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE [##2c61e6233f70436aa6461068ccf3b2c9] SET 库存合计#数量 = ISNULL(期末库存#数量,0) + ISNULL(在途库存#数量,0), [库存合计#S1] = ISNULL([期末库存#S1], 0) + ISNULL([在途库存#S1], 0) 时间: 2022-10-14 12:08:37,534 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Customer_ID] AS Customer_ID INTO [##a4f434387f24414db1fdbd659d2b151d] FROM [##2c61e6233f70436aa6461068ccf3b2c9] 时间: 2022-10-14 12:08:37,537 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT [Goods_No] AS Goods_No, [ColorID] AS ColorID INTO [##cf841271a9ef4428976ab18cead7c978] FROM [##2c61e6233f70436aa6461068ccf3b2c9] 时间: 2022-10-14 12:08:37,597 线程ID: 78 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: ;With cteData AS ( SELECT a.TinShop AS Customer_ID, b.Goods_No, MIN(a.Tin_Date) Tin_Date FROM dbo.ShopTin a INNER JOIN dbo.ShopTinGoods b ON A.ShopTinID = B.ShopTinID WHERE EXISTS(SELECT 1 FROM ##2c61e6233f70436aa6461068ccf3b2c9 Z WHERE A.TinShop = Z.Customer_ID AND B.Goods_No = Z.Goods_No) AND a.[Type]= 1 GROUP BY a.TinShop, b.Goods_No ) SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], SD.Tin_Date AS [到店日期], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], DC.ColorGroup AS [颜色组], A.Long AS [内长], SUM([期初库存#S1]) AS [期初库存#S1], SUM([期初库存#数量]) AS [期初库存#数量], SUM([期初库存#数量] * GS.UnitPrice) AS [期初库存#吊牌额], SUM([期初库存#数量] * GDP.DpPriceByRetail) AS [期初库存#渠道吊牌额], SUM([期初库存#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [期初库存#零售额], SUM([渠道采购收货#S1]) AS [渠道采购收货#S1], SUM([渠道采购收货#数量]) AS [渠道采购收货#数量], SUM([渠道采购收货#数量] * GS.UnitPrice) AS [渠道采购收货#吊牌额], SUM([渠道采购收货#数量] * GDP.DpPriceByRetail) AS [渠道采购收货#渠道吊牌额], SUM([渠道采购收货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道采购收货#零售额], SUM([渠道采购收货#金额]) AS [渠道采购收货#金额], SUM([渠道采购退货#S1]) AS [渠道采购退货#S1], SUM([渠道采购退货#数量]) AS [渠道采购退货#数量], SUM([渠道采购退货#数量] * GS.UnitPrice) AS [渠道采购退货#吊牌额], SUM([渠道采购退货#数量] * GDP.DpPriceByRetail) AS [渠道采购退货#渠道吊牌额], SUM([渠道采购退货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道采购退货#零售额], SUM([渠道采购退货#金额]) AS [渠道采购退货#金额], SUM([渠道收货#S1]) AS [渠道收货#S1], SUM([渠道收货#数量]) AS [渠道收货#数量], SUM([渠道收货#数量] * GS.UnitPrice) AS [渠道收货#吊牌额], SUM([渠道收货#数量] * GDP.DpPriceByRetail) AS [渠道收货#渠道吊牌额], SUM([渠道收货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道收货#零售额], SUM([渠道收货#金额]) AS [渠道收货#金额], SUM([渠道退货#S1]) AS [渠道退货#S1], SUM([渠道退货#数量]) AS [渠道退货#数量], SUM([渠道退货#数量] * GS.UnitPrice) AS [渠道退货#吊牌额], SUM([渠道退货#数量] * GDP.DpPriceByRetail) AS [渠道退货#渠道吊牌额], SUM([渠道退货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道退货#零售额], SUM([渠道退货#金额]) AS [渠道退货#金额], SUM([渠道调出#S1]) AS [渠道调出#S1], SUM([渠道调出#数量]) AS [渠道调出#数量], SUM([渠道调出#数量] * GS.UnitPrice) AS [渠道调出#吊牌额], SUM([渠道调出#数量] * GDP.DpPriceByRetail) AS [渠道调出#渠道吊牌额], SUM([渠道调出#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道调出#零售额], SUM([渠道调出#金额]) AS [渠道调出#金额], SUM([渠道调入#S1]) AS [渠道调入#S1], SUM([渠道调入#数量]) AS [渠道调入#数量], SUM([渠道调入#数量] * GS.UnitPrice) AS [渠道调入#吊牌额], SUM([渠道调入#数量] * GDP.DpPriceByRetail) AS [渠道调入#渠道吊牌额], SUM([渠道调入#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道调入#零售额], SUM([渠道调入#金额]) AS [渠道调入#金额], SUM([渠道损益#S1]) AS [渠道损益#S1], SUM([渠道损益#数量]) AS [渠道损益#数量], SUM([渠道损益#数量] * GS.UnitPrice) AS [渠道损益#吊牌额], SUM([渠道损益#数量] * GDP.DpPriceByRetail) AS [渠道损益#渠道吊牌额], SUM([渠道损益#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道损益#零售额], SUM([渠道销售#正常销售#S1]) AS [渠道销售#正常销售#S1], SUM([渠道销售#正常销售#数量]) AS [渠道销售#正常销售#数量], SUM([渠道销售#正常销售#数量] * GS.UnitPrice) AS [渠道销售#正常销售#吊牌额], SUM([渠道销售#正常销售#数量] * GDP.DpPriceByRetail) AS [渠道销售#正常销售#渠道吊牌额], SUM([渠道销售#正常销售#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#正常销售#零售额], SUM([渠道销售#正常销售#生意额]) AS [渠道销售#正常销售#生意额], SUM([渠道销售#正常销售#结算额]) AS [渠道销售#正常销售#结算额], SUM([渠道销售#预售直发#S1]) AS [渠道销售#预售直发#S1], SUM([渠道销售#预售直发#数量]) AS [渠道销售#预售直发#数量], SUM([渠道销售#预售直发#数量] * GS.UnitPrice) AS [渠道销售#预售直发#吊牌额], SUM([渠道销售#预售直发#数量] * GDP.DpPriceByRetail) AS [渠道销售#预售直发#渠道吊牌额], SUM([渠道销售#预售直发#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#预售直发#零售额], SUM([渠道销售#预售直发#生意额]) AS [渠道销售#预售直发#生意额], SUM([渠道销售#预售直发#结算额]) AS [渠道销售#预售直发#结算额], SUM([渠道销售#预售自提#S1]) AS [渠道销售#预售自提#S1], SUM([渠道销售#预售自提#数量]) AS [渠道销售#预售自提#数量], SUM([渠道销售#预售自提#数量] * GS.UnitPrice) AS [渠道销售#预售自提#吊牌额], SUM([渠道销售#预售自提#数量] * GDP.DpPriceByRetail) AS [渠道销售#预售自提#渠道吊牌额], SUM([渠道销售#预售自提#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#预售自提#零售额], SUM([渠道销售#预售自提#生意额]) AS [渠道销售#预售自提#生意额], SUM([渠道销售#预售自提#结算额]) AS [渠道销售#预售自提#结算额], SUM([渠道销售#线上发货#S1]) AS [渠道销售#线上发货#S1], SUM([渠道销售#线上发货#数量]) AS [渠道销售#线上发货#数量], SUM([渠道销售#线上发货#数量] * GS.UnitPrice) AS [渠道销售#线上发货#吊牌额], SUM([渠道销售#线上发货#数量] * GDP.DpPriceByRetail) AS [渠道销售#线上发货#渠道吊牌额], SUM([渠道销售#线上发货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#线上发货#零售额], SUM([渠道销售#线上发货#生意额]) AS [渠道销售#线上发货#生意额], SUM([渠道销售#线上发货#结算额]) AS [渠道销售#线上发货#结算额], SUM([渠道销售#线上退货#S1]) AS [渠道销售#线上退货#S1], SUM([渠道销售#线上退货#数量]) AS [渠道销售#线上退货#数量], SUM([渠道销售#线上退货#数量] * GS.UnitPrice) AS [渠道销售#线上退货#吊牌额], SUM([渠道销售#线上退货#数量] * GDP.DpPriceByRetail) AS [渠道销售#线上退货#渠道吊牌额], SUM([渠道销售#线上退货#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [渠道销售#线上退货#零售额], SUM([渠道销售#线上退货#生意额]) AS [渠道销售#线上退货#生意额], SUM([渠道销售#线上退货#结算额]) AS [渠道销售#线上退货#结算额], SUM([累计销售#S1]) AS [累计销售#S1], SUM([累计销售#数量]) AS [累计销售#数量], SUM([累计销售#数量] * GS.UnitPrice) AS [累计销售#吊牌额], SUM([累计销售#数量] * GDP.DpPriceByRetail) AS [累计销售#渠道吊牌额], SUM([累计销售#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [累计销售#零售额], SUM([累计销售#生意额]) AS [累计销售#生意额], SUM([累计销售#结算额]) AS [累计销售#结算额], SUM([期末库存#S1]) AS [期末库存#S1], SUM([期末库存#数量]) AS [期末库存#数量], SUM([期末库存#数量] * GS.UnitPrice) AS [期末库存#吊牌额], SUM([期末库存#数量] * GDP.DpPriceByRetail) AS [期末库存#渠道吊牌额], SUM([期末库存#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [期末库存#零售额], SUM([在途库存#S1]) AS [在途库存#S1], SUM([在途库存#数量]) AS [在途库存#数量], SUM([在途库存#数量] * GS.UnitPrice) AS [在途库存#吊牌额], SUM([在途库存#数量] * GDP.DpPriceByRetail) AS [在途库存#渠道吊牌额], SUM([在途库存#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [在途库存#零售额], SUM([库存合计#S1]) AS [库存合计#S1], SUM([库存合计#数量]) AS [库存合计#数量], SUM([库存合计#数量] * GS.UnitPrice) AS [库存合计#吊牌额], SUM([库存合计#数量] * GDP.DpPriceByRetail) AS [库存合计#渠道吊牌额], SUM([库存合计#数量] * ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail)) AS [库存合计#零售额], ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail) AS [零售价], convert(varchar,min(第一次到货日期),23) AS [第一次到货日期], GS.UnitPrice AS [吊牌价], GDP.DpPriceByRetail AS [渠道吊牌价], CAST(NULL AS IMAGE) AS [图片] INTO tempdb.dbo.[b27bd012-0bf2-4474-bbe3-3a5f21772b06] FROM [##2c61e6233f70436aa6461068ccf3b2c9] A INNER JOIN Customer CT ON A.Customer_ID = CT.Customer_ID INNER JOIN Goods GS ON A.Goods_No = GS.Goods_No INNER JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID LEFT JOIN cteData SD ON A.Customer_ID = SD.Customer_ID AND A.Goods_No = SD.Goods_No INNER JOIN vGoodsDpPrice GDP ON A.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No LEFT JOIN [##1ff0739d85e74de3a336664a2b7d0e1d] CP ON A.Customer_ID = CP.Customer_ID AND A.Goods_No = CP.Goods_No LEFT JOIN [##1bb63b1d44bf413ba4e1fc9d7a3b878e] CPC ON A.Customer_ID = CPC.Customer_ID AND A.Goods_No = CPC.Goods_No AND A.ColorID = CPC.ColorID GROUP BY A.Customer_ID, CT.Abbrev, SD.Tin_Date, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Long, ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail), GS.UnitPrice, GDP.DpPriceByRetail HAVING (ISNULL(SUM([期初库存#S1]), 0) <> 0) OR (ISNULL(SUM([渠道采购收货#S1]), 0) <> 0) OR SUM([渠道采购收货#金额]) <> 0 OR (ISNULL(SUM([渠道采购退货#S1]), 0) <> 0) OR SUM([渠道采购退货#金额]) <> 0 OR (ISNULL(SUM([渠道收货#S1]), 0) <> 0) OR SUM([渠道收货#金额]) <> 0 OR (ISNULL(SUM([渠道退货#S1]), 0) <> 0) OR SUM([渠道退货#金额]) <> 0 OR (ISNULL(SUM([渠道调出#S1]), 0) <> 0) OR SUM([渠道调出#金额]) <> 0 OR (ISNULL(SUM([渠道调入#S1]), 0) <> 0) OR SUM([渠道调入#金额]) <> 0 OR (ISNULL(SUM([渠道损益#S1]), 0) <> 0) OR (ISNULL(SUM([渠道销售#正常销售#S1]), 0) <> 0) OR SUM([渠道销售#正常销售#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#预售直发#S1]), 0) <> 0) OR SUM([渠道销售#预售直发#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#预售自提#S1]), 0) <> 0) OR SUM([渠道销售#预售自提#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#线上发货#S1]), 0) <> 0) OR SUM([渠道销售#线上发货#生意额]) <> 0 OR (ISNULL(SUM([渠道销售#线上退货#S1]), 0) <> 0) OR SUM([渠道销售#线上退货#生意额]) <> 0 OR (ISNULL(SUM([累计销售#S1]), 0) <> 0) OR SUM([累计销售#生意额]) <> 0 OR (ISNULL(SUM([在途库存#S1]), 0) <> 0) ORDER BY A.Customer_ID, CT.Abbrev, SD.Tin_Date, A.Goods_No, GS.Goods_Name, A.ColorID, VGC.Color, DC.ColorGroup, A.Long, ISNULL(ISNULL(CPC.Price,CP.Price), GDP.DpPriceByRetail), GS.UnitPrice, GDP.DpPriceByRetail 时间: 2022-10-14 16:44:22,897 线程ID: 48 日志级别: 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 [##fd6dd55f8658400e97bf4a5176dcf245] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 16:44:23,564 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0c3e0fda7b884ae89b72b40735f7abf9] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 16:44:23,568 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fd6dd55f8658400e97bf4a5176dcf245] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0c3e0fda7b884ae89b72b40735f7abf9] 时间: 2022-10-14 16:44:23,662 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##726be9b235ec4902a5f91a731d9b4d3b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 16:44:23,677 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##726be9b235ec4902a5f91a731d9b4d3b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 16:44:23,685 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##726be9b235ec4902a5f91a731d9b4d3b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 16:44:23,744 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##726be9b235ec4902a5f91a731d9b4d3b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 16:44:23,746 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##726be9b235ec4902a5f91a731d9b4d3b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 16:44:23,750 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##fd6dd55f8658400e97bf4a5176dcf245] (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 [##7629f85b7111422a825f49ddfb47547c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 16:44:23,783 线程ID: 48 日志级别: 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.[1039aa69-f4c3-41aa-921e-858fe4af7f63] FROM ##fd6dd55f8658400e97bf4a5176dcf245 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 时间: 2022-10-14 17:45:49,677 线程ID: 37 日志级别: 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.[d29e8e07-c1d0-44c3-bf78-26bed1f4ae53] FROM [##b7c5dde37ac8434a9464114dd6a9317a] ORDER BY Goods_no 时间: 2022-10-14 17:45:52,160 线程ID: 37 日志级别: 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.[d29e8e07-c1d0-44c3-bf78-26bed1f4ae53] FROM [##fc7f1ad845774f0880070f65806d87af] ORDER BY Goods_no 时间: 2022-10-14 17:45:56,975 线程ID: 37 日志级别: 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.[d29e8e07-c1d0-44c3-bf78-26bed1f4ae53] FROM [##e9c8cf020e884128a84d3c64cf41da86] ORDER BY Goods_no 时间: 2022-10-14 17:46:27,677 线程ID: 49 日志级别: 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.[58fc7351-c1e0-40f4-81ef-43b5ef21ab1f] FROM [##6c1f12e2fdf24e2d9adbb33027080265] ORDER BY Goods_no 时间: 2022-10-14 17:46:36,301 线程ID: 49 日志级别: 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.[58fc7351-c1e0-40f4-81ef-43b5ef21ab1f] FROM [##ba458aac63f348ae8ad3d86cc36c2631] ORDER BY Goods_no 时间: 2022-10-14 17:46:40,455 线程ID: 37 日志级别: 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.[58fc7351-c1e0-40f4-81ef-43b5ef21ab1f] FROM [##b3bab959247a4c5794a31fe9398eb980] ORDER BY Goods_no 时间: 2022-10-14 17:46:51,591 线程ID: 49 日志级别: 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 [##3ceddf99dd6c4060baa32dccfb6b8e82] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 17:46:51,978 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##a07080b6fc7946c8a0597514c4ec91f4] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 17:46:51,980 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3ceddf99dd6c4060baa32dccfb6b8e82] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##a07080b6fc7946c8a0597514c4ec91f4] 时间: 2022-10-14 17:46:52,033 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8ff1ceba390b4b8382613e1682be73f1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 17:46:52,035 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8ff1ceba390b4b8382613e1682be73f1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 17:46:52,039 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##8ff1ceba390b4b8382613e1682be73f1 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 17:46:52,069 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8ff1ceba390b4b8382613e1682be73f1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 17:46:52,071 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##8ff1ceba390b4b8382613e1682be73f1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 17:46:52,074 线程ID: 49 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##3ceddf99dd6c4060baa32dccfb6b8e82] (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 [##b77e2da16e244e9888a1fafcaee15f56] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 17:46:52,081 线程ID: 49 日志级别: 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.[1039aa69-f4c3-41aa-921e-858fe4af7f63] FROM ##3ceddf99dd6c4060baa32dccfb6b8e82 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 时间: 2022-10-14 17:47:24,877 线程ID: 37 日志级别: 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 [##ea1823e4bec24737b93d4cc0d38b2917] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 17:47:25,267 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##103da5e323544854a7830f0373e6b59b] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 17:47:25,270 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ea1823e4bec24737b93d4cc0d38b2917] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##103da5e323544854a7830f0373e6b59b] 时间: 2022-10-14 17:47:25,332 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fa7607b0d61a4b948e64d18b82106c35 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 17:47:25,335 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fa7607b0d61a4b948e64d18b82106c35 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 17:47:25,339 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##fa7607b0d61a4b948e64d18b82106c35 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 17:47:25,372 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fa7607b0d61a4b948e64d18b82106c35 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 17:47:25,374 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##fa7607b0d61a4b948e64d18b82106c35 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 17:47:25,378 线程ID: 37 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ea1823e4bec24737b93d4cc0d38b2917] (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 [##a926d2b35ce84e6f8e94a20846917f8c] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 17:47:25,388 线程ID: 37 日志级别: 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.[1039aa69-f4c3-41aa-921e-858fe4af7f63] FROM ##ea1823e4bec24737b93d4cc0d38b2917 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 时间: 2022-10-14 17:48:26,520 线程ID: 46 日志级别: 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 [##dae85576ebd84f0cbc943f98d2e2edaf] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 17:48:26,898 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##bd80bab9d0ef49818d9ec1255ef27f80] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 17:48:26,901 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dae85576ebd84f0cbc943f98d2e2edaf] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##bd80bab9d0ef49818d9ec1255ef27f80] 时间: 2022-10-14 17:48:26,958 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a8163569aba4479e8777a9e4ffaada53 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 17:48:26,961 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8163569aba4479e8777a9e4ffaada53 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 17:48:26,965 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a8163569aba4479e8777a9e4ffaada53 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 17:48:26,998 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8163569aba4479e8777a9e4ffaada53 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 17:48:27,001 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a8163569aba4479e8777a9e4ffaada53 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 17:48:27,006 线程ID: 46 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dae85576ebd84f0cbc943f98d2e2edaf] (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 [##f4522fb329c6429da2a3e1a4aa9b6b25] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 17:48:27,012 线程ID: 46 日志级别: 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.[1039aa69-f4c3-41aa-921e-858fe4af7f63] FROM ##dae85576ebd84f0cbc943f98d2e2edaf 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 时间: 2022-10-14 18:15:57,827 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount] , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1] , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1] , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1] , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1] , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1] , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1] INTO [##5d979286e0c54d1781c7c0ea06eea102] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:15:58,203 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##1505bb11b2eb41b983907145eb3cb8dc] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:15:58,205 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5d979286e0c54d1781c7c0ea06eea102] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1505bb11b2eb41b983907145eb3cb8dc] 时间: 2022-10-14 18:15:58,256 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##619bd7881780499f8c2447993ee9661b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:15:58,258 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##619bd7881780499f8c2447993ee9661b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:15:58,260 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##619bd7881780499f8c2447993ee9661b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:15:58,296 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##619bd7881780499f8c2447993ee9661b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:15:58,299 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##619bd7881780499f8c2447993ee9661b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:15:58,303 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5d979286e0c54d1781c7c0ea06eea102] (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 [##98d404e5de5b4e119f897f6cb2a84ef5] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 18:15:58,311 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##b3e8015e0cbb4bc599b9934ede424ac5 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 [##8ed31b6698d14ac396d5cfa79768298c] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##affcd303d24642ea8112d6832c6da1a7] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >='2022/9/14' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:15:58,338 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b3e8015e0cbb4bc599b9934ede424ac5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:15:58,340 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b3e8015e0cbb4bc599b9934ede424ac5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:15:58,342 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b3e8015e0cbb4bc599b9934ede424ac5 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:15:58,380 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b3e8015e0cbb4bc599b9934ede424ac5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:15:58,382 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b3e8015e0cbb4bc599b9934ede424ac5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:15:58,386 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5d979286e0c54d1781c7c0ea06eea102(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e0071e38f0ed4bedb3492eea8a048d8c WHERE CheckDate BETWEEN '2022/10/8' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##5d979286e0c54d1781c7c0ea06eea102(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e0071e38f0ed4bedb3492eea8a048d8c WHERE CheckDate BETWEEN '2022/9/30' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##5d979286e0c54d1781c7c0ea06eea102(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##e0071e38f0ed4bedb3492eea8a048d8c WHERE CheckDate BETWEEN '2022/9/15' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:15:58,586 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fcd386280abe495c9de78cf55ebdd65a] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:15:58,587 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5d979286e0c54d1781c7c0ea06eea102] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fcd386280abe495c9de78cf55ebdd65a] 时间: 2022-10-14 18:15:58,589 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MIN(a.Tin_Date) AS MinShopTinDate , MAX(a.Tin_Date) AS MaxShopTinDate INTO ##89756e5a535647eb8a4f3b953170a80d 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 [##8ed31b6698d14ac396d5cfa79768298c] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##affcd303d24642ea8112d6832c6da1a7] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:15:58,664 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID PreSaleID, B.SaleTypeID, B.Status, A.PaymentWay1, Cast(NULL AS Varchar(50)) CheckSaleType , SUM(C.[S1]) AS [S1] , SUM(ISNULL(C.[S1], 0)) AS Quantity , SUM(ISNULL(B.DiscountPrice*C.[S1], 0)) AS Amount INTO ##2def9b95acc346e792c8d04eacbe79a7 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 [##8ed31b6698d14ac396d5cfa79768298c] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##affcd303d24642ea8112d6832c6da1a7] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:15:58,710 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2def9b95acc346e792c8d04eacbe79a7 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:15:58,712 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2def9b95acc346e792c8d04eacbe79a7 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:15:58,714 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2def9b95acc346e792c8d04eacbe79a7 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:15:58,745 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2def9b95acc346e792c8d04eacbe79a7 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:15:58,747 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2def9b95acc346e792c8d04eacbe79a7 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:15:58,749 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##5d979286e0c54d1781c7c0ea06eea102(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##92d7355b8d9d4380bd0aba1e8c046053 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:15:58,754 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存#数量], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道在途#数量]) AS [渠道在途#数量], CAST(NULL AS IMAGE) AS [图片], SUM(A.[30DayCheckQuantity]) AS [月销售数量] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##5d979286e0c54d1781c7c0ea06eea102 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 ##89756e5a535647eb8a4f3b953170a80d T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2022-10-14 18:16:12,147 线程ID: 26 日志级别: 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 [##cbb728c9865d442abeb5ab7e6ee35a7d] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:16:12,509 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##4586c24ff0ba4a3093fae8538c7d8de0] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:16:12,511 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbb728c9865d442abeb5ab7e6ee35a7d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##4586c24ff0ba4a3093fae8538c7d8de0] 时间: 2022-10-14 18:16:12,596 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b2dff15c35f643cdb46bb1d9cd85c1f5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:12,599 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b2dff15c35f643cdb46bb1d9cd85c1f5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:12,601 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b2dff15c35f643cdb46bb1d9cd85c1f5 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:12,631 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b2dff15c35f643cdb46bb1d9cd85c1f5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:12,633 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b2dff15c35f643cdb46bb1d9cd85c1f5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:12,639 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbb728c9865d442abeb5ab7e6ee35a7d] (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 [##6dbd92c2c1bc415aa4eed442b697faac] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 18:16:12,643 线程ID: 26 日志级别: 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 ##e6045b00ceba4d38a90d486212b1e774 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 [##849ec5d071bd4681b63bb5cf2e6e974a] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##4edab19c3b974e57ba2729f739b7362f] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >='2022/9/14' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:16:12,669 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e6045b00ceba4d38a90d486212b1e774 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:12,671 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e6045b00ceba4d38a90d486212b1e774 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:12,673 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e6045b00ceba4d38a90d486212b1e774 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:12,708 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e6045b00ceba4d38a90d486212b1e774 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:12,710 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e6045b00ceba4d38a90d486212b1e774 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:12,713 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##cbb728c9865d442abeb5ab7e6ee35a7d(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##ef113a61b99644da810f43bb77738065 WHERE CheckDate BETWEEN '2022/10/8' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##cbb728c9865d442abeb5ab7e6ee35a7d(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##ef113a61b99644da810f43bb77738065 WHERE CheckDate BETWEEN '2022/9/30' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##cbb728c9865d442abeb5ab7e6ee35a7d(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##ef113a61b99644da810f43bb77738065 WHERE CheckDate BETWEEN '2022/9/15' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:16:12,914 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3310ac12654749aca845e53381483e9c] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:16:12,915 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##cbb728c9865d442abeb5ab7e6ee35a7d] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3310ac12654749aca845e53381483e9c] 时间: 2022-10-14 18:16:12,917 线程ID: 26 日志级别: 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 ##cc29fff122b442c2a87df6166ffaf4e8 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 [##849ec5d071bd4681b63bb5cf2e6e974a] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##4edab19c3b974e57ba2729f739b7362f] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:13,008 线程ID: 26 日志级别: 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 ##3d651f7d7de84dc4b2c723bd41884531 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 [##849ec5d071bd4681b63bb5cf2e6e974a] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##4edab19c3b974e57ba2729f739b7362f] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:16:13,052 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3d651f7d7de84dc4b2c723bd41884531 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:13,056 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3d651f7d7de84dc4b2c723bd41884531 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:13,058 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##3d651f7d7de84dc4b2c723bd41884531 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:13,090 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3d651f7d7de84dc4b2c723bd41884531 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:13,092 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##3d651f7d7de84dc4b2c723bd41884531 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:13,097 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##cbb728c9865d442abeb5ab7e6ee35a7d(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##5a32831e60f84f06b1312bafbc8b58a7 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:16:13,103 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存#数量], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道在途#数量]) AS [渠道在途#数量], CAST(NULL AS IMAGE) AS [图片], SUM(A.[30DayCheckQuantity]) AS [月销售数量] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##cbb728c9865d442abeb5ab7e6ee35a7d 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 ##cc29fff122b442c2a87df6166ffaf4e8 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name 时间: 2022-10-14 18:16:42,511 线程ID: 38 日志级别: 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 [##0d8ee780358c4cf8b803eeb89b8e5f3c] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:16:42,894 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c446968a05984df0990c79ba3afee6bf] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:16:42,895 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0d8ee780358c4cf8b803eeb89b8e5f3c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c446968a05984df0990c79ba3afee6bf] 时间: 2022-10-14 18:16:42,971 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b800538d6e854cb2a848385d5735fdd9 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:42,974 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b800538d6e854cb2a848385d5735fdd9 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:42,976 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b800538d6e854cb2a848385d5735fdd9 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:43,006 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b800538d6e854cb2a848385d5735fdd9 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:43,008 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b800538d6e854cb2a848385d5735fdd9 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:43,013 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0d8ee780358c4cf8b803eeb89b8e5f3c] (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 [##e4c1c808181348db835b064f72fac01d] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 18:16:43,016 线程ID: 38 日志级别: 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 ##c2b23b0893df4356be4eb543916927a1 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 [##6c3cb83acdf149fb83e455fb56f1441c] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##5c69df952bde4df9a3b92139ba2173de] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >='2022/9/14' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:16:43,041 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c2b23b0893df4356be4eb543916927a1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:43,043 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c2b23b0893df4356be4eb543916927a1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:43,046 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##c2b23b0893df4356be4eb543916927a1 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:43,077 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c2b23b0893df4356be4eb543916927a1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:43,079 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##c2b23b0893df4356be4eb543916927a1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:43,083 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0d8ee780358c4cf8b803eeb89b8e5f3c(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##93856af3a9ab4f918af43f329719ff12 WHERE CheckDate BETWEEN '2022/10/8' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##0d8ee780358c4cf8b803eeb89b8e5f3c(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##93856af3a9ab4f918af43f329719ff12 WHERE CheckDate BETWEEN '2022/9/30' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##0d8ee780358c4cf8b803eeb89b8e5f3c(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##93856af3a9ab4f918af43f329719ff12 WHERE CheckDate BETWEEN '2022/9/15' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:16:43,295 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##2cdc5bc443034f77842d431d37bc40db] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:16:43,297 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0d8ee780358c4cf8b803eeb89b8e5f3c] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##2cdc5bc443034f77842d431d37bc40db] 时间: 2022-10-14 18:16:43,299 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_id, B.Goods_No, C.ColorID, C.Long , MIN(a.Delivery_Date) as MinDeliveryDate , MAX(a.Delivery_Date) as MaxDeliveryDate INTO ##fb98dce0a13345fe802eb616dab788b8 FROM Delivery a INNER JOIN DeliveryGoods b on A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID WHERE A.Type IN (1,2) AND A.Posted=1 AND EXISTS (SELECT 1 FROM [##6c3cb83acdf149fb83e455fb56f1441c] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##5c69df952bde4df9a3b92139ba2173de] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_id,B.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:43,445 线程ID: 38 日志级别: 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 ##0f98fb6d242c49bcbd8eda68f44cd3dd 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 [##6c3cb83acdf149fb83e455fb56f1441c] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##5c69df952bde4df9a3b92139ba2173de] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:43,512 线程ID: 38 日志级别: 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 ##f4db661f57af4fffbb5a24f69630d00e 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 [##6c3cb83acdf149fb83e455fb56f1441c] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##5c69df952bde4df9a3b92139ba2173de] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:16:43,543 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f4db661f57af4fffbb5a24f69630d00e a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:43,546 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4db661f57af4fffbb5a24f69630d00e SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:43,550 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##f4db661f57af4fffbb5a24f69630d00e a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:43,583 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4db661f57af4fffbb5a24f69630d00e SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:43,584 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##f4db661f57af4fffbb5a24f69630d00e SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:43,588 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0d8ee780358c4cf8b803eeb89b8e5f3c(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##4fce249d28c146c3a57c74a06eb7b04c GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:16:43,594 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, max(A.DeliveryID) as DeliveryID INTO ##58c33236765d46ceb081cc85fe07f6db FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##fb98dce0a13345fe802eb616dab788b8 T ON T.Customer_id = A.Customer_id AND T.Goods_No=b.Goods_No AND T.MaxDeliveryDate = A.Delivery_Date WHERE A.Type in (1,2) AND A.Posted=1 GROUP BY A.Customer_ID,b.Goods_No 时间: 2022-10-14 18:16:43,612 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, A.Mode, SUM(b.Quantity) as Quantity INTO ##4c8f053b24684415ab075b2a3e74179f FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##58c33236765d46ceb081cc85fe07f6db T ON T.Customer_ID = A.Customer_ID AND T.Goods_No=b.Goods_No AND T.DeliveryID = A.DeliveryID WHERE 1=1 AND EXISTS (SELECT 1 FROM [##6c3cb83acdf149fb83e455fb56f1441c] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##5c69df952bde4df9a3b92139ba2173de] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_ID, B.Goods_No, A.Mode 时间: 2022-10-14 18:16:43,746 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.Tin_Date) AS MaxLoadInDate INTO ##d3c8a5dcd95c4d5bb674c957c9c160dc FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND Type = 2 AND EXISTS (SELECT 1 FROM [##6c3cb83acdf149fb83e455fb56f1441c] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##5c69df952bde4df9a3b92139ba2173de] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:43,832 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.CheckDate) AS MaxCheckDate INTO ##60dd59f7f38f4e09bdc1a55bbeb80a67 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##6c3cb83acdf149fb83e455fb56f1441c] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##5c69df952bde4df9a3b92139ba2173de] WHERE Goods_No = B.Goods_No) GROUP BY a.Customer_ID, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:43,912 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存#数量], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道在途#数量]) AS [渠道在途#数量], CAST(NULL AS IMAGE) AS [图片], SUM(A.[30DayCheckQuantity]) AS [月销售数量], CONVERT(VARCHAR(10), MIN(T5.MinDeliveryDate), 120) AS [最早发货日期], CONVERT(VARCHAR(10), MAX(T5.MaxDeliveryDate), 120) AS [最后发货日期], CONVERT(VARCHAR(10), MIN(T9.MinShopTinDate), 120) AS [最早收货日期], CONVERT(VARCHAR(10), MIN(T9.MaxShopTinDate), 120) AS [最后收货日期], T6.Mode AS [最后发货方式], MAX(T6.Quantity) AS [最后发货数量], MAX(T7.MaxLoadInDate) AS [最后调入日期], MAX(T8.MaxCheckDate) AS [最后销售日期] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##0d8ee780358c4cf8b803eeb89b8e5f3c 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 ##fb98dce0a13345fe802eb616dab788b8 T5 ON A.Goods_No = T5.Goods_No AND A.Customer_ID = T5.Customer_ID AND T5.ColorID=A.ColorID AND T5.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##4c8f053b24684415ab075b2a3e74179f T6 ON A.Goods_No = T6.Goods_No AND A.Customer_ID = T6.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##0f98fb6d242c49bcbd8eda68f44cd3dd T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##d3c8a5dcd95c4d5bb674c957c9c160dc T7 ON A.Goods_No = T7.Goods_No AND A.Customer_ID = T7.Customer_ID AND T7.ColorID=A.ColorID AND T7.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##60dd59f7f38f4e09bdc1a55bbeb80a67 T8 ON A.Goods_No = T8.Goods_No AND A.Customer_ID = T8.Customer_ID AND T8.ColorID=A.ColorID AND T8.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, T6.Mode ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, T6.Mode 时间: 2022-10-14 18:16:55,309 线程ID: 38 日志级别: 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 [##0ef88ce29d8d4d6d898c4f1153705725] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:16:55,769 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##e88ba2c971934d48bd23bf7ed1ce20f7] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:16:55,774 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ef88ce29d8d4d6d898c4f1153705725] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e88ba2c971934d48bd23bf7ed1ce20f7] 时间: 2022-10-14 18:16:55,868 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2172cbc3266c4320aefa38eacd801784 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:55,871 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2172cbc3266c4320aefa38eacd801784 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:55,875 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##2172cbc3266c4320aefa38eacd801784 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:55,917 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2172cbc3266c4320aefa38eacd801784 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:55,919 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2172cbc3266c4320aefa38eacd801784 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:55,925 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ef88ce29d8d4d6d898c4f1153705725] (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 [##b30d916929fa495f8d63d0c84e67d30b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 18:16:55,930 线程ID: 38 日志级别: 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 ##5bd44abba85d4c75b0045ddd10192423 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 [##a336623117944b5f8099b0413d670688] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##fe2aff84a02c4afe9391d97a4c7076bb] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >='2022/9/14' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:16:55,957 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5bd44abba85d4c75b0045ddd10192423 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:55,960 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5bd44abba85d4c75b0045ddd10192423 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:55,964 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##5bd44abba85d4c75b0045ddd10192423 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:56,004 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5bd44abba85d4c75b0045ddd10192423 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:56,006 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5bd44abba85d4c75b0045ddd10192423 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:56,010 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0ef88ce29d8d4d6d898c4f1153705725(Customer_ID, Goods_No, ColorID, Long, [7DayCheckQuantity], [7DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##f160ef01a75d4949bbc80ec44f677b74 WHERE CheckDate BETWEEN '2022/10/8' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##0ef88ce29d8d4d6d898c4f1153705725(Customer_ID, Goods_No, ColorID, Long, [15DayCheckQuantity], [15DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##f160ef01a75d4949bbc80ec44f677b74 WHERE CheckDate BETWEEN '2022/9/30' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long INSERT INTO ##0ef88ce29d8d4d6d898c4f1153705725(Customer_ID, Goods_No, ColorID, Long, [30DayCheckQuantity], [30DayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##f160ef01a75d4949bbc80ec44f677b74 WHERE CheckDate BETWEEN '2022/9/15' AND '2022-10-14 23:59:59' GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:16:56,296 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##721368a4a5e84b7385c85f757609359f] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:16:56,298 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##0ef88ce29d8d4d6d898c4f1153705725] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##721368a4a5e84b7385c85f757609359f] 时间: 2022-10-14 18:16:56,299 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_id, B.Goods_No, C.ColorID, C.Long , MIN(a.Delivery_Date) as MinDeliveryDate , MAX(a.Delivery_Date) as MaxDeliveryDate INTO ##be59212662264543bc12b504aa0b22c2 FROM Delivery a INNER JOIN DeliveryGoods b on A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID WHERE A.Type IN (1,2) AND A.Posted=1 AND EXISTS (SELECT 1 FROM [##a336623117944b5f8099b0413d670688] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##fe2aff84a02c4afe9391d97a4c7076bb] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_id,B.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:56,376 线程ID: 38 日志级别: 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 ##fad5ce2ac6204478acb7f857d4e67203 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 [##a336623117944b5f8099b0413d670688] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##fe2aff84a02c4afe9391d97a4c7076bb] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:56,448 线程ID: 38 日志级别: 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 ##b1e3acfac2954a0a875881a00ecf30e0 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 [##a336623117944b5f8099b0413d670688] CT ON A.Customer_ID = CT.Customer_ID INNER JOIN [##fe2aff84a02c4afe9391d97a4c7076bb] GS ON B.Goods_No = GS.Goods_No WHERE A.Posted=1 AND CheckDate >= '1990-01-01' AND CheckDate <='2022-10-14' GROUP BY A.Customer_ID, A.CheckDate, B.Goods_No, B.DiscountPrice, C.ColorID, C.Long , A.RetailOrderID, B.RetailOrderID, B.SaleTypeID, B.Status, A.PaymentWay1 时间: 2022-10-14 18:16:56,492 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b1e3acfac2954a0a875881a00ecf30e0 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:16:56,497 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b1e3acfac2954a0a875881a00ecf30e0 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:16:56,500 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##b1e3acfac2954a0a875881a00ecf30e0 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:16:56,536 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b1e3acfac2954a0a875881a00ecf30e0 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:16:56,540 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##b1e3acfac2954a0a875881a00ecf30e0 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:16:56,544 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO ##0ef88ce29d8d4d6d898c4f1153705725(Customer_ID, Goods_No, ColorID, Long, [AllDayCheckQuantity], [AllDayCheckAmount]) SELECT Customer_ID, Goods_No, ColorID, Long, SUM(Quantity), SUM(Amount) FROM ##8d9a2010a4a84a1c8d151660fea92f37 GROUP BY Customer_ID, Goods_No, ColorID, Long 时间: 2022-10-14 18:16:56,551 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, max(A.DeliveryID) as DeliveryID INTO ##3c398f1f1e8a4d389966b24a30288532 FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##be59212662264543bc12b504aa0b22c2 T ON T.Customer_id = A.Customer_id AND T.Goods_No=b.Goods_No AND T.MaxDeliveryDate = A.Delivery_Date WHERE A.Type in (1,2) AND A.Posted=1 GROUP BY A.Customer_ID,b.Goods_No 时间: 2022-10-14 18:16:56,574 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, A.Mode, SUM(b.Quantity) as Quantity INTO ##1136da06cac14094b3631a8d31add973 FROM Delivery A INNER JOIN DeliveryGoods B ON A.DeliveryID = B.DeliveryID INNER JOIN DeliveryDetail C ON B.DeliveryGoodsID = C.DeliveryGoodsID INNER JOIN ##3c398f1f1e8a4d389966b24a30288532 T ON T.Customer_ID = A.Customer_ID AND T.Goods_No=b.Goods_No AND T.DeliveryID = A.DeliveryID WHERE 1=1 AND EXISTS (SELECT 1 FROM [##a336623117944b5f8099b0413d670688] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##fe2aff84a02c4afe9391d97a4c7076bb] WHERE Goods_No = B.Goods_No) GROUP BY A.Customer_ID, B.Goods_No, A.Mode 时间: 2022-10-14 18:16:56,711 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.TinShop as Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.Tin_Date) AS MaxLoadInDate INTO ##a6a2472426ed49e2a5bd2616bcaf0001 FROM ShopTin A INNER JOIN ShopTinGoods b on A.ShopTinID = B.ShopTinID INNER JOIN ShopTinDetail C ON B.ShopTinGoodsID = C.ShopTinGoodsID WHERE A.Posted=1 AND Type = 2 AND EXISTS (SELECT 1 FROM [##a336623117944b5f8099b0413d670688] WHERE Customer_ID = A.TinShop) AND EXISTS (SELECT 1 FROM [##fe2aff84a02c4afe9391d97a4c7076bb] WHERE Goods_No = B.Goods_No) GROUP BY a.TinShop, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:56,795 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT A.Customer_ID, B.Goods_No, C.ColorID, C.Long , MAX(a.CheckDate) AS MaxCheckDate INTO ##121fad851fbd414bace701dfa65e4711 FROM [vn_Check] A INNER JOIN vn_CheckGoods B ON A.CheckID = B.CheckID INNER JOIN vn_CheckDetail C ON B.CheckGoodsID = C.CheckGoodsID WHERE A.Posted=1 AND EXISTS (SELECT 1 FROM [##a336623117944b5f8099b0413d670688] WHERE Customer_ID = A.Customer_ID) AND EXISTS (SELECT 1 FROM [##fe2aff84a02c4afe9391d97a4c7076bb] WHERE Goods_No = B.Goods_No) GROUP BY a.Customer_ID, b.Goods_No, C.ColorID, C.Long 时间: 2022-10-14 18:16:56,883 线程ID: 38 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM(A.[AllDayCheckQuantity]) AS [累销数量], SUM([渠道库存#数量]) AS [渠道库存#数量], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], SUM([渠道在途#数量]) AS [渠道在途#数量], CAST(NULL AS IMAGE) AS [图片], SUM(A.[30DayCheckQuantity]) AS [月销售数量], CONVERT(VARCHAR(10), MIN(T5.MinDeliveryDate), 120) AS [最早发货日期], CONVERT(VARCHAR(10), MAX(T5.MaxDeliveryDate), 120) AS [最后发货日期], CONVERT(VARCHAR(10), MIN(T9.MinShopTinDate), 120) AS [最早收货日期], CONVERT(VARCHAR(10), MIN(T9.MaxShopTinDate), 120) AS [最后收货日期], T6.Mode AS [最后发货方式], MAX(T6.Quantity) AS [最后发货数量], MAX(T7.MaxLoadInDate) AS [最后调入日期], MAX(T8.MaxCheckDate) AS [最后销售日期] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##0ef88ce29d8d4d6d898c4f1153705725 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 ##be59212662264543bc12b504aa0b22c2 T5 ON A.Goods_No = T5.Goods_No AND A.Customer_ID = T5.Customer_ID AND T5.ColorID=A.ColorID AND T5.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##1136da06cac14094b3631a8d31add973 T6 ON A.Goods_No = T6.Goods_No AND A.Customer_ID = T6.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##fad5ce2ac6204478acb7f857d4e67203 T9 ON A.Goods_No = T9.Goods_No AND A.Customer_ID = T9.Customer_ID AND T9.ColorID=A.ColorID AND T9.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##a6a2472426ed49e2a5bd2616bcaf0001 T7 ON A.Goods_No = T7.Goods_No AND A.Customer_ID = T7.Customer_ID AND T7.ColorID=A.ColorID AND T7.Long=A.Long AND ISNULL(A.ItemType,0) = 0 LEFT JOIN ##121fad851fbd414bace701dfa65e4711 T8 ON A.Goods_No = T8.Goods_No AND A.Customer_ID = T8.Customer_ID AND T8.ColorID=A.ColorID AND T8.Long=A.Long AND ISNULL(A.ItemType,0) = 0 GROUP BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, T6.Mode ORDER BY CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, T6.Mode 时间: 2022-10-14 18:19:25,602 线程ID: 54 日志级别: 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 [##ff43722624914df38be26f9a0f0d5e51] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:19:26,034 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##0308e37642c144989f07d6dee8313573] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:19:26,036 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff43722624914df38be26f9a0f0d5e51] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##0308e37642c144989f07d6dee8313573] 时间: 2022-10-14 18:19:26,359 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##c8dbd6f53de544259e37ed0fa1cda315] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:19:26,360 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##ff43722624914df38be26f9a0f0d5e51] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##c8dbd6f53de544259e37ed0fa1cda315] 时间: 2022-10-14 18:19:26,362 线程ID: 54 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##ff43722624914df38be26f9a0f0d5e51 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.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2022-10-14 18:19:30,245 线程ID: 53 日志级别: 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 [##abe901321cf2443d973d46c36f171ef8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:19:30,685 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##fe360a0a152441388417d24e5da9741f] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:19:30,687 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##abe901321cf2443d973d46c36f171ef8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##fe360a0a152441388417d24e5da9741f] 时间: 2022-10-14 18:19:30,999 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ca6accbb38c8436ebad441d852db56bb] where 2=2 and ISNULL(S1,0)=0 时间: 2022-10-14 18:19:31,001 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##abe901321cf2443d973d46c36f171ef8] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ca6accbb38c8436ebad441d852db56bb] 时间: 2022-10-14 18:19:31,004 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##abe901321cf2443d973d46c36f171ef8 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.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2022-10-14 18:19:48,867 线程ID: 26 日志级别: 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 [##f6872110fb444a1187b5274d4d16c15f] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:19:49,319 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f6872110fb444a1187b5274d4d16c15f] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##e43aea0662694aef9c9e9b3fe89b0ead] 时间: 2022-10-14 18:19:49,609 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f6872110fb444a1187b5274d4d16c15f] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##1035f6079a3a4cf0bcd6bef545c5d5c3] 时间: 2022-10-14 18:19:49,612 线程ID: 26 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##f6872110fb444a1187b5274d4d16c15f 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.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2022-10-14 18:20:33,996 线程ID: 53 日志级别: 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 [##1fcbc327db614e569716a0198c18e8a5] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2022-10-14 18:20:34,457 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1fcbc327db614e569716a0198c18e8a5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##d4f208973706476ebc7e056d8c90fe7c] 时间: 2022-10-14 18:20:34,542 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1a3741c9c5884041b9fcad36da15a3f5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2022-10-14 18:20:34,546 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1a3741c9c5884041b9fcad36da15a3f5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2022-10-14 18:20:34,548 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1a3741c9c5884041b9fcad36da15a3f5 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2022-10-14 18:20:34,581 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1a3741c9c5884041b9fcad36da15a3f5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2022-10-14 18:20:34,583 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1a3741c9c5884041b9fcad36da15a3f5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2022-10-14 18:20:34,587 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1fcbc327db614e569716a0198c18e8a5] (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 [##04195439ea3d454d8e89f82d0569e3a1] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2022-10-14 18:20:34,888 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1fcbc327db614e569716a0198c18e8a5] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1], 渠道在途#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##dd552988d87d40d9957d32490bf3a6a4] 时间: 2022-10-14 18:20:34,891 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.UnitPrice AS [吊牌价], CASE WHEN SUM(A.销售#数量)=0 THEN NULL ELSE CAST(SUM(A.渠道库存#数量)*1.00/SUM(A.销售#数量) AS NUMERIC(29,2)) END AS [存销比], SUM([渠道库存#数量]) AS [渠道库存], SUM([渠道在途#数量]) AS [渠道在途], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], SUM([销售#数量]) AS [销售], GS.Range AS [系列] INTO tempdb.dbo.[d6f903d0-e1d6-4965-bb27-e03c0961ddf4] FROM ##1fcbc327db614e569716a0198c18e8a5 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.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Range ORDER BY A.Goods_No, GS.Goods_Name, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, GS.Range