//更新用户教育经历 public bool Update(EduExperience edex) { try { if (edex != null) { EduExperience newedex = dbcontext.EduExperienceContext.Find(edex.EduExperienceID); newedex.EduExperienceID = edex.EduExperienceID; newedex.UserInfoID = edex.UserInfoID; newedex.StartTime = edex.StartTime; newedex.EndTime = edex.EndTime; newedex.Major = edex.Major; newedex.EHoldOffice = edex.EHoldOffice; newedex.SecrecyLevel = edex.SecrecyLevel; newedex.Remark = edex.Remark; dbcontext.SaveChanges(); return(true); } else { return(false); } } catch (System.Data.SqlClient.SqlException e) { throw e; } }
//删除用户教育经历 public bool Delete(int EduExperienceID) { try { EduExperience edex = dbcontext.EduExperienceContext.Where(u => u.EduExperienceID == EduExperienceID).FirstOrDefault(); dbcontext.EduExperienceContext.Attach(edex); dbcontext.EduExperienceContext.Remove(edex); dbcontext.SaveChanges(); return(true); } catch (System.Data.SqlClient.SqlException e) { throw e; } }
//更新IsPass状态 public void UpdateIsPass(int ID, bool isPass) { try { EduExperience NewEduExperience = dbcontext.EduExperienceContext.Find(ID); if (NewEduExperience == null) { return; } NewEduExperience.IsPass = isPass; dbcontext.SaveChanges(); } catch { throw; } }
public void BindData() { try { List <EduExperience> edulist = bllEdu.FindEduExperienceID(Convert.ToInt32(Session["EduExperienceID"])); EduExperience education = edulist.FirstOrDefault(); UserInfoName.Text = bllUser.FindByUserID(Convert.ToInt32(education.UserInfoID)); DatePickerStartTime.SelectedDate = education.StartTime; DatePickerEndTime.SelectedDate = education.EndTime; Major.Text = education.Major; EHoldOffice.Text = education.EHoldOffice; DropDownListSecrecyLevel.SelectedIndex = Convert.ToInt32(education.SecrecyLevel - 1); Remark.Text = education.Remark; } catch (Exception ex) { publicmethod.SaveError(ex, this.Request);; } }
//为某用户添加教育经历 public bool InsertForPeople(EduExperience edex) { try { if (edex != null) { dbcontext.EduExperienceContext.Add(edex); dbcontext.SaveChanges(); return(true); } else { return(false); } } catch (System.Data.SqlClient.SqlException e) { throw e; } }
//保存 protected void Save_Click(object sender, EventArgs e) { try { if (UserInfoName.Text.Trim() != "") { if (bllUser.IsUser(UserInfoName.Text.Trim()) != null) { if (bllUser.IsUser(UserInfoName.Text.Trim()).IsPass == true) { if (EHoldOffice.Text.Trim() == "") { Alert.ShowInTop("教育单位不能为空!"); EHoldOffice.Text = ""; return; } if (Major.Text.Trim() == "") { Alert.ShowInTop("所学专业不能为空!"); Major.Text = ""; return; } EduExperience eduE = new EduExperience(); eduE.UserInfoID = bllUser.FindID(UserInfoName.Text.Trim()); eduE.StartTime = DatePickerStartTime.SelectedDate; if (DatePickerEndTime.SelectedDate.HasValue) { if (DatePickerEndTime.SelectedDate < DatePickerStartTime.SelectedDate) { Alert.ShowInTop("结束时间不能小于开始时间!"); return; } else { eduE.EndTime = DatePickerEndTime.SelectedDate; } } eduE.Remark = Remark.Text.Trim(); eduE.EndTime = DatePickerEndTime.SelectedDate; eduE.Major = Major.Text.Trim(); eduE.EHoldOffice = EHoldOffice.Text.Trim(); eduE.SecrecyLevel = DropDownListSecrecyLevel.SelectedIndex + 1; eduE.EntryPerson = bllEdu.Find(Convert.ToInt32(Session["EduExperienceID"])).EntryPerson; if (Convert.ToInt32(Session["SecrecyLevel"]) != 5) { bllEdu.UpdateIsPass(Convert.ToInt32(Session["EduExperienceID"]), false); eduE.IsPass = false; bllEdu.InsertForPeople(eduE); //插入教育经历表 OperationLog operate = new OperationLog(); operate.LoginName = bllEdu.Find(Convert.ToInt32(Session["EduExperienceID"])).EntryPerson; operate.LoginIP = ""; operate.OperationType = "更新"; operate.OperationContent = "EduExperience"; operate.OperationDataID = Convert.ToInt32(Session["EduExperienceID"]); operate.OperationTime = System.DateTime.Now; operate.Remark = eduE.EduExperienceID.ToString(); bllOperate.Insert(operate);//插入操作表 PageContext.RegisterStartupScript(ActiveWindow.GetConfirmHideRefreshReference() + Alert.GetShowInTopReference("人员教育经历信息已提交审核!")); } else { eduE.IsPass = true; eduE.EduExperienceID = Convert.ToInt32(Session["EduExperienceID"]); bllEdu.Update(eduE); //更新教育经历表 PageContext.RegisterStartupScript(ActiveWindow.GetConfirmHideRefreshReference() + Alert.GetShowInTopReference("人员教育经历信息已修改完成!")); } } else { Alert.ShowInTop("该人员尚未通过审核!"); } } else { Alert.ShowInTop("人员不存在!"); UserInfoName.Text = ""; } } else { Alert.ShowInTop("人员名称不能为空!"); UserInfoName.Text = ""; return; } } catch (Exception ex) { publicmethod.SaveError(ex, this.Request); } }