在我的 ASP.NET MVC 應用程式中，我想創建請求詳細資訊和每個請求的總金額的視圖。
這就是我創建視圖模型的方式
public class ApprovedMedicals
{
public int ReqId { get; set; }
public int EmpNo { get; set; }
public string Company { get; set; }
public string EmpName { get; set; }
public string ApprovedMedicalNo { get; set; }
public decimal TotalAmount { get; set; }
public DateTime CreatedDate { get; set; }
public DateTime? ApprovedDate { get; set; }
}
為了獲取資料并將其分配給我，我使用了 3 個資料庫表。AppRequest主要Medical是通過外鍵連接AppRequest和MedicalExpences通過連接Medical。MedicalExpences因此，一個請求可能在表中有 1 條或多條記錄。所以我想AmountClaimed從該表中獲取總和并將其分配給Total AmountView Model 屬性。我被困在如何計算總和并將其分配給列部分。請你幫我一下好嗎？
List < ApprovedMedicals > report = (from a in db.AppRequest
join m in db.Medical on a.Id equals m.Req_Id
join me in db.MedicalExpences on m.Id equals me.Medic_Id
join e in db.CreateEmployee on a.Create_By equals e.Id
join c in db.CreateCompany on e.CompanyId equals c.Id
where m.HodApproval == true && m.HodApprovedDate <=
ToDate && m.HodApprovedDate >= FromDate
select new ApprovedMedicals {
EmpNo = e.EmpNo,
EmpName = e.EmpName,
Company = c.CompanyName,
ApprovedMedicalNo = m.ApproveNumber,
ApprovedDate = m.HodApprovedDate,
CreatedDate = a.Created_Date,
ReqId = a.Id,
TotalAmount = // Here I want to get the Total of me.Amount
}).OrderByDescending(x => x.ReqId).ToList();
uj5u.com熱心網友回復：
嘗試 ：
List < ApprovedMedicals > report = (from a in db.AppRequest
join m in db.Medical on a.Id equals m.Req_Id
join me in db.MedicalExpences on m.Id equals me.Medic_Id
join e in db.CreateEmployee on a.Create_By equals e.Id
join c in db.CreateCompany on e.CompanyId equals c.Id
where m.HodApproval == true && m.HodApprovedDate <=
ToDate && m.HodApprovedDate >= FromDate
select new ApprovedMedicals {
EmpNo = e.EmpNo,
EmpName = e.EmpName,
Company = c.CompanyName,
ApprovedMedicalNo = m.ApproveNumber,
ApprovedDate = m.HodApprovedDate,
CreatedDate = a.Created_Date,
ReqId = a.Id,
TotalAmount = 0
}).OrderByDescending(x => x.ReqId).ToList();
foreach (var item in report)
{
var Id = db.Medical.Where(x => x.Req_Id == item.ReqId).Select(x => x.Id).FirstOrDefault();
item.TotalAmount = db.MedicalExpences.Where(x => x.Medic_Id == Id).Sum(x => x.Amount);
}
轉載請註明出處，本文鏈接：https://www.uj5u.com/qita/445778.html
標籤：C＃ 网 asp.net-mvc asp.net-mvc-4