From cf5e996699836cc380b1cb469fea341475eb2b81 Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期一, 30 六月 2025 15:11:41 +0800
Subject: [PATCH] 代码提交

---
 StandardPda/MESApplication/Controllers/QC/LljController.cs |  422 +++++++++++++++++++++++++++++++++++++++++++++++++++-
 1 files changed, 408 insertions(+), 14 deletions(-)

diff --git a/StandardPda/MESApplication/Controllers/QC/LljController.cs b/StandardPda/MESApplication/Controllers/QC/LljController.cs
index 529ba55..7186298 100644
--- a/StandardPda/MESApplication/Controllers/QC/LljController.cs
+++ b/StandardPda/MESApplication/Controllers/QC/LljController.cs
@@ -1,10 +1,13 @@
-锘縰sing System.Dynamic;
-using MES.Service.Dto.service;
+锘縰sing MES.Service.Dto.service;
 using MES.Service.Modes;
 using MES.Service.service.QC;
 using MES.Service.util;
 using Microsoft.AspNetCore.Mvc;
+using Microsoft.EntityFrameworkCore.Metadata.Internal;
+using Newtonsoft.Json;
 using Newtonsoft.Json.Linq;
+using System.Data;
+using System.Dynamic;
 
 namespace MESApplication.Controllers.QC;
 
@@ -45,14 +48,14 @@
         try
         {
             dynamic resultInfos = new ExpandoObject();
-            var tbBillList =
-                new LljService().SetItems(itemNo, quantity, releaseNo);
-            resultInfos.tbBillList = tbBillList;
+
+            var msg = new LljService().SetItems(itemNo, quantity, releaseNo);
+
             return new ResponseResult
             {
-                status = 0,
-                message = "OK",
-                data = resultInfos
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = msg[1]
             };
         }
         catch (Exception ex)
@@ -83,6 +86,35 @@
         }
     }
 
