From 8ba0722979e389a8a2f5835022a7d305ab215c08 Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期四, 24 七月 2025 17:52:26 +0800
Subject: [PATCH] 来料检增加字段
---
StandardInterface/MES.Service/service/QC/LljService.cs | 28 +++++++++++++++-------------
1 files changed, 15 insertions(+), 13 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/LljService.cs b/StandardInterface/MES.Service/service/QC/LljService.cs
index 08a075a..9ac71ce 100644
--- a/StandardInterface/MES.Service/service/QC/LljService.cs
+++ b/StandardInterface/MES.Service/service/QC/LljService.cs
@@ -67,7 +67,7 @@
.Contains(queryObj.SearchValue.ToLower()))
// .OrderByDescending((a, b,
- .OrderBy("CASE WHEN a.STATUS = '宸叉彁浜�' THEN 0 ELSE 1 END, a.IQC_DATE desc, a.ID asc")
+ .OrderBy("CASE WHEN a.EMERGENCY = 1 THEN 0 ELSE 1 END, CASE WHEN a.STATUS = '宸叉彁浜�' THEN 0 ELSE 1 END, a.IQC_DATE desc, a.ID asc")
.ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList();
@@ -311,24 +311,24 @@
return input.Substring(startIndex + 1, length);
}
- public List<QamftpDto> GetAttachments(string releaseNo)
+ public List<QamftpDto> GetAttachments(string ItemNo)
{
- if (string.IsNullOrEmpty(releaseNo))
- {
- throw new ArgumentException("妫�楠屽崟鍙蜂笉鑳戒负绌�");
- }
+ //if (string.IsNullOrEmpty(ItemNo))
+ //{
+ // throw new ArgumentException("妫�楠屽崟鍙蜂笉鑳戒负绌�");
+ //}
var db = SqlSugarHelper.GetInstance();
try
{
return db.Queryable<MesQamftp>()
- .Where(x => x.ReleaseNo == releaseNo)
+ .Where(x => x.ItemNo == ItemNo)
.OrderBy(x => x.Fdate, OrderByType.Desc)
// .ThenBy(x => x.CreateDate, OrderByType.Desc)
.Select(x => new QamftpDto
{
Id = x.Id,
- ItemNo = x.ItemNo,
+ itemNo = x.ItemNo,
Ftype = x.Ftype,
Fattach = x.Fattach,
Fversion = x.Fversion,
@@ -337,7 +337,7 @@
CreateDate = x.CreateDate,
Company = x.Company,
Factory = x.Factory,
- ReleaseNo = x.ReleaseNo,
+
F_type = x.F_type,
LastupdateBy = x.LastupdateBy,
LastupdateDate = x.LastupdateDate,
@@ -861,15 +861,17 @@
return withOracle;
}
- //涓昏〃淇敼澶囨敞瀛楁
+ //涓昏〃淇敼瀛楁
public int saveRemarksGid(LLJDto dto)
{
return SqlSugarHelper.UseTransactionWithOracle(db =>
{
return db.Updateable<MesQaItemsDetect01>()
- .SetColumns(it =>
- it.FngDesc == dto.Remarks) //SetColumns鏄彲浠ュ彔鍔犵殑 鍐�2涓氨2涓瓧娈佃祴鍊�
- .SetColumns(it => it.PHSY == dto.PHSY)//鐮村潖瀹為獙鏁�
+ .SetColumns(it => it.FngDesc == dto.Remarks)
+ .SetColumns(it => it.PHSY == dto.PHSY)
+ .SetColumns(it => it.BLYY == dto.BLYY)
+ .SetColumns(it => it.SSCJ == dto.SSCJ)
+ .SetColumns(it => it.PSZT == dto.PSZT)
.Where(it => it.ReleaseNo == dto.releaseNo)
.ExecuteCommand();
});
--
Gitblit v1.9.3