/// <summary> /// 登录 /// </summary> private void Login() { List <string> errorList = new List <string>(); UserManagementLogin login = GetAllLoginInformation(); UserManagementAdmin admin = new UserManagementAdmin(); int responseCode = userManagementBll.adminLogin(login, out admin, ref errorList); if (responseCode == 200 && admin != null) { MessageBox.Show("登陆成功"); var form = new AdminForm(this, admin); form.Show(); Hide(); } else if (responseCode == 401) { MessageBox.Show("密码不正确,请重新输入"); } else if (responseCode == 403) { MessageBox.Show("权限不足,禁止登陆"); } else if (responseCode == 415) { MessageBox.Show("输入格式有误,请重新输入"); } else { MessageBox.Show("登录失败"); } }
private void btn_addCase_Click(object sender, EventArgs e) { try { List <string> errorList = new List <string>();//创建一个错误列表 //获取根据当前页面内容生成的订单(若有错误会被添加到错误列表中) var list = new UserManagementLogin[] { GetAllLoginInformation() }; if (errorList.Count == 0) { if (userCaseHandle.AddUserCases(list.ToList())) { MessageBox.Show("添加成功"); } } else { MessageBox.Show("添加失败"); foreach (var i in errorList) { MessageBox.Show(i);//逐条显示错误信息 } } } catch (Exception ex) { MessageBox.Show(ex.Message); } DataBind(); }
/// <summary> /// 获取登录页面用户输入的信息 /// </summary> /// <returns>登录信息</returns> private UserManagementLogin GetAllLoginInformation() { UserManagementLogin login = new UserManagementLogin() { UserNumber = txb_Login.Text, Password = txb_Password.Text }; return(login); }
/// <summary> /// 管理员登陆 /// 登陆成功 200 /// 密码不正确 401 /// 权限不足 403 /// 未知错误 420 /// </summary> /// <param name="login"></param> /// <returns>状态码</returns> public int adminLogin(UserManagementLogin login) { int result; SQLHelper helper = new SQLHelper(); string pwd = helper.GetMD5(login.Password); string role = "Administrator"; string sql = " SELECT " + " tb_Login.`Password`, " + " tb_BasicInformation.UserNumber, " + " tb_User.Role " + " FROM " + " tb_User " + " INNER JOIN tb_BasicInformation ON tb_User.Id = tb_BasicInformation.UserId " + " INNER JOIN tb_Login ON tb_BasicInformation.UserId = tb_Login.UserId " + "WHERE " + "tb_User.Role = @role " + "AND " + "tb_BasicInformation.UserNumber = @userNumber "; MySqlParameter[] adminPara = new MySqlParameter[] { new MySqlParameter("@userNumber", login.UserNumber), new MySqlParameter("@role", role) }; DataTable dt = helper.ExecuteQuery(sql, adminPara, CommandType.Text); if (dt.Rows.Count == 1) { if ((string)dt.Rows[0]["Password"] == pwd) { result = 200; } else { result = 401; } } else if (dt.Rows.Count == 0) { result = 403; } else { result = 420; } return(result); }
/// <summary> /// 管理员登陆 /// 格式错误 415 /// </summary> /// <param name="login">登录信息</param> /// <returns>状态码</returns> public int adminLogin(UserManagementLogin login, ref List <string> errorMsg) { int result = 415; try { if (!UserManagementLogin.isNull(login)) //是否有空项 { if (UserManagementLogin.isNormative(login, ref errorMsg)) //是否符合规范 { result = userManagementDal.adminLogin(login); } } } catch (Exception e) { Console.WriteLine(e.Message); throw e; } return(result); }
public int adminLogin(UserManagementLogin login, out UserManagementAdmin admin) { int result; SQLHelper helper = new SQLHelper(); string pwd = helper.GetMD5(login.Password); string sql = " SELECT " + " tb_BasicInformation.UserId AS `编号`, " + " tb_Login.`Password` AS `密码`, " + " tb_BasicInformation.UserName AS `名称`, " + " tb_BasicInformation.UserNumber AS `账号`, " + " GROUP_CONCAT( tb_AdminInformation.AdminRole SEPARATOR '|') AS `角色` " + " FROM " + " tb_AdminInformation " + " INNER JOIN " + " tb_BasicInformation " + " ON " + " tb_AdminInformation.UserId = tb_BasicInformation.UserId " + " INNER JOIN " + " tb_Login " + " ON " + " tb_BasicInformation.UserId = tb_Login.UserId " + " WHERE " + " tb_BasicInformation.UserNumber =@userNumber AND " + " tb_Login.`Password` = @password " + " GROUP BY " + " tb_BasicInformation.UserId,tb_Login.`Password` ;"; MySqlParameter[] adminPara = new MySqlParameter[] { new MySqlParameter("@userNumber", login.UserNumber), new MySqlParameter("@password", pwd) }; DataTable dt = helper.ExecuteQuery(sql, adminPara, CommandType.Text); if (dt.Rows.Count == 1) { if ((string)dt.Rows[0]["密码"] == pwd) { result = 200; admin = new UserManagementAdmin() { Id = (int)dt.Rows[0]["编号"], Name = dt.Rows[0]["名称"].ToString(), Number = dt.Rows[0]["账号"].ToString(), Roles = dt.Rows[0]["角色"].ToString(), }; return(result); } else { result = 401; } } else if (dt.Rows.Count == 0) { result = 403; } else { result = 420; } admin = null; return(result); }