| | |
|---|
| | | |
|---|
| | | var itemIds = GetQaItem(db, queryObj.createUser); |
|---|
| | | |
|---|
| | | var pageList = db.Queryable<LtsLlj>() |
|---|
| | | var pageList = db.Queryable<LtsLlj, IqcBefore, SysUser, VMesQaItemsDetect01, SysUser>((a, b, c,d,e) => |
|---|
| | | new JoinQueryInfos(JoinType.Left, a.ItemId == b.ItemId, |
|---|
| | | JoinType.Left, b.Sid == c.Fid, |
|---|
| | | JoinType.Inner, a.Id == d.Id, |
|---|
| | | JoinType.Left, a.CreateBy == e.Fcode |
|---|
| | | )) |
|---|
| | | .WhereIF( |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | "未完成".Equals(queryObj.result), |
|---|
| | | a => a.FcheckResu == null) |
|---|
| | | (a, b, c) => a.FcheckResu == null ) |
|---|
| | | .WhereIF( |
|---|
| | | StringUtil.IsNotNullOrEmpty(queryObj.result) && |
|---|
| | | !"未完成".Equals(queryObj.result), |
|---|
| | | a => a.FcheckResu != null) |
|---|
| | | (a, b, c) => a.FcheckResu != null) |
|---|
| | | .WhereIF( |
|---|
| | | itemIds is { Length: > 0 }, |
|---|
| | | a => itemIds.Contains(a.ItemId)) |
|---|
| | | .WhereIF(id > 0, a => a.Id == id) |
|---|
| | | .OrderByDescending(a => a.Id) |
|---|
| | | (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, d,e) => new LtsLlj |
|---|
| | | { |
|---|
| | | UserName = c.Fname, |
|---|
| | | FIRST=d.First, |
|---|
| | | CreateUserName=e.Fname |
|---|
| | | }, true) |
|---|
| | | .ToPageList(queryObj.PageIndex, queryObj.Limit, ref totalCount); |
|---|
| | | |
|---|
| | | return (pageList, totalCount); |
|---|
