时间: 2021-08-25 11:33:06,273
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##bb4f97ad6a8e4f9ea2293644071d5849 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-25 11:33:06,336
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bb4f97ad6a8e4f9ea2293644071d5849 SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-08-25 11:33:06,354
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##bb4f97ad6a8e4f9ea2293644071d5849 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.Pre_RetailOrderID = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-08-25 11:33:06,394
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bb4f97ad6a8e4f9ea2293644071d5849 SET SaleType='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') 
AND Status = '退货'


    时间: 2021-08-25 11:33:06,396
  线程ID: 48
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##bb4f97ad6a8e4f9ea2293644071d5849 SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-08-25 11:34:36,295
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##84b59ef7800448788ea1ebd2ae82b13d a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-25 11:34:36,303
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##84b59ef7800448788ea1ebd2ae82b13d SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-08-25 11:34:36,309
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##84b59ef7800448788ea1ebd2ae82b13d a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.Pre_RetailOrderID = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-08-25 11:34:36,345
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##84b59ef7800448788ea1ebd2ae82b13d SET SaleType='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') 
AND Status = '退货'


    时间: 2021-08-25 11:34:36,348
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##84b59ef7800448788ea1ebd2ae82b13d SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-08-25 11:36:22,030
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##89c5a23fb706434c83cb9fea7d3b65e3 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-25 11:36:22,037
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##89c5a23fb706434c83cb9fea7d3b65e3 SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-08-25 11:36:22,059
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##89c5a23fb706434c83cb9fea7d3b65e3 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.Pre_RetailOrderID = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-08-25 11:36:22,095
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##89c5a23fb706434c83cb9fea7d3b65e3 SET SaleType='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') 
AND Status = '退货'


    时间: 2021-08-25 11:36:22,097
  线程ID: 51
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##89c5a23fb706434c83cb9fea7d3b65e3 SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-08-25 12:04:29,790
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##deb7774723fe4643b3ad76457a9545ff a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-25 12:04:29,799
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##deb7774723fe4643b3ad76457a9545ff SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-08-25 12:04:29,805
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##deb7774723fe4643b3ad76457a9545ff a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.Pre_RetailOrderID = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-08-25 12:04:29,842
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##deb7774723fe4643b3ad76457a9545ff SET SaleType='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') 
AND Status = '退货'


    时间: 2021-08-25 12:04:29,845
  线程ID: 37
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##deb7774723fe4643b3ad76457a9545ff SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-08-25 12:05:56,471
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##994eb9be32554a2182f8814444104b53 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-08-25 12:05:56,479
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##994eb9be32554a2182f8814444104b53 SET SaleType='线上发货' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-08-25 12:05:56,484
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.SaleType=b.SaleType
FROM ##994eb9be32554a2182f8814444104b53 a  INNER JOIN vn_Check SC ON a.PaymentWay1 = SC.CheckID 
 INNER JOIN vn_CheckGoods SCG ON SC.CheckID = SCG.CheckID AND A.Goods_No = SCG.Goods_No AND A.Pre_RetailOrderID = SCG.RetailOrderID AND A.DiscountPrice = SCG.DiscountPrice AND A.CostPrice = SCG.CostPrice
 INNER JOIN KS2_RetailOrder KSR ON SCG.RetailOrderID = KSR.RetailOrderID 
 INNER JOIN DictSaleType b ON KSR.SaleTypeID=b.ID
 WHERE  a.Status = '退货' 


    时间: 2021-08-25 12:05:56,521
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##994eb9be32554a2182f8814444104b53 SET SaleType='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (Pre_RetailOrderID IS NULL OR Pre_RetailOrderID = '') 
AND Status = '退货'


    时间: 2021-08-25 12:05:56,523
  线程ID: 24
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##994eb9be32554a2182f8814444104b53 SET SaleType='正常销售' WHERE (SaleType='正常' OR SaleType IS NULL OR SaleType = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-08-25 12:12:29,306
  线程ID: 32
