MarketOperators_info.cs 29 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800801802803804805806807808809810811812813814815816817818819820821822823824825826827828829830831832833834835836837838839840841842843844845846847848849850851852853854855856857858859
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Text;
  4. using System.Data;
  5. using SysBaseLibs;
  6. using System.Web.Script.Serialization;
  7. namespace SysDataLibs.TableClass
  8. {
  9. #region MarketOperators
  10. public class MarketOperators_info : ITableInfo
  11. {
  12. #region MarketOperators表 字段信息
  13. /// <summary>
  14. /// 为关键字段: N ;
  15. /// 自动增长: N;
  16. /// 数据类型: datetime;
  17. /// 数据长度: 8;
  18. /// 是否允许为空: Y;
  19. /// 默认值: ;
  20. /// 描述: 出生日期;
  21. /// </summary>
  22. public const string cBirthDate = "BirthDate";
  23. /// <summary>
  24. /// 为关键字段: N ;
  25. /// 自动增长: N;
  26. /// 数据类型: varchar;
  27. /// 数据长度: 20;
  28. /// 是否允许为空: Y;
  29. /// 默认值: ;
  30. /// 描述: 手机号码;
  31. /// </summary>
  32. public const string cCellPhone = "CellPhone";
  33. /// <summary>
  34. /// 为关键字段: N ;
  35. /// 自动增长: N;
  36. /// 数据类型: int;
  37. /// 数据长度: 4;
  38. /// 是否允许为空: Y;
  39. /// 默认值: ;
  40. /// 描述: 学历类型;
  41. /// </summary>
  42. public const string cDegreeTypeID = "DegreeTypeID";
  43. /// <summary>
  44. /// 为关键字段: N ;
  45. /// 自动增长: N;
  46. /// 数据类型: datetime;
  47. /// 数据长度: 8;
  48. /// 是否允许为空: Y;
  49. /// 默认值: ;
  50. /// 描述: 进单位时间;
  51. /// </summary>
  52. public const string cEnterCompanyDate = "EnterCompanyDate";
  53. /// <summary>
  54. /// 为关键字段: N ;
  55. /// 自动增长: N;
  56. /// 数据类型: varchar;
  57. /// 数据长度: 10;
  58. /// 是否允许为空: Y;
  59. /// 默认值: ;
  60. /// 描述: 家庭成员1称谓;
  61. /// </summary>
  62. public const string cFamily1Appellation = "Family1Appellation";
  63. /// <summary>
  64. /// 为关键字段: N ;
  65. /// 自动增长: N;
  66. /// 数据类型: varchar;
  67. /// 数据长度: 100;
  68. /// 是否允许为空: Y;
  69. /// 默认值: ;
  70. /// 描述: 家庭成员1单位;
  71. /// </summary>
  72. public const string cFamily1Company = "Family1Company";
  73. /// <summary>
  74. /// 为关键字段: N ;
  75. /// 自动增长: N;
  76. /// 数据类型: varchar;
  77. /// 数据长度: 10;
  78. /// 是否允许为空: Y;
  79. /// 默认值: ;
  80. /// 描述: 家庭成员1名称;
  81. /// </summary>
  82. public const string cFamily1Name = "Family1Name";
  83. /// <summary>
  84. /// 为关键字段: N ;
  85. /// 自动增长: N;
  86. /// 数据类型: varchar;
  87. /// 数据长度: 100;
  88. /// 是否允许为空: Y;
  89. /// 默认值: ;
  90. /// 描述: 家庭成员1户籍地;
  91. /// </summary>
  92. public const string cFamily1Residence = "Family1Residence";
  93. /// <summary>
  94. /// 为关键字段: N ;
  95. /// 自动增长: N;
  96. /// 数据类型: varchar;
  97. /// 数据长度: 10;
  98. /// 是否允许为空: Y;
  99. /// 默认值: ;
  100. /// 描述: 家庭成员2称谓;
  101. /// </summary>
  102. public const string cFamily2Appellation = "Family2Appellation";
  103. /// <summary>
  104. /// 为关键字段: N ;
  105. /// 自动增长: N;
  106. /// 数据类型: varchar;
  107. /// 数据长度: 100;
  108. /// 是否允许为空: Y;
  109. /// 默认值: ;
  110. /// 描述: 家庭成员2单位;
  111. /// </summary>
  112. public const string cFamily2Company = "Family2Company";
  113. /// <summary>
  114. /// 为关键字段: N ;
  115. /// 自动增长: N;
  116. /// 数据类型: varchar;
  117. /// 数据长度: 10;
  118. /// 是否允许为空: Y;
  119. /// 默认值: ;
  120. /// 描述: 家庭成员2名称;
  121. /// </summary>
  122. public const string cFamily2Name = "Family2Name";
  123. /// <summary>
  124. /// 为关键字段: N ;
  125. /// 自动增长: N;
  126. /// 数据类型: varchar;
  127. /// 数据长度: 100;
  128. /// 是否允许为空: Y;
  129. /// 默认值: ;
  130. /// 描述: 家庭成员2户籍地;
  131. /// </summary>
  132. public const string cFamily2Residence = "Family2Residence";
  133. /// <summary>
  134. /// 为关键字段: N ;
  135. /// 自动增长: N;
  136. /// 数据类型: varchar;
  137. /// 数据长度: 10;
  138. /// 是否允许为空: Y;
  139. /// 默认值: ;
  140. /// 描述: 家庭成员3称谓;
  141. /// </summary>
  142. public const string cFamily3Appellation = "Family3Appellation";
  143. /// <summary>
  144. /// 为关键字段: N ;
  145. /// 自动增长: N;
  146. /// 数据类型: varchar;
  147. /// 数据长度: 100;
  148. /// 是否允许为空: Y;
  149. /// 默认值: ;
  150. /// 描述: 家庭成员3单位;
  151. /// </summary>
  152. public const string cFamily3Company = "Family3Company";
  153. /// <summary>
  154. /// 为关键字段: N ;
  155. /// 自动增长: N;
  156. /// 数据类型: varchar;
  157. /// 数据长度: 10;
  158. /// 是否允许为空: Y;
  159. /// 默认值: ;
  160. /// 描述: 家庭成员3名称;
  161. /// </summary>
  162. public const string cFamily3Name = "Family3Name";
  163. /// <summary>
  164. /// 为关键字段: N ;
  165. /// 自动增长: N;
  166. /// 数据类型: varchar;
  167. /// 数据长度: 100;
  168. /// 是否允许为空: Y;
  169. /// 默认值: ;
  170. /// 描述: 家庭成员3户籍地;
  171. /// </summary>
  172. public const string cFamily3Residence = "Family3Residence";
  173. /// <summary>
  174. /// 为关键字段: N ;
  175. /// 自动增长: N;
  176. /// 数据类型: smallint;
  177. /// 数据长度: 2;
  178. /// 是否允许为空: Y;
  179. /// 默认值: ;
  180. /// 描述: 性别;
  181. /// </summary>
  182. public const string cGender = "Gender";
  183. /// <summary>
  184. /// 为关键字段: N ;
  185. /// 自动增长: N;
  186. /// 数据类型: varchar;
  187. /// 数据长度: 100;
  188. /// 是否允许为空: Y;
  189. /// 默认值: ;
  190. /// 描述: 家庭住址;
  191. /// </summary>
  192. public const string cHomeAddress = "HomeAddress";
  193. /// <summary>
  194. /// 为关键字段: N ;
  195. /// 自动增长: N;
  196. /// 数据类型: varchar;
  197. /// 数据长度: 20;
  198. /// 是否允许为空: Y;
  199. /// 默认值: ;
  200. /// 描述: 身份证号;
  201. /// </summary>
  202. public const string cIdCard = "IdCard";
  203. /// <summary>
  204. /// 为关键字段: N ;
  205. /// 自动增长: N;
  206. /// 数据类型: varchar;
  207. /// 数据长度: 20;
  208. /// 是否允许为空: Y;
  209. /// 默认值: ;
  210. /// 描述: 分管工作;
  211. /// </summary>
  212. public const string cJob = "Job";
  213. /// <summary>
  214. /// 为关键字段: N ;
  215. /// 自动增长: N;
  216. /// 数据类型: char;
  217. /// 数据长度: 10;
  218. /// 是否允许为空: N;
  219. /// 默认值: ;
  220. /// 描述: 市场编号;
  221. /// </summary>
  222. public const string cMarketID = "MarketID";
  223. /// <summary>
  224. /// 为关键字段: N ;
  225. /// 自动增长: N;
  226. /// 数据类型: varchar;
  227. /// 数据长度: 10;
  228. /// 是否允许为空: Y;
  229. /// 默认值: ;
  230. /// 描述: 姓名;
  231. /// </summary>
  232. public const string cName = "Name";
  233. /// <summary>
  234. /// 为关键字段: N ;
  235. /// 自动增长: N;
  236. /// 数据类型: varchar;
  237. /// 数据长度: 200;
  238. /// 是否允许为空: Y;
  239. /// 默认值: ;
  240. /// 描述: 备注;
  241. /// </summary>
  242. public const string cNotes = "Notes";
  243. /// <summary>
  244. /// 为关键字段: Y --- PrimaryKey;
  245. /// 自动增长: Y;
  246. /// 数据类型: int;
  247. /// 数据长度: 4;
  248. /// 是否允许为空: N;
  249. /// 默认值: ;
  250. /// 描述: 编号;
  251. /// </summary>
  252. public const string cOperatorID = "OperatorID";
  253. /// <summary>
  254. /// 为关键字段: N ;
  255. /// 自动增长: N;
  256. /// 数据类型: varchar;
  257. /// 数据长度: 20;
  258. /// 是否允许为空: Y;
  259. /// 默认值: ;
  260. /// 描述: 政治面貌;
  261. /// </summary>
  262. public const string cPolitics = "Politics";
  263. /// <summary>
  264. /// 为关键字段: N ;
  265. /// 自动增长: N;
  266. /// 数据类型: varchar;
  267. /// 数据长度: 2000;
  268. /// 是否允许为空: Y;
  269. /// 默认值: ;
  270. /// 描述: 奖惩记录;
  271. /// </summary>
  272. public const string cResume = "Resume";
  273. /// <summary>
  274. /// 为关键字段: N ;
  275. /// 自动增长: N;
  276. /// 数据类型: varchar;
  277. /// 数据长度: 30;
  278. /// 是否允许为空: Y;
  279. /// 默认值: ;
  280. /// 描述: 电话;
  281. /// </summary>
  282. public const string cTel = "Tel";
  283. /// <summary>
  284. /// 为关键字段: N ;
  285. /// 自动增长: N;
  286. /// 数据类型: varchar;
  287. /// 数据长度: 20;
  288. /// 是否允许为空: Y;
  289. /// 默认值: ;
  290. /// 描述: 职务;
  291. /// </summary>
  292. public const string cTitle = "Title";
  293. /// <summary>
  294. /// 为关键字段: N ;
  295. /// 自动增长: N;
  296. /// 数据类型: varchar;
  297. /// 数据长度: 20;
  298. /// 是否允许为空: Y;
  299. /// 默认值: ;
  300. /// 描述: 用户名称;
  301. /// </summary>
  302. public const string cUserName = "UserName";
  303. #endregion
  304. public MarketOperators_info(){}
  305. public MarketOperators_info(DataRow poRow)
  306. {
  307. CreateTableInfo(poRow);
  308. }
  309. public void CreateTableInfo(DataRow poRow)
  310. {
  311. _BirthDate=UtilStr.StrFromObj(poRow[cBirthDate]);
  312. _CellPhone=UtilStr.StrFromObj(poRow[cCellPhone]);
  313. _DegreeTypeID=UtilStr.StrFromObj(poRow[cDegreeTypeID]);
  314. _EnterCompanyDate=UtilStr.StrFromObj(poRow[cEnterCompanyDate]);
  315. _Family1Appellation=UtilStr.StrFromObj(poRow[cFamily1Appellation]);
  316. _Family1Company=UtilStr.StrFromObj(poRow[cFamily1Company]);
  317. _Family1Name=UtilStr.StrFromObj(poRow[cFamily1Name]);
  318. _Family1Residence=UtilStr.StrFromObj(poRow[cFamily1Residence]);
  319. _Family2Appellation=UtilStr.StrFromObj(poRow[cFamily2Appellation]);
  320. _Family2Company=UtilStr.StrFromObj(poRow[cFamily2Company]);
  321. _Family2Name=UtilStr.StrFromObj(poRow[cFamily2Name]);
  322. _Family2Residence=UtilStr.StrFromObj(poRow[cFamily2Residence]);
  323. _Family3Appellation=UtilStr.StrFromObj(poRow[cFamily3Appellation]);
  324. _Family3Company=UtilStr.StrFromObj(poRow[cFamily3Company]);
  325. _Family3Name=UtilStr.StrFromObj(poRow[cFamily3Name]);
  326. _Family3Residence=UtilStr.StrFromObj(poRow[cFamily3Residence]);
  327. _Gender=UtilStr.StrFromObj(poRow[cGender]);
  328. _HomeAddress=UtilStr.StrFromObj(poRow[cHomeAddress]);
  329. _IdCard=UtilStr.StrFromObj(poRow[cIdCard]);
  330. _Job=UtilStr.StrFromObj(poRow[cJob]);
  331. _MarketID=UtilStr.StrFromObj(poRow[cMarketID]);
  332. _Name=UtilStr.StrFromObj(poRow[cName]);
  333. _Notes=UtilStr.StrFromObj(poRow[cNotes]);
  334. _OperatorID=UtilStr.StrFromObj(poRow[cOperatorID]);
  335. _Politics=UtilStr.StrFromObj(poRow[cPolitics]);
  336. _Resume=UtilStr.StrFromObj(poRow[cResume]);
  337. _Tel=UtilStr.StrFromObj(poRow[cTel]);
  338. _Title=UtilStr.StrFromObj(poRow[cTitle]);
  339. _UserName=UtilStr.StrFromObj(poRow[cUserName]);
  340. }
  341. public MarketOperators_info( string pcOperatorID, DBConnSql poDBConn)
  342. {
  343. if ( pcOperatorID.Trim().Length > 0 && poDBConn != null)
  344. {
  345. string lcSql = "select * from " + Tn.MarketOperators + " where OperatorID='"+pcOperatorID+"'";
  346. rsQuery loQuery = poDBConn.OpenQuery(lcSql);
  347. if (loQuery != null && loQuery.IsOpened && loQuery.RecCount == 1)
  348. {
  349. loQuery.MoveFirst();
  350. CreateTableInfo(loQuery.CurrentRow);
  351. }
  352. }
  353. }
  354. private string _BirthDate="";
  355. public string BirthDate
  356. {
  357. get { return _BirthDate; }
  358. set { _BirthDate = value; }
  359. }
  360. private string _CellPhone="";
  361. public string CellPhone
  362. {
  363. get { return _CellPhone; }
  364. set { _CellPhone = value; }
  365. }
  366. private string _DegreeTypeID="";
  367. public string DegreeTypeID
  368. {
  369. get { return _DegreeTypeID; }
  370. set { _DegreeTypeID = value; }
  371. }
  372. private string _EnterCompanyDate="";
  373. public string EnterCompanyDate
  374. {
  375. get { return _EnterCompanyDate; }
  376. set { _EnterCompanyDate = value; }
  377. }
  378. private string _Family1Appellation="";
  379. public string Family1Appellation
  380. {
  381. get { return _Family1Appellation; }
  382. set { _Family1Appellation = value; }
  383. }
  384. private string _Family1Company="";
  385. public string Family1Company
  386. {
  387. get { return _Family1Company; }
  388. set { _Family1Company = value; }
  389. }
  390. private string _Family1Name="";
  391. public string Family1Name
  392. {
  393. get { return _Family1Name; }
  394. set { _Family1Name = value; }
  395. }
  396. private string _Family1Residence="";
  397. public string Family1Residence
  398. {
  399. get { return _Family1Residence; }
  400. set { _Family1Residence = value; }
  401. }
  402. private string _Family2Appellation="";
  403. public string Family2Appellation
  404. {
  405. get { return _Family2Appellation; }
  406. set { _Family2Appellation = value; }
  407. }
  408. private string _Family2Company="";
  409. public string Family2Company
  410. {
  411. get { return _Family2Company; }
  412. set { _Family2Company = value; }
  413. }
  414. private string _Family2Name="";
  415. public string Family2Name
  416. {
  417. get { return _Family2Name; }
  418. set { _Family2Name = value; }
  419. }
  420. private string _Family2Residence="";
  421. public string Family2Residence
  422. {
  423. get { return _Family2Residence; }
  424. set { _Family2Residence = value; }
  425. }
  426. private string _Family3Appellation="";
  427. public string Family3Appellation
  428. {
  429. get { return _Family3Appellation; }
  430. set { _Family3Appellation = value; }
  431. }
  432. private string _Family3Company="";
  433. public string Family3Company
  434. {
  435. get { return _Family3Company; }
  436. set { _Family3Company = value; }
  437. }
  438. private string _Family3Name="";
  439. public string Family3Name
  440. {
  441. get { return _Family3Name; }
  442. set { _Family3Name = value; }
  443. }
  444. private string _Family3Residence="";
  445. public string Family3Residence
  446. {
  447. get { return _Family3Residence; }
  448. set { _Family3Residence = value; }
  449. }
  450. private string _Gender="";
  451. public string Gender
  452. {
  453. get { return _Gender; }
  454. set { _Gender = value; }
  455. }
  456. private string _HomeAddress="";
  457. public string HomeAddress
  458. {
  459. get { return _HomeAddress; }
  460. set { _HomeAddress = value; }
  461. }
  462. private string _IdCard="";
  463. public string IdCard
  464. {
  465. get { return _IdCard; }
  466. set { _IdCard = value; }
  467. }
  468. private string _Job="";
  469. public string Job
  470. {
  471. get { return _Job; }
  472. set { _Job = value; }
  473. }
  474. private string _MarketID="";
  475. public string MarketID
  476. {
  477. get { return _MarketID; }
  478. set { _MarketID = value; }
  479. }
  480. private string _Name="";
  481. public string Name
  482. {
  483. get { return _Name; }
  484. set { _Name = value; }
  485. }
  486. private string _Notes="";
  487. public string Notes
  488. {
  489. get { return _Notes; }
  490. set { _Notes = value; }
  491. }
  492. private string _OperatorID="";
  493. public string OperatorID
  494. {
  495. get { return _OperatorID; }
  496. set { _OperatorID = value; }
  497. }
  498. private string _Politics="";
  499. public string Politics
  500. {
  501. get { return _Politics; }
  502. set { _Politics = value; }
  503. }
  504. private string _Resume="";
  505. public string Resume
  506. {
  507. get { return _Resume; }
  508. set { _Resume = value; }
  509. }
  510. private string _Tel="";
  511. public string Tel
  512. {
  513. get { return _Tel; }
  514. set { _Tel = value; }
  515. }
  516. private string _Title="";
  517. public string Title
  518. {
  519. get { return _Title; }
  520. set { _Title = value; }
  521. }
  522. private string _UserName="";
  523. public string UserName
  524. {
  525. get { return _UserName; }
  526. set { _UserName = value; }
  527. }
  528. [ScriptIgnore]
  529. public rsXmlNode DataXMLNode
  530. {
  531. get
  532. {
  533. rsXmlNode loMainNode = new rsXmlNode("MarketOperatorsRecord", "");
  534. rsXmlNode loNode =null;
  535. loNode = new rsXmlNode(cBirthDate, BirthDate);
  536. loMainNode.AddChild(loNode);
  537. loNode = new rsXmlNode(cCellPhone, CellPhone);
  538. loMainNode.AddChild(loNode);
  539. loNode = new rsXmlNode(cDegreeTypeID, DegreeTypeID);
  540. loMainNode.AddChild(loNode);
  541. loNode = new rsXmlNode(cEnterCompanyDate, EnterCompanyDate);
  542. loMainNode.AddChild(loNode);
  543. loNode = new rsXmlNode(cFamily1Appellation, Family1Appellation);
  544. loMainNode.AddChild(loNode);
  545. loNode = new rsXmlNode(cFamily1Company, Family1Company);
  546. loMainNode.AddChild(loNode);
  547. loNode = new rsXmlNode(cFamily1Name, Family1Name);
  548. loMainNode.AddChild(loNode);
  549. loNode = new rsXmlNode(cFamily1Residence, Family1Residence);
  550. loMainNode.AddChild(loNode);
  551. loNode = new rsXmlNode(cFamily2Appellation, Family2Appellation);
  552. loMainNode.AddChild(loNode);
  553. loNode = new rsXmlNode(cFamily2Company, Family2Company);
  554. loMainNode.AddChild(loNode);
  555. loNode = new rsXmlNode(cFamily2Name, Family2Name);
  556. loMainNode.AddChild(loNode);
  557. loNode = new rsXmlNode(cFamily2Residence, Family2Residence);
  558. loMainNode.AddChild(loNode);
  559. loNode = new rsXmlNode(cFamily3Appellation, Family3Appellation);
  560. loMainNode.AddChild(loNode);
  561. loNode = new rsXmlNode(cFamily3Company, Family3Company);
  562. loMainNode.AddChild(loNode);
  563. loNode = new rsXmlNode(cFamily3Name, Family3Name);
  564. loMainNode.AddChild(loNode);
  565. loNode = new rsXmlNode(cFamily3Residence, Family3Residence);
  566. loMainNode.AddChild(loNode);
  567. loNode = new rsXmlNode(cGender, Gender);
  568. loMainNode.AddChild(loNode);
  569. loNode = new rsXmlNode(cHomeAddress, HomeAddress);
  570. loMainNode.AddChild(loNode);
  571. loNode = new rsXmlNode(cIdCard, IdCard);
  572. loMainNode.AddChild(loNode);
  573. loNode = new rsXmlNode(cJob, Job);
  574. loMainNode.AddChild(loNode);
  575. loNode = new rsXmlNode(cMarketID, MarketID);
  576. loMainNode.AddChild(loNode);
  577. loNode = new rsXmlNode(cName, Name);
  578. loMainNode.AddChild(loNode);
  579. loNode = new rsXmlNode(cNotes, Notes);
  580. loMainNode.AddChild(loNode);
  581. loNode = new rsXmlNode(cOperatorID, OperatorID);
  582. loMainNode.AddChild(loNode);
  583. loNode = new rsXmlNode(cPolitics, Politics);
  584. loMainNode.AddChild(loNode);
  585. loNode = new rsXmlNode(cResume, Resume);
  586. loMainNode.AddChild(loNode);
  587. loNode = new rsXmlNode(cTel, Tel);
  588. loMainNode.AddChild(loNode);
  589. loNode = new rsXmlNode(cTitle, Title);
  590. loMainNode.AddChild(loNode);
  591. loNode = new rsXmlNode(cUserName, UserName);
  592. loMainNode.AddChild(loNode);
  593. return loMainNode ;
  594. }
  595. }
  596. public string InsertSql()
  597. {
  598. return " insert into "+Tn.MarketOperators+" "+
  599. " ("+cBirthDate+","+cCellPhone+","+cDegreeTypeID+","+cEnterCompanyDate+","+cFamily1Appellation+","+cFamily1Company+","+cFamily1Name+","+cFamily1Residence+","+cFamily2Appellation+","+cFamily2Company+","+cFamily2Name+","+cFamily2Residence+","+cFamily3Appellation+","+cFamily3Company+","+cFamily3Name+","+cFamily3Residence+","+cGender+","+cHomeAddress+","+cIdCard+","+cJob+","+cMarketID+","+cName+","+cNotes+","+cPolitics+","+cResume+","+cTel+","+cTitle+","+cUserName+") "+
  600. " values ('"+_BirthDate+"','"+_CellPhone+"',"+_DegreeTypeID+",'"+_EnterCompanyDate+"','"+_Family1Appellation+"','"+_Family1Company+"','"+_Family1Name+"','"+_Family1Residence+"','"+_Family2Appellation+"','"+_Family2Company+"','"+_Family2Name+"','"+_Family2Residence+"','"+_Family3Appellation+"','"+_Family3Company+"','"+_Family3Name+"','"+_Family3Residence+"','"+_Gender+"','"+_HomeAddress+"','"+_IdCard+"','"+_Job+"','"+_MarketID+"','"+_Name+"','"+_Notes+"','"+_Politics+"','"+_Resume+"','"+_Tel+"','"+_Title+"','"+_UserName+"') " ;
  601. }
  602. public string UpdateSql()
  603. {
  604. return " update "+Tn.MarketOperators+" "+
  605. " set "+cBirthDate+"='"+_BirthDate+"',"+cCellPhone+"='"+_CellPhone+"',"+cDegreeTypeID+"="+_DegreeTypeID+","+cEnterCompanyDate+"='"+_EnterCompanyDate+"',"+cFamily1Appellation+"='"+_Family1Appellation+"',"+cFamily1Company+"='"+_Family1Company+"',"+cFamily1Name+"='"+_Family1Name+"',"+cFamily1Residence+"='"+_Family1Residence+"',"+cFamily2Appellation+"='"+_Family2Appellation+"',"+cFamily2Company+"='"+_Family2Company+"',"+cFamily2Name+"='"+_Family2Name+"',"+cFamily2Residence+"='"+_Family2Residence+"',"+cFamily3Appellation+"='"+_Family3Appellation+"',"+cFamily3Company+"='"+_Family3Company+"',"+cFamily3Name+"='"+_Family3Name+"',"+cFamily3Residence+"='"+_Family3Residence+"',"+cGender+"='"+_Gender+"',"+cHomeAddress+"='"+_HomeAddress+"',"+cIdCard+"='"+_IdCard+"',"+cJob+"='"+_Job+"',"+cMarketID+"='"+_MarketID+"',"+cName+"='"+_Name+"',"+cNotes+"='"+_Notes+"',"+cPolitics+"='"+_Politics+"',"+cResume+"='"+_Resume+"',"+cTel+"='"+_Tel+"',"+cTitle+"='"+_Title+"',"+cUserName+"='"+_UserName+"' "+
  606. " where "+cOperatorID+"="+_OperatorID+"" ;
  607. }
  608. public string DeleteSql()
  609. {
  610. return "Delete "+Tn.MarketOperators+" where "+cOperatorID+"="+_OperatorID+"" ;
  611. }
  612. }
  613. #endregion
  614. #region
  615. public class MarketOperators_Qry : rsQuery
  616. {
  617. public DateTime BirthDate
  618. {
  619. get { return GetDateTime(MarketOperators_info.cBirthDate); }
  620. // set { SetField(MarketOperators_info.cBirthDate, value); }
  621. }
  622. public String CellPhone
  623. {
  624. get { return GetString(MarketOperators_info.cCellPhone); }
  625. // set { SetField(MarketOperators_info.cCellPhone, value); }
  626. }
  627. public Int64 DegreeTypeID
  628. {
  629. get { return GetInt(MarketOperators_info.cDegreeTypeID); }
  630. // set { SetField(MarketOperators_info.cDegreeTypeID, value); }
  631. }
  632. public DateTime EnterCompanyDate
  633. {
  634. get { return GetDateTime(MarketOperators_info.cEnterCompanyDate); }
  635. // set { SetField(MarketOperators_info.cEnterCompanyDate, value); }
  636. }
  637. public String Family1Appellation
  638. {
  639. get { return GetString(MarketOperators_info.cFamily1Appellation); }
  640. // set { SetField(MarketOperators_info.cFamily1Appellation, value); }
  641. }
  642. public String Family1Company
  643. {
  644. get { return GetString(MarketOperators_info.cFamily1Company); }
  645. // set { SetField(MarketOperators_info.cFamily1Company, value); }
  646. }
  647. public String Family1Name
  648. {
  649. get { return GetString(MarketOperators_info.cFamily1Name); }
  650. // set { SetField(MarketOperators_info.cFamily1Name, value); }
  651. }
  652. public String Family1Residence
  653. {
  654. get { return GetString(MarketOperators_info.cFamily1Residence); }
  655. // set { SetField(MarketOperators_info.cFamily1Residence, value); }
  656. }
  657. public String Family2Appellation
  658. {
  659. get { return GetString(MarketOperators_info.cFamily2Appellation); }
  660. // set { SetField(MarketOperators_info.cFamily2Appellation, value); }
  661. }
  662. public String Family2Company
  663. {
  664. get { return GetString(MarketOperators_info.cFamily2Company); }
  665. // set { SetField(MarketOperators_info.cFamily2Company, value); }
  666. }
  667. public String Family2Name
  668. {
  669. get { return GetString(MarketOperators_info.cFamily2Name); }
  670. // set { SetField(MarketOperators_info.cFamily2Name, value); }
  671. }
  672. public String Family2Residence
  673. {
  674. get { return GetString(MarketOperators_info.cFamily2Residence); }
  675. // set { SetField(MarketOperators_info.cFamily2Residence, value); }
  676. }
  677. public String Family3Appellation
  678. {
  679. get { return GetString(MarketOperators_info.cFamily3Appellation); }
  680. // set { SetField(MarketOperators_info.cFamily3Appellation, value); }
  681. }
  682. public String Family3Company
  683. {
  684. get { return GetString(MarketOperators_info.cFamily3Company); }
  685. // set { SetField(MarketOperators_info.cFamily3Company, value); }
  686. }
  687. public String Family3Name
  688. {
  689. get { return GetString(MarketOperators_info.cFamily3Name); }
  690. // set { SetField(MarketOperators_info.cFamily3Name, value); }
  691. }
  692. public String Family3Residence
  693. {
  694. get { return GetString(MarketOperators_info.cFamily3Residence); }
  695. // set { SetField(MarketOperators_info.cFamily3Residence, value); }
  696. }
  697. public Int64 Gender
  698. {
  699. get { return GetInt(MarketOperators_info.cGender); }
  700. // set { SetField(MarketOperators_info.cGender, value); }
  701. }
  702. public String HomeAddress
  703. {
  704. get { return GetString(MarketOperators_info.cHomeAddress); }
  705. // set { SetField(MarketOperators_info.cHomeAddress, value); }
  706. }
  707. public String IdCard
  708. {
  709. get { return GetString(MarketOperators_info.cIdCard); }
  710. // set { SetField(MarketOperators_info.cIdCard, value); }
  711. }
  712. public String Job
  713. {
  714. get { return GetString(MarketOperators_info.cJob); }
  715. // set { SetField(MarketOperators_info.cJob, value); }
  716. }
  717. public String MarketID
  718. {
  719. get { return GetString(MarketOperators_info.cMarketID); }
  720. // set { SetField(MarketOperators_info.cMarketID, value); }
  721. }
  722. public String Name
  723. {
  724. get { return GetString(MarketOperators_info.cName); }
  725. // set { SetField(MarketOperators_info.cName, value); }
  726. }
  727. public String Notes
  728. {
  729. get { return GetString(MarketOperators_info.cNotes); }
  730. // set { SetField(MarketOperators_info.cNotes, value); }
  731. }
  732. public Int64 OperatorID
  733. {
  734. get { return GetInt(MarketOperators_info.cOperatorID); }
  735. // set { SetField(MarketOperators_info.cOperatorID, value); }
  736. }
  737. public String Politics
  738. {
  739. get { return GetString(MarketOperators_info.cPolitics); }
  740. // set { SetField(MarketOperators_info.cPolitics, value); }
  741. }
  742. public String Resume
  743. {
  744. get { return GetString(MarketOperators_info.cResume); }
  745. // set { SetField(MarketOperators_info.cResume, value); }
  746. }
  747. public String Tel
  748. {
  749. get { return GetString(MarketOperators_info.cTel); }
  750. // set { SetField(MarketOperators_info.cTel, value); }
  751. }
  752. public String Title
  753. {
  754. get { return GetString(MarketOperators_info.cTitle); }
  755. // set { SetField(MarketOperators_info.cTitle, value); }
  756. }
  757. public String UserName
  758. {
  759. get { return GetString(MarketOperators_info.cUserName); }
  760. // set { SetField(MarketOperators_info.cUserName, value); }
  761. }
  762. }
  763. #endregion
  764. }