1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071727374757677787980818283848586878889909192939495969798991001011021031041051061071081091101111121131141151161171181191201211221231241251261271281291301311321331341351361371381391401411421431441451461471481491501511521531541551561571581591601611621631641651661671681691701711721731741751761771781791801811821831841851861871881891901911921931941951961971981992002012022032042052062072082092102112122132142152162172182192202212222232242252262272282292302312322332342352362372382392402412422432442452462472482492502512522532542552562572582592602612622632642652662672682692702712722732742752762772782792802812822832842852862872882892902912922932942952962972982993003013023033043053063073083093103113123133143153163173183193203213223233243253263273283293303313323333343353363373383393403413423433443453463473483493503513523533543553563573583593603613623633643653663673683693703713723733743753763773783793803813823833843853863873883893903913923933943953963973983994004014024034044054064074084094104114124134144154164174184194204214224234244254264274284294304314324334344354364374384394404414424434444454464474484494504514524534544554564574584594604614624634644654664674684694704714724734744754764774784794804814824834844854864874884894904914924934944954964974984995005015025035045055065075085095105115125135145155165175185195205215225235245255265275285295305315325335345355365375385395405415425435445455465475485495505515525535545555565575585595605615625635645655665675685695705715725735745755765775785795805815825835845855865875885895905915925935945955965975985996006016026036046056066076086096106116126136146156166176186196206216226236246256266276286296306316326336346356366376386396406416426436446456466476486496506516526536546556566576586596606616626636646656666676686696706716726736746756766776786796806816826836846856866876886896906916926936946956966976986997007017027037047057067077087097107117127137147157167177187197207217227237247257267277287297307317327337347357367377387397407417427437447457467477487497507517527537547557567577587597607617627637647657667677687697707717727737747757767777787797807817827837847857867877887897907917927937947957967977987998008018028038048058068078088098108118128138148158168178188198208218228238248258268278288298308318328338348358368378388398408418428438448458468478488498508518528538548558568578588598608618628638648658668678688698708718728738748758768778788798808818828838848858868878888898908918928938948958968978988999009019029039049059069079089099109119129139149159169179189199209219229239249259269279289299309319329339349359369379389399409419429439449459469479489499509519529539549559569579589599609619629639649659669679689699709719729739749759769779789799809819829839849859869879889899909919929939949959969979989991000100110021003100410051006100710081009101010111012101310141015101610171018101910201021102210231024102510261027102810291030103110321033103410351036103710381039104010411042104310441045104610471048104910501051105210531054105510561057105810591060106110621063106410651066106710681069107010711072107310741075107610771078107910801081108210831084108510861087108810891090109110921093109410951096109710981099110011011102110311041105110611071108110911101111111211131114111511161117111811191120112111221123112411251126112711281129113011311132113311341135113611371138113911401141114211431144114511461147114811491150115111521153115411551156115711581159116011611162116311641165116611671168116911701171117211731174117511761177117811791180118111821183118411851186118711881189119011911192119311941195119611971198119912001201120212031204120512061207120812091210121112121213121412151216121712181219122012211222122312241225122612271228122912301231123212331234123512361237123812391240124112421243124412451246124712481249125012511252125312541255125612571258125912601261126212631264126512661267126812691270127112721273127412751276127712781279128012811282128312841285128612871288128912901291129212931294129512961297129812991300130113021303130413051306130713081309131013111312131313141315131613171318131913201321132213231324132513261327132813291330133113321333133413351336 |
- using Dm;
- using Npgsql.Replication.PgOutput;
- using OASystem.Domain.Entities.Financial;
- using OASystem.Domain.ViewModels.System;
- using System;
- using System.Collections.Generic;
- using System.Globalization;
- using System.Linq;
- using System.Text;
- using System.Threading.Tasks;
- using System.Xml.Linq;
- namespace OASystem.Domain.ViewModels.Financial
- {
-
-
-
- public class Fin_DailyFeePaymentView : Fin_DailyFeePayment
- { }
- public class Fin_DailyFeePaymentPageCount
- {
-
-
-
- public int Count { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentPageListView
- {
-
-
-
- public bool IsChecked { get; set; }
-
-
-
- public int RowNumber { get; set; }
-
-
-
- public int Id { get; set; }
-
-
-
- public int CompanyId { get; set; }
-
-
-
- public string? CompanyName { get; set; }
-
-
-
- public string? Instructions { get; set; }
-
-
-
- public decimal? SumPrice { get; set; }
-
-
-
- public int CreateUserId { get; set; }
-
-
-
- public string? CreateUser { get; set; }
-
-
-
- public DateTime CreateTime { get; set; }
-
-
-
- public int FAudit { get; set; }
-
-
-
- public string? FAuditDesc
- {
- get
- {
- string str = "未审核";
- if (FAudit == 0) str = "未审核";
- else if (FAudit == 1)
- {
- str = "已通过";
- FAuditName = "朱成梅";
- }
- else if (FAudit == 2)
- {
- str = "未通过";
- FAuditName = "朱成梅";
- }
- return str;
- }
- }
-
-
-
- public string? FAuditName { get; set; } = "无";
-
-
-
- public int MAudit { get; set; }
-
-
-
- public string? MAuditDesc
- {
- get
- {
- string str = "未审核";
- if (MAudit == 0) str = "未审核";
- else if (MAudit == 1) { str = "已通过"; MAuditName = "张海麟"; }
- else if (MAudit == 2) { str = "未通过"; MAuditName = "张海麟"; }
- return str;
- }
- }
-
-
-
- public string? MAuditName { get; set; } = "无";
-
-
-
- public int PriceTypeId { get; set; }
-
-
-
- public int IsPay { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentPage
- {
-
-
-
- public int? Rows { get; set; }
- public List<Fin_DailyFeePaymentPageListView> Data { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentContentInfolView
- {
- public int Id { get; set; }
-
-
-
- public string PriceName { get; set; }
-
-
-
- public decimal Quantity { get; set; }
-
-
-
- public decimal Price { get; set; }
-
-
-
- public decimal ItemTotal { get; set; }
-
-
-
- public string Remark { get; set; }
-
-
-
- public string RemaksDescription { get; set; }
-
-
-
- public string ExcelRemaksDescription { get; set; }
- }
- public class Fin_DailyFeePaymentInfolView
- {
- public int Id { get; set; }
- public int CompanyId { get; set; }
- public int TransferTypeId { get; set; }
- public int PriceTypeId { get; set; }
- public string Instructions { get; set; }
- public decimal SumPrice { get; set; }
- public int CreateUserId { get; set; }
-
-
-
- public int FAudit { get; set; }
- public string FAuditDesc
- {
- get
- {
- string str = "未审核";
- if (FAudit == 0) str = "未审核";
- else if (FAudit == 1) str = "已通过";
- else if (FAudit == 2) str = "未通过";
- return str;
- }
- }
-
-
-
- public int MAudit { get; set; }
- public string MAuditDesc
- {
- get
- {
- string str = "未审核";
- if (MAudit == 0) str = "未审核";
- else if (MAudit == 1) str = "已通过";
- else if (MAudit == 2) str = "未通过";
- return str;
- }
- }
- public DateTime CreateTime { get; set; }
- public List<Fin_DailyFeePaymentContentInfolView> FeeContents { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentInfoAndroidlView
- {
- public int Id { get; set; }
- public int CompanyId { get; set; }
- public int TransferTypeId { get; set; }
- public int PriceTypeId { get; set; }
- public string Instructions { get; set; }
- public decimal SumPrice { get; set; }
- public int CreateUserId { get; set; }
- public List<Fin_DailyFeePaymentContentInfolView> FeeContents { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentPagePriceTypeView
- {
-
-
-
- public int Id { get; set; }
-
-
-
- public string Name { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentPagePriceSubTypeView
- {
-
-
-
- public int STid { get; set; }
-
-
-
- public int Id { get; set; }
-
-
-
- public string Name { get; set; }
- }
-
-
-
- public class Fin_DailyFeePaymentPagePriceTypeDataView
- {
-
-
-
- public List<Fin_DailyFeePaymentPagePriceTypeView>? FeeTypeData { get; set; }
-
-
-
- public List<Fin_DailyFeePaymentPagePriceSubTypeView>? FeeSubTypeData { get; set; }
-
-
-
- public List<UserNameView>? UserNameData { get; set; }
-
-
-
- public List<Fin_DailyFeePaymentPagePriceTypeView>? FeeMarkTypeData { get; set; }
-
-
-
- public List<Fin_DailyFeePaymentPagePriceSubTypeView>? FeeMarkSubTypeData { get; set; }
-
-
-
- public List<CompanyNameView>? CompanyNameData { get; set; }
- }
-
-
-
- public class DailyFeePaymentDataSourceView : Fin_DailyFeePaymentPagePriceTypeView
- {
- public List<Fin_DailyFeePaymentPagePriceSubTypeView> SubDatas { get; set; }
- }
- public class tree_Fin_DailyFeePaymentPageListView : Fin_DailyFeePaymentPageListView
- {
- public List<Fin_DailyFeePaymentContentInfolView> childList { get; set; }
- public string priceTypeStr { get; set; }
- public int transferTypeId { get; set; }
- public string transferTypeIdStr { get; set; }
-
-
-
- public int transferParentId { get; set; }
- public string transferParentIdStr { get; set; }
- }
- public class tree_Fin_DailyFeePaymentResult : tree_Fin_DailyFeePaymentPageListView
- {
- public decimal gz { get; set; } = 0M;
- public decimal sz { get; set; } = 0M;
- public List<tree_Fin_DailyFeePaymentPageListView> dataList { get; set; }
- }
-
-
-
- public class tree_Group_DailyFeePaymentResult
- {
- public decimal gz { get; set; } = 0M;
- public decimal sz { get; set; } = 0M;
- public List<tree_Group_DailyFeePaymentPageListView> dataList { get; set; }
- }
-
-
-
- public class tree_Group_DailyFeePaymentPageListView
- {
- public string Id { get; set; }
- public string GroupName { get; set; }
-
-
-
- public int CompanyId { get; set; }
-
-
-
- public string ConpanyName { get; set; }
-
-
-
- public decimal CNYTotalAmount { get; set; }
- public List<Group_DailyFeePaymentContentInfolView> ChildList { get; set; }
- }
- public class CompanyInfo
- {
- public int Id { get; set; }
- public string ConpanyName { get; set; }
- }
- public class Group_DailyFeePaymentContentInfolView
- {
-
-
-
- public bool IsChecked { get; set; }
- public int Id { get; set; }
-
-
-
- public int HotelSubId { get; set; } = -1;
-
-
-
- public string PayType { get; set; }
-
-
-
- public string TransferMark { get; set; }
-
-
-
- public int RowNumber { get; set; }
-
-
-
- public string Applicant { get; set; }
-
-
-
- public string ApplicantDt { get; set; }
-
-
-
- public string Payee { get; set; }
-
-
-
- public string PriceName { get; set; }
-
-
-
- public string ModuleName { get; set; }
-
-
-
- public string PayCurrCode { get; set; }
-
-
-
- public decimal PaymentAmount { get; set; }
-
-
-
- public decimal PayRate { get; set; }
-
-
-
- public decimal CNYSubTotalAmount { get; set; }
-
-
-
- public string RemaksDescription { get; set; }
-
-
-
-
- public int AuditStatus { get; set; }
- }
- public class PaymentRequestCheckedView
- {
- public List<int> GroupIds { get; set; }
- public List<int> DailyPaymentIds { get; set; }
- public List<int> HotelSubIds { get; set; }
- }
- #region 日付报表
- [SqlSugar.SugarTable("Fin_DailyFeePayment")]
- public class DailyFeePaymentRangeView
- {
-
-
-
-
-
-
-
- public string ViewStr
- {
- get
- {
- return $"【{CompanyName}】【{TransferType}】【{FeeType}】【{Instructions}】【{SumPrice.ToString("#0.00")}】【申请人:{Applicant} 申请时间:{ApplicantDt.ToString("yyyy-MM-dd HH:mm:ss")}】";
- }
- }
- [SugarColumn(IsIgnore = true)]
- public int RowIndex { get; set; }
- [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
- public int Id { get; set; }
- public string Instructions { get; set; }
- public int PriceTypeId { get; set; }
- public string FeeType { get; set; }
- public int TransferTypeId { get; set; }
- public string TransferType { get; set; }
- public decimal SumPrice { get; set; }
- public DateTime FAuditDate { get; set; }
- public DateTime MAuditDate { get; set; }
- public int CompanyId { get; set; }
- public string CompanyName { get; set; }
- public int ApplicantId { get; set; }
- public string Applicant { get; set; }
- public DateTime ApplicantDt { get; set; }
- [Navigate(NavigateType.OneToMany, nameof(DailyFeePaymentContentView.DFPId))]
- public List<DailyFeePaymentContentView> Contents { get; set; }
-
- }
- [SqlSugar.SugarTable("Fin_DailyFeePaymentContent")]
- public class DailyFeePaymentContentView
- {
-
-
- [SugarColumn(IsPrimaryKey = true, IsIdentity = true)]
- public int Id { get; set; }
- public int DFPId { get; set; }
- public string PriceName { get; set; }
- public int Quantity { get; set; }
- public decimal Price { get; set; }
- public decimal ItemTotal { get; set; }
- public string Remark { get; set; }
-
-
-
-
-
-
-
-
-
-
-
-
- }
- public class ExcelView : DailyFeePaymentRangeView
- {
- public string ContentStr { get; set; }
- }
- #endregion
- #region 统计模块
- #region YOY
- public class StatisticsYOYView
- {
- public int Id { get; set; }
- public DateTime VisitDate { get; set; }
- public int Year { get; set; }
- public int Month { get; set; }
-
-
-
- public decimal SaleAmount { get; set; }
-
-
-
- public decimal AirTicketAmount { get; set; }
-
-
-
- public decimal OPAmount { get; set; }
-
-
-
- public decimal OtherCostAmount { get; set; }
-
-
-
- public decimal VisaAmount { get; set; }
-
-
-
- public decimal OAAmount { get; set; }
-
-
-
- public decimal InsureAmount { get; set; }
-
-
-
- public decimal HotelAmount { get; set; }
-
-
-
- public decimal ExcessAmount { get; set; }
-
-
-
- public decimal SKTHAmount { get; set; }
-
-
-
- public decimal CostAmount
- {
- get
- {
- return AirTicketAmount + HotelAmount + InsureAmount + OAAmount + VisaAmount + OtherCostAmount + OPAmount + ExcessAmount;
- }
- }
-
-
-
- public decimal GrossProfitAmount
- {
- get
- {
- return SaleAmount - SKTHAmount - CostAmount;
- }
- }
- }
- public class YOYReturnView
- {
- public int Year { get; set; }
- public int Month { get; set; }
- public decimal ThisAmount { get; set; }
- public decimal LastAmount { get; set; }
- public string Yoy { get; set; }
- public List<int> ThisIds { get; set; }
- public List<int> LastIds { get; set; }
-
-
-
-
-
-
-
-
-
- public YOYReturnView(int year, int month, decimal thisAmount, decimal lastAmount, List<int> thisIds, List<int> lastIds)
- {
- this.Year = year;
- this.Month = month;
- this.ThisAmount = thisAmount;
- this.LastAmount = lastAmount;
- string _yoy = "0.00%";
- if (lastAmount != 0)
- {
- _yoy = ((thisAmount - lastAmount) / lastAmount).ToString("#0.00") + "%";
- }
- this.Yoy = _yoy;
- this.ThisIds = thisIds;
- this.LastIds = lastIds;
- }
- }
- #endregion
- #region 国交数据统计 - 机票
- public class StatisticsAirTicketView
- {
- public int DIId { get; set; }
- public DmDateTime FlightsDate { get; set; }
- public int Year { get; set; }
- public int Month { get; set; }
- public int CType { get; set; }
- public string CTypeName { get; set; }
- public string FlightsCity { get; set; }
- public string FlightsCityName { get; set; }
- public int ClientNum { get; set; }
- }
- public class AirTicketReturnView
- {
- public int Year { get; set; }
- public int Month { get; set; }
-
-
-
- public int Quantity { get; set; }
- public List<AitTicketInfo> AitTicketInfos { get; set; }
- public List<int> LinkGroupIds { get; set; }
-
-
-
-
-
-
-
- public AirTicketReturnView(int year, int month, int quantity, List<AitTicketInfo> aitTicketInfos, List<int> linkGroupIds)
- {
- this.Year = year;
- this.Month = month;
- this.Quantity = quantity;
- this.AitTicketInfos = aitTicketInfos;
- this.LinkGroupIds = linkGroupIds;
- }
-
-
-
-
-
-
-
- public AirTicketReturnView(int year, int month, int quantity, List<int> linkGroupIds)
- {
- this.Year = year;
- this.Month = month;
- this.Quantity = quantity;
- this.LinkGroupIds = linkGroupIds;
- }
- }
- public class AirTicketCityReturnView : AirTicketReturnView
- {
- public List<AirTicketCityInfo> CityData { get; set; }
-
-
-
-
-
-
-
- public AirTicketCityReturnView(int year, int month, int quantity, List<AirTicketCityInfo> cityData, List<int> linkGroupIds)
- : base(year, month, quantity, linkGroupIds)
- {
- this.Year = year;
- this.Month = month;
- this.Quantity = quantity;
- this.CityData = cityData;
- this.LinkGroupIds = linkGroupIds;
- }
- }
- public class AitTicketInfo
- {
- public int Id { get; set; }
- public string GroupName { get; set; }
- public int Quantity { get; set; }
- public AitTicketInfo(int id, string groupName, int quantity)
- {
- this.Id = id;
- this.GroupName = groupName;
- this.Quantity = quantity;
- }
- }
- public class AirTicketCityInfo
- {
- public string City { get; set; }
- public int Quantity { get; set; }
- public AirTicketCityInfo(string city, int quantity = 0)
- {
- City = city;
- Quantity = quantity;
- }
- }
- #endregion
- #region 酒店
- public class StatisticsHotelView
- {
- public int DIId { get; set; }
- public string City { get; set; }
- public string CityStr
- {
- get
- {
- return City.Replace(" ", "").ToUpper();
- }
- }
- public string HotelName { get; set; }
- public string BookinSite { get; set; }
- public string CheckInDate { get; set; }
-
-
- public string CheckOutDate { get; set; }
- public int SingleRoomCount { get; set; }
- public int DoubleRoomCount { get; set; }
- public int SuiteRoomCount { get; set; }
- public int OtherRoomCount { get; set; }
- public int RoomNights
- {
- get
- {
- int nights = 0;
- if (!string.IsNullOrEmpty(CheckInDate) && !string.IsNullOrEmpty(CheckOutDate))
- {
- DateTime checkin, checkout;
- bool checkInBool = DateTime.TryParse(CheckInDate, out checkin);
- bool checkOutBool = DateTime.TryParse(CheckOutDate, out checkout);
- if (checkInBool && checkOutBool)
- {
- nights = (checkout - checkin).Days * RoomTotal;
- }
- }
- return nights;
- }
- }
- public int RoomTotal
- {
- get
- {
- return SingleRoomCount + DoubleRoomCount + SuiteRoomCount + OtherRoomCount;
- }
- }
- public StatisticsHotelView() { }
- public StatisticsHotelView(int diid, string city, string hotelName, string bookingSite, string checkIn, string checkOut, int singleRoom, int doubleRoomCount, int suiteRoomCount, int otherRoomCount)
- {
- DIId = diid;
- City = city;
- BookinSite = bookingSite;
- CheckInDate = checkIn;
- CheckOutDate = checkOut;
- SingleRoomCount = singleRoom;
- DoubleRoomCount = doubleRoomCount;
- SuiteRoomCount = suiteRoomCount;
- OtherRoomCount = otherRoomCount;
- }
- }
- public class HotelReturnView
- {
- }
- #endregion
- #region 商邀邀请
- public class StatisticsInvitation
- {
- public int DIId { get; set; }
- public string Country { get; set; }
- }
- #endregion
- #region 团组相关
- public class StatisticsGroupInfoEntity
- {
- public int Id { get; set; }
- public DateTime VisitDate { get; set; }
- public int Month { get; set; }
- public string MonthName { get { return VisitDate.ToString("MMM", CultureInfo.GetCultureInfo("zh-CN")); } }
- public int Quarter
- {
- get
- {
- int quarter = 0;
- if (Month < 1 || Month > 12) return quarter;
- if (Month >= 1 && Month <= 3) quarter = 1;
- else if (Month >= 4 && Month <= 6) quarter = 2;
- else if (Month >= 7 && Month <= 9) quarter = 3;
- else if (Month >= 10 && Month <= 12) quarter = 4;
- return quarter;
- }
- }
- public string QuarterName
- {
- get
- {
- string quarterName = "-";
- if (Month < 1 || Month > 12) return quarterName;
- if (Month >= 1 && Month <= 3) quarterName = "第一季度";
- else if (Month >= 4 && Month <= 6) quarterName = "第二季度";
- else if (Month >= 7 && Month <= 9) quarterName = "第三季度";
- else if (Month >= 10 && Month <= 12) quarterName = "第四季度";
- return quarterName;
- }
- }
- public int VisitPNumber { get; set; }
- }
- #endregion
- #region OP
- public class StatisticsOP
- {
-
-
- private static int[] _carFeeIds = new int[] {
- 91,
- 982,
- };
-
- private static int[] _guideFeeIds = new int[] {
- 92,
- 985,
- 1059,
- };
-
- private static int[] _driverFeeIds = new int[]{
- 979,
- };
-
- private static int[] _tipsFeeIds = new int[] {
- 980,
- 95,
- };
-
- private static int[] _airportTransferFeeIds = new int[] {
- 96,
- };
-
- private static int[] _mealFeeIds = new[] {
- 93,
- 981,
- 983,
- 988,
- 989,
- 1074,
- 1075,
- 1076,
- };
-
- private static int[] _sububoFeeIds = new[] {
- 992,
- 984,
- };
-
- private static int[] _scenicSpotFeeIds = new[] {
- 94,
- 990,
- 1085,
- };
-
- private static int[] _translationFeeIds = new[] {
- 994,
- 1073,
- };
-
- private static int[] _DSFFeeIds = new int[] {
- 991,
- };
-
- private static int[] _otherFeeIds = new int[] {
- 97,
- 1071,
- };
- public int Id { get; set; }
- public int DiId { get; set; }
- public DateTime PaymentTime { get; set; }
- public int Year { get; set; }
- public int Quarter { get; set; }
- public int Month { get; set; }
- public string Area { get; set; }
- public string Country { get; set; }
- public string City { get; set; }
- public int ParentFeeId {
- get
- {
- return int.TryParse(GetFeeParentInfo(FeeSubType, 1), out int id) ? id : 0;
- }
- }
- public string ParentFeeName
- {
- get
- {
- return GetFeeParentInfo(FeeSubType, 2);
- }
- }
- public string ParentFeeRemark { get; set; }
- public int FeeType { get; set; }
- public string FeeTypeName { get; set; }
- public int FeeSubType { get; set; }
- public string FeeSubTypeName { get; set; }
- public decimal Price { get; set; }
-
-
-
-
-
-
- private static string GetFeeParentInfo(int subFee,int type)
- {
- int id = -1;
- string name =string.Empty;
- string remark = string.Empty;
-
- if (_carFeeIds.Contains(subFee))
- {
- id = 1;
- name = "车费";
- remark = "费用组成:车费、车超时费";
- }
-
- if (_guideFeeIds.Contains(subFee))
- {
- id = 2;
- remark = "费用组成:导游费、导游交通、导游超时费用";
- name = "导游费";
- }
-
- if (_driverFeeIds.Contains(subFee))
- {
- id = 3;
- remark = "费用组成:司机工资";
- name = "司机费";
- }
-
- if (_tipsFeeIds.Contains(subFee))
- {
- id = 4;
- remark = "费用组成:司机小费、导游小费";
- name = "小费";
- }
-
- if (_airportTransferFeeIds.Contains(subFee))
- {
- id = 5;
- remark = "费用组成:接送机费";
- name = "接送机费";
- }
-
-
- if (_mealFeeIds.Contains(subFee))
- {
- id = 6;
- remark = "费用组成:客户早餐费用、客户午餐费用、客户晚餐费用、司机餐补、导游餐补、早餐超支费用、午餐超支费用、晚餐超支费用";
- name = "餐费";
- }
-
- if (_sububoFeeIds.Contains(subFee))
- {
- id = 7;
- remark = "费用组成:住补费用、导游房补";
- name = "住补费";
- }
-
- if (_scenicSpotFeeIds.Contains(subFee))
- {
- id = 8;
- remark = "费用组成:导游景点费、景点门票费、景点门票超支费用";
- name = "景点费";
- }
-
- if (_translationFeeIds.Contains(subFee))
- {
- id = 9;
- remark = "费用组成:翻译费、翻译超时费";
- name = "翻译费";
- }
-
- if (_DSFFeeIds.Contains(subFee))
- {
- id = 10;
- remark = "费用组成:饮料/零食/水果费";
- name = "饮料/零食/水果费";
- }
-
- if (_otherFeeIds.Contains(subFee))
- {
- id = 11;
- remark = "费用组成:其他费用、其他额外费用";
- name = "其他费用";
- }
- string returnStr = string.Empty;
- if (type == 1) returnStr = id.ToString();
- else if (type == 2) returnStr = name;
- else if (type == 3) returnStr = remark;
- return returnStr;
- }
- }
-
- public class StatisticsOPYOY
- {
- public int FeeId { get; set; }
- public string FeeName { get; set; }
-
-
-
- public decimal CurrPeriodFee { get; set; }
-
-
-
- public decimal SamePeriodFee { get; set; }
- public decimal Yoy { get; set; }
- public int CurrPeriodGroupTotal { get; set; }
- public int SamePeriodGroupTotal { get; set; }
- public StatisticsOPSubFeeYOY[] SubFeeData { get; set; }
- public StatisticsOPYOY() { }
-
-
-
-
-
-
-
-
-
- public StatisticsOPYOY(int feeId, string feeName, decimal currPeriodFee, decimal samePeriodFee,
- int currPeriodGroupTotal ,int samePeriodGroupTotal, StatisticsOPSubFeeYOY[] subFeeData)
- {
- this.FeeId = feeId;
- this.FeeName = feeName;
- this.CurrPeriodFee = currPeriodFee;
- this.SamePeriodFee = samePeriodFee;
- decimal _yoy = 0.00M;
- if (samePeriodFee != 0.00M)
- {
- _yoy = (currPeriodFee - samePeriodFee) / samePeriodFee;
- }
- this.Yoy = decimal.Parse(_yoy.ToString("0.##"));
- this.CurrPeriodGroupTotal = currPeriodGroupTotal;
- this.SamePeriodGroupTotal = samePeriodGroupTotal;
- this.SubFeeData = subFeeData;
- }
- }
- public class StatisticsOPSubFeeYOY : StatisticsOPYOY
- {
- public StatisticsOPCityYOY[] CityData { get; set; }
- public StatisticsOPSubFeeYOY() { }
-
-
-
-
-
-
-
-
-
- public StatisticsOPSubFeeYOY(int feeId, string feeName, decimal currPeriodFee, decimal samePeriodFee,
- int currPeriodGroupTotal, int samePeriodGroupTotal, StatisticsOPCityYOY[] cityData)
- {
- this.FeeId = feeId;
- this.FeeName = feeName;
- this.CurrPeriodFee = currPeriodFee;
- this.SamePeriodFee = samePeriodFee;
- decimal _yoy = 0.00M;
- if (samePeriodFee != 0.00M)
- {
- _yoy = (currPeriodFee - samePeriodFee) / samePeriodFee;
- }
- this.Yoy = decimal.Parse(_yoy.ToString("0.##"));
- this.CurrPeriodGroupTotal = currPeriodGroupTotal;
- this.SamePeriodGroupTotal = samePeriodGroupTotal;
- this.CityData = cityData;
- }
- }
- public class StatisticsOPCityYOY
- {
- public string CityName { get; set; }
- public int CurrPeriodGroupTotal { get; set; }
- public int SamePeriodGroupTotal { get; set; }
-
-
-
- public decimal CurrPeriodFee { get; set; }
-
-
-
- public decimal SamePeriodFee { get; set; }
- public decimal Yoy { get; set; }
- public StatisticsOPCityYOY() { }
- public StatisticsOPCityYOY(string cityName, decimal currPeriodFee, decimal samePeriodFee,
- int currPeriodGroupTotal,int samePeriodGroupTotal)
- {
- this.CityName = cityName;
- this.CurrPeriodGroupTotal = currPeriodGroupTotal;
- this.SamePeriodGroupTotal = samePeriodGroupTotal;
- this.CurrPeriodFee = currPeriodFee;
- this.SamePeriodFee = samePeriodFee;
- string _yoy = "0.00";
- if (samePeriodFee != 0)
- {
- _yoy = ((currPeriodFee - samePeriodFee) / samePeriodFee).ToString("0.##");
- }
- this.Yoy = decimal.TryParse(_yoy, out decimal yoy1) ? yoy1 : 0.00M;
- }
- }
- public class StatisticsOPMonthYOY
- {
- public int MonthId { get; set; }
- public string MonthName { get; set; }
- public StatisticsOPYOY[] FeeDatas { get; set; }
- public StatisticsOPMonthYOY() { }
- public StatisticsOPMonthYOY(int monthId, string monthName, StatisticsOPYOY[] feeDatas)
- {
- MonthId = monthId;
- MonthName = monthName;
- FeeDatas = feeDatas;
- }
- }
- #endregion
- #endregion
- }
|