【教师管理操作流程】

1、教师管理操作流程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()

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); 查询修改信息查询教师基本信息(代码区域：)

3、 TeacherBaseForm teacherBaseForm = new TeacherBaseForm(); teacherBaseForm.Show();TeacherBaseForm（教师基本信息窗体）查询及修改学生信息(代码区域：) UpdateStudentForm updateStudentForm = new UpdateStudentForm(); updateStudentForm.Show();SearchTeacherForm.cs（查询及修改信息窗体）AddScoreForm（学生成绩录入窗体）录入按钮代码：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("操作数据库出错！", "输入提示&quo

9、t;, 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 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; reader.Close

11、(); 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 (

12、reader.Read() string subName = (string)reader0; reader.Close(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); private void cboGrade_SelectedIndexChanged(object sender, EventArgs e) if"") int gradeId = -1; string sql = string.Format("select Grad

13、eId 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.S

14、how("操作数据库出错"); 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 = "&q

15、uot; while (reader.Read() className = (string)reader"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 SqlCommandBuilder(dataAdapter); dataAdapte