From 8276722de62e0be1e68adf65f150686a236268bd Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期五, 18 七月 2025 10:08:44 +0800 Subject: [PATCH] 产测接口代码提交 --- StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs | 573 ++++++++++++++++++++++++++++++++++++--------------------- 1 files changed, 361 insertions(+), 212 deletions(-) diff --git a/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs b/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs index 14760fb..87de6a7 100644 --- a/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs +++ b/StandardPda/MES.Service/Modes/MesQaItemsDetect01.cs @@ -8,324 +8,473 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 妫�楠屽崟鍙� - /// </summary> - [SugarColumn(ColumnName = "RELEASE_NO")] + /// <summary> + /// 妫�楠屽崟鍙� + /// </summary> + [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } - /// <summary> - /// 妫�楠屾棩鏈� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_DATE")] + /// <summary> + /// 妫�楠屾棩鏈� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } - /// <summary> - /// 妫�楠屼汉鍛� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_BY")] + /// <summary> + /// 妫�楠屼汉鍛� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 鏉ユ枡鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FBATCH_QTY")] + /// <summary> + /// 鏉ユ枡鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } - /// <summary> - /// 鍒ゅ畾缁撴灉 - /// </summary> - [SugarColumn(ColumnName = "FRECE_QTY")] + /// <summary> + /// 鎺ユ敹鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟嗙紪鍙� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FNG_DESC")] - public string FngDesc { get; set; } + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "FNG_DESC")] + public string? FngDesc { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_RESU")] + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FREVIEW")] + /// <summary> + /// OA璇勫鍙嶉 + /// </summary> + [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } - /// <summary> - /// 妫�楠屾按鍑� - /// </summary> - [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] + /// <summary> + /// 妫�楠屾按鍑� + /// </summary> + [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } - /// <summary> - /// 妫�楠屾按骞� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_LEVEL")] + /// <summary> + /// 妫�楠屾按骞� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } - /// <summary> - /// 鎷掓敹姘村钩 - /// </summary> - [SugarColumn(ColumnName = "FAC_LEVEL")] + /// <summary> + /// 鎷掓敹姘村钩 + /// </summary> + [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } - /// <summary> - /// 鎶芥鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QTY")] + /// <summary> + /// 鎶芥鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } - /// <summary> - /// 鎵规鍙� --鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] + /// <summary> + /// 鎵规鍙� --鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } - /// <summary> - /// 鏄惁鎺ㄩ�� - /// </summary> - [SugarColumn(ColumnName = "FMOVE")] + /// <summary> + /// 鏄惁鎺ㄩ�� + /// </summary> + [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } - /// <summary> - /// 鏄惁澶勭悊 - /// </summary> - [SugarColumn(ColumnName = "FHANDLE")] + /// <summary> + /// 鏄惁澶勭悊 + /// </summary> + [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏇存柊浜� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏇存柊浜� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏇存柊鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏇存柊鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鏄惁瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_FLAG")] + /// <summary> + /// 鏄惁瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_BY")] + /// <summary> + /// 瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_DATE")] + /// <summary> + /// 瀹℃牳鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// XRF娴嬭瘯鎶ュ憡缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FCHECK_REPNO")] + /// <summary> + /// XRF娴嬭瘯鎶ュ憡缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } - /// <summary> - /// 绗笁鏂规姤鍛� - /// </summary> - [SugarColumn(ColumnName = "FTHIRD_REP")] + /// <summary> + /// 绗笁鏂规姤鍛� + /// </summary> + [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } - /// <summary> - /// 鏄惁浣滃簾 - /// </summary> - [SugarColumn(ColumnName = "FCANCEL")] + /// <summary> + /// 鏄惁浣滃簾 + /// </summary> + [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } - /// <summary> - /// 鎻愪氦鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "FSUBMIT")] + /// <summary> + /// 鎻愪氦鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } - /// <summary> - /// 妫�楠屼緷鎹� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_ACCORD")] + /// <summary> + /// 妫�楠屼緷鎹� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } - /// <summary> - /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱) - /// </summary> - [SugarColumn(ColumnName = "FTYPE")] + /// <summary> + /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱) + /// </summary> + [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "ITEM_UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } - /// <summary> - /// 鍑鸿揣鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "OUT_DATE")] + /// <summary> + /// 鍑鸿揣鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } - /// <summary> - /// 鏄惁鍏嶆 - /// </summary> - [SugarColumn(ColumnName = "FEXEMPTION")] + /// <summary> + /// 鏄惁鍏嶆 + /// </summary> + [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } - /// <summary> - /// 妗d綅鏍囧噯 - /// </summary> - [SugarColumn(ColumnName = "FGEAR_STAND")] + /// <summary> + /// 妗d綅鏍囧噯 + /// </summary> + [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } - /// <summary> - /// 涓嶈壇澶勭悊鏂规硶 - /// </summary> - [SugarColumn(ColumnName = "FNG_HANDLE")] + /// <summary> + /// 涓嶈壇鏈�缁堝鐞嗘柟寮� + /// </summary> + [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } - /// <summary> - /// 绠$悊缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FMANAGE_NO")] + /// <summary> + /// 绠$悊缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } - /// <summary> - /// 杞崲鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FCOVERT_QTY")] + /// <summary> + /// 杞崲鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } - /// <summary> - /// 鐗堟湰 - /// </summary> - [SugarColumn(ColumnName = "FVERSION")] + /// <summary> + /// 鐗堟湰 + /// </summary> + [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FSECOND_RESU")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } - /// <summary> - /// 鏈�澶ф娊妫�鏁� - /// </summary> - [SugarColumn(ColumnName = "MAX_CHECK_QTY")] + /// <summary> + /// 鏈�澶ф娊妫�鏁� + /// </summary> + [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } - /// <summary> - /// 鐗瑰畾淇敼鏄惁瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_FLAG1")] + /// <summary> + /// 鐗瑰畾淇敼鏄惁瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } - /// <summary> - /// 鐗瑰畾淇敼瀹℃牳浜� - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_BY1")] + /// <summary> + /// 鐗瑰畾淇敼瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } - /// <summary> - /// 鐗瑰畾淇敼瀹℃牳鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_DATE1")] + /// <summary> + /// 鐗瑰畾淇敼瀹℃牳鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } - /// <summary> - /// 灏忔壒娆″彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO1")] + /// <summary> + /// 灏忔壒娆″彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } - /// <summary> - /// 閲囪喘鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO2")] + /// <summary> + /// 閲囪喘鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } - /// <summary> - /// 浜у搧鍨嬪彿 - /// </summary> - [SugarColumn(ColumnName = "BOARD_STYLE")] + /// <summary> + /// 浜у搧鍨嬪彿 + /// </summary> + [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 鍒拌揣鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "DHA018")] + /// <summary> + /// 鍒拌揣鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "DHB002")] + /// <summary> + /// 琛屽彿 + /// </summary> + [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB001")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "LIFNR")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } - /// <summary> - /// 閫�鏂欐柟寮� - /// </summary> - [SugarColumn(ColumnName = "FMRMODE")] + /// <summary> + /// 閫�鏂欐柟寮� + /// </summary> + [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } + + /// <summary> + /// erp杩斿洖淇℃伅 + /// </summary> + [SugarColumn(ColumnName = "MSG")] + public string Msg { get; set; } + + /// <summary> + /// 鐘舵�� + /// </summary> + [SugarColumn(ColumnName = "STATES")] + public string States { get; set; } + + /// <summary> + /// IQC鎻愪氦鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "IQC_DATE")] + public DateTime? IqcDate { get; set; } + + /// <summary> + /// 閲囪喘璁㈠崟ID + /// </summary> + [SugarColumn(ColumnName = "EBELN_K3ID")] + public decimal? EbelnK3id { get; set; } + + /// <summary> + /// 閲囪喘璁㈠崟琛孖D + /// </summary> + [SugarColumn(ColumnName = "LINE_K3ID")] + public decimal? LineK3id { get; set; } + + /// <summary> + /// 鍝佽川瀹℃牳鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "QUALITY_AUDIT")] + public decimal? QualityAudit { get; set; } + + /// <summary> + /// 鐗╂枡ID + /// </summary> + [SugarColumn(ColumnName = "ITEM_ID")] + public decimal? ItemId { get; set; } + + /// <summary> + /// 楠屾敹鏁� + /// </summary> + [SugarColumn(ColumnName = "YANS_NUM")] + public decimal? YansNum { get; set; } + + /// <summary> + /// 楠岄��鏁� + /// </summary> + [SugarColumn(ColumnName = "YANT_NUM")] + public decimal? YantNum { get; set; } + + /// <summary> + /// 閲囪喘瀹℃牳鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "CG_AUDIT")] + public decimal? CgAudit { get; set; } + + /// <summary> + /// 閲囪喘鎰忚 + /// </summary> + [SugarColumn(ColumnName = "CG_OPINION")] + public string CgOpinion { get; set; } + + /// <summary> + /// 閲囪喘澶勭悊鏂瑰紡 + /// </summary> + [SugarColumn(ColumnName = "CG_HANDLE")] + public string CgHandle { get; set; } + + /// <summary> + /// 鍝佽川鎰忚 + /// </summary> + [SugarColumn(ColumnName = "QC_OPINION")] + public string QcOpinion { get; set; } + + /// <summary> + /// 鍝佽川澶勭悊鏂瑰紡 + /// </summary> + [SugarColumn(ColumnName = "QC_HANDLE")] + public string QcHandle { get; set; } + + /// <summary> + /// 缁忕悊瀹℃牳鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "MANAGER_AUDIT")] + public decimal? ManagerAudit { get; set; } + + /// <summary> + /// 缁忕悊鎰忚 + /// </summary> + [SugarColumn(ColumnName = "MANAGER_OPINION")] + public string ManagerOpinion { get; set; } + + /// <summary> + /// 缁忕悊澶勭悊鏂瑰紡 + /// </summary> + [SugarColumn(ColumnName = "MANAGER_HANDLE")] + public string ManagerHandle { get; set; } + + /// <summary> + /// 閿�鍞鍗� + /// </summary> + [SugarColumn(ColumnName = "SALES_ORDER")] + public string SalesOrder { get; set; } + + /// <summary> + /// 閲囪喘瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "CG_USER")] + public string CgUser { get; set; } + + /// <summary> + /// 鍝佽川瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "QC_USER")] + public string QcUser { get; set; } + + /// <summary> + /// 缁忕悊瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "MANAGER_USER")] + public string ManagerUser { get; set; } + + /// <summary> + /// 璁″垝璺熻釜鍙� + /// </summary> + [SugarColumn(ColumnName = "FMTONO")] + public string Fmtono { get; set; } + + /// <summary> + /// 瀹為獙瀹ら�佹鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "IS_SJ")] + public decimal? IsSj { get; set; } + + /// <summary> + /// 瀹為獙瀹ら�佹鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "SJ_NO")] + public string SjNo { get; set; } } \ No newline at end of file -- Gitblit v1.9.3