Visual C#.NET+Access教务管理系统任务书+论文+源代码

三三级级实实践践课课题题设设计计任任务务书书 姓姓 名名 软件技术编码 专业 班 题题 目目教务管理系统 设设 计计 任任 务务 开发一个比较完善的基于 b s 结构或 c s 结构的教务管理系统 主要功能包括 1 教务人员排课 调课 汇总各类考试成绩 2 学生选课 查看考试成绩及选课情况 3 管理员管理各类用户基本信息 以及各类查询统计等功能 4 一般教师查看课程表 打印学生名单 录入考试成绩 要求 具有教务的完整功能 界面操作合理 人性化 每个组员工作量都要饱满 数据 库设计及代码符合规范 文档完整 规范 要求各类用户可根据条件生成各种类型的报表 方便管理 时时 间间 进进 度度 第 17 周 09 12 25 09 12 31 第 18 周 10 01 01 10 01 7 第 19 周 10 01 8 10 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 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 formvisible 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 MdiParent 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 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 计算器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 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 object 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 SplitterEventArgs 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 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 false 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 TeaMessage Select real public void UIModel t new EModel Teacher string Id DataRowView this BindingContext dataGridView1 DataSource Current 0 ToString dt u TeaMessage Select teaid Id int id this dataGridView1 CurrentRow Index textBox24 Text dataGridView1 0 id Value ToString textBox23 Text dataGridView1 1 id Value ToString comboBox2 Text dataGridView1 2 id Value ToString if dataGridView1 3 id Value ToString dateTimePicker4 Value DateTime Parse dataGridView1 3 id Value ToString textBox13 Text dataGridView1 4 id Value ToString textBox22 Text dataGridView1 5 id Value ToString textBox21 Text dataGridView1 6 id Value ToString textBox20 Text dataGridView1 7 id Value ToString textBox19 Text dataGridView1 8 id Value ToString textBox18 Text dataGridView1 9 id Value ToString if dataGridView1 10 id Value ToString dateTimePicker3 Value DateTime Parse dataGridView1 10 id Value ToString textBox17 Text dataGridView1 11 id Value ToString textBox16 Text dataGridView1 12 id Value ToString textBox15 Text dataGridView1 13 id Value ToString textBox14 Text dataGridView1 14 id Value ToString private 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 修改 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 textBox21 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 BindingContext dataGridView1 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 textBox22 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 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 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 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 添加 button2 Text 修改 int id this dataGridView1 CurrentRow Index if dataGridView1 0 id Value ToString null MessageBox Show 请选择所要删除的信息 确认 MessageBoxButtons OK else dlgresult MessageBox Show 确实要删除该记录吗 确认 MessageBoxButtons YesNo if dlgresult DialogResult Yes u TeaMessage Delete DataRowView this BindingContext dataGridView1 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 saveFileDialog 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 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 try 写标题 for int i 0 i 0 str t str dataGridView1 Columns i 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 Rows j Cells k Value ToString sw WriteLine tempStr 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 button1 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 splitContainer1 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 textBox2 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 public void combox1 u new EBLL User dt new DataTable dt u Profession Select for int i 0 i dt Rows Count i comboBox1 Items Add dt Rows i 1 public void UIModel g new EModel grade string Id DataRowView this BindingContext dataGridView1 DataSource Current 0 ToString int id this dataGridView1 CurrentRow Index dt u ClassMessage Select classid Id textBox1 Text dataGridView1 0 id Value ToString textBox2 Text dataGridView1 1 id Value ToString comboBox1 Text dataGridView1 2 id Value ToString textBox4 Text dataGridView1 3 id Value ToString textBox5 Text dataGridView1 4 id Value ToString textBox6 Text dataGridView1 5 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 ClassMessage 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 textBox4 Text g fudaoyuan textBox5 Text g classmount textBox6 Text u ClassMessage Updata g DataRowView this BindingContext dataGridView1 DataSource Current 0 ToString MessageBox Show 恭喜你 修改成功 button2 Text 修改 ClassMessage Load new object new EventArgs private void panel2 Paint 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 new 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 EventArgs 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 dataGridView1 0 id Value ToString null MessageBox Show 请选择所要删除的信息 确认 MessageBoxButtons OK else dlgresult MessageBox Show 确实要删除该记录吗 确认 MessageBoxButtons YesNo if dlgresult DialogResult Yes u ClassMessage Delete DataRowView this BindingContext dataGridView1 DataSource Current 0 ToString ClassMessage Load new object new EventArgs private void dataGridView1 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 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