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