From 26fadad29b5de7846ebf5ec043f39a7d5e0448bb Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期二, 13 五月 2025 13:53:02 +0800
Subject: [PATCH] 查询来料检验单所有不良描述信息接口上传
---
StandardPda/MESApplication/Controllers/QC/LljController.cs | 30 +++++++++++++++++++++++++++++-
StandardPda/MES.Service/service/QC/LljService.cs | 8 ++++++++
2 files changed, 37 insertions(+), 1 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/LljService.cs b/StandardPda/MES.Service/service/QC/LljService.cs
index 9689a68..888e9b9 100644
--- a/StandardPda/MES.Service/service/QC/LljService.cs
+++ b/StandardPda/MES.Service/service/QC/LljService.cs
@@ -773,6 +773,14 @@
return SQLHelper.ExecuteQuery(sql1);
}
+ public DataTable getBlmsItem(string id)
+ {
+ OracleSQLHelper SQLHelper = new();
+ //鏌ヤ笉鑹弿杩�
+ var sql1 = string.Format(@"select FCHECK_ITEM,FUNIT from mes_qa_items_detect_detail5 f where RELEASE_NO='"+id+"' and FUNIT is not null order by FCHECK_ITEM");
+
+ return SQLHelper.ExecuteQuery(sql1);
+ }
public void saveYzxBDlist(string id,DataTable DB)
{
OracleSQLHelper SQLHelper = new();
diff --git a/StandardPda/MESApplication/Controllers/QC/LljController.cs b/StandardPda/MESApplication/Controllers/QC/LljController.cs
index ba87f37..21faab8 100644
--- a/StandardPda/MESApplication/Controllers/QC/LljController.cs
+++ b/StandardPda/MESApplication/Controllers/QC/LljController.cs
@@ -151,7 +151,6 @@
{
var id = data["id"]?.ToString();
- var releaseNo = data["releaseNo"]?.ToString();
try
{
var tbBillList =new LljService().getYzxBDlist(id);
@@ -170,6 +169,35 @@
}
/// <summary>
+ /// 鑾峰彇妫�楠屽崟鎵�鏈変笉鑹弿杩�
+ /// </summary>
+ /// <param name="data"></param>
+ /// <returns></returns>
+ [HttpPost("getJYBlmsItem")]
+ public ResponseResult getJYBlmsItem([FromBody] JObject data)
+ {
+
+ var id = data["id"]?.ToString();
+
+ try
+ {
+ var tbBillList = new LljService().getBlmsItem(id);
+
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = tbBillList
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+
+ /// <summary>
/// 淇濆瓨涓�鑷存�ф牳瀵归」鐩�
/// </summary>
/// <param name="data"></param>
--
Gitblit v1.9.3