Grp_GroupCostParameter.cs 11 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330
  1. 
  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_GroupCostParameter")]
  13. public class Grp_GroupCostParameter: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 = "varchar(50)")]
  24. public string Currency { get; set; }
  25. /// <summary>
  26. /// 汇率
  27. /// </summary>
  28. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  29. public decimal Rate { get; set; }
  30. /// <summary>
  31. /// 税率
  32. /// </summary>
  33. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  34. public decimal Tax { get; set; }
  35. /// <summary>
  36. /// 房费预算
  37. /// </summary>
  38. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  39. public decimal FFYS { get; set; }
  40. /// <summary>
  41. /// 酒店系数
  42. /// </summary>
  43. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  44. public decimal HotelXS { get; set; }
  45. /// <summary>
  46. /// 经济舱成本
  47. /// </summary>
  48. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  49. public decimal JJCCB { get; set; }
  50. /// <summary>
  51. /// 经济舱系数
  52. /// </summary>
  53. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  54. public decimal JJCXS { get; set; }
  55. /// <summary>
  56. /// 经济舱人数
  57. /// </summary>
  58. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  59. public int JJCRS { get; set; }
  60. /// <summary>
  61. /// 公务舱成本
  62. /// </summary>
  63. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  64. public decimal GWCCB { get; set; }
  65. /// <summary>
  66. /// 公务舱系数
  67. /// </summary>
  68. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  69. public decimal GWCXS { get; set; }
  70. /// <summary>
  71. /// 公务舱人数
  72. /// </summary>
  73. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  74. public int GWCRS { get; set; }
  75. /// <summary>
  76. /// 火车票成本
  77. /// </summary>
  78. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  79. public decimal HCPCB { get; set; }
  80. /// <summary>
  81. /// 火车票系数
  82. /// </summary>
  83. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  84. public decimal HCPXS { get; set; }
  85. /// <summary>
  86. /// 火车票人数
  87. /// </summary>
  88. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  89. public int HCPRS { get; set; }
  90. /// <summary>
  91. /// 船票成本
  92. /// </summary>
  93. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  94. public decimal CPCB { get; set; }
  95. /// <summary>
  96. /// 船票系数
  97. /// </summary>
  98. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  99. public decimal CPXS { get; set; }
  100. /// <summary>
  101. /// 船票人数
  102. /// </summary>
  103. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  104. public int CPRS { get; set; }
  105. /// <summary>
  106. /// 保险成本
  107. /// </summary>
  108. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  109. public decimal BXCB { get; set; }
  110. /// <summary>
  111. /// 保险系数
  112. /// </summary>
  113. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  114. public decimal BXXS { get; set; }
  115. /// <summary>
  116. /// 保险人数
  117. /// </summary>
  118. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  119. public int BXRS { get; set; }
  120. /// <summary>
  121. /// 核酸检测成本
  122. /// </summary>
  123. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  124. public decimal HSCB { get; set; }
  125. /// <summary>
  126. /// 核酸检测系数
  127. /// </summary>
  128. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  129. public decimal HSXS { get; set; }
  130. /// <summary>
  131. /// 核酸检测人数
  132. /// </summary>
  133. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  134. public int HSRS { get; set; }
  135. /// <summary>
  136. /// 签证成本
  137. /// </summary>
  138. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  139. public decimal VisaCB { get; set; }
  140. /// <summary>
  141. /// 签证系数
  142. /// </summary>
  143. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  144. public decimal VisaXS { get; set; }
  145. /// <summary>
  146. /// 签证人数
  147. /// </summary>
  148. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  149. public int VisaRS { get; set; }
  150. /// <summary>
  151. /// 公务成本 : 公杂费
  152. /// </summary>
  153. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  154. public decimal GWCB { get; set; }
  155. /// <summary>
  156. /// 公务系数: 公杂费
  157. /// </summary>
  158. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  159. public decimal GWXS { get; set; }
  160. /// <summary>
  161. /// 公务人数 : 公杂费
  162. /// </summary>
  163. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  164. public int GWRS { get; set; }
  165. /// <summary>
  166. /// 地接成本
  167. /// </summary>
  168. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  169. public decimal DJCB { get; set; }
  170. /// <summary>
  171. /// 地接人数
  172. /// </summary>
  173. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  174. public int DJRS { get; set; }
  175. /// <summary>
  176. /// 地接系数
  177. /// </summary>
  178. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  179. public decimal DJXS { get; set; }
  180. /// <summary>
  181. /// 单间 单人成本
  182. /// </summary>
  183. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  184. public decimal SGRCB { get; set; }
  185. /// <summary>
  186. /// 单间数量(人数)
  187. /// </summary>
  188. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  189. public int SGRNumber { get; set; }
  190. /// <summary>
  191. /// 单间 系数
  192. /// </summary>
  193. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  194. public decimal SGRXS { get; set; }
  195. /// <summary>
  196. /// 1/2标间 单人成本
  197. /// </summary>
  198. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  199. public decimal TBRCB { get; set; }
  200. /// <summary>
  201. /// 1/2标间数量(人数)
  202. /// </summary>
  203. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  204. public int TBRNumber { get; set; }
  205. /// <summary>
  206. /// 1/2标间 系数
  207. /// </summary>
  208. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  209. public decimal TBRXS { get; set; }
  210. /// <summary>
  211. /// 小套房/豪华套房 单人成本
  212. /// </summary>
  213. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  214. public decimal JSESCB { get; set; }
  215. /// <summary>
  216. /// 小套房/豪华套房数量(人数)
  217. /// </summary>
  218. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  219. public int JSESNumber { get; set; }
  220. /// <summary>
  221. /// 小套房/豪华套房 系数
  222. /// </summary>
  223. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  224. public decimal JSESXS { get; set; }
  225. /// <summary>
  226. /// 套房 单人成本
  227. /// </summary>
  228. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  229. public decimal SUITECB { get; set; }
  230. /// <summary>
  231. /// 套房数量(人数)
  232. /// </summary>
  233. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  234. public int SUITENumber { get; set; }
  235. /// <summary>
  236. /// 套房 系数
  237. /// </summary>
  238. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  239. public decimal SUITEXS { get; set; }
  240. /// <summary>
  241. /// 零用金成本
  242. /// </summary>
  243. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  244. public decimal LYJCB { get; set; }
  245. /// <summary>
  246. /// 零用金系数
  247. /// </summary>
  248. [SugarColumn(IsNullable = true, ColumnDataType = "decimal(10,2)")]
  249. public decimal LYJXS { get; set; }
  250. /// <summary>
  251. /// 零用金人数
  252. /// </summary>
  253. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  254. public int LYJRS { get; set; }
  255. /// <summary>
  256. /// 成本完成标识 0:未完成 1:完成
  257. /// </summary>
  258. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  259. public int IsShare { get; set; }
  260. /// <summary>
  261. /// 分段类型 A B
  262. /// </summary>
  263. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  264. public string CostType { get; set; }
  265. /// <summary>
  266. /// 开始时间
  267. /// </summary>
  268. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  269. public string CostTypeStartTime { get; set; }
  270. /// <summary>
  271. /// 结束时间
  272. /// </summary>
  273. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  274. public string CostTypeendTime { get; set; }
  275. /// <summary>
  276. /// 此段人数
  277. /// </summary>
  278. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  279. public int CostTypenumber { get; set; }
  280. /// <summary>
  281. /// 头等舱成本
  282. /// </summary>
  283. public decimal TDCCB { get; set; }
  284. /// <summary>
  285. /// 头等舱系数
  286. /// </summary>
  287. public decimal TDCXS { get; set; }
  288. /// <summary>
  289. /// 头等舱人数
  290. /// </summary>
  291. public int TDCRS { get; set; }
  292. }
  293. public class Grp_GroupCostParameterView: Grp_GroupCostParameter
  294. {
  295. }
  296. }