时间: 2021-01-16 13:54:20,132
  线程ID: 42
日志级别: 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.[2065db20-375b-41bc-a936-527a4b8899be]
 FROM Customer A
 INNER JOIN [##82d551b1fe49497893642cf64ccd6fcf] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


    时间: 2021-01-16 20:24:09,889
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:      UPDATE A SET SaleType='线上发货'
     FROM [##732ae34f028f4da88a7956a0770f82f3] A 
     WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') 
     AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' 
UPDATE [##732ae34f028f4da88a7956a0770f82f3]  SET SaleType='正常销售' 
WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' 
DELETE FROM [##732ae34f028f4da88a7956a0770f82f3] WHERE 1=1
AND NOT EXISTS(SELECT 1 FROM ##3ff44368fdfd4d9caafbf8d80edb6ea8 B WHERE B.data = SaleType)


    时间: 2021-01-16 20:24:09,897
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE [##732ae34f028f4da88a7956a0770f82f3] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID

    时间: 2021-01-16 20:24:09,898
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##732ae34f028f4da88a7956a0770f82f3] A
 WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 


    时间: 2021-01-16 20:24:09,900
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##732ae34f028f4da88a7956a0770f82f3] A
    INNER JOIN (
        SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount
        FROM [vn_CheckGoods] A 
             INNER JOIN vn_Check B ON A.CheckID = B.CheckID
             LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID
             LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##732ae34f028f4da88a7956a0770f82f3 WHERE A.CheckID = CheckID )
     AND EXISTS (SELECT 1 FROM [##1fef98cf49184294b7cd734afbc46404] WHERE Goods_No = A.Goods_No)
        GROUP BY A.CheckID
    ) B ON A.CheckID = B.CheckID


    时间: 2021-01-16 20:24:09,934
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT DISTINCT * INTO [##9f7578aed65d4fedbd6160219c78a79a] FROM [##732ae34f028f4da88a7956a0770f82f3]

    时间: 2021-01-16 20:24:09,988
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期]
, Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
        , DpAmount AS [吊牌额]
, Amount AS [生意额]
, JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期]
, Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期]
, Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期]
, PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[d67c14ff-6419-48f7-8b91-04b3e90dd169]
 FROM [##9f7578aed65d4fedbd6160219c78a79a]
 ORDER BY CheckDate DESC, CheckID ASC


    时间: 2021-01-16 20:24:16,145
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:      UPDATE A SET SaleType='线上发货'
     FROM [##ef9b483d386e4695a46a1bc80a8cf6f0] A 
     WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') 
     AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' 
UPDATE [##ef9b483d386e4695a46a1bc80a8cf6f0]  SET SaleType='正常销售' 
WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' 
DELETE FROM [##ef9b483d386e4695a46a1bc80a8cf6f0] WHERE 1=1
AND NOT EXISTS(SELECT 1 FROM ##d9a4707bea624a75ab30a31d8545d024 B WHERE B.data = SaleType)


    时间: 2021-01-16 20:24:16,151
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE [##ef9b483d386e4695a46a1bc80a8cf6f0] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID

    时间: 2021-01-16 20:24:16,152
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##ef9b483d386e4695a46a1bc80a8cf6f0] A
 WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 


    时间: 2021-01-16 20:24:16,155
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##ef9b483d386e4695a46a1bc80a8cf6f0] A
    INNER JOIN (
        SELECT A.CheckID, SUM(ISNULL(A.Quantity,0)) As Quantity, 
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.DiscountPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(GDP.DpPriceByRetail,0) ) As DpAmount
        FROM [vn_CheckGoods] A 
             INNER JOIN vn_Check B ON A.CheckID = B.CheckID
             LEFT JOIN [Customer] CT ON CT.Customer_ID=B.Customer_ID
             LEFT JOIN vGoodsDpPrice GDP ON CT.Customer_ID = GDP.Customer_ID AND A.Goods_No = GDP.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##ef9b483d386e4695a46a1bc80a8cf6f0 WHERE A.CheckID = CheckID )
     AND EXISTS (SELECT 1 FROM [##6c9ac26ab96d469da7ba731521f8f12b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.CheckID
    ) B ON A.CheckID = B.CheckID


    时间: 2021-01-16 20:24:16,211
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT DISTINCT * INTO [##a1e140f42a8d4923a3b3aa33ea79c476] FROM [##ef9b483d386e4695a46a1bc80a8cf6f0]

    时间: 2021-01-16 20:24:16,225
  线程ID: 32
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CheckID AS [单号], Manual_ID AS [手工单号], CheckDate AS [日期]
, Customer_ID AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
        , DpAmount AS [吊牌额]
, Amount AS [生意额]
, JiZhang AS [记账状态#记账], JzOperator AS [记账状态#记账人], JzDate AS [记账状态#记账日期]
, Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期]
, Posted AS [单据状态#审核], PostUser AS [单据状态#审核人],PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期]
, PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[d67c14ff-6419-48f7-8b91-04b3e90dd169]
 FROM [##a1e140f42a8d4923a3b3aa33ea79c476]
 ORDER BY CheckDate DESC, CheckID ASC


    时间: 2021-01-16 20:41:12,148
  线程ID: 68
日志级别: 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.[8159ff6e-7b44-4c12-8b9a-78d380704872]
 FROM Customer A
 INNER JOIN [##16bef36d75f046258f68492a5c84c8f3] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID