From 5de35354e8dfcb4933350d0d1b645d400bcf23ab Mon Sep 17 00:00:00 2001 From: sjz <1240968267@qq.com> Date: 星期二, 22 七月 2025 15:30:09 +0800 Subject: [PATCH] 优化多组织 --- MES.Service/service/BasicData/MesItemsManager.cs | 8 ++++---- 1 files changed, 4 insertions(+), 4 deletions(-) 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 -- Gitblit v1.9.3