Нет описания

T_Wo_WorkOrder.cs 22KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739
  1. using System;
  2. using System.ComponentModel;
  3. namespace CallCenterApi.Model
  4. {
  5. /// <summary>
  6. /// 工单管理表
  7. /// </summary>
  8. [Serializable]
  9. public partial class T_Wo_WorkOrder
  10. {
  11. public T_Wo_WorkOrder()
  12. { }
  13. #region Model
  14. private int _f_id;
  15. private string _f_workordercode;
  16. private string _f_callid;
  17. private string _f_source;
  18. private string _f_type;
  19. private string _f_incidentprovince;
  20. private string _f_incidentcity;
  21. private string _f_incidentcountry;
  22. private string _f_incidenttownship;
  23. private string _f_incidentdetailed;
  24. private string _f_salesbase;
  25. private string _f_description;
  26. private string _f_files;
  27. private string _f_dealtype;
  28. private int? _f_customerid;
  29. private string _f_materialid;
  30. private string _f_questiontype;
  31. private string _f_batchnumber;
  32. private string _f_ts_formula;
  33. private string _f_ts_category;
  34. private string _f_ts_quantity;
  35. private string _f_ts_level;
  36. private string _f_zx_proname;
  37. private string _f_zx_quantity;
  38. private string _f_zx_area;
  39. private string _f_zx_branch;
  40. private DateTime? _f_cj_time;
  41. private string _f_cj_level;
  42. private string _f_cj_unit;
  43. private string _f_cj_testunit;
  44. private string _f_cj_tonnage;
  45. private string _f_cj_bagno;
  46. private string _f_cj_outlay;
  47. private int? _f_state;
  48. private string _f_sc_productbase;
  49. private string _f_sc_preliminaryopinion;
  50. private string _f_sc_qualitymonth;
  51. private string _f_sc_cj_spotresult;
  52. private string _f_sc_cj_selfresult;
  53. private string _f_sc_cj_approvalno;
  54. private string _f_sc_cj_returnaccount;
  55. private string _f_zl_qualityeventlevel;
  56. private string _f_zl_claimamount;
  57. private string _f_zl_responsibleunit;
  58. private string _f_zl_approvalopinions;
  59. private string _f_zl_approvaldisagree;
  60. private string _f_zl_compensationmethod;
  61. private string _f_zl_compensationmoney;
  62. private string _f_zl_cresponsibleunits;
  63. private string _f_zl_fquantity;
  64. private string _f_zl_improvementrequirements;
  65. private string _f_zl_capprovalno;
  66. private string _f_zl_cj_isrecord;
  67. private int? _f_isaudit;
  68. private int? _f_auditstate;
  69. private string _f_auditby;
  70. private DateTime? _f_auditon;
  71. private string _f_auditcont;
  72. private int? _f_isover;
  73. private string _f_dealby;
  74. private DateTime? _f_dealtime;
  75. private string _f_dealcontent;
  76. private string _f_dealresult;
  77. private string _f_dealreasons;
  78. private int? _f_isvisit;
  79. private DateTime? _f_visiton;
  80. private string _f_visitby;
  81. private string _f_visitresult;
  82. private string _f_visitreason;
  83. private string _f_createby;
  84. private DateTime? _f_createon;
  85. private int? _f_updatecount;
  86. private string _f_updateby;
  87. private DateTime? _f_updateon;
  88. private int? _f_isdelete;
  89. private string _f_deleteby;
  90. private DateTime? _f_deleteon;
  91. /// <summary>
  92. /// 工单ID
  93. /// </summary>
  94. public int F_ID
  95. {
  96. set { _f_id = value; }
  97. get { return _f_id; }
  98. }
  99. /// <summary>
  100. /// 工单编号
  101. /// </summary>
  102. public string F_WorkOrderCode
  103. {
  104. set { _f_workordercode = value; }
  105. get { return _f_workordercode; }
  106. }
  107. /// <summary>
  108. /// 通话记录ID
  109. /// </summary>
  110. public string F_CallID
  111. {
  112. set { _f_callid = value; }
  113. get { return _f_callid; }
  114. }
  115. /// <summary>
  116. /// 工单来源:电话、微信业务员、微信客户、官网
  117. /// </summary>
  118. public string F_Source
  119. {
  120. set { _f_source = value; }
  121. get { return _f_source; }
  122. }
  123. /// <summary>
  124. /// 工单类型:咨询及需求、投诉、抽检、其他
  125. /// </summary>
  126. public string F_Type
  127. {
  128. set { _f_type = value; }
  129. get { return _f_type; }
  130. }
  131. /// <summary>
  132. /// 事发地-省
  133. /// </summary>
  134. public string F_IncidentProvince
  135. {
  136. set { _f_incidentprovince = value; }
  137. get { return _f_incidentprovince; }
  138. }
  139. /// <summary>
  140. /// 事发地-市
  141. /// </summary>
  142. public string F_IncidentCity
  143. {
  144. set { _f_incidentcity = value; }
  145. get { return _f_incidentcity; }
  146. }
  147. /// <summary>
  148. /// 事发地-县
  149. /// </summary>
  150. public string F_IncidentCountry
  151. {
  152. set { _f_incidentcountry = value; }
  153. get { return _f_incidentcountry; }
  154. }
  155. /// <summary>
  156. /// 事发地-乡
  157. /// </summary>
  158. public string F_IncidentTownship
  159. {
  160. set { _f_incidenttownship = value; }
  161. get { return _f_incidenttownship; }
  162. }
  163. /// <summary>
  164. /// 事发地-详细
  165. /// </summary>
  166. public string F_IncidentDetailed
  167. {
  168. set { _f_incidentdetailed = value; }
  169. get { return _f_incidentdetailed; }
  170. }
  171. /// <summary>
  172. /// 销售基地:新乡、新疆、九江、东北、其他
  173. /// </summary>
  174. public string F_SalesBase
  175. {
  176. set { _f_salesbase = value; }
  177. get { return _f_salesbase; }
  178. }
  179. /// <summary>
  180. /// 问题描述
  181. /// </summary>
  182. public string F_Description
  183. {
  184. set { _f_description = value; }
  185. get { return _f_description; }
  186. }
  187. /// <summary>
  188. /// 附件上传ids
  189. /// </summary>
  190. public string F_Files
  191. {
  192. set { _f_files = value; }
  193. get { return _f_files; }
  194. }
  195. /// <summary>
  196. /// 处理方式:当即办理、电话转接、网络转办
  197. /// </summary>
  198. public string F_DealType
  199. {
  200. set { _f_dealtype = value; }
  201. get { return _f_dealtype; }
  202. }
  203. /// <summary>
  204. /// 客户id
  205. /// </summary>
  206. public int? F_CustomerID
  207. {
  208. set { _f_customerid = value; }
  209. get { return _f_customerid; }
  210. }
  211. /// <summary>
  212. /// 物料id
  213. /// </summary>
  214. public string F_MaterialID
  215. {
  216. set { _f_materialid = value; }
  217. get { return _f_materialid; }
  218. }
  219. /// <summary>
  220. /// 问题类别
  221. /// </summary>
  222. public string F_QuestionType
  223. {
  224. set { _f_questiontype = value; }
  225. get { return _f_questiontype; }
  226. }
  227. /// <summary>
  228. /// 生产批次号
  229. /// </summary>
  230. public string F_BatchNumber
  231. {
  232. set { _f_batchnumber = value; }
  233. get { return _f_batchnumber; }
  234. }
  235. /// <summary>
  236. /// 投诉-配方
  237. /// </summary>
  238. public string F_TS_Formula
  239. {
  240. set { _f_ts_formula = value; }
  241. get { return _f_ts_formula; }
  242. }
  243. /// <summary>
  244. /// 投诉-产品种类:化肥、化工、其他
  245. /// </summary>
  246. public string F_TS_Category
  247. {
  248. set { _f_ts_category = value; }
  249. get { return _f_ts_category; }
  250. }
  251. /// <summary>
  252. /// 投诉-问题数量(吨)
  253. /// </summary>
  254. public string F_TS_Quantity
  255. {
  256. set { _f_ts_quantity = value; }
  257. get { return _f_ts_quantity; }
  258. }
  259. /// <summary>
  260. /// 投诉-重要级别:轻微、一般、较大、重大
  261. /// </summary>
  262. public string F_TS_Level
  263. {
  264. set { _f_ts_level = value; }
  265. get { return _f_ts_level; }
  266. }
  267. /// <summary>
  268. /// 咨询-产品名称:三聚氰胺、甲醇、液氨、二甲醚、糠醇、其他
  269. /// </summary>
  270. public string F_ZX_ProName
  271. {
  272. set { _f_zx_proname = value; }
  273. get { return _f_zx_proname; }
  274. }
  275. /// <summary>
  276. /// 咨询-问题数量
  277. /// </summary>
  278. public string F_ZX_Quantity
  279. {
  280. set { _f_zx_quantity = value; }
  281. get { return _f_zx_quantity; }
  282. }
  283. /// <summary>
  284. /// 咨询-大区
  285. /// </summary>
  286. public string F_ZX_Area
  287. {
  288. set { _f_zx_area = value; }
  289. get { return _f_zx_area; }
  290. }
  291. /// <summary>
  292. /// 咨询-分公司
  293. /// </summary>
  294. public string F_ZX_Branch
  295. {
  296. set { _f_zx_branch = value; }
  297. get { return _f_zx_branch; }
  298. }
  299. /// <summary>
  300. /// 抽检-抽检时间
  301. /// </summary>
  302. public DateTime? F_CJ_Time
  303. {
  304. set { _f_cj_time = value; }
  305. get { return _f_cj_time; }
  306. }
  307. /// <summary>
  308. /// 抽检-抽检级别:乡镇级、县级、市级、省级及以上、个人送检
  309. /// </summary>
  310. public string F_CJ_Level
  311. {
  312. set { _f_cj_level = value; }
  313. get { return _f_cj_level; }
  314. }
  315. /// <summary>
  316. /// 抽检-抽检单位:市场监督、农业部、土肥站、工商、联合执法、其他
  317. /// </summary>
  318. public string F_CJ_Unit
  319. {
  320. set { _f_cj_unit = value; }
  321. get { return _f_cj_unit; }
  322. }
  323. /// <summary>
  324. /// 抽检-化验单位
  325. /// </summary>
  326. public string F_CJ_TestUnit
  327. {
  328. set { _f_cj_testunit = value; }
  329. get { return _f_cj_testunit; }
  330. }
  331. /// <summary>
  332. /// 抽检-抽检吨数
  333. /// </summary>
  334. public string F_CJ_Tonnage
  335. {
  336. set { _f_cj_tonnage = value; }
  337. get { return _f_cj_tonnage; }
  338. }
  339. /// <summary>
  340. /// 抽检-抽检袋数
  341. /// </summary>
  342. public string F_CJ_BagNo
  343. {
  344. set { _f_cj_bagno = value; }
  345. get { return _f_cj_bagno; }
  346. }
  347. /// <summary>
  348. /// 抽检-公关费用金额:单位元
  349. /// </summary>
  350. public string F_CJ_Outlay
  351. {
  352. set { _f_cj_outlay = value; }
  353. get { return _f_cj_outlay; }
  354. }
  355. /// <summary>
  356. /// 工单状态
  357. /// </summary>
  358. public int? F_State
  359. {
  360. set { _f_state = value; }
  361. get { return _f_state; }
  362. }
  363. /// <summary>
  364. /// 市场管理科-生产基地(新乡、新疆、九江、东北、贴牌、无法确定)
  365. /// </summary>
  366. public string F_SC_ProductBase
  367. {
  368. set { _f_sc_productbase = value; }
  369. get { return _f_sc_productbase; }
  370. }
  371. /// <summary>
  372. /// 市场管理科-初审意见:退货、换货、补偿、自行处理
  373. /// </summary>
  374. public string F_SC_PreliminaryOpinion
  375. {
  376. set { _f_sc_preliminaryopinion = value; }
  377. get { return _f_sc_preliminaryopinion; }
  378. }
  379. /// <summary>
  380. /// 市场管理科-超出质保期限(算法:工单创建日期-生产日期,生产日期根据生产批次号获取,单位:月)
  381. /// </summary>
  382. public string F_SC_QualityMonth
  383. {
  384. set { _f_sc_qualitymonth = value; }
  385. get { return _f_sc_qualitymonth; }
  386. }
  387. /// <summary>
  388. /// 市场管理科-抽检-抽检结果(视同合格、合格、不合格、复检后合格、未送检)
  389. /// </summary>
  390. public string F_SC_CJ_SpotResult
  391. {
  392. set { _f_sc_cj_spotresult = value; }
  393. get { return _f_sc_cj_spotresult; }
  394. }
  395. /// <summary>
  396. /// 市场管理科-抽检-自检结果
  397. /// </summary>
  398. public string F_SC_CJ_SelfResult
  399. {
  400. set { _f_sc_cj_selfresult = value; }
  401. get { return _f_sc_cj_selfresult; }
  402. }
  403. /// <summary>
  404. /// 市场管理科-抽检-对应审批工作流单号
  405. /// </summary>
  406. public string F_SC_CJ_ApprovalNo
  407. {
  408. set { _f_sc_cj_approvalno = value; }
  409. get { return _f_sc_cj_approvalno; }
  410. }
  411. /// <summary>
  412. /// 市场管理科-抽检-确认返账金额(元)
  413. /// </summary>
  414. public string F_SC_CJ_ReturnAccount
  415. {
  416. set { _f_sc_cj_returnaccount = value; }
  417. get { return _f_sc_cj_returnaccount; }
  418. }
  419. /// <summary>
  420. /// 质量管理科-质量事件等级(未遂、一般、较大、重大)
  421. /// </summary>
  422. public string F_ZL_QualityEventLevel
  423. {
  424. set { _f_zl_qualityeventlevel = value; }
  425. get { return _f_zl_qualityeventlevel; }
  426. }
  427. /// <summary>
  428. /// 质量管理科-索赔金额(单位元,对应责任单位)
  429. /// </summary>
  430. public string F_ZL_ClaimAmount
  431. {
  432. set { _f_zl_claimamount = value; }
  433. get { return _f_zl_claimamount; }
  434. }
  435. /// <summary>
  436. /// 质量管理科-责任单位(需列出,可选多个)
  437. /// </summary>
  438. public string F_ZL_ResponsibleUnit
  439. {
  440. set { _f_zl_responsibleunit = value; }
  441. get { return _f_zl_responsibleunit; }
  442. }
  443. /// <summary>
  444. /// 质量管理科-审批意见(同意、不同意,若选择不同意,增加输入框输入补充内容)
  445. /// </summary>
  446. public string F_ZL_ApprovalOpinions
  447. {
  448. set { _f_zl_approvalopinions = value; }
  449. get { return _f_zl_approvalopinions; }
  450. }
  451. /// <summary>
  452. /// 质量管理科-审批不同意意见
  453. /// </summary>
  454. public string F_ZL_ApprovalDisagree
  455. {
  456. set { _f_zl_approvaldisagree = value; }
  457. get { return _f_zl_approvaldisagree; }
  458. }
  459. /// <summary>
  460. /// 质量管理科-补偿方式(实物、钱款【单位元】,若选择钱款,增加输入框输入补充内容)
  461. /// </summary>
  462. public string F_ZL_CompensationMethod
  463. {
  464. set { _f_zl_compensationmethod = value; }
  465. get { return _f_zl_compensationmethod; }
  466. }
  467. /// <summary>
  468. /// 质量管理科-补偿钱款
  469. /// </summary>
  470. public string F_ZL_CompensationMoney
  471. {
  472. set { _f_zl_compensationmoney = value; }
  473. get { return _f_zl_compensationmoney; }
  474. }
  475. /// <summary>
  476. /// 质量管理科-对应责任单位(生产、研发、农化、物流、质量管理科,销售内勤)
  477. /// </summary>
  478. public string F_ZL_CResponsibleUnits
  479. {
  480. set { _f_zl_cresponsibleunits = value; }
  481. get { return _f_zl_cresponsibleunits; }
  482. }
  483. /// <summary>
  484. /// 质量管理科-确认实收数量(吨)
  485. /// </summary>
  486. public string F_ZL_Fquantity
  487. {
  488. set { _f_zl_fquantity = value; }
  489. get { return _f_zl_fquantity; }
  490. }
  491. /// <summary>
  492. /// 质量管理科-改进要求
  493. /// </summary>
  494. public string F_ZL_ImprovementRequirements
  495. {
  496. set { _f_zl_improvementrequirements = value; }
  497. get { return _f_zl_improvementrequirements; }
  498. }
  499. /// <summary>
  500. /// 质量管理科-对应审批工作流单号
  501. /// </summary>
  502. public string F_ZL_CApprovalNo
  503. {
  504. set { _f_zl_capprovalno = value; }
  505. get { return _f_zl_capprovalno; }
  506. }
  507. /// <summary>
  508. /// 质量管理科-抽检-未备案、已备案
  509. /// </summary>
  510. public string F_ZL_CJ_IsRecord
  511. {
  512. set { _f_zl_cj_isrecord = value; }
  513. get { return _f_zl_cj_isrecord; }
  514. }
  515. /// <summary>
  516. /// 是否审核
  517. /// </summary>
  518. public int? F_IsAudit
  519. {
  520. set { _f_isaudit = value; }
  521. get { return _f_isaudit; }
  522. }
  523. /// <summary>
  524. /// 审核状态
  525. /// </summary>
  526. public int? F_AuditState
  527. {
  528. set { _f_auditstate = value; }
  529. get { return _f_auditstate; }
  530. }
  531. /// <summary>
  532. /// 审核人
  533. /// </summary>
  534. public string F_AuditBy
  535. {
  536. set { _f_auditby = value; }
  537. get { return _f_auditby; }
  538. }
  539. /// <summary>
  540. /// 审核时间
  541. /// </summary>
  542. public DateTime? F_AuditOn
  543. {
  544. set { _f_auditon = value; }
  545. get { return _f_auditon; }
  546. }
  547. /// <summary>
  548. /// 审核内容
  549. /// </summary>
  550. public string F_AuditCont
  551. {
  552. set { _f_auditcont = value; }
  553. get { return _f_auditcont; }
  554. }
  555. /// <summary>
  556. /// 是否超时
  557. /// </summary>
  558. public int? F_IsOver
  559. {
  560. set { _f_isover = value; }
  561. get { return _f_isover; }
  562. }
  563. /// <summary>
  564. /// 处理人
  565. /// </summary>
  566. public string F_DealBy
  567. {
  568. set { _f_dealby = value; }
  569. get { return _f_dealby; }
  570. }
  571. /// <summary>
  572. /// 处理时间
  573. /// </summary>
  574. public DateTime? F_DealTime
  575. {
  576. set { _f_dealtime = value; }
  577. get { return _f_dealtime; }
  578. }
  579. /// <summary>
  580. /// 处理内容
  581. /// </summary>
  582. public string F_DealContent
  583. {
  584. set { _f_dealcontent = value; }
  585. get { return _f_dealcontent; }
  586. }
  587. /// <summary>
  588. /// 处理结果:已处理,未处理
  589. /// </summary>
  590. public string F_DealResult
  591. {
  592. set { _f_dealresult = value; }
  593. get { return _f_dealresult; }
  594. }
  595. /// <summary>
  596. /// 未处理原因:资金、技术、人员、其他(若选其他,则手输)
  597. /// </summary>
  598. public string F_DealReasons
  599. {
  600. set { _f_dealreasons = value; }
  601. get { return _f_dealreasons; }
  602. }
  603. /// <summary>
  604. /// 是否建议回访(是,否)此项若选是,则流转到客服-待回访工单,若选否,则流转至客服待完结工单
  605. /// </summary>
  606. public int? F_IsVisit
  607. {
  608. set { _f_isvisit = value; }
  609. get { return _f_isvisit; }
  610. }
  611. /// <summary>
  612. /// 回访时间
  613. /// </summary>
  614. public DateTime? F_VisitOn
  615. {
  616. set { _f_visiton = value; }
  617. get { return _f_visiton; }
  618. }
  619. /// <summary>
  620. /// 回访人
  621. /// </summary>
  622. public string F_VisitBy
  623. {
  624. set { _f_visitby = value; }
  625. get { return _f_visitby; }
  626. }
  627. /// <summary>
  628. /// 回访结果:非常满意、满意、一般、不满意
  629. /// </summary>
  630. public string F_VisitResult
  631. {
  632. set { _f_visitresult = value; }
  633. get { return _f_visitresult; }
  634. }
  635. /// <summary>
  636. /// 回访不满意原因
  637. /// </summary>
  638. public string F_VisitReason
  639. {
  640. set { _f_visitreason = value; }
  641. get { return _f_visitreason; }
  642. }
  643. /// <summary>
  644. /// 添加人工号
  645. /// </summary>
  646. public string F_CreateBy
  647. {
  648. set { _f_createby = value; }
  649. get { return _f_createby; }
  650. }
  651. /// <summary>
  652. /// 添加时间
  653. /// </summary>
  654. public DateTime? F_CreateOn
  655. {
  656. set { _f_createon = value; }
  657. get { return _f_createon; }
  658. }
  659. /// <summary>
  660. /// 修改次数
  661. /// </summary>
  662. public int? F_UpdateCount
  663. {
  664. set { _f_updatecount = value; }
  665. get { return _f_updatecount; }
  666. }
  667. /// <summary>
  668. /// 修改人工号
  669. /// </summary>
  670. public string F_UpdateBy
  671. {
  672. set { _f_updateby = value; }
  673. get { return _f_updateby; }
  674. }
  675. /// <summary>
  676. /// 修改时间
  677. /// </summary>
  678. public DateTime? F_UpdateOn
  679. {
  680. set { _f_updateon = value; }
  681. get { return _f_updateon; }
  682. }
  683. /// <summary>
  684. /// 是否删除:0否,1是
  685. /// </summary>
  686. public int? F_IsDelete
  687. {
  688. set { _f_isdelete = value; }
  689. get { return _f_isdelete; }
  690. }
  691. /// <summary>
  692. /// 删除人工号
  693. /// </summary>
  694. public string F_DeleteBy
  695. {
  696. set { _f_deleteby = value; }
  697. get { return _f_deleteby; }
  698. }
  699. /// <summary>
  700. /// 删除时间
  701. /// </summary>
  702. public DateTime? F_DeleteOn
  703. {
  704. set { _f_deleteon = value; }
  705. get { return _f_deleteon; }
  706. }
  707. #endregion Model
  708. }
  709. /// <summary>
  710. /// 工单类型枚举
  711. /// </summary>
  712. public enum EnumWOType
  713. {
  714. /// <summary>
  715. /// 投诉
  716. /// </summary>
  717. [Description("投诉")]
  718. Complaint=1,
  719. /// <summary>
  720. /// 抽检
  721. /// </summary>
  722. [Description("抽检")]
  723. SpotCheck,
  724. /// <summary>
  725. /// 咨询及需求
  726. /// </summary>
  727. [Description("咨询及需求")]
  728. ConsultingNeeds,
  729. /// <summary>
  730. /// 其他
  731. /// </summary>
  732. [Description("其他")]
  733. Other
  734. }
  735. }