时间: 2021-11-02 09:39:28,341
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##6a6ed5beef7e42aeb295be73960c07d9 ADD 销售类型 VARCHAR(50)

    时间: 2021-11-02 09:39:28,396
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##6a6ed5beef7e42aeb295be73960c07d9 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-11-02 09:39:28,440
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6a6ed5beef7e42aeb295be73960c07d9 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-11-02 09:39:28,482
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##6a6ed5beef7e42aeb295be73960c07d9 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON a.CheckGoodsID = SCG.CheckGoodsID 
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-11-02 09:39:28,522
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6a6ed5beef7e42aeb295be73960c07d9 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-11-02 09:39:28,533
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6a6ed5beef7e42aeb295be73960c07d9 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-11-02 09:39:28,850
  线程ID: 14
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  SELECT IDENTITY(INT, 1, 1) AS RowNumber,   A.Customer_ID AS [渠道编号], SUM(a.VipQuantity) AS [会员消费数量], SUM(A.VIPAmount) AS [会员消费额], SUM(A.TotalAmount) AS [生意额], CAST( (CASE WHEN ISNULL(SUM(A.TotalAmount), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VIPAmount), 0)/SUM(A.TotalAmount) END)  AS Numeric(18, 4)) AS [会员消费额占比], CAST( (CASE WHEN ISNULL(SUM(A.TotalQuantity), 0) = 0 THEN 0 ELSE 1.00 * ISNULL(SUM(A.VipQuantity), 0)/SUM(A.TotalQuantity) END)  AS Numeric(18, 4)) AS [会员消费数占比], SUM(a.TotalQuantity) AS [销售数量]
 INTO tempdb.dbo.[c21faaa7-9de1-483a-acb4-741dbcc1a5d5]
FROM ##0551af63d2fd43ea972de9d4e46f520d A 
INNER JOIN Customer CT on CT.Customer_ID=A.Customer_ID
LEFT JOIN customervip Vip on Vip.VIP=A.VIP_Card

GROUP BY  A.Customer_ID

