| | |
|---|
| | | .Select((a, b, c) => |
|---|
| | | new |
|---|
| | | { |
|---|
| | | a.Id, a.BillNo, c.Daa001 |
|---|
| | | a.Id, |
|---|
| | | a.BillNo, |
|---|
| | | c.Daa001 |
|---|
| | | }) |
|---|
| | | .ToList(); |
|---|
| | | |
|---|
| | |
|---|
| | | JoinType.Left, a.Id == b.ItemInId)) |
|---|
| | | .Where((a, b) => a.BillNo == qsItemOqcReq.BillNo) |
|---|
| | | .Select((a, b) => new |
|---|
| | | { b.ItemBarcode, b.Quantity, b.MesScgdGxId }) |
|---|
| | | { b.ItemBarcode, b.Quantity, b.MesScgdGxId }) |
|---|
| | | .ToList(); |
|---|
| | | |
|---|
| | | var barCodes = mesInvItemInsList.Select(s => s.ItemBarcode).ToList(); |
|---|
| | |
|---|
| | | JoinType.Left, c.Id == m.ItemInId && a.ItemNo == m.ItemNo, |
|---|
| | | JoinType.Left, da.Daa001 == c.RbillNo, |
|---|
| | | JoinType.Left, da.Daa015 == z.LineNo //, |
|---|
| | | //JoinType.Left,c.Bgr == d.UserNo |
|---|
| | | //JoinType.Left,c.Bgr == d.UserNo |
|---|
| | | )) |
|---|
| | | // .WhereIF(lineNo != null && lineNo.Length > 0, |
|---|
| | | // (a, b, c, ca, m, da) => lineNo.Contains(da.Daa015)) |
|---|
