时间: 2022-05-20 12:37:50,151
  线程ID: 33
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##5338b6472df64c6fa9a12811fcad9a8c]
ORDER BY Goods_no


    时间: 2022-05-20 12:37:51,152
  线程ID: 24
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##3bf06e9c05654cff94e89205e7705e5b]
ORDER BY Goods_no


    时间: 2022-05-20 15:55:04,511
  线程ID: 22
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##717997eea12445a3bda094413dbaa863]
ORDER BY Goods_no


    时间: 2022-05-20 15:55:54,242
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##03ff5974e37f4b139f86ab62b9bc03c8] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##03ff5974e37f4b139f86ab62b9bc03c8] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##7db4a552e91d43b08a743128adb9c61a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

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

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

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


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


    时间: 2022-05-20 15:56:25,449
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##33455cd9ae2b47d581d63363ea8c7dd2] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##33455cd9ae2b47d581d63363ea8c7dd2] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##c1f18226ce4b4e239ee76aafdb5e8bc3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

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

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

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


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


    时间: 2022-05-20 15:59:15,116
  线程ID: 14
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##faa56735022341268c90b9f1a5643c10]
ORDER BY Goods_no


    时间: 2022-05-20 16:01:03,285
  线程ID: 42
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##e5c45d3fe17e46bb9abad182e19496a0]
ORDER BY Goods_no


    时间: 2022-05-20 16:01:04,327
  线程ID: 41
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##b38b76c34ec849ae8599e81899ebd68c]
ORDER BY Goods_no


    时间: 2022-05-20 16:01:05,266
  线程ID: 20
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##d426e62bec174a4489b6170f44aa468b]
ORDER BY Goods_no


    时间: 2022-05-20 16:15:08,552
  线程ID: 96
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##981efa3235074a7ea26843907967f387]
ORDER BY Goods_no


    时间: 2022-05-20 16:15:26,938
  线程ID: 29
