public ActionResult Edit(int id = 0) { var vm = new Models.Calendar.Edit(); if (id > 0) { using (var db = new XkSystem.Models.DbContext()) { var tb = (from p in db.Table <Basis.Entity.tbCalendar>() where p.tbYear.Id == vm.YearId && p.CalendarDate == vm.CalendarDate select new Dto.Calendar.Edit() { Id = p.Id, tbWeekId = p.tbWeek.Id, tbYearId = p.tbYear.Id, CalendarDate = p.CalendarDate, Remark = p.Remark }).FirstOrDefault(); if (tb != null) { vm.CalendarEdit = tb; } } } else { vm.CalendarEdit.tbYearId = vm.YearId; vm.CalendarDate = vm.CalendarDate; } vm.WeekList = WeekController.SelectList(); return(View(vm)); }
public ActionResult Edit(Models.Calendar.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { if (vm.CalendarEdit.Id > 0) { var tb = (from p in db.Table <Basis.Entity.tbCalendar>() where p.Id == vm.CalendarEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.Remark = vm.CalendarEdit.Remark; tb.tbWeek = db.Set <Basis.Entity.tbWeek>().Find(vm.CalendarEdit.tbWeekId); if (db.SaveChanges() > 0) { Sys.Controllers.SysUserLogController.Insert("修改了校历!"); } } else { return(Code.MvcHelper.Post(new List <string>() { Resources.LocalizedText.MsgNotFound })); } } else { var tb = new Basis.Entity.tbCalendar() { CalendarDate = vm.CalendarDate, tbWeek = db.Set <Basis.Entity.tbWeek>().Find(vm.CalendarEdit.tbWeekId), tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.YearId), Remark = vm.CalendarEdit.Remark }; db.Set <Basis.Entity.tbCalendar>().Add(tb); if (db.SaveChanges() > 0) { Sys.Controllers.SysUserLogController.Insert("添加了校历!"); } } } return(Code.MvcHelper.Post()); }