时间: 2021-08-23 10:20:32,742
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##ac002c1d86b44829aea0d75e3224f481]
ORDER BY Goods_no


    时间: 2021-08-23 10:20:37,770
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##59ddcba76bc443618c19c619975f344f]
ORDER BY Goods_no


    时间: 2021-08-23 10:20:38,583
  线程ID: 18
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##51f8b51bbf2e4645bc334d99b9567b69]
ORDER BY Goods_no


    时间: 2021-08-23 10:20:39,330
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##b1078d3eaa904c5fa3755f8fda853579]
ORDER BY Goods_no


    时间: 2021-08-23 13:45:00,508
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[6a95fe94-b94b-49d4-81e7-940354d2defe]
 FROM Customer A
 INNER JOIN [##2e5f4fe168bd4c81b73dbb877d402433] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


    时间: 2021-08-23 13:53:40,601
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##f012378d7e244582a7c96c87196e3d2c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-08-23 13:53:40,608
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##f012378d7e244582a7c96c87196e3d2c] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##f012378d7e244582a7c96c87196e3d2c WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##2492580868874750b9154492b5983936] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-08-23 13:53:40,807
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[0505a131-19b2-4fe9-adbf-f402735c441b]
 FROM [##f012378d7e244582a7c96c87196e3d2c]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-08-23 13:57:26,433
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##ac5070d93c314e54add9b5bbc2a76ae5] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-08-23 13:57:26,438
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##ac5070d93c314e54add9b5bbc2a76ae5] A
    INNER JOIN (
        SELECT A.BalanceID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(B.UnitPrice,0) ) As DpAmount
        FROM [BalanceGoods] A 
             INNER JOIN Goods B ON A.Goods_No = B.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##ac5070d93c314e54add9b5bbc2a76ae5 WHERE A.BalanceID = BalanceID )
     AND EXISTS (SELECT 1 FROM [##090bafc493174f4f8128cc4c1a121ba1] WHERE Goods_No = A.Goods_No)
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-08-23 13:57:26,635
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BalanceID AS [单号], Manual_ID AS [手工单号], Balance_Date [日期]
, rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称]
, Quantity AS [数量]
, DpAmount AS [吊牌额]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], Balance_Date AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[0505a131-19b2-4fe9-adbf-f402735c441b]
 FROM [##ac5070d93c314e54add9b5bbc2a76ae5]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-08-23 14:09:00,091
  线程ID: 70
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f0c79f755b174b32beb45a7d32ea19cb]
ORDER BY Goods_no


    时间: 2021-08-23 14:09:28,885
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(NULL AS SMALLINT) AS ItemType, CAST(NULL AS VARCHAR(50) ) AS Customer_ID, B.Goods_No, C.ColorID, C.Long
    , CAST(NULL AS INT) AS [渠道库存#数量], CAST(C.[S1] AS INT) AS [渠道库存#S1]
    , CAST(NULL AS INT) AS [仓库库存#数量], CAST(C.[S1] AS INT) AS [仓库库存#S1]
    , CAST(NULL AS INT) AS [仓库可用库存#数量],CAST(C.[S1] AS INT) AS [仓库可用库存#S1]
    , CAST(NULL AS INT) AS [批发在途#数量]
    , CAST(NULL AS INT) AS [调拨在途#数量]
    , CAST(NULL AS INT) AS [7DayCheckQuantity]
    , CAST(NULL AS INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##7520caf595ec47d2a2fc704305e72218]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-08-23 14:09:29,210
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##a0c7c057398b40808be8a79bf1a4afca] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-08-23 14:09:29,212
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7520caf595ec47d2a2fc704305e72218] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##a0c7c057398b40808be8a79bf1a4afca]


    时间: 2021-08-23 14:09:29,285
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##f2c40123ba834996b1a0d11ecc29fb05 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2021-08-23 14:09:29,288
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##f2c40123ba834996b1a0d11ecc29fb05 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 = '退货' 


    时间: 2021-08-23 14:09:29,318
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f2c40123ba834996b1a0d11ecc29fb05 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-08-23 14:09:29,320
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##f2c40123ba834996b1a0d11ecc29fb05 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-08-23 14:09:29,324
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##7520caf595ec47d2a2fc704305e72218] (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 [##5de2315caf844d48b0c131ca62397d86]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-08-23 14:09:29,336
  线程ID: 56
日志级别: 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.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##7520caf595ec47d2a2fc704305e72218 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


    时间: 2021-08-23 14:15:51,847
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[ab1ad726-78b2-404d-9529-01a9fccbc451]
 FROM Customer A
 INNER JOIN [##a66bb07e89ed45df9521a0ddd7c04147] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


    时间: 2021-08-23 14:37:53,512
  线程ID: 29
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##9a1656b0c3fa4c3b8ab64bc3f4796621]
ORDER BY Goods_no


    时间: 2021-08-23 14:38:07,138
  线程ID: 32
日志级别: 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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##255f7f7eb10c4b508973fbba708bd8f7]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-08-23 14:38:07,473
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##01b813af6a3e416bad8478cbfde2171c] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-08-23 14:38:07,475
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##255f7f7eb10c4b508973fbba708bd8f7] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##01b813af6a3e416bad8478cbfde2171c]


    时间: 2021-08-23 14:38:07,543
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##c4f46fee7bf342d3bd52e6f253f99360 a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-23 14:38:07,545
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c4f46fee7bf342d3bd52e6f253f99360 SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-08-23 14:38:07,548
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##c4f46fee7bf342d3bd52e6f253f99360 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 = '退货' 


    时间: 2021-08-23 14:38:07,577
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c4f46fee7bf342d3bd52e6f253f99360 SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-08-23 14:38:07,579
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##c4f46fee7bf342d3bd52e6f253f99360 SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-08-23 14:38:07,582
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##255f7f7eb10c4b508973fbba708bd8f7] (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 [##4c1ef21b4a404c10a491a7ab60a6081c]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-08-23 14:38:07,588
  线程ID: 32
日志级别: 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.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##255f7f7eb10c4b508973fbba708bd8f7 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


    时间: 2021-08-23 14:39:36,733
  线程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 INT) AS [15DayCheckQuantity]
    , CAST(NULL AS INT) AS [30DayCheckQuantity]
    , CAST(NULL AS INT) AS [AllDayCheckQuantity]
    , 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 [##6a78dfe9bc4f4ecfb97c3a2515d6386c]
FROM Customer A, Barcode B, DeliveryDetail C


    时间: 2021-08-23 14:39:37,065
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: delete [##83362a5dba0a4292abfcc9f1f7acb2e0] 
where 2=2
 and ISNULL(S1,0)=0 

    时间: 2021-08-23 14:39:37,066
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6a78dfe9bc4f4ecfb97c3a2515d6386c] (Customer_ID, Goods_No, ColorID, Long, [渠道库存#S1], 渠道库存#数量)
SELECT Customer_ID, Goods_No, ColorID, Long, [S1], (ISNULL([S1], 0))
FROM [##83362a5dba0a4292abfcc9f1f7acb2e0]


    时间: 2021-08-23 14:39:37,138
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
   FROM ##43bb332bbd5e4fd08732a2d1efff5a4e a 
         INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-23 14:39:37,141
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##43bb332bbd5e4fd08732a2d1efff5a4e SET CheckSaleType='线上发货' 
     WHERE ( CheckSaleType = '正常' OR LEN(ISNULL(CheckSaleType, '')) = 0 )
         AND LEN(ISNULL(RetailOrderID, '')) > 0 
         AND Status <> '退货'


    时间: 2021-08-23 14:39:37,143
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.CheckSaleType = b.SaleType
FROM ##43bb332bbd5e4fd08732a2d1efff5a4e 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 = '退货' 


    时间: 2021-08-23 14:39:37,174
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##43bb332bbd5e4fd08732a2d1efff5a4e SET CheckSaleType='线上发货' 
     WHERE LEN(ISNULL(RetailOrderID, '')) > 0 
         AND LEN(ISNULL(PreSaleID, '')) = 0 
         AND Status = '退货'


    时间: 2021-08-23 14:39:37,175
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##43bb332bbd5e4fd08732a2d1efff5a4e SET CheckSaleType='正常销售' 
     WHERE CheckSaleType='正常' OR LEN(ISNULL(CheckSaleType, '')) = 0  


    时间: 2021-08-23 14:39:37,178
  线程ID: 36
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##6a78dfe9bc4f4ecfb97c3a2515d6386c] (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 [##f47dee3db15c486188c5ab365ca6042e]
GROUP BY  Customer_ID, Goods_NO, ColorID, Long


    时间: 2021-08-23 14:39:37,184
  线程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.[a1e931b4-99af-434a-9b05-fbb0c874355e]
FROM ##6a78dfe9bc4f4ecfb97c3a2515d6386c 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


    时间: 2021-08-23 19:11:28,137
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##c2b96a9c53c342559f83f2575dc9e214]
ORDER BY Goods_no


    时间: 2021-08-23 19:17:09,782
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##a97404376e934370a5009b2390633541] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:17:09,788
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##a97404376e934370a5009b2390633541] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##a97404376e934370a5009b2390633541] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:09,793
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##a97404376e934370a5009b2390633541] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##a97404376e934370a5009b2390633541] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:09,796
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##a97404376e934370a5009b2390633541 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##a97404376e934370a5009b2390633541 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##be42f4388e8f4c2da344fa28d721f26e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:17:09,855
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##a97404376e934370a5009b2390633541 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##a97404376e934370a5009b2390633541 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##be42f4388e8f4c2da344fa28d721f26e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:17:09,915
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##a97404376e934370a5009b2390633541 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##a97404376e934370a5009b2390633541 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##be42f4388e8f4c2da344fa28d721f26e] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:10,031
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##a97404376e934370a5009b2390633541 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##a97404376e934370a5009b2390633541 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##be42f4388e8f4c2da344fa28d721f26e] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:10,528
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##a97404376e934370a5009b2390633541 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##a97404376e934370a5009b2390633541 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##be42f4388e8f4c2da344fa28d721f26e] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:10,745
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##a97404376e934370a5009b2390633541
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:17:10,747
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##a97404376e934370a5009b2390633541] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##a97404376e934370a5009b2390633541] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:17:17,222
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##64a2a362fdd142cabed5cb56fe9ae6d7] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:17:17,225
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##64a2a362fdd142cabed5cb56fe9ae6d7] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##64a2a362fdd142cabed5cb56fe9ae6d7] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:17,231
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##64a2a362fdd142cabed5cb56fe9ae6d7] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##64a2a362fdd142cabed5cb56fe9ae6d7] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:17,233
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##f56e14fd0d944cfaa7b360171a025940] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:17:17,295
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##f56e14fd0d944cfaa7b360171a025940] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:17:17,356
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f56e14fd0d944cfaa7b360171a025940] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:17,472
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f56e14fd0d944cfaa7b360171a025940] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:17,969
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##64a2a362fdd142cabed5cb56fe9ae6d7 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##f56e14fd0d944cfaa7b360171a025940] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:18,179
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##64a2a362fdd142cabed5cb56fe9ae6d7
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:17:18,181
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##64a2a362fdd142cabed5cb56fe9ae6d7] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##64a2a362fdd142cabed5cb56fe9ae6d7] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:17:18,496
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##3c97d0999e8b47739458f929c0b6d4c2] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:17:18,499
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##3c97d0999e8b47739458f929c0b6d4c2] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##3c97d0999e8b47739458f929c0b6d4c2] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:18,505
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##3c97d0999e8b47739458f929c0b6d4c2] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##3c97d0999e8b47739458f929c0b6d4c2] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:18,508
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##3c97d0999e8b47739458f929c0b6d4c2 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##3c97d0999e8b47739458f929c0b6d4c2 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##1175babe01e0456cae6453e152df0bb4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:17:18,565
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##3c97d0999e8b47739458f929c0b6d4c2 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##3c97d0999e8b47739458f929c0b6d4c2 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##1175babe01e0456cae6453e152df0bb4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:17:18,626
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##3c97d0999e8b47739458f929c0b6d4c2 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##3c97d0999e8b47739458f929c0b6d4c2 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1175babe01e0456cae6453e152df0bb4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:18,739
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##3c97d0999e8b47739458f929c0b6d4c2 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##3c97d0999e8b47739458f929c0b6d4c2 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1175babe01e0456cae6453e152df0bb4] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:19,237
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##3c97d0999e8b47739458f929c0b6d4c2 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##3c97d0999e8b47739458f929c0b6d4c2 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1175babe01e0456cae6453e152df0bb4] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:19,446
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##3c97d0999e8b47739458f929c0b6d4c2
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:17:19,447
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##3c97d0999e8b47739458f929c0b6d4c2] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##3c97d0999e8b47739458f929c0b6d4c2] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:17:19,760
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##4babf85bafa4426391a02ba0692b9a9e] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:17:19,763
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4babf85bafa4426391a02ba0692b9a9e] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##4babf85bafa4426391a02ba0692b9a9e] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:19,768
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##4babf85bafa4426391a02ba0692b9a9e] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##4babf85bafa4426391a02ba0692b9a9e] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:19,770
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##4babf85bafa4426391a02ba0692b9a9e A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##4babf85bafa4426391a02ba0692b9a9e WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##a4516119a66c42ba884e3bf1d4b224d6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:17:19,829
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##4babf85bafa4426391a02ba0692b9a9e A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##4babf85bafa4426391a02ba0692b9a9e WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##a4516119a66c42ba884e3bf1d4b224d6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:17:19,890
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##4babf85bafa4426391a02ba0692b9a9e A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##4babf85bafa4426391a02ba0692b9a9e WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##a4516119a66c42ba884e3bf1d4b224d6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:20,004
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##4babf85bafa4426391a02ba0692b9a9e A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##4babf85bafa4426391a02ba0692b9a9e WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##a4516119a66c42ba884e3bf1d4b224d6] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:20,504
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##4babf85bafa4426391a02ba0692b9a9e A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##4babf85bafa4426391a02ba0692b9a9e C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##a4516119a66c42ba884e3bf1d4b224d6] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:20,714
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##4babf85bafa4426391a02ba0692b9a9e
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:17:20,716
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##4babf85bafa4426391a02ba0692b9a9e] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##4babf85bafa4426391a02ba0692b9a9e] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:17:22,940
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##d4f080ae358344efb81101541f1369f2] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:17:22,947
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d4f080ae358344efb81101541f1369f2] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##d4f080ae358344efb81101541f1369f2] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:22,954
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##d4f080ae358344efb81101541f1369f2] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##d4f080ae358344efb81101541f1369f2] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:22,957
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##d4f080ae358344efb81101541f1369f2 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##d4f080ae358344efb81101541f1369f2 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##1b4401169747407da7f4f65bf15e56d6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:17:23,050
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##d4f080ae358344efb81101541f1369f2 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##d4f080ae358344efb81101541f1369f2 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##1b4401169747407da7f4f65bf15e56d6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:17:23,143
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##d4f080ae358344efb81101541f1369f2 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##d4f080ae358344efb81101541f1369f2 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1b4401169747407da7f4f65bf15e56d6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:23,327
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##d4f080ae358344efb81101541f1369f2 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##d4f080ae358344efb81101541f1369f2 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1b4401169747407da7f4f65bf15e56d6] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:23,717
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##d4f080ae358344efb81101541f1369f2 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##d4f080ae358344efb81101541f1369f2 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##1b4401169747407da7f4f65bf15e56d6] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:23,859
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##d4f080ae358344efb81101541f1369f2
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:17:23,861
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##d4f080ae358344efb81101541f1369f2] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##d4f080ae358344efb81101541f1369f2] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:17:24,917
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##e3a51790db8144d0a5792d1f52d66904] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:17:24,923
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##e3a51790db8144d0a5792d1f52d66904] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##e3a51790db8144d0a5792d1f52d66904] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:24,931
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##e3a51790db8144d0a5792d1f52d66904] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##e3a51790db8144d0a5792d1f52d66904] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:17:24,934
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##e3a51790db8144d0a5792d1f52d66904 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##e3a51790db8144d0a5792d1f52d66904 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##2bfc0e233c264df2890e03f25832baba] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:17:25,026
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##e3a51790db8144d0a5792d1f52d66904 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##e3a51790db8144d0a5792d1f52d66904 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##2bfc0e233c264df2890e03f25832baba] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:17:25,121
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##e3a51790db8144d0a5792d1f52d66904 A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##e3a51790db8144d0a5792d1f52d66904 WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2bfc0e233c264df2890e03f25832baba] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:25,303
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##e3a51790db8144d0a5792d1f52d66904 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##e3a51790db8144d0a5792d1f52d66904 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2bfc0e233c264df2890e03f25832baba] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:25,696
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##e3a51790db8144d0a5792d1f52d66904 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##e3a51790db8144d0a5792d1f52d66904 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##2bfc0e233c264df2890e03f25832baba] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:17:25,837
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##e3a51790db8144d0a5792d1f52d66904
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:17:25,839
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##e3a51790db8144d0a5792d1f52d66904] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##e3a51790db8144d0a5792d1f52d66904] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:19:12,587
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##c587195e178c4429a2670cafa4fe5a1a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-08-23 19:19:12,595
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##c587195e178c4429a2670cafa4fe5a1a] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##c587195e178c4429a2670cafa4fe5a1a] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-08-23 19:19:12,603
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##c587195e178c4429a2670cafa4fe5a1a] SET IsInStock = CASE WHEN (select 1 from PuReceipt B where B.DeliveryID = A.DeliveryID) = 1 THEN 1 ELSE 0 END 
 FROM [##c587195e178c4429a2670cafa4fe5a1a] A 
 WHERE 1 = 1 


    时间: 2021-08-23 19:19:12,606
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##c587195e178c4429a2670cafa4fe5a1a A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##c587195e178c4429a2670cafa4fe5a1a WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##afc11e50fea6433881e3f717b2ba2bfa] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-08-23 19:19:12,700
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##c587195e178c4429a2670cafa4fe5a1a A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##c587195e178c4429a2670cafa4fe5a1a WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##afc11e50fea6433881e3f717b2ba2bfa] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-08-23 19:19:12,794
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##c587195e178c4429a2670cafa4fe5a1a A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##c587195e178c4429a2670cafa4fe5a1a WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##afc11e50fea6433881e3f717b2ba2bfa] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:19:13,057
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##c587195e178c4429a2670cafa4fe5a1a A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##c587195e178c4429a2670cafa4fe5a1a WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##afc11e50fea6433881e3f717b2ba2bfa] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:19:13,456
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##c587195e178c4429a2670cafa4fe5a1a A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##c587195e178c4429a2670cafa4fe5a1a C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##afc11e50fea6433881e3f717b2ba2bfa] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-08-23 19:19:13,597
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##c587195e178c4429a2670cafa4fe5a1a
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


    时间: 2021-08-23 19:19:13,599
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET BoxCount = ISNULL(B.BoxCount,0)
 FROM [##c587195e178c4429a2670cafa4fe5a1a] A
    INNER JOIN (
        SELECT A.AccBillNo As DeliveryID, COUNT(DISTINCT A.BoxNo) AS BoxCount
        FROM BoxBill A INNER JOIN Boxes B ON A.BoxNo = B.BoxNo
        WHERE A.AccBillType = 'WareDelivery' 
          AND EXISTS( SELECT 1 FROM [##c587195e178c4429a2670cafa4fe5a1a] WHERE A.AccBillNo = DeliveryID )
        GROUP BY A.AccBillNo
    ) B ON A.DeliveryID = B.DeliveryID


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


    时间: 2021-08-23 19:31:35,289
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##e1668194650d47ba88fb7c098251006a]
ORDER BY Goods_no


    时间: 2021-08-23 19:32:42,911
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##dd7463d30d7e46648ac6cfc1d673b632]
ORDER BY Goods_no


    时间: 2021-08-23 19:33:49,791
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##cbb97096d7094e5faebea9c27f465a25]
ORDER BY Goods_no


    时间: 2021-08-23 19:34:16,179
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##0fb7cdd3bca649f5930bf569e6ffe396]
ORDER BY Goods_no


    时间: 2021-08-23 19:34:43,083
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##7c3e0e1be3dc498cb7f918db3e604e76]
ORDER BY Goods_no


    时间: 2021-08-23 19:35:32,372
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##14dc655a4bd34c65bb90e7aa0bdd57f1]
ORDER BY Goods_no


    时间: 2021-08-23 19:36:11,400
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##2079f6ba70ef47e59c000dd16a5f0116]
ORDER BY Goods_no


    时间: 2021-08-23 19:36:32,124
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##5072f39c75bb4eba8c1fe96b8d008bd7]
ORDER BY Goods_no


    时间: 2021-08-23 19:36:45,354
  线程ID: 80
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##c0636436f9db4ed490f7c676395ad637]
ORDER BY Goods_no


    时间: 2021-08-23 19:37:04,809
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##2c5b3f797ddc456e80a48dfe78652f8e]
ORDER BY Goods_no


    时间: 2021-08-23 19:37:32,750
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##4437a2fa5f664dd0aab1efed268c8fff]
ORDER BY Goods_no


    时间: 2021-08-23 19:37:46,182
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##1bb16e308b2b4d58b393384519e58df5]
ORDER BY Goods_no


    时间: 2021-08-23 19:38:12,156
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##9c6bd636e6e6435299b54dca7f4455d0]
ORDER BY Goods_no


    时间: 2021-08-23 19:38:35,701
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##d60133e1f8c64f17879de0a4dbe72a0d]
ORDER BY Goods_no


    时间: 2021-08-23 19:38:36,437
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##9f777b7da56141d7ad48aad56ec295bd]
ORDER BY Goods_no


    时间: 2021-08-23 19:39:01,866
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##b0a047579d1c4a94b1d093edef4b8273]
ORDER BY Goods_no


    时间: 2021-08-23 19:39:31,435
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##0dd3f4526e2d48df9b93566515b5509d]
ORDER BY Goods_no


    时间: 2021-08-23 19:40:19,785
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##17f95ae0b6be44749697f1840123a96f]
ORDER BY Goods_no


    时间: 2021-08-23 19:41:03,085
  线程ID: 64
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##8aad36b2357b4f50bf0645c973de6c9d]
ORDER BY Goods_no


    时间: 2021-08-23 19:41:31,403
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##718b8cf7ea014067a77fcb947d43d6ff]
ORDER BY Goods_no


    时间: 2021-08-23 19:41:56,503
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f17fa46c14b040929a5b23a24b94836f]
ORDER BY Goods_no


    时间: 2021-08-23 19:42:16,428
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##2317f776c8f94b6b826cad04d390ae12]
ORDER BY Goods_no


    时间: 2021-08-23 19:42:49,054
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##f35e25439ec54af18ac24defbaf20509]
ORDER BY Goods_no


    时间: 2021-08-23 19:43:31,878
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##a9691f4b9485451fae963bd75e836ae3]
ORDER BY Goods_no


    时间: 2021-08-23 19:43:57,477
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##cfa542af14bf442680235733d8d7b1ae]
ORDER BY Goods_no


    时间: 2021-08-23 19:44:22,631
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##65c102fa5d7a406aa06fc681ee4f1ad5]
ORDER BY Goods_no


    时间: 2021-08-23 19:44:48,751
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##7baf0094e05c458f8de4817763a0a0d1]
ORDER BY Goods_no


    时间: 2021-08-23 19:45:26,080
  线程ID: 88
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##7e9df27a7c6141999d3cfe8c62bb9650]
ORDER BY Goods_no


    时间: 2021-08-23 19:45:26,800
  线程ID: 81
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##092bc059595b4c99b7bbc320264c80c6]
ORDER BY Goods_no


    时间: 2021-08-23 19:45:49,930
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##809353fa837d44b49b89f8781a5de1d1]
ORDER BY Goods_no


    时间: 2021-08-23 19:46:14,265
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##d6686bd57fbc45809b128916a952788e]
ORDER BY Goods_no


    时间: 2021-08-23 19:46:29,106
  线程ID: 89
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌]
,Category AS [一级类别], Category2 AS [二级类别]
,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权]
,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价]
,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[ffd27388-1648-40d6-80d7-3b0523b6ad5b]
FROM [##86d47a451c23482eb0e612f07c947ba7]
ORDER BY Goods_no