public ActionResult List(Models.ExamSegmentMark.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new
{
gradeId = vm.GradeId,
subjectId = vm.SubjectId,
segmentGroupId = vm.SegmentGroupId,
searchText = vm.SearchText
})));
}
public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.ExamSegmentMark.List();
vm.GradeList = Basis.Controllers.GradeController.SelectList();
vm.SubjectList = Areas.Course.Controllers.SubjectController.SelectList();
vm.SegmentGroupList = Areas.Exam.Controllers.ExamSegmentGroupController.SelectList();
var tb = from p in db.Table <Exam.Entity.tbExamSegmentMark>()
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.SegmentName.Contains(vm.SearchText));
}
if (vm.GradeId != 0)
{
tb = tb.Where(d => d.tbGrade.Id == vm.GradeId);
}
if (vm.SubjectId != 0)
{
tb = tb.Where(d => d.tbSubject.Id == vm.SubjectId);
}
if (vm.SegmentGroupId != 0)
{
tb = tb.Where(d => d.tbExamSegmentGroup.Id == vm.SegmentGroupId);
}
vm.ExamSegmentMarkList = (from p in tb
orderby p.tbGrade.No, p.tbSubject.No, p.No, p.SegmentName
select new Dto.ExamSegmentMark.List
{
Id = p.Id,
No = p.No,
SegmentName = p.SegmentName,
SubjectName = p.tbSubject.SubjectName,
ExamSegmentGroupName = p.tbExamSegmentGroup.ExamSegmentGroupName,
GradeName = p.tbGrade.GradeName,
MinMark = p.MinMark,
MaxMark = p.MaxMark,
IsGood = p.IsGood,
IsPass = p.IsPass,
IsNormal = p.IsNormal,
IsTotal = p.IsTotal,
Rate = p.Rate,
IsGenerate = p.IsGenerate
}).ToList();
return(View(vm));
}
}
