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

源代码地址 
 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;
        }
不知哪里出错没搜到出来