时间: 2021-07-16 09:33:39,003 线程ID: 34 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], MAX(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(MAX(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/MAX(A.TotalQuantity) END) AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(MAX(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/MAX(A.TotalDpAmount) END) AS Numeric(18, 4)) AS [会员消费吊牌额占比], MAX(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], MAX(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(MAX(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/MAX(A.TotalAmount) END) AS Numeric(18, 4)) AS [会员消费额占比] INTO tempdb.dbo.[a14793a7-c5a3-4f82-a3cd-c62de79d2f3c] FROM ##b59dddd5863e4f1aba232fd0f8e8cd94 A INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID LEFT JOIN customervip Vip on Vip.VIP=A.VIP_Card GROUP BY A.Customer_ID, CT.Abbrev, A.CheckDate ORDER BY A.Customer_ID, CT.Abbrev, A.CheckDate 时间: 2021-07-16 09:34:25,558 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 Vip,CAST(0 AS INT) [合计#消费数],CAST(0 AS DECIMAL(18,2)) [合计#消费额],CAST(0 AS DECIMAL(18,2)) [合计#积分],CAST(0 AS DECIMAL(18,2)) 当前积分 ,CAST(0 AS INT) [1月#消费数],CAST(0 AS DECIMAL(18,2)) [1月#消费额],CAST(0 AS DECIMAL(18,2)) [1月#积分] ,CAST(0 AS INT) [2月#消费数],CAST(0 AS DECIMAL(18,2)) [2月#消费额],CAST(0 AS DECIMAL(18,2)) [2月#积分] ,CAST(0 AS INT) [3月#消费数],CAST(0 AS DECIMAL(18,2)) [3月#消费额],CAST(0 AS DECIMAL(18,2)) [3月#积分] ,CAST(0 AS INT) [4月#消费数],CAST(0 AS DECIMAL(18,2)) [4月#消费额],CAST(0 AS DECIMAL(18,2)) [4月#积分] ,CAST(0 AS INT) [5月#消费数],CAST(0 AS DECIMAL(18,2)) [5月#消费额],CAST(0 AS DECIMAL(18,2)) [5月#积分] ,CAST(0 AS INT) [6月#消费数],CAST(0 AS DECIMAL(18,2)) [6月#消费额],CAST(0 AS DECIMAL(18,2)) [6月#积分] ,CAST(0 AS INT) [7月#消费数],CAST(0 AS DECIMAL(18,2)) [7月#消费额],CAST(0 AS DECIMAL(18,2)) [7月#积分] ,CAST(0 AS INT) [8月#消费数],CAST(0 AS DECIMAL(18,2)) [8月#消费额],CAST(0 AS DECIMAL(18,2)) [8月#积分] ,CAST(0 AS INT) [9月#消费数],CAST(0 AS DECIMAL(18,2)) [9月#消费额],CAST(0 AS DECIMAL(18,2)) [9月#积分] ,CAST(0 AS INT) [10月#消费数],CAST(0 AS DECIMAL(18,2)) [10月#消费额],CAST(0 AS DECIMAL(18,2)) [10月#积分] ,CAST(0 AS INT) [11月#消费数],CAST(0 AS DECIMAL(18,2)) [11月#消费额],CAST(0 AS DECIMAL(18,2)) [11月#积分] ,CAST(0 AS INT) [12月#消费数],CAST(0 AS DECIMAL(18,2)) [12月#消费额],CAST(0 AS DECIMAL(18,2)) [12月#积分] INTO [##359823c8855644adb3cb1f55a526383a] FROM CustomerVip 时间: 2021-07-16 09:34:25,576 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[1月#消费数],[1月#消费额],[1月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=1 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,622 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[2月#消费数],[2月#消费额],[2月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=2 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,661 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[3月#消费数],[3月#消费额],[3月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=3 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,698 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[4月#消费数],[4月#消费额],[4月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=4 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,732 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[5月#消费数],[5月#消费额],[5月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=5 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,765 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[6月#消费数],[6月#消费额],[6月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=6 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,799 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[7月#消费数],[7月#消费额],[7月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=7 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,832 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[8月#消费数],[8月#消费额],[8月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=8 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,863 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[9月#消费数],[9月#消费额],[9月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=9 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,895 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[10月#消费数],[10月#消费额],[10月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=10 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,925 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[11月#消费数],[11月#消费额],[11月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=11 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,955 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##359823c8855644adb3cb1f55a526383a] (Vip,[12月#消费数],[12月#消费额],[12月#积分],[合计#消费数],[合计#消费额],[合计#积分]) SELECT a.Vip_Card,SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral),SUM(b.Quantity),SUM(b.Quantity*b.DiscountPrice),SUM(b.Integral) FROM vn_check a INNER JOIN vn_checkgoods b ON a.CheckID=b.CheckID INNER JOIN [##f0d2371938dc4592ad3a1a0bb9450a52] vvv ON a.Vip_Card=vvv.VIP WHERE a.Posted=1 AND DATEPART(MONTH,a.CheckDate)=12 AND DATEPART(YEAR,a.CheckDate)=2021 GROUP BY a.Vip_Card 时间: 2021-07-16 09:34:25,990 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT a.VIP AS [VIP卡号], VIP.Name AS [Vip姓名], SUM([2月#消费数]) [2月#消费数],SUM([2月#消费额]) [2月#消费额],SUM([2月#积分]) [2月#积分] ,SUM([3月#消费数]) [3月#消费数],SUM([3月#消费额]) [3月#消费额],SUM([3月#积分]) [3月#积分] ,SUM([4月#消费数]) [4月#消费数],SUM([4月#消费额]) [4月#消费额],SUM([4月#积分]) [4月#积分] ,SUM([5月#消费数]) [5月#消费数],SUM([5月#消费额]) [5月#消费额],SUM([5月#积分]) [5月#积分] ,SUM([6月#消费数]) [6月#消费数],SUM([6月#消费额]) [6月#消费额],SUM([6月#积分]) [6月#积分] ,SUM([7月#消费数]) [7月#消费数],SUM([7月#消费额]) [7月#消费额],SUM([7月#积分]) [7月#积分] , MIN(当前积分) AS [当前积分], SUM([合计#消费数]) [合计#消费数], SUM([合计#消费额]) [合计#消费额], SUM([合计#积分]) [合计#积分] INTO [##bcb01780fb1440f1a1abafc4792ed925] FROM [##359823c8855644adb3cb1f55a526383a] a INNER JOIN CustomerVip VIP ON a.Vip=VIP.Vip LEFT JOIN Customer C1 on C1.Customer_ID=VIP.Customer_ID LEFT JOIN Customer C3 on C3.Customer_ID=VIP.Customer_ID LEFT JOIN Customer C2 on C2.Customer_ID=VIP.OriginalCustomer WHERE 1 = 1 GROUP BY a.VIP, VIP.Name ORDER BY a.VIP, VIP.Name 时间: 2021-07-16 09:34:26,007 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT DISTINCT VIP卡号 Vip INTO ##de0c216285824670919926fdcf517d6f FROM ##bcb01780fb1440f1a1abafc4792ed925 时间: 2021-07-16 09:34:26,012 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: EXECUTE p_VipGetIntegral @VipTable = ##de0c216285824670919926fdcf517d6f ,@DataTable = ##c9a661339eaf40bab5ebc93bc0750019 时间: 2021-07-16 09:34:26,434 线程ID: 53 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET A.当前积分=B.IntegralAmount FROM [##bcb01780fb1440f1a1abafc4792ed925] A INNER JOIN [##c9a661339eaf40bab5ebc93bc0750019] B ON A.VIP卡号 = B.Vip 时间: 2021-07-16 11:49:00,483 线程ID: 97 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##8490c6be72cf4e86a7e7695d477e9196] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 11:49:01,085 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##92670a34f281437db9fd66cd9a4c0a27] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 11:49:01,091 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8490c6be72cf4e86a7e7695d477e9196] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##92670a34f281437db9fd66cd9a4c0a27] 时间: 2021-07-16 11:49:01,269 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1f7d9047ab494619ae550539afd7d3b1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 11:49:01,298 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1f7d9047ab494619ae550539afd7d3b1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 11:49:01,312 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1f7d9047ab494619ae550539afd7d3b1 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 11:49:01,358 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1f7d9047ab494619ae550539afd7d3b1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 11:49:01,361 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1f7d9047ab494619ae550539afd7d3b1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 11:49:01,390 线程ID: 97 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##8490c6be72cf4e86a7e7695d477e9196] (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 [##f66cd870dd374bed9f96dca403ae7fbd] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 11:49:01,452 线程ID: 97 日志级别: 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 [销售#生意额], SUM([渠道库存#数量]) AS [渠道库存#数量], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[af955de6-6a6f-4e26-9d82-37fe91aed31d] FROM ##8490c6be72cf4e86a7e7695d477e9196 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0 LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1 LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No GROUP BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END ORDER BY A.Goods_No, GS.Goods_Name, GS.Range, GS.UnitPrice, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 14:29:13,044 线程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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##f2b00355c298420da7022981ec0ada9b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 14:29:13,495 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##79fc6f3e0ee74d91a251ffb3bafcafc6] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 14:29:13,500 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f2b00355c298420da7022981ec0ada9b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##79fc6f3e0ee74d91a251ffb3bafcafc6] 时间: 2021-07-16 14:29:13,579 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##91e146d685b247209993ea91430c549b a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 14:29:13,581 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##91e146d685b247209993ea91430c549b SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 14:29:13,584 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##91e146d685b247209993ea91430c549b a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 14:29:13,614 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##91e146d685b247209993ea91430c549b SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 14:29:13,616 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##91e146d685b247209993ea91430c549b SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 14:29:13,621 线程ID: 48 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f2b00355c298420da7022981ec0ada9b] (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 [##98a2911192e442a29aaa47dc26b6b3df] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 14:29:13,635 线程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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##f2b00355c298420da7022981ec0ada9b 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 15:22:37,690 线程ID: 16 日志级别: 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 [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##8730765f122d45128603535585a051da] ORDER BY Goods_no 时间: 2021-07-16 15:28:23,209 线程ID: 53 日志级别: 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 [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##e0e465fcacd14a0f98111e4f637bafd5] ORDER BY Goods_no 时间: 2021-07-16 16:28:43,860 线程ID: 55 日志级别: 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 [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##d70f9e9117dd4aa0b531cefa1723c92e] ORDER BY Goods_no 时间: 2021-07-16 16:29:43,683 线程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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##1fb0a0089df44d5084e61e424c047405] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:29:46,771 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##f20de2df93874f3bb1f50690e4d7d7c8] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:29:46,773 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1fb0a0089df44d5084e61e424c047405] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##f20de2df93874f3bb1f50690e4d7d7c8] 时间: 2021-07-16 16:29:47,022 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ed3380a2754d4c8bbcaa874296126fb6 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:29:47,025 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed3380a2754d4c8bbcaa874296126fb6 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:29:47,176 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ed3380a2754d4c8bbcaa874296126fb6 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:29:48,049 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed3380a2754d4c8bbcaa874296126fb6 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:29:48,314 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ed3380a2754d4c8bbcaa874296126fb6 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:29:48,369 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##1fb0a0089df44d5084e61e424c047405] (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 [##9171a6bef3bb4dcd97a21cf468acb12b] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:29:48,570 线程ID: 28 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##1fb0a0089df44d5084e61e424c047405 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:30:09,999 线程ID: 60 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##dade6603afcf488095ca31c28ba7bea9] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:30:13,375 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ab35bb5db2b747a3acc0a40dc5bc802c] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:30:13,377 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dade6603afcf488095ca31c28ba7bea9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ab35bb5db2b747a3acc0a40dc5bc802c] 时间: 2021-07-16 16:30:14,741 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a7d53d8bc65444508a988cb8d66cd3db a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:30:14,743 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a7d53d8bc65444508a988cb8d66cd3db SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:30:14,746 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##a7d53d8bc65444508a988cb8d66cd3db a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:30:14,914 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a7d53d8bc65444508a988cb8d66cd3db SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:30:14,916 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##a7d53d8bc65444508a988cb8d66cd3db SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:30:14,935 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dade6603afcf488095ca31c28ba7bea9] (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 [##d7e33c77223c4589a92c10f7d5046079] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:30:15,091 线程ID: 60 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##dade6603afcf488095ca31c28ba7bea9 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:30:23,451 线程ID: 60 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##5b52bbc7fdb8444982620ca6ac4561dd] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:30:25,011 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##7d9d74c9f88b4542ad966672a913e4ca] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:30:25,013 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5b52bbc7fdb8444982620ca6ac4561dd] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##7d9d74c9f88b4542ad966672a913e4ca] 时间: 2021-07-16 16:30:25,463 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##50100bab36f044ae9f28b1ae83fa68da a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:30:25,465 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##50100bab36f044ae9f28b1ae83fa68da SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:30:25,468 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##50100bab36f044ae9f28b1ae83fa68da a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:30:25,574 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##50100bab36f044ae9f28b1ae83fa68da SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:30:25,694 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##50100bab36f044ae9f28b1ae83fa68da SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:30:25,696 线程ID: 60 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##5b52bbc7fdb8444982620ca6ac4561dd] (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 [##6f8d113ce8cb433b8cfe501b5a607d45] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:30:25,745 线程ID: 60 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##5b52bbc7fdb8444982620ca6ac4561dd 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:30:31,880 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##30be6050a5c94d17bd3870c60a03387e] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:30:33,108 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##9443dfa6405f4cd4ad2f0b635d3b1ee0] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:30:33,109 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##30be6050a5c94d17bd3870c60a03387e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##9443dfa6405f4cd4ad2f0b635d3b1ee0] 时间: 2021-07-16 16:30:33,452 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1c39d3b8c9524de0b2efdad809f806a1 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:30:33,456 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1c39d3b8c9524de0b2efdad809f806a1 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:30:33,460 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##1c39d3b8c9524de0b2efdad809f806a1 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:30:33,495 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1c39d3b8c9524de0b2efdad809f806a1 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:30:33,527 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1c39d3b8c9524de0b2efdad809f806a1 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:30:33,558 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##30be6050a5c94d17bd3870c60a03387e] (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 [##223684fad5784ae78063260889ca48ea] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:30:33,757 线程ID: 33 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##30be6050a5c94d17bd3870c60a03387e 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:30:55,119 线程ID: 21 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##c9c8abc7224e48d8b41f13765020c58a] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:30:56,201 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5dcca8cc84de44a98a3d35c0cf3d1a5e] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:30:56,235 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c9c8abc7224e48d8b41f13765020c58a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5dcca8cc84de44a98a3d35c0cf3d1a5e] 时间: 2021-07-16 16:30:56,449 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##aa12a747416d41588ed690ef522adece a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:30:56,452 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##aa12a747416d41588ed690ef522adece SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:30:56,455 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##aa12a747416d41588ed690ef522adece a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:30:56,551 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##aa12a747416d41588ed690ef522adece SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:30:56,644 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##aa12a747416d41588ed690ef522adece SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:30:56,679 线程ID: 21 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##c9c8abc7224e48d8b41f13765020c58a] (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 [##d70c7553957144309cdce307538c4271] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:30:56,761 线程ID: 21 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##c9c8abc7224e48d8b41f13765020c58a 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:31:05,311 线程ID: 33 日志级别: 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 [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[a173264f-1f24-4dea-a4a7-6724dc01c3e8] FROM [##fa438981e96c40b9a078e294c42a6ba8] ORDER BY Goods_no 时间: 2021-07-16 16:31:14,838 线程ID: 55 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##d05ae0c093f3488fbb3575eab55ddcb3] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:31:16,204 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##ef81c880449549a6ad82817684d36a17] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:31:16,207 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d05ae0c093f3488fbb3575eab55ddcb3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##ef81c880449549a6ad82817684d36a17] 时间: 2021-07-16 16:31:16,503 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##445b39efdd1346909b1ecdaa7b7e4203 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:31:16,538 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##445b39efdd1346909b1ecdaa7b7e4203 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:31:16,572 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##445b39efdd1346909b1ecdaa7b7e4203 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:31:16,653 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##445b39efdd1346909b1ecdaa7b7e4203 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:31:16,860 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##445b39efdd1346909b1ecdaa7b7e4203 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:31:16,879 线程ID: 55 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d05ae0c093f3488fbb3575eab55ddcb3] (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 [##5deca458b37642659518d4b3a8649ab5] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:31:16,949 线程ID: 55 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##d05ae0c093f3488fbb3575eab55ddcb3 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:31:43,080 线程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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##294aa0dd206e4ee286a9785d219c8c83] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:31:44,454 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##3ff6db7d2e6945a2a7b86ef6f193e49e] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:31:44,456 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##294aa0dd206e4ee286a9785d219c8c83] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##3ff6db7d2e6945a2a7b86ef6f193e49e] 时间: 2021-07-16 16:31:44,688 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##32e1f3183d034b49a8256a280228bfda a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:31:44,690 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##32e1f3183d034b49a8256a280228bfda SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:31:44,729 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##32e1f3183d034b49a8256a280228bfda a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:31:44,778 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##32e1f3183d034b49a8256a280228bfda SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:31:44,914 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##32e1f3183d034b49a8256a280228bfda SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:31:44,918 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##294aa0dd206e4ee286a9785d219c8c83] (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 [##08929f018f9d4c739a95e092c78112be] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:31:44,956 线程ID: 28 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##294aa0dd206e4ee286a9785d219c8c83 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:31:55,269 线程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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##22c77e3a17e7460bb7bb27f88cfb905b] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:31:56,898 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##dc8266660a5343c1811574028f0822a4] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:31:57,010 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22c77e3a17e7460bb7bb27f88cfb905b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##dc8266660a5343c1811574028f0822a4] 时间: 2021-07-16 16:31:57,250 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ae04aec51cf745eca2c07716487880a8 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:31:57,253 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ae04aec51cf745eca2c07716487880a8 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:31:57,256 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##ae04aec51cf745eca2c07716487880a8 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:31:57,341 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ae04aec51cf745eca2c07716487880a8 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:31:57,420 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##ae04aec51cf745eca2c07716487880a8 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:31:57,424 线程ID: 28 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##22c77e3a17e7460bb7bb27f88cfb905b] (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 [##91dc4baf308d41e28242aeceb1573a7f] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:31:57,517 线程ID: 28 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##22c77e3a17e7460bb7bb27f88cfb905b 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:32:09,758 线程ID: 32 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##d5d9f122cf644def82d46ec68fd0d87d] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:32:11,045 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##08047985e70e456ebc20e814207cddd2] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:32:11,047 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d5d9f122cf644def82d46ec68fd0d87d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##08047985e70e456ebc20e814207cddd2] 时间: 2021-07-16 16:32:11,360 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d41a5dd4f9c74aa68623c603817c6b9f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:32:11,364 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d41a5dd4f9c74aa68623c603817c6b9f SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:32:11,368 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##d41a5dd4f9c74aa68623c603817c6b9f a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:32:11,531 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d41a5dd4f9c74aa68623c603817c6b9f SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:32:11,533 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##d41a5dd4f9c74aa68623c603817c6b9f SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:32:11,550 线程ID: 32 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##d5d9f122cf644def82d46ec68fd0d87d] (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 [##2e667b778b82422c9db0ab24a40a8d03] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:32:11,562 线程ID: 32 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##d5d9f122cf644def82d46ec68fd0d87d 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:32:27,033 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##2e06f0b5b088449ea4867cdd9c622334] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:32:28,537 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5d557798738c4a558df97a4c720ccbfa] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:32:28,539 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2e06f0b5b088449ea4867cdd9c622334] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5d557798738c4a558df97a4c720ccbfa] 时间: 2021-07-16 16:32:28,688 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0c0869470f7d48c8b3fce6fdc2fc5be5 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:32:28,760 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0c0869470f7d48c8b3fce6fdc2fc5be5 SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:32:28,763 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##0c0869470f7d48c8b3fce6fdc2fc5be5 a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:32:28,876 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0c0869470f7d48c8b3fce6fdc2fc5be5 SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:32:28,879 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##0c0869470f7d48c8b3fce6fdc2fc5be5 SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:32:28,921 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##2e06f0b5b088449ea4867cdd9c622334] (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 [##46d134d91e1b41e1b916c18df1dff514] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:32:28,927 线程ID: 33 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##2e06f0b5b088449ea4867cdd9c622334 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:32:47,738 线程ID: 35 日志级别: 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 INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##f2a42c2ab31e4378b9a24de8d1fb0e09] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:32:48,871 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##5a31053ec086400ca888ffbd809f93be] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:32:48,875 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f2a42c2ab31e4378b9a24de8d1fb0e09] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##5a31053ec086400ca888ffbd809f93be] 时间: 2021-07-16 16:32:49,019 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##62218d9a2a284d5ea4dcbc645bfa778f a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:32:49,022 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##62218d9a2a284d5ea4dcbc645bfa778f SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:32:49,025 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##62218d9a2a284d5ea4dcbc645bfa778f a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:32:49,063 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##62218d9a2a284d5ea4dcbc645bfa778f SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:32:49,065 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##62218d9a2a284d5ea4dcbc645bfa778f SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:32:49,070 线程ID: 35 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##f2a42c2ab31e4378b9a24de8d1fb0e09] (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 [##a6a05051c9a443db979165f84c302cfa] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:32:49,076 线程ID: 35 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##f2a42c2ab31e4378b9a24de8d1fb0e09 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END 时间: 2021-07-16 16:33:51,120 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1] , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1] , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1] , CAST(NULL AS INT) AS [批发在途#数量] , CAST(NULL AS INT) AS [调拨在途#数量] , CAST(NULL AS INT) AS [7DayCheckQuantity] , CAST(NULL AS INT) AS [15DayCheckQuantity] , CAST(NULL AS INT) AS [30DayCheckQuantity] , CAST(NULL AS INT) AS [AllDayCheckQuantity] , 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 [##dab4804e16c84613a19a26d43471a2d8] FROM Customer A, Barcode B, DeliveryDetail C 时间: 2021-07-16 16:33:52,850 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: delete [##234a5e1c909e492fb21918ea25635b0f] where 2=2 and ISNULL(S1,0)=0 时间: 2021-07-16 16:33:52,852 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dab4804e16c84613a19a26d43471a2d8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量) SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0)) FROM [##234a5e1c909e492fb21918ea25635b0f] 时间: 2021-07-16 16:33:53,140 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e6d522f101834dec8a974109a9f961cc a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-07-16 16:33:53,145 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e6d522f101834dec8a974109a9f961cc SET CheckSaleType='线上发货' WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 ) AND LEN(ISNULL(RetailOrderID, '')) > 0 AND Status <> '退货' 时间: 2021-07-16 16:33:53,148 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.CheckSaleType = b.SaleType FROM ##e6d522f101834dec8a974109a9f961cc a INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID WHERE a.Status = '退货' 时间: 2021-07-16 16:33:53,193 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e6d522f101834dec8a974109a9f961cc SET CheckSaleType='线上发货' WHERE LEN(ISNULL(RetailOrderID, '')) > 0 AND LEN(ISNULL(PreSaleID, '')) = 0 AND Status = '退货' 时间: 2021-07-16 16:33:53,196 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##e6d522f101834dec8a974109a9f961cc SET CheckSaleType='正常销售' WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 时间: 2021-07-16 16:33:53,427 线程ID: 33 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##dab4804e16c84613a19a26d43471a2d8] (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 [##06153527bbaa4d1a9b9169d0f73b049a] GROUP BY Customer_ID, Goods_NO, ColorID, Long 时间: 2021-07-16 16:33:53,433 线程ID: 33 日志级别: 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 [渠道库存], GS.Pattern AS [款型], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称] INTO tempdb.dbo.[ee32f950-ec83-4be8-95dc-023fb68e3eb7] FROM ##dab4804e16c84613a19a26d43471a2d8 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, GS.Pattern, 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, GS.Pattern, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END