标准版初始化

lg

2025-11-20 b98df034707a61fd2857dbccd5a232605076ca59

 WebApi/GS.QC/Service/MesQaMjManager.cs

@@ -46,21 +46,28 @@
            var _sbBy =
                new StringBuilder(query.sortName + " " + query.sortOrder);
            var totalCount = 0;
            var itemsList = Db.Queryable<MesQaMj, MesItems, SysOrganization, MesSupplier>(
                    (a, b, org, d) => new JoinQueryInfos(
            var itemsList = Db.Queryable<MesQaMj, MesItems, SysOrganization, MesSupplier, SysUser, SysUser, SysUser>(
                    (a, b, org, d, u1, u2, u3) => new JoinQueryInfos(
                        JoinType.Inner, a.ItemId == b.Id,
                        JoinType.Inner, b.FSubsidiary == org.Fid,
                        JoinType.Left, a.SuppId == d.Id.ToString()
                        JoinType.Left, a.SuppId == d.Id.ToString(),
                        JoinType.Left, a.CheckUser == u1.Account,
                        JoinType.Left, a.CreateBy == u2.Account,
                        JoinType.Left, a.LastupdateBy == u3.Account
                    ))
                 .Where(_sbWhere.ToString())
                 .OrderBy(_sbBy.ToString())
                .Select((a, b, org, d) => new MesQaMj
                .Select((a, b, org, d, u1, u2, u3) => new MesQaMj
                {
                    FSubsidiary = "(" + org.FNumber + ") " + org.Name,
                    Guid = a.Guid.SelectAll(),
                    gysName = d.SuppName,
                    itemName = b.ItemName,
                    suppNo = d.SuppNo
                    suppNo = d.SuppNo,
                    // 新增：审核人、创建人、最后更新人姓名
                    CheckUserName = u1.UserName,
                    CreateByName = u2.UserName,
                    LastupdateByName = u3.UserName
                })
                .ToPageList(query.currentPage, query.everyPageSize,
                    ref totalCount);
@@ -103,6 +110,25 @@
        {
            LogHelper.Debug(ToString(), "GetModel error：" + ex.Message);
        }

        // 新增：联查SysUser获取CheckUser和LastupdateBy的姓名
        if (!string.IsNullOrEmpty(m.CheckUser))
        {
            var checkUserName = Db.Queryable<SysUser>()
                .Where(u => u.Account == m.CheckUser)
                .Select(u => u.UserName)
                .First();
            m.CheckUser = checkUserName ?? m.CheckUser;
        }
        if (!string.IsNullOrEmpty(m.LastupdateBy))
        {
            var lastupdateByName = Db.Queryable<SysUser>()
                .Where(u => u.Account == m.LastupdateBy)
                .Select(u => u.UserName)
                .First();
            m.LastupdateBy = lastupdateByName ?? m.LastupdateBy;
        }

        if (m != null)
            return ReturnDto<MesQaMj>.QuickReturn(m,
                ReturnCode.Success, "读取成功！");