private void course_Load(object sender, EventArgs e)
{
shenheDao s = new shenheDao();
List <Course> ss = new List <Course>();
ss = s.find_courses();
Console.Write(ss);
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));
int i = 0;
foreach (Course s1 in ss)
{
dt.Rows.Add(s1.Course_num, s1.Course_name, s1.Type, s1.Academy);
i++;
}
dataGridView1.DataSource = dt;
foreach (DataGridViewColumn co in dataGridView1.Columns)
{
if (co.Index != 0)
{
co.ReadOnly = true;
}
}
data = dataGridView1;
}
private void button1_Click(object sender, EventArgs e)
{
shenheDao s = new shenheDao();
Course c = new Course();
c = s.find_course(textBox1.Text);
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.Rows.Add(c.Course_num, c.Course_name, c.Type, c.Academy);
dataGridView1.DataSource = dt;
}
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;
}
