public ActionResult Edit(int id = 0) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.Course.Edit(); vm.SubjectList = Course.Controllers.SubjectController.SelectList(); vm.CourseTypeList = Course.Controllers.CourseTypeController.SelectList(); vm.CourseDomainList = Course.Controllers.CourseDomainController.SelectList(); vm.CourseGroupList = Course.Controllers.CourseGroupController.SelectList(); if (id != 0) { var tb = (from p in db.Table <Course.Entity.tbCourse>() where p.Id == id select new Dto.Course.Edit { Id = p.Id, CourseName = p.CourseName, CourseNameEn = p.CourseNameEn, CourseTypeId = p.tbCourseType.Id, SubjectId = p.tbSubject.Id, Point = p.Point, Hour = p.Hour, CourseCode = p.CourseCode, Remark = p.Remark, CourseDomainId = p.tbCourseDomain.Id, CourseGroupId = p.tbCourseGroup.Id, IsLevel = p.IsLevel }).FirstOrDefault(); if (tb != null) { vm.CourseEdit = tb; } } return(View(vm)); } }
public ActionResult Edit(Models.Course.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == 0) { if (db.Table <Course.Entity.tbCourse>().Where(d => d.CourseName == vm.CourseEdit.CourseName && d.Id != vm.CourseEdit.Id).Any()) { error.AddError("该课程已存在!"); } else { if (vm.CourseEdit.Id == 0) { var tb = new Course.Entity.tbCourse(); tb.tbSubject = db.Set <Course.Entity.tbSubject>().Find(vm.CourseEdit.SubjectId); tb.tbCourseType = db.Set <Course.Entity.tbCourseType>().Find(vm.CourseEdit.CourseTypeId); tb.CourseName = vm.CourseEdit.CourseName; tb.CourseCode = vm.CourseEdit.CourseCode; tb.CourseNameEn = vm.CourseEdit.CourseNameEn; tb.tbCourseDomain = db.Set <Course.Entity.tbCourseDomain>().Find(vm.CourseEdit.CourseDomainId); tb.tbCourseGroup = db.Set <Course.Entity.tbCourseGroup>().Find(vm.CourseEdit.CourseGroupId); tb.Point = vm.CourseEdit.Point; tb.Hour = vm.CourseEdit.Hour; tb.Remark = vm.CourseEdit.Remark; tb.IsLevel = vm.CourseEdit.IsLevel; db.Set <Course.Entity.tbCourse>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了课程"); } } else { var tb = (from p in db.Table <Course.Entity.tbCourse>() .Include(d => d.tbCourseDomain) where p.Id == vm.CourseEdit.Id select p).FirstOrDefault(); if (tb != null) { tb.CourseName = vm.CourseEdit.CourseName; tb.CourseCode = vm.CourseEdit.CourseCode; tb.CourseNameEn = vm.CourseEdit.CourseNameEn; tb.tbSubject = db.Set <Course.Entity.tbSubject>().Find(vm.CourseEdit.SubjectId); tb.tbCourseType = db.Set <Course.Entity.tbCourseType>().Find(vm.CourseEdit.CourseTypeId); tb.tbCourseDomain = db.Set <Course.Entity.tbCourseDomain>().Find(vm.CourseEdit.CourseDomainId); tb.tbCourseGroup = db.Set <Course.Entity.tbCourseGroup>().Find(vm.CourseEdit.CourseGroupId); tb.Point = vm.CourseEdit.Point; tb.Hour = vm.CourseEdit.Hour; tb.Remark = vm.CourseEdit.Remark; tb.IsLevel = vm.CourseEdit.IsLevel; if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了课程"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } } } return(Code.MvcHelper.Post(error)); } }