//删除用户
private void menuDelUser_Click(object sender, EventArgs e)
{
if (dataGridView.SelectedRows.Count == 0)
{
MessageBox.Show("请先选中要删除的行");
}
else
{
string strErr = "";
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Login.Login objlogin = new Manage.Login.Login(strConnection);
for (int i = 0; i < dataGridView.SelectedRows.Count; i++)
{
int iRights = int.Parse(dataGridView.SelectedRows[i].Cells["权限"].Value.ToString());
string strUserNumble = dataGridView.SelectedRows[i].Cells["帐号"].Value.ToString();
int iRent = objlogin.DelUser(iRights, strUserNumble, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
}
BindDataGridView();
}
}
//查询用户
private void btnSearch_Click(object sender, EventArgs e)
{
string strUserNo = txtUserNo.Text.Replace(@"\", @"\\");
strUserNo = strUserNo.Replace("%", @"\%");
strUserNo = strUserNo.Replace("_", @"\_");
strUserNo = strUserNo.Replace("'", @"\''");
strUserNo = strUserNo.Trim();
string strUserName = txtUserName.Text.Replace(@"\", @"\\");
strUserName = strUserName.Replace("%", @"\%");
strUserName = strUserName.Replace("_", @"\_");
strUserName = strUserName.Replace("'", @"\''");
strUserName = strUserName.Trim();
//字符串连接
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Login.Login objlogin = new Manage.Login.Login(strConnection);
string strErr = "";
//根据用户账号或是用户名称来查询
if (strUserNo == "" && strUserName == "")
{
BindDataGridView();
}
else
{
DataTable objDataTable = new DataTable();
int iRent = objlogin.SearchUserBy(strUserNo, strUserName, out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
}
else
{
if (objDataTable.Rows.Count == 0)
{
MessageBox.Show("没有您要查询的记录");
}
else
{
dataGridView.DataSource = objDataTable;
}
}
txtUserNo.Text = "";
txtUserName.Text = "";
}
}
//修改用户密码
private void btnSubmit_Click(object sender, EventArgs e)
{
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Login.Login objLogin = new Manage.Login.Login(strConnection);
string strErr = "";
Model.Users.Users objUsers = new Model.Users.Users();
string struserno = this.lblUserNo.Text;
if (this.txtNewPWD.Text == "" || this.txtConfirmPWD.Text == "")
{
MessageBox.Show("请确认信息是否填写完整！");
}
else
{
if (this.txtNewPWD.Text != this.txtConfirmPWD.Text)
{
MessageBox.Show("两次输入的密码不一致,请重新输入！");
this.txtNewPWD.Clear();
this.txtConfirmPWD.Clear();
}
else
{
if (this.txtNewPWD.Text == this.txtConfirmPWD.Text && this.txtNewPWD.Text.Length > 14)
{
MessageBox.Show("密码长度限制在14位之内！");
this.txtNewPWD.Clear();
this.txtConfirmPWD.Clear();
}
else
{
objUsers.PassWord = txtNewPWD.Text;
}
int iRent = objLogin.ChangePWD(iRight, struserno, objUsers, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("修改密码成功");
this.Close();
}
}
}
}
void BindDataGridViewStuAll()
{
string strErr = "";
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Login.Login objLogin = new Manage.Login.Login(strConnection);
DataTable objDataTable = new DataTable();
int iRent = objLogin.SearchUserisStu(out objDataTable, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
dataGridView.DataSource = objDataTable;
}
}
//修改用户名称 用户密码
private void btnSubmit_Click(object sender, EventArgs e)
{
string strErr = "";
string strUserNo;
Model.Users.Users objUsers = new Model.Users.Users();
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Login.Login objLogin = new Manage.Login.Login(strConnection);
strUserNo = objUsers.UserNo = txtUserNo.Text.Replace("'", "''");
objUsers.UserNo = objUsers.UserNo.Trim();
objUsers.UserName = txtUserName.Text.Replace("'", "''");
objUsers.UserName = objUsers.UserName.Trim();
objUsers.PassWord = txtPWD.Text.Replace("'", "''");
objUsers.PassWord = objUsers.PassWord.Trim();
objUsers.Rights = int.Parse(txtRights.Text.ToString());
if (objUsers.UserNo == "" || objUsers.UserName == "")
{
MessageBox.Show("请将信息填写完整！");
}
else
{
if (userno == objUsers.UserNo)
{
int iRent = objLogin.ModifyUser(iRights, strUserNo, userno, objUsers, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("修改成功！");
this.Visible = false;
}
}
else
{
int iExist = objLogin.JudgeUserNo(objUsers.UserNo);
if (iExist == 0)
{
int iRent = objLogin.ModifyUser(iRights, strUserNo, userno, objUsers, out strErr);
if (iRent == 0)
{
MessageBox.Show(strErr);
return;
}
else
{
MessageBox.Show("修改成功！");
this.Visible = false;
}
}
else
{
MessageBox.Show("此帐号已存在，修改失败");
txtUserNo.Text = userno;
}
}
}
}
private void btnLogin_Click(object sender, EventArgs e)
{
string strErr = "";
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
Manage.Login.Login objLogin = new Manage.Login.Login(strConnection);
if (rabAdmin.Checked == true)
{
Model.Users.Users objUsers = new Model.Users.Users();
objUsers.UserNo = txtUserNo.Text.Replace("'", "''");
objUsers.UserNo = objUsers.UserNo.Trim();
objUsers.PassWord = txtPassWord.Text.Replace("'", "''");
objUsers.PassWord = objUsers.PassWord.Trim();
//以管理员身份登录
//判断输入的用户名和密码是否正确,正确进入 MainForm界面,否则提示您输入的账号或密码错误，请重新输入
if (txtUserNo.Text == "system" && txtPassWord.Text == "521521")
{
objUsers.Rights = 1;
MainForm objEnter = new MainForm(objUsers.UserNo, objUsers.PassWord, objUsers.Rights);
this.Visible = false;
objEnter.Show();
}
else
{
MessageBox.Show("您输入的账号或密码错误，请重新输入！");
txtUserNo.Text = "";
txtPassWord.Text = "";
return;
}
}
////以教师身份登录
else if (rabTea.Checked == true)
{
Model.Users.Users objUsers = new Model.Users.Users();
objUsers.UserNo = txtUserNo.Text.Replace("'", "''");
objUsers.UserNo = objUsers.UserNo.Trim();
objUsers.UserNo = objUsers.UserNo.Replace("%", @"\%");
objUsers.PassWord = txtPassWord.Text.Replace("'", "''");
objUsers.PassWord = objUsers.PassWord.Trim();
objUsers.PassWord = objUsers.PassWord.Replace("%", @"\%");
objUsers.Rights = 2;
int iRent = objLogin.JudgeExist(objUsers.UserNo, objUsers.PassWord, objUsers.Rights, out strErr);
if (iRent == 1)
{
MainForm objEnter = new MainForm(objUsers.UserNo, objUsers.PassWord, objUsers.Rights);
objEnter.Show();
this.Visible = false;
}
else
{
MessageBox.Show("您输入的账号或密码错误，请重新输入！");
txtUserNo.Text = "";
txtPassWord.Text = "";
return;
}
}
else
{
// //以学生方式登录
Model.Users.Users objUsers = new Model.Users.Users();
objUsers.UserNo = txtUserNo.Text.Replace("'", "''");
objUsers.UserNo = objUsers.UserNo.Trim();
objUsers.PassWord = txtPassWord.Text.Replace("'", "''");
objUsers.PassWord = objUsers.PassWord.Trim();
objUsers.Rights = 3;
int iRent = objLogin.JudgeExist(objUsers.UserNo, objUsers.PassWord, objUsers.Rights, out strErr);
if (iRent == 1)
{
MainForm objEnter = new MainForm(objUsers.UserNo, objUsers.PassWord, objUsers.Rights);
objEnter.Show();
this.Visible = false;
}
else
{
MessageBox.Show("您输入的账号或密码错误，请重新输入！");
txtUserNo.Text = "";
txtPassWord.Text = "";
return;
}
}
}
