1.0 select 结果集中嵌套子集合查询
var sResult = (from a in details
select new
{
a.item_no,
item_barcods = (from b in Repository.t_im_sheet_barcode_qty
where b.sheet_no==a.sheet_no && b.item_no==a.item_no
select new
{
b.item_no,
b.item_barcode,
b.qty
})
}).ToList();
2.0 内联结,关联条件多个联合查询
var rlt = (from a in Repository.t_im_sheet_barcode_qty
join ib in Repository.t_bd_item_barcode on new { a.item_no, a.item_barcode } equals new { ib.item_no, ib.item_barcode }
join c in Repository.t_bd_color_code on ib.color_id equals c.color_id
join s in Repository.t_bd_size_code on ib.size_id equals s.size_id
where a.item_no == item.item_no && a.sheet_no == item.sheet_no
select new
{
a.item_barcode,
ib.color_id,
c.color_name,
ib.size_id,
s.size_name,
qty = a.qty,
inPrice = item.item_price,
item_name = item.item_name,
item_no = a.item_no,
}).ToList();