private void BindsTypes() { ddlCourseId.DataSource = CourseBLL.AllData("", "CourseId", ""); ddlCourseId.DataTextField = "CourseName"; ddlCourseId.DataValueField = "CourseId"; ddlCourseId.DataBind(); ddlSutId.DataSource = SudentsBLL.AllData("", "SutId", ""); ddlSutId.DataTextField = "SutName"; ddlSutId.DataValueField = "SutId"; ddlSutId.DataBind(); ddlSemesterId.DataSource = SemesterBLL.AllData("", "SemesterId", ""); ddlSemesterId.DataTextField = "SemesterName"; ddlSemesterId.DataValueField = "SemesterId"; ddlSemesterId.DataBind(); ddlSemesterName.DataSource = SemesterBLL.AllData("", "SemesterId", ""); ddlSemesterName.DataTextField = "SemesterName"; ddlSemesterName.DataValueField = "SemesterId"; ddlSemesterName.DataBind(); ddlSemesterName.Items.Insert(0, new ListItem("全部", "0")); ddlCourseName.DataSource = CourseBLL.AllData("", "CourseId", ""); ddlCourseName.DataTextField = "CourseName"; ddlCourseName.DataValueField = "CourseId"; ddlCourseName.DataBind(); ddlCourseName.Items.Insert(0, new ListItem("全部", "0")); }
//添加、修改 protected void btnAdd_Click(object sender, EventArgs e) { if (btnAdd.Text == "添加") { Semester model = new Semester(); model.SemesterName = txtSemesterName.Value.Trim(); if (SemesterBLL.IsTrue(model.SemesterName)) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该学期名称已存在,不能重复!');</script>"); return; } else { if (SemesterBLL.AddSemester(model) > 0) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加成功!');window.location.replace('SemesterManage.aspx');</script>"); return; } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('添加失败!');</script>"); return; } } } else { Semester model = SemesterBLL.GetIdBySemester(Convert.ToInt32(Request.QueryString["uid"])); model.SemesterName = txtSemesterName.Value.Trim(); if (SemesterBLL.IsTrue(model.SemesterName, model.SemesterId)) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('该学期名称已存在,不能重复!');</script>"); return; } else { if (SemesterBLL.UpdateSemester(model) > 0) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改成功!');window.location.replace('SemesterManage.aspx');</script>"); return; } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('修改失败!');</script>"); return; } } } }
protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { if (Request.QueryString["uid"] != null) { Semester model = SemesterBLL.GetIdBySemester(Convert.ToInt32(Request.QueryString["uid"])); txtSemesterName.Value = model.SemesterName.Trim(); btnAdd.Text = "修改"; } Binds(); } }
protected void lnkbDel_Click(object sender, EventArgs e) { LinkButton lnkbDel = (LinkButton)sender; if (SemesterBLL.DeleteSemester(Convert.ToInt32(lnkbDel.CommandArgument)) > 0) { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除成功!');window.location.replace('SemesterManage.aspx');</script>"); return; } else { this.Page.ClientScript.RegisterStartupScript(this.GetType(), "", "<script>alert('删除失败!');</script>"); return; } }
private void Binds() { ddlCourseId.DataSource = CourseBLL.AllData("", "CourseId", ""); ddlCourseId.DataTextField = "CourseName"; ddlCourseId.DataValueField = "CourseId"; ddlCourseId.DataBind(); ddlSemesterId.DataSource = SemesterBLL.AllData("", "SemesterId", ""); ddlSemesterId.DataTextField = "SemesterName"; ddlSemesterId.DataValueField = "SemesterId"; ddlSemesterId.DataBind(); rpView.DataSource = ResultsBLL.AllData(" and SutId=" + sudents.SutId, "ResultsId", "asc"); rpView.DataBind(); }
private void Binds() { rpView.DataSource = SemesterBLL.AllData("", "SemesterId", "asc"); rpView.DataBind(); }