1
using System;
2using System.Data;
3using System.Collections;
4
5using HRManager.DataAccessLayer;
6using HRManager.DataAccessHelper;
7using HRManager.CommonComponent;
8
9
10namespace HRManager.BusinessLogicLayer
11
...{
12
/**//// <summary>
13
/// Job 的摘要说明。
14
/// </summary>
15 public class Job
16 ...{
17 私有成员#region 私有成员
18
19 private int _jobId; //职位Id
20 private string _jobName; //职位
21 private int _jobCityId; //职位所在城市Id
22 private string _jobCityName; //职位所在城市
23 private int _jobTypeId; //职位种类Id
24 private string _jobTypeName; //职位种类
25 private string _responsibility; //职位职责
26 private string _requirement; //职位要求
27 private bool _isUrgent; //是否紧急
28
29 private bool _exist; //是否存在标志
30
31 #endregion 私有成员
32
33 属性#region 属性
34
35 //职位Id
36 public int JobId
37 ...{
38 set
39 ...{
40 this._jobId = value;
41 }
42 get
43 ...{
44 return this._jobId;
45 }
46 }
47 //职位
48 public string JobName
49 ...{
50 set
51 ...{
52 this._jobName = value;
53 }
54 get
55 ...{
56 return this._jobName;
57 }
58 }
59 //职位所在城市Id
60 public int JobCityId
61 ...{
62 set
63 ...{
64 this._jobCityId = value;
65 }
66 get
67 ...{
68 return this._jobCityId;
69 }
70 }
71 //职位所在城市
72 public string JobCityName
73 ...{
74 set
75 ...{
76 this._jobCityName = value;
77 }
78 get
79 ...{
80 return this._jobCityName;
81 }
82 }
83 //职位种类Id
84 public int JobTypeId
85 ...{
86 set
87 ...{
88 this._jobTypeId = value;
89 }
90 get
91 ...{
92 return this._jobTypeId;
93 }
94 }
95 //职位种类
96 public string JobTypeName
97 ...{
98 set
99 ...{
100 this._jobTypeName = value;
101 }
102 get
103 ...{
104 return this._jobTypeName;
105 }
106 }
107 //职位职责
108 public string Responsibility
109 ...{
110 set
111 ...{
112 this._responsibility = value;
113 }
114 get
115 ...{
116 return this._responsibility;
117 }
118 }
119 //职位要求
120 public string Requirement
121 ...{
122 set
123 ...{
124 this._requirement = value;
125 }
126 get
127 ...{
128 return this._requirement;
129 }
130 }
131 //是否紧急
132 public bool IsUrgent
133 ...{
134 set
135 ...{
136 this._isUrgent = value;
137 }
138 get
139 ...{
140 return this._isUrgent;
141 }
142 }
143 //存在标志
144 public bool Exist
145 ...{
146 get
147 ...{
148 return this._exist;
149 }
150 }
151
152 #endregion 属性
153
154 方法#region 方法
155
156 /**//// <summary>
157 /// 根据参数JobId，获取职位详细信息
158 /// </summary>
159 /// <param name="JobId">职位ID</param>
160 public void LoadData(int JobId)
161 ...{
162 Database db = new Database(); //实例化一个Database类
163
164 string sql = "";
165 sql = "Select * from [Job],[City],[JobType] where JobId = " + JobId
166 + " And [Job].JobCityId=[City].CityId"
167 + " And [Job].JobTypeId=[JobType].TypeId";
168
169 DataRow dr = db.GetDataRow(sql); //利用Database类的GetDataRow方法查询职位数据
170
171 //根据查询得到的数据，对成员赋值
172 if (dr != null)
173 ...{
174 this._jobId = GetSafeData.ValidateDataRow_N(dr, "JobID");
175 this._jobName = GetSafeData.ValidateDataRow_S(dr, "JobName");
176 this._jobCityId = GetSafeData.ValidateDataRow_N(dr, "CityId");
177 this._jobCityName = GetSafeData.ValidateDataRow_S(dr, "CityName");
178 this._jobTypeId = GetSafeData.ValidateDataRow_N(dr, "JobTypeId");
179 this._jobTypeName = GetSafeData.ValidateDataRow_S(dr, "TypeName");
180 this._responsibility = GetSafeData.ValidateDataRow_S(dr, "Responsibility");
181 this._requirement = GetSafeData.ValidateDataRow_S(dr, "Requirement");
182 this._isUrgent =Convert.ToBoolean( GetSafeData.ValidateDataRow_N(dr, "IsUrgent"));
183
184 this._exist = true;
185 }
186 else
187 ...{
188 this._exist = false;
189 }
190 }
191
192 /**//// <summary>
193 /// 向数据库添加一个职位
194 /// </summary>
195 /// <param name="htUserInfo">职位信息哈希表</param>
196 public static void Add(Hashtable JobInfo)
197 ...{
198 Database db = new Database(); //实例化一个Database类
199 db.Insert("[Job]", JobInfo); //利用Database类的Insert方法添加职位数据
200 }
201
202 /**//// <summary>
203 /// 查询职位
204 /// </summary>
205 /// <param name="queryItems">“AND”子句查询条件哈希表</param>
206 /// <returns>以DataTable形式返回查询结果数据</returns>
207 public static DataTable Query(Hashtable queryItems)
208 ...{
209 string where = SqlStringConstructor.GetConditionClause(queryItems);
210
211 string sql = "Select * From [Job],[City],[JobType]";
212
213 if (where == "")
214 ...{
215 where = " Where [Job].JobCityId=[City].CityId"
216 + " And [Job].JobTypeId=[JobType].TypeId";
217 }
218 else
219 ...{
220 where += " And [Job].JobCityId=[City].CityId"
221 + " And [Job].JobTypeId=[JobType].TypeId";
222 }
223
224 sql += where;
225
226 Database db = new Database();
227 return db.GetDataTable(sql);
228 }
229
230 /**//// <summary>
231 /// 全文搜索，即在：职位名称、职责、要求、城市、类别中查找关键字
232 /// </summary>
233 /// <param name="keyWords">关键字集合</param>
234 public static DataTable KeyWordsSearch(ArrayList keyWords)
235 ...{
236 string sql = "Select * From [Job],[City],[JobType]";
237 string where = " Where ";
238
239 foreach (string key in keyWords)
240 ...{
241 where += "( [Job].JobName Like '%"+key+"%' ";
242 where += "Or [Job].Responsibility Like '%" + key + "%' ";
243 where += "Or [Job].Requirement Like '%" + key + "%' ";
244 where += "Or [JobType].TypeName Like '%" + key + "%' ";
245 where += "Or [City].CityName Like '%" + key + "%') ";
246 where += " And ";
247 }
248
249 where += " [Job].JobCityId=[City].CityId"
250 + " And [Job].JobTypeId=[JobType].TypeId";
251
252 sql += where;
253 Database db = new Database();
254 return db.GetDataTable(sql);
255 }
256
257 #endregion 方法
258 }
259
}
51Job/App_Code/BusinessLogicLayer/Job.cs[7K，2009-6-12 11:31:08]，打开代码结构图
打包下载该项目完整源码：无忧之源招聘系统及Log4Net源码