日志级别: 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 [##f309f43d515a41c5902ea94ea94fe2ad]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 16:15:27,251
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##ec1052c427434914a92a3a964750a753] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 16:15:27,253
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f309f43d515a41c5902ea94ea94fe2ad] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##ec1052c427434914a92a3a964750a753]


    时间: 2022-05-20 16:15:27,322
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##670af6cf39094739bffd6ce3b6313894 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 16:15:27,324
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##670af6cf39094739bffd6ce3b6313894 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 16:15:27,325
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##670af6cf39094739bffd6ce3b6313894 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 16:15:27,352
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##670af6cf39094739bffd6ce3b6313894 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 16:15:27,353
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##670af6cf39094739bffd6ce3b6313894 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 16:15:27,356
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f309f43d515a41c5902ea94ea94fe2ad] (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 [##a0ba4f3eb58d4adfb88c6536c814bdfb]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 16:15:27,807
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##8a32941a7567497ebc4762374343c45c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 16:15:27,808
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f309f43d515a41c5902ea94ea94fe2ad] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##8a32941a7567497ebc4762374343c45c]


    时间: 2022-05-20 16:15:27,819
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##f309f43d515a41c5902ea94ea94fe2ad A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 16:15:33,037
  线程ID: 99
日志级别: 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 [##9e52e0c67c754c92b0c34519411a371b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 16:15:33,353
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##936061645b71485784ba71a73bab4dbb] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 16:15:33,354
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9e52e0c67c754c92b0c34519411a371b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##936061645b71485784ba71a73bab4dbb]


    时间: 2022-05-20 16:15:33,421
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##bfefc7d7411c46f6a49491654a97386a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2022-05-20 16:15:33,425
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##bfefc7d7411c46f6a49491654a97386a a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 16:15:33,451
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bfefc7d7411c46f6a49491654a97386a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 16:15:33,453
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bfefc7d7411c46f6a49491654a97386a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 16:15:33,456
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9e52e0c67c754c92b0c34519411a371b] (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 [##9d1fb5458f1f47aa8245dcb26c7be82c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 16:15:33,683
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##b2c32fc977244ac5ad500a7214c565e7] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 16:15:33,684
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##9e52e0c67c754c92b0c34519411a371b] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##b2c32fc977244ac5ad500a7214c565e7]


    时间: 2022-05-20 16:15:33,686
  线程ID: 99
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##9e52e0c67c754c92b0c34519411a371b A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 16:15:46,950
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##07338c700e264c20bbecdc3eb6d1f444] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2022-05-20 16:15:46,956
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##07338c700e264c20bbecdc3eb6d1f444] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##07338c700e264c20bbecdc3eb6d1f444] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2022-05-20 16:15:46,960
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##07338c700e264c20bbecdc3eb6d1f444] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-05-20 16:15:46,964
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##07338c700e264c20bbecdc3eb6d1f444] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2022-05-20 16:15:46,968
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##07338c700e264c20bbecdc3eb6d1f444 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##07338c700e264c20bbecdc3eb6d1f444 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##7c937e4443084ae6a2c170c0e6477b1a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-05-20 16:15:47,012
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##07338c700e264c20bbecdc3eb6d1f444 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##07338c700e264c20bbecdc3eb6d1f444 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##7c937e4443084ae6a2c170c0e6477b1a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2022-05-20 16:15:47,058
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##07338c700e264c20bbecdc3eb6d1f444 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 ##07338c700e264c20bbecdc3eb6d1f444 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##7c937e4443084ae6a2c170c0e6477b1a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-20 16:15:47,142
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##07338c700e264c20bbecdc3eb6d1f444 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 ##07338c700e264c20bbecdc3eb6d1f444 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##7c937e4443084ae6a2c170c0e6477b1a] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-20 16:15:47,353
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##07338c700e264c20bbecdc3eb6d1f444 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 ##07338c700e264c20bbecdc3eb6d1f444 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##7c937e4443084ae6a2c170c0e6477b1a] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-20 16:15:47,528
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##07338c700e264c20bbecdc3eb6d1f444
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2022-05-20 16:15:47,530
  线程ID: 96
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##07338c700e264c20bbecdc3eb6d1f444] 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 [##07338c700e264c20bbecdc3eb6d1f444] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2022-05-20 16:15:47,564
  线程ID: 96
日志级别: 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.[4c9e39fb-b7d4-4f89-8211-7b3c106b0bf7]
 FROM [##07338c700e264c20bbecdc3eb6d1f444]
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2022-05-20 17:00:36,729
  线程ID: 66
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##df00c3a8f1874683b70c1108eac65923]
ORDER BY Goods_no


    时间: 2022-05-20 17:02:10,821
  线程ID: 72
日志级别: 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 [##bbdf354b7b6f4fff9cda19d810fa3db6]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:02:11,157
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##5111c92913724c93a138cc136fc36486] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:02:11,160
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##bbdf354b7b6f4fff9cda19d810fa3db6] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##5111c92913724c93a138cc136fc36486]


    时间: 2022-05-20 17:02:11,228
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##491a82d0d1ec4ef797c3b97240aa76cc a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 17:02:11,230
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##491a82d0d1ec4ef797c3b97240aa76cc SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 17:02:11,233
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##491a82d0d1ec4ef797c3b97240aa76cc a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:02:11,264
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##491a82d0d1ec4ef797c3b97240aa76cc SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:02:11,265
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##491a82d0d1ec4ef797c3b97240aa76cc SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:02:11,268
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##bbdf354b7b6f4fff9cda19d810fa3db6] (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 [##4c0ee229603c4988a55cdee42c5df975]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:02:11,488
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##dce44266e9cb4feca2a90d66596a94bc] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:02:11,489
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##bbdf354b7b6f4fff9cda19d810fa3db6] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##dce44266e9cb4feca2a90d66596a94bc]


    时间: 2022-05-20 17:02:11,491
  线程ID: 72
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##bbdf354b7b6f4fff9cda19d810fa3db6 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 17:03:28,560
  线程ID: 60
日志级别: 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 [##49f87417f5c74f4eb03b187802c5a70e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:03:28,891
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##bf893b076216422cbadbad41fdeebb9c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:03:28,892
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##49f87417f5c74f4eb03b187802c5a70e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##bf893b076216422cbadbad41fdeebb9c]


    时间: 2022-05-20 17:03:28,961
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##b5cac8c1d9064e74ba3954ff3df017c3 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 17:03:28,964
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5cac8c1d9064e74ba3954ff3df017c3 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 17:03:28,967
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##b5cac8c1d9064e74ba3954ff3df017c3 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:03:28,996
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5cac8c1d9064e74ba3954ff3df017c3 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:03:28,999
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b5cac8c1d9064e74ba3954ff3df017c3 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:03:29,002
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##49f87417f5c74f4eb03b187802c5a70e] (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 [##067af846aa0f4632a6529ba3096e9faf]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:03:29,218
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##9f79e7254a1643b785fb0aebffddc5e5] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:03:29,219
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##49f87417f5c74f4eb03b187802c5a70e] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##9f79e7254a1643b785fb0aebffddc5e5]


    时间: 2022-05-20 17:03:29,221
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##49f87417f5c74f4eb03b187802c5a70e A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 17:05:04,446
  线程ID: 60
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##5b1155374ce04c1eb8599a838c558c1a]
ORDER BY Goods_no


    时间: 2022-05-20 17:05:15,550
  线程ID: 56
日志级别: 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 [##b51fb950e38c43269727ca59cdbd5c05]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:05:15,891
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3d5b0455077a4035a97768c36fa4684e] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:05:15,892
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b51fb950e38c43269727ca59cdbd5c05] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3d5b0455077a4035a97768c36fa4684e]


    时间: 2022-05-20 17:05:15,959
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##8ee25fd91627448f9bd6d6051c253e34 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2022-05-20 17:05:15,965
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##8ee25fd91627448f9bd6d6051c253e34 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:05:15,993
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8ee25fd91627448f9bd6d6051c253e34 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:05:15,995
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8ee25fd91627448f9bd6d6051c253e34 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:05:15,998
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b51fb950e38c43269727ca59cdbd5c05] (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 [##5997b27ea8e940be8a29b3bddf740006]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:05:16,215
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d1c259e3aac84b75a16ad27d436c44db] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:05:16,217
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##b51fb950e38c43269727ca59cdbd5c05] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d1c259e3aac84b75a16ad27d436c44db]


    时间: 2022-05-20 17:05:16,219
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##b51fb950e38c43269727ca59cdbd5c05 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 17:07:15,064
  线程ID: 60
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##71bd8bf465c44324baa2066adb981373]
ORDER BY Goods_no


    时间: 2022-05-20 17:07:25,722
  线程ID: 56
日志级别: 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 [##23fa18c9dc854cd0a77ba78fe9c31866]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:07:26,062
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##4dccd78f3e224765959797f3ba3e970f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:07:26,064
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##23fa18c9dc854cd0a77ba78fe9c31866] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##4dccd78f3e224765959797f3ba3e970f]


    时间: 2022-05-20 17:07:26,132
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##2f5d7c2efed34356b89956e84c875eb5 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 17:07:26,134
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2f5d7c2efed34356b89956e84c875eb5 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 17:07:26,137
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##2f5d7c2efed34356b89956e84c875eb5 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:07:26,167
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2f5d7c2efed34356b89956e84c875eb5 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:07:26,168
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2f5d7c2efed34356b89956e84c875eb5 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:07:26,171
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##23fa18c9dc854cd0a77ba78fe9c31866] (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 [##9b4cb84883aa4197a0d02581f1b3061f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:07:26,391
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fea5323661844a7faae231c6b782365d] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:07:26,392
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##23fa18c9dc854cd0a77ba78fe9c31866] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fea5323661844a7faae231c6b782365d]


    时间: 2022-05-20 17:07:26,393
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##23fa18c9dc854cd0a77ba78fe9c31866 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 17:08:41,464
  线程ID: 60
日志级别: 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 [##fcf54f9b10034ec4bda7fa17b200f66a]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:08:41,785
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6b33593ca9234db384ec0efadc6eb9d3] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:08:41,787
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fcf54f9b10034ec4bda7fa17b200f66a] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6b33593ca9234db384ec0efadc6eb9d3]


    时间: 2022-05-20 17:08:41,852
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##bc7446be3d29488b83011b4ca295eb03 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 17:08:41,854
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bc7446be3d29488b83011b4ca295eb03 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 17:08:41,856
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##bc7446be3d29488b83011b4ca295eb03 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:08:41,887
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bc7446be3d29488b83011b4ca295eb03 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:08:41,889
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bc7446be3d29488b83011b4ca295eb03 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:08:41,891
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fcf54f9b10034ec4bda7fa17b200f66a] (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 [##91e9eb06e9604617a8be76069fb28ab2]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:08:42,109
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##5a75c7ef10934747917c56e6883a48e8] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:08:42,110
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fcf54f9b10034ec4bda7fa17b200f66a] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##5a75c7ef10934747917c56e6883a48e8]


    时间: 2022-05-20 17:08:42,112
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##fcf54f9b10034ec4bda7fa17b200f66a A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 17:11:08,229
  线程ID: 53
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##65c8553133b6431197ef983d74ef4ae6]
ORDER BY Goods_no


    时间: 2022-05-20 17:11:19,066
  线程ID: 57
日志级别: 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 [##073b26e00ad446d8ab624da86bc58298]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:11:19,392
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##f4ec8bf90e844db48fe6844d13489d88] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:11:19,394
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##073b26e00ad446d8ab624da86bc58298] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##f4ec8bf90e844db48fe6844d13489d88]


    时间: 2022-05-20 17:11:19,467
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##44cae6221971471b9e42c4f818dceae4 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 17:11:19,469
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##44cae6221971471b9e42c4f818dceae4 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 17:11:19,473
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##44cae6221971471b9e42c4f818dceae4 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:11:19,502
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##44cae6221971471b9e42c4f818dceae4 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:11:19,503
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##44cae6221971471b9e42c4f818dceae4 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:11:19,506
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##073b26e00ad446d8ab624da86bc58298] (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 [##b91dff81dd894163b51955fdb71d134f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:11:19,734
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6b9068f00134415e983658a7be819de3] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:11:19,735
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##073b26e00ad446d8ab624da86bc58298] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6b9068f00134415e983658a7be819de3]


    时间: 2022-05-20 17:11:19,737
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##073b26e00ad446d8ab624da86bc58298 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name


    时间: 2022-05-20 17:35:27,198
  线程ID: 38
日志级别: 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.[8ba39021-d241-4b96-a980-e32a52399334]
FROM [##d815fdf0eaf144bd8663a42ee7946472]
ORDER BY Goods_no


    时间: 2022-05-20 17:35:37,595
  线程ID: 22
日志级别: 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 [##a3eeafddd0134df3bcc348a64da456b8]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-05-20 17:35:37,946
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##8b3b547ca75b4197a340949129b8319c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:35:37,948
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a3eeafddd0134df3bcc348a64da456b8] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##8b3b547ca75b4197a340949129b8319c]


    时间: 2022-05-20 17:35:38,028
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##fb788d69f2da4092b2e77f20037e35d4 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-05-20 17:35:38,030
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##fb788d69f2da4092b2e77f20037e35d4 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2022-05-20 17:35:38,034
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##fb788d69f2da4092b2e77f20037e35d4 a 
     INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
     INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND a.Goods_No = SCG.Goods_No AND A.PreSaleID = SCG.RetailOrderID AND a.DiscountPrice = SCG.DiscountPrice
     INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
     INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-05-20 17:35:38,065
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##fb788d69f2da4092b2e77f20037e35d4 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-05-20 17:35:38,067
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##fb788d69f2da4092b2e77f20037e35d4 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-05-20 17:35:38,071
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a3eeafddd0134df3bcc348a64da456b8] (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 [##023719364d5d4a558bfce31d23f1f89f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-05-20 17:35:38,295
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##17f3341a1c8946fd92d20cff67ce09f3] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-05-20 17:35:38,297
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a3eeafddd0134df3bcc348a64da456b8] (Customer_ID,Goods_No, ColorID, Long, [渠道在途#S1],  渠道在途#数量)
SELECT  Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##17f3341a1c8946fd92d20cff67ce09f3]


    时间: 2022-05-20 17:35:38,299
  线程ID: 22
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END AS [项目类型], A.Customer_ID AS [项目编号], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], SUM([渠道库存#数量]) AS [渠道库存], SUM([销售#数量]) AS [销售], SUM([渠道在途#数量]) AS [渠道在途], CAST(NULL AS IMAGE) AS [图片]
INTO tempdb.dbo.[eedc7ad3-ad78-4488-a232-ca30ed3a5147]
FROM ##a3eeafddd0134df3bcc348a64da456b8 A LEFT JOIN Goods GS ON GS.Goods_No = A.Goods_No
         LEFT JOIN Customer CT ON CT.Customer_ID = A.Customer_ID AND ISNULL(A.ItemType,0) = 0
         LEFT JOIN Warehouse W ON W.Warehouse_no = A.Customer_ID AND A.ItemType = 1
         LEFT JOIN vPlan VP ON A.Goods_No = VP.Goods_No

GROUP BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name

ORDER BY  CASE WHEN A.ItemType = 1 THEN '仓库' ELSE '渠道' END, A.Customer_ID, CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, GS.Goods_Name