public ActionResult Edit(int id = 0)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ClassTeacher.Edit();
if (id != 0)
{
var tb = (from p in db.Table <Basis.Entity.tbClassTeacher>()
where p.Id == id
select new Dto.ClassTeacher.Edit
{
Id = p.Id,
ClassId = p.tbClass.Id,
TeacherId = p.tbTeacher.Id
}).FirstOrDefault();
if (tb != null)
{
vm.ClassTeacherEdit = tb;
}
}
return(View(vm));
}
}
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));
}
}
