studentlistclasses.ascx.cs

电子选课系统 电子选课系统电子选课系统电子选课系统

namespace Park.StudentSystem
{
	using System;
	using System.Data;
	using System.Data.SqlClient;
	using System.Drawing;
	using System.Web;
	using System.Web.UI.WebControls;
	using System.Web.UI.HtmlControls;
	using Park.Common;

	/// <summary>
	///		StudentListClasses 的摘要说明。
	/// </summary>
	public abstract class StudentListClasses : System.Web.UI.UserControl
	{
		protected System.Web.UI.WebControls.DataGrid ClassList;

		private void Page_Load(object sender, System.EventArgs e)
		{//处理退选操作
			ProcessDeleted();
//列出所有已选课程信息
			ListCourses();
//如果操作失败，显示错误信息
			SendMessage();
		}

		private void 	SendMessage()
		{
			if(rows<2) Message.Text = "选课不能少于两门";		
		}

		private void ProcessDeleted()
		{
			string id=Request["removeid"];
			if(id != null && !id.Equals("")) 
			{
				int i =	StudentSystemDB.DeleteClass( ((Park.MainPage)Page).UserName , id );
				if ( i == 1) Utils.Error(this.Page,"选课时间过期");
				if ( i == 2) Utils.Error(this.Page,"选课不能少于两门");
			}
		}

		protected System.Web.UI.WebControls.Label Message;
		
		protected int rows=0;

		public void ListCourses()
		{
			SqlConnection CourseConn	= Utils.GetConnection();
			CourseConn.Open();

			SqlCommand SeltedCommand	= new SqlCommand("StudentSystem_List_Classes",   CourseConn);

			SeltedCommand.CommandType	= CommandType.StoredProcedure;

			// Add Parameters to SPROC
			SqlParameter StudentID = new SqlParameter("@studentid", SqlDbType.NVarChar, 20);
			StudentID.Value = ((Park.MainPage)Page).UserName;
			SeltedCommand.Parameters.Add(StudentID);

			SqlDataReader SeltedReader = SeltedCommand.ExecuteReader();
			ClassList.DataSource = SeltedReader;
			ClassList.DataBind();

			SeltedCommand.Dispose();
			CourseConn.Dispose();
			return ;
		}
		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN：该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		///		设计器支持所需的方法 - 不要使用
		///		代码编辑器修改此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{
			this.ClassList.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.ClassList_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ClassList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			switch(e.Item.ItemType)
			{
				case ListItemType.AlternatingItem :
					rows++;
					break;
				case ListItemType.Item :
					rows++;
					break;
				default:
					break;
			}
		}
	}
}