//绑定班级
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;
}
