学生成绩管理系统设计说明书(3)

重庆三峡学院

{

InitializeComponent(); }

private void treeView1_AfterSelect(object sender, TreeViewEventArgs e) {

switch (e.Node.Text) {

case \学生信息\

shouwStudentInfo(); break;

case \班级信息\

shouwClassInfo(); break;

case \课程信息\

shouwCoureinfo(); break;

case \成绩信息\

shouwScoreInfo(); break; } }

private void shouwStudentInfo() {

Student stu = new Student();

DataSet stuInfo;

stuInfo = stu.selectAll();

dataGridView1.DataSource = stuInfo; dataGridView1.DataMember = \ }

private void shouwClassInfo() {

Classinfo cla = new Classinfo();

DataSet claInfo;

claInfo = cla.selectAll();

dataGridView1.DataSource = claInfo; dataGridView1.DataMember = \

共 42 页 第 10 页

重庆三峡学院

}

private void shouwCoureinfo() {

Course cou = new Course();

DataSet couInfo;

couInfo = cou.selectAll();

dataGridView1.DataSource = couInfo; dataGridView1.DataMember = \ }

private void shouwScoreInfo() {

Score sco = new Score();

DataSet scoInfo;

scoInfo = sco.selectAll();

dataGridView1.DataSource = scoInfo; dataGridView1.DataMember = \ }

private void 插入数据ToolStripMenuItem_Click(object sender, EventArgs e) {

InsertFrom from = new InsertFrom(); from.Show(); }

private void 删除数据ToolStripMenuItem_Click(object sender, EventArgs e) {

DeleteForm from = new DeleteForm(); from.Show(); }

private void 修改数据ToolStripMenuItem_Click(object sender, EventArgs e) {

ModifyForm from = new ModifyForm(); from.Show(); }

private void 查询数据ToolStripMenuItem_Click(object sender, EventArgs e) {

SearchForm from = new SearchForm(); from.Show();

共 42 页 第 11 页

重庆三峡学院

}

private void 关于这个软件ToolStripMenuItem_Click(object sender, EventArgs e) {

MessageBox.Show(\作者信息:计Y052班 罗鑫 200502001071\\n\ } } }

1.2信息插入模块

namespace StudentManagerSys {

public partial class InsertFrom : Form {

//插入学生信息用到的数据 public string studnetno; public string studentname; public string sex; public string ative; public string address; public string birth;

//插入班级信息用到的数据 public string classno; public string depart; public string specical; public string studyears; public string entertime;

//插入课程信息用到的数据 public string courseno; public string coursename; public string coursetype; public string openterm; public string ccoursehours; public string credit;

//插入成绩信息需要的数据 public string score;

public InsertFrom() {

InitializeComponent();

共 42 页第 12 页

重庆三峡学院

}

//插入学生信息，确认按钮消息相应函数

private void button1_makesure_Click(object sender, EventArgs e) {

studnetno = textBox1.Text; studentname = textBox2.Text; if (comboBox1.Text == \男\ sex = \ else

sex = \

ative = textBox3.Text; address = textBox4.Text;

birth = dateTimePicker1.Value.ToString(\ Student stu = new Student();

stu.insert(studnetno, studentname, sex, birth, ative, address); this.Close(); }

//插入学生信息，重置按钮消息相应函数

private void button1_reset_Click(object sender, EventArgs e) {

textBox1.Text = \ textBox2.Text = \ textBox3.Text = \ textBox4.Text = \

dateTimePicker1.Text = \ comboBox1.Text = \男\ }

//插入班级信息，确认按钮消息相应函数

private void button1_Click(object sender, EventArgs e) {

classno = textBox5.Text; depart = textBox8.Text; specical = textBox9.Text; studyears = textBox6.Text;

entertime = dateTimePicker2.Value.ToString(\ Classinfo cla = new Classinfo();

cla.insert(classno, depart, specical, studyears, entertime); this.Close(); }

//插入班级信息，重置按钮消息相应函数

共 42 页 第 13 页

重庆三峡学院

private void button2_Click(object sender, EventArgs e) {

textBox5.Text = \ textBox8.Text = \ textBox9.Text = \ textBox6.Text = \

dateTimePicker2.Text = \ }

//插入课程信息，确认按钮消息相应函数

private void button4_Click(object sender, EventArgs e) {

courseno = textBox10.Text; coursename = textBox11.Text; coursetype = textBox12.Text; openterm = textBox13.Text; ccoursehours = textBox14.Text; credit = textBox15.Text;

Course cou = new Course();

cou.insert(courseno, coursename, coursetype, openterm, ccoursehours, credit); this.Close(); }

//插入课程信息，重置按钮消息相应函数

private void button3_Click(object sender, EventArgs e) {

textBox10.Text = \ textBox11.Text = \ textBox12.Text = \ textBox13.Text = \ textBox14.Text = \ textBox15.Text = \ }

//插入成绩信息，确认按钮消息相应函数

private void button6_Click(object sender, EventArgs e) {

courseno = textBox16.Text; studnetno = textBox17.Text; score = textBox18.Text; Score sco = new Score();

sco.insert(studnetno, courseno, score);

共 42 页 第 14 页

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库学生成绩管理系统设计说明书(3)在线全文阅读。