private DataTable GetEducationBackground(ISession session, Resume resume)
{
string sql = "select * from education_background where resume_id=? order by edu_end_date desc";
ISqlQuery query = session.CreateSqlQuery(sql, resume.Id);
query.FirstResult = 0;
query.PageSize = 1;
return query.ExecuteGetDataTable();
}
private DataTable GetPersonInfo(ISession session, Resume resume)
{
string sql = @"
select person_info.*,
case person_gender
when 1 then '男'
else '女'
end as person_sex,
area_name as living_place
from person_info join area_dict
on (person_info.person_living_area = area_dict.area_code)
where resume_id=?";
return session.CreateSqlQuery(sql, resume.Id).ExecuteGetDataTable();
}
private DataTable GetWorkExperience(ISession session, Resume resume)
{
string sql = "select * from experience where resume_id=? order by exp_end_date desc";
return session.CreateSqlQuery(sql, resume.Id).ExecuteGetDataTable();
}
private DataTable GetProfessionalSkill(ISession session, Resume resume)
{
string sql = "select * from professional_skill where resume_id=? order by skill_order";
return session.CreateSqlQuery(sql, resume.Id).ExecuteGetDataTable();
}
private DataTable GetAward(ISession session, Resume resume)
{
string sql = "select * from award where resume_id=? order by award_order";
return session.CreateSqlQuery(sql, resume.Id).ExecuteGetDataTable();
}