1 //-----------------------------------------------------------------------  2 // <copyright file="BaseUserLogonExtendEntity.cs" company="Hairihan">  3 //     Copyright (c) 2015 , All rights reserved.  4 // </copyright>  5 //-----------------------------------------------------------------------  6   7 using System;  8 using System.Collections.Generic;  9 using System.Linq; 10 using System.Data; 11  12 namespace DotNet.Business 13 { 14     using DotNet.Utilities; 15  16     /// <summary> 17     /// BaseUserLogonExtendEntity 18     /// 用户登录的扩展表，账号登录方式，登录提醒方式 19     ///  20     /// 修改纪录 21     ///  22     /// 2015-01-26 版本：1.0 JiRiGaLa 创建文件。 23     ///  24     /// <author> 25     ///     <name>JiRiGaLa</name> 26     ///     <date>2015-01-26</date> 27     /// </author> 28     /// </summary> 29     public partial class BaseUserLogonExtendEntity : BaseEntity 30     { 31         private Decimal id; 32         /// <summary> 33         /// 主键 用户ID 34         /// </summary> 35         public Decimal Id 36         { 37             get 38             { 39                 return id; 40             } 41             set 42             { 43                 id = value; 44             } 45         } 46  47         private Decimal? emailRemind = null; 48         /// <summary> 49         /// 登录邮件提醒 50         /// </summary> 51         public Decimal? EmailRemind 52         { 53             get 54             { 55                 return emailRemind; 56             } 57             set 58             { 59                 emailRemind = value; 60             } 61         } 62  63         private Decimal? qrCodeLogon = null; 64         /// <summary> 65         /// 二维码登录 66         /// </summary> 67         public Decimal? QrCodeLogon 68         { 69             get 70             { 71                 return qrCodeLogon; 72             } 73             set 74             { 75                 qrCodeLogon = value; 76             } 77         } 78  79         private Decimal? jixinRemind = null; 80         /// <summary> 81         /// 登录提醒 82         /// </summary> 83         public Decimal? JixinRemind 84         { 85             get 86             { 87                 return jixinRemind; 88             } 89             set 90             { 91                 jixinRemind = value; 92             } 93         } 94  95         private Decimal? wechatRemind = null; 96         /// <summary> 97         /// 登录微信提醒 98         /// </summary> 99         public Decimal? WechatRemind100         {101             get102             {103                 return wechatRemind;104             }105             set106             {107                 wechatRemind = value;108             }109         }110 111         private Decimal? dynamicCodeLogon = null;112         /// <summary>113         /// 动态码登录114         /// </summary>115         public Decimal? DynamicCodeLogon116         {117             get118             {119                 return dynamicCodeLogon;120             }121             set122             {123                 dynamicCodeLogon = value;124             }125         }126 127         private Decimal? mobileRemind = null;128         /// <summary>129         /// 登录手机短信提醒130         /// </summary>131         public Decimal? MobileRemind132         {133             get134             {135                 return mobileRemind;136             }137             set138             {139                 mobileRemind = value;140             }141         }142 143         private Decimal? usernamePasswordLogon = null;144         /// <summary>145         /// 用户名密码方式登录146         /// </summary>147         public Decimal? UsernamePasswordLogon148         {149             get150             {151                 return usernamePasswordLogon;152             }153             set154             {155                 usernamePasswordLogon = value;156             }157         }158 159         /// <summary>160         /// 从数据行读取161         /// </summary>162         /// <param name="dr">数据行</param>163         protected override BaseEntity GetFrom(IDataRow dr)164         {165             GetFromExpand(dr);166             Id = BaseBusinessLogic.ConvertToDecimal(dr[BaseUserLogonExtendEntity.FieldId]);167             EmailRemind = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldEmailRemind]);168             QrCodeLogon = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldQrCodeLogon]);169             JixinRemind = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldJixinRemind]);170             WechatRemind = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldWechatRemind]);171             DynamicCodeLogon = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldDynamicCodeLogon]);172             MobileRemind = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldMobileRemind]);173             UsernamePasswordLogon = BaseBusinessLogic.ConvertToNullableDecimal(dr[BaseUserLogonExtendEntity.FieldUsernamePasswordLogon]);174             return this;175         }176 177         ///<summary>178         /// 用户登录的扩展表，账号登录方式，登录提醒方式179         ///</summary>180         public static string TableName = "BASE_USER_LOGON_EXTEND";181 182         ///<summary>183         /// 主键 用户ID184         ///</summary>185         public static string FieldId = "Id";186 187         ///<summary>188         /// 登录邮件提醒189         ///</summary>190         public static string FieldEmailRemind = "EMAIL_REMIND";191 192         ///<summary>193         /// 二维码登录194         ///</summary>195         public static string FieldQrCodeLogon = "QR_CODE_LOGON";196 197         ///<summary>198         /// 登录其它提醒199         ///</summary>200         public static string FieldJixinRemind = "JIXIN_REMIND";201 202         ///<summary>203         /// 登录微信提醒204         ///</summary>205         public static string FieldWechatRemind = "WECHAT_REMIND";206 207         ///<summary>208         /// 动态码登录209         ///</summary>210         public static string FieldDynamicCodeLogon = "DYNAMIC_CODE_LOGON";211 212         ///<summary>213         /// 登录手机短信提醒214         ///</summary>215         public static string FieldMobileRemind = "MOBILE_REMIND";216 217         ///<summary>218         /// 用户名密码方式登录219         ///</summary>220         public static string FieldUsernamePasswordLogon = "USERNAME_PASSWORD_LOGON";221     }222 }

  1 --------------------------------------------  2   3 using System;  4 using System.Collections.Generic;  5 using System.Linq;  6 using System.Data;  7   8 namespace DotNet.Business  9 { 10     using DotNet.Business; 11     using DotNet.Utilities; 12  13     /// <summary> 14     /// BaseUserLogonExtendManager 15     /// 用户登录的扩展表，账号登录方式，登录提醒方式 16     ///  17     /// 修改纪录 18     ///  19     /// 2015-01-26 版本：1.0 JiRiGaLa 创建文件。 20     ///  21     /// <author> 22     ///     <name>JiRiGaLa</name> 23     ///     <date>2015-01-26</date> 24     /// </author> 25     /// </summary> 26     public partial class BaseUserLogonExtendManager : BaseManager, IBaseManager 27     { 28         /// <summary> 29         /// 构造函数 30         /// </summary> 31         public BaseUserLogonExtendManager() 32         { 33             if (base.dbHelper == null) 34             { 35                 base.dbHelper = DbHelperFactory.GetHelper(BaseSystemInfo.UserCenterDbType, BaseSystemInfo.UserCenterDbConnection); 36             } 37             if (string.IsNullOrEmpty(base.CurrentTableName)) 38             { 39                 base.CurrentTableName = BaseUserLogonExtendEntity.TableName; 40             } 41             base.PrimaryKey = "Id"; 42         } 43  44         /// <summary> 45         /// 构造函数 46         /// <param name="tableName">指定表名</param> 47         /// </summary> 48         public BaseUserLogonExtendManager(string tableName) 49         { 50             base.CurrentTableName = tableName; 51         } 52  53         /// <summary> 54         /// 构造函数 55         /// </summary> 56         /// <param name="dbHelper">数据库连接</param> 57         public BaseUserLogonExtendManager(IDbHelper dbHelper): this() 58         { 59             DbHelper = dbHelper; 60         } 61  62         /// <summary> 63         /// 构造函数 64         /// </summary> 65         /// <param name="userInfo">用户信息</param> 66         public BaseUserLogonExtendManager(BaseUserInfo userInfo) : this() 67         { 68             UserInfo = userInfo; 69         } 70  71         /// <summary> 72         /// 构造函数 73         /// </summary> 74         /// <param name="userInfo">用户信息</param> 75         /// <param name="tableName">指定表名</param> 76         public BaseUserLogonExtendManager(BaseUserInfo userInfo, string tableName) : this(userInfo) 77         { 78             base.CurrentTableName = tableName; 79         } 80  81         /// <summary> 82         /// 构造函数 83         /// </summary> 84         /// <param name="dbHelper">数据库连接</param> 85         /// <param name="userInfo">用户信息</param> 86         public BaseUserLogonExtendManager(IDbHelper dbHelper, BaseUserInfo userInfo) : this(dbHelper) 87         { 88             UserInfo = userInfo; 89         } 90  91         /// <summary> 92         /// 构造函数 93         /// </summary> 94         /// <param name="dbHelper">数据库连接</param> 95         /// <param name="userInfo">用户信息</param> 96         /// <param name="tableName">指定表名</param> 97         public BaseUserLogonExtendManager(IDbHelper dbHelper, BaseUserInfo userInfo, string tableName) : this(dbHelper, userInfo) 98         { 99             base.CurrentTableName = tableName;100         }101 102         /// <summary>103         /// 添加, 这里可以人工干预，提高程序的性能104         /// </summary>105         /// <param name="entity">实体</param>106         /// <param name="identity">自增量方式，表主键是否采用自增的策略</param>107         /// <param name="returnId">返回主键，不返回程序允许速度会快，主要是为了主细表批量插入数据优化用的</param>108         /// <returns>主键</returns>109         public string Add(BaseUserLogonExtendEntity entity, bool identity = false, bool returnId = false)110         {111             this.Identity = identity;112             this.ReturnId = returnId;113             return this.AddObject(entity);114         }115 116         /// <summary>117         /// 更新118         /// </summary>119         /// <param name="entity">实体</param>120         public int Update(BaseUserLogonExtendEntity entity)121         {122             return this.UpdateObject(entity);123         }124 125         /// <summary>126         /// 获取实体127         /// </summary>128         /// <param name="id">主键</param>129         public BaseUserLogonExtendEntity GetObject(string id)130         {131             return BaseEntity.Create<BaseUserLogonExtendEntity>(this.GetDataTable(new KeyValuePair<string, object>(this.PrimaryKey, id)));132         }133 134         /// <summary>135         /// 添加实体136         /// </summary>137         /// <param name="entity">实体</param>138         public string AddObject(BaseUserLogonExtendEntity entity)139         {140             string key = string.Empty;141             if (entity.Id != null)142             {143                 key = entity.Id.ToString();144             }145             SQLBuilder sqlBuilder = new SQLBuilder(DbHelper, this.Identity, this.ReturnId);146             sqlBuilder.BeginInsert(this.CurrentTableName, this.PrimaryKey);147             if (!this.Identity) 148             {149                 // 这里已经是指定了主键了，所以不需要返回主键了150                 sqlBuilder.ReturnId = false;151                 sqlBuilder.SetValue(this.PrimaryKey, entity.Id);152             }153             else154             {155                 if (!this.ReturnId && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))156                 {157                     if (DbHelper.CurrentDbType == CurrentDbType.Oracle)158                     {159                         sqlBuilder.SetFormula(this.PrimaryKey, "SEQ_" + this.CurrentTableName.ToUpper() + ".NEXTVAL ");160                     }161                     if (DbHelper.CurrentDbType == CurrentDbType.DB2)162                     {163                         sqlBuilder.SetFormula(this.PrimaryKey, "NEXT VALUE FOR SEQ_" + this.CurrentTableName.ToUpper());164                     }165                 }166                 else167                 {168                     if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))169                     {170                         BaseSequenceManager sequenceManager = new BaseSequenceManager(DbHelper);171                         entity.Id = int.Parse(sequenceManager.Increment(this.CurrentTableName));172                         sqlBuilder.SetValue(this.PrimaryKey, entity.Id);173                     }174                 }175             }176             this.SetObject(sqlBuilder, entity);177             if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.SqlServer || DbHelper.CurrentDbType == CurrentDbType.Access))178             {179                 key = sqlBuilder.EndInsert().ToString();180             }181             else182             {183                 sqlBuilder.EndInsert();184             }185             if (this.Identity && (DbHelper.CurrentDbType == CurrentDbType.Oracle || DbHelper.CurrentDbType == CurrentDbType.DB2))186             {187                 return entity.Id.ToString();188             }189             return key;190         }191 192         /// <summary>193         /// 更新实体194         /// </summary>195         /// <param name="entity">实体</param>196         public int UpdateObject(BaseUserLogonExtendEntity entity)197         {198             SQLBuilder sqlBuilder = new SQLBuilder(DbHelper);199             sqlBuilder.BeginUpdate(this.CurrentTableName);200             this.SetObject(sqlBuilder, entity);201             sqlBuilder.SetWhere(this.PrimaryKey, entity.Id);202             return sqlBuilder.EndUpdate();203         }204 205         // 这个是声明扩展方法206         partial void SetObjectExpand(SQLBuilder sqlBuilder, BaseUserLogonExtendEntity entity);207         208         /// <summary>209         /// 设置实体210         /// </summary>211         /// <param name="entity">实体</param>212         private void SetObject(SQLBuilder sqlBuilder, BaseUserLogonExtendEntity entity)213         {214             SetObjectExpand(sqlBuilder, entity);215             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldEmailRemind, entity.EmailRemind);216             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldQrCodeLogon, entity.QrCodeLogon);217             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldJixinRemind, entity.JixinRemind);218             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldWechatRemind, entity.WechatRemind);219             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldDynamicCodeLogon, entity.DynamicCodeLogon);220             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldMobileRemind, entity.MobileRemind);221             sqlBuilder.SetValue(BaseUserLogonExtendEntity.FieldUsernamePasswordLogon, entity.UsernamePasswordLogon);222         }223 224         /// <summary>225         /// 删除实体226         /// </summary>227         /// <param name="id">主键</param>228         /// <returns>影响行数</returns>229         public int Delete(string id)230         {231             return this.Delete(new KeyValuePair<string, object>(this.PrimaryKey, id));232         }233     }234 }