From 90b1732bd159aea424925d2605058c2417a4f412 Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期五, 18 七月 2025 14:27:33 +0800
Subject: [PATCH] 替代料品转换
---
StandardPda/MES.Service/Modes/MesQualityStandard.cs | 204 +++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 204 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/MesQualityStandard.cs b/StandardPda/MES.Service/Modes/MesQualityStandard.cs
new file mode 100644
index 0000000..bf414fa
--- /dev/null
+++ b/StandardPda/MES.Service/Modes/MesQualityStandard.cs
@@ -0,0 +1,204 @@
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// 璐ㄩ噺鏍囧噯琛�
+/// </summary>
+[Table("MES_QUALITY_STANDARD")]
+[SugarTable("MES_QUALITY_STANDARD")] //鐢ㄤ簬SqlSugar
+public class MesQualityStandard
+{
+ /// <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
--
Gitblit v1.9.3