From 76cdb99e924eebdd5025584c103fa9bfdf0adecc Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期一, 12 五月 2025 19:14:11 +0800 Subject: [PATCH] 获取所有检验单图片接口上传 --- StandardPda/MES.Service/service/QC/BaseService.cs | 14 ++++++++++++++ 1 files changed, 14 insertions(+), 0 deletions(-) diff --git a/StandardPda/MES.Service/service/QC/BaseService.cs b/StandardPda/MES.Service/service/QC/BaseService.cs index 4c9af3a..7e4abef 100644 --- a/StandardPda/MES.Service/service/QC/BaseService.cs +++ b/StandardPda/MES.Service/service/QC/BaseService.cs @@ -1,5 +1,6 @@ 锘縰sing MES.Service.DB; using MES.Service.Modes; +using SqlSugar; namespace MES.Service.service.QC; @@ -50,4 +51,17 @@ }); return mesQsImages; } + public List<MesQsImage> getLljAllImgByFid(string id, string qsType) + { + var db = SqlSugarHelper.GetInstance(); + var mesQsImages = db.Queryable<MesQsImage,MesQaItemsDetectDetail5>((a,b)=> + new JoinQueryInfos(JoinType.Left,a.Fid==b.Id)) + .Where((a,b)=> b.ReleaseNo == id && a.Id != null).ToList(); + mesQsImages.ForEach(s => + { + if (s.ImageData is { Length: > 0 }) + s.base64Date = Convert.ToBase64String(s.ImageData); + }); + return mesQsImages; + } } \ No newline at end of file -- Gitblit v1.9.3