ORDER BY  A.Customer_ID


    时间: 2021-11-02 09:48:57,187
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT a.VIP 
INTO ##894a0fa284b94671af4caf633b102a85
FROM CustomerVIP a
 WHERE Exists(SELECT 1 FROM ##85f2e3242cdc42109af967173b7f8a56 WHERE Customer_ID=a.Customer_ID) 
 AND Exists(select 1 from ##4b09f184a77f4f6ab791bfef137c01ce where VIP=a.VIP) 
AND a.[ExpireDate] > GETDATE()


    时间: 2021-11-02 09:48:57,222
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH t1 as
(
select a.VIP_Card,a.CheckDate 
from [Check] a 
inner join [##894a0fa284b94671af4caf633b102a85] CV on a.VIP_Card=CV.VIP
inner join [##85f2e3242cdc42109af967173b7f8a56] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
GROUP BY a.VIP_Card,a.CheckDate 
union all 
select a.VIP_Card,a.CheckDate 
from [CheckL] a 
inner join [##894a0fa284b94671af4caf633b102a85] CV on a.VIP_Card=CV.VIP
inner join [##85f2e3242cdc42109af967173b7f8a56] CT on a.Customer_ID=CT.Customer_ID
where  a.Posted=1
GROUP BY a.VIP_Card,a.CheckDate 
)

select VIP_Card
,MAX(最近消费日期) as 最近消费日期,MAX(上次消费日期) as 上次消费日期
,DATEDIFF(DAY,MAX(上次消费日期),MAX(最近消费日期)) as 周期
into ##a23eb3355de047c2842f3668dac0b985
from (
	select VIP_Card
	,case when RowNumber=1 then CheckDate end as 最近消费日期
	,case when RowNumber=2 then CheckDate else null end as 上次消费日期
	from(
		select ROW_NUMBER() over (partition by VIP_Card order by CheckDate desc) as RowNumber
		, VIP_Card,CheckDate
		from t1
	)t where RowNumber<=2
)t group by VIP_Card


    时间: 2021-11-02 09:48:57,254
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,COUNT(distinct(a.CheckID)) as BillQty
,SUM(b.Quantity) as Quantity
,SUM(b.Quantity*b.DiscountPrice) as DiscountAmount
,SUM(b.Quantity*gd.UnitPrice) as DpAmount
into ##d5a6d720464e483792338155d746fe0f
from [Check] a
inner join CheckGoods b on a.CheckID=b.CheckID
inner join Goods Gd on B.Goods_no=Gd.Goods_no
inner join [##894a0fa284b94671af4caf633b102a85] CV on a.VIP_Card=CV.VIP
inner join [##85f2e3242cdc42109af967173b7f8a56] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
and a.CheckDate >= '2021-10-02' 
and a.CheckDate <= '2021-11-02' 
group by VIP_Card


    时间: 2021-11-02 09:48:57,275
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: insert into ##d5a6d720464e483792338155d746fe0f
select VIP_Card,COUNT(distinct(a.CheckID)) as BillQty
,SUM(b.Quantity) as Quantity
,SUM(b.Quantity*b.DiscountPrice) as DiscountAmount
,SUM(b.Quantity*gd.UnitPrice) as DpAmount
from [CheckL] a
inner join CheckLGoods b on a.CheckID=b.CheckID
inner join Goods Gd on B.Goods_no=Gd.Goods_no
inner join [##894a0fa284b94671af4caf633b102a85] CV on a.VIP_Card=CV.VIP
inner join [##85f2e3242cdc42109af967173b7f8a56] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
and a.CheckDate >= '2021-10-02' 
and a.CheckDate <= '2021-11-02' 
group by VIP_Card


    时间: 2021-11-02 09:48:57,286
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,SUM(DiscountAmount) as DiscountAmount 
into ##54f947feacbf41899e3b699a606c8934
from ##d5a6d720464e483792338155d746fe0f
group by VIP_Card


    时间: 2021-11-02 09:48:57,289
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,SUM(BillQty) as BillQty,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
,SUM(DpAmount) as DpAmount
into ##a7d2b2be217b4ac083335bfab57d4b54
from ##d5a6d720464e483792338155d746fe0f
group by VIP_Card


    时间: 2021-11-02 09:48:57,291
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,DiscountAmount
,case when isnull(DpAmount,0)=0 then null
  else cast(DiscountAmount/DpAmount as numeric(30,2)) end as AVGDiscoun 
,cast(Quantity*1.0/BillQty as  numeric(30,2))  as AVGQty 
,cast(DiscountAmount/BillQty as  numeric(30,2))  as AVGAmount 
into ##eca74fc9066d42bd94a7dc431aa4ab9d
from ##a7d2b2be217b4ac083335bfab57d4b54 a 


    时间: 2021-11-02 09:48:57,293
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##d5a6d720464e483792338155d746fe0f

    时间: 2021-11-02 09:48:57,296
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##a7d2b2be217b4ac083335bfab57d4b54

    时间: 2021-11-02 09:48:57,297
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: exec p_VipGetIntegral @DataTable='##ccc31e9cf962464ba36d4e3dd10a5d10',@VipTable='##894a0fa284b94671af4caf633b102a85', @EndDate = '2021-11-02' 

    时间: 2021-11-02 09:48:57,559
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , SUM(t3.DiscountAmount) AS [累计消费金额], t1.最近消费日期 AS [最近消费日期], CV.Name AS [Vip姓名], v.VIP AS [Vip卡号], SUM(t2.DiscountAmount) AS [本期消费金额], SUM(t2.AVGAmount) AS [本期单票金额], SUM(t2.AVGQty) AS [本期单票件数], t1.上次消费日期 AS [上次消费日期], SUM(t4.IntegralAmount) AS [当前积分], t1.周期 AS [周期] 
   INTO tempdb.dbo.[64eca413-37f5-4f9a-ab8d-9f76eba75f02] 
FROM ##894a0fa284b94671af4caf633b102a85 v 
   LEFT JOIN CustomerVIP CV on CV.VIP=v.VIP 
   LEFT JOIN ##a23eb3355de047c2842f3668dac0b985 t1 on t1.VIP_Card=v.VIP 
   LEFT JOIN ##eca74fc9066d42bd94a7dc431aa4ab9d t2 on t2.VIP_Card=v.VIP 
   LEFT JOIN ##54f947feacbf41899e3b699a606c8934 t3 on t3.VIP_Card=v.VIP 
   LEFT JOIN ##ccc31e9cf962464ba36d4e3dd10a5d10 t4 on t4.VIP=v.VIP 
     LEFT JOIN VIPGradeIntegralBase t5 ON CV.VipGrade = t5.VipGrade
     LEFT JOIN CUSTOMER CV1 ON CV.CUSTOMER_ID=CV1.CUSTOMER_ID

GROUP BY  t1.最近消费日期, CV.Name, v.VIP, t1.上次消费日期, t1.周期

ORDER BY  t1.最近消费日期, CV.Name, v.VIP, t1.上次消费日期, t1.周期


    时间: 2021-11-02 09:49:25,868
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT a.VIP 
INTO ##7d09e69aac1f440a81ca7d781b443222
FROM CustomerVIP a
 WHERE Exists(SELECT 1 FROM ##092d7768d2474ee3840d4b9417d2d0fe WHERE Customer_ID=a.Customer_ID) 
 AND Exists(select 1 from ##8797618597824dacb1e8f3a4197778b0 where VIP=a.VIP) 
AND a.[ExpireDate] > GETDATE()


    时间: 2021-11-02 09:49:25,903
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ;WITH t1 as
(
select a.VIP_Card,a.CheckDate 
from [Check] a 
inner join [##7d09e69aac1f440a81ca7d781b443222] CV on a.VIP_Card=CV.VIP
inner join [##092d7768d2474ee3840d4b9417d2d0fe] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
GROUP BY a.VIP_Card,a.CheckDate 
union all 
select a.VIP_Card,a.CheckDate 
from [CheckL] a 
inner join [##7d09e69aac1f440a81ca7d781b443222] CV on a.VIP_Card=CV.VIP
inner join [##092d7768d2474ee3840d4b9417d2d0fe] CT on a.Customer_ID=CT.Customer_ID
where  a.Posted=1
GROUP BY a.VIP_Card,a.CheckDate 
)

select VIP_Card
,MAX(最近消费日期) as 最近消费日期,MAX(上次消费日期) as 上次消费日期
,DATEDIFF(DAY,MAX(上次消费日期),MAX(最近消费日期)) as 周期
into ##6dfc5d6f61f6427e8174528e6008b678
from (
	select VIP_Card
	,case when RowNumber=1 then CheckDate end as 最近消费日期
	,case when RowNumber=2 then CheckDate else null end as 上次消费日期
	from(
		select ROW_NUMBER() over (partition by VIP_Card order by CheckDate desc) as RowNumber
		, VIP_Card,CheckDate
		from t1
	)t where RowNumber<=2
)t group by VIP_Card


    时间: 2021-11-02 09:49:25,934
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,COUNT(distinct(a.CheckID)) as BillQty
,SUM(b.Quantity) as Quantity
,SUM(b.Quantity*b.DiscountPrice) as DiscountAmount
,SUM(b.Quantity*gd.UnitPrice) as DpAmount
into ##93e4968ab2804495aac96a0e94370553
from [Check] a
inner join CheckGoods b on a.CheckID=b.CheckID
inner join Goods Gd on B.Goods_no=Gd.Goods_no
inner join [##7d09e69aac1f440a81ca7d781b443222] CV on a.VIP_Card=CV.VIP
inner join [##092d7768d2474ee3840d4b9417d2d0fe] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
and a.CheckDate >= '2021-01-01' 
and a.CheckDate <= '2021-11-02' 
group by VIP_Card


    时间: 2021-11-02 09:49:26,012
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: insert into ##93e4968ab2804495aac96a0e94370553
select VIP_Card,COUNT(distinct(a.CheckID)) as BillQty
,SUM(b.Quantity) as Quantity
,SUM(b.Quantity*b.DiscountPrice) as DiscountAmount
,SUM(b.Quantity*gd.UnitPrice) as DpAmount
from [CheckL] a
inner join CheckLGoods b on a.CheckID=b.CheckID
inner join Goods Gd on B.Goods_no=Gd.Goods_no
inner join [##7d09e69aac1f440a81ca7d781b443222] CV on a.VIP_Card=CV.VIP
inner join [##092d7768d2474ee3840d4b9417d2d0fe] CT on a.Customer_ID=CT.Customer_ID
where a.Posted=1
and a.CheckDate >= '2021-01-01' 
and a.CheckDate <= '2021-11-02' 
group by VIP_Card


    时间: 2021-11-02 09:49:26,025
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,SUM(DiscountAmount) as DiscountAmount 
into ##491ca2aafaa743f28334a1865670e388
from ##93e4968ab2804495aac96a0e94370553
group by VIP_Card


    时间: 2021-11-02 09:49:26,030
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,SUM(BillQty) as BillQty,SUM(Quantity) as Quantity,SUM(DiscountAmount) as DiscountAmount
,SUM(DpAmount) as DpAmount
into ##d27eaa69a0a8400096cd9db92d476eef
from ##93e4968ab2804495aac96a0e94370553
group by VIP_Card


    时间: 2021-11-02 09:49:26,034
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: select VIP_Card,DiscountAmount
,case when isnull(DpAmount,0)=0 then null
  else cast(DiscountAmount/DpAmount as numeric(30,2)) end as AVGDiscoun 
,cast(Quantity*1.0/BillQty as  numeric(30,2))  as AVGQty 
,cast(DiscountAmount/BillQty as  numeric(30,2))  as AVGAmount 
into ##ce8ff4bbb5f44d30b548b0c2a456e115
from ##d27eaa69a0a8400096cd9db92d476eef a 


    时间: 2021-11-02 09:49:26,037
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##93e4968ab2804495aac96a0e94370553

    时间: 2021-11-02 09:49:26,038
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: p_DropTable ##d27eaa69a0a8400096cd9db92d476eef

    时间: 2021-11-02 09:49:26,039
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: exec p_VipGetIntegral @DataTable='##70dbcf505a0049f4827403dc648c7c70',@VipTable='##7d09e69aac1f440a81ca7d781b443222', @EndDate = '2021-11-02' 

    时间: 2021-11-02 09:49:26,272
  线程ID: 39
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber , SUM(t3.DiscountAmount) AS [累计消费金额], t1.最近消费日期 AS [最近消费日期], CV.Name AS [Vip姓名], v.VIP AS [Vip卡号], SUM(t2.DiscountAmount) AS [本期消费金额], SUM(t2.AVGAmount) AS [本期单票金额], SUM(t2.AVGQty) AS [本期单票件数], t1.上次消费日期 AS [上次消费日期], SUM(t4.IntegralAmount) AS [当前积分], t1.周期 AS [周期] 
   INTO tempdb.dbo.[64eca413-37f5-4f9a-ab8d-9f76eba75f02] 
FROM ##7d09e69aac1f440a81ca7d781b443222 v 
   LEFT JOIN CustomerVIP CV on CV.VIP=v.VIP 
   LEFT JOIN ##6dfc5d6f61f6427e8174528e6008b678 t1 on t1.VIP_Card=v.VIP 
   LEFT JOIN ##ce8ff4bbb5f44d30b548b0c2a456e115 t2 on t2.VIP_Card=v.VIP 
   LEFT JOIN ##491ca2aafaa743f28334a1865670e388 t3 on t3.VIP_Card=v.VIP 
   LEFT JOIN ##70dbcf505a0049f4827403dc648c7c70 t4 on t4.VIP=v.VIP 
     LEFT JOIN VIPGradeIntegralBase t5 ON CV.VipGrade = t5.VipGrade
     LEFT JOIN CUSTOMER CV1 ON CV.CUSTOMER_ID=CV1.CUSTOMER_ID

GROUP BY  t1.最近消费日期, CV.Name, v.VIP, t1.上次消费日期, t1.周期

ORDER BY  t1.最近消费日期, CV.Name, v.VIP, t1.上次消费日期, t1.周期


    时间: 2021-11-02 10:23:36,129
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##62927ef07a2f47c496ff93b51c688b90] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-11-02 10:23:36,147
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##62927ef07a2f47c496ff93b51c688b90] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##62927ef07a2f47c496ff93b51c688b90] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-11-02 10:23:36,152
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##62927ef07a2f47c496ff93b51c688b90] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2021-11-02 10:23:36,156
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##62927ef07a2f47c496ff93b51c688b90] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2021-11-02 10:23:36,161
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##62927ef07a2f47c496ff93b51c688b90 A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##62927ef07a2f47c496ff93b51c688b90 WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##769398fc6e8e43e6878ead8bf2e187b7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-11-02 10:23:36,242
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##62927ef07a2f47c496ff93b51c688b90 A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##62927ef07a2f47c496ff93b51c688b90 WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##769398fc6e8e43e6878ead8bf2e187b7] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


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


    时间: 2021-11-02 10:23:36,418
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##62927ef07a2f47c496ff93b51c688b90 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##62927ef07a2f47c496ff93b51c688b90 WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##769398fc6e8e43e6878ead8bf2e187b7] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 10:23:36,884
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##62927ef07a2f47c496ff93b51c688b90 A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##62927ef07a2f47c496ff93b51c688b90 C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##769398fc6e8e43e6878ead8bf2e187b7] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 10:23:37,179
  线程ID: 5
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##62927ef07a2f47c496ff93b51c688b90
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


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


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


    时间: 2021-11-02 11:02:25,619
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##f95ab89f7f0f4b799a4c3d880efd2ffb] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-11-02 11:02:25,623
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##f95ab89f7f0f4b799a4c3d880efd2ffb] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##f95ab89f7f0f4b799a4c3d880efd2ffb] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-11-02 11:02:25,629
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##f95ab89f7f0f4b799a4c3d880efd2ffb] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2021-11-02 11:02:25,634
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##f95ab89f7f0f4b799a4c3d880efd2ffb] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2021-11-02 11:02:25,640
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##805aa1a989ab4fb4ba10abc0b993a5f3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-11-02 11:02:25,721
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##805aa1a989ab4fb4ba10abc0b993a5f3] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


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


    时间: 2021-11-02 11:02:25,895
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##805aa1a989ab4fb4ba10abc0b993a5f3] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 11:02:26,324
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##f95ab89f7f0f4b799a4c3d880efd2ffb C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##805aa1a989ab4fb4ba10abc0b993a5f3] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 11:02:26,611
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##f95ab89f7f0f4b799a4c3d880efd2ffb
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


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


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


    时间: 2021-11-02 11:04:26,077
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PrintStatus = 1
 FROM [##5dd8cc140cdd4253b87bc394b9b8700c] A
 WHERE EXISTS( SELECT 1 FROM BillPrint 
               WHERE BillType = 'Wout' AND A.DeliveryID = BillNo )


    时间: 2021-11-02 11:04:26,081
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE [##5dd8cc140cdd4253b87bc394b9b8700c] SET IsInStock = CASE WHEN ISNULL(B.Posted,0) = 1 THEN 1 ELSE 0 END 
 FROM [##5dd8cc140cdd4253b87bc394b9b8700c] A INNER JOIN  ShopTin B ON A.DeliveryID = B.DeliveryID
 WHERE 1 = 1 


    时间: 2021-11-02 11:04:26,087
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 0 
 FROM [##5dd8cc140cdd4253b87bc394b9b8700c] A 
 WHERE NOT EXISTS(SELECT * FROM ShopTin WHERE DeliveryID = A.DeliveryID) 


    时间: 2021-11-02 11:04:26,091
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET IsInStock = 1 
 FROM [##5dd8cc140cdd4253b87bc394b9b8700c] A 
 WHERE EXISTS(SELECT * FROM PuReceipt WHERE DeliveryID = A.DeliveryID) 


    时间: 2021-11-02 11:04:26,098
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET SortingQuantity = ISNULL(B.Quantity,0)
 FROM ##5dd8cc140cdd4253b87bc394b9b8700c A
    INNER JOIN (
        SELECT A.SortingID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM SortingGoods A
        WHERE EXISTS( SELECT 1 FROM ##5dd8cc140cdd4253b87bc394b9b8700c WHERE A.SortingID = SortingID )
     AND EXISTS (SELECT 1 FROM [##951ff83571554b2fb3558113be1fd62c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.SortingID
    ) B ON A.SortingID = B.SortingID


    时间: 2021-11-02 11:04:26,179
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET OrderQuantity = ISNULL(B.Quantity,0)
 FROM ##5dd8cc140cdd4253b87bc394b9b8700c A
    INNER JOIN (
        SELECT A.OrderID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM OrderGoods A
        WHERE EXISTS( SELECT 1 FROM ##5dd8cc140cdd4253b87bc394b9b8700c WHERE A.OrderID = OrderID )
     AND EXISTS (SELECT 1 FROM [##951ff83571554b2fb3558113be1fd62c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.OrderID
    ) B ON A.OrderID = B.OrderID


    时间: 2021-11-02 11:04:26,263
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0), Amount = ISNULL(B.Amount,0), DpAmount = ISNULL(B.DpAmount,0)
 FROM ##5dd8cc140cdd4253b87bc394b9b8700c A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(A.Quantity,0)) As Quantity, SUM(ISNULL(A.Quantity,0) * ISNULL(A.UnitPrice,0)) As Amount
             , SUM(ISNULL(A.Quantity,0) * ISNULL(vdp.DpPriceByBatch,0)) As DpAmount
        FROM DeliveryGoods A
            LEFT JOIN Delivery B ON A.DeliveryID=B.DeliveryID
            LEFT JOIN vGoodsDpPrice vdp ON vdp.Goods_No = a.Goods_No AND vdp.Customer_ID = b.Customer_ID
             LEFT JOIN Goods G ON A.Goods_No=G.Goods_No
        WHERE EXISTS( SELECT 1 FROM ##5dd8cc140cdd4253b87bc394b9b8700c WHERE A.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##951ff83571554b2fb3558113be1fd62c] WHERE Goods_No = A.Goods_No)
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 11:04:26,357
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET ReceiveQuantity = ISNULL(B.Quantity,0)
 FROM ##5dd8cc140cdd4253b87bc394b9b8700c A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM ShopTinSSGoods A INNER JOIN ShopTin B ON A.ShopTinID = B.ShopTinID
        WHERE B.DeliveryID IS NOT NULL AND EXISTS( SELECT 1 FROM ##5dd8cc140cdd4253b87bc394b9b8700c WHERE B.DeliveryID = DeliveryID )
     AND EXISTS (SELECT 1 FROM [##951ff83571554b2fb3558113be1fd62c] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 11:04:26,791
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET PuReceiptQuantity = ISNULL(B.Quantity,0)
 FROM ##5dd8cc140cdd4253b87bc394b9b8700c A
    INNER JOIN (
        SELECT B.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        INNER JOIN PuReceipt B ON A.PuReceiptID = B.PuReceiptID
        WHERE EXISTS( SELECT 1 FROM ##5dd8cc140cdd4253b87bc394b9b8700c C WHERE B.DeliveryID = C.DeliveryID )
     AND EXISTS (SELECT 1 FROM [##951ff83571554b2fb3558113be1fd62c] WHERE Goods_No = A.Goods_No)
        GROUP BY B.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 11:04:27,078
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE ##5dd8cc140cdd4253b87bc394b9b8700c
        SET ChangeQuantity = ISNULL(Quantity,0) - ISNULL(ReceiveQuantity,0)
        , ChangeWarehouse = ISNULL(Quantity,0) - ISNULL(PuReceiptQuantity,0)


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


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


    时间: 2021-11-02 11:38:28,912
  线程ID: 33
日志级别: 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 [货期],Modi_Operator [修改人],Modi_OperatorTime [修改日期], [GoodsRemark] [备注], ShutOut [停用]
INTO tempdb.dbo.[4d178762-680e-4060-98c4-09b28fe0b7c0]
FROM [##92717d42de8a4d249be64bdae38d147e]
ORDER BY Goods_no


    时间: 2021-11-02 11:39:00,262
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息:  UPDATE A SET Quantity = ISNULL(B.Quantity,0)
 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PuReceiptGoods A
        WHERE EXISTS( SELECT 1 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] WHERE A.PuReceiptID = PuReceiptID )
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID

 UPDATE A SET DeliveryQuantity = ISNULL(B.Quantity,0)
 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM DeliveryGoods A
        WHERE EXISTS( SELECT 1 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] WHERE A.DeliveryID = DeliveryID )
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID

 UPDATE A SET PurchaseQuantity = ISNULL(B.Quantity,0)
 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(Quantity,0)) As Quantity
        FROM PurchaseGoods A
        WHERE EXISTS( SELECT 1 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] WHERE A.Purchase_ID = Purchase_ID )
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID

 UPDATE A SET PurchaseDiffQuantity = ISNULL(A.PurchaseQuantity,0) - ISNULL(B.Quantity,0)
 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] A
    INNER JOIN (
        SELECT A.Purchase_ID, SUM(ISNULL(R.Quantity,0)) As Quantity
        FROM PuReceipt A
        INNER JOIN PuReceiptGoods R ON A.PuReceiptID = R.PuReceiptID
        INNER JOIN Purchase P ON A.Purchase_ID = P.Purchase_ID
        WHERE 1 = 1 AND A.[Type] = 1
        GROUP BY A.Purchase_ID
    ) B ON A.Purchase_ID = B.Purchase_ID
 UPDATE A SET DpAmount = ISNULL(B.DpAmount,0),BillAmount = ISNULL(B.BillAmount,0)
 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] A
    INNER JOIN (
        SELECT A.PuReceiptID, SUM(A.Quantity * A.UnitPrice) As BillAmount,SUM(A.Quantity * B.UnitPrice) As DpAmount
        FROM PuReceiptGoods A LEFT JOIN Goods B ON A.Goods_No=B.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] WHERE A.PuReceiptID = PuReceiptID )
        GROUP BY A.PuReceiptID
    ) B ON A.PuReceiptID = B.PuReceiptID


    时间: 2021-11-02 11:39:00,352
  线程ID: 59
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, PureceiptID AS [单号], Manual_ID AS [手工单号], Receipt_Date AS [日期], 
        Purchase_ID AS [采购单号], ArrivalID AS [到货通知单号], DeliveryID AS [出货单号], ReceiptMode AS [收货方式],
        rtrim(Supply_No) AS [供应商编号], Supply_Abv AS [供应商简称], rtrim(Warehouse_No) AS [仓库编号], Warehouse_Na AS [仓库名称], 
        Quantity AS [数量],
 DpAmount AS [吊牌额],
 BillAmount AS [采购额],
        PurchaseQuantity AS [业务状态#采购数], PurchaseDiffQuantity AS [业务状态#采购差异],
        DeliveryQuantity AS [业务状态#出货数], DifferencesQuantity AS [业务状态#出货差异],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], OperatorName AS [单据状态#操作员名称],Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostUserName AS [单据状态#审核人名称], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Remark AS [备注]
INTO tempdb.dbo.[68b0d6da-628f-4b06-b058-920fe44abf43]
 FROM [##8729f7846b314cf88b8c5751e0ca8ab4] 
 ORDER BY Receipt_Date DESC, PureceiptID ASC


    时间: 2021-11-02 11:48:08,003
  线程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 [##5779722b988a4b07afdc7f191de6a838] A
    INNER JOIN (
        SELECT A.DeliveryID, SUM(ISNULL(Quantity,0)) As Quantity, SUM(ISNULL(Quantity,0) * ISNULL(BalancePrice,0)) As Amount,
               SUM(ISNULL(Quantity,0) * ISNULL(A.UnitPrice,ISNULL(G.UnitPrice,0))) As DpAmount
        FROM DeliveryGoods A
        LEFT JOIN Goods G ON A.Goods_No = G.Goods_No
        WHERE EXISTS( SELECT 1 FROM [##5779722b988a4b07afdc7f191de6a838] WHERE A.DeliveryID = DeliveryID )
        GROUP BY A.DeliveryID
    ) B ON A.DeliveryID = B.DeliveryID


    时间: 2021-11-02 11:48:08,033
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, DeliveryID AS [单号], Manual_ID AS [手工单号], Delivery_Date AS [日期], 
        rtrim(Warehouse_No) AS [调出仓库编号], Warehouse_Na AS [调出仓库名称], rtrim(ToWarehouse_No) AS [调入仓库编号], ToWarehouse_Na AS [调入仓库名称], 
        Quantity AS [数量],
        DpAmount AS [吊牌额],
        JiZhang AS [记账状态#记账], JiZhangOperator AS [记账状态#记账人], JiZhangDate AS [记账状态#记账日期],
        Operator AS [单据状态#操作员], Input_Date AS [单据状态#录入日期], 
        Posted AS [单据状态#审核], PostUser AS [单据状态#审核人], PostedDate AS [单据状态#审核日期], 
        PrintFlag AS [单据状态#打印], Flag AS [单据状态#完成], Remark AS [备注]
INTO tempdb.dbo.[7922b1b3-f913-456d-84f9-d6d683b69cba]
 FROM [##5779722b988a4b07afdc7f191de6a838] 
 ORDER BY Delivery_Date DESC, DeliveryID ASC


    时间: 2021-11-02 15:13:56,941
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 库存合计#数量
    , 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 [##afb8f88e4d294279a448e9c5b3d802ef]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-11-02 15:13:57,144
  线程ID: 28
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##afb8f88e4d294279a448e9c5b3d802ef] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##b9f3ce3424cd448ab74cdbe40d71025c] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No


    时间: 2021-11-02 15:14:29,246
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT TOP 0 CAST(W.Company_ID AS VARCHAR(50)) AS Company_ID, A.Warehouse_No, B.Goods_No, C.ColorID, C.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 库存合计#数量
    , 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 [##5d7ad9341be548fea817794807e4dd0f]
FROM Delivery A, Barcode B, DeliveryDetail C, Warehouse W


    时间: 2021-11-02 15:14:29,418
  线程ID: 16
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##5d7ad9341be548fea817794807e4dd0f] (Company_ID, Warehouse_No, Goods_No, ColorID, Long, [库存#S1], 库存#数量)
SELECT W.Company_ID, A.Warehouse_No, A.Goods_No, A.ColorID, A.Long, [S1], (ISNULL([S1], 0))
FROM [##cd349d918db94148af239a63faf5a9ae] A
INNER JOIN Warehouse W ON W.Warehouse_No = A.Warehouse_No