在MVC中更新Master-Detail / Parent-Child数据

Question

拥有一个具有发票主-详细样式视图的视图。主是发票，明细是发票行。我试图在编辑帖子时保存详细数据项，但在到达控制器上的帖子edit时，细节数据会丢失。因此，主数据保存得很好，但详细信息显然没有保存。

发票类别：

public class Invoice
{
    public Invoice()
    {

    }

    [Required]
    [Key]
    public int InvoiceID { get; set; }

    [Required]
    [StringLength(30)]
    [DisplayName("Invoice Number")]
    public string InvoiceNumber { get; set; }

    [Required, DatabaseGenerated(DatabaseGeneratedOption.Computed)]
    [DataType(DataType.Date)]
    [Column(TypeName = "Date")]

    [DisplayName("Invoice Date")]
    public DateTime InvoiceDate { get; set; }

    public List<InvoiceLine> InvoiceLines { get; set; }

    [ForeignKey("Client")]
    public int OwnerClientIDFK { get; set; }

    [DisplayName("Client")]
    public Client Client { get; set; }
}

发票行分类：

public class InvoiceLine
{
    public InvoiceLine()
    {

    }

    [Key]
    [Required]
    public int InvoiceLineId { get; set; }

    [Required]
    [StringLength(255)]
    [DisplayName("Item")]
    public string ItemName { get; set; }

    [DisplayName("Description")]
    public string ItemDescription { get; set; }

    [Required]
    public int Quantity { get; set; }

    [Required]
    [DisplayFormat(DataFormatString = "{0:C}", ApplyFormatInEditMode = true)]
    public decimal Value { get; set; }

    [ForeignKey("ParentInvoice")]
    public int InvoiceID { get; set; }

    public Invoice ParentInvoice { get; set; }

} 

控制器编辑(get)：

    public ActionResult Edit(int? id)
    {
        if (id == null)
        {
            return new HttpStatusCodeResult(HttpStatusCode.BadRequest);
        }
        // Invoice invoice = db.Invoices.Find(id);
        Invoice invoice = db.Invoices.Include(i => i.InvoiceLines)
                            .Include(i => i.Client)
                            .Where(c => c.InvoiceID == id).FirstOrDefault();

        if (invoice == null)
        {
            return HttpNotFound();
        }
        ViewBag.OwnerClientIDFK = new SelectList(db.Clients, "ClientId", "CompanyName", invoice.OwnerClientIDFK);
        return View(invoice);
    } 

控制器编辑(post)：

    public ActionResult Edit([Bind(Include = "InvoiceID,InvoiceNumber,InvoiceDate,OwnerClientIDFK")] Invoice invoice)
    {
        if (ModelState.IsValid)
        {
            db.Entry(invoice).State = EntityState.Modified;

            foreach (var invLine in invoice.InvoiceLines)
            {
                db.Entry(invLine).State = EntityState.Modified;
            }

            db.SaveChanges();
            return RedirectToAction("Index");
        }
        ViewBag.OwnerClientIDFK = new SelectList(db.Clients, "ClientId", "CompanyName", invoice.OwnerClientIDFK);
        return View(invoice);
    } 

因此，在上面的代码中，当它到达foreach时，它会抛出一个异常，因为InvoiceLines为空。

查看：

@model DemoApp.Entities.Invoice

@{
    ViewBag.Title = "Edit";
}

<h2>Edit</h2>
@using (Html.BeginForm())
{
@Html.AntiForgeryToken()

<div class="form-horizontal">
    <h4>Invoice</h4>
    <hr />
    @Html.ValidationSummary(true, "", new { @class = "text-danger" })
    @Html.HiddenFor(model => model.InvoiceID)

    <div class="form-group">
        @Html.LabelFor(model => model.InvoiceNumber, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.EditorFor(model => model.InvoiceNumber, new { htmlAttributes = new { @class = "form-control" } })
            @Html.ValidationMessageFor(model => model.InvoiceNumber, "", new { @class = "text-danger" })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.InvoiceDate, htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.EditorFor(model => model.InvoiceDate, new { htmlAttributes = new { @class = "form-control" } })
            @Html.ValidationMessageFor(model => model.InvoiceDate, "", new { @class = "text-danger" })
        </div>
    </div>

    <div class="form-group">
        @Html.LabelFor(model => model.OwnerClientIDFK, "OwnerClientIDFK", htmlAttributes: new { @class = "control-label col-md-2" })
        <div class="col-md-10">
            @Html.DropDownList("OwnerClientIDFK", null, htmlAttributes: new { @class = "form-control" })
            @Html.ValidationMessageFor(model => model.OwnerClientIDFK, "", new { @class = "text-danger" })
        </div>
    </div>

    <div class="form-group">
        <h2>Invoice Lines</h2>
        <hr />
        @Html.ValidationSummary(true, "", new { @class = "text-danger" })

        <div class="row">
            <div class="col-md-8">
                <table class="table">
                    <thead>
                        <tr>
                            <th>Item</th>
                            <th>Description</th>
                            <th>Qty</th>
                            <th>Unit Value</th>
                        </tr>
                    </thead>
                    <tbody>
                        @for (int i = 0; i < Model.InvoiceLines.Count; i++)
                        {
                            <tr>
                                <td>@Html.EditorFor(x => x.InvoiceLines[i].ItemName, new { htmlAttributes = new { @class = "form-control" } })</td>
                            </tr>
                        }
                    </tbody>

                </table>
            </div>
        </div>

    </div>

    <div class="form-group">
        <div class="col-md-offset-2 col-md-10">
            <input type="submit" value="Save" class="btn btn-default" />
        </div>
    </div>

</div>
}

<div>
    @Html.ActionLink("Back to List", "Index")
</div>

@section Scripts {
    @Scripts.Render("~/bundles/jqueryval")
}

如何让它更新明细/子数据？

感谢您的帮助。提前谢谢。

Answer 1

您没有在编辑post操作方法上绑定InvoiceLines

公有发票编辑(Bind( ActionResult = "InvoiceID，InvoiceNumber，InvoiceDate，OwnerClientIDFK，InvoiceLines")发票){

Answer 2

您可能需要的是在获取父实体时加载发票行。

db.Entry(invoice).Collection(i=>i.InvoiceLines).Load()应该做到这一点。

Answer 3

首先，这是一个棘手的场景。有很多活动部件。我对此非常感兴趣，并编写了一个示例应用程序。:)

这是GitHub上的存储库的链接：https://github.com/benday/asp-mvc-invoice-sample

有几件事情正在合谋在你的代码中引起问题。

1)具有讽刺意味的是，您的Edit(发票模型)方法中的Bind[]正在阻碍您的工作。如果将其完全删除，ASP MVC将尝试绑定所有内容。现在，它只绑定您告诉它绑定的内容，因为您没有包含InvoiceLines集合，所以它将出现null。

2)如果您希望ASP MVC尝试将数据绑定到您的模型中，则需要将该数据发送回服务器。如果这些发票行不在html表单中，也没有表示为表单域，那么这些数据就会丢失。

用于绘制发票行的代码缺少填充InvoiceLine对象所需的大多数字段。

表单控件(x => x.InvoiceLinesi.ItemName，new { htmlAttributes = new {@=>=“表单控件”} })

Editor Template for the InvoiceLine class

在我的示例代码中，我为InvoiceLine类创建了一个编辑器模板。这使我可以通过调用@Html.EditorFor(model => model.Invoice.InvoiceLines) asdf轻松地为InvoiceLines创建可绑定的html

我知道这不是最简单的答案，但我希望这能帮助你克服困难。