記事編集

日付

ジャンルのカテゴリ―名

タイトル

内容の要旨

Controller側でデータベースの数値列を合計する&nbsp; public async Task&lt;IActionResult&gt; Index()&nbsp; {&nbsp;　　var kakeiContext = _context.Payment.Include(p =&gt; p.PayCategory);&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;// Amount列の合計を計算&nbsp; &nbsp; &nbsp;&nbsp;ViewBag.TotalAmount = amount.Sum(t =&gt; t.Amount);&nbsp; &nbsp; &nbsp; return View(await kakeiContext.ToListAsync());&nbsp; }View側でViewBag.TotalAmountのデータを表示する。（&lt;/table&gt;の外）&nbsp;@foreach (var item in Model) {&nbsp; &nbsp; &nbsp; &nbsp; &lt;tr&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;img src=&quot;data:image/jpeg;base64,@Convert.ToBase64String(item.PayCategory.CategoryImage)&quot; alt=&quot;CategoryName&quot; style=&quot;width: 40px; height: auto;&quot; /&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @Html.DisplayFor(modelItem =&gt; item.PayCategory.CategoryName)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @Html.DisplayFor(modelItem =&gt; item.Posted)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @Html.DisplayFor(modelItem =&gt; item.ItemName)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; @Html.DisplayFor(modelItem =&gt; item.Amount)&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a asp-action=&quot;Edit&quot; asp-route-id=&quot;@item.PaymentId&quot;&gt;Edit&lt;/a&gt; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a asp-action=&quot;Details&quot; asp-route-id=&quot;@item.PaymentId&quot;&gt;Details&lt;/a&gt; |&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;a asp-action=&quot;Delete&quot; asp-route-id=&quot;@item.PaymentId&quot;&gt;Delete&lt;/a&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &lt;/td&gt;&nbsp; &nbsp; &nbsp; &nbsp; &lt;/tr&gt;}&nbsp; &nbsp; &lt;/tbody&gt;&lt;/table&gt;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;&lt;h3&gt;Total Amount: @ViewBag.TotalAmount&lt;/h3&gt;

添付画像

画像を変更

Back to List

//検索文：Editor内でHTMLコードをコピーさせる