时间: 2024-12-25 00:07:04,608
  线程ID: 6
日志级别: INFO 
对象名称: Jd.ACES.Task.SendReportCacheTask
日志信息: send reports...

    时间: 2024-12-25 01:07:04,637
  线程ID: 29
日志级别: INFO 
对象名称: Jd.ACES.Task.FlushKeyCacheTask
日志信息: Key Management Thread Performs Key Updating...

    时间: 2024-12-25 01:07:04,638
  线程ID: 29
日志级别: INFO 
对象名称: Jd.ACES.Task.FlushKeyCacheTask
日志信息: Key Management Thread Performs Key Updating...0

    时间: 2024-12-25 01:07:04,669
  线程ID: 189
日志级别: INFO 
对象名称: Jd.ACES.Task.SendReportCacheTask
日志信息: send reports...

    时间: 2024-12-25 02:07:04,738
  线程ID: 169
日志级别: INFO 
对象名称: Jd.ACES.Task.SendReportCacheTask
日志信息: send reports...

    时间: 2024-12-25 03:07:04,799
  线程ID: 212
日志级别: INFO 
对象名称: Jd.ACES.Task.SendReportCacheTask
日志信息: send reports...

    时间: 2024-12-25 04:07:04,872
  线程ID: 173
日志级别: INFO 
对象名称: Jd.ACES.Task.SendReportCacheTask
日志信息: send reports...

    时间: 2024-12-25 10:05:18,180
  线程ID: 90
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>Customer_ID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>Goods_No</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>billdatebegin</ID>
    <Caption />
    <Data>2024-12-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2024-12-24</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>chkisquery</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT031</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data />
    <ConditionType>4</ConditionType>
  </__customer__>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>JN001</Customer_ID>
    <Abbrev>济南集合</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>QD001BUR</Customer_ID>
    <Abbrev>青岛BUR</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>YC01BUR</Customer_ID>
    <Abbrev>银川BUR</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>Z029XA1</Customer_ID>
    <Abbrev>临潼BUR店</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>Z029XA2</Customer_ID>
    <Abbrev>咸阳机场店</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>Z029XA3</Customer_ID>
    <Abbrev>咸阳ARM店</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__customer___x0024_customer_id_x0024_>
    <Customer_ID>Z029XA5</Customer_ID>
    <Abbrev>临潼阿玛尼</Abbrev>
  </__customer___x0024_customer_id_x0024_>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>LT031</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__goods__>
    <ID>userno</ID>
    <Caption />
    <Data>LT031</Data>
    <ConditionType>0</ConditionType>
  </__goods__>
  <OutputData>
    <ID>9</ID>
    <ParentID>1</ParentID>
    <FieldID>Name</FieldID>
    <FieldName>营业员姓名</FieldName>
    <Expression>BM.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>14</ID>
    <ParentID>1</ParentID>
    <FieldID>Quantity</FieldID>
    <FieldName>数量</FieldName>
    <Expression>SUM(A.Quantity)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>16</ID>
    <ParentID>1</ParentID>
    <FieldID>DiscountAmount</FieldID>
    <FieldName>生意额</FieldName>
    <Expression>SUM(DiscountAmount)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID>Abbrev</FieldID>
    <FieldName>渠道简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2024-12-25 10:05:18,211
  线程ID: 90
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##f418130092254166bca89e31b43e64b8]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2024-12-25 13:40:29,478
  线程ID: 85
日志级别: 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>LT017</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT017</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2024-12-25 13:40:29,489
  线程ID: 85
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##9d317b3304d54f1197cc11a4165f6dc0]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2024-12-25 13:51:57,266
  线程ID: 85
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>buisnessmanid</ID>
    <Caption />
    <Data>LTB0565</Data>
    <ConditionType>1</ConditionType>
  </__data__>
</NewDataSet>

    时间: 2024-12-25 13:54:02,132
  线程ID: 72
日志级别: 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__>
  <__data__>
    <ID>abbrev</ID>
    <Caption />
    <Data>上海</Data>
    <ConditionType>2</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>LT062</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT062</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2024-12-25 13:54:02,139
  线程ID: 72
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##a917a2be41a34bf5bc1ade76b1683304]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2024-12-25 13:54:16,130
  线程ID: 75
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:SHZG01]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>LT062</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT062</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>SHZG01</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2024-12-25 13:54:16,138
  线程ID: 75
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##598b0ca96d434e9a9c0b5595c6381ec4]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2024-12-25 14:34:39,790
  线程ID: 72
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>Customer_ID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>Goods_No</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>billdatebegin</ID>
    <Caption />
    <Data>2024-12-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2024-12-25</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>chkisquery</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT091</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>LT091</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__goods__>
    <ID>userno</ID>
    <Caption />
    <Data>LT091</Data>
    <ConditionType>0</ConditionType>
  </__goods__>
  <OutputData>
    <ID>8</ID>
    <ParentID>1</ParentID>
    <FieldID>BusiManID</FieldID>
    <FieldName>营业员编号</FieldName>
    <Expression>A.BusiManID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>9</ID>
    <ParentID>1</ParentID>
    <FieldID>Name</FieldID>
    <FieldName>营业员姓名</FieldName>
    <Expression>BM.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>14</ID>
    <ParentID>1</ParentID>
    <FieldID>Quantity</FieldID>
    <FieldName>数量</FieldName>
    <Expression>SUM(A.Quantity)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>16</ID>
    <ParentID>1</ParentID>
    <FieldID>DiscountAmount</FieldID>
    <FieldName>生意额</FieldName>
    <Expression>SUM(DiscountAmount)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>17</ID>
    <ParentID>1</ParentID>
    <FieldID>Discount</FieldID>
    <FieldName>折扣</FieldName>
    <Expression>CASE WHEN ISNULL(SUM(A.CustDpAmount), 0) &lt;&gt; 0 THEN CAST(SUM(DiscountAmount) / SUM(A.CustDpAmount) AS NUMERIC(18,2)) ELSE 0 END </Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2024-12-25 14:34:39,798
  线程ID: 72
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##3d14f10089524518891ca24dbb0ebabc]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2024-12-25 15:26:29,716
  线程ID: 13
日志级别: 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>LT017</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT017</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2024-12-25 15:26:29,724
  线程ID: 13
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##17b03f1dd33c4711a1982ab452d53d95]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2024-12-25 16:01:41,698
  线程ID: 79
日志级别: 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>LT017</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>LT017</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2024-12-25 16:01:41,710
  线程ID: 79
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##ba3d2eefe2c14c84ba229a69b3a24478]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID