教务管理员操作流程

教务管理员操作流程1、使用Admin账号登陆——教务管理员系统代码区域：int count = 0;bool isValidUser = false;if (loginType == "教务管理员"){string sql = ("select count(*) from Admin where LoginId='{0}' AND LoginPwd='{1}'", loginId, loginPwd);try{SqlCommand command = new SqlCommand(sql, ; count = (int)();if (count == 1){isValidUser = true;}else{index++;if (index <=3){message = "用户名或密码不存在！";}else if (index >= 3){();}isValidUser = false;}}catch (Exception ex){message = ;;}finally{}if == "教务管理员"){AdminForm adminForm = new AdminForm();();return true;}成功进入后可以进行（教务管理员窗体）用户管理→新增用户→新增学生信息（代码如下：）AddStudentForm addstudnetForm = new AddStudentForm(); = this;();→弹出窗口（学生信息添加）→Student表保存按钮代码如下:if (TianJia()){try{SqlCommand command = new SqlCommand(sql, ;int result = ();if (result != 1){("添加失败", "输入提示", , ;}{("添加成功", "输入提示", , ;}}catch (Exception ex){;}finally {}}}private void AddStudentForm_Load(object sender, EventArgs e){string sql = "select gradeName from Grade";try {SqlCommand command=new SqlCommand(sql,;SqlDataReader reader=();string gradeName=(string)reader[0];}();}catch(Exception ex){;}finally{}}private void cboGrade_SelectedIndexChanged(object sender, EventArgs e){if != ""){int gradeId = -1;string sql = ("select GradeId from Grade where GradeName='{0}'",;SqlCommand command = new SqlCommand(sql, ;try{SqlDataReader reader = ();{gradeId = (int)reader[0];}();}catch (Exception ex){("操作数据库出错");;}finally{}sql = "SELECT ClassName FROM Class WHERE GradeId=" +gradeId;= sql;try{SqlDataReader reader = ();string className = "";while ()){className = (string)reader["ClassName"]; }();}catch (Exception ex){("操作数据库出错");;}finally{}}}private void txtStudentPassword_TextChanged(object sender, EventArgs e){}}（教师信息添加窗体）新增教师信息→弹出窗口（教师信息添加）→Teacher表保存按钮代码如下:if (TianJia()){try{SqlCommand command = new SqlCommand(sql, ;int result = ();if (result != 1){("添加失败", "输入提示", , ;}else{("添加成功", "输入提示", , ;}}catch (Exception ex){("操作数据库出错", "输入提示", , ;;}finally{}}}查询修改信息→学生信息→查询及删除信息（可以进行模糊查询）（学生查询及删除信息窗体）查询按钮代码：if == ""){("请输入用户名", "输入提示", , ;();}else {SearchStudent();}}private void tsmiDelete_Click(object sender, EventArgs e) {if == 0){("您没有选择任何用户", "输入提示", , ;}else {DialogResult choice = ("确定要删除该用户吗", "警告", , ;if (choice == {int result = 0;try{string sql = ("delete Student where StudentId={0}", (int)[0].Tag);SqlCommand command = new SqlCommand(sql, ; result = ();}catch (Exception ex){;}finally {}if (result < 1){("删除失败", "输入提示", , ;}else {("删除成功", "输入提示", , ;SearchStudent();}}}（学生更新信息窗体）保存信息按钮代码:DialogResult result = ("确实要将修改保存到数据库吗", "输入提示", , ;if (result =={SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter);(dataSet, "Student");("保存成功", "输入提示", , ;}else{("保存失败", "输入提示", , ;}（教师查询及删除信息窗体）查询按钮代码：if == ""){("请输入用户名", "输入提示", , ;();}else{SearchTeacher();}}private void btnExit_Click(object sender, EventArgs e) {();}private void tsmiDelete1_Click(object sender, EventArgs e) {if == 0){("您没有选择任何用户", "输入提示", , ;}else {DialogResult choice = ("确定要删除该用户吗", "警告", , ;if (choice == {int result = 0;try{string sql = ("delete Teacher where TeacherId={0}", (int)[0].Tag);SqlCommand command = new SqlCommand(sql, ; result = ();}catch (Exception ex){;}finally {}if (result < 1){("删除失败", "输入提示", , ;}else {("删除成功", "输入提示", , ;SearchTeacher();}}（教师更新信息窗体）保存信息按钮代码:DialogResult result = ("确实要将修改保存到数据库吗", "输入提示",, ;if (result =={SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter);(dataSet, "Teacher");("保存成功", "输入提示", , ;}else {("保存失败", "输入提示", , ;}}娱乐通过引用完成操作退出系统→重新登录（代码如下：）LoginForm fm1 = new LoginForm();();();帮助说明→版权说明（帮助窗体）→帮助信息（("欢迎使用帮助系统\n 本系统新建用户初始密码：\n 【123】", "帮助信息");）→运行屏保（引用外部文件）。