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;
}
