job.cs

精通SQL Server2005项目开发

using System;
using System.Data;
using System.Collections;

using HRManager.DataAccessLayer;
using HRManager.DataAccessHelper;
using HRManager.CommonComponent;


namespace HRManager.BusinessLogicLayer
{
    /// <summary>
    /// Job 的摘要说明。
    /// </summary>
    public class Job
    {
        #region 私有成员

        private int _jobId;			//职位Id
        private string _jobName;		//职位
        private int _jobCityId;			//职位所在城市Id
        private string _jobCityName;			//职位所在城市
        private int _jobTypeId;			//职位种类Id
        private string _jobTypeName;			//职位种类
        private string _responsibility;		//职位职责
        private string _requirement;		//职位要求
        private bool _isUrgent;		//是否紧急

        private bool _exist;		//是否存在标志

        #endregion 私有成员

        #region 属性

        //职位Id
        public int JobId
        {
            set
            {
                this._jobId = value;
            }
            get
            {
                return this._jobId;
            }
        }
        //职位
        public string JobName
        {
            set
            {
                this._jobName = value;
            }
            get
            {
                return this._jobName;
            }
        }
        //职位所在城市Id
        public int JobCityId
        {
            set
            {
                this._jobCityId = value;
            }
            get
            {
                return this._jobCityId;
            }
        }
        //职位所在城市
        public string JobCityName
        {
            set
            {
                this._jobCityName = value;
            }
            get
            {
                return this._jobCityName;
            }
        }
        //职位种类Id
        public int JobTypeId
        {
            set
            {
                this._jobTypeId = value;
            }
            get
            {
                return this._jobTypeId;
            }
        }
        //职位种类
        public string JobTypeName
        {
            set
            {
                this._jobTypeName = value;
            }
            get
            {
                return this._jobTypeName;
            }
        }
        //职位职责
        public string Responsibility
        {
            set
            {
                this._responsibility = value;
            }
            get
            {
                return this._responsibility;
            }
        }
        //职位要求
        public string Requirement
        {
            set
            {
                this._requirement = value;
            }
            get
            {
                return this._requirement;
            }
        }
        //是否紧急
        public bool IsUrgent
        {		
            set
            {
                this._isUrgent = value;
            }
            get
            {
                return this._isUrgent;
            }
        }
        //存在标志
        public bool Exist
        {
            get
            {
                return this._exist;
            }
        }

        #endregion 属性

        #region 方法

        /// <summary>
        /// 根据参数JobId，获取职位详细信息
        /// </summary>
        /// <param name="JobId">职位ID</param>
        public void LoadData(int JobId)
        {
            Database db = new Database();		//实例化一个Database类

            string sql = "";
            sql = "Select * from [Job],[City],[JobType] where JobId = " + JobId
                + " And [Job].JobCityId=[City].CityId"
                + " And [Job].JobTypeId=[JobType].TypeId";

            DataRow dr = db.GetDataRow(sql);	//利用Database类的GetDataRow方法查询职位数据

            //根据查询得到的数据，对成员赋值
            if (dr != null)
            {
                this._jobId = GetSafeData.ValidateDataRow_N(dr, "JobID");
                this._jobName = GetSafeData.ValidateDataRow_S(dr, "JobName");
                this._jobCityId = GetSafeData.ValidateDataRow_N(dr, "CityId");
                this._jobCityName = GetSafeData.ValidateDataRow_S(dr, "CityName");
                this._jobTypeId = GetSafeData.ValidateDataRow_N(dr, "JobTypeId");
                this._jobTypeName = GetSafeData.ValidateDataRow_S(dr, "TypeName");
                this._responsibility = GetSafeData.ValidateDataRow_S(dr, "Responsibility");
                this._requirement = GetSafeData.ValidateDataRow_S(dr, "Requirement");
                this._isUrgent =Convert.ToBoolean( GetSafeData.ValidateDataRow_N(dr, "IsUrgent"));

                this._exist = true;
            }
            else
            {
                this._exist = false;
            }
        }

        /// <summary>
        /// 向数据库添加一个职位
        /// </summary>
        /// <param name="htUserInfo">职位信息哈希表</param>
        public static void Add(Hashtable JobInfo)
        {
            Database db = new Database();	//实例化一个Database类
            db.Insert("[Job]", JobInfo);	//利用Database类的Insert方法添加职位数据
        }

        /// <summary>
        /// 查询职位
        /// </summary>
        /// <param name="queryItems">“AND”子句查询条件哈希表</param>
        /// <returns>以DataTable形式返回查询结果数据</returns>
        public static DataTable Query(Hashtable queryItems)
        {
            string where = SqlStringConstructor.GetConditionClause(queryItems);

            string sql = "Select * From [Job],[City],[JobType]";

            if (where == "")
            {
                where = " Where [Job].JobCityId=[City].CityId"
                + " And [Job].JobTypeId=[JobType].TypeId";
            }
            else
            {
                where += " And [Job].JobCityId=[City].CityId"
                + " And [Job].JobTypeId=[JobType].TypeId";
            }

            sql += where;

            Database db = new Database();
            return db.GetDataTable(sql);
        }

        /// <summary>
        /// 全文搜索，即在：职位名称、职责、要求、城市、类别中查找关键字
        /// </summary>
        /// <param name="keyWords">关键字集合</param>
        public static DataTable KeyWordsSearch(ArrayList keyWords)
        {
            string sql = "Select * From [Job],[City],[JobType]";
            string where = " Where ";

            foreach (string key in keyWords)
            {
                where += "( [Job].JobName Like '%"+key+"%' ";
                where += "Or [Job].Responsibility Like '%" + key + "%' ";
                where += "Or [Job].Requirement Like '%" + key + "%' ";
                where += "Or [JobType].TypeName Like '%" + key + "%' ";
                where += "Or [City].CityName Like '%" + key + "%') ";
                where += " And ";
            }

            where += " [Job].JobCityId=[City].CityId"
            + " And [Job].JobTypeId=[JobType].TypeId";

            sql += where;
            Database db = new Database();
            return db.GetDataTable(sql);
        }

        #endregion 方法
    }
}