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); } }