string CheckVaile(string Userlogin, string UserPWD)
{
string MSG = "";
if (Userlogin == "" || UserPWD == "")
{
MSG = "请输入正确的用户名和密码！";
}
H_UserEntity users = new H_UserEntity();
users.UserLoginName = Userlogin;
users.UserPWD = UserPWD;
// var users = DataConvert<H_UserEntity>.ToList(dt);
if (!db.IsVaileLogin(users))
{
MSG = "用户名密码错误！！！";
}
return(MSG);
}
// string strCon = StrCon();
//AccessHelper.conn_str;
/// <summary>
/// 登录是否有效
/// </summary>
/// <param name="ue"></param>
/// <returns></returns>
public bool IsVaileLogin(H_UserEntity ue)
{
bool result = true;
try
{
string SqlStr = "SELECT * FROM H_User where UserLoginName=@ul and UserPWD=@pwd";
OleDbParameter[] prams =
{
new OleDbParameter("@ul", ue.UserLoginName),
new OleDbParameter("@pwd", ue.UserPWD)
};
DataSet ds = AccessHelper.ExecuteDataSet(strCon(), SqlStr, prams);
if (ds == null)
{
result = false;
}
else if (ds.Tables[0].Rows.Count == 0)
{
result = false;
}
else
{
result = true;
}
UserPublicClass.LoginValue = ue.UserLoginName;
UserPublicClass.NameValue = ds.Tables[0].Rows[0]["UserName"].ToString();
UserPublicClass.PWDValue = ds.Tables[0].Rows[0]["UserPWD"].ToString();
}
catch (Exception ex)
{
log.wrirteLog("数据库操作", "登录是否有效", ex.Message);
result = false;
}
return(result);
}
