public ActionResult PowerTeacherList()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamPower.List();
var tb = from p in db.Table <Exam.Entity.tbExamPower>()
where p.tbExamCourse.Id == vm.ExamCourseId && p.tbTeacher.IsDeleted == false
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => (d.tbTeacher.TeacherCode.Contains(vm.SearchText) || d.tbTeacher.TeacherName.Contains(vm.SearchText)));
}
vm.ExamPowerList = (from p in tb
orderby p.tbTeacher.TeacherCode
select new Dto.ExamPower.List
{
Id = p.Id,
TeacherCode = p.tbTeacher.TeacherCode,
TeacherName = p.tbTeacher.TeacherName,
IsOrgTeacher = p.IsOrgTeacher
}).ToList();
return(View(vm));
}
}
public ActionResult Save(int examId)
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamPower.List();
var arrystr = new string[] { };
var ids = Request["txtId"] != null ? Request["txtId"].Split(',') : arrystr;
var fromDate = Request["FromDate"] != null ? Request["FromDate"] : string.Empty;
var toDate = Request["ToDate"] != null ? Request["ToDate"] : string.Empty;
if (string.IsNullOrEmpty(fromDate) || string.IsNullOrEmpty(toDate))
{
return(Code.MvcHelper.Post(null, Url.Action("List", new { examId = examId }), "请输入批量设置开始时间!"));
}
var error = new List <string>();
if (error.Count == decimal.Zero)
{
foreach (var id in ids)
{
var examCourseId = id.ConvertToInt();
var tb = (from p in db.Table <Exam.Entity.tbExamCourse>()
where p.Id == examCourseId
select p).FirstOrDefault();
if (tb != null)
{
tb.FromDate = fromDate.ConvertToDateTime();
tb.ToDate = toDate.ConvertToDateTime();
}
}
db.SaveChanges();
}
return(Code.MvcHelper.Post(null, string.Empty, "保存成功!"));
}
}
public ActionResult List(Models.ExamPower.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, examId = vm.ExamId, SubjectId = vm.SubjectId, CourseTypeId = vm.CourseTypeId })));
}
public ActionResult PowerTeacherList(Models.ExamPower.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("PowerTeacherList", new { searchText = vm.SearchText, examId = vm.ExamId, examCourseId = vm.ExamCourseId })));
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamPower.List();
vm.ExamName = db.Table <Exam.Entity.tbExam>().FirstOrDefault(d => d.Id == vm.ExamId).ExamName;
vm.SubjectList = Course.Controllers.SubjectController.SelectList();
vm.CourseTypeList = Course.Controllers.CourseTypeController.SelectList();
var tb = from p in db.Table <Exam.Entity.tbExamCourse>()
where p.tbExam.Id == vm.ExamId
select p;
var examPowerList = (from p in db.Table <Exam.Entity.tbExamPower>()
where p.tbExamCourse.IsDeleted == false &&
p.tbExamCourse.tbExam.Id == vm.ExamId
select new
{
p.tbTeacher.TeacherName,
ExamCourseId = p.tbExamCourse.Id
}).ToList();
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.tbCourse.CourseName.Contains(vm.SearchText));
}
if (vm.SubjectId != 0)
{
tb = tb.Where(d => d.tbCourse.tbSubject.Id == vm.SubjectId);
}
if (vm.CourseTypeId != 0)
{
tb = tb.Where(d => d.tbCourse.tbCourseType.Id == vm.CourseTypeId);
}
var tf = (from p in tb
orderby p.tbCourse.tbSubject.No, p.tbCourse.CourseName
select new
{
Id = p.Id,
SubjectName = p.tbCourse.tbSubject.SubjectName,
CourseName = p.tbCourse.CourseName,
FromDate = p.FromDate,
ToDate = p.ToDate
}).ToList();
var tg = (from p in tf
select new
{
Id = p.Id,
SubjectName = p.SubjectName,
CourseName = p.CourseName,
FromDate = p.FromDate.ConvertDateTimeToString(),
ToDate = p.ToDate.ConvertDateTimeToString(),
}).ToList();
vm.ExamPowerList = (from p in tg
select new Dto.ExamPower.List
{
Id = p.Id,
SubjectName = p.SubjectName,
CourseName = p.CourseName,
InputDate = p.FromDate + "-" + p.ToDate,
TeacherName = examPowerList.Where(d => d.ExamCourseId == p.Id).FirstOrDefault() == null ? "设置" : string.Join(",", examPowerList.Where(d => d.ExamCourseId == p.Id).Select(d => d.TeacherName).ToArray())
}).ToList();
return(View(vm));
}
}
