public FrmResumeAdd(int CandidateID, bool isnewResume)
{
InitializeComponent();
this.tableAdapterManager1.candidateTableAdapter.FillByCandidate_id(this.humanresourcesDataSet1.candidate, CandidateID);
EditCandidate = this.humanresourcesDataSet1.candidate.SingleOrDefault();
ContralInit();
bind(true);
}
public FrmResumeList(int Candidate_id)
{
InitializeComponent();
this.tableAdapterManager1.candidateTableAdapter.FillByCandidate_id(this.humanresourcesDataSet1.candidate, Candidate_id);
c = this.humanresourcesDataSet1.candidate.SingleOrDefault();
this.dataGridView1.AutoGenerateColumns = false;
this.lblCandidate_name.Text = c.Candidate_name;
this.tableAdapterManager1.resumeTableAdapter.FillByCandidate_id(this.humanresourcesDataSet1.resume, c.Candidate_id);
this.dataGridView1.DataSource = this.humanresourcesDataSet1.resume;
dataGridView1.Columns[1].DefaultCellStyle.Format = "yyyy年MM月dd日";
}
public FrmResumeAdd(int resumeid)
{
InitializeComponent();
this.tableAdapterManager1.resumeTableAdapter.FillByResume_id(this.humanresourcesDataSet1.resume,resumeid);
Editresume = this.humanresourcesDataSet1.resume.SingleOrDefault();
this.tableAdapterManager1.candidateTableAdapter.FillByCandidate_id(this.humanresourcesDataSet1.candidate,Editresume.Candidate_id);
EditCandidate = this.humanresourcesDataSet1.candidate.SingleOrDefault();
this.tableAdapterManager1.educationTableAdapter.FillByResume_id(this.humanresourcesDataSet1.education, resumeid);
this.tableAdapterManager1.work_experienceTableAdapter.FillByResume_id(this.humanresourcesDataSet1.work_experience, resumeid);
ContralInit();
bind(false);
}
void Bind()
{
this.tableAdapterManager1.candidateTableAdapter.FillByCandidate_id(this.humanresourcesDataSet1.candidate, bindResume.Candidate_id);
bindCandidate = this.humanresourcesDataSet1.candidate.SingleOrDefault();
this.lblCandidate_name.Text = bindCandidate.Candidate_name;
this.lblCandidate_sex.Text = bindCandidate.Candidate_sex == 1 ? "男" : "女";
this.lblCandidate_birthday.Text = bindCandidate.Candidate_birthday.ToShortDateString();
try
{
this.lblMingz_id.Text = this.tableAdapterManager1.mingzTableAdapter.GetDataByMingz_id(bindCandidate.Mingz_id).SingleOrDefault().Mingz_name;
}
catch (Exception)
{
this.lblMingz_id.Text = "";
}
try
{
this.lblNationality_id.Text = this.tableAdapterManager1.nationalityTableAdapter.GetDataByNationality_id(bindCandidate.Nationality_id).SingleOrDefault().Nationality_name;
}
catch (Exception)
{
this.lblNationality_id.Text = "";
}
this.lblCandidate_marriage.Text = bindCandidate.Candidate_marriage;
this.lblCandidate_papersT.Text = bindCandidate.Candidate_papersT;
this.lblCandidate_papersN.Text = bindCandidate.Candidate_papersN;
this.lblregistered.Text = bindCandidate.registered;
this.lblCandidate_method1.Text = bindCandidate.Candidate_method1;
this.lblCandidate_method2.Text = bindCandidate.Candidate_method2;
this.lblCandidate_telephone.Text = bindCandidate.Candidate_telephone;
this.lblCandidate_Email.Text = bindCandidate.Candidate_Email;
this.lblUser_id.Text = this.tableAdapterManager1.usersTableAdapter.GetDataByUser_id(bindCandidate.User_id).SingleOrDefault().User_realName;
this.lblincumbency_mode.Text = bindCandidate.incumbency_mode;
this.lblResume_language.Text = bindResume.Resume_language + "简历";
if (bindResume.City_id <= 0)
{
this.lblCity_id.Text = "未知";
this.lblCity_id1.Text = "未知";
}
else
{
this.lblCity_id.Text = this.tableAdapterManager1.cityTableAdapter.GetDataByCity_id(bindResume.City_id).SingleOrDefault().City_name;
this.lblCity_id1.Text = this.tableAdapterManager1.cityTableAdapter.GetDataByCity_id(bindResume.City_id1).SingleOrDefault().City_name;
}
List<humanresourcesDataSet.jobsdetailRow> jdl = getJobsDetailByIDArr(bindResume.JobsDetail_idArr);
List<humanresourcesDataSet.tradeRow> tl = getTradeByIDArr(bindResume.Trade_IDArr);
if (jdl.Count > 0)
{
this.lblJobsDetail_idArr.Text = string.Join(",", jdl.Select(j => j.JobsDetail_name).ToArray());
}
if (tl.Count > 0)
{
this.lblTrade_IDArr.Text = string.Join(",", tl.Select(j => j.Trade_name).ToArray());
}
this.lblExperience.Text = bindResume.Experience.ToString() +"年";
this.lblResume_annual.Text = bindResume.Resume_annual.ToString() +"元";
this.lblResume_expectation.Text = bindResume.Resume_expectation.ToString() + "元";
this.lblResume_overseas.Text = bindResume.Resume_overseas;
this.lblResume_evaluate.Text = bindResume.Resume_evaluate;
this.lblComment.Text = bindResume.Comment;
this.tableAdapterManager1.educationTableAdapter.FillByResume_id(this.humanresourcesDataSet1.education,bindResume.Resume_id);
this.dataGridView1.DataSource = this.humanresourcesDataSet1.education;
this.tableAdapterManager1.work_experienceTableAdapter.FillByResume_id(this.humanresourcesDataSet1.work_experience, bindResume.Resume_id);
this.dataGridView3.DataSource = this.humanresourcesDataSet1.work_experience;
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(this.txtCandidate_name.Text))
{
throw new Exception("候选人姓名必须填写!");
}
if (EditCandidate == null)
{
EditCandidate = this.humanresourcesDataSet1.candidate.NewcandidateRow();
EditCandidate.Candidate_name = this.txtCandidate_name.Text;
}
EditCandidate.Candidate_birthday = Convert.ToDateTime(this.dtpCandidate_birthday.Value.ToShortDateString());
EditCandidate.Candidate_Email = this.txtCandidate_Email.Text;
EditCandidate.Candidate_marriage = this.cboCandidate_marriage.SelectedItem as string;
EditCandidate.Candidate_method1 = this.txtCandidate_method1.Text;
EditCandidate.Candidate_method2 = this.txtCandidate_method2.Text;
EditCandidate.Candidate_papersN = this.txtCandidate_papersN.Text;
EditCandidate.Candidate_papersT = this.cboCandidate_papersT.SelectedItem as string;
EditCandidate.Candidate_sex = this.rbtnCandidate_sexM.Checked ? 1 : 0;
EditCandidate.Candidate_telephone = this.txtCandidate_telephone.Text.Trim();
EditCandidate.Comment = this.txtComment.Text;
EditCandidate.incumbency_mode = this.cboincumbency_mode.SelectedItem as string;
EditCandidate.Mingz_id =this.cboMingz.SelectedValue==null?0: Convert.ToInt32(this.cboMingz.SelectedValue);
EditCandidate.Nationality_id =this.cboNationality.SelectedValue == null?0: Convert.ToInt32(this.cboNationality.SelectedValue);
EditCandidate.recommend_mode = "未推荐";
EditCandidate.registered = this.txtregistered.Text;
EditCandidate.User_id =this.cboUser.SelectedValue==null?0: Convert.ToInt32(this.cboUser.SelectedValue);
int newID = 0;
if (EditCandidate.Candidate_id > 0)
{
newID = EditCandidate.Candidate_id;
this.tableAdapterManager1.UpdateAll(this.humanresourcesDataSet1);
}
else
{
this.humanresourcesDataSet1.candidate.AddcandidateRow(EditCandidate);
this.tableAdapterManager1.UpdateAll(this.humanresourcesDataSet1);
newID = Convert.ToInt32(this.tableAdapterManager1.candidateTableAdapter.Adapter.InsertCommand.LastInsertedId);
}
if (newID > 0)
{
if (Editresume == null)
{
Editresume = this.humanresourcesDataSet1.resume.NewresumeRow();
}
Editresume.Candidate_id = newID;
Editresume.Resume_ShowName = this.txtCandidate_name.Text;
Editresume.City_id = Convert.ToInt32(this.cboCity.SelectedValue);
Editresume.City_id1 = Convert.ToInt32(this.cboCityWant.SelectedValue);
Editresume.Experience = Convert.ToInt32(this.nudExperience.Value);
Editresume.Resume_annual = this.nudResume_annual.Value;
Editresume.Resume_expectation = this.nudResume_expectation.Value;
Editresume.Resume_evaluate = this.txtResume_evaluate.Text;
Editresume.Resume_language = this.cboResume_language.SelectedItem as string;
Editresume.Resume_overseas = this.txtResume_overseas.Text;
string JArr = "";
foreach (humanresourcesDataSet.jobsdetailRow item in tempJL)
{
JArr += item.JobsDetail_id+ ",";
}
Editresume.JobsDetail_idArr = JArr;
string TArr = "";
foreach (humanresourcesDataSet.tradeRow item in tempTL)
{
TArr += item.Trade_id + ",";
}
Editresume.Trade_IDArr = TArr;
Editresume.update_time = DateTime.Now;
int rusumeId = 0;
if (Editresume.Resume_id > 0)
{
rusumeId = Editresume.Resume_id;
this.tableAdapterManager1.UpdateAll(this.humanresourcesDataSet1);
}
else
{
this.humanresourcesDataSet1.resume.AddresumeRow(Editresume);
this.tableAdapterManager1.UpdateAll(this.humanresourcesDataSet1);
rusumeId = Convert.ToInt32(this.tableAdapterManager1.resumeTableAdapter.Adapter.InsertCommand.LastInsertedId);
}
foreach (humanresourcesDataSet.educationRow item in this.humanresourcesDataSet1.education)
{
item.Resume_id = item.Resume_id == 0 ? rusumeId : item.Resume_id;
}
foreach (humanresourcesDataSet.work_experienceRow item in this.humanresourcesDataSet1.work_experience)
{
item.Resume_id = item.Resume_id == 0 ? rusumeId : item.Resume_id;
}
if (!string.IsNullOrEmpty(this.txtEvaluate_value.Text) && !string.IsNullOrEmpty(this.txtEvaluate_Comment.Text))
{
this.humanresourcesDataSet1.evaluate.AddevaluateRow(this.txtEvaluate_value.Text,rusumeId,this.txtEvaluate_Comment.Text,EditCandidate.User_id);
}
this.tableAdapterManager1.UpdateAll(this.humanresourcesDataSet1);
MessageBox.Show("保存成功!");
FrmResumeInfo fri = new FrmResumeInfo(rusumeId);
fri.MdiParent = this.MdiParent;
fri.Show();
this.Close();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
