Grp_HotelReservations.cs 10 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. namespace OASystem.Domain.Entities.Groups
  7. {
  8. /// <summary>
  9. /// 酒店预定费用表
  10. /// </summary>
  11. [SugarTable("Grp_HotelReservations")]
  12. public class Grp_HotelReservations:EntityBase
  13. {
  14. /// <summary>
  15. /// 团组Id
  16. /// </summary>
  17. [SugarColumn(IsNullable =true,ColumnDataType ="int")]
  18. public int DiId { get; set; }
  19. /// <summary>
  20. /// 客人类型(设置数据外键编号)
  21. /// </summary>
  22. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  23. public int GTId { get; set; }
  24. /// <summary>
  25. /// 入住卷号码
  26. /// </summary>
  27. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  28. public string CheckNumber { get; set; }
  29. /// <summary>
  30. /// 预订网站(设置数据外键编号)
  31. /// </summary>
  32. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  33. public int ReservationsWebsite { get; set; }
  34. /// <summary>
  35. /// 预订号码
  36. /// </summary>
  37. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  38. public string ReservationsNo { get; set; }
  39. /// <summary>
  40. /// 酒店确定编号
  41. /// </summary>
  42. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  43. public string DetermineNo { get; set; }
  44. /// <summary>
  45. /// 所在城市
  46. /// </summary>
  47. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  48. public string City { get; set; }
  49. /// <summary>
  50. /// 酒店名称
  51. /// </summary>
  52. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  53. public string HotelName { get; set; }
  54. /// <summary>
  55. /// 酒店地址
  56. /// </summary>
  57. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  58. public string HotelAddress { get; set; }
  59. /// <summary>
  60. /// 酒店电话
  61. /// </summary>
  62. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  63. public string HotelTel { get; set; }
  64. /// <summary>
  65. /// 酒店传真
  66. /// 弃用 弃用时间 2023-12-28 17:30
  67. /// </summary>
  68. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  69. public string HotelFax { get; set; }
  70. /// <summary>
  71. /// 客人姓名
  72. /// </summary>
  73. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  74. public string GuestName { get; set; }
  75. /// <summary>
  76. /// 入住日期
  77. /// </summary>
  78. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(80)")]
  79. public string CheckInDate { get; set; }
  80. /// <summary>
  81. /// 退房日期
  82. /// </summary>
  83. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(80)")]
  84. public string CheckOutDate { get; set; }
  85. /// <summary>
  86. /// 预算金额
  87. /// 弃用 弃用时间 2023-12-28 17:30
  88. /// </summary>
  89. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  90. public decimal Budget { get; set; }
  91. /// <summary>
  92. /// 预算币种(设置数据外键编号)
  93. /// 弃用 弃用时间 2023-12-28 17:30
  94. /// </summary>
  95. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  96. public int BudgetCurrency { get; set; }
  97. /// <summary>
  98. /// 单间数量
  99. /// </summary>
  100. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  101. public int SingleRoomCount { get; set; }
  102. /// <summary>
  103. /// 单间单价
  104. /// </summary>
  105. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  106. public decimal SingleRoomPrice { get; set; }
  107. /// <summary>
  108. /// 双间数量
  109. /// </summary>
  110. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  111. public int DoubleRoomCount { get; set; }
  112. /// <summary>
  113. /// 双间单价
  114. /// </summary>
  115. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  116. public decimal DoubleRoomPrice { get; set; }
  117. /// <summary>
  118. /// 套房数量
  119. /// </summary>
  120. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  121. public int SuiteRoomCount { get; set; }
  122. /// <summary>
  123. /// 套房单价
  124. /// </summary>
  125. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  126. public decimal SuiteRoomPrice { get; set; }
  127. /// <summary>
  128. /// 其他房型数量
  129. /// </summary>
  130. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  131. public int OtherRoomCount { get; set; }
  132. /// <summary>
  133. /// 其他房型单价
  134. /// </summary>
  135. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  136. public decimal OtherRoomPrice { get; set; }
  137. /// <summary>
  138. /// 佣金
  139. /// 弃用 弃用时间 2023-12-28 17:30
  140. /// </summary>
  141. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  142. public decimal Commission { get; set; }
  143. /// <summary>
  144. /// 佣金币种(设置数据外键编号)
  145. /// 弃用 弃用时间 2023-12-28 17:30
  146. /// </summary>
  147. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  148. public int CommissionCurrency { get; set; }
  149. /// <summary>
  150. /// 佣金标识
  151. /// 弃用 弃用时间 2023-12-28 17:30
  152. /// </summary>
  153. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  154. public int CommissionMark { get; set; }
  155. /// <summary>
  156. /// 房间说明
  157. /// </summary>
  158. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  159. public string RoomExplanation { get; set; }
  160. /// <summary>
  161. /// 附件地址
  162. /// 弃用 弃用时间 2023-12-28 17:30
  163. /// </summary>
  164. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  165. public string Attachment { get; set; }
  166. /// <summary>
  167. /// 信用卡金额
  168. /// </summary>
  169. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  170. public decimal CardPrice { get; set; }
  171. /// <summary>
  172. /// 信用卡刷卡类型
  173. /// </summary>
  174. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  175. public int CardPriceCurrency { get; set; }
  176. /// <summary>
  177. /// 确认标识 信用卡金额
  178. /// 0:未刷(红色) 1:已刷(绿色)
  179. /// 弃用 弃用时间 2023-12-28 17:30
  180. /// </summary>
  181. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  182. public int IsCardPrice { get; set; }
  183. /// <summary>
  184. /// 早餐费
  185. /// </summary>
  186. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  187. public decimal BreakfastPrice { get; set; }
  188. /// <summary>
  189. /// 早餐费 币种
  190. /// </summary>
  191. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  192. public decimal BreakfastCurrency { get; set; }
  193. /// <summary>
  194. /// 由地接支付
  195. /// </summary>
  196. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  197. public int Isoppay { get; set; }
  198. /// <summary>
  199. /// 是否有单间
  200. /// 弃用 弃用时间 2023-12-28 17:30
  201. /// </summary>
  202. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  203. public int CboOne { get; set; }
  204. /// <summary>
  205. /// 是否有双间
  206. /// 弃用 弃用时间 2023-12-28 17:30
  207. /// </summary>
  208. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  209. public int CboTwo { get; set; }
  210. /// <summary>
  211. /// 是否有酒店套房
  212. /// 弃用 弃用时间 2023-12-28 17:30
  213. /// </summary>
  214. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  215. public int CboThree { get; set; }
  216. /// <summary>
  217. /// 是否有其他房型
  218. /// 弃用 弃用时间 2023-12-28 17:30
  219. /// </summary>
  220. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  221. public int CboFour { get; set; }
  222. /// <summary>
  223. /// 预计单间数量
  224. /// 弃用 弃用时间 2023-12-28 17:30
  225. /// </summary>
  226. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  227. public int PredictSingleRoom { get; set; }
  228. /// <summary>
  229. /// 预计双人间数量
  230. /// 弃用 弃用时间 2023-12-28 17:30
  231. /// </summary>
  232. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  233. public int PredictDoubleRoom { get; set; }
  234. /// <summary>
  235. /// 预计套房数量
  236. /// 弃用 弃用时间 2023-12-28 17:30
  237. /// </summary>
  238. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  239. public int PredictSuiteRoom { get; set; }
  240. /// <summary>
  241. /// 预计其他间数量
  242. /// 弃用 弃用时间 2023-12-28 17:30
  243. /// </summary>
  244. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  245. public int PredictOtherRoom { get; set; }
  246. /// <summary>
  247. /// 地税
  248. /// </summary>
  249. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  250. public decimal GovernmentRent { get; set; }
  251. /// <summary>
  252. /// 地税币种
  253. /// </summary>
  254. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  255. public int GovernmentRentCurrency { get; set; }
  256. /// <summary>
  257. /// 城市税
  258. /// </summary>
  259. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  260. public decimal CityTax { get; set; }
  261. /// <summary>
  262. /// 城市税币种
  263. /// </summary>
  264. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  265. public int CityTaxCurrency { get; set; }
  266. /// <summary>
  267. /// 房间入住人类型
  268. /// </summary>
  269. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  270. public int CheckType { get; set; }
  271. }
  272. }