private int CheckUserExist(string userName, string passWord) { int loadIdent = 0; DataTable dtUser = new DataTable(); dtUser = ClsSQLMethod.SearchUser(); foreach (DataRow row in dtUser.Rows) { if (row[1].ToString() == userName) { if (row[2].ToString() == passWord) { loadIdent = 1; FillCUserInfo(row); break; } else { loadIdent = 2; break; } } } return(loadIdent); }
public string Login(string sqlIP, int sqlPort, string userName, string passWord) { try { sqlMethod = new ClsSQLMethod(); string info = string.Empty; if (sqlMethod.Connection(sqlIP, sqlPort)) { //lblConnection.Text = "与数据库成功建立连接!"; } else { info = "与数据库连接失败!"; } switch (CheckUserExist(userName, passWord)) { case 1: info = "登陆成功"; break; case 2: info = "密码不正确!"; return(info); case 0: info = "用户名不存在!"; return(info); default: return(info); } return(info); } catch (Exception EX) { throw new Exception(EX.Message); } }