时间: 2021-08-17 16:15:54,195
  线程ID: 14
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-08-17 16:15:54,217
  线程ID: 14
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##fcc3f67b9ecc4729838f1ad2cd9d24e6]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2021-08-17 16:15:54,228
  线程ID: 14
日志级别: 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.[0568b301-0b3f-4fff-a8dc-8bd36609badf]
 FROM [##3fcaaf67346b4c8d8842580ca3e61934]
 ORDER BY BuisnessManID ASC, WorkDate DESC


    时间: 2021-08-17 16:35:14,269
  线程ID: 123
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[e628dee3-170b-408d-bce4-11947c307319]
 FROM Customer A
 INNER JOIN [##890f9a537e404862923cff108f0d4c74] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


    时间: 2021-08-17 16:35:42,429
  线程ID: 7
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>201</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>201</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-08-17 16:35:42,429
  线程ID: 7
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##36f7462fa81b4476bb34d18d19f2285e]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2021-08-17 16:35:42,445
  线程ID: 7
日志级别: 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.[bcc98180-ed3e-4e29-b31f-8086287f389f]
 FROM [##19958d6c6a89449fade2528d8d77d472]
 ORDER BY BuisnessManID ASC, WorkDate DESC


    时间: 2021-08-17 19:33:30,349
  线程ID: 108
日志级别: 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.[849f9061-f5e5-4a9e-a1d0-bda7e42b22d6]
FROM [##e627fd82898f4879800e4a531d432bf3]
ORDER BY Goods_no


    时间: 2021-08-17 19:38:40,387
  线程ID: 108
日志级别: 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 [##ca759d8af0a94f7caef6a615c2eadafc]
FROM Delivery A, Barcode B, DeliveryDetail C, Customer CT


    时间: 2021-08-17 19:38:40,942
  线程ID: 108
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: INSERT INTO [##ca759d8af0a94f7caef6a615c2eadafc] (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 [##5a77e9fc58ec4d2fad09e2ba64d3131c] A
INNER JOIN Customer CT ON CT.Customer_ID = A.Customer_ID


    时间: 2021-08-17 19:41:31,758
  线程ID: 8
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT IDENTITY(INT, 1, 1) AS RowNumber, RTRIM(A.Customer_ID) AS [渠道编号], Abbrev AS [渠道简称], Customer_Na AS [渠道名称]
,[Level] [等级],Region AS [区域], Mathod AS [经营方式], DealInPattern AS [经营模式]
,ParentChannelID AS [上级渠道], AccountCustomer_ID [应收归集户口], Credit [信用额]
,Fdiscount AS [期货折扣], Discount [补货折扣], PuDiscount [铺货折扣], MaiDiscount AS [买断折扣]
,[Group] [组], Company_ID [公司编号], SaleMan [业务员]
,Keyman AS [联系人], Country [国家], Province [省份], City [城市], District AS [地区], Sort [类别]
INTO tempdb.dbo.[85b2fcfd-5fe0-4b53-ab38-b85cb68a1dc9]
 FROM Customer A
 INNER JOIN [##43405c5509ed44e5b278976c8befa09d] B ON A.Customer_ID = B.Customer_ID
 ORDER BY A.Customer_ID


    时间: 2021-08-17 19:45:25,711
  线程ID: 123
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2021-08-17 19:45:25,711
  线程ID: 123
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2922c109070f443b810ff3afe20dca27]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2021-08-17 19:45:25,726
  线程ID: 123
日志级别: 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.[2e1ae6ff-fafa-4ad8-83bd-6a254096ec42]
 FROM [##7bb5cd8970964d58b15bbfec5d8e423e]
 ORDER BY BuisnessManID ASC, WorkDate DESC