From d6b12fe74eaee1b68ca518507749ee5989503ef6 Mon Sep 17 00:00:00 2001
From: xwt <2740516069@qq.com>
Date: 星期四, 07 八月 2025 21:04:09 +0800
Subject: [PATCH] 来料检接口修改
---
StandardInterface/MES.Service/service/QC/LljService.cs | 31 ++++++++++++---
StandardInterface/MESApplication/Controllers/QC/LljController.cs | 45 ++++++++++++++++++++++
2 files changed, 70 insertions(+), 6 deletions(-)
diff --git a/StandardInterface/MES.Service/service/QC/LljService.cs b/StandardInterface/MES.Service/service/QC/LljService.cs
index 9ac71ce..272b38a 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.EMERGENCY = 1 THEN 0 ELSE 1 END, 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, a.IQC_DATE desc, CASE WHEN a.STATUS = '宸叉彁浜�' THEN 0 ELSE 1 END, a.ID asc")
.ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount);
var emergencyValues = pageList.Select(item => item.EMERGENCY).ToList();
@@ -868,15 +868,34 @@
{
return db.Updateable<MesQaItemsDetect01>()
.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();
});
}
-
+ //涓昏〃淇敼鐮村潖瀹為獙
+ public int savePhsyGid(LLJDto dto)
+ {
+ return SqlSugarHelper.UseTransactionWithOracle(db =>
+ {
+ return db.Updateable<MesQaItemsDetect01>()
+ .SetColumns(it => it.PHSY == dto.PHSY)
+ .Where(it => it.ReleaseNo == dto.releaseNo)
+ .ExecuteCommand();
+ });
+ }
+ // 涓昏〃淇敼涓嬫媺妗嗗瓧娈�
+ public int saveDropdownFields(LLJDto dto)
+ {
+ return SqlSugarHelper.UseTransactionWithOracle(db =>
+ {
+ return db.Updateable<MesQaItemsDetect01>()
+ .SetColumns(it => it.BLYY == dto.BLYY)
+ .SetColumns(it => it.PSZT == dto.PSZT)
+ .SetColumns(it => it.SSCJ == dto.SSCJ)
+ .Where(it => it.ReleaseNo == dto.releaseNo)
+ .ExecuteCommand();
+ });
+ }
//瀛愯〃淇敼澶囨敞瀛楁
public int saveRemarksPid(LLJDto dto)
{
diff --git a/StandardInterface/MESApplication/Controllers/QC/LljController.cs b/StandardInterface/MESApplication/Controllers/QC/LljController.cs
index 838c228..a206bee 100644
--- a/StandardInterface/MESApplication/Controllers/QC/LljController.cs
+++ b/StandardInterface/MESApplication/Controllers/QC/LljController.cs
@@ -204,6 +204,51 @@
}
}
+ //savePhsyGid 涓昏〃娣诲姞鐮村潖瀹為獙
+ [HttpPost("savePhsyGid")]
+ public ResponseResult savePhsyGid([FromBody] LLJDto rkjDto)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var tbBillList =
+ new LljService().savePhsyGid(rkjDto);
+ resultInfos.tbBillList = tbBillList;
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+ [HttpPost("saveDropdownFields")]
+ public ResponseResult saveDropdownFields([FromBody] LLJDto rkjDto)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var tbBillList =
+ new LljService().saveDropdownFields(rkjDto);
+ resultInfos.tbBillList = tbBillList;
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
//saveRemarksPid 瀛愯〃娣诲姞涓嶅悎鏍兼弿杩�
[HttpPost("saveRemarksPid")]
public ResponseResult saveRemarksPid([FromBody] LLJDto rkjDto)
--
Gitblit v1.9.3