From 372d77eb2d8932a58da206965b30d9aca72fe15b Mon Sep 17 00:00:00 2001 From: 啊鑫 <t2856754968@163.com> Date: 星期四, 15 八月 2024 10:05:00 +0800 Subject: [PATCH] aa --- MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs | 79 + MES.Service/service/BasicData/MesStaffManager.cs | 2 MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs | 163 ++ MES.Service/service/Warehouse/MesInvItemMovesManager.cs | 45 MES.Service/Modes/MesInvItemBarcodes.cs | 600 ++++---- MES.Service/Modes/MesInvItemInCItems.cs | 184 +- MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs | 204 ++ MES.Service/Modes/Purdhb.cs | 352 ++-- MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs | 97 MES.Service/Modes/MesInvItemArn.cs | 304 ++-- MES.Service/service/Warehouse/MesInvBusiness2Manager.cs | 94 MES.Service/service/Warehouse/OpeningReceiptServer.cs | 37 MES.Service/service/Warehouse/MesDepotSectionsManager.cs | 45 MES.Service/Modes/Purdka.cs | 160 +- MES.Service/Modes/MesInvItemMovesCDetails.cs | 231 +++ MESApplication/Controllers/Warehouse/OpeningReceiptController.cs | 2 MES.Service/Modes/MesInvItemMoves.cs | 178 ++ MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs | 10 MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs | 308 ++-- MES.Service/Modes/MesQaItemsDetect01.cs | 422 ++-- MES.Service/Modes/MesInvBusiness2.cs | 419 +++-- MES.Service/Modes/MesInvItemStocks.cs | 2 MES.Service/Modes/MesQaItemsDetectDetail5.cs | 326 ++-- MES.Service/Modes/MesInvItemInCDetails.cs | 3 MES.Service/Dto/service/InventoryItem.cs | 8 MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs | 42 MES.Service/Dto/service/WarehouseQuery.cs | 4 27 files changed, 2,661 insertions(+), 1,660 deletions(-) diff --git a/MES.Service/Dto/service/InventoryItem.cs b/MES.Service/Dto/service/InventoryItem.cs index ca5767f..2d4a948 100644 --- a/MES.Service/Dto/service/InventoryItem.cs +++ b/MES.Service/Dto/service/InventoryItem.cs @@ -16,4 +16,12 @@ [SugarColumn(ColumnName = "QTY")] public decimal Qty { get; set; } // 浣跨敤 decimal 鏉ヨ〃绀烘暟閲� + + [SugarColumn(ColumnName = "sections_code")] + public string SectionsCode { get; set; } + + [SugarColumn(ColumnName = "erp_item_no")] + public string ErpItemNo { get; set; } + + [SugarColumn(ColumnName = "flist")] public string Flist { get; set; } } \ No newline at end of file diff --git a/MES.Service/Dto/service/WarehouseQuery.cs b/MES.Service/Dto/service/WarehouseQuery.cs index ea3e707..b3f0734 100644 --- a/MES.Service/Dto/service/WarehouseQuery.cs +++ b/MES.Service/Dto/service/WarehouseQuery.cs @@ -19,4 +19,8 @@ public string? Type { get; set; } public string? DepotCode { get; set; } public string? SuppNo { get; set; } + + public string Factory { get; set; } + + public string Company { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvBusiness2.cs b/MES.Service/Modes/MesInvBusiness2.cs index 82f13d9..89ddce5 100644 --- a/MES.Service/Modes/MesInvBusiness2.cs +++ b/MES.Service/Modes/MesInvBusiness2.cs @@ -1,194 +1,227 @@ -锘縰sing System; -using System.Collections.Generic; -using System.Linq; -using SqlSugar; -namespace MES.Service.Modes +锘縰sing SqlSugar; + +namespace MES.Service.Modes; + +/// <summary> +/// 搴撳瓨浜ゆ槗璁板綍琛� +/// </summary> +[SugarTable("MES_INV_BUSINESS2")] +public class MesInvBusiness2 { - /// <summary> - /// 搴撳瓨浜ゆ槗璁板綍琛� - ///</summary> - [SugarTable("MES_INV_BUSINESS2")] - public class MesInvBusiness2 - { - /// <summary> - /// ID(seq_inv_id) - ///</summary> - [SugarColumn(ColumnName="ID",OracleSequenceName = "SEQ_ID",IsPrimaryKey = true )] - public decimal Id { get; set; } - /// <summary> - /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄� - ///</summary> - [SugarColumn(ColumnName="STATUS" )] - public decimal? Status { get; set; } - /// <summary> - /// 鍗曟嵁绫诲瀷ID - ///</summary> - [SugarColumn(ColumnName="BILL_TYPE_ID" )] - public decimal? BillTypeId { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷缂栫爜 - ///</summary> - [SugarColumn(ColumnName="TRANSACTION_CODE" )] - public string TransactionCode { get; set; } - /// <summary> - /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱 - ///</summary> - [SugarColumn(ColumnName="BUSINESS_TYPE" )] - public decimal? BusinessType { get; set; } - /// <summary> - /// 鍗曟嵁ID - ///</summary> - [SugarColumn(ColumnName="BILL_ID" )] - public decimal? BillId { get; set; } - /// <summary> - /// 鍗曟嵁缂栫爜 - ///</summary> - [SugarColumn(ColumnName="BILL_NO" )] - public string BillNo { get; set; } - /// <summary> - /// 鐢熶骇璁㈠崟鍙� - ///</summary> - [SugarColumn(ColumnName="TASK_NO" )] - public string TaskNo { get; set; } - /// <summary> - /// 瀹㈡埛缂栧彿 - ///</summary> - [SugarColumn(ColumnName="CUSTOMER_NO" )] - public string CustomerNo { get; set; } - /// <summary> - /// 鍗曟嵁琛孖D - ///</summary> - [SugarColumn(ColumnName="BILL_LINE_ID" )] - public decimal? BillLineId { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜 - ///</summary> - [SugarColumn(ColumnName="ITEM_BARCODE" )] - public string ItemBarcode { get; set; } - /// <summary> - /// 鏈徃鐗╂枡缂栫爜 - ///</summary> - [SugarColumn(ColumnName="ITEM_NO" )] - public string ItemNo { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡缂栫爜 - ///</summary> - [SugarColumn(ColumnName="C_ITEM_CODE" )] - public string CItemCode { get; set; } - /// <summary> - /// 鍘傚鎵规 - ///</summary> - [SugarColumn(ColumnName="LOT_NO" )] - public string LotNo { get; set; } - /// <summary> - /// 鏄惁鐜繚(0:鍚�,1:鏄�) - ///</summary> - [SugarColumn(ColumnName="EP_FLAG" )] - public short? EpFlag { get; set; } - /// <summary> - /// 鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="QUANTITY" )] - public decimal? Quantity { get; set; } - /// <summary> - /// 婧愬瓙搴揅ODE - ///</summary> - [SugarColumn(ColumnName="FROM_INV_DEPOTS_CODE" )] - public string FromInvDepotsCode { get; set; } - /// <summary> - /// 婧愯揣浣岰ODE - ///</summary> - [SugarColumn(ColumnName="FROM_INV_DEPOT_SECTIONS_CODE" )] - public string FromInvDepotSectionsCode { get; set; } - /// <summary> - /// 鐩殑瀛愬簱CODE - ///</summary> - [SugarColumn(ColumnName="TO_INV_DEPOTS_CODE" )] - public string ToInvDepotsCode { get; set; } - /// <summary> - /// 鐩殑璐т綅CODE - ///</summary> - [SugarColumn(ColumnName="TO_INV_DEPOT_SECTIONS_CODE" )] - public string ToInvDepotSectionsCode { get; set; } - /// <summary> - /// 浜ゆ槗寮傚父淇℃伅 - ///</summary> - [SugarColumn(ColumnName="DESCRIPTION" )] - public string Description { 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="ULLAGE_STAT_FLAG" )] - public short? UllageStatFlag { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - ///</summary> - [SugarColumn(ColumnName="FACTORY" )] - public string Factory { get; set; } - /// <summary> - /// 鍏徃浠g爜 - ///</summary> - [SugarColumn(ColumnName="COMPANY" )] - public string Company { 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="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> - /// 閲囪喘璁㈠崟id - ///</summary> - [SugarColumn(ColumnName="EBELN_K3ID" )] - public decimal? EbelnK3id { get; set; } - /// <summary> - /// 閲囪喘璁㈠崟琛宨d - ///</summary> - [SugarColumn(ColumnName="LINE_K3ID" )] - public decimal? LineK3id { get; set; } - } -} + /// <summary> + /// ID(seq_inv_id) + /// </summary> + [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ID", + IsPrimaryKey = true)] + public decimal Id { get; set; } + + /// <summary> + /// 鐘舵�亅0-鏈氦鏄�1-宸蹭氦鏄� + /// </summary> + [SugarColumn(ColumnName = "STATUS")] + public decimal? Status { get; set; } + + /// <summary> + /// 鍗曟嵁绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "BILL_TYPE_ID")] + public decimal? BillTypeId { get; set; } + + /// <summary> + /// 浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_CODE")] + public string TransactionCode { get; set; } + + /// <summary> + /// 浜ゆ槗绫诲瀷|1-鍏ュ簱0-杞簱-1鍑哄簱 + /// </summary> + [SugarColumn(ColumnName = "BUSINESS_TYPE")] + public decimal? BusinessType { get; set; } + + /// <summary> + /// 鍗曟嵁ID + /// </summary> + [SugarColumn(ColumnName = "BILL_ID")] + public decimal? BillId { get; set; } + + /// <summary> + /// 鍗曟嵁缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] + public string BillNo { get; set; } + + /// <summary> + /// 鐢熶骇璁㈠崟鍙� + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] + public string TaskNo { get; set; } + + /// <summary> + /// 瀹㈡埛缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "CUSTOMER_NO")] + public string CustomerNo { get; set; } + + /// <summary> + /// 鍗曟嵁琛孖D + /// </summary> + [SugarColumn(ColumnName = "BILL_LINE_ID")] + public decimal? BillLineId { get; set; } + + /// <summary> + /// 鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE")] + public string ItemBarcode { get; set; } + + /// <summary> + /// 鏈徃鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] + public string ItemNo { get; set; } + + /// <summary> + /// 瀹㈡埛鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "C_ITEM_CODE")] + public string CItemCode { get; set; } + + /// <summary> + /// 鍘傚鎵规 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] + public string LotNo { get; set; } + + /// <summary> + /// 鏄惁鐜繚(0:鍚�,1:鏄�) + /// </summary> + [SugarColumn(ColumnName = "EP_FLAG")] + public short? EpFlag { get; set; } + + /// <summary> + /// 鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] + public decimal? Quantity { get; set; } + + /// <summary> + /// 婧愬瓙搴揅ODE + /// </summary> + [SugarColumn(ColumnName = "FROM_INV_DEPOTS_CODE")] + public string FromInvDepotsCode { get; set; } + + /// <summary> + /// 婧愯揣浣岰ODE + /// </summary> + [SugarColumn(ColumnName = "FROM_INV_DEPOT_SECTIONS_CODE")] + public string FromInvDepotSectionsCode { get; set; } + + /// <summary> + /// 鐩殑瀛愬簱CODE + /// </summary> + [SugarColumn(ColumnName = "TO_INV_DEPOTS_CODE")] + public string ToInvDepotsCode { get; set; } + + /// <summary> + /// 鐩殑璐т綅CODE + /// </summary> + [SugarColumn(ColumnName = "TO_INV_DEPOT_SECTIONS_CODE")] + public string ToInvDepotSectionsCode { get; set; } + + /// <summary> + /// 浜ゆ槗寮傚父淇℃伅 + /// </summary> + [SugarColumn(ColumnName = "DESCRIPTION")] + public string Description { 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 = "ULLAGE_STAT_FLAG")] + public short? UllageStatFlag { get; set; } + + /// <summary> + /// 鍒嗗巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] + public string Factory { get; set; } + + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] + public string Company { 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 = "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> + /// 閲囪喘璁㈠崟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/MES.Service/Modes/MesInvItemArn.cs b/MES.Service/Modes/MesInvItemArn.cs index bf0d207..518f09f 100644 --- a/MES.Service/Modes/MesInvItemArn.cs +++ b/MES.Service/Modes/MesInvItemArn.cs @@ -8,232 +8,232 @@ [SugarTable("MES_INV_ITEM_ARN")] public class MesInvItemArn { - /// <summary> - /// ID(SEQ_INV_ID) - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// ID(SEQ_INV_ID) + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴 - /// </summary> - [SugarColumn(ColumnName = "STATUS")] + /// <summary> + /// 鐘舵�亅0-鏈鏍�1-瀹℃牳鍏ュ簱\缁撴 + /// </summary> + [SugarColumn(ColumnName = "STATUS")] public short? Status { get; set; } - /// <summary> - /// 鍘熷洜 - /// </summary> - [SugarColumn(ColumnName = "REASON")] + /// <summary> + /// 鍘熷洜 + /// </summary> + [SugarColumn(ColumnName = "REASON")] public string Reason { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鍗曟嵁绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "BILL_TYPE_ID")] + /// <summary> + /// 鍗曟嵁绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "BILL_TYPE_ID")] public decimal? BillTypeId { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷ID - /// </summary> - [SugarColumn(ColumnName = "TRANSACTION_ID")] + /// <summary> + /// 浜嬪姟绫诲瀷ID + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_ID")] public decimal? TransactionId { get; set; } - /// <summary> - /// 澶囨敞 - /// </summary> - [SugarColumn(ColumnName = "REMARK")] + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } - /// <summary> - /// 閫佽揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "PAPER_BILL_NO")] + /// <summary> + /// 閫佽揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "PAPER_BILL_NO")] public string PaperBillNo { get; set; } - /// <summary> - /// 閫�鏂欎汉宸ュ彿 - /// </summary> - [SugarColumn(ColumnName = "USER_NO_BACK")] + /// <summary> + /// 閫�鏂欎汉宸ュ彿 + /// </summary> + [SugarColumn(ColumnName = "USER_NO_BACK")] public string UserNoBack { get; set; } - /// <summary> - /// 鎻愪氦浜� - /// </summary> - [SugarColumn(ColumnName = "CHECK_USER")] + /// <summary> + /// 鎻愪氦浜� + /// </summary> + [SugarColumn(ColumnName = "CHECK_USER")] public string CheckUser { get; set; } - /// <summary> - /// 鎻愪氦鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CHECK_DATE")] + /// <summary> + /// 鎻愪氦鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CHECK_DATE")] public DateTime? CheckDate { get; set; } - /// <summary> - /// 鍏ュ簱鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INS_DATE")] + /// <summary> + /// 鍏ュ簱鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "CHECK_RES")] + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "CHECK_RES")] public string CheckRes { get; set; } - /// <summary> - /// 宸叉崱鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QTY")] + /// <summary> + /// 宸叉崱鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QTY")] public decimal? CheckQty { get; set; } - /// <summary> - /// 浠撳簱缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOTS_CODE")] + /// <summary> + /// 浠撳簱缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DEPOTS_CODE")] public string DepotsCode { get; set; } - /// <summary> - /// 浜嬪姟绫诲瀷缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "TRANSCTION_NO")] + /// <summary> + /// 浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "TRANSCTION_NO")] public string TransctionNo { get; set; } - /// <summary> - /// 渚涘簲鍟嗙紪鐮� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟嗙紪鐮� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// 鎻愪氦鐘舵�� - /// </summary> - [SugarColumn(ColumnName = "FSTATUS")] + /// <summary> + /// 鎻愪氦鐘舵�� + /// </summary> + [SugarColumn(ColumnName = "FSTATUS")] public short? Fstatus { get; set; } - /// <summary> - /// 宸ュ巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 宸ュ巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鏄惁宸插洖鍐橲AP - /// </summary> - [SugarColumn(ColumnName = "SAPSTATUS")] + /// <summary> + /// 鏄惁宸插洖鍐橲AP + /// </summary> + [SugarColumn(ColumnName = "SAPSTATUS")] public short? Sapstatus { get; set; } - /// <summary> - /// 纭鍏ュ簱鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INS_DATE")] + /// <summary> + /// 纭鍏ュ簱鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INS_DATE")] public DateTime? Insdate { get; set; } - /// <summary> - /// 鏄惁妫�楠� - /// </summary> - [SugarColumn(ColumnName = "ISCHECK")] + /// <summary> + /// 鏄惁妫�楠� + /// </summary> + [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } - /// <summary> - /// 瀹℃牳鍏ュ簱浜� - /// </summary> - [SugarColumn(ColumnName = "INSBY")] + /// <summary> + /// 瀹℃牳鍏ュ簱浜� + /// </summary> + [SugarColumn(ColumnName = "INSBY")] public string Insby { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 鎬ユ枡鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "URGENT_FLAG")] + /// <summary> + /// 鎬ユ枡鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } - /// <summary> - /// 鍐查攢浜嬪姟绫诲瀷缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "MTTRANSCTION_NO")] + /// <summary> + /// 鍐查攢浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "MTTRANSCTION_NO")] public decimal? MttransctionNo { get; set; } - /// <summary> - /// IQC妫�楠屽崟鍙� - /// </summary> - [SugarColumn(ColumnName = "IQC_RELEASE_NO")] + /// <summary> + /// IQC妫�楠屽崟鍙� + /// </summary> + [SugarColumn(ColumnName = "IQC_RELEASE_NO")] public string IqcReleaseNo { get; set; } - /// <summary> - /// 鏄惁鏄剧ず - /// </summary> - [SugarColumn(ColumnName = "IS_VISUAL")] + /// <summary> + /// 鏄惁鏄剧ず + /// </summary> + [SugarColumn(ColumnName = "IS_VISUAL")] public decimal? IsVisual { get; set; } - /// <summary> - /// 0=閲囪喘锛�1=濮斿 - /// </summary> - [SugarColumn(ColumnName = "F_TYPE")] + /// <summary> + /// 0=閲囪喘锛�1=濮斿 + /// </summary> + [SugarColumn(ColumnName = "F_TYPE")] public decimal? FType { get; set; } - /// <summary> - /// ERP鍒拌揣鍗旾D - /// </summary> - [SugarColumn(ColumnName = "EBELN_K3ID")] + /// <summary> + /// ERP鍒拌揣鍗旾D + /// </summary> + [SugarColumn(ColumnName = "EBELN_K3ID")] public string EbelnK3id { get; set; } - /// <summary> - /// 鏉$爜鏉″嵃杩涘害 - /// </summary> - [SugarColumn(ColumnName = "BARCODE_RATIO")] + /// <summary> + /// 鏉$爜鏉″嵃杩涘害 + /// </summary> + [SugarColumn(ColumnName = "BARCODE_RATIO")] public decimal? BarcodeRatio { get; set; } - /// <summary> - /// ERP鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "ERPNO")] + /// <summary> + /// ERP鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "ERPNO")] public string Erpno { get; set; } - /// <summary> - /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐� - /// </summary> - [SugarColumn(ColumnName = "THSTATUS")] + /// <summary> + /// 鏄惁宸查��璐�0-鏈��璐э紝1-閫�璐� + /// </summary> + [SugarColumn(ColumnName = "THSTATUS")] public short? Thstatus { get; set; } - /// <summary> - /// ERP閫�璐у崟鍙� - /// </summary> - [SugarColumn(ColumnName = "ERPTHNO")] + /// <summary> + /// ERP閫�璐у崟鍙� + /// </summary> + [SugarColumn(ColumnName = "ERPTHNO")] public string Erpthno { get; set; } diff --git a/MES.Service/Modes/MesInvItemBarcodes.cs b/MES.Service/Modes/MesInvItemBarcodes.cs index 0e5e2c0..078ac04 100644 --- a/MES.Service/Modes/MesInvItemBarcodes.cs +++ b/MES.Service/Modes/MesInvItemBarcodes.cs @@ -8,453 +8,453 @@ [SugarTable("MES_INV_ITEM_BARCODES")] public class MesInvItemBarcodes { - /// <summary> - /// SEQ_BARCODE_PSN_ID - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// SEQ_BARCODE_PSN_ID + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE")] + /// <summary> + /// 鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE")] public string ItemBarcode { get; set; } - /// <summary> - /// 瀹㈡埛鎴愬搧缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "C_PRODUCT_CODE")] + /// <summary> + /// 瀹㈡埛鎴愬搧缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "C_PRODUCT_CODE")] public string CProductCode { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_BARCODE")] + /// <summary> + /// 瀹㈡埛鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "C_ITEM_BARCODE")] public string CItemBarcode { get; set; } - /// <summary> - /// 瀹㈡埛鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "C_ITEM_CODE")] + /// <summary> + /// 瀹㈡埛鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "C_ITEM_CODE")] public string CItemCode { get; set; } - /// <summary> - /// 鏈徃鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鏈徃鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 鍘傚鎵规 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] + /// <summary> + /// 鍘傚鎵规 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } - /// <summary> - /// 鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] + /// <summary> + /// 鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } - /// <summary> - /// 鏄惁鐜繚(0:鍚�,1:鏄�) - /// </summary> - [SugarColumn(ColumnName = "EP_FLAG")] + /// <summary> + /// 鏄惁鐜繚(0:鍚�,1:鏄�) + /// </summary> + [SugarColumn(ColumnName = "EP_FLAG")] public short? EpFlag { get; set; } - /// <summary> - /// 鐢熶骇宸ュ崟 - /// </summary> - [SugarColumn(ColumnName = "TASK_NO")] + /// <summary> + /// 鐢熶骇宸ュ崟 + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 瀹㈡埛缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "CUST_NO")] + /// <summary> + /// 瀹㈡埛缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "CUST_NO")] public string CustNo { get; set; } - /// <summary> - /// 鐗╂枡鏉$爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙ - /// </summary> - [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] + /// <summary> + /// 鐗╂枡鏉$爜娉ㄩ噴琛孾鍐椾綑锛屾潯鐮侀噸鎵撲娇鐢╙ + /// </summary> + [SugarColumn(ColumnName = "ITEM_BARCODE_TEXT")] public string ItemBarcodeText { get; set; } - /// <summary> - /// 鍘烶SN鐗╂枡鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] + /// <summary> + /// 鍘烶SN鐗╂枡鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "OLD_ITEM_BARCODE")] public string OldItemBarcode { get; set; } - /// <summary> - /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "MBLNR")] + /// <summary> + /// SAP鏀惰揣鐗╂枡鍑瘉鍙� --閲囪喘鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "MBLNR")] public string Mblnr { get; set; } - /// <summary> - /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "ZEILE")] + /// <summary> + /// SAP鏀惰揣鐗╂枡鍑瘉琛屽彿 --閲囪喘鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "ZEILE")] public decimal? Zeile { get; set; } - /// <summary> - /// 鏀舵枡琛↖D - /// </summary> - [SugarColumn(ColumnName = "ROH_IN_ID")] + /// <summary> + /// 鏀舵枡琛↖D + /// </summary> + [SugarColumn(ColumnName = "ROH_IN_ID")] public decimal? RohInId { get; set; } - /// <summary> - /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮� - /// </summary> - [SugarColumn(ColumnName = "BARCODESTATUS")] + /// <summary> + /// 0涓烘湁鏁堟潯鐮侊紱1涓烘棤鏁堟潯鐮� + /// </summary> + [SugarColumn(ColumnName = "BARCODESTATUS")] public short? Barcodestatus { get; set; } - /// <summary> - /// 鍘熷鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "OLDQTY")] + /// <summary> + /// 鍘熷鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "OLDQTY")] public decimal? Oldqty { get; set; } - /// <summary> - /// 浣跨敤鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "USEQTY")] + /// <summary> + /// 浣跨敤鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "USEQTY")] public decimal? Useqty { get; set; } - /// <summary> - /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾 - /// </summary> - [SugarColumn(ColumnName = "LOCATION")] + /// <summary> + /// 0鍦ㄥ簱锛�1鍦ㄧ嚎锛�2浣滃簾 + /// </summary> + [SugarColumn(ColumnName = "LOCATION")] public short? Location { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } - /// <summary> - /// 閲嶉噺锛堝崟浣嶏細鍏枻锛� - /// </summary> - [SugarColumn(ColumnName = "WEIGHT_UNIT")] + /// <summary> + /// 閲嶉噺锛堝崟浣嶏細鍏枻锛� + /// </summary> + [SugarColumn(ColumnName = "WEIGHT_UNIT")] public decimal? WeightUnit { get; set; } - /// <summary> - /// 鍗曚环 - /// </summary> - [SugarColumn(ColumnName = "PRICE")] + /// <summary> + /// 鍗曚环 + /// </summary> + [SugarColumn(ColumnName = "PRICE")] public decimal? Price { get; set; } - /// <summary> - /// 鍘熸潯鐮佹暟閲� - /// </summary> - [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] + /// <summary> + /// 鍘熸潯鐮佹暟閲� + /// </summary> + [SugarColumn(ColumnName = "OLD_BAR_QUANTITY")] public decimal? OldBarQuantity { get; set; } - /// <summary> - /// 姹囨�绘潯鐮� - /// </summary> - [SugarColumn(ColumnName = "SUM_BARCODE")] + /// <summary> + /// 姹囨�绘潯鐮� + /// </summary> + [SugarColumn(ColumnName = "SUM_BARCODE")] public string SumBarcode { get; set; } - /// <summary> - /// 鐢熶骇鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "LOT_DATE")] + /// <summary> + /// 鐢熶骇鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "LOT_DATE")] public string LotDate { get; set; } - /// <summary> - /// 妯″彿 - /// </summary> - [SugarColumn(ColumnName = "MOCODE")] + /// <summary> + /// 妯″彿 + /// </summary> + [SugarColumn(ColumnName = "MOCODE")] public string Mocode { get; set; } - /// <summary> - /// 鏉ユ簮 - /// </summary> - [SugarColumn(ColumnName = "MEMO")] + /// <summary> + /// 鏉ユ簮 + /// </summary> + [SugarColumn(ColumnName = "MEMO")] public string Memo { get; set; } - /// <summary> - /// 渚涘簲鍟嗙紪鐮� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟嗙紪鐮� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// 妗d綅浣庡�� - /// </summary> - [SugarColumn(ColumnName = "SPOSTION")] + /// <summary> + /// 妗d綅浣庡�� + /// </summary> + [SugarColumn(ColumnName = "SPOSTION")] public string Spostion { get; set; } - /// <summary> - /// 妗d綅楂樺�� - /// </summary> - [SugarColumn(ColumnName = "EPOSTION")] + /// <summary> + /// 妗d綅楂樺�� + /// </summary> + [SugarColumn(ColumnName = "EPOSTION")] public string Epostion { get; set; } - /// <summary> - /// 鐗╂枡绠�绉� - /// </summary> - [SugarColumn(ColumnName = "ITEM_SNAME")] + /// <summary> + /// 鐗╂枡绠�绉� + /// </summary> + [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } - /// <summary> - /// 鏄惁宸插喕缁�,1鍐荤粨 - /// </summary> - [SugarColumn(ColumnName = "VISABLE")] + /// <summary> + /// 鏄惁宸插喕缁�,1鍐荤粨 + /// </summary> + [SugarColumn(ColumnName = "VISABLE")] public short? Visable { get; set; } - /// <summary> - /// 渚涘簲鍟嗘壒娆� - /// </summary> - [SugarColumn(ColumnName = "TR_LOTNO")] + /// <summary> + /// 渚涘簲鍟嗘壒娆� + /// </summary> + [SugarColumn(ColumnName = "TR_LOTNO")] public string TrLotno { get; set; } - /// <summary> - /// 鍐荤粨鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "FLEZZ_DATE")] + /// <summary> + /// 鍐荤粨鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "FLEZZ_DATE")] public DateTime? FlezzDate { get; set; } - /// <summary> - /// 鍐荤粨鍘熷洜 - /// </summary> - [SugarColumn(ColumnName = "FLEZZ_REASON")] + /// <summary> + /// 鍐荤粨鍘熷洜 + /// </summary> + [SugarColumn(ColumnName = "FLEZZ_REASON")] public string FlezzReason { get; set; } - /// <summary> - /// 鍐荤粨浜� - /// </summary> - [SugarColumn(ColumnName = "FLEZZ_BY")] + /// <summary> + /// 鍐荤粨浜� + /// </summary> + [SugarColumn(ColumnName = "FLEZZ_BY")] public string FlezzBy { get; set; } - /// <summary> - /// 寤堕暱淇濊川鏈� - /// </summary> - [SugarColumn(ColumnName = "DELANY_MONTH")] + /// <summary> + /// 寤堕暱淇濊川鏈� + /// </summary> + [SugarColumn(ColumnName = "DELANY_MONTH")] public decimal? DelanyMonth { get; set; } - /// <summary> - /// 鏈�灏忓寘瑁呮爣璇� - /// </summary> - [SugarColumn(ColumnName = "MINPACK_FLAG")] + /// <summary> + /// 鏈�灏忓寘瑁呮爣璇� + /// </summary> + [SugarColumn(ColumnName = "MINPACK_FLAG")] public short? MinpackFlag { get; set; } - /// <summary> - /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁� - /// </summary> - [SugarColumn(ColumnName = "PRINT_ID")] + /// <summary> + /// 鎵撳嵃ID锛岀敤鏉ュ尯鍒嗘墦鍗版鏁� + /// </summary> + [SugarColumn(ColumnName = "PRINT_ID")] public string PrintId { get; set; } - /// <summary> - /// 鐜繚椤圭洰 - /// </summary> - [SugarColumn(ColumnName = "EP_ITEM")] + /// <summary> + /// 鐜繚椤圭洰 + /// </summary> + [SugarColumn(ColumnName = "EP_ITEM")] public string EpItem { get; set; } - /// <summary> - /// 宸ュ巶缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 宸ュ巶缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鍏徃缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 鍗℃澘缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "CB_NO")] + /// <summary> + /// 鍗℃澘缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "CB_NO")] public string CbNo { get; set; } - /// <summary> - /// 鍘傚鐢熶骇绾� - /// </summary> - [SugarColumn(ColumnName = "LINFLINE")] + /// <summary> + /// 鍘傚鐢熶骇绾� + /// </summary> + [SugarColumn(ColumnName = "LINFLINE")] public string Linfline { get; set; } - /// <summary> - /// 鏈夋晥鏈� - /// </summary> - [SugarColumn(ColumnName = "VALID_TIME")] + /// <summary> + /// 鏈夋晥鏈� + /// </summary> + [SugarColumn(ColumnName = "VALID_TIME")] public DateTime? ValidTime { get; set; } - /// <summary> - /// 璐ㄦ缁撴灉 - /// </summary> - [SugarColumn(ColumnName = "IQC_STATUS")] + /// <summary> + /// 璐ㄦ缁撴灉 + /// </summary> + [SugarColumn(ColumnName = "IQC_STATUS")] public string IqcStatus { get; set; } - /// <summary> - /// 灏忚溅鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "FCAR")] + /// <summary> + /// 灏忚溅鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "FCAR")] public string Fcar { get; set; } - /// <summary> - /// 姣涢噸 - /// </summary> - [SugarColumn(ColumnName = "GWEIGHT")] + /// <summary> + /// 姣涢噸 + /// </summary> + [SugarColumn(ColumnName = "GWEIGHT")] public string Gweight { get; set; } - /// <summary> - /// 鍑�閲� - /// </summary> - [SugarColumn(ColumnName = "NWEIGHT")] + /// <summary> + /// 鍑�閲� + /// </summary> + [SugarColumn(ColumnName = "NWEIGHT")] public string Nweight { get; set; } - /// <summary> - /// 淇濊川鏈� - /// </summary> - [SugarColumn(ColumnName = "EXT_DATE")] + /// <summary> + /// 淇濊川鏈� + /// </summary> + [SugarColumn(ColumnName = "EXT_DATE")] public decimal? ExtDate { get; set; } - /// <summary> - /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶� - /// </summary> - [SugarColumn(ColumnName = "BARCODETYPE")] + /// <summary> + /// 渚涘簲鍟嗐�佽禒鍝併�佸渚涙枡銆佸澶� + /// </summary> + [SugarColumn(ColumnName = "BARCODETYPE")] public string Barcodetype { get; set; } - /// <summary> - /// 渚涘簲鍟嗗悕绉� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NAME")] + /// <summary> + /// 渚涘簲鍟嗗悕绉� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NAME")] public string SuppName { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍒拌揣鍗曞彿/鍏ュ簱鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鎬ユ枡鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "URGENT_FLAG")] + /// <summary> + /// 鎬ユ枡鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "URGENT_FLAG")] public short? UrgentFlag { get; set; } - /// <summary> - /// 棰滆壊 - /// </summary> - [SugarColumn(ColumnName = "COLOR_NAME")] + /// <summary> + /// 棰滆壊 + /// </summary> + [SugarColumn(ColumnName = "COLOR_NAME")] public string ColorName { get; set; } - /// <summary> - /// 浜у搧鍨嬪彿 - /// </summary> - [SugarColumn(ColumnName = "BOARD_STYLE")] + /// <summary> + /// 浜у搧鍨嬪彿 + /// </summary> + [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } - /// <summary> - /// 鏉ユ枡鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "INS_DATE")] + /// <summary> + /// 鏉ユ枡鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "INS_DATE")] public DateTime? InsDate { get; set; } - /// <summary> - /// 鍒拌揣鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] + /// <summary> + /// 鍒拌揣鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } - /// <summary> - /// 涓嶈壇鍘熷洜 - /// </summary> - [SugarColumn(ColumnName = "MEMO_BAD")] + /// <summary> + /// 涓嶈壇鍘熷洜 + /// </summary> + [SugarColumn(ColumnName = "MEMO_BAD")] public string MemoBad { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 鏉$爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉$爜 - /// </summary> - [SugarColumn(ColumnName = "COME_FLG")] + /// <summary> + /// 鏉$爜鏉ユ簮鏍囪瘑锛�0-鍒濇湡鐗╂枡,1-閲囪喘鍏ュ簱锛�2銆佺敓浜ч��鏂欙紝3銆佸叾瀹冨叆搴擄紝4-瀹緵鏂�,5-鍦ㄥ簱鍒嗘枡锛�6-鍒剁▼鏉$爜 + /// </summary> + [SugarColumn(ColumnName = "COME_FLG")] public short? ComeFlg { get; set; } - /// <summary> - /// 鐢熶骇绾夸綋 - /// </summary> - [SugarColumn(ColumnName = "LINE_NO")] + /// <summary> + /// 鐢熶骇绾夸綋 + /// </summary> + [SugarColumn(ColumnName = "LINE_NO")] public string LineNo { get; set; } - /// <summary> - /// 涓濆嵃娆℃暟 - /// </summary> - [SugarColumn(ColumnName = "SILK_PQTY")] + /// <summary> + /// 涓濆嵃娆℃暟 + /// </summary> + [SugarColumn(ColumnName = "SILK_PQTY")] public decimal? SilkPqty { get; set; } - /// <summary> - /// 涓濆嵃娆℃暟姣� - /// </summary> - [SugarColumn(ColumnName = "SILK")] + /// <summary> + /// 涓濆嵃娆℃暟姣� + /// </summary> + [SugarColumn(ColumnName = "SILK")] public string Silk { get; set; } - /// <summary> - /// 涓濆嵃娲惧伐浠庤〃ID - /// </summary> - [SugarColumn(ColumnName = "SILK_ID")] + /// <summary> + /// 涓濆嵃娲惧伐浠庤〃ID + /// </summary> + [SugarColumn(ColumnName = "SILK_ID")] public decimal? SilkId { get; set; } - /// <summary> - /// 宸叉姤宸ユ爣璇� - /// </summary> - [SugarColumn(ColumnName = "WORK_FLG")] + /// <summary> + /// 宸叉姤宸ユ爣璇� + /// </summary> + [SugarColumn(ColumnName = "WORK_FLG")] public decimal? WorkFlg { get; set; } - /// <summary> - /// 鏈�鍚庡伐搴� - /// </summary> - [SugarColumn(ColumnName = "WORK_LAST")] + /// <summary> + /// 鏈�鍚庡伐搴� + /// </summary> + [SugarColumn(ColumnName = "WORK_LAST")] public decimal? WorkLast { get; set; } - /// <summary> - /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃 - /// </summary> - [SugarColumn(ColumnName = "HBDY")] + /// <summary> + /// 0-鏈悎骞舵墦鍗帮紝1-鍚堝苟鎵撳嵃 + /// </summary> + [SugarColumn(ColumnName = "HBDY")] public decimal? Hbdy { get; set; } - /// <summary> - /// 0-鏈夋晥鏉$爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥 - /// </summary> - [SugarColumn(ColumnName = "HBDYTM")] + /// <summary> + /// 0-鏈夋晥鏉$爜锛�1-鍚堝苟鎷嗗垎鐨勬潯鐮侊紝鏃犳晥 + /// </summary> + [SugarColumn(ColumnName = "HBDYTM")] public decimal? Hbdytm { get; set; } - /// <summary> - /// 鎶ュ伐鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "WORK_FLGTIME")] + /// <summary> + /// 鎶ュ伐鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "WORK_FLGTIME")] public string WorkFlgtime { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemInCDetails.cs b/MES.Service/Modes/MesInvItemInCDetails.cs index be92da1..0bf8253 100644 --- a/MES.Service/Modes/MesInvItemInCDetails.cs +++ b/MES.Service/Modes/MesInvItemInCDetails.cs @@ -11,7 +11,8 @@ /// <summary> /// SEQ_OUT /// </summary> - [SugarColumn(ColumnName = "ID",OracleSequenceName = "SEQ_INV_ID", IsPrimaryKey = true)] + [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID", + IsPrimaryKey = true)] public decimal Id { get; set; } /// <summary> diff --git a/MES.Service/Modes/MesInvItemInCItems.cs b/MES.Service/Modes/MesInvItemInCItems.cs index 9c3eb27..05e3293 100644 --- a/MES.Service/Modes/MesInvItemInCItems.cs +++ b/MES.Service/Modes/MesInvItemInCItems.cs @@ -8,141 +8,141 @@ [SugarTable("MES_INV_ITEM_IN_C_ITEMS")] public class MesInvItemInCItems { - /// <summary> - /// SEQ_OUT - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// SEQ_OUT + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 鍏ュ簱鍗昳d - /// </summary> - [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] + /// <summary> + /// 鍏ュ簱鍗昳d + /// </summary> + [SugarColumn(ColumnName = "ITEM_IN_ID", IsPrimaryKey = true)] public decimal ItemInId { get; set; } - /// <summary> - /// 楠屾敹鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "QUANTITY")] + /// <summary> + /// 楠屾敹鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "QUANTITY")] public decimal? Quantity { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂颁汉 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏈�鍚庢洿鏂颁汉 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏈�鍚庢洿鏂版椂闂� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏈�鍚庢洿鏂版椂闂� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 浠撳簱缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOT_CODE")] + /// <summary> + /// 浠撳簱缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DEPOT_CODE")] public string DepotCode { get; set; } - /// <summary> - /// 璐т綅缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] + /// <summary> + /// 璐т綅缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DEPOT_SECTION_CODE")] public string DepotSectionCode { get; set; } - /// <summary> - /// 鐗硅浜嬮」 - /// </summary> - [SugarColumn(ColumnName = "REMARK")] + /// <summary> + /// 鐗硅浜嬮」 + /// </summary> + [SugarColumn(ColumnName = "REMARK")] public string Remark { get; set; } - /// <summary> - /// 鐗╂枡绠�绉� - /// </summary> - [SugarColumn(ColumnName = "ITEM_SNAME")] + /// <summary> + /// 鐗╂枡绠�绉� + /// </summary> + [SugarColumn(ColumnName = "ITEM_SNAME")] public string ItemSname { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "UNIT")] public string Unit { get; set; } - /// <summary> - /// 閲囪喘璁㈠崟 - /// </summary> - [SugarColumn(ColumnName = "EBELN")] + /// <summary> + /// 閲囪喘璁㈠崟 + /// </summary> + [SugarColumn(ColumnName = "EBELN")] public string Ebeln { get; set; } - /// <summary> - /// 鍏ュ簱鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "BILL_NO")] + /// <summary> + /// 鍏ュ簱鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] public string BillNo { get; set; } - /// <summary> - /// 鍒嗗巶缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// 鍒嗗巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// 鍏徃浠g爜 - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "EBELN_LINE_NO")] + /// <summary> + /// 琛屽彿 + /// </summary> + [SugarColumn(ColumnName = "EBELN_LINE_NO")] public decimal? EbelnLineNo { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "CBILL_NO")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "CBILL_NO")] public string CbillNo { get; set; } - /// <summary> - /// 浠诲姟鍗曡鍙� - /// </summary> - [SugarColumn(ColumnName = "WORK_LINE")] + /// <summary> + /// 浠诲姟鍗曡鍙� + /// </summary> + [SugarColumn(ColumnName = "WORK_LINE")] public decimal? WorkLine { get; set; } - /// <summary> - /// 鐢熶骇宸ュ崟 - /// </summary> - [SugarColumn(ColumnName = "TASK_NO")] + /// <summary> + /// 鐢熶骇宸ュ崟 + /// </summary> + [SugarColumn(ColumnName = "TASK_NO")] public string TaskNo { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemMoves.cs b/MES.Service/Modes/MesInvItemMoves.cs new file mode 100644 index 0000000..b65928e --- /dev/null +++ b/MES.Service/Modes/MesInvItemMoves.cs @@ -0,0 +1,178 @@ +锘縰sing SqlSugar; + +namespace MES.Service.Modes; + +/// <summary> +/// 鐗╂枡绉诲簱涓昏〃 +/// </summary> +[SugarTable("MES_INV_ITEM_MOVES")] +public class MesInvItemMoves +{ + /// <summary> + /// SEQ_INV_ID + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + public decimal Id { get; set; } + + /// <summary> + /// 绉诲簱鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "BILL_NO")] + public string BillNo { 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 = "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 = "STATUS")] + public decimal? Status { get; set; } + + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "REMARK")] + public string Remark { 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 = "CHECKUSER")] + public string Checkuser { get; set; } + + /// <summary> + /// 瀹℃牳鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CHECKDATE")] + public DateTime? Checkdate { get; set; } + + /// <summary> + /// 绉诲叆瀛愬簱code + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOTS_CODE")] + public string InvDepotsCode { get; set; } + + /// <summary> + /// 绉诲叆璐т綅code + /// </summary> + [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")] + public string InvDepotSectionsCode { get; set; } + + /// <summary> + /// 浜嬪姟绫诲瀷缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "TRANSACTION_NO")] + public decimal? TransactionNo { get; set; } + + /// <summary> + /// 绉诲嚭瀛愬簱code + /// </summary> + [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")] + public string FromDepotsCode { get; set; } + + /// <summary> + /// 宸ュ巶缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "FACTORY_CODE")] + public string FactoryCode { 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 = "FACTORY")] + public string Factory { get; set; } + + /// <summary> + /// 鍏徃浠g爜 + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] + public string Company { get; set; } + + /// <summary> + /// 鍙嶅鏍镐簨鍔$被鍨嬬紪鐮� + /// </summary> + [SugarColumn(ColumnName = "MTRANSACTION_NO")] + public decimal? MtransactionNo { get; set; } + + /// <summary> + /// 鑷姩淇濆瓨瀛楁 + /// </summary> + [SugarColumn(ColumnName = "ZD_NUM")] + public decimal? ZdNum { get; set; } + + /// <summary> + /// 鏄惁鎺ㄩ�丒RP1-鏄紝2-鍚� + /// </summary> + [SugarColumn(ColumnName = "TS")] + public decimal? Ts { get; set; } +} \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemMovesCDetails.cs b/MES.Service/Modes/MesInvItemMovesCDetails.cs new file mode 100644 index 0000000..ec6b0c2 --- /dev/null +++ b/MES.Service/Modes/MesInvItemMovesCDetails.cs @@ -0,0 +1,231 @@ +锘縰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", 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> + /// 鍏徃浠g爜 + /// </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; } +} \ No newline at end of file diff --git a/MES.Service/Modes/MesInvItemStocks.cs b/MES.Service/Modes/MesInvItemStocks.cs index c3c46e1..a867ce8 100644 --- a/MES.Service/Modes/MesInvItemStocks.cs +++ b/MES.Service/Modes/MesInvItemStocks.cs @@ -9,7 +9,7 @@ public class MesInvItemStocks { /// <summary> - /// SEQ_ME_ID + /// SEQ_ME_ID /// </summary> [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_ME_ID", IsPrimaryKey = true)] diff --git a/MES.Service/Modes/MesQaItemsDetect01.cs b/MES.Service/Modes/MesQaItemsDetect01.cs index 14760fb..2a26d0c 100644 --- a/MES.Service/Modes/MesQaItemsDetect01.cs +++ b/MES.Service/Modes/MesQaItemsDetect01.cs @@ -8,324 +8,324 @@ [SugarTable("MES_QA_ITEMS_DETECT_01")] public class MesQaItemsDetect01 { - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] public decimal Id { get; set; } - /// <summary> - /// 妫�楠屽崟鍙� - /// </summary> - [SugarColumn(ColumnName = "RELEASE_NO")] + /// <summary> + /// 妫�楠屽崟鍙� + /// </summary> + [SugarColumn(ColumnName = "RELEASE_NO")] public string ReleaseNo { get; set; } - /// <summary> - /// 妫�楠屾棩鏈� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_DATE")] + /// <summary> + /// 妫�楠屾棩鏈� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_DATE")] public DateTime? FcheckDate { get; set; } - /// <summary> - /// 妫�楠屼汉鍛� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_BY")] + /// <summary> + /// 妫�楠屼汉鍛� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_BY")] public string FcheckBy { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "ITEM_NO")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "ITEM_NO")] public string ItemNo { get; set; } - /// <summary> - /// 鏉ユ枡鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FBATCH_QTY")] + /// <summary> + /// 鏉ユ枡鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FBATCH_QTY")] public decimal? FbatchQty { get; set; } - /// <summary> - /// 鍒ゅ畾缁撴灉 - /// </summary> - [SugarColumn(ColumnName = "FRECE_QTY")] + /// <summary> + /// 鍒ゅ畾缁撴灉 + /// </summary> + [SugarColumn(ColumnName = "FRECE_QTY")] public string FreceQty { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "SUPP_NO")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "SUPP_NO")] public string SuppNo { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FNG_DESC")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FNG_DESC")] public string FngDesc { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_RESU")] + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_RESU")] public string FcheckResu { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FREVIEW")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FREVIEW")] public string Freview { get; set; } - /// <summary> - /// 妫�楠屾按鍑� - /// </summary> - [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] + /// <summary> + /// 妫�楠屾按鍑� + /// </summary> + [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] public string SampleSizeNo { get; set; } - /// <summary> - /// 妫�楠屾按骞� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_LEVEL")] + /// <summary> + /// 妫�楠屾按骞� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_LEVEL")] public string FcheckLevel { get; set; } - /// <summary> - /// 鎷掓敹姘村钩 - /// </summary> - [SugarColumn(ColumnName = "FAC_LEVEL")] + /// <summary> + /// 鎷掓敹姘村钩 + /// </summary> + [SugarColumn(ColumnName = "FAC_LEVEL")] public string FacLevel { get; set; } - /// <summary> - /// 鎶芥鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "CHECK_QTY")] + /// <summary> + /// 鎶芥鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QTY")] public string CheckQty { get; set; } - /// <summary> - /// 鎵规鍙� --鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO")] + /// <summary> + /// 鎵规鍙� --鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO")] public string LotNo { get; set; } - /// <summary> - /// 鏄惁鎺ㄩ�� - /// </summary> - [SugarColumn(ColumnName = "FMOVE")] + /// <summary> + /// 鏄惁鎺ㄩ�� + /// </summary> + [SugarColumn(ColumnName = "FMOVE")] public string Fmove { get; set; } - /// <summary> - /// 鏄惁澶勭悊 - /// </summary> - [SugarColumn(ColumnName = "FHANDLE")] + /// <summary> + /// 鏄惁澶勭悊 + /// </summary> + [SugarColumn(ColumnName = "FHANDLE")] public string Fhandle { get; set; } - /// <summary> - /// 鍒涘缓浜� - /// </summary> - [SugarColumn(ColumnName = "CREATE_BY")] + /// <summary> + /// 鍒涘缓浜� + /// </summary> + [SugarColumn(ColumnName = "CREATE_BY")] public string CreateBy { get; set; } - /// <summary> - /// 鍒涘缓鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "CREATE_DATE")] + /// <summary> + /// 鍒涘缓鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "CREATE_DATE")] public DateTime? CreateDate { get; set; } - /// <summary> - /// 鏇存柊浜� - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_BY")] + /// <summary> + /// 鏇存柊浜� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] public string LastupdateBy { get; set; } - /// <summary> - /// 鏇存柊鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + /// <summary> + /// 鏇存柊鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] public DateTime? LastupdateDate { get; set; } - /// <summary> - /// 鏄惁瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_FLAG")] + /// <summary> + /// 鏄惁瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_FLAG")] public decimal? Modify1Flag { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_BY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_BY")] public string Modify1By { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_DATE")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_DATE")] public DateTime? Modify1Date { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FACTORY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] public string Factory { get; set; } - /// <summary> - /// XRF娴嬭瘯鎶ュ憡缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FCHECK_REPNO")] + /// <summary> + /// XRF娴嬭瘯鎶ュ憡缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FCHECK_REPNO")] public string FcheckRepno { get; set; } - /// <summary> - /// 绗笁鏂规姤鍛� - /// </summary> - [SugarColumn(ColumnName = "FTHIRD_REP")] + /// <summary> + /// 绗笁鏂规姤鍛� + /// </summary> + [SugarColumn(ColumnName = "FTHIRD_REP")] public string FthirdRep { get; set; } - /// <summary> - /// 鏄惁浣滃簾 - /// </summary> - [SugarColumn(ColumnName = "FCANCEL")] + /// <summary> + /// 鏄惁浣滃簾 + /// </summary> + [SugarColumn(ColumnName = "FCANCEL")] public decimal? Fcancel { get; set; } - /// <summary> - /// 鎻愪氦鏍囪瘑 - /// </summary> - [SugarColumn(ColumnName = "FSUBMIT")] + /// <summary> + /// 鎻愪氦鏍囪瘑 + /// </summary> + [SugarColumn(ColumnName = "FSUBMIT")] public decimal? Fsubmit { get; set; } - /// <summary> - /// 妫�楠屼緷鎹� - /// </summary> - [SugarColumn(ColumnName = "FCHECK_ACCORD")] + /// <summary> + /// 妫�楠屼緷鎹� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ACCORD")] public string FcheckAccord { get; set; } - /// <summary> - /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱) - /// </summary> - [SugarColumn(ColumnName = "FTYPE")] + /// <summary> + /// 绫诲瀷(0 鏉ユ枡 1 鍦ㄥ簱) + /// </summary> + [SugarColumn(ColumnName = "FTYPE")] public short? Ftype { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "ITEM_UNIT")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "ITEM_UNIT")] public string ItemUnit { get; set; } - /// <summary> - /// 鍑鸿揣鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "OUT_DATE")] + /// <summary> + /// 鍑鸿揣鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "OUT_DATE")] public string OutDate { get; set; } - /// <summary> - /// 鏄惁鍏嶆 - /// </summary> - [SugarColumn(ColumnName = "FEXEMPTION")] + /// <summary> + /// 鏄惁鍏嶆 + /// </summary> + [SugarColumn(ColumnName = "FEXEMPTION")] public decimal? Fexemption { get; set; } - /// <summary> - /// 妗d綅鏍囧噯 - /// </summary> - [SugarColumn(ColumnName = "FGEAR_STAND")] + /// <summary> + /// 妗d綅鏍囧噯 + /// </summary> + [SugarColumn(ColumnName = "FGEAR_STAND")] public string FgearStand { get; set; } - /// <summary> - /// 涓嶈壇澶勭悊鏂规硶 - /// </summary> - [SugarColumn(ColumnName = "FNG_HANDLE")] + /// <summary> + /// 涓嶈壇澶勭悊鏂规硶 + /// </summary> + [SugarColumn(ColumnName = "FNG_HANDLE")] public string FngHandle { get; set; } - /// <summary> - /// 绠$悊缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "FMANAGE_NO")] + /// <summary> + /// 绠$悊缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "FMANAGE_NO")] public string FmanageNo { get; set; } - /// <summary> - /// 杞崲鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "FCOVERT_QTY")] + /// <summary> + /// 杞崲鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FCOVERT_QTY")] public string FcovertQty { get; set; } - /// <summary> - /// 鐗堟湰 - /// </summary> - [SugarColumn(ColumnName = "FVERSION")] + /// <summary> + /// 鐗堟湰 + /// </summary> + [SugarColumn(ColumnName = "FVERSION")] public decimal? Fversion { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "COMPANY")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] public string Company { get; set; } - /// <summary> - /// </summary> - [SugarColumn(ColumnName = "FSECOND_RESU")] + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FSECOND_RESU")] public string FsecondResu { get; set; } - /// <summary> - /// 鏈�澶ф娊妫�鏁� - /// </summary> - [SugarColumn(ColumnName = "MAX_CHECK_QTY")] + /// <summary> + /// 鏈�澶ф娊妫�鏁� + /// </summary> + [SugarColumn(ColumnName = "MAX_CHECK_QTY")] public decimal? MaxCheckQty { get; set; } - /// <summary> - /// 鐗瑰畾淇敼鏄惁瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_FLAG1")] + /// <summary> + /// 鐗瑰畾淇敼鏄惁瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_FLAG1")] public decimal? Modify1Flag1 { get; set; } - /// <summary> - /// 鐗瑰畾淇敼瀹℃牳浜� - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_BY1")] + /// <summary> + /// 鐗瑰畾淇敼瀹℃牳浜� + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_BY1")] public string Modify1By1 { get; set; } - /// <summary> - /// 鐗瑰畾淇敼瀹℃牳鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "MODIFY1_DATE1")] + /// <summary> + /// 鐗瑰畾淇敼瀹℃牳鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "MODIFY1_DATE1")] public DateTime? Modify1Date1 { get; set; } - /// <summary> - /// 灏忔壒娆″彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO1")] + /// <summary> + /// 灏忔壒娆″彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO1")] public string LotNo1 { get; set; } - /// <summary> - /// 閲囪喘鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "LOT_NO2")] + /// <summary> + /// 閲囪喘鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "LOT_NO2")] public string LotNo2 { get; set; } - /// <summary> - /// 浜у搧鍨嬪彿 - /// </summary> - [SugarColumn(ColumnName = "BOARD_STYLE")] + /// <summary> + /// 浜у搧鍨嬪彿 + /// </summary> + [SugarColumn(ColumnName = "BOARD_STYLE")] public string BoardStyle { get; set; } - /// <summary> - /// 浠诲姟鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "WORK_NO")] + /// <summary> + /// 浠诲姟鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "WORK_NO")] public string WorkNo { get; set; } - /// <summary> - /// 鍒拌揣鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "DHA018")] + /// <summary> + /// 鍒拌揣鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "DHA018")] public string Dha018 { get; set; } - /// <summary> - /// 琛屽彿 - /// </summary> - [SugarColumn(ColumnName = "DHB002")] + /// <summary> + /// 琛屽彿 + /// </summary> + [SugarColumn(ColumnName = "DHB002")] public decimal? Dhb002 { get; set; } - /// <summary> - /// 鍒拌揣鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB001")] + /// <summary> + /// 鍒拌揣鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "LIFNR")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "LIFNR")] public string Lifnr { get; set; } - /// <summary> - /// 閫�鏂欐柟寮� - /// </summary> - [SugarColumn(ColumnName = "FMRMODE")] + /// <summary> + /// 閫�鏂欐柟寮� + /// </summary> + [SugarColumn(ColumnName = "FMRMODE")] public string Fmrmode { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/MesQaItemsDetectDetail5.cs b/MES.Service/Modes/MesQaItemsDetectDetail5.cs index 9421a04..d6159cc 100644 --- a/MES.Service/Modes/MesQaItemsDetectDetail5.cs +++ b/MES.Service/Modes/MesQaItemsDetectDetail5.cs @@ -1,154 +1,174 @@ -锘縰sing System; -using System.Collections.Generic; -using System.Linq; -using SqlSugar; -namespace MES.Service.Modes +锘縰sing SqlSugar; + +namespace MES.Service.Modes; + +/// <summary> +/// 鏉ユ枡妫�楠屼粠琛� +/// </summary> +[SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] +public class MesQaItemsDetectDetail5 { - /// <summary> - /// 鏉ユ枡妫�楠屼粠琛� - ///</summary> - [SugarTable("MES_QA_ITEMS_DETECT_DETAIL5")] - public class MesQaItemsDetectDetail5 - { - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="ID" ,IsPrimaryKey = true )] - public decimal Id { get; set; } - /// <summary> - /// 鏍囧噯鍊肩被鍨� - ///</summary> - [SugarColumn(ColumnName="FTEXT_TYPE" )] - public string FtextType { get; set; } - /// <summary> - /// 鏍囧噯鍊� - ///</summary> - [SugarColumn(ColumnName="FSTAND" )] - public decimal? Fstand { get; set; } - /// <summary> - /// 涓婂叕宸� - ///</summary> - [SugarColumn(ColumnName="FUP_ALLOW" )] - public string FupAllow { get; set; } - /// <summary> - /// 涓嬪叕宸� - ///</summary> - [SugarColumn(ColumnName="FDOWN_ALLOW" )] - public string FdownAllow { get; set; } - /// <summary> - /// 妫�楠屾按鍑� - ///</summary> - [SugarColumn(ColumnName="SAMPLE_SIZE_NO" )] - public string SampleSizeNo { get; set; } - /// <summary> - /// 妫�楠屾按骞� - ///</summary> - [SugarColumn(ColumnName="FCHECK_LEVEL" )] - public string FcheckLevel { get; set; } - /// <summary> - /// 鎷掓敹姘村钩 - ///</summary> - [SugarColumn(ColumnName="FAC_LEVEL" )] - public string FacLevel { get; set; } - /// <summary> - /// 妫�楠岄」鐩� - ///</summary> - [SugarColumn(ColumnName="FCHECK_ITEM" )] - public string FcheckItem { get; set; } - /// <summary> - /// 瑙勬牸瑕佹眰 - ///</summary> - [SugarColumn(ColumnName="FSPEC_REQU" )] - public string FspecRequ { get; set; } - /// <summary> - /// 鎶芥鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="CHECK_QYT" )] - public decimal? CheckQyt { get; set; } - /// <summary> - /// 妫�楠岀粨鏋� - ///</summary> - [SugarColumn(ColumnName="FCHECK_RESU" )] - public string FcheckResu { get; set; } - /// <summary> - /// AC鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="FAC_QTY" )] - public decimal? FacQty { get; set; } - /// <summary> - /// RE鏁伴噺 - ///</summary> - [SugarColumn(ColumnName="FRE_QTY" )] - public decimal? FreQty { get; set; } - /// <summary> - /// 涓嶅悎鏍兼暟 - ///</summary> - [SugarColumn(ColumnName="FNG_QTY" )] - public decimal? FngQty { get; set; } - /// <summary> - /// 涓嶈壇鐜� - ///</summary> - [SugarColumn(ColumnName="FNG_RATE" )] - public decimal? FngRate { get; set; } - /// <summary> - /// 宸插綍鍏ユ暟閲� - ///</summary> - [SugarColumn(ColumnName="FENTER_QTY" )] - public decimal? FenterQty { get; set; } - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="RELEASE_NO" )] - public string ReleaseNo { get; set; } - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="COMPANY" )] - public string Company { get; set; } - /// <summary> - /// - ///</summary> - [SugarColumn(ColumnName="FACTORY" )] - public string Factory { get; set; } - /// <summary> - /// 妫�楠岄」鐩弿杩� - ///</summary> - [SugarColumn(ColumnName="FCHECK_ITEM_DESC" )] - public string FcheckItemDesc { get; set; } - /// <summary> - /// 宸ュ簭鍙� - ///</summary> - [SugarColumn(ColumnName="PROC_NO" )] - public string ProcNo { get; set; } - /// <summary> - /// 宸ヤ綔涓績缂栫爜 - ///</summary> - [SugarColumn(ColumnName="WORKSHOP_CENTER_CODE" )] - public string WorkshopCenterCode { get; set; } - /// <summary> - /// 鍗曚綅 - ///</summary> - [SugarColumn(ColumnName="FUNIT" )] - public string Funit { get; set; } - /// <summary> - /// 鐗瑰畾淇敼 - ///</summary> - [SugarColumn(ColumnName="GIVEN_MODIFY" )] - public short? GivenModify { get; set; } - /// <summary> - /// 妫�楠屽伐鍏� - ///</summary> - [SugarColumn(ColumnName="FCHECK_TOOL" )] - public string FcheckTool { get; set; } - /// <summary> - /// 鏇存柊浜� - ///</summary> - [SugarColumn(ColumnName="LASTUPDATE_BY" )] - public string LastupdateBy { get; set; } - /// <summary> - /// 鏇存柊鏃堕棿 - ///</summary> - [SugarColumn(ColumnName="LASTUPDATE_DATE" )] - public DateTime? LastupdateDate { get; set; } - } -} + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "ID", IsPrimaryKey = true)] + public decimal Id { get; set; } + + /// <summary> + /// 鏍囧噯鍊肩被鍨� + /// </summary> + [SugarColumn(ColumnName = "FTEXT_TYPE")] + public string FtextType { get; set; } + + /// <summary> + /// 鏍囧噯鍊� + /// </summary> + [SugarColumn(ColumnName = "FSTAND")] + public decimal? Fstand { get; set; } + + /// <summary> + /// 涓婂叕宸� + /// </summary> + [SugarColumn(ColumnName = "FUP_ALLOW")] + public string FupAllow { get; set; } + + /// <summary> + /// 涓嬪叕宸� + /// </summary> + [SugarColumn(ColumnName = "FDOWN_ALLOW")] + public string FdownAllow { get; set; } + + /// <summary> + /// 妫�楠屾按鍑� + /// </summary> + [SugarColumn(ColumnName = "SAMPLE_SIZE_NO")] + public string SampleSizeNo { get; set; } + + /// <summary> + /// 妫�楠屾按骞� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_LEVEL")] + public string FcheckLevel { get; set; } + + /// <summary> + /// 鎷掓敹姘村钩 + /// </summary> + [SugarColumn(ColumnName = "FAC_LEVEL")] + public string FacLevel { get; set; } + + /// <summary> + /// 妫�楠岄」鐩� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ITEM")] + public string FcheckItem { get; set; } + + /// <summary> + /// 瑙勬牸瑕佹眰 + /// </summary> + [SugarColumn(ColumnName = "FSPEC_REQU")] + public string FspecRequ { get; set; } + + /// <summary> + /// 鎶芥鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "CHECK_QYT")] + public decimal? CheckQyt { get; set; } + + /// <summary> + /// 妫�楠岀粨鏋� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_RESU")] + public string FcheckResu { get; set; } + + /// <summary> + /// AC鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FAC_QTY")] + public decimal? FacQty { get; set; } + + /// <summary> + /// RE鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "FRE_QTY")] + public decimal? FreQty { get; set; } + + /// <summary> + /// 涓嶅悎鏍兼暟 + /// </summary> + [SugarColumn(ColumnName = "FNG_QTY")] + public decimal? FngQty { get; set; } + + /// <summary> + /// 涓嶈壇鐜� + /// </summary> + [SugarColumn(ColumnName = "FNG_RATE")] + public decimal? FngRate { get; set; } + + /// <summary> + /// 宸插綍鍏ユ暟閲� + /// </summary> + [SugarColumn(ColumnName = "FENTER_QTY")] + public decimal? FenterQty { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "RELEASE_NO")] + public string ReleaseNo { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "COMPANY")] + public string Company { get; set; } + + /// <summary> + /// </summary> + [SugarColumn(ColumnName = "FACTORY")] + public string Factory { get; set; } + + /// <summary> + /// 妫�楠岄」鐩弿杩� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_ITEM_DESC")] + public string FcheckItemDesc { get; set; } + + /// <summary> + /// 宸ュ簭鍙� + /// </summary> + [SugarColumn(ColumnName = "PROC_NO")] + public string ProcNo { get; set; } + + /// <summary> + /// 宸ヤ綔涓績缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "WORKSHOP_CENTER_CODE")] + public string WorkshopCenterCode { get; set; } + + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "FUNIT")] + public string Funit { get; set; } + + /// <summary> + /// 鐗瑰畾淇敼 + /// </summary> + [SugarColumn(ColumnName = "GIVEN_MODIFY")] + public short? GivenModify { get; set; } + + /// <summary> + /// 妫�楠屽伐鍏� + /// </summary> + [SugarColumn(ColumnName = "FCHECK_TOOL")] + public string FcheckTool { get; set; } + + /// <summary> + /// 鏇存柊浜� + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_BY")] + public string LastupdateBy { get; set; } + + /// <summary> + /// 鏇存柊鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "LASTUPDATE_DATE")] + public DateTime? LastupdateDate { get; set; } +} \ No newline at end of file diff --git a/MES.Service/Modes/Purdhb.cs b/MES.Service/Modes/Purdhb.cs index b8de0cc..7fff6ee 100644 --- a/MES.Service/Modes/Purdhb.cs +++ b/MES.Service/Modes/Purdhb.cs @@ -8,267 +8,267 @@ [SugarTable("PURDHB")] public class Purdhb { - /// <summary> - /// 鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB001")] + /// <summary> + /// 鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB001")] public string Dhb001 { get; set; } - /// <summary> - /// 搴忓彿 - /// </summary> - [SugarColumn(ColumnName = "DHB002")] + /// <summary> + /// 搴忓彿 + /// </summary> + [SugarColumn(ColumnName = "DHB002")] public string Dhb002 { get; set; } - /// <summary> - /// 鐗╂枡缂栫爜 - /// </summary> - [SugarColumn(ColumnName = "DHB003")] + /// <summary> + /// 鐗╂枡缂栫爜 + /// </summary> + [SugarColumn(ColumnName = "DHB003")] public string Dhb003 { get; set; } - /// <summary> - /// 鐗╂枡鍚嶇О - /// </summary> - [SugarColumn(ColumnName = "DHB004")] + /// <summary> + /// 鐗╂枡鍚嶇О + /// </summary> + [SugarColumn(ColumnName = "DHB004")] public string Dhb004 { get; set; } - /// <summary> - /// 鐗╂枡瑙勬牸 - /// </summary> - [SugarColumn(ColumnName = "DHB005")] + /// <summary> + /// 鐗╂枡瑙勬牸 + /// </summary> + [SugarColumn(ColumnName = "DHB005")] public string Dhb005 { get; set; } - /// <summary> - /// 浜よ揣鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB006")] + /// <summary> + /// 浜よ揣鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB006")] public decimal? Dhb006 { get; set; } - /// <summary> - /// 鍗曚綅 - /// </summary> - [SugarColumn(ColumnName = "DHB007")] + /// <summary> + /// 鍗曚綅 + /// </summary> + [SugarColumn(ColumnName = "DHB007")] public string Dhb007 { get; set; } - /// <summary> - /// 浠撳簱 - /// </summary> - [SugarColumn(ColumnName = "DHB008")] + /// <summary> + /// 浠撳簱 + /// </summary> + [SugarColumn(ColumnName = "DHB008")] public string Dhb008 { get; set; } - /// <summary> - /// 浠撳簱鍚嶇О - /// </summary> - [SugarColumn(ColumnName = "DHB009")] + /// <summary> + /// 浠撳簱鍚嶇О + /// </summary> + [SugarColumn(ColumnName = "DHB009")] public string Dhb009 { get; set; } - /// <summary> - /// 鎵瑰彿 - /// </summary> - [SugarColumn(ColumnName = "DHB010")] + /// <summary> + /// 鎵瑰彿 + /// </summary> + [SugarColumn(ColumnName = "DHB010")] public string Dhb010 { get; set; } - /// <summary> - /// 鏉ユ簮鍗曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB011")] + /// <summary> + /// 鏉ユ簮鍗曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB011")] public string Dhb011 { get; set; } - /// <summary> - /// 鏉ユ簮搴忓彿 - /// </summary> - [SugarColumn(ColumnName = "DHB012")] + /// <summary> + /// 鏉ユ簮搴忓彿 + /// </summary> + [SugarColumn(ColumnName = "DHB012")] public decimal? Dhb012 { get; set; } - /// <summary> - /// 娓呯偣鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB013")] + /// <summary> + /// 娓呯偣鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB013")] public decimal? Dhb013 { get; set; } - /// <summary> - /// 鍒板巶鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "DHB014")] + /// <summary> + /// 鍒板巶鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "DHB014")] public string Dhb014 { get; set; } - /// <summary> - /// 楠屾敹鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB015")] + /// <summary> + /// 楠屾敹鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB015")] public decimal? Dhb015 { get; set; } - /// <summary> - /// 楠岄��鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB016")] + /// <summary> + /// 楠岄��鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB016")] public decimal? Dhb016 { get; set; } - /// <summary> - /// 杩涜揣鍗曚环 - /// </summary> - [SugarColumn(ColumnName = "DHB017")] + /// <summary> + /// 杩涜揣鍗曚环 + /// </summary> + [SugarColumn(ColumnName = "DHB017")] public decimal? Dhb017 { get; set; } - /// <summary> - /// 杩涜揣閲戦 - /// </summary> - [SugarColumn(ColumnName = "DHB018")] + /// <summary> + /// 杩涜揣閲戦 + /// </summary> + [SugarColumn(ColumnName = "DHB018")] public decimal? Dhb018 { get; set; } - /// <summary> - /// 瀹㈡埛鏂欏彿 - /// </summary> - [SugarColumn(ColumnName = "DHB019")] + /// <summary> + /// 瀹㈡埛鏂欏彿 + /// </summary> + [SugarColumn(ColumnName = "DHB019")] public string Dhb019 { get; set; } - /// <summary> - /// 閮ㄩ棬缂栧彿 - /// </summary> - [SugarColumn(ColumnName = "DHB020")] + /// <summary> + /// 閮ㄩ棬缂栧彿 + /// </summary> + [SugarColumn(ColumnName = "DHB020")] public string Dhb020 { get; set; } - /// <summary> - /// 璧犲搧鏁� - /// </summary> - [SugarColumn(ColumnName = "DHB021")] + /// <summary> + /// 璧犲搧鏁� + /// </summary> + [SugarColumn(ColumnName = "DHB021")] public decimal? Dhb021 { get; set; } - /// <summary> - /// 鏇存柊ERP - /// </summary> - [SugarColumn(ColumnName = "DHB022")] + /// <summary> + /// 鏇存柊ERP + /// </summary> + [SugarColumn(ColumnName = "DHB022")] public string Dhb022 { get; set; } - /// <summary> - /// 妫�楠岀姸鎬� - /// </summary> - [SugarColumn(ColumnName = "DHB023")] + /// <summary> + /// 妫�楠岀姸鎬� + /// </summary> + [SugarColumn(ColumnName = "DHB023")] public string Dhb023 { get; set; } - /// <summary> - /// 澶囨敞 - /// </summary> - [SugarColumn(ColumnName = "DHB024")] + /// <summary> + /// 澶囨敞 + /// </summary> + [SugarColumn(ColumnName = "DHB024")] public string Dhb024 { get; set; } - /// <summary> - /// 瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "AUDITING")] + /// <summary> + /// 瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "AUDITING")] public decimal? Auditing { get; set; } - /// <summary> - /// ERP閲囪喘鍗曞彿ID - /// </summary> - [SugarColumn(ColumnName = "DHB026")] + /// <summary> + /// ERP閲囪喘鍗曞彿ID + /// </summary> + [SugarColumn(ColumnName = "DHB026")] public decimal? Dhb026 { get; set; } - /// <summary> - /// ERP閲囪喘搴忓彿ID - /// </summary> - [SugarColumn(ColumnName = "DHB027")] + /// <summary> + /// ERP閲囪喘搴忓彿ID + /// </summary> + [SugarColumn(ColumnName = "DHB027")] public decimal? Dhb027 { get; set; } - /// <summary> - /// ERP鐗╂枡ID - /// </summary> - [SugarColumn(ColumnName = "DHB028")] + /// <summary> + /// ERP鐗╂枡ID + /// </summary> + [SugarColumn(ColumnName = "DHB028")] public decimal? Dhb028 { get; set; } - /// <summary> - /// 寰呮鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB029")] + /// <summary> + /// 寰呮鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB029")] public decimal? Dhb029 { get; set; } - /// <summary> - /// 妫�楠屾棩鏈� - /// </summary> - [SugarColumn(ColumnName = "DHB030")] + /// <summary> + /// 妫�楠屾棩鏈� + /// </summary> + [SugarColumn(ColumnName = "DHB030")] public string Dhb030 { get; set; } - /// <summary> - /// 妫�楠屽憳 - /// </summary> - [SugarColumn(ColumnName = "DHB031")] + /// <summary> + /// 妫�楠屽憳 + /// </summary> + [SugarColumn(ColumnName = "DHB031")] public string Dhb031 { get; set; } - /// <summary> - /// 鍏ュ簱鏁伴噺 - /// </summary> - [SugarColumn(ColumnName = "DHB032")] + /// <summary> + /// 鍏ュ簱鏁伴噺 + /// </summary> + [SugarColumn(ColumnName = "DHB032")] public decimal? Dhb032 { get; set; } - /// <summary> - /// 鍏ュ簱浜� - /// </summary> - [SugarColumn(ColumnName = "DHB033")] + /// <summary> + /// 鍏ュ簱浜� + /// </summary> + [SugarColumn(ColumnName = "DHB033")] public string Dhb033 { get; set; } - /// <summary> - /// 鍏ュ簱鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "DHB034")] + /// <summary> + /// 鍏ュ簱鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "DHB034")] public string Dhb034 { get; set; } - /// <summary> - /// 閫�璐ф暟閲� - /// </summary> - [SugarColumn(ColumnName = "DHB035")] + /// <summary> + /// 閫�璐ф暟閲� + /// </summary> + [SugarColumn(ColumnName = "DHB035")] public decimal? Dhb035 { get; set; } - /// <summary> - /// ERPID - /// </summary> - [SugarColumn(ColumnName = "DHB037")] + /// <summary> + /// ERPID + /// </summary> + [SugarColumn(ColumnName = "DHB037")] public decimal? Dhb037 { get; set; } - /// <summary> - /// 閫�璐т汉 - /// </summary> - [SugarColumn(ColumnName = "DHB036")] + /// <summary> + /// 閫�璐т汉 + /// </summary> + [SugarColumn(ColumnName = "DHB036")] public string Dhb036 { get; set; } - /// <summary> - /// ERP鍘熷垎褰曞彿 - /// </summary> - [SugarColumn(ColumnName = "DHB038")] + /// <summary> + /// ERP鍘熷垎褰曞彿 + /// </summary> + [SugarColumn(ColumnName = "DHB038")] public decimal? Dhb038 { get; set; } - /// <summary> - /// ERP婧愬崟鍐呯爜 - /// </summary> - [SugarColumn(ColumnName = "DHB039")] + /// <summary> + /// ERP婧愬崟鍐呯爜 + /// </summary> + [SugarColumn(ColumnName = "DHB039")] public decimal? Dhb039 { get; set; } - /// <summary> - /// ERP婧愬崟绫诲瀷 - /// </summary> - [SugarColumn(ColumnName = "DHB040")] + /// <summary> + /// ERP婧愬崟绫诲瀷 + /// </summary> + [SugarColumn(ColumnName = "DHB040")] public decimal? Dhb040 { get; set; } - /// <summary> - /// ERP璁㈠崟鍐呯爜 - /// </summary> - [SugarColumn(ColumnName = "DHB041")] + /// <summary> + /// ERP璁㈠崟鍐呯爜 + /// </summary> + [SugarColumn(ColumnName = "DHB041")] public decimal? Dhb041 { get; set; } - /// <summary> - /// 鑷鍒� - /// </summary> - [SugarColumn(ColumnName = "ID")] + /// <summary> + /// 鑷鍒� + /// </summary> + [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } - /// <summary> - /// 鏄惁妫�楠岋紝1涓哄凡妫� - /// </summary> - [SugarColumn(ColumnName = "ISCHECK")] + /// <summary> + /// 鏄惁妫�楠岋紝1涓哄凡妫� + /// </summary> + [SugarColumn(ColumnName = "ISCHECK")] public decimal? Ischeck { get; set; } - /// <summary> - /// 浠撳簱 - /// </summary> - [SugarColumn(ColumnName = "DHB042")] + /// <summary> + /// 浠撳簱 + /// </summary> + [SugarColumn(ColumnName = "DHB042")] public string Dhb042 { get; set; } } \ No newline at end of file diff --git a/MES.Service/Modes/Purdka.cs b/MES.Service/Modes/Purdka.cs index 4330c13..1c3ea40 100644 --- a/MES.Service/Modes/Purdka.cs +++ b/MES.Service/Modes/Purdka.cs @@ -8,123 +8,123 @@ [SugarTable("PURDKA")] public class Purdka { - /// <summary> - /// 鑷鍒� - /// </summary> - [SugarColumn(ColumnName = "ID")] + /// <summary> + /// 鑷鍒� + /// </summary> + [SugarColumn(ColumnName = "ID")] public decimal? Id { get; set; } - /// <summary> - /// 鍒涘缓浜哄憳 - /// </summary> - [SugarColumn(ColumnName = "CREATEUSER")] + /// <summary> + /// 鍒涘缓浜哄憳 + /// </summary> + [SugarColumn(ColumnName = "CREATEUSER")] public string Createuser { get; set; } - /// <summary> - /// 鍒涘缓鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "CREATETIME")] + /// <summary> + /// 鍒涘缓鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "CREATETIME")] public string Createtime { get; set; } - /// <summary> - /// 淇敼鏃堕棿 - /// </summary> - [SugarColumn(ColumnName = "MODIFYTIME")] + /// <summary> + /// 淇敼鏃堕棿 + /// </summary> + [SugarColumn(ColumnName = "MODIFYTIME")] public string Modifytime { get; set; } - /// <summary> - /// 淇敼浜哄憳 - /// </summary> - [SugarColumn(ColumnName = "MODIFYUSER")] + /// <summary> + /// 淇敼浜哄憳 + /// </summary> + [SugarColumn(ColumnName = "MODIFYUSER")] public string Modifyuser { get; set; } - /// <summary> - /// 瀹℃牳 - /// </summary> - [SugarColumn(ColumnName = "AUDITING")] + /// <summary> + /// 瀹℃牳 + /// </summary> + [SugarColumn(ColumnName = "AUDITING")] public string Auditing { get; set; } - /// <summary> - /// 閫�璐у崟鍙� - /// </summary> - [SugarColumn(ColumnName = "DKA001")] + /// <summary> + /// 閫�璐у崟鍙� + /// </summary> + [SugarColumn(ColumnName = "DKA001")] public string Dka001 { get; set; } - /// <summary> - /// 閫�璐х被鍨� - /// </summary> - [SugarColumn(ColumnName = "DKA002")] + /// <summary> + /// 閫�璐х被鍨� + /// </summary> + [SugarColumn(ColumnName = "DKA002")] public string Dka002 { get; set; } - /// <summary> - /// 閫�璐ф棩鏈� - /// </summary> - [SugarColumn(ColumnName = "DKA003")] + /// <summary> + /// 閫�璐ф棩鏈� + /// </summary> + [SugarColumn(ColumnName = "DKA003")] public string Dka003 { get; set; } - /// <summary> - /// 閫�璐ф椂闂� - /// </summary> - [SugarColumn(ColumnName = "DKA004")] + /// <summary> + /// 閫�璐ф椂闂� + /// </summary> + [SugarColumn(ColumnName = "DKA004")] public string Dka004 { get; set; } - /// <summary> - /// 渚涘簲鍟� - /// </summary> - [SugarColumn(ColumnName = "DKA005")] + /// <summary> + /// 渚涘簲鍟� + /// </summary> + [SugarColumn(ColumnName = "DKA005")] public string Dka005 { get; set; } - /// <summary> - /// 渚涘簲鍟嗗悕绉� - /// </summary> - [SugarColumn(ColumnName = "DKA006")] + /// <summary> + /// 渚涘簲鍟嗗悕绉� + /// </summary> + [SugarColumn(ColumnName = "DKA006")] public string Dka006 { get; set; } - /// <summary> - /// 閮ㄩ棬 - /// </summary> - [SugarColumn(ColumnName = "DKA007")] + /// <summary> + /// 閮ㄩ棬 + /// </summary> + [SugarColumn(ColumnName = "DKA007")] public string Dka007 { get; set; } - /// <summary> - /// 瀹℃牳鑰� - /// </summary> - [SugarColumn(ColumnName = "DKA008")] + /// <summary> + /// 瀹℃牳鑰� + /// </summary> + [SugarColumn(ColumnName = "DKA008")] public string Dka008 { get; set; } - /// <summary> - /// 瀹℃牳鏃ユ湡 - /// </summary> - [SugarColumn(ColumnName = "DKA009")] + /// <summary> + /// 瀹℃牳鏃ユ湡 + /// </summary> + [SugarColumn(ColumnName = "DKA009")] public string Dka009 { get; set; } - /// <summary> - /// 閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹� - /// </summary> - [SugarColumn(ColumnName = "DKA010")] + /// <summary> + /// 閫�璐х姸鎬侊紝0鎴栫┖涓烘湭閫�璐э紝1涓哄凡閫�瀹� + /// </summary> + [SugarColumn(ColumnName = "DKA010")] public string Dka010 { get; set; } - /// <summary> - /// ERPID - /// </summary> - [SugarColumn(ColumnName = "ERPID")] + /// <summary> + /// ERPID + /// </summary> + [SugarColumn(ColumnName = "ERPID")] public decimal? Erpid { get; set; } - /// <summary> - /// 淇濈鍛樼紪鐮� - /// </summary> - [SugarColumn(ColumnName = "DKA011")] + /// <summary> + /// 淇濈鍛樼紪鐮� + /// </summary> + [SugarColumn(ColumnName = "DKA011")] public string Dka011 { get; set; } - /// <summary> - /// 楠屾敹鍛樼紪鐮� - /// </summary> - [SugarColumn(ColumnName = "DKA012")] + /// <summary> + /// 楠屾敹鍛樼紪鐮� + /// </summary> + [SugarColumn(ColumnName = "DKA012")] public string Dka012 { get; set; } - /// <summary> - /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫� - /// </summary> - [SugarColumn(ColumnName = "DKA013")] + /// <summary> + /// 鏄惁鎺ㄩ�佺孩瀛楀叆搴�1-鎺ㄩ�侊紝0-鏈帹閫� + /// </summary> + [SugarColumn(ColumnName = "DKA013")] public decimal? Dka013 { get; set; } } \ No newline at end of file diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs index 5dc3db7..1f5f4dc 100644 --- a/MES.Service/service/BasicData/MesStaffManager.cs +++ b/MES.Service/service/BasicData/MesStaffManager.cs @@ -149,7 +149,7 @@ Status = 0, Isdeparture = 0, CheckFlag = 0, - ExpFiel12 = 0, + ExpFiel12 = 0 }; } diff --git a/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs b/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs index 8fda982..a471429 100644 --- a/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs +++ b/MES.Service/service/QC/MesQaItemsDetectDetail5Manager.cs @@ -1,78 +1,79 @@ -锘縰sing SqlSugar; -using System; -using System.Collections.Generic; -using MES.Service.DB; +锘縰sing MES.Service.DB; using MES.Service.Modes; +using SqlSugar; -namespace MES.Service.service.QC +namespace MES.Service.service.QC; + +public class + MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5> { -public class MesQaItemsDetectDetail5Manager : Repository<MesQaItemsDetectDetail5> -{ - //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉� //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesQaItemsDetectDetail5Manager.cs #region 鏁欏鏂规硶 + /// <summary> - /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� + /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� /// </summary> public void Study() { - - /*********鏌ヨ*********/ + /*********鏌ヨ*********/ - var data1 = base.GetById(1);//鏍规嵁ID鏌ヨ - var data2 = base.GetList();//鏌ヨ鎵�鏈� - var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ + var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ + var data2 = base.GetList(); //鏌ヨ鎵�鏈� + var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊 - var p = new PageModel() { PageIndex = 1, PageSize = 2 };// 鍒嗛〉鏌ヨ + var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ var data5 = base.GetPageList(it => 1 == 1, p); - Console.Write(p.TotalCount);//杩斿洖鎬绘暟 + Console.Write(p.TotalCount); //杩斿洖鎬绘暟 - var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// 鍒嗛〉鏌ヨ鍔犳帓搴� - Console.Write(p.TotalCount);//杩斿洖鎬绘暟 - - List<IConditionalModel> conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴� - conModels.Add(new ConditionalModel() { FieldName= typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 - var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); + var data6 = + base.GetPageList(it => 1 == 1, p, + it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴� + Console.Write(p.TotalCount); //杩斿洖鎬绘暟 - base.AsQueryable().Where(x => 1 == 1).ToList();//鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 + var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴� + conModels.Add(new ConditionalModel + { + FieldName = typeof(MesQaItemsDetectDetail5).GetProperties()[0].Name, + ConditionalType = ConditionalType.Equal, FieldValue = "1" + }); //id=1 + var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); - + AsQueryable().Where(x => 1 == 1) + .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 + /*********鎻掑叆*********/ - var insertData = new MesQaItemsDetectDetail5() { };//娴嬭瘯鍙傛暟 - var insertArray = new MesQaItemsDetectDetail5[] { insertData }; - base.Insert(insertData);//鎻掑叆 - base.InsertRange(insertArray);//鎵归噺鎻掑叆 - var id = base.InsertReturnIdentity(insertData);//鎻掑叆杩斿洖鑷鍒� - base.AsInsertable(insertData).ExecuteCommand();//鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆 + var insertData = new MesQaItemsDetectDetail5(); //娴嬭瘯鍙傛暟 + var insertArray = new[] { insertData }; + base.Insert(insertData); //鎻掑叆 + base.InsertRange(insertArray); //鎵归噺鎻掑叆 + var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒� + AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆 - - /*********鏇存柊*********/ - var updateData = new MesQaItemsDetectDetail5() { };//娴嬭瘯鍙傛暟 - var updateArray = new MesQaItemsDetectDetail5[] { updateData };//娴嬭瘯鍙傛暟 - base.Update(updateData);//鏍规嵁瀹炰綋鏇存柊 - base.UpdateRange(updateArray);//鎵归噺鏇存柊 + /*********鏇存柊*********/ + var updateData = new MesQaItemsDetectDetail5(); //娴嬭瘯鍙傛暟 + var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟 + base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊 + base.UpdateRange(updateArray); //鎵归噺鏇存柊 //base.Update(it => new MesQaItemsDetectDetail5() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1 - base.AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏� + AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏� + /*********鍒犻櫎*********/ + var deldata = new MesQaItemsDetectDetail5(); //娴嬭瘯鍙傛暟 + base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎 + base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎 + base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎 + base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎 + AsDeleteable().Where(it => 1 == 2) + .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� + } - /*********鍒犻櫎*********/ - var deldata = new MesQaItemsDetectDetail5() { };//娴嬭瘯鍙傛暟 - base.Delete(deldata);//鏍规嵁瀹炰綋鍒犻櫎 - base.DeleteById(1);//鏍规嵁涓婚敭鍒犻櫎 - base.DeleteById(new int[] { 1,2});//鏍规嵁涓婚敭鏁扮粍鍒犻櫎 - base.Delete(it=>1==2);//鏍规嵁鏉′欢鍒犻櫎 - base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� - } #endregion - - - } } \ No newline at end of file diff --git a/MES.Service/service/Warehouse/MesDepotSectionsManager.cs b/MES.Service/service/Warehouse/MesDepotSectionsManager.cs index 3a02a02..0fbb744 100644 --- a/MES.Service/service/Warehouse/MesDepotSectionsManager.cs +++ b/MES.Service/service/Warehouse/MesDepotSectionsManager.cs @@ -17,21 +17,17 @@ .Select((a, b) => a.DepotSectionName).Single(); if (sectionName == null) - { throw new Exception("搴撲綅缂栫爜 " + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁わ紒"); - } return sectionName; } + //搴撲綅鍙樻洿 public MesDepotSections ScanInDepotSectionsName(WarehouseQuery query) { - if (string.IsNullOrEmpty(query.sectionCode)) - { throw new Exception("璇锋壂搴撲綅鏉$爜!"); - } - + var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>( (a, b) => new JoinQueryInfos(JoinType.Inner, a.DepotId == b.DepotId)) @@ -44,20 +40,47 @@ }).First(); if (mesDepotSections == null) - { throw new Exception("搴撲綅缂栫爜" + query.sectionCode + " 涓嶅瓨鍦紝璇风‘璁�!"); - } return mesDepotSections; } + //搴撲綅鍙樻洿 public MesInvItemStocks ScanEditBarcode(WarehouseQuery entity) { if (string.IsNullOrEmpty(entity.sectionCode)) - { throw new Exception("璇锋壂搴撲綅鏉$爜!"); - } - return null; + var mesDepotSections = Db.Queryable<MesDepotSections, MesDepots>( + (a, b) => + new JoinQueryInfos(JoinType.Inner, + a.Zuid.ToString() == b.Zuid)) + .Where((a, b) => a.DepotSectionCode == entity.sectionCode) + .First(); + if (mesDepotSections == null) + throw new Exception("搴撲綅缂栫爜" + entity.sectionCode + " 涓嶅瓨鍦紝璇风‘璁わ紒"); + + var mesInvItemStocks = Db.Queryable<MesInvItemStocks>() + .Where(s => s.ItemBarcode == entity.barcode).First(); + + if (mesInvItemStocks == null) throw new Exception("鏉$爜鍦ㄤ粨搴撲腑涓嶅瓨鍦紝璇锋牳瀵癸紒"); + + if (mesInvItemStocks.DepotsCode != mesDepotSections.DepotCode) + throw new Exception( + "鏉$爜鍘熶粨搴擄細" + mesInvItemStocks.DepotsCode + " 涓庣洰鏍囦粨搴擄細" + + mesDepotSections.DepotCode + " 涓嶄竴鑷达紝搴撲綅鍙樻洿澶辫触锛�"); + + UseTransaction(db => + { + return db.Updateable<MesInvItemStocks>() + .SetColumns(s => s.DepotsCode == mesDepotSections.DepotCode) + .SetColumns(s => s.DepotSectionsCode == entity.sectionCode) + .Where(s => s.ItemBarcode == entity.barcode) + .ExecuteCommand(); + }); + + return mesInvItemStocks; } + + //璋冩嫧鍏ュ簱 } \ No newline at end of file diff --git a/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs b/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs index 8704a00..13679e8 100644 --- a/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs +++ b/MES.Service/service/Warehouse/MesInvBusiness2Manager.cs @@ -1,78 +1,78 @@ -锘縰sing SqlSugar; -using System; -using System.Collections.Generic; -using MES.Service.DB; +锘縰sing MES.Service.DB; using MES.Service.Modes; +using SqlSugar; -namespace MES.Service.service.Warehouse -{ +namespace MES.Service.service.Warehouse; + public class MesInvBusiness2Manager : Repository<MesInvBusiness2> { - //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉� //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvBusiness2Manager.cs #region 鏁欏鏂规硶 + /// <summary> - /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� + /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� /// </summary> public void Study() { - - /*********鏌ヨ*********/ + /*********鏌ヨ*********/ - var data1 = base.GetById(1);//鏍规嵁ID鏌ヨ - var data2 = base.GetList();//鏌ヨ鎵�鏈� - var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ + var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ + var data2 = base.GetList(); //鏌ヨ鎵�鏈� + var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊 - var p = new PageModel() { PageIndex = 1, PageSize = 2 };// 鍒嗛〉鏌ヨ + var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ var data5 = base.GetPageList(it => 1 == 1, p); - Console.Write(p.TotalCount);//杩斿洖鎬绘暟 + Console.Write(p.TotalCount); //杩斿洖鎬绘暟 - var data6 = base.GetPageList(it => 1 == 1, p, it => SqlFunc.GetRandom(), OrderByType.Asc);// 鍒嗛〉鏌ヨ鍔犳帓搴� - Console.Write(p.TotalCount);//杩斿洖鎬绘暟 - - List<IConditionalModel> conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴� - conModels.Add(new ConditionalModel() { FieldName= typeof(MesInvBusiness2).GetProperties()[0].Name, ConditionalType = ConditionalType.Equal, FieldValue = "1" });//id=1 - var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom(), OrderByType.Asc); + var data6 = + base.GetPageList(it => 1 == 1, p, + it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴� + Console.Write(p.TotalCount); //杩斿洖鎬绘暟 - base.AsQueryable().Where(x => 1 == 1).ToList();//鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 + var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴� + conModels.Add(new ConditionalModel + { + FieldName = typeof(MesInvBusiness2).GetProperties()[0].Name, + ConditionalType = ConditionalType.Equal, FieldValue = "1" + }); //id=1 + var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); - + AsQueryable().Where(x => 1 == 1) + .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 + /*********鎻掑叆*********/ - var insertData = new MesInvBusiness2() { };//娴嬭瘯鍙傛暟 - var insertArray = new MesInvBusiness2[] { insertData }; - base.Insert(insertData);//鎻掑叆 - base.InsertRange(insertArray);//鎵归噺鎻掑叆 - var id = base.InsertReturnIdentity(insertData);//鎻掑叆杩斿洖鑷鍒� - base.AsInsertable(insertData).ExecuteCommand();//鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆 + var insertData = new MesInvBusiness2(); //娴嬭瘯鍙傛暟 + var insertArray = new[] { insertData }; + base.Insert(insertData); //鎻掑叆 + base.InsertRange(insertArray); //鎵归噺鎻掑叆 + var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒� + AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆 - - /*********鏇存柊*********/ - var updateData = new MesInvBusiness2() { };//娴嬭瘯鍙傛暟 - var updateArray = new MesInvBusiness2[] { updateData };//娴嬭瘯鍙傛暟 - base.Update(updateData);//鏍规嵁瀹炰綋鏇存柊 - base.UpdateRange(updateArray);//鎵归噺鏇存柊 + /*********鏇存柊*********/ + var updateData = new MesInvBusiness2(); //娴嬭瘯鍙傛暟 + var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟 + base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊 + base.UpdateRange(updateArray); //鎵归噺鏇存柊 //base.Update(it => new MesInvBusiness2() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1 - base.AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏� + AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏� + /*********鍒犻櫎*********/ + var deldata = new MesInvBusiness2(); //娴嬭瘯鍙傛暟 + base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎 + base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎 + base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎 + base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎 + AsDeleteable().Where(it => 1 == 2) + .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� + } - /*********鍒犻櫎*********/ - var deldata = new MesInvBusiness2() { };//娴嬭瘯鍙傛暟 - base.Delete(deldata);//鏍规嵁瀹炰綋鍒犻櫎 - base.DeleteById(1);//鏍规嵁涓婚敭鍒犻櫎 - base.DeleteById(new int[] { 1,2});//鏍规嵁涓婚敭鏁扮粍鍒犻櫎 - base.Delete(it=>1==2);//鏍规嵁鏉′欢鍒犻櫎 - base.AsDeleteable().Where(it=>1==2).ExecuteCommand();//杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� - } #endregion - - - } } \ No newline at end of file diff --git a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs index 49ad635..f4a9f24 100644 --- a/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs +++ b/MES.Service/service/Warehouse/MesInvItemArnDetailManager.cs @@ -59,8 +59,8 @@ // 鏌ヨ var result = Db .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail, - MesItems, MesUnit,MesQaItemsDetectDetail5>( - (a, d, b, c, t,z) => new object[] + MesItems, MesUnit, MesQaItemsDetectDetail5>( + (a, d, b, c, t, z) => new object[] { JoinType.Inner, d.BillNo == a.LotNo, JoinType.Inner, d.Id == b.Mid && b.ItemNo == a.ItemNo, @@ -70,9 +70,9 @@ JoinType.Inner, c.Fpurchaseunitid == t.Id, JoinType.Inner, z.ReleaseNo == a.ReleaseNo }) - .Where((a, d, b, c, t,z) => a.FngHandle == "閫�璐�" && - z.FcheckResu == "涓嶅悎鏍�" && - query.ItemArnDetailIds.Contains(b.Id)) + .Where((a, d, b, c, t, z) => a.FngHandle == "閫�璐�" && + z.FcheckResu == "涓嶅悎鏍�" && + query.ItemArnDetailIds.Contains(b.Id)) .Select((a, d, b, c, t) => new Material { FmrMode = a.Fmrmode, diff --git a/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs new file mode 100644 index 0000000..cf8c2a3 --- /dev/null +++ b/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs @@ -0,0 +1,79 @@ +锘縰sing MES.Service.DB; +using MES.Service.Modes; +using SqlSugar; + +namespace MES.Service.service.Warehouse; + +public class + MesInvItemMovesCDetailsManager : Repository<MesInvItemMovesCDetails> +{ + //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉� + + //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemMovesCDetailsManager.cs + + + #region 鏁欏鏂规硶 + + /// <summary> + /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠g爜璇峰湪杩欓噷闈㈠畾涔夋柟娉� + /// </summary> + public void Study() + { + /*********鏌ヨ*********/ + + var data1 = base.GetById(1); //鏍规嵁ID鏌ヨ + var data2 = base.GetList(); //鏌ヨ鎵�鏈� + var data3 = base.GetList(it => 1 == 1); //鏍规嵁鏉′欢鏌ヨ + //var data4 = base.GetSingle(it => 1 == 1);//鏍规嵁鏉′欢鏌ヨ涓�鏉�,濡傛灉瓒呰繃涓�鏉′細鎶ラ敊 + + var p = new PageModel { PageIndex = 1, PageSize = 2 }; // 鍒嗛〉鏌ヨ + var data5 = base.GetPageList(it => 1 == 1, p); + Console.Write(p.TotalCount); //杩斿洖鎬绘暟 + + var data6 = + base.GetPageList(it => 1 == 1, p, + it => SqlFunc.GetRandom()); // 鍒嗛〉鏌ヨ鍔犳帓搴� + Console.Write(p.TotalCount); //杩斿洖鎬绘暟 + + var conModels = new List<IConditionalModel>(); //缁勮鏉′欢鏌ヨ浣滀负鏉′欢瀹炵幇 鍒嗛〉鏌ヨ鍔犳帓搴� + conModels.Add(new ConditionalModel + { + FieldName = typeof(MesInvItemMovesCDetails).GetProperties()[0].Name, + ConditionalType = ConditionalType.Equal, FieldValue = "1" + }); //id=1 + var data7 = base.GetPageList(conModels, p, it => SqlFunc.GetRandom()); + + AsQueryable().Where(x => 1 == 1) + .ToList(); //鏀寔浜嗚浆鎹㈡垚queryable,鎴戜滑鍙互鐢╭ueryable瀹炵幇澶嶆潅鍔熻兘 + + + /*********鎻掑叆*********/ + var insertData = new MesInvItemMovesCDetails(); //娴嬭瘯鍙傛暟 + var insertArray = new[] { insertData }; + base.Insert(insertData); //鎻掑叆 + base.InsertRange(insertArray); //鎵归噺鎻掑叆 + var id = base.InsertReturnIdentity(insertData); //鎻掑叆杩斿洖鑷鍒� + AsInsertable(insertData).ExecuteCommand(); //鎴戜滑鍙互杞垚 Insertable瀹炵幇澶嶆潅鎻掑叆 + + + /*********鏇存柊*********/ + var updateData = new MesInvItemMovesCDetails(); //娴嬭瘯鍙傛暟 + var updateArray = new[] { updateData }; //娴嬭瘯鍙傛暟 + base.Update(updateData); //鏍规嵁瀹炰綋鏇存柊 + base.UpdateRange(updateArray); //鎵归噺鏇存柊 + //base.Update(it => new MesInvItemMovesCDetails() { ClassName = "a", CreateTime = DateTime.Now }, it => it.id==1);// 鍙洿鏂癈lassName鍒楀拰CreateTime鍒楋紝鍏跺畠鍒椾笉鏇存柊锛屾潯浠秈d=1 + AsUpdateable(updateData).ExecuteCommand(); //杞垚Updateable鍙互瀹炵幇澶嶆潅鐨勬彃鍏� + + + /*********鍒犻櫎*********/ + var deldata = new MesInvItemMovesCDetails(); //娴嬭瘯鍙傛暟 + base.Delete(deldata); //鏍规嵁瀹炰綋鍒犻櫎 + base.DeleteById(1); //鏍规嵁涓婚敭鍒犻櫎 + base.DeleteById(new[] { 1, 2 }); //鏍规嵁涓婚敭鏁扮粍鍒犻櫎 + base.Delete(it => 1 == 2); //鏍规嵁鏉′欢鍒犻櫎 + AsDeleteable().Where(it => 1 == 2) + .ExecuteCommand(); //杞垚Deleteable瀹炵幇澶嶆潅鐨勬搷浣� + } + + #endregion +} \ No newline at end of file diff --git a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs new file mode 100644 index 0000000..59d36c3 --- /dev/null +++ b/MES.Service/service/Warehouse/MesInvItemMovesManager.cs @@ -0,0 +1,45 @@ +锘縰sing MES.Service.DB; +using MES.Service.Dto.service; +using MES.Service.Modes; +using SqlSugar; + +namespace MES.Service.service.Warehouse; + +public class MesInvItemMovesManager : Repository<MesInvItemMoves> +{ + //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉� + + //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemMovesManager.cs + + public List<MesInvItemMoves> GetBillNo(WarehouseQuery query) + { + query.Factory = "1000"; + query.Company = "1000"; + + return Db.Queryable<MesInvItemMoves>() + .Where(it => + SqlFunc.IsNull(it.Status, 0) == 1 && + SqlFunc.IsNull(it.Ts, 0) != 1) + .Where(it => + it.Factory == query.Factory && it.Company == query.Company) + .OrderBy(it => it.Id, OrderByType.Desc).ToList(); + } + + //scan_out_show_DB + public List<InventoryItem> ScanOutShowDb(WarehouseQuery query) + { + var BillTypeId = 300; + var TransctionNo = 301; + query.Factory = "1000"; + query.Company = "1000"; + + var sql = string.Format( + "select f_get_sections_code({0}, {1}, b.item_no) sections_code , s.erp_item_no , S.ITEM_MODEL , to_char(nvl(b.quantity, 0) - nvl(quantity_ok, 0), 'FM9999999990.00') flist from mes_inv_item_moves a join mes_inv_item_out_items b on b.item_out_id = a.id join mes_items s on b.item_no = s.item_no left join (select ITEM_MOVE_ID, item_no, sum(quantity) quantity_ok from MES_INV_ITEM_MOVES_C_DETAILS group by ITEM_MOVE_ID, item_no) c on c.ITEM_MOVE_ID = a.id and b.item_no = c.item_no where 1 = 1 and a.bill_type_id = {2} and a.transaction_no = {3} and a.bill_no = {4} and nvl(b.quantity, 0) - nvl(quantity_ok, 0) > 0 and rownum < 500 AND A.STATUS = 1 order by f_get_sections_code({0}, {1}, b.item_no), s.erp_item_no ", + query.Factory, query.Company, BillTypeId, TransctionNo, + query.billNo); + + var results = Db.Ado.SqlQuery<InventoryItem>(sql); + + return results; + } +} \ No newline at end of file diff --git a/MES.Service/service/Warehouse/OpeningReceiptServer.cs b/MES.Service/service/Warehouse/OpeningReceiptServer.cs index 74dc31e..d525417 100644 --- a/MES.Service/service/Warehouse/OpeningReceiptServer.cs +++ b/MES.Service/service/Warehouse/OpeningReceiptServer.cs @@ -18,37 +18,26 @@ public MesInvItemBarcodes ScanInBarcodeQC(WarehouseQuery query) { if (string.IsNullOrWhiteSpace(query.sectionCode)) - { throw new Exception("璇锋壂搴撲綅鏉$爜锛�"); - } var depotCode = GetDepotCode(query.sectionCode); if (depotCode == null) - { throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒"); - } var checkBarcodeAlreadyReceived = CheckBarcodeAlreadyReceived(query.barcode); - if (checkBarcodeAlreadyReceived > 0) - { - throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�"); - } + if (checkBarcodeAlreadyReceived > 0) throw new Exception("鏉$爜閲嶅鎵弿锛岃鏍稿锛�"); if (CheckBarcodeInStock(query.barcode) > 0) - { throw new Exception("鏉$爜宸插湪搴撳瓨涓紝璇锋牳瀵癸紒"); - } var barcodeInfo = GetBarcodeInfo(query.barcode); if (barcodeInfo == null || barcodeInfo.ComeFlg != 0) - { throw new Exception("鏉$爜涓嶆槸鏈熷垵鏉$爜锛屾棤娉曠敤鏈熷垵鍏ュ簱锛�"); - } var inventoryItemInId = GetOrCreateInventoryItemInId(barcodeInfo, - depotCode, query.userName, out string billNo); + depotCode, query.userName, out var billNo); UseTransaction(db => { @@ -71,15 +60,12 @@ var mesInvItemBarcodes = Db.Queryable<MesInvItemBarcodes>() .Where(s => s.ItemBarcode == query.barcode).Count(); - if (mesInvItemBarcodes <= 0) - { - throw new Exception("鏉$爜涓嶅瓨鍦�"); - } + if (mesInvItemBarcodes <= 0) throw new Exception("鏉$爜涓嶅瓨鍦�"); var mesInvItemInCDetails = Db.Queryable<MesInvItemInCDetails>() .Where(s => s.ItemBarcode == query.barcode).Single(); - PurchaseInventory entity = new PurchaseInventory + var entity = new PurchaseInventory { ItemIns = GetMesInvItemIns(mesInvItemInCDetails.ItemInId), InvItemInCDetails = @@ -153,10 +139,7 @@ TaskNo = barcodeInfo.TaskNo }).ExecuteCommand(); - if (executeCommand <= 0) - { - throw new Exception("鍐欏叆澶辫触"); - } + if (executeCommand <= 0) throw new Exception("鍐欏叆澶辫触"); } private decimal GetOrCreateInventoryItemInId(MesInvItemBarcodes barcodeInfo, @@ -264,10 +247,7 @@ SuppNo = barcodeInfo.SuppNo }).ExecuteCommand(); - if (executeCommand <= 0) - { - throw new Exception("鍐欏叆澶辫触"); - } + if (executeCommand <= 0) throw new Exception("鍐欏叆澶辫触"); } private void InsertBusinessRecord(MesInvItemBarcodes barcodeInfo, @@ -300,9 +280,6 @@ SuppNo = barcodeInfo.SuppNo }).ExecuteCommand(); - if (executeCommand <= 0) - { - throw new Exception("鍐欏叆澶辫触"); - } + if (executeCommand <= 0) throw new Exception("鍐欏叆澶辫触"); } } \ No newline at end of file diff --git a/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs b/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs index 8819082..0cfbcc2 100644 --- a/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs +++ b/MESApplication/Controllers/Warehouse/MesDepotSectionsController.cs @@ -16,6 +16,48 @@ /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/ + //ScanInDepotSectionsName + [HttpPost("ScanInDepotSectionsName")] + public ResponseResult ScanInDepotSectionsName(WarehouseQuery query) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.ScanInDepotSectionsName(query); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + //ScanEditBarcode + [HttpPost("ScanEditBarcode")] + public ResponseResult ScanEditBarcode(WarehouseQuery query) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.ScanEditBarcode(query); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + //GetSectionName [HttpPost("GetSectionName")] public ResponseResult GetSectionName(WarehouseQuery query) diff --git a/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs b/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs index c50ee43..bbcda91 100644 --- a/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs +++ b/MESApplication/Controllers/Warehouse/MesInvBusiness2Controller.cs @@ -1,170 +1,162 @@ -锘縰sing Microsoft.AspNetCore.Mvc; -using Microsoft.Extensions.Logging; -using SqlSugar; -using System; -using System.Collections.Generic; -using System.Linq; -using System.Threading.Tasks; -using System.Dynamic; +锘縰sing System.Dynamic; using MES.Service.Modes; -using MES.Service.service; using MES.Service.service.Warehouse; using MES.Service.util; +using Microsoft.AspNetCore.Mvc; -namespace MESApplication.Controllers.Warehouse +namespace MESApplication.Controllers.Warehouse; + +[ApiController] +[Route("api/[controller]")] +public class MesInvBusiness2Controller : ControllerBase { - [ApiController] - [Route("api/[controller]")] - public class MesInvBusiness2Controller : ControllerBase + private readonly MesInvBusiness2Manager m = new(); + + + /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/ + + /// <summary> + /// 鑾峰彇鎵�鏈� + /// </summary> + /// <returns></returns> + [HttpPost("GetList")] + public ResponseResult GetList() { - - private MesInvBusiness2Manager m = new MesInvBusiness2Manager(); - - - /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/ - - /// <summary> - /// 鑾峰彇鎵�鏈� - /// </summary> - /// <returns></returns> - [HttpPost("GetList")] - public ResponseResult GetList() + try { - try + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetList(); + return new ResponseResult { - dynamic resultInfos = new ExpandoObject(); - resultInfos.tbBillList = m.GetList(); - return new ResponseResult - { - status = 0, - message = "OK", - data = resultInfos - }; - } - catch (Exception ex) - { - return ResponseResult.ResponseError(ex); - } + status = 0, + message = "OK", + data = resultInfos + }; } - - - /// <summary> - /// 鏍规嵁涓婚敭鑾峰彇 - /// </summary> - /// <returns></returns> - [HttpPost("GetById")] - public ResponseResult GetById(int id) + catch (Exception ex) { - try - { - dynamic resultInfos = new ExpandoObject(); - resultInfos.tbBillList = m.GetById(id); - return new ResponseResult - { - status = 0, - message = "OK", - data = resultInfos - }; - } - catch (Exception ex) - { - return ResponseResult.ResponseError(ex); - } - } - - /// <summary> - /// 鏍规嵁涓婚敭鍒犻櫎 - /// </summary> - /// <returns></returns> - [HttpPost("DeleteByIds")] - public ResponseResult DeleteByIds([FromBody] object[] ids) - { - try - { - dynamic resultInfos = new ExpandoObject(); - resultInfos.tbBillList = m.DeleteByIds(ids); - return new ResponseResult - { - status = 0, - message = "OK", - data = resultInfos - }; - } - catch (Exception ex) - { - return ResponseResult.ResponseError(ex); - } - } - - /// <summary> - /// 娣诲姞 - /// </summary> - /// <returns></returns> - [HttpPost("Insert")] - public ResponseResult Add([FromBody] MesInvBusiness2 data) - { - try - { - dynamic resultInfos = new ExpandoObject(); - resultInfos.tbBillList = m.Insert(data); - return new ResponseResult - { - status = 0, - message = "OK", - data = resultInfos - }; - } - catch (Exception ex) - { - return ResponseResult.ResponseError(ex); - } - } - /// <summary> - /// 娣诲姞杩斿洖鑷 - /// </summary> - /// <returns></returns> - [HttpPost("InsertReturnIdentity")] - public ResponseResult InsertReturnIdentity([FromBody] MesInvBusiness2 data) - { - try - { - dynamic resultInfos = new ExpandoObject(); - resultInfos.tbBillList = m.InsertReturnIdentity(data); - return new ResponseResult - { - status = 0, - message = "OK", - data = resultInfos - }; - } - catch (Exception ex) - { - return ResponseResult.ResponseError(ex); - } - } - - /// <summary> - /// 淇敼 - /// </summary> - /// <returns></returns> - [HttpPost("Update")] - public ResponseResult Update([FromBody] MesInvBusiness2 data) - { - try - { - dynamic resultInfos = new ExpandoObject(); - resultInfos.tbBillList = m.Update(data); - return new ResponseResult - { - status = 0, - message = "OK", - data = resultInfos - }; - } - catch (Exception ex) - { - return ResponseResult.ResponseError(ex); - } + return ResponseResult.ResponseError(ex); } } -} + + + /// <summary> + /// 鏍规嵁涓婚敭鑾峰彇 + /// </summary> + /// <returns></returns> + [HttpPost("GetById")] + public ResponseResult GetById(int id) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetById(id); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 鏍规嵁涓婚敭鍒犻櫎 + /// </summary> + /// <returns></returns> + [HttpPost("DeleteByIds")] + public ResponseResult DeleteByIds([FromBody] object[] ids) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.DeleteByIds(ids); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 娣诲姞 + /// </summary> + /// <returns></returns> + [HttpPost("Insert")] + public ResponseResult Add([FromBody] MesInvBusiness2 data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.Insert(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 娣诲姞杩斿洖鑷 + /// </summary> + /// <returns></returns> + [HttpPost("InsertReturnIdentity")] + public ResponseResult InsertReturnIdentity([FromBody] MesInvBusiness2 data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.InsertReturnIdentity(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 淇敼 + /// </summary> + /// <returns></returns> + [HttpPost("Update")] + public ResponseResult Update([FromBody] MesInvBusiness2 data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.Update(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } +} \ No newline at end of file diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs new file mode 100644 index 0000000..fb0be61 --- /dev/null +++ b/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs @@ -0,0 +1,163 @@ +锘縰sing System.Dynamic; +using MES.Service.Modes; +using MES.Service.service.Warehouse; +using MES.Service.util; +using Microsoft.AspNetCore.Mvc; + +namespace MESApplication.Controllers.Warehouse; + +[ApiController] +[Route("api/[controller]")] +public class MesInvItemMovesCDetailsController : ControllerBase +{ + private readonly MesInvItemMovesCDetailsManager m = new(); + + + /***杩涘叆妯$増绠$悊鍙互淇敼妯$増***/ + + /// <summary> + /// 鑾峰彇鎵�鏈� + /// </summary> + /// <returns></returns> + [HttpPost("GetList")] + public ResponseResult GetList() + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetList(); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + + /// <summary> + /// 鏍规嵁涓婚敭鑾峰彇 + /// </summary> + /// <returns></returns> + [HttpPost("GetById")] + public ResponseResult GetById(int id) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetById(id); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 鏍规嵁涓婚敭鍒犻櫎 + /// </summary> + /// <returns></returns> + [HttpPost("DeleteByIds")] + public ResponseResult DeleteByIds([FromBody] object[] ids) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.DeleteByIds(ids); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 娣诲姞 + /// </summary> + /// <returns></returns> + [HttpPost("Insert")] + public ResponseResult Add([FromBody] MesInvItemMovesCDetails data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.Insert(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 娣诲姞杩斿洖鑷 + /// </summary> + /// <returns></returns> + [HttpPost("InsertReturnIdentity")] + public ResponseResult InsertReturnIdentity( + [FromBody] MesInvItemMovesCDetails data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.InsertReturnIdentity(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 淇敼 + /// </summary> + /// <returns></returns> + [HttpPost("Update")] + public ResponseResult Update([FromBody] MesInvItemMovesCDetails data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.Update(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } +} \ No newline at end of file diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs new file mode 100644 index 0000000..d8106fb --- /dev/null +++ b/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs @@ -0,0 +1,204 @@ +锘縰sing System.Dynamic; +using MES.Service.Dto.service; +using MES.Service.Modes; +using MES.Service.service.Warehouse; +using MES.Service.util; +using Microsoft.AspNetCore.Mvc; + +namespace MESApplication.Controllers.Warehouse; + +[ApiController] +[Route("api/[controller]")] +public class MesInvItemMovesController : ControllerBase +{ + private readonly MesInvItemMovesManager m = new(); + + // GetBillNo + [HttpPost("GetBillNo")] + public ResponseResult GetBillNo(WarehouseQuery query) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetBillNo(query); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + //ScanOutShowDb + [HttpPost("ScanOutShowDb")] + public ResponseResult ScanOutShowDb(WarehouseQuery query) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetBillNo(query); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + + /// <summary> + /// 鑾峰彇鎵�鏈� + /// </summary> + /// <returns></returns> + [HttpPost("GetList")] + public ResponseResult GetList() + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetList(); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + + /// <summary> + /// 鏍规嵁涓婚敭鑾峰彇 + /// </summary> + /// <returns></returns> + [HttpPost("GetById")] + public ResponseResult GetById(int id) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.GetById(id); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 鏍规嵁涓婚敭鍒犻櫎 + /// </summary> + /// <returns></returns> + [HttpPost("DeleteByIds")] + public ResponseResult DeleteByIds([FromBody] object[] ids) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.DeleteByIds(ids); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 娣诲姞 + /// </summary> + /// <returns></returns> + [HttpPost("Insert")] + public ResponseResult Add([FromBody] MesInvItemMoves data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.Insert(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 娣诲姞杩斿洖鑷 + /// </summary> + /// <returns></returns> + [HttpPost("InsertReturnIdentity")] + public ResponseResult InsertReturnIdentity( + [FromBody] MesInvItemMoves data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.InsertReturnIdentity(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } + + /// <summary> + /// 淇敼 + /// </summary> + /// <returns></returns> + [HttpPost("Update")] + public ResponseResult Update([FromBody] MesInvItemMoves data) + { + try + { + dynamic resultInfos = new ExpandoObject(); + resultInfos.tbBillList = m.Update(data); + return new ResponseResult + { + status = 0, + message = "OK", + data = resultInfos + }; + } + catch (Exception ex) + { + return ResponseResult.ResponseError(ex); + } + } +} \ No newline at end of file diff --git a/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs b/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs index 9ed6425..cda99fa 100644 --- a/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs +++ b/MESApplication/Controllers/Warehouse/OpeningReceiptController.cs @@ -31,7 +31,7 @@ return ResponseResult.ResponseError(ex); } } - + [HttpPost("GetForm")] public ResponseResult GetForm(WarehouseQuery query) { -- Gitblit v1.9.3