时间: 2021-02-22 10:35:36,320 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##2a47003c4480432f9590eba78edda7dd a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-02-22 10:35:36,350 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2a47003c4480432f9590eba78edda7dd SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-02-22 10:35:36,354 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##2a47003c4480432f9590eba78edda7dd 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.Pre_RetailOrderID = 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-02-22 10:35:36,388 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2a47003c4480432f9590eba78edda7dd SET SaleType='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') AND Status = '退货' 时间: 2021-02-22 10:35:36,392 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##2a47003c4480432f9590eba78edda7dd SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-02-22 10:35:43,430 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##041e2cf1ac604146a5998215d549af3c a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-02-22 10:35:43,436 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##041e2cf1ac604146a5998215d549af3c SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-02-22 10:35:43,442 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##041e2cf1ac604146a5998215d549af3c 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.Pre_RetailOrderID = 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-02-22 10:35:43,469 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##041e2cf1ac604146a5998215d549af3c SET SaleType='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') AND Status = '退货' 时间: 2021-02-22 10:35:43,471 线程ID: 68 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##041e2cf1ac604146a5998215d549af3c SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-02-22 10:36:33,698 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##5272863cc11c48c0a62925de24411f41 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-02-22 10:36:33,702 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5272863cc11c48c0a62925de24411f41 SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-02-22 10:36:33,706 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##5272863cc11c48c0a62925de24411f41 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.Pre_RetailOrderID = 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-02-22 10:36:33,731 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5272863cc11c48c0a62925de24411f41 SET SaleType='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') AND Status = '退货' 时间: 2021-02-22 10:36:33,733 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##5272863cc11c48c0a62925de24411f41 SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-02-22 10:36:57,285 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##9afd3572cf824e07984d332960fb2350 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-02-22 10:36:57,290 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9afd3572cf824e07984d332960fb2350 SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-02-22 10:36:57,293 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##9afd3572cf824e07984d332960fb2350 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.Pre_RetailOrderID = 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-02-22 10:36:57,315 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9afd3572cf824e07984d332960fb2350 SET SaleType='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') AND Status = '退货' 时间: 2021-02-22 10:36:57,317 线程ID: 61 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##9afd3572cf824e07984d332960fb2350 SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-02-22 10:40:40,226 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, CONVERT(VARCHAR(10), A.PdStock_Date, 120) AS [单据日期], A.Customer_ID AS [渠道编号], CT.Abbrev AS [渠道简称], GS.Goods_Name AS [货品名称], A.ColorID AS [颜色编号], A.Long AS [内长], SUM(A.Quantity) AS [数量], GS.UnitPrice AS [吊牌价] INTO tempdb.dbo.[4e352214-a622-43dc-9560-673272a630ba] FROM ##dc190e21f8564ca7b017f5ba9303b610 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 CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice ORDER BY CONVERT(VARCHAR(10), A.PdStock_Date, 120), A.Customer_ID, CT.Abbrev, GS.Goods_Name, A.ColorID, A.Long, GS.UnitPrice 时间: 2021-02-22 10:45:01,363 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##1adde17787254863be81589b154235c0 a INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID 时间: 2021-02-22 10:45:01,367 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1adde17787254863be81589b154235c0 SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND Status <> '退货' 时间: 2021-02-22 10:45:01,370 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE a SET a.SaleType=b.SaleType FROM ##1adde17787254863be81589b154235c0 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.Pre_RetailOrderID = 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-02-22 10:45:01,391 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1adde17787254863be81589b154235c0 SET SaleType='线上发货' WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> '' AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') AND Status = '退货' 时间: 2021-02-22 10:45:01,393 线程ID: 57 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE ##1adde17787254863be81589b154235c0 SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> '' 时间: 2021-02-22 11:03:39,023 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET PrintStatus = 1 FROM [##970d59766f674399b65d7f0e4592571b] A WHERE EXISTS( SELECT 1 FROM BillPrint WHERE BillType = 'CPdStock' AND A.PdStockID = BillNo ) 时间: 2021-02-22 11:03:39,030 线程ID: 65 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: UPDATE A SET Quantity = ISNULL(B.Quantity,0) FROM [##970d59766f674399b65d7f0e4592571b] A INNER JOIN ( SELECT A.PdStockID, SUM(ISNULL(A.Quantity,0)) As Quantity FROM [PdStockGoods] A WHERE EXISTS( SELECT 1 FROM ##970d59766f674399b65d7f0e4592571b WHERE A.PdStockID = PdStockID ) AND EXISTS (SELECT 1 FROM [##702572d4a42c44be8716d6db70b3e4ce] WHERE Goods_No = A.Goods_No) GROUP BY A.PdStockID ) B ON A.PdStockID = B.PdStockID 时间: 2021-02-22 11:03:39,159 线程ID: 65 日志级别: 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.[47017721-865f-42ed-bacf-7e5e37286422] FROM [##970d59766f674399b65d7f0e4592571b] ORDER BY PdStock_Date DESC, PdStockID ASC 时间: 2021-02-22 11:32:17,326 线程ID: 57 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Vip 5 <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> billdatebegin 2021-01-20 0 <__data__> billdateend 2021-02-20 0 <__vip__> userno 201 0 <__customer__> userno 201 0 <__businessman__> userno 201 0 2 1 VIP卡号 A.VIP true 1 3 1 VIP姓名 A.Name true 2 4 1 发卡店铺 A.Customer_ID true 3 16 1 电话 A.Tel true 4 9 1 性别 A.Sex true 5 6 1 发卡日期 CONVERT(VARCHAR(10), A.BegainDate, 120) true 6 7 1 失效日期 CONVERT(VARCHAR(10), A.ExpireDate, 120) true 7 时间: 2021-02-22 11:32:17,334 线程ID: 57 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##a6a2dd0faa714b9d85a9233ee21e81e5] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2021-02-22 11:32:50,077 线程ID: 57 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Vip 5 <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> billdatebegin 2021-01-20 0 <__data__> billdateend 2021-02-20 0 <__vip__> userno 201 0 <__customer__> userno 201 0 <__businessman__> userno 201 0 2 1 VIP卡号 A.VIP true 1 3 1 VIP姓名 A.Name true 2 16 1 电话 A.Tel true 4 9 1 性别 A.Sex true 5 6 1 发卡日期 CONVERT(VARCHAR(10), A.BegainDate, 120) true 6 7 1 失效日期 CONVERT(VARCHAR(10), A.ExpireDate, 120) true 7 5 1 发卡店铺简称 CT.Abbrev true 8 时间: 2021-02-22 11:32:50,080 线程ID: 57 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##d63752c76dad41da97a25063953163f9] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2021-02-22 11:38:25,112 线程ID: 57 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> Vip 5 <__data__> Customer_ID 5 <__data__> BuisnessManID 5 <__data__> billdatebegin 2021-01-20 0 <__data__> billdateend 2021-02-20 0 <__vip__> userno 201 0 <__customer__> userno 201 0 <__businessman__> userno 201 0 2 1 VIP卡号 A.VIP true 1 3 1 VIP姓名 A.Name true 2 16 1 电话 A.Tel true 4 9 1 性别 A.Sex true 5 6 1 发卡日期 CONVERT(VARCHAR(10), A.BegainDate, 120) true 6 7 1 失效日期 CONVERT(VARCHAR(10), A.ExpireDate, 120) true 7 5 1 发卡店铺简称 CT.Abbrev true 8 42 1 VIP等级 A.Vipgrade true 9 34 1 状态 A.Status true 10 35 1 资料 A.Information true 11 时间: 2021-02-22 11:38:25,114 线程ID: 57 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##9acfd96254ef456abefa023c2fabb6d3] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2021-02-22 11:51:23,849 线程ID: 66 日志级别: 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 [##a722fc31caea4eddafe2dd51be29d251] FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT 时间: 2021-02-22 11:51:24,110 线程ID: 66 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: INSERT INTO [##a722fc31caea4eddafe2dd51be29d251] (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 [##b99007af513947839ed1bb1653a63f95] A INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID 时间: 2021-02-22 12:11:32,619 线程ID: 63 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[587959b0-f5af-4e87-b4ee-829ec98b5e8c] FROM [##396d1b9aeedb4a94b3298415e99f8c96] ORDER BY Goods_no 时间: 2021-02-22 12:11:37,494 线程ID: 64 日志级别: 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.[587959b0-f5af-4e87-b4ee-829ec98b5e8c] FROM [##979e5f3e50454cfe8ebd23b3d1c7cabd] ORDER BY Goods_no 时间: 2021-02-22 12:11:42,287 线程ID: 65 日志级别: 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.[587959b0-f5af-4e87-b4ee-829ec98b5e8c] FROM [##812a8334188e4af0b4f62b752c1ecdc5] ORDER BY Goods_no 时间: 2021-02-22 13:55:45,277 线程ID: 42 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> BuisnessManID 5 <__data__> CustomerID 5 <__businessman__> userno SYSTEM 0 <__customer__> userno SYSTEM 0 时间: 2021-02-22 13:55:45,281 线程ID: 42 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT BuisnessManID, Name INTO [##e2779391b9fb4de7a7530bb5efa9c5cd] FROM ( SELECT BuisnessManID, Name FROM BuisnessMan A WHERE 1 = 1 ) A ORDER BY BuisnessManID 时间: 2021-02-22 13:55:45,289 线程ID: 42 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BuisnessManID AS [营业员编号], Name AS [营业员姓名] , CustomerID AS [渠道编号], Abbrev AS [渠道简称], Tel1 AS [电话], WorkDate AS [入职日期] , [Type] AS [类型], [Status] AS [状态], ParentBuisnessManID AS [营业员上线], ShutOut AS [停用] INTO tempdb.dbo.[c7ecbaee-a7b2-4565-9b0b-964c60447e53] FROM [##fc939258518b4246bb6a8f86373afdf2] ORDER BY BuisnessManID ASC, WorkDate DESC 时间: 2021-02-22 16:42:54,339 线程ID: 23 日志级别: INFO 对象名称: Regentsoft.Core.LoggingService 日志信息: <__data__> buisnessmanid 001 1 时间: 2021-02-22 16:42:54,345 线程ID: 23 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, BuisnessManID AS [营业员编号], Name AS [营业员姓名] , CustomerID AS [渠道编号], Abbrev AS [渠道简称], Tel1 AS [电话], WorkDate AS [入职日期] , [Type] AS [类型], [Status] AS [状态], ParentBuisnessManID AS [营业员上线], ShutOut AS [停用] INTO tempdb.dbo.[13e5ee06-3d81-466b-8fab-d35615f0696f] FROM [##8cadd6da31844c1ea912bad5cd8c1ef2] ORDER BY BuisnessManID ASC, WorkDate DESC 时间: 2021-02-22 18:16:04,168 线程ID: 8 日志级别: 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.[587959b0-f5af-4e87-b4ee-829ec98b5e8c] FROM [##67a0eedeaac84f57801679af038c2dc8] ORDER BY Goods_no 时间: 2021-02-22 18:16:04,520 线程ID: 8 日志级别: 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.[587959b0-f5af-4e87-b4ee-829ec98b5e8c] FROM [##a2d58c99b82b4039bc8cf1428ad28afd] ORDER BY Goods_no 时间: 2021-02-22 18:19:00,718 线程ID: 50 日志级别: DEBUG 对象名称: Regentsoft.Core.LoggingService 日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, Goods_no AS [货号], Goods_name AS [货品名称], Brand AS [品牌] ,Category AS [一级类别], Category2 AS [二级类别] ,Range [系列], Pattern [款型], Item AS [项目], Authorisation [授权] ,Season [季节], [Year] [年份], ManuFacturer 厂家编号, Sex AS [性别], UnitPrice [吊牌价] ,GoodsDate [货期], [GoodsRemark] [备注], ShutOut [停用] INTO tempdb.dbo.[587959b0-f5af-4e87-b4ee-829ec98b5e8c] FROM [##b0b94a542bb64c4f99de49ab199ae871] ORDER BY Goods_no