protected void ClassName1_SelectedIndexChanged(object sender, EventArgs e)
{
ClassName2.DataSource = WebBLL.Tbl_ClassManager.GetTbl_ClassByParentID(Convert.ToInt32(this.ClassName1.SelectedValue));
ClassName2.DataTextField = "ClassName";
ClassName2.DataValueField = "ID";
ClassName2.DataBind();
ClassName2.Items.Insert(0, new ListItem("选择卷册", ""));
}
protected void ClassName1_SelectedIndexChanged(object sender, EventArgs e)
{
//卷
ClassName2.DataSource = WebBLL.Tbl_ClassManager.GetDataTableByPage(50, 1, "parentid=(select top 1 id from tbl_class where parentid=15 and classname='" + ClassName1.SelectedItem.Text + "')", "");
ClassName2.DataTextField = "ClassName";
ClassName2.DataValueField = "ID";
ClassName2.DataBind();
ClassName2.Items.Insert(0, new ListItem("选择卷", ""));
//该专业的人绑定
DT_SheJiRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(100, 1, "status='在职' and u_designlimit like '%设计人%' and U_Specialty like '%" + ClassName1.SelectedItem.Text + "%'", "username asc");
DT_SheJiRen.DataTextField = "UserName";
DT_SheJiRen.DataValueField = "UserName";
DT_SheJiRen.DataBind();
DT_SheJiRen.Items.Insert(0, new ListItem("选设计人", ""));
DT_JiaoDuiRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(100, 1, "status='在职' and u_designlimit like '%校对人%' and U_Specialty like '%" + ClassName1.SelectedItem.Text + "%'", "username asc");
DT_JiaoDuiRen.DataTextField = "UserName";
DT_JiaoDuiRen.DataValueField = "UserName";
DT_JiaoDuiRen.DataBind();
DT_JiaoDuiRen.Items.Insert(0, new ListItem("选校对人", ""));
DT_ShenHeRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(50, 1, "status='在职' and u_designlimit like '%审核人%' and U_Specialty like '%" + ClassName1.SelectedItem.Text + "%'", "username asc");
DT_ShenHeRen.DataTextField = "UserName";
DT_ShenHeRen.DataValueField = "UserName";
DT_ShenHeRen.DataBind();
DT_ShenHeRen.Items.Insert(0, new ListItem("选审核人", ""));
DT_ShenDingRen.DataSource = WebBLL.Tbl_UserManager.GetDataTableByPage(50, 1, "status='在职' and u_designlimit like '%审定人%' and U_Specialty like '%" + ClassName1.SelectedItem.Text + "%'", "username asc");
DT_ShenDingRen.DataTextField = "UserName";
DT_ShenDingRen.DataValueField = "UserName";
DT_ShenDingRen.DataBind();
DT_ShenDingRen.Items.Insert(0, new ListItem("选审定人", ""));
//任务绑定
BindList();
}
