时间: 2021-02-25 11:20:35,076
  线程ID: 55
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>Vip</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>Customer_ID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>billdatebegin</ID>
    <Caption />
    <Data>2020-11-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2021-02-25</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__vip__>
    <ID>userno</ID>
    <Caption />
    <Data>201</Data>
    <ConditionType>0</ConditionType>
  </__vip__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>201</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>201</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>5</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>6</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BegainDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>7</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>失效日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.ExpireDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>9</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>性别</FieldName>
    <Expression>A.Sex</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>16</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>电话</FieldName>
    <Expression>A.Tel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>7</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>32</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡人</FieldName>
    <Expression>A.PayCardUser</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>8</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>30</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>经办人</FieldName>
    <Expression>A.JBUser</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>9</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>34</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>状态</FieldName>
    <Expression>A.Status</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>10</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>33</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>使用状态</FieldName>
    <Expression>A.UseStatus</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>11</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>42</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级</FieldName>
    <Expression>A.Vipgrade</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>12</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>43</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级折扣</FieldName>
    <Expression>C.Discount</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>13</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>46</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>营业员姓名</FieldName>
    <Expression>BM.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>14</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2021-02-25 11:20:35,084
  线程ID: 55
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##ebccc1645fb04975af2cc59d6f5d26b0]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2021-02-25 12:51:21,310
  线程ID: 9
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: <NewDataSet>
  <__data__>
    <ID>Vip</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>Customer_ID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>BuisnessManID</ID>
    <Caption />
    <Data />
    <ConditionType>5</ConditionType>
  </__data__>
  <__data__>
    <ID>billdatebegin</ID>
    <Caption />
    <Data>2001-02-20</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2021-02-25</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__vip__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__vip__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>SYSTEM</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>4</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺</FieldName>
    <Expression>A.Customer_ID</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>5</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>6</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BegainDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2021-02-25 12:51:21,317
  线程ID: 9
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##6d22020d91b048969a22148287958374]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID