【教师管理操作流程】.doc

教师管理操作流程1、 使用Teacher账号登陆教师管理系统代码区域：if (loginType = 教师) string sql = string.Format(select count(*) from teacher where LoginId=0 AND LoginPwd=1, loginId, loginPwd); try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); count = (int)command.ExecuteScalar(); if (count = 1) isValidUser = true; else index+; if (index = 3) Application.Exit(); isValidUser = false; catch (Exception ex) message = ex.Message; Console.WriteLine(ex.Message); 查询修改信息查询教师基本信息(代码区域：) TeacherBaseForm teacherBaseForm = new TeacherBaseForm(); teacherBaseForm.Show();TeacherBaseForm（教师基本信息窗体）查询及修改学生信息(代码区域：) UpdateStudentForm updateStudentForm = new UpdateStudentForm(); updateStudentForm.Show();SearchTeacherForm.cs（查询及修改信息窗体）AddScoreForm（学生成绩录入窗体）录入按钮代码：string sql = string.Format(select StudentId,StudentNo,StudentName from Student where StudentId=0, txtId.Text); try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() id = (int)readerStudentId; no = (string)readerStudentNo; name = (string)readerStudentName; reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); if (TianJia() if (txtId.Text = Convert.ToString(id) & txtStudentNo.Text = no & txtStudentName.Text = name) string studentName = txtStudentName.Text; string sdudentNo = txtStudentNo.Text; string subject = cboSubject.Text; string score = txtScore.Text; int classId = GetClassId(); string studentId = txtId.Text; string sql1 = string.Format(insert into Score(StudentNo,Subject,SScore,SName,ClassId,StudentId)values(0,1,2,3,4,5), sdudentNo, subject, score, studentName, classId, studentId); try SqlCommand command = new SqlCommand(sql1, DBHelper.connection); DBHelper.connection.Open(); int result = command.ExecuteNonQuery(); if (result != 1) MessageBox.Show(添加失败, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show(添加成功, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); catch (Exception ex) /MessageBox.Show(操作数据库出错！, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); /Console.WriteLine(ex.Message); MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); else MessageBox.Show(您输入的学生在数据库中没有，请重新输入, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); private void AddScoreForm_Load(object sender, EventArgs e) string sql = select gradeName from Grade; try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() string gradeName = (string)reader0; cboGrade.Items.Add(gradeName); reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); string sql1 = select SubjectName from Subject; try SqlCommand command = new SqlCommand(sql1, DBHelper.connection); DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() string subName = (string)reader0; cboSubject.Items.Add(subName); reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); private void cboGrade_SelectedIndexChanged(object sender, EventArgs e) if (cboGrade.Text.Trim() != ) int gradeId = -1; string sql = string.Format(select GradeId from Grade where GradeName=0, cboGrade.Text); SqlCommand command = new SqlCommand(sql, DBHelper.connection); try DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); if (reader.Read() gradeId = (int)reader0; reader.Close(); catch (Exception ex) MessageBox.Show(操作数据库出错); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); sql = SELECT ClassName FROM Class WHERE GradeId= + gradeId; command.CommandText = sql; try DBHelper.connection.Open(); SqlDataReader reader = command.ExecuteReader(); string className = ; cboClass.Items.Clear(); while (reader.Read() className = (string)readerClassName; cboClass.Items.Add(className); reader.Close(); catch (Exception ex) MessageBox.Show(操作数据库出错); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); private void txtId_TextChanged(object sender, EventArgs e) UpdateScoreForm（更新成绩窗体）保存按钮代码：DialogResult result = MessageBox.Show(确实要将修改保存到数据库吗？, 输入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); if (result = DialogResult.OK) SqlCommandBuilder builder = new SqlCom