From 5159c3dc64fc7a783384b1c13da01f338340e5dd Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期五, 16 五月 2025 15:58:02 +0800
Subject: [PATCH] bug修改
---
StandardInterface/MES.Service/service/QC/LljService.cs | 20 ++++++++++++--------
1 files changed, 12 insertions(+), 8 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/LljService.cs b/StandardInterface/MES.Service/service/QC/LljService.cs
index 4e9276f..713ea9e 100644
--- a/StandardInterface/MES.Service/service/QC/LljService.cs
+++ b/StandardInterface/MES.Service/service/QC/LljService.cs
@@ -43,7 +43,11 @@
|| a.ItemName.ToLower()
.Contains(queryObj.SearchValue.ToLower())
|| a.ItemNo.ToLower()
- .Contains(queryObj.SearchValue.ToLower()))
+ .Contains(queryObj.SearchValue.ToLower())
+ || a.LotNo.ToLower()
+ .Contains(queryObj.SearchValue.ToLower())
+ || a.ReleaseNo.ToLower()
+ .Contains(queryObj.SearchValue.ToLower()))
.OrderByDescending(a => a.Id)
.ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
@@ -59,9 +63,9 @@
/// <param name="quantity"></param>
/// <param name="releaseNo"></param>
/// <returns></returns>
- public string[] SetItems(string itemNo,
- decimal quantity, string releaseNo)
+ public string[] SetItems(decimal itemNo, decimal quantity, string releaseNo)
{
+
// 瀹氫箟杈撳嚭鍙傛暟
var outputResult = new SugarParameter("o_Result", null,
DbType.Int32, ParameterDirection.Output,
@@ -74,8 +78,8 @@
// 瀹氫箟杈撳叆鍙傛暟
var parameters = new List<SugarParameter>
{
- new("P_RELEASE_NO", releaseNo,
- DbType.String, ParameterDirection.Input),
+ new("P_RELEASE_NO", releaseNo, DbType.String, ParameterDirection.Input),
+ new("P_ITEM_ID", itemNo, DbType.String, ParameterDirection.Input),
outputResult,
outputMessage
};
@@ -84,7 +88,7 @@
// 浣跨敤 SqlSugar 鎵ц瀛樺偍杩囩▼
db.Ado.ExecuteCommand(
- "BEGIN PRC_QA_ITEM_INSERT_BTN(:P_RELEASE_NO, :o_Result, :o_Msg); END;",
+ "BEGIN PRC_QA_ITEM_INSERT_BTN(:P_RELEASE_NO,:P_ITEM_ID, :o_Result, :o_Msg); END;",
parameters.ToArray());
// 鑾峰彇杈撳嚭鍙傛暟鐨勫��
@@ -482,8 +486,8 @@
return SqlSugarHelper.UseTransactionWithOracle(db =>
{
return db.Updateable<MesQaItemsDetectDetail5>()
- // .SetColumns(it =>
- // it.Remarks == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
+ .SetColumns(it =>
+ it.Funit == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
.Where(it => it.Id == dto.pid)
.ExecuteCommand();
});
--
Gitblit v1.9.3