/// <summary> /// 获得储备人才的数据集 /// </summary> /// <returns>返回储备人才集合</returns> HR_TrainEmploye GetTrainEmployeData() { HR_TrainEmploye trainEmploye = new HR_TrainEmploye(); trainEmploye.Address = txtAddress.Text.Trim(); trainEmploye.Age = Convert.ToInt32(numAge.Value); trainEmploye.Birthday = dtpBirthday.Value; trainEmploye.Birthplace = txtBirthplace.Text; trainEmploye.College = txtCollege.Text.Trim(); trainEmploye.ComputerLevel = txtComputerLevel.Text.Trim(); trainEmploye.DesiredSalary = numDesiredSalary.Value; trainEmploye.EducatedDegree = txtEducatedDegree.Text.Trim(); trainEmploye.EducatedMajor = txtEducatedMajor.Text.Trim(); trainEmploye.EmergencyPhone = txtEmergencyPhone.Text.Trim(); trainEmploye.EnglishLevel = txtEnglishLevel.Text.Trim(); trainEmploye.Evaluate = txtEvaluate.Text.Trim(); trainEmploye.ResumeStatus = cmbResumeStatus.Text; trainEmploye.Height = numHeight.Value; trainEmploye.ID_Card = txtCard.Text.Trim(); if (dtpInterviewDate.Checked) { trainEmploye.InterviewDate = dtpInterviewDate.Value; } trainEmploye.IsThirdParty = cbIsThirdParty.Checked; trainEmploye.JobYears = Convert.ToInt32(numJobYears.Value); trainEmploye.MaritalStatus = cmbMaritalStatus.Text; trainEmploye.Name = txtName.Text; trainEmploye.Nationality = txtNationality.Text.Trim(); trainEmploye.Party = txtParty.Text; trainEmploye.PersonType = cmbPersonType.Text; trainEmploye.Phone = txtPhone.Text; trainEmploye.Sex = cmbSex.Text; trainEmploye.Race = txtRace.Text; trainEmploye.RecruitType = cmbRecruitType.Text; trainEmploye.Speciality = txtSpeciality.Text.Trim(); trainEmploye.TakeJobDate = dtpTakeJobDate.Value; trainEmploye.ThirdParty = txtThirdParty.Text.Trim(); if (picbyte != null) { trainEmploye.Anne = picbyte; trainEmploye.FileName = pathName; } trainEmploye.Recorder = BasicInfo.LoginID; trainEmploye.RecordTime = ServerTime.Time; trainEmploye.Remark = txtRemark.Text; return(trainEmploye); }
/// <summary> /// 绑定控件 /// </summary> private void BindControl() { HR_TrainEmploye trainEmploye = m_trainEmployeServer.GetInfoByID(m_id, out m_error); txtAddress.Text = trainEmploye.Address; numAge.Value = Convert.ToDecimal(trainEmploye.Age); dtpBirthday.Value = Convert.ToDateTime(trainEmploye.Birthday); txtBirthplace.Text = trainEmploye.Birthplace; txtCollege.Text = trainEmploye.College; txtComputerLevel.Text = trainEmploye.ComputerLevel; numDesiredSalary.Value = Convert.ToDecimal(trainEmploye.DesiredSalary); txtEducatedDegree.Text = trainEmploye.EducatedDegree; txtEducatedMajor.Text = trainEmploye.EducatedMajor; txtEmergencyPhone.Text = trainEmploye.EmergencyPhone; txtEnglishLevel.Text = trainEmploye.EnglishLevel; txtEvaluate.Text = trainEmploye.Evaluate; cmbResumeStatus.Text = trainEmploye.ResumeStatus; numHeight.Value = Convert.ToDecimal(trainEmploye.Height); txtCard.Text = trainEmploye.ID_Card; txtPhone.Text = trainEmploye.Phone; if (trainEmploye.InterviewDate != null) { dtpInterviewDate.Value = Convert.ToDateTime(trainEmploye.InterviewDate); } cbIsThirdParty.Checked = Convert.ToBoolean(trainEmploye.IsThirdParty); numJobYears.Value = Convert.ToDecimal(trainEmploye.JobYears); cmbMaritalStatus.Text = trainEmploye.MaritalStatus; txtName.Text = trainEmploye.Name; txtNationality.Text = trainEmploye.Nationality; txtParty.Text = trainEmploye.Party; cmbPersonType.Text = trainEmploye.PersonType; cmbSex.Text = trainEmploye.Sex; txtRace.Text = trainEmploye.Race; cmbRecruitType.Text = trainEmploye.RecruitType; txtSpeciality.Text = trainEmploye.Speciality; dtpTakeJobDate.Value = Convert.ToDateTime(trainEmploye.TakeJobDate); txtThirdParty.Text = trainEmploye.ThirdParty; if (trainEmploye.Anne != null) { picbyte = trainEmploye.Anne == null ? null : trainEmploye.Anne.ToArray(); lblAnnxeName.Text = trainEmploye.FileName; } txtRemark.Text = trainEmploye.Remark; DataTable dtWorkHistory = m_trainEmployeServer.GetWorkHistory(m_id); if (dtWorkHistory != null && dtWorkHistory.Rows.Count > 0) { dgvWorkHistory.DataSource = dtWorkHistory; if (dgvWorkHistory.Rows.Count > 0) { dgvWorkHistory.Columns["编号"].Visible = false; } } DataTable dtEducated = m_trainEmployeServer.GetEducatedHistory(m_id); if (dtEducated != null && dtEducated.Rows.Count > 0) { dgvEducatedHistory.DataSource = dtEducated; if (dgvEducatedHistory.Rows.Count > 0) { dgvEducatedHistory.Columns["编号2"].Visible = false; } } DataTable dtFamilyMember = m_trainEmployeServer.GetFamilyMember(m_id); if (dtFamilyMember != null && dtFamilyMember.Rows.Count > 0) { dgvFamilyMember.DataSource = dtFamilyMember; if (dgvFamilyMember.Rows.Count > 0) { dgvFamilyMember.Columns["编号3"].Visible = false; } } }
/// <summary> /// 修改储备人才信息 /// </summary> /// <param name="trainEmploye">储备人才数据集</param> /// <param name="workHistory">工作经验</param> /// <param name="edeucate">教育经历</param> /// <param name="family">家庭成员</param> /// <param name="id">id</param> /// <param name="error">错误信息</param> /// <returns>成功返回true,失败返回False</returns> public bool UpdateTrainEmploye(HR_TrainEmploye trainEmploye, List <HR_WorkHistory> workHistory, List <HR_EducatedHistory> edeucate, List <HR_FamilyMember> family, int id, out string error) { error = ""; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.HR_TrainEmploye where a.ID == id select a; if (result.Count() != 1) { error = "信息有误,请查证后再操作!"; return(false); } else { HR_TrainEmploye trainEmployeList = result.Single(); trainEmployeList.Address = trainEmploye.Address; trainEmployeList.Age = trainEmploye.Age; trainEmployeList.Anne = trainEmploye.Anne; trainEmployeList.Birthday = trainEmploye.Birthday; trainEmployeList.Birthplace = trainEmploye.Birthplace; trainEmployeList.College = trainEmploye.College; trainEmployeList.ComputerLevel = trainEmploye.ComputerLevel; trainEmployeList.DesiredSalary = trainEmploye.DesiredSalary; trainEmployeList.EducatedDegree = trainEmploye.EducatedDegree; trainEmployeList.EducatedMajor = trainEmploye.EducatedMajor; trainEmployeList.EmergencyPhone = trainEmploye.EmergencyPhone; trainEmployeList.EnglishLevel = trainEmploye.EnglishLevel; trainEmployeList.Evaluate = trainEmploye.Evaluate; trainEmployeList.FileName = trainEmploye.FileName; trainEmployeList.Height = trainEmploye.Height; trainEmployeList.ID_Card = trainEmploye.ID_Card; trainEmployeList.InterviewDate = trainEmploye.InterviewDate; trainEmployeList.IsThirdParty = trainEmploye.IsThirdParty; trainEmployeList.JobYears = trainEmploye.JobYears; trainEmployeList.MaritalStatus = trainEmploye.MaritalStatus; trainEmployeList.Name = trainEmploye.Name; trainEmployeList.Nationality = trainEmploye.Nationality; trainEmployeList.Party = trainEmploye.Party; trainEmployeList.PersonType = trainEmploye.PersonType; trainEmployeList.Phone = trainEmploye.Phone; trainEmployeList.Race = trainEmploye.Race; trainEmployeList.Recorder = trainEmploye.Recorder; trainEmployeList.RecordTime = trainEmploye.RecordTime; trainEmployeList.RecruitType = trainEmploye.RecruitType; trainEmployeList.Remark = trainEmploye.Remark; trainEmployeList.ResumeStatus = trainEmploye.ResumeStatus; trainEmployeList.Sex = trainEmploye.Sex; trainEmployeList.Speciality = trainEmploye.Speciality; trainEmployeList.TakeJobDate = trainEmploye.TakeJobDate; trainEmployeList.ThirdParty = trainEmploye.ThirdParty; } var resultList = from c in dataContxt.HR_WorkHistory where c.EmployeID == id select c; if (resultList.Count() > 0) { dataContxt.HR_WorkHistory.DeleteAllOnSubmit(resultList); } foreach (var item in workHistory) { item.EmployeID = id; dataContxt.HR_WorkHistory.InsertOnSubmit(item); } var resultEducated = from e in dataContxt.HR_EducatedHistory where e.EmployeID == id select e; if (resultEducated.Count() > 0) { dataContxt.HR_EducatedHistory.DeleteAllOnSubmit(resultEducated); } foreach (var item in edeucate) { item.EmployeID = id; dataContxt.HR_EducatedHistory.InsertOnSubmit(item); } var resultFamily = from f in dataContxt.HR_FamilyMember where f.EmployeID == id select f; if (resultFamily.Count() > 0) { dataContxt.HR_FamilyMember.DeleteAllOnSubmit(resultFamily); } foreach (var item in family) { item.EmployeID = id; dataContxt.HR_FamilyMember.InsertOnSubmit(item); } dataContxt.SubmitChanges(); return(true); } catch (Exception ex) { error = ex.Message; return(false); } }
/// <summary> /// 添加储备人才信息 /// </summary> /// <param name="trainEmploye">储备人才数据集</param> /// <param name="edeucate">教育经历</param> /// <param name="family">家庭成员</param> /// <param name="workHistory">工作经验</param> /// <param name="error">错误信息</param> /// <returns>成功返回True,失败返回False</returns> public bool AddTrainEmploye(HR_TrainEmploye trainEmploye, List <HR_WorkHistory> workHistory, List <HR_EducatedHistory> edeucate, List <HR_FamilyMember> family, out string error) { error = ""; int id = 0; try { DepotManagementDataContext dataContxt = CommentParameter.DepotDataContext; var result = from a in dataContxt.HR_TrainEmploye where a.ID_Card == trainEmploye.ID_Card select a; if (result.Count() == 0) { dataContxt.HR_TrainEmploye.InsertOnSubmit(trainEmploye); dataContxt.SubmitChanges(); } else { error = "身份证为【" + trainEmploye.ID_Card + "】,姓名叫【" + trainEmploye.Name + "】的人员已经存在!"; return(false); } var resultList = from a in dataContxt.HR_TrainEmploye where a.ID_Card == trainEmploye.ID_Card select a; if (resultList.Count() == 1) { id = resultList.Single().ID; foreach (var item in workHistory) { item.EmployeID = id; dataContxt.HR_WorkHistory.InsertOnSubmit(item); } foreach (var item in edeucate) { item.EmployeID = id; dataContxt.HR_EducatedHistory.InsertOnSubmit(item); } foreach (var item in family) { item.EmployeID = id; dataContxt.HR_FamilyMember.InsertOnSubmit(item); } dataContxt.SubmitChanges(); } return(true); } catch (Exception ex) { error = ex.Message; return(false); } }