时间: 2021-03-15 10:17:41,162
  线程ID: 52
日志级别: 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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##27ed3ee267024987989dea370fd5167e]
ORDER BY Goods_no


    时间: 2021-03-15 10:17:45,822
  线程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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##58ebcbd9ea24455abd2b826507f75f73]
ORDER BY Goods_no


    时间: 2021-03-15 10:17:46,471
  线程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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##4aa7f56a5c0d42ac8775c685609938f8]
ORDER BY Goods_no


    时间: 2021-03-15 10:17:47,113
  线程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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##6a38d7d146cd411c8014702f934941b9]
ORDER BY Goods_no


    时间: 2021-03-15 10:17:47,751
  线程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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##cf3eb15364f543d681ebe286da4795a9]
ORDER BY Goods_no


    时间: 2021-03-15 11:55:27,961
  线程ID: 74
日志级别: 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 [##45a0ea2722ef456cbd3368196a18f6e8]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-03-15 11:55:28,248
  线程ID: 74
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##45a0ea2722ef456cbd3368196a18f6e8] (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 [##11c2619788f84cfb95eb6b2eb561a4c0] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-03-15 17:49:59,595
  线程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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##94c2340d7fab42038d1783eb41347682]
ORDER BY Goods_no


    时间: 2021-03-15 17:50:06,108
  线程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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##741ab686308d408788c1917afc67a04f]
ORDER BY Goods_no


    时间: 2021-03-15 17:50:32,944
  线程ID: 15
日志级别: 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.[c5220a97-3624-4610-8411-caafa7ca813b]
FROM [##fc6f8056980e4912af67c5186624e881]
ORDER BY Goods_no


    时间: 2021-03-15 17:54:06,911
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##ef1858998fbb4b62b3f604795b5daeec] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Crecive' AND A.ShopTinID = BillNo )


    时间: 2021-03-15 17:54:06,915
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##ef1858998fbb4b62b3f604795b5daeec] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinSSGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##ef1858998fbb4b62b3f604795b5daeec] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##4e9be65306634946be886fffb39ab677] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-15 17:54:06,980
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OriginalQuantity = ISNULL(B.Quantity,0)
 FROM [##ef1858998fbb4b62b3f604795b5daeec] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [ShopTinGoods] A 
        WHERE EXISTS( SELECT 1 FROM [##ef1858998fbb4b62b3f604795b5daeec] WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##4e9be65306634946be886fffb39ab677] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-15 17:54:07,042
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##ef1858998fbb4b62b3f604795b5daeec] A
    INNER JOIN (
        SELECT A.ShopTinID, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0) ) As Amount,
               SUM(ISNULL(A.Quantity,0) * ISNULL(C.DpPriceByBatch,0) ) As DpAmount
        FROM [ShopTinSSGoods] A 
             INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
             LEFT  JOIN vGoodsDpPrice C ON A.Goods_No = C.Goods_No AND B.TinShop = C.Customer_ID
        WHERE EXISTS( SELECT 1 FROM ##ef1858998fbb4b62b3f604795b5daeec WHERE A.ShopTinID = ShopTinID )
     AND EXISTS (SELECT 1 FROM [##4e9be65306634946be886fffb39ab677] WHERE Goods_No = A.Goods_No)
        GROUP BY A.ShopTinID
    ) B ON A.ShopTinID = B.ShopTinID


    时间: 2021-03-15 17:54:07,159
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE [##ef1858998fbb4b62b3f604795b5daeec] SET ChangeQuantity = CASE WHEN ISNULL(OriginalQuantity,0)=0 THEN 0 ELSE ISNULL(OriginalQuantity,0) - ISNULL(Quantity,0) END 

    时间: 2021-03-15 17:54:07,162
  线程ID: 9
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, ShopTinID AS [单号], Manual_ID AS [手工单号], Tin_Date AS [日期]
, DeliveryID AS [出货单], rtrim(FmWarehouse_No) AS [仓库编号], FmWarehouse_Na AS [仓库名称], rtrim(TinShop) AS [渠道编号]
, TinShopAbv AS [渠道简称], BuisnessManID AS [营业员编号], BuisnessManName AS [营业员名称], Quantity AS [数量]
, DpAmount AS [吊牌额]
     , Amount AS [零售额]
     , OriginalQuantity AS [业务状态#原单数], ChangeQuantity AS [业务状态#差异数]
     , JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期]
     , Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[ccbaba99-21b1-4c18-bbb7-6467e8ab6014]
 FROM [##ef1858998fbb4b62b3f604795b5daeec]
 ORDER BY Tin_Date DESC, ShopTinID ASC