記事編集

日付

ジャンルのカテゴリ―名

タイトル

内容の要旨

<p data-bm="35" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: 4px; padding: revert; -webkit-line-clamp: revert; color: rgba(0, 0, 0, 0.8); font-family: roboto, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;" data-pasted="true">なるほど、やりたいことは&nbsp;ASP.NET Core MVC の Create ビューで、親 <code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">&lt;select&gt;</code> に「新規項目」を追加できるようにし、その場で子 <code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">&lt;select&gt;</code> にも新規項目を追加し、DB に保存する ということですね。 これは&nbsp;親子マスタの動的追加 + Ajax 連動 のパターンです。<p data-bm="36" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: 4px; padding: revert; -webkit-line-clamp: revert; color: rgba(0, 0, 0, 0.8); font-family: roboto, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">以下に、完全な実装例 を示します。 （親：<code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">PaymentTypes</code>、子：<code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">PaymentMethods</code>）<h2 data-bm="37" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: revert; padding: revert; font: 22px / 24px roboto, helvetica, sans-serif; height: 32px; -webkit-line-clamp: 1; overflow: hidden; text-overflow: ellipsis; display: -webkit-box; -webkit-box-orient: vertical; color: rgba(0, 0, 0, 0.8); letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">1. モデル定義</h2><pre data-priority="2" data-bm="38" style="background: none 0% 0% / auto repeat scroll padding-box border-box rgb(245, 245, 245); border: 1px solid rgba(0, 0, 0, 0.1); border-radius: 8px; overflow: hidden; color: rgba(0, 0, 0, 0.8); font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><div data-bm="45" style="display: flex; height: 28px; flex-direction: row; justify-content: space-between; align-items: center; gap: 8px; padding: 8px 12px; border-bottom: 1px solid rgba(0, 0, 0, 0.1); background: none 0% 0% / auto repeat scroll padding-box border-box rgb(248, 244, 241);"><h5 style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: 0px; padding: revert; font-style: normal !important; font-variant: normal !important; font-weight: 400 !important; font-stretch: 100% !important; line-height: 18px; font-family: roboto, helvetica, sans-serif !important; font-optical-sizing: auto !important; font-size-adjust: none !important; font-kerning: auto !important; font-feature-settings: normal !important; font-variation-settings: normal !important; font-language-override: normal !important; font-size: 16px; display: inline-block; color: rgb(60, 81, 180);">Csharp</h5><div style="height: 28px;"><button type="button" tabindex="" title="Copy code" style="box-sizing: border-box; margin: 0px; padding: 0px; font: 400 13px / 20px roboto, helvetica, sans-serif; background-color: rgb(217, 223, 251); border: 1px solid rgba(0, 0, 0, 0); display: grid; grid-auto-flow: column; align-items: center; cursor: pointer; color: rgb(60, 81, 180) !important; text-decoration: none !important; border-radius: 9999px; block-size: 28px; gap: 2px; padding-inline: 10px;"><div style="box-sizing: border-box; margin: 0px; padding: 0px; min-inline-size: 0px; max-inline-size: 100%; white-space: nowrap; text-overflow: ellipsis; overflow: clip; max-block-size: calc(1lh); padding-inline: 2px;">Copy code</div></button></div></div><code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255); display: block; white-space: pre-wrap; overflow-wrap: anywhere; padding: 8px 16px 16px;">// 親テーブル
public class PaymentType
{
 public int Id { get; set; }
 public string Name { get; set; }
 public ICollection&lt;PaymentMethod&gt; PaymentMethods { get; set; }
}

// 子テーブル
public class PaymentMethod
{
 public int Id { get; set; }
 public string Name { get; set; }

