public ActionResult Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.MoralGroup.Edit(); if (id > 0) { var tb = (from p in db.Table <Moral.Entity.tbMoralGroup>() where p.Id == id select new Dto.MoralGroup.Edit() { Id = p.Id, No = p.No, MoralGroupName = p.MoralGroupName, MoralId = p.tbMoral.Id }).FirstOrDefault(); if (tb != null) { vm.MoralGroupEdit = tb; } } else { vm.MoralGroupEdit.No = db.Table <Moral.Entity.tbMoralGroup>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1; } return(View(vm)); } }
public ActionResult Edit(Models.MoralGroup.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var isExists = db.Table <Moral.Entity.tbMoralGroup>().Count(p => p.MoralGroupName.Equals(vm.MoralGroupEdit.MoralGroupName) && p.tbMoral.Id == vm.MoralId && p.Id != vm.MoralGroupEdit.Id) > 0; if (isExists) { var error = new List <string>() { "系统中已存在相同名称的记录!" }; return(Code.MvcHelper.Post(error)); } if (vm.MoralGroupEdit.Id == 0) { var tb = new Moral.Entity.tbMoralGroup() { No = vm.MoralGroupEdit.No.HasValue ? vm.MoralGroupEdit.No.Value : db.Table <Moral.Entity.tbMoralGroup>().Where(p => p.tbMoral.Id == vm.MoralId).Select(d => d.No).DefaultIfEmpty(0).Max() + 1, MoralGroupName = vm.MoralGroupEdit.MoralGroupName, tbMoral = db.Set <Moral.Entity.tbMoral>().Find(vm.MoralId) }; db.Set <Moral.Entity.tbMoralGroup>().Add(tb); if (db.SaveChanges() > 0) { Sys.Controllers.SysUserLogController.Insert("添加了德育分组!"); } } else { var tb = db.Set <Moral.Entity.tbMoralGroup>().Find(vm.MoralGroupEdit.Id); tb.No = vm.MoralGroupEdit.No.HasValue ? vm.MoralGroupEdit.No.Value : db.Table <Moral.Entity.tbMoralGroup>().Where(p => p.tbMoral.Id == vm.MoralId).Select(d => d.No).DefaultIfEmpty(0).Max() + 1; tb.MoralGroupName = vm.MoralGroupEdit.MoralGroupName; tb.tbMoral = db.Set <Moral.Entity.tbMoral>().Find(vm.MoralId); if (db.SaveChanges() > 0) { Sys.Controllers.SysUserLogController.Insert("修改了德育分组!"); } } } return(Code.MvcHelper.Post()); }