public ResultModel Get(UserModel user, string accountName) { ResultModel result = new ResultModel(); if (string.IsNullOrEmpty(accountName)) { result.Message = "用户名不能为空"; return result; } List<SqlParameter> paras = new List<SqlParameter>(); SqlParameter para = new SqlParameter("@AccountName", accountName); paras.Add(para); SqlDataReader dr = null; try { string cmdText = "select * from NFMT_User.dbo.Account where AccountName = @AccountName"; dr = SqlHelper.ExecuteReader(SqlHelper.ConnectionStringUser, CommandType.Text, cmdText, paras.ToArray()); Account account = new Account(); if (dr.Read()) { int indexAccId = dr.GetOrdinal("AccId"); account.AccId = Convert.ToInt32(dr[indexAccId]); int indexAccountName = dr.GetOrdinal("AccountName"); if (dr["AccountName"] != DBNull.Value) account.AccountName = Convert.ToString(dr[indexAccountName]); int indexPassWord = dr.GetOrdinal("PassWord"); if (dr["PassWord"] != DBNull.Value) account.PassWord = Convert.ToString(dr[indexPassWord]); int indexAccStatus = dr.GetOrdinal("AccStatus"); if (dr["AccStatus"] != DBNull.Value) account.AccStatus = (Common.StatusEnum)Enum.Parse(typeof(Common.StatusEnum), dr[indexAccStatus].ToString()); int indexEmpId = dr.GetOrdinal("EmpId"); if (dr["EmpId"] != DBNull.Value) account.EmpId = Convert.ToInt32(dr[indexEmpId]); int indexIsValid = dr.GetOrdinal("IsValid"); if (dr["IsValid"] != DBNull.Value) account.IsValid = Convert.ToBoolean(dr[indexIsValid]); int indexCreatorId = dr.GetOrdinal("CreatorId"); if (dr["CreatorId"] != DBNull.Value) account.CreatorId = Convert.ToInt32(dr[indexCreatorId]); int indexCreateTime = dr.GetOrdinal("CreateTime"); if (dr["CreateTime"] != DBNull.Value) account.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) account.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) account.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); result.AffectCount = 1; result.Message = "读取成功"; result.ResultStatus = 0; result.ReturnValue = account; } else { result.Message = "读取失败或无数据"; result.AffectCount = 0; } } catch (Exception ex) { result.Message = ex.Message; } finally { if (dr != null) dr.Dispose(); } return result; }
public override IModel CreateModel(SqlDataReader dr) { Account account = new Account(); int indexAccId = dr.GetOrdinal("AccId"); account.AccId = Convert.ToInt32(dr[indexAccId]); int indexAccountName = dr.GetOrdinal("AccountName"); account.AccountName = Convert.ToString(dr[indexAccountName]); int indexPassWord = dr.GetOrdinal("PassWord"); account.PassWord = Convert.ToString(dr[indexPassWord]); int indexAccStatus = dr.GetOrdinal("AccStatus"); if (dr["AccStatus"] != DBNull.Value) { account.AccStatus = (StatusEnum)Convert.ToInt32(dr[indexAccStatus]); } int indexEmpId = dr.GetOrdinal("EmpId"); account.EmpId = Convert.ToInt32(dr[indexEmpId]); int indexIsValid = dr.GetOrdinal("IsValid"); account.IsValid = Convert.ToBoolean(dr[indexIsValid]); int indexCreatorId = dr.GetOrdinal("CreatorId"); account.CreatorId = Convert.ToInt32(dr[indexCreatorId]); int indexCreateTime = dr.GetOrdinal("CreateTime"); account.CreateTime = Convert.ToDateTime(dr[indexCreateTime]); int indexLastModifyId = dr.GetOrdinal("LastModifyId"); if (dr["LastModifyId"] != DBNull.Value) { account.LastModifyId = Convert.ToInt32(dr[indexLastModifyId]); } int indexLastModifyTime = dr.GetOrdinal("LastModifyTime"); if (dr["LastModifyTime"] != DBNull.Value) { account.LastModifyTime = Convert.ToDateTime(dr[indexLastModifyTime]); } return account; }