people.cs

为湖北省教委、湖北省就业指导中心订做的学历查询系统

using System;
using System.Data;
using System.Collections;
using www.kcgx.com.Database;

namespace WindowsApplication3
{
	/// <summary>
	/// 查询人员信息
	/// 吴隐峰
	/// </summary>
	public class People
	{
		#region -------属    性-------
		/// <summary>
		/// 查询人员姓名
		/// </summary>
		private string m_name;
		/// <summary>
		/// 查询人员性别
		/// </summary>
		private string m_sex;
		/// <summary>
		/// 查询人员出生日
		/// </summary>
		private string m_birthday;
		/// <summary>
		/// 查询人员层次
		/// </summary>
		private string m_classOfStudent;
		/// <summary>
		/// 查询人员学历
		/// </summary>
		private string m_diploma;
		/// <summary>
		/// 查询人员学制
		/// </summary>
		private string m_systemOfEducation;
		/// <summary>
		/// 查询人员所在学校
		/// </summary>
		private string m_school;
		/// <summary>
		/// 查询人员专业
		/// </summary>
		private string m_specialty;
		/// <summary>
		/// 查询人员毕结业情况
		/// </summary>
		private string m_conclusion;
		/// <summary>
		/// 查询人员入学日期
		/// </summary>
		private string m_enrollmentTime;
		/// <summary>
		/// 查询人员毕业时间
		/// </summary>
		private string m_graduationTime;
		/// <summary>
		/// 查询人员证书编号
		/// </summary>
		private string m_diplomaID;
		/// <summary>
		/// 是否为查询的
		/// </summary>
		private bool isQuery;
		private string m_connectingString;
		private DBAgent db = new DBAgent( );
		/// <summary>
		/// 数据库路径
		/// </summary>
		private string m_path ;
		/// <summary>
		/// 姓名
		/// </summary>
		public string Name
		{
			get
			{
				return m_name;
			}
		}
		/// <summary>
		/// 性别
		/// </summary>
		public string Sex
		{
			get
			{
				return m_sex;
			}
		}
		/// <summary>
		/// 出生日期
		/// </summary>
		public string Birthday
		{
			get
			{
				return m_birthday;
			}
		}
		/// <summary>
		/// 层次
		/// </summary>
		public string ClassOfStudent
		{
			get
			{
				return m_classOfStudent;
			}
		}
		/// <summary>
		/// 学历类型
		/// </summary>
		public string Diploma
		{
			get
			{
				return m_diploma;
			}
		}
		/// <summary>
		/// 学制
		/// </summary>
		public string SystemOfEducation
		{
			get
			{
				return m_systemOfEducation;
			}
		}
		/// <summary>
		/// 院校名称
		/// </summary>
		public string School
		{
			get
			{
				return m_school;
			}
		}
		/// <summary>
		/// 专业
		/// </summary>
		public string Specialty
		{
			get
			{
				return m_specialty;
			}
		}
		/// <summary>
		/// 毕结业结论
		/// </summary>
		public string Conclusion
		{
			get
			{
				return m_conclusion;
			}
		}
		/// <summary>
		/// 入学日期
		/// </summary>
		public string EnrollmentTime
		{
			get
			{
				return m_enrollmentTime;
			}
		}
		/// <summary>
		/// 毕业日期
		/// </summary>
		public string GraduationTime
		{
			get
			{
				return m_graduationTime;
			}
		}
		/// <summary>
		/// 证书编号
		/// </summary>
		public string DiplomaID
		{
			get
			{
				return m_diplomaID;
			}
		}
		#endregion

		#region -------构造函数-------
		/// <summary>
		/// 查询人员的具体对象
		/// </summary>
		/// <param name="name">名字</param>
		/// <param name="sex">性别</param>
		/// <param name="birthday">生日</param>
		/// <param name="classOfStudent">层次</param>
		/// <param name="diploma">学历类型</param>
		/// <param name="systemOfEducation">学制</param>
		/// <param name="school">院校名称</param>
		/// <param name="specialty">专业</param>
		/// <param name="conclusion">毕结业结论</param>
		/// <param name="enrollmentTime">入学时间</param>
		/// <param name="graduationTime">毕业时间</param>
		/// <param name="diplomaID">证书编号</param>
		/// <param name="query">是否查询</param>
		public People(string name,string sex,string birthday,string classOfStudent,string diploma,string systemOfEducation,string school,string specialty,string conclusion,string enrollmentTime,string graduationTime, string diplomaID,bool query)
		{
			this.m_name = name;
			this.m_sex = sex;
			this.m_birthday = birthday;
			this.m_classOfStudent = classOfStudent;
			this.m_diploma = diploma;
			this.m_systemOfEducation = systemOfEducation;
			this.m_school = school;
			this.m_specialty = specialty;
			this.m_conclusion = conclusion;
			this.m_enrollmentTime = enrollmentTime;
			this.m_graduationTime = graduationTime;
			this.m_diplomaID = diplomaID;
			this.m_path = Config.GetPath( );
			this.isQuery = true;
			InitDB();
		}
		
