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(); }