// 添加管理员 private void Button1_Click(object sender, EventArgs e) { adminName = textBox1.Text; pwd = textBox2.Text; rePwd = textBox3.Text; if (radioButton1.Checked) { changeStuPower = "1"; } else { changeStuPower = "0"; } if (radioButton3.Checked) { isSuperAdmin = "1"; } else { isSuperAdmin = "0"; } if (adminName != "" || pwd != "") { if (pwd == rePwd) { pwd = otherFunction.SHA1(pwd, Encoding.UTF8); DataSet dataSet = SqlFunction.GetDs("SELECT * FROM Admin Where adminName='" + adminName + "'"); DataView dataView = dataSet.Tables[0].DefaultView; if (dataView.Count == 0) // 先和数据库里的进行判断 是否存在 { String sqlLanguage = "INSERT Admin VALUES('" + adminName + "','" + pwd + "','" + changeStuPower + "','" + isSuperAdmin + "')"; if (SqlFunction.Execute(sqlLanguage) > 0) { MessageBox.Show("插入成功!"); GetNewValues(); } else { MessageBox.Show("插入失败!"); } } else { MessageBox.Show("已经存在当前管理员"); } } else { MessageBox.Show("确认密码不相符,请确认密码"); } } else { MessageBox.Show("用户名和密码均不能空!!"); } }
private void Button1_Click(object sender, EventArgs e) { String adminName = textBox1.Text; String pwd = textBox2.Text; String rePwd = textBox3.Text; if (adminName != "" || pwd != "") { if (pwd == rePwd) { pwd = otherFunction.SHA1(pwd, Encoding.UTF8); DataSet dataSet = SqlFunction.GetDs("SELECT * FROM Admin Where adminName='" + adminName + "'"); DataView dataView = dataSet.Tables[0].DefaultView; if (dataView.Count == 0 || adminName == otherFunction.LoginName) { if (MessageBox.Show("确认修改?", "是否提交修改?", MessageBoxButtons.OKCancel) == DialogResult.OK) { String sqlLanguage = "UPDATE Admin SET adminName='" + adminName + "',pwd='" + pwd + "' WHERE adminName = '" + otherFunction.LoginName + "'"; if (SqlFunction.Execute(sqlLanguage) > 0) { MessageBox.Show("修改成功!"); otherFunction.LoginName = adminName; } else { MessageBox.Show("妈呀!修改失败咯!!!!怎么肥事?"); } } } else { MessageBox.Show("已经存在当前管理员"); } } else { MessageBox.Show("确认密码不相符,请确认密码"); } } else { MessageBox.Show("用户名和密码均不能空!!"); } }
private void Button1_Click(object sender, EventArgs e) { string adminName = textBox1.Text, pwd = otherFunction.SHA1(textBox2.Text, Encoding.UTF8); DataSet dataSet = SqlFunction.GetDs("SELECT * FROM Admin WHERE adminName='" + adminName + "' AND pwd='" + pwd + "'"); DataView dataView = dataSet.Tables[0].DefaultView; if (dataView.Count != 0) { otherFunction.LoginName = dataView[0]["adminName"].ToString(); otherFunction.ChangeStuPower = dataView[0]["changeStuPower"].ToString(); otherFunction.IsSuperAdmin = dataView[0]["isSuperAdmin"].ToString(); if (MessageBox.Show("登陆成功", "登陆成功,是否进入系统?", MessageBoxButtons.OKCancel) == DialogResult.OK) { this.Hide(); MainFram mainFram = new MainFram(); mainFram.ShowDialog(); } } else { MessageBox.Show("用户名或密码错误!!"); } }