+
+    [HttpPost("SaveCheckBy")]
+    public ResponseResult SaveCheckBy([FromBody] JObject data)
+    {
+        try
+        {
+            var NewStaffName = data["NewStaffName"].ToString();
+            var userID = data["userID"].ToString();
+            var releaseNo = data["releaseNo"].ToString();
+            var NewStaffUserID = data["NewStaffUserID"].ToString();
+
+            var msg =
+                new LljService().SaveCheckBy(NewStaffUserID, userID, releaseNo);
+
+
+            return new ResponseResult
+            {
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = msg[1]
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
     //getItems
     [HttpPost("getJYItem")]
     public ResponseResult getJYItem([FromBody] JObject data)
@@ -109,6 +141,123 @@
         }
     }
 
+    /// <summary>
+    ///     鑾峰彇涓�鑷存�ф牳瀵归」鐩�
+    /// </summary>
+    /// <param name="data"></param>
+    /// <returns></returns>
+    [HttpPost("getYzxItem")]
+    public ResponseResult getYzxItem([FromBody] JObject data)
+    {
+        var id = data["id"]?.ToString();
+        try
+        {
+            var tbBillList = new LljService().getYzxBDlist(id);
+
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = tbBillList
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <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>
+    /// <returns></returns>
+    [HttpPost("saveYzxItem")]
+    public ResponseResult saveYzxItem([FromBody] JObject data)
+    {
+        var id = data["id"]?.ToString();
+        var dataDt = data["data"]?.ToString();
+        var dt = JsonConvert.DeserializeObject<DataTable>(dataDt);
+        try
+        {
+            if (!dt.Columns.Contains("id"))
+            {
+                return new ResponseResult
+                {
+                    status = 1,
+                    message = "璇峰厛閫夋嫨鏁版嵁鍐嶄繚瀛橈紒",
+                    data = "璇峰厛閫夋嫨鏁版嵁鍐嶄繚瀛橈紒"
+                };
+            }
+            new LljService().saveYzxBDlist(id, dt);
+            var msg = new LljService().YzxImgVerify(id);
+
+            return new ResponseResult
+            {
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = ""
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     鑾峰彇鎵�鏈夋楠屽憳淇℃伅
+    /// </summary>
+    /// <param name="data"></param>
+    /// <returns></returns>
+    [HttpPost("getAllInspectors")]
+    public ResponseResult getAllInspectors([FromBody] JObject data)
+    {
+        try
+        {
+            var tbBillList = new LljService().getAllInspectors();
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = tbBillList
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
     //getXjDetail02ById
     [HttpPost("getXjDetail02ById")]
     public ResponseResult getXjDetail02ById([FromBody] JObject data)
@@ -126,6 +275,93 @@
                 status = 0,
                 message = "OK",
                 data = resultInfos
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
+    /// <summary>
+    ///     閫氳繃鏉$爜鑾峰彇閫佹鍗曚俊鎭�
+    /// </summary>
+    /// <param name="data"></param>
+    /// <returns></returns>
+    [HttpPost("getFromInfo")]
+    public ResponseResult getFromInfo([FromBody] JObject data)
+    {
+        var id = data["Barcode"]?.ToString();
+
+        try
+        {
+            dynamic resultInfos = new ExpandoObject();
+            var tbBillList =
+                new LljService().getFromInfo(id);
+            resultInfos.tbBillList = tbBillList;
+            if (resultInfos.tbBillList.Rows.Count>0)
+            {
+                return new ResponseResult
+                {
+                    status = 0,
+                    message = "OK",
+                    data = resultInfos
+                };
+            }
+            else
+            {
+                var mj =
+                new LljService().getFromMJCount(id);
+                if (mj>0)
+                {
+                    return new ResponseResult
+                    {
+                        status = 1,
+                        message = "璇ョ墿鏂欎负鍏嶆鐗╂枡锛屾棤闇�妫�楠岋紒",
+                        data = resultInfos
+                    };
+                }
+                else
+                {
+                    return new ResponseResult
+                    {
+                        status = 1,
+                        message = "鎵句笉鍒版楠屽崟鎹紝璇风‘璁よ揣鐗╂槸鍚︾鏀讹紒",
+                        data = resultInfos
+                    };
+                }
+              
+            }
+           
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+
+    /// <summary>
+    ///     鑾峰彇涓嶈壇鎻忚堪淇℃伅
+    /// </summary>
+    /// <param name="data"></param>
+    /// <returns></returns>
+    [HttpPost("getBlmsItem")]
+    public ResponseResult getBlmsItem([FromBody] JObject data)
+    {
+        try
+        {
+            var tbBillList = new LljService().getBlmsItem();
+            string[] arrRate = tbBillList.AsEnumerable()
+                .Select(d => d.Field<string>("DEFECT_NAME")).ToArray();
+
+
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = arrRate
             };
         }
         catch (Exception ex)
@@ -258,14 +494,13 @@
         try
         {
             dynamic resultInfos = new ExpandoObject();
-            var tbBillList =
-                new LljService().IqcQaSubmit(rkjDto);
-            resultInfos.tbBillList = tbBillList;
+            var msg = new LljService().IqcQaSubmit(rkjDto);
+
             return new ResponseResult
             {
-                status = 0,
-                message = "OK",
-                data = resultInfos
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = msg[1]
             };
         }
         catch (Exception ex)
@@ -273,4 +508,163 @@
             return ResponseResult.ResponseError(ex);
         }
     }
+
+    //IqcQaSubmit
+    [HttpPost("getImgBDlist")]
+    public ResponseResult getImgBDlist([FromBody] JObject data)
+    {
+        try
+        {
+            var id = data["id"]?.ToString();
+
+            var db = new LljService().getImgBDlist(id);
+
+            return new ResponseResult
+            {
+                status = int.Parse("0"),
+                message = "OK",
+                data = db
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     鑾峰彇U9鍥剧焊鏁版嵁
+    /// </summary>
+    /// <param name="data"></param>
+    /// <returns></returns>
+    [HttpPost("GetFileUrlByU9List")]
+    public async Task<ResponseResult> GetFileUrlByU9List(
+        [FromBody] JObject data)
+    {
+        try
+        {
+            var type = data["type"]?.ToString();
+            var itemID = data["u9No"]?.ToString();
+            dynamic resultInfos = new ExpandoObject();
+            var lljService = new LljService();
+            var tbBillList = await lljService.GetFileUrlByU9List(type, itemID);
+            if (tbBillList != null)
+                return new ResponseResult
+                {
+                    status = 0,
+                    message = "OK",
+                    data = tbBillList
+                };
+
+            return new ResponseResult
+            {
+                status = 0,
+                message = "OK",
+                data = ""
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     瀹為獙瀹ら�佹鏁版嵁淇濆瓨
+    /// </summary>
+    /// <param name="sysSubmit">瀹為獙瀹ら�佹鏁版嵁</param>
+    /// <returns></returns>
+    [HttpPost("SaveSysSubmit")]
+    public ResponseResult SaveSysSubmit(SysSubmit sysSubmit)
+    {
+        try
+        {
+            var msg = new LljService().SaveSysSubmit(sysSubmit);
+
+            return new ResponseResult
+            {
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = msg[1]
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
+    /// <summary>
+    ///     閫佽揣鍗曠鏀跺苟鐢熸垚鍒拌揣鍗�
+    /// </summary>
+    /// <param name="id"></param>
+    /// <returns></returns>
+    [HttpPost("SignDelivery")]
+    public async Task<ResponseResult> SignDelivery(string id)
+    {
+        try
+        {
+            //string[] msg = new LljService().SaveSysSubmit(sysSubmit);
+            var msg = await new LljService().SignDelivery(id);
+            return new ResponseResult
+            {
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = msg[1]
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+    /// <summary>
+    ///     閫佽揣鍗曠鏀跺苟鐢熸垚鍒拌揣鍗�
+    /// </summary>
+    /// <param name="id"></param>
+    /// <returns></returns>
+    [HttpPost("SignDelivery2")]
+    public async Task<ResponseResult> SignDelivery2(string id,string c_user)
+    {
+        try
+        {
+            //string[] msg = new LljService().SaveSysSubmit(sysSubmit);
+            var msg = await new LljService().SignDelivery2(id, c_user);
+            return new ResponseResult
+            {
+                status = int.Parse(msg[0]),
+                message = msg[1],
+                data = msg[1]
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+    /// <summary>
+    ///     鑾峰彇鎼哄浜戞祴璇曠幆澧冪鍚�
+    /// </summary>
+    /// <param name="id"></param>
+    /// <returns></returns>
+    [HttpGet("getTestXKYSign")]
+    public async Task<ResponseResult> getTestXKYSign()
+    {
+        try
+        {
+            //string[] msg = new LljService().SaveSysSubmit(sysSubmit);
+            var msg = await new LljService().getTestXKYSign();
+            return new ResponseResult
+            {
+                status = int.Parse(msg[0]),
+                message = "OK",
+                data = msg[1]
+            };
+        }
+        catch (Exception ex)
+        {
+            return ResponseResult.ResponseError(ex);
+        }
+    }
+
 }
\ No newline at end of file

--
Gitblit v1.9.3