 public int PaymentTypeId { get; set; }
 public PaymentType PaymentType { get; set; }
}
</code></pre><h2 data-bm="39" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: revert; padding: revert; font: 22px / 24px roboto, helvetica, sans-serif; height: 32px; -webkit-line-clamp: 1; overflow: hidden; text-overflow: ellipsis; display: -webkit-box; -webkit-box-orient: vertical; color: rgba(0, 0, 0, 0.8); letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">2. コントローラー</h2><pre data-priority="2" data-bm="40" style="background: none 0% 0% / auto repeat scroll padding-box border-box rgb(245, 245, 245); border: 1px solid rgba(0, 0, 0, 0.1); border-radius: 8px; overflow: hidden; color: rgba(0, 0, 0, 0.8); font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><div data-bm="46" style="display: flex; height: 28px; flex-direction: row; justify-content: space-between; align-items: center; gap: 8px; padding: 8px 12px; border-bottom: 1px solid rgba(0, 0, 0, 0.1); background: none 0% 0% / auto repeat scroll padding-box border-box rgb(248, 244, 241);"><h5 style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: 0px; padding: revert; font-style: normal !important; font-variant: normal !important; font-weight: 400 !important; font-stretch: 100% !important; line-height: 18px; font-family: roboto, helvetica, sans-serif !important; font-optical-sizing: auto !important; font-size-adjust: none !important; font-kerning: auto !important; font-feature-settings: normal !important; font-variation-settings: normal !important; font-language-override: normal !important; font-size: 16px; display: inline-block; color: rgb(60, 81, 180);">Csharp</h5><div style="height: 28px;"><button type="button" tabindex="" title="Copy code" style="box-sizing: border-box; margin: 0px; padding: 0px; font: 400 13px / 20px roboto, helvetica, sans-serif; background-color: rgb(217, 223, 251); border: 1px solid rgba(0, 0, 0, 0); display: grid; grid-auto-flow: column; align-items: center; cursor: pointer; color: rgb(60, 81, 180) !important; text-decoration: none !important; border-radius: 9999px; block-size: 28px; gap: 2px; padding-inline: 10px;"><div style="box-sizing: border-box; margin: 0px; padding: 0px; min-inline-size: 0px; max-inline-size: 100%; white-space: nowrap; text-overflow: ellipsis; overflow: clip; max-block-size: calc(1lh); padding-inline: 2px;">Copy code</div></button></div></div><code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255); display: block; white-space: pre-wrap; overflow-wrap: anywhere; padding: 8px 16px 16px;">using Microsoft.AspNetCore.Mvc;
using Microsoft.AspNetCore.Mvc.Rendering;
using Microsoft.EntityFrameworkCore;

public class PaymentsController : Controller
{
 private readonly AppDbContext _context;

 public PaymentsController(AppDbContext context)
 {
 _context = context;
 }

 // Create GET
 public IActionResult Create()
 {
 ViewData[&quot;PaymentTypeId&quot;] = new SelectList(_context.PaymentTypes, &quot;Id&quot;, &quot;Name&quot;);
 ViewData[&quot;PaymentMethodId&quot;] = new SelectList(Enumerable.Empty&lt;SelectListItem&gt;());
 return View();
 }

 // Create POST
 [HttpPost]
 [ValidateAntiForgeryToken]
 public async Task&lt;IActionResult&gt; Create(PaymentMethod model)
 {
 if (ModelState.IsValid)
 {
 _context.PaymentMethods.Add(model);
 await _context.SaveChangesAsync();
 return RedirectToAction(nameof(Create));
 }
 ViewData[&quot;PaymentTypeId&quot;] = new SelectList(_context.PaymentTypes, &quot;Id&quot;, &quot;Name&quot;, model.PaymentTypeId);
 ViewData[&quot;PaymentMethodId&quot;] = new SelectList(_context.PaymentMethods.Where(m =&gt; m.PaymentTypeId == model.PaymentTypeId), &quot;Id&quot;, &quot;Name&quot;, model.Id);
 return View(model);
 }

 // Ajax: 親選択時に子を取得
 [HttpGet]
 public async Task&lt;IActionResult&gt; GetMethods(int paymentTypeId)
 {
 var methods = await _context.PaymentMethods
 .Where(m =&gt; m.PaymentTypeId == paymentTypeId)
 .Select(m =&gt; new { m.Id, m.Name })
 .ToListAsync();
 return Json(methods);
 }

 // Ajax: 親の新規追加
 [HttpPost]
 public async Task&lt;IActionResult&gt; AddPaymentType(string name)
 {
 if (string.IsNullOrWhiteSpace(name))
 return BadRequest(&quot;Name is required&quot;);

 var type = new PaymentType { Name = name };
 _context.PaymentTypes.Add(type);
 await _context.SaveChangesAsync();

 return Json(new { id = type.Id, name = type.Name });
 }

