From 917046b715a412f7ecee91ead1557d5a7df172a3 Mon Sep 17 00:00:00 2001
From: wbc <2597324127@qq.com>
Date: 星期六, 10 五月 2025 11:31:35 +0800
Subject: [PATCH] 巡检检验项
---
MES.Service/service/QC/SJService.cs | 20 ++++++++++++++++----
1 files changed, 16 insertions(+), 4 deletions(-)
diff --git a/MES.Service/service/QC/SJService.cs b/MES.Service/service/QC/SJService.cs
index 435dd6a..9362b8f 100644
--- a/MES.Service/service/QC/SJService.cs
+++ b/MES.Service/service/QC/SJService.cs
@@ -17,9 +17,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);
@@ -59,6 +57,7 @@
StringUtil.IsNotNullOrEmpty(queryObj.Result) &&
!"鏈畬鎴�".Equals(queryObj.Result),
a => a.Result != "鏈畬鎴�")
+ .WhereIF(queryObj.Comments != null, a => a.Comments == queryObj.Comments)
.OrderBy(a => a.BillNo, OrderByType.Desc)
.ToPageList(queryObj.PageIndex, queryObj.Limit);
@@ -224,7 +223,7 @@
item.Items = getQSItems(qsItemIpiReq.Id, null);
var sjPageResult = new SJPageResult
- { Id = item.From.Id, Limit = 1, PageIndex = 1 };
+ { Id = item.From.Id, Limit = 1, PageIndex = 1 };
item.Result = getPage(sjPageResult)[0];
return item;
@@ -411,6 +410,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