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