温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:无忧之源招聘系统及Log4Net源码
当前文件:
51Job/App_Code/BusinessLogicLayer/Job.cs[7K,2009-6-12 11:31:08],打开代码结构图
51Job/App_Code/BusinessLogicLayer/Job.cs[7K,2009-6-12 11:31:08],打开代码结构图1using System; 2
using System.Data; 3
using System.Collections; 4
5
using HRManager.DataAccessLayer; 6
using HRManager.DataAccessHelper; 7
using HRManager.CommonComponent; 8
9
10
namespace 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
}






}