| | |
| | | .Where((a, i) => a.Daa001 == query.daa001) |
| | | .Select((a, i) => new |
| | | { |
| | | a.Daa001, a.Eid |
| | | a.Daa001, a.RwdGuid |
| | | }).First(); |
| | | |
| | | if (womdaa?.Daa001 == null) throw new Exception("工单号不存在"); |
| | | |
| | | var womdabs = Db.Queryable<WwGd, WwGdDetail, MesItems, Womcab>( |
| | | var womdabs = Db.Queryable<WwGd, WwGdDetail, MesItems, ProductionOrderSub>( |
| | | (a, b, c, d) => |
| | | new JoinQueryInfos( |
| | | JoinType.Left, |
| | |
| | | JoinType.Inner, |
| | | c.Id == |
| | | b.Dab003, |
| | | JoinType.Inner, b.Erpid == d.Erpid |
| | | JoinType.Inner, b.Erpid.ToString() == d.ErpId |
| | | )) |
| | | .Where((a, b, c, d) => |
| | | a.Daa001 == query.daa001 && d.IssueType == "1") |
| | | a.Daa001 == query.daa001 && d.IssuingMethod == "1") |
| | | .Select((a, b, c, d) => new WwGdDetail |
| | | { |
| | | Pid = b.Pid, |
| | |
| | | .ToList(); |
| | | |
| | | var womcaa = Db.Queryable<ProductionOrder>() |
| | | .Where(s => s.ErpId == womdaa.Eid.ToString()) |
| | | .Where(s => s.Guid == womdaa.RwdGuid) |
| | | .First(); |
| | | |
| | | var dto = new ProductionPickDto |