public void viewPermit()
{
string viewPer = "select * from DT_employer";
SqlHelp sqlHelper = new TryDBMS.SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(viewPer, "DT_employer").Tables["DT_employer"];
}
public void workView()
{
string sqlView = "select careernum 职业号,classnum 类型号,neednum 需求数量,lastnum 聘用数量,employer 用人单位 from DT_employer";
SqlHelp sqlHelper = new TryDBMS.SqlHelp();
dataGridView1.DataSource = sqlHelper.showData(sqlView, "DT_employer").Tables["DT_employer"];
}
private void cbCg_SelectedIndexChanged(object sender, EventArgs e)
{
string findMj = "select distinct zyname from dt_zy where yxnum in (select yxnum from dt_yx where yxname ='" + cbCg.Text + "')";
SqlHelp sqlHelper = new TryDBMS.SqlHelp();
cbMj.DataSource = sqlHelper.showData(findMj, "dt_zy").Tables[0];
cbMj.DisplayMember = "zyname";
cbMj.ValueMember = "zyname";
}
private void Register_Load(object sender, EventArgs e)
{
string findCg = "select distinct yxname from dt_yx";
SqlHelp sqlHelper = new TryDBMS.SqlHelp();
cbCg.DataSource = sqlHelper.showData(findCg, "dt_yx").Tables[0];
cbCg.DisplayMember = "yxname";
cbCg.ValueMember = "yxname";
}
private void btOk_Click(object sender, EventArgs e)
{
string findSql = "select * from DT_career where classnum ='" + tBcnu.Text + "'";
string insertSql = "insert into DT_career" + "(classnum,classname)" + "values('" + tBcnu.Text + "','" + tbCna.Text + "')";
SqlHelp sqlHelper = new TryDBMS.SqlHelp();
int count1 = sqlHelper.SqlServerRecordCount(findSql);
if (count1 > 0)
{
wrong1();
}
int count2 = sqlHelper.ExecuteNonQueryCount(insertSql);
if (count2 > 0)
{
right();
}
Hide();
}
public updategraduated()
{
InitializeComponent();
skinEngine1.SkinFile = "mdc_summer.ssk";
skinEngine1.SkinDialogs = false;
lbUnm.Text = Login.Username;
string getUn = "select stunum from DT_students where name = '" + lbUnm.Text + "'";
string getSex = "select sex from DT_students where name = '" + lbUnm.Text + "'";
//string getCg = "select distinct yxname from dt_yx where yxnum in (select yxnum from dt_students where name ='" + lbUnm.Text + "')";
SqlHelp sqlHelper = new TryDBMS.SqlHelp();
lbUnu.Text = sqlHelper.GetDataReaderValue(getUn);
if (sqlHelper.GetDataReaderValue(getSex) == "女")
{
rbFemale.Checked = true;
}
else
{
rbMale.Checked = true;
}
}
