deletepaper.aspx.cs

用ASP.NET（C#）、SQL Server2000数据库开发在线考试系统源代码

using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;

namespace ExamineSystem
{
	/// <summary>
	/// Summary description for DeletePaper.
	/// </summary>
	public class DeletePaper : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.ImageButton deleteBtn;
		protected System.Web.UI.WebControls.ListBox PaperList;
		protected System.Web.UI.HtmlControls.HtmlGenericControl title;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			///验证用户的权限
			if(Session["UserID"] == null)
			{
				Response.Redirect("~/Default.aspx");
			}
			

			if(!Page.IsPostBack)
			{
				BindData();
			}

			deleteBtn.Attributes.Add("onclick","return confirm('你确定要删除所选择的项吗?');");
		}

		private void BindData()
		{
			PaperList.Items.Clear();

			PaperDB paper = new PaperDB();
			SqlDataReader recm = paper.GetPapers();

			int i = 0;
			while(recm.Read())
			{
				i++;
				PaperList.Items.Add(new ListItem("试卷" + i.ToString(),recm["PaperID"].ToString()));
			}
			recm.Close();
		}

		private void EditDeleteBtn_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			String commandName = ((ImageButton)sender).CommandName;
		
			if(PaperList.SelectedIndex > -1)
			{
				switch(commandName)
				{
					case "delete":
					{
						DeletePaperInfo();
						break;
					}
					default:
					{
						break;
					}
				}
				if(commandName == "delete")
				{
					BindData();
				}
			}
			else
			{
				Response.Write("<script>alert(\"请选择你的数据项！\")</script>");
			}		
		}

		private void DeletePaperInfo()
		{
			PaperDB paper = new PaperDB();
			if(Int32.Parse(PaperList.SelectedValue) > 0)
			{
				paper.DeletePaper(Int32.Parse(PaperList.SelectedValue));
			}	
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.deleteBtn.Click += new System.Web.UI.ImageClickEventHandler(this.EditDeleteBtn_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}