学生成绩管理系统运行说明附代码.docx

1、学生成绩管理系统运行说明附代码金融信息系统设计课程设计运行说明题目：学生成绩管理系统班级：XXXXXXXX指导教师：XXXX小组成员：XXXXXXXXXXXX1. Program.csusing System;using System.Collections.Generic;using System.Linq;using System.Windows.Forms;namespace GradeMIS static class Program / / 应用程序的主入口点。 / STAThread static void Main() Application.EnableVisualStyles(

2、); Application.SetCompatibleTextRenderingDefault(false); Application.Run(new Main(); 2. Main.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.Sql;using S

3、ystem.Data.SqlClient;namespace GradeMIS public partial class Main : Form public Main() InitializeComponent(); private void Main_Load(object sender, EventArgs e) Login login = new Login(); login.ShowDialog(); /用户卡片/调用Login.cs中的name变量，并赋给cuname的text值 this.cuname.Text = Login.name; /调用Login.cs中的rank变量，

4、并赋给cuiden的text值this.cuiden.Text = Login.rank;/调用Login.cs中的num变量，并赋给cuID的text值 this.cuID.Text = Login.num; this.label6.Text = System.DateTime.Now.ToString(yy-MM-dd hh:mm); /菜单栏“学生管理”选项 private void 查看学生信息ToolStripMenuItem_Click(object sender, EventArgs e) StuInfo sInfo = new StuInfo(); sInfo.Show();

5、private void 添加学生信息ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 更新学生信息ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 删除学生信息ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); /菜单栏“教师管理”选项 private void 查看教师信息ToolStripMenuItem_Click(object

6、sender, EventArgs e) TeacInofo tInfo = new TeacInofo(); tInfo.Show(); private void 添加教师信息ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 更新教师信息ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 删除教师信息ToolStripMenuItem_Click(object sender, EventArgs e) D

7、eve(); /菜单栏“成绩管理”选项 private void 成绩查询ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 申请查分ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 成绩录入ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 修改成绩ToolStripMenuItem_Click(object s

8、ender, EventArgs e) Deve(); /菜单栏“帮助”选项 private void 技术支持ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 关于系统ToolStripMenuItem_Click(object sender, EventArgs e) Deve(); private void 联系我们ToolStripMenuItem_Click(object sender, EventArgs e) Touch t = new Touch(); t.Show(); /弹出“开

9、发中”窗口 static void Deve() Developing d = new Developing(); d.Show(); 3. Login.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.Sql;using System.Data.SqlCl

10、ient;namespace GradeMIS public partial class Login : Form static public string num, name, rank; / public Login() InitializeComponent(); /“取消按钮”退出应用程序 private void cancelbtn_Click(object sender, EventArgs e) Application.Exit(); /“登录按钮”验证用户身份、账号和密码均正确后方成功登录 private void loginbtn_Click(object sender, E

11、ventArgs e) /连接数据库 string sql = Data Source=.;Initial Catalog=GradeDB;Persist Security Info=True;User ID=sa;Password=123456; SqlConnection conn = new SqlConnection(sql); conn.Open(); /学生身份登录验证 if (student.Checked) string cstr = select * from Users where Type=学生and ID= + txt1.Text + and PWD= + txt2.T

12、ext + ; SqlCommand comm = new SqlCommand(cstr, conn); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read() /将对象的编号赋给变量num，以便在Main.cs中显示当前用户编号num = dr0.ToString();/将对象的名字赋给变量name，以便在Main.cs中显示当前用户姓名 name = dr1.ToString(); /将对象的身份类型赋给变量rank，以便在Main.cs中显示用户身份 rank = dr3.ToString(); this.Close(); else

13、 MessageBox.Show(用户名或密码错误，请重新输入！); txt1.Text = ; /清空账户 txt2.Text = ; /清空密码 /教师身份登录验证 if (teacher.Checked) string cstr = select * from Users where Type=教师and ID= + txt1.Text + and PWD= + txt2.Text + ; SqlCommand comm = new SqlCommand(cstr, conn); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read()

14、 num = dr0.ToString(); name = dr1.ToString(); rank = dr3.ToString(); this.Close(); else MessageBox.Show(用户名或密码错误，请重新输入！); txt1.Text = ; txt2.Text = ; /管理员身份登录验证 if (admin.Checked) string cstr = select count(*) from Users where Type=管理员and ID= + txt1.Text + and PWD= + txt2.Text + ; SqlCommand comm =

15、new SqlCommand(cstr, conn); SqlDataReader dr = comm.ExecuteReader(); if (dr.Read() num = dr0.ToString(); name = 郭涛; rank = 管理员; this.Close(); else MessageBox.Show(用户名或密码错误，请重新输入！); txt1.Text = ; txt2.Text = ; conn.Close(); conn.Dispose(); 4. StuInfo.csusing System;using System.Collections.Generic;us

16、ing System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;using System.Data.Sql;using System.Data.SqlClient;namespace GradeMIS public partial class StuInfo : Form public StuInfo() InitializeComponent(); private void StuInfo_Load(o

17、bject sender, EventArgs e) / TODO: 这行代码将数据加载到表“stuInfoDataSet.Student”中。您可以根据需要移动或移除它。 this.studentTableAdapter.Fill(this.stuInfoDataSet.Student); 5. TeacInfo.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using Sy

18、stem.Text;using System.Windows.Forms;namespace GradeMIS public partial class TeacInofo : Form public TeacInofo() InitializeComponent(); private void TeacInofo_Load(object sender, EventArgs e) / TODO: 这行代码将数据加载到表“teacDataSet.Course”中。您可以根据需要移动或移除它。 this.courseTableAdapter.Fill(this.teacDataSet.Course

19、); 6. Touch.csusing System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace GradeMIS public partial class Touch : Form public Touch() InitializeComponent(); 7. Developing.csusi

20、ng System;using System.Collections.Generic;using System.ComponentModel;using System.Data;using System.Drawing;using System.Linq;using System.Text;using System.Windows.Forms;namespace GradeMIS public partial class Developing : Form public Developing() InitializeComponent(); 8. 运行说明8.1 登录界面启动程序，主界面加载时

21、弹出登录界面，由身份、账号及密码三部分组成。如下图所示。8.2 主界面完成身份验证以确保是系统用户后，进入主界面。主界面可显示当前用户的姓名、身份、编号及管理时间。如下图所示。8.3 学生管理相应界面在菜单栏中单击【学生管理】，显示有选项【查看学生信息】、【添加学生信息】、【更新学生信息】和【删除学生信息】。如下图所示。单击【查看学生信息】，弹出教师基本信息窗口。如下图所示。8.4 教师管理相应界面在菜单栏中单击【教师管理】，显示有选项【查看教师信息】、【添加教师信息】、【更新教师信息】和【删除教师信息】。如下图所示。单击【查看教师信息】，弹出教师基本信息窗口。如下图所示。8.5 成绩管理相应界面在菜单栏中单击【成绩管理】，显示有选项【成绩查询】、【申请查分】、【成绩录入】、【修改成绩】和【分析与统计】。如下图所示。8.6 帮助界面在菜单栏中单击【帮助】，显示有选项【技术支持】、【关于系统】和【联系我们】。如下图所示。单击【联系我们】，弹出联系窗口。如下图所示。8.7 Other界面由于其它功能模块还在开发中，若选中未开发完的菜单栏选项，会弹出道歉窗口。如下图所示。