2 回答

TA貢獻(xiàn)1828條經(jīng)驗(yàn) 獲得超3個(gè)贊
你可以嘗試使用.Where(i=> getConsignmentbookedin.Any(z=> z != i.pallet_identifier))
entity = new List<GoodInWarehouseBM>((from consighdrs in mi9db.consighdrs
join consigdests in mi9db.consigdests on consighdrs.consignment equals consigdests
.consignment
join consigliness in mi9db.consiglines on consigdests.condestint equals consigliness
.condestint
join productcodess in mi9db.productcodes on consigliness.varint equals productcodess.varint
join products in mi9db.products on productcodess.prodint equals products.prodint
where consigdests.destination == storeId && consighdrs.status == "T" && consighdrs.warehouse == "900"
group new { consigdests, productcodess, consigliness, products } by consigdests.consignment into grp
select new GoodInWarehouseBM
{
pallet_identifier = grp.Key,
shipment_items = grp.Select(a => new GoodInWarehouseBM.ShipmentItems
{
sku = a.productcodess.variantcode,
stock_qty = a.consigliness.issueqty,
description = a.products.proddesc
}).ToList()
}).Where(i=> getConsignmentbookedin.Any(z=> z != i.pallet_identifier)).ToList();

TA貢獻(xiàn)1856條經(jīng)驗(yàn) 獲得超17個(gè)贊
您應(yīng)該在組和選擇之前應(yīng)用過(guò)濾器,因?yàn)槟鷣G棄了不需要的所有內(nèi)容,所以它會(huì)大大提高您的查詢。
entity = new List<GoodInWarehouseBM>((from consighdrs in mi9db.consighdrs.Where(i=> !getConsignmentbookedin.Contains(i.Id(id of item not sure which one it is))
join consigdests in mi9db.consigdests on consighdrs.consignment equals consigdests
.consignment
join consigliness in mi9db.consiglines on consigdests.condestint equals consigliness
.condestint
join productcodess in mi9db.productcodes on consigliness.varint equals productcodess.varint
join products in mi9db.products on productcodess.prodint equals products.prodint
where consigdests.destination == storeId && consighdrs.status == "T" && consighdrs.warehouse == "900"
group new { consigdests, productcodess, consigliness, products } by consigdests.consignment into grp
select new GoodInWarehouseBM
{
pallet_identifier = grp.Key,
shipment_items = grp.Select(a => new GoodInWarehouseBM.ShipmentItems
{
sku = a.productcodess.variantcode,
stock_qty = a.consigliness.issueqty,
description = a.products.proddesc
}).ToList()
})).ToList();
- 2 回答
- 0 關(guān)注
- 114 瀏覽
添加回答
舉報(bào)