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, "", "");
}
}
}