日志级别: 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>2021-07-25</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2021-08-25</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__vip__>
    <ID>userno</ID>
    <Caption />
    <Data>888</Data>
    <ConditionType>0</ConditionType>
  </__vip__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>888</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>888</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</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>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>9</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>性别</FieldName>
    <Expression>A.Sex</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>10</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>出生日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BirthDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>11</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>身高</FieldName>
    <Expression>A.[Height]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>7</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>12</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>体重</FieldName>
    <Expression>A.[Weight]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>8</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>13</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>国籍</FieldName>
    <Expression>A.[Nationality]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>9</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>14</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>爱好</FieldName>
    <Expression>A.[Hobby]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>10</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>15</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>鞋码</FieldName>
    <Expression>A.ShoeSize</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>11</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>16</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>电话</FieldName>
    <Expression>A.Tel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>12</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>17</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>电子邮件</FieldName>
    <Expression>A.Email</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>13</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>18</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>地址</FieldName>
    <Expression>A.[Address]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>14</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>20</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>收入水平</FieldName>
    <Expression>A.Earning</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>15</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>22</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>推荐人卡号</FieldName>
    <Expression>A.RecomCardNo</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>16</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>23</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>推荐人姓名</FieldName>
    <Expression>B.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>17</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>43</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级折扣</FieldName>
    <Expression>C.Discount</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>18</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>42</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级</FieldName>
    <Expression>A.Vipgrade</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>19</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>41</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>移动电话</FieldName>
    <Expression>A.MobileTel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>20</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>39</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>所在城市</FieldName>
    <Expression>A.InCity</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>21</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>38</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>城市</FieldName>
    <Expression>A.City</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>22</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>36</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>预存款</FieldName>
    <Expression>A.Imprest</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>23</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>35</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>资料</FieldName>
    <Expression>A.Information</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>24</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>34</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>状态</FieldName>
    <Expression>A.Status</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>25</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>33</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>使用状态</FieldName>
    <Expression>A.UseStatus</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>26</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>32</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡人</FieldName>
    <Expression>A.PayCardUser</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>27</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>29</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>历史积分</FieldName>
    <Expression>A.HisIntegral</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>28</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>27</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>腰围</FieldName>
    <Expression>A.WaistLine</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>29</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>26</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>类别</FieldName>
    <Expression>A.LeiBie</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>30</OrderIndex>
  </OutputData>
</NewDataSet>

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


 ) A
ORDER BY BuisnessManID


    时间: 2021-08-25 12:12:58,445
  线程ID: 13
日志级别: 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>2019-11-01</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2021-08-25</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__vip__>
    <ID>userno</ID>
    <Caption />
    <Data>888</Data>
    <ConditionType>0</ConditionType>
  </__vip__>
  <__customer__>
    <ID>userno</ID>
    <Caption />
    <Data>888</Data>
    <ConditionType>0</ConditionType>
  </__customer__>
  <__businessman__>
    <ID>userno</ID>
    <Caption />
    <Data>888</Data>
    <ConditionType>0</ConditionType>
  </__businessman__>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</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>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>9</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>性别</FieldName>
    <Expression>A.Sex</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>5</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>10</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>出生日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BirthDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>6</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>11</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>身高</FieldName>
    <Expression>A.[Height]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>7</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>12</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>体重</FieldName>
    <Expression>A.[Weight]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>8</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>13</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>国籍</FieldName>
    <Expression>A.[Nationality]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>9</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>14</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>爱好</FieldName>
    <Expression>A.[Hobby]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>10</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>15</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>鞋码</FieldName>
    <Expression>A.ShoeSize</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>11</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>16</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>电话</FieldName>
    <Expression>A.Tel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>12</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>17</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>电子邮件</FieldName>
    <Expression>A.Email</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>13</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>18</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>地址</FieldName>
    <Expression>A.[Address]</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>14</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>20</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>收入水平</FieldName>
    <Expression>A.Earning</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>15</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>22</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>推荐人卡号</FieldName>
    <Expression>A.RecomCardNo</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>16</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>23</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>推荐人姓名</FieldName>
    <Expression>B.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>17</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>43</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级折扣</FieldName>
    <Expression>C.Discount</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>18</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>42</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP等级</FieldName>
    <Expression>A.Vipgrade</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>19</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>41</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>移动电话</FieldName>
    <Expression>A.MobileTel</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>20</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>39</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>所在城市</FieldName>
    <Expression>A.InCity</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>21</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>38</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>城市</FieldName>
    <Expression>A.City</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>22</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>36</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>预存款</FieldName>
    <Expression>A.Imprest</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>23</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>35</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>资料</FieldName>
    <Expression>A.Information</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>24</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>34</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>状态</FieldName>
    <Expression>A.Status</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>25</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>33</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>使用状态</FieldName>
    <Expression>A.UseStatus</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>26</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>32</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡人</FieldName>
    <Expression>A.PayCardUser</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>27</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>29</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>历史积分</FieldName>
    <Expression>A.HisIntegral</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>28</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>27</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>腰围</FieldName>
    <Expression>A.WaistLine</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>29</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>26</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>类别</FieldName>
    <Expression>A.LeiBie</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>30</OrderIndex>
  </OutputData>
</NewDataSet>

    时间: 2021-08-25 12:12:58,449
  线程ID: 13
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##902a3ab2f2be43c69d3d1322ff97cdbc]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID