毕业设计（论文）Visual C#.NET Access教务管理系统

1、三三级级实实践践课课题题设设计计任任务务书书 姓姓 名名 软件技术编码 专业 班 题题 目目教务管理系统 设设 计计 任任 务务 开发一个比较完善的基于 b/s 结构或 c/s 结构的教务管理系统 主要功能包括： 1、教务人员排课、调课、汇总各类考试成绩 2、学生选课、查看考试成绩及选课情况， 3、管理员管理各类用户基本信息，以及各类查询统计等功能。 4、一般教师查看课程表、打印学生名单、录入考试成绩， 要求：具有教务的完整功能，界面操作合理、人性化，每个组员工作量都要饱满。数据 库设计及代码符合规范。文档完整、规范。 要求各类用户可根据条件生成各种类型的报表，方便管理。 时时 间间 进进 度

2、度 第 17 周（09-12-2509-12-31）： 第 18 周（10-01-01-10-01-7）： 第 19 周（10-01-810-01-14）： 原原 主主 始始 要要 资资 参参 料料 考考 与与 文文 献献 01杨云. asp.net 典型系统开发 m:北京.人民邮电出版社. 2006.6 02千丽霞.asp teamessage tm; stumessage sm; classmessage cm; coursemessage coum; departmessage dm; public void formvisible() if (tm != null) tm.close(

3、); if (sm != null) sm.close(); if (cm!= null) cm.close(); if (coum != null) coum.close(); if (dm != null) dm.close(); private void button1_click(object sender, eventargs e) formvisible(); tm = new teamessage(); tm.mdiparent =this; tm.show(); private void button2_click(object sender, eventargs e) for

4、mvisible(); sm = new stumessage(); sm.mdiparent =this; sm.show(); private void button3_click(object sender, eventargs e) formvisible(); cm = new classmessage(); cm.mdiparent = this; cm.show(); private void button4_click(object sender, eventargs e) formvisible(); coum = new coursemessage(); coum.mdip

5、arent =this; coum.show(); private void button5_click(object sender, eventargs e) formvisible(); dm = new departmessage(); dm.mdiparent = this; dm.show(); private void button6_click(object sender, eventargs e) pwd_change pc = new pwd_change(); pc.showdialog(); private void button7_click(object sender

6、, eventargs e) this.close(); private void frm_admin_formclosing(object sender, formclosingeventargs e) application.exit(); private void button8_click(object sender, eventargs e) formvisible(); messagesort ms = new messagesort(); ms.mdiparent=this; ms.textbox12.text = 管理员; ms.show(); private void 计算器

7、toolstripmenuitem_click(object sender, eventargs e) system.diagnostics.process.start(calc.exe); private void 记事本toolstripmenuitem_click(object sender, eventargs e) system.diagnostics.process.start(notepad.exe); private void 绘图板toolstripmenuitem_click(object sender, eventargs e) system.diagnostics.pr

8、ocess.start(mspaint.exe); private void 蓝色天空toolstripmenuitem_click(object sender, eventargs e) skinengine1.skinfile = diamondblue.ssk; private void 绿色心情toolstripmenuitem_click(object sender, eventargs e) skinengine1.skinfile = diamondgreen.ssk; private void msntoolstripmenuitem_click(object sender,

9、eventargs e) skinengine1.skinfile = msn.ssk; private void frm_admin_load(object sender, eventargs e) 教师信息管理界面层代码如下： namespace edumanagement public partial class teamessage : form public teamessage() initializecomponent(); private void splitcontainer1_splittermoved(object sender, splittereventargs e)

10、 ebll.user u; emodel.teacher t; public void real() textbox24.readonly = true; textbox23.readonly = true; textbox13.readonly = true; textbox22.readonly = true; textbox21.readonly = true; textbox20.readonly = true; textbox19.readonly = true; textbox18.readonly = true; textbox17.readonly = true; textbo

11、x16.readonly = true; textbox15.readonly = true; textbox14.readonly = true; public void noreal() textbox24.readonly = false; textbox23.readonly = false; textbox13.readonly = false; textbox22.readonly = false; textbox21.readonly = false; textbox20.readonly = false; textbox19.readonly = false; textbox1

12、8.readonly = false; textbox17.readonly = false; textbox16.readonly = false; textbox15.readonly = false; textbox14.readonly = false; private void teamessage_load(object sender, eventargs e) this.windowstate = formwindowstate.maximized; u=new ebll.user(); datagridview1.datasource = u.teamessage_select

13、(); real(); public void uimodel() /t = new emodel.teacher(); /string id = (datarowview)this.bindingcontextdatagridview1.datasource.current)0.tostring(); /dt = u.teamessage_select(teaid=+id+); int id = this.datagridview1.currentrow.index; textbox24.text = datagridview10,id.value.tostring(); textbox23

