时间: 2021-03-31 10:05:23,752
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##02987a01ae8c408aa81054dc6a607bed]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 10:05:24,191
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##02987a01ae8c408aa81054dc6a607bed] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##86d63d3b7dc649f887dfcd8899d808d6] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-31 10:07:13,750
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##c818f33312ba49319812cb0078c2e6d7]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 10:07:14,055
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##c818f33312ba49319812cb0078c2e6d7] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##0ddc1c22e9774d6eb0df354b2976735a] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-31 10:08:23,198
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##d2095e65b9414e5fb2b102653c6aa003]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 10:08:23,516
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d2095e65b9414e5fb2b102653c6aa003] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##c08a51846d3348de9b6676bb7f84fd09] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-31 10:08:36,086
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##fcbc06d04def4d1c9fb848d38c235904]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 10:08:36,385
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fcbc06d04def4d1c9fb848d38c235904] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##7e60c6f2c9a64e0d913a566ad4442c53] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-31 10:08:59,287
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##4919cf835d874d59a45c03cc0fdf5079]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 10:08:59,607
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##4919cf835d874d59a45c03cc0fdf5079] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##2ce8d9f318324b7780c5db1c782c1a31] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-31 10:20:56,968
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##4d93bf26bcf74c80a8e9ee6398b2734c ADD 销售类型 VARCHAR(50)

    时间: 2021-03-31 10:20:56,976
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##4d93bf26bcf74c80a8e9ee6398b2734c a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-03-31 10:20:56,985
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d93bf26bcf74c80a8e9ee6398b2734c SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-03-31 10:20:56,992
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##4d93bf26bcf74c80a8e9ee6398b2734c 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-03-31 10:20:57,032
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d93bf26bcf74c80a8e9ee6398b2734c SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-03-31 10:20:57,035
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4d93bf26bcf74c80a8e9ee6398b2734c SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-03-31 10:20:57,094
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##4d93bf26bcf74c80a8e9ee6398b2734c

    时间: 2021-03-31 10:21:05,976
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##1a31d58dbe5b4a1eae5e5d7cd4ced02f ADD 销售类型 VARCHAR(50)

    时间: 2021-03-31 10:21:05,977
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##1a31d58dbe5b4a1eae5e5d7cd4ced02f a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-03-31 10:21:05,986
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1a31d58dbe5b4a1eae5e5d7cd4ced02f SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-03-31 10:21:05,992
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##1a31d58dbe5b4a1eae5e5d7cd4ced02f 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-03-31 10:21:06,034
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1a31d58dbe5b4a1eae5e5d7cd4ced02f SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-03-31 10:21:06,037
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##1a31d58dbe5b4a1eae5e5d7cd4ced02f SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-03-31 10:21:06,096
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##1a31d58dbe5b4a1eae5e5d7cd4ced02f

    时间: 2021-03-31 10:22:24,610
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##306ce9d737ea44bb8053e8d355d15af5 ADD 销售类型 VARCHAR(50)

    时间: 2021-03-31 10:22:24,612
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##306ce9d737ea44bb8053e8d355d15af5 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-03-31 10:22:24,621
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##306ce9d737ea44bb8053e8d355d15af5 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-03-31 10:22:24,627
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##306ce9d737ea44bb8053e8d355d15af5 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-03-31 10:22:24,666
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##306ce9d737ea44bb8053e8d355d15af5 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-03-31 10:22:24,669
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##306ce9d737ea44bb8053e8d355d15af5 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-03-31 10:22:24,734
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##306ce9d737ea44bb8053e8d355d15af5

    时间: 2021-03-31 10:22:38,344
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##b350f89d7199482980df549cead95e83 ADD 销售类型 VARCHAR(50)

    时间: 2021-03-31 10:22:38,345
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##b350f89d7199482980df549cead95e83 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-03-31 10:22:38,352
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b350f89d7199482980df549cead95e83 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-03-31 10:22:38,357
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##b350f89d7199482980df549cead95e83 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-03-31 10:22:38,396
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b350f89d7199482980df549cead95e83 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-03-31 10:22:38,398
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b350f89d7199482980df549cead95e83 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-03-31 10:22:38,463
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##b350f89d7199482980df549cead95e83

    时间: 2021-03-31 14:13:38,259
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d6b310a5196646bd9e3b7f7e8000960d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-03-31 14:13:38,265
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d6b310a5196646bd9e3b7f7e8000960d] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##d6b310a5196646bd9e3b7f7e8000960d].DealereturnID = DealereturnID)


    时间: 2021-03-31 14:13:38,352
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d6b310a5196646bd9e3b7f7e8000960d] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##d6b310a5196646bd9e3b7f7e8000960d] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-03-31 14:13:38,359
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##d6b310a5196646bd9e3b7f7e8000960d] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##d6b310a5196646bd9e3b7f7e8000960d WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##8cb5f130ffa443d290a8e9152db6cdff] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-03-31 14:13:38,476
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d6b310a5196646bd9e3b7f7e8000960d] SET ReceiveQuantity = B.Quantity 
 FROM [##d6b310a5196646bd9e3b7f7e8000960d] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##d6b310a5196646bd9e3b7f7e8000960d WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##8cb5f130ffa443d290a8e9152db6cdff] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-03-31 14:13:38,643
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##d6b310a5196646bd9e3b7f7e8000960d] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-03-31 14:13:38,646
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[77e2ee3d-5e06-4677-baae-f9f8e4e72b70]
 FROM [##d6b310a5196646bd9e3b7f7e8000960d]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-03-31 14:13:42,653
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##fbb751db4d2748f69e6ea49e51075f66] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-03-31 14:13:42,658
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##fbb751db4d2748f69e6ea49e51075f66] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##fbb751db4d2748f69e6ea49e51075f66].DealereturnID = DealereturnID)


    时间: 2021-03-31 14:13:42,743
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##fbb751db4d2748f69e6ea49e51075f66] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##fbb751db4d2748f69e6ea49e51075f66] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-03-31 14:13:42,750
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##fbb751db4d2748f69e6ea49e51075f66] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##fbb751db4d2748f69e6ea49e51075f66 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##74e74e16e915439baa29437c9f02a025] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-03-31 14:13:42,873
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##fbb751db4d2748f69e6ea49e51075f66] SET ReceiveQuantity = B.Quantity 
 FROM [##fbb751db4d2748f69e6ea49e51075f66] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##fbb751db4d2748f69e6ea49e51075f66 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##74e74e16e915439baa29437c9f02a025] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-03-31 14:13:43,031
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##fbb751db4d2748f69e6ea49e51075f66] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-03-31 14:13:43,033
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[77e2ee3d-5e06-4677-baae-f9f8e4e72b70]
 FROM [##fbb751db4d2748f69e6ea49e51075f66]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-03-31 14:13:43,556
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d6c574626ddf49f5b17b735749591678] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-03-31 14:13:43,561
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d6c574626ddf49f5b17b735749591678] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##d6c574626ddf49f5b17b735749591678].DealereturnID = DealereturnID)


    时间: 2021-03-31 14:13:43,643
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d6c574626ddf49f5b17b735749591678] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##d6c574626ddf49f5b17b735749591678] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-03-31 14:13:43,650
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##d6c574626ddf49f5b17b735749591678] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##d6c574626ddf49f5b17b735749591678 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##18c11e451e844f70834408c1618b2f7d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-03-31 14:13:43,776
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d6c574626ddf49f5b17b735749591678] SET ReceiveQuantity = B.Quantity 
 FROM [##d6c574626ddf49f5b17b735749591678] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##d6c574626ddf49f5b17b735749591678 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##18c11e451e844f70834408c1618b2f7d] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-03-31 14:13:43,941
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##d6c574626ddf49f5b17b735749591678] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-03-31 14:13:43,943
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[77e2ee3d-5e06-4677-baae-f9f8e4e72b70]
 FROM [##d6c574626ddf49f5b17b735749591678]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-03-31 14:13:44,521
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##4c4d6f0c84564b4db2ad20ccd62c7c18] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-03-31 14:13:44,526
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4c4d6f0c84564b4db2ad20ccd62c7c18] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##4c4d6f0c84564b4db2ad20ccd62c7c18].DealereturnID = DealereturnID)


    时间: 2021-03-31 14:13:44,607
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4c4d6f0c84564b4db2ad20ccd62c7c18] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##4c4d6f0c84564b4db2ad20ccd62c7c18] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-03-31 14:13:44,614
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##4c4d6f0c84564b4db2ad20ccd62c7c18] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##4c4d6f0c84564b4db2ad20ccd62c7c18 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##e322c624635e4d519d4fc36c76195f9f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-03-31 14:13:44,738
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4c4d6f0c84564b4db2ad20ccd62c7c18] SET ReceiveQuantity = B.Quantity 
 FROM [##4c4d6f0c84564b4db2ad20ccd62c7c18] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##4c4d6f0c84564b4db2ad20ccd62c7c18 WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##e322c624635e4d519d4fc36c76195f9f] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-03-31 14:13:44,896
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##4c4d6f0c84564b4db2ad20ccd62c7c18] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-03-31 14:13:44,898
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[77e2ee3d-5e06-4677-baae-f9f8e4e72b70]
 FROM [##4c4d6f0c84564b4db2ad20ccd62c7c18]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-03-31 14:13:45,434
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2aba74ffb7ce4da0984a7136ced97a2f] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CShopRtn' AND A.DealereturnID = BillNo )


    时间: 2021-03-31 14:13:45,440
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2aba74ffb7ce4da0984a7136ced97a2f] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT DealereturnID FROM Pureceipt 
      WHERE Type = 3 AND [##2aba74ffb7ce4da0984a7136ced97a2f].DealereturnID = DealereturnID)


    时间: 2021-03-31 14:13:45,526
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2aba74ffb7ce4da0984a7136ced97a2f] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END  
                              , IsReceive = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 0 ELSE 1 END  
 FROM [##2aba74ffb7ce4da0984a7136ced97a2f] A INNER JOIN  Pureceipt B ON A.DealereturnID = B.DealereturnID
 WHERE B.Type = 3 


    时间: 2021-03-31 14:13:45,533
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2aba74ffb7ce4da0984a7136ced97a2f] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [DealeReturnGoods] A 
             INNER JOIN DealeReturn B ON A.DealereturnID = B.DealereturnID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.Customer_ID = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##2aba74ffb7ce4da0984a7136ced97a2f WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##f74e2d070a1c440db9b3b5aae758c6c1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2021-03-31 14:13:45,658
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2aba74ffb7ce4da0984a7136ced97a2f] SET ReceiveQuantity = B.Quantity 
 FROM [##2aba74ffb7ce4da0984a7136ced97a2f] A INNER JOIN 
     ( SELECT A.DealereturnID,SUM(C.Quantity) As Quantity 
       FROM Pureceipt A 
            INNER JOIN PureceiptSSGoods C ON A.PureceiptID = C.PureceiptID 
        WHERE EXISTS( SELECT 1 FROM ##2aba74ffb7ce4da0984a7136ced97a2f WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##f74e2d070a1c440db9b3b5aae758c6c1] WHERE Goods_No = C.Goods_No)
       GROUP BY A.DealereturnID 
      ) B ON A.DealereturnID = B.DealereturnID 


    时间: 2021-03-31 14:13:45,820
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##2aba74ffb7ce4da0984a7136ced97a2f] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0) 

    时间: 2021-03-31 14:13:45,822
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DealereturnID AS [单号], Manual_ID AS [手工单号], Return_Date AS [日期]
, rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号]
, Abbrev AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , ReceiveQuantity AS [业务状态#收退货数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[77e2ee3d-5e06-4677-baae-f9f8e4e72b70]
 FROM [##2aba74ffb7ce4da0984a7136ced97a2f]
 ORDER BY Return_Date DESC, DealereturnID ASC


    时间: 2021-03-31 16:59:22,882
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##c9435fffe40b462d86fce19e8939420b ADD 销售类型 VARCHAR(50)

    时间: 2021-03-31 16:59:22,884
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##c9435fffe40b462d86fce19e8939420b a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-03-31 16:59:22,896
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c9435fffe40b462d86fce19e8939420b SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-03-31 16:59:22,904
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##c9435fffe40b462d86fce19e8939420b 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.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-03-31 16:59:22,972
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c9435fffe40b462d86fce19e8939420b SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-03-31 16:59:22,976
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c9435fffe40b462d86fce19e8939420b SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-03-31 16:59:23,048
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##c9435fffe40b462d86fce19e8939420b

    时间: 2021-03-31 17:02:16,134
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[f3076b28-151d-4acf-82d4-26fe4bb2e98a]
FROM [##a580b02fae414f7685b1150673890d5d]
ORDER BY Goods_no


    时间: 2021-03-31 17:03:30,021
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##ea69aacf7e704ba097e37fb0379d5a6f]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 17:03:30,284
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ea69aacf7e704ba097e37fb0379d5a6f] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##e422b7eeb8eb4ce4a2d98dbb78ea885e] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-31 17:03:44,945
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##1489e61cffb04d6b84c68e6569da1118]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-31 17:03:45,211
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1489e61cffb04d6b84c68e6569da1118] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##63b2200d8cb746fca61dc6f4f649af2e] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID