protected void DDLJobGroup_SelectedIndexChanged(object sender, EventArgs e)
{
JobRepository jr = new JobRepository();
DDLJob.DataSource = jr.getJobsByGroupID(DDLJobGroup.SelectedValue.ToString().ToInt());
DDLJob.DataTextField = "JobTitle";
DDLJob.DataValueField = "JobID";
DDLJob.DataBind();
DDLJob.Items.Insert(0, new ListItem("-", "-1"));
tbxSearch.Value = "";
}
private void ShowJobInfo()
{
string strConn = ConfigurationSettings.AppSettings["strConn"];
SqlConnection SqlConn = new SqlConnection(strConn);
SqlDataAdapter SqlCmd = new SqlDataAdapter("select * from JobInfo", SqlConn);
DataSet SqlDS = new DataSet();
SqlCmd.Fill(SqlDS, "JobInfo");
DDLJob.DataSource = SqlDS.Tables["JobInfo"].DefaultView;
DDLJob.DataTextField = "JobName";
DDLJob.DataValueField = "JobID";
DDLJob.DataBind();
SqlConn.Dispose();
ListItem strTmp = new ListItem("--请选择--", "0");
DDLJob.Items.Add(strTmp);
}
private void fillDDLs()
{
JobGroupsRepository r = new JobGroupsRepository();
DDLJobGroup.DataSource = r.getJobGroups();
DDLJobGroup.DataTextField = "JobGroupTitle";
DDLJobGroup.DataValueField = "JobGroupID";
DDLJobGroup.DataBind();
DDLJobGroup.Items.Insert(0, new ListItem("-", "-1"));
JobRepository jr = new JobRepository();
DDLJob.DataSource = jr.getJobsByGroupID(DDLJobGroup.SelectedValue.ToString().ToInt());
DDLJob.DataTextField = "JobTitle";
DDLJob.DataValueField = "JobID";
DDLJob.DataBind();
DDLJob.Items.Insert(0, new ListItem("-", "-1"));
}
