private void SetVisible()
{
string[] roles = UserManagementAdmin.GetRoles(admin.Roles);
if (roles.Contains("读者信息管理员"))
{
userManagementSystemButton.Visible = true;
}
if (roles.Contains("流通管理员"))
{
circulationSystemButton.Visible = true;
}
if (roles.Contains("编目员"))
{
catalogSystemBtn.Visible = true;
}
if (roles.Contains("采访员"))
{
interviewSystemButton.Visible = true;
}
if (roles.Contains("系统维护员"))
{
maintainaceSystemButton.Visible = true;
}
if (roles.Contains("统计员"))
{
statisticalSystemButton.Visible = true;
}
if (roles.Contains("期刊管理员"))
{
periodicalSystemButton.Visible = true;
}
}
/// <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("登录失败");
}
}
/// <summary>
/// 管理员登陆
/// 格式错误 415
/// </summary>
/// <param name="login">登录信息</param>
/// <returns>状态码</returns>
public int adminLogin(UserManagementLogin login, out UserManagementAdmin admin, ref List <string> errorMsg)
{
int result = 415;
try
{
if (!UserManagementLogin.isNull(login)) //是否有空项
{
if (UserManagementLogin.isNormative(login, ref errorMsg)) //是否符合规范
{
return(userManagementDal.adminLogin(login, out admin));
}
}
}
catch (Exception e)
{
Console.WriteLine(e.Message);
throw e;
}
admin = null;
return(result);
}
public AdminForm(Form form, UserManagementAdmin user)
{
InitializeComponent();
parentForm = form;
admin = user;
}
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);
}
