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());
}
