| | |
|---|
| | | // 查询 |
|---|
| | | var result = Db |
|---|
| | | .Queryable<MesQaItemsDetect01, MesInvItemArn, MesInvItemArnDetail, |
|---|
| | | MesItems, MesUnit>( |
|---|
| | | (a, d, b, c, t) => new object[] |
|---|
| | | MesItems, MesUnit,MesQaItemsDetectDetail5>( |
|---|
| | | (a, d, b, c, t,z) => new object[] |
|---|
| | | { |
|---|
| | | JoinType.Inner, d.BillNo == a.LotNo, |
|---|
| | | JoinType.Inner, d.Id == b.Mid && b.ItemNo == a.ItemNo, |
|---|
| | | JoinType.Inner, |
|---|
| | | a.ItemNo == c.ItemNo && a.Company == c.Company && |
|---|
| | | a.Factory == c.Factory, |
|---|
| | | JoinType.Inner, c.Fpurchaseunitid == t.Id |
|---|
| | | JoinType.Inner, c.Fpurchaseunitid == t.Id, |
|---|
| | | JoinType.Inner, z.ReleaseNo == a.ReleaseNo |
|---|
| | | }) |
|---|
| | | .Where((a, d, b, c, t) => a.FngHandle == "退货" && |
|---|
| | | .Where((a, d, b, c, t,z) => a.FngHandle == "退货" && |
|---|
| | | z.FcheckResu == "不合格" && |
|---|
| | | query.ItemArnDetailIds.Contains(b.Id)) |
|---|
| | | .Select((a, d, b, c, t) => new Material |
|---|
| | | { |
|---|
