我正在從多個表中獲取基于 ID 的資料。這是我的代碼。
public async Task<IActionResult> GeneratePDF(string uniqID)
{
//Other code
List<MasterDetails> MasterData = await _dbInvoiceInfoContext.GetAllInvoiceAsync();
CustData.CustInvoiceInfo = MasterData[0].CustInvoiceInfo;
CustData.CustInvoiceTotalInfo = MasterData[0].CustInvoiceTotalInfo;
List<MasterDetails> MasterData1 = await _dbClientInfoContext.GetAllClientAsync();
CustData.CustClientInfo = MasterData1[0].CustClientInfo;
CustData.CustClientAddress = MasterData1[0].CustClientAddress;
IEnumerable<MasterDetails> clientRecord = from c in CustData.CustInvoiceInfo
join a in CustData.CustInvoiceTotalInfo on
c.InvoiceUniqueID equals a.InvoiceId into table1
from a in table1.ToList()
join b in CustData.CustClientInfo on
c.InvoiceClientId equals b.ClientId into table2
from b in table2.ToList()
select new MasterDetails
{
finalInvoiceInfo = c,
finalInvoiceTotalInfo = a,
finalClientInfo = b
};
}
如何在上面的代碼中放置 where 條件并根據unidID獲取資料？unidID是我從另一個 ActionResult 頁面傳遞的 ID 。
uj5u.com熱心網友回復：
您可以在Where之后添加table2.ToList()，但請注意括號是必需的，以便將搜索的內容視為完整的物件。
IEnumerable<MasterDetails> clientRecord = （from c in CustData.CustInvoiceInfo
join a in CustData.CustInvoiceTotalInfo on
c.InvoiceUniqueID equals a.InvoiceId into table1
from a in table1.ToList()
join b in CustData.CustClientInfo on
c.InvoiceClientId equals b.ClientId into table2
from b in table2.ToList()).Where(a=>a.unidID=unidID)
select new MasterDetails
{
finalInvoiceInfo = c,
finalInvoiceTotalInfo = a,
finalClientInfo = b
};
或者
IEnumerable<MasterDetails> clientRecord = from c in CustData.CustInvoiceInfo
join a in CustData.CustInvoiceTotalInfo on
c.InvoiceUniqueID equals a.InvoiceId into table1
from a in table1.ToList()
join b in CustData.CustClientInfo on
c.InvoiceClientId equals b.ClientId into table2
from b in table2.ToList()
select new MasterDetails
{
finalInvoiceInfo = c,
finalInvoiceTotalInfo = a,
finalClientInfo = b
};
var data=clientRecord.Where()...
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/461155.html
標籤：sql服务器 asp.net 核心 .net-core asp.net-mvc-5 asp.net-core-mvc