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

1、金融信息系统设计课程设计运行说明题目：学生成绩管理系统班级：XXXXXXXX指导教师：XXXX小组成员：XXXXXXXXXXXX目录1. Program.cs.1.2. Main.cs2.3. Login.cs5.4. Stulnfo.cs8.5. TeacInfo.cs9.6. Touch.cs.107. Developing.cs.1.1.8. 运行说明.128.1登录界面128.2主界面128.3学生管理相应界面128.4教师管理相应界面138.5成绩管理相应界面148.6帮助界面148.7 Other 界面141. Program .csusing System;using Syste

2、m.Collect ion s.Ge neric;using System.L inq;using System.Wi ndows.Forms;n amespace GradeMISstatic class Program/ /应用程序的主入口点。/ STAThreadstatic void Main()Application .EnableVisualStyles();Application .SetCompatibleTextRenderingDefault( false);Application .Run(new Main ();2. Main .csusing System;using

3、 System.Collect ion s.Ge neric;using System.Comp onen tModel;using System.Data;using System.Draw ing;using System.L inq;using System.Text;using System.Wi ndows.Forms;using System.Data.Sql;using System.Data.SqlClie nt;n amespace GradeMISpublic partial class Main : Formpublic Mai n()In itializeComp on

4、en t();private void Main_Load( object sender, EventArgs e)Login login = new Login ();logi n.ShowDialog();/用户卡片II调用Login.cs中的name变量，并赋给cuname的text值 this.c un ame.Text = Log in .n ame;II调用Login.cs中的rank变量，并赋给cuiden的text值 this.cuide n. Text = Log in.rank;II调用Login.cs中的num变量，并赋给culD的text值 this.culD.Text

5、 = Log in .num;this.label6.Text = System.DateTime .Now.ToString( yy-MM-dd hh:mm);菜单栏“学生管理”选项private void 查看学生信息 ToolStripMenultem_Click( object sender, EventArgs e) Stul nfo slnfo = new Stul nfo();sl nfo.Show();private void 添加学生信息 ToolStripMenultem_Click( object sender, EventArgs e)Deve();private vo

6、id 更新学生信息 ToolStripMenultem_Click( object sender, EventArgs e) Deve();private void 删除学生信息 ToolStripMenultem_Click( object sender, EventArgs e) Deve();菜单栏“教师管理”选项private void 查看教师信息 ToolStripMenultem_Click( object sender, EventArgs e) TeacInofo tlnfo = new TeacInofo();tIn fo.Show();private void 添加教师信

7、息 ToolStripMenultem_Click( object sender, EventArgs e) Deve();private void 更新教师信息 ToolStripMenultem_Click( object sender, EventArgs e) Deve();private void 删除教师信息 ToolStripMenultem_Click( object sender, EventArgs e) Deve();菜单栏“成绩管理”选项private void 成绩查询 ToolStripMenultem_Click( object sender, EventArgs

8、 e) Deve();private void 申请查分 ToolStripMenultem_Click( object sender, EventArgs e)Deve();private void 成绩录入 ToolStripMenultem_Click( object sender, EventArgs e) Deve();private void 修改成绩 ToolStripMenultem_Click( object sender, EventArgs e) Deve();/菜单栏“帮助”选项private void 技术支持 ToolStripMenultem_Click( obj

9、ect sender, EventArgs e) Deve();private void 关于系统 ToolStripMenultem_Click( object sender, EventArgs e) Deve();private void 联系我们 ToolStripMenultem_Click( object sender, EventArgs e) Touch t = new Touch();t.Show();弹出“开发中”窗口static void Deve()Developing d = new Developing ();d.Show();3 Login .csusing Sy

10、stem;using System.Collect ion s.Ge neric;using System.Comp onen tModel;using System.Data;using System.Draw ing;using System.L inq;using System.Text;using System.Wi ndows.Forms;using System.Data.Sql;using System.Data.SqlClie nt;n amespace GradeMISpublic partial class Log in : Formstatic public string

11、 num, name, rank;/public Logi n()In itializeComp onen t();/ “取消按钮”一一退出应用程序private void cancelbtn_Click( object sender, EventArgs e)Application .Exit();/ “登录按钮”一一验证用户身份、账号和密码均正确后方成功登录private void loginbtn_Click( object sender, EventArgs e)/连接数据库stri ng sql = Data Source=.;I nitial Catalog=GradeDB;Per

12、sist SecurityIn fo=True;User ID=sa;Password=123456;SqlC onn ecti on conn = new SqlC onnection (sql);conn. Ope n();/学生身份登录验证if (stude nt.Checked)string cstr = select * from Users where Type= 学生and ID= + txt1.Text +and PWD= + txt2.Text + ”;SqlComma nd comm = new SqlComma nd(cstr, conn);SqlDataReader d

13、r = comm.ExecuteReader();if (dr.Read()将对象的编号赋给变量num,以便在Main.cs中显示当前用户编号 num = dr0.ToStri ng();将对象的名字赋给变量name，以便在Main.cs中显示当前用户姓名 n ame = dr1.ToStri ng();将对象的身份类型赋给变量rank，以便在Main.cs中显示用户身份 rank = dr3.ToStri ng();this.Close();elseMessageBox.Show(用户名或密码错误，请重新输入！); txt1.Text = ;/ 清空账户txt2.Text = ;/清空密码/

14、教师身份登录验证if (teacher.Checked)and PWD=string cstr = select * from Users where Type= 教#and ID= + txtl.Text + + txt2.Text + ”;SqlComma nd comm = new SqlComma nd(cstr, conn);SqlDataReader dr = comm.ExecuteReader();if (dr.Read()num = dr0.ToStri ng();n ame = dr1.ToStri ng();rank = dr3.ToStri ng();this.Clos

15、e();elseMessageBox.Show(用户名或密码错误，请重新输入！);txtl.Text =;txt2.Text =;/管理员身份登录验证if (adm in. Checked)txtl.Text +string cstr = select count(*) from Users where Type=管理员and ID= + and PWD= + txt2.Text + ”;SqlComma nd comm = new SqlComma nd(cstr, conn);SqlDataReader dr = comm.ExecuteReader();if (dr.Read()num

16、= dr0.ToStri ng();name =郭涛;rank =管理员;this.Close();elseMessageBox.Show(用户名或密码错误，请重新输入！);txt1.Text =;txt2.Text =;conn .Close();conn .Dispose。；4. Stulnfo .csusing System;using System.Collect ion s.Ge neric;using System.Comp onen tModel;using System.Data;using System.Draw ing;using System.L inq;using Sy

17、stem.Text;using System.Wi ndows.Forms;using System.Data.Sql;using System.Data.SqlClie nt;n amespace GradeMISpublic partial class Stulnfo : Formpublic StuI nfo()In itializeComp onen t();private void Stulnfo_Load( object sender, EventArgs e)/ TODO:这行代码将数据加载到表“ stuInfoDataSet.Student”中。您可以根 据需要移动或移除它。t

18、his.studentTableAdapter.Fill( this.stuInfoDataSet.Student);5. Teaclnf o.csusing System;using System.Collect ion s.Ge neric;using System.Comp onen tModel;using System.Data;using System.Draw ing;using System.L inq;using System.Text;using System.Wi ndows.Forms;n amespace GradeMISpublic partial class Te

19、acInofo : Formpublic Teac lnofo()In itializeComp onen t();private void TeacInofo_Load( object sender, EventArgs e)II TODO:这行代码将数据加载到表“ teacDataSet.Course”中。您可以根据需 要移动或移除它。this.courseTableAdapter.Fill( this.teacDataSet.Course);6 Touch .csusing System;using System.Collect ion s.Ge neric;using System.C

20、omp onen tModel;using System.Data;using System.Draw ing;using System.L inq;using System.Text;using System.Wi ndows.Forms;n amespace GradeMISpublic partial class Touch : Formpublic Touch()In itializeComp onen t();7. Developing .csusing System;using System.Collect ion s.Ge neric;using System.Comp onen

21、 tModel;using System.Data;using System.Draw ing;using System.L inq;using System.Text;using System.Wi ndows.Forms;n amespace GradeMISpublic partial class Developing : Formpublic Develop in g()In itializeComp onen t();8.运行说明&1登录界面启动程序，主界面加载时弹出登录界面，由身份、账号及密码三部分组成。 如下图所示。&2主界面完成身份验证以确保是系统用户后，进入主界面。主界面可显示当前用户的姓名、身份、编号及管理时间。如下图所示。&3学生管理相应界面在菜单栏中单击【学生管理】，显示有选项【查看学生信息】、【添加学生信息】、【更新 学生信息】和【删除学生信息】。如下图所