From 26fadad29b5de7846ebf5ec043f39a7d5e0448bb Mon Sep 17 00:00:00 2001
From: zjh <2207896513@qq.com>
Date: 星期二, 13 五月 2025 13:53:02 +0800
Subject: [PATCH] 查询来料检验单所有不良描述信息接口上传
---
StandardPda/MES.Service/service/QC/BaseService.cs | 34 ++++++++++++++++++++++++----------
1 files changed, 24 insertions(+), 10 deletions(-)
diff --git a/StandardPda/MES.Service/service/QC/BaseService.cs b/StandardPda/MES.Service/service/QC/BaseService.cs
index d99828f..7e4abef 100644
--- a/StandardPda/MES.Service/service/QC/BaseService.cs
+++ b/StandardPda/MES.Service/service/QC/BaseService.cs
@@ -1,20 +1,21 @@
锘縰sing MES.Service.DB;
using MES.Service.Modes;
+using SqlSugar;
namespace MES.Service.service.QC;
public class BaseService
{
- // public string?[] getUserLineNo(string userNo)
- // {
- // //MesLineUser
- // var db = SqlSugarHelper.GetInstance();
- // var mesLineUsers = db.Queryable<MesLineUser>()
- // .Where(a => a.Fcode == userNo)
- // .ToList();
- // // 浣跨敤 Distinct 鏂规硶瀵� LineNo 杩涜鍘婚噸
- // return mesLineUsers.Select(s => s.LineNo).Distinct().ToArray();
- // }
+ public string?[] getUserLineNo(string userNo)
+ {
+ //MesLineUser
+ var db = SqlSugarHelper.GetInstance();
+ var mesLineUsers = db.Queryable<MesLineUser>()
+ .Where(a => a.Fcode == userNo)
+ .ToList();
+ // 浣跨敤 Distinct 鏂规硶瀵� LineNo 杩涜鍘婚噸
+ return mesLineUsers.Select(s => s.LineNo).Distinct().ToArray();
+ }
public int saveImage(List<MesQsImage> entity)
{
@@ -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