/// <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));
}