From 5adecb7ffd986930d2f4e195c0273e4db73b5315 Mon Sep 17 00:00:00 2001
From: kyy <3283105747@qq.com>
Date: 星期五, 07 二月 2025 18:36:51 +0800
Subject: [PATCH] 优化首检
---
MES.Service/Modes/MesQualityStandard.cs | 375 +++++++++++++++++++++++++----------------------------
1 files changed, 176 insertions(+), 199 deletions(-)
diff --git a/MES.Service/Modes/MesQualityStandard.cs b/MES.Service/Modes/MesQualityStandard.cs
index bf414fa..abffd37 100644
--- a/MES.Service/Modes/MesQualityStandard.cs
+++ b/MES.Service/Modes/MesQualityStandard.cs
@@ -1,204 +1,181 @@
using System.ComponentModel.DataAnnotations;
using System.ComponentModel.DataAnnotations.Schema;
+using System;
+using System.Collections.Generic;
+using System.Linq;
using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 璐ㄩ噺鏍囧噯琛�
-/// </summary>
-[Table("MES_QUALITY_STANDARD")]
-[SugarTable("MES_QUALITY_STANDARD")] //鐢ㄤ簬SqlSugar
-public class MesQualityStandard
+namespace MES.Service.Modes
{
/// <summary>
- /// 搴忓垪SEQ_QS
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [Column("CREATE_BY")]
- [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�20")]
- public string CreateBy { get; set; }
-
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 鎺ユ敹姘村钩
- /// </summary>
- [Column("FAC_LEVEL")]
- [SugarColumn(ColumnName = "FAC_LEVEL")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "鎺ユ敹姘村钩闀垮害涓嶈兘瓒呭嚭100")]
- public string FacLevel { get; set; }
-
- /// <summary>
- /// 妫�楠屾按骞�
- /// </summary>
- [Column("FCHECK_LEVEL")]
- [SugarColumn(ColumnName = "FCHECK_LEVEL")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "妫�楠屾按骞抽暱搴︿笉鑳借秴鍑�100")]
- public string FcheckLevel { get; set; }
-
- /// <summary>
- /// 瀹℃牳鐘舵��
- /// </summary>
- [Column("FSUBMIT")]
- [SugarColumn(ColumnName = "FSUBMIT")] //鐢ㄤ簬SqlSugar
- public decimal? Fsubmit { get; set; }
-
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [Column("FSUBMIT_BY")]
- [SugarColumn(ColumnName = "FSUBMIT_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "瀹℃牳浜洪暱搴︿笉鑳借秴鍑�50")]
- public string FsubmitBy { get; set; }
-
- /// <summary>
- /// 瀹℃牳鏃堕棿
- /// </summary>
- [Column("FSUBMIT_DATE")]
- [SugarColumn(ColumnName = "FSUBMIT_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? FsubmitDate { get; set; }
-
- /// <summary>
- /// 妯℃暟
- /// </summary>
- [Column("INSPECTION_LEVEL")]
- [SugarColumn(ColumnName = "INSPECTION_LEVEL")] //鐢ㄤ簬SqlSugar
- public decimal? InspectionLevel { get; set; }
-
- /// <summary>
- /// 妫�楠屾柟娉�
- /// </summary>
- [Column("INSPECTION_METHOD")]
- [SugarColumn(ColumnName = "INSPECTION_METHOD")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "妫�楠屾柟娉曢暱搴︿笉鑳借秴鍑�50")]
- public string InspectionMethod { get; set; }
-
- /// <summary>
- /// 璐ㄩ噺瑕佹眰
- /// </summary>
- [Column("ITEM_MOD")]
- [SugarColumn(ColumnName = "ITEM_MOD")] //鐢ㄤ簬SqlSugar
- [StringLength(500, ErrorMessage = "璐ㄩ噺瑕佹眰闀垮害涓嶈兘瓒呭嚭500")]
- public string ItemMod { get; set; }
-
- /// <summary>
- /// 鐗╂枡缂栧彿
- /// </summary>
- [Column("ITEM_NO")]
- [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鐗╂枡缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
- public string ItemNo { get; set; }
-
- /// <summary>
- /// 姣忔ā澶氬皯涓�
- /// </summary>
- [Column("LEVEL_NUM")]
- [SugarColumn(ColumnName = "LEVEL_NUM")] //鐢ㄤ簬SqlSugar
- public decimal? LevelNum { get; set; }
-
- /// <summary>
- /// 鏈�澶у��
- /// </summary>
- [Column("MAX_VALUE")]
- [SugarColumn(ColumnName = "MAX_VALUE")] //鐢ㄤ簬SqlSugar
- public decimal? MaxValue { get; set; }
-
- /// <summary>
- /// 鏈�灏忓��
- /// </summary>
- [Column("MIN_VALUE")]
- [SugarColumn(ColumnName = "MIN_VALUE")] //鐢ㄤ簬SqlSugar
- public decimal? MinValue { get; set; }
-
- /// <summary>
- /// 妯″叿鍙�
- /// </summary>
- [Column("MOID_NUM")]
- [SugarColumn(ColumnName = "MOID_NUM")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "妯″叿鍙烽暱搴︿笉鑳借秴鍑�50")]
- public string MoidNum { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [Column("NOTES")]
- [SugarColumn(ColumnName = "NOTES")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "澶囨敞闀垮害涓嶈兘瓒呭嚭100")]
- public string Notes { get; set; }
-
- /// <summary>
- /// 鍥剧墖鍦板潃
- /// </summary>
- [Column("PICTURE")]
- [SugarColumn(ColumnName = "PICTURE")] //鐢ㄤ簬SqlSugar
- public byte[]? Picture { get; set; }
-
- /// <summary>
- /// 鍥剧墖鍚嶇О
- /// </summary>
- [Column("PICTURENAME")]
- [SugarColumn(ColumnName = "PICTURENAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "Picturename闀垮害涓嶈兘瓒呭嚭32")]
- public string? Picturename { get; set; }
-
- /// <summary>
- /// 椤圭洰鍚嶇О
- /// </summary>
- [Column("PROJ_NAME")]
- [SugarColumn(ColumnName = "PROJ_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "椤圭洰鍚嶇О闀垮害涓嶈兘瓒呭嚭50")]
- public string ProjName { get; set; }
-
- /// <summary>
- /// 妫�楠屾爣鍑嗙紪鐮�
- /// </summary>
- [Column("QS_CODE")]
- [SugarColumn(ColumnName = "QS_CODE")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "妫�楠屾爣鍑嗙紪鐮侀暱搴︿笉鑳借秴鍑�100")]
- public string QsCode { get; set; }
-
- /// <summary>
- /// 妫�楠屾爣鍑嗗悕绉�
- /// </summary>
- [Column("QS_NAME")]
- [SugarColumn(ColumnName = "QS_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "妫�楠屾爣鍑嗗悕绉伴暱搴︿笉鑳借秴鍑�100")]
- public string QsName { get; set; }
-
- /// <summary>
- /// 1涓洪妫�锛�2涓哄贰妫�锛�3涓哄叆搴撴
- /// </summary>
- [Column("QS_TYPE")]
- [SugarColumn(ColumnName = "QS_TYPE")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "1涓洪妫�锛�2涓哄贰妫�锛�3涓哄叆搴撴闀垮害涓嶈兘瓒呭嚭1")]
- public string QsType { get; set; }
-
- /// <summary>
- /// 鏍囧噯鍊�
- /// </summary>
- [Column("STANDARD_VALUE")]
- [SugarColumn(ColumnName = "STANDARD_VALUE")] //鐢ㄤ簬SqlSugar
- public decimal? StandardValue { get; set; }
-
- /// <summary>
- /// 浣跨敤浠〃
- /// </summary>
- [Column("USING_INSTRUMENTS")]
- [SugarColumn(ColumnName = "USING_INSTRUMENTS")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "浣跨敤浠〃闀垮害涓嶈兘瓒呭嚭50")]
- public string UsingInstruments { get; set; }
-}
\ No newline at end of file
+ ///
+ ///</summary>
+ [SugarTable("MES_QUALITY_STANDARD")]
+ public class MesQualityStandard
+ {
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )]
+ public decimal Id { get; set; }
+ /// <summary>
+ /// 妯″叿鍙�
+ ///</summary>
+ [SugarColumn(ColumnName="MOID_NUM" )]
+ public string MoidNum { get; set; }
+ /// <summary>
+ /// 椤圭洰鍚嶇О
+ ///</summary>
+ [SugarColumn(ColumnName="PROJ_NAME" )]
+ public string ProjName { get; set; }
+ /// <summary>
+ /// 璐ㄩ噺瑕佹眰
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_MOD" )]
+ public string ItemMod { get; set; }
+ /// <summary>
+ /// 妫�楠屾柟娉�
+ ///</summary>
+ [SugarColumn(ColumnName="INSPECTION_METHOD" )]
+ public string InspectionMethod { get; set; }
+ /// <summary>
+ /// 浣跨敤浠〃
+ ///</summary>
+ [SugarColumn(ColumnName="USING_INSTRUMENTS" )]
+ public string UsingInstruments { get; set; }
+ /// <summary>
+ /// 妫�楠屾按骞�
+ ///</summary>
+ [SugarColumn(ColumnName="INSPECTION_LEVEL" )]
+ public string InspectionLevel { get; set; }
+ /// <summary>
+ /// 姣忔ā澶氬皯涓�
+ ///</summary>
+ [SugarColumn(ColumnName="LEVEL_NUM" )]
+ public string LevelNum { get; set; }
+ /// <summary>
+ /// 涓婇檺
+ ///</summary>
+ [SugarColumn(ColumnName="MAX_VALUE" )]
+ public string MaxValue { get; set; }
+ /// <summary>
+ /// 鏍囧噯
+ ///</summary>
+ [SugarColumn(ColumnName="STANDARD_VALUE" )]
+ public string StandardValue { get; set; }
+ /// <summary>
+ /// 涓嬮檺
+ ///</summary>
+ [SugarColumn(ColumnName="MIN_VALUE" )]
+ public string MinValue { get; set; }
+ /// <summary>
+ /// 澶囨敞
+ ///</summary>
+ [SugarColumn(ColumnName="NOTES" )]
+ public string Notes { get; set; }
+ /// <summary>
+ /// 绫诲瀷
+ ///</summary>
+ [SugarColumn(ColumnName="QS_TYPE" )]
+ public string QsType { get; set; }
+ /// <summary>
+ /// 妫�楠屾按骞�
+ ///</summary>
+ [SugarColumn(ColumnName="FCHECK_LEVEL" )]
+ public string FcheckLevel { get; set; }
+ /// <summary>
+ /// 鎺ュ彈姘村钩
+ ///</summary>
+ [SugarColumn(ColumnName="FAC_LEVEL" )]
+ public string FacLevel { get; set; }
+ /// <summary>
+ /// 妫�楠屾爣鍑嗙紪鐮�
+ ///</summary>
+ [SugarColumn(ColumnName="QS_CODE" )]
+ public string QsCode { get; set; }
+ /// <summary>
+ /// 妫�楠屾爣鍑嗗悕绉�
+ ///</summary>
+ [SugarColumn(ColumnName="QS_NAME" )]
+ public string QsName { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_BY" )]
+ public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="CREATE_DATE" )]
+ public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 瀹℃牳鐘舵��
+ ///</summary>
+ [SugarColumn(ColumnName="FSUBMIT" )]
+ public decimal? Fsubmit { get; set; }
+ /// <summary>
+ /// 瀹℃牳浜�
+ ///</summary>
+ [SugarColumn(ColumnName="FSUBMIT_BY" )]
+ public string FsubmitBy { get; set; }
+ /// <summary>
+ /// 瀹℃牳鏃堕棿
+ ///</summary>
+ [SugarColumn(ColumnName="FSUBMIT_DATE" )]
+ public DateTime? FsubmitDate { get; set; }
+ /// <summary>
+ ///
+ ///</summary>
+ [SugarColumn(ColumnName="PICTURE" )]
+ public byte[]? Picture { get; set; }
+ /// <summary>
+ /// 鍥剧墖
+ ///</summary>
+ [SugarColumn(ColumnName="PICTURENAME" )]
+ public string Picturename { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_NO" )]
+ public string ItemNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡id
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_ID" )]
+ public decimal? ItemId { get; set; }
+ /// <summary>
+ /// 鎸夎溅闂村垎绫荤埗ID
+ ///</summary>
+ [SugarColumn(ColumnName="PID" )]
+ public decimal? Pid { get; set; }
+ /// <summary>
+ /// 绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_TYPE_NO" )]
+ public string ItemTypeNo { get; set; }
+ /// <summary>
+ /// 绫诲瀷缂栫爜
+ ///</summary>
+ [SugarColumn(ColumnName="ITEM_TYPE_ID" )]
+ public decimal? ItemTypeId { get; set; }
+ /// <summary>
+ /// 杞﹂棿id
+ ///</summary>
+ [SugarColumn(ColumnName="WORKSHOP_ID" )]
+ public decimal? WorkshopId { get; set; }
+ /// <summary>
+ /// 缁勭粐id
+ ///</summary>
+ [SugarColumn(ColumnName="ORGID" )]
+ public decimal? Orgid { get; set; }
+ /// <summary>
+ /// 妫�楠屾爣鍑唅d
+ ///</summary>
+ [SugarColumn(ColumnName="AQL1_ID" )]
+ public decimal? Aql1Id { get; set; }
+ /// <summary>
+ /// 椤圭洰鎻忚堪
+ ///</summary>
+ [SugarColumn(ColumnName="MEMO" )]
+ public string Memo { get; set; }
+ }
+}
--
Gitblit v1.9.3