private void button1_Click(object sender, EventArgs e) { dao.resultDao dao = new dao.resultDao(); dao.courseDao cdao = new dao.courseDao(); dao.teacherDao tdao = new dao.teacherDao(); List <model.Course> rs = new List <model.Course>(); rs = cdao.selectNum1(teacher_login.tnumber); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("课程编号", typeof(string)); dt.Columns.Add("课程名称", typeof(string)); dt.Columns.Add("教师", typeof(string)); dt.Columns.Add("上课地点", typeof(string)); dt.Columns.Add("时间", typeof(string)); dt.Columns.Add("课时", typeof(string)); dt.Columns.Add("学分", typeof(string)); dt.Columns.Add("类型", typeof(string)); foreach (model.Course r1 in rs) { model.Teacher t = new model.Teacher(); t = tdao.selectNum2(teacher_login.tnumber); Console.WriteLine("2:" + r1.Course_num); Console.WriteLine("3:" + r1.Course_name); Console.WriteLine("4:" + r1.Type); Console.WriteLine("5:" + t.Teacher_name); Console.WriteLine("6:" + r1.Credit_hour); Console.WriteLine("7:" + r1.Type); dt.Rows.Add(r1.Course_num, r1.Course_name, t.Teacher_name, r1.Address, r1.Time_week, r1.Time_jie, r1.Credit_hour, r1.Type); } dataGridView2.DataSource = dt; }
private void button3成绩_Click(object sender, EventArgs e) { MessageBoxButtons messButton = MessageBoxButtons.OKCancel; DialogResult dr = MessageBox.Show("是否确认提交?", "提交", messButton); if (dr == DialogResult.OK) { string course = comboBox1成绩.Text; dao.resultDao rdao = new dao.resultDao(); string[] c = course.Split(' '); string cour = c[0]; bool b = true; for (int i = 0; i < dataGridView1成绩.Rows.Count; i++) { try { rdao.updateScore(dataGridView1成绩.Rows[i].Cells[0].Value.ToString(), cour, dataGridView1成绩.Rows[i].Cells[3].Value.ToString(), Convert.ToDouble(dataGridView1成绩.Rows[i].Cells[4].Value)); } catch (SystemException) { MessageBox.Show("格式错误!"); b = false; } } if (b == true) { MessageBox.Show("提交成功"); } } else { } }
private void search_Click(object sender, EventArgs e) { dao.resultDao dao = new dao.resultDao(); dao.studentDao sdao = new dao.studentDao(); List <model.Result> rs = new List <model.Result>(); rs = dao.selectStudent(textBox1.Text, comboBox1.Text, comboBox2.Text);//学生编号s List <model.Student> s = new List <model.Student>(); s = sdao.selectStudent(rs);//根据学生编号s查询出所有的学生信息 DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("学号", typeof(string)); dt.Columns.Add("性别", typeof(String)); dt.Columns.Add("学院", typeof(string)); dt.Columns.Add("专业", typeof(String)); dt.Columns.Add("年级", typeof(String)); dt.Columns.Add("班级", typeof(String)); foreach (model.Student a in s) { dt.Rows.Add(a.Student_name, a.Id_number, a.Sex, a.Student_academy, a.Profession, a.Student_grade, a.Classs); } dataGridView1.DataSource = dt; }
//录入成绩 private void button1成绩_Click(object sender, EventArgs e) { string course = comboBox1成绩.Text; if (course == "") { MessageBox.Show("请选择需要录入的课程!"); } else { dataGridView1成绩.Rows.Clear(); //coursedao cdao = new coursedao(); string[] c = course.Split(' '); string cour = c[0]; dao.resultDao rdao = new dao.resultDao(); List <model.Result> rs = new List <model.Result>(); rs = rdao.selectResult(cour); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dao.studentDao sdao = new dao.studentDao(); Console.WriteLine("姚雅丽"); dt.Columns.Add("学号", typeof(string)); dt.Columns.Add("姓名", typeof(string)); dt.Columns.Add("性别", typeof(string)); dt.Columns.Add("类型", typeof(string)); dt.Columns.Add("成绩", typeof(string)); foreach (DataGridViewColumn co in dataGridView1成绩.Columns) { if (co.Index != 4 && co.Index != 3) { co.ReadOnly = true; } } foreach (model.Result r in rs) { model.Student s = new model.Student(); s = sdao.selectNum(r.Student_num); dataGridView1成绩.Rows.Add(r.Student_num, s.Student_name, s.Sex, "", ""); } } }
private void teacher_home_Load(object sender, EventArgs e) { Timer = new Timer();//显示当前时间 Timer.Interval = 1000; Timer.Tick += new EventHandler(Timer_Tick); Timer.Start(); panel7成绩.Visible = false; dao.resultDao rdao = new dao.resultDao(); dao.courseDao cdao = new dao.courseDao(); List <model.Course> cs = new List <model.Course>(); cs = cdao.selecttc(teacher_login.tnumber); foreach (model.Course r1 in cs) { model.Course c = new model.Course(); c = cdao.selectNum(r1.Course_num); //Console.WriteLine(c.Course_num + " " + c.Course_name + c.Time_week + c.Time_jie); comboBox1成绩.Items.Add(c.Course_num + " " + c.Course_name + c.Time_week + c.Time_jie); } }
private void button1课表_Click(object sender, EventArgs e) { dao.resultDao dao = new dao.resultDao(); dao.courseDao cdao = new dao.courseDao(); dao.teacherDao tdao = new dao.teacherDao(); List <model.Result> rs = new List <model.Result>(); rs = dao.selectAll1(student_login.number, comboBox1课表.Text, comboBox2课表.Text); Console.WriteLine(comboBox1课表.Text); Console.WriteLine(comboBox2课表.Text); // DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("代码", typeof(string)); dt.Columns.Add("课程编号", typeof(string)); dt.Columns.Add("课程名称", typeof(string)); dt.Columns.Add("教师", typeof(string)); dt.Columns.Add("学分", typeof(string)); dt.Columns.Add("类型", typeof(string)); dt.Columns.Add("学年", typeof(string)); dt.Columns.Add("学期", typeof(string)); foreach (model.Result r1 in rs) { model.Course c = new model.Course(); c = cdao.selectNum(r1.Course_num); model.Teacher t = new model.Teacher(); t = tdao.selectNum(c.Teacher_num); Console.WriteLine(r1.Result_num); Console.WriteLine(c.Type); Console.WriteLine(c.Course_num); Console.WriteLine(c.Type); Console.WriteLine(r1.Year); Console.WriteLine(r1.Term); dt.Rows.Add(r1.Result_num, c.Course_num, c.Course_name, t.Teacher_name, c.Credit_hour, c.Type, r1.Year, r1.Term); } dataGridView1课表.DataSource = dt; }
private void button1成绩_Click(object sender, EventArgs e) { dao.resultDao dao = new dao.resultDao(); dao.courseDao cdao = new dao.courseDao(); dao.teacherDao tdao = new dao.teacherDao(); List <model.Result> rs = new List <model.Result>(); if (checkBox2成绩.Checked == false && checkBox1成绩.Checked == false) { rs = dao.selectAll(student_login.number, comboBox1成绩.Text, comboBox2成绩.Text); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("代码", typeof(string)); dt.Columns.Add("课程名称", typeof(string)); dt.Columns.Add("性质", typeof(String)); dt.Columns.Add("教师", typeof(string)); dt.Columns.Add("学分", typeof(String)); dt.Columns.Add("成绩", typeof(String)); dt.Columns.Add("类型", typeof(String)); dt.Columns.Add("学年", typeof(String)); dt.Columns.Add("学期", typeof(String)); foreach (model.Result r1 in rs) { if (r1.Score != double.NaN) { model.Course c = new model.Course(); c = cdao.selectNum(r1.Course_num); model.Teacher t = new model.Teacher(); t = tdao.selectNum(c.Teacher_num); dt.Rows.Add(r1.Result_num, c.Course_name, c.Type, t.Teacher_name, c.Credit_hour, r1.Score, r1.Type, r1.Year, r1.Term); } } dataGridView1成绩.DataSource = dt; } else if (checkBox1成绩.Checked == true && checkBox2成绩.Checked == false) { rs = dao.select1(student_login.number, comboBox1成绩.Text, comboBox2成绩.Text); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("代码", typeof(string)); dt.Columns.Add("课程名称", typeof(string)); dt.Columns.Add("性质", typeof(String)); dt.Columns.Add("教师", typeof(string)); dt.Columns.Add("学分", typeof(String)); dt.Columns.Add("成绩", typeof(String)); dt.Columns.Add("类型", typeof(String)); dt.Columns.Add("学年", typeof(String)); dt.Columns.Add("学期", typeof(String)); foreach (model.Result r1 in rs) { if (r1.Score != double.NaN) { model.Course c = new model.Course(); c = cdao.selectNum(r1.Course_num); model.Teacher t = new model.Teacher(); t = tdao.selectNum(c.Teacher_num); dt.Rows.Add(r1.Result_num, c.Course_name, c.Type, t.Teacher_name, c.Credit_hour, r1.Score, r1.Type, r1.Year, r1.Term); } } dataGridView1成绩.DataSource = dt; } else if (checkBox1成绩.Checked == false && checkBox2成绩.Checked == true) { rs = dao.select2(student_login.number, comboBox1成绩.Text, comboBox2成绩.Text); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("代码", typeof(string)); dt.Columns.Add("课程名称", typeof(string)); dt.Columns.Add("性质", typeof(String)); dt.Columns.Add("教师", typeof(string)); dt.Columns.Add("学分", typeof(String)); dt.Columns.Add("成绩", typeof(String)); dt.Columns.Add("类型", typeof(String)); dt.Columns.Add("学年", typeof(String)); dt.Columns.Add("学期", typeof(String)); foreach (model.Result r1 in rs) { if (r1.Score != double.NaN) { model.Course c = new model.Course(); c = cdao.selectNum(r1.Course_num); model.Teacher t = new model.Teacher(); t = tdao.selectNum(c.Teacher_num); dt.Rows.Add(r1.Result_num, c.Course_name, c.Type, t.Teacher_name, c.Credit_hour, r1.Score, r1.Type, r1.Year, r1.Term); } } dataGridView1成绩.DataSource = dt; } else if (checkBox1成绩.Checked == true && checkBox2成绩.Checked == true) { rs = dao.select3(student_login.number, comboBox1成绩.Text, comboBox2成绩.Text); DataSet ds = new DataSet(); DataTable dt = new DataTable("Table_New"); dt.Columns.Add("代码", typeof(string)); dt.Columns.Add("课程名称", typeof(string)); dt.Columns.Add("性质", typeof(String)); dt.Columns.Add("教师", typeof(string)); dt.Columns.Add("学分", typeof(String)); dt.Columns.Add("成绩", typeof(String)); dt.Columns.Add("类型", typeof(String)); dt.Columns.Add("学年", typeof(String)); dt.Columns.Add("学期", typeof(String)); foreach (model.Result r1 in rs) { if (r1.Score != double.NaN) { model.Course c = new model.Course(); c = cdao.selectNum(r1.Course_num); model.Teacher t = new model.Teacher(); t = tdao.selectNum(c.Teacher_num); dt.Rows.Add(r1.Result_num, c.Course_name, c.Type, t.Teacher_name, c.Credit_hour, r1.Score, r1.Type, r1.Year, r1.Term); } } dataGridView1成绩.DataSource = dt; } }