《毕业设计（论文）-Visual C#.NET Access教务管理系统.doc》由会员分享，可在线阅读，更多相关《毕业设计（论文）-Visual C#.NET Access教务管理系统.doc（36页珍藏版）》请在三一文库上搜索。
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.Diagnost
8、ics.Process.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(obj
9、ect sender, 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, Splitt
10、erEventArgs e) 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
11、= true; textBox16.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 = f
12、alse; textBox18.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.Tea
13、Message_Select(“); 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.ToS
14、tring(); textBox23.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(); textBox2
15、2.Text = dataGridView15,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() !=
16、 “) dateTimePicker3.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(); priv
17、ate void button4_Click(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
18、= “修改“) noreal(); button2.Text = “保存“; 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 = textB
19、ox21.Text; t.xueli = textBox20.Text; t.profession = 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.Bind
20、ingContextdataGridView1.DataSource.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 = “; textB
21、ox22.Text = “; textBox21.Text = “; textBox20.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.T
22、ext; 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.Text; t.profession = textBox19.Text; t.graduateschool = textBox18.Text; t.graduatetime = dateTimePicke
23、r3.Value; t.telephone = textBox17.Text; t.address = textBox16.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 =
24、new EBLL.User(); DialogResult dlgresult; button1.Text = “添加“; button2.Text = “修改“; /int id=this.dataGridView1.CurrentRow.Index; /if (dataGridView10, id.Value.ToString() = null) / / MessageBox.Show(“请选择所要删除的信息“, “确认“, MessageBoxButtons.OK); / /else / dlgresult = MessageBox.Show(“确实要删除该记录吗？“, “确认“, Me
25、ssageBoxButtons.YesNo); if (dlgresult = DialogResult.Yes) u.TeaMessage_Delete(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
26、SaveFileDialog(); saveFileDialog.Filter = “Execl files (*.xls)|*.xls“; saveFileDialog.FilterIndex = 0; saveFileDialog.RestoreDirectory = true; saveFileDialog.CreatePrompt = true; saveFileDialog.Title = “导出Excel文件到“; DateTime now = DateTime.Now; saveFileDialog.FileName = now.Year.ToString().PadLeft(2
27、) + 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.Second.ToString().PadLeft(2, 0); saveFileDialog.ShowDialog(); Stream myStream; myStream = saveFileDialog.OpenFile(); StreamWriter sw = new S
28、treamWriter(myStream, System.Text.Encoding.GetEncoding(“gb2312“); string str = “; try /写标题 for (int i = 0; i 0) str += “t“; str += dataGridView1.Columnsi.HeaderText; sw.WriteLine(str); /写内容 for (int j = 0; j 0) tempStr += “t“; tempStr += dataGridView1.Rowsj.Cellsk.Value.ToString(); sw.WriteLine(temp
29、Str); sw.Close(); 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(); b
30、utton1.Text = “添加“; 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 splitC
31、ontainer1_Panel1_Paint(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; text
32、Box2.ReadOnly = false; 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()
33、; public void combox1() u = new EBLL.User(); dt = new DataTable(); dt = u.Profession_Select(“); for (int i = 0; i 0) str += “t“; str += dataGridView1.Columnsi.HeaderText; sw.WriteLine(str); /写内容 for (int j = 0; j 0) tempStr += “t“; tempStr += dataGridView1.Rowsj.Cellsk.Value.ToString(); sw.WriteLine
34、(tempStr); sw.Close(); myStream.Close(); catch (Exception ex) MessageBox.Show(ex.ToString(); finally sw.Close(); myStream.Close(); private void button6_Click(object sender, EventArgs e) print p = new print(); p.DT(dataGridView1); p.ShowDialog(); 信息发布代码如下： namespace EduManagement public partial class
35、 MessageSort : Form public MessageSort() InitializeComponent(); EBLL.User u; private void button18_Click(object sender, EventArgs e) if (textBox10.Text = “) MessageBox.Show(“请写入发布主题！“); else if (richTextBox1.Text.Trim() = “) MessageBox.Show(“请写入发布内容！“); else string var = DateTime.Now.ToString(), “管理
36、员“, textBox10.Text.Trim().ToString(), richTextBox1.Text.Trim().ToString() ; try u = new EBLL.User(); u.Message_Add(var); MessageBox.Show(“消息发布成功！“); textBox10.Clear(); richTextBox1.Clear(); catch (Exception ex) MessageBox.Show(ex.Message); private void MessageSort_Load(object sender, EventArgs e) this.WindowState = FormWindowState.Maximized; 成绩：