GroupStatementView.cs 51 KB

12345678910111213141516171819202122232425262728293031323334353637383940414243444546474849505152535455565758596061626364656667686970717273747576777879808182838485868788899091929394959697989910010110210310410510610710810911011111211311411511611711811912012112212312412512612712812913013113213313413513613713813914014114214314414514614714814915015115215315415515615715815916016116216316416516616716816917017117217317417517617717817918018118218318418518618718818919019119219319419519619719819920020120220320420520620720820921021121221321421521621721821922022122222322422522622722822923023123223323423523623723823924024124224324424524624724824925025125225325425525625725825926026126226326426526626726826927027127227327427527627727827928028128228328428528628728828929029129229329429529629729829930030130230330430530630730830931031131231331431531631731831932032132232332432532632732832933033133233333433533633733833934034134234334434534634734834935035135235335435535635735835936036136236336436536636736836937037137237337437537637737837938038138238338438538638738838939039139239339439539639739839940040140240340440540640740840941041141241341441541641741841942042142242342442542642742842943043143243343443543643743843944044144244344444544644744844945045145245345445545645745845946046146246346446546646746846947047147247347447547647747847948048148248348448548648748848949049149249349449549649749849950050150250350450550650750850951051151251351451551651751851952052152252352452552652752852953053153253353453553653753853954054154254354454554654754854955055155255355455555655755855956056156256356456556656756856957057157257357457557657757857958058158258358458558658758858959059159259359459559659759859960060160260360460560660760860961061161261361461561661761861962062162262362462562662762862963063163263363463563663763863964064164264364464564664764864965065165265365465565665765865966066166266366466566666766866967067167267367467567667767867968068168268368468568668768868969069169269369469569669769869970070170270370470570670770870971071171271371471571671771871972072172272372472572672772872973073173273373473573673773873974074174274374474574674774874975075175275375475575675775875976076176276376476576676776876977077177277377477577677777877978078178278378478578678778878979079179279379479579679779879980080180280380480580680780880981081181281381481581681781881982082182282382482582682782882983083183283383483583683783883984084184284384484584684784884985085185285385485585685785885986086186286386486586686786886987087187287387487587687787887988088188288388488588688788888989089189289389489589689789889990090190290390490590690790890991091191291391491591691791891992092192292392492592692792892993093193293393493593693793893994094194294394494594694794894995095195295395495595695795895996096196296396496596696796896997097197297397497597697797897998098198298398498598698798898999099199299399499599699799899910001001100210031004100510061007100810091010101110121013101410151016101710181019102010211022102310241025102610271028102910301031103210331034103510361037103810391040104110421043104410451046104710481049105010511052105310541055105610571058105910601061106210631064106510661067106810691070107110721073107410751076107710781079108010811082108310841085108610871088108910901091109210931094109510961097109810991100110111021103110411051106110711081109111011111112111311141115111611171118111911201121112211231124112511261127112811291130113111321133113411351136113711381139114011411142114311441145114611471148114911501151115211531154115511561157115811591160116111621163116411651166116711681169117011711172117311741175117611771178117911801181118211831184118511861187118811891190119111921193119411951196119711981199120012011202120312041205120612071208120912101211121212131214121512161217121812191220122112221223122412251226122712281229123012311232123312341235123612371238123912401241124212431244124512461247124812491250125112521253125412551256125712581259126012611262126312641265126612671268126912701271127212731274127512761277127812791280128112821283128412851286128712881289129012911292129312941295129612971298129913001301130213031304130513061307130813091310131113121313131413151316131713181319132013211322132313241325132613271328132913301331133213331334133513361337133813391340134113421343134413451346134713481349135013511352135313541355135613571358135913601361136213631364136513661367136813691370137113721373137413751376137713781379138013811382138313841385138613871388138913901391139213931394139513961397139813991400140114021403140414051406140714081409141014111412141314141415141614171418141914201421142214231424142514261427142814291430143114321433143414351436143714381439144014411442144314441445144614471448144914501451145214531454145514561457145814591460146114621463146414651466146714681469147014711472147314741475147614771478147914801481148214831484148514861487148814891490149114921493149414951496149714981499150015011502150315041505150615071508150915101511151215131514151515161517151815191520152115221523152415251526152715281529153015311532153315341535153615371538153915401541154215431544154515461547154815491550155115521553155415551556155715581559156015611562156315641565156615671568156915701571157215731574157515761577157815791580158115821583158415851586158715881589159015911592159315941595159615971598159916001601160216031604160516061607160816091610161116121613161416151616161716181619162016211622162316241625162616271628162916301631163216331634163516361637163816391640164116421643164416451646164716481649165016511652165316541655165616571658165916601661166216631664166516661667166816691670167116721673167416751676167716781679168016811682168316841685168616871688168916901691169216931694169516961697169816991700170117021703170417051706170717081709171017111712171317141715171617171718171917201721172217231724172517261727172817291730173117321733173417351736173717381739174017411742174317441745174617471748174917501751175217531754175517561757175817591760176117621763176417651766176717681769177017711772177317741775177617771778177917801781178217831784178517861787178817891790179117921793179417951796179717981799180018011802180318041805180618071808180918101811181218131814181518161817181818191820182118221823182418251826182718281829183018311832183318341835183618371838183918401841184218431844184518461847184818491850185118521853185418551856185718581859186018611862186318641865186618671868186918701871187218731874187518761877187818791880188118821883188418851886188718881889189018911892189318941895189618971898189919001901190219031904190519061907190819091910191119121913191419151916191719181919192019211922192319241925192619271928192919301931193219331934193519361937193819391940194119421943194419451946194719481949195019511952195319541955195619571958195919601961196219631964196519661967196819691970197119721973197419751976197719781979198019811982198319841985198619871988198919901991199219931994199519961997199819992000200120022003200420052006200720082009201020112012201320142015201620172018201920202021202220232024202520262027202820292030203120322033203420352036203720382039204020412042204320442045204620472048204920502051205220532054205520562057205820592060206120622063206420652066206720682069207020712072207320742075207620772078
  1. using Google.Protobuf;
  2. using Newtonsoft.Json;
  3. using OASystem.Domain.Entities.Financial;
  4. using OASystem.Domain.Entities.Groups;
  5. using System;
  6. using System.Collections.Generic;
  7. using System.Linq;
  8. using System.Runtime.Intrinsics.Arm;
  9. using System.Text;
  10. using System.Threading.Tasks;
  11. namespace OASystem.Domain.ViewModels.Statistics
  12. {
  13. /// <summary>
  14. /// 团组报表
  15. /// </summary>
  16. public class GroupStatementView
  17. {
  18. }
  19. /// <summary>
  20. /// 团组报表
  21. /// Items View
  22. /// </summary>
  23. public class GroupStatementItemView
  24. {
  25. /// <summary>
  26. /// 序号
  27. /// </summary>
  28. public int Row_Number { get; set; }
  29. /// <summary>
  30. /// 是否操作完成
  31. /// 0否1是
  32. /// </summary>
  33. public int IsSure { get; set; }
  34. /// <summary>
  35. /// 主键Id
  36. /// 团组Id
  37. /// </summary>
  38. public int Id { get; set; }
  39. /// <summary>
  40. /// 团号
  41. /// </summary>
  42. public string? TourCode { get; set; }
  43. /// <summary>
  44. /// 接团操作人
  45. /// </summary>
  46. public string? JietuanOperator { get; set; }
  47. /// <summary>
  48. /// 团组等级Id
  49. /// </summary>
  50. public int TeamLevId { get; set; }
  51. /// <summary>
  52. /// 团组等级
  53. /// </summary>
  54. public string? TeamLev { get; set; }
  55. /// <summary>
  56. /// 团组名称
  57. /// </summary>
  58. public string? TeamName { get; set; }
  59. /// <summary>
  60. /// 客户名称
  61. /// </summary>
  62. public string? ClientName { get; set; }
  63. /// <summary>
  64. /// 客户所属公司
  65. /// </summary>
  66. public string? ClientUnit { get; set; }
  67. /// <summary>
  68. /// 团组类型Id
  69. /// </summary>
  70. public int TeamTypeId { get; set; }
  71. /// <summary>
  72. /// 团组类型
  73. /// </summary>
  74. public string? TeamType { get; set; }
  75. /// <summary>
  76. /// 出团日期
  77. /// </summary>
  78. public DateTime VisitDate { get; set; }
  79. /// <summary>
  80. /// 出行天数
  81. /// </summary>
  82. public int VisitDays { get; set; }
  83. /// <summary>
  84. /// 出行人数
  85. /// </summary>
  86. public int VisitPNumber { get; set; }
  87. /// <summary>
  88. /// 最后收款时间
  89. /// </summary>
  90. public DateTime? LastCollectionTime { get; set; }
  91. }
  92. /// <summary>
  93. /// 团组报表
  94. /// Details View
  95. /// </summary>
  96. public class GroupStatementDetailsView
  97. {
  98. /// <summary>
  99. /// 费用总计 描述
  100. /// </summary>
  101. public string? FeeTotalStr { get; set; }
  102. /// <summary>
  103. /// 团组收入
  104. /// Data View
  105. /// </summary>
  106. public GroupIncomeView? GroupIncome { get; set; }
  107. /// <summary>
  108. /// 团组收入
  109. /// 描述
  110. /// </summary>
  111. public string? GroupIncomeStr { get; set; }
  112. /// <summary>
  113. /// 团组支出
  114. /// </summary>
  115. public GroupExpenditureView? GroupExpenditure { get; set; }
  116. }
  117. #region 团组收入
  118. /// <summary>
  119. /// 团组收入
  120. /// Data View
  121. /// </summary>
  122. public class GroupIncomeView
  123. {
  124. /// <summary>
  125. /// 应收 Items
  126. /// </summary>
  127. public List<Gsd_ForeignReceivablesView>? Receivables { get; set; }
  128. /// <summary>
  129. /// 应收 Str
  130. /// </summary>
  131. public string? ReceivableStr { get; set; }
  132. /// <summary>
  133. /// 已收 Items
  134. /// </summary>
  135. public List<Gsd_ProceedsReceivedView>? ProceedsReceivedViews { get; set; }
  136. /// <summary>
  137. /// 已收 Str
  138. /// </summary>
  139. public string? ProceedsReceivedStr { get; set; }
  140. /// <summary>
  141. /// 支出费用 Items
  142. /// </summary>
  143. public List<Gsd_ExtraCostsView>? ExtraCostsViews { get; set; }
  144. /// <summary>
  145. /// 支出费用 Str
  146. /// </summary>
  147. public string? ExtraCostsStr { get; set; }
  148. /// <summary>
  149. /// 收款退还 Items
  150. /// </summary>
  151. public List<Gsd_PaymentRefundAndOtherMoneyView>? PaymentRefundAndOtherMoneyViews { get; set; }
  152. /// <summary>
  153. /// 收款退还 Str
  154. /// </summary>
  155. public string? PaymentRefundAndOtherMoneyStr { get; set; }
  156. }
  157. /// <summary>
  158. /// 应收报表
  159. /// </summary>
  160. public class Gsd_ForeignReceivablesView
  161. {
  162. public int Id { get; set; }
  163. public int diid { get; set; }
  164. /// <summary>
  165. /// 添加方式
  166. /// 0 - 账单模块 1 - 成本预算模块 2 - 实际报价
  167. /// </summary>
  168. public int AddingWay { get; set; }
  169. /// <summary>
  170. /// 审核状态 AddingWay==2该项有值
  171. /// 0 - 未审核 1 - 审核通过 2 - 审核不通过
  172. /// </summary>
  173. public int Status { get; set; }
  174. public string StatusStr
  175. {
  176. get
  177. {
  178. string str = "-";
  179. if (AddingWay == 2)
  180. {
  181. if (Status == 0) str = "未审核";
  182. else if (Status == 1) str = "审核通过";
  183. else if (Status == 2) str = "审核不通过";
  184. }
  185. return str;
  186. }
  187. }
  188. public string Auditor { get; set; }
  189. public string AuditorStr { get {
  190. string str = "-";
  191. if (AddingWay == 2)
  192. {
  193. if (Status != 0)
  194. {
  195. str = @$"{Auditor} ";
  196. }
  197. }
  198. return str;
  199. } }
  200. //public DateTime? AuditTime { get; set; }
  201. /// <summary>
  202. /// 费用名称
  203. /// </summary>
  204. public string? PriceName { get; set; }
  205. /// <summary>
  206. /// 单价
  207. /// </summary>
  208. public decimal Price { get; set; } = 0.00M;
  209. /// <summary>
  210. /// 数量
  211. /// </summary>
  212. public int Count { get; set; }
  213. /// <summary>
  214. /// 单位
  215. /// </summary>
  216. public string? Unit { get; set; }
  217. /// <summary>
  218. /// 币种
  219. /// </summary>
  220. public int Currency { get; set; }
  221. /// <summary>
  222. /// 币种 Code
  223. /// </summary>
  224. public string CurrencyCode { get; set; }
  225. /// <summary>
  226. /// 币种 Name
  227. /// </summary>
  228. public string CurrencyName { get; set; }
  229. /// <summary>
  230. /// 汇率
  231. /// </summary>
  232. public decimal Rate { get; set; } = 1.0000M;
  233. /// <summary>
  234. /// 应收金额
  235. /// </summary>
  236. public decimal ItemSumPrice { get; set; } = 0.00M;
  237. public string Remark { get; set; }
  238. }
  239. /// <summary>
  240. /// 已收报表
  241. /// </summary>
  242. public class Gsd_ProceedsReceivedView
  243. {
  244. public int Id { get; set; }
  245. public int Diid { get; set; }
  246. public string SectionTimeDt { get; set; }
  247. /// <summary>
  248. /// 到款时间
  249. /// </summary>
  250. public string SectionTime { get {
  251. string dt = "";
  252. if (!string.IsNullOrEmpty(SectionTimeDt))
  253. {
  254. DateTime validDate;
  255. bool isValid = DateTime.TryParse(SectionTimeDt, out validDate);
  256. if (isValid)
  257. {
  258. dt = validDate.ToString("yyyy-MM-dd");
  259. }
  260. }
  261. return dt;
  262. } }
  263. /// <summary>
  264. /// 费用金额
  265. /// </summary>
  266. public decimal Price { get; set; } = 0.00M;
  267. /// <summary>
  268. /// 币种
  269. /// </summary>
  270. public int Currency { get; set; }
  271. /// <summary>
  272. /// 币种 Code
  273. /// </summary>
  274. public string CurrencyCode { get; set; }
  275. /// <summary>
  276. /// 币种 Name
  277. /// </summary>
  278. public string CurrencyName { get; set; }
  279. /// <summary>
  280. /// 支出单位
  281. /// </summary>
  282. public string? Client { get; set; }
  283. /// <summary>
  284. /// 转账标识Id
  285. /// </summary>
  286. public int ReceivablesType { get; set; }
  287. /// <summary>
  288. /// 转账类型名称
  289. /// </summary>
  290. public string ReceivablesTypeName { get; set; }
  291. /// <summary>
  292. /// 备注
  293. /// </summary>
  294. public string? Remark { get; set; }
  295. }
  296. /// <summary>
  297. /// 超支费用
  298. /// </summary>
  299. public class Gsd_ExtraCostsView
  300. {
  301. public int GECId { get; set; }
  302. public int GECDiId { get; set; }
  303. /// <summary>
  304. /// 费用名称
  305. /// </summary>
  306. public string? PriceName { get; set; }
  307. /// <summary>
  308. /// 付款金额
  309. /// </summary>
  310. public decimal PayMoney { get; set; } = 0.00M;
  311. /// <summary>
  312. /// 付款币种
  313. /// </summary>
  314. public string? PaymentCurrency { get; set; }
  315. /// <summary>
  316. /// 当天汇率
  317. /// </summary>
  318. public decimal DayRate { get; set; } = 1.0000M;
  319. /// <summary>
  320. /// 人民币金额
  321. /// </summary>
  322. public decimal CNYPrice { get; set; } = 0.00M;
  323. /// <summary>
  324. /// 收款方
  325. /// </summary>
  326. public string? Payee { get; set; }
  327. /// <summary>
  328. /// 费用标识
  329. /// -1 未选择 0 公转 1 私转
  330. /// </summary>
  331. public int OrbitalPrivateTransfer { get; set; }
  332. /// <summary>
  333. /// 支付方式
  334. /// </summary>
  335. public string? PayWay { get; set; }
  336. /// <summary>
  337. /// 卡类型
  338. /// </summary>
  339. public string? CardType { get; set; }
  340. /// <summary>
  341. /// 付款状态
  342. /// </summary>
  343. public int IsPay { get; set; }
  344. /// <summary>
  345. /// 申请人
  346. /// </summary>
  347. public string? Applicant { get; set; }
  348. }
  349. /// <summary>
  350. /// 收款退还
  351. /// </summary>
  352. public class Gsd_PaymentRefundAndOtherMoneyView
  353. {
  354. public int Id { get; set; }
  355. public int DiId { get; set; }
  356. /// <summary>
  357. /// 费用名称
  358. /// </summary>
  359. public string? PriceName { get; set; }
  360. /// <summary>
  361. /// 币种code
  362. /// </summary>
  363. public string? PayCurrencyCode { get; set; }
  364. /// <summary>
  365. /// 币种名称
  366. /// </summary>
  367. public string? PayCurrencyName { get; set; }
  368. /// <summary>
  369. /// 费用
  370. /// </summary>
  371. public decimal Price { get; set; } = 0.00M;
  372. /// <summary>
  373. /// 人民币金额
  374. /// </summary>
  375. public decimal CNYPrice { get; set; } = 0.00M;
  376. /// <summary>
  377. /// 当时汇率
  378. /// </summary>
  379. public decimal ThisRate { get; set; } = 1.0000M;
  380. /// <summary>
  381. /// 收款方
  382. /// </summary>
  383. public string? Payee { get; set; }
  384. /// <summary>
  385. /// 付款时间
  386. /// </summary>
  387. public string? PayTime { get; set; }
  388. /// <summary>
  389. /// 费用标识
  390. /// -1 未选择 0 公转 1 私转
  391. /// </summary>
  392. public int OrbitalPrivateTransfer { get; set; }
  393. public string CostMark
  394. {
  395. get
  396. {
  397. return OrbitalPrivateTransfer == 0 ? "公转" : OrbitalPrivateTransfer == 1 ? "私转" : "-";
  398. }
  399. }
  400. /// <summary>
  401. /// 支付方式
  402. /// </summary>
  403. public string? PayType { get; set; }
  404. /// <summary>
  405. /// 付款状态
  406. /// 0 未付款 1 已付款
  407. /// </summary>
  408. public int IsPay { get; set; }
  409. public string IsPayLable
  410. {
  411. get
  412. {
  413. return IsPay == 0 ? "未付款" : IsPay == 1 ? "已付款" : "-";
  414. }
  415. }
  416. /// <summary>
  417. /// 申请人
  418. /// </summary>
  419. public string? Applicant { get; set; }
  420. public string Remark { get; set; }
  421. }
  422. #region 收款退还 View
  423. public class Gsd_PaymentRefundAndOtherMoneyDataSource1View : Grp_CreditCardPayment
  424. {
  425. /// <summary>
  426. /// 申请人
  427. /// </summary>
  428. public string Appliction { get; set; }
  429. public int PrId { get; set; }
  430. public int PrDiId { get; set; }
  431. public string PrPriceName { get; set; }
  432. public decimal PrPrice { get; set; } = 0.00M;
  433. public int PrCurrencyId { get; set; }
  434. public int PrPayType { get; set; }
  435. public int PrPriceType { get; set; }
  436. public string SKTHRemark { get; set; }
  437. };
  438. #endregion
  439. #endregion
  440. #region 团组支出
  441. /// <summary>
  442. /// 团组支出 View
  443. /// </summary>
  444. public class GroupExpenditureView
  445. {
  446. /// <summary>
  447. /// 酒店费用集合
  448. /// </summary>
  449. public List<GroupHotelFeeView>? GroupHotelFeeViews { get; set; }
  450. /// <summary>
  451. /// 酒店费用描述
  452. /// </summary>
  453. public string? GroupHotelFeeStr { get; set; }
  454. /// <summary>
  455. /// 地接费用集合
  456. /// </summary>
  457. public List<GroupCTGGRFeeView>? GroupCTGGRFeeViews { get; set; }
  458. /// <summary>
  459. /// 地接费用描述
  460. /// </summary>
  461. public string? GroupCTGGRFeeStr { get; set; }
  462. /// <summary>
  463. /// 机票费用集合
  464. /// </summary>
  465. public List<GroupAirFeeView>? GroupAirFeeViews { get; set; }
  466. /// <summary>
  467. /// 机票费用描述
  468. /// </summary>
  469. public string? GroupAirFeeStr { get; set; }
  470. /// <summary>
  471. /// 签证费用集合
  472. /// </summary>
  473. public List<GroupVisaFeeView>? GroupVisaFeeViews { get; set; }
  474. /// <summary>
  475. /// 签证费用描述
  476. /// </summary>
  477. public string? GroupVisaFeeStr { get; set; }
  478. /// <summary>
  479. /// 邀请/公务费用集合
  480. /// </summary>
  481. public List<GroupInvitationalFeeView>? GroupInvitationalFeeViews { get; set; }
  482. /// <summary>
  483. /// 邀请/公务费用描述
  484. /// </summary>
  485. public string? GroupInvitationalFeeStr { get; set; }
  486. /// <summary>
  487. /// 保险费用集合
  488. /// </summary>
  489. public List<GroupInsuranceFeeView>? GroupInsuranceFeeViews { get; set; }
  490. /// <summary>
  491. /// 保险费用描述
  492. /// </summary>
  493. public string? GroupInsuranceFeeStr { get; set; }
  494. /// <summary>
  495. /// 增减款项费用集合
  496. /// </summary>
  497. public List<GroupDecreaseFeeView>? GroupDecreaseFeeViews { get; set; }
  498. /// <summary>
  499. /// 增减款项费用描述
  500. /// </summary>
  501. public string? GroupDecreaseFeeStr { get; set; }
  502. public List<GroupRoyaltyFeeView> GroupRoyaltyFeeViews { get; set; }
  503. public string? GroupRoyaltyFeeStr { get; set; }
  504. /// <summary>
  505. /// 公司人员报销费用集合
  506. /// </summary>
  507. public List<GroupReimburseFeeInfoView> GroupReimburseFeeViews { get; set; }
  508. /// <summary>
  509. /// 公司人员报销费用描述
  510. /// </summary>
  511. public string? GroupReimburseFeeStr { get; set; }
  512. }
  513. /// <summary>
  514. /// 酒店费用View
  515. /// </summary>
  516. public class GroupHotelFeeView
  517. {
  518. /// <summary>
  519. /// 团组Id
  520. /// </summary>
  521. public int HrDiId { get; set; }
  522. /// <summary>
  523. /// 酒店Id
  524. /// </summary>
  525. public int HrId { get; set; }
  526. /// <summary>
  527. /// 城市
  528. /// </summary>
  529. public string? City { get; set; }
  530. /// <summary>
  531. /// 酒店名称
  532. /// </summary>
  533. public string? HotelName { get; set; }
  534. /// <summary>
  535. /// 入住时间
  536. /// </summary>
  537. public string? CheckInDate { get; set; }
  538. /// <summary>
  539. /// 离店时间
  540. /// </summary>
  541. public string? CheckOutDate { get; set; }
  542. /// <summary>
  543. /// 单间价格
  544. /// </summary>
  545. public decimal SingleRoomPrice { get; set; } = 0.00M;
  546. /// <summary>
  547. /// 单间数量
  548. /// </summary>
  549. public int SingleRoomCount { get; set; }
  550. /// <summary>
  551. /// 双间价格
  552. /// </summary>
  553. public decimal DoubleRoomPrice { get; set; } = 0.00M;
  554. /// <summary>
  555. /// 双间数量
  556. /// </summary>
  557. public int DoubleRoomCount { get; set; }
  558. /// <summary>
  559. /// 套房价格
  560. /// </summary>
  561. public decimal SuiteRoomPrice { get; set; } = 0.00M;
  562. /// <summary>
  563. /// 套房数量
  564. /// </summary>
  565. public int SuiteRoomCount { get; set; }
  566. /// <summary>
  567. /// 其他房型价格
  568. /// </summary>
  569. public decimal OtherRoomPrice { get; set; } = 0.00M;
  570. /// <summary>
  571. /// 其他房型数量
  572. /// </summary>
  573. public int OtherRoomCount { get; set; }
  574. /// <summary>
  575. /// 房间费用
  576. /// </summary>
  577. public decimal RoomPrice { get; set; }
  578. /// <summary>
  579. /// 房间费用币种
  580. /// </summary>
  581. public string RoomPriceCurrency { get; set; }
  582. /// <summary>
  583. /// 房间费用提示信息
  584. /// </summary>
  585. public string RoomInfoTips { get; set; }
  586. /// <summary>
  587. /// excel Label
  588. /// </summary>
  589. public string RoomFeeLabel { get { return $"{RoomPrice.ToString("#0.00")} {RoomPriceCurrency}"; } }
  590. /// <summary>
  591. /// 早餐费用
  592. /// </summary>
  593. public decimal BreakfastPrice { get; set; } = 0.00M;
  594. /// <summary>
  595. /// 早餐币种
  596. /// </summary>
  597. public string? BreakfastCurrency { get; set; }
  598. /// <summary>
  599. /// 早餐提示消息
  600. /// </summary>
  601. public string BreakfastInfoTips { get; set; }
  602. /// <summary>
  603. /// excel Label
  604. /// </summary>
  605. public string BreakfastFeeLabel { get { return $"{BreakfastPrice.ToString("#0.00")} {BreakfastCurrency}"; } }
  606. ///// <summary>
  607. ///// 由地接支付
  608. ///// 0 是 1否
  609. ///// </summary>
  610. //public int Isoppay { get; set; }
  611. /// <summary>
  612. /// 地税
  613. /// </summary>
  614. public decimal GovernmentRent { get; set; } = 0.00M;
  615. /// <summary>
  616. /// 地税币种
  617. /// </summary>
  618. public string? GovernmentRentCurrency { get; set; }
  619. /// <summary>
  620. /// 地税提示消息
  621. /// </summary>
  622. public string GovernmentRentTips { get; set; }
  623. /// <summary>
  624. /// excel Label
  625. /// </summary>
  626. public string GovernmentRentFeeLabel { get { return $"{GovernmentRent.ToString("#0.00")} {GovernmentRentCurrency}"; } }
  627. /// <summary>
  628. /// 城市价格
  629. /// </summary>
  630. public decimal CityTax { get; set; } = 0.00M;
  631. /// <summary>
  632. /// 城市币种
  633. /// </summary>
  634. public string? CityTaxCurrency { get; set; }
  635. /// <summary>
  636. /// 城市税提示信息
  637. /// </summary>
  638. public string? CityTaxTips { get; set; }
  639. /// <summary>
  640. /// excel Label
  641. /// </summary>
  642. public string CityTaxFeeLabel { get { return $"{CityTax.ToString("#0.00")} {CityTaxCurrency}"; } }
  643. /// <summary>
  644. /// 信用卡金额
  645. /// </summary>
  646. public decimal PayMoney { get; set; } = 0.00M;
  647. /// <summary>
  648. /// 信用卡金额币种
  649. /// </summary>
  650. public string? PaymentCurrency { get; set; }
  651. /// <summary>
  652. /// 人民币金额
  653. /// </summary>
  654. public decimal CNYPrice { get; set; } = 0.00M;
  655. /// <summary>
  656. /// 人民币金额
  657. /// </summary>
  658. public string CNYPriceLabel { get { return $"{CNYPrice.ToString("#0.00")} CNY"; } }
  659. ///// <summary>
  660. ///// 当天汇率
  661. ///// </summary>
  662. //public decimal DayRate { get; set; } = 0.0000M;
  663. ///// <summary>
  664. ///// 币种汇率
  665. ///// </summary>
  666. //public string? CurrencyRateStr { get; set; }
  667. /// <summary>
  668. /// 收款方
  669. /// </summary>
  670. public string? Payee { get; set; }
  671. ///// <summary>
  672. ///// 费用标识
  673. ///// -1 未选择 0 公转 1 私转
  674. ///// </summary>
  675. public int OrbitalPrivateTransfer { get; set; }
  676. public string CostMark
  677. {
  678. get
  679. {
  680. var label = string.Empty;
  681. if (OrbitalPrivateTransfer == 0) label = "公转";
  682. else if (OrbitalPrivateTransfer == 1) label = "私转";
  683. return label;
  684. }
  685. }
  686. /// <summary>
  687. /// 支付方式
  688. /// </summary>
  689. public string? PayWay { get; set; }
  690. ///// <summary>
  691. ///// 卡类型
  692. ///// </summary>
  693. //public string? CardType { get; set; }
  694. /// <summary>
  695. /// 是否支付
  696. /// -1 未选择 0 未付款 1 已付款 2 其它费用子项未付款
  697. /// </summary>
  698. public int IsPay { get; set; }
  699. public string IsPayLable
  700. {
  701. get
  702. {
  703. var label = $"未选择";
  704. if (IsPay == 0) label = "未付款";
  705. else if (IsPay == 1) label = "已付款";
  706. else if (IsPay == 2) label = "其它费用子项未付款";
  707. return label;
  708. }
  709. }
  710. /// <summary>
  711. ///
  712. /// </summary>
  713. public string PayTips { get; set; }
  714. /// <summary>
  715. /// 操作人
  716. /// </summary>
  717. public string? Applicant { get; set; }
  718. public string Remark { get; set; }
  719. }
  720. /// <summary>
  721. /// 地接费用View
  722. /// </summary>
  723. public class GroupCTGGRFeeView
  724. {
  725. public int CTGGRDiId { get; set; }
  726. public int CTGGRId { get; set; }
  727. /// <summary>
  728. /// 地区
  729. /// </summary>
  730. public string? Area { get; set; }
  731. /// <summary>
  732. /// 费用名称
  733. /// </summary>
  734. public string? PriceName { get; set; }
  735. /// <summary>
  736. /// 费用描述
  737. /// </summary>
  738. public string? PriceContent { get; set; }
  739. /// <summary>
  740. /// 付款金额
  741. /// </summary>
  742. public decimal PayMoney { get; set; } = 0.00M;
  743. /// <summary>
  744. /// 付款币种
  745. /// </summary>
  746. public string? PaymentCurrency { get; set; }
  747. /// <summary>
  748. /// 此次付款百分比
  749. /// </summary>
  750. public decimal PayPercentage { get; set; } = 0.00M;
  751. /// <summary>
  752. /// 已付款金额
  753. /// </summary>
  754. public decimal AmountPaid { get; set; } = 0.00M;
  755. /// <summary>
  756. /// 尾款
  757. /// </summary>
  758. public decimal BalancePayment { get; set; } = 0.00M;
  759. /// <summary>
  760. /// 消费日期
  761. /// </summary>
  762. public DateTime DatePrice { get; set; }
  763. /// <summary>
  764. /// 当时汇率
  765. /// </summary>
  766. public decimal DayRate { get; set; } = 1.0000M;
  767. /// <summary>
  768. /// 付款人民币金额
  769. /// </summary>
  770. public decimal CNYPrice { get; set; }
  771. /// <summary>
  772. /// 付款金额
  773. /// </summary>
  774. public string? Payee { get; set; }
  775. /// <summary>
  776. /// 付款时间
  777. /// </summary>
  778. public string? AuditGMDate { get; set; }
  779. /// <summary>
  780. /// 费用标识
  781. /// -1 未选择 0 公转 1 私转
  782. /// </summary>
  783. public int OrbitalPrivateTransfer { get; set; }
  784. /// <summary>
  785. /// 费用标识Text
  786. /// </summary>
  787. public string CostMark
  788. {
  789. get
  790. {
  791. return OrbitalPrivateTransfer == 0 ? "公转" : OrbitalPrivateTransfer == 1 ? "私转" : "-";
  792. }
  793. }
  794. /// <summary>
  795. /// 支付方式
  796. /// </summary>
  797. public string? PayWay { get; set; }
  798. /// <summary>
  799. /// 是否支付
  800. /// -1 未选择 0 未付款 1 已付款
  801. /// </summary>
  802. public int IsPay { get; set; }
  803. public string IsPayLabel
  804. {
  805. get
  806. {
  807. return IsPay == 0 ? "未付款" : IsPay == 1 ? "已付款" : "-";
  808. }
  809. }
  810. /// <summary>
  811. /// 操作人
  812. /// </summary>
  813. public string? Applicant { get; set; }
  814. }
  815. /// <summary>
  816. /// 机票费用View
  817. /// </summary>
  818. public class GroupAirFeeView
  819. {
  820. public int AirId { get; set; }
  821. public int AirDiId { get; set; }
  822. /// <summary>
  823. /// 舱位类型
  824. /// </summary>
  825. public string? AirTypeName { get; set; }
  826. /// <summary>
  827. /// 航班号
  828. /// </summary>
  829. public string? FlightsCode { get; set; }
  830. /// <summary>
  831. /// 城市A-B
  832. /// </summary>
  833. public string? FlightsCity { get; set; }
  834. /// <summary>
  835. /// 航班日期
  836. /// </summary>
  837. public string? FlightsDate { get; set; }
  838. /// <summary>
  839. /// 航班时间
  840. /// </summary>
  841. public string? FlightsTime { get; set; }
  842. /// <summary>
  843. /// 客户姓名
  844. /// </summary>
  845. public string? ClientName { get; set; }
  846. /// <summary>
  847. /// 客户人数
  848. /// </summary>
  849. public int ClientNum { get; set; }
  850. /// <summary>
  851. /// 付款金额
  852. /// </summary>
  853. public decimal PayMoney { get; set; } = 0.00M;
  854. /// <summary>
  855. /// 付款币种
  856. /// </summary>
  857. public string? PayMoneyCurrency { get; set; }
  858. /// <summary>
  859. /// CNY 金额
  860. /// </summary>
  861. public decimal CNYPrice { get; set; } = 0.00M;
  862. /// <summary>
  863. /// 当时汇率
  864. /// </summary>
  865. public decimal DayRate { get; set; } = 1.0000M;
  866. /// <summary>
  867. /// 付款时间
  868. /// </summary>
  869. public string? AuditGMDate { get; set; }
  870. /// <summary>
  871. /// 收款方
  872. /// </summary>
  873. public string? Payee { get; set; }
  874. /// <summary>
  875. /// 费用标识
  876. /// -1 未选择 0 公转 1 私转
  877. /// </summary>
  878. public int OrbitalPrivateTransfer { get; set; }
  879. /// <summary>
  880. /// 支付方式
  881. /// </summary>
  882. public string? PayWay { get; set; }
  883. /// <summary>
  884. /// 卡类型
  885. /// </summary>
  886. public string? CardType { get; set; }
  887. /// <summary>
  888. /// 是否支付
  889. /// -1 未选择 0 未付款 1 已付款
  890. /// </summary>
  891. public int IsPay { get; set; }
  892. /// <summary>
  893. /// 操作人
  894. /// </summary>
  895. public string? Applicant { get; set; }
  896. /// <summary>
  897. /// SetDataId
  898. /// </summary>
  899. public int CType { get; set; }
  900. }
  901. /// <summary>
  902. /// 签证费用View
  903. /// </summary>
  904. public class GroupVisaFeeView
  905. {
  906. public int VisaId { get; set; }
  907. public int VisaDiId { get; set; }
  908. /// <summary>
  909. /// 客户名称
  910. /// </summary>
  911. public string? VisaClient { get; set; }
  912. /// <summary>
  913. /// 付款金额
  914. /// </summary>
  915. public decimal PayMoney { get; set; } = 0.00M;
  916. /// <summary>
  917. /// 付款金额
  918. /// </summary>
  919. public decimal CNYPrice { get; set; } = 0.00M;
  920. /// <summary>
  921. /// 付款币种
  922. /// </summary>
  923. public string? PayMoneyCurrency { get; set; }
  924. /// <summary>
  925. /// 当时汇率
  926. /// </summary>
  927. public decimal DayRate { get; set; } = 1.0000M;
  928. /// <summary>
  929. /// 付款时间
  930. /// </summary>
  931. public string? AuditGMDate { get; set; }
  932. /// <summary>
  933. /// 收款方
  934. /// </summary>
  935. public string? Payee { get; set; }
  936. /// <summary>
  937. /// 费用标识
  938. /// -1 未选择 0 公转 1 私转
  939. /// </summary>
  940. public int OrbitalPrivateTransfer { get; set; }
  941. /// <summary>
  942. /// 支付方式
  943. /// </summary>
  944. public string? PayWay { get; set; }
  945. /// <summary>
  946. /// 卡类型
  947. /// </summary>
  948. public string? CardType { get; set; }
  949. /// <summary>
  950. /// 是否支付
  951. /// -1 未选择 0 未付款 1 已付款
  952. /// </summary>
  953. public int IsPay { get; set; }
  954. /// <summary>
  955. /// 操作人
  956. /// </summary>
  957. public string? Applicant { get; set; }
  958. }
  959. /// <summary>
  960. /// 邀请/公务费用View
  961. /// </summary>
  962. public class GroupInvitationalFeeView
  963. {
  964. public int IOAId { get; set; }
  965. public int IOADiId { get; set; }
  966. /// <summary>
  967. /// 邀请方地区
  968. /// </summary>
  969. public string? InviterArea { get; set; }
  970. /// <summary>
  971. /// 邀请方
  972. /// </summary>
  973. public string? Inviter { get; set; }
  974. /// <summary>
  975. /// 邀请时间
  976. /// </summary>
  977. public string? InviteTime { get; set; }
  978. /// <summary>
  979. /// 邀请函费用
  980. /// </summary>
  981. public decimal InviteCost { get; set; } = 0.00M;
  982. /// <summary>
  983. /// 邀请函币种
  984. /// </summary>
  985. public string? InviteCurrency { get; set; }
  986. /// <summary>
  987. /// 快递费用
  988. /// </summary>
  989. public decimal SendCost { get; set; } = 0.00M;
  990. /// <summary>
  991. /// 快递币种
  992. /// </summary>
  993. public string? SendCurrency { get; set; }
  994. /// <summary>
  995. /// 活动费用
  996. /// </summary>
  997. public decimal EventsCost { get; set; } = 0.00M;
  998. /// <summary>
  999. /// 活动币种
  1000. /// </summary>
  1001. public string? EventsCurrency { get; set; }
  1002. /// <summary>
  1003. /// 翻译费用
  1004. /// </summary>
  1005. public decimal TranslateCost { get; set; } = 0.00M;
  1006. /// <summary>
  1007. /// 翻译币种
  1008. /// </summary>
  1009. public string? TranslateCurrency { get; set; }
  1010. /// <summary>
  1011. /// 付款金额
  1012. /// </summary>
  1013. public decimal PayMoney { get; set; } = 0.00M;
  1014. /// <summary>
  1015. /// 付款币种
  1016. /// </summary>
  1017. public string? PaymentCurrency { get; set; }
  1018. /// <summary>
  1019. /// 人民币费用
  1020. /// </summary>
  1021. public decimal CNYPrice { get; set; } = 0.00M;
  1022. /// <summary>
  1023. /// 人民币费用(后台计算)
  1024. /// </summary>
  1025. public decimal CNYPrice2 { get; set; } = 0.00M;
  1026. /// <summary>
  1027. /// 当时币种汇率
  1028. /// </summary>
  1029. public string? CurrencyRateStr { get; set; }
  1030. /// <summary>
  1031. /// 收款方
  1032. /// </summary>
  1033. public string? Payee { get; set; }
  1034. /// <summary>
  1035. /// 付款时间
  1036. /// </summary>
  1037. public string? AuditGMDate { get; set; }
  1038. /// <summary>
  1039. /// 费用标识
  1040. /// -1 未选择 0 公转 1 私转
  1041. /// </summary>
  1042. public int OrbitalPrivateTransfer { get; set; }
  1043. /// <summary>
  1044. /// 支付方式
  1045. /// </summary>
  1046. public string? PayWay { get; set; }
  1047. /// <summary>
  1048. /// 是否支付
  1049. /// -1 未选择 0 未付款 1 已付款
  1050. /// </summary>
  1051. public int IsPay { get; set; }
  1052. /// <summary>
  1053. /// 操作人
  1054. /// </summary>
  1055. public string? Applicant { get; set; }
  1056. }
  1057. /// <summary>
  1058. /// 保险费用View
  1059. /// </summary>
  1060. public class GroupInsuranceFeeView
  1061. {
  1062. public int InsuranceId { get; set; }
  1063. public int InsuranceDiId { get; set; }
  1064. /// <summary>
  1065. /// 客户名称
  1066. /// </summary>
  1067. public string? ClientName { get; set; }
  1068. /// <summary>
  1069. /// 付款金额
  1070. /// </summary>
  1071. public decimal PayMoney { get; set; } = 0.00M;
  1072. /// <summary>
  1073. /// 付款币种
  1074. /// </summary>
  1075. public string? PayMoneyCurrency { get; set; }
  1076. /// <summary>
  1077. /// 人民币金额
  1078. /// </summary>
  1079. public decimal CNYPrice { get; set; } = 0.00M;
  1080. /// <summary>
  1081. /// 付款时间
  1082. /// </summary>
  1083. public string? AuditGMDate { get; set; }
  1084. /// <summary>
  1085. /// 收款方
  1086. /// </summary>
  1087. public string? Payee { get; set; }
  1088. /// <summary>
  1089. /// 费用标识
  1090. /// -1 未选择 0 公转 1 私转
  1091. /// </summary>
  1092. public int OrbitalPrivateTransfer { get; set; }
  1093. /// <summary>
  1094. /// 支付方式
  1095. /// </summary>
  1096. public string? PayWay { get; set; }
  1097. /// <summary>
  1098. /// 是否支付
  1099. /// -1 未选择 0 未付款 1 已付款
  1100. /// </summary>
  1101. public int IsPay { get; set; }
  1102. /// <summary>
  1103. /// 操作人
  1104. /// </summary>
  1105. public string? Applicant { get; set; }
  1106. }
  1107. /// <summary>
  1108. /// 增减款项View
  1109. /// </summary>
  1110. public class GroupDecreaseFeeView
  1111. {
  1112. public int DPId { get; set; }
  1113. public int DPDiId { get; set; }
  1114. /// <summary>
  1115. /// 费用名称
  1116. /// </summary>
  1117. public string? PriceName { get; set; }
  1118. /// <summary>
  1119. /// 付款金额
  1120. /// </summary>
  1121. public decimal PayMoney { get; set; } = 0.00M;
  1122. /// <summary>
  1123. /// 付款币种
  1124. /// </summary>
  1125. public string? PayMoneyCurrency { get; set; }
  1126. /// <summary>
  1127. /// 当时汇率
  1128. /// </summary>
  1129. public decimal DayRate { get; set; } = 1.0000M;
  1130. /// <summary>
  1131. /// 人民币金额
  1132. /// </summary>
  1133. public decimal CNYPrice { get; set; } = 0.00M;
  1134. /// <summary>
  1135. /// 付款时间
  1136. /// </summary>
  1137. public string? AuditGMDate { get; set; }
  1138. /// <summary>
  1139. /// 收款方
  1140. /// </summary>
  1141. public string? Payee { get; set; }
  1142. /// <summary>
  1143. /// 费用标识
  1144. /// -1 未选择 0 公转 1 私转
  1145. /// </summary>
  1146. public int OrbitalPrivateTransfer { get; set; }
  1147. /// <summary>
  1148. /// 支付方式
  1149. /// </summary>
  1150. public string? PayWay { get; set; }
  1151. /// <summary>
  1152. /// 是否支付
  1153. /// -1 未选择 0 未付款 1 已付款
  1154. /// </summary>
  1155. public int IsPay { get; set; }
  1156. /// <summary>
  1157. /// 操作人
  1158. /// </summary>
  1159. public string? Applicant { get; set; }
  1160. }
  1161. public class GroupRoyaltyFeeInfo
  1162. {
  1163. public int GroupId { get; set; }
  1164. public string OverviewInfo { get; set; }
  1165. [JsonIgnore]
  1166. public string DetailedInfo { get; set; }
  1167. public string[] DetailedInfoText
  1168. {
  1169. get
  1170. {
  1171. var jsonArray = Array.Empty<string>();
  1172. string str = DetailedInfo;
  1173. if (string.IsNullOrWhiteSpace(str)) return jsonArray;
  1174. str = str.Trim();
  1175. if ((str.StartsWith("{") && str.EndsWith("}")) || // 检查是否是 JSON 对象
  1176. (str.StartsWith("[") && str.EndsWith("]"))) // 检查是否是 JSON 数组
  1177. {
  1178. try
  1179. {
  1180. return JsonConvert.DeserializeObject<string[]>(str);
  1181. }
  1182. catch (JsonException)
  1183. {
  1184. return jsonArray;
  1185. }
  1186. }
  1187. return jsonArray;
  1188. }
  1189. }
  1190. public string DetailedInfoExcelText
  1191. {
  1192. get
  1193. {
  1194. string label = string.Empty;
  1195. var array = DetailedInfoText;
  1196. if (!array.Any()) return label;
  1197. foreach (var item in array) label += $"{item}\n";
  1198. if (label.EndsWith(@"\n")) label = label.Substring(0, label.Length - 2);
  1199. return label;
  1200. }
  1201. }
  1202. public decimal Amount { get; set; }
  1203. public int IsConfirm { get; set; }
  1204. public string IsConfrimText { get { return IsConfirm == 1 ? "已确认" : "未确认"; } }
  1205. public int IsSeed { get; set; }
  1206. public string IsSeedText { get { return IsSeed == 1 ? "已发放" : "未发放"; } }
  1207. public string RoyaltyUserName { get; set; }
  1208. public string CreateUserName { get; set; }
  1209. public DateTime CreateTime { get; set; }
  1210. }
  1211. public class GroupReimburseFeeInfoView
  1212. {
  1213. /// <summary>
  1214. /// 金额总计
  1215. /// </summary>
  1216. public decimal TotalAmt { get; set; }
  1217. public string Currency { get; set; } = "CNY";
  1218. //public GroupReimburseFeeSubInfo[]? FeeItems { get; set; }
  1219. /// <summary>
  1220. /// 申请原因
  1221. /// </summary>
  1222. public string AppReason { get; set; }
  1223. public int FAudit { get; set; }
  1224. public int MAudit { get; set; }
  1225. /// <summary>
  1226. /// 审核状态
  1227. /// </summary>
  1228. public string AuditStatusFlg
  1229. {
  1230. get
  1231. {
  1232. var fLabel = FAudit == 0 ? "财务未审核" : FAudit == 1 ? "财务已审核" : "财务审核未通过";
  1233. var mLabel = MAudit == 0 ? "总经理未审核" : MAudit == 1 ? "总经理已审核" : "总经理审核未通过";
  1234. return $"{fLabel}<br />{mLabel}";
  1235. }
  1236. }
  1237. /// <summary>
  1238. /// 付款描述
  1239. /// </summary>
  1240. public string PayStatusFlag { get; set; }
  1241. /// <summary>
  1242. /// 转账标识
  1243. /// </summary>
  1244. public string TransferLabel { get; set; }
  1245. /// <summary>
  1246. /// 申请公司
  1247. /// </summary>
  1248. public string ApplyComp { get; set; }
  1249. /// <summary>
  1250. /// 申请人
  1251. /// </summary>
  1252. public string ApplyName { get; set; }
  1253. /// <summary>
  1254. /// 申请时间
  1255. /// </summary>
  1256. public DateTime ApplyTime { get; set; }
  1257. }
  1258. public class GroupReimburseFeeSubInfo
  1259. {
  1260. /// <summary>
  1261. /// 费用名称
  1262. /// </summary>
  1263. public string? PriceName { get; set; }
  1264. /// <summary>
  1265. /// 数量
  1266. /// </summary>
  1267. public decimal Quantity { get; set; }
  1268. /// <summary>
  1269. /// 单价
  1270. /// </summary>
  1271. public decimal Price { get; set; }
  1272. /// <summary>
  1273. /// 小记
  1274. /// </summary>
  1275. public decimal SubTotal { get; set; }
  1276. public string Currency { get; set; } = "CNY";
  1277. public string Remark { get; set; }
  1278. }
  1279. /// <summary>
  1280. /// 操作人员提成View
  1281. /// </summary>
  1282. public class GroupRoyaltyFeeView
  1283. {
  1284. public int GroupId { get; set; }
  1285. public string OverviewInfo { get; set; }
  1286. public string[] DetailedInfoText { get; set; }
  1287. public decimal Amount { get; set; }
  1288. public string IsConfrimText { get; set; }
  1289. public string IsSeedText { get; set; }
  1290. public string RoyaltyUserName { get; set; }
  1291. public string CreateUserName { get; set; }
  1292. public DateTime CreateTime { get; set; }
  1293. }
  1294. #endregion
  1295. #region 团组统计报表下载
  1296. /// <summary>
  1297. /// Excel 签证费用View
  1298. /// </summary>
  1299. public class GroupVisaFeeExcelView
  1300. {
  1301. public int VisaId { get; set; }
  1302. public int VisaDiId { get; set; }
  1303. /// <summary>
  1304. /// 客户名称
  1305. /// </summary>
  1306. public string? VisaClient { get; set; }
  1307. /// <summary>
  1308. /// 付款金额
  1309. /// </summary>
  1310. public decimal PayMoney { get; set; } = 0.00M;
  1311. /// <summary>
  1312. /// 付款金额
  1313. /// </summary>
  1314. public decimal CNYPrice { get; set; } = 0.00M;
  1315. /// <summary>
  1316. /// 付款币种
  1317. /// </summary>
  1318. public string? PayMoneyCurrency { get; set; }
  1319. /// <summary>
  1320. /// 当时汇率
  1321. /// </summary>
  1322. public decimal DayRate { get; set; } = 1.0000M;
  1323. /// <summary>
  1324. /// 付款时间
  1325. /// </summary>
  1326. public string? AuditGMDate { get; set; }
  1327. /// <summary>
  1328. /// 收款方
  1329. /// </summary>
  1330. public string? Payee { get; set; }
  1331. /// <summary>
  1332. /// 费用标识
  1333. /// -1 未选择 0 公转 1 私转
  1334. /// </summary>
  1335. public string CostMark { get; set; }
  1336. /// <summary>
  1337. /// 支付方式
  1338. /// </summary>
  1339. public string? PaymentModes { get; set; }
  1340. /// <summary>
  1341. /// 卡类型
  1342. /// </summary>
  1343. public string? CardType { get; set; }
  1344. /// <summary>
  1345. /// 是否支付
  1346. /// </summary>
  1347. public string IsPay { get; set; }
  1348. /// <summary>
  1349. /// 付款时间
  1350. /// </summary>
  1351. public string ConsumptionDate { get; set; }
  1352. public string Remark { get; set; }
  1353. /// <summary>
  1354. /// 操作人
  1355. /// </summary>
  1356. public string? Applicant { get; set; }
  1357. public DateTime CreateTime { get; set; }
  1358. }
  1359. /// <summary>
  1360. /// Excel 商邀费用View
  1361. /// </summary>
  1362. public class GroupOAFeeExcelView
  1363. {
  1364. public int IOAId { get; set; }
  1365. public int IOADiId { get; set; }
  1366. /// <summary>
  1367. /// 邀请方地区
  1368. /// </summary>
  1369. public string? InviterArea { get; set; }
  1370. /// <summary>
  1371. /// 邀请方
  1372. /// </summary>
  1373. public string? Inviter { get; set; }
  1374. /// <summary>
  1375. /// 邀请时间
  1376. /// </summary>
  1377. public string? InviteTime { get; set; }
  1378. /// <summary>
  1379. /// 邀请函费用
  1380. /// </summary>
  1381. public decimal InviteCost { get; set; } = 0.00M;
  1382. /// <summary>
  1383. /// 邀请函币种
  1384. /// </summary>
  1385. public string? InviteCurrency { get; set; }
  1386. /// <summary>
  1387. /// 快递费用
  1388. /// </summary>
  1389. public decimal SendCost { get; set; } = 0.00M;
  1390. /// <summary>
  1391. /// 快递币种
  1392. /// </summary>
  1393. public string? SendCurrency { get; set; }
  1394. /// <summary>
  1395. /// 活动费用
  1396. /// </summary>
  1397. public decimal EventsCost { get; set; } = 0.00M;
  1398. /// <summary>
  1399. /// 活动币种
  1400. /// </summary>
  1401. public string? EventsCurrency { get; set; }
  1402. /// <summary>
  1403. /// 翻译费用
  1404. /// </summary>
  1405. public decimal TranslateCost { get; set; } = 0.00M;
  1406. /// <summary>
  1407. /// 翻译币种
  1408. /// </summary>
  1409. public string? TranslateCurrency { get; set; }
  1410. /// <summary>
  1411. /// 付款金额
  1412. /// </summary>
  1413. public decimal PayMoney { get; set; } = 0.00M;
  1414. /// <summary>
  1415. /// 付款币种汇率
  1416. /// </summary>
  1417. public decimal DayRate { get; set; } = 0.0000M;
  1418. /// <summary>
  1419. /// 付款币种
  1420. /// </summary>
  1421. public string? PaymentCurrency { get; set; }
  1422. /// <summary>
  1423. /// 人民币费用
  1424. /// </summary>
  1425. public decimal CNYPrice { get; set; } = 0.00M;
  1426. /// <summary>
  1427. /// 收款方
  1428. /// </summary>
  1429. public string? Payee { get; set; }
  1430. /// <summary>
  1431. /// 消费日期
  1432. /// </summary>
  1433. public string ConsumptionDate { get; set; }
  1434. /// <summary>
  1435. /// 费用标识
  1436. /// </summary>
  1437. public string CostMark { get; set; }
  1438. /// <summary>
  1439. /// 支付标识
  1440. /// </summary>
  1441. public string IsPay { get; set; }
  1442. /// <summary>
  1443. /// 支付方式
  1444. /// </summary>
  1445. public string PaymentModes { get; set; }
  1446. /// <summary>
  1447. /// 备注
  1448. /// </summary>
  1449. public string Remark { get; set; }
  1450. /// <summary>
  1451. /// 审核时间
  1452. /// </summary>
  1453. public string? AuditGMDate { get; set; }
  1454. /// <summary>
  1455. /// 操作人
  1456. /// </summary>
  1457. public string? Applicant { get; set; }
  1458. public DateTime CreateTime { get; set; }
  1459. }
  1460. /// <summary>
  1461. /// Excel 机票费用View
  1462. /// </summary>
  1463. public class GroupAirTicketExcelView
  1464. {
  1465. public int AirId { get; set; }
  1466. public int AirDiId { get; set; }
  1467. /// <summary>
  1468. /// 航班号
  1469. /// </summary>
  1470. public string? FlightsCode { get; set; }
  1471. /// <summary>
  1472. /// 城市A-B
  1473. /// </summary>
  1474. public string? FlightsCity { get; set; }
  1475. /// <summary>
  1476. /// 舱位类型
  1477. /// </summary>
  1478. public string? AirTypeName { get; set; }
  1479. /// <summary>
  1480. /// 航班日期
  1481. /// </summary>
  1482. public string? FlightsDate { get; set; }
  1483. /// <summary>
  1484. /// 航班时间
  1485. /// </summary>
  1486. public string? FlightsTime { get; set; }
  1487. /// <summary>
  1488. /// 客户姓名
  1489. /// </summary>
  1490. public string? ClientName { get; set; }
  1491. /// <summary>
  1492. /// 客户人数
  1493. /// </summary>
  1494. public int ClientNum { get; set; }
  1495. /// <summary>
  1496. /// 费用描述
  1497. /// </summary>
  1498. public string PriceDescription { get; set; }
  1499. /// <summary>
  1500. /// 付款金额
  1501. /// </summary>
  1502. public decimal PayMoney { get; set; } = 0.00M;
  1503. /// <summary>
  1504. /// 当时汇率
  1505. /// </summary>
  1506. public decimal DayRate { get; set; } = 1.0000M;
  1507. /// <summary>
  1508. /// 付款币种
  1509. /// </summary>
  1510. public string? PayMoneyCurrency { get; set; }
  1511. /// <summary>
  1512. /// CNY 金额
  1513. /// </summary>
  1514. public decimal CNYPrice { get; set; } = 0.00M;
  1515. /// <summary>
  1516. /// 付款时间
  1517. /// </summary>
  1518. public string ConsumptionDate { get; set; }
  1519. /// <summary>
  1520. /// 收款方
  1521. /// </summary>
  1522. public string? Payee { get; set; }
  1523. /// <summary>
  1524. /// 费用标识
  1525. /// </summary>
  1526. public string CostMark { get; set; }
  1527. /// <summary>
  1528. /// 是否支付
  1529. /// </summary>
  1530. public string IsPay { get; set; }
  1531. /// <summary>
  1532. /// 支付方式
  1533. /// </summary>
  1534. public string? PaymentModes { get; set; }
  1535. /// <summary>
  1536. /// 卡类型
  1537. /// </summary>
  1538. public string? CardType { get; set; }
  1539. /// <summary>
  1540. /// 审核时间
  1541. /// </summary>
  1542. public string? AuditGMDate { get; set; }
  1543. /// <summary>
  1544. /// 操作人
  1545. /// </summary>
  1546. public string? Applicant { get; set; }
  1547. /// <summary>
  1548. /// 创建时间
  1549. /// </summary>
  1550. public DateTime CreateTime { get; set; }
  1551. /// <summary>
  1552. /// SetDataId
  1553. /// </summary>
  1554. public int CType { get; set; }
  1555. public string Remark { get; set; }
  1556. }
  1557. /// <summary>
  1558. /// Excel 保险费用View
  1559. /// </summary>
  1560. public class GroupInsureExcelView
  1561. {
  1562. public int InsuranceId { get; set; }
  1563. public int InsuranceDiId { get; set; }
  1564. /// <summary>
  1565. /// 客户名称
  1566. /// </summary>
  1567. public string? ClientName { get; set; }
  1568. /// <summary>
  1569. /// 付款金额
  1570. /// </summary>
  1571. public decimal PayMoney { get; set; } = 0.00M;
  1572. /// <summary>
  1573. /// 付款币种
  1574. /// </summary>
  1575. public string? PayMoneyCurrency { get; set; }
  1576. /// <summary>
  1577. /// 当时汇率
  1578. /// </summary>
  1579. public decimal DayRate { get; set; }
  1580. /// <summary>
  1581. /// 人民币金额
  1582. /// </summary>
  1583. public decimal CNYPrice { get; set; } = 0.00M;
  1584. /// <summary>
  1585. /// 付款时间
  1586. /// </summary>
  1587. public string ConsumptionDate { get; set; }
  1588. /// <summary>
  1589. /// 费用标识
  1590. /// </summary>
  1591. public string CostMark { get; set; }
  1592. /// <summary>
  1593. /// 审核时间
  1594. /// </summary>
  1595. public string? AuditGMDate { get; set; }
  1596. /// <summary>
  1597. /// 收款方
  1598. /// </summary>
  1599. public string? Payee { get; set; }
  1600. /// <summary>
  1601. /// 是否支付
  1602. /// </summary>
  1603. public string IsPay { get; set; }
  1604. /// <summary>
  1605. /// 支付方式
  1606. /// </summary>
  1607. public string? PaymentModes { get; set; }
  1608. /// <summary>
  1609. /// 操作人
  1610. /// </summary>
  1611. public string? Applicant { get; set; }
  1612. public DateTime CreateTime { get; set; }
  1613. public string Remark { get; set; }
  1614. }
  1615. /// <summary>
  1616. /// Excel 保险费用View
  1617. /// </summary>
  1618. public class GroupOtherFeeExcelView
  1619. {
  1620. public int DPId { get; set; }
  1621. public int DPDiId { get; set; }
  1622. /// <summary>
  1623. /// 费用名称
  1624. /// </summary>
  1625. public string? PriceName { get; set; }
  1626. /// <summary>
  1627. /// 付款金额
  1628. /// </summary>
  1629. public decimal PayMoney { get; set; } = 0.00M;
  1630. /// <summary>
  1631. /// 付款币种
  1632. /// </summary>
  1633. public string? PayMoneyCurrency { get; set; }
  1634. /// <summary>
  1635. /// 当时汇率
  1636. /// </summary>
  1637. public decimal DayRate { get; set; } = 1.0000M;
  1638. /// <summary>
  1639. /// 人民币金额
  1640. /// </summary>
  1641. public decimal CNYPrice { get; set; } = 0.00M;
  1642. /// <summary>
  1643. /// 付款时间
  1644. /// </summary>
  1645. public string? AuditGMDate { get; set; }
  1646. /// <summary>
  1647. /// 收款方
  1648. /// </summary>
  1649. public string? Payee { get; set; }
  1650. /// <summary>
  1651. /// 费用标识
  1652. /// </summary>
  1653. public string CostMark { get; set; }
  1654. /// <summary>
  1655. /// 支付方式
  1656. /// </summary>
  1657. public string? PaymentModes { get; set; }
  1658. /// <summary>
  1659. /// 是否支付
  1660. /// </summary>
  1661. public string IsPay { get; set; }
  1662. /// <summary>
  1663. /// 操作人
  1664. /// </summary>
  1665. public string? Applicant { get; set; }
  1666. public DateTime CreateTime { get; set; }
  1667. public string? Remark { get; set; }
  1668. }
  1669. /// <summary>
  1670. /// 操作人员提成View
  1671. /// </summary>
  1672. public class GroupRoyaltyFeeExcelView
  1673. {
  1674. public int GroupId { get; set; }
  1675. public string OverviewInfo { get; set; }
  1676. public string DetailedInfoExcelText { get; set; }
  1677. public decimal Amount { get; set; }
  1678. public string IsConfrimText { get; set; }
  1679. public string IsSeedText { get; set; }
  1680. public string RoyaltyUserName { get; set; }
  1681. public string CreateUserName { get; set; }
  1682. public DateTime CreateTime { get; set; }
  1683. }
  1684. #endregion
  1685. }