VrpEntrustedBillEntity.cs 20 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766
  1. using Core.Mes.Client.Comm.Attribute;
  2. using System;
  3. using System.Collections.Generic;
  4. using System.ComponentModel;
  5. using System.Linq;
  6. using System.Text;
  7. namespace Core.StlMes.Client.Mcp.VRP.Entity
  8. {/// <summary>
  9. /// 数据库表VRP_ENTRUSTED_BILL所对应的实体类(生成工具:代码生成工具3.0)
  10. /// 作者:PC-20160925CXYF 时间:2016-10-17
  11. /// </summary>
  12. public class VrpEntrustedBillEntity
  13. {
  14. /// <summary>
  15. /// 委外单号
  16. /// </summary>
  17. private string subcontractNo = "";
  18. /// <summary>
  19. /// 委外单号序号
  20. /// </summary>
  21. private string subcontractNoSeq = "";
  22. /// <summary>
  23. /// 产线代码
  24. /// </summary>
  25. private string plineCode = "";
  26. /// <summary>
  27. /// 产线描述
  28. /// </summary>
  29. private string plineName = "";
  30. /// <summary>
  31. /// 工序点代码(上料。。。。)
  32. /// </summary>
  33. private string stationCode = "";
  34. /// <summary>
  35. /// 工序点名称
  36. /// </summary>
  37. private string stationDesc = "";
  38. /// <summary>
  39. /// 炉批计划ID
  40. /// </summary>
  41. private string heatPlanNo = "";
  42. /// <summary>
  43. /// 镦拔扩作业批次号
  44. /// </summary>
  45. private string zyBatchId = "";
  46. /// <summary>
  47. /// 镦拔扩订单编号(当前存工序合同号)
  48. /// </summary>
  49. private string proPlanId = "";
  50. /// <summary>
  51. /// 镦拔扩订单排产序号
  52. /// </summary>
  53. private string gxPlanNo = "";
  54. /// <summary>
  55. /// 判定炉号
  56. /// </summary>
  57. private string judgeStoveNo = "";
  58. /// <summary>
  59. /// 批号(炉批号)
  60. /// </summary>
  61. private string batchNo = "";
  62. /// <summary>
  63. /// 品名代码
  64. /// </summary>
  65. private string produccode = "";
  66. /// <summary>
  67. /// 品名描述
  68. /// </summary>
  69. private string producname = "";
  70. /// <summary>
  71. /// 钢级(牌号)代码
  72. /// </summary>
  73. private string steelcode = "";
  74. /// <summary>
  75. /// 钢级(牌号)名称
  76. /// </summary>
  77. private string steelname = "";
  78. /// <summary>
  79. /// 钢种代码
  80. /// </summary>
  81. private string gradecode = "";
  82. /// <summary>
  83. /// 钢种名称
  84. /// </summary>
  85. private string gradename = "";
  86. /// <summary>
  87. /// 扣型代码
  88. /// </summary>
  89. private string modelCode = "";
  90. /// <summary>
  91. /// 扣型描述
  92. /// </summary>
  93. private string modelDesc = "";
  94. /// <summary>
  95. /// 标准代码
  96. /// </summary>
  97. private string stdCode = "";
  98. /// <summary>
  99. /// 标准名称
  100. /// </summary>
  101. private string stdName = "";
  102. /// <summary>
  103. /// 标准类别代码
  104. /// </summary>
  105. private string stdStyle = "";
  106. /// <summary>
  107. /// 标准类别描述(PSL1....)
  108. /// </summary>
  109. private string stdStyleDesc = "";
  110. /// <summary>
  111. /// 外径(实际)
  112. /// </summary>
  113. private decimal? actDimater = null;
  114. /// <summary>
  115. /// 壁厚(实际)
  116. /// </summary>
  117. private decimal? actHeight = null;
  118. /// <summary>
  119. /// 长度(实际)
  120. /// </summary>
  121. private decimal? actLen = null;
  122. /// <summary>
  123. /// 长度下限(实际)
  124. /// </summary>
  125. private string actLenMin = "";
  126. /// <summary>
  127. /// 长度上限(实际)
  128. /// </summary>
  129. private string actLenMax = "";
  130. /// <summary>
  131. /// 工艺文件号
  132. /// </summary>
  133. private string craftFileNo = "";
  134. /// <summary>
  135. /// 委外支数
  136. /// </summary>
  137. private decimal? subcontractNum = null;
  138. /// <summary>
  139. /// 委外重量
  140. /// </summary>
  141. private decimal? subcontractWt = null;
  142. /// <summary>
  143. /// 委外回报合格支数
  144. /// </summary>
  145. private decimal? hbCompleteNum = null;
  146. /// <summary>
  147. /// 委外回报合格重量
  148. /// </summary>
  149. private decimal? hbCompleteWt = null;
  150. /// <summary>
  151. /// 委托操作人
  152. /// </summary>
  153. private string subcontractUser = "";
  154. /// <summary>
  155. /// 委托操作班次
  156. /// </summary>
  157. private string subcontractShift = "";
  158. /// <summary>
  159. /// 委托操作班组
  160. /// </summary>
  161. private string subcontractGroup = "";
  162. /// <summary>
  163. /// 委托操作时间
  164. /// </summary>
  165. private string subcontractTime = "";
  166. /// <summary>
  167. /// 审批操作人
  168. /// </summary>
  169. private string spUser = "";
  170. /// <summary>
  171. /// 审批操作时间
  172. /// </summary>
  173. private string spTime = "";
  174. /// <summary>
  175. /// 委托单状态(00:初始值、10:审核通过、20审核不通过、30委外回报完毕)
  176. /// </summary>
  177. private string subcontractLog = "";
  178. /// <summary>
  179. /// 委外产线代码
  180. /// </summary>
  181. private string subcontractPlineCode = "";
  182. /// <summary>
  183. /// 委外产线描述
  184. /// </summary>
  185. private string subcontractPlineName = "";
  186. /// <summary>
  187. /// 委外说明(委托单位)
  188. /// </summary>
  189. private string subcontractNote = "";
  190. /// <summary>
  191. /// 委外回报废品支数
  192. /// </summary>
  193. private decimal? hbFpNum = null;
  194. /// <summary>
  195. /// 委外回报废品重量
  196. /// </summary>
  197. private decimal? hbFpWt = null;
  198. /// <summary>
  199. /// 审批说明
  200. /// </summary>
  201. private string spNote = "";
  202. /// <summary>
  203. /// 委外单号
  204. /// </summary>
  205. [Description("委外单号")]
  206. [Nullable(false)]
  207. [DataLength(20)]
  208. public string SubcontractNo
  209. {
  210. get { return subcontractNo; }
  211. set { subcontractNo = value; }
  212. }
  213. /// <summary>
  214. /// 委外单号序号
  215. /// </summary>
  216. [Description("委外单号序号")]
  217. [Nullable(false)]
  218. [DataLength(20)]
  219. public string SubcontractNoSeq
  220. {
  221. get { return subcontractNoSeq; }
  222. set { subcontractNoSeq = value; }
  223. }
  224. /// <summary>
  225. /// 产线代码
  226. /// </summary>
  227. [Description("产线代码")]
  228. [Nullable(true)]
  229. [DataLength(20)]
  230. public string PlineCode
  231. {
  232. get { return plineCode; }
  233. set { plineCode = value; }
  234. }
  235. /// <summary>
  236. /// 产线描述
  237. /// </summary>
  238. [Description("产线描述")]
  239. [Nullable(true)]
  240. [DataLength(40)]
  241. public string PlineName
  242. {
  243. get { return plineName; }
  244. set { plineName = value; }
  245. }
  246. /// <summary>
  247. /// 工序点代码(上料。。。。)
  248. /// </summary>
  249. [Description("工序点代码(上料。。。。)")]
  250. [Nullable(true)]
  251. [DataLength(20)]
  252. public string StationCode
  253. {
  254. get { return stationCode; }
  255. set { stationCode = value; }
  256. }
  257. /// <summary>
  258. /// 工序点名称
  259. /// </summary>
  260. [Description("工序点名称")]
  261. [Nullable(true)]
  262. [DataLength(40)]
  263. public string StationDesc
  264. {
  265. get { return stationDesc; }
  266. set { stationDesc = value; }
  267. }
  268. /// <summary>
  269. /// 炉批计划ID
  270. /// </summary>
  271. [Description("炉批计划ID")]
  272. [Nullable(true)]
  273. [DataLength(20)]
  274. public string HeatPlanNo
  275. {
  276. get { return heatPlanNo; }
  277. set { heatPlanNo = value; }
  278. }
  279. /// <summary>
  280. /// 镦拔扩作业批次号
  281. /// </summary>
  282. [Description("镦拔扩作业批次号")]
  283. [Nullable(true)]
  284. [DataLength(20)]
  285. public string ZyBatchId
  286. {
  287. get { return zyBatchId; }
  288. set { zyBatchId = value; }
  289. }
  290. /// <summary>
  291. /// 镦拔扩订单编号(当前存工序合同号)
  292. /// </summary>
  293. [Description("镦拔扩订单编号(当前存工序合同号)")]
  294. [Nullable(true)]
  295. [DataLength(20)]
  296. public string ProPlanId
  297. {
  298. get { return proPlanId; }
  299. set { proPlanId = value; }
  300. }
  301. /// <summary>
  302. /// 镦拔扩订单排产序号
  303. /// </summary>
  304. [Description("镦拔扩订单排产序号")]
  305. [Nullable(true)]
  306. [DataLength(10)]
  307. public string GxPlanNo
  308. {
  309. get { return gxPlanNo; }
  310. set { gxPlanNo = value; }
  311. }
  312. /// <summary>
  313. /// 判定炉号
  314. /// </summary>
  315. [Description("判定炉号")]
  316. [Nullable(true)]
  317. [DataLength(6)]
  318. public string JudgeStoveNo
  319. {
  320. get { return judgeStoveNo; }
  321. set { judgeStoveNo = value; }
  322. }
  323. /// <summary>
  324. /// 批号(炉批号)
  325. /// </summary>
  326. [Description("批号(炉批号)")]
  327. [Nullable(true)]
  328. [DataLength(10)]
  329. public string BatchNo
  330. {
  331. get { return batchNo; }
  332. set { batchNo = value; }
  333. }
  334. /// <summary>
  335. /// 品名代码
  336. /// </summary>
  337. [Description("品名代码")]
  338. [Nullable(true)]
  339. [DataLength(20)]
  340. public string Produccode
  341. {
  342. get { return produccode; }
  343. set { produccode = value; }
  344. }
  345. /// <summary>
  346. /// 品名描述
  347. /// </summary>
  348. [Description("品名描述")]
  349. [Nullable(true)]
  350. [DataLength(100)]
  351. public string Producname
  352. {
  353. get { return producname; }
  354. set { producname = value; }
  355. }
  356. /// <summary>
  357. /// 钢级(牌号)代码
  358. /// </summary>
  359. [Description("钢级(牌号)代码")]
  360. [Nullable(true)]
  361. [DataLength(10)]
  362. public string Steelcode
  363. {
  364. get { return steelcode; }
  365. set { steelcode = value; }
  366. }
  367. /// <summary>
  368. /// 钢级(牌号)名称
  369. /// </summary>
  370. [Description("钢级(牌号)名称")]
  371. [Nullable(true)]
  372. [DataLength(100)]
  373. public string Steelname
  374. {
  375. get { return steelname; }
  376. set { steelname = value; }
  377. }
  378. /// <summary>
  379. /// 钢种代码
  380. /// </summary>
  381. [Description("钢种代码")]
  382. [Nullable(true)]
  383. [DataLength(10)]
  384. public string Gradecode
  385. {
  386. get { return gradecode; }
  387. set { gradecode = value; }
  388. }
  389. /// <summary>
  390. /// 钢种名称
  391. /// </summary>
  392. [Description("钢种名称")]
  393. [Nullable(true)]
  394. [DataLength(100)]
  395. public string Gradename
  396. {
  397. get { return gradename; }
  398. set { gradename = value; }
  399. }
  400. /// <summary>
  401. /// 扣型代码
  402. /// </summary>
  403. [Description("扣型代码")]
  404. [Nullable(true)]
  405. [DataLength(20)]
  406. public string ModelCode
  407. {
  408. get { return modelCode; }
  409. set { modelCode = value; }
  410. }
  411. /// <summary>
  412. /// 扣型描述
  413. /// </summary>
  414. [Description("扣型描述")]
  415. [Nullable(true)]
  416. [DataLength(100)]
  417. public string ModelDesc
  418. {
  419. get { return modelDesc; }
  420. set { modelDesc = value; }
  421. }
  422. /// <summary>
  423. /// 标准代码
  424. /// </summary>
  425. [Description("标准代码")]
  426. [Nullable(true)]
  427. [DataLength(20)]
  428. public string StdCode
  429. {
  430. get { return stdCode; }
  431. set { stdCode = value; }
  432. }
  433. /// <summary>
  434. /// 标准名称
  435. /// </summary>
  436. [Description("标准名称")]
  437. [Nullable(true)]
  438. [DataLength(256)]
  439. public string StdName
  440. {
  441. get { return stdName; }
  442. set { stdName = value; }
  443. }
  444. /// <summary>
  445. /// 标准类别代码
  446. /// </summary>
  447. [Description("标准类别代码")]
  448. [Nullable(true)]
  449. [DataLength(20)]
  450. public string StdStyle
  451. {
  452. get { return stdStyle; }
  453. set { stdStyle = value; }
  454. }
  455. /// <summary>
  456. /// 标准类别描述(PSL1....)
  457. /// </summary>
  458. [Description("标准类别描述(PSL1....)")]
  459. [Nullable(true)]
  460. [DataLength(50)]
  461. public string StdStyleDesc
  462. {
  463. get { return stdStyleDesc; }
  464. set { stdStyleDesc = value; }
  465. }
  466. /// <summary>
  467. /// 外径(实际)
  468. /// </summary>
  469. [Description("外径(实际)")]
  470. [Nullable(true)]
  471. [DataLength(5)]
  472. public decimal? ActDimater
  473. {
  474. get { return actDimater; }
  475. set { actDimater = value; }
  476. }
  477. /// <summary>
  478. /// 壁厚(实际)
  479. /// </summary>
  480. [Description("壁厚(实际)")]
  481. [Nullable(true)]
  482. [DataLength(5)]
  483. public decimal? ActHeight
  484. {
  485. get { return actHeight; }
  486. set { actHeight = value; }
  487. }
  488. /// <summary>
  489. /// 长度(实际)
  490. /// </summary>
  491. [Description("长度(实际)")]
  492. [Nullable(true)]
  493. [DataLength(9)]
  494. public decimal? ActLen
  495. {
  496. get { return actLen; }
  497. set { actLen = value; }
  498. }
  499. /// <summary>
  500. /// 长度下限(实际)
  501. /// </summary>
  502. [Description("长度下限(实际)")]
  503. [Nullable(true)]
  504. [DataLength(10)]
  505. public string ActLenMin
  506. {
  507. get { return actLenMin; }
  508. set { actLenMin = value; }
  509. }
  510. /// <summary>
  511. /// 长度上限(实际)
  512. /// </summary>
  513. [Description("长度上限(实际)")]
  514. [Nullable(true)]
  515. [DataLength(10)]
  516. public string ActLenMax
  517. {
  518. get { return actLenMax; }
  519. set { actLenMax = value; }
  520. }
  521. /// <summary>
  522. /// 工艺文件号
  523. /// </summary>
  524. [Description("工艺文件号")]
  525. [Nullable(true)]
  526. [DataLength(100)]
  527. public string CraftFileNo
  528. {
  529. get { return craftFileNo; }
  530. set { craftFileNo = value; }
  531. }
  532. /// <summary>
  533. /// 委外支数
  534. /// </summary>
  535. [Description("委外支数")]
  536. [Nullable(true)]
  537. [DataLength(6)]
  538. public decimal? SubcontractNum
  539. {
  540. get { return subcontractNum; }
  541. set { subcontractNum = value; }
  542. }
  543. /// <summary>
  544. /// 委外重量
  545. /// </summary>
  546. [Description("委外重量")]
  547. [Nullable(true)]
  548. [DataLength(8)]
  549. public decimal? SubcontractWt
  550. {
  551. get { return subcontractWt; }
  552. set { subcontractWt = value; }
  553. }
  554. /// <summary>
  555. /// 委外回报合格支数
  556. /// </summary>
  557. [Description("委外回报合格支数")]
  558. [Nullable(true)]
  559. [DataLength(6)]
  560. public decimal? HbCompleteNum
  561. {
  562. get { return hbCompleteNum; }
  563. set { hbCompleteNum = value; }
  564. }
  565. /// <summary>
  566. /// 委外回报合格重量
  567. /// </summary>
  568. [Description("委外回报合格重量")]
  569. [Nullable(true)]
  570. [DataLength(8)]
  571. public decimal? HbCompleteWt
  572. {
  573. get { return hbCompleteWt; }
  574. set { hbCompleteWt = value; }
  575. }
  576. /// <summary>
  577. /// 委托操作人
  578. /// </summary>
  579. [Description("委托操作人")]
  580. [Nullable(true)]
  581. [DataLength(20)]
  582. public string SubcontractUser
  583. {
  584. get { return subcontractUser; }
  585. set { subcontractUser = value; }
  586. }
  587. /// <summary>
  588. /// 委托操作班次
  589. /// </summary>
  590. [Description("委托操作班次")]
  591. [Nullable(true)]
  592. [DataLength(1)]
  593. public string SubcontractShift
  594. {
  595. get { return subcontractShift; }
  596. set { subcontractShift = value; }
  597. }
  598. /// <summary>
  599. /// 委托操作班组
  600. /// </summary>
  601. [Description("委托操作班组")]
  602. [Nullable(true)]
  603. [DataLength(1)]
  604. public string SubcontractGroup
  605. {
  606. get { return subcontractGroup; }
  607. set { subcontractGroup = value; }
  608. }
  609. /// <summary>
  610. /// 委托操作时间
  611. /// </summary>
  612. [Description("委托操作时间")]
  613. [Nullable(true)]
  614. public string SubcontractTime
  615. {
  616. get { return subcontractTime; }
  617. set { subcontractTime = value; }
  618. }
  619. /// <summary>
  620. /// 审批操作人
  621. /// </summary>
  622. [Description("审批操作人")]
  623. [Nullable(true)]
  624. [DataLength(20)]
  625. public string SpUser
  626. {
  627. get { return spUser; }
  628. set { spUser = value; }
  629. }
  630. /// <summary>
  631. /// 审批操作时间
  632. /// </summary>
  633. [Description("审批操作时间")]
  634. [Nullable(true)]
  635. public string SpTime
  636. {
  637. get { return spTime; }
  638. set { spTime = value; }
  639. }
  640. /// <summary>
  641. /// 委托单状态(00:初始值、10:审核通过、20审核不通过、30委外回报完毕)
  642. /// </summary>
  643. [Description("委托单状态(00:初始值、10:审核通过、20审核不通过、30委外回报完毕)")]
  644. [Nullable(true)]
  645. [DataLength(2)]
  646. public string SubcontractLog
  647. {
  648. get { return subcontractLog; }
  649. set { subcontractLog = value; }
  650. }
  651. /// <summary>
  652. /// 委外产线代码
  653. /// </summary>
  654. [Description("委外产线代码")]
  655. [Nullable(true)]
  656. [DataLength(20)]
  657. public string SubcontractPlineCode
  658. {
  659. get { return subcontractPlineCode; }
  660. set { subcontractPlineCode = value; }
  661. }
  662. /// <summary>
  663. /// 委外产线描述
  664. /// </summary>
  665. [Description("委外产线描述")]
  666. [Nullable(true)]
  667. [DataLength(40)]
  668. public string SubcontractPlineName
  669. {
  670. get { return subcontractPlineName; }
  671. set { subcontractPlineName = value; }
  672. }
  673. /// <summary>
  674. /// 委外说明(委托单位)
  675. /// </summary>
  676. [Description("委外说明(委托单位)")]
  677. [Nullable(true)]
  678. [DataLength(100)]
  679. public string SubcontractNote
  680. {
  681. get { return subcontractNote; }
  682. set { subcontractNote = value; }
  683. }
  684. /// <summary>
  685. /// 委外回报废品支数
  686. /// </summary>
  687. [Description("委外回报废品支数")]
  688. [Nullable(true)]
  689. [DataLength(6)]
  690. public decimal? HbFpNum
  691. {
  692. get { return hbFpNum; }
  693. set { hbFpNum = value; }
  694. }
  695. /// <summary>
  696. /// 委外回报废品重量
  697. /// </summary>
  698. [Description("委外回报废品重量")]
  699. [Nullable(true)]
  700. [DataLength(8)]
  701. public decimal? HbFpWt
  702. {
  703. get { return hbFpWt; }
  704. set { hbFpWt = value; }
  705. }
  706. /// <summary>
  707. /// 审批说明
  708. /// </summary>
  709. [Description("审批说明")]
  710. [Nullable(true)]
  711. [DataLength(100)]
  712. public string SpNote
  713. {
  714. get { return spNote; }
  715. set { spNote = value; }
  716. }
  717. }
  718. }