//更新用户教育经历
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);
}
}
