//获取教学任务书ID public int GetTeaMissID(int ID, string Year, string Term) { ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement(); DataSet ds = new DataSet(); int teaMisID; ds = arr.GetTeaMisID(ID, Year, Term); teaMisID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); return teaMisID; }
//绑定GridView protected void ArrangementGridView_DataBind(int CourseID, string Week, string WeekDay, string LocationName, string TeacherName) { List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>(); ExtendBLL.Arrangement couArrange = new ExtendBLL.Arrangement(); DataSet ds = new DataSet(); ds = couArrange.GetAllArrangement(CourseID, Week, WeekDay, LocationName, TeacherName); arrModelList = HandleList(ds); ArrangementGridView.DataSource = arrModelList; ArrangementGridView.DataBind(); }
//保存更改 protected void Save_OnClick(object sender, EventArgs e) { if (tb_StudentIDs.Text == "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('请选择教师!')</script>"); return; } if (tb_StudentIDs2.Value == "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('请选择班级!')</script>"); return; } string[] strArray = IDHF.Value.Split(','); ExtendBLL.Arrangement arrExBLL = new ExtendBLL.Arrangement(); string Week = strArray[0]; int WeekDay = int.Parse(strArray[1]); int Lession = int.Parse(strArray[2]); int LocationID = int.Parse(strArray[3]); arrExBLL.DeleteCouArr(" [Week]='" + Week + "' and Weekday=" + WeekDay + " and Lession=" + Lession + " and LocationID=" + LocationID + " and CourseID=" + int.Parse(CourseDDL.SelectedValue)); LabMS.BLL.Arrangement arrBLL = new LabMS.BLL.Arrangement(); LabMS.Model.Arrangement arr = new LabMS.Model.Arrangement(); LabMS.BLL.Course cou = new LabMS.BLL.Course(); LabMS.Model.Course couModel = new LabMS.Model.Course(); couModel = cou.GetModel(int.Parse(CourseDDL.SelectedValue)); arr.CourseID = couModel.ID;//课程ID arr.Year = couModel.CourseYear;//学年 arr.ScoreTerm = couModel.CourseSeason;//学期 arr.CourseName = couModel.Course_Name;//课程名称 arr.LocationID = int.Parse(HouseDDL.SelectedValue);//用房ID arr.LocationName = HouseDDL.SelectedItem.Text;//用房位置 arr.LabID = int.Parse(LabDDL.SelectedValue);//实验室ID arr.TeacherID = int.Parse(tb_StudentIDs.Text);//教师ID arr.TeacherName = tb_StudentNames.Value;//教师名称 string labName = LabDDL.Text; int index = labName.IndexOf("|-"); if (index == 0) { labName = labName.Substring(index, labName.Length - index - 1); } arr.LabName = labName;//实验室名称 String[] claListsID = tb_StudentIDs2.Value.Split(','); String[] claListsName = tb_StudentNames2.Value.Split(','); arr.CourseTeacherID = GetTeaCouID(int.Parse(tb_StudentIDs.Text), int.Parse(CourseDDL.SelectedValue)); for (int j = 0; j < claListsID.Length; j++) { arr.ClassID = int.Parse(claListsID[j]);//班级ID arr.ClassName = claListsName[j];//班级名称 arr.ChoosenClassID = GetClaCouID(int.Parse(CourseDDL.SelectedValue), int.Parse(claListsID[j]), GetTeaMissID(int.Parse(CourseDDL.SelectedValue), YearDDL.SelectedValue, TermDDL.SelectedValue));//选课班级ID arr.Week = WeekSelectDDL.SelectedValue;//授课周次 bool checkClassSelected = false; for (int n = 1; n < 8; n++) { arr.WeekDay = n;//授课天次 for (int p = 1; p < 6; p++) { CheckBox check2 = (CheckBox)lbDayAndClass.FindControl("chkDay" + n.ToString() + "Class" + p.ToString()); if (check2.Checked) { checkClassSelected = true; arr.Lession = p;//授课节次 string[] strCheckArrangement = new string[3]; strCheckArrangement = CheckArrangement(arr); if (strCheckArrangement[0] != "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('课程安排冲突!" + arr.LocationName + "在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排课程:" + strCheckArrangement[0] + "')</script>"); return; } if (strCheckArrangement[1] != "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('老师课程安排冲突!" + arr.TeacherName + "在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排课程:" + strCheckArrangement[1] + "')</script>"); return; } if (strCheckArrangement[3] != "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('班级安排冲突!" + arr.ClassName + "在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排课程:" + strCheckArrangement[3] + "')</script>"); return; } if (strCheckArrangement[4] != "") { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('老师地点安排冲突!在第" + arr.Week.ToString() + "周 星期" + arr.WeekDay.ToString() + " 第" + arr.Lession.ToString() + "大节已安排老师:" + strCheckArrangement[4] + "上课')</script>"); return; } if (strCheckArrangement[2] != "") { ; } else { arrBLL.Add(arr); } } } } if (!checkClassSelected) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('请选择上课节次!')</script>"); return; } } Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('修改成功!')</script>"); arrtable.Visible = false; YearDDL.Enabled = true; TermDDL.Enabled = true; CourseDDL.Enabled = true; DeleteBtn.Enabled = true; ArrangementGridView.Enabled = true; ArrangementGridView_DataBind(int.Parse(CourseDDL.SelectedValue), WeekDDL.SelectedValue, WeekDayDDL.SelectedValue, LocationBTX.Text.Trim(), TeacherTBX.Text.Trim()); }
//获取老师列表 protected DataSet GetTeacherList(string Week, int WeekDay, int Lession, int LocationID) { ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement(); DataSet ds = new DataSet(); ds = arr.GetTeaInfo(Week, WeekDay, Lession, LocationID); return ds; }
//删除 protected void Delete_OnClick(object sender, EventArgs e) { ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement(); for (int i = 0; i < ArrangementGridView.Rows.Count; i++) { CheckBox CB = (CheckBox)ArrangementGridView.Rows[i].FindControl("chk"); if (CB.Checked) { string[] str = ArrangementGridView.DataKeys[i].Value.ToString().Split(','); arr.DeleteCouArr("[Week]='" + str[0] + "' and [WeekDay]=" + int.Parse(str[1]) + " and Lession=" + int.Parse(str[2]) + " and LocationID=" + int.Parse(str[3])); } } ArrangementGridView_DataBind(int.Parse(CourseDDL.SelectedValue), WeekDDL.SelectedValue, WeekDayDDL.SelectedValue, LocationBTX.Text.Trim(), TeacherTBX.Text.Trim()); }
//��ȡGV�б� protected DataSet GetGVList(int CouID) { ExtendBLL.Arrangement arr =new ExtendBLL.Arrangement(); DataSet ds = new DataSet(); ds = arr.GetList(CouID); return ds; }
protected void ReSet_OnCommand(object sender, CommandEventArgs e) { if (e.CommandName == "ReSet") { ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement(); LabMS.BLL.ClassItem claItem = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> claItemModel = new List<LabMS.Model.ClassItem>(); StringBuilder strWhere = new StringBuilder(); strWhere.Append("ChoosenClassID=0"); claItemModel = claItem.GetModelList("TeachMissionID=" + int.Parse(e.CommandArgument.ToString())); for (int i = 0; i < claItemModel.Count; i++) { strWhere.Append(" or ChoosenClassID=" + claItemModel[i].ID); } arr.DeleteCouArr(strWhere.ToString()); } CouArrangeGridView_DataBind(); }
//��ȡ�γ�ID protected int GetCourseID(int ID) { ExtendBLL.Arrangement arr = new ExtendBLL.Arrangement(); DataSet ds = new DataSet(); ds = arr.GetCourseIDByTeaMisID(ID); int courseID; courseID = int.Parse(ds.Tables[0].Rows[0]["ID"].ToString()); return courseID; }