//************************************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));
}
