时间: 2023-06-26 12:01:41,526
  线程ID: 45
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[42ad2493-b296-44ff-915b-81b0d7451a5e]
FROM [##6054661acbf943ebbdeb5d6c597e7f6e]
ORDER BY Goods_no


    时间: 2023-06-26 13:44:31,264
  线程ID: 93
日志级别: 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 [##cc1e727f70f44d9cb05266c9cb879920]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 13:44:31,645
  线程ID: 93
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d9712cc48c02466d81c965c639f36f51] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 13:44:31,647
  线程ID: 93
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##cc1e727f70f44d9cb05266c9cb879920] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d9712cc48c02466d81c965c639f36f51]


    时间: 2023-06-26 13:44:31,706
  线程ID: 93
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##81bb46b213b64445aa8a53fd42d2bf51 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2023-06-26 13:44:31,744
  线程ID: 93
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##81bb46b213b64445aa8a53fd42d2bf51 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 13:44:31,747
  线程ID: 93
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##cc1e727f70f44d9cb05266c9cb879920] (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 [##d2d029f8101c4dcfbe4874494ee21014]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 13:44:31,752
  线程ID: 93
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], VGC.Color AS [颜色说明], A.Long AS [内长], SUM([销售#S1]) AS [销售#S1], SUM([销售#数量]) AS [销售#数量], SUM([渠道库存#S1]) AS [渠道库存#S1], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[9ac84ba3-a668-47e4-826f-49448ed68f56]
FROM ##cc1e727f70f44d9cb05266c9cb879920 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
         LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID
         LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, VGC.Color, A.Long

ORDER BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, VGC.Color, A.Long


    时间: 2023-06-26 13:53:09,154
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c1b42d756a8849cd988772d05c62cbea] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##c1b42d756a8849cd988772d05c62cbea] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##a4c2b0c3d17e41cb87dd2150218a6902] 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 [##c1b42d756a8849cd988772d05c62cbea] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##c1b42d756a8849cd988772d05c62cbea] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##a4c2b0c3d17e41cb87dd2150218a6902] 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 [##c1b42d756a8849cd988772d05c62cbea] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##c1b42d756a8849cd988772d05c62cbea] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##a4c2b0c3d17e41cb87dd2150218a6902] 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 [##c1b42d756a8849cd988772d05c62cbea] 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 [##a4c2b0c3d17e41cb87dd2150218a6902] 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 [##c1b42d756a8849cd988772d05c62cbea] 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 [##c1b42d756a8849cd988772d05c62cbea] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##a4c2b0c3d17e41cb87dd2150218a6902] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:09,650
  线程ID: 42
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##c1b42d756a8849cd988772d05c62cbea] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:17,798
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##d4e6ff9616ad46f082cb6f38a77ef316] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##d4e6ff9616ad46f082cb6f38a77ef316] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##b44adc9ee35a4d82ab7f8859f58b2b7b] 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 [##d4e6ff9616ad46f082cb6f38a77ef316] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##d4e6ff9616ad46f082cb6f38a77ef316] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b44adc9ee35a4d82ab7f8859f58b2b7b] 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 [##d4e6ff9616ad46f082cb6f38a77ef316] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##d4e6ff9616ad46f082cb6f38a77ef316] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##b44adc9ee35a4d82ab7f8859f58b2b7b] 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 [##d4e6ff9616ad46f082cb6f38a77ef316] 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 [##b44adc9ee35a4d82ab7f8859f58b2b7b] 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 [##d4e6ff9616ad46f082cb6f38a77ef316] 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 [##d4e6ff9616ad46f082cb6f38a77ef316] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##b44adc9ee35a4d82ab7f8859f58b2b7b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:18,304
  线程ID: 29
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##d4e6ff9616ad46f082cb6f38a77ef316] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:27,279
  线程ID: 42
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##594b73dce68741e08ee6570a9fd2acc0] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##594b73dce68741e08ee6570a9fd2acc0] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##2062bdf264b84ae8846d18f92d433fc7] 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 [##594b73dce68741e08ee6570a9fd2acc0] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##594b73dce68741e08ee6570a9fd2acc0] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2062bdf264b84ae8846d18f92d433fc7] 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 [##594b73dce68741e08ee6570a9fd2acc0] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##594b73dce68741e08ee6570a9fd2acc0] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##2062bdf264b84ae8846d18f92d433fc7] 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 [##594b73dce68741e08ee6570a9fd2acc0] 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 [##2062bdf264b84ae8846d18f92d433fc7] 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 [##594b73dce68741e08ee6570a9fd2acc0] 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 [##594b73dce68741e08ee6570a9fd2acc0] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##2062bdf264b84ae8846d18f92d433fc7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:27,799
  线程ID: 42
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##594b73dce68741e08ee6570a9fd2acc0] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:32,122
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##6d6e436c40ac40a383058db7b06e3c02] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##6d6e436c40ac40a383058db7b06e3c02] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e7dc0c5acb6f43958a424dab43c39b50] 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 [##6d6e436c40ac40a383058db7b06e3c02] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##6d6e436c40ac40a383058db7b06e3c02] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##e7dc0c5acb6f43958a424dab43c39b50] 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 [##6d6e436c40ac40a383058db7b06e3c02] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##6d6e436c40ac40a383058db7b06e3c02] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##e7dc0c5acb6f43958a424dab43c39b50] 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 [##6d6e436c40ac40a383058db7b06e3c02] 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 [##e7dc0c5acb6f43958a424dab43c39b50] 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 [##6d6e436c40ac40a383058db7b06e3c02] 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 [##6d6e436c40ac40a383058db7b06e3c02] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##e7dc0c5acb6f43958a424dab43c39b50] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:32,621
  线程ID: 52
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##6d6e436c40ac40a383058db7b06e3c02] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:33,343
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##fb42929c81a24bcb85005646011c4d71] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##fb42929c81a24bcb85005646011c4d71] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##616e87e9abc24529b7e4836edd5ab2ad] 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 [##fb42929c81a24bcb85005646011c4d71] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##fb42929c81a24bcb85005646011c4d71] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##616e87e9abc24529b7e4836edd5ab2ad] 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 [##fb42929c81a24bcb85005646011c4d71] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##fb42929c81a24bcb85005646011c4d71] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##616e87e9abc24529b7e4836edd5ab2ad] 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 [##fb42929c81a24bcb85005646011c4d71] 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 [##616e87e9abc24529b7e4836edd5ab2ad] 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 [##fb42929c81a24bcb85005646011c4d71] 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 [##fb42929c81a24bcb85005646011c4d71] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##616e87e9abc24529b7e4836edd5ab2ad] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:33,843
  线程ID: 18
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##fb42929c81a24bcb85005646011c4d71] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:36,991
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##361ba667d6414867aa15c89a886556c9] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##361ba667d6414867aa15c89a886556c9] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##15614d8d2c044d768002241e2d58e46a] 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 [##361ba667d6414867aa15c89a886556c9] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##361ba667d6414867aa15c89a886556c9] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##15614d8d2c044d768002241e2d58e46a] 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 [##361ba667d6414867aa15c89a886556c9] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##361ba667d6414867aa15c89a886556c9] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##15614d8d2c044d768002241e2d58e46a] 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 [##361ba667d6414867aa15c89a886556c9] 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 [##15614d8d2c044d768002241e2d58e46a] 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 [##361ba667d6414867aa15c89a886556c9] 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 [##361ba667d6414867aa15c89a886556c9] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##15614d8d2c044d768002241e2d58e46a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:37,483
  线程ID: 29
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##361ba667d6414867aa15c89a886556c9] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:37,884
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##908f2e4a60384f3297b077de69960882] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##908f2e4a60384f3297b077de69960882] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##7f88483729ed477f8194c842f78e0852] 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 [##908f2e4a60384f3297b077de69960882] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##908f2e4a60384f3297b077de69960882] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##7f88483729ed477f8194c842f78e0852] 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 [##908f2e4a60384f3297b077de69960882] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##908f2e4a60384f3297b077de69960882] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##7f88483729ed477f8194c842f78e0852] 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 [##908f2e4a60384f3297b077de69960882] 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 [##7f88483729ed477f8194c842f78e0852] 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 [##908f2e4a60384f3297b077de69960882] 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 [##908f2e4a60384f3297b077de69960882] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##7f88483729ed477f8194c842f78e0852] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:38,377
  线程ID: 18
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##908f2e4a60384f3297b077de69960882] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:38,708
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##68e25ef26b6a486b85d0ff5dd0f3729a] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##68e25ef26b6a486b85d0ff5dd0f3729a] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##168b74f60cf3481096f6703d0841c486] 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 [##68e25ef26b6a486b85d0ff5dd0f3729a] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##68e25ef26b6a486b85d0ff5dd0f3729a] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##168b74f60cf3481096f6703d0841c486] 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 [##68e25ef26b6a486b85d0ff5dd0f3729a] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##68e25ef26b6a486b85d0ff5dd0f3729a] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##168b74f60cf3481096f6703d0841c486] 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 [##68e25ef26b6a486b85d0ff5dd0f3729a] 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 [##168b74f60cf3481096f6703d0841c486] 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 [##68e25ef26b6a486b85d0ff5dd0f3729a] 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 [##68e25ef26b6a486b85d0ff5dd0f3729a] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##168b74f60cf3481096f6703d0841c486] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:39,224
  线程ID: 18
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##68e25ef26b6a486b85d0ff5dd0f3729a] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:39,538
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7fbfa79d2d4a4b52bc5c765c5e74f756] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##7fbfa79d2d4a4b52bc5c765c5e74f756] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##c0799e3377b7485ab8d426bb45215264] 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 [##7fbfa79d2d4a4b52bc5c765c5e74f756] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##7fbfa79d2d4a4b52bc5c765c5e74f756] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##c0799e3377b7485ab8d426bb45215264] 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 [##7fbfa79d2d4a4b52bc5c765c5e74f756] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##7fbfa79d2d4a4b52bc5c765c5e74f756] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##c0799e3377b7485ab8d426bb45215264] 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 [##7fbfa79d2d4a4b52bc5c765c5e74f756] 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 [##c0799e3377b7485ab8d426bb45215264] 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 [##7fbfa79d2d4a4b52bc5c765c5e74f756] 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 [##7fbfa79d2d4a4b52bc5c765c5e74f756] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##c0799e3377b7485ab8d426bb45215264] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:40,179
  线程ID: 52
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##7fbfa79d2d4a4b52bc5c765c5e74f756] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:40,511
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7b1b3e175a964b56a34797fc00ff546f] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##7b1b3e175a964b56a34797fc00ff546f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##04bbe7c045a84632841b80c54d50331f] 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 [##7b1b3e175a964b56a34797fc00ff546f] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##7b1b3e175a964b56a34797fc00ff546f] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##04bbe7c045a84632841b80c54d50331f] 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 [##7b1b3e175a964b56a34797fc00ff546f] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##7b1b3e175a964b56a34797fc00ff546f] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##04bbe7c045a84632841b80c54d50331f] 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 [##7b1b3e175a964b56a34797fc00ff546f] 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 [##04bbe7c045a84632841b80c54d50331f] 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 [##7b1b3e175a964b56a34797fc00ff546f] 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 [##7b1b3e175a964b56a34797fc00ff546f] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##04bbe7c045a84632841b80c54d50331f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:41,013
  线程ID: 29
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##7b1b3e175a964b56a34797fc00ff546f] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 13:53:44,278
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##da875bcc02ff413491dbabd45f003894] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##da875bcc02ff413491dbabd45f003894] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##b35a099e4f814d7996703d0f4c7ea88c] 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 [##da875bcc02ff413491dbabd45f003894] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##da875bcc02ff413491dbabd45f003894] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##b35a099e4f814d7996703d0f4c7ea88c] 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 [##da875bcc02ff413491dbabd45f003894] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##da875bcc02ff413491dbabd45f003894] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##b35a099e4f814d7996703d0f4c7ea88c] 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 [##da875bcc02ff413491dbabd45f003894] 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 [##b35a099e4f814d7996703d0f4c7ea88c] 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 [##da875bcc02ff413491dbabd45f003894] 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 [##da875bcc02ff413491dbabd45f003894] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##b35a099e4f814d7996703d0f4c7ea88c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 13:53:44,748
  线程ID: 16
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##da875bcc02ff413491dbabd45f003894] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 14:30:00,804
  线程ID: 17
