教師管理操作流程規(guī)范

1、教師管理操作流程1、 使用Teacher賬號登陸教師管理系統(tǒng)代碼區(qū)域：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()

2、; count = (int)command.ExecuteScalar(); if (count = 1) isValidUser = true; else index+; if (index <= 3) message = "用戶名或密碼不存在！" else if (index >= 3) Application.Exit(); isValidUser = false; catch (Exception ex) message = ex.Message; Console.WriteLine(ex.Message); 查詢修改信息查詢教師基本信息(代碼區(qū)域：)

3、 TeacherBaseForm teacherBaseForm = new TeacherBaseForm(); teacherBaseForm.Show();TeacherBaseForm（教師基本信息窗體）查詢及修改學(xué)生信息(代碼區(qū)域：) UpdateStudentForm updateStudentForm = new UpdateStudentForm(); updateStudentForm.Show();SearchTeacherForm.cs（查詢及修改信息窗體）AddScoreForm（學(xué)生成績錄入窗體）錄入按鈕代碼：string sql = string.Format(&q

4、uot;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)reader"StudentId&

5、quot; no = (string)reader"StudentNo" name = (string)reader"StudentName" reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); if (TianJia() if (txtId.Text = Convert.ToString(id) && txtStudentNo.Text = no && txtStude

6、ntName.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,

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

8、 (result != 1) MessageBox.Show("添加失敗", "輸入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show("添加成功", "輸入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); catch (Exception ex) /MessageBox.Show("操作數(shù)據(jù)庫出錯！", "輸入提示&quo

9、t;, MessageBoxButtons.OK, MessageBoxIcon.Information); /Console.WriteLine(ex.Message); MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); else MessageBox.Show("您輸入的學(xué)生在數(shù)據(jù)庫中沒有，請重新輸入", "輸入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); private void AddScoreFor

10、m_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.Ite

11、ms.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 = c

12、ommand.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.Tex

13、t.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

14、(reader.Read() gradeId = (int)reader0; reader.Close(); catch (Exception ex) MessageBox.Show("操作數(shù)據(jù)庫出錯"); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); sql = "SELECT ClassName FROM Class WHERE GradeId=" + gradeId; command.CommandText = sql; try DBHelper.connec

15、tion.Open(); SqlDataReader reader = command.ExecuteReader(); string className = "" cboClass.Items.Clear(); while (reader.Read() className = (string)reader"ClassName" cboClass.Items.Add(className); reader.Close(); catch (Exception ex) MessageBox.Show("操作數(shù)據(jù)庫出錯"); Console.

16、WriteLine(ex.Message); finally DBHelper.connection.Close(); private void txtId_TextChanged(object sender, EventArgs e) UpdateScoreForm（更新成績窗體）保存按鈕代碼：DialogResult result = MessageBox.Show("確實(shí)要將修改保存到數(shù)據(jù)庫嗎？", "輸入提示", MessageBoxButtons.OK, MessageBoxIcon.Information); if (result = DialogResult.OK) SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter); data