public student_update(string student_num) { InitializeComponent(); model.Student s = dao.studentDao.find_student(student_num); text11.Text = student_num; text12.Text = s.Student_name; text13.Text = s.Student_grade; text14.Text = s.Student_academy; text15.Text = s.Profession; text16.Text = s.Classs; text17.Text = s.Password; text18.Text = s.Id_number; }
//录入成绩 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 toolStripLabel1_Click(object sender, EventArgs e) { Console.Write("!!!!!!!!!!!!!!!!!!!!!!!!!"); string tmp1 = toolStripComboBox1.Text; dao.shenheDao s = new shenheDao(); model.Course c = new Course(); c = s.find_course(tmp1); Console.Write("lalalal" + c.Course_num); List <model.Result> l = new List <model.Result>(); num = s.selectAll2(c.Course_num); Console.Write(num + "555555555555555555555"); List <model.Result> rs = new List <model.Result>(); rs = s.selectAll1(c.Course_num); Console.WriteLine(c.Course_num + "33333333333333333333333333"); 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(int)); dt.Columns.Add("状态", typeof(string)); foreach (model.Result r1 in rs) { model.Student d = new model.Student(); Console.Write(r1.Student_num + "111111111111111111"); d = s.find_student(r1.Student_num); Console.Write("1111111111111111111"); dt.Rows.Add(r1.Result_num, r1.Course_num, tmp1, d.Student_num, d.Student_name, c.Maxcount, r1.State); } dataGridView1.DataSource = dt; }