Grp_HotelReservations.cs 9.0 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248
  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. /// </summary>
  67. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  68. public string HotelFax { get; set; }
  69. /// <summary>
  70. /// 客人姓名
  71. /// </summary>
  72. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  73. public string GuestName { get; set; }
  74. /// <summary>
  75. /// 入住日期
  76. /// </summary>
  77. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(80)")]
  78. public string CheckInDate { get; set; }
  79. /// <summary>
  80. /// 退房日期
  81. /// </summary>
  82. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(80)")]
  83. public string CheckOutDate { get; set; }
  84. /// <summary>
  85. /// 预算金额
  86. /// </summary>
  87. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  88. public decimal Budget { get; set; }
  89. /// <summary>
  90. /// 预算币种(设置数据外键编号)
  91. /// </summary>
  92. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  93. public int BudgetCurrency { get; set; }
  94. /// <summary>
  95. /// 单间数量
  96. /// </summary>
  97. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  98. public int SingleRoomCount { get; set; }
  99. /// <summary>
  100. /// 单间单价
  101. /// </summary>
  102. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  103. public decimal SingleRoomPrice { get; set; }
  104. /// <summary>
  105. /// 双间数量
  106. /// </summary>
  107. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  108. public int DoubleRoomCount { get; set; }
  109. /// <summary>
  110. /// 双间单价
  111. /// </summary>
  112. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  113. public decimal DoubleRoomPrice { get; set; }
  114. /// <summary>
  115. /// 套房数量
  116. /// </summary>
  117. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  118. public int SuiteRoomCount { get; set; }
  119. /// <summary>
  120. /// 套房单价
  121. /// </summary>
  122. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  123. public decimal SuiteRoomPrice { get; set; }
  124. /// <summary>
  125. /// 其他房型数量
  126. /// </summary>
  127. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  128. public int OtherRoomCount { get; set; }
  129. /// <summary>
  130. /// 其他房型单价
  131. /// </summary>
  132. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  133. public decimal OtherRoomPrice { get; set; }
  134. /// <summary>
  135. /// 佣金
  136. /// </summary>
  137. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  138. public decimal Commission { get; set; }
  139. /// <summary>
  140. /// 佣金币种(设置数据外键编号)
  141. /// </summary>
  142. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  143. public int CommissionCurrency { get; set; }
  144. /// <summary>
  145. /// 佣金标识
  146. /// </summary>
  147. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  148. public int CommissionMark { get; set; }
  149. /// <summary>
  150. /// 房间说明
  151. /// </summary>
  152. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  153. public string RoomExplanation { get; set; }
  154. /// <summary>
  155. /// 附件地址
  156. /// </summary>
  157. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  158. public string Attachment { get; set; }
  159. /// <summary>
  160. /// 信用卡金额
  161. /// </summary>
  162. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  163. public decimal CardPrice { get; set; }
  164. /// <summary>
  165. /// 确认标识 信用卡金额
  166. /// 0:未刷(红色) 1:已刷(绿色)
  167. /// </summary>
  168. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  169. public int IsCardPrice { get; set; }
  170. /// <summary>
  171. /// 早饭费
  172. /// </summary>
  173. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  174. public decimal BreakfastPrice { get; set; }
  175. /// <summary>
  176. /// 由地接支付
  177. /// </summary>
  178. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  179. public int Isoppay { get; set; }
  180. /// <summary>
  181. /// 是否有单间
  182. /// </summary>
  183. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  184. public int CboOne { get; set; }
  185. /// <summary>
  186. /// 是否有双间
  187. /// </summary>
  188. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  189. public int CboTwo { get; set; }
  190. /// <summary>
  191. /// 是否有酒店套房
  192. /// </summary>
  193. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  194. public int CboThree { get; set; }
  195. /// <summary>
  196. /// 是否有其他房型
  197. /// </summary>
  198. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  199. public int CboFour { get; set; }
  200. /// <summary>
  201. /// 预计单间数量
  202. /// </summary>
  203. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  204. public int PredictSingleRoom { get; set; }
  205. /// <summary>
  206. /// 预计双人间数量
  207. /// </summary>
  208. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  209. public int PredictDoubleRoom { get; set; }
  210. /// <summary>
  211. /// 预计套房数量
  212. /// </summary>
  213. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  214. public int PredictSuiteRoom { get; set; }
  215. /// <summary>
  216. /// 预计其他间数量
  217. /// </summary>
  218. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  219. public int PredictOtherRoom { get; set; }
  220. /// <summary>
  221. /// 地税
  222. /// </summary>
  223. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  224. public decimal GovernmentRent { get; set; }
  225. /// <summary>
  226. /// 地税币种
  227. /// </summary>
  228. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  229. public int GovernmentRentCurrency { get; set; }
  230. /// <summary>
  231. /// 城市税
  232. /// </summary>
  233. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(18,2)")]
  234. public decimal CityTax { get; set; }
  235. /// <summary>
  236. /// 城市税币种
  237. /// </summary>
  238. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  239. public int CityTaxCurrency { get; set; }
  240. /// <summary>
  241. /// 房间入住人类型
  242. /// </summary>
  243. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  244. public string CheckType { get; set; }
  245. }
  246. }