[流程管理]教务管理员操作流程

（流程管理)教务管理员操作流程教务管理员操作流程1、使用Admin账号登陆——教务管理员系统代码区域：intcount=0;boolisValidUser=false;if(loginType=="教务管理员"){stringsql=string.Format("selectcount(*)fromAdminwhereLoginId='{0}'ANDLoginPwd='{1}'",loginI d,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,rmation); }else{MessageBox.Show("添加成功","输入提示",MessageBoxButtons.OK,rmation); }}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;mandText=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,rmation);}else{MessageBox.Show("添加成功","输入提示",MessageBoxButtons.OK,rmation); }}catch(Exceptionex){MessageBox.Show("操作数据库出错","输入提示",MessageBoxButtons.OK,rmation);Console.WriteLine(ex.Message);}finally{DBHelper.connection.Close();}}}查询修改信息→学生信息→查询及删除信息（能够进行模糊查询）SearchStudentForm.cs（学生查询及删除信息窗体）查询按钮代码：if(txtName.Text==""){MessageBox.Show("请输入用户名","输入提示",MessageBoxButtons.OK,rmation);txtName.Focus();}else{SearchStudent();}}privatevoidtsmiDelete_Click(objectsender,EventArgse){if(listView1.SelectedItems.Count==0){MessageBox.Show("您没有选择任何用户","输入提示",MessageBoxButtons.OK,rmation);}else{DialogResultchoice=MessageBox.Show("确定要删除该用户吗","警告",MessageBoxButtons.OK,rmation);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(result<1){MessageBox.Show("删除失败","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation); }else{MessageBox.Show("删除成功","输入提示",MessageBoxButtons.OK,rmation); SearchStudent();}}}UpdateStudentForm.cs（学生更新信息窗体）保存信息按钮代码:DialogResultresult=MessageBox.Show("确实要将修改保存到数据库吗？","输入提示",MessageBoxButtons.OK,rmation);if(result==DialogResult.OK){SqlCommandBuilderbuilder=newSqlCommandBuilder(dataAdapter);dataAdapter.Update(dataSet,"Student");MessageBox.Show("保存成功","输入提示",MessageBoxButtons.OK,rmation); }else{MessageBox.Show("保存失败","输入提示",MessageBoxButtons.OK,rmation); }SearchTeacherForm.cs（教师查询及删除信息窗体）查询按钮代码：if(txtName.Text==""){MessageBox.Show("请输入用户名","输入提示",MessageBoxButtons.OK,rmation);txtName.Focus();}else{SearchTeacher();}}privatevoidbtnExit_Click(objectsender,EventArgse){this.Close();}privatevoidtsmiDelete1_Click(objectsender,EventArgse){if(listView1.SelectedItems.Count==0){MessageBox.Show("您没有选择任何用户","输入提示",MessageBoxButtons.OK,rmation);}else{DialogResultchoice=MessageBox.Show("确定要删除该用户吗","警告",MessageBoxButtons.OK,rmation);if(choice==DialogResult.OK){intresult=0;try{stringsql=string.Format("deleteTeacherwhereTeacherId={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(result<1){MessageBox.Show("删除失败","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Exclamation);}else{MessageBox.Show("删除成功","输入提示",MessageBoxButtons.OK,rmation); SearchTeacher();}}UpdateTeacherForm.cs（教师更新信息窗体）保存信息按钮代码:DialogResultresult=MessageBox.Show("确实要将修改保存到数据库吗？","输入提示",MessageBoxButtons.OK,rmation);if(result==DialogResult.OK){SqlCommandBuilderbuilder=newSqlCommandBuilder(dataAdapter);dataAdapter.Update(dataSet,"Teacher");MessageBox.Show("保存成功","输入提示",MessageBoxButtons.OK,rmation); }else{MessageBox.Show("保存失败","输入提示",MessageBoxButtons.OK,rmation); }}娱乐通过引用完成操作退出系统→重新登录（代码如下：）LoginFormfm1=newLoginForm();this.Hide();fm1.Show();帮助说明→版权说明（HelpForm.cs帮助窗体）→帮助信息（MessageBox.Show("欢迎使用帮助系统\n本系统新建用户初始密码：\n【123】","帮助信息");）→运行屏保（引用外部文件）。