From 312b2c297ee58bc5735bd48c16f9680d6aff5681 Mon Sep 17 00:00:00 2001
From: 南骏 池 <chiffly@163.com>
Date: 星期一, 24 三月 2025 16:07:17 +0800
Subject: [PATCH] 1.图片文件操作新增一个通用controller 2.来料检备注更新优化。
---
service/base/MesImageManager.cs | 32 ++++++++++
Controllers/base/MesImageController.cs | 61 ++++++++++++++++++++
Dto/base/ImageDto.cs | 12 ++++
Controllers/QC/LljController.cs | 22 -------
service/QC/LljService.cs | 13 ++--
5 files changed, 113 insertions(+), 27 deletions(-)
diff --git a/Controllers/QC/LljController.cs b/Controllers/QC/LljController.cs
index 33746e9..0b2c7de 100644
--- a/Controllers/QC/LljController.cs
+++ b/Controllers/QC/LljController.cs
@@ -341,25 +341,5 @@
}
}
- //鏇存柊涓嶅悎鏍兼弿杩�
- [HttpPost("getImage")]
- public ResponseResult getImage(LLJDto rkjDto)
- {
- try
- {
- dynamic resultInfos = new ExpandoObject();
- var tbBillList = new LljService().updateRemarks(rkjDto);
- resultInfos.tbBillList = tbBillList;
- return new ResponseResult
- {
- status = 0,
- message = "OK",
- data = resultInfos
- };
- }
- catch (Exception ex)
- {
- return ResponseResult.ResponseError(ex);
- }
- }
+
}
\ No newline at end of file
diff --git a/Controllers/base/MesImageController.cs b/Controllers/base/MesImageController.cs
new file mode 100644
index 0000000..4c15216
--- /dev/null
+++ b/Controllers/base/MesImageController.cs
@@ -0,0 +1,61 @@
+锘縰sing System.Dynamic;
+using Microsoft.AspNetCore.Mvc;
+using NewPdaSqlServer.Dto.service;
+using NewPdaSqlServer.entity;
+using NewPdaSqlServer.service.@base;
+using NewPdaSqlServer.service.QC;
+using NewPdaSqlServer.util;
+
+namespace NewPdaSqlServer.Controllers.@base;
+
+[ApiController]
+[Route("api/[controller]")]
+public class MesImageController : ControllerBase
+{
+ private MesImageManager m = new();
+
+ //鑾峰彇鍥剧墖
+ [HttpPost("getImage")]
+ public ResponseResult getImage(ImageDto imgDto)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var tbBillList = m.getImage(imgDto);
+ resultInfos.tbBillList = tbBillList;
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+ //鑾峰彇鍥剧墖
+ [HttpPost("deleteImage")]
+ public ResponseResult deleteImage(ImageDto imgDto)
+ {
+ try
+ {
+ dynamic resultInfos = new ExpandoObject();
+ var tbBillList = m.deleteImage(imgDto);
+ resultInfos.tbBillList = tbBillList;
+ return new ResponseResult
+ {
+ status = 0,
+ message = "OK",
+ data = resultInfos
+ };
+ }
+ catch (Exception ex)
+ {
+ return ResponseResult.ResponseError(ex);
+ }
+ }
+
+}
\ No newline at end of file
diff --git a/Dto/base/ImageDto.cs b/Dto/base/ImageDto.cs
new file mode 100644
index 0000000..7b29397
--- /dev/null
+++ b/Dto/base/ImageDto.cs
@@ -0,0 +1,12 @@
+锘縰sing NewPdaSqlServer.entity;
+
+namespace NewPdaSqlServer.Dto.service;
+
+public class ImageDto
+{
+ //鍏宠仈鍗曟嵁id
+ public string? parentId { get; set; }
+ //鍥剧墖淇℃伅id
+ public string? id { get; set; }
+
+}
\ No newline at end of file
diff --git a/service/QC/LljService.cs b/service/QC/LljService.cs
index 4d08f59..4a0ae3a 100644
--- a/service/QC/LljService.cs
+++ b/service/QC/LljService.cs
@@ -730,19 +730,20 @@
//鍒犻櫎鐗瑰緛鍊�
public int deleteDetail13(LLJDto dto)
{
- var withOracle = Db.Deleteable<MesQaItemsDetectDetail13>()
+ var withOracle = Db.Updateable<MesQaItemsDetectDetail13>()
.Where(s => s.Guid.ToString() == dto.id13)
.ExecuteCommand();
return withOracle;
}
- //鍒犻櫎鐗瑰緛鍊�
- public List<MesFile> updateRemarks(LLJDto dto)
+ //鏇存柊涓嶅悎鏍兼弿杩�
+ public int updateRemarks(LLJDto dto)
{
- var withOracle = Db.Queryable<MesFile>()
- .Where(s => s.ParentGuid.ToString() == dto.gid)
- .ToList();
+ var withOracle = Db.Updateable<MesQaItemsDetect01>()
+ .SetColumns(s => s.Remarks == dto.Remarks)
+ .Where(s => s.Guid.ToString() == dto.gid)
+ .ExecuteCommand();
return withOracle;
}
diff --git a/service/base/MesImageManager.cs b/service/base/MesImageManager.cs
new file mode 100644
index 0000000..dd1d13d
--- /dev/null
+++ b/service/base/MesImageManager.cs
@@ -0,0 +1,32 @@
+锘縰sing NewPdaSqlServer.DB;
+using NewPdaSqlServer.Dto.service;
+using NewPdaSqlServer.entity;
+
+namespace NewPdaSqlServer.service.@base;
+
+public class MesImageManager : Repository<MesFile>
+{
+ //褰撳墠绫诲凡缁忕户鎵夸簡 Repository 澧炪�佸垹銆佹煡銆佹敼鐨勬柟娉�
+
+ //杩欓噷闈㈠啓鐨勪唬鐮佷笉浼氱粰瑕嗙洊,濡傛灉瑕侀噸鏂扮敓鎴愯鍒犻櫎 MesStaffManager.cs
+
+ //鑾峰彇鍥剧墖
+ public List<MesFile> getImage(ImageDto dto)
+ {
+ var withOracle = Db.Queryable<MesFile>()
+ .Where(s => s.ParentGuid.ToString() == dto.parentId)
+ .ToList();
+
+ return withOracle;
+ }
+
+ //鍒犻櫎鍥剧墖
+ public int deleteImage(ImageDto dto)
+ {
+ var withOracle = Db.Deleteable<MesFile>()
+ .Where(s => s.Guid.ToString() == dto.id)
+ .ExecuteCommand();
+
+ return withOracle;
+ }
+}
\ No newline at end of file
--
Gitblit v1.9.3