public ActionResult GetPageIndex(BaseAuditListPageRequestViewModel request) { var response = new BaseAuditListPageResponseViewModel(); var total = 0; var modellist = _baseAuditDal.GetAllAuthorizeAndSelfByPublic(CaseStatus.PublicMortgage, CurrentUser); if (!string.IsNullOrEmpty(request.CaseStatus)) { modellist = modellist.Where(t => t.CaseStatus == request.CaseStatus); } if (!string.IsNullOrEmpty(request.BorrowerName) && !string.IsNullOrWhiteSpace(request.BorrowerName)) { modellist = modellist.Where(t => t.BorrowerName.Contains(request.BorrowerName)); } if (!string.IsNullOrEmpty(request.CaseNum) && !string.IsNullOrWhiteSpace(request.CaseNum)) { modellist = modellist.Where(t => t.NewCaseNum.Contains(request.CaseNum)); } if (request.SalesGroupId.IsNotNullOrWhiteSpace() && request.SalesGroupId.IsNotNullOrEmpty()) { modellist = modellist.Where(t => t.SalesGroupID == request.SalesGroupId); } var PageList = _baseAuditDal.GetAllPage(modellist, out total, request.PageSize, request.PageIndex, request.Order, request.Sort); //var PageList = _baseAuditDal.GetAllPageOrderByCaseStatus(modellist, out total, request.PageSize, request.PageIndex, request.Order, request.Sort); var newlist = PageList.ToList().Select(t => new BaseAuditViewModel().CastModel(t)); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize == 0 ? 10 : request.PageSize; response.Total = total; response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize); response.Data = newlist; return(Json(response, JsonRequestBehavior.AllowGet)); }