jobtype.cs

精通SQL Server2005项目开发

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

using HRManager.DataAccessLayer;
using HRManager.DataAccessHelper;

namespace HRManager.BusinessLogicLayer
{
    /// <summary>
    /// 职位种类类
    /// </summary>
    public class JobType
    {
        #region 私有成员

        private int _typeId;			//职位种类ID
        private string _typeName;		//职位种类名

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

        #endregion 私有成员

        #region 属性

        public int TypeId
        {
            set
            {
                this._typeId = value;
            }
            get
            {
                return this._typeId;
            }
        }
        public string TypeName
        {
            set
            {
                this._typeName = value;
            }
            get
            {
                return this._typeName;
            }
        }
        public bool Exist
        {
            get
            {
                return this._exist;
            }
        }

        #endregion 属性

        #region 方法

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

            string sql = "";
            sql = "Select * from [JobType] where TypeId = " + typeId;

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

            //根据查询得到的数据，对成员赋值
            if (dr != null)
            {
                this._typeId = GetSafeData.ValidateDataRow_N(dr, "TypeId");
                this._typeName = GetSafeData.ValidateDataRow_S(dr, "TypeName");

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

        /// <summary>
        /// 根据查询条件哈希表,查询数据
        /// </summary>
        /// <param name="queryItems">查询条件哈希表</param>
        /// <returns>查询结果数据DataTable</returns>
        public static DataTable Query(Hashtable queryItems)
        {
            string where = SqlStringConstructor.GetConditionClause(queryItems);
            string sql = "Select * From [JobType]" + where;
            Database db = new Database();
            return db.GetDataTable(sql);
        }

        #endregion 方法
    }
}