//绑定班级
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;
}
protected void Save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_CourseCode.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�γ̱�Ų���Ϊ��");
return;
}
if (string.IsNullOrEmpty(tb_CourseName.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "���������");
return;
}
if (ddl_Lab.SelectedValue == "0")
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��е��γ̵�ʵ����");
return;
}
if (string.IsNullOrEmpty(tb_ExpHouse.Text))
{
LabMS.Common.JShelper.JSAlert(this, "error", " ʵ��ѧʱ����Ϊ��");
return;
}
if (string.IsNullOrEmpty(tb_StartWeek.Text))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
return;
}
if (!IsNumber(tb_StartWeek.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
return;
}
if (!IsNumber(tb_EndWeek.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�����ܴβ���Ϊ����ӦΪ����");
return;
}
int Num1 = 0;
int Num2 = 0;
if (int.TryParse(tb_StartWeek.Text, out Num1) && int.TryParse(tb_EndWeek.Text, out Num2))
{
if (Num2 < Num1)
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴδ��ڽ����ܴ�");
return;
}
}
else
{
LabMS.Common.JShelper.JSAlert(this, "error", "�ܴβ���Ϊ�գ���Ӧ��Ϊ����");
return;
}
if (!IsNumber(tb_ComputerTime.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�ϻ�����Ϊ����ӦΪ����");
return;
}
if (string.IsNullOrEmpty(tb_Teacher.Text))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʦ����Ϊ����ӦΪ����");
return;
}
if (!(Gv_Class.Rows.Count > 0))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��γ̶�Ӧ�İ༶");
return;
}
LabMS.BLL.TeachMission TeachMission = new LabMS.BLL.TeachMission();
LabMS.Model.TeachMission model = new LabMS.Model.TeachMission();
model.LabID = Convert.ToInt32(ddl_Lab.SelectedValue.Trim());
model.Ms_CourseCode = (tb_CourseCode.Text);
model.Ms_CourseName = tb_CourseName.Text;
model.Ms_SubmitTime = DateTime.Now;
model.Ms_Teacher = Convert.ToInt32(tb_TeacherID.Text);
model.Ms_Conflict = rbl_Conflict.SelectedValue.Trim();
model.Ms_StartWeek = Convert.ToInt32(tb_StartWeek.Text.Trim().ToString());
model.Ms_EndWeek = Convert.ToInt32(tb_EndWeek.Text.Trim().ToString());
model.Ms_CourseHourse = Convert.ToInt32(tb_ExpHouse.Text.Trim());
model.Ms_ComputerHourse = Convert.ToInt32(tb_ComputerTime.Text.Trim());
model.Ms_Year = ddl_Year.SelectedValue;
model.Ms_Term = ddl_Season.SelectedValue;
int ID = TeachMission.Add(model);
string[] array = tb_ClassIDs.Text.Split(',');
List<string> lsIDs = new List<string>();
lsIDs.Add(array[0]);
foreach (string item in array)
{
int Count = 0;
foreach (string Pr in lsIDs)
{
if (item != Pr)
{
Count++;
}
}
if (Count == lsIDs.Count)
{
lsIDs.Add(item);
}
}
///�����༶��ѡ�ΰ༶ �Ϳγ̵�����
///\
///
int CourseID = int.Parse(tb_CourseID.Text.Trim());
LabMS.BLL.ClassItem ClassItem = new LabMS.BLL.ClassItem();
LabMS.BLL.Class Class = new LabMS.BLL.Class();
LabMS.Model.Class classModel;
LabMS.Model.ClassItem classItemModel;
for (int n = 0; n < lsIDs.Count; n++)
{
classModel = Class.GetModel(Convert.ToInt32(lsIDs[n]));
classItemModel = new LabMS.Model.ClassItem();
classItemModel.CourseID = CourseID;
classItemModel.ClassItem_Code = classModel.Class_Code;
classItemModel.ClassItem_Name = classModel.Class_Name;
classItemModel.ClassItem_Num = classModel.Class_StudentNum;
classItemModel.ClassItem_Degree = classModel.Class_Year;
classItemModel.ClassID = Convert.ToInt32(lsIDs[n]);
classItemModel.Time = DateTime.Now;
classItemModel.TeachMissionID = ID;
int classItemModelID = ClassItem.Add(classItemModel);
}
//������ʦ�Ϳγ�֮�����ϵ
/// ��ʦ��ѡ��
///
LabMS.BLL.TeacherCourse TC = new LabMS.BLL.TeacherCourse();
LabMS.Model.TeacherCourse Model = new LabMS.Model.TeacherCourse();
Model.CourseID = CourseID;
Model.TeacherID = Convert.ToInt32(tb_TeacherID.Text.Trim());
int temID = TC.Add(Model);
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('����ɹ���');if(window.confirm('�Ƿ��б�ҳ�棿')){window.location.href='TeachingMissionList.aspx'}else{window.location.href='TeachingMissionPreview.aspx?ID=" + temID + "'};</script>");
}
//获取选课班级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 Save_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(tb_CourseCode.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�γ̱�Ų���Ϊ��");
return;
}
if (string.IsNullOrEmpty(tb_CourseName.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "���������");
return;
}
if (ddl_Lab.SelectedValue == "0")
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��е��γ̵�ʵ����");
return;
}
if (string.IsNullOrEmpty(tb_ExpHouse.Text))
{
LabMS.Common.JShelper.JSAlert(this, "error", " ʵ��ѧʱ����Ϊ��");
return;
}
if (string.IsNullOrEmpty(tb_StartWeek.Text))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
return;
}
if (!IsNumber(tb_StartWeek.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴβ���Ϊ����ӦΪ����");
return;
}
if (!IsNumber(tb_EndWeek.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�����ܴβ���Ϊ����ӦΪ����");
return;
}
int Num1 = 0;
int Num2 = 0;
if (int.TryParse(tb_StartWeek.Text, out Num1) && int.TryParse(tb_EndWeek.Text, out Num2))
{
if (Num2 < Num1)
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʼ�ܴδ��ڽ����ܴ�");
}
}
else
{
LabMS.Common.JShelper.JSAlert(this, "error", "�ܴβ���Ϊ�գ���Ӧ��Ϊ����");
return;
}
if (!IsNumber(tb_ComputerTime.Text.Trim()))
{
LabMS.Common.JShelper.JSAlert(this, "error", "�ϻ�����Ϊ����ӦΪ����");
return;
}
if (string.IsNullOrEmpty(tb_Teacher.Text))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ʦ����Ϊ����ӦΪ����");
return;
}
if (!(Gv_Class.Rows.Count > 0))
{
LabMS.Common.JShelper.JSAlert(this, "error", "��ѡ��γ̶�Ӧ�İ༶");
return;
}
try
{
LabMS.BLL.TeachMission TeachMission = new LabMS.BLL.TeachMission();
LabMS.Model.TeachMission model = new LabMS.Model.TeachMission();
model = TeachMission.GetModel(QueryString);
if (model != null)
{
model.LabID = Convert.ToInt32(ddl_Lab.SelectedValue.Trim());
model.Ms_CourseCode = (tb_CourseCode.Text);
model.Ms_CourseName = tb_CourseName.Text;
model.Ms_SubmitTime = DateTime.Now;
model.Ms_Teacher = Convert.ToInt32(tb_TeacherID.Text);
model.Ms_Conflict = rbl_Conflict.SelectedValue.Trim();
model.Ms_StartWeek = Convert.ToInt32(tb_StartWeek.Text.Trim().ToString());
model.Ms_EndWeek = Convert.ToInt32(tb_EndWeek.Text.Trim().ToString());
model.Ms_CourseHourse = Convert.ToInt32(tb_ExpHouse.Text.Trim());
model.Ms_ComputerHourse = Convert.ToInt32(tb_ComputerTime.Text.Trim());
model.Ms_Term = ddl_Season.SelectedValue;
model.Ms_Year = ddl_Year.SelectedValue;
TeachMission.Update(model);
}
}
catch (Exception ex)
{
lb_Error.Text = ex.Message;
}
string[] array = tb_ClassIDs.Text.Split(',');
if (array.Length == 1 && array[0] == "")
{
return;
}
List<string> lsIDs = new List<string>();
lsIDs.Add(array[0]);
foreach (string item in array)
{
int Count = 0;
foreach (string Pr in lsIDs)
{
if (item != Pr)
{
Count++;
}
}
if (Count == lsIDs.Count)
{
lsIDs.Add(item);
}
}
//��ȡ�б�
try
{
ExtendBLL.ClassItemDelete ClassItemDelete = new ExtendBLL.ClassItemDelete();
int result = ClassItemDelete.Delete(QueryString.ToString());
if (result == 0)
{
//LabMS.Common.JShelper.JSAlert(this, "error", "��ѯ�ַ�������");
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>window.location.href='~/err.aspx?Message=��ѯ�ַ�������';<script>");
return;
}
if (result == 2)
{
LabMS.Common.JShelper.JSAlert(this, "error", "���´���");
}
}
catch (Exception ex)
{
lb_Error.Text = ex.Message;
}
int CourseID = int.Parse(tb_CourseID.Text.Trim());
LabMS.BLL.ClassItem ClassItem = new LabMS.BLL.ClassItem();
LabMS.BLL.Class Class = new LabMS.BLL.Class();
LabMS.Model.Class classModel;
LabMS.Model.ClassItem classItemModel;
for (int n = 0; n < lsIDs.Count; n++)
{
classModel = Class.GetModel(Convert.ToInt32(lsIDs[n]));
classItemModel = new LabMS.Model.ClassItem();
classItemModel.CourseID = CourseID;
classItemModel.ClassItem_Code = classModel.Class_Code;
classItemModel.ClassItem_Name = classModel.Class_Name;
classItemModel.ClassItem_Num = classModel.Class_StudentNum;
classItemModel.ClassItem_Degree = classModel.Class_Year;
classItemModel.ClassID = Convert.ToInt32(lsIDs[n]);
classItemModel.Time = DateTime.Now;
classItemModel.TeachMissionID = QueryString;
int classItemModelID = ClassItem.Add(classItemModel);
}
LabMS.BLL.TeacherCourse TC = new LabMS.BLL.TeacherCourse();
LabMS.Model.TeacherCourse Model = new LabMS.Model.TeacherCourse();
Model.CourseID = CourseID;
Model.TeacherID = Convert.ToInt32(tb_TeacherID.Text.Trim());
TC.Add(Model);
Page.ClientScript.RegisterClientScriptBlock(GetType(), "script", "<script type='text/javascript'>alert('�ijɹ�');window.location.href='TeachingMissionList.aspx';</script>");
}
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;
}
