时间: 2025-05-02 13:40:15,765
  线程ID: 198
日志级别: 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-04-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-04-30</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-05-02 13:40:15,791
  线程ID: 198
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##147d4cb1eed0414a8927655cc60b7bc8]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-05-02 13:59:05,549
  线程ID: 256
日志级别: 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-04-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-04-30</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-05-02 13:59:05,560
  线程ID: 256
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##783dc843b983492e95d88fbec611240b]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-05-02 14:27:51,093
  线程ID: 289
日志级别: 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-31</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-05-02 14:27:51,102
  线程ID: 289
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##b5144deebcdb4aeca2100cbee151b909]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-05-02 14:28:16,287
  线程ID: 288
日志级别: 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-01-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-04-30</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-05-02 14:28:16,297
  线程ID: 288
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##e328c46c86274f4685d0be6d4283b816]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-05-02 14:28:51,504
  线程ID: 287
日志级别: 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-04-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-04-30</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-05-02 14:28:51,514
  线程ID: 287
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##41abab59325e4a48b14010522d5fe3b9]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID