private void btnOK_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtUserName.Text.Trim()))
{
MessageBox.Show("用户名不能为空！");
return;
}
if (string.IsNullOrEmpty(this.txtPwd.Text.Trim()))
{
MessageBox.Show("密码不能为空！");
return;
}
//判断此管理员名是否已存在
string sql = "select Admin_Name from AdminInfo where Admin_Name=@0";
SqlDataReader sdr = DataBaseHelper.ExecReader(sql, this.txtUserName.Text.Trim());
if (sdr.Read())
{
MessageBox.Show("此用户名已存在！");
return;
}
sdr.Close();
//添加管理员
if (this.txtPwd.Text.Trim() != this.txtRePwd.Text.Trim())
{
MessageBox.Show("两次密码输入不一致！");
return;
}
string sql1 = "insert into AdminInfo (Admin_Name,Admin_Password,Admin_Level, Admin_Rember , Admin_AutoLogin) values(@0,@1,@2,@3,@4)";
int i = DataBaseHelper.ExecNoneQuery(sql1, this.txtUserName.Text.Trim(), this.txtPwd.Text.Trim(), this.cbbLevel.SelectedIndex, checkBox1.Checked ? "1" : "0", checkBox2.Checked ? "1" : "0");
if (i == 1)
{
MessageBox.Show("添加用户成功！");
}
else
{
MessageBox.Show("添加用户失败！");
}
this.txtUserName.Text = "";
this.txtPwd.Text = "";
this.txtRePwd.Text = "";
this.cbbLevel.SelectedIndex = 0;
}
private void btnOK_Click(object sender, EventArgs e)
{
if (this.cmbUserName.Text.Trim() == "")
{
MessageBox.Show("请先输入用户名!");
return;
}
else if (this.txtUserPwd.Text.Trim() == "")
{
MessageBox.Show("请先输入用户密码!");
return;
}
else
{
MainForm mf = (MainForm)this.Owner;
string sql = "select Admin_ID, Admin_Level from AdminInfo where Admin_Name=@0 and Admin_Password=@1";
SqlDataReader sdr = DataBaseHelper.ExecReader(sql, this.cmbUserName.Text, this.txtUserPwd.Text);
if (sdr.Read())
{
string level = sdr["Admin_Level"].ToString(); //获取用户权限
mf.adminID = (int)sdr["Admin_id"]; //存储用户编号
sdr.Close();
if (level == "1")
{
this.DialogResult = DialogResult.Yes;
}
else
{
this.DialogResult = DialogResult.No;
}
string updatesql = "update AdminInfo set Admin_Rember=@0,Admin_AutoLogin=@1 where Admin_ID=@2 ";
int r = DataBaseHelper.ExecNoneQuery(updatesql, checkBox1.Checked ? "1" : "0", checkBox2.Checked ? "1" : "0", cmbUserName.SelectedValue);
islogin = true;
this.Close();
}
else
{
sdr.Close();
MessageBox.Show("用户名或密码有误！", "错误");
return;
}
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(this.txtName.Text.Trim()))
{
MessageBox.Show("用户名不能为空！");
return;
}
if (string.IsNullOrEmpty(this.txtPassword.Text.Trim()))
{
MessageBox.Show("密码不能为空！");
return;
}
//判断此管理员名是否已存在
if (txtName.Enabled)
{
string sql = "select Admin_Name from AdminInfo where Admin_Name=@0";
SqlDataReader sdr = DataBaseHelper.ExecReader(sql, this.txtName.Text.Trim());
if (sdr.Read())
{
MessageBox.Show("此用户名已存在！");
return;
}
sdr.Close();
}
//保存更改
if (this.txtPassword.Text.Trim() != this.txtPassword2.Text.Trim())
{
MessageBox.Show("两次密码输入不一致！");
return;
}
string sql1 = "update AdminInfo set Admin_Name=@0,Admin_Password=@1,Admin_Level=@2, Admin_Rember=@3 , Admin_AutoLogin=@4 where Admin_ID=@5";
int i = DataBaseHelper.ExecNoneQuery(sql1, this.txtName.Text.Trim(), this.txtPassword.Text.Trim(), this.cmbLevel.SelectedIndex, cBremeber.Checked ? "1" : "0", cBauto.Checked ? "1" : "0", adminID);
if (i == 1)
{
MessageBox.Show("更新用户成功！");
}
else
{
MessageBox.Show("更新用户失败！");
}
}
