From bdbfc1045c94e23c74cf9c6f98b0b4f9b0ca0d00 Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 24 一月 2025 08:27:00 +0800
Subject: [PATCH] 删除多余的文件
---
StandardPda/MES.Service/service/BasicData/MesSupplierManager.cs | 4
/dev/null | 154 --------------------------------------
StandardPda/MES.Service/service/BasicData/MesItemsManager.cs | 4
StandardPda/MES.Service/Modes/MesDepots.cs | 1
StandardPda/MES.Service/service/BasicData/SysDepartmentManager.cs | 1
StandardPda/MES.Service/Modes/SysDepartment.cs | 18 ----
StandardPda/MESApplication/Controllers/BasicData/EmployeeInfoController.cs | 2
StandardPda/MES.Service/service/BasicData/MesProjectManager.cs | 6 +
8 files changed, 13 insertions(+), 177 deletions(-)
diff --git a/StandardPda/MES.Service/Dto/service/ImageDataDto.cs b/StandardPda/MES.Service/Dto/service/ImageDataDto.cs
deleted file mode 100644
index 23b46fe..0000000
--- a/StandardPda/MES.Service/Dto/service/ImageDataDto.cs
+++ /dev/null
@@ -1,8 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class ImageDataDto
-{
- public List<MesQsImage>? entity;
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/service/MaterialReceipt.cs b/StandardPda/MES.Service/Dto/service/MaterialReceipt.cs
deleted file mode 100644
index 2bffa77..0000000
--- a/StandardPda/MES.Service/Dto/service/MaterialReceipt.cs
+++ /dev/null
@@ -1,12 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class MaterialReceipt
-{
- public List<MesInvItemOutItems>? ItemsList { get; set; }
-
- public List<MesInvItemOutCDetails>? InvItemoutCDetails { get; set; }
-
- public MesInvItemOuts? ItemOuts { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/service/MovesDto.cs b/StandardPda/MES.Service/Dto/service/MovesDto.cs
deleted file mode 100644
index a36d0d2..0000000
--- a/StandardPda/MES.Service/Dto/service/MovesDto.cs
+++ /dev/null
@@ -1,15 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class MovesDto
-{
- //鍑哄叆鍗�
- public List<MesInvItemMoves>? FromList { get; set; }
- public List<MesInvItemOutItems>? OutItems { get; set; }
- public List<MesInvItemMovesCDetails>? BarcodeList { get; set; }
-
- //鍏ュ簱鍗�
- public bool? InAudit { get; set; }
- public MesInvItemBarcodes? BarcodesInfo { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/service/OutItemDto.cs b/StandardPda/MES.Service/Dto/service/OutItemDto.cs
deleted file mode 100644
index 14bc886..0000000
--- a/StandardPda/MES.Service/Dto/service/OutItemDto.cs
+++ /dev/null
@@ -1,16 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class OutItemDto
-{
- public MesInvItemOuts? Form { get; set; }
- public List<MesInvItemOutItems>? SaveItems { get; set; }
- public List<MESInvItemOutItems>? SelectItems { get; set; }
-
- public string? ItemNo { get; set; }
-
- public decimal? Quantity { get; set; }
-
- public List<InventoryItem>? SumItem { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/service/PurchaseInventory.cs b/StandardPda/MES.Service/Dto/service/PurchaseInventory.cs
deleted file mode 100644
index 3067272..0000000
--- a/StandardPda/MES.Service/Dto/service/PurchaseInventory.cs
+++ /dev/null
@@ -1,17 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class PurchaseInventory
-{
- public string? ItemNo { get; set; }
-
- public decimal? SumQuantity { get; set; }
-
- public MesInvItemIns? ItemIns { get; set; }
- public List<MesInvItemInCDetails>? InvItemInCDetails { get; set; }
-
- public List<MesInvItemInCItems>? ItemInDetails { get; set; }
-
- public List<MesInvItemStocks>? ItemStocks { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Dto/service/XJDto.cs b/StandardPda/MES.Service/Dto/service/XJDto.cs
deleted file mode 100644
index f36a69b..0000000
--- a/StandardPda/MES.Service/Dto/service/XJDto.cs
+++ /dev/null
@@ -1,35 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class XJDto
-{
- public string? userNo { get; set; }
-
- //涓昏〃id
- public int? gid { get; set; }
-
- //瀛愯〃id
- public int? pid { get; set; }
-
- //瀛欒〃id
- public int? id { get; set; }
-
- //澶囨敞
- public string? Remarks { get; set; }
-
- //==========================================
- //宸℃涓诲瓙琛ㄩ渶瑕佺殑鏁版嵁
- public QsQaItemXj? from { get; set; }
-
- public List<QsQaItemXj01>? items { get; set; }
-
- //==========================================
- //宸℃瀛愬瓩琛ㄩ渶瑕佺殑鏁版嵁
-
- public QsQaItemXj01? ItemXj01 { get; set; }
-
- public List<QsQaItemXj02>? ItemXj02s { get; set; }
-
- public MesQsSuspend? entity { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesDepots.cs b/StandardPda/MES.Service/Modes/MesDepots.cs
index 79a27e7..5583bdd 100644
--- a/StandardPda/MES.Service/Modes/MesDepots.cs
+++ b/StandardPda/MES.Service/Modes/MesDepots.cs
@@ -12,7 +12,6 @@
/// ID(SEQ_INV_ID)
///</summary>
[SugarColumn(ColumnName = "DEPOT_ID",
- OracleSequenceName = "SEQ_INV_ID",
IsPrimaryKey = true)]
public decimal DepotId { get; set; }
diff --git a/StandardPda/MES.Service/Modes/MesInvItemArnDetail.cs b/StandardPda/MES.Service/Modes/MesInvItemArnDetail.cs
deleted file mode 100644
index 7be265c..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemArnDetail.cs
+++ /dev/null
@@ -1,225 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// </summary>
-[SugarTable("MES_INV_ITEM_ARN_DETAIL")]
-public class MesInvItemArnDetail
-{
- /// <summary>
- /// SEQ_INV_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 涓昏〃ID
- /// </summary>
- [SugarColumn(ColumnName = "MID")]
- public decimal? Mid { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN")]
- public string Ebeln { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_LINE")]
- public decimal? EbelnLine { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_QTY")]
- public decimal? EbelnQty { get; set; }
-
- /// <summary>
- /// 鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
-
- /// <summary>
- /// 鏀惰揣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { 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 = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗旾D
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public decimal? EbelnK3id { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗曡ID
- /// </summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
- public decimal? LineK3id { get; set; }
-
- /// <summary>
- /// 鏈搴旀敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "SUB_QTY")]
- public decimal? SubQty { get; set; }
-
- /// <summary>
- /// 浣欓噺
- /// </summary>
- [SugarColumn(ColumnName = "MARGIN_QTY")]
- public decimal? MarginQty { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string WorkNo { get; set; }
-
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
- public decimal? UrgentFlag { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "MEMO")]
- public string Memo { get; set; }
-
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_RES")]
- public string CheckRes { get; set; }
-
- /// <summary>
- /// 妫�楠岀姸鎬� 锛堝緟妫�銆佸垎閫夈�佺壒閲囥�佸凡妫�锛�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_STATES")]
- public string CheckStates { get; set; }
-
- /// <summary>
- /// 鏀惰揣浣欓噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY_M")]
- public decimal? QuantityM { get; set; }
-
- /// <summary>
- /// 鏈搴旀敹浣欓噺
- /// </summary>
- [SugarColumn(ColumnName = "SUB_MQTY")]
- public decimal? SubMqty { get; set; }
-
- /// <summary>
- /// 妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
-
- /// <summary>
- /// 鏄惁妫�楠�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
- public short? Ischeck { get; set; }
-
- /// <summary>
- /// 宸叉敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "OK_QTY")]
- public decimal? OkQty { get; set; }
-
- /// <summary>
- /// 宸叉敹浣欓噺
- /// </summary>
- [SugarColumn(ColumnName = "OK_MQTY")]
- public decimal? OkMqty { get; set; }
-
- /// <summary>
- /// 浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string BoardStyle { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 0銆侀噰璐崟锛�1銆佸澶栧崟
- /// </summary>
- [SugarColumn(ColumnName = "F_TYPE")]
- public decimal? FType { get; set; }
-
- /// <summary>
- /// 鏄惁鍏ュ簱
- /// </summary>
- [SugarColumn(ColumnName = "ISDEPS_IN")]
- public short? IsdepsIn { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "DHA001")]
- public string Dha001 { get; set; }
-
- /// <summary>
- /// 宸插叆搴撴暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "OK_RKQTY")]
- public decimal? OkRkqty { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
- public string CbillNo { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? itemModel { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? itemName { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? Fname { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemBarcodes.cs b/StandardPda/MES.Service/Modes/MesInvItemBarcodes.cs
deleted file mode 100644
index 99458c0..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemBarcodes.cs
+++ /dev/null
@@ -1,496 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡鏉＄爜琛�
-/// </summary>
-[SugarTable("MES_INV_ITEM_BARCODES")]
-public class MesInvItemBarcodes
-{
- /// <summary>
- /// SEQ_BARCODE_PSN_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_EQBASE",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string ItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鎴愬搧缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "C_PRODUCT_CODE")]
- public string CProductCode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
- public string CItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string CItemCode { get; set; }
-
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
-
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string LotNo { get; set; }
-
- /// <summary>
- /// 鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
-
- /// <summary>
- /// 鏄惁鐜繚(0:鍚�,1:鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public short? EpFlag { get; set; }
-
- /// <summary>
- /// 鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string TaskNo { 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 = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string CustNo { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")]
- public string ItemBarcodeText { get; set; }
-
- /// <summary>
- /// 鍘烶SN鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")]
- public string OldItemBarcode { get; set; }
-
- /// <summary>
- /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "MBLNR")]
- public string Mblnr { get; set; }
-
- /// <summary>
- /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "ZEILE")]
- public decimal? Zeile { get; set; }
-
- /// <summary>
- /// 鏀舵枡琛↖D
- /// </summary>
- [SugarColumn(ColumnName = "ROH_IN_ID")]
- public decimal? RohInId { get; set; }
-
- /// <summary>
- /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮�
- /// </summary>
- [SugarColumn(ColumnName = "BARCODESTATUS")]
- public short? Barcodestatus { get; set; }
-
- /// <summary>
- /// 鍘熷鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "OLDQTY")]
- public decimal? Oldqty { get; set; }
-
- /// <summary>
- /// 浣跨敤鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "USEQTY")]
- public decimal? Useqty { get; set; }
-
- /// <summary>
- /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾
- /// </summary>
- [SugarColumn(ColumnName = "LOCATION")]
- public short? Location { get; set; }
-
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "UNIT")]
- public string Unit { get; set; }
-
- /// <summary>
- /// 閲嶉噺锛堝崟浣嶏細鍏枻锛�
- /// </summary>
- [SugarColumn(ColumnName = "WEIGHT_UNIT")]
- public decimal? WeightUnit { get; set; }
-
- /// <summary>
- /// 鍗曚环
- /// </summary>
- [SugarColumn(ColumnName = "PRICE")]
- public decimal? Price { get; set; }
-
- /// <summary>
- /// 鍘熸潯鐮佹暟閲�
- /// </summary>
- [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")]
- public decimal? OldBarQuantity { get; set; }
-
- /// <summary>
- /// 姹囨�绘潯鐮�
- /// </summary>
- [SugarColumn(ColumnName = "SUM_BARCODE")]
- public string SumBarcode { get; set; }
-
- /// <summary>
- /// 鐢熶骇鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "LOT_DATE")]
- public string LotDate { get; set; }
-
- /// <summary>
- /// 妯″彿
- /// </summary>
- [SugarColumn(ColumnName = "MOCODE")]
- public string Mocode { get; set; }
-
- /// <summary>
- /// 鏉ユ簮
- /// </summary>
- [SugarColumn(ColumnName = "MEMO")]
- public string Memo { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string SuppNo { get; set; }
-
- /// <summary>
- /// 妗ｄ綅浣庡��
- /// </summary>
- [SugarColumn(ColumnName = "SPOSTION")]
- public string Spostion { get; set; }
-
- /// <summary>
- /// 妗ｄ綅楂樺��
- /// </summary>
- [SugarColumn(ColumnName = "EPOSTION")]
- public string Epostion { get; set; }
-
- /// <summary>
- /// 鐗╂枡绠�绉�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_SNAME")]
- public string ItemSname { get; set; }
-
- /// <summary>
- /// 鏄惁宸插喕缁�,1鍐荤粨
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE")]
- public short? Visable { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗘壒娆�
- /// </summary>
- [SugarColumn(ColumnName = "TR_LOTNO")]
- public string TrLotno { get; set; }
-
- /// <summary>
- /// 鍐荤粨鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "FLEZZ_DATE")]
- public DateTime? FlezzDate { get; set; }
-
- /// <summary>
- /// 鍐荤粨鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "FLEZZ_REASON")]
- public string FlezzReason { get; set; }
-
- /// <summary>
- /// 鍐荤粨浜�
- /// </summary>
- [SugarColumn(ColumnName = "FLEZZ_BY")]
- public string FlezzBy { get; set; }
-
- /// <summary>
- /// 寤堕暱淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "DELANY_MONTH")]
- public decimal? DelanyMonth { get; set; }
-
- /// <summary>
- /// 鏈�灏忓寘瑁呮爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "MINPACK_FLAG")]
- public short? MinpackFlag { get; set; }
-
- /// <summary>
- /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁�
- /// </summary>
- [SugarColumn(ColumnName = "PRINT_ID")]
- public string PrintId { get; set; }
-
- /// <summary>
- /// 鐜繚椤圭洰
- /// </summary>
- [SugarColumn(ColumnName = "EP_ITEM")]
- public string EpItem { get; set; }
-
- /// <summary>
- /// 宸ュ巶缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
-
- /// <summary>
- /// 鍗℃澘缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CB_NO")]
- public string CbNo { get; set; }
-
- /// <summary>
- /// 鍘傚鐢熶骇绾�
- /// </summary>
- [SugarColumn(ColumnName = "LINFLINE")]
- public string Linfline { get; set; }
-
- /// <summary>
- /// 鏈夋晥鏈�
- /// </summary>
- [SugarColumn(ColumnName = "VALID_TIME")]
- public DateTime? ValidTime { get; set; }
-
- /// <summary>
- /// 璐ㄦ缁撴灉
- /// </summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
- public string IqcStatus { get; set; }
-
- /// <summary>
- /// 灏忚溅鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "FCAR")]
- public string Fcar { get; set; }
-
- /// <summary>
- /// 姣涢噸
- /// </summary>
- [SugarColumn(ColumnName = "GWEIGHT")]
- public string Gweight { get; set; }
-
- /// <summary>
- /// 鍑�閲�
- /// </summary>
- [SugarColumn(ColumnName = "NWEIGHT")]
- public string Nweight { get; set; }
-
- /// <summary>
- /// 淇濊川鏈�
- /// </summary>
- [SugarColumn(ColumnName = "EXT_DATE")]
- public decimal? ExtDate { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶�
- /// </summary>
- [SugarColumn(ColumnName = "BARCODETYPE")]
- public string Barcodetype { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗗悕绉�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NAME")]
- public string SuppName { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string BillNo { get; set; }
-
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
- public short? UrgentFlag { get; set; }
-
- /// <summary>
- /// 棰滆壊
- /// </summary>
- [SugarColumn(ColumnName = "COLOR_NAME")]
- public string ColorName { get; set; }
-
- /// <summary>
- /// 浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string BoardStyle { get; set; }
-
- /// <summary>
- /// 鏉ユ枡鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INS_DATE")]
- public DateTime? InsDate { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 涓嶈壇鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "MEMO_BAD")]
- public string MemoBad { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string WorkNo { get; set; }
-
- /// <summary>
- /// 鏉＄爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "COME_FLG")]
- public short? ComeFlg { get; set; }
-
- /// <summary>
- /// 鐢熶骇绾夸綋
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string LineNo { get; set; }
-
- /// <summary>
- /// 涓濆嵃娆℃暟
- /// </summary>
- [SugarColumn(ColumnName = "SILK_PQTY")]
- public decimal? SilkPqty { get; set; }
-
- /// <summary>
- /// 涓濆嵃娆℃暟姣�
- /// </summary>
- [SugarColumn(ColumnName = "SILK")]
- public string Silk { get; set; }
-
- /// <summary>
- /// 涓濆嵃娲惧伐浠庤〃ID
- /// </summary>
- [SugarColumn(ColumnName = "SILK_ID")]
- public decimal? SilkId { get; set; }
-
- /// <summary>
- /// 宸叉姤宸ユ爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_FLG")]
- public decimal? WorkFlg { get; set; }
-
- /// <summary>
- /// 鏈�鍚庡伐搴�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LAST")]
- public decimal? WorkLast { get; set; }
-
- /// <summary>
- /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃
- /// </summary>
- [SugarColumn(ColumnName = "HBDY")]
- public decimal? Hbdy { get; set; }
-
- /// <summary>
- /// 0-鏈夋晥鏉＄爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥
- /// </summary>
- [SugarColumn(ColumnName = "HBDYTM")]
- public decimal? Hbdytm { get; set; }
-
- /// <summary>
- /// 鎶ュ伐鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_FLGTIME")]
- public string WorkFlgtime { 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 = "ITEM_ID")]
- public decimal? ItemId { get; set; }
-
- /// <summary>
- /// 鐢熶骇宸ュ簭ID
- /// </summary>
- [SugarColumn(ColumnName = "GX_ID")]
- public decimal? GxId { get; set; }
-
- /// <summary>
- /// 缁勭粐id
- /// </summary>
- [SugarColumn(ColumnName = "ORG_NAME")]
- public string OrgName { get; set; }
-
- /// <summary>
- /// 璐т富id
- /// </summary>
- [SugarColumn(ColumnName = "ORG_OWNER")]
- public string OrgOwner { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemInCDetails.cs b/StandardPda/MES.Service/Modes/MesInvItemInCDetails.cs
deleted file mode 100644
index 0bf8253..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemInCDetails.cs
+++ /dev/null
@@ -1,362 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡鍏ュ簱鏉＄爜鏄庣粏
-/// </summary>
-[SugarTable("MES_INV_ITEM_IN_C_DETAILS")]
-public class MesInvItemInCDetails
-{
- /// <summary>
- /// SEQ_OUT
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鍗昳d
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)]
- public decimal ItemInId { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜PSN
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string ItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string CItemCode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_BARCODE")]
- public string CItemBarcode { get; set; }
-
- /// <summary>
- /// 楠屾敹鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_FLAG")]
- public short? BarcodeFlag { get; set; }
-
- /// <summary>
- /// 鐜繚鏍囧織锛�0-闈炵幆淇�,1-鐜繚.鏃犳潯鐮佹墜宸ュ綍鍏ワ紝鏈夋潯鐮佷负鍐椾綑瀛楁锛�
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public short? EpFlag { 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 = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 浣滀笟鏂瑰紡0-鏈夌嚎鏉＄爜鏋�1-鏃犵嚎鏉＄爜鏋�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_TYPE")]
- public decimal? WorkType { get; set; }
-
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
-
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string LotNo { get; set; }
-
- /// <summary>
- /// 鏄惁鍏辩鐗╂枡(0:鍚︼紝1:鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "COMANAGEMENT_FLAG")]
- public short? ComanagementFlag { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string CustNo { get; set; }
-
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_RES")]
- public string CheckRes { get; set; }
-
- /// <summary>
- /// 杩涜揣鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
- public decimal? CheckQty { get; set; }
-
- /// <summary>
- /// 妫�楠岀姸鎬�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_STATES")]
- public string CheckStates { get; set; }
-
- /// <summary>
- /// 寮哄埗鍏ュ簱鏍囪0鏃狅紝1-寮哄埗鍏ュ簱 閫�鏂欏崟浣跨敤
- /// </summary>
- [SugarColumn(ColumnName = "FORCE_IN_FLAG")]
- public short? ForceInFlag { get; set; }
-
- /// <summary>
- /// 浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
- public string DepotCode { get; set; }
-
- /// <summary>
- /// 璐т綅缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
- public string DepotSectionCode { get; set; }
-
- /// <summary>
- /// 鐗硅浜嬮」
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string Remark { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE2")]
- public string ItemBarcode2 { get; set; }
-
- /// <summary>
- /// 鏂版潯鐮�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE3")]
- public string ItemBarcode3 { get; set; }
-
- /// <summary>
- /// 浣跨敤鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "USE_QTY")]
- public decimal? UseQty { get; set; }
-
- /// <summary>
- /// 棰嗘枡鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "OUT_QTY")]
- public decimal? OutQty { get; set; }
-
- /// <summary>
- /// 鐗╂枡绠�绉�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_SNAME")]
- public string ItemSname { get; set; }
-
- /// <summary>
- /// 妗ｄ綅浣庡��
- /// </summary>
- [SugarColumn(ColumnName = "SPOSTION")]
- public decimal? Spostion { get; set; }
-
- /// <summary>
- /// 妗ｄ綅楂樺��
- /// </summary>
- [SugarColumn(ColumnName = "EPOSTION")]
- public decimal? Epostion { get; set; }
-
- /// <summary>
- /// 妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
-
- /// <summary>
- /// 鍗曚綅
- /// </summary>
- [SugarColumn(ColumnName = "UNIT")]
- public string Unit { get; set; }
-
- /// <summary>
- /// 鏄惁妫�楠�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
- public decimal? Ischeck { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "EBELN")]
- public string Ebeln { get; set; }
-
- /// <summary>
- /// 鐢熶骇鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "LOT_DATE")]
- public string LotDate { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string BillNo { get; set; }
-
- /// <summary>
- /// 鍏ュ簱瀹℃牳鏍囧織
- /// </summary>
- [SugarColumn(ColumnName = "STOCK_OK")]
- public short? StockOk { get; set; }
-
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
-
- /// <summary>
- /// 鍗℃澘缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CB_NO")]
- public string CbNo { get; set; }
-
- /// <summary>
- /// 绠卞彿
- /// </summary>
- [SugarColumn(ColumnName = "BOX_NO")]
- public string BoxNo { get; set; }
-
- /// <summary>
- /// 浠撳簱ID
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_ID")]
- public decimal? DepotId { get; set; }
-
- /// <summary>
- /// 璐т綅ID
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_ID")]
- public decimal? DepotSectionId { get; set; }
-
- /// <summary>
- /// 琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NUM")]
- public string LineNum { get; set; }
-
- /// <summary>
- /// 鎵爜鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "SM_QTY")]
- public decimal? SmQty { get; set; }
-
- /// <summary>
- /// 閿�鍞鍗�
- /// </summary>
- [SugarColumn(ColumnName = "VGBEL")]
- public string Vgbel { get; set; }
-
- /// <summary>
- /// 閿�鍞鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "KDPOS")]
- public decimal? Kdpos { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string WorkNo { get; set; }
-
- /// <summary>
- /// 琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_LINE_NO")]
- public decimal? EbelnLineNo { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
- public string CbillNo { get; set; }
-
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
- public decimal? UrgentFlag { get; set; }
-
- /// <summary>
- /// 浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string BoardStyle { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string TaskNo { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string SuppNo { get; set; }
-
- /// <summary>
- /// 浠诲姟姹囨姤鍗�
- /// </summary>
- [SugarColumn(ColumnName = "RBILL_NO")]
- public string RbillNo { get; set; }
-
- // 娣诲姞鐨勫瓧娈碉紝骞朵笖瀹冧滑涓嶅睘浜庢暟鎹簱琛�
- [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }
-
- [SugarColumn(IsIgnore = true)] public decimal? SumQuantity { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemIns.cs b/StandardPda/MES.Service/Modes/MesInvItemIns.cs
deleted file mode 100644
index 2e05e27..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemIns.cs
+++ /dev/null
@@ -1,316 +0,0 @@
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡鍏ュ簱涓昏〃
-/// </summary>
-[SugarTable("MES_INV_ITEM_INS")]
-public class MesInvItemIns
-{
- /// <summary>
- /// ID(SEQ_INV_ID)
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string? BillNo { get; set; }
-
- /// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
- public short? Status { get; set; }
-
- /// <summary>
- /// 浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DEPOTS_ID")]
- public decimal? DepotsId { get; set; }
-
- /// <summary>
- /// 鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "REASON")]
- public string? Reason { 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 = "LASTUPDATE_BY")]
- public string? LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
- public decimal? BillTypeId { get; set; }
-
- /// <summary>
- /// 浜嬪姟绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_ID")]
- public decimal? TransactionId { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
-
- /// <summary>
- /// 閫佽揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "PAPER_BILL_NO")]
- public string? PaperBillNo { get; set; }
-
- /// <summary>
- /// 閫�鏂欎汉宸ュ彿
- /// </summary>
- [SugarColumn(ColumnName = "USER_NO_BACK")]
- public string? UserNoBack { get; set; }
-
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_USER")]
- public string? CheckUser { get; set; }
-
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
-
- /// <summary>
- /// 鐢熶骇璁㈠崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INS_DATE")]
- public DateTime? InsDate { get; set; }
-
- /// <summary>
- /// 妫�楠岀粨鏋�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_RES")]
- public string? CheckRes { get; set; }
-
- /// <summary>
- /// 宸叉崱鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_QTY")]
- public decimal? CheckQty { get; set; }
-
- /// <summary>
- /// 棰嗘枡宸ユ
- /// </summary>
- [SugarColumn(ColumnName = "MMLIST")]
- public string? Mmlist { get; set; }
-
- /// <summary>
- /// SAP閲囪喘璁㈠崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "EBELN")]
- public string? Ebeln { get; set; }
-
- /// <summary>
- /// 浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOTS_CODE")]
- public string? DepotsCode { get; set; }
-
- /// <summary>
- /// 浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "TRANSCTION_NO")]
- public string? TransctionNo { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "FSTATUS")]
- public short? Fstatus { get; set; }
-
- /// <summary>
- /// 宸ュ巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
-
- /// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// </summary>
- [SugarColumn(ColumnName = "SAPSTATUS")]
- public short? Sapstatus { get; set; }
-
- /// <summary>
- /// SAP杩斿洖鍗曟嵁
- /// </summary>
- [SugarColumn(ColumnName = "SAPNO")]
- public string? Sapno { get; set; }
-
- /// <summary>
- /// SAP杩斿洖骞翠唤
- /// </summary>
- [SugarColumn(ColumnName = "SAPYEAR")]
- public short? Sapyear { get; set; }
-
- /// <summary>
- /// SAP杩斿洖淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "SAPTEXT")]
- public string? Saptext { get; set; }
-
- /// <summary>
- /// 纭鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INSDATE")]
- public DateTime? InsdateA { get; set; }
-
- /// <summary>
- /// 鏄惁妫�楠�
- /// </summary>
- [SugarColumn(ColumnName = "ISCHECK")]
- public decimal? Ischeck { get; set; }
-
- /// <summary>
- /// 瀹℃牳鍏ュ簱浜�
- /// </summary>
- [SugarColumn(ColumnName = "INSBY")]
- public string? Insby { get; set; }
-
- /// <summary>
- /// 鏄惁鏄剧ず
- /// </summary>
- [SugarColumn(ColumnName = "IS_VISUAL")]
- public decimal? IsVisual { get; set; }
-
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
-
- /// <summary>
- /// 鎬ユ枡鏍囪瘑
- /// </summary>
- [SugarColumn(ColumnName = "URGENT_FLAG")]
- public short? UrgentFlag { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string? LineNo { get; set; }
-
- /// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "MTTRANSCTION_NO")]
- public decimal? MttransctionNo { get; set; }
-
- /// <summary>
- /// 宸ュ崟琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "TASK_LINO")]
- public string? TaskLino { get; set; }
-
- /// <summary>
- /// 鎶曟枡閫氱煡鍗曞崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "FBILLNO")]
- public string? Fbillno { get; set; }
-
- /// <summary>
- /// 鎶曟枡鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "FBILL_LINO")]
- public string? FbillLino { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string? CustNo { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NAME")]
- public string? CustName { get; set; }
-
- /// <summary>
- /// IQC妫�楠屽崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "IQC_RELEASE_NO")]
- public string? IqcReleaseNo { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "CBILL_NO")]
- public string? CbillNo { get; set; }
-
- /// <summary>
- /// 0 鐢宠鍗曪紝1鍏ュ簱鍗曟爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "PICK_INS")]
- public decimal? PickIns { get; set; }
-
- /// <summary>
- /// 鍏ュ簱瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_USER")]
- public string? FcheckUser { get; set; }
-
- /// <summary>
- /// 鍏ュ簱瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "FCHECK_DATE")]
- public DateTime? FcheckDate { get; set; }
-
- /// <summary>
- /// 浠诲姟姹囨姤鍗�
- /// </summary>
- [SugarColumn(ColumnName = "RBILL_NO")]
- public string? RbillNo { get; set; }
-
- //鍦ㄦ暟鎹簱鏌ヨ鏃跺拷鐣ヨ繖涓瓧娈�
- [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemMovesCDetails.cs b/StandardPda/MES.Service/Modes/MesInvItemMovesCDetails.cs
deleted file mode 100644
index 1fc798b..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemMovesCDetails.cs
+++ /dev/null
@@ -1,237 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡绉诲簱鏉＄爜鏄庣粏浠庤〃
-/// </summary>
-[SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")]
-public class MesInvItemMovesCDetails
-{
- /// <summary>
- /// seq_inv_id
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
- public decimal? ItemMoveId { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string? ItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string? CItemCode { get; set; }
-
- /// <summary>
- /// 淇″崕鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
-
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string? LotNo { get; set; }
-
- /// <summary>
- /// 鏁伴噺锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
-
- /// <summary>
- /// 鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_FLAG")]
- public short? BarcodeFlag { get; set; }
-
- /// <summary>
- /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public short? EpFlag { 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 = "LASTUPDATE_BY")]
- public string? LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 瀛愬簱id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
- public decimal? InvDepotsId { get; set; }
-
- /// <summary>
- /// 璐т綅id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
- public decimal? InvDepotSectionsId { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string? CustNo { get; set; }
-
- /// <summary>
- /// 浠诲姟浠ゅ彿
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
-
- /// <summary>
- /// 绉诲嚭浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
- public string? FromDepotsCode { get; set; }
-
- /// <summary>
- /// 绉诲嚭搴撲綅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")]
- public string? FromDepotSectionsCode { get; set; }
-
- /// <summary>
- /// 鏉＄爜澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
-
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
-
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
-
- /// <summary>
- /// 绠卞彿
- /// </summary>
- [SugarColumn(ColumnName = "BOX_NO")]
- public string? BoxNo { get; set; }
-
- /// <summary>
- /// 鍗℃澘鍙�
- /// </summary>
- [SugarColumn(ColumnName = "KO_NO")]
- public string? KoNo { get; set; }
-
- /// <summary>
- /// 绉诲叆浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
- public string? InvDepotsCode { get; set; }
-
- /// <summary>
- /// 绉诲叆搴撲綅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
- public string? InvDepotSectionsCode { get; set; }
-
- /// <summary>
- /// 璐ㄦ缁撴灉
- /// </summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
- public string? IqcStatus { get; set; }
-
- /// <summary>
- /// 灏忚溅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FCAR")]
- public string? Fcar { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INDEP_DATE")]
- public DateTime? IndepDate { get; set; }
-
- /// <summary>
- /// 鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
- public short? VisableSubmit { get; set; }
-
- /// <summary>
- /// 鎻愪氦閲嶆浜�
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
- public string? VisableSubmitBy { get; set; }
-
- /// <summary>
- /// 鎻愪氦閲嶆鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
- public DateTime? VisableSubmitDate { 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_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
-
- /// <summary>
- /// 璋冨叆
- /// </summary>
- [SugarColumn(ColumnName = "MOVE_OK")]
- public decimal? MoveOk { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }
- [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemOutCDetails.cs b/StandardPda/MES.Service/Modes/MesInvItemOutCDetails.cs
deleted file mode 100644
index 2a20b10..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemOutCDetails.cs
+++ /dev/null
@@ -1,244 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡鍑哄簱鏉＄爜鏄庣粏
-/// </summary>
-[SugarTable("MES_INV_ITEM_OUT_C_DETAILS")]
-public class MesInvItemOutCDetails
-{
- /// <summary>
- /// SEQ_INV_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍑哄簱鍗昳d
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_OUT_ID")]
- public decimal? ItemOutId { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string ItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string CItemCode { get; set; }
-
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string ItemNo { get; set; }
-
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string LotNo { get; set; }
-
- /// <summary>
- /// 鏁伴噺锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
-
- /// <summary>
- /// 鎸枡鏍囧織锛�0锛嶅惁锛�1锛嶆槸锛�
- /// </summary>
- [SugarColumn(ColumnName = "FORCE_OUT_FLAG")]
- public decimal? ForceOutFlag { 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 = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string CustNo { get; set; }
-
- /// <summary>
- /// 浠撳簱缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
- public string DepotCode { get; set; }
-
- /// <summary>
- /// 璐т綅缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
- public string DepotSectionCode { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string Remark { get; set; }
-
- /// <summary>
- /// 鍏嶆鏍囪瘑(0-鍚︼紝1-鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "FORCE_EXEMPT_FLAG")]
- public short? ForceExemptFlag { get; set; }
-
- /// <summary>
- /// 鎶曟枡鎵规
- /// </summary>
- [SugarColumn(ColumnName = "PRD_LOT_NO")]
- public string PrdLotNo { get; set; }
-
- /// <summary>
- /// 鏄惁鍋氭帴鏀舵鏌�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_STATUS")]
- public short? CheckStatus { get; set; }
-
- /// <summary>
- /// 宸ュ巶缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string Company { get; set; }
-
- /// <summary>
- /// 鍘熺敓浜у伐鍗�
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NOY")]
- public string TaskNoy { get; set; }
-
- /// <summary>
- /// 绠卞彿
- /// </summary>
- [SugarColumn(ColumnName = "BOX_NO")]
- public string BoxNo { get; set; }
-
- /// <summary>
- /// 鍖呰鎵规
- /// </summary>
- [SugarColumn(ColumnName = "TASK_PACK")]
- public string TaskPack { get; set; }
-
- /// <summary>
- /// 鍗℃澘
- /// </summary>
- [SugarColumn(ColumnName = "KB_NO")]
- public string KbNo { get; set; }
-
- /// <summary>
- /// 浜у搧鏈哄瀷
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string BoardStyle { get; set; }
-
- /// <summary>
- /// 鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string TaskNo { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string WorkNo { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string SuppNo { get; set; }
-
- /// <summary>
- /// 棰嗘枡鍗曞彿/濮斿璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "PBILL_NO")]
- public string PbillNo { get; set; }
-
- /// <summary>
- /// 鎺ユ敹鏍囪瘑/1宸叉帴鏀�
- /// </summary>
- [SugarColumn(ColumnName = "RECEIVE")]
- public decimal? Receive { get; set; }
-
- /// <summary>
- /// 鎺ユ敹鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "RTIME")]
- public DateTime? Rtime { get; set; }
-
- /// <summary>
- /// 鎺ユ敹浜�
- /// </summary>
- [SugarColumn(ColumnName = "RCV_BY")]
- public string RcvBy { get; set; }
-
- /// <summary>
- /// 鎺ユ敹杞﹂棿
- /// </summary>
- [SugarColumn(ColumnName = "RCV_PART")]
- public string RcvPart { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "RK_NO")]
- public string RkNo { 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; }
-
- [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
- [SugarColumn(IsIgnore = true)] public string? Unit { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string DepotSectionName { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs b/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
deleted file mode 100644
index 41d01b8..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemOutItems.cs
+++ /dev/null
@@ -1,229 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鍑哄簱鐢宠鐗╂枡琛�
-/// </summary>
-[SugarTable("MES_INV_ITEM_OUT_ITEMS")]
-public class MesInvItemOutItems
-{
- /// <summary>
- /// SEQ_ITEM_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍑哄簱ID
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_OUT_ID")]
- public decimal? ItemOutId { get; set; }
-
- /// <summary>
- /// 鐗╂枡缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
-
- /// <summary>
- /// 鐢宠鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { 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 = "LASTUPDATE_BY")]
- public string? LastupdateBy { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 澶囨敞淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
-
- /// <summary>
- /// 鎺ㄤ粙浠撳簱
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
- public string? DepotCode { get; set; }
-
- /// <summary>
- /// 鎺ㄤ粙搴撲綅
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
- public string? DepotSectionCode { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string? WorkNo { get; set; }
-
- /// <summary>
- /// 鍒拌揣鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// ERP 涓昏〃ID
- /// </summary>
- [SugarColumn(ColumnName = "ERP_ID")]
- public decimal? ErpId { get; set; }
-
- /// <summary>
- /// ERP 浠庤〃ID
- /// </summary>
- [SugarColumn(ColumnName = "ERP_AUTOID")]
- public decimal? ErpAutoid { get; set; }
-
- /// <summary>
- /// ERP_鏂欏彿
- /// </summary>
- [SugarColumn(ColumnName = "ERP_ITEM_NO")]
- public string? ErpItemNo { get; set; }
-
- /// <summary>
- /// 棰滆壊
- /// </summary>
- [SugarColumn(ColumnName = "COLOR_NAME")]
- public string? ColorName { get; set; }
-
- /// <summary>
- /// 鏈�鏂颁笅杞芥洿鏂版爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "UPDATE_FLG")]
- public decimal? UpdateFlg { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗旾D
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_K3ID")]
- public decimal? EbelnK3id { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗曡ID
- /// </summary>
- [SugarColumn(ColumnName = "LINE_K3ID")]
- public decimal? LineK3id { get; set; }
-
- /// <summary>
- /// 閲囪喘鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN")]
- public string? Ebeln { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_LINE")]
- public decimal? EbelnLine { get; set; }
-
- /// <summary>
- /// 閲囪喘璁㈠崟鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "EBELN_QTY")]
- public decimal? EbelnQty { get; set; }
-
- /// <summary>
- /// 浜у搧缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_ITEM")]
- public string? BoardItem { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "F_TYPE")]
- public decimal? FType { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
- public decimal? Status { get; set; }
-
- /// <summary>
- /// 瀛愬瓙琛↖D
- /// </summary>
- [SugarColumn(ColumnName = "ALLOCATEID")]
- public decimal? Allocateid { get; set; }
-
- /// <summary>
- /// 棰嗘枡缂栧彿/鐢熶骇宸ュ崟
- /// </summary>
- [SugarColumn(ColumnName = "PBILL_NO")]
- public string? PbillNo { get; set; }
-
- /// <summary>
- /// erp鎺ュ彛杩斿洖
- /// </summary>
- [SugarColumn(ColumnName = "ERP_MARK")]
- public string? ErpMark { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "RK_NO")]
- public string? RkNo { get; set; }
-
- /// <summary>
- /// 宸插叆搴撴暟
- /// </summary>
- [SugarColumn(ColumnName = "RK_QTY")]
- public decimal? RkQty { get; set; }
-
- /// <summary>
- /// 宸叉壂鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "TL_QTY")]
- public decimal? TlQty { get; set; }
-
- /// <summary>
- /// 鐗╂枡ID
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_ID")]
- public decimal? ItemId { get; set; }
-
- /// <summary>
- /// 鐗╂枡鎶曟枡鍗旾D
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_DABID")]
- public decimal? ItemDabid { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }
- [SugarColumn(IsIgnore = true)] public string? QuantityOk { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemOuts.cs b/StandardPda/MES.Service/Modes/MesInvItemOuts.cs
deleted file mode 100644
index eeae84c..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemOuts.cs
+++ /dev/null
@@ -1,307 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡鍑哄簱琛�
-/// </summary>
-[SugarTable("MES_INV_ITEM_OUTS")]
-public class MesInvItemOuts
-{
- /// <summary>
- /// SEQ_INV_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍑哄簱鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_OUT_NO")]
- public string? ItemOutNo { get; set; }
-
- /// <summary>
- /// 鐢熶骇璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
-
- /// <summary>
- /// 宸ュ簭鍙�
- /// </summary>
- [SugarColumn(ColumnName = "PROC_NO")]
- public string? ProcNo { get; set; }
-
- /// <summary>
- /// 鐘舵�亅0-鏈鏍�1-瀹℃牳
- /// </summary>
- [SugarColumn(ColumnName = "STATUS")]
- public decimal? Status { 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 = "LASTUPDATE_BY")]
- public string? LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鍗曟嵁绫诲瀷ID
- /// </summary>
- [SugarColumn(ColumnName = "BILL_TYPE_ID")]
- public decimal? BillTypeId { get; set; }
-
- /// <summary>
- /// 浜嬪姟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "TRANSACTION_NO")]
- public decimal? TransactionNo { get; set; }
-
- /// <summary>
- /// 澶囨敞淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
-
- /// <summary>
- /// 鍑哄簱鍘熷洜
- /// </summary>
- [SugarColumn(ColumnName = "REASON")]
- public string? Reason { get; set; }
-
- /// <summary>
- /// 鐢熶骇绾跨紪鐮�
- /// </summary>
- [SugarColumn(ColumnName = "PRODUCE_LINE_NO")]
- public string? ProduceLineNo { get; set; }
-
- /// <summary>
- /// 瀹℃牳浜�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_USER")]
- public string? CheckUser { get; set; }
-
- /// <summary>
- /// 瀹℃牳鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
-
- /// <summary>
- /// 棰嗘枡鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "OUT_DATE")]
- public DateTime? OutDate { get; set; }
-
- /// <summary>
- /// 棰嗘枡宸ユ
- /// </summary>
- [SugarColumn(ColumnName = "MMLIST")]
- public string? Mmlist { get; set; }
-
- /// <summary>
- /// 瀛愬簱CODE
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_CODE")]
- public string? DepotCode { get; set; }
-
- /// <summary>
- /// SAP杩斿洖鍗曟嵁
- /// </summary>
- [SugarColumn(ColumnName = "SAPNO")]
- public string? Sapno { get; set; }
-
- /// <summary>
- /// 鏄惁宸插洖鍐橲AP
- /// </summary>
- [SugarColumn(ColumnName = "SAPSTATUS")]
- public short? Sapstatus { get; set; }
-
- /// <summary>
- /// SAP杩斿洖骞翠唤
- /// </summary>
- [SugarColumn(ColumnName = "SAPYEAR")]
- public short? Sapyear { get; set; }
-
- /// <summary>
- /// SAP杩斿洖淇℃伅
- /// </summary>
- [SugarColumn(ColumnName = "SAPTEXT")]
- public string? Saptext { get; set; }
-
- /// <summary>
- /// 宸ュ簭绾夸綋
- /// </summary>
- [SugarColumn(ColumnName = "PROC_LINE_NO")]
- public string? ProcLineNo { get; set; }
-
- /// <summary>
- /// 棰嗘枡閮ㄩ棬
- /// </summary>
- [SugarColumn(ColumnName = "OUT_PART")]
- public string? OutPart { get; set; }
-
- /// <summary>
- /// 0 鐢熶骇,1 濮斿
- /// </summary>
- [SugarColumn(ColumnName = "F_TYPE")]
- public long? FType { get; set; }
-
- /// <summary>
- /// 褰曞叆鎻愪氦
- /// </summary>
- [SugarColumn(ColumnName = "OUT_STATUS")]
- public decimal? OutStatus { get; set; }
-
- /// <summary>
- /// 鏄惁鍙
- /// </summary>
- [SugarColumn(ColumnName = "IS_VISUAL")]
- public decimal? IsVisual { get; set; }
-
- /// <summary>
- /// 鎺ユ敹浜�
- /// </summary>
- [SugarColumn(ColumnName = "RECEIVER")]
- public string? Receiver { get; set; }
-
- /// <summary>
- /// 宸ュ巶缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
-
- /// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
-
- /// <summary>
- /// 鍐查攢浜嬪姟绫诲瀷缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "MTRANSCTION_NO")]
- public decimal? MtransctionNo { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string? WorkNo { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿琛屽彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
-
- /// <summary>
- /// 璁㈠崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "CMPOCODE")]
- public string? Cmpocode { get; set; }
-
- /// <summary>
- /// 鍘熺墿鏂欏嚭璐ф爣璇�
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_FLAG")]
- public decimal? ItemFlag { get; set; }
-
- /// <summary>
- /// 1=鍗婃垚鍝佸嚭璐�
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_FLAG")]
- public decimal? BoardFlag { get; set; }
-
- /// <summary>
- /// 鍑哄簱绫诲埆
- /// </summary>
- [SugarColumn(ColumnName = "OUT_TYPE")]
- public string? OutType { get; set; }
-
- /// <summary>
- /// 涓氬姟绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "BUSINESS_TYPE")]
- public string? BusinessType { get; set; }
-
- /// <summary>
- /// 浜у搧缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_ITEM")]
- public string? BoardItem { get; set; }
-
- /// <summary>
- /// 浜ч噺
- /// </summary>
- [SugarColumn(ColumnName = "PLAN_QTY")]
- public decimal? PlanQty { get; set; }
-
- /// <summary>
- /// 棰嗘枡缂栧彿/濮斿璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "PBILL_NO")]
- public string? PbillNo { get; set; }
-
- /// <summary>
- /// 琛ユ枡鐢宠鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "BBILL_NO")]
- public string? BbillNo { get; set; }
-
- /// <summary>
- /// 鏍囪瘑 /1宸叉帹閫�
- /// </summary>
- [SugarColumn(ColumnName = "NFLAG")]
- public short? Nflag { get; set; }
-
- /// <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; }
-
- [SugarColumn(IsIgnore = true)] public string? DepotName { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? CreateByFname { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? CheckUserFname { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesInvItemStocks.cs b/StandardPda/MES.Service/Modes/MesInvItemStocks.cs
deleted file mode 100644
index 2a5a4d1..0000000
--- a/StandardPda/MES.Service/Modes/MesInvItemStocks.cs
+++ /dev/null
@@ -1,203 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡搴撳瓨琛�
-/// </summary>
-[SugarTable("MES_INV_ITEM_STOCKS")]
-public class MesInvItemStocks
-{
- /// <summary>
- /// SEQ_ME_ID
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鐢熶骇璁㈠崟
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string? ItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string? CItemCode { get; set; }
-
- /// <summary>
- /// 鏈徃鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
-
- /// <summary>
- /// 瀛愬簱id
- /// </summary>
- [SugarColumn(ColumnName = "DEPOTS_ID")]
- public decimal? DepotsId { get; set; }
-
- /// <summary>
- /// 璐т綅id
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTIONS_ID")]
- public decimal? DepotSectionsId { get; set; }
-
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string? LotNo { get; set; }
-
- /// <summary>
- /// 鏁伴噺
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
-
- /// <summary>
- /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級(0-鍚︼紝1-鏄�)
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public short? EpFlag { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CUSTOMER_NO")]
- public string? CustomerNo { get; set; }
-
- /// <summary>
- /// 閲嶉噺
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_WT")]
- public decimal? ItemWt { get; set; }
-
- /// <summary>
- /// 瀛愬簱CODE
- /// </summary>
- [SugarColumn(ColumnName = "DEPOTS_CODE")]
- public string? DepotsCode { get; set; }
-
- /// <summary>
- /// 璐т綅CODE
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTIONS_CODE")]
- public string? DepotSectionsCode { get; set; }
-
- /// <summary>
- /// 妫�楠屾棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "CHECK_DATE")]
- public DateTime? CheckDate { get; set; }
-
- /// <summary>
- /// 0 鐗╂枡 1 鍗婃垚鍝� 2 鎴愬搧
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_TYPE")]
- public short? ItemType { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INDEP_DATE")]
- public DateTime? IndepDate { get; set; }
-
- /// <summary>
- /// 宸ュ巶缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
-
- /// <summary>
- /// 鍏徃缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
-
- /// <summary>
- /// 璐ㄦ鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
- public string? IqcStatus { get; set; }
-
- /// <summary>
- /// 灏忚溅鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "FCAR")]
- public string? Fcar { get; set; }
-
- /// <summary>
- /// 鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
- public short? VisableSubmit { get; set; }
-
- /// <summary>
- /// 鎻愪氦閲嶆浜�
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
- public string? VisableSubmitBy { get; set; }
-
- /// <summary>
- /// 鎻愪氦閲嶆鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
- public DateTime? VisableSubmitDate { 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_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
-
- /// <summary>
- /// 鐢熶骇绾�
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string? LineNo { get; set; }
-
- /// <summary>
- /// 鍗婃垚鍝佸叆搴撳崟鍙�
- /// </summary>
- [SugarColumn(ColumnName = "BILL_NO")]
- public string? BillNo { 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; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesLine.cs b/StandardPda/MES.Service/Modes/MesLine.cs
deleted file mode 100644
index b1d8449..0000000
--- a/StandardPda/MES.Service/Modes/MesLine.cs
+++ /dev/null
@@ -1,167 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 绾夸綋
-/// </summary>
-[SugarTable("MES_LINE")]
-public class MesLine
-{
- /// <summary>
- /// 涓婚敭
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 绾夸綋缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string LineNo { get; set; }
-
- /// <summary>
- /// 绾夸綋鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NAME")]
- public string LineName { get; set; }
-
- /// <summary>
- /// 宸ヤ綔涓績缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")]
- public string WorkshopCenterCode { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "MEMO")]
- public string Memo { 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 = "LASTUPDATE_BY")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庝慨鏀规棩鏈�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鍗℃澘鍒嗙被
- /// </summary>
- [SugarColumn(ColumnName = "BK01")]
- public string Bk01 { get; set; }
-
- /// <summary>
- /// 鏍囩鏄剧ず鍊�
- /// </summary>
- [SugarColumn(ColumnName = "LABEL")]
- public string Label { get; set; }
-
- /// <summary>
- /// 杞﹂棿绠�鐮�
- /// </summary>
- [SugarColumn(ColumnName = "WORKHOMEJM")]
- public string Workhomejm { get; set; }
-
- /// <summary>
- /// 绾跨畝鐮�
- /// </summary>
- [SugarColumn(ColumnName = "LINEJM")]
- public string Linejm { get; set; }
-
- /// <summary>
- /// 鏉＄爜绫诲瀷
- /// </summary>
- [SugarColumn(ColumnName = "BARTYPE")]
- public string Bartype { get; set; }
-
- /// <summary>
- /// 寰俊鏄剧ず鍊�
- /// </summary>
- [SugarColumn(ColumnName = "WX_LABLE")]
- public string WxLable { get; set; }
-
- /// <summary>
- /// 鍖哄垎閿傞敯閿備簹
- /// </summary>
- [SugarColumn(ColumnName = "WORKCENTERTYPE")]
- public string Workcentertype { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "SIMPLENAME")]
- public string Simplename { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "SHOW_INDEX")]
- public decimal? ShowIndex { 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 = "DEPOT_CODE")]
- public string DepotCode { get; set; }
-
- /// <summary>
- /// 榛樿搴撲綅
- /// </summary>
- [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")]
- public string DepotSectionCode { get; set; }
-
- /// <summary>
- /// 鎶ュ伐鏂瑰紡锛�0銆佺鏁ｆ姤宸ワ紝1銆佹暣绾挎姤宸ワ級
- /// </summary>
- [SugarColumn(ColumnName = "WORK_TYPE")]
- public decimal? WorkType { get; set; }
-
- /// <summary>
- /// 閮ㄩ棬缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "DEPARTMENTCODE")]
- public string Departmentcode { get; set; }
-
- /// <summary>
- /// 鎵�灞炲伐搴�
- /// </summary>
- [SugarColumn(ColumnName = "PROC_NO")]
- public string ProcNo { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "LINE_STYLE")]
- public string LineStyle { get; set; }
-
- /// <summary>
- /// 缁勯暱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "L_CODE")]
- public string LCode { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesLineUser.cs b/StandardPda/MES.Service/Modes/MesLineUser.cs
deleted file mode 100644
index f96faf3..0000000
--- a/StandardPda/MES.Service/Modes/MesLineUser.cs
+++ /dev/null
@@ -1,40 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鏈哄彴涓庝汉鍛樺鐓�
-/// </summary>
-[SugarTable("MES_LINE_USER")]
-public class MesLineUser
-{
- /// <summary>
- /// 搴忓垪SEQ_LINE_US
- /// </summary>
- [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鏈哄彴缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NO")]
- public string? LineNo { get; set; }
-
- /// <summary>
- /// 鏈哄彴涓枃
- /// </summary>
- [SugarColumn(ColumnName = "LINE_NAME")]
- public string? LineName { get; set; }
-
- /// <summary>
- /// 浜哄憳缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FCODE")]
- public string? Fcode { get; set; }
-
- /// <summary>
- /// 浜哄憳鍚嶇О
- /// </summary>
- [SugarColumn(ColumnName = "FNAME")]
- public string? Fname { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQa.cs b/StandardPda/MES.Service/Modes/MesQa.cs
deleted file mode 100644
index 198761e..0000000
--- a/StandardPda/MES.Service/Modes/MesQa.cs
+++ /dev/null
@@ -1,73 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 妫�楠岄」鐩富琛�
-/// </summary>
-[Table("MES_QA")]
-[SugarTable("MES_QA")] //鐢ㄤ簬SqlSugar
-public class MesQa
-{
- /// <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("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>
- /// 搴忓垪SEQ_QS
- /// </summary>
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal? Id { get; set; }
-
- /// <summary>
- /// 鐗╂枡缂栧彿
- /// </summary>
- [Column("ITEM_NO")]
- [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鐗╂枡缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
- public string? ItemNo { 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; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQaItem.cs b/StandardPda/MES.Service/Modes/MesQaItem.cs
deleted file mode 100644
index d1f62bc..0000000
--- a/StandardPda/MES.Service/Modes/MesQaItem.cs
+++ /dev/null
@@ -1,35 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// </summary>
-[Table("MES_QA_ITEM")]
-[SugarTable("MES_QA_ITEM")] //鐢ㄤ簬SqlSugar
-public class MesQaItem
-{
- /// <summary>
- /// 瀵瑰簲搴忓垪SEQ_QA
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal? Id { get; set; }
-
- /// <summary>
- /// 鐗╂枡缂栧彿
- /// </summary>
- [Column("ITEM_NO")]
- [SugarColumn(ColumnName = "ITEM_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鐗╂枡缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
- public string? ItemNo { get; set; }
-
- /// <summary>
- /// 涓昏〃id
- /// </summary>
- [Column("QID")]
- [SugarColumn(ColumnName = "QID")] //鐢ㄤ簬SqlSugar
- public decimal? Qid { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs b/StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs
deleted file mode 100644
index d5e1b35..0000000
--- a/StandardPda/MES.Service/Modes/MesQaItemsDetect02.cs
+++ /dev/null
@@ -1,487 +0,0 @@
-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
diff --git a/StandardPda/MES.Service/Modes/MesQmAql1.cs b/StandardPda/MES.Service/Modes/MesQmAql1.cs
deleted file mode 100644
index cf40e09..0000000
--- a/StandardPda/MES.Service/Modes/MesQmAql1.cs
+++ /dev/null
@@ -1,172 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// AQL鎶芥牱鍩哄噯
-/// </summary>
-[Table("MES_QM_AQL1")]
-[SugarTable("MES_QM_AQL1")] //鐢ㄤ簬SqlSugar
-public class MesQmAql1
-{
- /// <summary>
- /// ID(seq_me_id)
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鍏徃
- /// </summary>
- [Column("COMPANY")]
- [SugarColumn(ColumnName = "COMPANY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "鍏徃闀垮害涓嶈兘瓒呭嚭20")]
- public string Company { get; set; }
-
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [Column("CREATE_BY")]
- [SugarColumn(ColumnName = "CREATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�32")]
- public string CreateBy { get; set; }
-
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 鍒涘缓浜哄鍚�
- /// </summary>
- [Column("CREATE_NAME")]
- [SugarColumn(ColumnName = "CREATE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鍒涘缓浜哄鍚嶉暱搴︿笉鑳借秴鍑�32")]
- public string CreateName { get; set; }
-
- /// <summary>
- /// 淇敼/鏂板鐘舵��
- /// </summary>
- [Column("EDIT_STATUS")]
- [SugarColumn(ColumnName = "EDIT_STATUS")] //鐢ㄤ簬SqlSugar
- public decimal? EditStatus { get; set; }
-
- /// <summary>
- /// 鎵�灞炲伐鍘�
- /// </summary>
- [Column("FACTORY")]
- [SugarColumn(ColumnName = "FACTORY")] //鐢ㄤ簬SqlSugar
- [StringLength(100, ErrorMessage = "鎵�灞炲伐鍘傞暱搴︿笉鑳借秴鍑�100")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 瀹℃壒鏃ユ湡
- /// </summary>
- [Column("FONE_CHECKDATE")]
- [SugarColumn(ColumnName = "FONE_CHECKDATE")] //鐢ㄤ簬SqlSugar
- public DateTime? FoneCheckdate { get; set; }
-
- /// <summary>
- /// 瀹℃壒鏍囪
- /// </summary>
- [Column("FONE_CHECKED")]
- [SugarColumn(ColumnName = "FONE_CHECKED")] //鐢ㄤ簬SqlSugar
- public decimal? FoneChecked { get; set; }
-
- /// <summary>
- /// 瀹℃壒浜�
- /// </summary>
- [Column("FONE_CHECKOR")]
- [SugarColumn(ColumnName = "FONE_CHECKOR")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "瀹℃壒浜洪暱搴︿笉鑳借秴鍑�50")]
- public string FoneCheckor { get; set; }
-
- /// <summary>
- /// 纭鏃ユ湡
- /// </summary>
- [Column("FTWO_CHECKDATE")]
- [SugarColumn(ColumnName = "FTWO_CHECKDATE")] //鐢ㄤ簬SqlSugar
- public DateTime? FtwoCheckdate { get; set; }
-
- /// <summary>
- /// 纭鏍囪
- /// </summary>
- [Column("FTWO_CHECKED")]
- [SugarColumn(ColumnName = "FTWO_CHECKED")] //鐢ㄤ簬SqlSugar
- public decimal? FtwoChecked { get; set; }
-
- /// <summary>
- /// 纭浜�
- /// </summary>
- [Column("FTWO_CHECKOR")]
- [SugarColumn(ColumnName = "FTWO_CHECKOR")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "纭浜洪暱搴︿笉鑳借秴鍑�50")]
- public string FtwoCheckor { get; set; }
-
- /// <summary>
- /// 鐗堟湰鍙�
- /// </summary>
- [Column("FVERSION")]
- [SugarColumn(ColumnName = "FVERSION")] //鐢ㄤ簬SqlSugar
- public decimal? Fversion { get; set; }
-
- /// <summary>
- /// 鏄惁鍙敤
- /// </summary>
- [Column("ISENABLED")]
- [SugarColumn(ColumnName = "ISENABLED")] //鐢ㄤ簬SqlSugar
- public decimal? Isenabled { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [Column("LASTUPDATE_BY")]
- [SugarColumn(ColumnName = "LASTUPDATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鏈�鍚庢洿鏂颁汉闀垮害涓嶈兘瓒呭嚭32")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [Column("LASTUPDATE_DATE")]
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鏇存柊浜哄鍚�
- /// </summary>
- [Column("LASTUPDATE_NAME")]
- [SugarColumn(ColumnName = "LASTUPDATE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鏇存柊浜哄鍚嶉暱搴︿笉鑳借秴鍑�32")]
- public string LastupdateName { get; set; }
-
- /// <summary>
- /// 澶囨敞淇℃伅
- /// </summary>
- [Column("MEMO")]
- [SugarColumn(ColumnName = "MEMO")] //鐢ㄤ簬SqlSugar
- [StringLength(255, ErrorMessage = "澶囨敞淇℃伅闀垮害涓嶈兘瓒呭嚭255")]
- public string Memo { get; set; }
-
- /// <summary>
- /// 鏍囧噯鍚嶇О
- /// </summary>
- [Column("SAMPLE_SIZE_NAME")]
- [SugarColumn(ColumnName = "SAMPLE_SIZE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鏍囧噯鍚嶇О闀垮害涓嶈兘瓒呭嚭50")]
- public string SampleSizeName { get; set; }
-
- /// <summary>
- /// 鏍囧噯缂栫爜
- /// </summary>
- [Column("SAMPLE_SIZE_NO")]
- [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "鏍囧噯缂栫爜闀垮害涓嶈兘瓒呭嚭50")]
- public string SampleSizeNo { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQmAql2.cs b/StandardPda/MES.Service/Modes/MesQmAql2.cs
deleted file mode 100644
index 3078fc3..0000000
--- a/StandardPda/MES.Service/Modes/MesQmAql2.cs
+++ /dev/null
@@ -1,173 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// AQL鎶芥牱鍩哄噯鏍锋湰閲忓瓙鐮�
-/// </summary>
-[Table("MES_QM_AQL2")]
-[SugarTable("MES_QM_AQL2")] //鐢ㄤ簬SqlSugar
-public class MesQmAql2
-{
- /// <summary>
- /// ID(seq_me_id)
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal Id { get; set; }
-
- /// <summary>
- /// AQL鎶芥牱鍩哄噯ID
- /// </summary>
- [Column("AQL1_ID")]
- [SugarColumn(ColumnName = "AQL1_ID")] //鐢ㄤ簬SqlSugar
- public decimal? Aql1Id { 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(32, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�32")]
- public string CreateBy { get; set; }
-
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 鍒涘缓浜哄鍚�
- /// </summary>
- [Column("CREATE_NAME")]
- [SugarColumn(ColumnName = "CREATE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鍒涘缓浜哄鍚嶉暱搴︿笉鑳借秴鍑�32")]
- public string CreateName { get; set; }
-
- /// <summary>
- /// 淇敼/鏂板鐘舵��
- /// </summary>
- [Column("EDIT_STATUS")]
- [SugarColumn(ColumnName = "EDIT_STATUS")] //鐢ㄤ簬SqlSugar
- public decimal? EditStatus { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FACTORY")]
- [SugarColumn(ColumnName = "FACTORY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Factory闀垮害涓嶈兘瓒呭嚭20")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 涓�鑸楠屾按骞硘I
- /// </summary>
- [Column("FLEVEL_I")]
- [SugarColumn(ColumnName = "FLEVEL_I")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "涓�鑸楠屾按骞硘I闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelI { get; set; }
-
- /// <summary>
- /// 涓�鑸楠屾按骞硘II
- /// </summary>
- [Column("FLEVEL_II")]
- [SugarColumn(ColumnName = "FLEVEL_II")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "涓�鑸楠屾按骞硘II闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelIi { get; set; }
-
- /// <summary>
- /// 涓�鑸楠屾按骞硘III
- /// </summary>
- [Column("FLEVEL_III")]
- [SugarColumn(ColumnName = "FLEVEL_III")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "涓�鑸楠屾按骞硘III闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelIii { get; set; }
-
- /// <summary>
- /// 鐗规畩妫�楠屾按骞硘S-1
- /// </summary>
- [Column("FLEVEL_S1")]
- [SugarColumn(ColumnName = "FLEVEL_S1")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "鐗规畩妫�楠屾按骞硘S-1闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelS1 { get; set; }
-
- /// <summary>
- /// 鐗规畩妫�楠屾按骞硘S-2
- /// </summary>
- [Column("FLEVEL_S2")]
- [SugarColumn(ColumnName = "FLEVEL_S2")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "鐗规畩妫�楠屾按骞硘S-2闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelS2 { get; set; }
-
- /// <summary>
- /// 鐗规畩妫�楠屾按骞硘S-3
- /// </summary>
- [Column("FLEVEL_S3")]
- [SugarColumn(ColumnName = "FLEVEL_S3")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "鐗规畩妫�楠屾按骞硘S-3闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelS3 { get; set; }
-
- /// <summary>
- /// 鐗规畩妫�楠屾按骞硘S-4
- /// </summary>
- [Column("FLEVEL_S4")]
- [SugarColumn(ColumnName = "FLEVEL_S4")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "鐗规畩妫�楠屾按骞硘S-4闀垮害涓嶈兘瓒呭嚭1")]
- public string FlevelS4 { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [Column("LASTUPDATE_BY")]
- [SugarColumn(ColumnName = "LASTUPDATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鏈�鍚庢洿鏂颁汉闀垮害涓嶈兘瓒呭嚭32")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [Column("LASTUPDATE_DATE")]
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鏇存柊浜哄鍚�
- /// </summary>
- [Column("LASTUPDATE_NAME")]
- [SugarColumn(ColumnName = "LASTUPDATE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鏇存柊浜哄鍚嶉暱搴︿笉鑳借秴鍑�32")]
- public string LastupdateName { get; set; }
-
- /// <summary>
- /// 鎵归噺寮�濮�
- /// </summary>
- [Column("LOT_FROM")]
- [SugarColumn(ColumnName = "LOT_FROM")] //鐢ㄤ簬SqlSugar
- public decimal? LotFrom { get; set; }
-
- /// <summary>
- /// 鎵归噺缁撴潫
- /// </summary>
- [Column("LOT_TO")]
- [SugarColumn(ColumnName = "LOT_TO")] //鐢ㄤ簬SqlSugar
- public decimal? LotTo { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [Column("MEMO")]
- [SugarColumn(ColumnName = "MEMO")] //鐢ㄤ簬SqlSugar
- [StringLength(255, ErrorMessage = "澶囨敞闀垮害涓嶈兘瓒呭嚭255")]
- public string Memo { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQmAql3.cs b/StandardPda/MES.Service/Modes/MesQmAql3.cs
deleted file mode 100644
index ae288e3..0000000
--- a/StandardPda/MES.Service/Modes/MesQmAql3.cs
+++ /dev/null
@@ -1,349 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// AQL鎶芥牱鍩哄噯鎶芥牱鏂规
-/// </summary>
-[Table("MES_QM_AQL3")]
-[SugarTable("MES_QM_AQL3")] //鐢ㄤ簬SqlSugar
-public class MesQmAql3
-{
- /// <summary>
- /// ID(seq_me_id)
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal Id { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0
- /// </summary>
- [Column("AQL_0_0")]
- [SugarColumn(ColumnName = "AQL_0_0")] //鐢ㄤ簬SqlSugar
- public decimal? Aql00 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.0010
- /// </summary>
- [Column("AQL_0_00010")]
- [SugarColumn(ColumnName = "AQL_0_00010")] //鐢ㄤ簬SqlSugar
- public decimal? Aql000010 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.010
- /// </summary>
- [Column("AQL_0_0010")]
- [SugarColumn(ColumnName = "AQL_0_0010")] //鐢ㄤ簬SqlSugar
- public decimal? Aql00010 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.015
- /// </summary>
- [Column("AQL_0_0015")]
- [SugarColumn(ColumnName = "AQL_0_0015")] //鐢ㄤ簬SqlSugar
- public decimal? Aql00015 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.025
- /// </summary>
- [Column("AQL_0_0025")]
- [SugarColumn(ColumnName = "AQL_0_0025")] //鐢ㄤ簬SqlSugar
- public decimal? Aql00025 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.040
- /// </summary>
- [Column("AQL_0_0040")]
- [SugarColumn(ColumnName = "AQL_0_0040")] //鐢ㄤ簬SqlSugar
- public decimal? Aql00040 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.065
- /// </summary>
- [Column("AQL_0_0065")]
- [SugarColumn(ColumnName = "AQL_0_0065")] //鐢ㄤ簬SqlSugar
- public decimal? Aql00065 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.10
- /// </summary>
- [Column("AQL_0_010")]
- [SugarColumn(ColumnName = "AQL_0_010")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0010 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.15
- /// </summary>
- [Column("AQL_0_015")]
- [SugarColumn(ColumnName = "AQL_0_015")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0015 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.25
- /// </summary>
- [Column("AQL_0_025")]
- [SugarColumn(ColumnName = "AQL_0_025")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0025 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.40
- /// </summary>
- [Column("AQL_0_040")]
- [SugarColumn(ColumnName = "AQL_0_040")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0040 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩0.65
- /// </summary>
- [Column("AQL_0_065")]
- [SugarColumn(ColumnName = "AQL_0_065")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0065 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1.0
- /// </summary>
- [Column("AQL_0_100")]
- [SugarColumn(ColumnName = "AQL_0_100")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0100 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1.5
- /// </summary>
- [Column("AQL_0_150")]
- [SugarColumn(ColumnName = "AQL_0_150")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0150 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩2.5
- /// </summary>
- [Column("AQL_0_250")]
- [SugarColumn(ColumnName = "AQL_0_250")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0250 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩4.0
- /// </summary>
- [Column("AQL_0_400")]
- [SugarColumn(ColumnName = "AQL_0_400")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0400 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩6.5
- /// </summary>
- [Column("AQL_0_650")]
- [SugarColumn(ColumnName = "AQL_0_650")] //鐢ㄤ簬SqlSugar
- public decimal? Aql0650 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩10
- /// </summary>
- [Column("AQL_1_000")]
- [SugarColumn(ColumnName = "AQL_1_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql1000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩100
- /// </summary>
- [Column("AQL_10_000")]
- [SugarColumn(ColumnName = "AQL_10_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql10000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1000
- /// </summary>
- [Column("AQL_100_000")]
- [SugarColumn(ColumnName = "AQL_100_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql100000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩10000
- /// </summary>
- [Column("AQL_1000_000")]
- [SugarColumn(ColumnName = "AQL_1000_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql1000000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩15
- /// </summary>
- [Column("AQL_1_500")]
- [SugarColumn(ColumnName = "AQL_1_500")] //鐢ㄤ簬SqlSugar
- public decimal? Aql1500 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩150
- /// </summary>
- [Column("AQL_15_000")]
- [SugarColumn(ColumnName = "AQL_15_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql15000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩1500
- /// </summary>
- [Column("AQL_150_000")]
- [SugarColumn(ColumnName = "AQL_150_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql150000 { get; set; }
-
- /// <summary>
- /// AQL鎶芥牱鍩哄噯ID
- /// </summary>
- [Column("AQL1_ID")]
- [SugarColumn(ColumnName = "AQL1_ID")] //鐢ㄤ簬SqlSugar
- public decimal? Aql1Id { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩25
- /// </summary>
- [Column("AQL_2_500")]
- [SugarColumn(ColumnName = "AQL_2_500")] //鐢ㄤ簬SqlSugar
- public decimal? Aql2500 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩250
- /// </summary>
- [Column("AQL_25_000")]
- [SugarColumn(ColumnName = "AQL_25_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql25000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩2500
- /// </summary>
- [Column("AQL_250_000")]
- [SugarColumn(ColumnName = "AQL_250_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql250000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩40
- /// </summary>
- [Column("AQL_4_000")]
- [SugarColumn(ColumnName = "AQL_4_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql4000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩400
- /// </summary>
- [Column("AQL_40_000")]
- [SugarColumn(ColumnName = "AQL_40_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql40000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩4000
- /// </summary>
- [Column("AQL_400_000")]
- [SugarColumn(ColumnName = "AQL_400_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql400000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩65
- /// </summary>
- [Column("AQL_6_500")]
- [SugarColumn(ColumnName = "AQL_6_500")] //鐢ㄤ簬SqlSugar
- public decimal? Aql6500 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩650
- /// </summary>
- [Column("AQL_65_000")]
- [SugarColumn(ColumnName = "AQL_65_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql65000 { get; set; }
-
- /// <summary>
- /// 鎺ユ敹璐ㄩ噺姘村钩6500
- /// </summary>
- [Column("AQL_650_000")]
- [SugarColumn(ColumnName = "AQL_650_000")] //鐢ㄤ簬SqlSugar
- public decimal? Aql650000 { 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(32, ErrorMessage = "鍒涘缓浜洪暱搴︿笉鑳借秴鍑�32")]
- public string CreateBy { get; set; }
-
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 鍒涘缓浜哄鍚�
- /// </summary>
- [Column("CREATE_NAME")]
- [SugarColumn(ColumnName = "CREATE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鍒涘缓浜哄鍚嶉暱搴︿笉鑳借秴鍑�32")]
- public string CreateName { get; set; }
-
- /// <summary>
- /// 淇敼/鏂板鐘舵��
- /// </summary>
- [Column("EDIT_STATUS")]
- [SugarColumn(ColumnName = "EDIT_STATUS")] //鐢ㄤ簬SqlSugar
- public decimal? EditStatus { get; set; }
-
- /// <summary>
- /// </summary>
- [Column("FACTORY")]
- [SugarColumn(ColumnName = "FACTORY")] //鐢ㄤ簬SqlSugar
- [StringLength(20, ErrorMessage = "Factory闀垮害涓嶈兘瓒呭嚭20")]
- public string Factory { get; set; }
-
- /// <summary>
- /// 鏍锋湰澶у皬
- /// </summary>
- [Column("FSAMPLE_SIZE_WORD")]
- [SugarColumn(ColumnName = "FSAMPLE_SIZE_WORD")] //鐢ㄤ簬SqlSugar
- public decimal? FsampleSizeWord { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [Column("LASTUPDATE_BY")]
- [SugarColumn(ColumnName = "LASTUPDATE_BY")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鏈�鍚庢洿鏂颁汉闀垮害涓嶈兘瓒呭嚭32")]
- public string LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [Column("LASTUPDATE_DATE")]
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 鏇存柊浜哄鍚�
- /// </summary>
- [Column("LASTUPDATE_NAME")]
- [SugarColumn(ColumnName = "LASTUPDATE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(32, ErrorMessage = "鏇存柊浜哄鍚嶉暱搴︿笉鑳借秴鍑�32")]
- public string LastupdateName { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [Column("MEMO")]
- [SugarColumn(ColumnName = "MEMO")] //鐢ㄤ簬SqlSugar
- [StringLength(255, ErrorMessage = "澶囨敞闀垮害涓嶈兘瓒呭嚭255")]
- public string Memo { get; set; }
-
- /// <summary>
- /// 鏍锋湰澶у皬瀛楃爜
- /// </summary>
- [Column("SAMPLE_SIZE_WORD")]
- [SugarColumn(ColumnName = "SAMPLE_SIZE_WORD")] //鐢ㄤ簬SqlSugar
- [StringLength(1, ErrorMessage = "鏍锋湰澶у皬瀛楃爜闀垮害涓嶈兘瓒呭嚭1")]
- public string SampleSizeWord { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQsImage.cs b/StandardPda/MES.Service/Modes/MesQsImage.cs
deleted file mode 100644
index 3f627b2..0000000
--- a/StandardPda/MES.Service/Modes/MesQsImage.cs
+++ /dev/null
@@ -1,55 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鍥剧墖淇℃伅
-/// </summary>
-[Table("MES_QS_IMAGE")]
-[SugarTable("MES_QS_IMAGE")] //鐢ㄤ簬SqlSugar
-public class MesQsImage
-{
- /// <summary>
- /// 涓婚敭
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_IMG",
- ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal? Id { get; set; }
-
- /// <summary>
- /// 妫�楠屽崟id
- /// </summary>
- [Column("FID")]
- [SugarColumn(ColumnName = "FID")] //鐢ㄤ簬SqlSugar
- public decimal? Fid { get; set; }
-
- /// <summary>
- /// 闄勪欢鍐呭
- /// </summary>
- [Column("IMAGE_DATA")]
- [SugarColumn(ColumnName = "IMAGE_DATA")] //鐢ㄤ簬SqlSugar
- [StringLength(4000, ErrorMessage = "ImageData闀垮害涓嶈兘瓒呭嚭4000")]
- public byte[]? ImageData { 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("PICTURENAME")]
- [SugarColumn(ColumnName = "PICTURENAME")] //鐢ㄤ簬SqlSugar
- [StringLength(200, ErrorMessage = "Picturename闀垮害涓嶈兘瓒呭嚭200")]
- public string? Picturename { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? base64Date { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQsSuspend.cs b/StandardPda/MES.Service/Modes/MesQsSuspend.cs
deleted file mode 100644
index 23ff075..0000000
--- a/StandardPda/MES.Service/Modes/MesQsSuspend.cs
+++ /dev/null
@@ -1,89 +0,0 @@
-using System.ComponentModel.DataAnnotations;
-using System.ComponentModel.DataAnnotations.Schema;
-using SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// </summary>
-[Table("MES_QS_SUSPEND")]
-[SugarTable("MES_QS_SUSPEND")] //鐢ㄤ簬SqlSugar
-public class MesQsSuspend
-{
- /// <summary>
- /// SEQ_QS_IMG
- /// </summary>
- [Key]
- [Column("ID")]
- [SugarColumn(IsPrimaryKey = true, OracleSequenceName = "SEQ_QS_IMG",
- ColumnName = "ID")] //鐢ㄤ簬SqlSugar
- public decimal? Id { get; set; }
-
- /// <summary>
- /// 閮ㄩ棬鍚嶇О
- /// </summary>
- [Column("DEPT_NAME")]
- [SugarColumn(ColumnName = "DEPT_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "閮ㄩ棬鍚嶇О闀垮害涓嶈兘瓒呭嚭50")]
- public string? DeptName { get; set; }
-
- /// <summary>
- /// 閮ㄩ棬缂栧彿
- /// </summary>
- [Column("DEPT_NO")]
- [SugarColumn(ColumnName = "DEPT_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "閮ㄩ棬缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
- public string? DeptNo { get; set; }
-
- /// <summary>
- /// 鏄惁鍋滄満
- /// </summary>
- [Column("IS_SUSPEND")]
- [SugarColumn(ColumnName = "IS_SUSPEND")] //鐢ㄤ簬SqlSugar
- public decimal? IsSuspend { get; set; }
-
- /// <summary>
- /// 浜х嚎鍚嶇О
- /// </summary>
- [Column("LINE_NAME")]
- [SugarColumn(ColumnName = "LINE_NAME")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "浜х嚎鍚嶇О闀垮害涓嶈兘瓒呭嚭50")]
- public string? LineName { get; set; }
-
- /// <summary>
- /// 浜х嚎缂栧彿
- /// </summary>
- [Column("LINE_NO")]
- [SugarColumn(ColumnName = "LINE_NO")] //鐢ㄤ簬SqlSugar
- [StringLength(50, ErrorMessage = "浜х嚎缂栧彿闀垮害涓嶈兘瓒呭嚭50")]
- public string? LineNo { get; set; }
-
- /// <summary>
- /// 鏆傚仠鏃ユ湡
- /// </summary>
- [Column("CREATE_DATE")]
- [SugarColumn(ColumnName = "CREATE_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 澶囨敞
- /// </summary>
- [Column("REMARKS")]
- [SugarColumn(ColumnName = "REMARKS")] //鐢ㄤ簬SqlSugar
- [StringLength(500, ErrorMessage = "澶囨敞闀垮害涓嶈兘瓒呭嚭500")]
- public string? Remarks { get; set; }
-
- /// <summary>
- /// 寮�鍚椂闂�
- /// </summary>
- [Column("OPEN_DATE")]
- [SugarColumn(ColumnName = "OPEN_DATE")] //鐢ㄤ簬SqlSugar
- public DateTime? OpenDate { get; set; }
-
- /// <summary>
- /// 鏃跺樊闂撮殧(鍒�)
- /// </summary>
- [Column("TIME_DIFFERENCE")]
- [SugarColumn(ColumnName = "TIME_DIFFERENCE")] //鐢ㄤ簬SqlSugar
- public decimal? TimeDifference { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/MesQualityStandard.cs b/StandardPda/MES.Service/Modes/MesQualityStandard.cs
deleted file mode 100644
index bf414fa..0000000
--- a/StandardPda/MES.Service/Modes/MesQualityStandard.cs
+++ /dev/null
@@ -1,204 +0,0 @@
-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
diff --git a/StandardPda/MES.Service/Modes/MesRfPrnbarcode.cs b/StandardPda/MES.Service/Modes/MesRfPrnbarcode.cs
deleted file mode 100644
index 042cb57..0000000
--- a/StandardPda/MES.Service/Modes/MesRfPrnbarcode.cs
+++ /dev/null
@@ -1,154 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鎵嬫寔鏉＄爜鎵撳嵃鏆傚瓨琛�
-/// </summary>
-[SugarTable("MES_RF_PRNBARCODE")]
-public class MesRfPrnbarcode
-{
- /// <summary>
- /// ID
- /// </summary>
- [SugarColumn(ColumnName = "ID")]
- public decimal? Id { get; set; }
-
- /// <summary>
- /// 鎵撳嵃椤哄簭
- /// </summary>
- [SugarColumn(ColumnName = "FORDER")]
- public string? Forder { get; set; }
-
- /// <summary>
- /// 鎵撳嵃浠芥暟
- /// </summary>
- [SugarColumn(ColumnName = "FNO")]
- public string? Fno { get; set; }
-
- /// <summary>
- /// 瀛楁1
- /// </summary>
- [SugarColumn(ColumnName = "STRP1")]
- public string? Strp1 { get; set; }
-
- /// <summary>
- /// 瀛楁2
- /// </summary>
- [SugarColumn(ColumnName = "STRP2")]
- public string? Strp2 { get; set; }
-
- /// <summary>
- /// 瀛楁3
- /// </summary>
- [SugarColumn(ColumnName = "STRP3")]
- public string? Strp3 { get; set; }
-
- /// <summary>
- /// 瀛楁4
- /// </summary>
- [SugarColumn(ColumnName = "STRP4")]
- public string? Strp4 { get; set; }
-
- /// <summary>
- /// 瀛楁5
- /// </summary>
- [SugarColumn(ColumnName = "STRP5")]
- public string? Strp5 { get; set; }
-
- /// <summary>
- /// 瀛楁6
- /// </summary>
- [SugarColumn(ColumnName = "STRP6")]
- public string? Strp6 { get; set; }
-
- /// <summary>
- /// 瀛楁7
- /// </summary>
- [SugarColumn(ColumnName = "STRP7")]
- public string? Strp7 { get; set; }
-
- /// <summary>
- /// 瀛楁8
- /// </summary>
- [SugarColumn(ColumnName = "STRP8")]
- public string? Strp8 { get; set; }
-
- /// <summary>
- /// 瀛楁9
- /// </summary>
- [SugarColumn(ColumnName = "STRP9")]
- public string? Strp9 { get; set; }
-
- /// <summary>
- /// 瀛楁10
- /// </summary>
- [SugarColumn(ColumnName = "STRP10")]
- public string? Strp10 { get; set; }
-
- /// <summary>
- /// 瀛楁11
- /// </summary>
- [SugarColumn(ColumnName = "STRP11")]
- public string? Strp11 { get; set; }
-
- /// <summary>
- /// 瀛楁12
- /// </summary>
- [SugarColumn(ColumnName = "STRP12")]
- public string? Strp12 { get; set; }
-
- /// <summary>
- /// 瀛楁13
- /// </summary>
- [SugarColumn(ColumnName = "STRP13")]
- public string? Strp13 { get; set; }
-
- /// <summary>
- /// 瀛楁14
- /// </summary>
- [SugarColumn(ColumnName = "STRP14")]
- public string? Strp14 { get; set; }
-
- /// <summary>
- /// 瀛楁15
- /// </summary>
- [SugarColumn(ColumnName = "STRP15")]
- public string? Strp15 { get; set; }
-
- /// <summary>
- /// 瀛楁16
- /// </summary>
- [SugarColumn(ColumnName = "STRP16")]
- public string? Strp16 { get; set; }
-
- /// <summary>
- /// 瀛楁17
- /// </summary>
- [SugarColumn(ColumnName = "STRP17")]
- public string? Strp17 { get; set; }
-
- /// <summary>
- /// 瀛楁18
- /// </summary>
- [SugarColumn(ColumnName = "STRP18")]
- public string? Strp18 { get; set; }
-
- /// <summary>
- /// 瀛楁19
- /// </summary>
- [SugarColumn(ColumnName = "STRP19")]
- public string? Strp19 { get; set; }
-
- /// <summary>
- /// 瀛楁20
- /// </summary>
- [SugarColumn(ColumnName = "STRP20")]
- public string? Strp20 { get; set; }
-
- /// <summary>
- /// 鐢熸垚鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
- public DateTime? CreateDate { get; set; }
-}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/Modes/SysDepartment.cs b/StandardPda/MES.Service/Modes/SysDepartment.cs
index 5084a52..223e0e4 100644
--- a/StandardPda/MES.Service/Modes/SysDepartment.cs
+++ b/StandardPda/MES.Service/Modes/SysDepartment.cs
@@ -165,21 +165,5 @@
[SugarColumn(IsIgnore = true)] public string? Type { get; set; }
-
- /// <summary>
- /// 鎺ュ彛瀛楁璋冩暣锛氭柊澧� ERP鏁版嵁鐘舵�併��
- /// </summary>
- /// <remarks>
- /// 淇敼浜猴細
- /// <姹犲崡楠�>
- /// 淇敼鏃ユ湡锛�<2024-12-31>
- /// 淇敼璇存槑锛�
- /// - 鍘熶唬鐮侊細绌�
- /// - 淇敼鍚庯細
- /// </remarks>
- /// <summary>
- /// ERP鏁版嵁鐘舵��
- /// </summary>
- [SugarColumn(ColumnName = "FDOCUMENTSTATUS")]
- public string? FDOCUMENTSTATUS { get; set; }
+
}
\ No newline at end of file
diff --git a/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs b/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs
index 26a0fc9..2c1c9bb 100644
--- a/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs
@@ -2,6 +2,7 @@
using MES.Service.Dto.service;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
+using MES.Service.util;
using SqlSugar;
namespace MES.Service.service.BasicData;
@@ -94,6 +95,7 @@
}
else
{
+ mesId = GetSeqUtil.GetSeq("SEQ_ITEMS_ID");
var entity = new MesLinkU9
{
CreateDate = DateTime.Now,
@@ -102,7 +104,7 @@
OrgId = erpDetail.FUseOrgId,
TableType = "MES_ITEMS"
};
- mesId = Db.Insertable(entity).ExecuteReturnIdentity();
+ Db.Insertable(entity).ExecuteCommand();
}
var items = new MesItems
diff --git a/StandardPda/MES.Service/service/BasicData/MesProjectManager.cs b/StandardPda/MES.Service/service/BasicData/MesProjectManager.cs
index 58bc851..aebb6d5 100644
--- a/StandardPda/MES.Service/service/BasicData/MesProjectManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/MesProjectManager.cs
@@ -1,6 +1,7 @@
锘縰sing MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
+using MES.Service.util;
using SqlSugar;
namespace MES.Service.service.BasicData;
@@ -115,6 +116,8 @@
}
else
{
+ mesId = GetSeqUtil.GetSeq("SEQ_ID");
+
var entity = new MesLinkU9
{
CreateDate = DateTime.Now,
@@ -123,7 +126,8 @@
OrgId = se.FUseOrgId,
TableType = "MES_PROJECT"
};
- mesId = Db.Insertable(entity).ExecuteReturnIdentity();
+ Db.Insertable(entity).ExecuteCommand();
+ // Db.Insertable(entity).ExecuteReturnIdentity();
}
var mesSupplier = new MesProject
diff --git a/StandardPda/MES.Service/service/BasicData/MesSupplierManager.cs b/StandardPda/MES.Service/service/BasicData/MesSupplierManager.cs
index ddfc488..95503d6 100644
--- a/StandardPda/MES.Service/service/BasicData/MesSupplierManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/MesSupplierManager.cs
@@ -1,6 +1,7 @@
锘縰sing MES.Service.DB;
using MES.Service.Dto.webApi;
using MES.Service.Modes;
+using MES.Service.util;
using SqlSugar;
namespace MES.Service.service.BasicData;
@@ -118,6 +119,7 @@
}
else
{
+ mesId = GetSeqUtil.GetSeq("SEQ_BASEINFO_ID");
var entity = new MesLinkU9
{
CreateDate = DateTime.Now,
@@ -126,7 +128,7 @@
OrgId = se.FUseOrgId,
TableType = "MES_SUPPLIER"
};
- mesId = Db.Insertable(entity).ExecuteReturnIdentity();
+ Db.Insertable(entity).ExecuteCommand();
}
var mesSupplier = new MesSupplier
diff --git a/StandardPda/MES.Service/service/BasicData/SysDepartmentManager.cs b/StandardPda/MES.Service/service/BasicData/SysDepartmentManager.cs
index c8bc92c..3219bff 100644
--- a/StandardPda/MES.Service/service/BasicData/SysDepartmentManager.cs
+++ b/StandardPda/MES.Service/service/BasicData/SysDepartmentManager.cs
@@ -113,7 +113,6 @@
CreateOrg = Convert.ToDecimal(department.FCreateOrgId),
UseOrg = Convert.ToDecimal(department.FUseOrgId),
ParentId = department.FParentID,
- FDOCUMENTSTATUS = department.FDocumentStatus,
Company = "1000",
Factory = "1000"
};
diff --git a/StandardPda/MESApplication/Controllers/BasicData/EmployeeInfoController.cs b/StandardPda/MESApplication/Controllers/BasicData/EmployeeInfoController.cs
index 1d80bb4..fe68a86 100644
--- a/StandardPda/MESApplication/Controllers/BasicData/EmployeeInfoController.cs
+++ b/StandardPda/MESApplication/Controllers/BasicData/EmployeeInfoController.cs
@@ -25,7 +25,7 @@
private readonly string METHOD = "POST";
- private readonly string TableName = "MES_ITEMS";
+ private readonly string TableName = "Employee_Info";
private readonly string
URL = "http://localhost:10054/api/EmployeeInfo/";
--
Gitblit v1.9.3