Brak opisu

T_Cus_CustomerBase.cs 19KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Text;
  5. using System.Threading.Tasks;
  6. namespace CallCenterApi.Model
  7. {
  8. /// <summary>
  9. /// T_Cus_CustomerBase:实体类(属性说明自动提取数据库字段的描述信息)
  10. /// </summary>
  11. [Serializable]
  12. public partial class T_Cus_CustomerBase
  13. {
  14. public T_Cus_CustomerBase()
  15. { }
  16. #region Model
  17. private int _f_customerid;
  18. private string _f_customername;
  19. private string _f_customercode;
  20. private string _f_customerename;
  21. private string _f_customerpym;
  22. private int? _f_layer;
  23. private string _f_customerlayer;
  24. private int? _f_categoryid = 0;
  25. private int? _f_tradeid = 0;
  26. private int? _f_regionid;
  27. private int? _f_industryid = 0;
  28. private string _f_address;
  29. private string _f_url;
  30. private string _f_telephone;
  31. private string _f_mobile;
  32. private string _f_fax;
  33. private string _f_email;
  34. private string _f_website;
  35. private string _f_postcode;
  36. private string _f_scaleresume;
  37. private string _f_businessprofile;
  38. private string _f_businesslicenseid;
  39. private string _f_taxid;
  40. private string _f_openingbank;
  41. private string _f_bankaccount;
  42. private string _f_legalrepresentative;
  43. private string _f_legalrepresentativecardid;
  44. private string _f_nature;
  45. private string _f_kind;
  46. private int? _f_customertype;
  47. private string _f_mainproduct;
  48. private string _f_customerfrom;
  49. private string _f_trackinfo;
  50. private string _f_trackstate;
  51. private string _f_importdegree;
  52. private string _f_intentproduct;
  53. private int? _f_createby = 0;
  54. private DateTime? _f_createdon;
  55. private int? _f_modifyby = 0;
  56. private DateTime? _f_modifiedon;
  57. private int? _f_deleteflag = 0;
  58. private int? _f_statuscode = 0;
  59. private string _f_servicedept;
  60. private string _f_chargename;
  61. private string _f_chargetelephone;
  62. private string _f_province;
  63. private string _f_productline;
  64. private string _f_chargedept;
  65. private string _f_aftersalename;
  66. private string _f_customernature;
  67. private string _f_customerclass;
  68. private string _f_customerindustry;
  69. private string _f_relationshipclass;
  70. private string _f_currentversion;
  71. private DateTime? _f_systemstarttime;
  72. private DateTime? _f_qualityguaranteeendtime;
  73. private string _f_aftersaletelephone;
  74. private string _f_notes;
  75. private string _f_systemtype;
  76. private string _f_city;
  77. private string _f_customerstatus;
  78. private int? _f_devicecount;
  79. private string _f_maintenancetype;
  80. private string _f_erpcustomercode;
  81. private int? _f_servicedeptid;
  82. private int? _f_productlineid;
  83. private int? _f_aftersalenameid;
  84. private int? _f_customernatureid;
  85. private int? _f_customerclassid;
  86. private int? _f_relationshipclassid;
  87. private int? _f_cityid;
  88. private int? _f_autoflag;
  89. private string _f_result;
  90. private int? _f_fileid;
  91. // alter table T_Cus_CustomerBase add F_SaleOffice[nvarchar] (100)
  92. //alter table T_Cus_CustomerBase add F_AccessTime[nvarchar] (100)
  93. //alter table T_Cus_CustomerBase add F_BroadbandAccount[nvarchar] (100)
  94. // alter table T_Cus_CustomerBase add F_Channel[nvarchar] (100)
  95. //alter table T_Cus_CustomerBase add F_Fusion[nvarchar] (50)
  96. private string _F_SaleOffice;
  97. private string _F_AccessTime;
  98. private string _F_BroadbandAccount;
  99. private string _F_Channele;
  100. private string _F_Fusion;
  101. //
  102. public string F_SaleOffice
  103. {
  104. set { _F_SaleOffice = value; }
  105. get { return _F_SaleOffice; }
  106. }
  107. public string F_AccessTime
  108. {
  109. set { _F_AccessTime = value; }
  110. get { return _F_AccessTime; }
  111. }
  112. public string F_BroadbandAccount
  113. {
  114. set { _F_BroadbandAccount = value; }
  115. get { return _F_BroadbandAccount; }
  116. }
  117. public string F_Channel
  118. {
  119. set { _F_Channele = value; }
  120. get { return _F_Channele; }
  121. }
  122. public string F_Fusion
  123. {
  124. set { _F_Fusion = value; }
  125. get { return _F_Fusion; }
  126. }
  127. /// <summary>
  128. ///
  129. /// </summary>
  130. public int F_CustomerId
  131. {
  132. set { _f_customerid = value; }
  133. get { return _f_customerid; }
  134. }
  135. /// <summary>
  136. ///
  137. /// </summary>
  138. public string F_CustomerName
  139. {
  140. set { _f_customername = value; }
  141. get { return _f_customername; }
  142. }
  143. /// <summary>
  144. ///
  145. /// </summary>
  146. public string F_CustomerCode
  147. {
  148. set { _f_customercode = value; }
  149. get { return _f_customercode; }
  150. }
  151. /// <summary>
  152. ///
  153. /// </summary>
  154. public string F_CustomerEName
  155. {
  156. set { _f_customerename = value; }
  157. get { return _f_customerename; }
  158. }
  159. /// <summary>
  160. ///
  161. /// </summary>
  162. public string F_CustomerPym
  163. {
  164. set { _f_customerpym = value; }
  165. get { return _f_customerpym; }
  166. }
  167. /// <summary>
  168. ///
  169. /// </summary>
  170. public int? F_Layer
  171. {
  172. set { _f_layer = value; }
  173. get { return _f_layer; }
  174. }
  175. /// <summary>
  176. ///
  177. /// </summary>
  178. public string F_CustomerLayer
  179. {
  180. set { _f_customerlayer = value; }
  181. get { return _f_customerlayer; }
  182. }
  183. /// <summary>
  184. ///
  185. /// </summary>
  186. public int? F_CategoryId
  187. {
  188. set { _f_categoryid = value; }
  189. get { return _f_categoryid; }
  190. }
  191. /// <summary>
  192. ///
  193. /// </summary>
  194. public int? F_TradeId
  195. {
  196. set { _f_tradeid = value; }
  197. get { return _f_tradeid; }
  198. }
  199. /// <summary>
  200. ///
  201. /// </summary>
  202. public int? F_RegionId
  203. {
  204. set { _f_regionid = value; }
  205. get { return _f_regionid; }
  206. }
  207. /// <summary>
  208. ///
  209. /// </summary>
  210. public int? F_IndustryId
  211. {
  212. set { _f_industryid = value; }
  213. get { return _f_industryid; }
  214. }
  215. /// <summary>
  216. ///
  217. /// </summary>
  218. public string F_Address
  219. {
  220. set { _f_address = value; }
  221. get { return _f_address; }
  222. }
  223. /// <summary>
  224. ///
  225. /// </summary>
  226. public string F_Url
  227. {
  228. set { _f_url = value; }
  229. get { return _f_url; }
  230. }
  231. /// <summary>
  232. ///
  233. /// </summary>
  234. public string F_Telephone
  235. {
  236. set { _f_telephone = value; }
  237. get { return _f_telephone; }
  238. }
  239. /// <summary>
  240. ///
  241. /// </summary>
  242. public string F_Mobile
  243. {
  244. set { _f_mobile = value; }
  245. get { return _f_mobile; }
  246. }
  247. /// <summary>
  248. ///
  249. /// </summary>
  250. public string F_Fax
  251. {
  252. set { _f_fax = value; }
  253. get { return _f_fax; }
  254. }
  255. /// <summary>
  256. ///
  257. /// </summary>
  258. public string F_Email
  259. {
  260. set { _f_email = value; }
  261. get { return _f_email; }
  262. }
  263. /// <summary>
  264. ///
  265. /// </summary>
  266. public string F_Website
  267. {
  268. set { _f_website = value; }
  269. get { return _f_website; }
  270. }
  271. /// <summary>
  272. ///
  273. /// </summary>
  274. public string F_PostCode
  275. {
  276. set { _f_postcode = value; }
  277. get { return _f_postcode; }
  278. }
  279. /// <summary>
  280. ///
  281. /// </summary>
  282. public string F_ScaleResume
  283. {
  284. set { _f_scaleresume = value; }
  285. get { return _f_scaleresume; }
  286. }
  287. /// <summary>
  288. ///
  289. /// </summary>
  290. public string F_BusinessProfile
  291. {
  292. set { _f_businessprofile = value; }
  293. get { return _f_businessprofile; }
  294. }
  295. /// <summary>
  296. ///
  297. /// </summary>
  298. public string F_BusinessLicenseID
  299. {
  300. set { _f_businesslicenseid = value; }
  301. get { return _f_businesslicenseid; }
  302. }
  303. /// <summary>
  304. ///
  305. /// </summary>
  306. public string F_TaxID
  307. {
  308. set { _f_taxid = value; }
  309. get { return _f_taxid; }
  310. }
  311. /// <summary>
  312. ///
  313. /// </summary>
  314. public string F_OpeningBank
  315. {
  316. set { _f_openingbank = value; }
  317. get { return _f_openingbank; }
  318. }
  319. /// <summary>
  320. ///
  321. /// </summary>
  322. public string F_BankAccount
  323. {
  324. set { _f_bankaccount = value; }
  325. get { return _f_bankaccount; }
  326. }
  327. /// <summary>
  328. ///
  329. /// </summary>
  330. public string F_LegalRepresentative
  331. {
  332. set { _f_legalrepresentative = value; }
  333. get { return _f_legalrepresentative; }
  334. }
  335. /// <summary>
  336. ///
  337. /// </summary>
  338. public string F_LegalRepresentativeCardID
  339. {
  340. set { _f_legalrepresentativecardid = value; }
  341. get { return _f_legalrepresentativecardid; }
  342. }
  343. /// <summary>
  344. ///
  345. /// </summary>
  346. public string F_Nature
  347. {
  348. set { _f_nature = value; }
  349. get { return _f_nature; }
  350. }
  351. /// <summary>
  352. ///
  353. /// </summary>
  354. public string F_Kind
  355. {
  356. set { _f_kind = value; }
  357. get { return _f_kind; }
  358. }
  359. /// <summary>
  360. ///
  361. /// </summary>
  362. public int? F_CustomerType
  363. {
  364. set { _f_customertype = value; }
  365. get { return _f_customertype; }
  366. }
  367. /// <summary>
  368. ///
  369. /// </summary>
  370. public string F_MainProduct
  371. {
  372. set { _f_mainproduct = value; }
  373. get { return _f_mainproduct; }
  374. }
  375. /// <summary>
  376. ///
  377. /// </summary>
  378. public string F_CustomerFrom
  379. {
  380. set { _f_customerfrom = value; }
  381. get { return _f_customerfrom; }
  382. }
  383. /// <summary>
  384. ///
  385. /// </summary>
  386. public string F_TrackInfo
  387. {
  388. set { _f_trackinfo = value; }
  389. get { return _f_trackinfo; }
  390. }
  391. /// <summary>
  392. ///
  393. /// </summary>
  394. public string F_TrackState
  395. {
  396. set { _f_trackstate = value; }
  397. get { return _f_trackstate; }
  398. }
  399. /// <summary>
  400. ///
  401. /// </summary>
  402. public string F_ImportDegree
  403. {
  404. set { _f_importdegree = value; }
  405. get { return _f_importdegree; }
  406. }
  407. /// <summary>
  408. ///
  409. /// </summary>
  410. public string F_IntentProduct
  411. {
  412. set { _f_intentproduct = value; }
  413. get { return _f_intentproduct; }
  414. }
  415. /// <summary>
  416. ///
  417. /// </summary>
  418. public int? F_CreateBy
  419. {
  420. set { _f_createby = value; }
  421. get { return _f_createby; }
  422. }
  423. /// <summary>
  424. ///
  425. /// </summary>
  426. public DateTime? F_CreatedOn
  427. {
  428. set { _f_createdon = value; }
  429. get { return _f_createdon; }
  430. }
  431. /// <summary>
  432. ///
  433. /// </summary>
  434. public int? F_ModifyBy
  435. {
  436. set { _f_modifyby = value; }
  437. get { return _f_modifyby; }
  438. }
  439. /// <summary>
  440. ///
  441. /// </summary>
  442. public DateTime? F_ModifiedOn
  443. {
  444. set { _f_modifiedon = value; }
  445. get { return _f_modifiedon; }
  446. }
  447. /// <summary>
  448. ///
  449. /// </summary>
  450. public int? F_DeleteFlag
  451. {
  452. set { _f_deleteflag = value; }
  453. get { return _f_deleteflag; }
  454. }
  455. /// <summary>
  456. ///
  457. /// </summary>
  458. public int? F_StatusCode
  459. {
  460. set { _f_statuscode = value; }
  461. get { return _f_statuscode; }
  462. }
  463. /// <summary>
  464. ///
  465. /// </summary>
  466. public string F_ServiceDept
  467. {
  468. set { _f_servicedept = value; }
  469. get { return _f_servicedept; }
  470. }
  471. /// <summary>
  472. ///
  473. /// </summary>
  474. public string F_ChargeName
  475. {
  476. set { _f_chargename = value; }
  477. get { return _f_chargename; }
  478. }
  479. /// <summary>
  480. ///
  481. /// </summary>
  482. public string F_ChargeTelephone
  483. {
  484. set { _f_chargetelephone = value; }
  485. get { return _f_chargetelephone; }
  486. }
  487. /// <summary>
  488. ///
  489. /// </summary>
  490. public string F_Province
  491. {
  492. set { _f_province = value; }
  493. get { return _f_province; }
  494. }
  495. /// <summary>
  496. ///
  497. /// </summary>
  498. public string F_ProductLine
  499. {
  500. set { _f_productline = value; }
  501. get { return _f_productline; }
  502. }
  503. /// <summary>
  504. /// 负责部门
  505. /// </summary>
  506. public string F_ChargeDept
  507. {
  508. set { _f_chargedept = value; }
  509. get { return _f_chargedept; }
  510. }
  511. /// <summary>
  512. ///
  513. /// </summary>
  514. public string F_AfterSaleName
  515. {
  516. set { _f_aftersalename = value; }
  517. get { return _f_aftersalename; }
  518. }
  519. /// <summary>
  520. ///
  521. /// </summary>
  522. public string F_CustomerNature
  523. {
  524. set { _f_customernature = value; }
  525. get { return _f_customernature; }
  526. }
  527. /// <summary>
  528. ///
  529. /// </summary>
  530. public string F_CustomerClass
  531. {
  532. set { _f_customerclass = value; }
  533. get { return _f_customerclass; }
  534. }
  535. /// <summary>
  536. ///
  537. /// </summary>
  538. public string F_CustomerIndustry
  539. {
  540. set { _f_customerindustry = value; }
  541. get { return _f_customerindustry; }
  542. }
  543. /// <summary>
  544. ///
  545. /// </summary>
  546. public string F_RelationShipClass
  547. {
  548. set { _f_relationshipclass = value; }
  549. get { return _f_relationshipclass; }
  550. }
  551. /// <summary>
  552. ///
  553. /// </summary>
  554. public string F_CurrentVersion
  555. {
  556. set { _f_currentversion = value; }
  557. get { return _f_currentversion; }
  558. }
  559. /// <summary>
  560. ///
  561. /// </summary>
  562. public DateTime? F_SystemStartTime
  563. {
  564. set { _f_systemstarttime = value; }
  565. get { return _f_systemstarttime; }
  566. }
  567. /// <summary>
  568. ///
  569. /// </summary>
  570. public DateTime? F_QualityGuaranteeEndTime
  571. {
  572. set { _f_qualityguaranteeendtime = value; }
  573. get { return _f_qualityguaranteeendtime; }
  574. }
  575. /// <summary>
  576. ///
  577. /// </summary>
  578. public string F_AfterSaleTelephone
  579. {
  580. set { _f_aftersaletelephone = value; }
  581. get { return _f_aftersaletelephone; }
  582. }
  583. /// <summary>
  584. ///
  585. /// </summary>
  586. public string F_Notes
  587. {
  588. set { _f_notes = value; }
  589. get { return _f_notes; }
  590. }
  591. /// <summary>
  592. ///
  593. /// </summary>
  594. public string F_SystemType
  595. {
  596. set { _f_systemtype = value; }
  597. get { return _f_systemtype; }
  598. }
  599. /// <summary>
  600. ///
  601. /// </summary>
  602. public string F_City
  603. {
  604. set { _f_city = value; }
  605. get { return _f_city; }
  606. }
  607. /// <summary>
  608. ///
  609. /// </summary>
  610. public string F_CustomerStatus
  611. {
  612. set { _f_customerstatus = value; }
  613. get { return _f_customerstatus; }
  614. }
  615. /// <summary>
  616. ///
  617. /// </summary>
  618. public int? F_DeviceCount
  619. {
  620. set { _f_devicecount = value; }
  621. get { return _f_devicecount; }
  622. }
  623. /// <summary>
  624. ///
  625. /// </summary>
  626. public string F_MaintenanceType
  627. {
  628. set { _f_maintenancetype = value; }
  629. get { return _f_maintenancetype; }
  630. }
  631. /// <summary>
  632. ///
  633. /// </summary>
  634. public string F_ERPCustomerCode
  635. {
  636. set { _f_erpcustomercode = value; }
  637. get { return _f_erpcustomercode; }
  638. }
  639. /// <summary>
  640. ///
  641. /// </summary>
  642. public int? F_ServiceDeptID
  643. {
  644. set { _f_servicedeptid = value; }
  645. get { return _f_servicedeptid; }
  646. }
  647. /// <summary>
  648. ///
  649. /// </summary>
  650. public int? F_ProductLineID
  651. {
  652. set { _f_productlineid = value; }
  653. get { return _f_productlineid; }
  654. }
  655. /// <summary>
  656. ///
  657. /// </summary>
  658. public int? F_AfterSaleNameID
  659. {
  660. set { _f_aftersalenameid = value; }
  661. get { return _f_aftersalenameid; }
  662. }
  663. /// <summary>
  664. ///
  665. /// </summary>
  666. public int? F_CustomerNatureID
  667. {
  668. set { _f_customernatureid = value; }
  669. get { return _f_customernatureid; }
  670. }
  671. /// <summary>
  672. ///
  673. /// </summary>
  674. public int? F_CustomerClassID
  675. {
  676. set { _f_customerclassid = value; }
  677. get { return _f_customerclassid; }
  678. }
  679. /// <summary>
  680. ///
  681. /// </summary>
  682. public int? F_RelationShipClassID
  683. {
  684. set { _f_relationshipclassid = value; }
  685. get { return _f_relationshipclassid; }
  686. }
  687. /// <summary>
  688. ///
  689. /// </summary>
  690. public int? F_CityID
  691. {
  692. set { _f_cityid = value; }
  693. get { return _f_cityid; }
  694. }
  695. #endregion Model
  696. //2017-11-1
  697. /// <summary>
  698. ///
  699. /// </summary>
  700. public string F_Result
  701. {
  702. set { _f_result = value; }
  703. get { return _f_result; }
  704. }
  705. /// <summary>
  706. ///
  707. /// </summary>
  708. public int? F_AutoFlag
  709. {
  710. set { _f_autoflag = value; }
  711. get { return _f_autoflag; }
  712. }
  713. //F_FileID
  714. //2017-11-1
  715. /// <summary>
  716. ///
  717. /// </summary>
  718. public int? F_FileID
  719. {
  720. set { _f_fileid = value; }
  721. get { return _f_fileid; }
  722. }
  723. }
  724. }