时间: 2025-11-29 17:58:25,300
  线程ID: 228
日志级别: 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-11-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-11-29</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>chkisquery</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB002</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM001</Data>
    <ConditionType>2</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB002</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__goods__>
    <ID>userno</ID>
    <Caption />
    <Data>NB002</Data>
    <ConditionType>0</ConditionType>
  </__goods__>
  <__goods__>
    <ID>brand</ID>
    <Caption>品牌</Caption>
    <Data>GUCCI</Data>
    <ConditionType>1</ConditionType>
  </__goods__>
  <OutputData>
    <ID>4</ID>
    <ParentID>1</ParentID>
    <FieldID>CheckID</FieldID>
    <FieldName>核销单号</FieldName>
    <Expression>A.CheckID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>7</ID>
    <ParentID>1</ParentID>
    <FieldID>Manual_ID</FieldID>
    <FieldName>手工单号</FieldName>
    <Expression>a.Manual_ID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>8</ID>
    <ParentID>1</ParentID>
    <FieldID>CheckDate</FieldID>
    <FieldName>日期</FieldName>
    <Expression>A.CheckDate</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>10</ID>
    <ParentID>1</ParentID>
    <FieldID>Name</FieldID>
    <FieldName>营业员姓名</FieldName>
    <Expression>BM.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>13</ID>
    <ParentID>1</ParentID>
    <FieldID>Quantity</FieldID>
    <FieldName>数量</FieldName>
    <Expression>SUM(A.Quantity)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>15</ID>
    <ParentID>1</ParentID>
    <FieldID>DiscountAmount</FieldID>
    <FieldName>生意额</FieldName>
    <Expression>SUM(DiscountAmount)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2025-11-29 17:58:25,326
  线程ID: 228
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##eed48cfe3e0246ba87f2fa3129f3e7c4]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2025-11-29 18:00:47,476
  线程ID: 192
日志级别: 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-11-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2025-11-29</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>chkisquery</ID>
    <Caption />
    <Data>0</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>NB002</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__customer__>
    <ID>customer_id</ID>
    <Caption>渠道编号</Caption>
    <Data>JM001</Data>
    <ConditionType>2</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>NB002</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <__goods__>
    <ID>userno</ID>
    <Caption />
    <Data>NB002</Data>
    <ConditionType>0</ConditionType>
  </__goods__>
  <__goods__>
    <ID>brand</ID>
    <Caption>品牌</Caption>
    <Data />
    <ConditionType>4</ConditionType>
  </__goods__>
  <__goods___x0024_brand_x0024_>
    <Brand>ALEXANDER MCQUEEN</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>BALENCIAGA</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>BALLY</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>FERRAGAMO</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>HERON PRESTON</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>KENZO</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>MARCELO BURLON</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>OFF WHITE</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>OFF-WHITE</Brand>
  </__goods___x0024_brand_x0024_>
  <__goods___x0024_brand_x0024_>
    <Brand>PALM ANGELS</Brand>
  </__goods___x0024_brand_x0024_>
  <OutputData>
    <ID>4</ID>
    <ParentID>1</ParentID>
    <FieldID>CheckID</FieldID>
    <FieldName>核销单号</FieldName>
    <Expression>A.CheckID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>7</ID>
    <ParentID>1</ParentID>
    <FieldID>Manual_ID</FieldID>
    <FieldName>手工单号</FieldName>
    <Expression>a.Manual_ID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>8</ID>
    <ParentID>1</ParentID>
    <FieldID>CheckDate</FieldID>
    <FieldName>日期</FieldName>
    <Expression>A.CheckDate</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>10</ID>
    <ParentID>1</ParentID>
    <FieldID>Name</FieldID>
    <FieldName>营业员姓名</FieldName>
    <Expression>BM.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>13</ID>
    <ParentID>1</ParentID>
    <FieldID>Quantity</FieldID>
    <FieldName>数量</FieldName>
    <Expression>SUM(A.Quantity)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>15</ID>
    <ParentID>1</ParentID>
    <FieldID>DiscountAmount</FieldID>
    <FieldName>生意额</FieldName>
    <Expression>SUM(DiscountAmount)</Expression>
    <IsGroup>false</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2025-11-29 18:00:47,511
  线程ID: 192
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##6ec59d6eb6bd4d79a0d7194205b623a3]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID