时间: 2021-01-14 13:59:22,261
  线程ID: 39
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##b176ec5d67a14432b83c8433711100fd]
ORDER BY Goods_no


    时间: 2021-01-14 13:59:26,781
  线程ID: 59
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##f6b47e2250584cfb8de6cd8e04b58ced]
ORDER BY Goods_no


    时间: 2021-01-14 13:59:28,135
  线程ID: 56
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##0d7ef9409244454f94d708117cfec85d]
ORDER BY Goods_no


    时间: 2021-01-14 13:59:28,280
  线程ID: 63
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##2b3d8741192e4eb7af9822a398a7a1ea]
ORDER BY Goods_no


    时间: 2021-01-14 13:59:28,431
  线程ID: 39
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##fe0e6021d831418c8b5dea90f3b3bd31]
ORDER BY Goods_no


    时间: 2021-01-14 13:59:28,586
  线程ID: 39
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##df4ab8be3e484ea980fafcbd2b7175a2]
ORDER BY Goods_no


    时间: 2021-01-14 13:59:36,032
  线程ID: 61
日志级别: 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.[33c2640a-ca90-4d81-a020-2553af309a36]
FROM [##4c6a86e916ae4b37ba2df4a2d7f22eab]
ORDER BY Goods_no


    时间: 2021-01-14 16:47:43,998
  线程ID: 45
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9c7cedc83670453e8cd5590cc1169baa] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-14 16:47:44,015
  线程ID: 45
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##9c7cedc83670453e8cd5590cc1169baa] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##9c7cedc83670453e8cd5590cc1169baa WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##55bb086a7a9c4d5b9547e8f92ea645c6] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-14 16:47:44,131
  线程ID: 45
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[29fb4c4b-2f1c-4dd8-b9e1-49d4eeca2f23]
 FROM [##9c7cedc83670453e8cd5590cc1169baa]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-14 16:50:55,494
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##473bd34817e34914bd29aa0410151465] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-14 16:50:55,497
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##473bd34817e34914bd29aa0410151465] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##473bd34817e34914bd29aa0410151465 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d06f25018ac44db9a0fab92aed6ebf76] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-14 16:50:55,611
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[9f43741e-13b2-4cf5-8e26-3d6b1adfda8d]
 FROM [##473bd34817e34914bd29aa0410151465]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-14 17:04:45,322
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##22532ced2ad54b5bb38ffcf8247900de] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-14 17:04:45,325
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##22532ced2ad54b5bb38ffcf8247900de] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##22532ced2ad54b5bb38ffcf8247900de WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##56162fceaf1f4f1ea602940a7455a280] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-14 17:04:45,428
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [盘点日期], rtrim(Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[9f43741e-13b2-4cf5-8e26-3d6b1adfda8d]
 FROM [##22532ced2ad54b5bb38ffcf8247900de]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-14 17:06:56,949
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:      UPDATE A SET SaleType='线上发货'
     FROM [##fe32ec29ba494723b679d1f41da70e5c] A 
     WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') 
     AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' 
UPDATE [##fe32ec29ba494723b679d1f41da70e5c]  SET SaleType='正常销售' 
WHERE SaleType='正常' OR SaleType IS NULL OR SaleType = '' 
DELETE FROM [##fe32ec29ba494723b679d1f41da70e5c] WHERE 1=1
AND NOT EXISTS(SELECT 1 FROM ##83e5dc696ade4d999e7176227a532c3a B WHERE B.data = SaleType)


    时间: 2021-01-14 17:06:56,955
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE [##fe32ec29ba494723b679d1f41da70e5c] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID

    时间: 2021-01-14 17:06:56,957
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##fe32ec29ba494723b679d1f41da70e5c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'ShopCheck2' AND A.CheckID = BillNo ) 


    时间: 2021-01-14 17:06:56,959
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##fe32ec29ba494723b679d1f41da70e5c] 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 ##fe32ec29ba494723b679d1f41da70e5c WHERE A.CheckID = CheckID )
     AND EXISTS (SELECT 1 FROM [##42c3b206a92d47d3b4031e5bb86d449c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.CheckID
    ) B ON A.CheckID = B.CheckID


    时间: 2021-01-14 17:06:57,000
  线程ID: 38
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT DISTINCT * INTO [##174c296f1097426093a609079f90aeba] FROM [##fe32ec29ba494723b679d1f41da70e5c]

    时间: 2021-01-14 17:06:57,009
  线程ID: 38
日志级别: 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.[a3522c2c-1a97-415c-b4c6-a98ab7e3f179]
 FROM [##174c296f1097426093a609079f90aeba]
 ORDER BY CheckDate DESC, CheckID ASC


    时间: 2021-01-14 17:08:12,934
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(CT.Company_ID AS VARCHAR(50)) AS Company_ID, A.Customer_ID, B.Goods_No, C.ColorID, CAST('' AS VARCHAR(50)) AS Long
    , 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 库存合计#数量
INTO [##ba0277c6e419415e811f259cdc8edd9d]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-01-14 17:08:13,169
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ba0277c6e419415e811f259cdc8edd9d] (Company_ID, Customer_ID, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT CT.Company_ID, A.Customer_ID, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##4f232311633f48f8935d5bf54e7da462] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-01-14 17:48:44,718
  线程ID: 16
日志级别: 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.[8ef689c9-bec9-45ef-ae27-3c7be34eab29]
 FROM Customer A
 INNER JOIN [##d009ec8f414b4eedba9d7c491e243e98] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


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


    时间: 2021-01-14 17:50:53,896
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE [##6e7f353c6c2047b299459b1926ac381a] DROP COLUMN SaleType, OnlineSaleTypeID, RetailOrderID

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


    时间: 2021-01-14 17:50:53,899
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##6e7f353c6c2047b299459b1926ac381a] 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 ##6e7f353c6c2047b299459b1926ac381a WHERE A.CheckID = CheckID )
     AND EXISTS (SELECT 1 FROM [##4e1b43bde973497e8fa0238a6d17a3d4] WHERE Goods_No = A.Goods_No)
        GROUP BY A.CheckID
    ) B ON A.CheckID = B.CheckID


    时间: 2021-01-14 17:50:53,941
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT DISTINCT * INTO [##c06ec0aa736d43d8994fa7db07a0d748] FROM [##6e7f353c6c2047b299459b1926ac381a]

    时间: 2021-01-14 17:50:53,946
  线程ID: 16
日志级别: 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.[71dfa95c-d781-41df-b990-788edef63ff5]
 FROM [##c06ec0aa736d43d8994fa7db07a0d748]
 ORDER BY CheckDate DESC, CheckID ASC


    时间: 2021-01-14 17:51:23,344
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##e99236cf2f75491d93f421ac281ed149] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CMoveOut' AND A.ShopToutID = BillNo )


    时间: 2021-01-14 17:51:23,351
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##e99236cf2f75491d93f421ac281ed149] SET IsForWay = 1 
 WHERE NOT Exists( 
      SELECT ShopToutID FROM ShopTin 
      WHERE 1 = 1 AND [##e99236cf2f75491d93f421ac281ed149].ShopToutID = ShopToutID)


    时间: 2021-01-14 17:51:23,354
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##e99236cf2f75491d93f421ac281ed149] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##e99236cf2f75491d93f421ac281ed149] A INNER JOIN  ShopTin B ON A.ShopToutID = B.ShopToutID
 WHERE 1 = 1 


    时间: 2021-01-14 17:51:23,357
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##e99236cf2f75491d93f421ac281ed149] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(ISNULL(A.Quantity,0)) As Quantity,
               SUM(ISNULL(A.Quantity,0) * ISNULL(A.BalancePrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopToutGoods] A 
             INNER JOIN ShopTout B ON A.ShopToutID = B.ShopToutID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.ToutShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##e99236cf2f75491d93f421ac281ed149 WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##d32adb28bb264db1aa320eb9e8a26452] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-01-14 17:51:23,515
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ShopTinQuantity = ISNULL(B.Quantity,0), IsReceive = (CASE WHEN ISNULL(B.Quantity,0)<>0 THEN 1 ELSE 0 END) 
 FROM [##e99236cf2f75491d93f421ac281ed149] A
    INNER JOIN (
        SELECT A.ShopToutID, SUM(B.Quantity) AS Quantity 
        FROM ShopTin A 
        INNER JOIN [ShopTinSSGoods] B ON A.ShopTinID = B.ShopTinID
        WHERE EXISTS( SELECT 1 FROM [##e99236cf2f75491d93f421ac281ed149] WHERE A.ShopToutID = ShopToutID )
     AND EXISTS (SELECT 1 FROM [##d32adb28bb264db1aa320eb9e8a26452] WHERE Goods_No = B.Goods_No)
        GROUP BY A.ShopToutID
    ) B ON A.ShopToutID = B.ShopToutID


    时间: 2021-01-14 17:51:23,645
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##e99236cf2f75491d93f421ac281ed149] SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ShopTinQuantity,0) 

    时间: 2021-01-14 17:51:23,649
  线程ID: 7
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopToutID AS [单号], Manual_ID AS [手工单号], Tout_Date AS [日期]
, ShopApplyOutID AS [调出通知单], rtrim(ToutShop) AS [调出渠道编号], ToutShopAbbrev AS [调出渠道简称], rtrim(TinShop) AS [调入渠道编号]
, TinShopAbbrev AS [调入渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , ShopTinQuantity AS [业务状态#调入数], ChangeQuantity AS [业务状态#差异数]
     , IsForWay AS [业务状态#在途], IsReceive AS [业务状态#收货], IsInStock AS [业务状态#入库]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[deeb768c-aa1a-42cc-96b1-b3c1a0741524]
 FROM [##e99236cf2f75491d93f421ac281ed149]
 ORDER BY Tout_Date DESC, ShopToutID ASC


    时间: 2021-01-14 22:13:57,392
  线程ID: 37
日志级别: 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 [##9624ce863cf64593af9605c50b737f7d] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID