/// <summary>
/// 获取简历数据
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <T_JobResumeRelationModel> GetIssueListData(T_IssueListParam param)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT TOP {0} rel.job_id,a01.A0101,a01.C0104,code1.A0114,A0111=CONVERT(varchar(100),a01.A0111,23),code3.A0107,code2.A0108,a04.A0410,rel.send_date,rel.job_status FROM
(SELECT send_date=CONVERT(varchar(100),send_date,23),UnitID,A0177,job_id,use_id,job_status,ROW_NUMBER() OVER(ORDER BY job_id) AS rowNumber FROM dbo.T_JobResumeRelation WHERE use_id={1}) rel INNER JOIN
(SELECT A0101,C0104,A0114,A0111,A0107,A0108,UnitID,A0177,PersonID FROM dbo.A01 WHERE 1=1 ", param.rows, param.use_id));
if (!string.IsNullOrEmpty(param.A0101))
{
sb.Append(string.Format(" AND A0101 LIKE '%{0}%' ", param.A0101));
}
if (!string.IsNullOrEmpty(param.C0104))
{
sb.Append(string.Format(" AND C0104='{0}' ", param.C0104));
}
sb.Append(string.Format(@" ) a01 ON rel.UnitID=a01.UnitID LEFT JOIN
(SELECT A0410,PersonID FROM dbo.A04 WHERE 1=1 "));
if (!string.IsNullOrEmpty(param.A0410))
{
sb.Append(string.Format(" AND A0410 LIKE '%{0}%' ", param.A0410));
}
sb.Append(string.Format(@" ) a04 ON a01.PersonID=a04.PersonID LEFT JOIN
(SELECT CodeItemID,CodeItemName AS A0114 FROM dbo.SM_CodeItems WHERE CodeID='AB') code1 ON a01.A0114=code1.CodeItemID LEFT JOIN
(SELECT CodeItemID,CodeItemName AS A0108 FROM dbo.SM_CodeItems WHERE CodeID='JDXL') code2 ON a01.A0108=code2.CodeItemID LEFT JOIN
(SELECT CodeItemID,CodeItemName AS A0107 FROM dbo.SM_CodeItems WHERE CodeID='AX') code3 ON a01.A0107=code3.CodeItemID
WHERE rel.A0177=a01.A0177 AND rel.rowNumber>{0};", (param.page - 1) * param.rows));
DataTable dt = SqlHelper.ExecuteDataTable(sb.ToString(), CommandType.Text);
return(HCQ2_Common.Data.DataTableHelper.DataTableToIList <T_JobResumeRelationModel>(dt));
}
/// <summary>
/// 获取招聘对于简历数据总量
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int GetIssueListDataCount(T_IssueListParam param)
{
if (null == param)
{
return(0);
}
return(DBSession.IT_UseWorkerDAL.GetIssueListDataCount(param));
}
/// <summary>
/// 获取简历数据
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public List <T_JobResumeRelationModel> GetIssueListData(T_IssueListParam param)
{
if (null == param)
{
return(null);
}
return(DBSession.IT_UseWorkerDAL.GetIssueListData(param));
}
public ActionResult InitResumeTable(int id)
{
string A0101 = RequestHelper.GetDeStrByName("A0101"), //姓名
C0104 = RequestHelper.GetStrByName("C0104"), //电话
A0410 = RequestHelper.GetDeStrByName("A0410"); //专业
int page = RequestHelper.GetIntByName("page"),
rows = RequestHelper.GetIntByName("rows");
T_IssueListParam param = new T_IssueListParam {
use_id = id, A0101 = A0101, C0104 = C0104, A0410 = A0410, page = page, rows = rows
};
List <T_JobResumeRelationModel> user = operateContext.bllSession.T_UseWorker.GetIssueListData(param);
TableModel tModel = new TableModel()
{
total = operateContext.bllSession.T_UseWorker.GetIssueListDataCount(param),
rows = user
};
return(Json(tModel, JsonRequestBehavior.AllowGet));
}
/// <summary>
/// 获取招聘对于简历数据总量
/// </summary>
/// <param name="param"></param>
/// <returns></returns>
public int GetIssueListDataCount(T_IssueListParam param)
{
sb?.Clear();
sb.Append(string.Format(@"SELECT COUNT(*) FROM
(SELECT UnitID,A0177,use_id,job_status FROM dbo.T_JobResumeRelation WHERE use_id={0}) rel INNER JOIN
(SELECT A0101,C0104,A0114,A0111,A0107,A0108,UnitID,A0177,PersonID FROM dbo.A01 WHERE 1=1 ", param.use_id));
if (!string.IsNullOrEmpty(param.A0101))
{
sb.Append(string.Format(" AND A0101 LIKE '%{0}%' ", param.A0101));
}
if (!string.IsNullOrEmpty(param.C0104))
{
sb.Append(string.Format(" AND C0104='{0}' ", param.C0104));
}
sb.Append(string.Format(@" ) a01 ON rel.UnitID=a01.UnitID LEFT JOIN
(SELECT A0410,PersonID FROM dbo.A04 WHERE 1=1 "));
if (!string.IsNullOrEmpty(param.A0410))
{
sb.Append(string.Format(" AND A0410 LIKE '%{0}%' ", param.A0410));
}
sb.Append(@") a04 ON a01.PersonID=a04.PersonID WHERE rel.A0177 = a01.A0177");
return(Helper.ToInt(SqlHelper.ExecuteScalar(sb.ToString(), CommandType.Text)));
}
