时间: 2022-08-29 13:24:42,981
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##8580a43043e04116815097ef8a57fb36 ADD 销售类型 VARCHAR(50)

    时间: 2022-08-29 13:24:43,010
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##8580a43043e04116815097ef8a57fb36 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-08-29 13:24:43,017
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8580a43043e04116815097ef8a57fb36 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2022-08-29 13:24:43,023
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##8580a43043e04116815097ef8a57fb36 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON a.CheckGoodsID = SCG.CheckGoodsID 
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-08-29 13:24:43,046
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8580a43043e04116815097ef8a57fb36 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2022-08-29 13:24:43,049
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8580a43043e04116815097ef8a57fb36 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2022-08-29 13:24:43,141
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], SUM(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(SUM(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/SUM(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(SUM(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/SUM(A.TotalDpAmount) END)  AS Numeric(18, 4)) AS [会员消费吊牌额占比], SUM(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], SUM(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(SUM(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/SUM(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比]
 INTO tempdb.dbo.[94bf897a-bde1-4a8f-9a76-085d690cdd7b]
FROM ##1bbb65fee7fb4b999440d8974082b914 A 
INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID
LEFT JOIN customervip Vip on Vip.VIP=A.VIP_Card

GROUP BY  A.Customer_ID, CT.Abbrev, A.CheckDate

ORDER BY  A.Customer_ID, CT.Abbrev, A.CheckDate


    时间: 2022-08-29 13:25:30,487
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##e16f88e245454ff29cb4cb29be5fdc54 ADD 销售类型 VARCHAR(50)

    时间: 2022-08-29 13:25:30,489
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##e16f88e245454ff29cb4cb29be5fdc54 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-08-29 13:25:30,495
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e16f88e245454ff29cb4cb29be5fdc54 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2022-08-29 13:25:30,500
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##e16f88e245454ff29cb4cb29be5fdc54 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON a.CheckGoodsID = SCG.CheckGoodsID 
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2022-08-29 13:25:30,522
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e16f88e245454ff29cb4cb29be5fdc54 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2022-08-29 13:25:30,525
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##e16f88e245454ff29cb4cb29be5fdc54 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2022-08-29 13:25:30,574
  线程ID: 63
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.CheckDate AS [核销日期], SUM(a.TotalQuantity) AS [销售数量], SUM(a.VipQuantity) AS [会员消费数量], CAST( (CASE WHEN ISNULL(SUM(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/SUM(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], CAST( (CASE WHEN ISNULL(SUM(A.TotalDpAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipDpAmount), 0)/SUM(A.TotalDpAmount) END)  AS Numeric(18, 4)) AS [会员消费吊牌额占比], SUM(a.TotalDpAmount) AS [吊牌额], SUM(a.VipDpAmount) AS [会员吊牌额], SUM(A.TotalAmount) AS [生意额], SUM(A.VIPAmount) AS [会员消费额], CAST( (CASE WHEN ISNULL(SUM(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/SUM(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比]
 INTO tempdb.dbo.[94bf897a-bde1-4a8f-9a76-085d690cdd7b]
FROM ##8557b3c437714254a49f209026df3d8b A 
INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID
LEFT JOIN customervip Vip on Vip.VIP=A.VIP_Card

GROUP BY  A.Customer_ID, CT.Abbrev, A.CheckDate

ORDER BY  A.Customer_ID, CT.Abbrev, A.CheckDate


    时间: 2022-08-29 16:05:26,782
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##211949be5ee8493f8469f3f129828253 A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:05:26,791
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##211949be5ee8493f8469f3f129828253] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:05:26,795
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##211949be5ee8493f8469f3f129828253] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##211949be5ee8493f8469f3f129828253 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##59fb22dd6f6f490ebacc7e4fc551c1e4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:05:26,974
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##211949be5ee8493f8469f3f129828253] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##211949be5ee8493f8469f3f129828253 WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##59fb22dd6f6f490ebacc7e4fc551c1e4] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:05:27,159
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##211949be5ee8493f8469f3f129828253] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##211949be5ee8493f8469f3f129828253 WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##59fb22dd6f6f490ebacc7e4fc551c1e4] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:05:27,635
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##211949be5ee8493f8469f3f129828253] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##211949be5ee8493f8469f3f129828253].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:05:27,639
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##211949be5ee8493f8469f3f129828253] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##211949be5ee8493f8469f3f129828253 WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##59fb22dd6f6f490ebacc7e4fc551c1e4] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:05:27,997
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##211949be5ee8493f8469f3f129828253] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##211949be5ee8493f8469f3f129828253 WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##59fb22dd6f6f490ebacc7e4fc551c1e4] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:05:28,575
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##211949be5ee8493f8469f3f129828253]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:06:29,537
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##9edd1d42327c433995a06f9a6c42c52a A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:06:29,543
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9edd1d42327c433995a06f9a6c42c52a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:06:29,547
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##9edd1d42327c433995a06f9a6c42c52a] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##9edd1d42327c433995a06f9a6c42c52a WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##1e93051316274d099f746f6b8c8fea1d] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:29,725
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##9edd1d42327c433995a06f9a6c42c52a] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##9edd1d42327c433995a06f9a6c42c52a WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##1e93051316274d099f746f6b8c8fea1d] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:06:29,906
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##9edd1d42327c433995a06f9a6c42c52a] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##9edd1d42327c433995a06f9a6c42c52a WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##1e93051316274d099f746f6b8c8fea1d] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:30,382
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##9edd1d42327c433995a06f9a6c42c52a] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##9edd1d42327c433995a06f9a6c42c52a].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:06:30,387
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##9edd1d42327c433995a06f9a6c42c52a] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##9edd1d42327c433995a06f9a6c42c52a WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##1e93051316274d099f746f6b8c8fea1d] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:30,746
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##9edd1d42327c433995a06f9a6c42c52a] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##9edd1d42327c433995a06f9a6c42c52a WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##1e93051316274d099f746f6b8c8fea1d] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:31,326
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##9edd1d42327c433995a06f9a6c42c52a]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:06:34,080
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##88ee4737337d4bf8856e832c82198cea A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:06:34,086
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##88ee4737337d4bf8856e832c82198cea] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:06:34,092
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##88ee4737337d4bf8856e832c82198cea] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##88ee4737337d4bf8856e832c82198cea WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##c867e7479dfc4742926dc4f73f3b42b9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:34,278
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##88ee4737337d4bf8856e832c82198cea] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##88ee4737337d4bf8856e832c82198cea WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##c867e7479dfc4742926dc4f73f3b42b9] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:06:34,463
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##88ee4737337d4bf8856e832c82198cea] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##88ee4737337d4bf8856e832c82198cea WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##c867e7479dfc4742926dc4f73f3b42b9] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:34,942
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##88ee4737337d4bf8856e832c82198cea] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##88ee4737337d4bf8856e832c82198cea].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:06:34,946
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##88ee4737337d4bf8856e832c82198cea] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##88ee4737337d4bf8856e832c82198cea WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##c867e7479dfc4742926dc4f73f3b42b9] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:35,313
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##88ee4737337d4bf8856e832c82198cea] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##88ee4737337d4bf8856e832c82198cea WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##c867e7479dfc4742926dc4f73f3b42b9] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:35,885
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##88ee4737337d4bf8856e832c82198cea]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:06:36,155
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##2507290170cb4a25bec37978908da28e A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:06:36,160
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2507290170cb4a25bec37978908da28e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:06:36,165
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2507290170cb4a25bec37978908da28e] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##2507290170cb4a25bec37978908da28e WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##17db82565e7543cca58d43db418e53c1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:36,341
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##2507290170cb4a25bec37978908da28e] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##2507290170cb4a25bec37978908da28e WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##17db82565e7543cca58d43db418e53c1] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:06:36,517
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##2507290170cb4a25bec37978908da28e] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##2507290170cb4a25bec37978908da28e WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##17db82565e7543cca58d43db418e53c1] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:36,987
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2507290170cb4a25bec37978908da28e] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##2507290170cb4a25bec37978908da28e].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:06:36,992
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##2507290170cb4a25bec37978908da28e] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##2507290170cb4a25bec37978908da28e WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##17db82565e7543cca58d43db418e53c1] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:37,359
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##2507290170cb4a25bec37978908da28e] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##2507290170cb4a25bec37978908da28e WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##17db82565e7543cca58d43db418e53c1] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:37,924
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##2507290170cb4a25bec37978908da28e]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:06:50,914
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##5b1321488f0c405c99f44dceac7210a1 A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:06:50,920
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5b1321488f0c405c99f44dceac7210a1] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:06:50,925
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##5b1321488f0c405c99f44dceac7210a1] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##5b1321488f0c405c99f44dceac7210a1 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##d3ef7ec8189f447cbb6f3f72e61a29a3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:51,103
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##5b1321488f0c405c99f44dceac7210a1] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##5b1321488f0c405c99f44dceac7210a1 WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##d3ef7ec8189f447cbb6f3f72e61a29a3] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:06:51,281
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##5b1321488f0c405c99f44dceac7210a1] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##5b1321488f0c405c99f44dceac7210a1 WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##d3ef7ec8189f447cbb6f3f72e61a29a3] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:51,755
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##5b1321488f0c405c99f44dceac7210a1] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##5b1321488f0c405c99f44dceac7210a1].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:06:51,759
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##5b1321488f0c405c99f44dceac7210a1] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##5b1321488f0c405c99f44dceac7210a1 WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##d3ef7ec8189f447cbb6f3f72e61a29a3] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:52,120
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##5b1321488f0c405c99f44dceac7210a1] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##5b1321488f0c405c99f44dceac7210a1 WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##d3ef7ec8189f447cbb6f3f72e61a29a3] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:52,733
  线程ID: 73
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##5b1321488f0c405c99f44dceac7210a1]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:06:53,664
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##2f16af31ad1b4f6793b14a3a653357a4 A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:06:53,671
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2f16af31ad1b4f6793b14a3a653357a4] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:06:53,675
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##2f16af31ad1b4f6793b14a3a653357a4] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##2f16af31ad1b4f6793b14a3a653357a4 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##fa03449c3e00453fae744371909bf826] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:53,849
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##2f16af31ad1b4f6793b14a3a653357a4] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##2f16af31ad1b4f6793b14a3a653357a4 WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##fa03449c3e00453fae744371909bf826] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:06:54,021
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##2f16af31ad1b4f6793b14a3a653357a4] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##2f16af31ad1b4f6793b14a3a653357a4 WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##fa03449c3e00453fae744371909bf826] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:54,482
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##2f16af31ad1b4f6793b14a3a653357a4] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##2f16af31ad1b4f6793b14a3a653357a4].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:06:54,487
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##2f16af31ad1b4f6793b14a3a653357a4] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##2f16af31ad1b4f6793b14a3a653357a4 WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##fa03449c3e00453fae744371909bf826] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:54,848
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##2f16af31ad1b4f6793b14a3a653357a4] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##2f16af31ad1b4f6793b14a3a653357a4 WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##fa03449c3e00453fae744371909bf826] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:06:55,421
  线程ID: 54
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##2f16af31ad1b4f6793b14a3a653357a4]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:07:11,933
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##8c887501b98a427e913e383c17a9734f A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:07:11,939
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8c887501b98a427e913e383c17a9734f] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:07:11,942
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##8c887501b98a427e913e383c17a9734f] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##8c887501b98a427e913e383c17a9734f WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##199102abb0cc40baa001e5b032b89dc6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:12,121
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##8c887501b98a427e913e383c17a9734f] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##8c887501b98a427e913e383c17a9734f WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##199102abb0cc40baa001e5b032b89dc6] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:07:12,298
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##8c887501b98a427e913e383c17a9734f] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##8c887501b98a427e913e383c17a9734f WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##199102abb0cc40baa001e5b032b89dc6] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:12,780
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##8c887501b98a427e913e383c17a9734f] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##8c887501b98a427e913e383c17a9734f].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:07:12,785
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##8c887501b98a427e913e383c17a9734f] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##8c887501b98a427e913e383c17a9734f WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##199102abb0cc40baa001e5b032b89dc6] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:13,195
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##8c887501b98a427e913e383c17a9734f] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##8c887501b98a427e913e383c17a9734f WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##199102abb0cc40baa001e5b032b89dc6] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:13,825
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##8c887501b98a427e913e383c17a9734f]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:07:14,132
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OutStatus = 1 
 FROM ##d95d50741fb04437bb6825fbb0e2d3ef A
 WHERE Exists( SELECT 1 FROM Delivery WHERE ISNULL(Posted,0) = 0 AND Type IN (1,2) AND A.SortingID = SortingID )


    时间: 2022-08-29 16:07:14,138
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WSorting' AND A.SortingID = BillNo )


    时间: 2022-08-29 16:07:14,144
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), BalanceAmount = ISNULL(B.BalanceAmount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As BalanceAmount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [SortingGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##d95d50741fb04437bb6825fbb0e2d3ef WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##30824aebd583469c9ec33594d6014e2f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:14,335
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxQuantity = ISNULL(B.BoxQuantity,0), BoxStatus = 1
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef] A
    INNER JOIN (
        SELECT A.AccBillNo, SUM(0+ISNULL(S1, 0))  AS BoxQuantity 
        FROM [BoxBill] A 
        INNER JOIN [BoxDetail] BG ON A.BoxNo = BG.BoxNo 
        WHERE A.AccBillType = 'WareSorting' 
        AND EXISTS( SELECT 1 FROM ##d95d50741fb04437bb6825fbb0e2d3ef WHERE A.AccBillNo = SortingID )
        AND NOT EXISTS( SELECT 1 FROM Delivery WHERE Type IN (1,2) AND A.AccBillNo = SortingID ) 
        AND EXISTS (SELECT 1 FROM [##30824aebd583469c9ec33594d6014e2f] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.AccBillNo
    ) B ON A.SortingID = B.AccBillNo


    时间: 2022-08-29 16:07:14,533
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET DeliveryQuantity = ISNULL(B.DeliveryQuantity,0), DeliveryStatus = 1
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As DeliveryQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Posted = 1 AND Type IN (1,2)
        AND EXISTS( SELECT 1 FROM ##d95d50741fb04437bb6825fbb0e2d3ef WHERE A.SortingID = SortingID )
        AND EXISTS (SELECT 1 FROM [##30824aebd583469c9ec33594d6014e2f] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:15,030
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d95d50741fb04437bb6825fbb0e2d3ef] SET DiffQuantity = CASE WHEN ISNULL(DeliveryQuantity,0) > ISNULL(Quantity,0) THEN 0 ELSE ISNULL(Quantity,0) - ISNULL(DeliveryQuantity,0) END
     WHERE ISNULL(Flag,0) = 0
     OR EXISTS( SELECT 1 FROM Delivery B WHERE B.Type IN (1,2) AND [##d95d50741fb04437bb6825fbb0e2d3ef].SortingID = B.SortingID ) 


    时间: 2022-08-29 16:07:15,036
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET WayQuantity = ISNULL(B.WayQuantity,0)
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef] A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(BG.Quantity,0)) As WayQuantity 
        FROM [Delivery] A 
        INNER JOIN [DeliveryGoods] BG ON A.DeliveryID = BG.DeliveryID 
        WHERE A.Type IN (1,2) AND A.Posted=1  
        AND EXISTS( SELECT 1 FROM ##d95d50741fb04437bb6825fbb0e2d3ef WHERE A.SortingID = SortingID )
        AND NOT EXISTS (SELECT ISNULL(DeliveryID,'') FROM ShopTin WHERE Type=1 AND Posted=1 AND A.DeliveryID=DeliveryID)
             AND EXISTS (SELECT 1 FROM [##30824aebd583469c9ec33594d6014e2f] WHERE Goods_No = BG.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:15,408
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PureceiptQuantity = ISNULL(B.PureceiptQuantity,0), PureceiptOperator = B.Operator 
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef] A
    INNER JOIN (
    SELECT C.SortingID, A.Operator, SUM(ISNULL(B.Quantity,0)) As PureceiptQuantity 
    FROM ShopTin A 
    INNER JOIN ShopTinGoods B ON A.ShopTinID = B.ShopTinID 
    INNER JOIN [Delivery] C ON A.DeliveryID = C.DeliveryID 
        WHERE A.Type =1 AND A.Posted=1
        AND EXISTS( SELECT 1 FROM ##d95d50741fb04437bb6825fbb0e2d3ef WHERE C.SortingID = SortingID )
             AND EXISTS (SELECT 1 FROM [##30824aebd583469c9ec33594d6014e2f] WHERE Goods_No = B.Goods_No)
        GROUP BY C.SortingID, A.Operator
    ) B ON A.SortingID = B.SortingID


    时间: 2022-08-29 16:07:15,985
  线程ID: 65
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, SortingID AS [单号], Manual_ID AS [手工单号], Sorting_Date AS [日期]
     , [Type] AS [订单类型], OrderID AS [订货单号], RetailOrderID AS [零售订单号], rtrim(Warehouse_No) AS [仓库编号]
     , Warehouse_Na AS [仓库名称], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , DpAmount AS [吊牌额]
     , BalanceAmount AS [结算额]
     , Remark AS [备注], Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称],PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成]
     , BoxQuantity AS [业务状态#装箱数], BoxStatus AS [业务状态#装箱], OutStatus AS [业务状态#备货]
     , DeliveryQuantity AS [业务状态#出货数], DeliveryStatus AS [业务状态#出货], DiffQuantity AS [业务状态#欠数]
     , WayQuantity AS [业务状态#在途数], PureceiptQuantity AS [业务状态#收货数], PureceiptOperator AS [业务状态#收货人]
INTO tempdb.dbo.[e7283c57-d76e-4227-9c4b-276260be2654]
 FROM [##d95d50741fb04437bb6825fbb0e2d3ef]
 ORDER BY Sorting_Date DESC, SortingID ASC


    时间: 2022-08-29 16:08:32,740
  线程ID: 84
日志级别: 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.[16264add-54b7-498d-b2bb-8c21b25976b0]
FROM [##83a8f1fecac94e19b85b5b0125938050]
ORDER BY Goods_no


    时间: 2022-08-29 16:09:16,495
  线程ID: 84
日志级别: 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 [##43c35fcfb004494ba99c282df60be856]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-08-29 16:09:16,869
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##2f08ad77ebcc4a68bb71af04d2b6055c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-08-29 16:09:16,872
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##43c35fcfb004494ba99c282df60be856] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##2f08ad77ebcc4a68bb71af04d2b6055c]


    时间: 2022-08-29 16:09:16,928
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##3ebf6166e9a1404b92bfa4a85e7986df a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-08-29 16:09:16,930
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3ebf6166e9a1404b92bfa4a85e7986df SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


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


    时间: 2022-08-29 16:09:16,962
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3ebf6166e9a1404b92bfa4a85e7986df SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-08-29 16:09:16,963
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##3ebf6166e9a1404b92bfa4a85e7986df SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-08-29 16:09:16,967
  线程ID: 84
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##43c35fcfb004494ba99c282df60be856] (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 [##69e8be7327284f3e9d75dc804d5d2ff3]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-08-29 16:09:16,977
  线程ID: 84
日志级别: 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.[63d5eba6-a193-4c74-9187-929a72f05360]
FROM ##43c35fcfb004494ba99c282df60be856 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


    时间: 2022-08-29 17:52:34,747
  线程ID: 7
日志级别: 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.[1b0dda20-64fe-4484-ad4a-e3573d1a66fb]
FROM [##936a99f66fc84175a70be358eb0bcac2]
ORDER BY Goods_no


    时间: 2022-08-29 17:53:20,980
  线程ID: 12
日志级别: 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 [##705e7c73bf01434e844f93a696b476dc]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-08-29 17:53:21,319
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##835380800de04796ab3f0907543a41b2] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-08-29 17:53:21,322
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##705e7c73bf01434e844f93a696b476dc] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##835380800de04796ab3f0907543a41b2]


    时间: 2022-08-29 17:53:21,373
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##6c2973aa256048b7a0f879deeeab154a a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-08-29 17:53:21,375
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6c2973aa256048b7a0f879deeeab154a SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


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


    时间: 2022-08-29 17:53:21,404
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6c2973aa256048b7a0f879deeeab154a SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-08-29 17:53:21,406
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6c2973aa256048b7a0f879deeeab154a SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-08-29 17:53:21,409
  线程ID: 12
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##705e7c73bf01434e844f93a696b476dc] (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 [##653e5f9362584cd2bf6ac020b8a0b555]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-08-29 17:53:21,421
  线程ID: 12
日志级别: 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.[78b3180d-21ab-4bbd-a1c9-8ca558222cc7]
FROM ##705e7c73bf01434e844f93a696b476dc 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


    时间: 2022-08-29 17:55:04,661
  线程ID: 20
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[d754104f-ff1d-4453-bc3a-89dd7b322b29]
FROM [##df48e9944478418489629141d7c0dd49]
ORDER BY Goods_no


    时间: 2022-08-29 17:55:17,703
  线程ID: 24
日志级别: 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 [##2e8f11805447432b88f374a33f32e76e]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2022-08-29 17:55:18,051
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##8ceea7c8c9aa40369d269224edab154a] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2022-08-29 17:55:18,053
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2e8f11805447432b88f374a33f32e76e] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##8ceea7c8c9aa40369d269224edab154a]


    时间: 2022-08-29 17:55:18,104
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##6ce8ba01233d4be1af1e0a44fcbe8528 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2022-08-29 17:55:18,106
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6ce8ba01233d4be1af1e0a44fcbe8528 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


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


    时间: 2022-08-29 17:55:18,136
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6ce8ba01233d4be1af1e0a44fcbe8528 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2022-08-29 17:55:18,137
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6ce8ba01233d4be1af1e0a44fcbe8528 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2022-08-29 17:55:18,140
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##2e8f11805447432b88f374a33f32e76e] (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 [##f5bb866d7fc349d7a6b8c9f64493c1f3]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2022-08-29 17:55:18,143
  线程ID: 24
日志级别: 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.[78b3180d-21ab-4bbd-a1c9-8ca558222cc7]
FROM ##2e8f11805447432b88f374a33f32e76e 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