//************************************APP Service***************************************** /// <summary> /// 获取职位列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <HCQ2_Model.APPModel.ResultApiModel.JobEmployResultModel> GetJobEmployList(HCQ2_Model.APPModel.ParamModel.JobEmployModel model) { sb?.Clear(); sb.Append(string.Format(@"SELECT TOP {0} info.unitName,work.use_title,work.header_img as 'logo',work.work_city AS 'addr',CONVERT(varchar(100),work.issue_start,23) AS 'issueDate',work.payMoney,work.use_id FROM (SELECT dwmc AS 'unitName',com_id FROM dbo.T_CompProInfo WHERE 1=1 ", model.size)); if (!string.IsNullOrEmpty(model.busType)) { sb.Append(string.Format(" AND bus_type='{0}' ", model.busType)); } if (!string.IsNullOrEmpty(model.busScale)) { sb.Append(string.Format(" AND bus_scale='{0}' ", model.busScale)); } string str = "issue_start"; if (!string.IsNullOrEmpty(model.orderType) && model.orderType.Equals("money")) { str = "use_wage_end"; } sb.Append(string.Format(@" ) info RIGHT JOIN (SELECT use_title,header_img,work_city,issue_start,payMoney=(CASE WHEN use_wage_end=0 THEN '面议' ELSE CAST(use_wage_start AS NVARCHAR(10))+'-'+CAST(use_wage_end AS NVARCHAR(10)) END),use_id,com_id,ROW_NUMBER() OVER(ORDER BY {0} DESC) AS 'rowNumber' FROM dbo.T_UseWorker WHERE 1=1 ", str)); //工作城市 if (!string.IsNullOrEmpty(model.city)) { sb.Append(string.Format(" AND work_city LIKE '%{0}%' ", model.city)); } //薪资范围 if (model.payStart > 0 && model.payEnd > 0) { sb.Append(string.Format(" AND use_wage_start>={0} AND use_wage_end<={1} ", model.payStart, model.payEnd)); } else if (model.payStart > 0 && model.payEnd <= 0) { sb.Append(string.Format(" AND use_wage_start>={0} ", model.payStart)); } else if (model.payStart <= 0 && model.payEnd > 0) { sb.Append(string.Format(" AND use_wage_end<={0} ", model.payEnd)); } //学历 if (!string.IsNullOrEmpty(model.use_edu)) { sb.Append(string.Format(" AND use_edu='{0}' ", model.use_edu)); } //工作经验 if (!string.IsNullOrEmpty(model.useLimit)) { sb.Append(string.Format(" AND use_ageLimit='{0}' ", model.useLimit)); } //发布时间 if (!string.IsNullOrEmpty(model.issueDate)) { sb.Append(string.Format(" AND CONVERT(VARCHAR(100),issue_start,23)='{0}' ", model.issueDate)); } //职位类型 if (!string.IsNullOrEmpty(model.postType)) { sb.Append(string.Format(" AND work_type='{0}' ", model.postType)); } sb.Append(string.Format(@" ) work ON info.com_id = work.com_id WHERE work.rowNumber>{0};", (model.page - 1) * model.size)); DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text); return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.APPModel.ResultApiModel.JobEmployResultModel>(dt)); }
//************************************APP Service***************************************** /// <summary> /// 获取职位列表 /// </summary> /// <param name="model"></param> /// <returns></returns> public List <HCQ2_Model.APPModel.ResultApiModel.JobEmployResultModel> GetJobEmployList(HCQ2_Model.APPModel.ParamModel.JobEmployModel model) { if (null == model) { return(null); } return(DBSession.IT_UseWorkerDAL.GetJobEmployList(model)); }