teacher.cs

在线 图书网上购物系统

using System;
using System.Data;
using System.Configuration;
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 System.Data.Common;
using System.Web.Management;
#region Teacher
	/// <summary>
	/// This object represents the properties and methods of a Teacher.
	/// </summary>
	public class Teacher
	{
		protected string _id;
		protected int _departmentID;
		protected int _majorID;
		protected string _tName = String.Empty;
		protected string _password = String.Empty;
		protected string _tel = String.Empty;
		protected string _address = String.Empty;
		protected string _email = String.Empty;
		protected string _other = String.Empty;
		protected short _canInstructNum;
		protected short _alreadyInstructNum;
		
		public Teacher()
		{
		}
		
		public Teacher(string id)
		{
            DbDataReader reader = DataAccess.ExecuteDataReader("usp_SelectTeacher", false, new object[] { id });
			if (reader.Read()) 
			{
				this.LoadFromReader(reader);
				reader.Close();
			}
			else
			{
				if (!reader.IsClosed) reader.Close();
				throw new ApplicationException("Teacher does not exist.");
			}
		}
		
		public Teacher(DbDataReader reader)
		{
			this.LoadFromReader(reader);
		}
		
		protected void LoadFromReader(DbDataReader reader)
		{
			if (reader != null && !reader.IsClosed)
			{
				_id = reader.GetString(0);
				if (!reader.IsDBNull(1)) _departmentID = reader.GetInt32(1);
				if (!reader.IsDBNull(2)) _majorID = reader.GetInt32(2);
				if (!reader.IsDBNull(3)) _tName = reader.GetString(3);
				if (!reader.IsDBNull(4)) _password = reader.GetString(4);
				if (!reader.IsDBNull(5)) _tel = reader.GetString(5);
				if (!reader.IsDBNull(6)) _address = reader.GetString(6);
				if (!reader.IsDBNull(7)) _email = reader.GetString(7);
				if (!reader.IsDBNull(8)) _other = reader.GetString(8);
				if (!reader.IsDBNull(9)) _canInstructNum = reader.GetInt16(9);
				if (!reader.IsDBNull(10)) _alreadyInstructNum = reader.GetInt16(10);
			}
		}
		
		#region Public Properties
		public string Id
		{
			get {return _id;}
		}
		
		public int DepartmentID
		{
			get {return _departmentID;}
			set {_departmentID = value;}
		}

		public int MajorID
		{
			get {return _majorID;}
			set {_majorID = value;}
		}

		public string TName
		{
			get {return _tName;}
			set {_tName = value;}
		}

		public string Password
		{
			get {return _password;}
			set {_password = value;}
		}

		public string Tel
		{
			get {return _tel;}
			set {_tel = value;}
		}

		public string Address
		{
			get {return _address;}
			set {_address = value;}
		}

		public string Email
		{
			get {return _email;}
			set {_email = value;}
		}

		public string Other
		{
			get {return _other;}
			set {_other = value;}
		}

		public short CanInstructNum
		{
			get {return _canInstructNum;}
			set {_canInstructNum = value;}
		}

		public short AlreadyInstructNum
		{
			get {return _alreadyInstructNum;}
			set {_alreadyInstructNum = value;}
		}
		#endregion
		
		public static Teacher GetTeacher(string id)
		{
			return new Teacher(id);
		}
	}
	#endregion