From 27bd7530f8c1334b9338dea64002164bd74de8ac Mon Sep 17 00:00:00 2001
From: 啊鑫 <t2856754968@163.com>
Date: 星期五, 30 五月 2025 14:50:25 +0800
Subject: [PATCH] 入库检验的逻辑修改
---
MES.Service/service/QC/SJService.cs | 33 ++++++++++++++++++++++++++-------
1 files changed, 26 insertions(+), 7 deletions(-)
diff --git a/MES.Service/service/QC/SJService.cs b/MES.Service/service/QC/SJService.cs
index 0f0f20a..b83cc8e 100644
--- a/MES.Service/service/QC/SJService.cs
+++ b/MES.Service/service/QC/SJService.cs
@@ -1,4 +1,5 @@
-锘縰sing System.Data;
+锘縰sing System.Buffers;
+using System.Data;
using MES.Service.DB;
using MES.Service.Dto.service;
using MES.Service.Modes;
@@ -17,7 +18,7 @@
{
var db = SqlSugarHelper.GetInstance();
var date = DateTime.Now.ToString("yyyy-MM-dd");
- var sql ="select max(BILL_NO) from QS_ITEM_IPI_REQ where to_char(CREATE_TIME,'yyyy-mm-dd') = '" + date + "'";
+ var sql = "select max(BILL_NO) from QS_ITEM_IPI_REQ where to_char(CREATE_TIME,'yyyy-mm-dd') = '" + date + "'";
var maxBillNo = db.Ado.SqlQuerySingle<string>(sql);
@@ -34,9 +35,11 @@
}
//鑾峰彇鎵�鏈夋暟鎹垎椤�
- public List<SJPageResult> getPage(SJPageResult queryObj)
+ public (List<SJPageResult> items, int TotalCount) getPage(SJPageResult queryObj)
{
var db = SqlSugarHelper.GetInstance();
+
+ var totalCount = 0;
string[]? lineNo = null;
@@ -57,10 +60,13 @@
StringUtil.IsNotNullOrEmpty(queryObj.Result) &&
!"鏈畬鎴�".Equals(queryObj.Result),
a => a.Result != "鏈畬鎴�")
+ .WhereIF(queryObj.Comments != null, a => a.Comments == queryObj.Comments)
+ .WhereIF(StringUtil.IsNotNullOrEmpty(queryObj.SearchValue),a=>a.BillNo.Contains(queryObj.SearchValue)
+ || a.ItemNo.Contains(queryObj.SearchValue))
.OrderBy(a => a.BillNo, OrderByType.Desc)
- .ToPageList(queryObj.PageIndex, queryObj.Limit);
+ .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
- return data;
+ return (data, totalCount);
}
@@ -222,8 +228,8 @@
item.Items = getQSItems(qsItemIpiReq.Id, null);
var sjPageResult = new SJPageResult
- { Id = item.From.Id, Limit = 1, PageIndex = 1 };
- item.Result = getPage(sjPageResult)[0];
+ { Id = item.From.Id, Limit = 1, PageIndex = 1 };
+ item.Result = getPage(sjPageResult).items[0];
return item;
}
@@ -409,6 +415,19 @@
});
}
+ //涓昏〃淇敼澶囨敞瀛楁1
+ public int saveCommentGid(QsItem dto)
+ {
+ return SqlSugarHelper.UseTransactionWithOracle(db =>
+ {
+ return db.Updateable<QsItemIpiReq>()
+ .SetColumns(it =>
+ it.Comments == dto.Comments) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
+ .Where(it => it.Id == dto.gid)
+ .ExecuteCommand();
+ });
+ }
+
//瀛愯〃淇敼澶囨敞瀛楁
public int saveRemarksPid(QsItem dto)
{
--
Gitblit v1.9.3