ComMscEntity.cs 19 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683684685686687688689690691692693694695696697698699700701702703704705706707708709710711712713714715716717718719720721722723724725726
  1. using Core.Mes.Client.Comm.Attribute;
  2. using System;
  3. using System.ComponentModel;
  4. namespace Core.StlMes.Client.Qcm.model
  5. {
  6. /// <summary>
  7. /// 数据库表COM_MSC所对应的实体类(生成工具:代码生成工具3.0)
  8. /// 作者:Chenxi-PC2 时间:2015-09-15
  9. /// </summary>
  10. public class ComMscEntity
  11. {
  12. /// <summary>
  13. /// 冶金规范码
  14. /// </summary>
  15. private string msc = "";
  16. /// <summary>
  17. /// 冶金规范描述
  18. /// </summary>
  19. private string mscDesc = "";
  20. /// <summary>
  21. /// Alpha代码
  22. /// </summary>
  23. private string useCode = "";
  24. /// <summary>
  25. /// Alpha描述
  26. /// </summary>
  27. private string useDesc = "";
  28. /// <summary>
  29. /// 管理部门代码
  30. /// </summary>
  31. private string departmentCode = "";
  32. /// <summary>
  33. /// 管理部门描述
  34. /// </summary>
  35. private string departmentDesc = "";
  36. /// <summary>
  37. /// 交付标准管理科室代码
  38. /// </summary>
  39. private string unitCode = "";
  40. /// <summary>
  41. /// 交付标准管理科室描述
  42. /// </summary>
  43. private string unitDesc = "";
  44. /// <summary>
  45. /// 规范类型(A:钢管+管坯、B:钢管+接箍、C:短节+附件)
  46. /// </summary>
  47. private string mscStyle = "";
  48. /// <summary>
  49. /// 有效使用次数(无限使用为-1)
  50. /// </summary>
  51. private decimal? userCount = null;
  52. /// <summary>
  53. /// 品名代码
  54. /// </summary>
  55. private string produccode = "";
  56. /// <summary>
  57. /// 品名描述
  58. /// </summary>
  59. private string producname = "";
  60. /// <summary>
  61. /// 标准代码
  62. /// </summary>
  63. private string stdCode = "";
  64. /// <summary>
  65. /// 标准名称
  66. /// </summary>
  67. private string stdName = "";
  68. /// <summary>
  69. /// 钢级(牌号)代码
  70. /// </summary>
  71. private string steelcode = "";
  72. /// <summary>
  73. /// 钢级(牌号)名称
  74. /// </summary>
  75. private string steelname = "";
  76. /// <summary>
  77. /// 标准类别代码
  78. /// </summary>
  79. private string stdStyle = "";
  80. /// <summary>
  81. /// 标准类别描述(PSL1....)
  82. /// </summary>
  83. private string stdStyleDesc = "";
  84. /// <summary>
  85. /// 新产品代码
  86. /// </summary>
  87. private string newProcCode = "";
  88. /// <summary>
  89. /// 新产品描述
  90. /// </summary>
  91. private string newProcDesc = "";
  92. /// <summary>
  93. /// 是否维护内控标准(1:需要,0:不需要(没有维护内控标准的,在判定时,用交付标准作为内控标准进行判定))
  94. /// </summary>
  95. private string allowNk = "";
  96. /// <summary>
  97. /// 引用冶金规范码
  98. /// </summary>
  99. private string mscSeq = "";
  100. /// <summary>
  101. /// 引用冶金规范描述
  102. /// </summary>
  103. private string mscDescSeq = "";
  104. /// <summary>
  105. /// 创建人
  106. /// </summary>
  107. private string createName = "";
  108. /// <summary>
  109. /// 创建时间
  110. /// </summary>
  111. private string createTime = "";
  112. /// <summary>
  113. /// 修改人
  114. /// </summary>
  115. private string updateName = "";
  116. /// <summary>
  117. /// 修改时间
  118. /// </summary>
  119. private string updateTime = "";
  120. /// <summary>
  121. /// 删除人
  122. /// </summary>
  123. private string deleteName = "";
  124. /// <summary>
  125. /// 删除时间
  126. /// </summary>
  127. private string deleteTime = "";
  128. /// <summary>
  129. /// 交货与制程有效标志(A:录入状态,B:提交审核,C:已生效,D:无效,E:申请修改)
  130. /// </summary>
  131. private string validflag = "";
  132. /// <summary>
  133. /// 备注
  134. /// </summary>
  135. private string memo = "";
  136. /// <summary>
  137. /// 产品大类(4049)
  138. /// </summary>
  139. private string producHead = "";
  140. /// <summary>
  141. /// 附件图片文件路径
  142. /// </summary>
  143. private string fileJpeg = "";
  144. /// <summary>
  145. /// 工艺标准管理科室代码
  146. /// </summary>
  147. private string unitCodeProcess = "";
  148. /// <summary>
  149. /// 工艺标准管理科室描述
  150. /// </summary>
  151. private string unitDescProcess = "";
  152. /// <summary>
  153. /// {老系统}冶金规范码
  154. /// </summary>
  155. private string mscOld = "";
  156. /// <summary>
  157. /// {老系统}Alpha代码
  158. /// </summary>
  159. private string useCodeOld = "";
  160. /// <summary>
  161. /// 审核说明
  162. /// </summary>
  163. private string remark = "";
  164. /// <summary>
  165. /// 审核人(交货标准)
  166. /// </summary>
  167. private string auditName = "";
  168. /// <summary>
  169. /// 审核时间(交货标准)
  170. /// </summary>
  171. private string auditTime = "";
  172. /// <summary>
  173. /// 内控标准的有效标志(A:录入状态,B:提交审核,C:已生效,D:无效,E:申请修改)
  174. /// </summary>
  175. private string validflagNk = "";
  176. /// <summary>
  177. /// 审核人(内控标准)
  178. /// </summary>
  179. private string auditNameNk = "";
  180. /// <summary>
  181. /// 审核时间(内控标准)
  182. /// </summary>
  183. private string auditTimeNk = "";
  184. /// <summary>
  185. /// 审核说明(内控标准)
  186. /// </summary>
  187. private string remarkNk = "";
  188. private string psc = "";
  189. /// <summary>
  190. /// 产品码
  191. /// </summary>
  192. [Description("产品码")]
  193. [Nullable(false)]
  194. [DataLength(20)]
  195. public string Psc
  196. {
  197. get { return psc; }
  198. set { psc = value; }
  199. }
  200. /// <summary>
  201. /// 冶金规范码
  202. /// </summary>
  203. [Description("冶金规范码")]
  204. [Nullable(false)]
  205. [DataLength(20)]
  206. public string Msc
  207. {
  208. get { return msc; }
  209. set { msc = value; }
  210. }
  211. /// <summary>
  212. /// 冶金规范描述
  213. /// </summary>
  214. [Description("冶金规范描述")]
  215. [Nullable(true)]
  216. [DataLength(500)]
  217. public string MscDesc
  218. {
  219. get { return mscDesc; }
  220. set { mscDesc = value; }
  221. }
  222. /// <summary>
  223. /// Alpha代码
  224. /// </summary>
  225. [Description("Alpha代码")]
  226. [Nullable(true)]
  227. [DataLength(20)]
  228. public string UseCode
  229. {
  230. get { return useCode; }
  231. set { useCode = value; }
  232. }
  233. /// <summary>
  234. /// Alpha描述
  235. /// </summary>
  236. [Description("用途描述")]
  237. [Nullable(true)]
  238. [DataLength(100)]
  239. public string UseDesc
  240. {
  241. get { return useDesc; }
  242. set { useDesc = value; }
  243. }
  244. /// <summary>
  245. /// 管理部门代码
  246. /// </summary>
  247. [Description("管理部门代码")]
  248. [Nullable(true)]
  249. [DataLength(20)]
  250. public string DepartmentCode
  251. {
  252. get { return departmentCode; }
  253. set { departmentCode = value; }
  254. }
  255. /// <summary>
  256. /// 管理部门描述
  257. /// </summary>
  258. [Description("管理部门描述")]
  259. [Nullable(true)]
  260. [DataLength(100)]
  261. public string DepartmentDesc
  262. {
  263. get { return departmentDesc; }
  264. set { departmentDesc = value; }
  265. }
  266. /// <summary>
  267. /// 交付标准管理科室代码
  268. /// </summary>
  269. [Description("交付标准管理科室代码")]
  270. [Nullable(true)]
  271. [DataLength(20)]
  272. public string UnitCode
  273. {
  274. get { return unitCode; }
  275. set { unitCode = value; }
  276. }
  277. /// <summary>
  278. /// 交付标准管理科室描述
  279. /// </summary>
  280. [Description("交付标准管理科室描述")]
  281. [Nullable(true)]
  282. [DataLength(100)]
  283. public string UnitDesc
  284. {
  285. get { return unitDesc; }
  286. set { unitDesc = value; }
  287. }
  288. /// <summary>
  289. /// 规范类型(A:钢管+管坯、B:钢管+接箍、C:短节+附件)
  290. /// </summary>
  291. [Description("规范类型")]
  292. [Nullable(false)]
  293. [DataLength(1)]
  294. public string MscStyle
  295. {
  296. get { return mscStyle; }
  297. set { mscStyle = value; }
  298. }
  299. /// <summary>
  300. /// 有效使用次数(无限使用为-1)
  301. /// </summary>
  302. [Description("有效使用次数")]
  303. [Nullable(true)]
  304. [DataLength(22)]
  305. public decimal? UserCount
  306. {
  307. get { return userCount; }
  308. set { userCount = value; }
  309. }
  310. /// <summary>
  311. /// 品名代码
  312. /// </summary>
  313. [Description("品名代码")]
  314. [Nullable(true)]
  315. [DataLength(20)]
  316. public string Produccode
  317. {
  318. get { return produccode; }
  319. set { produccode = value; }
  320. }
  321. /// <summary>
  322. /// 品名描述
  323. /// </summary>
  324. [Description("品名描述")]
  325. [Nullable(true)]
  326. [DataLength(100)]
  327. public string Producname
  328. {
  329. get { return producname; }
  330. set { producname = value; }
  331. }
  332. /// <summary>
  333. /// 标准代码
  334. /// </summary>
  335. [Description("标准代码")]
  336. [Nullable(false)]
  337. [DataLength(20)]
  338. public string StdCode
  339. {
  340. get { return stdCode; }
  341. set { stdCode = value; }
  342. }
  343. /// <summary>
  344. /// 标准名称
  345. /// </summary>
  346. [Description("标准名称")]
  347. [Nullable(true)]
  348. [DataLength(200)]
  349. public string StdName
  350. {
  351. get { return stdName; }
  352. set { stdName = value; }
  353. }
  354. /// <summary>
  355. /// 钢级(牌号)代码
  356. /// </summary>
  357. [Description("钢级(牌号)代码")]
  358. [Nullable(true)]
  359. [DataLength(10)]
  360. public string Steelcode
  361. {
  362. get { return steelcode; }
  363. set { steelcode = value; }
  364. }
  365. /// <summary>
  366. /// 钢级(牌号)名称
  367. /// </summary>
  368. [Description("钢级(牌号)名称")]
  369. [Nullable(true)]
  370. [DataLength(100)]
  371. public string Steelname
  372. {
  373. get { return steelname; }
  374. set { steelname = value; }
  375. }
  376. /// <summary>
  377. /// 标准类别代码
  378. /// </summary>
  379. [Description("标准类别代码")]
  380. [Nullable(true)]
  381. [DataLength(20)]
  382. public string StdStyle
  383. {
  384. get { return stdStyle; }
  385. set { stdStyle = value; }
  386. }
  387. /// <summary>
  388. /// 标准类别描述(PSL1....)
  389. /// </summary>
  390. [Description("标准类别描述")]
  391. [Nullable(true)]
  392. [DataLength(50)]
  393. public string StdStyleDesc
  394. {
  395. get { return stdStyleDesc; }
  396. set { stdStyleDesc = value; }
  397. }
  398. /// <summary>
  399. /// 新产品代码
  400. /// </summary>
  401. [Description("新产品代码")]
  402. [Nullable(true)]
  403. [DataLength(1)]
  404. public string NewProcCode
  405. {
  406. get { return newProcCode; }
  407. set { newProcCode = value; }
  408. }
  409. /// <summary>
  410. /// 新产品描述
  411. /// </summary>
  412. [Description("新产品描述")]
  413. [Nullable(true)]
  414. [DataLength(200)]
  415. public string NewProcDesc
  416. {
  417. get { return newProcDesc; }
  418. set { newProcDesc = value; }
  419. }
  420. /// <summary>
  421. /// 是否维护内控标准(1:需要,0:不需要(没有维护内控标准的,在判定时,用交付标准作为内控标准进行判定))
  422. /// </summary>
  423. [Description("是否内控")]
  424. [Nullable(true)]
  425. [DataLength(1)]
  426. public string AllowNk
  427. {
  428. get { return allowNk; }
  429. set { allowNk = value; }
  430. }
  431. /// <summary>
  432. /// 引用冶金规范码
  433. /// </summary>
  434. [Description("引用冶金规范码")]
  435. [Nullable(true)]
  436. [DataLength(25)]
  437. public string MscSeq
  438. {
  439. get { return mscSeq; }
  440. set { mscSeq = value; }
  441. }
  442. /// <summary>
  443. /// 引用冶金规范描述
  444. /// </summary>
  445. [Description("引用冶金规范描述")]
  446. [Nullable(true)]
  447. [DataLength(500)]
  448. public string MscDescSeq
  449. {
  450. get { return mscDescSeq; }
  451. set { mscDescSeq = value; }
  452. }
  453. /// <summary>
  454. /// 创建人
  455. /// </summary>
  456. [Description("创建人")]
  457. [Nullable(true)]
  458. [DataLength(20)]
  459. public string CreateName
  460. {
  461. get { return createName; }
  462. set { createName = value; }
  463. }
  464. /// <summary>
  465. /// 创建时间
  466. /// </summary>
  467. [Description("创建时间")]
  468. [Nullable(true)]
  469. public string CreateTime
  470. {
  471. get { return createTime; }
  472. set { createTime = value; }
  473. }
  474. /// <summary>
  475. /// 修改人
  476. /// </summary>
  477. [Description("修改人")]
  478. [Nullable(true)]
  479. [DataLength(20)]
  480. public string UpdateName
  481. {
  482. get { return updateName; }
  483. set { updateName = value; }
  484. }
  485. /// <summary>
  486. /// 修改时间
  487. /// </summary>
  488. [Description("修改时间")]
  489. [Nullable(true)]
  490. public string UpdateTime
  491. {
  492. get { return updateTime; }
  493. set { updateTime = value; }
  494. }
  495. /// <summary>
  496. /// 删除人
  497. /// </summary>
  498. [Description("删除人")]
  499. [Nullable(true)]
  500. [DataLength(20)]
  501. public string DeleteName
  502. {
  503. get { return deleteName; }
  504. set { deleteName = value; }
  505. }
  506. /// <summary>
  507. /// 删除时间
  508. /// </summary>
  509. [Description("删除时间")]
  510. [Nullable(true)]
  511. public string DeleteTime
  512. {
  513. get { return deleteTime; }
  514. set { deleteTime = value; }
  515. }
  516. /// <summary>
  517. /// 交货与制程有效标志(A:录入状态,B:提交审核,C:已生效,D:无效,E:申请修改)
  518. /// </summary>
  519. [Description("交货与制程有效标志")]
  520. [Nullable(false)]
  521. [DataLength(1)]
  522. public string Validflag
  523. {
  524. get { return validflag; }
  525. set { validflag = value; }
  526. }
  527. /// <summary>
  528. /// 备注
  529. /// </summary>
  530. [Description("备注")]
  531. [Nullable(true)]
  532. [DataLength(500)]
  533. public string Memo
  534. {
  535. get { return memo; }
  536. set { memo = value; }
  537. }
  538. /// <summary>
  539. /// 产品大类(4049)
  540. /// </summary>
  541. [Description("产品大类")]
  542. [Nullable(true)]
  543. [DataLength(20)]
  544. public string ProducHead
  545. {
  546. get { return producHead; }
  547. set { producHead = value; }
  548. }
  549. /// <summary>
  550. /// 附件图片文件路径
  551. /// </summary>
  552. [Description("附件图片文件路径")]
  553. [Nullable(true)]
  554. [DataLength(200)]
  555. public string FileJpeg
  556. {
  557. get { return fileJpeg; }
  558. set { fileJpeg = value; }
  559. }
  560. /// <summary>
  561. /// 工艺标准管理科室代码
  562. /// </summary>
  563. [Description("工艺标准管理科室代码")]
  564. [Nullable(true)]
  565. [DataLength(20)]
  566. public string UnitCodeProcess
  567. {
  568. get { return unitCodeProcess; }
  569. set { unitCodeProcess = value; }
  570. }
  571. /// <summary>
  572. /// 工艺标准管理科室描述
  573. /// </summary>
  574. [Description("工艺标准管理科室描述")]
  575. [Nullable(true)]
  576. [DataLength(100)]
  577. public string UnitDescProcess
  578. {
  579. get { return unitDescProcess; }
  580. set { unitDescProcess = value; }
  581. }
  582. /// <summary>
  583. /// {老系统}冶金规范码
  584. /// </summary>
  585. [Description("{老系统}冶金规范码")]
  586. [Nullable(true)]
  587. [DataLength(20)]
  588. public string MscOld
  589. {
  590. get { return mscOld; }
  591. set { mscOld = value; }
  592. }
  593. /// <summary>
  594. /// {老系统}Alpha代码
  595. /// </summary>
  596. [Description("{老系统}Alpha代码")]
  597. [Nullable(true)]
  598. [DataLength(20)]
  599. public string UseCodeOld
  600. {
  601. get { return useCodeOld; }
  602. set { useCodeOld = value; }
  603. }
  604. /// <summary>
  605. /// 审核说明
  606. /// </summary>
  607. [Description("审核说明")]
  608. [Nullable(true)]
  609. [DataLength(500)]
  610. public string Remark
  611. {
  612. get { return remark; }
  613. set { remark = value; }
  614. }
  615. /// <summary>
  616. /// 审核人(交货标准)
  617. /// </summary>
  618. [Description("审核人(交货标准)")]
  619. [Nullable(true)]
  620. [DataLength(20)]
  621. public string AuditName
  622. {
  623. get { return auditName; }
  624. set { auditName = value; }
  625. }
  626. /// <summary>
  627. /// 审核时间(交货标准)
  628. /// </summary>
  629. [Description("审核时间(交货标准)")]
  630. [Nullable(true)]
  631. public string AuditTime
  632. {
  633. get { return auditTime; }
  634. set { auditTime = value; }
  635. }
  636. /// <summary>
  637. /// 内控标准的有效标志(A:录入状态,B:提交审核,C:已生效,D:无效,E:申请修改)
  638. /// </summary>
  639. [Description("内控标准的有效标志")]
  640. [Nullable(false)]
  641. [DataLength(1)]
  642. public string ValidflagNk
  643. {
  644. get { return validflagNk; }
  645. set { validflagNk = value; }
  646. }
  647. /// <summary>
  648. /// 审核人(内控标准)
  649. /// </summary>
  650. [Description("审核人(内控标准)")]
  651. [Nullable(true)]
  652. [DataLength(20)]
  653. public string AuditNameNk
  654. {
  655. get { return auditNameNk; }
  656. set { auditNameNk = value; }
  657. }
  658. /// <summary>
  659. /// 审核时间(内控标准)
  660. /// </summary>
  661. [Description("审核时间(内控标准)")]
  662. [Nullable(true)]
  663. public string AuditTimeNk
  664. {
  665. get { return auditTimeNk; }
  666. set { auditTimeNk = value; }
  667. }
  668. /// <summary>
  669. /// 审核说明(内控标准)
  670. /// </summary>
  671. [Description("审核说明(内控标准)")]
  672. [Nullable(true)]
  673. [DataLength(500)]
  674. public string RemarkNk
  675. {
  676. get { return remarkNk; }
  677. set { remarkNk = value; }
  678. }
  679. }
  680. }