public void TestMethod1() { CaseAllPageRequestModel request = new CaseAllPageRequestModel() { PageSize = 100, }; CaseAllController call = new CaseAllController(); var list = call.GetPageIndex(request); }
/// <summary> /// 所有案件列表查询 /// </summary> /// <param name="request"></param> /// <returns></returns> public ActionResult GetPageIndex(CaseAllPageRequestModel request) { var bad = new ALLCaseDAL(); var response = new CaseAllPageResponseModel(); var list = bad.GetAll(CurrentUser); list = list.Where(s => !s.NewCaseNum.Contains("HIS")); if (!string.IsNullOrEmpty(request.CaseNum)) { list = list.Where(s => s.NewCaseNum.Contains(request.CaseNum)); } if (!string.IsNullOrEmpty(request.SalesGroupId)) { list = list.Where(s => s.SalesGroupID == request.SalesGroupId); } if (!string.IsNullOrEmpty(request.CaseMode)) { if (request.CaseMode == "-CaseMode-WeiXuanZe") { list = list.Where(s => s.CaseMode == null); } else { list = list.Where(s => s.CaseMode == request.CaseMode); } } if (!string.IsNullOrEmpty(request.ThirdParty)) { list = list.Where(s => s.ThirdParty == request.ThirdParty); } if (!string.IsNullOrEmpty(request.BorrowerName)) { list = list.Where(s => s.BorrowerName.Contains(request.BorrowerName)); } if (!string.IsNullOrEmpty(request.CaseStatus)) { list = list.Where(s => s.CaseStatus == request.CaseStatus); } if (!string.IsNullOrEmpty(request.LendTimeStart.ToString())) { list = list.Where(s => s.LendTime >= request.LendTimeStart); } if (!string.IsNullOrEmpty(request.LendTimeEnd.ToString())) { list = list.Where(s => request.LendTimeEnd != null && s.LendTime <= request.LendTimeEnd); } try { var caselist = list.Skip((request.PageIndex - 1) * request.PageSize).Take(request.PageSize); var newcaselist = caselist.Select(s => new CaseAllPageViewModel().CopyModel(s)); response.PageIndex = request.PageIndex; response.PageSize = request.PageSize == 0 ? 10 : request.PageSize; response.Total = list.Count(); response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize); response.Data = newcaselist; return(Json(response, JsonRequestBehavior.AllowGet)); } catch (Exception e) { response.PageIndex = request.PageIndex; response.PageSize = request.PageSize == 0 ? 10 : request.PageSize; response.Total = 0; //response.TotalPage = (int)Math.Ceiling((decimal)response.Total / response.PageSize); response.Data = null; return(Json(response, JsonRequestBehavior.AllowGet)); } }