public ActionResult Insert(List <int> ids, int classId) { using (var db = new XkSystem.Models.DbContext()) { var vm = new Models.ClassTeacher.Edit(); var classTeacherList = (from p in db.Table <Basis.Entity.tbClassTeacher>() where p.tbClass.Id == classId select p.tbTeacher.Id).ToList(); var TeacherList = (from p in db.Table <Teacher.Entity.tbTeacher>() where ids.Contains(p.Id) && classTeacherList.Contains(p.Id) == false select p).ToList(); foreach (var Teacher in TeacherList) { var tb = new Basis.Entity.tbClassTeacher(); tb.tbClass = db.Set <Basis.Entity.tbClass>().Find(classId); tb.tbTeacher = Teacher; db.Set <Basis.Entity.tbClassTeacher>().Add(tb); } if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("批量导入了班主任"); } return(Json(new { Status = decimal.One, Message = "操作成功!" })); } }
public ActionResult Edit(Models.ClassTeacher.Edit vm) { using (var db = new XkSystem.Models.DbContext()) { var error = new List <string>(); if (error.Count == decimal.Zero) { if (vm.ClassTeacherEdit.Id == 0) { var tb = new Basis.Entity.tbClassTeacher(); tb.tbClass = db.Set <Basis.Entity.tbClass>().Find(vm.ClassId); tb.tbTeacher = db.Set <Teacher.Entity.tbTeacher>().Find(vm.ClassTeacherEdit.TeacherId); db.Set <Basis.Entity.tbClassTeacher>().Add(tb); if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("添加了班主任"); } } else { var tb = (from p in db.Table <Basis.Entity.tbClassTeacher>() where p.Id == vm.ClassTeacherEdit.Id select p).FirstOrDefault(); if (tb != null) { if (db.SaveChanges() > 0) { XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("修改了班主任"); } } else { error.AddError(Resources.LocalizedText.MsgNotFound); } } } return(Code.MvcHelper.Post(error)); } }