teacher.cs

学生类：Student 教师类：Teacher 主任：AdminTeacher 班主任：MasterTeacher 授课老师： PrelectTeacher 班级类：classTeam 班

using System;
using System.Windows.Forms;
using System.Data;
using System.Data.SqlClient;
using System.Collections;
using DataAccess;
using Forms;

namespace BusinessRule
{
	/// <summary>
	/// Teacher 的摘要说明。
	/// 1.	在添加一个新教师时，才可以用默认构造方法。
	/// 2.	在实例化教师类之前，如果不能确定教师编号是否在数据库中存在，比如由界面层手动输入教师编号，
	/// 则应首先判断编号和理性（jimmy.teaIDJude()）
	/// 总之在实例化教师类之前，务必确定编号合理！！！
	/// 3.	在实例化已存在的教师实例时，传入教师编号作为参数
	/// </summary>
	public class Teacher						//教师基类
	{
		private int teaID ;						//教师编号
		private char teaLimit = 'T';			//教师权限，分三种：T,M,A
		private string teaName = null;			//姓名
		private bool teaSex = true;				//性别
		private string teaOrigin = null;		//籍贯
		private string teaNation = null;		//民族
		private string teaTelephone = null;		//联系电话
		private string teaAddress = null;		//地址
		private string teaPostcode = null;		//邮编
		private string teaPicture = null;		//照片目录
		private bool teaIn_Service = true;		//是否在职
		private string teaRemark = null;		//备注
		private ArrayList teaClasses = null;	//教师可以管理或者查看的班级的班级编号集合

		public Teacher()
		{
			//默认构造方法
		}

		//构造方法
		public Teacher(int teaID)
		{
			this.teaID = teaID;
			
			//获得教师信息表中数据
			SqlDataReader myRd = jimmy.GetTeaInfoByTeaID(teaID);
			myRd.Read();

			this.teaLimit = char.Parse((string)myRd["teaLimit"]);
			this.teaName = (string)myRd["teaName"];
			this.teaSex = (bool)myRd["teaSex"];
			this.teaOrigin = (string)myRd["teaOrigin"];
			this.teaNation = (string)myRd["teaNation"];
			this.teaTelephone = (string)myRd["teaTelephone"];
			this.teaAddress = (string)myRd["teaAddress"];
			this.teaPostcode = (string)myRd["teaPostcode"];
			this.teaPicture = (string)myRd["teaPicture"];
			this.teaIn_Service = (bool)myRd["teaIn_Service"];
			this.teaRemark = (string)myRd["teaRemark"];		
			this.teaClasses = jimmy.GetClassesByTeaID(teaID);
		}

		//修改密码方法
		public void NewPassWord(string teaPassWord)
		{
			string select = "Update TeacherPassWordInfo set teaPassWord = '"
				+ teaPassWord + "' where teaID = " + teaID.ToString();
			jimmy.DoSqlString(select);
		}

		//判断用户名和密码是否匹配
		public bool CheckUp(int teaID,string teaPassWord)
		{
			return jimmy.CheckUp(teaID,teaPassWord);
		}
			
		//获得所有教师编号
		public SqlDataReader GetAllTeaID()
		{
			string select = "select teaID from TeacherInfo where teaID != 10000 group by teaID";
			return jimmy.GetDataReaderBySqlString(select);
		}

		//获得所有教师姓名
		public SqlDataReader GetAllTeaName()
		{
			string select = "select distinct teaName from TeacherInfo where teaID != 10000";
			return jimmy.GetDataReaderBySqlString(select);
		}

		//获得所有班级编号
		public SqlDataReader GetAllClaID()
		{
			string select = "select claID from ClassInfo where claID != '0000'";
			return jimmy.GetDataReaderBySqlString(select);
		}

