public ActionResult Edit(StaffSkillViewModel staffSkill) { if (ModelState.IsValid) { StaffSkill ss = db.StaffSkills.Find(staffSkill.Id); /*查找员工技能预留字段(value)*/ var fieldValueList = (from ssr in db.StaffSkillReserves join rf in db.ReserveFields on ssr.FieldId equals rf.Id where ssr.Number == staffSkill.Id && rf.Status == true select new StaffSkillViewModel { Id = ssr.Id, Description = rf.Description, Value = ssr.Value }).ToList(); //ViewBag.fieldValueList = fieldValueList; /*给预留字段赋值*/ foreach (var temp in fieldValueList) { StaffSkillReserve ssr = db.StaffSkillReserves.Find(temp.Id); ssr.Value = Request[temp.Description]; db.SaveChanges(); } ss.ValidDate = staffSkill.ValidDate; ss.StaffNumber = staffSkill.StaffNumber; ss.SkillRemark = staffSkill.SkillRemark; ss.SkillNumber = staffSkill.SkillNumber; ss.BillTypeNumber = staffSkill.BillTypeNumber; ss.BillNumber = staffSkill.BillNumber; ss.ChangePerson = base.Name; ss.ChangeTime = DateTime.Now; db.SaveChanges(); return(RedirectToAction("Index")); } return(View(staffSkill)); }
public ActionResult Create(StaffSkill staffSkill) { if (ModelState.IsValid) { /*先保存员工技能固定的字段(为了生成主键Id)*/ db.StaffSkills.Add(staffSkill); db.SaveChanges(); /*查找员工技能预留字段(name)*/ var fieldList = (from p in db.ReserveFields where p.TableName == "StaffSkills" select p).ToList(); ViewBag.fieldList = fieldList; /*遍历,保存员工技能变化的字段*/ foreach (var temp in fieldList) { StaffSkillReserve ssr = new StaffSkillReserve(); ssr.Number = staffSkill.Id; ssr.FieldId = temp.Id; ssr.Value = Request[temp.FieldName]; /*占位,为了在Index中显示整齐的格式*/ if (ssr.Value == null) { ssr.Value = " "; } db.StaffSkillReserves.Add(ssr); db.SaveChanges(); } return(RedirectToAction("Index")); } return(View(staffSkill)); }
public ActionResult DeleteConfirmed(int id) { /*Step1:删除预留字段*/ var item = (from ssr in db.StaffSkillReserves where ssr.Number == id select new StaffSkillViewModel { Id = ssr.Id }).ToList(); foreach (var temp in item) { StaffSkillReserve ssr = db.StaffSkillReserves.Find(temp.Id); db.StaffSkillReserves.Remove(ssr); } db.SaveChanges(); /*Step2:删除固定字段*/ StaffSkill staffSkill = db.StaffSkills.Find(id); db.StaffSkills.Remove(staffSkill); db.SaveChanges(); return(RedirectToAction("Index")); }
public ActionResult Create(StaffSkill staffSkill3) { if (ModelState.IsValid) { staffSkill3.RecordTime = DateTime.Now; if (staffSkill3.ValidDate < DateTime.Today) { ModelState.AddModelError("", "生效日期错误!请重新选择"); CreateInite(); StaffSkillViewModel staffSkill = new StaffSkillViewModel(); staffSkill.Id = staffSkill3.Id; staffSkill.BillNumber = staffSkill3.BillNumber; staffSkill.StaffNumber = staffSkill3.StaffNumber; staffSkill.SkillNumber = staffSkill3.SkillNumber; staffSkill.SkillRemark = staffSkill3.SkillRemark; staffSkill.ValidDate = staffSkill3.ValidDate; return(View(staffSkill)); } staffSkill3.BillNumber = GenerateBillNumber(staffSkill3.BillTypeNumber); staffSkill3.RecordPerson = base.Name; /*先保存员工技能固定的字段(为了生成主键Id)*/ db.StaffSkills.Add(staffSkill3); db.SaveChanges(); //提交审核 byte status = AuditApplicationStaffSkill(staffSkill3); if (status == 7) { ViewBag.alertMessage = true; CreateInite(); StaffSkillViewModel staffSkill = new StaffSkillViewModel(); staffSkill.Id = staffSkill3.Id; // staffSkill.BillTypeNumber = GenerateBillNumber(); staffSkill.BillNumber = staffSkill3.BillNumber; staffSkill.StaffNumber = staffSkill3.StaffNumber; staffSkill.SkillNumber = staffSkill3.SkillNumber; staffSkill.SkillRemark = staffSkill3.SkillRemark; staffSkill.ValidDate = staffSkill3.ValidDate; return(View(staffSkill3)); } else { //需要对原表做出的修改 staffSkill3.AuditStatus = status; db.SaveChanges(); } /*查找员工技能预留字段(name)*/ var fieldList = (from p in db.ReserveFields join q in db.TableNameContrasts on p.TableNameId equals q.Id where q.TableName == "StaffSkills" select p).ToList(); ViewBag.fieldList = fieldList; /*遍历,保存员工技能变化的字段*/ foreach (var temp in fieldList) { StaffSkillReserve ssr = new StaffSkillReserve(); ssr.Number = staffSkill3.Id; ssr.FieldId = temp.Id; ssr.Value = Request[temp.FieldName]; /*占位,为了在Index中显示整齐的格式*/ if (ssr.Value == null) { ssr.Value = " "; } db.StaffSkillReserves.Add(ssr); db.SaveChanges(); } return(RedirectToAction("Index")); } else { CreateInite(); StaffSkillViewModel staffSkill = new StaffSkillViewModel(); staffSkill.Id = staffSkill3.Id; // staffSkill.BillTypeNumber = GenerateBillNumber(); staffSkill.BillNumber = staffSkill3.BillNumber; staffSkill.StaffNumber = staffSkill3.StaffNumber; staffSkill.SkillNumber = staffSkill3.SkillNumber; staffSkill.SkillRemark = staffSkill3.SkillRemark; staffSkill.ValidDate = staffSkill3.ValidDate; return(View(staffSkill)); } }