【教務(wù)管理員操作流程】

1、教務(wù)管理員操作流程使用Admin賬號登陸教務(wù)管理員系統(tǒng)代碼區(qū)域：int count = 0; bool isValidUser = false; if (loginType = 教務(wù)管理員) string sql = string.Format(select count(*) from Admin where LoginId=0 AND LoginPwd=1, loginId, loginPwd); try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); cou

2、nt = (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); finally DBHelper.connection.Close(); if (cboType.Text = 教務(wù)管理員) AdminForm adminForm = ne

3、w AdminForm(); adminForm.Show(); return true; 成功進(jìn)入后可以進(jìn)行AdminForm.cs （教務(wù)管理員窗體）用戶管理新增用戶新增學(xué)生信息（代碼如下：） AddStudentForm addstudnetForm = new AddStudentForm(); addstudnetForm.MdiParent = this; addstudnetForm.Show();彈出窗口（學(xué)生信息添加）Student表AdminStudentForm.cs保存按鈕代碼如下: if (TianJia() try SqlCommand command = new

4、SqlCommand(sql, 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 (Excepti

5、on ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); private void AddStudentForm_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.Exe

6、cuteReader(); while(reader.Read() string gradeName=(string)reader0; cboGrade.Items.Add(gradeName); 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() !=

7、) 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.C

8、lose(); 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.connection.Open(); SqlDataReader reader = command.ExecuteReader(); string clas

9、sName = ; cboClass.Items.Clear(); while (reader.Read() className = (string)readerClassName; cboClass.Items.Add(className); reader.Close(); catch (Exception ex) MessageBox.Show(操作數(shù)據(jù)庫出錯); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); private void txtStudentPassword_TextChanged(ob

10、ject sender, EventArgs e) AdminTeacherForm.cs （教師信息添加窗體） 新增教師信息彈出窗口（教師信息添加）Teacher表保存按鈕代碼如下:if (TianJia() try SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); int result = command.ExecuteNonQuery(); if (result != 1) MessageBox.Show(添加失敗, 輸入提示, MessageBoxButt

11、ons.OK, MessageBoxIcon.Information); else MessageBox.Show(添加成功, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); catch (Exception ex) MessageBox.Show(操作數(shù)據(jù)庫出錯, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); Console.WriteLine(ex.Message); finally DBHelper.connection.Close(); 查詢修改信息學(xué)生

12、信息查詢及刪除信息（可以進(jìn)行模糊查詢）SearchStudentForm.cs （學(xué)生查詢及刪除信息窗體）查詢按鈕代碼：if (txtName.Text = ) MessageBox.Show(請輸入用戶名, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); txtName.Focus(); else SearchStudent(); private void tsmiDelete_Click(object sender, EventArgs e) if (listView1.SelectedItems.Count = 0) Me

13、ssageBox.Show(您沒有選擇任何用戶, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); else DialogResult choice = MessageBox.Show(確定要刪除該用戶嗎, 警告, MessageBoxButtons.OK, MessageBoxIcon.Information); if (choice = DialogResult.OK) int result = 0; try string sql = string.Format(delete Student where StudentId=0

14、, (int)listView1.SelectedItems0.Tag); SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); result = command.ExecuteNonQuery(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); if (result 1) MessageBox.Show(刪除失敗, 輸入提示, Messag

15、eBoxButtons.OK, MessageBoxIcon.Exclamation); else MessageBox.Show(刪除成功, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); SearchStudent(); UpdateStudentForm.cs （學(xué)生更新信息窗體）保存信息按鈕代碼:DialogResult result = MessageBox.Show(確實要將修改保存到數(shù)據(jù)庫嗎？, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); if

16、(result = DialogResult.OK) SqlCommandBuilder builder = new SqlCommandBuilder(dataAdapter); dataAdapter.Update(dataSet, Student); MessageBox.Show(保存成功, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); else MessageBox.Show(保存失敗, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); SearchTe

17、acherForm.cs （教師查詢及刪除信息窗體）查詢按鈕代碼：if (txtName.Text = ) MessageBox.Show(請輸入用戶名, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); txtName.Focus(); else SearchTeacher(); private void btnExit_Click(object sender, EventArgs e) this.Close(); private void tsmiDelete1_Click(object sender, EventArgs e

18、) if (listView1.SelectedItems.Count = 0) MessageBox.Show(您沒有選擇任何用戶, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Information); else DialogResult choice = MessageBox.Show(確定要刪除該用戶嗎, 警告, MessageBoxButtons.OK, MessageBoxIcon.Information); if (choice = DialogResult.OK) int result = 0; try string sql = str

19、ing.Format(delete Teacher where TeacherId=0, (int)listView1.SelectedItems0.Tag); SqlCommand command = new SqlCommand(sql, DBHelper.connection); DBHelper.connection.Open(); result = command.ExecuteNonQuery(); catch (Exception ex) MessageBox.Show(ex.Message); finally DBHelper.connection.Close(); if (result 1) MessageBox.Show(刪除失敗, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Exclamation); else MessageBox.Show(刪除成功, 輸入提示, MessageBoxButtons.OK, MessageBoxIcon.Info