Crm_DeleClient.cs 26 KB

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