 // Ajax: 子の新規追加
 [HttpPost]
 public async Task&lt;IActionResult&gt; AddPaymentMethod(int paymentTypeId, string name)
 {
 if (string.IsNullOrWhiteSpace(name))
 return BadRequest(&quot;Name is required&quot;);

 var method = new PaymentMethod { PaymentTypeId = paymentTypeId, Name = name };
 _context.PaymentMethods.Add(method);
 await _context.SaveChangesAsync();

 return Json(new { id = method.Id, name = method.Name });
 }
}
</code></pre><h2 data-bm="41" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: revert; padding: revert; font: 22px / 24px roboto, helvetica, sans-serif; height: 32px; -webkit-line-clamp: 1; overflow: hidden; text-overflow: ellipsis; display: -webkit-box; -webkit-box-orient: vertical; color: rgba(0, 0, 0, 0.8); letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">3. Create.cshtml</h2><pre data-priority="2" data-bm="42" style="background: none 0% 0% / auto repeat scroll padding-box border-box rgb(245, 245, 245); border: 1px solid rgba(0, 0, 0, 0.1); border-radius: 8px; overflow: hidden; color: rgba(0, 0, 0, 0.8); font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><div data-bm="47" style="display: flex; height: 28px; flex-direction: row; justify-content: space-between; align-items: center; gap: 8px; padding: 8px 12px; border-bottom: 1px solid rgba(0, 0, 0, 0.1); background: none 0% 0% / auto repeat scroll padding-box border-box rgb(248, 244, 241);"><h5 style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: 0px; padding: revert; font-style: normal !important; font-variant: normal !important; font-weight: 400 !important; font-stretch: 100% !important; line-height: 18px; font-family: roboto, helvetica, sans-serif !important; font-optical-sizing: auto !important; font-size-adjust: none !important; font-kerning: auto !important; font-feature-settings: normal !important; font-variation-settings: normal !important; font-language-override: normal !important; font-size: 16px; display: inline-block; color: rgb(60, 81, 180);">Razor</h5><div style="height: 28px;"><button type="button" tabindex="" title="Copy code" style="box-sizing: border-box; margin: 0px; padding: 0px; font: 400 13px / 20px roboto, helvetica, sans-serif; background-color: rgb(217, 223, 251); border: 1px solid rgba(0, 0, 0, 0); display: grid; grid-auto-flow: column; align-items: center; cursor: pointer; color: rgb(60, 81, 180) !important; text-decoration: none !important; border-radius: 9999px; block-size: 28px; gap: 2px; padding-inline: 10px;"><div style="box-sizing: border-box; margin: 0px; padding: 0px; min-inline-size: 0px; max-inline-size: 100%; white-space: nowrap; text-overflow: ellipsis; overflow: clip; max-block-size: calc(1lh); padding-inline: 2px;">Copy code</div></button></div></div><code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255); display: block; white-space: pre-wrap; overflow-wrap: anywhere; padding: 8px 16px 16px;">@model PaymentMethod
@{
 ViewData[&quot;Title&quot;] = &quot;Create Payment Method&quot;;
}

&lt;h2&gt;Create Payment Method&lt;/h2&gt;

&lt;form asp-action=&quot;Create&quot; method=&quot;post&quot;&gt;
 &lt;div class=&quot;form-group&quot;&gt;
 &lt;label asp-for=&quot;PaymentTypeId&quot;&gt;&lt;/label&gt;
 &lt;select asp-for=&quot;PaymentTypeId&quot; class=&quot;form-control&quot;
 asp-items=&quot;@(ViewData[&quot;PaymentTypeId&quot;] as SelectList)&quot; id=&quot;PaymentTypeId&quot;&gt;
 &lt;option value=&quot;&quot;&gt;-- Select --&lt;/option&gt;
 &lt;/select&gt;
 &lt;button type=&quot;button&quot; id=&quot;btnAddType&quot; class=&quot;btn btn-sm btn-primary mt-1&quot;&gt;+ 新規項目&lt;/button&gt;
 &lt;/div&gt;

 &lt;div class=&quot;form-group&quot;&gt;
 &lt;label asp-for=&quot;Name&quot;&gt;Payment Method&lt;/label&gt;
 &lt;select asp-for=&quot;Id&quot; class=&quot;form-control&quot;
 asp-items=&quot;@(ViewData[&quot;PaymentMethodId&quot;] as SelectList)&quot; id=&quot;PaymentMethodId&quot;&gt;
 &lt;option value=&quot;&quot;&gt;-- Select --&lt;/option&gt;
 &lt;/select&gt;
 &lt;button type=&quot;button&quot; id=&quot;btnAddMethod&quot; class=&quot;btn btn-sm btn-primary mt-1&quot;&gt;+ 新規項目&lt;/button&gt;
 &lt;/div&gt;

 &lt;button type=&quot;submit&quot; class=&quot;btn btn-success&quot;&gt;Save&lt;/button&gt;
&lt;/form&gt;

