public void viewClassnum()
{
string seleCn = "select classnum 类型号,classname 类型名称 from DT_career";
SqlHelp sqlHelper = new SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(seleCn, "DT_career").Tables["DT_career"];
}
public void viewMajor()
{
string seleCg = "select zynum 专业编号,zyname 专业名称 from DT_ZY";
SqlHelp sqlHelper = new SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(seleCg, "DT_ZY").Tables["DT_ZY"];
}
public void viewCollege()
{
string seleCg = "select yxnum 院系编号,yxname 院系名称 from DT_YX";
SqlHelp sqlHelper = new SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(seleCg, "DT_YX").Tables["DT_YX"];
}
public void graduatedView()
{
string sqlView = "select stunum 学号,name 姓名,sex 性别,birthday 生日,[native place] 籍贯,zynum 专业编号,yxnum 院系编号 from DT_students";
SqlHelp sqlHelper = new SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(sqlView, "DT_students").Tables["DT_students"];
}
private void 查看职业信息VToolStripMenuItem_Click(object sender, EventArgs e)
{
string sele = "select careernum 职业号,classnum 类型号,neednum 需求数量,lastnum 聘用数量,employer 用人单位 from DT_employer";
SqlHelp sqlHelper = new SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(sele, "DT_employer").Tables["DT_employer"];
}
private void cbWc_SelectedIndexChanged(object sender, EventArgs e)
{
SqlHelp sqlHelper = new SqlHelp();
string findWn = "select classname from DT_career where classnum in(select classnum from DT_employer where employer ='" + cbWc.Text + "')";
cbWn.DataSource = sqlHelper.showData(findWn, "DT_career").Tables[0];
cbWn.DisplayMember = "classname";
cbWn.ValueMember = "classname";
}
private void permit_Load(object sender, EventArgs e)
{
string findWc = "select distinct employer from DT_employer";
SqlHelp sqlHelper = new SqlHelp();
cbWc.DataSource = sqlHelper.showData(findWc, "DT_employer").Tables[0];
cbWc.DisplayMember = "employer";
cbWc.ValueMember = "employer";
}