【教师管理操作流程】

1、 教师管理操作流程 1、使用 Teacher 账号登陆教师管理系统 代码区域： if (loginType = 教师) AND string sql = string .Format( select count(*) from teacher where LoginId=0 LoginPwd=1 , loginId, loginPwd); try SqlCommandcommand = new SqlCommand(sql, DBHelper .connection); DBHelper .connection.Open(); count = ( int )command.ExecuteSca

2、lar(); 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(); Teach

3、erBaseForm （教师基本信息窗体 ） 查询及修改学生信息 ( 代码区域： ) UpdateStudentForm updateStudentForm = new UpdateStudentForm (); updateStudentForm.Show(); SearchTeacherForm.cs (查询及修改信息窗体 ) AddScoreForm (学生成绩录入窗体) 录入按钮代码： string sql = string .Format( select StudentId,StudentNo,StudentName from Student where StudentId=0 ,

4、txtId.Text); try SqlCommandcommand = new SqlCommand(sql, DBHelper .connection); DBHelper .connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() id = (int )reader StudentId ; no = ( string )reader StudentNo ; name = ( string )reader StudentName ; reader.Close(); catc

5、h ( Exception ex) MessageBox.Show(ex.Message); finally DBHelper .connection.Close(); if (TianJia() if (txtId.Text = Convert .ToString(id) string sdudentNo = txtStudentNo.Text; string subject = cboSubject.Text; string score = txtScore.Text; int classId = GetClassId(); string studentId = txtId.Text; s

6、tring 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 SqlCommandcommand = new SqlCommand(sql1, DBHelper .connection); DBHelper .connection.Open(); int result = command.Ex

7、ecuteNonQuery(); if (result != 1) MessageBox.Show( 添加失败 , 输入提示 , MessageBoxButtons .OK, MessageBoxIcon.Information); else MessageBox.Show( 添加成功 , 输入提示 , MessageBoxButtons .OK, MessageBoxIcon.Information); catch ( Exception ex) /MessageBox.Show( 操作数据库出错！ , 输入提示 , MessageBoxButtons.OK, MessageBoxIcon.

8、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 gra

9、deName from Grade ; try SqlCommandcommand = 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) MessageB

10、ox.Show(ex.Message); finally DBHelper .connection.Close(); string sql1 = select SubjectName from Subject; try SqlCommandcommand = new SqlCommand(sql1, DBHelper .connection); DBHelper .connection.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read() string subName = ( string )r

11、eader0; 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

12、GradeId from Grade where GradeName=0 cboGrade.Text); SqlCommandcommand = 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( 操作数据

13、库出错 ); 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 (read

14、er.Read() className = (string )reader ClassName ; 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 SqlComma