时间: 2021-05-07 14:15:13,325
  线程ID: 49
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##052e10b66a0149a8a010d4d455011bf4]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:18,608
  线程ID: 48
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##03048b0b0f084a13b9dd4b569595bc75]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:19,477
  线程ID: 49
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##aad4fd7be90248bf9b5758de2d8a55e0]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:20,289
  线程ID: 53
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##d5415b5b27154ab1b76d7ffe921554af]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:21,110
  线程ID: 49
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##0e5690e8ade948c3b25aeb81b309f581]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:21,958
  线程ID: 53
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##e291dcbb776445a194aaf0f23aaaf086]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:22,811
  线程ID: 49
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##30b3958ed3ed4919839e833219837a09]
ORDER BY Goods_no


    时间: 2021-05-07 14:15:39,638
  线程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 [##970229bfa3fa469aaf616f7a126cc95b]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-05-07 14:15:39,986
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##970229bfa3fa469aaf616f7a126cc95b] (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 [##9382e2410ee3447987c030252ec1a549] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-05-07 14:16:37,444
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##25ab3579163f44e99d4847169a0e9e08 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:16:37,449
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##25ab3579163f44e99d4847169a0e9e08 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:16:37,452
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##25ab3579163f44e99d4847169a0e9e08 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:16:37,454
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##25ab3579163f44e99d4847169a0e9e08 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-05-07 14:16:37,487
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##25ab3579163f44e99d4847169a0e9e08 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-07 14:16:37,489
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##25ab3579163f44e99d4847169a0e9e08 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:16:37,525
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##25ab3579163f44e99d4847169a0e9e08

    时间: 2021-05-07 14:16:53,144
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##cae7fe24e69e4c91ad3359935ce44505 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:16:53,147
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##cae7fe24e69e4c91ad3359935ce44505 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:16:53,150
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cae7fe24e69e4c91ad3359935ce44505 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:16:53,153
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##cae7fe24e69e4c91ad3359935ce44505 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-05-07 14:16:53,193
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cae7fe24e69e4c91ad3359935ce44505 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-07 14:16:53,197
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##cae7fe24e69e4c91ad3359935ce44505 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:16:53,232
  线程ID: 47
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##cae7fe24e69e4c91ad3359935ce44505

    时间: 2021-05-07 14:18:18,097
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##6ca641e98ab144e1ba01e0914ba6dc6e ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:18:18,099
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##6ca641e98ab144e1ba01e0914ba6dc6e a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


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


    时间: 2021-05-07 14:18:18,107
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##6ca641e98ab144e1ba01e0914ba6dc6e a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


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


    时间: 2021-05-07 14:18:18,148
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##6ca641e98ab144e1ba01e0914ba6dc6e SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:18:18,183
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##6ca641e98ab144e1ba01e0914ba6dc6e

    时间: 2021-05-07 14:18:25,851
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##8a52e4a40ac7459caf54220ab7f06788 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:18:25,854
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##8a52e4a40ac7459caf54220ab7f06788 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:18:25,882
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8a52e4a40ac7459caf54220ab7f06788 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:18:25,897
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##8a52e4a40ac7459caf54220ab7f06788 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-05-07 14:18:25,952
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8a52e4a40ac7459caf54220ab7f06788 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-07 14:18:25,956
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##8a52e4a40ac7459caf54220ab7f06788 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:18:26,095
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##8a52e4a40ac7459caf54220ab7f06788

    时间: 2021-05-07 14:18:30,077
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##bb2a7b99302c483e886427959efcacc2 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:18:30,080
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##bb2a7b99302c483e886427959efcacc2 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:18:30,103
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bb2a7b99302c483e886427959efcacc2 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:18:30,116
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##bb2a7b99302c483e886427959efcacc2 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-05-07 14:18:30,159
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bb2a7b99302c483e886427959efcacc2 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-07 14:18:30,162
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bb2a7b99302c483e886427959efcacc2 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:18:30,291
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##bb2a7b99302c483e886427959efcacc2

    时间: 2021-05-07 14:19:10,951
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##63a7b38cbd544c15b91f6cddd3c48efe ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:19:10,953
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##63a7b38cbd544c15b91f6cddd3c48efe a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:19:10,980
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##63a7b38cbd544c15b91f6cddd3c48efe SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:19:10,994
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##63a7b38cbd544c15b91f6cddd3c48efe a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


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


    时间: 2021-05-07 14:19:11,038
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##63a7b38cbd544c15b91f6cddd3c48efe SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:19:11,204
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##63a7b38cbd544c15b91f6cddd3c48efe

    时间: 2021-05-07 14:19:17,235
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##05c0eeafee0a40b2a2704dc5ffe2c659 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:19:17,236
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##05c0eeafee0a40b2a2704dc5ffe2c659 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:19:17,262
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##05c0eeafee0a40b2a2704dc5ffe2c659 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:19:17,274
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##05c0eeafee0a40b2a2704dc5ffe2c659 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-05-07 14:19:17,316
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##05c0eeafee0a40b2a2704dc5ffe2c659 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-07 14:19:17,319
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##05c0eeafee0a40b2a2704dc5ffe2c659 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:19:17,462
  线程ID: 49
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##05c0eeafee0a40b2a2704dc5ffe2c659

    时间: 2021-05-07 14:23:33,318
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##b24d44f48dac42e08ebc2755d01d1767 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-07 14:23:33,320
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##b24d44f48dac42e08ebc2755d01d1767 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-07 14:23:33,324
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b24d44f48dac42e08ebc2755d01d1767 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-07 14:23:33,328
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##b24d44f48dac42e08ebc2755d01d1767 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.预售零售订单号 = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-05-07 14:23:33,368
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b24d44f48dac42e08ebc2755d01d1767 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-07 14:23:33,370
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##b24d44f48dac42e08ebc2755d01d1767 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-07 14:23:33,406
  线程ID: 53
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##b24d44f48dac42e08ebc2755d01d1767

    时间: 2021-05-07 17:16:24,630
  线程ID: 97
日志级别: 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.[5a72053f-4fed-45ae-a888-c5d26f4b741e]
FROM [##7810baf9204d451ebf3cd427cee492ed]
ORDER BY Goods_no