student.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;
#region Student
	/// <summary>
	/// This object represents the properties and methods of a Student.
	/// </summary>
	public class Student
	{
		protected string _id;
		protected int _departmentID;
		protected int _majorID;
		protected string _sName = String.Empty;
		protected string _password = String.Empty;
		protected string _tel = String.Empty;
		protected string _email = String.Empty;
		protected string _address = String.Empty;
		protected string _other = String.Empty;
        protected string _grade = String.Empty;
		
		public Student()
		{
		}
		
		public Student(string id)
		{
            DbDataReader reader = DataAccess.ExecuteDataReader("usp_SelectStudent", false, new object[] { id });
			
			if (reader.Read()) 
			{
				this.LoadFromReader(reader);
				reader.Close();
			}
			else
			{
				if (!reader.IsClosed) reader.Close();
				throw new ApplicationException("Student does not exist.");
			}
		}
		
		public Student(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)) _sName = reader.GetString(3);
				if (!reader.IsDBNull(4)) _password = reader.GetString(4);
				if (!reader.IsDBNull(5)) _tel = reader.GetString(5);
				if (!reader.IsDBNull(6)) _email = reader.GetString(6);
				if (!reader.IsDBNull(7)) _address = reader.GetString(7);
				if (!reader.IsDBNull(8)) _other = reader.GetString(8);
                if (!reader.IsDBNull(9)) _grade = reader.GetString(9);
                {
                }
			}
		}
		
		#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 SName
		{
			get {return _sName;}
			set {_sName = value;}
		}

        public string Grade
        {
            get { return _grade; }
            set { _grade = value; }
        }

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

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

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

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

		public string Other
		{
			get {return _other;}
			set {_other = value;}
		}
		#endregion
		
		public static Student GetStudent(string id)
		{
			return new Student(id);
		}
        public static string GetMajorNameByStudentID(string StudentID)
        {
            string name = "";
            string sql = @"SELECT Major.MajorName
                           FROM  Major INNER JOIN
                           Student ON Major.MajorID = Student.MajorID
                           WHERE Student.StudentID = '" + StudentID + "'";
            DbDataReader reader = DataAccess.ExecuteDataReader(sql);
            if (reader.Read())
            {
                name = reader.GetString(0);
            }
            reader.Close();
            return name;
        }
	}
	#endregion