From 2a0ac6f8783c138a3fa3937e0594ae339260f5e3 Mon Sep 17 00:00:00 2001 From: zjh <2207896513@qq.com> Date: 星期五, 21 二月 2025 14:22:52 +0800 Subject: [PATCH] 1、Llj接口添加物料标识(FIRST)返回,0:非首次、1:首次 --- StandardPda/MES.Service/service/QC/LljService.cs | 13 +++++++------ 1 files changed, 7 insertions(+), 6 deletions(-) diff --git a/StandardPda/MES.Service/service/QC/LljService.cs b/StandardPda/MES.Service/service/QC/LljService.cs index 22a172b..d625b60 100644 --- a/StandardPda/MES.Service/service/QC/LljService.cs +++ b/StandardPda/MES.Service/service/QC/LljService.cs @@ -27,14 +27,14 @@ var itemIds = GetQaItem(db, queryObj.createUser); - var pageList = db.Queryable<LtsLlj, IqcBefore, SysUser>((a, b, c) => - new JoinQueryInfos(JoinType.Inner, a.ItemId == b.ItemId, - JoinType.Inner, b.Sid == c.Fid + var pageList = db.Queryable<LtsLlj, IqcBefore, SysUser, VMesQaItemsDetect01>((a, b, c,d) => + new JoinQueryInfos(JoinType.Left, a.ItemId == b.ItemId, + JoinType.Left, b.Sid == c.Fid,JoinType.Inner, a.Id == d.Id )) .WhereIF( StringUtil.IsNotNullOrEmpty(queryObj.result) && "鏈畬鎴�".Equals(queryObj.result), - (a, b, c) => a.FcheckResu == null) + (a, b, c) => a.FcheckResu == null ) .WhereIF( StringUtil.IsNotNullOrEmpty(queryObj.result) && !"鏈畬鎴�".Equals(queryObj.result), @@ -44,9 +44,10 @@ (a, b, c) => itemIds.Contains(a.ItemId)) .WhereIF(id > 0, (a, b, c) => a.Id == id) .OrderByDescending((a, b, c) => a.Id) - .Select((a, b, c) => new LtsLlj + .Select((a, b, c, d) => new LtsLlj { - UserName = c.Fname + UserName = c.Fname, + FIRST=d.First }, true) .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); -- Gitblit v1.9.3