addpaper.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 AddPaper.
	/// </summary>
	public class AddPaper : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid PaperList;
		protected System.Web.UI.WebControls.Button AddPaperBtn;
		protected System.Web.UI.WebControls.TextBox TotalMark;
		protected System.Web.UI.WebControls.TextBox MinDefficult;
		protected System.Web.UI.WebControls.TextBox MaxDefficult;
		protected System.Web.UI.WebControls.DataGrid KindList;
		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)
			{
				BindKindData();
			}
		}

		private void BindKindData()
		{
			QuestionKindDB kind = new QuestionKindDB();
			SqlDataReader reck = kind.GetQuesKinds();

			KindList.DataSource = reck;
			KindList.DataKeyField = "KindID";
			KindList.DataBind();
		   
			reck.Close();
		}

		private void BindPaperData(ArrayList aPaperList)
		{
			PaperList.DataSource = aPaperList;
			PaperList.DataKeyField = "KindID";
			PaperList.DataBind();
		}

		private bool AddKindToPaper(ArrayList aKindList,PaperKinds paperKind)
		{
			bool isexist = false;
			for(int i = 0; i < aKindList.Count; i++)
			{
				if(paperKind.KindID == ((PaperKinds)aKindList[i]).KindID)
				{
					isexist = true;
				}
			}
			return(isexist);
		}

		#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.KindList.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.KindList_ItemCommand);
			this.PaperList.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.PaperList_ItemCommand);
			this.AddPaperBtn.Click += new System.EventHandler(this.AddPaperBtn_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void KindList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName.ToLower() == "add")
			{
				Button addKind = (Button)e.Item.FindControl("AddKindToPaper");
				if(addKind != null)
				{
					ArrayList aKindList = new ArrayList();
					if(Session[Session.SessionID + "Paper"] != null)
					{						
						aKindList = (ArrayList)Session[Session.SessionID + "Paper"];
					}
					PaperKinds paperKind = new PaperKinds();
					paperKind.KindID = Int32.Parse(KindList.DataKeys[e.Item.ItemIndex].ToString());
					Label kindName = (Label)e.Item.FindControl("KindName");
					if(kindName != null)
					{
						paperKind.KindName = kindName.Text;
					}
					if(AddKindToPaper(aKindList,paperKind) == false)
					{
						aKindList.Add(paperKind);
						Session[Session.SessionID + "Paper"] = aKindList;
						if(aKindList.Count > 0)
						{
							BindPaperData(aKindList);
							PaperList.Visible = true;
						}
					}
					else
					{
						Response.Write("<script>alert(\"你选中的试题类型已经添加了，请重新选择！！！\")</script>");
					}
				}
			}
		}

		private void PaperList_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			if(e.CommandName.ToLower() == "delete")
			{
				ImageButton deleteKind = (ImageButton)e.Item.FindControl("DeleteKind");
				if(deleteKind != null)
				{
					ArrayList aKindList = new ArrayList();
					if(Session[Session.SessionID + "Paper"] != null)
					{						
						aKindList = (ArrayList)Session[Session.SessionID + "Paper"];
					}
					for(int i = 0; i < aKindList.Count; i++)
					{
						if(((PaperKinds)aKindList[i]).KindID.ToString() == PaperList.DataKeys[e.Item.ItemIndex].ToString())
						{
							aKindList.RemoveAt(i);
							break;
						}
					}

					Session[Session.SessionID + "Paper"] = aKindList;
					if(aKindList.Count > 0)
					{
						BindPaperData(aKindList);
						PaperList.Visible = true;
					}
					else
					{
						PaperList.Visible = false;
					}
				}
			}
		}

		private void AddPaperBtn_Click(object sender, System.EventArgs e)
		{
			PaperDB paper = new PaperDB();
			PaperKindDB paperKind = new PaperKindDB();
			int nPaperID = 0;

			ArrayList aKindList = new ArrayList();
			if(Session[Session.SessionID + "Paper"] != null)
			{						
				aKindList = (ArrayList)Session[Session.SessionID + "Paper"];
			}

			try
			{
				nPaperID = paper.AddPaper(Int32.Parse(TotalMark.Text.Trim()),Int32.Parse(MinDefficult.Text.Trim())*100,
					Int32.Parse(MaxDefficult.Text.Trim())*100,Int32.Parse(Session["UserID"].ToString()),
					1);
				for(int i = 0; i < aKindList.Count; i++)
				{
					foreach(DataGridItem item in PaperList.Items)
					{
						if(PaperList.DataKeys[item.ItemIndex].ToString() == ((PaperKinds)aKindList[i]).KindID.ToString())
						{
							TextBox kindNum = (TextBox)item.FindControl("Quantity");
							if(kindNum != null)
							{
								paperKind.AddPaperKind(nPaperID,((PaperKinds)aKindList[i]).KindID,Int32.Parse(kindNum.Text.Trim()));
							}
							break;
						}
					}
				}
				Response.Write("<script>alert(\"构建试卷成功！！！\")</script>");
			}
			catch(Exception ex)
			{
				Response.Write("<script>alert(\"构建试卷错误，错误原因如下："  + ex.Message + "\")</script>");
			}
		}
	}
}