时间: 2021-05-24 13:37:41,141
  线程ID: 11
日志级别: 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-04-24</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2021-05-24</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>5</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>6</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BegainDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>41</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>移动电话</FieldName>
    <Expression>A.MobileTel</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>21</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>加密卡号</FieldName>
    <Expression>A.EncryptVIP</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>
</NewDataSet>

    时间: 2021-05-24 13:37:41,165
  线程ID: 11
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##2465994a9981428f8f04c776ba08b43e]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2021-05-24 13:37:54,623
  线程ID: 10
日志级别: 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-04-24</Data>
    <ConditionType>0</ConditionType>
  </__data__>
  <__data__>
    <ID>billdateend</ID>
    <Caption />
    <Data>2021-05-24</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>5</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡店铺简称</FieldName>
    <Expression>CT.Abbrev</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>1</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>6</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>发卡日期</FieldName>
    <Expression>CONVERT(VARCHAR(10), A.BegainDate, 120)</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>2</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>2</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP卡号</FieldName>
    <Expression>A.VIP</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>3</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>3</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>VIP姓名</FieldName>
    <Expression>A.Name</Expression>
    <IsGroup>true</IsGroup>
    <OrderIndex>4</OrderIndex>
  </OutputData>
  <OutputData>
    <ID>41</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>移动电话</FieldName>
    <Expression>A.MobileTel</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>21</ID>
    <ParentID>1</ParentID>
    <FieldID />
    <FieldName>加密卡号</FieldName>
    <Expression>A.EncryptVIP</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>
</NewDataSet>

    时间: 2021-05-24 13:37:54,627
  线程ID: 10
日志级别: INFO 
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT BuisnessManID, Name
INTO [##1c09430a2b3c468689fb58dccf62ba02]
FROM (
 SELECT BuisnessManID, Name
FROM BuisnessMan A
WHERE 1 = 1


 ) A
ORDER BY BuisnessManID


    时间: 2021-05-24 13:40:12,796
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##4a40a76fff2148f3bc4df0a5e82b1520 ADD 销售类型 VARCHAR(50)

    时间: 2021-05-24 13:40:12,804
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##4a40a76fff2148f3bc4df0a5e82b1520 a  INNER JOIN DictSaleType b ON a.SaleTypeID=b.ID


    时间: 2021-05-24 13:40:12,832
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4a40a76fff2148f3bc4df0a5e82b1520 SET 销售类型='线上发货' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '')
AND RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND Status <> '退货'


    时间: 2021-05-24 13:40:12,846
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET a.销售类型=b.SaleType
FROM ##4a40a76fff2148f3bc4df0a5e82b1520 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.预售零售订单号 = 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-05-24 13:40:12,903
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4a40a76fff2148f3bc4df0a5e82b1520 SET 销售类型='线上发货'   WHERE RetailOrderID IS NOT NULL AND RetailOrderID <> ''
AND (预售零售订单号 IS NULL OR 预售零售订单号 = '') 
AND Status = '退货'


    时间: 2021-05-24 13:40:12,907
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE ##4a40a76fff2148f3bc4df0a5e82b1520 SET 销售类型='正常销售' WHERE (销售类型='正常' OR 销售类型 IS NULL OR 销售类型 = '') AND ISNULL(CheckID,'') <> ''


    时间: 2021-05-24 13:40:12,931
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: ALTER TABLE ##4a40a76fff2148f3bc4df0a5e82b1520 ADD NewCheckID VARCHAR(50)

    时间: 2021-05-24 13:40:12,932
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE A SET A.NewCheckID = A.CheckID 
     FROM [##4a40a76fff2148f3bc4df0a5e82b1520] A
     INNER JOIN ( SELECT C.CheckID, SUM(C.Quantity) Quantity FROM [##4a40a76fff2148f3bc4df0a5e82b1520] C GROUP BY C.CheckID ) B
         ON A.CheckID = B.CheckID
     WHERE (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) >= 2 OR (CASE WHEN A.Status = '赠送' THEN 0 ELSE B.Quantity END) <= -2


    时间: 2021-05-24 13:40:12,963
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: SELECT A.CheckID
     , CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='退货' THEN A.Status END)=1 AND COUNT(DISTINCT A.Status)=1 
                 THEN - COUNT(DISTINCT A.CHECKID) 
            WHEN COUNT(DISTINCT CASE WHEN A.Status='赠送' THEN A.Status END)=1  AND COUNT(DISTINCT A.Status)=1 
                 THEN 0 
             ELSE 
                 CASE WHEN COUNT(DISTINCT CASE WHEN A.Status='销售' THEN A.Status END)=1  AND COUNT(DISTINCT A.Status)=1 
                         THEN COUNT(DISTINCT A.CHECKID) 
                     ELSE 
                         CASE WHEN SUM(A.Quantity)>0 
                                 THEN COUNT(DISTINCT A.CHECKID) 
                             ELSE 0 
                         END
                 END 
     END CheckCount
     , CAST(0 AS INT) IsMultiCheck 
INTO ##f45155b1ae3740228fd545b95c5ad82d
FROM ##4a40a76fff2148f3bc4df0a5e82b1520 A
GROUP BY A.CheckID


    时间: 2021-05-24 13:40:13,030
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: UPDATE a SET IsMultiCheck = 1 
   FROM ##f45155b1ae3740228fd545b95c5ad82d a 
   WHERE (SELECT Count(NewCheckID) FROM ##4a40a76fff2148f3bc4df0a5e82b1520 WHERE a.CheckID = NewCheckID) > 1 


    时间: 2021-05-24 13:40:13,178
  线程ID: 13
日志级别: DEBUG
对象名称: Regentsoft.Core.LoggingService
日志信息: P_DropTable ##4a40a76fff2148f3bc4df0a5e82b1520