时间: 2021-01-19 15:37:53,955
  线程ID: 60
日志级别: 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.[3fc174f6-6c2b-437d-bde7-d73aa5803cdf]
FROM [##f129ef0499e34bcbb52c3b4345075024]
ORDER BY Goods_no


    时间: 2021-01-19 15:37:55,465
  线程ID: 73
日志级别: 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.[3fc174f6-6c2b-437d-bde7-d73aa5803cdf]
FROM [##8664103c198a4451a95fdee9a0630fc4]
ORDER BY Goods_no


    时间: 2021-01-19 17:12:23,155
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2a85029883d945ac86f821290895914d] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:12:23,160
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2a85029883d945ac86f821290895914d] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##2a85029883d945ac86f821290895914d WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##7c13f93d273a4450ad114165a3bd8535] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:12:23,282
  线程ID: 67
日志级别: 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.[4ab68bfa-6d91-4c53-ad3c-e8880b1b5733]
 FROM [##2a85029883d945ac86f821290895914d]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:13:47,508
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##7299e68c0abd4f6ebc0b569d569a6977] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:13:47,513
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##7299e68c0abd4f6ebc0b569d569a6977] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##7299e68c0abd4f6ebc0b569d569a6977 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##876a1c40fd6644f08386b4f66df39d4f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:13:47,621
  线程ID: 57
日志级别: 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.[3ade8504-2ded-4319-a14b-2f1fda7ffb2b]
 FROM [##7299e68c0abd4f6ebc0b569d569a6977]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-19 17:14:49,103
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##489660ca63a8430090d87355cfa23146] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##489660ca63a8430090d87355cfa23146 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##c781274a8e754fe18e3c9e234213317a] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:14:49,207
  线程ID: 71
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##489660ca63a8430090d87355cfa23146]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:25:26,103
  线程ID: 60
日志级别: 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.[20635f98-862b-42e7-a232-f83ac8180253]
FROM [##e1efe31e29fa40d29d66d5fce450174b]
ORDER BY Goods_no


    时间: 2021-01-19 17:26:23,114
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##8e08cf983b6b4533b3f29bd54807c896] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:26:23,119
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##8e08cf983b6b4533b3f29bd54807c896] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##8e08cf983b6b4533b3f29bd54807c896 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##4fedfb20921945d1badc373d50668b28] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:26:23,202
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [日期], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[b7c31d4d-7ce4-429c-b8ed-d4f60c04639e]
 FROM [##8e08cf983b6b4533b3f29bd54807c896]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:26:25,341
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##879186af4e844abb8b5d96f8094be3fa] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:26:25,343
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##879186af4e844abb8b5d96f8094be3fa] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##879186af4e844abb8b5d96f8094be3fa WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##934122945dc34f82a766bc0abb1b951f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:26:25,424
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [日期], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[b7c31d4d-7ce4-429c-b8ed-d4f60c04639e]
 FROM [##879186af4e844abb8b5d96f8094be3fa]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:26:27,460
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##43f460f4c433412baeef50ec2be67e6b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:26:27,462
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##43f460f4c433412baeef50ec2be67e6b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##43f460f4c433412baeef50ec2be67e6b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##3e27628b464e4d66b9bfc50b8ee13d38] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:26:27,545
  线程ID: 56
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [日期], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[b7c31d4d-7ce4-429c-b8ed-d4f60c04639e]
 FROM [##43f460f4c433412baeef50ec2be67e6b]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:26:27,690
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##443ba73044ca41098524434297693c04] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'WPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:26:27,693
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##443ba73044ca41098524434297693c04] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##443ba73044ca41098524434297693c04 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##6b61bcb5a564476cab02e25eebe36e5b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:26:27,776
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PdStockID AS [单号], Manual_ID AS [手工单号]
     , PdStock_Date AS [日期], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], Quantity AS [数量]
     , IsPdStockAnalyse AS [业务状态#过账], Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期]
     , Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期]
     , PrintStatus AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[b7c31d4d-7ce4-429c-b8ed-d4f60c04639e]
 FROM [##443ba73044ca41098524434297693c04]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:26:37,914
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##2496fe1730d34eca93f951d1b1f4c931] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 17:26:37,918
  线程ID: 60
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##2496fe1730d34eca93f951d1b1f4c931] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##2496fe1730d34eca93f951d1b1f4c931 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d1c02db06308442bb1b62a719378cbdf] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:26:38,035
  线程ID: 60
日志级别: 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.[2159d4f4-4812-4e70-b338-b7063bb9e91f]
 FROM [##2496fe1730d34eca93f951d1b1f4c931]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:35:03,662
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  select cast('2021/01/18' as varchar(50)) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型,CAST('上期余额' AS VARCHAR(50)) as 单据类型 ,
 cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号,
 cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号,
 cast('' AS VARCHAR(50)) 预售零售订单号,c.goods_no as 货号,goods.goods_name as 品名,CAST(c.colorid AS VARCHAR(20)) as 颜色,
 vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长 , 
 SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]  INTO ##b603a8bf54084e628c3b6b114cd48f4b from [Hcstock#20210118#Z004] c left join [goods] 
 on c.goods_no = goods.goods_no 
 left join vGoodsColor 
 on c.Goods_No = vGoodsColor.Goods_No 
 AND c.colorid = vGoodsColor.colorid 
 where c.goods_no = '2011133'  group by c.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long  


    时间: 2021-01-19 17:35:03,676
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型,  CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]  from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid         left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid             left join goods on b.goods_no=goods.goods_no             left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid         LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no       where a.type=1 and a.posted=1          and a.tinshop = 'Z004'             and b.goods_No = '2011133'             and a.tin_date > '2021/01/18'       and a.tin_date < '2021/1/20 0:00:00' 
 group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max))

    时间: 2021-01-19 17:35:03,689
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]  from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid         left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid             left join goods on b.goods_no=goods.goods_no             left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid         LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop       where a.type=2 and a.posted=1          and a.tinshop = 'Z004'             and b.goods_No = '2011133'              and a.tin_date > '2021/01/18'        and a.tin_date < '2021/1/20 0:00:00' 
 group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max))  

    时间: 2021-01-19 17:35:03,702
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b  select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号,  a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,  c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]   from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid    left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid   left join goods on b.goods_no=goods.goods_no   left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid    LEFT JOIN Supply s ON s.Supply_No = a.Supply_No   where a.type=3 and a.posted=1  and a.tinshop = 'Z004'             and b.goods_No = '2011133'              and a.tin_date > '2021/01/18'        and a.tin_date < '2021/1/20 0:00:00' 
  group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,  a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 

    时间: 2021-01-19 17:35:03,714
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:    INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b   select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,   goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]   from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid               left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid               left join goods on b.goods_no=goods.goods_no               left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid           LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No         where a.posted=1  AND (ISNULL(a.Type,'')='' OR a.Type=1)            and a.customer_ID = 'Z004'               and b.goods_No = '2011133'                and a.return_date > '2021/01/18'     and a.return_date < '2021/1/20 0:00:00' 
   group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid,   a.manual_id,a.return_date,cast(a.Remark as varchar(max))      

    时间: 2021-01-19 17:35:03,725
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b    select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,    goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]    from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid        left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid                left join goods on b.goods_no=goods.goods_no                left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid            LEFT JOIN Supply s ON s.Supply_No = a.Supply_No          where a.posted=1  AND (a.Type=2)              and a.customer_ID = 'Z004'                and b.goods_No = '2011133'                 and a.return_date > '2021/01/18'         and a.return_date < '2021/1/20 0:00:00' 
    group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max))      

    时间: 2021-01-19 17:35:03,737
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID,    a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注,    b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long,    SUM(-c.[S1]) AS [S1],    (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity]    into ##56c9085525b04f75adf8ab684c43b172              from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid                left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid    left join goods on b.goods_no=goods.goods_no                left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid            LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID          where a.posted=1  AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0)                and a.customer_ID = 'Z004'                and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理')                and b.goods_No = '2011133'                 and a.Checkdate > '2021/01/18'              and a.Checkdate < '2021/1/20 0:00:00' 
    group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,    a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate,    b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max))           

    时间: 2021-01-19 17:35:03,755
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     UPDATE A SET A.零售订单号='' FROM ##56c9085525b04f75adf8ab684c43b172    A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder     WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2))

    时间: 2021-01-19 17:35:03,760
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b  SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long,    SUM(c.[S1]) AS [S1],  sum(Quantity) FROM ##56c9085525b04f75adf8ab684c43b172 c  GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long

    时间: 2021-01-19 17:35:03,764
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:    INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b   select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位,    cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,   goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]   from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid           left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid                left join goods on b.goods_no=goods.goods_no                left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid           LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop         where a.posted=1                and a.toutshop = 'Z004'                and b.goods_No = '2011133'                and a.tout_date > '2021/01/18'              and a.tout_date < '2021/1/20 0:00:00' 
   group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,   a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max))

    时间: 2021-01-19 17:35:03,775
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     INSERT INTO ##b603a8bf54084e628c3b6b114cd48f4b    select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称,    a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,    vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]    from balance as a left join balancegoods as b on a.balanceid=b.balanceid             left join balancedetail as c on b.balancegoodsid=c.balancegoodsid                 left join goods on b.goods_no=goods.goods_no                 left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid            LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id          where a.posted=1 and a.type=2              and a.customer_ID = 'Z004'             and b.goods_No = '2011133'          and a.balance_date > '2021/01/18'              and a.balance_date < '2021/1/20 0:00:00' 
    group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id,    ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max))

    时间: 2021-01-19 17:35:03,789
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE ##b603a8bf54084e628c3b6b114cd48f4b SET 销售类型=ISNULL(销售类型,'')

    时间: 2021-01-19 17:35:03,790
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE a SET a.销售类型=b.SaleType  FROM ##b603a8bf54084e628c3b6b114cd48f4b a   INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR)  WHERE a.单据类型 IN('店铺零售','加盟店铺零售')

    时间: 2021-01-19 17:35:03,795
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE ##b603a8bf54084e628c3b6b114cd48f4b SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> ''

    时间: 2021-01-19 17:35:03,796
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE ##b603a8bf54084e628c3b6b114cd48f4b SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售')  AND 销售类型 NOT IN ('预售自提','预售直发','线上发货')

    时间: 2021-01-19 17:35:03,798
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   DELETE a FROM ##b603a8bf54084e628c3b6b114cd48f4b a  WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提')

    时间: 2021-01-19 17:35:03,799
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.*
 INTO tempdb.dbo.[a47c721c-ed85-4b9f-af07-370d28db421b]
 FROM ##b603a8bf54084e628c3b6b114cd48f4b A
 INNER JOIN Goods g ON a.货号 = g.Goods_No  


    时间: 2021-01-19 17:36:20,969
  线程ID: 61
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.PdStockID AS [单号], CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.PdTimes AS [盘次], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量]
INTO tempdb.dbo.[9cc585c6-d1c0-425c-b85a-9fac54fc541c]
FROM ##942b01b540ad4f0f9d1a54ff7ea4dcdf A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.PdTimes, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color

ORDER BY  A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.PdTimes, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color


    时间: 2021-01-19 17:36:51,291
  线程ID: 68
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.PdStockID AS [单号], CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.PdTimes AS [盘次], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量]
INTO tempdb.dbo.[9cc585c6-d1c0-425c-b85a-9fac54fc541c]
FROM ##71cb5ef47dc84fcbb1a3c768da1ef911 A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.PdTimes, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color

ORDER BY  A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.PdTimes, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color


    时间: 2021-01-19 17:37:04,110
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  select top 0 cast('' as varchar(50)) as 发生日期,
 CAST('' AS VARCHAR(20)) as 操作类型,CAST('' AS VARCHAR(50)) as 单据类型 ,
 cast('' as varCHAR(max)) as 对应单位 ,cast('' as varCHAR(max)) as 对应单位简称,cast('' as varCHAR(max)) as 单号,cast('' as varCHAR(max)) as 手工单号,
 cast('' as varCHAR(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型,cast('' AS VARCHAR(50)) 零售订单号,
 cast('' AS VARCHAR(50)) 预售零售订单号,cast('' AS VARCHAR(50)) 货号,cast('' AS VARCHAR(50)) 品名,CAST('' AS VARCHAR(20)) as 颜色,
 cast('' AS VARCHAR(50)) as 颜色说明,CAST('' AS VARCHAR(20)) as 内长 , 
 CAST(0 AS INT) AS [S1] , CAST('' AS INT) AS  数量
 INTO ##ee4055cf14724a89b013a1c8d140ec14 from Goods


    时间: 2021-01-19 17:37:04,113
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期, CAST('增加' AS VARCHAR(20)) as 操作类型, CAST('店铺收货' AS VARCHAR(20)) as 单据类型,  CAST(a.fmwarehouse_no AS VARCHAR(50)) as 对应单位, CAST(w.Warehouse_Na AS VARCHAR(50)) AS 对应单位简称,a.ShopTinid as 单号, CAST(a.manual_id AS VARCHAR(50)) as 手工单号,cast(a.Remark as varchar(max)) as 备注,cast('' AS VARCHAR(50)) 销售类型, cast('' AS VARCHAR(50)) 零售订单号,cast('' AS VARCHAR(50)) 预售零售订单号,b.goods_no as 货号,goods.goods_name as 品名, CAST(c.colorid AS VARCHAR(20)) as 颜色,vGoodsColor.color as 颜色说明,CAST(c.long AS VARCHAR(20)) as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]  from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid         left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid             left join goods on b.goods_no=goods.goods_no             left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid         LEFT JOIN Warehouse w ON w.Warehouse_No = a.fmwarehouse_no       where a.type=1 and a.posted=1          and a.tinshop = 'Z004'             and b.goods_No = '2011133'             and a.tin_date < '2021/1/20 0:00:00' 
 group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.fmwarehouse_no, w.Warehouse_Na,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max))

    时间: 2021-01-19 17:37:04,124
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14 select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺调入' as 单据类型,a.toutshop as 对应单位, co.Abbrev AS 对应单位简称,a.ShopTinid as 单号, a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色, vGoodsColor.color as 颜色说明,c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]  from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid         left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid             left join goods on b.goods_no=goods.goods_no             left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid         LEFT JOIN Customer co ON co.Customer_ID = a.TOutShop       where a.type=2 and a.posted=1          and a.tinshop = 'Z004'             and b.goods_No = '2011133'              and a.tin_date < '2021/1/20 0:00:00' 
 group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.toutshop,co.Abbrev,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max))  

    时间: 2021-01-19 17:37:04,139
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14  select convert(VARCHAR(20),a.Tin_date,120) as 发生日期,'增加' as 操作类型,'店铺采购收货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.ShopTinid as 单号,  a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,  c.long as 内长, SUM(c.[S1]) AS [S1] , SUM(ISNULL(c.[S1], 0)) AS [数量]   from ShopTin as a left join ShopTingoods as b on a.ShopTinid=b.ShopTinid    left join ShopTindetail as c on b.ShopTingoodsid=c.ShopTingoodsid   left join goods on b.goods_no=goods.goods_no   left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid    LEFT JOIN Supply s ON s.Supply_No = a.Supply_No   where a.type=3 and a.posted=1  and a.tinshop = 'Z004'             and b.goods_No = '2011133'              and a.tin_date < '2021/1/20 0:00:00' 
  group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,  a.supply_no, s.Supply_Abv,a.ShopTinid,a.manual_id,a.tin_date,cast(a.Remark as varchar(max)) 

    时间: 2021-01-19 17:37:04,150
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:    INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14   select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺退货' as 单据类型,a.warehouse_no as 对应单位, w.Warehouse_Na AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,   goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]   from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid               left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid               left join goods on b.goods_no=goods.goods_no               left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid           LEFT JOIN Warehouse w ON w.Warehouse_No = a.Warehouse_No         where a.posted=1  AND (ISNULL(a.Type,'')='' OR a.Type=1)            and a.customer_ID = 'Z004'               and b.goods_No = '2011133'                and a.return_date < '2021/1/20 0:00:00' 
   group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.warehouse_no,w.Warehouse_Na,a.Dealereturnid,   a.manual_id,a.return_date,cast(a.Remark as varchar(max))      

    时间: 2021-01-19 17:37:04,161
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14    select convert(VARCHAR(20),a.return_date,120) as 发生日期,'减少' as 操作类型,'店铺采购退货' as 单据类型,a.supply_no as 对应单位, s.Supply_Abv AS 对应单位简称,a.Dealereturnid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,    goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]    from Dealereturn as a left join Dealereturngoods as b on a.Dealereturnid=b.Dealereturnid        left join Dealereturndetail as c on b.Dealereturngoodsid=c.Dealereturngoodsid                left join goods on b.goods_no=goods.goods_no                left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid            LEFT JOIN Supply s ON s.Supply_No = a.Supply_No          where a.posted=1  AND (a.Type=2)              and a.customer_ID = 'Z004'                and b.goods_No = '2011133'                    and a.return_date < '2021/1/20 0:00:00' 
    group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.supply_no,s.Supply_Abv,a.Dealereturnid,a.manual_id,a.return_date,cast(a.Remark as varchar(max))      

    时间: 2021-01-19 17:37:04,172
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     SELECT CONVERT(VARCHAR(20),a.CheckDate,120) CheckDate ,'减少' HandleType,'店铺零售' DocType ,a.Customer_ID, ct.Abbrev,a.CheckID,    a.Manual_ID,CAST(b.SaleTypeID AS VARCHAR) 销售类型,a.RetailOrderID 零售订单号,b.RetailOrderID 预售零售订单号,b.Status 销售状态,cast(a.Remark as varchar(max)) as 备注,    b.Goods_No,goods.Goods_Name,c.ColorID,vGoodsColor.color,c.long,    SUM(-c.[S1]) AS [S1],    (-1)*SUM(ISNULL(c.[S1], 0)) AS [Quantity]    into ##dbd3dfb2bf5344cd9da9b378e10b4087              from [vn_Check] as a left join vn_checkgoods as b on a.checkid=b.checkid                left join vn_checkdetail as c on b.checkgoodsid=c.checkgoodsid    left join goods on b.goods_no=goods.goods_no                left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid            LEFT JOIN Customer ct ON ct.Customer_ID = a.Customer_ID          where a.posted=1  AND NOT EXISTS(SELECT 1 FROM DictSaleType WHERE ID=ISNULL(b.SaleTypeID,0) AND IsAdjustStock=0)                and a.customer_ID = 'Z004'                and a.customer_id in (select customer_id from customer where mathod='自营' or mathod='专柜' or mathod='加盟' or mathod='代理')                and b.goods_No = '2011133'                    and a.Checkdate < '2021/1/20 0:00:00' 
    group by b.Status,b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,    a.customer_id,ct.Abbrev,a.checkid,a.manual_id,a.checkdate,    b.SaleTypeID,a.RetailOrderID,b.RetailOrderID ,cast(a.Remark as varchar(max))           

    时间: 2021-01-19 17:37:04,192
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     UPDATE A SET A.零售订单号='' FROM ##dbd3dfb2bf5344cd9da9b378e10b4087    A WHERE 销售状态='退货' AND EXISTS(SELECT 1 FROM KS2_RetailOrder     WHERE RetailOrderID=A.零售订单号 AND ISNULL(SaleTypeID,0) IN (1,2))

    时间: 2021-01-19 17:37:04,198
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14  SELECT CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,备注,销售类型,零售订单号,预售零售订单号,Goods_No,Goods_Name,ColorID,color,long,    SUM(c.[S1]) AS [S1],  sum(Quantity) FROM ##dbd3dfb2bf5344cd9da9b378e10b4087 c  GROUP BY CheckDate,HandleType,DocType ,Customer_ID, Abbrev,CheckID,Manual_ID,销售类型,零售订单号,预售零售订单号,备注,Goods_No,Goods_Name,ColorID,color,long

    时间: 2021-01-19 17:37:04,209
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:    INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14   select convert(VARCHAR(20),a.tout_date,120) as 发生日期,'减少' as 操作类型,'店铺调出' as 单据类型,a.tinshop as 对应单位,    cti.Abbrev AS 对应单位简称,a.shoptoutid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,   goods.goods_name as 品名,c.colorid as 颜色,vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]   from shoptout as a left join shoptoutgoods as b on a.shoptoutid=b.shoptoutid           left join shoptoutdetail as c on b.shoptoutgoodsid=c.shoptoutgoodsid                left join goods on b.goods_no=goods.goods_no                left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid           LEFT JOIN Customer cti ON cti.Customer_ID = a.TinShop         where a.posted=1                and a.toutshop = 'Z004'                and b.goods_No = '2011133'                    and a.tout_date < '2021/1/20 0:00:00' 
   group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,   a.tinshop,cti.Abbrev,a.shoptoutid,a.manual_id,a.tout_date,cast(a.Remark as varchar(max))

    时间: 2021-01-19 17:37:04,221
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:     INSERT INTO ##ee4055cf14724a89b013a1c8d140ec14    select convert(VARCHAR(20),a.balance_date,120) as 发生日期,'减少' as 操作类型,'店铺损益' as 单据类型,a.customer_id as 对应单位, ct.Abbrev AS 对应单位简称,    a.balanceid as 单号,a.manual_id as 手工单号,cast(a.Remark as varchar(max)) as 备注,'','','',b.goods_no as 货号,goods.goods_name as 品名,c.colorid as 颜色,    vGoodsColor.color as 颜色说明,c.long as 内长,   SUM(-c.[S1]) AS [S1],   (-1)*SUM(ISNULL(c.[S1], 0)) AS [数量]    from balance as a left join balancegoods as b on a.balanceid=b.balanceid             left join balancedetail as c on b.balancegoodsid=c.balancegoodsid                 left join goods on b.goods_no=goods.goods_no                 left join vGoodsColor on B.Goods_No=vGoodsColor.Goods_No AND c.colorid=vGoodsColor.colorid            LEFT JOIN Customer ct ON ct.Customer_ID = a.customer_id          where a.posted=1 and a.type=2              and a.customer_ID = 'Z004'             and b.goods_No = '2011133'             and a.balance_date < '2021/1/20 0:00:00' 
    group by b.goods_no,goods.goods_name,c.colorid,vGoodsColor.color,c.long,a.customer_id,    ct.Abbrev,a.balanceid,a.manual_id,a.balance_date,cast(a.Remark as varchar(max))

    时间: 2021-01-19 17:37:04,231
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE ##ee4055cf14724a89b013a1c8d140ec14 SET 销售类型=ISNULL(销售类型,'')

    时间: 2021-01-19 17:37:04,232
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE a SET a.销售类型=b.SaleType  FROM ##ee4055cf14724a89b013a1c8d140ec14 a   INNER JOIN DictSaleType b ON a.销售类型=CAST(b.ID AS VARCHAR)  WHERE a.单据类型 IN('店铺零售','加盟店铺零售')

    时间: 2021-01-19 17:37:04,236
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE ##ee4055cf14724a89b013a1c8d140ec14 SET 销售类型='线上发货' WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND 零售订单号 IS NOT NULL AND 零售订单号 <> ''

    时间: 2021-01-19 17:37:04,238
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   UPDATE ##ee4055cf14724a89b013a1c8d140ec14 SET 销售类型='正常销售' WHERE 单据类型 IN('店铺零售','加盟店铺零售')  AND 销售类型 NOT IN ('预售自提','预售直发','线上发货')

    时间: 2021-01-19 17:37:04,239
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:   DELETE a FROM ##ee4055cf14724a89b013a1c8d140ec14 a  WHERE 单据类型 IN('店铺零售','加盟店铺零售') AND a.销售类型 NOT IN('正常销售','预售直发','预售自提')

    时间: 2021-01-19 17:37:04,241
  线程ID: 67
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber ,A.*
 INTO tempdb.dbo.[a47c721c-ed85-4b9f-af07-370d28db421b]
 FROM ##ee4055cf14724a89b013a1c8d140ec14 A
 INNER JOIN Goods g ON a.货号 = g.Goods_No  


    时间: 2021-01-19 17:37:32,240
  线程ID: 71
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber,  A.PdStockID AS [单号], CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], A.PdTimes AS [盘次], A.Goods_no AS [货号], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], VGC.Color AS [颜色说明], SUM([S1]) AS [尺码#S1], SUM(A.Quantity) AS [数量]
INTO tempdb.dbo.[9cc585c6-d1c0-425c-b85a-9fac54fc541c]
FROM ##c20db17dfeb3441483c31055352322fe A 
      LEFT  JOIN Customer CT ON A.Customer_ID = CT.Customer_ID
      LEFT  JOIN Goods GS ON A.Goods_No = GS.Goods_No
      LEFT  JOIN vGoodsColor VGC ON A.Goods_No = VGC.Goods_No AND A.ColorID = VGC.ColorID
      LEFT  JOIN DictColor DC ON VGC.ColorID = DC.ColorID

GROUP BY  A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.PdTimes, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color

ORDER BY  A.PdStockID, CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, A.PdTimes, A.Goods_no, GS.Goods_Name, A.ColorID, VGC.Color


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


    时间: 2021-01-19 17:54:04,393
  线程ID: 57
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##19d142f0727d4d02bf5fbc144d47687f] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##19d142f0727d4d02bf5fbc144d47687f WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##107139c6c2804436b4f1dbbb31b981f8] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 17:54:04,488
  线程ID: 57
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##19d142f0727d4d02bf5fbc144d47687f]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 17:55:34,846
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##17ef441d70b540cb846218ec0a0101b3] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CBalance' AND A.BalanceID = BillNo )


    时间: 2021-01-19 17:55:34,851
  线程ID: 58
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM [##17ef441d70b540cb846218ec0a0101b3] 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 ##17ef441d70b540cb846218ec0a0101b3 WHERE A.BalanceID = BalanceID )
        GROUP BY A.BalanceID
    ) B ON A.BalanceID = B.BalanceID


    时间: 2021-01-19 17:55:34,911
  线程ID: 58
日志级别: 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.[896b0d53-1cdf-47f0-91e6-3e9382a6b437]
 FROM [##17ef441d70b540cb846218ec0a0101b3]
 ORDER BY Balance_Date DESC, BalanceID ASC


    时间: 2021-01-19 20:04:09,772
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##6cea08389cb849148f8c14d128f402b8] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:04:09,775
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##6cea08389cb849148f8c14d128f402b8] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##6cea08389cb849148f8c14d128f402b8 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##ecab1367dbc9418d989bf9aa1c06c505] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:04:09,859
  线程ID: 51
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##6cea08389cb849148f8c14d128f402b8]
 ORDER BY PdStock_Date DESC, PdStockID ASC


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


    时间: 2021-01-19 20:04:17,778
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##32397bc625794e4aafadf80766a15b3c] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##32397bc625794e4aafadf80766a15b3c WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##9b4e4f7e5d7443eb9f61de099df944bf] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:04:17,886
  线程ID: 50
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##32397bc625794e4aafadf80766a15b3c]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:04:23,189
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b22ccf6cce814e0f99aaedfe9e213d5a] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:04:23,194
  线程ID: 50
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b22ccf6cce814e0f99aaedfe9e213d5a] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##b22ccf6cce814e0f99aaedfe9e213d5a WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##81c9d7027282493f9b4d846ac994f871] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:04:23,297
  线程ID: 50
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##b22ccf6cce814e0f99aaedfe9e213d5a]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:05:03,009
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##035dee46735e439caefbbd133248728c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:05:03,013
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##035dee46735e439caefbbd133248728c] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##035dee46735e439caefbbd133248728c WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##44aba083cb434b36a7282c00fe6789c9] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:05:03,123
  线程ID: 49
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##035dee46735e439caefbbd133248728c]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:05:19,267
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##e92b4d4d87594b6e8bcfc3b8687297a9] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:05:19,271
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##e92b4d4d87594b6e8bcfc3b8687297a9] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##e92b4d4d87594b6e8bcfc3b8687297a9 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##2ffd190ad2054b198823e07b3569bbcb] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:05:19,370
  线程ID: 51
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##e92b4d4d87594b6e8bcfc3b8687297a9]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:05:45,299
  线程ID: 52
日志级别: 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 [##648d7b85c43c486b8e1a3d538477d6fa]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-01-19 20:05:45,502
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##648d7b85c43c486b8e1a3d538477d6fa] (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 [##42fc468d768c4280a7aa25f7a845369b] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-01-19 20:05:50,388
  线程ID: 48
日志级别: 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 [##fa3d0c8dc7624e69a7114caca42f5344]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-01-19 20:05:50,592
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##fa3d0c8dc7624e69a7114caca42f5344] (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 [##0cdd0b7367bf4630bf6980cfeb07493f] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-01-19 20:06:31,554
  线程ID: 49
日志级别: 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 [##5bb4f2535d214a25aae89cec8d35b216]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-01-19 20:06:31,775
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5bb4f2535d214a25aae89cec8d35b216] (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 [##da08e4bb9bc94b54a5737b2ab122e91b] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-01-19 20:07:06,880
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##b5b9ad8afc2b4d57babaaa5d871a0f85] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:07:06,885
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##b5b9ad8afc2b4d57babaaa5d871a0f85] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##b5b9ad8afc2b4d57babaaa5d871a0f85 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##4240e80504dd476d86f794abc05b5c46] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:07:06,982
  线程ID: 46
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##b5b9ad8afc2b4d57babaaa5d871a0f85]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:07:16,793
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##38409ca3a5d340c0b37f289281df9118] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:07:16,797
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##38409ca3a5d340c0b37f289281df9118] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##38409ca3a5d340c0b37f289281df9118 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##21e42fe1210b42098a52bd847d534eaf] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:07:16,886
  线程ID: 49
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##38409ca3a5d340c0b37f289281df9118]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:07:59,625
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##978ed5441b524c7d9f14b18dbfe82186] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:07:59,627
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##978ed5441b524c7d9f14b18dbfe82186] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##978ed5441b524c7d9f14b18dbfe82186 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##327b616b404e4a2cb08e7ffc3a813792] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:07:59,709
  线程ID: 49
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##978ed5441b524c7d9f14b18dbfe82186]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:08:03,491
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##817cbb2635cd48efa2d379f48e2eb9da] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:08:03,495
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##817cbb2635cd48efa2d379f48e2eb9da] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##817cbb2635cd48efa2d379f48e2eb9da WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##d1bb1fe94c1646869667cba32e27ada3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:08:03,601
  线程ID: 66
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##817cbb2635cd48efa2d379f48e2eb9da]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:08:13,303
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##389081296f6c4a6585faa73b23409e96] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:08:13,307
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##389081296f6c4a6585faa73b23409e96] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##389081296f6c4a6585faa73b23409e96 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##5707f3d3604645ce8d58df778cb75cc5] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:08:13,396
  线程ID: 53
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##389081296f6c4a6585faa73b23409e96]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:11:33,619
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##de0c7825c4274b918d73ac9363f176dd] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:11:33,622
  线程ID: 66
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##de0c7825c4274b918d73ac9363f176dd] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##de0c7825c4274b918d73ac9363f176dd WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##5baea151657741fcaa99b52f49208a56] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:11:33,724
  线程ID: 66
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##de0c7825c4274b918d73ac9363f176dd]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:11:48,717
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##9524126d508e4fa59b7c1e1970dc99d7] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:11:48,720
  线程ID: 46
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##9524126d508e4fa59b7c1e1970dc99d7] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##9524126d508e4fa59b7c1e1970dc99d7 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##9a4a2fc2bcc94e89b1ee1899cadfeb18] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:11:48,812
  线程ID: 46
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##9524126d508e4fa59b7c1e1970dc99d7]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:12:08,406
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##fe91119a901e4d4384e0f71e90bb344b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:12:08,410
  线程ID: 55
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##fe91119a901e4d4384e0f71e90bb344b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##fe91119a901e4d4384e0f71e90bb344b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##f7a566e49b0e43ba8ac56ca58ca0572b] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:12:08,506
  线程ID: 55
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##fe91119a901e4d4384e0f71e90bb344b]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:13:13,424
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##fdd157e0d6ea4604ad6d1ccf96503916] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:13:13,427
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##fdd157e0d6ea4604ad6d1ccf96503916] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##fdd157e0d6ea4604ad6d1ccf96503916 WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##41d48abe80784bf39dbb94e8dc504dff] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:13:13,532
  线程ID: 49
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##fdd157e0d6ea4604ad6d1ccf96503916]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:14:36,297
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##6fca4790e932432bacff838b6a67c9ca] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:14:36,301
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##6fca4790e932432bacff838b6a67c9ca] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##6fca4790e932432bacff838b6a67c9ca WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##367b6288652a4feeaf162453cb602bdc] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:14:36,406
  线程ID: 49
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##6fca4790e932432bacff838b6a67c9ca]
 ORDER BY PdStock_Date DESC, PdStockID ASC


    时间: 2021-01-19 20:14:42,184
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##84d60de04cfd4f12b469c63d7a43768b] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo )


    时间: 2021-01-19 20:14:42,187
  线程ID: 52
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##84d60de04cfd4f12b469c63d7a43768b] A
    INNER JOIN (
        SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity
        FROM [PdStockGoods] A 
        WHERE EXISTS( SELECT 1 FROM ##84d60de04cfd4f12b469c63d7a43768b WHERE A.PdStockID = PdStockID )
     AND EXISTS (SELECT 1 FROM [##b788c0379fb548a3ba96e40e48fcd27f] WHERE Goods_No = A.Goods_No)
        GROUP BY A.PdStockID
    ) B ON A.PdStockID = B.PdStockID


    时间: 2021-01-19 20:14:42,296
  线程ID: 52
日志级别: 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.[ce9dad6f-ff40-4744-a468-7fefbfd148a2]
 FROM [##84d60de04cfd4f12b469c63d7a43768b]
 ORDER BY PdStock_Date DESC, PdStockID ASC