public ActionResult List()
{
var vm = new Models.DormData.List();
vm.DormOptionList = DormOptionController.SelectList();
using (var db = new XkSystem.Models.DbContext())
{
var tb = db.Table <Dorm.Entity.tbDormData>();
if (!string.IsNullOrEmpty(vm.SearchText))
{
tb = tb.Where(d => d.tbStudent.StudentCode.Contains(vm.SearchText) || d.tbStudent.StudentName.Contains(vm.SearchText));
}
if (vm.DormOptionId > 0)
{
tb = tb.Where(d => d.tbDormOption.Id == vm.DormOptionId);
}
vm.DormDataList = (from p in tb
orderby p.No
select new Dto.DormData.List()
{
Id = p.Id,
DormOptionName = p.tbDormOption.DormOptionName,
DormOptionValue = p.tbDormOption.DormOptionValue,
InputDate = p.InputDate,
Sex = p.tbStudent.tbSysUser.tbSex.SexName,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName
}).ToPageList(vm.Page);
}
return(View(vm));
}
public ActionResult List(Models.DormData.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new
{
SearchText = vm.SearchText,
DormOptionId = vm.DormOptionId,
pageIndex = vm.Page.PageIndex,
pageSize = vm.Page.PageSize
})));
}
