Grp_EnterExitCost.cs 7.4 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248
  1. using OASystem.Domain.Enums;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.Linq;
  5. using System.Text;
  6. using System.Threading.Tasks;
  7. namespace OASystem.Domain.Entities.Groups
  8. {
  9. /// <summary>
  10. /// 团组 - 出入境费用
  11. /// </summary>
  12. [SugarTable("Grp_EnterExitCost")]
  13. public class Grp_EnterExitCost : EntityBase
  14. {
  15. /// <summary>
  16. /// 团组Id
  17. /// </summary>
  18. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  19. public int DiId { get; set; }
  20. /// <summary>
  21. /// 境内费用(其他费用)
  22. /// </summary>
  23. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  24. public decimal InsidePay { get; set; }
  25. #region 境内费用(其他费用)子项
  26. /// <summary>
  27. /// 签证费
  28. /// </summary>
  29. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  30. public decimal Visa { get; set; }
  31. /// <summary>
  32. /// 签证费描述
  33. /// </summary>
  34. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  35. public string? VisaRemark { get; set; }
  36. /// <summary>
  37. /// 疫苗费
  38. /// </summary>
  39. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  40. public decimal YiMiao { get; set; }
  41. /// <summary>
  42. /// 核酸检测费用
  43. /// </summary>
  44. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  45. public decimal HeSuan { get; set; }
  46. /// <summary>
  47. /// 服务费用
  48. /// </summary>
  49. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  50. public decimal Service { get; set; }
  51. /// <summary>
  52. /// 参展门票
  53. /// </summary>
  54. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  55. public decimal Ticket { get; set; }
  56. /// <summary>
  57. /// 保险费
  58. /// </summary>
  59. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  60. public decimal Safe { get; set; }
  61. #endregion
  62. /// <summary>
  63. /// 国际旅费合计(经济舱)
  64. /// </summary>
  65. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  66. public decimal OutsideJJPay { get; set; }
  67. /// <summary>
  68. /// 国际旅费合计(公务舱)
  69. /// </summary>
  70. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  71. public decimal OutsideGWPay { get; set; }
  72. /// <summary>
  73. /// 国际旅费合计(头等舱)
  74. /// </summary>
  75. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  76. public decimal OutsideTDPay { get; set; }
  77. #region 国际旅费合计(经济舱\公务舱\头等舱)
  78. /// <summary>
  79. /// 国际机票(经济舱)
  80. /// </summary>
  81. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  82. public decimal AirJJ { get; set; }
  83. /// <summary>
  84. /// 国际机票(公务舱)
  85. /// </summary>
  86. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  87. public decimal AirGW { get; set; }
  88. /// <summary>
  89. /// 国际机票(头等舱)
  90. /// </summary>
  91. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  92. public decimal AirTD { get; set; }
  93. /// <summary>
  94. /// 国外城市间交通费
  95. /// </summary>
  96. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  97. public decimal CityTranffic { get; set; }
  98. #region 汇率币种
  99. /// <summary>
  100. /// 美元
  101. /// </summary>
  102. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,4)")]
  103. public decimal RateUSD { get; set; }
  104. /// <summary>
  105. /// 日元
  106. /// </summary>
  107. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,4)")]
  108. public decimal RateJPY { get; set; }
  109. /// <summary>
  110. /// 欧元
  111. /// </summary>
  112. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,4)")]
  113. public decimal RateEUR { get; set; }
  114. /// <summary>
  115. /// 英镑
  116. /// </summary>
  117. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,4)")]
  118. public decimal RateGBP { get; set; }
  119. /// <summary>
  120. /// 港币
  121. /// </summary>
  122. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,4)")]
  123. public decimal RateHKD { get; set; }
  124. /// <summary>
  125. /// 多个币种存储
  126. /// 存储方式: 美元(USD):6.2350|.......|墨西哥比索(MXN):1.0000
  127. /// </summary>
  128. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  129. public string? CurrencyRemark { get; set; }
  130. #endregion
  131. #endregion
  132. #region 选择框状态
  133. /// <summary>
  134. /// 境内费用(其他费用)选择框
  135. /// </summary>
  136. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  137. public int ChoiceOne { get; set; }
  138. /// <summary>
  139. /// 国际旅费合计选择框
  140. /// </summary>
  141. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  142. public int ChoiceTwo { get; set; }
  143. /// <summary>
  144. /// 经济舱小计选择框
  145. /// </summary>
  146. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  147. public int SumJJC { get; set; }
  148. /// <summary>
  149. /// 公务舱小计选择框
  150. /// </summary>
  151. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  152. public int SumGWC { get; set; }
  153. /// <summary>
  154. /// 头等舱小计选择框
  155. /// </summary>
  156. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  157. public int SumTDC { get; set; }
  158. /// <summary>
  159. /// 住宿费合计选择框
  160. /// </summary>
  161. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  162. public int ChoiceThree { get; set; }
  163. /// <summary>
  164. /// 伙食费合计选择框
  165. /// </summary>
  166. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  167. public int ChoiceFour { get; set; }
  168. /// <summary>
  169. /// 公杂费合计选择框
  170. /// </summary>
  171. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  172. public int ChoiceFive { get; set; }
  173. /// <summary>
  174. /// 境内费用(其他费用)选择框
  175. /// </summary>
  176. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  177. public int ChoiceSix { get; set; }
  178. /// <summary>
  179. /// 经济舱选择框
  180. /// </summary>
  181. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  182. public int AirJJC_Checked { get; set; }
  183. /// <summary>
  184. /// 公务舱选择框
  185. /// </summary>
  186. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  187. public int AirGWC_Checked { get; set; }
  188. /// <summary>
  189. /// 头等舱选择框
  190. /// </summary>
  191. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  192. public int AirTDC_Checked { get; set; }
  193. #endregion
  194. /// <summary>
  195. /// 确认费用(确认费用后 不可更改)
  196. /// 1:未确认 2:已确认
  197. /// </summary>
  198. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  199. public int IsConfirm { get; set; } = 1;
  200. }
  201. }