/// <summary>
/// 进入个人信息界面，获取所编辑的简历，加载内容
/// </summary>
/// <param name="data"></param>
public void OnBringToFront(object data)
{
try
{
resume = data as Resume;
personInfo = personInfoService.GetPersonInfo(resume);
if (personInfo == null)
{
personInfo = new PersonInfo();
personInfo.ResumeId = resume.Id;
}
textName.Text = personInfo.PersonName;
(personInfo.IsMale ? radioMale : radioFemale).Checked = true;
dtpBirthday.Value = personInfo.PersonBirthday == null ? DateTime.Now : personInfo.PersonBirthday.Value;
dtpWorkDate.Value = personInfo.PersonWorkdate == null ? DateTime.Now : personInfo.PersonWorkdate.Value;
ControlHelper.SetAreaToCmb(cmbBornProvince, cmbBornCity, cmbBornCounty, personInfo.PersonBornArea);
ControlHelper.SetAreaToCmb(cmbLivingProvince, cmbLivingCity, cmbLivingCounty, personInfo.PersonLivingArea);
textTel.Text = personInfo.PersonTel;
textEmail.Text = personInfo.PersonEmail;
textQQ.Text = personInfo.PersonQq;
SetMarriageStatus(personInfo.PersonMarriage);
cmbIdentityType.Text = personInfo.PersonIdentityType;
textIdentityCode.Text = personInfo.PersonIdentityCode;
(personInfo.HasBeenAbroad ? radioAbroad : radioNoAbrod).Checked = true;
SetPoliticalStatus(personInfo.PersonParty);
pictureBox.Image = personInfo.PersonAvatar;
pictureBox.Image = personInfo.PersonAvatar;
pictureBox.Image = personInfo.PersonAvatar;
}
catch (Exception e)
{
MessageBox.Show("加载个人信息发生异常：" + e.Message);
}
}
public FormResumeSetting(Form formMain, Resume resume, MineService mineService)
{
InitializeComponent();
this.formMain = formMain as FormMain;
this.resume = resume;
this.mineService = mineService;
}
/// <summary>
/// 进入求职意向窗口，获取当前编辑的求职意向
/// </summary>
/// <param name="data"></param>
public void OnBringToFront(object data)
{
try
{
resume = data as Resume;
expect = expectService.GetExpect(resume);
if (expect == null)
{
expect = new Expect();
expect.ResumeId = resume.Id;
}
checkBoxFullTime.Checked = expect.IsFullTime;
checkBoxPartTime.Checked = expect.IsPartTime;
checkBoxPractice.Checked = expect.IsPractice;
ControlHelper.SetAreaToCmb(cmbProvince1, cmbCity1, cmbCounty1, expect.ExpectArea1);
ControlHelper.SetAreaToCmb(cmbProvince2, cmbCity2, cmbCounty2, expect.ExpectArea2);
listIndustry1.Text = expect.ExpectIndustry1;
listIndustry2.Text = expect.ExpectIndustry2;
listJobClass1.Text = expect.ExpectJobClass1;
listJobSubclass1.Text = expect.ExpectJobSubclass1;
listJobClass2.Text = expect.ExpectJobClass2;
listJobSubclass2.Text = expect.ExpectJobSubclass2;
cmbSalary.Text = expect.ExpectSalary;
cmbStatus.Text = expect.WorkStatus;
}
catch (Exception ex)
{
MessageBox.Show("加载求职意向失败：" + ex.Message);
}
}
/// <summary>
/// 添加按钮点击
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void btnAdd_Click(object sender, EventArgs e)
{
Resume resume = new Resume();
resume.User = loginUser;
new FormResumeSetting(Owner, resume, mineService).ShowDialog();
RefreshData();
}
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();
}
public DataTable getEduBack(Resume resume)
{
using (ISession session = AppContext.Instance.OpenSession())
{
String sql = "select * from education_background where resume_id=?";
DataTable pi = session.CreateSqlQuery(sql, resume.Id).ExecuteGetDataTable();
return pi;
}
}
public Report PrepareReport(Resume resume)
{
Report report = new Report();
report.Load(Environment.CurrentDirectory + @"\Templates\About.frx");
PictureObject picture = report.FindObject("Picture1") as PictureObject;
picture.ImageLocation = Environment.CurrentDirectory + @"\Templates\logo.png";
report.Prepare();
return report;
}
public DataTable getResumeInfo(Resume resume)
{
using (ISession session = AppContext.Instance.OpenSession())
{
String sql = "select * from person_info where resume_id=?";
DataTable pi = session.CreateSqlQuery(sql, resume.Id).ExecuteGetDataTable();
return pi;
}
}
public void OnBringToFront(object data)
{
clearInfo();
resume = data as Resume;
if(resume==null)
{
resume = new Resume();
}
else refreshDgvData(resume);
}
public void OnBringToFront(object data)
{
resume = data as Resume;
try
{
datagvAward.AutoGenerateColumns = false;
datagvAward.DataSource = service.GetAwards(resume);
if (datagvAward.DataSource == null) datagvAward.DataSource = new List<Award>();
activity = service.GetSchoolActivity(resume);
txboxSchoolActivity.Text = activity == null ? "" : activity.Activity;
scholarships = service.GetScholarships(resume);
if (scholarships != null)
{
if (scholarships.Count >= 1)
{
cmboxType1.Text = scholarships[0].ScholarshipType;
cmboxLevel1.Text = scholarships[0].ScholarshipLevel;
}
if (scholarships.Count >= 2)
{
cmboxType2.Visible = cmboxLevel2.Visible = linkDeleteSecond.Visible = true;
cmboxType2.Text = scholarships[1].ScholarshipType;
cmboxLevel2.Text = scholarships[1].ScholarshipLevel;
}
else
{
cmboxType2.Visible = cmboxLevel2.Visible = linkDeleteSecond.Visible = false;
cmboxType2.Text = cmboxLevel2.Text = "请选择";
}
if (scholarships.Count >= 3)
{
cmboxType3.Visible = cmboxLevel3.Visible = linkDeleteThird.Visible = true;
cmboxType3.Text = scholarships[2].ScholarshipType;
cmboxLevel3.Text = scholarships[2].ScholarshipLevel;
}
else
{
cmboxType3.Visible = cmboxLevel3.Visible = linkDeleteThird.Visible = false;
cmboxType3.Text = cmboxLevel3.Text = "请选择";
}
}
else
{
cmboxType1.Text = cmboxLevel1.Text = "请选择";
cmboxType2.Text = cmboxLevel2.Text = "请选择";
cmboxType3.Text = cmboxLevel3.Text = "请选择";
cmboxLevel2.Visible = cmboxType2.Visible = false;
cmboxLevel3.Visible = cmboxType3.Visible = false;
}
}
catch (Exception ex)
{
MessageBox.Show("加载专业技能发生异常：" + ex.Message);
}
}
public void OnBringToFront(object data)
{
resume = data as Resume;
try
{
datagvPratices.AutoGenerateColumns = false;
datagvPratices.DataSource = service.GetPractices(resume);
}
catch (Exception ex)
{
MessageBox.Show("加载专业技能发生异常：" + ex.Message);
}
}
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();
}
public Report PrepareReport(Resume resume)
{
using (ISession session = AppContext.Instance.OpenSession())
{
Report report = new Report();
report.Load(Environment.CurrentDirectory + @"\Templates\极致简约.frx");
report.RegisterData(GetPersonInfo(session, resume), "person_info");
report.RegisterData(GetEducationBackground(session, resume), "education_background");
report.RegisterData(GetWorkExperience(session, resume), "experience");
report.RegisterData(GetProjectExperience(session, resume), "project_experience");
report.RegisterData(GetProfessionalSkill(session, resume), "professional_skill");
report.RegisterData(GetAward(session, resume), "award");
return report;
}
}
public void OnBringToFront(object data)
{
try
{
resume = data as Resume;
if (resume == null)
{
resume = new Resume();
return;
}
}
catch (Exception e)
{
MessageBox.Show("获取信息失败"+e.Message);
}
RefreshDgvCoverletterData();
}
public void OnBringToFront(object data)
{
resume = data as Resume;
try
{
datagvSkills.AutoGenerateColumns = false;
datagvSkills.DataSource = service.GetSkills(resume);
if (datagvSkills.DataSource == null)
{
datagvSkills.DataSource = new List<UIProfessionalSkill>();
}
}
catch (Exception ex)
{
MessageBox.Show("加载专业技能发生异常：" + ex.Message);
}
}
/// <summary>
/// 进入编辑简历窗口，获取所编辑的简历
/// </summary>
/// <param name="data"></param>
public void OnBringToFront(object data)
{
this.resume = data as Resume;
resumeItemPanel_Selected(panelPersonInfo, null);
}
/// <summary>
/// 根据简历ID和证书名称判断证书是否有重复，重复返回true，否则返回false
/// </summary>
/// <param name="resume"></param>
/// <param name="name"></param>
/// <returns></returns>
private bool TheSameCertificate(Resume resume, string p)
{
RefreshDgvData(this.resume);
for (int i = 0; i < certificateList.Count; i++)
{
if ((certificateList[i].ResumeId == certificate.ResumeId) && (certificateList[i].CertificateName == certificate.CertificateName))
return true;
}
return false;
//throw new NotImplementedException();
}
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();
}
public void OnBringToFront(object data)
{
resume = data as Resume;
RefreshData();
}
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 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();
}
/// <summary>
/// 刷新列表
/// </summary>
/// <param name="resume"></param>
private void refreshDgvData(Resume resume)
{
projectexperienceService = new ProjectExperienceService();
try
{
projectexperienceList = projectexperienceService.GetProjExpreienceListByResume(resume);
dgvProjExperience.AutoGenerateColumns = false;
dgvProjExperience.DataSource = projectexperienceList;
}
catch (Exception e)
{ MessageBox.Show("加载数据失败"+e.Message); }
//throw new NotImplementedException();
}
/// <summary>
/// 刷新数据列表
/// </summary>
/// <param name="resume"></param>
private void RefreshDgvData(Resume resume)
{
try
{
certificateList = certificateService.GetCertificateListByResume(resume);
if (certificateList != null)
{
dgvCertificateData.AutoGenerateColumns = false;
dgvCertificateData.DataSource = certificateList;
}
}
catch (Exception e)
{
MessageBox.Show("读取数据失败"+e.Message);
throw new NotImplementedException();
}
}