时间: 2025-03-14 10:09:55,947
  线程ID: 70
日志级别: 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>2025-03-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-03-14</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>

    时间: 2025-03-14 10:09:55,975
  线程ID: 70
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##872e233682eb40299c9e70e5de4d4596]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:10:06,712
  线程ID: 63
日志级别: 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>2025-03-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-03-14</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>
  <OutputData>
    <ID>7</ID>
    <ParentID>1</ParentID>
    <FieldID>CheckDate</FieldID>
    <FieldName>日期</FieldName>
    <Expression>A.CheckDate</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2025-03-14 10:10:06,728
  线程ID: 63
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##0313fdb0429249f1b878031847781b93]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:54:32,022
  线程ID: 25
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM004]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM004</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:54:32,046
  线程ID: 25
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##5f0ebcd8a8c34533940984d0ef9bbefa]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:55:11,529
  线程ID: 59
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM004]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM004</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:55:11,539
  线程ID: 59
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##4874c446a1ee45b19a8febf30e20c568]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:57:28,404
  线程ID: 15
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM004]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM004</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:57:28,413
  线程ID: 15
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##1d905404710447cca26e91122fd2f328]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:58:00,023
  线程ID: 51
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM004]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM004</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:58:00,032
  线程ID: 51
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##dd363f03d82148268d49047428f8ef38]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:58:28,009
  线程ID: 59
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM004]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM004</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:58:28,020
  线程ID: 59
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##86dadf9a5ea6416b9262c56b3f94762e]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:58:38,023
  线程ID: 15
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM005]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM005</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:58:38,034
  线程ID: 15
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##99153cfc51674e87a7dedb1d4bab7d5a]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:58:48,402
  线程ID: 54
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM003]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM003</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:58:48,413
  线程ID: 54
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##a9cae8804c4843efb12c77f6079e0414]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:59:05,865
  线程ID: 54
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM003]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM003</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:59:05,874
  线程ID: 54
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##fc83283d653b4734a68cf152f6eeb4e8]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:59:18,978
  线程ID: 15
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM001]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM001</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:59:18,989
  线程ID: 15
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##0ce24371114941429e78ddf1ab96c417]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:59:40,998
  线程ID: 78
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM001]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM001</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:59:41,007
  线程ID: 78
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##7a70463aca5c4dbb8818fa27d0400bc3]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 10:59:55,176
  线程ID: 51
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM004]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM004</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 10:59:55,189
  线程ID: 51
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##049108648e0d459eb2603ce6bcdaf96b]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 11:00:03,071
  线程ID: 14
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM006]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM006</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 11:00:03,084
  线程ID: 14
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##0e7ea658539044dbba07bdee326928cf]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 11:00:16,387
  线程ID: 11
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM006]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM006</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 11:00:16,396
  线程ID: 11
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##21fb491956d5472280e70ac89bb3b229]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 11:00:25,366
  线程ID: 85
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM007]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM007</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 11:00:25,377
  线程ID: 85
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##14f0c3d30ccc425b822a249e78734e10]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 11:00:36,067
  线程ID: 87
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM007]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM007</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 11:00:36,076
  线程ID: 87
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##7aba47befab94a0e910c6dbb3a6fc321]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 11:00:49,856
  线程ID: 86
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>CustomerID</ID>
    <Caption />
    <Data>[渠道编号:JM002]
</Data>
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM002</Data>
    <ConditionType>1</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 11:00:49,867
  线程ID: 86
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##ccdd88dbf2744770853b8d93a59b5a89]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 11:01:08,432
  线程ID: 12
日志级别: 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>shutout</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB001</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
</NewDataSet>

    时间: 2025-03-14 11:01:08,446
  线程ID: 12
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##bdb49d29b86c454bafaea88ee2fba358]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 14:13:53,341
  线程ID: 48
日志级别: 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>2025-03-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-03-14</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>

    时间: 2025-03-14 14:13:53,352
  线程ID: 48
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##53866313b95e468398a5456a4c0f828d]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-03-14 20:36:03,820
  线程ID: 344
日志级别: 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>2025-03-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-03-14</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>

    时间: 2025-03-14 20:36:03,834
  线程ID: 344
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2c4186dc769549de96e70e25326b012d]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID