【教务管理员操作流程】.doc

《【教务管理员操作流程】.doc》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、教务管理员操作流程1、使用Admin账号登陆——教务管理员系统代码区域：intcount=0;boolisValidUser=false;if(loginType=="教务管理员"){stringsql=string.Format("selectcount(*)fromAdminwhereLoginId='{0}'ANDLoginPwd='{1}'",loginId,loginPwd);try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.c

2、onnection.Open();count=(int)command.ExecuteScalar();if(count==1){isValidUser=true;}else{index++;if(index<=3){message="用户名或密码不存在！";}elseif(index>=3){Application.Exit();}isValidUser=false;}}catch(Exceptionex){message=ex.Message;Console.WriteLine(ex.Message);}finally{D

3、BHelper.connection.Close();}if(cboType.Text=="教务管理员"){AdminFormadminForm=newAdminForm();adminForm.Show();returntrue;}成功进入后可以进行AdminForm.cs（教务管理员窗体）用户管理→新增用户→新增学生信息（代码如下：）AddStudentFormaddstudnetForm=newAddStudentForm();addstudnetForm.MdiParent=this;addstudnetForm.Sh

4、ow();→弹出窗口（学生信息添加）→Student表AdminStudentForm.cs保存按钮代码如下:if(TianJia()){try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();intresult=command.ExecuteNonQuery();if(result!=1){MessageBox.Show("添加失败","输入提示",MessageBoxButtons.OK,MessageB

5、oxIcon.Information);}else{MessageBox.Show("添加成功","输入提示",MessageBoxButtons.OK,MessageBoxIcon.Information);}}catch(Exceptionex){MessageBox.Show(ex.Message);}finally{DBHelper.connection.Close();}}}privatevoidAddStudentForm_Load(objectsender,EventArgse){stringsql="selec

6、tgradeNamefromGrade";try{SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);DBHelper.connection.Open();SqlDataReaderreader=command.ExecuteReader();while(reader.Read()){stringgradeName=(string)reader[0];cboGrade.Items.Add(gradeName);}reader.Close();}catch(Excep

7、tionex){MessageBox.Show(ex.Message);}finally{DBHelper.connection.Close();}}privatevoidcboGrade_SelectedIndexChanged(objectsender,EventArgse){if(cboGrade.Text.Trim()!=""){intgradeId=-1;stringsql=string.Format("selectGradeIdfromGradewhereGradeName='{0}'",cboGrade.Text

8、);SqlCommandcommand=newSqlCommand(sql,DBHelper.connection);try{DBHelper.connection.Open();SqlDataReaderreader=command.ExecuteReader();if(r