static int FirstSxNum = 0;/*声明变量,初始化为0,用于判断筛选条件是否改变*/ /// <summary> /// 加载科目列表信息 /// </summary> /// <param name="apge">当前页面</param> public void Load_Subject() { string Txt_ZyName = txtSpecName.Value.Trim() == "按专业名模糊查找" ? "" : txtSpecName.Value.Trim(); if (Txt_ZyName != "按专业名模糊查找" && Txt_ZyName != "" && FirstSxNum == 0) { apge = 1; FirstSxNum = 1; } subjectList = TbSubjectManager.GetSubject(len, apge, Txt_ZyName); Count = TbSubjectManager.GetSubject(Txt_ZyName).Rows.Count; if (Count != 0) { if (Count % len == 0) //当数据库数据能整除10,最大页面数取Count/len的商 { Maxapge = Count / len; } else { Maxapge = Count / len + 1;//当数据库数据不能整除10,最大页面数取Count/len的商+1. } } else { Maxapge = 1; } }
protected void ButtonOK_Click(object sender, EventArgs e) { TbSubject subject = new TbSubject(); subject.KmName = this.KmName.Text; subject.Remark = this.Remark.Text; subject.ZyID = int.Parse(this.ZyName.SelectedValue); if (this.HiddenKmID.Value == "") { subject.ZyID = int.Parse(this.ZyName.SelectedValue); TbSubjectManager.addSubject(subject); if (apge <= Maxapge) { Load_Subject(); } else { apge--;//到达最后一页,apge已经加一,所以需要减一 } } else { subject.KmID = int.Parse(this.HiddenKmID.Value); TbSubjectManager.Get_SubjectBy(subject); this.HiddenKmID.Value = ""; } this.KmName.Text = ""; this.Remark.Text = ""; Load_Subject(); }
public static int maxPage = 0; //定义显示页面的最大页数,初始化为0 protected void Page_Load(object sender, EventArgs e) { HttpCookie usercookie = Request.Cookies["nowloginuser"]; string url = PublicClass.CheckLogin(usercookie, "main"); if (url != "") { Response.Write(url); return; } if (!IsPostBack) { string zyid = Request["ZyID"]; if (zyid != null) { //判断是否存在科目信息,存在则提示不能删除专业信息,不存在则执行删除操作 if (TbSubjectManager.QuerySubjectInfo(int.Parse(zyid)) <= 0) { //根据专业ID删除班级、老师信息表以及专业信息表对应的信息 TbClassManager.DeleteClassByZyID(int.Parse(zyid)); TbTeacherManager.DeleteTeaByZyID(int.Parse(zyid)); TbSpecialityManager.DeleteSpecByZyID(int.Parse(zyid)); } else { Page.RegisterStartupScript("", "<script>alert('存在专业对应的科目信息,如需继续执行删除操作,请先删除科目信息!')</script>"); } } GetAllSpenIntoCount(); } }
public void GetSubject(int KmID) { TbSubject subject = TbSubjectManager.GetSubjectByID(KmID); TbSpeciality speciality = TbSpecialityManager.GetSpecialByID(subject.ZyID); string message = subject.KmID + "," + subject.KmName + "," + speciality.ZyName + "," + subject.Remark; Response.Write(message); }
/// <summary> /// 根据专业ID查询所有科目 /// </summary> /// <param name="specid">专业ID</param> public void GetSubjectBySpecid(int specid) { DataTable table = TbSubjectManager.GetSubjectListByZyid(specid); string message = ""; foreach (DataRow row in table.Rows) { message += row["KmName"].ToString() + "*"; } Response.Write(message); }
/// <summary> /// 判断科目名是否存在 /// </summary> /// <param name="KmName"></param> public void CheckSunjectNameIsExist(string KmName, int ZyID) { string KmID = Request["KmID"]; int KmNum = TbSubjectManager.GetSubjectByKmName(KmName, ZyID); if (KmNum > 0 && KmID != KmNum.ToString()) { Response.Write("已存在"); } else { Response.Write("不存在"); } }
protected void ddlSpec_SelectedIndexChanged(object sender, EventArgs e) { if (SpecID.SelectedValue.ToString() != "0") { int zyid = int.Parse(SpecID.SelectedValue.ToString()); List <TbSubject> list = TbSubjectManager.GetSubjectListByZyId(zyid); ddlSubject.DataSource = list; ddlSubject.DataValueField = "KmID"; ddlSubject.DataTextField = "KmName"; ddlSubject.DataBind(); ddlSubject.Items.Insert(0, new ListItem("请选择..")); } else { ddlSubject.Items.Clear(); ddlSubject.Text = "请选择.."; } }
public static DataTable subjectList = new DataTable(); //定义一个Table表格,初始化为null. protected void Page_Load(object sender, EventArgs e) { HttpCookie usercookie = Request.Cookies["nowloginuser"]; string url = PublicClass.CheckLogin(usercookie, "main"); if (url != "") { Response.Write(url); return; } string Sub_Sc = Request["Sub_Sc"]; if (!IsPostBack) { ZyName.Items.Clear(); List <TbSpeciality> TbSpeciality = TbSpecialityManager.GetAllSpecialityList(); ZyName.DataSource = TbSpeciality; ZyName.DataTextField = "ZyName"; ZyName.DataValueField = "ZyID"; ZyName.DataBind(); ZyName.Items.Insert(0, new ListItem("请选择..", "0")); if (Sub_Sc != null) { int count = TbTestPaperManager.GetAllTestPaperIsExist(int.Parse(Sub_Sc)); if (count <= 0) { TbSubjectManager.Dele_Sub(int.Parse(Sub_Sc)); } else { Page.RegisterStartupScript("", "<script>alert('请先删除试卷信息!!')</script>"); } } Load_Subject(); //调用方法实现数据加载。 } }