using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;
using WindowsFormsApp1.lei;

namespace WindowsFormsApp1
{
    public partial class SelectCourseByStudent : Form
    {
        public delegate void ComBoboxHandler(string param);   //声明委托
        public event ComBoboxHandler Button1Event;        //声明事件
        private DBHelper dBHelper = new DBHelper();
        private DataTable dataTable = new DataTable();
        public SelectCourseByStudent()
        {
            InitializeComponent();
        }
        //查询课程
        public void selectCourse()
        {
            string sql = "select t.id,t.姓名,c.id,c.名称 from 教师信息 t left join 教师授课表 tg on t.id = tg.教师ID left join 学科信息 c on tg.学科ID = c.id ";
            dataTable = dBHelper.ExecSqlForDataTable(sql);
        }
        private void SelectCourseByStudent_Load(object sender, EventArgs e)
        {
            selectCourse();
            if(dataTable.Rows.Count > 0)
            {
                for (int i = 0; i < dataTable.Rows.Count; i++)
                {
                    string tid = dataTable.Rows[i]["id"].ToString();
                    string tname = dataTable.Rows[i]["姓名"].ToString();
                    string cid = dataTable.Rows[i]["id1"].ToString();
                    string cname = dataTable.Rows[i]["名称"].ToString();
                    string a = tid + " " + tname + " " + cid + " " + cname;
                    this.comboBox1.Items.Add(a);
                }
            }
        }
        private void button1_Click(object sender, EventArgs e)
        {
            Button1Event(this.comboBox1.Text);
            this.Close();
        }
    }
}