From e66255ea9dafedb0bc2c2f0787af2097cca549d6 Mon Sep 17 00:00:00 2001 From: zyf <1071160500@qq.com> Date: 星期二, 03 六月 2025 09:10:11 +0800 Subject: [PATCH] 更新BOM接口和采购申请接口 --- MES.Service/Modes/MesQaItemsDetectDetail5.cs | 335 ++++++++++++++++++++++++++++++------------------------- 1 files changed, 183 insertions(+), 152 deletions(-) diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs index 9421a04..0aa4263 100644 --- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs +++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs @@ -1,154 +1,185 @@ -锘縰sing System; -using System.Collections.Generic; -using System.Linq; +锘縰sing System.ComponentModel.DataAnnotations.Schema; using SqlSugar; -namespace MES.Service.Modes + +namespace MES.Service.Modes; + +/// <summary> +/// 鏉ユ枡妫�楠屼粠琛� +/// </summary> +[SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] +public class MesQaItemsDetectDetail5 { - /// <summary> - /// 鏉ユ枡妫�楠屼粠琛� - ///</summary> - [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] - public class MesQaItemsDetectDetail5 - { - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] - public decimal Id { get; set; } - /// <summary> - /// 鏍囧噯鍊肩被鍨� - ///</summary> - [SugarColumn(ColumnName="FTEXT_TYPE" )] - public string FtextType { get; set; } - /// <summary> - /// 鏍囧噯鍊� - ///</summary> - [SugarColumn(ColumnName="FSTAND" )] - public decimal? Fstand { get; set; } - /// <summary> - /// 涓婂叕宸� - ///</summary> - [SugarColumn(ColumnName="FUP_ALLOW" )] - public string FupAllow { get; set; } - /// <summary> - /// 涓嬪叕宸� - ///</summary> - [SugarColumn(ColumnName="FDOWN_ALLOW" )] - public string FdownAllow { get; set; } - /// <summary> - /// 妫�楠屾按鍑� - ///</summary> - [SugarColumn(ColumnName="SAMPLE_SIZE_NO" )] - public string SampleSizeNo { 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="FCHECK_ITEM" )] - public string FcheckItem { get; set; } - /// <summary> - /// 瑙勬牸瑕佹眰 - ///</summary> - [SugarColumn(ColumnName="FSPEC_REQU" )] - public string FspecRequ { get; set; } - /// <summary> - /// 鎶芥鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="CHECK_QYT" )] - public decimal? CheckQyt { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - ///</summary> - [SugarColumn(ColumnName="FCHECK_RESU" )] - public string FcheckResu { get; set; } - /// <summary> - /// AC鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="FAC_QTY" )] - public decimal? FacQty { get; set; } - /// <summary> - /// RE鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="FRE_QTY" )] - public decimal? FreQty { get; set; } - /// <summary> - /// 涓嶅悎鏍兼暟 - ///</summary> - [SugarColumn(ColumnName="FNG_QTY" )] - public decimal? FngQty { get; set; } - /// <summary> - /// 涓嶈壇鐜� - ///</summary> - [SugarColumn(ColumnName="FNG_RATE" )] - public decimal? FngRate { get; set; } - /// <summary> - /// 宸插綍鍏ユ暟閲� - ///</summary> - [SugarColumn(ColumnName="FENTER_QTY" )] - public decimal? FenterQty { get; set; } - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="RELEASE_NO" )] - public string ReleaseNo { get; set; } - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="COMPANY" )] - public string Company { get; set; } - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="FACTORY" )] - public string Factory { get; set; } - /// <summary> - /// 妫�楠岄」鐩弿杩� - ///</summary> - [SugarColumn(ColumnName="FCHECK_ITEM_DESC" )] - public string FcheckItemDesc { get; set; } - /// <summary> - /// 宸ュ簭鍙� - ///</summary> - [SugarColumn(ColumnName="PROC_NO" )] - public string ProcNo { get; set; } - /// <summary> - /// 宸ヤ綔涓績缂栫爜 - ///</summary> - [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE" )] - public string WorkshopCenterCode { get; set; } - /// <summary> - /// 鍗曚綅 - ///</summary> - [SugarColumn(ColumnName="FUNIT" )] - public string Funit { get; set; } - /// <summary> - /// 鐗瑰畾淇敼 - ///</summary> - [SugarColumn(ColumnName="GIVEN_MODIFY" )] - public short? GivenModify { get; set; } - /// <summary> - /// 妫�楠屽伐鍏� - ///</summary> - [SugarColumn(ColumnName="FCHECK_TOOL" )] - public string FcheckTool { get; set; } - /// <summary> - /// 鏇存柊浜� - ///</summary> - [SugarColumn(ColumnName="LASTUPDATE_BY" )] - public string LastupdateBy { get; set; } - /// <summary> - /// 鏇存柊鏃堕棿 - ///</summary> - [SugarColumn(ColumnName="LASTUPDATE_DATE" )] - public DateTime? LastupdateDate { get; set; } - } -} + /// <summary> + /// </summary> + [Column("ID")] + [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_QM_ID", + IsPrimaryKey = true)] + public decimal? Id { get; set; } + + /// <summary> + /// 鏍囧噯鍊肩被鍨� + /// </summary> + [SugarColumn(ColumnName = "FTEXT_TYPE")] + public string? FtextType { get; set; } + + /// <summary> + /// 鏍囧噯鍊� + /// </summary> + [SugarColumn(ColumnName = "FSTAND")] + public string? Fstand { get; set; } + + /// <summary> + /// 涓婂叕宸� + /// </summary> + [SugarColumn(ColumnName = "FUP_ALLOW")] + public string? FupAllow { get; set; } + + /// <summary> + /// 涓嬪叕宸� + /// </summary> + [SugarColumn(ColumnName = "FDOWN_ALLOW")] + public string? FdownAllow { get; set; } + + /// <summary> + /// 妫�楠屾按鍑� + /// </summary> + [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] + public string? SampleSizeNo { 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 = "FCHECK_ITEM")] + public string? FcheckItem { get; set; } + + /// <summary> + /// 瑙勬牸瑕佹眰 + /// </summary> + [SugarColumn(ColumnName = "FSPEC_REQU")] + public string? FspecRequ { get; set; } + + /// <summary> + /// 鎶芥鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QYT")] + public decimal? CheckQyt { get; set; } + + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_RESU")] + public string? FcheckResu { get; set; } + + /// <summary> + /// AC鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FAC_QTY")] + public decimal? FacQty { get; set; } + + /// <summary> + /// RE鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FRE_QTY")] + public decimal? FreQty { get; set; } + + /// <summary> + /// 涓嶅悎鏍兼暟 + /// </summary> + [SugarColumn(ColumnName = "FNG_QTY")] + public decimal? FngQty { get; set; } + + /// <summary> + /// 涓嶈壇鐜� + /// </summary> + [SugarColumn(ColumnName = "FNG_RATE")] + public decimal? FngRate { get; set; } + + /// <summary> + /// 宸插綍鍏ユ暟閲� + /// </summary> + [SugarColumn(ColumnName = "FENTER_QTY")] + public decimal? FenterQty { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "RELEASE_NO")] + public string? ReleaseNo { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] + public string? Company { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] + public string? Factory { get; set; } + + /// <summary> + /// 妫�楠岄」鐩弿杩� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] + public string? FcheckItemDesc { get; set; } + + /// <summary> + /// 宸ュ簭鍙� + /// </summary> + [SugarColumn(ColumnName = "PROC_NO")] + public string? ProcNo { get; set; } + + /// <summary> + /// 宸ヤ綔涓績缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] + public string? WorkshopCenterCode { get; set; } + + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "FUNIT")] + public string? Funit { get; set; } + + /// <summary> + /// 鐗瑰畾淇敼 + /// </summary> + [SugarColumn(ColumnName = "GIVEN_MODIFY")] + public short? GivenModify { get; set; } + + /// <summary> + /// 妫�楠屽伐鍏� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_TOOL")] + public string? FcheckTool { get; set; } + + /// <summary> + /// 鏇存柊浜� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] + public string? LastupdateBy { get; set; } + + /// <summary> + /// 鏇存柊鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + public DateTime? LastupdateDate { get; set; } + + /// <summary> + /// 涓嶈壇鎻忚堪 + /// </summary> + [SugarColumn(ColumnName = "REMARKS")] + public string? Remarks { get; set; } + + [SugarColumn(IsIgnore = true)] public int? Unqualified { get; set; } +} \ No newline at end of file -- Gitblit v1.9.3