public ActionResult Edit(Models.ExamLevel.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { if (vm.ExamLevelEdit.Id == 0) { var tb = new Exam.Entity.tbExamLevel(); tb.No = vm.ExamLevelEdit.No == null?db.Table <Exam.Entity.tbExamLevel>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.ExamLevelEdit.No; tb.ExamLevelName = vm.ExamLevelEdit.ExamLevelName; tb.tbExamLevelGroup = db.Set <Exam.Entity.tbExamLevelGroup>().Find(vm.LevelGroupId); tb.Rate = vm.ExamLevelEdit.Rate; tb.ExamLevelValue = vm.ExamLevelEdit.ExamLevelValue; tb.MaxScore = vm.ExamLevelEdit.MaxScore; tb.MinScore = vm.ExamLevelEdit.MinScore; db.Set <Exam.Entity.tbExamLevel>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加考试等级"); } } else { var tb = (from p in db.Table <Exam.Entity.tbExamLevel>() where p.Id == vm.ExamLevelEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.No = vm.ExamLevelEdit.No == null?db.Table <Exam.Entity.tbExamLevel>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.ExamLevelEdit.No; tb.ExamLevelName = vm.ExamLevelEdit.ExamLevelName; tb.tbExamLevelGroup = db.Set <Exam.Entity.tbExamLevelGroup>().Find(vm.LevelGroupId); tb.Rate = vm.ExamLevelEdit.Rate; tb.ExamLevelValue = vm.ExamLevelEdit.ExamLevelValue; tb.MaxScore = vm.ExamLevelEdit.MaxScore; tb.MinScore = vm.ExamLevelEdit.MinScore; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改考试等级"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } } return(Code.MvcHelper.Post(error)); } }
public ActionResult Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ExamLevel.Edit(); if (id != 0) { var tb = (from p in db.Table <Exam.Entity.tbExamLevel>() where p.Id == id select p).FirstOrDefault(); if (tb != null) { vm.ExamLevelEdit = tb; } } return(View(vm)); } }