@section Scripts {
&lt;script src=&quot;https://code.jquery.com/jquery-3.6.0.min.js&quot;&gt;&lt;/script&gt;
&lt;script&gt;
 // 親変更時に子を取得
 $(&quot;#PaymentTypeId&quot;).change(function () {
 var typeId = $(this).val();
 $(&quot;#PaymentMethodId&quot;).empty().append(&#39;&lt;option value=&quot;&quot;&gt;-- Select --&lt;/option&gt;&#39;);
 if (typeId) {
 $.getJSON(&#39;/Payments/GetMethods&#39;, { paymentTypeId: typeId }, function (data) {
 $.each(data, function (i, item) {
 $(&quot;#PaymentMethodId&quot;).append($(&#39;&lt;option&gt;&#39;, { value: item.id, text: item.name }));
 });
 });
 }
 });

 // 親の新規追加
 $(&quot;#btnAddType&quot;).click(function () {
 var name = prompt(&quot;新しい支払いタイプ名を入力してください:&quot;);
 if (name) {
 $.post(&#39;/Payments/AddPaymentType&#39;, { name: name }, function (data) {
 $(&quot;#PaymentTypeId&quot;).append($(&#39;&lt;option&gt;&#39;, { value: data.id, text: data.name, selected: true }));
 $(&quot;#PaymentTypeId&quot;).trigger(&quot;change&quot;);
 });
 }
 });

 // 子の新規追加
 $(&quot;#btnAddMethod&quot;).click(function () {
 var typeId = $(&quot;#PaymentTypeId&quot;).val();
 if (!typeId) {
 alert(&quot;先に支払いタイプを選択してください。&quot;);
 return;
 }
 var name = prompt(&quot;新しい支払い方法名を入力してください:&quot;);
 if (name) {
 $.post(&#39;/Payments/AddPaymentMethod&#39;, { paymentTypeId: typeId, name: name }, function (data) {
 $(&quot;#PaymentMethodId&quot;).append($(&#39;&lt;option&gt;&#39;, { value: data.id, text: data.name, selected: true }));
 });
 }
 });
&lt;/script&gt;
}
</code></pre><h2 data-bm="43" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: revert; padding: revert; font: 22px / 24px roboto, helvetica, sans-serif; height: 32px; -webkit-line-clamp: 1; overflow: hidden; text-overflow: ellipsis; display: -webkit-box; -webkit-box-orient: vertical; color: rgba(0, 0, 0, 0.8); letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;">4. 実装ポイント</h2><ul data-bm="44" style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin: revert; padding: revert; color: rgba(0, 0, 0, 0.8); font-family: roboto, helvetica, sans-serif; font-size: 16px; font-style: normal; font-variant-ligatures: normal; font-variant-caps: normal; font-weight: 400; letter-spacing: normal; orphans: 2; text-align: start; text-indent: 0px; text-transform: none; widows: 2; word-spacing: 0px; -webkit-text-stroke-width: 0px; white-space: normal; background-color: rgb(255, 255, 255); text-decoration-thickness: initial; text-decoration-style: initial; text-decoration-color: initial;"><li style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin-top: revert; margin-right: revert; margin-bottom: 8px; margin-left: revert; padding: revert;">親&nbsp;<code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">&lt;select&gt;</code> に「+ 新規項目」ボタンを付け、<code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">prompt()</code> で名前を入力 &rarr; Ajax で DB 保存 &rarr;&nbsp;<code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">&lt;select&gt;</code> に即反映。</li><li style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin-top: revert; margin-right: revert; margin-bottom: 8px; margin-left: revert; padding: revert;">子&nbsp;<code style="border-radius: 8px; background: none 0% 0% / auto repeat scroll padding-box border-box rgb(255, 255, 255);">&lt;select&gt;</code> も同様に「+ 新規項目」ボタンを付け、選択中の親 ID と一緒に Ajax 送信。</li><li style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin-top: revert; margin-right: revert; margin-bottom: 8px; margin-left: revert; padding: revert;">親変更時に Ajax で子リストを再取得。</li><li style="border: 0px; border-collapse: collapse; border-spacing: 0px; list-style-position: initial; list-style-image: initial; list-style-type: revert; margin-top: revert; margin-right: revert; margin-bottom: 8px; margin-left: revert; padding: revert;">DB 保存はコントローラーの `AddPayment</li></ul>Powered by <a href="https://www.froala.com/wysiwyg-editor?pb=1" title="Froala Editor">Froala Editor</a>

添付画像

画像を変更

Back to List

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