		//查询所有教师信息
		public DataTable GetAllTeaInfo()
		{
			string select = "select * from View_TeacherInfo ";
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得教师编号，返回教师信息
		public DataTable GetTeaInfoByTeaID(int teaID)
		{
			string select = "select * from View_TeacherInfo where teaID = " + teaID.ToString();
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得教师姓名，返回教师信息
		public DataTable GetTeaInfoByTeaName(string teaName)
		{
			string select = "select * from View_TeacherInfo where teaName = '" + teaName + "'";
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得班级编号，返回相关教师信息
		public DataTable GetTeaInfoByClaID(string claID)
		{
			string select = "select * from View_TeacherInfo where teaID in (select teaID from PrelectInfo where claID = '"
				+ claID + "') or teaID = (select claMasterID from ClassInfo where claID = '" + claID + "')";
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得职务信息，返回相关教师信息
		public DataTable GetTeaInfoByTeaCourse(string course)
		{
			string select = "select * from View_TeacherInfo where teaID in " 
				+ "( select distinct teaID from PrelectInfo where Remark like '%" + course + "%')";
			return jimmy.GetDataTableBySqlString(select);
		}

		//获得班级编号，返回该班所有学生的编号、姓名
		public DataTable GetStuIDStuNameByClaID(string claID)
		{
			char Grade = jimmy.ClassGradeJudge(claID);
			string select = "select stuID,stuName from StudentInfo where stuGrade" + Grade 
				+ " = '" + claID + "'";
			return jimmy.GetDataTableBySqlString(select);
		}
		
		//返回所有教室编号
		public SqlDataReader GetAllClaRoomID()
		{
			return jimmy.GetAllClaRoomID();
		}

		//获得班级编号，返回相关教师使用信息
		public DataTable GetClassRoomUserByClaID(string claID)
		{
			return jimmy.GetClassRoomUserByClaID(claID);
		}

		//返回所有教师使用信息
		public DataTable GetAllClassRoomUserInfo()
		{
			return jimmy.GetAllClassRoomUserInfo();
		}

		//获得教室编号，返回教师使用信息
		public DataTable GetClassRoomUserByCrID(string crID)
		{
			return jimmy.GetClassRoomUserByCrID(crID);
		}

		//获得班级编号，判断是否处于上课状态
		public bool CheckClassIsOn(string claID)
		{
			return jimmy.CheckClassIsOn(claID);
		}
		#region 为成员变量建立属性
		//教师编号 只读属性
		public int TeaID
		{
			get
			{
				return this.teaID;
			}
		}
		//教师权限 读/写属性
		public char TeaLimit
		{
			get
			{
				return this.teaLimit;
			}
			set
			{
				this.teaLimit = value;
			}
		}
		//姓名 读/写属性
		public string TeaName
		{
			get
			{
				return this.teaName;
			}
			set
			{
				this.teaName = value;
			}
		}
		//性别 读/写属性
		public bool TeaSex
		{
			get
			{
				return this.teaSex;
			}
			set
			{
				this.teaSex = value;
			}
		}
		//籍贯 读/写属性
		public string TeaOrigin
		{
			get
			{
				return this.teaOrigin;
			}
			set
			{
				this.teaOrigin = value;
			}
		}
		//民族  读/写属性
		public string TeaNation
		{
			get
			{
				return this.teaNation;
			}
			set
			{
				this.teaNation = value;
			}
		}
		//联系电话 读/写属性
		public string TeaTelephone
		{
			get
			{
				return this.teaTelephone;
			}
			set
			{
				this.teaTelephone = value;
			}
		}
		//地址 读/写属性
		public string TeaAddress
		{
			get
			{
				return this.teaAddress;
			}
			set
			{
				this.teaAddress = value;
			}
		}
		//邮政编码 读/写属性
		public string TeaPostcode
		{
			get
			{
				return this.teaPostcode;
			}
			set
			{
				this.teaPostcode = value;
			}
		}
		//图片目录 读/写属性
		public string TeaPicture
		{
			get
			{
				return this.teaPicture;
			}
			set
			{
				this.teaPicture = value;
			}
		}
		//是否在职 读/写属性
		public bool TeaIn_Service
		{
			get
			{
				return this.teaIn_Service;
			}
			set
			{
				this.teaIn_Service = value;
			}
		}
		//备注 读/写属性
		public string TeaRemark
		{
			get
			{
				return this.teaRemark;
			}
			set
			{
				this.teaRemark = value;
			}
		}
		//可管理的班机编号 读/写属性
		public ArrayList TeaClasses
		{
			get
			{
				return this.teaClasses;
			}
			set
			{
				this.teaClasses = value;
			}
		}
		#endregion


	}
}