From 94c9e2a81a3808e9e974ad43b7c2798093b632ed Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期二, 29 七月 2025 14:20:09 +0800
Subject: [PATCH] 1、销售模块：预测订单、标准出货、销售退货接口代码提交 2、仓退申请单接口bug修复代码提交
---
StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs | 487 ++++++++++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 487 insertions(+), 0 deletions(-)
diff --git a/StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs b/StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs
new file mode 100644
index 0000000..d5e1b35
--- /dev/null
+++ b/StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs
@@ -0,0 +1,487 @@
+using System.ComponentModel.DataAnnotations;
+using System.ComponentModel.DataAnnotations.Schema;
+using SqlSugar;
+
+namespace MES.Service.Modes;
+
+/// <summary>
+/// IQC鎶芥琛ㄥご
+/// </summary>
+[Table("MES_QA_ITEMS_DETECT_02")]
+[SugarTable("MES_QA_ITEMS_DETECT_02")] //鐢ㄤ簬SqlSugar
+public class MesQaItemsDetect02
+{
+ /// <summary>
+ /// SEQ_QM_ID
+ /// </summary>
+ [Key]
+ [Column("ID")]
+ [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QM_ID",
+ ColumnName = "ID")] //鐢ㄤ簬SqlSugar
+ public decimal Id { get; set; }
+
+ /// <summary>
+ /// 鍏ュ簱鍗曞彿
+ /// </summary>
+ [Column("AUFNR")]
+ [SugarColumn(ColumnName = "AUFNR")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "鍏ュ簱鍗曞彿闀垮害涓嶈兘瓒呭嚭100")]
+ public string? Aufnr { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜
+ /// </summary>
+ [Column("BARCODE_A")]
+ [SugarColumn(ColumnName = "BARCODE_A")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "鏉＄爜闀垮害涓嶈兘瓒呭嚭100")]
+ public string? BarcodeA { get; set; }
+
+ /// <summary>
+ /// 鏉＄爜
+ /// </summary>
+ [Column("BARCODE_B")]
+ [SugarColumn(ColumnName = "BARCODE_B")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "鏉＄爜闀垮害涓嶈兘瓒呭嚭100")]
+ public string? BarcodeB { get; set; }
+
+ /// <summary>
+ /// 浜у搧缂栫爜
+ /// </summary>
+ [Column("BOARD_ITEM")]
+ [SugarColumn(ColumnName = "BOARD_ITEM")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "浜у搧缂栫爜闀垮害涓嶈兘瓒呭嚭100")]
+ public string? BoardItem { get; set; }
+
+ /// <summary>
+ /// 璁よ瘉瑕佹眰
+ /// </summary>
+ [Column("CARD")]
+ [SugarColumn(ColumnName = "CARD")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "璁よ瘉瑕佹眰闀垮害涓嶈兘瓒呭嚭100")]
+ public string? Card { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("CLASS_NAME")]
+ [SugarColumn(ColumnName = "CLASS_NAME")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "ClassName闀垮害涓嶈兘瓒呭嚭100")]
+ public string? ClassName { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("CLASS_NO")]
+ [SugarColumn(ColumnName = "CLASS_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "ClassNo闀垮害涓嶈兘瓒呭嚭100")]
+ public string? ClassNo { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("COMPANY")]
+ [SugarColumn(ColumnName = "COMPANY")] //鐢ㄤ簬SqlSugar
+ [StringLength(20, ErrorMessage = "Company闀垮害涓嶈兘瓒呭嚭20")]
+ public string? Company { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [Column("CREATE_BY")]
+ [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�100")]
+ public string? CreateBy { get; set; }
+
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ /// </summary>
+ [Column("CREATE_DATE")]
+ [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? CreateDate { get; set; }
+
+ /// <summary>
+ /// 瀹㈡埛
+ /// </summary>
+ [Column("CUST_NAME")]
+ [SugarColumn(ColumnName = "CUST_NAME")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "瀹㈡埛闀垮害涓嶈兘瓒呭嚭100")]
+ public string? CustName { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("FAC_LEVEL")]
+ [SugarColumn(ColumnName = "FAC_LEVEL")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "FacLevel闀垮害涓嶈兘瓒呭嚭100")]
+ public string? FacLevel { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("FACTORY")]
+ [SugarColumn(ColumnName = "FACTORY")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "Factory闀垮害涓嶈兘瓒呭嚭100")]
+ public string? Factory { get; set; }
+
+ /// <summary>
+ /// 閿�鍞柟鍚�
+ /// </summary>
+ [Column("FANG")]
+ [SugarColumn(ColumnName = "FANG")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "閿�鍞柟鍚戦暱搴︿笉鑳借秴鍑�100")]
+ public string? Fang { get; set; }
+
+ /// <summary>
+ /// 閫佹鏁伴噺
+ /// </summary>
+ [Column("FBATCH_QTY")]
+ [SugarColumn(ColumnName = "FBATCH_QTY")] //鐢ㄤ簬SqlSugar
+ public decimal? FbatchQty { get; set; }
+
+ /// <summary>
+ /// 浣滃簾鏍囪瘑
+ /// </summary>
+ [Column("FCANCEL")]
+ [SugarColumn(ColumnName = "FCANCEL")] //鐢ㄤ簬SqlSugar
+ [StringLength(2, ErrorMessage = "浣滃簾鏍囪瘑闀垮害涓嶈兘瓒呭嚭2")]
+ public string? Fcancel { get; set; }
+
+ /// <summary>
+ /// 浜х嚎鑷鍛�
+ /// </summary>
+ [Column("FCHECK_BY")]
+ [SugarColumn(ColumnName = "FCHECK_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "浜х嚎鑷鍛橀暱搴︿笉鑳借秴鍑�100")]
+ public string? FcheckBy { get; set; }
+
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
+ [Column("FCHECK_DATE")]
+ [SugarColumn(ColumnName = "FCHECK_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? FcheckDate { get; set; }
+
+ /// <summary>
+ /// 涓嶅悎鏍肩▼搴�
+ /// </summary>
+ [Column("FCHECK_LEVEL")]
+ [SugarColumn(ColumnName = "FCHECK_LEVEL")] //鐢ㄤ簬SqlSugar
+ [StringLength(50, ErrorMessage = "涓嶅悎鏍肩▼搴﹂暱搴︿笉鑳借秴鍑�50")]
+ public string? FcheckLevel { get; set; }
+
+ /// <summary>
+ /// 鐗硅浜嬮」
+ /// </summary>
+ [Column("FCHECK_MEMO")]
+ [SugarColumn(ColumnName = "FCHECK_MEMO")] //鐢ㄤ簬SqlSugar
+ [StringLength(500, ErrorMessage = "鐗硅浜嬮」闀垮害涓嶈兘瓒呭嚭500")]
+ public string? FcheckMemo { get; set; }
+
+ /// <summary>
+ /// IPQC妫�楠屽憳
+ /// </summary>
+ [Column("FCHECK_RESU")]
+ [SugarColumn(ColumnName = "FCHECK_RESU")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "IPQC妫�楠屽憳闀垮害涓嶈兘瓒呭嚭100")]
+ public string? FcheckResu { get; set; }
+
+ /// <summary>
+ /// 璁惧缂栧彿
+ /// </summary>
+ [Column("FEQP")]
+ [SugarColumn(ColumnName = "FEQP")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "璁惧缂栧彿闀垮害涓嶈兘瓒呭嚭100")]
+ public string? Feqp { get; set; }
+
+ /// <summary>
+ /// 涓嶈壇鎻忚堪
+ /// </summary>
+ [Column("FNG_DESC")]
+ [SugarColumn(ColumnName = "FNG_DESC")] //鐢ㄤ簬SqlSugar
+ [StringLength(2000, ErrorMessage = "涓嶈壇鎻忚堪闀垮害涓嶈兘瓒呭嚭2000")]
+ public string? FngDesc { get; set; }
+
+ /// <summary>
+ /// 澶勭悊鏂规硶
+ /// </summary>
+ [Column("FNG_HANDLE")]
+ [SugarColumn(ColumnName = "FNG_HANDLE")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "澶勭悊鏂规硶闀垮害涓嶈兘瓒呭嚭100")]
+ public string? FngHandle { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇鏃ユ湡
+ /// </summary>
+ [Column("FPROD_DATE")]
+ [SugarColumn(ColumnName = "FPROD_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? FprodDate { get; set; }
+
+ /// <summary>
+ /// 鐢熶骇绫诲瀷
+ /// </summary>
+ [Column("FPROD_TYPE")]
+ [SugarColumn(ColumnName = "FPROD_TYPE")] //鐢ㄤ簬SqlSugar
+ [StringLength(200, ErrorMessage = "鐢熶骇绫诲瀷闀垮害涓嶈兘瓒呭嚭200")]
+ public string? FprodType { get; set; }
+
+ /// <summary>
+ /// 浜屾鍒ゅ畾缁撴灉
+ /// </summary>
+ [Column("FSECOND_RESU")]
+ [SugarColumn(ColumnName = "FSECOND_RESU")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "浜屾鍒ゅ畾缁撴灉闀垮害涓嶈兘瓒呭嚭100")]
+ public string? FsecondResu { get; set; }
+
+ /// <summary>
+ /// 1涓洪妫�锛�2涓哄畬宸ユ楠�
+ /// </summary>
+ [Column("FSTATUS")]
+ [SugarColumn(ColumnName = "FSTATUS")] //鐢ㄤ簬SqlSugar
+ public decimal? Fstatus { 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("FTYPE")]
+ [SugarColumn(ColumnName = "FTYPE")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "Ftype闀垮害涓嶈兘瓒呭嚭100")]
+ public string? Ftype { get; set; }
+
+ /// <summary>
+ /// 鐗堟湰
+ /// </summary>
+ [Column("FVERSION")]
+ [SugarColumn(ColumnName = "FVERSION")] //鐢ㄤ簬SqlSugar
+ public decimal? Fversion { get; set; }
+
+ /// <summary>
+ /// 澶勭疆浜�
+ /// </summary>
+ [Column("IPQC_BY")]
+ [SugarColumn(ColumnName = "IPQC_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(50, ErrorMessage = "澶勭疆浜洪暱搴︿笉鑳借秴鍑�50")]
+ public string? IpqcBy { get; set; }
+
+ /// <summary>
+ /// 澶勭疆鏃ユ湡
+ /// </summary>
+ [Column("IPQC_DATE")]
+ [SugarColumn(ColumnName = "IPQC_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? IpqcDate { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏍囪瘑
+ /// </summary>
+ [Column("IPQC_STATUS")]
+ [SugarColumn(ColumnName = "IPQC_STATUS")] //鐢ㄤ簬SqlSugar
+ public decimal? IpqcStatus { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("ISMODIFY1")]
+ [SugarColumn(ColumnName = "ISMODIFY1")] //鐢ㄤ簬SqlSugar
+ public decimal? Ismodify1 { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("ITEM_NO")]
+ [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "ItemNo闀垮害涓嶈兘瓒呭嚭100")]
+ public string? ItemNo { get; set; }
+
+ /// <summary>
+ /// 鏇存柊浜�
+ /// </summary>
+ [Column("LASTUPDATE_BY")]
+ [SugarColumn(ColumnName = "LASTUPDATE_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "鏇存柊浜洪暱搴︿笉鑳借秴鍑�100")]
+ public string? LastupdateBy { get; set; }
+
+ /// <summary>
+ /// 鏇存柊鏃ユ湡
+ /// </summary>
+ [Column("LASTUPDATE_DATE")]
+ [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? LastupdateDate { get; set; }
+
+ /// <summary>
+ /// 宸ヤ綅ID
+ /// </summary>
+ [Column("LINEINFO_ID")]
+ [SugarColumn(ColumnName = "LINEINFO_ID")] //鐢ㄤ簬SqlSugar
+ [StringLength(20, ErrorMessage = "宸ヤ綅ID闀垮害涓嶈兘瓒呭嚭20")]
+ public string? LineinfoId { get; set; }
+
+ /// <summary>
+ /// 绾夸綋缂栧彿
+ /// </summary>
+ [Column("LINE_NO")]
+ [SugarColumn(ColumnName = "LINE_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "绾夸綋缂栧彿闀垮害涓嶈兘瓒呭嚭100")]
+ public string? LineNo { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("LOT_NO")]
+ [SugarColumn(ColumnName = "LOT_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "LotNo闀垮害涓嶈兘瓒呭嚭100")]
+ public string? LotNo { get; set; }
+
+ /// <summary>
+ /// 澶勭疆浜�
+ /// </summary>
+ [Column("MANAGE_BY")]
+ [SugarColumn(ColumnName = "MANAGE_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(50, ErrorMessage = "澶勭疆浜洪暱搴︿笉鑳借秴鍑�50")]
+ public string? ManageBy { get; set; }
+
+ /// <summary>
+ /// 澶勭疆鏃ユ湡
+ /// </summary>
+ [Column("MANAGE_DATE")]
+ [SugarColumn(ColumnName = "MANAGE_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? ManageDate { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("MAX_CHECK_QTY")]
+ [SugarColumn(ColumnName = "MAX_CHECK_QTY")] //鐢ㄤ簬SqlSugar
+ public decimal? MaxCheckQty { get; set; }
+
+ /// <summary>
+ /// 鍘熷洜鍒嗘瀽
+ /// </summary>
+ [Column("MEMO_A")]
+ [SugarColumn(ColumnName = "MEMO_A")] //鐢ㄤ簬SqlSugar
+ [StringLength(4000, ErrorMessage = "鍘熷洜鍒嗘瀽闀垮害涓嶈兘瓒呭嚭4000")]
+ public string? MemoA { get; set; }
+
+ /// <summary>
+ /// 涓存椂瀵圭瓥
+ /// </summary>
+ [Column("MEMO_B")]
+ [SugarColumn(ColumnName = "MEMO_B")] //鐢ㄤ簬SqlSugar
+ [StringLength(4000, ErrorMessage = "涓存椂瀵圭瓥闀垮害涓嶈兘瓒呭嚭4000")]
+ public string? MemoB { get; set; }
+
+ /// <summary>
+ /// 闀挎湡瀵圭瓥
+ /// </summary>
+ [Column("MEMO_C")]
+ [SugarColumn(ColumnName = "MEMO_C")] //鐢ㄤ簬SqlSugar
+ [StringLength(4000, ErrorMessage = "闀挎湡瀵圭瓥闀垮害涓嶈兘瓒呭嚭4000")]
+ public string? MemoC { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("MENU_ID")]
+ [SugarColumn(ColumnName = "MENU_ID")] //鐢ㄤ簬SqlSugar
+ public decimal? MenuId { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳浜�
+ /// </summary>
+ [Column("MODIFY1_BY")]
+ [SugarColumn(ColumnName = "MODIFY1_BY")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "瀹℃牳浜洪暱搴︿笉鑳借秴鍑�100")]
+ public string? Modify1By { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏃ユ湡
+ /// </summary>
+ [Column("MODIFY1_DATE")]
+ [SugarColumn(ColumnName = "MODIFY1_DATE")] //鐢ㄤ簬SqlSugar
+ public DateTime? Modify1Date { get; set; }
+
+ /// <summary>
+ /// 瀹℃牳鏍囪瘑
+ /// </summary>
+ [Column("MODIFY1_FLAG")]
+ [SugarColumn(ColumnName = "MODIFY1_FLAG")] //鐢ㄤ簬SqlSugar
+ public decimal? Modify1Flag { get; set; }
+
+ /// <summary>
+ /// 鍝佺増
+ /// </summary>
+ [Column("PINGPAI")]
+ [SugarColumn(ColumnName = "PINGPAI")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "鍝佺増闀垮害涓嶈兘瓒呭嚭100")]
+ public string? Pingpai { get; set; }
+
+ /// <summary>
+ /// 璁″垝鏁伴噺
+ /// </summary>
+ [Column("PLAN_QTY")]
+ [SugarColumn(ColumnName = "PLAN_QTY")] //鐢ㄤ簬SqlSugar
+ public decimal? PlanQty { get; set; }
+
+ /// <summary>
+ /// PQC绫诲瀷璇存槑
+ /// </summary>
+ [Column("PQC_TEXT")]
+ [SugarColumn(ColumnName = "PQC_TEXT")] //鐢ㄤ簬SqlSugar
+ [StringLength(200, ErrorMessage = "PQC绫诲瀷璇存槑闀垮害涓嶈兘瓒呭嚭200")]
+ public string? PqcText { get; set; }
+
+ /// <summary>
+ /// PQC妫�楠岀被鍨�
+ /// </summary>
+ [Column("PQC_TYPE")]
+ [SugarColumn(ColumnName = "PQC_TYPE")] //鐢ㄤ簬SqlSugar
+ [StringLength(30, ErrorMessage = "PQC妫�楠岀被鍨嬮暱搴︿笉鑳借秴鍑�30")]
+ public string? PqcType { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("PROC_NAME")]
+ [SugarColumn(ColumnName = "PROC_NAME")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "ProcName闀垮害涓嶈兘瓒呭嚭100")]
+ public string? ProcName { get; set; }
+
+ /// <summary>
+ /// </summary>
+ [Column("PROC_NO")]
+ [SugarColumn(ColumnName = "PROC_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "ProcNo闀垮害涓嶈兘瓒呭嚭100")]
+ public string? ProcNo { get; set; }
+
+ /// <summary>
+ /// 妫�楠屽崟鍙�
+ /// </summary>
+ [Column("RELEASE_NO")]
+ [SugarColumn(ColumnName = "RELEASE_NO")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "妫�楠屽崟鍙烽暱搴︿笉鑳借秴鍑�100")]
+ public string? ReleaseNo { get; set; }
+
+ /// <summary>
+ /// 宸ヤ綔涓績
+ /// </summary>
+ [Column("WORKSHOP_CENTER_CODE")]
+ [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "宸ヤ綔涓績闀垮害涓嶈兘瓒呭嚭100")]
+ public string? WorkshopCenterCode { get; set; }
+
+ /// <summary>
+ /// 宸ヤ綔涓績
+ /// </summary>
+ [Column("GID")]
+ [SugarColumn(ColumnName = "GID")] //鐢ㄤ簬SqlSugar
+ [StringLength(100, ErrorMessage = "GID100")]
+ public decimal? Gid { get; set; }
+}
\ No newline at end of file
--
Gitblit v1.9.3