//绑定班级 protected void ClassDDL_DataBind(int CourseID) { LabMS.BLL.ClassItem classItem = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> classItemModel = new List<LabMS.Model.ClassItem>(); classItemModel = classItem.GetModelList("CourseID=" + CourseID); ClassDDL.DataSource = classItemModel; ClassDDL.DataBind(); }
//通过课程ID获取选课班级信息 protected List<LabMS.Model.ClassItem> GetClassItemInfo(int CourseID) { LabMS.BLL.ClassItem classitem = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> classitenList = new List<LabMS.Model.ClassItem>(); try { classitenList = classitem.GetModelList("CourseID=" + CourseID); } catch (Exception ex) { throw ex; } return classitenList; }
//获取选课班级ID protected int? GetClaCouID(int CourseID, int ClassID, int TeaMisID) { LabMS.BLL.ClassItem claIte = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> claIteModel = new List<LabMS.Model.ClassItem>(); claIteModel = claIte.GetModelList("ClassID=" + ClassID + " and CourseID=" + CourseID + " and TeachMissionID=" + TeaMisID); int? ID; if (claIteModel.Count == 0) { ID = null; } else { ID = int.Parse(claIteModel[0].ID.ToString()); } return ID; }
//通过班级ID获取选课班级ID protected int GetCouClaIDByClaID(int CID,int IID) { LabMS.BLL.ClassItem claItem = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> claItemModel = new List<LabMS.Model.ClassItem>(); int CIID = 0; claItemModel = claItem.GetModelList("ClassID=" + CID + " and CourseID=" + IID); if (claItemModel.Count != 0) { CIID = claItemModel[0].ID; } return CIID; }
//获取选课班级 总人数 protected LabMS.Model.ClassItem GetClassName(int ID) { LabMS.BLL.ClassItem classItem = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> classItemModel = new List<LabMS.Model.ClassItem>(); LabMS.Model.ClassItem cIModel = new LabMS.Model.ClassItem(); string str; cIModel.ClassItem_Name = ""; cIModel.ClassItem_Num = 0; classItemModel = classItem.GetModelList("CourseID=" + ID); for (int i = 0; i < classItemModel.Count; i++) { cIModel.ClassItem_Name += classItemModel[i].ClassItem_Name+","; cIModel.ClassItem_Num += classItemModel[i].ClassItem_Num; } str = cIModel.ClassItem_Name; cIModel.ClassItem_Name = str.Substring(0, str.Length - 1); return cIModel; }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("JXRWS"); strPageUserType.Add("mana"); if (!Page.IsPostBack) { bool right = false; if (!string.IsNullOrEmpty(Request.QueryString["ID"])) { int TempID = 0; if (int.TryParse(Request.QueryString["ID"], out TempID)) { if (TempID > 0) { DataBinds(); LabMS.BLL.Class Class = new LabMS.BLL.Class(); LabMS.BLL.ClassItem ClassItem = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> ls = new List<LabMS.Model.ClassItem>(); ls = ClassItem.GetModelList("TeachMissionID=" + Request.QueryString["ID"].Trim()); if (ls.Count != 0) { tb_ClassIDs.Text = ""; for (int n = 0; n < ls.Count; n++) { if (tb_ClassIDs.Text == "") { tb_ClassIDs.Text += ls[n].ClassID; } else { tb_ClassIDs.Text += ","; tb_ClassIDs.Text += ls[n].ClassID; } } } tb_CourseID.Text = ls[0].CourseID.ToString(); Gv_DataBinds(); right = true; } } } if (!right) { Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>window.location.href='~/err.aspx?Message=��ѯ�ַ�������';<script>"); return; } } if (tb_Tag.Text == "0") { Gv_DataBinds(); } }
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(); }
//����γ̰����б� protected List<ExtendModule.CourseArrange> HandCouArrList(List<LabMS.Model.TeachMission> couArrList) { List<ExtendModule.CourseArrange> list=new List<ExtendModule.CourseArrange>(); if (couArrList.Count == 0) { return list; } LabMS.BLL.ClassItem claIte = new LabMS.BLL.ClassItem(); List<LabMS.Model.ClassItem> claIteModel = new List<LabMS.Model.ClassItem>(); LabMS.BLL.Arrangement arr = new LabMS.BLL.Arrangement(); List<LabMS.Model.Arrangement> arrModelList = new List<LabMS.Model.Arrangement>(); claIteModel = claIte.GetModelList("TeachMissionID is not null"); arrModelList = arr.GetModelList("ChoosenClassID is not null"); for (int i = 0; i < couArrList.Count; i++) { ExtendModule.CourseArrange listModel = new ExtendModule.CourseArrange(); listModel.ID = GetCourseID(int.Parse(couArrList[i].ID.ToString())); listModel.TeaMisID = couArrList[i].ID; listModel.Course_Code = couArrList[i].Ms_CourseCode; listModel.Course_Name = couArrList[i].Ms_CourseName; listModel.IsCheck = couArrList[i].Ms_Conflict; listModel.LabName = GetLabNameByID((int)couArrList[i].LabID); listModel.Course_ExprientHouse = couArrList[i].Ms_CourseHourse; listModel.Class = GetClassAndNum(claIteModel, couArrList[i].ID); listModel.ClassArrange = GetArrangedClass(arrModelList, claIteModel, couArrList[i].ID); list.Add(listModel); } return list; }