/// <summary>
/// 根据用户名获得用户信息
/// </summary>
/// <param name="loginId">用户名</param>
/// <returns>UserMsg</returns>
public UserMsg GetUeserBaseMsgByLoginId(string loginId)
{
UserMsg um = null;
string sql = "select CC_AutoID,CC_LoginPassword,CC_UserName from T_Seats where CC_LoginId=@uid";
using (SqlDataReader reader=SqlHelper.ExecuteReader(sql, System.Data.CommandType.Text,new SqlParameter("@uid",loginId)))
{
//如果用用户名获得了数据,才把um实例化
if (reader.HasRows)
{
um = new UserMsg();
if (reader.Read())
{
um.AutoId = reader.GetInt32(0);
um.LoginId = loginId;//用传入值赋值
um.Psw = reader.GetString(1);
um.UserName = reader.GetString(2);
}
}
}
return um;
}
/// <summary>
/// 有三种状态:登入成功,密码错误,用户名不存在,故使用枚举单做返回值,如果登入成功返回用户信息
/// </summary>
/// <param name="uid">用户名</param>
/// <param name="psw">密码</param>
/// <param name="usermg">输出参数:用户信息</param>
/// <returns></returns>
public LoginReasult Login2(string uid, string psw, out UserMsg usermg)
{
UserMsg um = dal.GetUeserBaseMsgByLoginId(uid);
usermg = null;
if (um == null)
{
return LoginReasult.UserNameNoExist;
}
else if (um.Psw == CommonHelper.GetMD5FromString(psw))
{
usermg = um;
return LoginReasult.Succeed;
}
else
{
return LoginReasult.PswError;
}
}