public DataPack <ResponseInsuranceDepositLog> QueryInsuranceDepositLog(RequestQueryInsuranceDepositLog qInsuranceDepositLog, int pageIndex, int pageSize = 20) { pageIndex = (pageIndex - 1) * pageSize; IQueryable <InsuranceDepositLog> query; var insuranceDomainService = ObjectFactory.GetInstance <InsuranceDomainService>(); //查询参数 string bussinessCode = null; DateTime?buyStartTime = null; DateTime?buyEndTime = null; EnumInsuranceDepositType?insuranceDepositType = null; string payNo = null; string tradeId = null; //获得查询参数 if (qInsuranceDepositLog != null) { if (qInsuranceDepositLog.IsCtrlStationCall) { if (!string.IsNullOrWhiteSpace(qInsuranceDepositLog.Code)) { bussinessCode = qInsuranceDepositLog.Code; } } else { bussinessCode = _code; } buyStartTime = qInsuranceDepositLog.BuyStartTime; buyEndTime = qInsuranceDepositLog.BuyEndTime; insuranceDepositType = qInsuranceDepositLog.InsuranceDepositType; payNo = qInsuranceDepositLog.PayNo; tradeId = qInsuranceDepositLog.TradeId; } //查询逻辑 query = insuranceDomainService.QueryInsuranceDepositLog(bussinessCode, payNo, tradeId, buyStartTime, buyEndTime, insuranceDepositType); //排序 query = query.OrderByDescending(p => p.BuyTime); //获取总数 var total = query.Count(); //分页 query = query.Skip(pageIndex).Take(pageSize); //数据转换 var data = new DataPack <ResponseInsuranceDepositLog> { TotalCount = total, List = AutoMapper.Mapper.Map <List <InsuranceDepositLog>, List <ResponseInsuranceDepositLog> >(query.ToList()) }; return(data); }
/// <summary> /// 购买保险记录 /// </summary> /// <param name="startTime"></param> /// <param name="endTime"></param> /// <param name="page"></param> /// <param name="rows"></param> /// <returns></returns> public JsonResult QueryBuyInsuranceLog(DateTime?startTime, DateTime?endTime, string insuranceDepositType, int page = 1, int rows = 10) { DataPack <ResponseInsuranceDepositLog> data = null; CommunicateManager.Invoke <IInsuranceService>(service => { var log = new RequestQueryInsuranceDepositLog(); log.IsCtrlStationCall = false; log.BuyStartTime = startTime; log.BuyEndTime = endTime; if (string.IsNullOrWhiteSpace(insuranceDepositType)) { log.InsuranceDepositType = null; } else { log.InsuranceDepositType = EnumHelper.GetInstance <EnumInsuranceDepositType>(insuranceDepositType); } data = service.QueryInsuranceDepositLog(log, page, rows); }); return(Json(data == null ? new { total = 0, rows = new List <ResponseInsuranceDepositLog>() } : new { total = data.TotalCount, rows = data.List }, JsonRequestBehavior.AllowGet)); }