From b646b9bee3991eb91fb916a290e5efb33eb5f68c Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期五, 18 四月 2025 19:13:40 +0800 Subject: [PATCH] 代码提交 --- StandardPda/MES.Service/service/BasicData/MesItemsManager.cs | 12 ++++++++---- 1 files changed, 8 insertions(+), 4 deletions(-) diff --git a/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs b/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs index d5a23f8..03e085c 100644 --- a/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs +++ b/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs @@ -1,7 +1,7 @@ 锘縰sing MES.Service.DB; -using MES.Service.Dto.service; using MES.Service.Dto.webApi; using MES.Service.Modes; +using MES.Service.util; using SqlSugar; namespace MES.Service.service.BasicData; @@ -63,7 +63,7 @@ .Distinct() // 搴旂敤 Distinct 鍘婚噸 .ToList(); - var deleteByIds = Db.Deleteable<MesProject>().In(idsToDelete) + var deleteByIds = Db.Deleteable<MesItems>().In(idsToDelete) .ExecuteCommand(); // if (deleteByIds > 0) // return true; @@ -94,6 +94,7 @@ } else { + mesId = GetSeqUtil.GetSeq("SEQ_ITEMS_ID"); var entity = new MesLinkU9 { CreateDate = DateTime.Now, @@ -102,7 +103,7 @@ OrgId = erpDetail.FUseOrgId, TableType = "MES_ITEMS" }; - mesId = Db.Insertable(entity).ExecuteReturnIdentity(); + Db.Insertable(entity).ExecuteCommand(); } var items = new MesItems @@ -147,6 +148,9 @@ CreateDate = DateTime.Now, Company = "1000", Factory = "1000", + WarehouseKeeper=item.WarehouseKeeper, + Merchandiser=item.Merchandiser + }; list.Add(items); } @@ -158,7 +162,7 @@ { DeleteItem(db, listItem); - var insert = db.Insertable(listItem).IgnoreColumns(true) + var insert = db.Insertable(listItem).PageSize(1).IgnoreColumnsNull() .ExecuteCommand(); return insert > 0; } -- Gitblit v1.9.3