/// <summary>
/// 投递简历
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public bool SendResumeByID(HCQ2_Model.APPModel.ParamModel.PostDetialParam model)
{
HCQ2_Model.T_User user = DBSession.IT_UserDAL.Select(s => s.user_guid.Equals(model.userid)).FirstOrDefault();
if (null == user)
{
return(false);
}
HCQ2_Model.A01 a01 = DBSession.IA01DAL.Select(s => s.A0177.Equals(user.user_identify)).FirstOrDefault();
if (null == a01)
{
return(false);
}
HCQ2_Model.T_UseWorker work = DBSession.IT_UseWorkerDAL.Select(s => s.use_id == model.use_id).FirstOrDefault();
HCQ2_Model.T_JobResumeRelation job = new HCQ2_Model.T_JobResumeRelation
{
com_id = work.com_id,
use_id = model.use_id,
A0177 = a01.A0177,
UnitID = a01.UnitID,
send_date = DateTime.Now,
job_status = "01"
};
int mark = DBSession.IT_JobResumeRelationDAL.Add(job);
return(mark > 0 ? true : false);
}
/// <summary>
/// 根据招聘信息 获取职位详情
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <HCQ2_Model.APPModel.ResultApiModel.PostDetialResultModel> GetPostDetialByID(HCQ2_Model.APPModel.ParamModel.PostDetialParam model)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT TOP {0} info.unitName,work.use_title,work.header_img as 'logo',work.work_city,SUBSTRING(CONVERT(varchar(100), GETDATE(),23),6,6) AS 'issueDate',
work.payMoney,work.use_id,info.com_id,work.use_edu,code1.useLimit,work.addr,work.postNote FROM
(SELECT dwmc AS 'unitName',com_id FROM dbo.T_CompProInfo) info RIGHT JOIN
(SELECT use_title,addr,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,use_ageLimit,postNote,header_img,use_edu=(CASE WHEN use_edu='0' THEN '不限' ELSE use_edu END),ROW_NUMBER() OVER(ORDER BY issue_start DESC) AS 'rowNumber' FROM dbo.T_UseWorker
WHERE use_id={1}) work ON info.com_id = work.com_id INNER JOIN
(SELECT item2.useLimit,item2.ageLimit_value FROM
(SELECT item_id,item_code FROM dbo.T_ItemCode WHERE item_code='WorkExperience') item1 INNER JOIN
(SELECT code_name AS useLimit,code_value AS ageLimit_value,item_id AS id FROM dbo.T_ItemCodeMenum) item2 ON item1.item_id = item2.id) code1 ON code1.ageLimit_value=work.use_ageLimit
WHERE work.rowNumber>{2};", model.size, model.use_id, (model.page - 1) * model.size));
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text);
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <HCQ2_Model.APPModel.ResultApiModel.PostDetialResultModel>(dt));
}
/// <summary>
/// 根据招聘信息 获取职位详情
/// </summary>
/// <param name="model"></param>
/// <returns></returns>
public List <HCQ2_Model.APPModel.ResultApiModel.PostDetialResultModel> GetPostDetialByID(HCQ2_Model.APPModel.ParamModel.PostDetialParam model)
{
if (null == model)
{
return(null);
}
return(DBSession.IT_UseWorkerDAL.GetPostDetialByID(model));
}
