/// <summary>
/// 注册用户
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuRegiste_Click(object sender, EventArgs e)
{
UserRegistForm frmReg = new UserRegistForm();
if (frmReg.ShowDialog() == DialogResult.OK)
{
if (frmReg.Password != frmReg.OkPassword)
{
ShowWarningMessageBox("密码填写错误");
frmReg.Password = "";
frmReg.OkPassword = "";
return;
}
else if (frmReg.UserName == "")
{
ShowWarningMessageBox("用户名不能为空");
}
else
{
string strMi = Encryption_Decryption.MingToMi(frmReg.OkPassword);
string userName = frmReg.UserName;
//经用户添加到数据库中
if (AddUserToDB(userName, strMi))
{
MessageBox.Show("注册用户成功", "恭喜");
//为新用户赋予相应权限
HavePermission();
}
}
}
}
//加密操作 utf-8码
public static String MingToMi(string strMing)
{
byte[] byteArrMi = Encryption_Decryption.EncryptString(
Encoding.UTF8.GetBytes(strMing));
string strMi = Encoding.UTF8.GetString(byteArrMi);
return(strMi);
}
/// <summary>
/// 登录
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void menuLogin_Click(object sender, EventArgs e)
{
LoginForm frmLogin = new LoginForm();
if (frmLogin.ShowDialog() == DialogResult.OK)
{
string userName = frmLogin.UserName;
string password = frmLogin.PassWord;
string MiPwd = Encryption_Decryption.MingToMi(password);
string sql = string.Format("select count(*) from [tb_User] where name='{0}'and pwd='{1}'",
userName, MiPwd);
SqlConnection connection = ConnDataBase.connection;
try
{
connection.Open();
SqlCommand command = new SqlCommand(sql, connection);
//执行查询语句，发挥匹配的行数
int num = (int)command.ExecuteScalar();
if (num > 0)
{
frmLogin.Close();
//获得相应权限
HavePermission();
//保存到当前用户
CurUser = userName;
if (!frmLogin.DicNameCode.ContainsKey(frmLogin.UserName) &&
frmLogin.CkRememberNameCode.Checked == true)
{
frmLogin.WriteNameCodeToXml(frmLogin.UserName, frmLogin.PassWord);
}
MessageBox.Show("恭喜您，成功登录", "信息提示",
MessageBoxButtons.OKCancel,
MessageBoxIcon.Information);
}
else
{
frmLogin.PassWord = "";
MessageBox.Show("您输入的用户名或密码错误！", "登录失败",
MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message, "操作数据库出错", MessageBoxButtons.OK,
MessageBoxIcon.Information);
}
finally
{
connection.Close();
}
}
}
