PlnOrderJgEntityCraftNo.cs 18 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726727728729730731732733734735736737738739740741742743744745746747748749750751752753754755756757758759760761762763764765766767768769770771772773774775776777778779780781782783784785786787788789790791792793794795796797798799800
  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.PlnSaleOrd.JGGXPln.Entity
  8. {
  9. /// <summary>
  10. /// 数据库表PLN_ORDER_JG所对应的实体类(生成工具:代码生成工具3.0)
  11. /// 作者:PC-20180117CCCC 时间:2018-10-15
  12. /// </summary>
  13. public class PlnOrderJgEntityCraftNo
  14. {
  15. /// <summary>
  16. /// 接箍合同号
  17. /// </summary>
  18. private string jgOrderno = "";
  19. /// <summary>
  20. /// 合同号
  21. /// </summary>
  22. private string orderNo = "";
  23. /// <summary>
  24. /// 合同行号
  25. /// </summary>
  26. private string orderSeq = "";
  27. /// <summary>
  28. /// 交货编码
  29. /// </summary>
  30. private string deliveryNo = "";
  31. /// <summary>
  32. /// 客户编号
  33. /// </summary>
  34. private string buyerId = "";
  35. /// <summary>
  36. /// 客户名称
  37. /// </summary>
  38. private string buyerName = "";
  39. /// <summary>
  40. /// 交货开始日期
  41. /// </summary>
  42. private string delvryBdate = "";
  43. /// <summary>
  44. /// 交货结束日期
  45. /// </summary>
  46. private string delvryEdate = "";
  47. /// <summary>
  48. /// 合同联系人
  49. /// </summary>
  50. private string ordercontact = "";
  51. /// <summary>
  52. /// 监制要求
  53. /// </summary>
  54. private string monitordemand = "";
  55. /// <summary>
  56. /// 是否接箍监制
  57. /// </summary>
  58. private string ifMonitorJg = "";
  59. /// <summary>
  60. /// 监制编号
  61. /// </summary>
  62. private string prdcrNo = "";
  63. /// <summary>
  64. /// 产品规范码
  65. /// </summary>
  66. private string psc = "";
  67. /// <summary>
  68. /// 冶金规范码
  69. /// </summary>
  70. private string msc = "";
  71. /// <summary>
  72. /// 制程索引号
  73. /// </summary>
  74. private string indexSeq = "";
  75. /// <summary>
  76. /// 接箍码
  77. /// </summary>
  78. private string codeJg = "";
  79. /// <summary>
  80. /// 钢级(牌号)代码
  81. /// </summary>
  82. private string steelcode = "";
  83. /// <summary>
  84. /// 钢级(牌号)名称
  85. /// </summary>
  86. private string steelname = "";
  87. /// <summary>
  88. /// 外径
  89. /// </summary>
  90. private decimal? outdiameter = null;
  91. /// <summary>
  92. /// 临界壁厚
  93. /// </summary>
  94. private decimal? wallthick = null;
  95. /// <summary>
  96. /// 控制壁厚(暂不用)
  97. /// </summary>
  98. private decimal? aimwallthick = null;
  99. /// <summary>
  100. /// 扣型代码
  101. /// </summary>
  102. private string modelCode = "";
  103. /// <summary>
  104. /// 目标长度
  105. /// </summary>
  106. private decimal? aimlength = null;
  107. /// <summary>
  108. /// 单重
  109. /// </summary>
  110. private decimal? singleweight = null;
  111. /// <summary>
  112. /// 合同重量
  113. /// </summary>
  114. private decimal? orderweight = null;
  115. /// <summary>
  116. /// 合同个数
  117. /// </summary>
  118. private decimal? ordernum = null;
  119. /// <summary>
  120. /// 最迟生产日期
  121. /// </summary>
  122. private string latestProdDate = "";
  123. /// <summary>
  124. /// 利库充当量
  125. /// </summary>
  126. private decimal? matchweight = null;
  127. /// <summary>
  128. /// 利库个数
  129. /// </summary>
  130. private decimal? matchnum = null;
  131. /// <summary>
  132. /// 有无外购计划
  133. /// </summary>
  134. private string ifbuyplan = "";
  135. /// <summary>
  136. /// 外购计划号
  137. /// </summary>
  138. private string buyplanid = "";
  139. /// <summary>
  140. /// 外购计划重量
  141. /// </summary>
  142. private decimal? buyplanweight = null;
  143. /// <summary>
  144. /// 外购计划个数
  145. /// </summary>
  146. private decimal? buyplannum = null;
  147. /// <summary>
  148. /// 接箍合同状态 (0待处理、1已组订单、2完成)
  149. /// </summary>
  150. private string jgorderstatus = "";
  151. /// <summary>
  152. /// 创建人
  153. /// </summary>
  154. private string createName = "";
  155. /// <summary>
  156. /// 创建时间
  157. /// </summary>
  158. private string createTime = "";
  159. /// <summary>
  160. /// 修改人
  161. /// </summary>
  162. private string updateName = "";
  163. /// <summary>
  164. /// 修改时间
  165. /// </summary>
  166. private string updateTime = "";
  167. /// <summary>
  168. /// 接箍加工组
  169. /// </summary>
  170. private string groupJgx = "";
  171. /// <summary>
  172. /// 已做备料需求接箍量
  173. /// </summary>
  174. private decimal? jgwtBlreq = null;
  175. /// <summary>
  176. /// 下发时间
  177. /// </summary>
  178. private string issuedTime = "";
  179. /// <summary>
  180. /// 接箍规格代码
  181. /// </summary>
  182. private string specJg = "";
  183. /// <summary>
  184. /// 接箍规格描述
  185. /// </summary>
  186. private string specJgDesc = "";
  187. /// <summary>
  188. /// 接箍扣型描述
  189. /// </summary>
  190. private string modelDesc = "";
  191. /// <summary>
  192. /// 中孔类别
  193. /// </summary>
  194. private string styleJg = "";
  195. /// <summary>
  196. /// 中孔内径
  197. /// </summary>
  198. private decimal? diameter = null;
  199. /// <summary>
  200. /// 测量J值
  201. /// </summary>
  202. private decimal? checkJVal = null;
  203. /// <summary>
  204. /// 交货行PK
  205. /// </summary>
  206. private string ordLnDlyPk = "";
  207. /// <summary>
  208. /// 探伤要求
  209. /// </summary>
  210. private string demandDetection = "";
  211. /// <summary>
  212. /// 磷化镀铜要求
  213. /// </summary>
  214. private string demandBonderizing = "";
  215. /// <summary>
  216. /// 压印喷标
  217. /// </summary>
  218. private string demandCopper = "";
  219. /// <summary>
  220. /// 喷砂要求
  221. /// </summary>
  222. private string demandBlast = "";
  223. /// <summary>
  224. /// 接箍工序需求编号
  225. /// </summary>
  226. private string proPlanId = "";
  227. /// <summary>
  228. /// 接箍KEY
  229. /// </summary>
  230. private string keyJg = "";
  231. /// <summary>
  232. /// 订单属性分组号
  233. /// </summary>
  234. private string jgGroupId = "";
  235. /// <summary>
  236. /// 最终用户(来源客户表)
  237. /// </summary>
  238. private string finalUser = "";
  239. /// <summary>
  240. /// 最终用户描述
  241. /// </summary>
  242. private string finalUserDesc = "";
  243. /// <summary>
  244. /// 是否接箍成品合同
  245. /// </summary>
  246. private string ifJgSaleord = "";
  247. /// <summary>
  248. /// 接箍订单
  249. /// </summary>
  250. private string proPlanIdS = "";
  251. /// <summary>
  252. /// 工单号
  253. /// </summary>
  254. private string woId = "";
  255. /// <summary>
  256. /// 接箍订单从表编号
  257. /// </summary>
  258. private string key = "";
  259. /// <summary>
  260. /// 状态(0,计划,1下发,2完成)(备料需求下发)
  261. /// </summary>
  262. private string status = "";
  263. /// <summary>
  264. /// 接箍合同号
  265. /// </summary>
  266. [Description("接箍合同号")]
  267. [Nullable(false)]
  268. [DataLength(40)]
  269. public string JgOrderno
  270. {
  271. get { return jgOrderno; }
  272. set { jgOrderno = value; }
  273. }
  274. /// <summary>
  275. /// 合同号
  276. /// </summary>
  277. [Description("合同号")]
  278. [Nullable(true)]
  279. [DataLength(20)]
  280. public string OrderNo
  281. {
  282. get { return orderNo; }
  283. set { orderNo = value; }
  284. }
  285. /// <summary>
  286. /// 交货编码
  287. /// </summary>
  288. [Description("交货编码")]
  289. [Nullable(true)]
  290. [DataLength(3)]
  291. public string DeliveryNo
  292. {
  293. get { return deliveryNo; }
  294. set { deliveryNo = value; }
  295. }
  296. /// <summary>
  297. /// 客户名称
  298. /// </summary>
  299. [Description("客户名称")]
  300. [Nullable(true)]
  301. [DataLength(100)]
  302. public string BuyerName
  303. {
  304. get { return buyerName; }
  305. set { buyerName = value; }
  306. }
  307. /// <summary>
  308. /// 监制要求
  309. /// </summary>
  310. [Description("监制要求")]
  311. [Nullable(true)]
  312. [DataLength(200)]
  313. public string Monitordemand
  314. {
  315. get { return monitordemand; }
  316. set { monitordemand = value; }
  317. }
  318. /// <summary>
  319. /// 是否接箍监制
  320. /// </summary>
  321. [Description("是否监制")]
  322. [Nullable(true)]
  323. [DataLength(1)]
  324. public string IfMonitorJg
  325. {
  326. get { return ifMonitorJg; }
  327. set { ifMonitorJg = value; }
  328. }
  329. /// <summary>
  330. /// 监制编号
  331. /// </summary>
  332. [Description("监制编号")]
  333. [Nullable(true)]
  334. [DataLength(40)]
  335. public string PrdcrNo
  336. {
  337. get { return prdcrNo; }
  338. set { prdcrNo = value; }
  339. }
  340. /// <summary>
  341. /// 产品规范码
  342. /// </summary>
  343. [Description("产品规范码")]
  344. [Nullable(true)]
  345. [DataLength(20)]
  346. public string Psc
  347. {
  348. get { return psc; }
  349. set { psc = value; }
  350. }
  351. /// <summary>
  352. /// 冶金规范码
  353. /// </summary>
  354. [Description("冶金规范码")]
  355. [Nullable(true)]
  356. [DataLength(20)]
  357. public string Msc
  358. {
  359. get { return msc; }
  360. set { msc = value; }
  361. }
  362. /// <summary>
  363. /// 制程索引号
  364. /// </summary>
  365. [Description("制程索引号")]
  366. [Nullable(true)]
  367. [DataLength(32)]
  368. public string IndexSeq
  369. {
  370. get { return indexSeq; }
  371. set { indexSeq = value; }
  372. }
  373. /// <summary>
  374. /// 接箍码
  375. /// </summary>
  376. [Description("接箍码")]
  377. [Nullable(true)]
  378. [DataLength(7)]
  379. public string CodeJg
  380. {
  381. get { return codeJg; }
  382. set { codeJg = value; }
  383. }
  384. /// <summary>
  385. /// 钢级(牌号)名称
  386. /// </summary>
  387. [Description("钢级")]
  388. [Nullable(true)]
  389. [DataLength(100)]
  390. public string Steelname
  391. {
  392. get { return steelname; }
  393. set { steelname = value; }
  394. }
  395. /// <summary>
  396. /// 外径
  397. /// </summary>
  398. [Description("外径")]
  399. [Nullable(true)]
  400. [DataLength(10)]
  401. public decimal? Outdiameter
  402. {
  403. get { return outdiameter; }
  404. set { outdiameter = value; }
  405. }
  406. /// <summary>
  407. /// 临界壁厚
  408. /// </summary>
  409. [Description("壁厚")]
  410. [Nullable(true)]
  411. [DataLength(10)]
  412. public decimal? Wallthick
  413. {
  414. get { return wallthick; }
  415. set { wallthick = value; }
  416. }
  417. /// <summary>
  418. /// 目标长度
  419. /// </summary>
  420. [Description("目标长度")]
  421. [Nullable(true)]
  422. [DataLength(10)]
  423. public decimal? Aimlength
  424. {
  425. get { return aimlength; }
  426. set { aimlength = value; }
  427. }
  428. /// <summary>
  429. /// 单重
  430. /// </summary>
  431. [Description("单重")]
  432. [Nullable(true)]
  433. [DataLength(10)]
  434. public decimal? Singleweight
  435. {
  436. get { return singleweight; }
  437. set { singleweight = value; }
  438. }
  439. /// <summary>
  440. /// 合同重量
  441. /// </summary>
  442. [Description("合同重量")]
  443. [Nullable(true)]
  444. [DataLength(16)]
  445. public decimal? Orderweight
  446. {
  447. get { return orderweight; }
  448. set { orderweight = value; }
  449. }
  450. /// <summary>
  451. /// 合同个数
  452. /// </summary>
  453. [Description("合同个数")]
  454. [Nullable(true)]
  455. [DataLength(10)]
  456. public decimal? Ordernum
  457. {
  458. get { return ordernum; }
  459. set { ordernum = value; }
  460. }
  461. /// <summary>
  462. /// 接箍合同状态 (0待处理、1已组订单、2完成)
  463. /// </summary>
  464. [Description("接箍合同状态")]
  465. [Nullable(true)]
  466. [DataLength(20)]
  467. public string Jgorderstatus
  468. {
  469. get { return jgorderstatus; }
  470. set { jgorderstatus = value; }
  471. }
  472. /// <summary>
  473. /// 创建人
  474. /// </summary>
  475. [Description("创建人")]
  476. [Nullable(true)]
  477. [DataLength(20)]
  478. public string CreateName
  479. {
  480. get { return createName; }
  481. set { createName = value; }
  482. }
  483. /// <summary>
  484. /// 创建时间
  485. /// </summary>
  486. [Description("创建时间")]
  487. [Nullable(true)]
  488. public string CreateTime
  489. {
  490. get { return createTime; }
  491. set { createTime = value; }
  492. }
  493. /// <summary>
  494. /// 修改人
  495. /// </summary>
  496. [Description("修改人")]
  497. [Nullable(true)]
  498. [DataLength(20)]
  499. public string UpdateName
  500. {
  501. get { return updateName; }
  502. set { updateName = value; }
  503. }
  504. /// <summary>
  505. /// 修改时间
  506. /// </summary>
  507. [Description("修改时间")]
  508. [Nullable(true)]
  509. public string UpdateTime
  510. {
  511. get { return updateTime; }
  512. set { updateTime = value; }
  513. }
  514. /// <summary>
  515. /// 接箍加工组
  516. /// </summary>
  517. [Description("接箍加工组")]
  518. [Nullable(true)]
  519. [DataLength(20)]
  520. public string GroupJgx
  521. {
  522. get { return groupJgx; }
  523. set { groupJgx = value; }
  524. }
  525. /// <summary>
  526. /// 下发时间
  527. /// </summary>
  528. [Description("下发时间")]
  529. [Nullable(true)]
  530. public string IssuedTime
  531. {
  532. get { return issuedTime; }
  533. set { issuedTime = value; }
  534. }
  535. /// <summary>
  536. /// 接箍规格描述
  537. /// </summary>
  538. [Description("规格")]
  539. [Nullable(true)]
  540. [DataLength(100)]
  541. public string SpecJgDesc
  542. {
  543. get { return specJgDesc; }
  544. set { specJgDesc = value; }
  545. }
  546. /// <summary>
  547. /// 接箍扣型描述
  548. /// </summary>
  549. [Description("扣型")]
  550. [Nullable(true)]
  551. [DataLength(100)]
  552. public string ModelDesc
  553. {
  554. get { return modelDesc; }
  555. set { modelDesc = value; }
  556. }
  557. /// <summary>
  558. /// 中孔类别
  559. /// </summary>
  560. [Description("中孔类别")]
  561. [Nullable(true)]
  562. [DataLength(8)]
  563. public string StyleJg
  564. {
  565. get { return styleJg; }
  566. set { styleJg = value; }
  567. }
  568. /// <summary>
  569. /// 中孔内径
  570. /// </summary>
  571. [Description("中孔内径")]
  572. [Nullable(true)]
  573. [DataLength(6)]
  574. public decimal? Diameter
  575. {
  576. get { return diameter; }
  577. set { diameter = value; }
  578. }
  579. /// <summary>
  580. /// 测量J值
  581. /// </summary>
  582. [Description("测量J值")]
  583. [Nullable(true)]
  584. [DataLength(6)]
  585. public decimal? CheckJVal
  586. {
  587. get { return checkJVal; }
  588. set { checkJVal = value; }
  589. }
  590. /// <summary>
  591. /// 交货行PK
  592. /// </summary>
  593. [Description("交货行PK")]
  594. [Nullable(true)]
  595. [DataLength(40)]
  596. public string OrdLnDlyPk
  597. {
  598. get { return ordLnDlyPk; }
  599. set { ordLnDlyPk = value; }
  600. }
  601. /// <summary>
  602. /// 探伤要求
  603. /// </summary>
  604. [Description("是否探伤")]
  605. [Nullable(true)]
  606. [DataLength(200)]
  607. public string DemandDetection
  608. {
  609. get { return demandDetection; }
  610. set { demandDetection = value; }
  611. }
  612. /// <summary>
  613. /// 磷化镀铜要求
  614. /// </summary>
  615. [Description("是否磷化镀铜")]
  616. [Nullable(true)]
  617. [DataLength(200)]
  618. public string DemandBonderizing
  619. {
  620. get { return demandBonderizing; }
  621. set { demandBonderizing = value; }
  622. }
  623. /// <summary>
  624. /// 压印喷标
  625. /// </summary>
  626. [Description("是否压印喷标")]
  627. [Nullable(true)]
  628. [DataLength(400)]
  629. public string DemandCopper
  630. {
  631. get { return demandCopper; }
  632. set { demandCopper = value; }
  633. }
  634. /// <summary>
  635. /// 喷砂要求
  636. /// </summary>
  637. [Description("是否喷砂")]
  638. [Nullable(true)]
  639. [DataLength(200)]
  640. public string DemandBlast
  641. {
  642. get { return demandBlast; }
  643. set { demandBlast = value; }
  644. }
  645. /// <summary>
  646. /// 接箍工序需求编号
  647. /// </summary>
  648. [Description("接箍工序编号")]
  649. [Nullable(true)]
  650. [DataLength(20)]
  651. public string ProPlanId
  652. {
  653. get { return proPlanId; }
  654. set { proPlanId = value; }
  655. }
  656. /// <summary>
  657. /// 接箍KEY
  658. /// </summary>
  659. [Description("接箍KEY")]
  660. [Nullable(true)]
  661. [DataLength(32)]
  662. public string KeyJg
  663. {
  664. get { return keyJg; }
  665. set { keyJg = value; }
  666. }
  667. /// <summary>
  668. /// 最终用户描述
  669. /// </summary>
  670. [Description("最终用户")]
  671. [Nullable(true)]
  672. [DataLength(100)]
  673. public string FinalUserDesc
  674. {
  675. get { return finalUserDesc; }
  676. set { finalUserDesc = value; }
  677. }
  678. /// <summary>
  679. /// 是否接箍成品合同
  680. /// </summary>
  681. [Description("是否接箍成品合同")]
  682. [Nullable(true)]
  683. [DataLength(1)]
  684. public string IfJgSaleord
  685. {
  686. get { return ifJgSaleord; }
  687. set { ifJgSaleord = value; }
  688. }
  689. /// <summary>
  690. /// 接箍订单
  691. /// </summary>
  692. [Description("接箍排产订单")]
  693. [Nullable(true)]
  694. [DataLength(20)]
  695. public string ProPlanIdS
  696. {
  697. get { return proPlanIdS; }
  698. set { proPlanIdS = value; }
  699. }
  700. /// <summary>
  701. /// 工单号
  702. /// </summary>
  703. [Description("工单号")]
  704. [Nullable(true)]
  705. [DataLength(30)]
  706. public string WoId
  707. {
  708. get { return woId; }
  709. set { woId = value; }
  710. }
  711. /// <summary>
  712. /// 接箍订单从表编号
  713. /// </summary>
  714. [Description("接箍排产订单7+4")]
  715. [Nullable(true)]
  716. [DataLength(20)]
  717. public string Key
  718. {
  719. get { return key; }
  720. set { key = value; }
  721. }
  722. private string craftNoJg2 = "";
  723. [Description("二级工艺文件")]
  724. public string CraftNoJg2
  725. {
  726. get { return craftNoJg2; }
  727. set { craftNoJg2 = value; }
  728. }
  729. private string craftSeq2 = "";
  730. [Description("二级工艺序号")]
  731. public string CraftSeq2
  732. {
  733. get { return craftSeq2; }
  734. set { craftSeq2 = value; }
  735. }
  736. private string craftPath = "";
  737. [Description("二级工艺存放路径")]
  738. public string CraftPath
  739. {
  740. get { return craftPath; }
  741. set { craftPath = value; }
  742. }
  743. private string timeCp = "";
  744. [Description("成品合同时间")]
  745. public string TimeCp
  746. {
  747. get { return timeCp; }
  748. set { timeCp = value; }
  749. }
  750. private string exeStatus = "";
  751. [Description("成品排产行状态")]
  752. public string ExeStatus
  753. {
  754. get { return exeStatus; }
  755. set { exeStatus = value; }
  756. }
  757. private string isPlanOk = "";
  758. [Description("工艺确认")]
  759. public string IsPlanOk
  760. {
  761. get { return isPlanOk; }
  762. set { isPlanOk = value; }
  763. }
  764. }
  765. }