时间: 2023-05-06 11:14:38,186
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d701f2affba04fbeb18d261df39af79d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2023-05-06 11:14:38,194
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d701f2affba04fbeb18d261df39af79d] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##d701f2affba04fbeb18d261df39af79d] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2023-05-06 11:14:38,200
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##d701f2affba04fbeb18d261df39af79d] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2023-05-06 11:14:38,209
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##d701f2affba04fbeb18d261df39af79d] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2023-05-06 11:14:38,218
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##d701f2affba04fbeb18d261df39af79d A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##d701f2affba04fbeb18d261df39af79d WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##65963f6dce2a4f0cb09f9ace3810cef2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2023-05-06 11:14:38,292
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##d701f2affba04fbeb18d261df39af79d A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##d701f2affba04fbeb18d261df39af79d WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##65963f6dce2a4f0cb09f9ace3810cef2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2023-05-06 11:14:38,368
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##d701f2affba04fbeb18d261df39af79d A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##d701f2affba04fbeb18d261df39af79d WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##65963f6dce2a4f0cb09f9ace3810cef2] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2023-05-06 11:14:38,496
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##d701f2affba04fbeb18d261df39af79d A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##d701f2affba04fbeb18d261df39af79d WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##65963f6dce2a4f0cb09f9ace3810cef2] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2023-05-06 11:14:38,834
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##d701f2affba04fbeb18d261df39af79d A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##d701f2affba04fbeb18d261df39af79d C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##65963f6dce2a4f0cb09f9ace3810cef2] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2023-05-06 11:14:39,086
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##d701f2affba04fbeb18d261df39af79d
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2023-05-06 11:14:39,088
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##d701f2affba04fbeb18d261df39af79d] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##d701f2affba04fbeb18d261df39af79d] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2023-05-06 11:14:39,124
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号]
, Delivery_Date AS [日期], Mode AS [出货方式], OrderID AS [订货单号], SortingID AS [配货单号]
, CartonID AS [装箱单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
, Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], SaleMan [业务员], FreightCorp AS [货运公司], YunBillID AS [物流单号], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [结算额]
     , OrderQuantity AS [业务状态#订货数], PuReceiptQuantity AS [业务状态#厂家来货数]
     , SortingQuantity AS [业务状态#配货数], BoxCount [业务状态#箱数], ReceiveQuantity AS [业务状态#渠道收货数]
     , ChangeQuantity AS [业务状态#渠道收货差异],ChangeWarehouse AS [业务状态#仓库收货差异], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[ef983c67-fde7-49a5-a1af-64f15a293d03]
 FROM [##d701f2affba04fbeb18d261df39af79d]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2023-05-06 11:42:41,153
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##7ca16a41d08c4677a0ab1dbc11b8bbb5] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount,
               SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount
        FROM DeliveryGoods A
        LEFT JOIN Goods G ON A.Goods_No = G.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##7ca16a41d08c4677a0ab1dbc11b8bbb5] WHERE A.DeliveryID = DeliveryID )
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2023-05-06 11:42:41,180
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], 
        rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], 
        Quantity AS [数量],
        DpAmount AS [吊牌额],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[19f95a72-e0c2-40b0-bc45-e2a5273c08c0]
 FROM [##7ca16a41d08c4677a0ab1dbc11b8bbb5] 
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2023-05-06 14:42:07,405
  线程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 [##3f04a6ebbae040c08386d739bb885799]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 14:42:07,731
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##714ffda4341a4f0cb0cc1fd41e50607f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 14:42:07,732
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3f04a6ebbae040c08386d739bb885799] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##714ffda4341a4f0cb0cc1fd41e50607f]


    时间: 2023-05-06 14:42:07,779
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##3614aafba8644277ab7e7a359112e60e a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 14:42:07,781
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3614aafba8644277ab7e7a359112e60e SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 14:42:07,782
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##3614aafba8644277ab7e7a359112e60e 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-06 14:42:07,810
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3614aafba8644277ab7e7a359112e60e SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 14:42:07,811
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3614aafba8644277ab7e7a359112e60e SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 14:42:07,814
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3f04a6ebbae040c08386d739bb885799] (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 [##5331125a3125407e9db88fea9e5b4f67]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 14:42:07,817
  线程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.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##3f04a6ebbae040c08386d739bb885799 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-06 15:30:38,204
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##73c33d43ef874ee9bda51d2fac9291ec]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 15:30:38,554
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##2c10c604e6cf406084d7fd6b10607f0a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 15:30:38,555
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##73c33d43ef874ee9bda51d2fac9291ec] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##2c10c604e6cf406084d7fd6b10607f0a]


    时间: 2023-05-06 15:30:38,605
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##a7934a99a4fd4821a285d2fffd56878d a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-05-06 15:30:38,609
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##a7934a99a4fd4821a285d2fffd56878d 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-06 15:30:38,635
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a7934a99a4fd4821a285d2fffd56878d SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 15:30:38,636
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##a7934a99a4fd4821a285d2fffd56878d SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 15:30:38,640
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##73c33d43ef874ee9bda51d2fac9291ec] (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 [##e4319f3c4835458085b8264fa71dcb1a]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 15:30:38,644
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##73c33d43ef874ee9bda51d2fac9291ec 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-06 16:20:23,635
  线程ID: 73
日志级别: 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 [##518d7f0d2f4b4c479ab797899d1ca918]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:20:24,012
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##18e5f7456dfc41058803bae98fa7404f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:20:24,014
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##518d7f0d2f4b4c479ab797899d1ca918] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##18e5f7456dfc41058803bae98fa7404f]


    时间: 2023-05-06 16:20:24,073
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##adf5f84204cc42aba88edac9b6641dc5 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 16:20:24,075
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##adf5f84204cc42aba88edac9b6641dc5 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 16:20:24,077
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##adf5f84204cc42aba88edac9b6641dc5 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-06 16:20:24,110
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##adf5f84204cc42aba88edac9b6641dc5 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:20:24,111
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##adf5f84204cc42aba88edac9b6641dc5 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:20:24,115
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##518d7f0d2f4b4c479ab797899d1ca918] (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 [##d78fc234e7a949a39fd7aa730f743dc2]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:20:24,119
  线程ID: 73
日志级别: 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.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##518d7f0d2f4b4c479ab797899d1ca918 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-06 16:21:58,256
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##cec9eca4243b4c73b134fab93d6c0696]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:21:58,602
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##cdf96b79d8c44f22aa8273f353fb339d] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:21:58,604
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##cec9eca4243b4c73b134fab93d6c0696] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##cdf96b79d8c44f22aa8273f353fb339d]


    时间: 2023-05-06 16:21:58,655
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##60e40b723ac940d19022e7e813125fdd a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 16:21:58,657
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##60e40b723ac940d19022e7e813125fdd SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 16:21:58,659
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##60e40b723ac940d19022e7e813125fdd 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-06 16:21:58,686
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##60e40b723ac940d19022e7e813125fdd SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:21:58,689
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##60e40b723ac940d19022e7e813125fdd SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:21:58,691
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##cec9eca4243b4c73b134fab93d6c0696] (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 [##d4149053dd2848f8a8cbba71d607ade2]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:21:58,694
  线程ID: 77
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##cec9eca4243b4c73b134fab93d6c0696 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-06 16:22:21,045
  线程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 [##14f86e2dd01d47778628a52f502ccd4e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:22:21,369
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b1aabb278ca848f8b38ea8396a6b028e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:22:21,372
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##14f86e2dd01d47778628a52f502ccd4e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b1aabb278ca848f8b38ea8396a6b028e]


    时间: 2023-05-06 16:22:21,420
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##5b182e96d73e4109bdddc2626090e982 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 16:22:21,421
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5b182e96d73e4109bdddc2626090e982 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 16:22:21,423
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##5b182e96d73e4109bdddc2626090e982 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-06 16:22:21,451
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5b182e96d73e4109bdddc2626090e982 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:22:21,452
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##5b182e96d73e4109bdddc2626090e982 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:22:21,455
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##14f86e2dd01d47778628a52f502ccd4e] (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 [##a40dc143288c4a199468370e2dd60f1f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:22:21,458
  线程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.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##14f86e2dd01d47778628a52f502ccd4e 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-06 16:22:40,086
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [7DayCheckAmount]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [15DayCheckAmount]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [30DayCheckAmount]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , CAST(NULL AS NUMERIC(15, 2)) AS [AllDayCheckAmount]
    , CAST(NULL AS INT) AS [销售#数量], CAST(NULL AS NUMERIC(15, 2)) AS [销售#金额], CAST(C.[S1] AS INT) AS [销售#S1]
    , CAST(NULL AS INT) AS [渠道在途#数量],CAST(C.[S1] AS INT) AS [渠道在途#S1]
    , CAST(NULL AS INT) AS [仓库在途#数量],CAST(C.[S1] AS INT) AS [仓库在途#S1]
    , CAST(NULL AS INT) AS [总库存#数量],CAST(C.[S1] AS INT) AS [总库存#S1]
    , CAST(NULL AS INT) AS [渠道库存(含在途)#数量], CAST(C.[S1] AS INT) AS [渠道库存(含在途)#S1]
    , CAST(NULL AS INT) AS [仓库库存(含在途)#数量], CAST(C.[S1] AS INT) AS [仓库库存(含在途)#S1]
INTO [##6356db12b3f64b7ca343bce10b52c10a]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:22:40,470
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fef8952aa54645aa96f1b3ade9f18bfd] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:22:40,472
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6356db12b3f64b7ca343bce10b52c10a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fef8952aa54645aa96f1b3ade9f18bfd]


    时间: 2023-05-06 16:22:40,527
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##2a64c9e9930f46ebae06c2581d0a61ba a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 16:22:40,534
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2a64c9e9930f46ebae06c2581d0a61ba SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 16:22:40,538
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##2a64c9e9930f46ebae06c2581d0a61ba 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-06 16:22:40,570
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2a64c9e9930f46ebae06c2581d0a61ba SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:22:40,572
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2a64c9e9930f46ebae06c2581d0a61ba SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:22:40,575
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6356db12b3f64b7ca343bce10b52c10a] (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 [##16d5d3d8865145dc93ea3331c6bdfab9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:22:40,581
  线程ID: 78
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##6356db12b3f64b7ca343bce10b52c10a 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-06 16:30:23,330
  线程ID: 74
日志级别: 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.[99fd147c-092b-4909-8096-b6af72f24186]
FROM [##c92542834b31453a8369fc5f8412efc1]
ORDER BY Goods_no


    时间: 2023-05-06 16:31:16,023
  线程ID: 75
日志级别: 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 [##eb434aabe11643c2b5b0455235b54dfc]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:31:16,419
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##071f6bee17cf410695f6d993cdfb67ba] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:31:16,421
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##eb434aabe11643c2b5b0455235b54dfc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##071f6bee17cf410695f6d993cdfb67ba]


    时间: 2023-05-06 16:31:16,476
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##d9d6c67a0c3449b28505cab71d739bc1 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-05-06 16:31:16,480
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##d9d6c67a0c3449b28505cab71d739bc1 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-06 16:31:16,509
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d9d6c67a0c3449b28505cab71d739bc1 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:31:16,510
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##d9d6c67a0c3449b28505cab71d739bc1 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:31:16,513
  线程ID: 75
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##eb434aabe11643c2b5b0455235b54dfc] (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 [##5a95ccce6a68496886f1553b4986015f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:31:16,518
  线程ID: 75
日志级别: 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.[87df6045-ac31-49a1-8365-5600ed5836c1]
FROM ##eb434aabe11643c2b5b0455235b54dfc 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-06 16:34:32,539
  线程ID: 73
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##ddd80d5205734ea18faa5902ba31621c]
ORDER BY Goods_no


    时间: 2023-05-06 16:34:35,827
  线程ID: 62
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##47fd11a730f24a64b2a949bb4ae15184]
ORDER BY Goods_no


    时间: 2023-05-06 16:34:36,588
  线程ID: 75
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##6ee2517df74c4ed39826202c00dfa97f]
ORDER BY Goods_no


    时间: 2023-05-06 16:34:37,014
  线程ID: 65
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##931a1e92779142e0bb7c55019b549757]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:17,995
  线程ID: 73
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##fcaf7b3601f54ef9b5297f51f3ba9dc7]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:20,272
  线程ID: 73
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##858fff6c6c5c493e9c224f6b0aa51dc8]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:20,716
  线程ID: 76
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##338e1544d0d748cfab9756c09dc88c48]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:21,022
  线程ID: 75
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##eb7909fe9a804275bc4fc769f68442d3]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:21,310
  线程ID: 79
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##526a94082a294f3e9052f9e587f2e9ed]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:21,586
  线程ID: 74
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##27915073ca85416dbd74bf4ef1f7a516]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:21,908
  线程ID: 76
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##66d0c205efd1481a841c9387f1edad19]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:22,186
  线程ID: 65
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##ccf0e8617ab34064b00a6c7cc1da1cbd]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:22,566
  线程ID: 74
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##cf3c5d86112748cfa6a7f53756d52502]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:22,887
  线程ID: 75
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##ae928ab695654a61b839bcc5d36cdb43]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:23,210
  线程ID: 73
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##6c56f0f935384ba0b9ebee513778efe3]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:23,533
  线程ID: 74
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##5b8108edee32492c91eb38ceae2113b5]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:30,480
  线程ID: 62
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##66542383523b412ebe63975ed4b140b5]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:30,839
  线程ID: 73
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##b018e55b531840bcaa6d516ddc038c94]
ORDER BY Goods_no


    时间: 2023-05-06 16:35:31,286
  线程ID: 79
日志级别: 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.[a9986216-419f-4871-98f8-4d729ac6c6a4]
FROM [##eee0d7809df04c9d8e4155800544118f]
ORDER BY Goods_no


    时间: 2023-05-06 16:36:06,285
  线程ID: 62
日志级别: 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 [##d7e85096e6184d46a85262451e46b2a9]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:36:06,692
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fede7bd6379f450dbca0a73660ff1b3e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:36:06,693
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d7e85096e6184d46a85262451e46b2a9] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fede7bd6379f450dbca0a73660ff1b3e]


    时间: 2023-05-06 16:36:06,750
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##0af3d26609794a2598ae57c8e4b5dd4a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 16:36:06,752
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##0af3d26609794a2598ae57c8e4b5dd4a SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 16:36:06,754
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##0af3d26609794a2598ae57c8e4b5dd4a 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-06 16:36:06,783
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##0af3d26609794a2598ae57c8e4b5dd4a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:36:06,784
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##0af3d26609794a2598ae57c8e4b5dd4a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:36:06,788
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##d7e85096e6184d46a85262451e46b2a9] (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 [##e1a9448cb36e45f78456b62c03862c17]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:36:06,792
  线程ID: 62
日志级别: 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.[c8d73427-b81c-430d-be83-c7fd1735776f]
FROM ##d7e85096e6184d46a85262451e46b2a9 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-06 16:36:08,396
  线程ID: 73
日志级别: 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 [##0f15fb3cb2884ed191de4de25908beaa]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 16:36:08,781
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##263f3b8292d3400dbc90e1a39154577e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 16:36:08,783
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0f15fb3cb2884ed191de4de25908beaa] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##263f3b8292d3400dbc90e1a39154577e]


    时间: 2023-05-06 16:36:08,839
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b17bf233424f4d888523b38e340cdb3e a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-05-06 16:36:08,841
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b17bf233424f4d888523b38e340cdb3e SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-05-06 16:36:08,843
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b17bf233424f4d888523b38e340cdb3e 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-06 16:36:08,874
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b17bf233424f4d888523b38e340cdb3e SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 16:36:08,875
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b17bf233424f4d888523b38e340cdb3e SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 16:36:08,878
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##0f15fb3cb2884ed191de4de25908beaa] (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 [##d2a243791cf849669c4cddc8028b0195]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 16:36:08,882
  线程ID: 73
日志级别: 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.[c8d73427-b81c-430d-be83-c7fd1735776f]
FROM ##0f15fb3cb2884ed191de4de25908beaa 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-06 17:22:41,754
  线程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 [##39ceb738e66b485b968989e96791c555]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 17:22:42,089
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##def20d33cff94bbf81e049c466018d8b] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 17:22:42,090
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##39ceb738e66b485b968989e96791c555] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##def20d33cff94bbf81e049c466018d8b]


    时间: 2023-05-06 17:22:42,142
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##820b01122bb345348d872140dce51790 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-05-06 17:22:42,145
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##820b01122bb345348d872140dce51790 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-06 17:22:42,173
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##820b01122bb345348d872140dce51790 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 17:22:42,174
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##820b01122bb345348d872140dce51790 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 17:22:42,177
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##39ceb738e66b485b968989e96791c555] (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 [##da2688131ca64707b6cf44705548c06e]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 17:22:42,181
  线程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.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##39ceb738e66b485b968989e96791c555 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-06 17:23:48,702
  线程ID: 62
日志级别: 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 [##27dbb3436db14e558c8aa4eb1f45ce70]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-05-06 17:23:49,076
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b113ef16d4ab42848ce3c87642dea988] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-05-06 17:23:49,078
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##27dbb3436db14e558c8aa4eb1f45ce70] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b113ef16d4ab42848ce3c87642dea988]


    时间: 2023-05-06 17:23:49,127
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##c70af98a91764ccdabf371643447e323 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2023-05-06 17:23:49,130
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##c70af98a91764ccdabf371643447e323 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-06 17:23:49,156
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c70af98a91764ccdabf371643447e323 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-05-06 17:23:49,158
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c70af98a91764ccdabf371643447e323 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-05-06 17:23:49,161
  线程ID: 62
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##27dbb3436db14e558c8aa4eb1f45ce70] (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 [##8580e595fa464b04aea8763b5be83911]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-05-06 17:23:49,164
  线程ID: 62
日志级别: 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.[d2d0fc3d-e937-4958-85c9-608544fcfcc8]
FROM ##27dbb3436db14e558c8aa4eb1f45ce70 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