当前文件： 51Job/App_Code/BusinessLogicLayer/JobType.cs[2K，2009-6-12 11:31:08]，打开代码结构图

		            
  1using System;
  2using System.Data;
  3using System.Collections;
  4
  5using HRManager.DataAccessLayer;
  6using HRManager.DataAccessHelper;
  7
  8namespace HRManager.BusinessLogicLayer
  9...{
 10    /**//// <summary>
 11    /// 职位种类类
 12    /// </summary>
 13    public class JobType
 14    ...{
 15        私有成员#region 私有成员
 16
 17        private int _typeId;            //职位种类ID
 18        private string _typeName;        //职位种类名
 19
 20        private bool _exist;                //是否存在标志
 21
 22        #endregion 私有成员
 23
 24        属性#region 属性
 25
 26        public int TypeId
 27        ...{
 28            set
 29            ...{
 30                this._typeId = value;
 31            }
 32            get
 33            ...{
 34                return this._typeId;
 35            }
 36        }
 37        public string TypeName
 38        ...{
 39            set
 40            ...{
 41                this._typeName = value;
 42            }
 43            get
 44            ...{
 45                return this._typeName;
 46            }
 47        }
 48        public bool Exist
 49        ...{
 50            get
 51            ...{
 52                return this._exist;
 53            }
 54        }
 55
 56        #endregion 属性
 57
 58        方法#region 方法
 59
 60        /**//// <summary>
 61        /// 根据参数typeId，获取城市详细信息
 62        /// </summary>
 63        /// <param name="typeId">类别ID</param>
 64        public void LoadData(int typeId)
 65        ...{
 66            Database db = new Database();        //实例化一个Database类
 67
 68            string sql = "";
 69            sql = "Select * from [JobType] where TypeId = " + typeId;
 70
 71            DataRow dr = db.GetDataRow(sql);    //利用Database类的GetDataRow方法查询数据
 72
 73            //根据查询得到的数据，对成员赋值
 74            if (dr != null)
 75            ...{
 76                this._typeId = GetSafeData.ValidateDataRow_N(dr, "TypeId");
 77                this._typeName = GetSafeData.ValidateDataRow_S(dr, "TypeName");
 78
 79                this._exist = true;
 80            }
 81            else
 82            ...{
 83                this._exist = false;
 84            }
 85        }
 86
 87        /**//// <summary>
 88        /// 根据查询条件哈希表,查询数据
 89        /// </summary>
 90        /// <param name="queryItems">查询条件哈希表</param>
 91        /// <returns>查询结果数据DataTable</returns>
 92        public static DataTable Query(Hashtable queryItems)
 93        ...{
 94            string where = SqlStringConstructor.GetConditionClause(queryItems);
 95            string sql = "Select * From [JobType]" + where;
 96            Database db = new Database();
 97            return db.GetDataTable(sql);
 98        }
 99
100        #endregion 方法
101    }
102}
103