coursemanage.aspx.cs

来自「《精通ASP.NET2.0网络应用系统开发》书中的源码」· CS 代码 · 共 99 行

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using StudentManager;
using System.Data.SqlClient;

public partial class CourseManage : System.Web.UI.Page
{
	protected void Page_Load(object sender,EventArgs e)
	{
		if (!Page.IsPostBack)
		{
			///绑定控件的数据
			BindCourseData();
		}

		///添加删除确认对话框
		deleteBtn.Attributes.Add("onclick","return confirm('" + ASPNET2System.OPERATIONDELETEMESSAGE + "');");
	}

	private void BindCourseData()
	{
		///定义获取数据的类
		Course course = new Course();
		SqlDataReader recc = course.GetCourses();

		///设定控件的数据源
		CourseList.DataSource = recc;

		///设定控件的Text属性和Value属性
		CourseList.DataTextField = "Desn";
		CourseList.DataValueField = "CourseID";

		///绑定控件的数据
		CourseList.DataBind();

		///关闭数据读取器和数据库的连接
		recc.Close();
	}

	protected void AddBtn_Click(object sender,EventArgs e)
	{
		///跳转到添加页面
		Response.Redirect("~/DesktopModules/Course/AddCourse.aspx");
	}
	
	protected void deleteBtn_Click(object sender,ImageClickEventArgs e)
	{
		if (CourseList.SelectedIndex > -1)
		{
			///定义类Course
			Course course = new Course();
			try
			{
				///删除
				course.DeleteCourse(Int32.Parse(CourseList.SelectedValue));

				///显示操作结果信息
				Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONDELETESUCCESSMESSAGE + "')</script>");

				///重新绑定数据
				BindCourseData();
			}
			catch (Exception ex)
			{
				///显示添加操作中的失败、错误信息
				Response.Redirect("~/DesktopModules/ErrorPage.aspx?ErrorUrl="
					+ ASPNET2System.RedirectErrorUrl(Request.RawUrl)
					+ "&ErrorMessage=" + ex.Message.Replace("\n"," "));
			}
		}
		else
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
		}
	}
	protected void editBtn_Click(object sender,ImageClickEventArgs e)
	{
		if (CourseList.SelectedIndex > -1)
		{
			///跳转到查看页面
			Response.Redirect("~/DesktopModules/Course/UpdateCourse.aspx?CourseID=" + CourseList.SelectedValue);
		}
		else
		{
			///显示操作结果信息
			Response.Write("<script>window.alert('" + ASPNET2System.OPERATIONNOSELECTMESSAGE + "')</script>");
		}
	}
}