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("选择卷册", ""));
}
private void button7_Click(object sender, EventArgs e)
{
comboBox6.SelectedIndex = -1;
comboBox6.Items.Clear();
if (comboBox4.SelectedIndex == -1 || comboBox5.SelectedIndex == -1)
{
MessageBox.Show("Must enter hours before");
return;
}
string start = comboBox4.SelectedItem.ToString();
string end = comboBox5.SelectedItem.ToString();
string start2, end2, ClassName, ClassName2, day2;
int capacity;
bool flag = true;
DataTable Lessons = Program.get_dt("select StartH,EndH,ClassName,day from lessons");
DataTable Classes = Program.get_dt("select id,capacity from classes");
if (comboBox7.SelectedItem.ToString().Equals("Prac"))
{
capacity = 25;
}
else
{
capacity = 50;
}
for (int i = 0; i < Classes.Rows.Count; i++)// move over classes
{
if (capacity > Int32.Parse(Classes.Rows[i][1].ToString()))
{
continue;
}
ClassName = Classes.Rows[i][0].ToString();
for (int j = 0; j < Lessons.Rows.Count; j++) //move over lessons
{
start2 = Lessons.Rows[j][0].ToString(); //start time
end2 = Lessons.Rows[j][1].ToString(); //end time
ClassName2 = Lessons.Rows[j][2].ToString(); //class name
day2 = Lessons.Rows[j][3].ToString();
if (!Sec.notSameTime(start, start2, end, end2) && ClassName2.Equals(ClassName) && day.Equals(day2))
{
flag = false;
}
}
if (flag)//if class is free at this time
{
comboBox6.Items.Add(ClassName);
}
flag = true;
}
}
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();
}