		#endregion
	
		#region-------方    法-------
		
		/// <summary>
		/// 初始化数据库
		/// </summary>
		private void InitDB()
		{
			if( isQuery )
			{
				m_connectingString = "Provider=vfpoledb.1;Data Source=" + Config.GetDir( m_diploma.ToString( ) );
				db.InitConnectionPool(m_connectingString,1);
			}
		}
 

		/// <summary>
		/// 返回查询字符串
		/// </summary>
		/// <returns></returns>
		private string GetQueryString( )
		{
			string query = "SELECT * FROM " + Config.GetTableName( m_diploma.ToString( ) , TimeChange.GetYear(m_graduationTime) ) + " WHERE ";
			if ( m_name.Trim( ).Length != 0 )
			{
				query += "xm='" + m_name.Trim( ) + "' AND ";
			}
			if ( m_sex.Trim( ).Length != 0  )
			{
				query += "xb='" + m_sex.Trim( ) + "' AND ";
			}
			if( m_birthday.Trim( ).Length != 0 )
			{
				query += "csrq='" + m_birthday.Trim( ) + "' AND ";
			}
			if ( m_classOfStudent.Trim( ).Length  != 0 )
			{
				query += "pycc='" + m_classOfStudent.Trim( ) + "' AND ";
			}
			if ( m_systemOfEducation.Trim( ).Length != 0 )
			{
				query += "xz='" + m_systemOfEducation.Trim( ) + "' AND ";
			}
			if ( m_school.Trim( ).Length != 0 )
			{
				query += "yxmc='" + m_school.Trim( ) + "' AND ";
			}
			if ( m_specialty.Trim( ).Length != 0 )
			{
				query += "zymc='" + m_specialty.Trim( ) + "' AND ";
			}
			if ( m_conclusion.Trim( ).Length != 0 )
			{
				query += "bxlx='" + m_conclusion.Trim( ) + "' AND ";
			}
			if ( m_enrollmentTime.Trim( ).Length != 0 )
			{
				query += "rxrq='" + m_enrollmentTime.Trim( ) + "' AND ";
			}
			if ( m_diplomaID.Trim( ).Length != 0 )
			{
				query += "zsbh='" + m_diplomaID.Trim( ) + "' AND ";
			}
			query = query.Substring(0,query.Length - 5);
			return query;
		}

		/// <summary>
		/// 得到比较结果
		/// </summary>
		/// <returns></returns>
		public ArrayList GetQueryObject( )
		{
			ArrayList al = new ArrayList( );
			string address = m_connectingString;
		
				DataSet ds = db.ExecuteCommand( GetQueryString( ) );
				for( int i = 0 ;i < ds.Tables[0].Rows.Count ; i++ )
				{
					string name = ds.Tables[0].Rows[i]["xm"].ToString( ).Trim( );
					string sex = ds.Tables[0].Rows[i]["xb"].ToString( ).Trim( );
					string birthday = ds.Tables[0].Rows[i]["csrq"].ToString( );
					string classOfStudent = ds.Tables[0].Rows[i]["pycc"].ToString( ).Trim( );
					string diploma = ds.Tables[0].Rows[i]["xxxs"].ToString( ).Trim( );
					string systemOfEducation = ds.Tables[0].Rows[i]["xz"].ToString( ).Trim( );
					string school = ds.Tables[0].Rows[i]["yxmc"].ToString( ).Trim( );
					string specialty = ds.Tables[0].Rows[i]["zymc"].ToString( ).Trim( );
					string conclusion = ds.Tables[0].Rows[i]["bjyjl"].ToString( ).Trim( );
					string enrollmentTime = ds.Tables[0].Rows[i]["rxrq"].ToString( );
					string graduationTime = ds.Tables[0].Rows[i]["byrq"].ToString( );
					string diplomaID = ds.Tables[0].Rows[i]["zsbh"].ToString( ).Trim( );
					al.Add( new People(name,sex,birthday,classOfStudent,diploma,systemOfEducation,school,specialty,conclusion,enrollmentTime,graduationTime,diplomaID,false));
				}
				return al;
			
		}
			
		#endregion
	}
}