From 0cff826ea489a1faa5cbb320cad52d102530a9e0 Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期四, 13 三月 2025 10:53:42 +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