From 2389c8496f97aa2c15c5e4e7475de39b967d678c Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期三, 23 七月 2025 09:03:52 +0800
Subject: [PATCH] 产测查询工单数据接口调整，改为按站位号反查产线，再通过产线查出工单信息
---
StandardPda/MES.Service/service/BasicData/MesItemsManager.cs | 9 ++++++---
1 files changed, 6 insertions(+), 3 deletions(-)
diff --git a/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs b/StandardPda/MES.Service/service/BasicData/MesItemsManager.cs
index 26a0fc9..cafaa5e 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;
@@ -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,8 @@
CreateDate = DateTime.Now,
Company = "1000",
Factory = "1000",
+ WarehouseKeeper = item.WarehouseKeeper,
+ Merchandiser = item.Merchandiser
};
list.Add(items);
}
@@ -158,7 +161,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