人才招聘网搜索功能没出来。

[longai123]

源代码地址
public static IList<ReleaseJob> GetLikeReleaseJob(string sortName)
{
return ReleaseJobService.GetLikeReleaseJob(sortName);
}
/// <summary>
/// 输入关键字查询岗位
/// </summary>
/// <param name="sortName"></param>
/// <returns></returns>
public static IList<ReleaseJob> GetLikeReleaseJob(string sortName)
{
IList<ReleaseJob> list = new List<ReleaseJob>();
string sql = "SELECT * FROM Job_ReleaseJob INNER JOIN Job_JobSort"
+ " ON Job_ReleaseJob.JobSortId = Job_JobSort.Id where Job_JobSort.Id in"
+ "(select Id from Job_JobSort where SortName like '%@SortName%')";
SqlParameter[] para = new SqlParameter[]
{
new SqlParameter("@SortName",sortName)
};
SqlDataReader reader = DBHelper.ExecuteDataReader(sql, para);
int companyId;
int callingId;
int jobNatureId;
int jobCategorieId;
int jobSortId;
int jobMoneyId;
int schoolRecordId;
int workExperienceTimeId;
while (reader.Read())
{
ReleaseJob rj = new ReleaseJob();

rj.Id = (int)reader["Id"];
rj.ReleaseTime = (DateTime)reader["ReleaseTime"];
rj.JobNum = (int)reader["JobNum"];
rj.EndTime = (DateTime)reader["EndTime"];
rj.JobAddress = (string)reader["JobAddress"];
rj.AgeNeed = (string)reader["AgeNeed"];
rj.SexNeed = (string)reader["SexNeed"];
rj.LinkMan = (string)reader["LinkMan"];
rj.LinkPhone = (string)reader["LinkPhone"];
rj.LinkFax = (string)reader["LinkFax"];
rj.LinkArea = (int)reader["LinkArea"];
rj.LinkAddress = (string)reader["LinkAddress"];
rj.CarLines = (string)reader["CarLines"];
rj.JobAbout = (string)reader["JobAbout"];
rj.JobNeet = (string)reader["JobNeet"];
rj.BranchDemand = (string)reader["BranchDemand"];
rj.LinkEmail = (string)reader["LinkEmail"];

companyId = (int)reader["CompanyId"];
callingId = (int)reader["CallingId"];
jobNatureId = (int)reader["JobNatureId"];
jobCategorieId = (int)reader["JobCategorieId"];
jobSortId = (int)reader["JobSortId"];
jobMoneyId = (int)reader["JobMoneyId"];
schoolRecordId = (int)reader["SchoolRecordId"];
workExperienceTimeId = (int)reader["WorkExperienceTimeId"];
rj.CompanyId = CompanyService.GetCompanyById(companyId);
rj.CallingId = CallingService.GetCallingById(callingId);
rj.JobNatureId = JobNatureService.GetJobNatureById(jobNatureId);
rj.JobCategorieId = JobCategorieService.GetJobCategorieById(jobCategorieId);
rj.JobSortId = JobSortService.GetJobSortById(jobSortId);
rj.JobMoneyId = JobMoneyService.GetJobMoneyById(jobMoneyId);
rj.SchoolRecordId = SchoolRecordService.GetSchoolRecordById(schoolRecordId);
rj.WorkExperienceTimeId = WorkExperienceTimeService.GetWorkExperienceTimeById(workExperienceTimeId);

list.Add(rj);
}
reader.Close();
return list;
}
public static SqlDataReader ExecuteDataReader(string sql, SqlParameter[] paras, CommandType type)
{
SqlDataReader dr = null;
//构造连接对象
SqlConnection con = new SqlConnection(str);
//构造执行对象
SqlCommand cmd = GetCommand(sql, paras, type);
cmd.Connection = con;
try
{
//打开连接
con.Open();
//执行命令
dr = cmd.ExecuteReader();
}
catch (Exception ex)
{
//输出异常
Console.WriteLine(ex.Message);
}
return dr;
}
public static SqlCommand GetCommand(string sql, SqlParameter[] paras, CommandType type)
{
SqlConnection con = new SqlConnection(str);
SqlCommand cmd = new SqlCommand(sql, con);
cmd.CommandType = type;
if (paras != null)
{
cmd.Parameters.AddRange(paras);
}
return cmd;
}
不知哪里出错没搜到出来

[longai123]

源代码地址
http://www.51aspx.com/CV/A28Job