| | |
| | | using MES.Service.DB; |
| | | using MES.Service.Modes; |
| | | using SqlSugar; |
| | | |
| | | namespace MES.Service.service.QC; |
| | | |
| | | public class BaseService |
| | | { |
| | | public string[]? getUserLineNo(string userNo) |
| | | public string?[] getUserLineNo(string userNo) |
| | | { |
| | | //MesLineUser |
| | | var db = SqlSugarHelper.GetInstance(); |
| | | var mesLineUsers = db.Queryable<MesLineUser>() |
| | | .Where(a => a.Fcode == userNo) |
| | | .ToList(); |
| | | return mesLineUsers.Select(s => s.LineNo).ToArray(); |
| | | // 使用 Distinct 方法对 LineNo 进行去重 |
| | | return mesLineUsers.Select(s => s.LineNo).Distinct().ToArray(); |
| | | } |
| | | |
| | | public int saveImage(List<MesQsImage> entity) |
| | |
| | | }); |
| | | 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; |
| | | } |
| | | } |