/// <summary> /// 带事务的Update /// </summary> /// <param name="entity"></param> /// <param name="trans">The trans.</param> /// <returns></returns> /// <remarks>2016/6/17 10:29:28</remarks> public bool Update(NbUserEntity entity, DbTransaction trans = null) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("dbo.P_NbUser_Update"); database.AddInParameter(commandWrapper, "@Account", DbType.AnsiString, entity.Account); database.AddInParameter(commandWrapper, "@Source", DbType.String, entity.Source); database.AddInParameter(commandWrapper, "@LastLoginTime", DbType.DateTime, entity.LastLoginTime); database.AddInParameter(commandWrapper, "@LastLoginIp", DbType.AnsiString, entity.LastLoginIp); database.AddInParameter(commandWrapper, "@LastLoginDate", DbType.DateTime, entity.LastLoginDate); database.AddInParameter(commandWrapper, "@ContinuingLoginDay", DbType.Int32, entity.ContinuingLoginDay); database.AddInParameter(commandWrapper, "@RegisterIp", DbType.AnsiString, entity.RegisterIp); database.AddInParameter(commandWrapper, "@RegisterDate", DbType.DateTime, entity.RegisterDate); database.AddInParameter(commandWrapper, "@Status", DbType.Int32, entity.Status); database.AddInParameter(commandWrapper, "@RowTime", DbType.DateTime, entity.RowTime); int results = 0; if (trans != null) { results = database.ExecuteNonQuery(commandWrapper, trans); } else { results = database.ExecuteNonQuery(commandWrapper); } return(Convert.ToBoolean(results)); }
/// <summary> /// 将IDataReader的当前记录读取到NbUserEntity 对象 /// </summary> /// <param name="reader"></param> /// <returns></returns> public NbUserEntity LoadSingleRow(IDataReader reader) { var obj = new NbUserEntity(); obj.Account = (System.String)reader["Account"]; obj.Source = (System.String)reader["Source"]; obj.LastLoginTime = (System.DateTime)reader["LastLoginTime"]; obj.LastLoginIp = (System.String)reader["LastLoginIp"]; obj.LastLoginDate = (System.DateTime)reader["LastLoginDate"]; obj.ContinuingLoginDay = (System.Int32)reader["ContinuingLoginDay"]; obj.RegisterIp = (System.String)reader["RegisterIp"]; obj.RegisterDate = (System.DateTime)reader["RegisterDate"]; obj.Status = (System.Int32)reader["Status"]; obj.RowTime = (System.DateTime)reader["RowTime"]; return(obj); }
/// <summary> /// GetById /// </summary> /// <param name="account">account</param> /// <returns>NbUserEntity</returns> /// <remarks>2016/6/17 10:29:27</remarks> public NbUserEntity GetById(System.String account) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("P_NbUser_GetById"); database.AddInParameter(commandWrapper, "@Account", DbType.AnsiString, account); NbUserEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
/// <summary> /// GetByAccount /// </summary> /// <param name="account">account</param> /// <param name="userIp">userIp</param> /// <param name="yesterday">yesterday</param> /// <param name="today">today</param> /// <param name="status">status</param> /// <returns>NbUserEntity</returns> /// <remarks>2016/6/17 10:29:27</remarks> public NbUserEntity GetByAccount(System.String account, System.String userIp, System.DateTime yesterday, System.DateTime today, System.Int32 status) { var database = new SqlDatabase(this.ConnectionString); DbCommand commandWrapper = database.GetStoredProcCommand("C_User_GetByAccount"); database.AddInParameter(commandWrapper, "@Account", DbType.AnsiString, account); database.AddInParameter(commandWrapper, "@UserIp", DbType.AnsiString, userIp); database.AddInParameter(commandWrapper, "@Yesterday", DbType.DateTime, yesterday); database.AddInParameter(commandWrapper, "@Today", DbType.DateTime, today); database.AddInParameter(commandWrapper, "@Status", DbType.Int32, status); NbUserEntity obj = null; using (IDataReader reader = database.ExecuteReader(commandWrapper)) { if (reader.Read()) { obj = LoadSingleRow(reader); } } return(obj); }
public static bool Update(NbUserEntity nbUserEntity, DbTransaction trans = null, string zoneId = "") { var provider = new NbUserProvider(zoneId); return(provider.Update(nbUserEntity, trans)); }