public ActionResult InserOrgTeacher(int examId, int examCourseId)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamCourse.List();
var error = new List <string>();
if (error.Count == decimal.Zero)
{
var year = (from p in db.Table <Exam.Entity.tbExamCourse>()
where p.Id == examCourseId && p.tbCourse.IsDeleted == false &&
p.tbExam.Id == examId
select new
{
YearId = p.tbExam.tbYear.Id,
CouseId = p.tbCourse.Id
}).FirstOrDefault();
var teacherList = (from p in db.Table <Course.Entity.tbOrgTeacher>()
where p.tbOrg.IsDeleted == false && p.tbTeacher.IsDeleted == false &&
p.tbOrg.tbCourse.Id == year.CouseId &&
p.tbOrg.tbYear.Id == year.YearId
select p.tbTeacher).Distinct().ToList();
foreach (var Teacher in teacherList)
{
var check = (from p in db.Table <Exam.Entity.tbExamPower>()
where p.tbExamCourse.Id == examCourseId &&
p.tbTeacher.Id == Teacher.Id
select p).FirstOrDefault();
if (check == null)
{
var tb = new Exam.Entity.tbExamPower();
tb.tbExamCourse = db.Set <Exam.Entity.tbExamCourse>().Find(examCourseId);
tb.tbTeacher = Teacher;
tb.IsOrgTeacher = true;
db.Set <Exam.Entity.tbExamPower>().Add(tb);
}
}
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("批量添加录入人员");
}
db.SaveChanges();
}
return(Code.MvcHelper.Post(null, string.Empty, "添加成功!"));
}
}
public ActionResult Insert(List <int> ids, int examCourseId)
{
using (var db = new XkSystem.Models.DbContext())
{
var error = new List <string>();
var classTeacherList = (from p in db.Table <Exam.Entity.tbExamPower>()
where p.tbExamCourse.Id == examCourseId
select p.tbTeacher.Id).ToList();
var check = (from p in db.Table <Exam.Entity.tbExamPower>()
where p.tbExamCourse.Id == examCourseId &&
ids.Contains(p.tbTeacher.Id)
select new
{
p.tbTeacher.TeacherCode,
p.tbTeacher.TeacherName,
p.tbExamCourse.tbCourse.CourseName
}).ToList();
if (check.Count > 0)
{
error.AddError(string.Join("\r\n", check.Select(d => d.TeacherCode + "(" + d.TeacherName + ")已在" + d.CourseName).ToList()));
}
else
{
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 Exam.Entity.tbExamPower();
tb.tbExamCourse = db.Set <Exam.Entity.tbExamCourse>().Find(examCourseId);
tb.tbTeacher = Teacher;
tb.IsOrgTeacher = false;
db.Set <Exam.Entity.tbExamPower>().Add(tb);
}
if (db.SaveChanges() > 0)
{
XkSystem.Areas.Sys.Controllers.SysUserLogController.Insert("批量添加录入人员");
}
}
return(Code.MvcHelper.Post(error));
}
}
