Crm_DeleClient.cs 27 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788
  1. using OASystem.Domain.Attributes;
  2. namespace OASystem.Domain.Entities.Customer
  3. {
  4. /// <summary>
  5. /// 客户信息表
  6. /// </summary>
  7. [SugarTable("Crm_DeleClient")]
  8. public class Crm_DeleClient : EntityBase
  9. {
  10. /// <summary>
  11. /// 团组Id
  12. /// </summary>
  13. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  14. public int DiId { get; set; }
  15. /// <summary>
  16. /// 中文姓
  17. /// </summary>
  18. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  19. [Encrypted]
  20. public string LastName { get; set; }
  21. /// <summary>
  22. /// 中文名
  23. /// </summary>
  24. [Encrypted]
  25. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  26. public string FirstName { get; set; }
  27. /// <summary>
  28. /// 曾用名
  29. /// </summary>
  30. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  31. public string OldName { get; set; }
  32. /// <summary>
  33. /// 名字拼音
  34. /// </summary>
  35. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  36. [Encrypted]
  37. public string Pinyin { get; set; }
  38. /// <summary>
  39. /// 性别
  40. /// 0男1女 -1未选择
  41. /// </summary>
  42. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  43. public int Sex { get; set; } = -1;
  44. /// <summary>
  45. /// 婚姻状况 0、1、2、3、4 (未设置、未婚、已婚、离异、丧偶)
  46. /// </summary>
  47. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  48. public int Marriage { get; set; } = 0;
  49. /// <summary>
  50. /// 客户手机号
  51. /// </summary>
  52. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  53. [Encrypted]
  54. public string Phone { get; set; } = "";
  55. /// <summary>
  56. /// 出生省份
  57. /// </summary>
  58. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  59. public string BirthProvince { get; set; }
  60. /// <summary>
  61. /// 出生城市
  62. /// </summary>
  63. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  64. public string BirthCity { get; set; }
  65. /// <summary>
  66. /// 出生日期
  67. /// </summary>
  68. [SugarColumn(IsNullable = true, ColumnDataType = "datetime")]
  69. public DateTime? BirthDay { get; set; } = null;
  70. /// <summary>
  71. /// 机票喜好舱位
  72. /// </summary>
  73. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  74. public string AirType { get; set; }
  75. /// <summary>
  76. /// 是否靠窗
  77. /// </summary>
  78. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  79. public int SeatPref { get; set; }
  80. /// <summary>
  81. /// 机票备注
  82. /// </summary>
  83. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  84. public string AirRemark { get; set; }
  85. /// <summary>
  86. /// 酒店喜好房型
  87. /// </summary>
  88. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  89. public string RoomType { get; set; }
  90. /// <summary>
  91. /// 酒店需求
  92. /// </summary>
  93. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  94. public string RoomPref { get; set; }
  95. /// <summary>
  96. /// 家庭联系方式
  97. /// </summary>
  98. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  99. public string Tel { get; set; }
  100. /// <summary>
  101. /// 客户电子邮件
  102. /// </summary>
  103. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  104. public string Email { get; set; }
  105. /// <summary>
  106. /// 住址
  107. /// </summary>
  108. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  109. public string Address { get; set; }
  110. /// <summary>
  111. /// 最高学历
  112. /// </summary>
  113. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  114. public string HighestEducation { get; set; }
  115. /// <summary>
  116. /// 客户公司Id
  117. /// </summary>
  118. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  119. public int CrmCompanyId { get; set; }
  120. /// <summary>
  121. /// 邮编
  122. /// </summary>
  123. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  124. public string PostCodes { get; set; }
  125. /// <summary>
  126. /// 职位
  127. /// </summary>
  128. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  129. [Encrypted]
  130. public string Job { get; set; }
  131. /// <summary>
  132. /// 本人工作内容
  133. /// </summary>
  134. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  135. public string WorkState { get; set; }
  136. /// <summary>
  137. /// 入职时间
  138. /// </summary>
  139. [SugarColumn(IsNullable = true, ColumnDataType = "Datetime")]
  140. public string WorkDate { get; set; }
  141. /// <summary>
  142. /// 薪资
  143. /// </summary>
  144. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  145. public string Wage { get; set; }
  146. /// <summary>
  147. /// (单位/部门)电话
  148. /// </summary>
  149. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  150. public string ClientPhone { get; set; }
  151. /// <summary>
  152. /// (单位/部门)传真
  153. /// </summary>
  154. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  155. public string ClientFax { get; set; }
  156. /// <summary>
  157. /// (单位/部门)邮箱
  158. /// </summary>
  159. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  160. public string ClientEmail { get; set; }
  161. /// <summary>
  162. /// (单位/部门)负责人姓名
  163. /// </summary>
  164. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  165. public string ClientLeader { get; set; }
  166. /// <summary>
  167. /// (单位/部门)负责人职务
  168. /// </summary>
  169. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  170. public string ClientLeaderJob { get; set; }
  171. /// <summary>
  172. /// 是否有获批的申根签证
  173. /// 0否1是
  174. /// </summary>
  175. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  176. public int IsGetSchengen { get; set; } = 0;
  177. /// <summary>
  178. /// 申根有效期
  179. /// </summary>
  180. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  181. public DateTime StartTime { get; set; }
  182. /// <summary>
  183. /// 申根有效期
  184. /// </summary>
  185. [SugarColumn(IsNullable = true, ColumnDataType = "Datetime")]
  186. public DateTime EndTime { get; set; }
  187. /// <summary>
  188. /// 是否因公去过美国/加拿大
  189. /// 0否1是
  190. /// </summary>
  191. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  192. public int IsVisitUC { get; set; } = 0;
  193. /// <summary>
  194. /// 美国抵达日期
  195. /// </summary>
  196. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  197. public DateTime? USADate { get; set; }
  198. /// <summary>
  199. /// 美国停留天数
  200. /// </summary>
  201. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  202. public int? USADays { get; set; } = 0;
  203. /// <summary>
  204. /// 加拿大抵达日期
  205. /// </summary>
  206. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  207. public DateTime CanDate { get; set; }
  208. /// <summary>
  209. /// 加拿大停留天数
  210. /// </summary>
  211. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  212. public int CanDays { get; set; } = 0;
  213. /// 因公美国签证地点
  214. /// </summary>
  215. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  216. public string GetUPPlace { get; set; }
  217. /// <summary>
  218. /// 是否在使馆留过十指的指纹 0否1是
  219. /// </summary>
  220. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  221. public int USAFinger { get; set; } = 0;
  222. /// <summary>
  223. /// 是否曾经被拒签 0否1是
  224. /// </summary>
  225. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  226. public int IsRejected { get; set; } = 0;
  227. /// <summary>
  228. /// 被拒时间
  229. /// </summary>
  230. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  231. public DateTime? RejectedDate { get; set; }
  232. /// <summary>
  233. /// 被拒地点
  234. /// </summary>
  235. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  236. public string RejectedPlace { get; set; }
  237. /// <summary>
  238. /// 被拒签证种类
  239. /// </summary>
  240. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  241. public string RejectedVisa { get; set; }
  242. /// <summary>
  243. /// 美国签证是否被吊销过 0否1是
  244. /// </summary>
  245. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  246. public int IsRevoke { get; set; } = 0;
  247. /// <summary>
  248. /// 护照是否曾经丢失 0否1是
  249. /// </summary>
  250. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  251. public int IsLose { get; set; } = 0;
  252. /// <summary>
  253. /// 丢失护照时间
  254. /// </summary>
  255. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  256. public DateTime LoseDate { get; set; }
  257. /// <summary>
  258. /// 丢失护照编号
  259. /// </summary>
  260. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  261. public string LoseCode { get; set; }
  262. /// <summary>
  263. /// 丢失的护照是否有美国签证 0否1是
  264. /// </summary>
  265. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  266. public int IsUSAVisa { get; set; } = 0;
  267. /// <summary>
  268. /// 夫/妻是否已在美国
  269. /// 0否1是
  270. /// </summary>
  271. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  272. public int MateUSA { get; set; } = 0;
  273. /// <summary>
  274. /// 夫/妻身份
  275. /// </summary>
  276. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  277. public string MateIden { get; set; }
  278. /// <summary>
  279. /// 未婚夫/妻是否已在美国 0否1是
  280. /// </summary>
  281. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  282. public int WHUSA { get; set; } = 0;
  283. /// <summary>
  284. /// 未婚夫/妻身份
  285. /// </summary>
  286. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  287. public string WHIden { get; set; }
  288. /// <summary>
  289. /// 父/母是否已在美国
  290. /// 0否1是
  291. /// </summary>
  292. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  293. public int ParentUSA { get; set; } = 0;
  294. /// <summary>
  295. /// 父/母身份
  296. /// </summary>
  297. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  298. public string ParentIden { get; set; }
  299. /// <summary>
  300. /// 子/女是否已在美国 0否1是
  301. /// </summary>
  302. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  303. public int ChildUSA { get; set; } = 0;
  304. /// <summary>
  305. /// 子/女身份
  306. /// </summary>
  307. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  308. public string ChildIden { get; set; }
  309. /// <summary>
  310. /// 兄弟/姐妹是否已在美国 0否1是
  311. /// </summary>
  312. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  313. public int BroUSA { get; set; } = 0;
  314. /// <summary>
  315. /// 兄弟/姐妹身份
  316. /// </summary>
  317. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  318. public string BroIden { get; set; }
  319. /// <summary>
  320. /// 所属/捐助/工作过的职业协会、社会团体和慈善机构
  321. /// </summary>
  322. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  323. public string Social { get; set; }
  324. /// <summary>
  325. /// 是否参军
  326. /// 0否1是
  327. /// </summary>
  328. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  329. public int IsArmy { get; set; } = 0;
  330. /// <summary>
  331. /// 参军详情
  332. /// </summary>
  333. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  334. public string ArmyState { get; set; }
  335. /// <summary>
  336. /// 在外期间费用承担人
  337. /// </summary>
  338. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  339. public string CostBearers { get; set; }
  340. /// <summary>
  341. /// 填表经办人
  342. /// </summary>
  343. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  344. public string TableOpName { get; set; }
  345. /// <summary>
  346. /// 填表经办人联系电话
  347. /// </summary>
  348. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  349. public string TableOpTel { get; set; }
  350. /// <summary>
  351. /// 填表日期
  352. /// </summary>
  353. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  354. public DateTime TableDate { get; set; }
  355. /// <summary>
  356. /// 所属党派或宗教
  357. /// </summary>
  358. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  359. public string Party { get; set; }
  360. /// <summary>
  361. /// 国籍
  362. /// </summary>
  363. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(20)")]
  364. public string Nationality { get; set; }
  365. /// <summary>
  366. /// 结婚日期
  367. /// </summary>
  368. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  369. public DateTime? WeddingDate { get; set; }
  370. /// <summary>
  371. /// 离婚日期
  372. /// </summary>
  373. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  374. public DateTime? DivorceDate { get; set; }
  375. /// <summary>
  376. /// 配偶姓名
  377. /// </summary>
  378. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  379. public string MateName { get; set; }
  380. /// <summary>
  381. /// 配偶出生日期
  382. /// </summary>
  383. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  384. public DateTime MateBirthDay { get; set; }
  385. /// <summary>
  386. /// 配偶出生城市
  387. /// </summary>
  388. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  389. public string MateBirthCity { get; set; }
  390. /// <summary>
  391. /// 配偶出生国家省份
  392. /// </summary>
  393. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  394. public string MateBirthCountry { get; set; }
  395. /// <summary>
  396. /// 配偶住址
  397. /// </summary>
  398. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  399. public string MateAddress { get; set; }
  400. /// <summary>
  401. /// 配偶工作单位
  402. /// </summary>
  403. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  404. public string MateClient { get; set; }
  405. /// <summary>
  406. /// 配偶工作单位地址
  407. /// </summary>
  408. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  409. public string MateClientAddress { get; set; }
  410. /// <summary>
  411. /// 配偶职务
  412. /// </summary>
  413. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  414. public string MateJob { get; set; }
  415. /// <summary>
  416. /// 因公出访国家
  417. /// </summary>
  418. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  419. public string VisitCountry { get; set; }
  420. /// <summary>
  421. /// 发表的期刊/论文
  422. /// </summary>
  423. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  424. public string Paper { get; set; }
  425. /// <summary>
  426. /// 专利
  427. /// </summary>
  428. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  429. public string Papent { get; set; }
  430. /// <summary>
  431. /// 发表的博士论文
  432. /// </summary>
  433. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  434. public string PhD { get; set; }
  435. //----------增加字段------------
  436. /// <summary>
  437. /// 赴美目的
  438. /// </summary>
  439. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  440. public string USAPurpose { get; set; }
  441. /// <summary>
  442. /// 是否曾获得过因公美国签证 0否1是
  443. /// </summary>
  444. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  445. public int IsUSAVia { get; set; }
  446. /// <summary>
  447. /// 因公美国签证最近获得时间 / 有效期
  448. /// </summary>
  449. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  450. public DateTime? GetUSAVisaDate { get; set; }
  451. /// <summary>
  452. /// 因公美国签证种类
  453. /// </summary>
  454. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  455. public string USAVisaCate { get; set; }
  456. /// <summary>
  457. /// 因公美国签证编码
  458. /// </summary>
  459. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  460. public string USAVisaCode { get; set; }
  461. /// <summary>
  462. /// 申根是否在使馆有指纹记录
  463. /// 0否1是
  464. /// </summary>
  465. [SugarColumn(IsNullable = true, ColumnDataType = "int")]
  466. public int IsFinger { get; set; } = 0;
  467. /// <summary>
  468. /// 申根指纹录入时间
  469. /// </summary>
  470. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  471. public DateTime? FingerDate { get; set; }
  472. /// <summary>
  473. /// 美国驾照No
  474. /// </summary>
  475. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  476. public string USA_DLNo { get; set; }
  477. /// <summary>
  478. /// 美国驾照签发地
  479. /// </summary>
  480. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  481. public string USA_DLPlace { get; set; }
  482. /// <summary>
  483. /// 美国社会安全号或者纳税ID号
  484. /// </summary>
  485. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  486. public string USA_SSNOrITIN { get; set; }
  487. /// <summary>
  488. /// 是否是其他国家的永久居民
  489. /// </summary>
  490. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  491. public string Resident { get; set; }
  492. /// <summary>
  493. /// 曾抵达过美国时间
  494. /// </summary>
  495. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  496. public string USAHadArrival‌ { get; set; }
  497. /// <summary>
  498. /// 曾停留美国天数
  499. /// </summary>
  500. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(30)")]
  501. public string USAHadDays‌ { get; set; }
  502. /// <summary>
  503. /// 离婚原因
  504. /// </summary>
  505. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(500)")]
  506. public string DivorceRsn { get; set; }
  507. /// <summary>
  508. /// 近五年内是否使用过任何社交账号
  509. /// </summary>
  510. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  511. public string HasSocialAcc‌ { get; set; }
  512. /// <summary>
  513. /// 请提供美国详细住址
  514. /// </summary>
  515. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(200)")]
  516. public string USAAddress { get; set; }
  517. /// <summary>
  518. /// 美国联系人或组织
  519. /// </summary>
  520. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  521. public string USAContact‌ { get; set; }
  522. /// <summary>
  523. /// 美国联系人电话
  524. /// </summary>
  525. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  526. public string USAContact‌Tel‌ { get; set; }
  527. /// <summary>
  528. /// 美国联系人邮箱
  529. /// </summary>
  530. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  531. public string USAContact‌Email { get; set; }
  532. /// <summary>
  533. /// 赴美的到达城市
  534. /// </summary>
  535. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  536. public string USAArrivalCity‌ { get; set; }
  537. /// <summary>
  538. /// 赴美的离开城市
  539. /// </summary>
  540. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  541. public string USADepartCity‌ { get; set; }
  542. /// <summary>
  543. /// 计划在美国访问的景点
  544. /// </summary>
  545. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  546. public string USAVisitSites‌ { get; set; }
  547. /// <summary>
  548. /// 赴美同行人姓名
  549. /// </summary>
  550. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  551. public string USACmpName‌ { get; set; }
  552. /// <summary>
  553. /// 赴美同行人关系
  554. /// </summary>
  555. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  556. public string USACmpRelation‌ { get; set; }
  557. /// <summary>
  558. /// 过去5年内到过的国家
  559. /// </summary>
  560. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  561. public string Cntry5Y‌ { get; set; }
  562. /// <summary>
  563. /// 签时能流利交流的语言
  564. /// </summary>
  565. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(100)")]
  566. public string LangSkill‌ { get; set; }
  567. /// <summary>
  568. /// 曾被哪些国家拒签/拒签原因
  569. /// </summary>
  570. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(300)")]
  571. public string DenyNationRsn { get; set; }
  572. /// <summary>
  573. /// 美国移民签证时间
  574. /// </summary>
  575. [SugarColumn(IsNullable = true, ColumnDataType = "DateTime")]
  576. public DateTime? USAImmVisa‌Date { get; set; }
  577. /// <summary>
  578. /// 美国移民签证地点
  579. /// </summary>
  580. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  581. public string USAImmVisa‌Place { get; set; }
  582. /// <summary>
  583. /// 美国移民签证种类
  584. /// </summary>
  585. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  586. public string USAImmVisa‌ { get; set; }
  587. /// <summary>
  588. /// 直系亲属在美国 姓名
  589. /// </summary>
  590. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  591. public string USAImmedFamName { get; set; }
  592. /// <summary>
  593. /// 直系亲属在美国 关系
  594. /// </summary>
  595. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  596. public string USAImmedFamRel { get; set; }
  597. /// <summary>
  598. /// 直系亲属在美国 身份
  599. /// </summary>
  600. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  601. public string USAImmedFamStat { get; set; }
  602. /// <summary>
  603. /// 旁系亲属在美国 姓名
  604. /// </summary>
  605. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  606. public string USAUncleFamName { get; set; }
  607. /// <summary>
  608. /// 旁系亲属在美国 关系
  609. /// </summary>
  610. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  611. public string USAUncleFamRel { get; set; }
  612. /// <summary>
  613. /// 旁系亲属在美国 身份
  614. /// </summary>
  615. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  616. public string USAUncleFamStat { get; set; }
  617. /// <summary>
  618. /// 父亲姓名
  619. /// </summary>
  620. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  621. public string FthName { get; set; }
  622. /// <summary>
  623. /// 父亲出生日期
  624. /// </summary>
  625. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  626. public DateTime? FthBirth { get; set; }
  627. /// <summary>
  628. /// 母亲姓名
  629. /// </summary>
  630. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  631. public string MthName { get; set; }
  632. /// <summary>
  633. /// 母亲出生日期
  634. /// </summary>
  635. [SugarColumn(IsNullable = true, ColumnDataType = "varchar(50)")]
  636. public DateTime? MthBirth { get; set; }
  637. }
  638. public class GroupClints
  639. {
  640. public int Id { get; set; }
  641. public string Name { get; set; }
  642. /// <summary>
  643. /// 是否陪同
  644. /// 1 否 2 是
  645. /// 默认:1
  646. /// </summary>
  647. public int IsAccompany { get; set; }
  648. [Encrypted]
  649. public string CompanyFullName { get; set; }
  650. }
  651. /// <summary>
  652. /// 军事信息
  653. /// </summary>
  654. public class MilitaryInfo
  655. {
  656. /// <summary>
  657. /// 军种(陆军/海军/空军等)
  658. /// </summary>
  659. public string MilBranch { get; set; }
  660. /// <summary>
  661. /// 军衔(列兵/上校等)
  662. /// </summary>
  663. public string MilRank { get; set; }
  664. /// <summary>
  665. /// 军事特长(狙击/医疗等)
  666. /// </summary>
  667. public string MilSkill { get; set; }
  668. /// <summary>
  669. /// 服役时间(单位:xxxx年xx月xx日) 起 止
  670. /// </summary>
  671. public string ServeDuration { get; set; }
  672. }
  673. /// <summary>
  674. /// 拒签记录
  675. /// </summary>
  676. public class VisaRefusalRecord
  677. {
  678. public string Country { get; set; }
  679. public DateTime? Date { get; set; }
  680. public string Address { get; set; }
  681. public string VisaType { get; set; }
  682. public string Reason { get; set; }
  683. }
  684. /// <summary>
  685. /// 旅行历史
  686. /// </summary>
  687. public class TravelHistory
  688. {
  689. public string Country { get; set; }
  690. public DateTime? ArrivalDate { get; set; }
  691. public DateTime? DepartureDate { get; set; }
  692. public string VisaType { get; set; }
  693. }
  694. /// <summary>
  695. /// 已出访的国家
  696. /// </summary>
  697. public class CountryVisited
  698. {
  699. public string Country { get; set; }
  700. public string VisitDate { get; set; }
  701. }
  702. /// <summary>
  703. /// 定义申根签证记录类
  704. /// </summary>
  705. public class SchengenVisaRecord
  706. {
  707. public string VisaType { get; set; } // 签证类型
  708. public string VisaNumber { get; set; } // 签证号码
  709. public DateTime? IssueDate { get; set; } // 签发日期
  710. public DateTime? ExpiryDate { get; set; } // 有效期至
  711. //public string IssuingCountry { get; set; } // 签发国家
  712. }
  713. /// <summary>
  714. /// 定义社交账号类
  715. /// </summary>
  716. public class SocialAccount
  717. {
  718. public string Platform { get; set; } // 平台名称
  719. public string Account { get; set; } // 账号
  720. }
  721. /// <summary>
  722. /// 亲属朋友信息
  723. /// </summary>
  724. public class PersonInfo
  725. {
  726. /// <summary>
  727. /// 类型(亲属/朋友/联系人)
  728. /// </summary>
  729. public string Type { get; set; }
  730. public string Name { get; set; } // 姓名
  731. public DateTime? BirthDay { get; set; }
  732. public string Address { get; set; } // 地址
  733. public string ContactInfo { get; set; } // 联系方式
  734. }
  735. }