/// <summary> /// 根据班级号查出班级名称 /// </summary> /// <param name="ClassID"></param> /// <returns></returns> public string GetClassNameByClassID(int ClassID) { string str = "ID="+ClassID; LabMS.BLL.Class BClass=new LabMS.BLL.Class(); string Class_Name = BClass.GetModelList(str)[0].Class_Name; return Class_Name; }
protected void Gv_DataBinds() { LabMS.BLL.Class Class = new LabMS.BLL.Class(); List<LabMS.Model.Class> ls = new List<LabMS.Model.Class>(); ls = Class.GetModelList(CombineStr()); Gv_Class.DataSource = ls; Gv_Class.DataBind(); }
protected void InitBindFromDB(int ID) { LabMS.BLL.Class BC = new LabMS.BLL.Class(); LabMS.Model.Class MC = new LabMS.Model.Class(); MC = BC.GetModel(ID); tbClassName.Text = MC.Class_Name; tbClassNumber.Text = MC.Class_Code;//班号 ddlClass.SelectedValue = MC.Class_Year; tbNum.Text = MC.Class_StudentNum.Value.ToString(); tb.Text = MC.Class_Professional.Value.ToString();//专业代号 ExtendBLL.Class EC = new ExtendBLL.Class(); tbClassMajor.Text=EC.ProessionalNameByID(int.Parse(tb.Text.Trim())); }
/// <summary> /// 班级编号是否存在 /// </summary> /// <param name="Class"></param> /// <returns></returns> public int IsExistClass(string strClass) { string str = "Class_Code='"+strClass+"'"; LabMS.BLL.Class BC = new LabMS.BLL.Class(); if (BC.GetModelList(str).Count > 0) { //已经存在 return 1; } else { //不存在,可以保存 return 0; } }
void bindClass(string Year, string Pro) { List<LabMS.Model.Class> listClass = new List<LabMS.Model.Class>(); LabMS.BLL.Class bClass = new LabMS.BLL.Class(); string strWhere = "1=1"; if (Year != "0") { strWhere += " and Class_Year ='" + Year + "'"; } if (Pro!="0") { strWhere += " and Class_Professional =" + Pro; } listClass = bClass.GetModelList(strWhere); ddlClass.DataSource = listClass; ddlClass.DataValueField = "ID"; ddlClass.DataTextField = "Class_Name"; ddlClass.DataBind(); ddlClass.Items.Insert(0, new ListItem("", "0")); }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("BJKB"); strPageUserType.Add("student"); if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(UserID) && !string.IsNullOrEmpty(UserName)) { YearBind(); lb_Year.Text = ddl_Year.SelectedValue; if (ddl_Term.SelectedValue == "1") { lb_Term.Text = "��ѧ��"; } else { lb_Term.Text = "��ѧ��"; } int TempID = 0; if (int.TryParse(UserID,out TempID)) { if (TempID > 0) { LabMS.BLL.Student Student = new LabMS.BLL.Student(); LabMS.Model.Student model = Student.GetModel(TempID); if (model != null) { if (model.ClassID.HasValue) { LabMS.BLL.Class Class = new LabMS.BLL.Class(); LabMS.Model.Class classmodel = Class.GetModel(model.ClassID.Value); if (classmodel != null) { lb_ClassName.Text = classmodel.Class_Name; } } } } } DataBinds(); } else { LabMS.Common.JShelper.JSAlert(this, "error", "ϵͳ��������ϵ����Ա"); } } }
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>"); }
protected void Gv_DataBinds() { LabMS.BLL.Class Class = new LabMS.BLL.Class(); List<LabMS.Model.Class> ls = new List<LabMS.Model.Class>(); string strWhere = CombineStr(); if (!string.IsNullOrEmpty(strWhere)) { ls = Class.GetModelList(strWhere); Gv_Class.DataSource = ls; Gv_Class.DataBind(); } else { Gv_Class.DataSource = ls; Gv_Class.DataBind(); } }
protected void Page_Load(object sender, EventArgs e) { strPagePrivilege.Add("BJKB"); strPageUserType.Add("mana"); if (!Page.IsPostBack) { if (!string.IsNullOrEmpty(Request.QueryString["ID"]) && !string.IsNullOrEmpty(Request.QueryString["Year"]) && !string.IsNullOrEmpty(Request.QueryString["Term"])) { int ClassID = 0; int Year = 0; int Term = 0; if (int.TryParse(Request.QueryString["ID"], out ClassID) && int.TryParse(Request.QueryString["Year"], out Year) && int.TryParse(Request.QueryString["Term"], out Term)) { DataBinds(); if (ClassID != 0) { LabMS.BLL.Class Class = new LabMS.BLL.Class(); LabMS.Model.Class model = new LabMS.Model.Class(); model = Class.GetModel(ClassID); if (model != null) { lb_Class.Text = model.Class_Name; } if (Year != 0) { lb_Year.Text = Year.ToString(); } if (Term != 0) { if (Term == 1) { lb_Term.Text = "��ѧ��"; } else { lb_Term.Text = "��ѧ��"; } } } } } } }
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(); } }
void searchbind() { string strwhere = " 1=1 "; string strclass = ddlClass.SelectedValue; string strYear = ddlYear.SelectedValue; string strPro = ddlPro.SelectedValue; string strSName = tbSName.Text.Trim(); string strSCode = tbSNub.Text.Trim(); if (strclass != "0") { strwhere += " and ClassID = " + strclass; } if (strYear != "0") { List<LabMS.Model.Class> listClass = new List<LabMS.Model.Class>(); LabMS.BLL.Class bclass = new LabMS.BLL.Class(); bclass.GetModelList("Class_Year = '"+ strYear +"'"); strwhere += " and ( 1<>1 "; foreach (LabMS.Model.Class c in listClass) { strwhere += " and ( or ClassID = " + c.ID.ToString(); } strwhere += ")"; } if (strPro != "0") { strwhere += " and Student_Pro = " + strPro; } if (strSCode != "") { strwhere += " and Student_Code like '%" + strSCode + "%'"; } if (strSName != "") { strwhere += " and Student_Name like '%" + strSName + "%'"; } bind(strwhere); }