时间: 2023-05-31 15:49:16,532
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT A.VIP_Card, A.Customer_ID, A.CheckDate, A.CheckID, B.Goods_No
         , ISNULL(B.Quantity, 0) Quantity, ISNULL(B.Quantity,0) * ISNULL(B.DiscountPrice,0) DiscountAmount, b.Discount, ISNULL(b.Integral,0) Integral
 INTO ##a54cffde849948cea653f8e6d7fbbcd0
 FROM [Check] A 
     INNER JOIN CheckGoods B ON A.CheckID = B.CheckID
     INNER JOIN Goods G ON B.Goods_No = G.Goods_no 
     INNER JOIN CustomerVIP V ON A.VIP_Card=V.VIP 
     INNER JOIN Customer C ON A.Customer_ID = C.Customer_id 
     LEFT JOIN CUSTOMER CV ON v.CUSTOMER_ID = CV.CUSTOMER_ID
     LEFT JOIN CUSTOMER CV2 ON v.OriginalCustomer = CV2.CUSTOMER_ID
 WHERE LEN(ISNULL(A.VIP_Card, '')) > 0 AND A.Posted = 1 
 AND A.CheckDate >= '2021/1/1 0:00:00'  
 AND A.CheckDate <= '2023/5/30 0:00:00'  
 AND EXISTS (SELECT 1 FROM ##59069e4675104edca815e6b683d84370 WHERE Customer_ID = a.Customer_ID) 
  AND EXISTS (SELECT 1 FROM ##63495feb24ce42e79f559870a68de99b WHERE VIP = A.VIP_Card) 
 

    时间: 2023-05-31 15:49:17,103
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##a54cffde849948cea653f8e6d7fbbcd0
 SELECT A.VIP_Card, A.Customer_ID, A.CheckDate, A.CheckID, B.Goods_No
         , ISNULL(B.Quantity, 0) Quantity, ISNULL(B.Quantity,0) * ISNULL(B.DiscountPrice,0) DiscountAmount, b.Discount, ISNULL(b.Integral,0) Integral
 FROM [CheckL] A 
     INNER JOIN CheckLGoods B ON A.CheckID = B.CheckID
     INNER JOIN Goods G ON B.Goods_No = G.Goods_no 
     INNER JOIN CustomerVIP V ON A.VIP_Card = V.VIP 
     INNER JOIN Customer C ON A.Customer_ID = C.Customer_id 
     LEFT JOIN CUSTOMER CV ON v.CUSTOMER_ID = CV.CUSTOMER_ID
     LEFT JOIN CUSTOMER CV2 ON v.OriginalCustomer = CV2.CUSTOMER_ID
 WHERE LEN(ISNULL(A.VIP_Card, '')) > 0 AND A.Posted = 1 
 AND A.CheckDate >= '2021/1/1 0:00:00'  
 AND A.CheckDate <= '2023/5/30 0:00:00'  
 AND EXISTS (SELECT 1 FROM ##59069e4675104edca815e6b683d84370 WHERE Customer_ID = A.Customer_ID) 
  AND EXISTS (SELECT 1 FROM ##63495feb24ce42e79f559870a68de99b WHERE VIP = A.VIP_Card) 
 

    时间: 2023-05-31 15:49:17,204
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , A.CheckID AS [核销单], CONVERT(VARCHAR(20), A.CheckDate, 23) AS [日期], a.VIP_Card AS [Vip卡号], V.Name AS [Vip姓名], A.Customer_ID AS [渠道编号], CV.Abbrev AS [渠道简称], A.Goods_No AS [货号], SUM(A.Quantity) AS [数量], SUM(DiscountAmount) AS [金额], A.Discount AS [折扣], SUM(A.Integral) AS [积分] 
   INTO tempdb.dbo.[84bc3cec-8157-4d66-baa2-9304d0832925] 
FROM ##a54cffde849948cea653f8e6d7fbbcd0 A 
   INNER JOIN CustomerVIP V ON A.VIP_Card = V.VIP 
   LEFT JOIN Customer CV ON A.CUSTOMER_ID = CV.CUSTOMER_ID 
GROUP BY  A.CheckID, CONVERT(VARCHAR(20), A.CheckDate, 23), a.VIP_Card, V.Name, A.Customer_ID, CV.Abbrev, A.Goods_No, A.Discount
ORDER BY  A.CheckID, CONVERT(VARCHAR(20), A.CheckDate, 23), a.VIP_Card, V.Name, A.Customer_ID, CV.Abbrev, A.Goods_No, A.Discount


    时间: 2023-05-31 15:57:16,699
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Vip AS [卡号]
, CAST(NULL AS DECIMAL(30,2)) AS [期初积分]
, CAST(NULL AS DECIMAL(30,2)) AS [本期积分]
, CAST(NULL AS DECIMAL(30,2)) AS [消费积分]
, CAST(NULL AS DECIMAL(30,2)) AS [抵减积分]
, CAST(NULL AS DECIMAL(30,2)) AS [金额充值赠送]
, CAST(NULL AS DECIMAL(30,2)) AS [增提积分]
, CAST(NULL AS DECIMAL(30,2)) AS [积分换购]
, CAST(NULL AS DECIMAL(30,2)) AS [积分转入]
, CAST(NULL AS DECIMAL(30,2)) AS [积分转出]
, CAST(NULL AS DECIMAL(30,2)) AS [零售订单积分]
, CAST(NULL AS DECIMAL(30,2)) AS [可用积分]
, CAST(NULL AS DECIMAL(30,2)) AS [累计积分]
, CAST(NULL AS DECIMAL(30,2)) AS [当前积分]
INTO [##6ee01aa28c3b49fea35248af285222f9]
FROM CustomerVip A


    时间: 2023-05-31 15:57:16,704
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##7837beb815e4486c81c363bce21d4742', 
@EndDate = '2023/4/29', 
@DataTable = '##d396aa06e3cf4eeab0773434764bbe8c' 


    时间: 2023-05-31 15:57:16,979
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [期初积分])
SELECT A.VIP, SUM(A.IntegralAmount)
FROM ##d396aa06e3cf4eeab0773434764bbe8c A
GROUP BY A.VIP


    时间: 2023-05-31 15:57:16,991
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [金额充值赠送])
SELECT A.Vip, SUM(A.Integral)
FROM VIPAddValue A
WHERE A.Posted = 1
AND  A.VipAddValue_Date>='2023/4/30' AND A.VipAddValue_Date<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-05-31 15:57:17,001
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT Vip INTO ##27f29103a29d4747ad3c3050d2aeaad6 FROM ##7837beb815e4486c81c363bce21d4742

    时间: 2023-05-31 15:57:17,003
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: EXEC p_VipGetIntegral 
@VipTable = '##27f29103a29d4747ad3c3050d2aeaad6', 
@DataTable = '##8268ef8fa55d4595982514956bfafa88', 
@IsUsabeIntegral = 1 


    时间: 2023-05-31 15:57:17,313
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [可用积分], [当前积分])
SELECT A.VIP, SUM(A.IntegralAmount), SUM(A.Integral)
FROM ##8268ef8fa55d4595982514956bfafa88 A
GROUP BY A.VIP


    时间: 2023-05-31 15:57:17,325
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [消费积分])
SELECT A.Vip_Card, SUM(A.IntegralAmount) 
FROM [vn_Check] A
WHERE A.Posted = 1
AND  A.CheckDate>='2023/4/30' AND A.CheckDate<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2023-05-31 15:57:17,371
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [增提积分])
SELECT A.VIP, SUM(A.Integral)
FROM [VIPAddIntegral] A
WHERE A.Posted = 1
AND  A.VipAddIntegral_Date>='2023/4/30' AND A.VipAddIntegral_Date<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.VIP) 
GROUP BY A.VIP, A.VipAddIntegralID, A.VipAddIntegral_Date


    时间: 2023-05-31 15:57:17,387
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [积分换购])
SELECT A.VIP, SUM(A.Amount)
FROM [VipIntegralExchange] A
WHERE A.Posted = 1
AND  A.ExchangeDate>='2023/4/30' AND A.ExchangeDate<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-05-31 15:57:17,397
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [抵减积分])
SELECT A.Vip_Card, SUM(B.Integral)
FROM [vn_Check] A
INNER JOIN CheckCounteractIntegral B ON A.CheckId=B.CheckId
WHERE A.Posted = 1
AND A.CheckDate>='2023/4/30' AND A.CheckDate<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.Vip_Card) 
GROUP BY A.Vip_Card


    时间: 2023-05-31 15:57:17,471
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [积分转入])
SELECT A.TurnInCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2023/4/30' AND A.IntegralTurnCard_Date<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.TurnInCard) 
GROUP BY A.TurnInCard


    时间: 2023-05-31 15:57:17,479
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [积分转出])
SELECT A.TurnOutCard, SUM(A.TurnInIntegral)
FROM [IntegralTurnCard] A
WHERE A.Posted = 1
AND  A.IntegralTurnCard_Date>='2023/4/30' AND A.IntegralTurnCard_Date<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.TurnOutCard) 
GROUP BY A.TurnOutCard


    时间: 2023-05-31 15:57:17,487
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##6ee01aa28c3b49fea35248af285222f9 ([卡号], [零售订单积分])
SELECT A.VIP, SUM(A.Integral)
FROM [KS2_RetailOrderIntegral] A
WHERE 1 = 1
AND  A.InputTime>='2023/4/30' AND A.InputTime<='2023/5/30 23:59:59'
AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE VIP=A.VIP) 
GROUP BY A.VIP


    时间: 2023-05-31 15:57:17,498
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6ee01aa28c3b49fea35248af285222f9 SET [本期积分] = ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0)


    时间: 2023-05-31 15:57:17,505
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6ee01aa28c3b49fea35248af285222f9 SET [累计积分] = ISNULL([期初积分],0) + ISNULL([消费积分],0) - ISNULL([抵减积分],0) - ISNULL([积分换购],0) + ISNULL([金额充值赠送],0) + ISNULL([增提积分],0) + ISNULL([积分转入],0) - ISNULL([积分转出],0) + ISNULL([零售订单积分],0)


    时间: 2023-05-31 15:57:17,519
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 A.Vip
, CAST(NULL AS VARCHAR(10)) AS [首次消费日期]
, CAST(NULL AS VARCHAR(10)) AS [最后消费日期]
, CAST(NULL AS VARCHAR(50)) AS [最后消费渠道]
, CAST(NULL AS DECIMAL(30,2)) AS [消费金额]
, CAST(NULL AS DECIMAL(30,2)) AS [累计消费金额]
, CAST(NULL AS NVARCHAR(50)) AS [活跃度]
, CAST(NULL AS INT) AS [活跃度2]
INTO [##742308d22d284fa7bb831bbcafcfc724]
FROM CustomerVip A


    时间: 2023-05-31 15:57:17,521
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO ##742308d22d284fa7bb831bbcafcfc724(Vip,活跃度)
SELECT A.Vip,'深度休眠' FROM ##7837beb815e4486c81c363bce21d4742 A 
INNER JOIN CustomerVip B ON A.Vip = B.Vip 
WHERE EXISTS(SELECT 1 FROM ##98072a8ae6a84f5d9c2a45424c39ee82 C WHERE B.Customer_ID = C.Customer_ID)


    时间: 2023-05-31 15:57:17,544
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteData 
AS (
    SELECT a.VIP_Card VIP, MIN(a.CheckDate) AS MinDate, MAX(a.CheckDate) AS MaxDate 
    FROM vn_check a 
       WHERE ISNULL(A.Posted,0) = 1 
           AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 B WHERE a.VIP_Card = B.Vip) 
    GROUP BY a.VIP_Card
)
UPDATE A SET A.首次消费日期 = CONVERT(VARCHAR(10),B.MinDate,120)
      ,A.最后消费日期 = CONVERT(VARCHAR(10),B.MaxDate,120)
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
INNER JOIN cteData B ON A.Vip = B.VIP


    时间: 2023-05-31 15:57:17,682
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteSaleData 
AS (
   SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount 
         FROM vn_check a 
             INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID
             INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID
         WHERE a.Posted = 1 
           AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE Vip = a.VIP_Card ) 
           AND a.CheckDate>'2023/4/29' and a.CheckDate<'2023/5/31' 
         GROUP BY a.VIP_Card
)
UPDATE A SET A.消费金额 = B.Amount
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
INNER JOIN cteSaleData B ON A.Vip = B.Vip


    时间: 2023-05-31 15:57:17,744
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteSaleData 
AS (
   SELECT a.VIP_Card Vip, SUM(ISNULL(b.DiscountPrice, 0) * (ISNULL([S1], 0))) Amount 
         FROM vn_check a 
             INNER JOIN VN_CheckGoods b ON a.CheckID = b.CheckID
             INNER JOIN VN_CheckDetail c ON b.CheckGoodsID = c.CheckGoodsID
         WHERE a.Posted = 1 
           AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 WHERE Vip = a.VIP_Card ) 
         GROUP BY a.VIP_Card
)
UPDATE A SET A.累计消费金额 = B.Amount
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
INNER JOIN cteSaleData B ON A.Vip = B.Vip


    时间: 2023-05-31 15:57:17,855
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH cteLastSale
AS (
    SELECT a.Customer_ID, a.VIP_Card VIP, MAX(A.CheckDate) AS CheckDate
    FROM vn_Check a 
    WHERE ISNULL(a.Posted,0) = 1
       AND EXISTS(SELECT 1 FROM ##7837beb815e4486c81c363bce21d4742 B WHERE a.VIP_Card = B.Vip) 
    GROUP BY a.Customer_ID, a.VIP_Card
)
,cteMax 
AS (
    SELECT Vip, MAX(CheckDate) AS CheckDate
    FROM cteLastSale 
    GROUP BY Vip
)
,cteSet
AS (
    SELECT A.* 
    FROM cteLastSale A 
    WHERE EXISTS(SELECT 1 FROM cteMax B WHERE A.Vip = B.Vip AND A.CheckDate = B.CheckDate)
)
UPDATE A SET A.最后消费渠道 = C.Abbrev 
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
INNER JOIN cteSet B ON A.Vip = B.Vip 
INNER JOIN Customer C ON B.Customer_ID = C.Customer_ID 


    时间: 2023-05-31 15:57:18,240
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.Vip = A.Vip
      ,A.活跃度2 = DATEDIFF(DAY,CAST(A.最后消费日期 AS DATETIME),GETDATE())
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
WHERE ISNULL(A.最后消费日期,'') != ''


    时间: 2023-05-31 15:57:18,254
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '活跃'
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) <= 90 


    时间: 2023-05-31 15:57:18,260
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '较活跃'
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 90 
AND CAST(A.活跃度2 AS INT) < 180 


    时间: 2023-05-31 15:57:18,264
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '警戒'
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 180 
AND CAST(A.活跃度2 AS INT) < 365 


    时间: 2023-05-31 15:57:18,269
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '休眠'
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 365 
AND CAST(A.活跃度2 AS INT) < 730 


    时间: 2023-05-31 15:57:18,278
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.活跃度 = '深度休眠'
FROM ##742308d22d284fa7bb831bbcafcfc724 A 
WHERE ISNULL(A.最后消费日期,'') != ''
AND CAST(A.活跃度2 AS INT) >= 730 


    时间: 2023-05-31 15:57:18,281
  线程ID: 102
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber ,Vip.VIP AS [VIP卡号], CV.Name AS [VIP姓名], B.首次消费日期 AS [首次消费日期], B.最后消费日期 AS [最后消费日期], B.最后消费渠道 AS [最后消费渠道], B.累计消费金额 AS [累计消费金额], SUM(可用积分) AS [可用积分], SUM(累计积分) AS [累计积分], SUM(当前积分) AS [当前积分] 
   INTO tempdb.dbo.[ca26eaf6-c6d9-49e2-9189-ba3ba4c8ec49] 
 FROM [##7837beb815e4486c81c363bce21d4742] Vip
 LEFT JOIN [##6ee01aa28c3b49fea35248af285222f9] A ON Vip.VIP=A.[卡号]
 LEFT JOIN [##742308d22d284fa7bb831bbcafcfc724] B ON Vip.VIP=B.Vip
 LEFT JOIN CustomerVIP CV ON Vip.VIP=CV.VIP
 LEFT JOIN Customer CV1 ON CV.Customer_ID=CV1.Customer_ID
GROUP BY  Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.累计消费金额
HAVING 1=1
ORDER BY  Vip.VIP, CV.Name, B.首次消费日期, B.最后消费日期, B.最后消费渠道, B.累计消费金额


    时间: 2023-05-31 17:15:12,530
  线程ID: 27
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[f3f9b03e-233c-447b-a4f6-7635ba75abfc]
FROM [##ca73020b24ea4ff6bcdeb29c9ecb866f]
ORDER BY Goods_no


    时间: 2023-05-31 17:15:43,684
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##b04297283b5f4cbb923a7bed9064a702]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-31 17:15:44,088
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##20801ebcb51744d3aa924d4948d190e9] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-31 17:15:44,089
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b04297283b5f4cbb923a7bed9064a702] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##20801ebcb51744d3aa924d4948d190e9]


    时间: 2023-05-31 17:15:44,154
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##46fe7c3a37b94b4dafda486775e136c8 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-31 17:15:44,156
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##46fe7c3a37b94b4dafda486775e136c8 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-31 17:15:44,158
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##46fe7c3a37b94b4dafda486775e136c8 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 = '退货' 


    时间: 2023-05-31 17:15:44,185
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##46fe7c3a37b94b4dafda486775e136c8 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-31 17:15:44,186
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##46fe7c3a37b94b4dafda486775e136c8 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-31 17:15:44,190
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b04297283b5f4cbb923a7bed9064a702] (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 [##473838bb8614427f84c76e5534307ab7]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-31 17:15:44,199
  线程ID: 67
日志级别: 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.[5be1a249-a311-44bc-9724-930635772400]
FROM ##b04297283b5f4cbb923a7bed9064a702 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


    时间: 2023-05-31 18:06:54,809
  线程ID: 112
日志级别: 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.[81c0275c-3ee7-4660-b0b4-f0498fe4d7ab]
FROM [##9c9df26b253e430fb847fca60a00e9ba]
ORDER BY Goods_no


    时间: 2023-05-31 18:07:16,936
  线程ID: 81
日志级别: 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 [##0084ca8ecd694f95ad567fa2d677dbcf]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-31 18:07:17,321
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d26245b4c1e14b5fb85fe64efd01a132] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-31 18:07:17,323
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0084ca8ecd694f95ad567fa2d677dbcf] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d26245b4c1e14b5fb85fe64efd01a132]


    时间: 2023-05-31 18:07:17,379
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##a1dbdd1434264029bdea8a487b268e60 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-31 18:07:17,382
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a1dbdd1434264029bdea8a487b268e60 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-31 18:07:17,382
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##a1dbdd1434264029bdea8a487b268e60 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 = '退货' 


    时间: 2023-05-31 18:07:17,410
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a1dbdd1434264029bdea8a487b268e60 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-31 18:07:17,411
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a1dbdd1434264029bdea8a487b268e60 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-31 18:07:17,414
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0084ca8ecd694f95ad567fa2d677dbcf] (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 [##b7c95bc1db5847a5bd153341530a8655]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-31 18:07:17,418
  线程ID: 81
日志级别: 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.[ac3b2d88-5a6f-4068-bbc8-224766b19b32]
FROM ##0084ca8ecd694f95ad567fa2d677dbcf 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


    时间: 2023-05-31 18:07:43,200
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##82c76523b76c45e484ee11a8d9d54d7c] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##82c76523b76c45e484ee11a8d9d54d7c] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##7c3659f22c6e457ea62c98c05e6173d7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##82c76523b76c45e484ee11a8d9d54d7c] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##82c76523b76c45e484ee11a8d9d54d7c] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##7c3659f22c6e457ea62c98c05e6173d7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##82c76523b76c45e484ee11a8d9d54d7c] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##82c76523b76c45e484ee11a8d9d54d7c] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##7c3659f22c6e457ea62c98c05e6173d7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##82c76523b76c45e484ee11a8d9d54d7c] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##7c3659f22c6e457ea62c98c05e6173d7] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##82c76523b76c45e484ee11a8d9d54d7c] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##82c76523b76c45e484ee11a8d9d54d7c] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##7c3659f22c6e457ea62c98c05e6173d7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:07:43,746
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##82c76523b76c45e484ee11a8d9d54d7c] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:07:52,647
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##bf5945721d57495bba9d0a53695577ed] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##bf5945721d57495bba9d0a53695577ed] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##53b0da7e786244d18e7f93d1399ec622] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##bf5945721d57495bba9d0a53695577ed] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##bf5945721d57495bba9d0a53695577ed] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##53b0da7e786244d18e7f93d1399ec622] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##bf5945721d57495bba9d0a53695577ed] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##bf5945721d57495bba9d0a53695577ed] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##53b0da7e786244d18e7f93d1399ec622] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##bf5945721d57495bba9d0a53695577ed] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##53b0da7e786244d18e7f93d1399ec622] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##bf5945721d57495bba9d0a53695577ed] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##bf5945721d57495bba9d0a53695577ed] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##53b0da7e786244d18e7f93d1399ec622] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:07:53,232
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##bf5945721d57495bba9d0a53695577ed] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:11:43,968
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##c358c335560f4361b861cc307434955c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-31 18:11:44,352
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d1c63f41e9f34d24849535e6d442e8b0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-31 18:11:44,354
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c358c335560f4361b861cc307434955c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d1c63f41e9f34d24849535e6d442e8b0]


    时间: 2023-05-31 18:11:44,410
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##4eb5a197abe242ed9a51b28224151ffa a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-31 18:11:44,413
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4eb5a197abe242ed9a51b28224151ffa SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-31 18:11:44,414
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##4eb5a197abe242ed9a51b28224151ffa 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 = '退货' 


    时间: 2023-05-31 18:11:44,441
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4eb5a197abe242ed9a51b28224151ffa SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-31 18:11:44,443
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4eb5a197abe242ed9a51b28224151ffa SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-31 18:11:44,446
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c358c335560f4361b861cc307434955c] (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 [##96358ef3ba174aadb81dbe6d688f4cbf]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-31 18:11:44,450
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[ac3b2d88-5a6f-4068-bbc8-224766b19b32]
FROM ##c358c335560f4361b861cc307434955c 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


    时间: 2023-05-31 18:13:13,752
  线程ID: 45
日志级别: 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.[81c0275c-3ee7-4660-b0b4-f0498fe4d7ab]
FROM [##6b07c31694d3469fa7fb03f057bcaf09]
ORDER BY Goods_no


    时间: 2023-05-31 18:13:29,956
  线程ID: 69
日志级别: 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 [##106d722d0fdb4e7984aa67ca1bbc261e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-31 18:13:30,286
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f635ad4545534b679669d94f1c25bfb9] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-31 18:13:30,289
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##106d722d0fdb4e7984aa67ca1bbc261e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f635ad4545534b679669d94f1c25bfb9]


    时间: 2023-05-31 18:13:30,344
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##a77c7bf950044d5492df7e2ecda26abd a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-31 18:13:30,346
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a77c7bf950044d5492df7e2ecda26abd SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-31 18:13:30,348
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##a77c7bf950044d5492df7e2ecda26abd 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 = '退货' 


    时间: 2023-05-31 18:13:30,375
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a77c7bf950044d5492df7e2ecda26abd SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-31 18:13:30,376
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a77c7bf950044d5492df7e2ecda26abd SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-31 18:13:30,379
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##106d722d0fdb4e7984aa67ca1bbc261e] (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 [##467dded17cd541c88f8d99e92091e38b]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-31 18:13:30,382
  线程ID: 69
日志级别: 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.[ac3b2d88-5a6f-4068-bbc8-224766b19b32]
FROM ##106d722d0fdb4e7984aa67ca1bbc261e 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


    时间: 2023-05-31 18:15:07,177
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1032f44dcc564f5bbdb9ef0152f591b7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1032f44dcc564f5bbdb9ef0152f591b7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##1032f44dcc564f5bbdb9ef0152f591b7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##1032f44dcc564f5bbdb9ef0152f591b7] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1032f44dcc564f5bbdb9ef0152f591b7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:15:07,677
  线程ID: 41
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##a7a2a1132ffc42dca9be18985ea9d4c6] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:15:11,152
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##65b46e0736d041f3aa89574e5515b084] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##65b46e0736d041f3aa89574e5515b084] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##8746c328095c46eeac3e45ce7cc287fd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##65b46e0736d041f3aa89574e5515b084] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##65b46e0736d041f3aa89574e5515b084] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##8746c328095c46eeac3e45ce7cc287fd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##65b46e0736d041f3aa89574e5515b084] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##65b46e0736d041f3aa89574e5515b084] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##8746c328095c46eeac3e45ce7cc287fd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##65b46e0736d041f3aa89574e5515b084] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##8746c328095c46eeac3e45ce7cc287fd] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##65b46e0736d041f3aa89574e5515b084] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##65b46e0736d041f3aa89574e5515b084] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##8746c328095c46eeac3e45ce7cc287fd] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:15:11,649
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##65b46e0736d041f3aa89574e5515b084] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:15:21,514
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##6795c4585926403d8ae9949a599904a5] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##6795c4585926403d8ae9949a599904a5] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##6dc9975f76284d148c8f2d15965e6a46] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##6795c4585926403d8ae9949a599904a5] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##6795c4585926403d8ae9949a599904a5] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##6dc9975f76284d148c8f2d15965e6a46] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##6795c4585926403d8ae9949a599904a5] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##6795c4585926403d8ae9949a599904a5] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##6dc9975f76284d148c8f2d15965e6a46] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##6795c4585926403d8ae9949a599904a5] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##6dc9975f76284d148c8f2d15965e6a46] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##6795c4585926403d8ae9949a599904a5] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##6795c4585926403d8ae9949a599904a5] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##6dc9975f76284d148c8f2d15965e6a46] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:15:22,018
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##6795c4585926403d8ae9949a599904a5] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:15:31,301
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7982b943d16d49bb893023f7e32fe0be] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##7982b943d16d49bb893023f7e32fe0be] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##f49db03fe03240fba6d5af56f5d1a2d5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##7982b943d16d49bb893023f7e32fe0be] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##7982b943d16d49bb893023f7e32fe0be] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f49db03fe03240fba6d5af56f5d1a2d5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##7982b943d16d49bb893023f7e32fe0be] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##7982b943d16d49bb893023f7e32fe0be] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##f49db03fe03240fba6d5af56f5d1a2d5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##7982b943d16d49bb893023f7e32fe0be] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##f49db03fe03240fba6d5af56f5d1a2d5] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##7982b943d16d49bb893023f7e32fe0be] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##7982b943d16d49bb893023f7e32fe0be] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##f49db03fe03240fba6d5af56f5d1a2d5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:15:31,803
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##7982b943d16d49bb893023f7e32fe0be] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:15:45,165
  线程ID: 69
日志级别: 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.[81c0275c-3ee7-4660-b0b4-f0498fe4d7ab]
FROM [##40ad4d7b694c4b9fb632445361888814]
ORDER BY Goods_no


    时间: 2023-05-31 18:15:58,275
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##9289d90d90c04b2c9721062322f9197e] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##9289d90d90c04b2c9721062322f9197e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##41615eeb90f24bc09716b31cd50900f8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##9289d90d90c04b2c9721062322f9197e] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##9289d90d90c04b2c9721062322f9197e] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##41615eeb90f24bc09716b31cd50900f8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##9289d90d90c04b2c9721062322f9197e] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##9289d90d90c04b2c9721062322f9197e] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##41615eeb90f24bc09716b31cd50900f8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##9289d90d90c04b2c9721062322f9197e] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
     AND EXISTS (SELECT 1 FROM [##41615eeb90f24bc09716b31cd50900f8] WHERE Goods_No = R.Goods_No)
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##9289d90d90c04b2c9721062322f9197e] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##9289d90d90c04b2c9721062322f9197e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##41615eeb90f24bc09716b31cd50900f8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-05-31 18:15:58,810
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[65738e2c-8ee4-4dea-8c05-3d5476d41389]
 FROM [##9289d90d90c04b2c9721062322f9197e] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-05-31 18:21:16,677
  线程ID: 69
日志级别: 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 [##1186000cf28e42a3b24db88ab578b518]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-31 18:21:17,066
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##9f81b542dcf94c2c9dd043e119a90c7b] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-31 18:21:17,068
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1186000cf28e42a3b24db88ab578b518] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##9f81b542dcf94c2c9dd043e119a90c7b]


    时间: 2023-05-31 18:21:17,126
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b5f943af119d47aeac28579b0c4c3c3a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-31 18:21:17,128
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5f943af119d47aeac28579b0c4c3c3a SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-31 18:21:17,130
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b5f943af119d47aeac28579b0c4c3c3a 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 = '退货' 


    时间: 2023-05-31 18:21:17,158
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5f943af119d47aeac28579b0c4c3c3a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-31 18:21:17,159
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5f943af119d47aeac28579b0c4c3c3a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-31 18:21:17,162
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1186000cf28e42a3b24db88ab578b518] (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 [##d4e11c5c4d6446cca1c0ee33ea54697f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-31 18:21:17,165
  线程ID: 69
日志级别: 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.[ac3b2d88-5a6f-4068-bbc8-224766b19b32]
FROM ##1186000cf28e42a3b24db88ab578b518 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