时间: 2021-11-01 10:21:01,695
  线程ID: 40
日志级别: 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 [##f3ef2fd9f6ea4a1fafdc303232263a2c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-11-01 10:21:02,256
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##bb5e534f33d245c2875eae86f702bbf0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-11-01 10:21:02,260
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f3ef2fd9f6ea4a1fafdc303232263a2c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##bb5e534f33d245c2875eae86f702bbf0]


    时间: 2021-11-01 10:21:02,332
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##d2b4115fc99a4db88bd6debb81493a57 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-11-01 10:21:02,335
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d2b4115fc99a4db88bd6debb81493a57 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-11-01 10:21:02,337
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##d2b4115fc99a4db88bd6debb81493a57 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-11-01 10:21:02,368
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d2b4115fc99a4db88bd6debb81493a57 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-11-01 10:21:02,369
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d2b4115fc99a4db88bd6debb81493a57 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-11-01 10:21:02,372
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f3ef2fd9f6ea4a1fafdc303232263a2c] (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 [##aed42426f94f4002b182b252ea7ebdfb]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-11-01 10:21:02,417
  线程ID: 40
日志级别: 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.[cc3fa22e-24a1-44d1-ba42-8073bf219c67]
FROM ##f3ef2fd9f6ea4a1fafdc303232263a2c A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2021-11-01 10:21:10,209
  线程ID: 78
日志级别: 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 [##a91671aedbd74e0da09e515cd46aed47]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-11-01 10:21:10,520
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##4db94c2b956045ed8aed850fd44da840] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-11-01 10:21:10,522
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a91671aedbd74e0da09e515cd46aed47] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##4db94c2b956045ed8aed850fd44da840]


    时间: 2021-11-01 10:21:10,591
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##581308749fe240e2b30c3c6e1f16ac62 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-11-01 10:21:10,593
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##581308749fe240e2b30c3c6e1f16ac62 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-11-01 10:21:10,596
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##581308749fe240e2b30c3c6e1f16ac62 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-11-01 10:21:10,627
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##581308749fe240e2b30c3c6e1f16ac62 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-11-01 10:21:10,628
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##581308749fe240e2b30c3c6e1f16ac62 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-11-01 10:21:10,632
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a91671aedbd74e0da09e515cd46aed47] (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 [##c4c9e37c7ace462ebe7a8df9608a5d87]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-11-01 10:21:10,638
  线程ID: 78
日志级别: 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.[cc3fa22e-24a1-44d1-ba42-8073bf219c67]
FROM ##a91671aedbd74e0da09e515cd46aed47 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2021-11-01 14:48:02,101
  线程ID: 77
日志级别: 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.[ce8bdd6b-0e63-475a-8342-e655df277464]
FROM [##d512723f1e504ac9a05d558a2eb8c304]
ORDER BY Goods_no


    时间: 2021-11-01 14:48:10,162
  线程ID: 40
日志级别: 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 [##06d0a89faee046bdaf66b313bfc66b00]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-11-01 14:48:10,488
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ccda539e1190429ab1d39db0dfcbfd22] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-11-01 14:48:10,490
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##06d0a89faee046bdaf66b313bfc66b00] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ccda539e1190429ab1d39db0dfcbfd22]


    时间: 2021-11-01 14:48:10,565
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##402eee6493714e29ba573c6c13649d98 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-11-01 14:48:10,567
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##402eee6493714e29ba573c6c13649d98 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-11-01 14:48:10,570
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##402eee6493714e29ba573c6c13649d98 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-11-01 14:48:10,601
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##402eee6493714e29ba573c6c13649d98 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-11-01 14:48:10,603
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##402eee6493714e29ba573c6c13649d98 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-11-01 14:48:10,606
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##06d0a89faee046bdaf66b313bfc66b00] (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 [##9df3c7818ae74976bf2f0382f06e0820]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-11-01 14:48:10,613
  线程ID: 40
日志级别: 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.[cc3fa22e-24a1-44d1-ba42-8073bf219c67]
FROM ##06d0a89faee046bdaf66b313bfc66b00 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2021-11-01 14:48:20,167
  线程ID: 40
日志级别: 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 [##88f309aafd4c4f84b35abdbc531650dc]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-11-01 14:48:20,610
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f8ddb1891156488fa891c6fcdff1f8e3] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-11-01 14:48:20,612
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##88f309aafd4c4f84b35abdbc531650dc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f8ddb1891156488fa891c6fcdff1f8e3]


    时间: 2021-11-01 14:48:20,680
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##31ddb6b2e0944c1c8b3af3d681d90e2a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-11-01 14:48:20,683
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##31ddb6b2e0944c1c8b3af3d681d90e2a SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-11-01 14:48:20,687
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##31ddb6b2e0944c1c8b3af3d681d90e2a a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-11-01 14:48:20,717
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##31ddb6b2e0944c1c8b3af3d681d90e2a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-11-01 14:48:20,719
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##31ddb6b2e0944c1c8b3af3d681d90e2a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-11-01 14:48:20,722
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##88f309aafd4c4f84b35abdbc531650dc] (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 [##0d1d8ae3e19d41abbe082c6f169c6c06]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-11-01 14:48:20,727
  线程ID: 40
日志级别: 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.[cc3fa22e-24a1-44d1-ba42-8073bf219c67]
FROM ##88f309aafd4c4f84b35abdbc531650dc A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2021-11-01 14:48:35,262
  线程ID: 77
日志级别: 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 [##637cfd37c8fa4f36903ac76f0b86c2de]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-11-01 14:48:35,588
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ed07a1d99985466ca540c20c08e118eb] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-11-01 14:48:35,589
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##637cfd37c8fa4f36903ac76f0b86c2de] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ed07a1d99985466ca540c20c08e118eb]


    时间: 2021-11-01 14:48:35,659
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##21ac1c19700242f9891902e029d8c916 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-11-01 14:48:35,662
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##21ac1c19700242f9891902e029d8c916 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-11-01 14:48:35,666
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##21ac1c19700242f9891902e029d8c916 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-11-01 14:48:35,699
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##21ac1c19700242f9891902e029d8c916 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-11-01 14:48:35,700
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##21ac1c19700242f9891902e029d8c916 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-11-01 14:48:35,703
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##637cfd37c8fa4f36903ac76f0b86c2de] (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 [##0063a7ef8bd14cf9a213cf321502e127]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-11-01 14:48:35,710
  线程ID: 77
日志级别: 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.[cc3fa22e-24a1-44d1-ba42-8073bf219c67]
FROM ##637cfd37c8fa4f36903ac76f0b86c2de A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

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

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


    时间: 2021-11-01 14:51:22,709
  线程ID: 77
日志级别: 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.[ce8bdd6b-0e63-475a-8342-e655df277464]
FROM [##5c09bcd91490487397dc2134ecf92f8e]
ORDER BY Goods_no


    时间: 2021-11-01 16:25:57,707
  线程ID: 64
日志级别: 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.[ce8bdd6b-0e63-475a-8342-e655df277464]
FROM [##74965c0a628741b0b41b0979899e7e79]
ORDER BY Goods_no


    时间: 2021-11-01 16:26:01,884
  线程ID: 58
日志级别: 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.[ce8bdd6b-0e63-475a-8342-e655df277464]
FROM [##bbb7791faafa4ce1b8027021331875bd]
ORDER BY Goods_no


    时间: 2021-11-01 17:10:43,457
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT a.VIP 
INTO ##1c8d7b4d2eb74965a208ca9e6192bc48
FROM CustomerVIP a
 WHERE Exists(SELECT 1 FROM ##725dffd92d374d53b43d231d1043c00b WHERE Customer_ID=a.Customer_ID) 
 AND Exists(select 1 from ##8b971b47144046aca3dd065cd7cfb999 where VIP=a.VIP) 
AND a.[ExpireDate] > GETDATE()


    时间: 2021-11-01 17:10:43,495
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH t1 as
(
select a.VIP_Card,a.CheckDate 
from [Check] a 
inner join [##1c8d7b4d2eb74965a208ca9e6192bc48] CV on a.VIP_Card=CV.VIP
inner join [##725dffd92d374d53b43d231d1043c00b] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
GROUP BY a.VIP_Card,a.CheckDate 
union all 
select a.VIP_Card,a.CheckDate 
from [CheckL] a 
inner join [##1c8d7b4d2eb74965a208ca9e6192bc48] CV on a.VIP_Card=CV.VIP
inner join [##725dffd92d374d53b43d231d1043c00b] CT on a.Customer_ID=CT.Customer_ID
where  a.Posted=1
GROUP BY a.VIP_Card,a.CheckDate 
)

select VIP_Card
,MAX(最近消费日期) as 最近消费日期,MAX(上次消费日期) as 上次消费日期
,DATEDIFF(DAY,MAX(上次消费日期),MAX(最近消费日期)) as 周期
into ##54a3ad5a68bb410fa94e480460d82efd
from (
	select VIP_Card
	,case when RowNumber=1 then CheckDate end as 最近消费日期
	,case when RowNumber=2 then CheckDate else null end as 上次消费日期
	from(
		select ROW_NUMBER() over (partition by VIP_Card order by CheckDate desc) as RowNumber
		, VIP_Card,CheckDate
		from t1
	)t where RowNumber<=2
)t group by VIP_Card


    时间: 2021-11-01 17:10:43,530
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,COUNT(distinct(a.CheckID)) as BillQty
,SUM(b.Quantity) as Quantity
,SUM(b.Quantity*b.DiscountPrice) as DiscountAmount
,SUM(b.Quantity*gd.UnitPrice) as DpAmount
into ##d16a62def5644e5095ac4b05951b5551
from [Check] a
inner join CheckGoods b on a.CheckID=b.CheckID
inner join Goods Gd on B.Goods_no=Gd.Goods_no
inner join [##1c8d7b4d2eb74965a208ca9e6192bc48] CV on a.VIP_Card=CV.VIP
inner join [##725dffd92d374d53b43d231d1043c00b] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
and a.CheckDate >= '2021-09-01' 
and a.CheckDate <= '2021-11-01' 
group by VIP_Card


    时间: 2021-11-01 17:10:43,599
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: insert into ##d16a62def5644e5095ac4b05951b5551
select VIP_Card,COUNT(distinct(a.CheckID)) as BillQty
,SUM(b.Quantity) as Quantity
,SUM(b.Quantity*b.DiscountPrice) as DiscountAmount
,SUM(b.Quantity*gd.UnitPrice) as DpAmount
from [CheckL] a
inner join CheckLGoods b on a.CheckID=b.CheckID
inner join Goods Gd on B.Goods_no=Gd.Goods_no
inner join [##1c8d7b4d2eb74965a208ca9e6192bc48] CV on a.VIP_Card=CV.VIP
inner join [##725dffd92d374d53b43d231d1043c00b] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
and a.CheckDate >= '2021-09-01' 
and a.CheckDate <= '2021-11-01' 
group by VIP_Card


    时间: 2021-11-01 17:10:43,613
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,SUM(DiscountAmount) as DiscountAmount 
into ##82798bacdb704851b28a7c4baa02f425
from ##d16a62def5644e5095ac4b05951b5551
group by VIP_Card


    时间: 2021-11-01 17:10:43,617
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,SUM(BillQty) as BillQty,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
,SUM(DpAmount) as DpAmount
into ##988e21fa6a4240dc8f6190bd6b390c97
from ##d16a62def5644e5095ac4b05951b5551
group by VIP_Card


    时间: 2021-11-01 17:10:43,619
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,DiscountAmount
,case when isnull(DpAmount,0)=0 then null
  else cast(DiscountAmount/DpAmount as numeric(30,2)) end as AVGDiscoun 
,cast(Quantity*1.0/BillQty as  numeric(30,2))  as AVGQty 
,cast(DiscountAmount/BillQty as  numeric(30,2))  as AVGAmount 
into ##6040f2b90d404ef492b021871f541c05
from ##988e21fa6a4240dc8f6190bd6b390c97 a 


    时间: 2021-11-01 17:10:43,621
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##d16a62def5644e5095ac4b05951b5551

    时间: 2021-11-01 17:10:43,622
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##988e21fa6a4240dc8f6190bd6b390c97

    时间: 2021-11-01 17:10:43,623
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: exec p_VipGetIntegral @DataTable='##41d69e3d969e4543ab447e0fb06deb69',@VipTable='##1c8d7b4d2eb74965a208ca9e6192bc48', @EndDate = '2021-11-01' 

    时间: 2021-11-01 17:10:43,860
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , v.VIP AS [Vip卡号], CV.Name AS [Vip姓名], t1.最近消费日期 AS [最近消费日期], t1.上次消费日期 AS [上次消费日期], t1.周期 AS [周期], SUM(t2.DiscountAmount) AS [本期消费金额], SUM(t2.AVGDiscoun) AS [平均折扣], SUM(t2.AVGQty) AS [本期单票件数], SUM(t2.AVGAmount) AS [本期单票金额], SUM(t3.DiscountAmount) AS [累计消费金额], SUM(t4.IntegralAmount) AS [当前积分], t5.Discount AS [等级折扣] 
   INTO tempdb.dbo.[5b956b1a-a71a-4043-bccb-cfcdf535130d] 
FROM ##1c8d7b4d2eb74965a208ca9e6192bc48 v 
   LEFT JOIN CustomerVIP CV on CV.VIP=v.VIP 
   LEFT JOIN ##54a3ad5a68bb410fa94e480460d82efd t1 on t1.VIP_Card=v.VIP 
   LEFT JOIN ##6040f2b90d404ef492b021871f541c05 t2 on t2.VIP_Card=v.VIP 
   LEFT JOIN ##82798bacdb704851b28a7c4baa02f425 t3 on t3.VIP_Card=v.VIP 
   LEFT JOIN ##41d69e3d969e4543ab447e0fb06deb69 t4 on t4.VIP=v.VIP 
     LEFT JOIN VIPGradeIntegralBase t5 ON CV.VipGrade = t5.VipGrade
     LEFT JOIN CUSTOMER CV1 ON CV.CUSTOMER_ID=CV1.CUSTOMER_ID

GROUP BY  v.VIP, CV.Name, t1.最近消费日期, t1.上次消费日期, t1.周期, t5.Discount

ORDER BY  v.VIP, CV.Name, t1.最近消费日期, t1.上次消费日期, t1.周期, t5.Discount


    时间: 2021-11-01 17:52:18,727
  线程ID: 58
日志级别: 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.[ce8bdd6b-0e63-475a-8342-e655df277464]
FROM [##6cf8c6b5c2444c6b9a438615b66acbee]
ORDER BY Goods_no


    时间: 2021-11-01 18:01:00,521
  线程ID: 10
日志级别: 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.[ce8bdd6b-0e63-475a-8342-e655df277464]
FROM [##603b9511e85f4eb190ab33235a587320]
ORDER BY Goods_no


    时间: 2021-11-01 18:28:17,502
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP 
into ##44e7fd192b1441abaa6b64b0d59b2a28
from CustomerVIP a
where Exists(select 1 from ##ab6d7c535b274f3596945ccb8c5fb345 where VIP =a.VIP) 
and isnull(a.Input_Date,'1911-01-01')>='1900/1/1 0:00:00' 
and isnull(a.Input_Date,'1911-01-01')<='9999/12/31 23:59:59' 
ALTER TABLE ##44e7fd192b1441abaa6b64b0d59b2a28 ADD  CONSTRAINT [PK_##44e7fd192b1441abaa6b64b0d59b2a28] PRIMARY KEY CLUSTERED 
(VIP ASC)
 WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, 
ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 90) ON [PRIMARY]


    时间: 2021-11-01 18:28:17,536
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select a.CheckID,case when b.SaleTypeID=1 then null else a.CheckID end newCheckID,a.VIP_Card,b.Goods_No,c.ColorID,c.Long
,Convert(Varchar(10),'S1') SIZE,SUM(ISNULL(S1,0)) as Quantity 
,sum(ISNULL(S1,0)*ISNULL(b.DiscountPrice,0)) as Amount 
into ##f537b1f70b5444a6b5602e1ea19b0ed2
from [Check] a
inner join CheckGoods b on a.CheckID=b.CheckID
inner join CheckDetail c on b.CheckGoodsID=c.CheckGoodsID
where a.Posted=1
and Exists (select 1 from ##44e7fd192b1441abaa6b64b0d59b2a28 where VIP = a.VIP_Card) 
and Exists (select 1 from ##ce30b8b1c8784b5e87eda41a4e2604c9 where Goods_No = b.Goods_No) 
and a.CheckDate between '2001/10/1 0:00:00' and '2021/10/30 0:00:00' 
group by a.CheckID,b.SaleTypeID,a.VIP_Card,b.Goods_No,c.ColorID,c.Long
 having SUM(ISNULL(S1,0))<>0

    时间: 2021-11-01 18:28:17,727
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: insert into ##f537b1f70b5444a6b5602e1ea19b0ed2
select a.CheckID,case when b.SaleTypeID=1 then null else a.CheckID end newCheckID,a.VIP_Card,b.Goods_No,c.ColorID,c.Long
,'S1' SIZE,SUM(ISNULL(S1,0)) as Quantity 
,sum(ISNULL(S1,0)*ISNULL(b.DiscountPrice,0)) as Amount 
from [CheckL] a
inner join CheckLGoods b on a.CheckID=b.CheckID
inner join CheckLDetail c on b.CheckGoodsID=c.CheckGoodsID
where a.Posted=1
and Exists (select 1 from ##44e7fd192b1441abaa6b64b0d59b2a28 where VIP = a.VIP_Card) 
and Exists (select 1 from ##ce30b8b1c8784b5e87eda41a4e2604c9 where Goods_No = b.Goods_No) 
and a.CheckDate between '2001/10/1 0:00:00' and '2021/10/30 0:00:00' 
group by a.CheckID,b.SaleTypeID,a.VIP_Card,b.Goods_No,c.ColorID,c.Long
 having SUM(ISNULL(S1,0))<>0

    时间: 2021-11-01 18:28:17,775
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT CheckID,newCheckID,VIP_Card,Goods_No,ColorID,Long, SIZE, SUM(Quantity) as Quantity, SUM(Amount) As Amount
 INTO ##ac9574e4ea194abe846d582fbbf1565e
 FROM ##f537b1f70b5444a6b5602e1ea19b0ed2
 GROUP BY CheckID,newCheckID,VIP_Card,Goods_No,ColorID,Long, SIZE


    时间: 2021-11-01 18:28:17,821
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select Vip_Card,max(CheckDate) as CheckDate 
into ##97ea26c75c4e4b75ab4a27f6ff6faf8d
from [Check] a 
where Exists (select 1 from ##44e7fd192b1441abaa6b64b0d59b2a28 where VIP=a.Vip_Card) 
group by Vip_Card

insert into ##97ea26c75c4e4b75ab4a27f6ff6faf8d
select Vip_Card,max(CheckDate) as CheckDate 
from [CheckL] a
where Exists (select 1 from ##44e7fd192b1441abaa6b64b0d59b2a28 where VIP=a.Vip_Card) 
group by Vip_Card

select Vip_Card,max(CheckDate) as CheckDate 
into ##aeb78457542941aaa302d5f5b36d77fd
from ##97ea26c75c4e4b75ab4a27f6ff6faf8d
group by Vip_Card


    时间: 2021-11-01 18:28:17,845
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select IDENTITY(INT, 1, 1) AS RowNumber,  A.VIP_Card AS [VIP编号], v.Name AS [姓名], sum(a.Quantity) AS [数量], count(distinct a.newCheckID) AS [累计消费次数], cast(datediff(day,'2001/10/1','2021/10/30')*1.0/Count(distinct a.CheckID) as numeric(30,0)) AS [平均消费天数], sum(a.Amount) AS [生意额], case when isnull(sum(a.Quantity*g.UnitPrice),0)=0 then 0 else cast(sum(a.Amount)/sum(a.Quantity*g.UnitPrice) as numeric(30,0)) end AS [平均折扣], max(b.CheckDate) AS [最后消费日期]
into tempdb.dbo.[3fd6f2c0-03d4-4e8b-84de-4b3246f4d4ce]
from ##ac9574e4ea194abe846d582fbbf1565e a 
inner join ##aeb78457542941aaa302d5f5b36d77fd b on a.Vip_Card=b.Vip_Card 
inner join CustomerVIP v on v.VIP=a.Vip_Card
inner join Goods g on g.Goods_No=a.Goods_No 
inner join vGoodsColor vgc on vgc.Goods_No=a.Goods_No and vgc.ColorID=a.ColorID
left  join DictColor DC ON VGC.ColorID = DC.ColorID
left join Customer ct on ct.Customer_ID=v.Customer_ID
inner join vGoodsSize GS ON GS.GOODS_NO=A.GOODS_NO and a.size=gs.FieldName

GROUP BY  A.VIP_Card, v.Name

ORDER BY  A.VIP_Card, v.Name