OA2014DB.cs 13 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606
  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.ViewModels
  7. {
  8. public class OA2014DB
  9. {
  10. }
  11. public class OA2014_Visa
  12. {
  13. int id;
  14. /// <summary>
  15. /// 主键编号
  16. /// </summary>
  17. public int Id
  18. {
  19. get { return id; }
  20. set { id = value; }
  21. }
  22. int dIId;
  23. /// <summary>
  24. /// 团组外键编号
  25. /// </summary>
  26. public int DIId
  27. {
  28. get { return dIId; }
  29. set { dIId = value; }
  30. }
  31. string visaClient;
  32. /// <summary>
  33. /// 签证客户
  34. /// </summary>
  35. public string VisaClient
  36. {
  37. get { return visaClient; }
  38. set { visaClient = value; }
  39. }
  40. float visaPrice;
  41. /// <summary>
  42. /// 签证费用
  43. /// </summary>
  44. public float VisaPrice
  45. {
  46. get { return visaPrice; }
  47. set { visaPrice = value; }
  48. }
  49. int visaCurrency;
  50. /// <summary>
  51. /// 币种
  52. /// </summary>
  53. public int VisaCurrency
  54. {
  55. get { return visaCurrency; }
  56. set { visaCurrency = value; }
  57. }
  58. /// <summary>
  59. /// 是否第三方支付
  60. /// </summary>
  61. public int IsThird { get; set; }
  62. string visaAttachment;
  63. /// <summary>
  64. /// 签证附件
  65. /// </summary>
  66. public string VisaAttachment
  67. {
  68. get { return visaAttachment; }
  69. set { visaAttachment = value; }
  70. }
  71. string remark;
  72. /// <summary>
  73. /// 备注
  74. /// </summary>
  75. public string Remark
  76. {
  77. get { return remark; }
  78. set { remark = value; }
  79. }
  80. int operators;
  81. /// <summary>
  82. /// 操作人
  83. /// </summary>
  84. public int Operators
  85. {
  86. get { return operators; }
  87. set { operators = value; }
  88. }
  89. string operatorsDate;
  90. /// <summary>
  91. /// 操作时间
  92. /// </summary>
  93. public string OperatorsDate
  94. {
  95. get { return operatorsDate; }
  96. set { operatorsDate = value; }
  97. }
  98. int isDel;
  99. /// <summary>
  100. /// 删除标识
  101. /// </summary>
  102. public int IsDel
  103. {
  104. get { return isDel; }
  105. set { isDel = value; }
  106. }
  107. public string IsAuditGM { get; set; }
  108. /// <summary>
  109. /// 签字人员类型
  110. /// </summary>
  111. public string PassengerType { get; set; }
  112. /// <summary>
  113. /// 办理签证人数
  114. /// </summary>
  115. public int VisaNumber { get; set; }
  116. /// <summary>
  117. /// 免签人数
  118. /// </summary>
  119. public int VisaFreeNumber { get; set; }
  120. }
  121. public class OA2014_CreditCardPayment
  122. {
  123. int id;
  124. /// <summary>
  125. /// 主键编号
  126. /// </summary>
  127. public int Id
  128. {
  129. get { return id; }
  130. set { id = value; }
  131. }
  132. int payDId;
  133. /// <summary>
  134. /// 支付方式(设置数据外键编号)
  135. /// </summary>
  136. public int PayDId
  137. {
  138. get { return payDId; }
  139. set { payDId = value; }
  140. }
  141. string consumptionPatterns;
  142. /// <summary>
  143. /// 消费方式
  144. /// </summary>
  145. public string ConsumptionPatterns
  146. {
  147. get { return consumptionPatterns; }
  148. set { consumptionPatterns = value; }
  149. }
  150. string consumptionDate;
  151. /// <summary>
  152. /// 消费日期
  153. /// </summary>
  154. public string ConsumptionDate
  155. {
  156. get { return consumptionDate; }
  157. set { consumptionDate = value; }
  158. }
  159. int cTDId;
  160. /// <summary>
  161. /// 卡类型
  162. /// </summary>
  163. public int CTDId
  164. {
  165. get { return cTDId; }
  166. set { cTDId = value; }
  167. }
  168. string bankNo;
  169. /// <summary>
  170. /// 银行卡号
  171. /// </summary>
  172. public string BankNo
  173. {
  174. get { return bankNo; }
  175. set { bankNo = value; }
  176. }
  177. string cardholderName;
  178. /// <summary>
  179. /// 持卡人姓名
  180. /// </summary>
  181. public string CardholderName
  182. {
  183. get { return cardholderName; }
  184. set { cardholderName = value; }
  185. }
  186. float payMoney;
  187. /// <summary>
  188. /// 付款金额
  189. /// </summary>
  190. public float PayMoney
  191. {
  192. get { return payMoney; }
  193. set { payMoney = value; }
  194. }
  195. int paymentCurrency;
  196. /// <summary>
  197. /// 付款币种
  198. /// </summary>
  199. public int PaymentCurrency
  200. {
  201. get { return paymentCurrency; }
  202. set { paymentCurrency = value; }
  203. }
  204. string dayRate;
  205. /// <summary>
  206. /// 当天汇率
  207. /// </summary>
  208. public string DayRate
  209. {
  210. get { return dayRate; }
  211. set { dayRate = value; }
  212. }
  213. string companyBankNo;
  214. /// <summary>
  215. /// 公司银行卡号
  216. /// </summary>
  217. public string CompanyBankNo
  218. {
  219. get { return companyBankNo; }
  220. set { companyBankNo = value; }
  221. }
  222. string otherBankName;
  223. /// <summary>
  224. /// 对方开户行
  225. /// </summary>
  226. public string OtherBankName
  227. {
  228. get { return otherBankName; }
  229. set { otherBankName = value; }
  230. }
  231. string otherSideNo;
  232. /// <summary>
  233. /// 对方银行账号
  234. /// </summary>
  235. public string OtherSideNo
  236. {
  237. get { return otherSideNo; }
  238. set { otherSideNo = value; }
  239. }
  240. string otherSideName;
  241. /// <summary>
  242. /// 对方姓名
  243. /// </summary>
  244. public string OtherSideName
  245. {
  246. get { return otherSideName; }
  247. set { otherSideName = value; }
  248. }
  249. string remark;
  250. /// <summary>
  251. /// 备注
  252. /// </summary>
  253. public string Remark
  254. {
  255. get { return remark; }
  256. set { remark = value; }
  257. }
  258. int operators;
  259. /// <summary>
  260. /// 操作人
  261. /// </summary>
  262. public int Operators
  263. {
  264. get { return operators; }
  265. set { operators = value; }
  266. }
  267. string operatorsDate;
  268. /// <summary>
  269. /// 操作时间
  270. /// </summary>
  271. public string OperatorsDate
  272. {
  273. get { return operatorsDate; }
  274. set { operatorsDate = value; }
  275. }
  276. int mFOperators;
  277. /// <summary>
  278. /// 财务操作人
  279. /// </summary>
  280. public int MFOperators
  281. {
  282. get { return mFOperators; }
  283. set { mFOperators = value; }
  284. }
  285. string mFOperatorsDate;
  286. /// <summary>
  287. /// 财务操作时间
  288. /// </summary>
  289. public string MFOperatorsDate
  290. {
  291. get { return mFOperatorsDate; }
  292. set { mFOperatorsDate = value; }
  293. }
  294. int isAuditDM;
  295. /// <summary>
  296. /// 部门经理是否审核
  297. /// </summary>
  298. public int IsAuditDM
  299. {
  300. get { return isAuditDM; }
  301. set { isAuditDM = value; }
  302. }
  303. int auditDMOperate;
  304. /// <summary>
  305. /// 部门经理审核人
  306. /// </summary>
  307. public int AuditDMOperate
  308. {
  309. get { return auditDMOperate; }
  310. set { auditDMOperate = value; }
  311. }
  312. string auditDMDate;
  313. /// <summary>
  314. /// 部门经理审核时间
  315. /// </summary>
  316. public string AuditDMDate
  317. {
  318. get { return auditDMDate; }
  319. set { auditDMDate = value; }
  320. }
  321. int isAuditMF;
  322. /// <summary>
  323. /// 财务部是否审核
  324. /// </summary>
  325. public int IsAuditMF
  326. {
  327. get { return isAuditMF; }
  328. set { isAuditMF = value; }
  329. }
  330. int auditMFOperate;
  331. /// <summary>
  332. /// 财务部审核人
  333. /// </summary>
  334. public int AuditMFOperate
  335. {
  336. get { return auditMFOperate; }
  337. set { auditMFOperate = value; }
  338. }
  339. string auditMFDate;
  340. /// <summary>
  341. /// 财务部审核时间
  342. /// </summary>
  343. public string AuditMFDate
  344. {
  345. get { return auditMFDate; }
  346. set { auditMFDate = value; }
  347. }
  348. int isAuditGM;
  349. /// <summary>
  350. /// 总经理是否审核
  351. /// </summary>
  352. public int IsAuditGM
  353. {
  354. get { return isAuditGM; }
  355. set { isAuditGM = value; }
  356. }
  357. int auditGMOperate;
  358. /// <summary>
  359. /// 总经理审核人
  360. /// </summary>
  361. public int AuditGMOperate
  362. {
  363. get { return auditGMOperate; }
  364. set { auditGMOperate = value; }
  365. }
  366. string auditGMDate;
  367. /// <summary>
  368. /// 总经理审核时间
  369. /// </summary>
  370. public string AuditGMDate
  371. {
  372. get { return auditGMDate; }
  373. set { auditGMDate = value; }
  374. }
  375. int isPay;
  376. /// <summary>
  377. /// 是否付款
  378. /// </summary>
  379. public int IsPay
  380. {
  381. get { return isPay; }
  382. set { isPay = value; }
  383. }
  384. int dIId;
  385. /// <summary>
  386. /// 团组外键编号
  387. /// </summary>
  388. public int DIId
  389. {
  390. get { return dIId; }
  391. set { dIId = value; }
  392. }
  393. int cId;
  394. /// <summary>
  395. /// 指向表外键编号
  396. /// </summary>
  397. public int CId
  398. {
  399. get { return cId; }
  400. set { cId = value; }
  401. }
  402. int cTable;
  403. /// <summary>
  404. /// 指向标识(设置数据外键编号)
  405. /// </summary>
  406. public int CTable
  407. {
  408. get { return cTable; }
  409. set { cTable = value; }
  410. }
  411. int isDel;
  412. /// <summary>
  413. /// 删除标识
  414. /// </summary>
  415. public int IsDel
  416. {
  417. get { return isDel; }
  418. set { isDel = value; }
  419. }
  420. string payPercentage;
  421. /// <summary>
  422. /// 此次付款百分比
  423. /// </summary>
  424. public string PayPercentage
  425. {
  426. get { return payPercentage; }
  427. set { payPercentage = value; }
  428. }
  429. string payThenMoney;
  430. /// <summary>
  431. /// 此次付款金额
  432. /// </summary>
  433. public string PayThenMoney
  434. {
  435. get { return payThenMoney; }
  436. set { payThenMoney = value; }
  437. }
  438. string payPercentageOld;
  439. /// <summary>
  440. /// 上次付款百分比
  441. /// </summary>
  442. public string PayPercentageOld
  443. {
  444. get { return payPercentageOld; }
  445. set { payPercentageOld = value; }
  446. }
  447. string payThenMoneyOld;
  448. /// <summary>
  449. /// 上次付款金额
  450. /// </summary>
  451. public string PayThenMoneyOld
  452. {
  453. get { return payThenMoneyOld; }
  454. set { payThenMoneyOld = value; }
  455. }
  456. string updateDate;
  457. /// <summary>
  458. /// 上次付款时间
  459. /// </summary>
  460. public string UpdateDate
  461. {
  462. get { return updateDate; }
  463. set { updateDate = value; }
  464. }
  465. string payee;
  466. /// <summary>
  467. /// 收款方
  468. /// </summary>
  469. public string Payee
  470. {
  471. get { return payee; }
  472. set { payee = value; }
  473. }
  474. float rMBPrice;
  475. /// <summary>
  476. /// 人民币费用
  477. /// </summary>
  478. public float RMBPrice
  479. {
  480. get { return rMBPrice; }
  481. set { rMBPrice = value; }
  482. }
  483. string orbitalPrivateTransfer;
  484. /// <summary>
  485. /// 费用标识
  486. /// </summary>
  487. public string OrbitalPrivateTransfer
  488. {
  489. get { return orbitalPrivateTransfer; }
  490. set { orbitalPrivateTransfer = value; }
  491. }
  492. /// <summary>
  493. /// 超出预算比例
  494. /// </summary>
  495. public float ExceedBudget { get; set; }
  496. /// <summary>
  497. /// 是否匹配上了信用卡账单
  498. /// </summary>
  499. public int IsMatchCreditCard { get; set; }
  500. }
  501. }