时间: 2022-10-10 13:08:12,728
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##4d8b41baadea4a279489bceb2e0a8ae8 ADD 销售类型 VARCHAR(50)

    时间: 2022-10-10 13:08:12,763
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##4d8b41baadea4a279489bceb2e0a8ae8 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-10-10 13:08:12,768
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d8b41baadea4a279489bceb2e0a8ae8 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2022-10-10 13:08:12,774
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##4d8b41baadea4a279489bceb2e0a8ae8 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON a.CheckGoodsID = SCG.CheckGoodsID 
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-10-10 13:08:12,791
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d8b41baadea4a279489bceb2e0a8ae8 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2022-10-10 13:08:12,793
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d8b41baadea4a279489bceb2e0a8ae8 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2022-10-10 13:08:12,843
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], SUM(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(SUM(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/SUM(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(SUM(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/SUM(A.TotalDpAmount) END)  AS Numeric(18, 4)) AS [会员消费吊牌额占比], SUM(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], SUM(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(SUM(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/SUM(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比]
 INTO tempdb.dbo.[0f524293-7924-480b-8d7f-80b0fd4f77c7]
FROM ##e70240afd50a47bb866d4a77f6415744 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


    时间: 2022-10-10 13:12:33,221
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##f0a645e7fda64f1790c7baeed2ebd13d ADD 销售类型 VARCHAR(50)

    时间: 2022-10-10 13:12:33,223
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##f0a645e7fda64f1790c7baeed2ebd13d a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-10-10 13:12:33,229
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f0a645e7fda64f1790c7baeed2ebd13d SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2022-10-10 13:12:33,238
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##f0a645e7fda64f1790c7baeed2ebd13d a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON a.CheckGoodsID = SCG.CheckGoodsID 
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-10-10 13:12:33,267
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f0a645e7fda64f1790c7baeed2ebd13d SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2022-10-10 13:12:33,272
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f0a645e7fda64f1790c7baeed2ebd13d SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2022-10-10 13:12:33,339
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], SUM(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(SUM(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/SUM(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(SUM(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/SUM(A.TotalDpAmount) END)  AS Numeric(18, 4)) AS [会员消费吊牌额占比], SUM(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], SUM(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(SUM(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/SUM(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比]
 INTO tempdb.dbo.[0f524293-7924-480b-8d7f-80b0fd4f77c7]
FROM ##814aa1c6e4614f66852c1f5be78bb310 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


    时间: 2022-10-10 14:32:20,475
  线程ID: 84
日志级别: 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 [##c3b4e9b6fd61474e8fe0d56c626e0b48]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-10-10 14:32:21,301
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##357c710478b0421c88787046c53861f8] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-10-10 14:32:21,308
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c3b4e9b6fd61474e8fe0d56c626e0b48] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##357c710478b0421c88787046c53861f8]


    时间: 2022-10-10 14:32:21,379
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##16a4c2892a3c4dd6817b3512a152e771 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-10-10 14:32:21,385
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##16a4c2892a3c4dd6817b3512a152e771 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-10-10 14:32:21,390
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##16a4c2892a3c4dd6817b3512a152e771 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-10 14:32:21,425
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##16a4c2892a3c4dd6817b3512a152e771 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-10-10 14:32:21,427
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##16a4c2892a3c4dd6817b3512a152e771 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-10-10 14:32:21,433
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c3b4e9b6fd61474e8fe0d56c626e0b48] (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 [##2804a7dc16d94893bf94fff04185635b]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-10-10 14:32:21,449
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Category AS [类别], GS.Range AS [系列], GS.Pattern AS [款型], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], GS.UnitPrice AS [吊牌价], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[fc698b8d-6d94-4cd8-a261-e91231d51246]
FROM ##c3b4e9b6fd61474e8fe0d56c626e0b48 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.Category, GS.Range, GS.Pattern, GS.UnitPrice

ORDER BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name, GS.Category, GS.Range, GS.Pattern, GS.UnitPrice


    时间: 2022-10-10 14:33:07,846
  线程ID: 85
日志级别: 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 [##9e90d62723d24ac183b6d2a02285bfca]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-10-10 14:33:08,701
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##853c7656c4814593bc60b771d2e4111c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-10-10 14:33:08,709
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9e90d62723d24ac183b6d2a02285bfca] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##853c7656c4814593bc60b771d2e4111c]


    时间: 2022-10-10 14:33:08,784
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##bbcd2a9e3f144721b221deeda166cd11 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-10-10 14:33:08,789
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bbcd2a9e3f144721b221deeda166cd11 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-10-10 14:33:08,794
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##bbcd2a9e3f144721b221deeda166cd11 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-10 14:33:08,834
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bbcd2a9e3f144721b221deeda166cd11 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-10-10 14:33:08,837
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bbcd2a9e3f144721b221deeda166cd11 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-10-10 14:33:08,842
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9e90d62723d24ac183b6d2a02285bfca] (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 [##913112c342c449dfb7aabc1c1be54ed1]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-10-10 14:33:08,854
  线程ID: 85
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Category AS [类别], GS.Range AS [系列], GS.Pattern AS [款型], SUM([销售#数量]) AS [销售#数量], SUM([销售#金额]) AS [销售#生意额], GS.UnitPrice AS [吊牌价], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[fc698b8d-6d94-4cd8-a261-e91231d51246]
FROM ##9e90d62723d24ac183b6d2a02285bfca 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.Category, GS.Range, GS.Pattern, GS.UnitPrice

ORDER BY  A.Goods_No, GS.Goods_Name, GS.Category, GS.Range, GS.Pattern, GS.UnitPrice


    时间: 2022-10-10 17:24:07,770
  线程ID: 85
日志级别: 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.[d412ff24-bfc3-46b8-8305-ddf46441ece9]
FROM [##60f057a5aeb14bdeae4bef00823d6753]
ORDER BY Goods_no


    时间: 2022-10-10 17:24:55,687
  线程ID: 12
日志级别: 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 [##9fd14f0b35544009b4ce5fcbba90e7bb]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-10-10 17:24:56,200
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0e3de98bfe5d4bc99a9d0ebd96b6496d] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-10-10 17:24:56,202
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9fd14f0b35544009b4ce5fcbba90e7bb] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0e3de98bfe5d4bc99a9d0ebd96b6496d]


    时间: 2022-10-10 17:24:56,258
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##1ae838f8aa874db39bdfac004f23c094 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-10-10 17:24:56,261
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1ae838f8aa874db39bdfac004f23c094 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-10-10 17:24:56,264
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##1ae838f8aa874db39bdfac004f23c094 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-10 17:24:56,302
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1ae838f8aa874db39bdfac004f23c094 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-10-10 17:24:56,303
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1ae838f8aa874db39bdfac004f23c094 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-10-10 17:24:56,307
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9fd14f0b35544009b4ce5fcbba90e7bb] (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 [##3044cce34b914ba289a461203ac8e5ba]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-10-10 17:24:56,311
  线程ID: 12
日志级别: 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.[7310e09e-cf53-458d-a608-07533c247570]
FROM ##9fd14f0b35544009b4ce5fcbba90e7bb 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