【教务管理员操作流程】

教务管理员操作流程1、使用Admin账号登陆——教务管理员系统代码区域：intcount=0;boolisValidUser=false;if(loginType==教务管理员){stringsql=string.Format(selectcount(*)fromAdminwhereLoginId='{0}'ANDLoginPwd='{1}',loginId,loginPwd);try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();count=(int)command.ExecuteScalar();if(count==1){isValidUser=true;}else{index++;if(index=3){message=用户名或密码不存在！;}elseif(index=3){Application.Exit();}isValidUser=false;}}catch(Exceptionex){message=ex.Message;Console.WriteLine(ex.Message);}finally{DBHelper.connection.Close();}if(cboType.Text==教务管理员){AdminFormadminForm=newAdminForm();adminForm.Show();returntrue;}成功进入后可以进行AdminForm.cs（教务管理员窗体）用户管理→新增用户→新增学生信息（代码如下：）AddStudentFormaddstudnetForm=newAddStudentForm();addstudnetForm.MdiParent=this;addstudnetForm.Show();→弹出窗口（学生信息添加）→Student表AdminStudentForm.cs保存按钮代码如下:if(TianJia()){try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();intresult=command.ExecuteNonQuery();if(result!=1){MessageBox.Show(添加失败,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show(添加成功,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message);}finally{DBHelper.connection.Close();}}}privatevoidAddStudentForm_Load(objectsender,EventArgse){stringsql=selectgradeNamefromGrade;try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();SqlDataReaderreader=command.ExecuteReader();while(reader.Read()){stringgradeName=(string)reader[0];cboGrade.Items.Add(gradeName);}reader.Close();}catch(Exceptionex){MessageBox.Show(ex.Message);}finally{DBHelper.connection.Close();}}privatevoidcboGrade_SelectedIndexChanged(objectsender,EventArgse){if(cboGrade.Text.Trim()!=){intgradeId=-1;stringsql=string.Format(selectGradeIdfromGradewhereGradeName='{0}',cboGrade.Text);SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);try{DBHelper.connection.Open();SqlDataReaderreader=command.ExecuteReader();if(reader.Read()){gradeId=(int)reader[0];}reader.Close();}catch(Exceptionex){MessageBox.Show(操作数据库出错);Console.WriteLine(ex.Message);}finally{DBHelper.connection.Close();}sql=SELECTClassNameFROMClassWHEREGradeId=+gradeId;command.CommandText=sql;try{DBHelper.connection.Open();SqlDataReaderreader=command.ExecuteReader();stringclassName=;cboClass.Items.Clear();while(reader.Read()){className=(string)reader[ClassName];cboClass.Items.Add(className);}reader.Close();}catch(Exceptionex){MessageBox.Show(操作数据库出错);Console.WriteLine(ex.Message);}finally{DBHelper.connection.Close();}}}privatevoidtxtStudentPassword_TextChanged(objectsender,EventArgse){}}AdminTeacherForm.cs（教师信息添加窗体）新增教师信息→弹出窗口（教师信息添加）→Teacher表保存按钮代码如下:if(TianJia()){try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();intresult=command.ExecuteNonQuery();if(result!=1){MessageBox.Show(添加失败,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show(添加成功,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(操作数据库出错,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);Console.WriteLine(ex.Message);}finally{DBHelper.connection.Close();}}}查询修改信息→学生信息→查询及删除信息（可以进行模糊查询）SearchStudentForm.cs（学生查询及删除信息窗体）查询按钮代码：if(txtName.Text==){MessageBox.Show(请输入用户名,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);txtName.Focus();}else{SearchStudent();}}privatevoidtsmiDelete_Click(objectsender,EventArgse){if(listView1.SelectedItems.Count==0){MessageBox.Show(您没有选择任何用户,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}else{DialogResultchoice=MessageBox.Show(确定要删除该用户吗,警告,MessageBoxButtons.OK,MessageBoxIcon.Information);if(choice==DialogResult.OK){intresult=0;try{stringsql=string.Format(deleteStudentwhereStudentId={0},(int)listView1.SelectedItems[0].Tag);SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();result=command.ExecuteNonQuery();}catch(Exceptionex){MessageBox.Show(ex.Message);}finally{DBHelper.connection.Close();}if(result1){MessageBox.Show(删除失败,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}else{MessageBox.Show(删除成功,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);SearchStudent();}}}UpdateStudentForm.cs（学生更新信息窗体）保存信息按钮代码:DialogResultresult=MessageBox.Show(确实要将修改保存到数据库吗？,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);if(result==DialogResult.OK){SqlCommandBuilderbuilder=newSqlCommandBuilder(dataAdapter);dataAdapter.Update(dataSet,Student);MessageBox.Show(保存成功,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}else{MessageBox.Show(保存失败,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);}SearchTeacherForm.cs（教师查询及删除信息窗体）查询按钮代码：if(txtName.Text==){MessageBox.Show(请输入用户名,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Information);txtName.Focus();}else{SearchTeacher();}}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}privatevoidtsmiDelete1_Click(objectsender,EventArgse){if(listView1.SelectedItems.Count==0){MessageBox.Show(您没有选择任何用户,输入提示,MessageBoxButtons.OK,MessageBoxIcon.Informatio