日志级别: 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 [##3d6a44a0eb534ab8a69ad20720548e1b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 14:30:01,163
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##fc17c3e9cfc3479b870cb178fca9e971] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 14:30:01,166
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3d6a44a0eb534ab8a69ad20720548e1b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##fc17c3e9cfc3479b870cb178fca9e971]


    时间: 2023-06-26 14:30:01,224
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##00835b64dcaa4c58b93ac42520bc391f a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-26 14:30:01,227
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##00835b64dcaa4c58b93ac42520bc391f SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-26 14:30:01,230
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##00835b64dcaa4c58b93ac42520bc391f 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-06-26 14:30:01,270
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##00835b64dcaa4c58b93ac42520bc391f SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-26 14:30:01,273
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##00835b64dcaa4c58b93ac42520bc391f SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 14:30:01,276
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3d6a44a0eb534ab8a69ad20720548e1b] (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 [##c4dc10e6154842f3b0c3e69f36767a4f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 14:30:01,282
  线程ID: 17
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], VGC.Color AS [颜色说明], A.Long AS [内长], SUM([销售#S1]) AS [销售#S1], SUM([销售#数量]) AS [销售#数量], SUM([渠道库存#S1]) AS [渠道库存#S1], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[9ac84ba3-a668-47e4-826f-49448ed68f56]
FROM ##3d6a44a0eb534ab8a69ad20720548e1b 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
         LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID
         LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, VGC.Color, A.Long

ORDER BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, VGC.Color, A.Long


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


    时间: 2023-06-26 14:40:40,494
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##7049e3e924bf4c859bb474967d29b36a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 14:40:40,495
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##aa2c5fb5adea4861babdad2760532186] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##7049e3e924bf4c859bb474967d29b36a]


    时间: 2023-06-26 14:40:40,548
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##48344a1516834f5dabc775fca536a8df a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-26 14:40:40,550
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##48344a1516834f5dabc775fca536a8df SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-26 14:40:40,552
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##48344a1516834f5dabc775fca536a8df 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-06-26 14:40:40,579
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##48344a1516834f5dabc775fca536a8df SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-26 14:40:40,580
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##48344a1516834f5dabc775fca536a8df SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 14:40:40,584
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##aa2c5fb5adea4861babdad2760532186] (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 [##70c6c829c3ec4305b9c05a434012b772]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 14:40:40,588
  线程ID: 69
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称], A.Goods_No AS [货号], VGC.Color AS [颜色说明], A.Long AS [内长], SUM([销售#S1]) AS [销售#S1], SUM([销售#数量]) AS [销售#数量], SUM([渠道库存#S1]) AS [渠道库存#S1], SUM([渠道库存#数量]) AS [渠道库存#数量]
INTO tempdb.dbo.[9ac84ba3-a668-47e4-826f-49448ed68f56]
FROM ##aa2c5fb5adea4861babdad2760532186 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
         LEFT JOIN vGoodsColor VGC ON VGC.Goods_No = A.Goods_No and VGC.ColorID = A.ColorID
         LEFT JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, VGC.Color, A.Long

ORDER BY  CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END, A.Goods_No, VGC.Color, A.Long


    时间: 2023-06-26 14:48:34,699
  线程ID: 36
日志级别: 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.[270f672a-7117-4636-873f-30eca4c4cdda]
FROM [##7aba340e3c37458cb05e4d6e5f8c6b98]
ORDER BY Goods_no


    时间: 2023-06-26 14:48:56,002
  线程ID: 88
日志级别: 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 [##329988011d634f55806f439b6495308c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 14:48:56,377
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##87efabdc04aa448babdc357e1a6ec3de] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 14:48:56,379
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##329988011d634f55806f439b6495308c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##87efabdc04aa448babdc357e1a6ec3de]


    时间: 2023-06-26 14:48:56,455
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##6d184ea91f524b26882b67791d04d823 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-26 14:48:56,458
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6d184ea91f524b26882b67791d04d823 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-26 14:48:56,463
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##6d184ea91f524b26882b67791d04d823 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-06-26 14:48:56,492
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6d184ea91f524b26882b67791d04d823 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-26 14:48:56,495
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6d184ea91f524b26882b67791d04d823 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 14:48:56,498
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##329988011d634f55806f439b6495308c] (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 [##6f7ef81d092846eea1e4b6026ecb488f]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 14:48:56,503
  线程ID: 88
日志级别: 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.[e50d071a-8db3-45f4-bb87-ae73cf98b73f]
FROM ##329988011d634f55806f439b6495308c 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-06-26 15:38:41,458
  线程ID: 45
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##6f0e2db5bf664235a4fcf775b2cc08f9] 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 [##6f0e2db5bf664235a4fcf775b2cc08f9] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##81c02e0bbd9a41649cfc9caac2419986] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2023-06-26 15:38:41,572
  线程ID: 45
日志级别: 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.[1d034991-a494-4a64-a94e-ecc1ccb900bb]
 FROM [##6f0e2db5bf664235a4fcf775b2cc08f9] 
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2023-06-26 15:55:46,831
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2f7ede3e2c9b44a9adabd8c356d4acf3] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##2f7ede3e2c9b44a9adabd8c356d4acf3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##dc71417dccd04f37a01bda8cd8dd7335] 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 [##2f7ede3e2c9b44a9adabd8c356d4acf3] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##2f7ede3e2c9b44a9adabd8c356d4acf3] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##dc71417dccd04f37a01bda8cd8dd7335] 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 [##2f7ede3e2c9b44a9adabd8c356d4acf3] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##2f7ede3e2c9b44a9adabd8c356d4acf3] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##dc71417dccd04f37a01bda8cd8dd7335] 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 [##2f7ede3e2c9b44a9adabd8c356d4acf3] 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 [##dc71417dccd04f37a01bda8cd8dd7335] 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 [##2f7ede3e2c9b44a9adabd8c356d4acf3] 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 [##2f7ede3e2c9b44a9adabd8c356d4acf3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##dc71417dccd04f37a01bda8cd8dd7335] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:55:47,374
  线程ID: 36
日志级别: 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.[491c48a4-bb2d-4da4-b7a3-e15fd5e5abe0]
 FROM [##2f7ede3e2c9b44a9adabd8c356d4acf3] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 15:56:55,542
  线程ID: 45
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##c5c2ec1e50d14f38b7958855db2272f0] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##c5c2ec1e50d14f38b7958855db2272f0] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1f03e3fb1df24ff4b0bc7505bb00a31d] 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 [##c5c2ec1e50d14f38b7958855db2272f0] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##c5c2ec1e50d14f38b7958855db2272f0] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1f03e3fb1df24ff4b0bc7505bb00a31d] 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 [##c5c2ec1e50d14f38b7958855db2272f0] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##c5c2ec1e50d14f38b7958855db2272f0] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##1f03e3fb1df24ff4b0bc7505bb00a31d] 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 [##c5c2ec1e50d14f38b7958855db2272f0] 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 [##1f03e3fb1df24ff4b0bc7505bb00a31d] 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 [##c5c2ec1e50d14f38b7958855db2272f0] 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 [##c5c2ec1e50d14f38b7958855db2272f0] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1f03e3fb1df24ff4b0bc7505bb00a31d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:56:56,113
  线程ID: 45
日志级别: 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.[491c48a4-bb2d-4da4-b7a3-e15fd5e5abe0]
 FROM [##c5c2ec1e50d14f38b7958855db2272f0] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 15:57:23,081
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##7d8d091f43284f35bd026ede36d1a9bb] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##7d8d091f43284f35bd026ede36d1a9bb] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##592c24479c3c4885af463df7d8469b2c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:57:23,258
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##7d8d091f43284f35bd026ede36d1a9bb] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##7d8d091f43284f35bd026ede36d1a9bb] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##592c24479c3c4885af463df7d8469b2c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:57:23,397
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##7d8d091f43284f35bd026ede36d1a9bb] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##7d8d091f43284f35bd026ede36d1a9bb] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##592c24479c3c4885af463df7d8469b2c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2023-06-26 15:57:23,543
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##7d8d091f43284f35bd026ede36d1a9bb] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##7d8d091f43284f35bd026ede36d1a9bb] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##592c24479c3c4885af463df7d8469b2c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2023-06-26 15:57:23,667
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##7d8d091f43284f35bd026ede36d1a9bb] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##7d8d091f43284f35bd026ede36d1a9bb] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##592c24479c3c4885af463df7d8469b2c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2023-06-26 15:57:23,790
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##7d8d091f43284f35bd026ede36d1a9bb A

    时间: 2023-06-26 15:57:23,794
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[f9dc2b33-a1e5-43c4-8039-5eb5e46d1bf5]
 FROM [##7d8d091f43284f35bd026ede36d1a9bb] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 15:57:33,045
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##3e15c66b65924ccc9f821259d7a7c303] A
    INNER JOIN (
        SELECT A.PuReceiptID, 
               SUM(ISNULL(GDP.DpPriceByBatch,0) * ISNULL(A.Quantity,0)) As DpAmount, 
               SUM(ISNULL(A.BalancePrice,0) * ISNULL(A.Quantity,0)) As BalanceAmount, 
               SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptSSGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
             LEFT  JOIN vGoodsDpPrice GDP ON B.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##3e15c66b65924ccc9f821259d7a7c303] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##20061b50b85f48c1b0e8faca28fc89de] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:57:33,262
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OldQuantity = ISNULL(B.Quantity,0)
 FROM [##3e15c66b65924ccc9f821259d7a7c303] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReceiptGoods A
             INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM [##3e15c66b65924ccc9f821259d7a7c303] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##20061b50b85f48c1b0e8faca28fc89de] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:57:33,426
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DealeReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##3e15c66b65924ccc9f821259d7a7c303] A
    INNER JOIN (
        SELECT A.DealereturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM DealeReturnGoods A
             INNER JOIN Dealereturn B ON A.DealereturnID = B.DealereturnID
        WHERE EXISTS( SELECT 1 FROM [##3e15c66b65924ccc9f821259d7a7c303] WHERE A.DealereturnID = DealereturnID )
     AND EXISTS (SELECT 1 FROM [##20061b50b85f48c1b0e8faca28fc89de] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DealereturnID
    ) B ON A.DealereturnID = B.DealereturnID


    时间: 2023-06-26 15:57:33,570
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET RenoticeQuantity = ISNULL(B.Quantity,0)
 FROM [##3e15c66b65924ccc9f821259d7a7c303] A
    INNER JOIN (
        SELECT A.RenoticeID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM RenoticeGoods A
             INNER JOIN Renotice B ON A.RenoticeID = B.RenoticeID
        WHERE EXISTS( SELECT 1 FROM [##3e15c66b65924ccc9f821259d7a7c303] WHERE A.RenoticeID = RenoticeID )
     AND EXISTS (SELECT 1 FROM [##20061b50b85f48c1b0e8faca28fc89de] WHERE Goods_No = A.Goods_No)
        GROUP BY A.RenoticeID
    ) B ON A.RenoticeID = B.RenoticeID


    时间: 2023-06-26 15:57:33,695
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReturnQuantity = ISNULL(B.Quantity,0)
 FROM [##3e15c66b65924ccc9f821259d7a7c303] A
    INNER JOIN (
        SELECT A.PuReturnID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM PuReturnGoods A
             INNER JOIN PuReturn B ON A.PuReturnID = B.PuReturnID
        WHERE EXISTS( SELECT 1 FROM [##3e15c66b65924ccc9f821259d7a7c303] WHERE A.PuReturnID = PuReturnID )
     AND EXISTS (SELECT 1 FROM [##20061b50b85f48c1b0e8faca28fc89de] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReturnID
    ) B ON A.PuReturnID = B.PuReturnID


    时间: 2023-06-26 15:57:33,820
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.CompareQuantity = ISNULL(A.OldQuantity,0)-ISNULL(A.Quantity,0)
 FROM ##3e15c66b65924ccc9f821259d7a7c303 A

    时间: 2023-06-26 15:57:33,823
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        RenoticeID AS [退货通知单], DealereturnID AS [渠道退货单], PuReturnID AS [采购退货单], EOrderID AS [线上订单号],
        BuyerNo AS [买家昵称], RetailOrderID AS [零售订单号], PlatformName AS [平台类型],
        rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称],
        SaleMan [业务员], PriceType [价格类型], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BalanceAmount AS [结算额],
        PuReturnQuantity AS [业务状态#采购退货数], DealeReturnQuantity AS [业务状态#退货数], RenoticeQuantity AS [业务状态#退货通知数],
        OldQuantity AS [业务状态#原单数], CompareQuantity AS [业务状态#差异数], RefundStatus 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.[f9dc2b33-a1e5-43c4-8039-5eb5e46d1bf5]
 FROM [##3e15c66b65924ccc9f821259d7a7c303] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 15:58:21,795
  线程ID: 34
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ae03a8a4789a4e66b397a1456586a7c3] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##ae03a8a4789a4e66b397a1456586a7c3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##6c9b7a1b1d27427495ccf64b59f99d82] 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 [##ae03a8a4789a4e66b397a1456586a7c3] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##ae03a8a4789a4e66b397a1456586a7c3] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##6c9b7a1b1d27427495ccf64b59f99d82] 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 [##ae03a8a4789a4e66b397a1456586a7c3] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##ae03a8a4789a4e66b397a1456586a7c3] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##6c9b7a1b1d27427495ccf64b59f99d82] 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 [##ae03a8a4789a4e66b397a1456586a7c3] 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 [##6c9b7a1b1d27427495ccf64b59f99d82] 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 [##ae03a8a4789a4e66b397a1456586a7c3] 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 [##ae03a8a4789a4e66b397a1456586a7c3] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##6c9b7a1b1d27427495ccf64b59f99d82] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 15:58:22,385
  线程ID: 34
日志级别: 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.[a8c7c649-81d0-4e52-945b-526df2f49066]
 FROM [##ae03a8a4789a4e66b397a1456586a7c3] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 16:18:23,678
  线程ID: 44
日志级别: 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 [##ac875b6b8b854e86b8b70b31c4e97b2d]
FROM Customer A, Barcode B, DeliveryDetail C


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

    时间: 2023-06-26 16:18:24,024
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ac875b6b8b854e86b8b70b31c4e97b2d] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##9585754a14f849359c61c5c19ad8ca00]


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


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


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


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


    时间: 2023-06-26 16:18:24,110
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ac875b6b8b854e86b8b70b31c4e97b2d] (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 [##f5ed75648b5b4d15baee1515511c2e27]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:18:24,125
  线程ID: 44
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##ac875b6b8b854e86b8b70b31c4e97b2d 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-06-26 16:18:26,013
  线程ID: 36
日志级别: 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 [##f66ff0a0e80e4454b870b23831e6e50c]
FROM Customer A, Barcode B, DeliveryDetail C


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

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


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


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


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


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


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


    时间: 2023-06-26 16:18:26,465
  线程ID: 36
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##f66ff0a0e80e4454b870b23831e6e50c 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-06-26 16:18:37,306
  线程ID: 44
日志级别: 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 [##84d442be798f43aca6c0995f9ef61f47]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 16:18:37,686
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##0f98446d8e3f43ac822eb3412d5fd1dc] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:18:37,687
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##84d442be798f43aca6c0995f9ef61f47] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##0f98446d8e3f43ac822eb3412d5fd1dc]


    时间: 2023-06-26 16:18:37,738
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##21da72a792af43fb8f115bfbff446d42 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2023-06-26 16:18:37,771
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##21da72a792af43fb8f115bfbff446d42 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 16:18:37,774
  线程ID: 44
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##84d442be798f43aca6c0995f9ef61f47] (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 [##9436a77a612d463ea6d5f89548e9af7c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:18:37,777
  线程ID: 44
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##84d442be798f43aca6c0995f9ef61f47 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-06-26 16:23:57,072
  线程ID: 38
日志级别: 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 [##3ad6b9c21cbd4f3aae80bd8250218ee3]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 16:23:57,375
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##52b65a72c92b4e1d9573b5ad9140ac36] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:23:57,376
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3ad6b9c21cbd4f3aae80bd8250218ee3] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##52b65a72c92b4e1d9573b5ad9140ac36]


    时间: 2023-06-26 16:23:57,427
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##863ce951c017436ca1716a2b60213647 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2023-06-26 16:23:57,465
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##863ce951c017436ca1716a2b60213647 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 16:23:57,468
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##3ad6b9c21cbd4f3aae80bd8250218ee3] (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 [##c8337da4346e4a3eba68f423d6b2a5ab]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:23:57,472
  线程ID: 38
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##3ad6b9c21cbd4f3aae80bd8250218ee3 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-06-26 16:23:59,921
  线程ID: 31
日志级别: 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 [##1feb058abc984d48a7a98fa57870d2e2]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 16:24:00,273
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##4f2c250f91ea4c09a43c34c4239ac6cf] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:24:00,275
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1feb058abc984d48a7a98fa57870d2e2] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##4f2c250f91ea4c09a43c34c4239ac6cf]


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


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


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


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


    时间: 2023-06-26 16:24:00,366
  线程ID: 31
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##1feb058abc984d48a7a98fa57870d2e2] (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 [##fccddc40e4f5446da3121a28cfd69098]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:24:00,371
  线程ID: 31
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##1feb058abc984d48a7a98fa57870d2e2 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-06-26 16:24:03,921
  线程ID: 38
日志级别: 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 [##7b4f50a6feee4cb58d4d2b57eb534f35]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 16:24:04,234
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##11ae7f58b3bc43f4906cb05f40925447] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:24:04,235
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7b4f50a6feee4cb58d4d2b57eb534f35] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##11ae7f58b3bc43f4906cb05f40925447]


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


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


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


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


    时间: 2023-06-26 16:24:04,324
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7b4f50a6feee4cb58d4d2b57eb534f35] (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 [##8c18038d58ad490f94738a12dc93c77e]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:24:04,327
  线程ID: 38
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##7b4f50a6feee4cb58d4d2b57eb534f35 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-06-26 16:24:06,705
  线程ID: 48
日志级别: 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 [##08b40fea5b7446f5bdef865a0ece2057]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 16:24:07,097
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##d44a135d6a0946468e8ee25b7de175eb] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:24:07,099
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##08b40fea5b7446f5bdef865a0ece2057] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##d44a135d6a0946468e8ee25b7de175eb]


    时间: 2023-06-26 16:24:07,159
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##614a5962635f4403a2347961b52c83e8 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


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


    时间: 2023-06-26 16:24:07,201
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##08b40fea5b7446f5bdef865a0ece2057] (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 [##19f9fc7c8bb1410d806078a57f12649a]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:24:07,207
  线程ID: 48
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##08b40fea5b7446f5bdef865a0ece2057 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-06-26 16:24:36,535
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##4fbfec87fcba458482994990a1b3f56e] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##4fbfec87fcba458482994990a1b3f56e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1f4fbe74c1044e089603f44f24c0d14c] 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 [##4fbfec87fcba458482994990a1b3f56e] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##4fbfec87fcba458482994990a1b3f56e] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1f4fbe74c1044e089603f44f24c0d14c] 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 [##4fbfec87fcba458482994990a1b3f56e] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##4fbfec87fcba458482994990a1b3f56e] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##1f4fbe74c1044e089603f44f24c0d14c] 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 [##4fbfec87fcba458482994990a1b3f56e] 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 [##1f4fbe74c1044e089603f44f24c0d14c] 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 [##4fbfec87fcba458482994990a1b3f56e] 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 [##4fbfec87fcba458482994990a1b3f56e] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##1f4fbe74c1044e089603f44f24c0d14c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 16:24:37,112
  线程ID: 32
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##4fbfec87fcba458482994990a1b3f56e] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 16:26:57,852
  线程ID: 30
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##5d63279d915446d2a27958a186445dc4] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##5d63279d915446d2a27958a186445dc4] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##729dbe47881e4029be5165f4be4d967a] 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 [##5d63279d915446d2a27958a186445dc4] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##5d63279d915446d2a27958a186445dc4] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##729dbe47881e4029be5165f4be4d967a] 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 [##5d63279d915446d2a27958a186445dc4] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##5d63279d915446d2a27958a186445dc4] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##729dbe47881e4029be5165f4be4d967a] 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 [##5d63279d915446d2a27958a186445dc4] 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 [##729dbe47881e4029be5165f4be4d967a] 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 [##5d63279d915446d2a27958a186445dc4] 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 [##5d63279d915446d2a27958a186445dc4] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##729dbe47881e4029be5165f4be4d967a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 16:26:58,394
  线程ID: 30
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##5d63279d915446d2a27958a186445dc4] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


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


    时间: 2023-06-26 16:30:23,830
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##6f18ebcde42441b7bfad4d24b59aeded] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:30:23,832
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##69c4519eef05460f8c25d27dbb64d7c5] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##6f18ebcde42441b7bfad4d24b59aeded]


    时间: 2023-06-26 16:30:23,892
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##2465167423da45f093295df7885da7f6 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2023-06-26 16:30:23,933
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##2465167423da45f093295df7885da7f6 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 16:30:23,936
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##69c4519eef05460f8c25d27dbb64d7c5] (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 [##34f86bbb4c9040f58db95d583de7e4b9]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:30:23,942
  线程ID: 40
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.Goods_No AS [货号], GS.Goods_Name AS [货品名称], GS.Range AS [系列], GS.UnitPrice AS [吊牌价], SUM([销售#数量]) AS [销售], SUM([渠道库存#数量]) AS [渠道库存], CASE WHEN A.ItemType = 1 THEN W.Warehouse_Na ELSE CT.Abbrev END AS [项目名称]
INTO tempdb.dbo.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##69c4519eef05460f8c25d27dbb64d7c5 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-06-26 16:31:15,964
  线程ID: 28
日志级别: 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 [##59cf11f65cec4a4b953e07d1cf3c820b]
FROM Customer A, Barcode B, DeliveryDetail C


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

    时间: 2023-06-26 16:31:16,331
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##59cf11f65cec4a4b953e07d1cf3c820b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##1f63ecefa6c246b3b3cf16b311c85d99]


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


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


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


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


    时间: 2023-06-26 16:31:16,434
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##59cf11f65cec4a4b953e07d1cf3c820b] (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 [##ac86ec998b6a441db4d0fe2f545f7ef6]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:31:16,440
  线程ID: 28
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##59cf11f65cec4a4b953e07d1cf3c820b 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-06-26 16:45:44,678
  线程ID: 15
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##e58e17fccde045c6a20fc87c1f584227] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##e58e17fccde045c6a20fc87c1f584227] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9a450d79d80a41249542d3c58c861c2f] 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 [##e58e17fccde045c6a20fc87c1f584227] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##e58e17fccde045c6a20fc87c1f584227] WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##9a450d79d80a41249542d3c58c861c2f] 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 [##e58e17fccde045c6a20fc87c1f584227] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##e58e17fccde045c6a20fc87c1f584227] WHERE A.Purchase_ID = Purchase_ID )
     AND EXISTS (SELECT 1 FROM [##9a450d79d80a41249542d3c58c861c2f] 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 [##e58e17fccde045c6a20fc87c1f584227] 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 [##9a450d79d80a41249542d3c58c861c2f] 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 [##e58e17fccde045c6a20fc87c1f584227] 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 [##e58e17fccde045c6a20fc87c1f584227] WHERE A.PuReceiptID = PuReceiptID )
     AND EXISTS (SELECT 1 FROM [##9a450d79d80a41249542d3c58c861c2f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2023-06-26 16:45:45,220
  线程ID: 15
日志级别: 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.[fcae256c-cc9f-402c-908c-372d86492087]
 FROM [##e58e17fccde045c6a20fc87c1f584227] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2023-06-26 16:48:28,186
  线程ID: 14
日志级别: 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 [##a14b33bb9d5746bf9ae1c4614ad1bff1]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 16:48:28,543
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##3f8ebb77705d40e0922aa5dba958bb0f] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 16:48:28,545
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a14b33bb9d5746bf9ae1c4614ad1bff1] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##3f8ebb77705d40e0922aa5dba958bb0f]


    时间: 2023-06-26 16:48:28,605
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##af60d5be5e3643d89cde77b450074785 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


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


    时间: 2023-06-26 16:48:28,638
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##af60d5be5e3643d89cde77b450074785 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 16:48:28,642
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##a14b33bb9d5746bf9ae1c4614ad1bff1] (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 [##36c2209d675d404e8ecbe0d514b42242]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 16:48:28,646
  线程ID: 14
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##a14b33bb9d5746bf9ae1c4614ad1bff1 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-06-26 18:29:10,479
  线程ID: 50
日志级别: 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 [##f2204ef9e05048998b97a7d8e83c442b]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2023-06-26 18:29:10,850
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##c8801128457941d5913311aa1fc998f4] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2023-06-26 18:29:10,852
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f2204ef9e05048998b97a7d8e83c442b] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##c8801128457941d5913311aa1fc998f4]


    时间: 2023-06-26 18:29:10,913
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##e9206d6e35a44db590d6206db7c199b2 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2023-06-26 18:29:10,915
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e9206d6e35a44db590d6206db7c199b2 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2023-06-26 18:29:10,919
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##e9206d6e35a44db590d6206db7c199b2 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-06-26 18:29:10,948
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e9206d6e35a44db590d6206db7c199b2 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2023-06-26 18:29:10,950
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e9206d6e35a44db590d6206db7c199b2 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2023-06-26 18:29:10,953
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##f2204ef9e05048998b97a7d8e83c442b] (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 [##924b0c49a9334863a3af9d8e8ac74b72]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2023-06-26 18:29:10,958
  线程ID: 50
日志级别: 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.[6c90f575-c4e3-49a6-84ae-6700381a92f0]
FROM ##f2204ef9e05048998b97a7d8e83c442b 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