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 | 10 +++++-----
1 files changed, 5 insertions(+), 5 deletions(-)
diff --git a/MES.Service/service/BasicData/MesItemsManager.cs b/MES.Service/service/BasicData/MesItemsManager.cs
index f3ab3cf..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<MesItems>().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<Organize>().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
@@ -143,7 +143,7 @@
return new MesItems
{
Id = Convert.ToDecimal(item.Id),
- ItemId= Convert.ToDecimal(item.Id),
+ ItemId = Convert.ToDecimal(item.Id),
ItemNo = item.FNumber,
ItemName = item.FName,
ItemModel = item.FSpecification,
--
Gitblit v1.9.3