public ActionResult Edit(int id = 0)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.StudyCost.Edit();
vm.TeacherList = Teacher.Controllers.TeacherController.SelectList();
if (id != 0)
{
var tb = (from p in db.Table <Study.Entity.tbStudyCost>()
where p.Id == id
select new Dto.StudyCost.Edit
{
Id = p.Id,
No = p.No,
TeacherId = p.tbTeacher.Id,
Cost = p.Cost
}).FirstOrDefault();
if (tb != null)
{
vm.StudyCostEdit = tb;
}
}
return(View(vm));
}
}
public ActionResult Edit(Models.StudyCost.Edit vm)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
if (error.Count == decimal.Zero)
{
if (vm.StudyCostEdit.Id == 0)
{
var check = (from p in db.Table <Study.Entity.tbStudyCost>()
where p.tbTeacher.Id == vm.StudyCostEdit.TeacherId
select p).FirstOrDefault();
if (check == null)
{
var tb = new Study.Entity.tbStudyCost();
tb.No = vm.StudyCostEdit.No == null?db.Table <Study.Entity.tbStudyCost>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.StudyCostEdit.No;
tb.tbTeacher = db.Set <Teacher.Entity.tbTeacher>().Find(vm.StudyCostEdit.TeacherId);
tb.Cost = Convert.ToDecimal(vm.StudyCostEdit.Cost);
db.Set <Study.Entity.tbStudyCost>().Add(tb);
}
else
{
check.Cost = Convert.ToDecimal(vm.StudyCostEdit.Cost);
}
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加费用设置");
}
}
else
{
var tb = (from p in db.Table <Study.Entity.tbStudyCost>()
where p.Id == vm.StudyCostEdit.Id
select p).FirstOrDefault();
if (tb != null)
{
tb.No = vm.StudyCostEdit.No == null?db.Table <Study.Entity.tbStudyCost>().Select(d => d.No).DefaultIfEmpty(0).Max() + 1 : (int)vm.StudyCostEdit.No;
tb.tbTeacher = db.Set <Teacher.Entity.tbTeacher>().Find(vm.StudyCostEdit.TeacherId);
tb.Cost = Convert.ToDecimal(vm.StudyCostEdit.Cost);
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改费用设置");
}
}
else
{
error.AddError(Resources.LocalizedText.MsgNotFound);
}
}
}
return(Code.MvcHelper.Post(error, Url.Action("List")));
}
}
