public ActionResult List()
{
using (var db = new XkSystem.Models.DbContext())
{
var vm = new Models.StudentChange.List();
var tb = from p in db.Table <Student.Entity.tbStudentChange>()
select p;
if (string.IsNullOrEmpty(vm.SearchText) == false)
{
tb = tb.Where(d => d.tbStudentChangeType.StudentChangeTypeName.Contains(vm.SearchText) ||
d.tbSysUser.UserCode.Contains(vm.SearchText) ||
d.tbSysUser.UserName.Contains(vm.SearchText) ||
d.tbStudent.StudentCode.Contains(vm.SearchText) ||
d.tbStudent.StudentName.Contains(vm.SearchText) ||
d.tbStudent.StudentNameEn.Contains(vm.SearchText));
}
vm.StudentChangeList = (from p in tb
orderby p.InputDate descending
select new Dto.StudentChange.List
{
Id = p.Id,
StudentCode = p.tbStudent.StudentCode,
StudentName = p.tbStudent.StudentName,
StudentChangeTypeName = p.tbStudentChangeType.StudentChangeTypeName,
InputDate = p.InputDate,
UserName = p.tbSysUser.UserName,
StudentChangeType = p.tbStudentChangeType.StudentChangeType
}).ToPageList(vm.Page);
return(View(vm));
}
}
public ActionResult List(Models.StudentChange.List vm)
{
return(Code.MvcHelper.Post(null, Url.Action("List", new { searchText = vm.SearchText, pageIndex = vm.Page.PageIndex, pageSize = vm.Page.PageSize })));
}
