From 1653a432611f93b2595efbd335ae2d83b7e42f5c Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 14 二月 2025 08:25:39 +0800
Subject: [PATCH] 采购订单的项目，供应商，物料增加U9id的转换
---
StandardPda/MES.Service/service/BasicData/MesItemsManager.cs | 11 ++++++-----
1 files changed, 6 insertions(+), 5 deletions(-)
diff --git a/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs b/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs
index d5a23f8..7adff42 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
@@ -146,7 +147,7 @@
UseOrg = erpDetail.FUseOrgId,
CreateDate = DateTime.Now,
Company = "1000",
- Factory = "1000",
+ Factory = "1000"
};
list.Add(items);
}
@@ -158,7 +159,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