public ActionResult Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.Dorm.Edit(); vm.YearList = Areas.Basis.Controllers.YearController.SelectList(Code.EnumHelper.YearType.Year); if (vm.DormEdit.YearId == 0 && vm.YearList.Count > 0) { vm.DormEdit.YearId = vm.YearList.OrderByDescending(d => d.Selected).FirstOrDefault().Value.ConvertToInt(); } if (id > 0) { vm.DormEdit = (from p in db.Table <Dorm.Entity.tbDorm>() where p.Id == id select new Dto.Dorm.Edit() { Id = p.Id, DormName = p.DormName, IsApply = p.IsApply, YearId = p.tbYear.Id, ApplyFrom = p.ApplyFrom, ApplyTo = p.ApplyTo }).FirstOrDefault(); } return(View(vm)); } }
public ActionResult Edit(Models.Dorm.Edit vm) { var error = new List <string>(); if (error.Count == decimal.Zero) { using (var db = new XkSystem.Models.DbContext()) { if (db.Table <Dorm.Entity.tbDorm>().Where(d => d.tbYear.Id == vm.DormEdit.YearId).Count() == 0) { var tb = new Dorm.Entity.tbDorm() { No = vm.DormEdit.No, ApplyFrom = vm.DormEdit.ApplyFrom, ApplyTo = vm.DormEdit.ApplyTo, DormName = vm.DormEdit.DormName, IsApply = vm.DormEdit.IsApply, tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.DormEdit.YearId) }; db.Set <Dorm.Entity.tbDorm>().Add(tb); } else { var tb = db.Table <Dorm.Entity.tbDorm>().Where(d => d.tbYear.Id == vm.DormEdit.YearId).FirstOrDefault(); tb.ApplyFrom = vm.DormEdit.ApplyFrom; tb.ApplyTo = vm.DormEdit.ApplyTo; tb.DormName = vm.DormEdit.DormName; tb.IsApply = vm.DormEdit.IsApply; tb.No = vm.DormEdit.No; tb.tbYear = db.Set <Basis.Entity.tbYear>().Find(vm.DormEdit.YearId); } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改/添加了住宿"); } } } return(Code.MvcHelper.Post(error)); }