/// <summary> /// 获取汇款单 /// </summary> /// <param name="arg"></param> /// <returns></returns> public Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.CustomDTO.CarInsurancePolymerizationDTO> GetCarInsuranceRebateExt(Jinher.AMP.BTP.Deploy.CustomDTO.YJBCarInsuranceRebateSearchDTO arg) { var result = new Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.CustomDTO.CarInsurancePolymerizationDTO>() { IsSuccess = true, Message = "sucess", Code = "200" }; if (arg == null) { result.IsSuccess = false; result.Message = "参数信息不正确"; result.Code = "404"; LogHelper.Error("查询车险返利信息发生错误:参数信息不正确"); } LogHelper.Debug("查询车险返利信息;查询依据" + JsonHelper.JsonSerializer(arg)); try { var query = YJBCarInsuranceRebate.ObjectSet() .GroupBy(x => new { x.RemittanceNo, x.RebateDate, x.RebateMoney, x.RebateNum }).Select(x => new CarInsurancePolymerizationDTO() { RemittanceNo = x.Key.RemittanceNo, RebateDate = x.Key.RebateDate, RebateMoney = x.Sum(o => o.RebateMoney), RebateNum = x.Sum(o => o.RebateNum.Value), AfterTaxMoney = x.Sum(o => o.RebateMoney.Value) * (decimal)1.06 }); var count = query.Count(); var Data = query.OrderByDescending(o => o.RebateDate).Skip((arg.PageIndex - 1) * arg.PageSize).Take(arg.PageSize).ToList(); return(Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.CustomDTO.CarInsurancePolymerizationDTO> .Success(count, Data)); } catch (Exception ex) { result.Code = ""; result.IsSuccess = false; result.Message = "fail"; LogHelper.Error("查询车险返利信息发生错误:参数信息:" + JsonHelper.JsonSerializer(arg), ex); } return(result); }
public Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.YJBDSFOrderInfoDTO> GetDSFOrderInfoExt(Jinher.AMP.BTP.Deploy.CustomDTO.YJBDSFOrderInfoSearchDTO arg) { var result = new Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.YJBDSFOrderInfoDTO>() { IsSuccess = true, Message = "sucess", Code = "200" }; if (arg == null) { result.IsSuccess = false; result.Message = "参数信息不正确"; result.Code = "404"; LogHelper.Error("查询第三方订单信息发生错误:参数信息不正确"); } LogHelper.Debug("查询第三方订单信息;查询依据" + JsonHelper.JsonSerializer(arg)); try { var data = YJBDSFOrderInfo.ObjectSet().ToList(); if (arg.OrderPayState == "0") { data = data.Where(o => o.OrderPayState == "待支付").ToList(); } var count = data.Count(); var Data = new BE.YJBDSFOrderInfo().ToEntityDataList(data.OrderBy(o => o.SubTime).Skip((arg.PageIndex - 1) * arg.PageSize).Take(arg.PageSize).OrderByDescending(O => O.OrderPayDate).ToList <YJBDSFOrderInfo>()); return(Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.YJBDSFOrderInfoDTO> .Success(count, Data)); } catch (Exception ex) { result.Code = ""; result.IsSuccess = false; result.Message = "fail"; LogHelper.Error("查询第三方订单信息发生错误:参数信息:" + JsonHelper.JsonSerializer(arg), ex); } return(result); }
/// <summary> /// 获取保险统计报表 /// </summary> /// <param name="arg"></param> /// <returns></returns> public Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.YJBCarInsuranceReportDTO> GetCarInsuranceReportExt(Jinher.AMP.BTP.Deploy.CustomDTO.YJBCarInsuranceReportSearchDTO arg) { var result = new Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.YJBCarInsuranceReportDTO>() { IsSuccess = true, Message = "sucess", Code = "200" }; if (arg == null) { result.IsSuccess = false; result.Message = "参数信息不正确"; result.Code = "404"; LogHelper.Error("查询车险报表信息发生错误:参数信息不正确"); } LogHelper.Debug("查询车险报表信息查询依据" + JsonHelper.JsonSerializer(arg)); try { var query = YJBCarInsuranceReport.ObjectSet(); var count = query.Count(); var Data = new BE.YJBCarInsuranceReport().ToEntityDataList(query.OrderByDescending(o => o.InsuranceTime).Skip((arg.PageIndex - 1) * arg.PageSize).Take(arg.PageSize).ToList()); return(Jinher.AMP.YJB.Deploy.CustomDTO.ListResultDTO <Jinher.AMP.BTP.Deploy.YJBCarInsuranceReportDTO> .Success(count, Data)); } catch (Exception ex) { result.Code = ""; result.IsSuccess = false; result.Message = "fail"; LogHelper.Error("查询车险报表信息发生错误:参数信息:" + JsonHelper.JsonSerializer(arg), ex); } return(result); }