/// <summary>
/// 查询统计报表
/// </summary>
/// <param name="arg"></param>
/// <returns></returns>
public ResultDTO <List <Jinher.AMP.BTP.Deploy.CustomDTO.YJBCarInsuranceReportDTO> > GetCarInsuranceReportExt(Jinher.AMP.BTP.Deploy.CustomDTO.YJBCarInsuranceReportSearchDTO arg)
{
var result = new ResultDTO <List <Jinher.AMP.BTP.Deploy.CustomDTO.YJBCarInsuranceReportDTO> >()
{
isSuccess = true,
Message = "sucess"
};
if (arg == null)
{
result.isSuccess = false;
result.Message = "参数信息不正确";
LogHelper.Error("查询车险报表信息发生错误:参数信息不正确");
}
LogHelper.Debug("查询车险报表信息查询依据" + JsonHelper.JsonSerializer(arg));
try
{
var query = from r in YJBCarInsuranceReport.ObjectSet()
join d in YJBCarInsReportDetail.ObjectSet() on r.DetailId equals d.Id
select new Jinher.AMP.BTP.Deploy.CustomDTO.YJBCarInsuranceReportDTO
{
OrderNo = r.OrderNo,
MemberPhone = r.MemberPhone,
CustomPhone = r.CustomPhone,
InsuranceAmount = r.InsuranceAmount.Value,
InsuranceTime = r.InsuranceTime,
State = r.State,
RecommendName = r.RecommendName,
RecommendAmount = SqlFunctions.StringConvert(r.RecommendAmount.Value),
CustomAmount = r.CustomAmount.Value,
SinopecAmount = r.SinopecAmount.Value,
RebateState = (CarInsuranceStateEnum)r.RebateState.Value,
StrongInsuranceAmount = d.StrongInsuranceAmount.Value,
BusinessAmount = d.BusinessAmount.Value,
StrongInsuranceOrderId = d.StrongInsuranceOrderId,
StrongInsuranceStartTime = d.StrongInsuranceStartTime,
StrongInsuranceEndTime = d.StrongInsuranceEndTime,
BusinessOrderId = d.BusinessOrderId,
BusinessStartTime = d.BusinessStartTime,
BusinessEndTime = d.BusinessEndTime,
PlateNumber = d.PlateNumber,
ChassisNumber = d.ChassisNumber,
EngineNumber = d.EngineNumber,
CarTypeName = d.CarTypeName,
RegisterTime = d.RegisterTime,
IsTransfer = d.IsTransfer,
CarOwnerName = d.CarOwnerName,
CarOwnerIdType = d.CarOwnerIdType,
CarOwnerId = d.CarOwnerId,
CarOwnerAddress = d.CarOwnerAddress,
CarOwnerPhone = d.CarOwnerPhone,
PolicyHolderName = d.PolicyHolderName,
PolicyHolderIdType = d.PolicyHolderIdType,
PolicyHolderId = d.PolicyHolderId,
PolicyHolderPhone = d.PolicyHolderPhone,
PolicyHolderAddress = d.PolicyHolderAddress,
StrongInsurance_SI = d.StrongInsurance_SI,
StrongInsurance_Car = d.StrongInsurance_Car,
Business_Car = d.Business_Car,
Business_Three = d.Business_Three,
Business_Driver = d.Business_Driver,
Business_Passenger = d.Business_Passenger,
Business_AllCar = d.Business_AllCar,
Business_Glass = d.Business_Glass,
Business_Body = d.Business_Body,
Business_Engine = d.Business_Engine,
Business_Natural = d.Business_Natural,
Business_Garage = d.Business_Garage,
Business_Third = d.Business_Third,
Business_Spirit = d.Business_Spirit,
NoDeductibles_Car = d.NoDeductibles_Car,
NoDeductibles_Three = d.NoDeductibles_Three,
NoDeductibles_Driver = d.NoDeductibles_Driver,
NoDeductibles_Passenger = d.NoDeductibles_Passenger,
NoDeductibles_AllCar = d.NoDeductibles_AllCar,
NoDeductibles_Body = d.NoDeductibles_Body,
NoDeductibles_Engine = d.NoDeductibles_Engine,
NoDeductibles_Natural = d.NoDeductibles_Natural,
NoDeductibles__Spirit = d.NoDeductibles__Spirit,
InsuranceCompanyCode = r.InsuranceCompanyCode,
SubTime = r.SubTime
};
if (arg.BeginTime != null)
{
//DateTime begintime = DateTime.Parse(arg.BeginTime);
query = query.Where(x => x.SubTime >= arg.BeginTime);
}
if (arg.EndTime != null)
{
DateTime endtime = arg.EndTime.Value.AddDays(1);
query = query.Where(x => x.SubTime < endtime);
}
if (arg.CompanyCode != null && arg.CompanyCode.Any())
{
query = query.Where(x => x.InsuranceCompanyCode != null && x.InsuranceCompanyCode != "");
query = query.Where(x => arg.CompanyCode.Contains(x.InsuranceCompanyCode));
//var ss = LinqHelper.GetEFCommandSql(query);
}
if (!string.IsNullOrEmpty(arg.Status) && arg.Status != "-1")
{
query = query.Where(x => x.State.Equals(arg.Status));
}
var count = query.Count();
var Data = query.OrderByDescending(o => o.InsuranceTime).Skip((arg.PageIndex - 1) * arg.PageSize).Take(arg.PageSize).ToList();
result.isSuccess = true;
result.ResultCode = count;
result.Data = Data;
}
catch (Exception ex)
{
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);
}
