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