//分类航司
public TravelReportSalePriceResponseViewModel GetTravelReport_SalePrice(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportSalePriceModel> modelList = _TravelReportServiceBll.GetTravelReportSalePrice(requestmodel);
List <TravelReportSalePriceViewModel> viewList = Mapper.Map <List <TravelReportSalePriceModel>, List <TravelReportSalePriceViewModel> >(
modelList);
if (modelList.Count > 0)
{
int manCount = 0;
for (int i = 0; i < modelList.Count; i++)
{
manCount += modelList[i].manNum;
}
for (int i = 0; i < viewList.Count; i++)
{
double percent = Convert.ToDouble(modelList[i].manNum) / Convert.ToDouble(manCount);
decimal result = Convert.ToDecimal((percent * 100).ToString("0.00"));
viewList[i].salePercentage = result;
}
}
return(new TravelReportSalePriceResponseViewModel()
{
TravelReportSalePriceList = viewList
});
}
//预定提前天数占比
public TravelReportReserveDayResponseViewModel GetTravelReport_ReserveDay(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportReserveDayModel> modelList = _TravelReportServiceBll.GetTravelReportReserveDay(requestmodel);
List <TravelReportReserveDayViewModel> viewList = Mapper.Map <List <TravelReportReserveDayModel>, List <TravelReportReserveDayViewModel> >(
modelList);
if (modelList.Count > 0)
{
int manCount = 0;
decimal salepriceCount = 0;
for (int i = 0; i < modelList.Count; i++)
{
manCount += modelList[i].manNum;
salepriceCount = modelList[i].SalePriceSum;
}
for (int i = 0; i < viewList.Count; i++)
{
double percent = Convert.ToDouble(modelList[i].manNum) / Convert.ToDouble(manCount);
decimal result = Convert.ToDecimal((percent * 100).ToString("0.00"));
double saleprice = Convert.ToDouble(modelList[i].SalePriceSum) / Convert.ToDouble(salepriceCount);
decimal result1 = Convert.ToDecimal((saleprice * 100).ToString("0.00"));
viewList[i].ManPercentage = result;
viewList[i].moneyPercentage = result1;
}
}
return(new TravelReportReserveDayResponseViewModel()
{
TravelReportReserveDayList = viewList
});
}
//改签
public TravelReportFltRefundFltModResponseViewModel GetTravelReport_FltMod(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(request);
List <TravelReportFltRefundFltModModel> modelList = _TravelReportServiceBll.GetTravelReportFltMod(requestmodel);
List <TravelReportFltRefundFltModViewModel> viewList = Mapper.Map <List <TravelReportFltRefundFltModModel>, List <TravelReportFltRefundFltModViewModel> >(
modelList).ToList();
return(new TravelReportFltRefundFltModResponseViewModel()
{
TravelReportFltRefundFltModList = viewList
});
}
///
///年享受航司协议节省金额 Table显示
///
public List <T> GetTravelReport_AirConsumeCountTable <T>(TravelReportRequestDoModel Remodel) where T : class
{
List <T> tList =
base.ExcuteQueryBySql <T>(
@"EXEC Sp1_TravelReport_AirConsumeCountTable @TheYear,@corpid,@SourceType",
new SqlParameter("@TheYear", Remodel.TheYear),
new SqlParameter("@corpid", Remodel.Corpid),
new SqlParameter("@SourceType", Remodel.SourceType)
).ToList();
return(tList);
}
///
///预定提前天数占比
///
public List <T> GetTravelReport_ReserveDay <T>(TravelReportRequestDoModel Remodel) where T : class
{
List <T> tList =
base.ExcuteQueryBySql <T>(
@"EXEC Sp1_TravelReport_ReserveDay @startMonth,@endMonth,@corpid,@SourceType",
new SqlParameter("@startMonth", Remodel.StartMonth),
new SqlParameter("@endMonth", Remodel.EndMonth),
new SqlParameter("@corpid", Remodel.Corpid),
new SqlParameter("@SourceType", Remodel.SourceType)
).ToList();
return(tList);
}
//汇总页面
public TravelReportConsumeCountResponseViewModel GetTravelReport_ConsumeCount(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportConsumeCountModel> modelList = _TravelReportServiceBll.GetTravelReportConsumeCount(requestmodel);
List <TravelReportConsumeCountViewModel> viewList = Mapper.Map <List <TravelReportConsumeCountModel>, List <TravelReportConsumeCountViewModel> >(
modelList).ToList();
return(new TravelReportConsumeCountResponseViewModel()
{
TravelReportConsumeCountList = viewList
});
}
//前10位人员出差人次汇总表
public TravelReportPassengerTopResponseViewModel GetTravelReport_PassengerTop(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportPassengerTopModel> modelList = _TravelReportServiceBll.GetTravelReportPassengerTop(requestmodel);
List <TravelReportPassengerTopViewModel> viewList = Mapper.Map <List <TravelReportPassengerTopModel>, List <TravelReportPassengerTopViewModel> >(
modelList).Take(10).OrderByDescending(x => x.manNum).ToList();
return(new TravelReportPassengerTopResponseViewModel()
{
TravelReportPassengerTopList = viewList
});
}
//成本中心汇总表
public TravelReportCostCenterResponseViewModel GetTravelReport_CostCenter(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportCostCenterModel> modelList = _TravelReportServiceBll.GetTravelReportCostCenter(requestmodel);
List <TravelReportCostCenterViewModel> viewList = Mapper.Map <List <TravelReportCostCenterModel>, List <TravelReportCostCenterViewModel> >(
modelList).OrderByDescending(x => x.SalePriceSum).Take(6).ToList();;
return(new TravelReportCostCenterResponseViewModel()
{
TravelReportCostCenterList = viewList
});
}
//前10条出差航段汇总表
public TravelReportDportCityResponseViewModel GetTravelReport_DportCity(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportDportCityModel> modelList = _TravelReportServiceBll.GetTravelReportDportCity(requestmodel);
List <TravelReportDportCityViewModel> viewList = Mapper.Map <List <TravelReportDportCityModel>, List <TravelReportDportCityViewModel> >(
modelList).Take(10).ToList();
return(new TravelReportDportCityResponseViewModel()
{
TravelReportDportCityList = viewList
});
}
/// <summary>
/// 求改签金额
/// </summary>
/// <typeparam name="T"></typeparam>
/// <param name="yearval"></param>
/// <param name="corpId"></param>
/// <returns></returns> where (TheMonth>=@startMonth and TheMonth<=@endMonth) and corpid=@corpid and SourceType = @SourceType
public List <T> GetTravelReportFltMod <T>(TravelReportRequestDoModel Remodel) where T : class
{
List <T> tList =
base.ExcuteQueryBySql <T>(
@"select top 10
CostCenter
,sum(ModPrice) PriceSum --改签金额
from TravelReport_FltModSource
where (TheMonth>=@startMonth and TheMonth<=@endMonth) and corpid=@corpid and SourceType = @SourceType
and CostCenter IS NOT NULL
group by CostCenter
order by sum(ModPrice) desc",
new SqlParameter("@startMonth", Remodel.StartMonth),
new SqlParameter("@endMonth", Remodel.EndMonth),
new SqlParameter("@corpid", Remodel.Corpid),
new SqlParameter("@SourceType", Remodel.SourceType)
).ToList();
return(tList);
}
//全航司折扣舱位
public List <TravelReportAllSalePriceModel> GetTravelReportAllSalePrice(TravelReportRequestDoModel Remodel)
{
List <TravelReportAllSalePriceModel> list = _travelReportAirlineCountDal.GetTravelReport_AllSalePrice <TravelReportAllSalePriceModel>(Remodel);
return(list);
}
//成本中心汇总表
public List <TravelReportCostCenterModel> GetTravelReportCostCenter(TravelReportRequestDoModel Remodel)
{
List <TravelReportCostCenterModel> list = _travelReportAirlineCountDal.GetTravelReport_CostCenter <TravelReportCostCenterModel>(Remodel);
return(list);
}
//航空公司占比分析
public TravelReportAirlineCountResponseViewModel GetTravelReport_AirlineCount(TravelReportRequestUIModel request)
{
TravelReportRequestDoModel requestmodel = Mapper.Map <TravelReportRequestUIModel, TravelReportRequestDoModel>(
request);
List <TravelReportAirlineCountModel> modelListTemp = _TravelReportServiceBll.GetTravelReportAirlineCount(requestmodel);
List <string> airlineNoList = modelListTemp.Select(n => n.AirlineNo).Distinct().ToList();
List <TravelReportAirlineCountModel> modelList = new List <TravelReportAirlineCountModel>();
//合并重复的航段
decimal s = 0;
int m = 0;
TravelReportAirlineCountModel other = null;
foreach (string airlineNo in airlineNoList)
{
if (airlineNo != "其它航空")
{
var model = modelListTemp.Find(n => n.AirlineNo == airlineNo);
if (model == null)
{
continue;
}
modelList.Add(model);
}
else
{
List <TravelReportAirlineCountModel> model = modelListTemp.FindAll(n => n.AirlineNo == airlineNo);
if (model != null && model.Count > 0)
{
s = model.Sum(n => n.SalePriceSum);
m = model.Sum(n => n.manNum);
if (other == null)
{
other = model[0];
}
}
}
}
if (other != null)
{
other.manNum = m;
other.SalePriceSum = s;
modelList.Add(other);
}
List <TravelReportAirlineCountViewModel> viewList = Mapper.Map <List <TravelReportAirlineCountModel>, List <TravelReportAirlineCountViewModel> >(
modelList);
if (modelList.Count > 0)
{
int manCount = 0;
for (int i = 0; i < modelList.Count; i++)
{
manCount += modelList[i].manNum;
}
for (int i = 0; i < viewList.Count; i++)
{
double percent = Convert.ToDouble(modelList[i].manNum) / Convert.ToDouble(manCount);
decimal result = Convert.ToDecimal((percent * 100).ToString("0.00"));
viewList[i].ManPercentage = result;
}
}
return(new TravelReportAirlineCountResponseViewModel()
{
TravelReportAirlineCountList = viewList
});
}
//改签数量
public List <TravelReportFltRefundFltModModel> GetTravelReportFltMod(TravelReportRequestDoModel Remodel)
{
List <TravelReportFltRefundFltModModel> list = _travelReportAirlineCountDal.GetTravelReportFltMod <TravelReportFltRefundFltModModel>(Remodel);
return(list);
}
//预定提前天数占比
public List <TravelReportReserveDayModel> GetTravelReportReserveDay(TravelReportRequestDoModel Remodel)
{
List <TravelReportReserveDayModel> list = _travelReportAirlineCountDal.GetTravelReport_ReserveDay <TravelReportReserveDayModel>(Remodel);
return(list);
}
//前10条出差航段汇总表
public List <TravelReportDportCityModel> GetTravelReportDportCity(TravelReportRequestDoModel Remodel)
{
List <TravelReportDportCityModel> list = _travelReportAirlineCountDal.GetTravelReport_DportCity <TravelReportDportCityModel>(Remodel);
return(list);
}
//前10位人员出差人次汇总表
public List <TravelReportPassengerTopModel> GetTravelReportPassengerTop(TravelReportRequestDoModel Remodel)
{
List <TravelReportPassengerTopModel> list = _travelReportAirlineCountDal.GetTravelReport_PassengerTop <TravelReportPassengerTopModel>(Remodel);
return(list);
}
//汇总页面
public List <TravelReportConsumeCountModel> GetTravelReportConsumeCount(TravelReportRequestDoModel Remodel)
{
List <TravelReportConsumeCountModel> list = _travelReportAirlineCountDal.GetTravelReport_ConsumeCount <TravelReportConsumeCountModel>(Remodel);
return(list);
}
