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