From 5de35354e8dfcb4933350d0d1b645d400bcf23ab Mon Sep 17 00:00:00 2001
From: sjz <1240968267@qq.com>
Date: 星期二, 22 七月 2025 15:30:09 +0800
Subject: [PATCH] 优化多组织
---
MESApplication/bin/Release/net8.0/MESApplication.exe | 0
MES.Service/Dto/webApi/FbsDb/FbsDbA.cs | 23 ++
MESApplication/Controllers/FBSDB/FbsDbController.cs | 6
MES.Service/service/BasicData/MesStaffManager.cs | 7
MESApplication/MESApplication.csproj | 8
MESApplication/bin/Release/net8.0/publish/MESApplication.pdb | 0
MESApplication/bin/Release/net8.0/MESApplication.xml | 72 -------
MESApplication/bin/Release/net8.0/publish/MESApplication.dll | 0
MES.Service/service/FBSDB/FbsDbManager.cs | 8
MESApplication/bin/Release/net8.0/MES.Service.dll | 0
MESApplication/bin/Release/net8.0/MESApplication.dll | 0
MES.Service/service/BasicData/MesCustomerManager.cs | 8
MESApplication/bin/Release/net8.0/publish/MES.Service.pdb | 0
MES.Service/service/BasicData/MesSupplierManager.cs | 8
MESApplication/bin/Release/net8.0/MES.Service.pdb | 0
MESApplication/bin/Release/net8.0/publish/MESApplication.exe | 0
MESApplication/bin/Release/net8.0/MESApplication.pdb | 0
MES.Service/service/BasicData/MesDepotsManager.cs | 8
MESApplication/bin/Release/net8.0/publish/MES.Service.dll | 0
MESApplication/bin/Release/net8.0/publish/MESApplication.xml | 72 -------
MES.Service/Dto/webApi/FbsDb/FbsDbB.cs | 22 ++
MES.Service/service/BasicData/SysDepartmentManager.cs | 8
MES.Service/MES.Service.csproj | 6
/dev/null | 306 ------------------------------
MES.Service/Modes/FBSDB/MesInvItemMoveItems.cs | 7
MESApplication/Properties/PublishProfiles/FolderProfile.pubxml.user | 2
MES.Service/bin/Release/net8.0/MES.Service.dll | 0
MES.Service/bin/Release/net8.0/MES.Service.pdb | 0
MES.Service/Dto/webApi/FbsDb/ErpDb.cs | 8
MES.Service/service/BasicData/MesItemsManager.cs | 8
MES.Service/Modes/FBSDB/MesInvItemMoves.cs | 8
31 files changed, 113 insertions(+), 482 deletions(-)
diff --git a/MES.Service/Dto/service/MovesDto.cs b/MES.Service/Dto/service/MovesDto.cs
deleted file mode 100644
index a36d0d2..0000000
--- a/MES.Service/Dto/service/MovesDto.cs
+++ /dev/null
@@ -1,15 +0,0 @@
-锘縰sing MES.Service.Modes;
-
-namespace MES.Service.Dto.service;
-
-public class MovesDto
-{
- //鍑哄叆鍗�
- public List<MesInvItemMoves>? FromList { get; set; }
- public List<MesInvItemOutItems>? OutItems { get; set; }
- public List<MesInvItemMovesCDetails>? BarcodeList { get; set; }
-
- //鍏ュ簱鍗�
- public bool? InAudit { get; set; }
- public MesInvItemBarcodes? BarcodesInfo { get; set; }
-}
\ No newline at end of file
diff --git a/MES.Service/Dto/webApi/FbsDb/ErpDb.cs b/MES.Service/Dto/webApi/FbsDb/ErpDb.cs
new file mode 100644
index 0000000..6b61c78
--- /dev/null
+++ b/MES.Service/Dto/webApi/FbsDb/ErpDb.cs
@@ -0,0 +1,8 @@
+锘�
+namespace MES.Service.Dto.webApi.FbsDb;
+
+public class ErpDb
+{
+ public FbsDbA FbsDbA { get; set; }
+ public List<FbsDbB> FbsDbBs { get; set; }
+}
diff --git a/MES.Service/Dto/webApi/FbsDb/FbsDbA.cs b/MES.Service/Dto/webApi/FbsDb/FbsDbA.cs
new file mode 100644
index 0000000..0e612ce
--- /dev/null
+++ b/MES.Service/Dto/webApi/FbsDb/FbsDbA.cs
@@ -0,0 +1,23 @@
+锘�
+
+namespace MES.Service.Dto.webApi.FbsDb;
+
+public class FbsDbA
+{
+ public string erpid { get; set; }
+ public string type { get; set; }
+ public string? FBillNo { get; set; }
+ public string? FBillTypeID { get; set; }
+ public string? FDocumentStatus { get; set; }
+ public string? FTransferDirect { get; set; }
+ public string? FTRANSTYPE { get; set; }
+ public string? FBusinessType { get; set; }
+ public string? sq_bm { get; set; }
+ public string? FAPPORGID { get; set; }
+ public string? FDate { get; set; }
+ public string? FCreateDate { get; set; }
+ public string? FOwnerTypeIdHead { get; set; }
+ public string? FOwnerTypeInIdHead { get; set; }
+ public string? FRemarks { get; set; }
+
+}
diff --git a/MES.Service/Dto/webApi/FbsDb/FbsDbB.cs b/MES.Service/Dto/webApi/FbsDb/FbsDbB.cs
new file mode 100644
index 0000000..c3640e6
--- /dev/null
+++ b/MES.Service/Dto/webApi/FbsDb/FbsDbB.cs
@@ -0,0 +1,22 @@
+锘�
+namespace MES.Service.Dto.webApi.FbsDb;
+
+public class FbsDbB
+{
+ public string eid { get; set; }
+ public string erpid { get; set; }
+ public string? FMATERIALID { get; set; }
+ public string? FUNITID { get; set; }
+ public string? FQty { get; set; }
+ public string? FOwnerTypeId { get; set; }
+ public string? FOwnerId { get; set; }
+ public string? FStockId { get; set; }
+ public string? FOwnerTypeInId { get; set; }
+ public string? FOwnerInId { get; set; }
+ public string? FStockInId { get; set; }
+ public string? FNote { get; set; }
+ public string? FStockOrgId { get; set; }
+ public string? FStockOrgInId { get; set; }
+ public string? FLot { get; set; }
+ public string? FMtoNo { get; set; }
+}
diff --git a/MES.Service/MES.Service.csproj b/MES.Service/MES.Service.csproj
index f2b5b6a..95e220e 100644
--- a/MES.Service/MES.Service.csproj
+++ b/MES.Service/MES.Service.csproj
@@ -7,12 +7,12 @@
</PropertyGroup>
<ItemGroup>
- <PackageReference Include="Masuit.Tools.Core" Version="2024.3.4"/>
- <PackageReference Include="SqlSugarCore" Version="5.1.4.158"/>
+ <PackageReference Include="Masuit.Tools.Core" Version="2024.3.4" />
+ <PackageReference Include="SqlSugarCore" Version="5.1.4.158" />
</ItemGroup>
<ItemGroup>
- <Folder Include="DB\Scripts\"/>
+ <Folder Include="DB\Scripts\" />
</ItemGroup>
</Project>
diff --git a/MES.Service/Modes/FBSDB/MesInvItemMoveItems.cs b/MES.Service/Modes/FBSDB/MesInvItemMoveItems.cs
new file mode 100644
index 0000000..bfab43e
--- /dev/null
+++ b/MES.Service/Modes/FBSDB/MesInvItemMoveItems.cs
@@ -0,0 +1,7 @@
+锘�
+namespace MES.Service.Modes.FBSDB;
+
+internal class MesInvItemMoveItems
+{
+
+}
diff --git a/MES.Service/Modes/FBSDB/MesInvItemMoves.cs b/MES.Service/Modes/FBSDB/MesInvItemMoves.cs
new file mode 100644
index 0000000..f78f0c0
--- /dev/null
+++ b/MES.Service/Modes/FBSDB/MesInvItemMoves.cs
@@ -0,0 +1,8 @@
+锘�
+
+namespace MES.Service.Modes.FBSDB;
+
+internal class MesInvItemMoves
+{
+
+}
diff --git a/MES.Service/Modes/MesInvItemMoves.cs b/MES.Service/Modes/MesInvItemMoves.cs
deleted file mode 100644
index b65928e..0000000
--- a/MES.Service/Modes/MesInvItemMoves.cs
+++ /dev/null
@@ -1,178 +0,0 @@
-锘縰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>
- /// 鍏徃浠ｇ爜
- /// </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
deleted file mode 100644
index 1fc798b..0000000
--- a/MES.Service/Modes/MesInvItemMovesCDetails.cs
+++ /dev/null
@@ -1,237 +0,0 @@
-锘縰sing SqlSugar;
-
-namespace MES.Service.Modes;
-
-/// <summary>
-/// 鐗╂枡绉诲簱鏉＄爜鏄庣粏浠庤〃
-/// </summary>
-[SugarTable("MES_INV_ITEM_MOVES_C_DETAILS")]
-public class MesInvItemMovesCDetails
-{
- /// <summary>
- /// seq_inv_id
- /// </summary>
- [SugarColumn(ColumnName = "ID", OracleSequenceName = "SEQ_INV_ID",
- IsPrimaryKey = true)]
- public decimal Id { get; set; }
-
- /// <summary>
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_MOVE_ID")]
- public decimal? ItemMoveId { get; set; }
-
- /// <summary>
- /// 鐗╂枡鏉＄爜
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_BARCODE")]
- public string? ItemBarcode { get; set; }
-
- /// <summary>
- /// 瀹㈡埛鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "C_ITEM_CODE")]
- public string? CItemCode { get; set; }
-
- /// <summary>
- /// 淇″崕鐗╂枡缂栫爜锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "ITEM_NO")]
- public string? ItemNo { get; set; }
-
- /// <summary>
- /// 鍘傚鎵规
- /// </summary>
- [SugarColumn(ColumnName = "LOT_NO")]
- public string? LotNo { get; set; }
-
- /// <summary>
- /// 鏁伴噺锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "QUANTITY")]
- public decimal? Quantity { get; set; }
-
- /// <summary>
- /// 鍑哄簱鏂瑰紡(1:鏈夋潯鐮�,0:鏃犳潯鐮�)
- /// </summary>
- [SugarColumn(ColumnName = "BARCODE_FLAG")]
- public short? BarcodeFlag { get; set; }
-
- /// <summary>
- /// 鐜繚鏍囧織锛堟棤鏉＄爜鎵嬪伐褰曞叆锛屾湁鏉＄爜涓哄啑浣欏瓧娈碉級
- /// </summary>
- [SugarColumn(ColumnName = "EP_FLAG")]
- public short? EpFlag { get; set; }
-
- /// <summary>
- /// 鍒涘缓浜�
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_BY")]
- public string? CreateBy { get; set; }
-
- /// <summary>
- /// 鍒涘缓鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "CREATE_DATE")]
- public DateTime? CreateDate { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂颁汉
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_BY")]
- public string? LastupdateBy { get; set; }
-
- /// <summary>
- /// 鏈�鍚庢洿鏂版椂闂�
- /// </summary>
- [SugarColumn(ColumnName = "LASTUPDATE_DATE")]
- public DateTime? LastupdateDate { get; set; }
-
- /// <summary>
- /// 瀛愬簱id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_ID")]
- public decimal? InvDepotsId { get; set; }
-
- /// <summary>
- /// 璐т綅id
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_ID")]
- public decimal? InvDepotSectionsId { get; set; }
-
- /// <summary>
- /// 瀹㈡埛缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "CUST_NO")]
- public string? CustNo { get; set; }
-
- /// <summary>
- /// 浠诲姟浠ゅ彿
- /// </summary>
- [SugarColumn(ColumnName = "TASK_NO")]
- public string? TaskNo { get; set; }
-
- /// <summary>
- /// 绉诲嚭浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOTS_CODE")]
- public string? FromDepotsCode { get; set; }
-
- /// <summary>
- /// 绉诲嚭搴撲綅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FROM_DEPOT_SECTIONS_CODE")]
- public string? FromDepotSectionsCode { get; set; }
-
- /// <summary>
- /// 鏉＄爜澶囨敞
- /// </summary>
- [SugarColumn(ColumnName = "REMARK")]
- public string? Remark { get; set; }
-
- /// <summary>
- /// 鍒嗗巶缂栫爜
- /// </summary>
- [SugarColumn(ColumnName = "FACTORY")]
- public string? Factory { get; set; }
-
- /// <summary>
- /// 鍏徃浠ｇ爜
- /// </summary>
- [SugarColumn(ColumnName = "COMPANY")]
- public string? Company { get; set; }
-
- /// <summary>
- /// 绠卞彿
- /// </summary>
- [SugarColumn(ColumnName = "BOX_NO")]
- public string? BoxNo { get; set; }
-
- /// <summary>
- /// 鍗℃澘鍙�
- /// </summary>
- [SugarColumn(ColumnName = "KO_NO")]
- public string? KoNo { get; set; }
-
- /// <summary>
- /// 绉诲叆浠撳簱缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOTS_CODE")]
- public string? InvDepotsCode { get; set; }
-
- /// <summary>
- /// 绉诲叆搴撲綅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "INV_DEPOT_SECTIONS_CODE")]
- public string? InvDepotSectionsCode { get; set; }
-
- /// <summary>
- /// 璐ㄦ缁撴灉
- /// </summary>
- [SugarColumn(ColumnName = "IQC_STATUS")]
- public string? IqcStatus { get; set; }
-
- /// <summary>
- /// 灏忚溅缂栧彿
- /// </summary>
- [SugarColumn(ColumnName = "FCAR")]
- public string? Fcar { get; set; }
-
- /// <summary>
- /// 鍏ュ簱鏃ユ湡
- /// </summary>
- [SugarColumn(ColumnName = "INDEP_DATE")]
- public DateTime? IndepDate { get; set; }
-
- /// <summary>
- /// 鍐荤粨鎻愪氦閲嶆锛�0锛氬喕缁撴湭鎻愪氦閲嶆锛�1锛氬喕缁撳苟鎻愪氦閲嶆
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT")]
- public short? VisableSubmit { get; set; }
-
- /// <summary>
- /// 鎻愪氦閲嶆浜�
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_BY")]
- public string? VisableSubmitBy { get; set; }
-
- /// <summary>
- /// 鎻愪氦閲嶆鏃堕棿
- /// </summary>
- [SugarColumn(ColumnName = "VISABLE_SUBMIT_DATE")]
- public DateTime? VisableSubmitDate { get; set; }
-
- /// <summary>
- /// 浜у搧鍨嬪彿
- /// </summary>
- [SugarColumn(ColumnName = "BOARD_STYLE")]
- public string? BoardStyle { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曞彿
- /// </summary>
- [SugarColumn(ColumnName = "WORK_NO")]
- public string? WorkNo { get; set; }
-
- /// <summary>
- /// 浠诲姟鍗曡鍙�
- /// </summary>
- [SugarColumn(ColumnName = "WORK_LINE")]
- public decimal? WorkLine { get; set; }
-
- /// <summary>
- /// 渚涘簲鍟嗙紪鍙�
- /// </summary>
- [SugarColumn(ColumnName = "SUPP_NO")]
- public string? SuppNo { get; set; }
-
- /// <summary>
- /// 璋冨叆
- /// </summary>
- [SugarColumn(ColumnName = "MOVE_OK")]
- public decimal? MoveOk { get; set; }
-
- [SugarColumn(IsIgnore = true)] public string? ItemName { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemModel { get; set; }
- [SugarColumn(IsIgnore = true)] public string? ItemUnit { get; set; }
- [SugarColumn(IsIgnore = true)] public string? SuppName { get; set; }
-}
\ No newline at end of file
diff --git a/MES.Service/bin/Release/net8.0/MES.Service.dll b/MES.Service/bin/Release/net8.0/MES.Service.dll
index 4542b0f..16647e7 100644
--- a/MES.Service/bin/Release/net8.0/MES.Service.dll
+++ b/MES.Service/bin/Release/net8.0/MES.Service.dll
Binary files differ
diff --git a/MES.Service/bin/Release/net8.0/MES.Service.pdb b/MES.Service/bin/Release/net8.0/MES.Service.pdb
index c926788..bc98886 100644
--- a/MES.Service/bin/Release/net8.0/MES.Service.pdb
+++ b/MES.Service/bin/Release/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MES.Service/service/BasicData/MesCustomerManager.cs b/MES.Service/service/BasicData/MesCustomerManager.cs
index e3f3404..724eac6 100644
--- a/MES.Service/service/BasicData/MesCustomerManager.cs
+++ b/MES.Service/service/BasicData/MesCustomerManager.cs
@@ -92,10 +92,10 @@
private bool InsertCustomer(SqlSugarScope db, MesCustomer entity)
{
- var exists = db.Queryable<MesCustomer>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesCustomer>().Any(e => e.Id == entity.Id && e.CustNo==entity.CustNo);
if (exists)
{
- var result = db.Updateable(entity).ExecuteCommand();
+ var result = db.Updateable(entity).Where(e => e.Id == entity.Id && e.CustNo == entity.CustNo).ExecuteCommand();
return true;
}
else
@@ -113,10 +113,10 @@
}
private bool InsertOrUpdate(SqlSugarScope db, MesCustomer entity)
{
- var exists = db.Queryable<MesCustomer>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesCustomer>().Any(e => e.Id == entity.Id && e.CustNo == entity.CustNo);
if (exists)
{
- var update = db.Updateable(entity).ExecuteCommand();
+ var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.CustNo == entity.CustNo).ExecuteCommand();
return true;
}
else
diff --git a/MES.Service/service/BasicData/MesDepotsManager.cs b/MES.Service/service/BasicData/MesDepotsManager.cs
index 0aea512..ae137ed 100644
--- a/MES.Service/service/BasicData/MesDepotsManager.cs
+++ b/MES.Service/service/BasicData/MesDepotsManager.cs
@@ -53,10 +53,10 @@
// 鎻掑叆鏂颁粨搴撶殑鏂规硶
private bool InsertDepot(SqlSugarScope db, MesDepots entity)
{
- var exists = db.Queryable<MesDepots>().Any(e => e.DepotId == entity.DepotId);
+ var exists = db.Queryable<MesDepots>().Any(e => e.DepotId == entity.DepotId && e.DepotCode == entity.DepotCode);
if (exists)
{
- var result = db.Updateable(entity).ExecuteCommand();
+ var result = db.Updateable(entity).Where(e => e.DepotId == entity.DepotId && e.DepotCode == entity.DepotCode).ExecuteCommand();
return true;
}
else
@@ -76,10 +76,10 @@
// 鎻掑叆鎴栨洿鏂颁粨搴撶殑鏂规硶
private bool InsertOrUpdate(SqlSugarScope db, MesDepots entity)
{
- var exists = db.Queryable<MesDepots>().Any(e => e.DepotId == entity.DepotId);
+ var exists = db.Queryable<MesDepots>().Any(e => e.DepotId == entity.DepotId && e.DepotCode == entity.DepotCode);
if (exists)
{
- var update = db.Updateable(entity).ExecuteCommand();
+ var update = db.Updateable(entity).Where(e => e.DepotId == entity.DepotId && e.DepotCode == entity.DepotCode).ExecuteCommand();
return true;
}
else
diff --git a/MES.Service/service/BasicData/MesItemsManager.cs b/MES.Service/service/BasicData/MesItemsManager.cs
index f6efbc5..5ed04ff 100644
--- a/MES.Service/service/BasicData/MesItemsManager.cs
+++ b/MES.Service/service/BasicData/MesItemsManager.cs
@@ -96,10 +96,10 @@
private bool InsertItem(SqlSugarScope db, MesItems entity)
{
- var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id && e.ItemNo==entity.ItemNo);
if (exists)
{
- var result = db.Updateable(entity).ExecuteCommand();
+ var result = db.Updateable(entity).Where(e => e.Id == entity.Id && e.ItemNo == entity.ItemNo).ExecuteCommand();
return true;
}
else
@@ -118,10 +118,10 @@
private bool InsertOrUpdate(SqlSugarScope db, MesItems entity)
{
- var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesItems>().Any(e => e.Id == entity.Id && e.ItemNo==entity.ItemNo);
if (exists)
{
- var update = db.Updateable(entity).ExecuteCommand();
+ var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.ItemNo == entity.ItemNo).ExecuteCommand();
return true;
}
else
diff --git a/MES.Service/service/BasicData/MesStaffManager.cs b/MES.Service/service/BasicData/MesStaffManager.cs
index 52a57c9..28a1ef5 100644
--- a/MES.Service/service/BasicData/MesStaffManager.cs
+++ b/MES.Service/service/BasicData/MesStaffManager.cs
@@ -42,8 +42,7 @@
}
// 鏇存柊鍛樺伐鐘舵�佺殑鏂规硶
- private bool UpdateStaffStatus(SqlSugarScope db, decimal staffId,
- string status)
+ private bool UpdateStaffStatus(SqlSugarScope db, decimal staffId,string status)
{
var result = db.Updateable<MesStaff>().SetColumns(s => s.FforbidStatus == status).Where(s => s.Id == staffId).ExecuteCommand();
return true;
@@ -52,10 +51,10 @@
// 鎻掑叆鎴栨洿鏂板憳宸ョ殑鏂规硶
private bool InsertOrUpdateStaff(SqlSugarScope db, MesStaff entity)
{
- var exists = db.Queryable<MesStaff>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesStaff>().Any(e => e.Id == entity.Id && e.StaffNo==entity.StaffNo);
if (exists)
{
- var update = db.Updateable(entity).ExecuteCommand();
+ var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.StaffNo == entity.StaffNo).ExecuteCommand();
return true;
}
else
diff --git a/MES.Service/service/BasicData/MesSupplierManager.cs b/MES.Service/service/BasicData/MesSupplierManager.cs
index d284c46..6ce5efc 100644
--- a/MES.Service/service/BasicData/MesSupplierManager.cs
+++ b/MES.Service/service/BasicData/MesSupplierManager.cs
@@ -89,10 +89,10 @@
private bool InsertSupplier(SqlSugarScope db, MesSupplier entity)
{
- var exists = db.Queryable<MesSupplier>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesSupplier>().Any(e => e.Id == entity.Id && e.SuppNo == entity.SuppNo);
if (exists)
{
- var result = db.Updateable(entity).ExecuteCommand();
+ var result = db.Updateable(entity).Where(e => e.Id == entity.Id && e.SuppNo == entity.SuppNo).ExecuteCommand();
return true;
}
else
@@ -111,10 +111,10 @@
private bool InsertOrUpdate(SqlSugarScope db, MesSupplier entity)
{
- var exists = db.Queryable<MesSupplier>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<MesSupplier>().Any(e => e.Id == entity.Id && e.SuppNo == entity.SuppNo);
if (exists)
{
- var update = db.Updateable(entity).ExecuteCommand();
+ var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.SuppNo == entity.SuppNo).ExecuteCommand();
return true;
}
else
diff --git a/MES.Service/service/BasicData/SysDepartmentManager.cs b/MES.Service/service/BasicData/SysDepartmentManager.cs
index bb87f41..5fda40f 100644
--- a/MES.Service/service/BasicData/SysDepartmentManager.cs
+++ b/MES.Service/service/BasicData/SysDepartmentManager.cs
@@ -58,10 +58,10 @@
// 鎻掑叆鏂伴儴闂ㄧ殑鏂规硶
private bool InsertDepartment(SqlSugarScope db, SysDepartment entity)
{
- var exists = db.Queryable<SysDepartment>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<SysDepartment>().Any(e => e.Id == entity.Id && e.Departmentcode==entity.Departmentcode);
if (exists)
{
- var result = db.Updateable(entity).ExecuteCommand();
+ var result = db.Updateable(entity).Where(e => e.Id == entity.Id && e.Departmentcode == entity.Departmentcode).ExecuteCommand();
return true;
}
else
@@ -81,10 +81,10 @@
// 鎻掑叆鎴栨洿鏂伴儴闂ㄧ殑鏂规硶
private bool InsertOrUpdateDepartment(SqlSugarScope db,SysDepartment entity)
{
- var exists = db.Queryable<SysDepartment>().Any(e => e.Id == entity.Id);
+ var exists = db.Queryable<SysDepartment>().Any(e => e.Id == entity.Id && e.Departmentcode == entity.Departmentcode);
if (exists)
{
- var update = db.Updateable(entity).ExecuteCommand();
+ var update = db.Updateable(entity).Where(e => e.Id == entity.Id && e.Departmentcode == entity.Departmentcode).ExecuteCommand();
return true;
}
else
diff --git a/MES.Service/service/FBSDB/FbsDbManager.cs b/MES.Service/service/FBSDB/FbsDbManager.cs
new file mode 100644
index 0000000..8cfd820
--- /dev/null
+++ b/MES.Service/service/FBSDB/FbsDbManager.cs
@@ -0,0 +1,8 @@
+锘�
+
+namespace MES.Service.service.FBSDB;
+
+internal class FbsDbManager
+{
+
+}
diff --git a/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs b/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs
deleted file mode 100644
index cf8c2a3..0000000
--- a/MES.Service/service/Warehouse/MesInvItemMovesCDetailsManager.cs
+++ /dev/null
@@ -1,79 +0,0 @@
-锘縰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>
- /// 浠撳偍鏂规硶婊¤冻涓嶄簡澶嶆潅涓氬姟闇�姹傦紝涓氬姟浠ｇ爜璇峰湪杩欓噷闈㈠畾涔夋柟娉�
- /// </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
deleted file mode 100644
index 31c8488..0000000
--- a/MES.Service/service/Warehouse/MesInvItemMovesManager.cs
+++ /dev/null
@@ -1,504 +0,0 @@
-锘縰sing MES.Service.DB;
-using MES.Service.Dto.service;
-using MES.Service.Modes;
-using MES.Service.util;
-using SqlSugar;
-
-namespace MES.Service.service.Warehouse;
-
-public class MesInvItemMovesManager : Repository<MesInvItemMoves>
-{
- //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
-
- //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesInvItemMovesManager.cs
-
- public MovesDto ScanInBarcode(WarehouseQuery query)
- {
- if (string.IsNullOrEmpty(query.sectionCode))
- throw new Exception("璇锋壂搴撲綅鏉＄爜锛�");
-
- var pBillTypeId = 300;
- var pTransctionNo = 301;
-
- var depotQuery = Db.Queryable<MesDepotSections, MesDepots>((a, b) =>
- new JoinQueryInfos(
- JoinType.Inner, a.Zuid.ToString() == b.Zuid))
- .Where((a, b) => a.DepotSectionCode == query.sectionCode)
- .Select((a, b) => new { b.DepotCode })
- .First();
-
- if (depotQuery == null)
- throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
-
- var cDepotCode = depotQuery.DepotCode;
-
- // 鏌ヨ璋冩嫈鍏ュ簱淇℃伅
- var itemMoveQuery = Db
- .Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) =>
- new JoinQueryInfos(
- JoinType.Inner, a.Id == b.ItemMoveId))
- .Where((a, b) => b.ItemBarcode == query.barcode &&
- a.BillTypeId == pBillTypeId &&
- a.TransactionNo == pTransctionNo &&
- a.Status == 1 && SqlFunc.IsNull(b.MoveOk, 0) != 1)
- .Select((a, b) => new { a.Id, a.BillNo, a.InvDepotsCode })
- .First();
-
- if (itemMoveQuery == null) throw new Exception("鏉＄爜鏈仛璋冩嫈鍑哄簱鎵爜锛岃鏍稿锛�");
-
- var cBillNo = itemMoveQuery.BillNo;
- var iDepotCode = itemMoveQuery.InvDepotsCode;
-
- // 楠岃瘉搴撳尯涓庝粨搴�
- var depotValidationQuery = Db
- .Queryable<MesDepotSections, MesDepots>((a, b) =>
- new JoinQueryInfos(
- JoinType.Inner, a.Zuid.ToString() == b.Zuid))
- .Where((a, b) => a.DepotSectionCode == query.sectionCode &&
- b.DepotCode == iDepotCode)
- .Select((a, b) => new { b.DepotCode })
- .First();
-
- if (depotValidationQuery == null)
- throw new Exception($"002[搴撲綅缂栫爜 {query.sectionCode} 涓嶅瓨鍦紝璇风‘璁わ紒");
-
- if (iDepotCode != depotValidationQuery.DepotCode)
- throw new Exception("瀹為檯浠撳簱涓庣敵璇疯皟鍏ヤ粨搴撲笉绗︼紝璇锋牳瀵癸紒");
-
- var barcodeCount = Db.Queryable<MesInvItemMovesCDetails>()
- .Where(b =>
- b.ItemBarcode == query.barcode &&
- b.ItemMoveId == itemMoveQuery.Id && b.MoveOk == 1)
- .Count();
-
- if (barcodeCount > 0) throw new Exception("鏉＄爜璋冩嫈宸插畬鎴愶紝璇锋牳瀵癸紒");
-
- var barcodeInfo = Db.Queryable<MesInvItemBarcodes>()
- .Where(t => t.ItemBarcode == query.barcode)
- .First();
-
- if (barcodeInfo == null) throw new Exception("鏉＄爜涓嶅瓨鍦紝璇锋牳瀵癸紒");
-
- var isAudit = UseTransaction(db =>
- {
- // 鏇存柊涓氬姟銆佸簱瀛樺拰鏉＄爜鏁版嵁
- db.Updateable<MesInvBusiness2>()
- .SetColumns(b => new MesInvBusiness2
- {
- ToInvDepotsCode = cDepotCode,
- ToInvDepotSectionsCode = query.sectionCode
- })
- .Where(b =>
- b.BillNo == cBillNo && b.BillTypeId == pBillTypeId &&
- b.TransactionCode == pTransctionNo.ToString() &&
- b.ItemBarcode == query.barcode)
- .ExecuteCommand();
-
- db.Updateable<MesInvItemStocks>()
- .SetColumns(b => new MesInvItemStocks
- {
- DepotsCode = cDepotCode,
- DepotSectionsCode = query.sectionCode
- })
- .Where(b => b.ItemBarcode == query.barcode)
- .ExecuteCommand();
-
- db.Updateable<MesInvItemMovesCDetails>()
- .SetColumns(b => new MesInvItemMovesCDetails
- {
- MoveOk = 1,
- InvDepotsCode = cDepotCode,
- InvDepotSectionsCode = query.sectionCode
- })
- .Where(b =>
- b.ItemBarcode == query.barcode &&
- b.ItemMoveId == itemMoveQuery.Id)
- .ExecuteCommand();
-
- // 妫�鏌ユ槸鍚︽墍鏈夋潯鐮佸凡鎵爜绉诲簱
- var totalQuantity = db.Queryable<MesInvItemOutItems>()
- .Where(a => a.ItemOutId == itemMoveQuery.Id)
- .Sum(a => SqlFunc.IsNull(a.Quantity, 0));
-
- var scannedQuantity = db.Queryable<MesInvItemMovesCDetails>()
- .Where(a => a.ItemMoveId == itemMoveQuery.Id && a.MoveOk == 1)
- .Sum(a => SqlFunc.IsNull(a.Quantity, 0));
-
- if (totalQuantity == scannedQuantity) return 1;
-
- return 0;
- });
-
- var dto = new MovesDto();
- dto.InAudit = isAudit == 1;
- dto.BarcodesInfo = barcodeInfo;
- return dto;
- }
-
-
- 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();
- }
-
- public List<MesInvItemMoves> GetPage(WarehouseQuery query)
- {
- return Db.Queryable<MesInvItemMoves>()
- .WhereIF(!string.IsNullOrEmpty(query.billNo),
- s => s.BillNo == query.billNo)
- .OrderByDescending(s => s.Id)
- .ToPageList(query.PageIndex, query.Limit);
- }
-
- public MovesDto GetItems(WarehouseQuery query)
- {
- var dto = new MovesDto();
-
- dto.BarcodeList = GetItemMovesCDetails(query);
- dto.OutItems = GetItemOutItems(query);
-
- return dto;
- }
-
- private List<MesInvItemOutItems> GetItemOutItems(WarehouseQuery query)
- {
- var sql = string.Format(
- "SELECT C.ITEM_NO, C.QUANTITY, C.REMARK, C.REMARK, S.ITEM_NAME, S.ITEM_MODEL, U.FNAME ITEM_UNIT, D.QUANTITY_OK, NVL(ST.QUANTITY, 0) WLKC FROM MES_INV_ITEM_OUT_ITEMS C JOIN MES_ITEMS S ON C.ITEM_ID = S.ID LEFT JOIN MES_UNIT U ON U.ID = S.ITEM_UNIT LEFT JOIN MES_DEPOTS P ON P.DEPOT_CODE = C.DEPOT_CODE LEFT JOIN MES_DEPOT_SECTIONS E ON E.DEPOT_SECTION_CODE = C.DEPOT_SECTION_CODE 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) D ON D.ITEM_MOVE_ID = C.ITEM_OUT_ID AND D.ITEM_NO = C.ITEM_NO LEFT JOIN MES_INV_ITEM_MOVES A ON A.ID = C.ITEM_OUT_ID left join (SELECT ITEM_ID, SUM(QUANTITY) QUANTITY, DEPOTS_CODE FROM MES_INV_ITEM_STOCKS GROUP BY ITEM_ID, DEPOTS_CODE) ST ON C.ITEM_ID = ST.ITEM_ID AND ST.DEPOTS_CODE = A.FROM_DEPOTS_CODE where C.ITEM_OUT_ID = {0}",
- query.id);
-
- return Db.Ado.SqlQuery<MesInvItemOutItems>(sql);
- }
-
- private List<MesInvItemMovesCDetails> GetItemMovesCDetails(
- WarehouseQuery query)
- {
- return Db
- .Queryable<MesInvItemMovesCDetails, MesItems,
- MesSupplier>((b, c, f) => new JoinQueryInfos(
- JoinType.Left,
- b.ItemNo == c.ItemNo && b.Company == c.Company &&
- b.Factory == c.Factory,
- JoinType.Left, b.SuppNo == f.SuppNo
- ))
- .Where((b, c, f) => b.ItemMoveId == query.id)
- .Select((b, c, f) => new MesInvItemMovesCDetails
- {
- FromDepotSectionsCode = b.FromDepotSectionsCode,
- BoardStyle = b.BoardStyle,
- FromDepotsCode = b.FromDepotsCode,
- InvDepotSectionsCode = b.InvDepotSectionsCode,
- InvDepotsCode = b.InvDepotsCode,
- Quantity = b.Quantity,
- LotNo = b.LotNo,
- ItemNo = b.ItemNo,
- ItemBarcode = b.ItemBarcode,
- ItemName = c.ItemName,
- ItemModel = c.ItemModel,
- ItemUnit = c.ItemUnit,
- SuppName = f.SuppName,
- MoveOk =
- SqlFunc.IsNull(b.MoveOk, 0) // 浣跨敤 SqlFunc.IsNull 瀹炵幇 NVL 鐨勬晥鏋�
- }).ToList();
- }
-
- public OutItemDto ScanMoveBarcode(WarehouseQuery query)
- {
- var BillTypeId = 300;
- var TransctionNo = 301;
- query.Factory = "1000";
- query.Company = "1000";
-
- if (string.IsNullOrEmpty(query.billNo)) throw new Exception("璇烽�夊崟鎹彿锛�");
-
- var mesInvItemStocks = Db.Queryable<MesInvItemStocks>()
- .Where(s => s.ItemBarcode == query.barcode &&
- s.Quantity > 0 && s.DepotsCode != null).First();
- if (mesInvItemStocks == null)
- throw new Exception("搴撳瓨涓棤姝ゆ潯鐮侊紝璇锋牳瀵癸紒" + query.barcode);
-
- var mesInvItemMoves = Db.Queryable<MesInvItemMoves>()
- .Where(d => d.TransactionNo == TransctionNo
- && SqlFunc.IsNull(d.Status, 0) == 1).First();
-
- if (mesInvItemMoves == null)
- throw new Exception("鍑哄簱鍗� " + query.billNo + "涓嶅瓨鍦紝璇风‘璁わ紒");
-
- var count = Db
- .Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) =>
- new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
- .Where((a, b) => b.ItemBarcode == query.barcode
- && a.TransactionNo == TransctionNo &&
- SqlFunc.IsNull(a.Status, 0) == 0).Count();
- if (count > 0) throw new Exception("鏉＄爜閲嶅鎵弿锛岃鏍稿锛�");
-
- count = Db.Queryable<MesInvItemMoves, MesInvItemMovesCDetails>((a, b) =>
- new JoinQueryInfos(JoinType.Inner, a.Id == b.ItemMoveId))
- .Where((a, b) => b.ItemBarcode == query.barcode
- && a.TransactionNo == TransctionNo &&
- SqlFunc.IsNull(b.MoveOk, 0) == 0).Count();
-
- if (count > 0) throw new Exception("鏉＄爜閲嶅鎵弿锛岃鏍稿锛�");
-
- if (mesInvItemMoves.FromDepotsCode != mesInvItemStocks.DepotsCode)
- throw new Exception("鏉＄爜鐜板瓨浠撳簱涓庣敵璇峰嚭璐т粨搴撲笉涓�鑷达紝璇锋牳瀵癸紒");
-
- var quantity = Db.Queryable<MesInvItemOutItems>()
- .Where(b => b.ItemNo == mesInvItemStocks.ItemNo
- && b.ItemOutId == mesInvItemMoves.Id)
- .Sum(b => b.Quantity);
-
- if (quantity == null)
- throw new Exception("鎵爜鐗╂枡闈炴湰娆＄敵璇风墿鏂欙紝璇锋牳瀵癸紒" + query.barcode);
-
- var sum = Db.Queryable<MesInvItemMovesCDetails>()
- .Where(b => b.ItemNo == mesInvItemStocks.ItemNo
- && b.ItemMoveId == mesInvItemMoves.Id)
- .Sum(b => b.Quantity) ?? 0;
-
- var sumqty = sum + (mesInvItemStocks.Quantity ?? 0);
-
- if (sumqty > quantity)
- throw new Exception(
- "宸叉壂鏉＄爜鏁伴噺鎴栨湰娆℃壂鐮佹暟閲忥細" + sumqty + " 澶т簬鐢宠鏁伴噺锛�" + quantity + "锛岃鏍稿锛�");
-
- UseTransaction(db =>
- {
- SaveMesInvItemMovesCDetails(db, query, mesInvItemMoves,
- mesInvItemStocks);
-
- // Insert into mes_inv_business2
- SaveMesInvBusiness2(db, query, BillTypeId, TransctionNo,
- mesInvItemStocks, mesInvItemMoves);
-
- if (TransctionNo == 303)
- db.Updateable<MesInvItemStocks>()
- .SetColumns(s =>
- s.DepotSectionsCode == mesInvItemMoves.InvDepotsCode)
- .SetColumns(s =>
- s.DepotsCode == mesInvItemMoves.InvDepotsCode)
- .Where(s => s.Id == mesInvItemStocks.Id)
- .ExecuteCommand();
- else
- db.Updateable<MesInvItemStocks>()
- .SetColumns(s => s.DepotSectionsCode == null)
- .SetColumns(s => s.DepotsCode == null)
- .Where(s => s.Id == mesInvItemStocks.Id)
- .ExecuteCommand();
-
- var scanOutShowDb = ScanOutShowDb(query);
- if (CollectionUtil.IsNullOrEmpty(scanOutShowDb))
- db.Updateable<MesInvItemMoves>()
- .SetColumns(s => s.Status == 1)
- .SetColumns(s => s.Checkdate == DateTime.Now)
- .SetColumns(s => s.Checkuser == query.userName)
- .Where(s => s.BillNo == query.billNo).ExecuteCommand();
-
- return 1;
- });
-
- var itemDto = new OutItemDto();
- //itemDto.SumItem = scanOutShowDb;
-
- if (TransctionNo == 201) itemDto.Quantity = mesInvItemStocks.Quantity;
-
- itemDto.ItemNo = mesInvItemStocks.ItemNo;
-
- return itemDto;
- }
-
- private void SaveMesInvBusiness2(SqlSugarScope Db, WarehouseQuery query,
- int BillTypeId,
- int TransctionNo, MesInvItemStocks mesInvItemStocks,
- MesInvItemMoves mesInvItemMoves)
- {
- var executeCommand = Db.Insertable(new MesInvBusiness2
- {
- Status = 1,
- BillTypeId = BillTypeId,
- TransactionCode = TransctionNo.ToString(),
- BusinessType = 1,
- ItemBarcode = query.barcode,
- ItemNo = mesInvItemStocks.ItemNo,
- LotNo = mesInvItemStocks.LotNo,
- EpFlag = 1,
- Quantity = mesInvItemStocks.Quantity,
- FromInvDepotsCode = mesInvItemStocks.DepotsCode,
- FromInvDepotSectionsCode = mesInvItemStocks.DepotSectionsCode,
- ToInvDepotsCode = TransctionNo == 303
- ? mesInvItemMoves.InvDepotsCode
- : null,
- ToInvDepotSectionsCode = TransctionNo == 303
- ? mesInvItemMoves.InvDepotsCode
- : null,
- CreateBy = query.userName,
- CreateDate = DateTime.Now,
- LastupdateBy = query.userName,
- LastupdateDate = DateTime.Now,
- Factory = query.Factory,
- Company = query.Company,
- TaskNo = mesInvItemStocks.TaskNo,
- BillNo = query.billNo,
- WorkNo = mesInvItemStocks.WorkNo,
- WorkLine = mesInvItemStocks.WorkLine,
- SuppNo = mesInvItemStocks.SuppNo
- }).ExecuteCommand();
-
- if (executeCommand <= 0) throw new Exception("鍐欏叆MesInvBusiness2琛ㄥけ璐�");
- }
-
- private void SaveMesInvItemMovesCDetails(SqlSugarScope Db,
- WarehouseQuery query,
- MesInvItemMoves mesInvItemMoves, MesInvItemStocks mesInvItemStocks)
- {
- var executeCommand = Db.Insertable(new MesInvItemMovesCDetails
- {
- ItemMoveId = mesInvItemMoves.Id,
- ItemBarcode = query.barcode,
- CItemCode = mesInvItemStocks.CItemCode,
- ItemNo = mesInvItemStocks.ItemNo,
- LotNo = mesInvItemStocks.LotNo,
- Quantity = mesInvItemStocks.Quantity,
- EpFlag = mesInvItemStocks.EpFlag,
- CreateBy = query.userName,
- CreateDate = DateTime.Now,
- LastupdateBy = query.userName,
- LastupdateDate = DateTime.Now,
- CustNo = mesInvItemStocks.CustomerNo,
- TaskNo = mesInvItemStocks.TaskNo,
- FromDepotsCode = mesInvItemStocks.DepotsCode,
- FromDepotSectionsCode = mesInvItemStocks.DepotSectionsCode,
- Factory = mesInvItemStocks.Factory,
- Company = mesInvItemStocks.Company,
- IqcStatus = mesInvItemStocks.IqcStatus,
- Fcar = mesInvItemStocks.Fcar,
- IndepDate = mesInvItemStocks.IndepDate,
- VisableSubmit = mesInvItemStocks.VisableSubmit,
- VisableSubmitBy = mesInvItemStocks.VisableSubmitBy,
- VisableSubmitDate = mesInvItemStocks.VisableSubmitDate,
- BoardStyle = mesInvItemStocks.BoardStyle,
- WorkNo = mesInvItemStocks.WorkNo,
- WorkLine = mesInvItemStocks.WorkLine,
- SuppNo = mesInvItemStocks.SuppNo
- }).ExecuteCommand();
-
- if (executeCommand <= 0)
- throw new Exception("鍐欏叆MesInvItemMovesCDetails琛ㄥけ璐�");
- }
-
- //scan_out_show_DB
- private List<InventoryItem> ScanOutShowDb(WarehouseQuery query)
- {
- var BillTypeId = 300;
- var TransctionNo = 301;
- query.Factory = "1000";
- query.Company = "1000";
-
- if (string.IsNullOrEmpty(query.billNo)) throw new Exception("璇烽�夊崟鎹彿锛�");
-
- 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;
- }
-
- public bool Audit(WarehouseQuery query)
- {
- return Db.Updateable<MesInvItemMoves>()
- .SetColumns(a => new MesInvItemMoves { Ts = 1 })
- .Where(a => a.Id == query.id)
- .ExecuteCommand() > 0;
- }
-
- public MessageCenter SaveMessageCenter(WarehouseQuery query)
- {
- var message = MesToErpParam(query);
-
- var executeReturnIdentity =
- Db.Insertable(message).ExecuteReturnIdentity();
- if (executeReturnIdentity > 0)
- {
- message.Id = executeReturnIdentity;
- message.Pid = executeReturnIdentity;
- return message;
- }
-
- throw new Exception("鑾峰彇鏁版嵁澶辫触");
- }
-
- public MessageCenter MesToErpParam(WarehouseQuery query)
- {
- var erpParameters = "";
- var title = "";
- var tableName = "MES_INV_ITEM_MOVES_" + query.Type;
- if ("A".Equals(query.Type))
- {
- erpParameters = GetErpParameters(query.billNo);
- title = "璋冩嫧鍏ュ簱鍗�" + query.billNo + "瀹℃牳";
- }
- else if ("B".Equals(query.Type))
- {
- erpParameters = GetDeApprovePam(query.id);
- title = "璋冩嫧鍏ュ簱鍗�" + query.billNo + "鍙嶅鏍�";
- }
-
- var ErpUrl = AppsettingsUtility.Settings.ProductionErpUrl;
- var message = new MessageCenter
- {
- TableName = tableName,
- Url = ErpUrl,
- Status = 1,
- CreateBy = query.userName,
- Route = query.billNo,
- Title = title,
- PageName = "Allocation/Add?id=" + query.id +
- "&billNo=" + query.billNo,
- CreateDate = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss"),
- Method = "POST",
- Seq = 1,
- Data = erpParameters,
- IsMessage = 0,
- ContentType = "application/x-www-form-urlencoded"
- };
- return message;
- }
-
- private string GetErpParameters(string? billNo)
- {
- // var invItemIns = Db.Queryable<MesInvItemOuts>()
- // .Single(x => x.ItemOutNo == billNo);
- //
- // //璋冪敤function鍑芥暟
- // var sql =
- // $"SELECT F_GENERATE_DATA_INSERTED('{billNo}') FROM DUAL;";
- // var jsonString = Db.Ado.SqlQuerySingle<string>(sql);
- //
- // var encodedUrl = "taskname=CGTL&mesid=" + invItemIns.Id +
- // "&optype=create&datajson=" + jsonString;
- //
- // return encodedUrl;
- return null;
- }
-
- private string GetDeApprovePam(decimal? id)
- {
- // var sid = (int)id;
- // var encodedUrl = "taskname=CGTL&mesid=" + sid +
- // "&optype=delete&datajson={}";
- //
- // return encodedUrl;
- return null;
- }
-}
\ No newline at end of file
diff --git a/MESApplication/Controllers/FBSDB/FbsDbController.cs b/MESApplication/Controllers/FBSDB/FbsDbController.cs
new file mode 100644
index 0000000..80aaec3
--- /dev/null
+++ b/MESApplication/Controllers/FBSDB/FbsDbController.cs
@@ -0,0 +1,6 @@
+锘縩amespace MESApplication.Controllers.FBSDB;
+
+public class FbsDbController
+{
+
+}
diff --git a/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs b/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs
deleted file mode 100644
index fb0be61..0000000
--- a/MESApplication/Controllers/Warehouse/MesInvItemMovesCDetailsController.cs
+++ /dev/null
@@ -1,163 +0,0 @@
-锘縰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
deleted file mode 100644
index 36da5ff..0000000
--- a/MESApplication/Controllers/Warehouse/MesInvItemMovesController.cs
+++ /dev/null
@@ -1,306 +0,0 @@
-锘縰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();
-
- //ScanInBarcode
- [HttpPost("ScanInBarcode")]
- public ResponseResult ScanInBarcode(WarehouseQuery query)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- resultInfos.tbBillList = m.ScanInBarcode(query);
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
-
- [HttpPost("Audit")]
- public ResponseResult Audit(WarehouseQuery query)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- resultInfos.tbBillList = m.Audit(query);
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
-
- [HttpPost("SaveMessageCenter")]
- public ResponseResult SaveMessageCenter(WarehouseQuery entity)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- resultInfos.tbBillList = m.SaveMessageCenter(entity);
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
-
- //GetPage
- [HttpPost("GetPage")]
- public ResponseResult GetPage(WarehouseQuery query)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- resultInfos.tbBillList = m.GetPage(query);
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
-
- //GetItems
- [HttpPost("GetItems")]
- public ResponseResult GetItems(WarehouseQuery query)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- resultInfos.tbBillList = m.GetItems(query);
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
-
- //ScanMoveBarcode
- [HttpPost("ScanMoveBarcode")]
- public ResponseResult ScanMoveBarcode(WarehouseQuery query)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- resultInfos.tbBillList = m.ScanMoveBarcode(query);
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
-
- // 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);
- }
- }
-
- /// <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/MESApplication.csproj b/MESApplication/MESApplication.csproj
index b87eece..3ae7129 100644
--- a/MESApplication/MESApplication.csproj
+++ b/MESApplication/MESApplication.csproj
@@ -9,7 +9,7 @@
</PropertyGroup>
<ItemGroup>
- <PackageReference Include="Microsoft.AspNetCore.Mvc.NewtonsoftJson" Version="8.0.0"/>
+ <PackageReference Include="Microsoft.AspNetCore.Mvc.NewtonsoftJson" Version="8.0.0" />
<PackageReference Include="Microsoft.EntityFrameworkCore.Design" Version="8.0.1">
<PrivateAssets>all</PrivateAssets>
<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
@@ -18,12 +18,12 @@
<PrivateAssets>all</PrivateAssets>
<IncludeAssets>runtime; build; native; contentfiles; analyzers; buildtransitive</IncludeAssets>
</PackageReference>
- <PackageReference Include="Oracle.EntityFrameworkCore" Version="8.21.121"/>
- <PackageReference Include="Swashbuckle.AspNetCore" Version="6.4.0"/>
+ <PackageReference Include="Oracle.EntityFrameworkCore" Version="8.21.121" />
+ <PackageReference Include="Swashbuckle.AspNetCore" Version="6.4.0" />
</ItemGroup>
<ItemGroup>
- <ProjectReference Include="..\MES.Service\MES.Service.csproj"/>
+ <ProjectReference Include="..\MES.Service\MES.Service.csproj" />
</ItemGroup>
</Project>
diff --git a/MESApplication/Properties/PublishProfiles/FolderProfile.pubxml.user b/MESApplication/Properties/PublishProfiles/FolderProfile.pubxml.user
index 98e1d18..cf4cf17 100644
--- a/MESApplication/Properties/PublishProfiles/FolderProfile.pubxml.user
+++ b/MESApplication/Properties/PublishProfiles/FolderProfile.pubxml.user
@@ -5,7 +5,7 @@
<Project>
<PropertyGroup>
<_PublishTargetUrl>E:\Tool\TLM\TLM_JK\MESApplication\bin\Release\net8.0\publish\</_PublishTargetUrl>
- <History>True|2025-07-16T06:28:49.8020385Z||;True|2025-07-15T14:10:46.5966766+08:00||;True|2025-07-15T13:47:28.9454088+08:00||;True|2025-07-15T13:47:02.7000977+08:00||;False|2025-07-15T13:46:13.1024314+08:00||;True|2025-06-23T11:21:29.8285053+08:00||;True|2025-06-23T10:42:44.4782901+08:00||;True|2025-06-13T11:39:26.7350436+08:00||;False|2025-06-13T11:38:43.8884292+08:00||;True|2025-06-13T11:00:43.8087373+08:00||;True|2025-05-16T15:10:24.9670924+08:00||;True|2025-05-15T14:40:01.9090441+08:00||;True|2025-05-15T14:37:16.5010870+08:00||;True|2025-05-14T11:08:53.5234495+08:00||;True|2025-05-10T11:32:49.9307363+08:00||;True|2025-05-09T18:04:27.4863117+08:00||;True|2025-04-16T18:13:28.4207378+08:00||;True|2025-04-11T18:24:26.3046003+08:00||;True|2025-03-26T10:03:35.1416945+08:00||;True|2025-03-24T14:54:31.6912596+08:00||;True|2025-03-04T15:36:06.8726998+08:00||;True|2025-03-04T15:07:10.0825281+08:00||;True|2025-02-28T12:01:45.7353138+08:00||;True|2025-02-27T18:49:51.8648828+08:00||;True|2025-02-24T18:08:27.1066831+08:00||;True|2025-02-14T20:58:59.6306239+08:00||;True|2025-02-12T18:28:32.5741267+08:00||;True|2024-12-28T09:06:17.0669698+08:00||;True|2024-12-26T14:45:42.2002555+08:00||;True|2024-12-26T13:03:07.9325085+08:00||;True|2024-12-26T11:43:04.0852484+08:00||;True|2024-12-21T22:33:39.6121285+08:00||;True|2024-12-16T14:40:36.9800141+08:00||;True|2024-12-14T16:23:42.9536129+08:00||;True|2024-12-11T15:50:13.8959852+08:00||;True|2024-12-11T10:47:42.1561088+08:00||;True|2024-12-08T18:32:27.3909077+08:00||;True|2024-12-06T16:30:29.0031886+08:00||;True|2024-12-05T16:20:00.9907217+08:00||;True|2024-12-05T16:19:41.4441561+08:00||;True|2024-12-05T16:19:22.9404769+08:00||;True|2024-12-05T11:07:30.6547548+08:00||;True|2024-12-03T17:12:24.9349522+08:00||;True|2024-11-27T11:05:24.9761937+08:00||;True|2024-11-19T08:57:10.9008301+08:00||;True|2024-11-18T21:02:57.0481324+08:00||;True|2024-11-05T17:25:48.6360448+08:00||;True|2024-11-05T17:16:08.2144948+08:00||;True|2024-10-28T11:56:24.2694762+08:00||;True|2024-10-28T11:40:56.4512491+08:00||;True|2024-10-28T11:28:42.4509497+08:00||;True|2024-10-28T11:11:11.1286907+08:00||;True|2024-10-28T10:09:42.4378313+08:00||;True|2024-10-28T09:57:51.0792947+08:00||;True|2024-10-23T17:07:23.7741858+08:00||;True|2024-10-22T14:34:55.4526970+08:00||;True|2024-10-17T16:37:53.4763504+08:00||;True|2024-10-13T14:04:45.3666662+08:00||;True|2024-10-13T12:30:16.7294894+08:00||;True|2024-10-13T12:22:13.5740642+08:00||;True|2024-09-26T17:43:56.9592414+08:00||;True|2024-09-25T09:56:59.0722612+08:00||;True|2024-09-20T16:35:40.9416105+08:00||;True|2024-09-13T15:42:08.2824743+08:00||;True|2024-08-20T17:12:00.2924570+08:00||;True|2024-08-17T10:57:05.6670396+08:00||;True|2024-08-17T10:56:46.8068041+08:00||;True|2024-08-16T14:09:17.0526491+08:00||;True|2024-08-15T08:40:32.8134665+08:00||;True|2024-08-14T10:00:27.7017207+08:00||;True|2024-08-14T08:54:44.8284031+08:00||;True|2024-08-07T10:32:10.3689256+08:00||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;True|2024-01-29T17:44:43.6800769+08:00||;True|2024-01-23T09:47:26.7811926+08:00||;True|2024-01-18T16:23:30.3373836+08:00||;</History>
+ <History>True|2025-07-22T07:29:46.8848508Z||;False|2025-07-22T15:29:15.2781716+08:00||;False|2025-07-22T15:26:28.6544573+08:00||;True|2025-07-16T14:28:49.8020385+08:00||;True|2025-07-15T14:10:46.5966766+08:00||;True|2025-07-15T13:47:28.9454088+08:00||;True|2025-07-15T13:47:02.7000977+08:00||;False|2025-07-15T13:46:13.1024314+08:00||;True|2025-06-23T11:21:29.8285053+08:00||;True|2025-06-23T10:42:44.4782901+08:00||;True|2025-06-13T11:39:26.7350436+08:00||;False|2025-06-13T11:38:43.8884292+08:00||;True|2025-06-13T11:00:43.8087373+08:00||;True|2025-05-16T15:10:24.9670924+08:00||;True|2025-05-15T14:40:01.9090441+08:00||;True|2025-05-15T14:37:16.5010870+08:00||;True|2025-05-14T11:08:53.5234495+08:00||;True|2025-05-10T11:32:49.9307363+08:00||;True|2025-05-09T18:04:27.4863117+08:00||;True|2025-04-16T18:13:28.4207378+08:00||;True|2025-04-11T18:24:26.3046003+08:00||;True|2025-03-26T10:03:35.1416945+08:00||;True|2025-03-24T14:54:31.6912596+08:00||;True|2025-03-04T15:36:06.8726998+08:00||;True|2025-03-04T15:07:10.0825281+08:00||;True|2025-02-28T12:01:45.7353138+08:00||;True|2025-02-27T18:49:51.8648828+08:00||;True|2025-02-24T18:08:27.1066831+08:00||;True|2025-02-14T20:58:59.6306239+08:00||;True|2025-02-12T18:28:32.5741267+08:00||;True|2024-12-28T09:06:17.0669698+08:00||;True|2024-12-26T14:45:42.2002555+08:00||;True|2024-12-26T13:03:07.9325085+08:00||;True|2024-12-26T11:43:04.0852484+08:00||;True|2024-12-21T22:33:39.6121285+08:00||;True|2024-12-16T14:40:36.9800141+08:00||;True|2024-12-14T16:23:42.9536129+08:00||;True|2024-12-11T15:50:13.8959852+08:00||;True|2024-12-11T10:47:42.1561088+08:00||;True|2024-12-08T18:32:27.3909077+08:00||;True|2024-12-06T16:30:29.0031886+08:00||;True|2024-12-05T16:20:00.9907217+08:00||;True|2024-12-05T16:19:41.4441561+08:00||;True|2024-12-05T16:19:22.9404769+08:00||;True|2024-12-05T11:07:30.6547548+08:00||;True|2024-12-03T17:12:24.9349522+08:00||;True|2024-11-27T11:05:24.9761937+08:00||;True|2024-11-19T08:57:10.9008301+08:00||;True|2024-11-18T21:02:57.0481324+08:00||;True|2024-11-05T17:25:48.6360448+08:00||;True|2024-11-05T17:16:08.2144948+08:00||;True|2024-10-28T11:56:24.2694762+08:00||;True|2024-10-28T11:40:56.4512491+08:00||;True|2024-10-28T11:28:42.4509497+08:00||;True|2024-10-28T11:11:11.1286907+08:00||;True|2024-10-28T10:09:42.4378313+08:00||;True|2024-10-28T09:57:51.0792947+08:00||;True|2024-10-23T17:07:23.7741858+08:00||;True|2024-10-22T14:34:55.4526970+08:00||;True|2024-10-17T16:37:53.4763504+08:00||;True|2024-10-13T14:04:45.3666662+08:00||;True|2024-10-13T12:30:16.7294894+08:00||;True|2024-10-13T12:22:13.5740642+08:00||;True|2024-09-26T17:43:56.9592414+08:00||;True|2024-09-25T09:56:59.0722612+08:00||;True|2024-09-20T16:35:40.9416105+08:00||;True|2024-09-13T15:42:08.2824743+08:00||;True|2024-08-20T17:12:00.2924570+08:00||;True|2024-08-17T10:57:05.6670396+08:00||;True|2024-08-17T10:56:46.8068041+08:00||;True|2024-08-16T14:09:17.0526491+08:00||;True|2024-08-15T08:40:32.8134665+08:00||;True|2024-08-14T10:00:27.7017207+08:00||;True|2024-08-14T08:54:44.8284031+08:00||;True|2024-08-07T10:32:10.3689256+08:00||;True|2024-08-05T15:45:03.0864530+08:00||;True|2024-08-03T09:59:13.7916520+08:00||;True|2024-07-31T17:27:28.1965929+08:00||;True|2024-07-31T15:27:34.7943845+08:00||;True|2024-07-30T15:04:50.5849235+08:00||;True|2024-07-30T14:09:06.2877325+08:00||;True|2024-07-29T16:11:30.4493940+08:00||;True|2024-07-23T14:30:34.4591002+08:00||;True|2024-07-22T14:17:39.8186158+08:00||;True|2024-04-10T12:55:31.3963752+08:00||;True|2024-04-08T13:59:25.5487203+08:00||;True|2024-04-06T09:30:09.5350539+08:00||;True|2024-04-06T08:46:05.8814658+08:00||;True|2024-04-05T14:06:52.0448024+08:00||;True|2024-04-05T12:47:46.0561601+08:00||;True|2024-02-26T08:46:22.0988887+08:00||;True|2024-02-24T19:17:13.6770376+08:00||;True|2024-02-24T14:32:37.4450337+08:00||;True|2024-02-23T10:22:06.5150173+08:00||;True|2024-02-22T13:19:56.6997993+08:00||;True|2024-02-22T10:53:17.7929585+08:00||;True|2024-02-21T17:08:06.5553444+08:00||;True|2024-02-19T16:24:37.4912012+08:00||;True|2024-02-02T10:07:23.2726075+08:00||;True|2024-02-02T08:36:49.2904460+08:00||;</History>
<LastFailureDetails />
</PropertyGroup>
</Project>
\ No newline at end of file
diff --git a/MESApplication/bin/Release/net8.0/MES.Service.dll b/MESApplication/bin/Release/net8.0/MES.Service.dll
index 4542b0f..16647e7 100644
--- a/MESApplication/bin/Release/net8.0/MES.Service.dll
+++ b/MESApplication/bin/Release/net8.0/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MES.Service.pdb b/MESApplication/bin/Release/net8.0/MES.Service.pdb
index c926788..bc98886 100644
--- a/MESApplication/bin/Release/net8.0/MES.Service.pdb
+++ b/MESApplication/bin/Release/net8.0/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.dll b/MESApplication/bin/Release/net8.0/MESApplication.dll
index 6db62a9..ac1129b 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.dll
+++ b/MESApplication/bin/Release/net8.0/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.exe b/MESApplication/bin/Release/net8.0/MESApplication.exe
index a46503a..3f77676 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.exe
+++ b/MESApplication/bin/Release/net8.0/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.pdb b/MESApplication/bin/Release/net8.0/MESApplication.pdb
index de6b490..2010af8 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.pdb
+++ b/MESApplication/bin/Release/net8.0/MESApplication.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/MESApplication.xml b/MESApplication/bin/Release/net8.0/MESApplication.xml
index 9c5bcee..399b61a 100644
--- a/MESApplication/bin/Release/net8.0/MESApplication.xml
+++ b/MESApplication/bin/Release/net8.0/MESApplication.xml
@@ -1225,78 +1225,6 @@
</summary>
<returns></returns>
</member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.GetList">
- <summary>
- 鑾峰彇鎵�鏈�
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.GetById(System.Int32)">
- <summary>
- 鏍规嵁涓婚敭鑾峰彇
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.DeleteByIds(System.Object[])">
- <summary>
- 鏍规嵁涓婚敭鍒犻櫎
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.Add(MES.Service.Modes.MesInvItemMovesCDetails)">
- <summary>
- 娣诲姞
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.InsertReturnIdentity(MES.Service.Modes.MesInvItemMovesCDetails)">
- <summary>
- 娣诲姞杩斿洖鑷
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.Update(MES.Service.Modes.MesInvItemMovesCDetails)">
- <summary>
- 淇敼
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.GetList">
- <summary>
- 鑾峰彇鎵�鏈�
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.GetById(System.Int32)">
- <summary>
- 鏍规嵁涓婚敭鑾峰彇
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.DeleteByIds(System.Object[])">
- <summary>
- 鏍规嵁涓婚敭鍒犻櫎
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.Add(MES.Service.Modes.MesInvItemMoves)">
- <summary>
- 娣诲姞
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.InsertReturnIdentity(MES.Service.Modes.MesInvItemMoves)">
- <summary>
- 娣诲姞杩斿洖鑷
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.Update(MES.Service.Modes.MesInvItemMoves)">
- <summary>
- 淇敼
- </summary>
- <returns></returns>
- </member>
<member name="M:MESApplication.Controllers.Warehouse.MesInvItemOutCDetailsController.GetOutItemList(MES.Service.Dto.service.WarehouseQuery)">
<summary>
鑾峰彇鐗╂枡鎺ユ敹淇℃伅
diff --git a/MESApplication/bin/Release/net8.0/publish/MES.Service.dll b/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
index 4542b0f..16647e7 100644
--- a/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
+++ b/MESApplication/bin/Release/net8.0/publish/MES.Service.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb b/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
index c926788..bc98886 100644
--- a/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
+++ b/MESApplication/bin/Release/net8.0/publish/MES.Service.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.dll b/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
index 6db62a9..ac1129b 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.dll
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.exe b/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
index a46503a..3f77676 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.exe
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb b/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
index de6b490..2010af8 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.pdb
Binary files differ
diff --git a/MESApplication/bin/Release/net8.0/publish/MESApplication.xml b/MESApplication/bin/Release/net8.0/publish/MESApplication.xml
index 9c5bcee..399b61a 100644
--- a/MESApplication/bin/Release/net8.0/publish/MESApplication.xml
+++ b/MESApplication/bin/Release/net8.0/publish/MESApplication.xml
@@ -1225,78 +1225,6 @@
</summary>
<returns></returns>
</member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.GetList">
- <summary>
- 鑾峰彇鎵�鏈�
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.GetById(System.Int32)">
- <summary>
- 鏍规嵁涓婚敭鑾峰彇
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.DeleteByIds(System.Object[])">
- <summary>
- 鏍规嵁涓婚敭鍒犻櫎
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.Add(MES.Service.Modes.MesInvItemMovesCDetails)">
- <summary>
- 娣诲姞
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.InsertReturnIdentity(MES.Service.Modes.MesInvItemMovesCDetails)">
- <summary>
- 娣诲姞杩斿洖鑷
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesCDetailsController.Update(MES.Service.Modes.MesInvItemMovesCDetails)">
- <summary>
- 淇敼
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.GetList">
- <summary>
- 鑾峰彇鎵�鏈�
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.GetById(System.Int32)">
- <summary>
- 鏍规嵁涓婚敭鑾峰彇
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.DeleteByIds(System.Object[])">
- <summary>
- 鏍规嵁涓婚敭鍒犻櫎
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.Add(MES.Service.Modes.MesInvItemMoves)">
- <summary>
- 娣诲姞
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.InsertReturnIdentity(MES.Service.Modes.MesInvItemMoves)">
- <summary>
- 娣诲姞杩斿洖鑷
- </summary>
- <returns></returns>
- </member>
- <member name="M:MESApplication.Controllers.Warehouse.MesInvItemMovesController.Update(MES.Service.Modes.MesInvItemMoves)">
- <summary>
- 淇敼
- </summary>
- <returns></returns>
- </member>
<member name="M:MESApplication.Controllers.Warehouse.MesInvItemOutCDetailsController.GetOutItemList(MES.Service.Dto.service.WarehouseQuery)">
<summary>
鑾峰彇鐗╂枡鎺ユ敹淇℃伅
--
Gitblit v1.9.3