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;
}
public teacher_update(string teacher_num)
{
InitializeComponent();
model.Teacher s = dao.teacherDao.find_teacher(teacher_num);
text11.Text = teacher_num;
text12.Text = s.Teacher_name;
text14.Text = s.Teacher_academy;
text15.Text = s.Profession;
text17.Text = s.Password;
text18.Text = s.Id_number;
}
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)
{
model.Teacher t1 = new model.Teacher();
t1.Teacher_num = textBox2.Text;
t1.Teacher_name = textBox1.Text;
t1.Teacher_academy = textBox3.Text;
t1.Profession = textBox4.Text;
List <model.Teacher> rs;
if (t1.Teacher_num != "" || t1.Teacher_name != "" || t1.Teacher_academy != "" || t1.Profession != "")
{
rs = dao.teacherDao.find_teachers2(t1);
}
else
{
rs = dao.teacherDao.find_teachers();
}
Console.Write(rs);
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 (model.Teacher s1 in rs)
{
dt.Rows.Add(s1.Teacher_num, s1.Teacher_name, s1.Teacher_academy, s1.Profession);
i++;
}
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;
}
}
