2 回答

TA貢獻1828條經驗 獲得超3個贊
你可以嘗試使用.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貢獻1856條經驗 獲得超17個贊
您應該在組和選擇之前應用過濾器,因為您丟棄了不需要的所有內容,所以它會大大提高您的查詢。
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 關注
- 118 瀏覽
添加回答
舉報