//管理员修改用户信息
public int ModifyUser(int iRights, string userno, string strUserNo, Model.Users.Users objUsers, out string strErr)
{
int iRent = 0;
strErr = "";
SqlCommand sqlCom = new SqlCommand();
sqlCom.Connection = sqlCon;
string strSql = "";
if (iRights == 2)
{
strSql = " update Users set UserNo ='" + userno + "',UserName ='******',PassWord='******' where UserNo='" + strUserNo + "' and Type=1 ";
strSql += " update Teacher set teano='" + userno + "', teaname='" + objUsers.UserName + "' where TeaNo ='" + strUserNo + "'and Type=1 ";
}
if (iRights == 3)
{
strSql = " update Users set UserNo ='" + userno + "',UserName ='******',PassWord='******' where UserNo='" + strUserNo + "' and Type=1 ";
strSql += " update Student set stuno='" + userno + "',stuname='" + objUsers.UserName + "' where StuNo ='" + strUserNo + "' and Type=1 ";
}
sqlCom.CommandText = strSql;
try
{
sqlCon.Open();
sqlCom.ExecuteNonQuery();
iRent = 1;
}
catch (Exception ex)
{
strErr = ex.ToString();
iRent = 0;
}
finally
{
sqlCon.Close();
sqlCom.Dispose();
}
return(iRent);
}
public void LoadData()
{
string strErr = "";
Model.Users.Users objUsers = new Model.Users.Users();
DataSet ds = new DataSet();
DataTable dt = new DataTable();
string strConnection = System.Configuration.ConfigurationManager.ConnectionStrings["StudentManager"].ConnectionString;
string strSql = "select * from Users where UserNo='" + strUserNumber + "' and Type=1";
SqlConnection conn = new SqlConnection();
conn.ConnectionString = strConnection;
conn.Open();
SqlCommand sqlcomd = new SqlCommand();
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
try
{
da.Fill(ds);
}
catch (Exception exce)
{
strErr = exce.ToString();
}
finally
{
conn.Close();
}
DataRow dr = ds.Tables[0].Rows[0];
userno = this.txtUserNo.Text = dr["UserNo"].ToString();
this.txtUserName.Text = dr["UserName"].ToString();
this.txtPWD.Text = dr["PassWord"].ToString();
this.txtRights.Text = dr["Rights"].ToString();
}
//修改用户名称 用户密码
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;
}
}
}
