From 99b5d3d7c950a8332f81d3ca07be9f2d5957f58c Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期六, 29 三月 2025 16:26:44 +0800
Subject: [PATCH] 1.期初入库优化
---
entity/MesQaItemsDetect01.cs | 647 ++++++++++++++++++++++++++++-----------------------------
1 files changed, 318 insertions(+), 329 deletions(-)
diff --git a/entity/MesQaItemsDetect01.cs b/entity/MesQaItemsDetect01.cs
index 1040d23..d6481d8 100644
--- a/entity/MesQaItemsDetect01.cs
+++ b/entity/MesQaItemsDetect01.cs
@@ -1,397 +1,386 @@
锘縰sing SqlSugar;
-namespace NewPdaSqlServer.entity
+namespace NewPdaSqlServer.entity;
+
+/// <summary>
+/// </summary>
+[SugarTable("MES_QA_ITEMS_DETECT_01")]
+public class MesQaItemsDetect01
{
/// <summary>
- ///
- ///</summary>
- [SugarTable("MES_QA_ITEMS_DETECT_01")]
- public class MesQaItemsDetect01
- {
- /// <summary>
- ///
- /// 榛樿鍊�: (newid())
- ///</summary>
- [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
- public Guid Guid { get; set; }
+ /// 榛樿鍊�: (newid())
+ /// </summary>
+ [SugarColumn(ColumnName = "guid", IsPrimaryKey = true)]
+ public Guid Guid { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "about_Guid")]
- public Guid? AboutGuid { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "about_Guid")]
+ public Guid? AboutGuid { get; set; }
- /// <summary>
- /// 妫�楠屽崟鍙�
- ///</summary>
- [SugarColumn(ColumnName = "release_no")]
- public string ReleaseNo { get; set; }
+ /// <summary>
+ /// 妫�楠屽崟鍙�
+ /// </summary>
+ [SugarColumn(ColumnName = "release_no")]
+ public string ReleaseNo { get; set; }
- /// <summary>
- /// 妫�楠屾棩鏈�
- ///</summary>
- [SugarColumn(ColumnName = "fcheck_date")]
- public DateTime? FcheckDate { get; set; }
+ /// <summary>
+ /// 妫�楠屾棩鏈�
+ /// </summary>
+ [SugarColumn(ColumnName = "fcheck_date")]
+ public DateTime? FcheckDate { get; set; }
- /// <summary>
- /// 妫�楠屼汉鍛�
- ///</summary>
- [SugarColumn(ColumnName = "fcheck_by")]
- public string FcheckBy { get; set; }
+ /// <summary>
+ /// 妫�楠屼汉鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "fcheck_by")]
+ public string FcheckBy { get; set; }
- /// <summary>
- /// 鐗╂枡缂栫爜
- ///</summary>
- [SugarColumn(ColumnName = "item_no")]
- public string ItemNo { get; set; }
+ /// <summary>
+ /// 鐗╂枡缂栫爜
+ /// </summary>
+ [SugarColumn(ColumnName = "item_no")]
+ public string ItemNo { get; set; }
- /// <summary>
- /// 鏉ユ枡鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "fbatch_qty")]
- public decimal? FbatchQty { get; set; }
+ /// <summary>
+ /// 鏉ユ枡鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "fbatch_qty")]
+ public decimal? FbatchQty { get; set; }
- /// <summary>
- /// 鍒ゅ畾缁撴灉
- ///</summary>
- [SugarColumn(ColumnName = "frece_qty")]
- public string FreceQty { get; set; }
+ /// <summary>
+ /// 鍒ゅ畾缁撴灉
+ /// </summary>
+ [SugarColumn(ColumnName = "frece_qty")]
+ public string FreceQty { get; set; }
- /// <summary>
- /// 渚涘簲鍟咺D
- ///</summary>
- [SugarColumn(ColumnName = "supp_id")]
- public string SuppId { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟咺D
+ /// </summary>
+ [SugarColumn(ColumnName = "supp_id")]
+ public string SuppId { 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")]
- public string FcheckResu { get; set; }
+ /// <summary>
+ /// 妫�楠岀粨鏋�
+ /// </summary>
+ [SugarColumn(ColumnName = "fcheck_resu")]
+ public string FcheckResu { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "freview")]
- public string Freview { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "freview")]
+ public string Freview { get; set; }
- /// <summary>
- /// 妫�楠屾按鍑�
- ///</summary>
- [SugarColumn(ColumnName = "sample_size_no")]
- public string SampleSizeNo { 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 = "fcheck_level")]
+ public string FcheckLevel { get; set; }
- /// <summary>
- /// 鎷掓敹姘村钩
- ///</summary>
- [SugarColumn(ColumnName = "fac_level")]
- public string FacLevel { get; set; }
+ /// <summary>
+ /// 鎷掓敹姘村钩
+ /// </summary>
+ [SugarColumn(ColumnName = "fac_level")]
+ public string FacLevel { get; set; }
- /// <summary>
- /// 鎶芥鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "check_qty")]
- public string CheckQty { get; set; }
+ /// <summary>
+ /// 鎶芥鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "check_qty")]
+ public string CheckQty { get; set; }
- /// <summary>
- /// 鎵规鍙� --鍒拌揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "lot_no")]
- public string LotNo { get; set; }
+ /// <summary>
+ /// 鎵规鍙� --鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "lot_no")]
+ public string LotNo { get; set; }
- /// <summary>
- /// 鏄惁鎺ㄩ��
- ///</summary>
- [SugarColumn(ColumnName = "fmove")]
- public string Fmove { get; set; }
+ /// <summary>
+ /// 鏄惁鎺ㄩ��
+ /// </summary>
+ [SugarColumn(ColumnName = "fmove")]
+ public string Fmove { get; set; }
- /// <summary>
- /// 鏄惁澶勭悊
- ///</summary>
- [SugarColumn(ColumnName = "fhandle")]
- public string Fhandle { get; set; }
+ /// <summary>
+ /// 鏄惁澶勭悊
+ /// </summary>
+ [SugarColumn(ColumnName = "fhandle")]
+ public string Fhandle { get; set; }
- /// <summary>
- /// 鍒涘缓浜�
- ///</summary>
- [SugarColumn(ColumnName = "create_by")]
- public string CreateBy { get; set; }
+ /// <summary>
+ /// 鍒涘缓浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "create_by")]
+ public string CreateBy { get; set; }
- /// <summary>
- /// 鍒涘缓鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "create_date")]
- public DateTime? CreateDate { get; set; }
+ /// <summary>
+ /// 鍒涘缓鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "create_date")]
+ public DateTime? CreateDate { get; set; }
- /// <summary>
- /// 鏇存柊浜�
- ///</summary>
- [SugarColumn(ColumnName = "lastupdate_by")]
- public string LastupdateBy { 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 = "lastupdate_date")]
+ public DateTime? LastupdateDate { get; set; }
- /// <summary>
- /// 鏄惁瀹℃牳
- ///</summary>
- [SugarColumn(ColumnName = "modify1_flag")]
- public int? Modify1Flag { get; set; }
+ /// <summary>
+ /// 鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "modify1_flag")]
+ public int? Modify1Flag { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "modify1_by")]
- public string Modify1By { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "modify1_by")]
+ public string Modify1By { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "modify1_date")]
- public DateTime? Modify1Date { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "modify1_date")]
+ public DateTime? Modify1Date { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "factory")]
- public string Factory { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "factory")]
+ public string Factory { get; set; }
- /// <summary>
- /// XRF娴嬭瘯鎶ュ憡缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "fcheck_repno")]
- public string FcheckRepno { get; set; }
+ /// <summary>
+ /// XRF娴嬭瘯鎶ュ憡缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "fcheck_repno")]
+ public string FcheckRepno { get; set; }
- /// <summary>
- /// 绗笁鏂规姤鍛�
- ///</summary>
- [SugarColumn(ColumnName = "fthird_rep")]
- public string FthirdRep { get; set; }
+ /// <summary>
+ /// 绗笁鏂规姤鍛�
+ /// </summary>
+ [SugarColumn(ColumnName = "fthird_rep")]
+ public string FthirdRep { get; set; }
- /// <summary>
- /// 鏄惁浣滃簾
- ///</summary>
- [SugarColumn(ColumnName = "fcancel")]
- public int? Fcancel { get; set; }
+ /// <summary>
+ /// 鏄惁浣滃簾
+ /// </summary>
+ [SugarColumn(ColumnName = "fcancel")]
+ public int? Fcancel { get; set; }
- /// <summary>
- /// 鎻愪氦鏍囪瘑
- ///</summary>
- [SugarColumn(ColumnName = "fsubmit")]
- public int? Fsubmit { get; set; }
+ /// <summary>
+ /// 鎻愪氦鏍囪瘑
+ /// </summary>
+ [SugarColumn(ColumnName = "fsubmit")]
+ public int? Fsubmit { get; set; }
- /// <summary>
- /// 妫�楠屼緷鎹�
- ///</summary>
- [SugarColumn(ColumnName = "fcheck_accord")]
- public string FcheckAccord { get; set; }
+ /// <summary>
+ /// 妫�楠屼緷鎹�
+ /// </summary>
+ [SugarColumn(ColumnName = "fcheck_accord")]
+ public string FcheckAccord { get; set; }
- /// <summary>
- /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
- ///</summary>
- [SugarColumn(ColumnName = "ftype")]
- public int? Ftype { get; set; }
+ /// <summary>
+ /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱)
+ /// </summary>
+ [SugarColumn(ColumnName = "ftype")]
+ public int? Ftype { get; set; }
- /// <summary>
- /// 鍗曚綅
- ///</summary>
- [SugarColumn(ColumnName = "item_unit")]
- public string ItemUnit { get; set; }
+ /// <summary>
+ /// 鍗曚綅
+ /// </summary>
+ [SugarColumn(ColumnName = "item_unit")]
+ public string ItemUnit { get; set; }
- /// <summary>
- /// 鍑鸿揣鏃ユ湡
- ///</summary>
- [SugarColumn(ColumnName = "out_date")]
- public string OutDate { get; set; }
+ /// <summary>
+ /// 鍑鸿揣鏃ユ湡
+ /// </summary>
+ [SugarColumn(ColumnName = "out_date")]
+ public string OutDate { get; set; }
- /// <summary>
- /// 鏄惁鍏嶆
- ///</summary>
- [SugarColumn(ColumnName = "fexemption")]
- public int? Fexemption { get; set; }
+ /// <summary>
+ /// 鏄惁鍏嶆
+ /// </summary>
+ [SugarColumn(ColumnName = "fexemption")]
+ public int? Fexemption { get; set; }
- /// <summary>
- /// 妗ｄ綅鏍囧噯
- ///</summary>
- [SugarColumn(ColumnName = "fgear_stand")]
- public string FgearStand { get; set; }
+ /// <summary>
+ /// 妗ｄ綅鏍囧噯
+ /// </summary>
+ [SugarColumn(ColumnName = "fgear_stand")]
+ public string FgearStand { get; set; }
- /// <summary>
- /// 涓嶈壇澶勭悊鏂规硶
- ///</summary>
- [SugarColumn(ColumnName = "fng_handle")]
- public string FngHandle { get; set; }
+ /// <summary>
+ /// 涓嶈壇澶勭悊鏂规硶
+ /// </summary>
+ [SugarColumn(ColumnName = "fng_handle")]
+ public string FngHandle { get; set; }
- /// <summary>
- /// 绠＄悊缂栧彿
- ///</summary>
- [SugarColumn(ColumnName = "fmanage_no")]
- public string FmanageNo { get; set; }
+ /// <summary>
+ /// 绠＄悊缂栧彿
+ /// </summary>
+ [SugarColumn(ColumnName = "fmanage_no")]
+ public string FmanageNo { get; set; }
- /// <summary>
- /// 杞崲鏁伴噺
- ///</summary>
- [SugarColumn(ColumnName = "fcovert_qty")]
- public string FcovertQty { get; set; }
+ /// <summary>
+ /// 杞崲鏁伴噺
+ /// </summary>
+ [SugarColumn(ColumnName = "fcovert_qty")]
+ public string FcovertQty { get; set; }
- /// <summary>
- /// 鐗堟湰
- ///</summary>
- [SugarColumn(ColumnName = "fversion")]
- public int? Fversion { get; set; }
+ /// <summary>
+ /// 鐗堟湰
+ /// </summary>
+ [SugarColumn(ColumnName = "fversion")]
+ public int? Fversion { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "company")]
- public string Company { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "company")]
+ public string Company { get; set; }
- /// <summary>
- ///
- ///</summary>
- [SugarColumn(ColumnName = "fsecond_resu")]
- public string FsecondResu { get; set; }
+ /// <summary>
+ /// </summary>
+ [SugarColumn(ColumnName = "fsecond_resu")]
+ public string FsecondResu { get; set; }
- /// <summary>
- /// 鏈�澶ф娊妫�鏁�
- ///</summary>
- [SugarColumn(ColumnName = "max_check_qty")]
- public int? MaxCheckQty { get; set; }
+ /// <summary>
+ /// 鏈�澶ф娊妫�鏁�
+ /// </summary>
+ [SugarColumn(ColumnName = "max_check_qty")]
+ public int? MaxCheckQty { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼鏄惁瀹℃牳
- ///</summary>
- [SugarColumn(ColumnName = "modify1_flag1")]
- public int? Modify1Flag1 { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼鏄惁瀹℃牳
+ /// </summary>
+ [SugarColumn(ColumnName = "modify1_flag1")]
+ public int? Modify1Flag1 { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼瀹℃牳浜�
- ///</summary>
- [SugarColumn(ColumnName = "modify1_by1")]
- public string Modify1By1 { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼瀹℃牳浜�
+ /// </summary>
+ [SugarColumn(ColumnName = "modify1_by1")]
+ public string Modify1By1 { get; set; }
- /// <summary>
- /// 鐗瑰畾淇敼瀹℃牳鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "modify1_date1")]
- public DateTime? Modify1Date1 { get; set; }
+ /// <summary>
+ /// 鐗瑰畾淇敼瀹℃牳鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "modify1_date1")]
+ public DateTime? Modify1Date1 { get; set; }
- /// <summary>
- /// 灏忔壒娆″彿
- ///</summary>
- [SugarColumn(ColumnName = "lot_no1")]
- public string LotNo1 { get; set; }
+ /// <summary>
+ /// 灏忔壒娆″彿
+ /// </summary>
+ [SugarColumn(ColumnName = "lot_no1")]
+ public string LotNo1 { get; set; }
- /// <summary>
- /// 閲囪喘鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "lot_no2")]
- public string LotNo2 { get; set; }
+ /// <summary>
+ /// 閲囪喘鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "lot_no2")]
+ public string LotNo2 { get; set; }
- /// <summary>
- /// 浜у搧鍨嬪彿
- ///</summary>
- [SugarColumn(ColumnName = "board_style")]
- public string BoardStyle { get; set; }
+ /// <summary>
+ /// 浜у搧鍨嬪彿
+ /// </summary>
+ [SugarColumn(ColumnName = "board_style")]
+ public string BoardStyle { get; set; }
- /// <summary>
- /// 浠诲姟鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "work_no")]
- public string WorkNo { get; set; }
+ /// <summary>
+ /// 浠诲姟鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "work_no")]
+ public string WorkNo { get; set; }
- /// <summary>
- /// 鍒拌揣鏃堕棿
- ///</summary>
- [SugarColumn(ColumnName = "dha018")]
- public string Dha018 { get; set; }
+ /// <summary>
+ /// 鍒拌揣鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "dha018")]
+ public string Dha018 { get; set; }
- /// <summary>
- /// 琛屽彿
- ///</summary>
- [SugarColumn(ColumnName = "dhb002")]
- public int? Dhb002 { get; set; }
+ /// <summary>
+ /// 琛屽彿
+ /// </summary>
+ [SugarColumn(ColumnName = "dhb002")]
+ public int? Dhb002 { get; set; }
- /// <summary>
- /// 鍒拌揣鍗曞彿
- ///</summary>
- [SugarColumn(ColumnName = "dhb001")]
- public string Dhb001 { get; set; }
+ /// <summary>
+ /// 鍒拌揣鍗曞彿
+ /// </summary>
+ [SugarColumn(ColumnName = "dhb001")]
+ public string Dhb001 { get; set; }
- /// <summary>
- /// 渚涘簲鍟�
- ///</summary>
- [SugarColumn(ColumnName = "lifnr")]
- public string Lifnr { get; set; }
+ /// <summary>
+ /// 渚涘簲鍟�
+ /// </summary>
+ [SugarColumn(ColumnName = "lifnr")]
+ public string Lifnr { get; set; }
- /// <summary>
- /// 閫�鏂欐柟寮�
- ///</summary>
- [SugarColumn(ColumnName = "fmrmode")]
- public string Fmrmode { get; set; }
+ /// <summary>
+ /// 閫�鏂欐柟寮�
+ /// </summary>
+ [SugarColumn(ColumnName = "fmrmode")]
+ public string Fmrmode { get; set; }
- /// <summary>
- /// erp杩斿洖淇℃伅
- ///</summary>
- [SugarColumn(ColumnName = "msg")]
- public string Msg { get; set; }
+ /// <summary>
+ /// erp杩斿洖淇℃伅
+ /// </summary>
+ [SugarColumn(ColumnName = "msg")]
+ public string Msg { get; set; }
- /// <summary>
- /// 鐘舵��
- ///</summary>
- [SugarColumn(ColumnName = "states")]
- public string States { 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>
+ /// IQC鎻愪氦鏃堕棿
+ /// </summary>
+ [SugarColumn(ColumnName = "iqc_date")]
+ public DateTime? IqcDate { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟ID
- ///</summary>
- [SugarColumn(ColumnName = "ebeln_k3id")]
- public int? EbelnK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟ID
+ /// </summary>
+ [SugarColumn(ColumnName = "ebeln_k3id")]
+ public int? EbelnK3id { get; set; }
- /// <summary>
- /// 閲囪喘璁㈠崟琛孖D
- ///</summary>
- [SugarColumn(ColumnName = "line_k3id")]
- public int? LineK3id { get; set; }
+ /// <summary>
+ /// 閲囪喘璁㈠崟琛孖D
+ /// </summary>
+ [SugarColumn(ColumnName = "line_k3id")]
+ public int? LineK3id { get; set; }
- /// <summary>
- /// 璐ㄩ噺瀹℃牳鏍囪瘑
- /// 榛樿鍊�: ((0))
- ///</summary>
- [SugarColumn(ColumnName = "quality_audit")]
- public int? QualityAudit { get; set; }
+ /// <summary>
+ /// 璐ㄩ噺瀹℃牳鏍囪瘑
+ /// 榛樿鍊�: ((0))
+ /// </summary>
+ [SugarColumn(ColumnName = "quality_audit")]
+ public int? QualityAudit { get; set; }
- /// <summary>
- /// 鐗╂枡ID
- ///</summary>
- [SugarColumn(ColumnName = "item_id")]
- public int? ItemId { get; set; }
+ /// <summary>
+ /// 鐗╂枡ID
+ /// </summary>
+ [SugarColumn(ColumnName = "item_id")]
+ public int? ItemId { get; set; }
- /// <summary>
- /// 涓嶈壇鎻忚堪
- ///</summary>
- [SugarColumn(ColumnName = "remarks")]
- public string Remarks { get; set; }
- }
+ /// <summary>
+ /// 涓嶈壇鎻忚堪
+ /// </summary>
+ [SugarColumn(ColumnName = "remarks")]
+ public string Remarks { get; set; }
}
\ No newline at end of file
--
Gitblit v1.9.3