15 lines
474 B
C#
15 lines
474 B
C#
var prod = context.ProdBom
|
|
.Join(context.ProdTable,
|
|
pb => pb.ProdId,
|
|
pt => pt.Id,
|
|
(pb, pt) => new
|
|
{
|
|
ProdBom = pb,
|
|
ProdTable = pt
|
|
})
|
|
.Where(x => x.ProdTable.ProjId == prodTable.ProjId
|
|
&& x.ProdTable.SubProjId == prodTable.SubProjId
|
|
&& x.ProdBom.ItemId == prodTable.ItemId
|
|
&& x.ProdBom.ProdId == x.ProdTable.Id)
|
|
.Select(x => x.ProdTable)
|
|
.ToList(); |