/// <summary> /// 查询结清案件 /// </summary> /// <param name="input">查询条件</param> /// <param name="total">总条数</param> /// <returns>结清案件</returns> public IEnumerable <BaseAudit> GetFinishedCases(GetFinishedCasesInput input, out int total) { var allCases = GetAllFinishedCase(); if (input.BorrowerName.IsNotNullOrWhiteSpace()) { allCases = allCases.Where(p => p.BorrowerName.Contains(input.BorrowerName)); } if (input.CaseNum.IsNotNullOrWhiteSpace()) { allCases = allCases.Where(p => p.CaseNum.Contains(input.CaseNum)); } var pageResult = _auditDal.GetAllPage(allCases, out total, input.PageSize, input.PageIndex, input.Order, input.Sort); return(pageResult); }
public ActionResult GetPageIndex(LendingCriteriaRequest request) { BaseAuditDAL bd = new BaseAuditDAL(); LendingDAL ld = new LendingDAL(); int total = 0; request.PageSize = request.PageSize == 0 ? 10 : request.PageSize; request.PageIndex = request.PageIndex == 0 ? 1 : request.PageIndex; var modellist = ld.GetAllAuthorizeAndSelf(request.StartDate, request.EndDate, 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); } IEnumerable <BaseAudit> pageList = bd.GetAllPage(modellist, out total, request.PageSize, request.PageIndex, request.Order, request.Sort); var response = new PageResponseViewModel <LendingPageViewModel>(); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize; response.Total = total; response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize); response.Data = Map(pageList.ToList()); return(Json(response, JsonRequestBehavior.AllowGet)); }
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)); }