14、.text = datagridview11, id.value.tostring(); combobox2.text = datagridview12, id.value.tostring(); if (datagridview13, id.value.tostring() != ) datetimepicker4.value = datetime.parse(datagridview13, id.value.tostring(); textbox13.text = datagridview14,id.value.tostring(); textbox22.text = datagridvi

15、ew15,id.value.tostring(); textbox21.text = datagridview16,id.value.tostring(); textbox20.text = datagridview17,id.value.tostring(); textbox19.text = datagridview18,id.value.tostring(); textbox18.text = datagridview19,id.value.tostring(); if (datagridview110, id.value.tostring() != ) datetimepicker3.

16、value = datetime.parse(datagridview110, id.value.tostring(); textbox17.text =datagridview111,id.value.tostring(); textbox16.text = datagridview112,id.value.tostring(); textbox15.text = datagridview113,id.value.tostring(); textbox14.text = datagridview114,id.value.tostring(); private void button4_cli

17、ck(object sender, eventargs e) u = new ebll.user(); button1.text = 添加; button2.text = 修改; string strwhere = teaid like % + textbox1.text + %; datagridview1.datasource = u.teamessage_select(strwhere); private void button2_click(object sender, eventargs e) if (button2.text = 修改) noreal(); button2.text

18、 = 保存; button1.text = 添加; else u = new ebll.user(); t = new emodel.teacher(); t.teaid = textbox24.text; t.teaname = textbox23.text; t.teasex = combobox2.text; t.birthday = datetimepicker4.value; t.minzu = textbox13.text; t.teahome = textbox22.text; t.mianmao = textbox21.text; t.xueli = textbox20.tex

19、t; fession = textbox19.text; t.graduateschool = textbox18.text; t.graduatetime = datetimepicker3.value; t.telephone = textbox17.text; t.address = textbox16.text; t.personid = textbox15.text; t.myid = textbox14.text; u.teamessage_updata(t, (datarowview)this.bindingcontextdatagridview1.datasource

20、.current)0.tostring(); messagebox.show(恭喜你，修改成功！); button2.text = 修改; teamessage_load(new object(), new eventargs(); private void button1_click(object sender, eventargs e) if (button1.text = 添加) textbox24.text = ; textbox23.text = ; textbox13.text = ; textbox22.text = ; textbox21.text = ; textbox20.

21、text = ; textbox19.text = ; textbox18.text = ; textbox17.text = ; textbox16.text = ; textbox15.text = ; textbox14.text = ; noreal(); button1.text = 保存; button2.text = 修改; else u = new ebll.user(); t = new emodel.teacher(); t.teaid = textbox24.text; t.teaname = textbox23.text; t.teasex = combobox2.te

22、xt; t.birthday = datetimepicker4.value; t.minzu = textbox13.text; t.teahome = textbox22.text; t.mianmao = textbox21.text; t.xueli = textbox20.text; fession = textbox19.text; t.graduateschool = textbox18.text; t.graduatetime = datetimepicker3.value; t.telephone = textbox17.text; t.address = text

23、box16.text; t.personid = textbox15.text; t.myid = textbox14.text; u.teamessage_add(t); messagebox.show(恭喜你，添加成功！); button1.text = 添加; teamessage_load(new object(), new eventargs(); private void button3_click(object sender, eventargs e) u = new ebll.user(); dialogresult dlgresult; button1.text = 添加;

24、button2.text = 修改; /int id=this.datagridview1.currentrow.index; /if (datagridview10, id.value.tostring() = null) / / messagebox.show(请选择所要删除的信息, 确认, messageboxbuttons.ok); / /else / dlgresult = messagebox.show(确实要删除该记录吗？, 确认, messageboxbuttons.yesno); if (dlgresult = dialogresult.yes) u.teamessage_d

25、elete(datarowview)this.bindingcontextdatagridview1.datasource.current)0.tostring(); this.teamessage_load(new object(),new eventargs(); / private void button5_click(object sender, eventargs e) savefiledialog savefiledialog = new savefiledialog(); savefiledialog.filter = execl files (*.xls)|*.xls; sav

26、efiledialog.filterindex = 0; savefiledialog.restoredirectory = true; savefiledialog.createprompt = true; savefiledialog.title = 导出excel文件到; datetime now = datetime.now; savefiledialog.filename = now.year.tostring().padleft(2) + now.month.tostring().padleft(2, 0) + now.day.tostring().padleft(2, 0) +

27、- + now.hour.tostring().padleft(2, 0) + now.minute.tostring().padleft(2, 0) + now.second.tostring().padleft(2, 0); savefiledialog.showdialog(); stream mystream; mystream = savefiledialog.openfile(); streamwriter sw = new streamwriter(mystream, system.text.encoding.getencoding(gb2312); string str = ;

28、 try /写标题 for (int i = 0; i 0) str += t; str += datagridview1.columnsi.headertext; sw.writeline(str); /写内容 for (int j = 0; j datagridview1.rows.count-1; j+) string tempstr = ; for (int k = 0; k 0) tempstr += t; tempstr += datagridview1.rowsj.cellsk.value.tostring(); sw.writeline(tempstr); sw.close()

29、; mystream.close(); catch (exception ex) messagebox.show(ex.tostring(); finally sw.close(); mystream.close(); private void datagridview1_cellleave(object sender, datagridviewcelleventargs e) private void datagridview1_cellenter(object sender, datagridviewcelleventargs e) uimodel(); button1.text = 添加

30、; button2.text = 修改; private void button6_click(object sender, eventargs e) print p = new print(); p.dt(datagridview1); p.showdialog(); 班级信息管理界面层代码如下： namespace edumanagement public partial class classmessage : form public classmessage() initializecomponent(); private void splitcontainer1_panel1_pai

31、nt(object sender, painteventargs e) ebll.user u; emodel.grade g; datatable dt; public void real() textbox1.readonly = true; textbox2.readonly = true; textbox4.readonly = true; textbox5.readonly = true; textbox6.readonly = true; public void noreal() textbox1.readonly = false; textbox2.readonly = fals

32、e; textbox4.readonly = false; textbox5.readonly = false; textbox6.readonly = false; private void classmessage_load(object sender, eventargs e) this.windowstate = formwindowstate.maximized; combox1(); u = new ebll.user(); datagridview1.datasource = u.classmessage_select(); real(); public void combox1

33、() u = new ebll.user(); dt = new datatable(); dt = u.profession_select(); for (int i = 0; i dt.rows.count; i+) combobox1.items.add(dt.rowsi1); public void uimodel() /g = new emodel.grade(); / string id = (datarowview)this.bindingcontextdatagridview1.datasource.current)0.tostring(); int id = this.dat

34、agridview1.currentrow.index ; / dt = u.classmessage_select(classid= + id + ); textbox1.text = datagridview10,id.value.tostring(); textbox2.text = datagridview11, id.value.tostring(); combobox1.text = datagridview12, id.value.tostring(); textbox4.text = datagridview13, id.value.tostring(); textbox5.t

35、ext = datagridview14, id.value.tostring(); textbox6.text = datagridview15, id.value.tostring(); private void button4_click(object sender, eventargs e) u = new ebll.user(); button1.text = 添加; button2.text = 修改; string strwhere = classid like % + textbox7.text + %; datagridview1.datasource = u.classme

36、ssage_select(strwhere); private void button2_click(object sender, eventargs e) if (button2.text = 修改) noreal(); button2.text = 保存; button1.text = 添加; else u = new ebll.user(); g = new emodel.grade(); g.classname = textbox2.text; g.classid = textbox1.text; g.department = combobox1.text; g.classtea =

37、textbox4.text; g.fudaoyuan = textbox5.text; g.classmount = textbox6.text; u.classmessage_updata(g, (datarowview)this.bindingcontextdatagridview1.datasource.current)0.tostring(); messagebox.show(恭喜你，修改成功！); button2.text = 修改; classmessage_load(new object(), new eventargs(); private void panel2_paint(

38、object sender, painteventargs e) private void button1_click(object sender, eventargs e) if (button1.text = 添加) textbox1.text = ; textbox2.text = ; combobox1.text = ; textbox4.text = ; textbox5.text = ; textbox6.text = ; noreal(); button1.text = 保存; button2.text = 修改; else u = new ebll.user(); g = ne

39、w emodel.grade(); g.classname = textbox2.text; g.classid = textbox1.text; g.department = combobox1.text; g.classtea = textbox4.text; g.fudaoyuan = textbox5.text; g.classmount = textbox6.text; u.classmessage_add(g); messagebox.show(恭喜你，添加成功！); button1.text = 添加; classmessage_load(new object(), new ev

40、entargs(); private void button3_click(object sender, eventargs e) ebll.user u = new ebll.user(); dialogresult dlgresult; button1.text = 添加; button2.text = 修改; /int id=this.datagridview1.currentrow.index; /if (datagridview10, id.value.tostring() = null) / / messagebox.show(请选择所要删除的信息, 确认, messageboxb

41、uttons.ok); / /else / dlgresult = messagebox.show(确实要删除该记录吗？, 确认, messageboxbuttons.yesno); if (dlgresult = dialogresult.yes) u.classmessage_delete(datarowview)this.bindingcontextdatagridview1.datasource.current)0.tostring(); / classmessage_load(new object(), new eventargs(); private void datagridvi

42、ew1_cellenter(object sender, datagridviewcelleventargs e) uimodel(); private void button5_click(object sender, eventargs e) savefiledialog savefiledialog = new savefiledialog(); savefiledialog.filter = execl files (*.xls)|*.xls; savefiledialog.filterindex = 0; savefiledialog.restoredirectory = true;

43、 savefiledialog.createprompt = true; savefiledialog.title = 导出excel文件到; datetime now = datetime.now; savefiledialog.filename = now.year.tostring().padleft(2) + now.month.tostring().padleft(2, 0) + now.day.tostring().padleft(2, 0) + - + now.hour.tostring().padleft(2, 0) + now.minute.tostring().padleft(2, 0) + now.