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("更新用户失败!"); } }