如何使用ASP.NET MVC将列表表视图链接到另一个表视图以获取详细信息

我正在第一页上查看一个列表,在第二页上,它应该使用与第一页数据库相同的ID进行链接,但在第二页上是其详细信息页面。

第一页-列表视图

第二页-详细信息

这是我已经尝试过的

示例:http://abctutorial.com/Post/53/mvc5-master-detail-edit-using-aspnet--jquery--razor

名为“ Ordering”的模型及其在ListView上的显示

        public Ordering()
        {
            this.Invoice_Line_Item = new HashSet<Invoice_Line_Items>();
        }
        [Key]
        public int order_id { get; set; }
        public Guid? CustomerId { get; set; }
        public int? CustId { get; set; }
        [DatabaseGenerated(DatabaseGeneratedOption.Computed)]
        [StringLength(34)]
        public string invoice_number { get; set; }
        [StringLength(200)]
        public string EmailId { get; set; }
        [StringLength(50)]
        public string ClientFirstname { get; set; }
        [StringLength(50)]
        public string ClientLastname { get; set; }
        [StringLength(50)]
        public string MobileNumber { get; set; }
        [StringLength(50)]
        public string PaymentStatus { get; set; }
        [StringLength(50)]
        public string trackingorderno { get; set; }
        [StringLength(50)]
        public string Status { get; set; }
        [StringLength(200)]
        public string DeliveryNote { get; set; }
        [StringLength(250)]
        public string Agent { get; set; }
        public DateTime? date_order_placed { get; set; }
        public virtual ICollection<Invoice_Line_Items> Invoice_Line_Item { 
        get; set; }

“订购”的ListView页面

@model IEnumerable<LifestyleAdminOriginal.Models.Ordering>

          @foreach (var item in Model)
            {
             <tr>
              <td>
               @Html.DisplayFor(modelItem => item.invoice_number)
              </td>
               <td>
               @Html.DisplayFor(modelItem => item.ClientFirstname) @Html.DisplayFor(modelItem => item.ClientLastname)
               </td>
               <td>
               @Html.DisplayFor(modelItem => item.EmailId)
               </td>
               <td>
                @Html.DisplayFor(modelItem => item.MobileNumber)
                </td>
                <td>
                <span class="label label-danger">@Html.DisplayFor(modelItem => item.Status)</span>
                </td>
                <td>
               @Html.actionLink("View","NewOrdersDetails",new { id = item.CustId })
                 </td>
                 </tr>
                }

“发票行项目”的详细信息页面

<div class="row">
                                    @if (Model.Count() != 0)
                                    {
                                        foreach (var item in Model)
                                        {
                                            <div class="col-lg-12 col-md-12 col-sm-12 col-xs-12">
                                                <div class="invoice-sp">
                                                    <table class="table table-hover">
                                                        <thead>
                                                            <tr>

                                                                <th>Service</th>
                                                                <th>Item</th>
                                                                <th>Gender</th>
                                                                <th>Unit Price</th>
                                                                <th>Quantity</th>
                                                                <th>Total</th>
                                                            </tr>
                                                        </thead>
                                                        <tbody>
                                                            <tr>
                                                                @foreach (var inv in item.Invoice_Line_Item)
                                                            {
                                                                        <th>@inv.service</th>
                                                                        <td>@inv.item</td>
                                                                    <td>@inv.gender</td>
                                                                    <td>@inv.price</td>
                                                                    <td>@inv.quantity</td>
                                                                    <td>@inv.price</td>
                                                            }
                                                            </tr>

                                                        </tbody>
                                                    </table>
                                                </div>
                                            </div>
                                             }
                                        }
                                        </div>

用于“订购”的Listview控制器

public actionResult NewOrders()
        {
            var count = db.Orderings.Where(s => s.trackingorderno == "New Order").Count();
            ViewBag.totalall = count;

            return View(db.Orderings.ToList().Where(x => x.trackingorderno == "New Order").Select(x => x));
        }

“发票行项目”和“订购”的Detailsview控制器

public actionResult NewOrdersDetails(int? CustId)
        {
            if (CustId == null)
            {
                return new system.web.Mvc.HttpStatusCodeResult(HttpStatusCode.BadRequest);
            }
            List<Ordering> OrderAndCustomerList = db.Orderings.ToList();

            if (OrderAndCustomerList == null)
            {
                return HttpNotFound();
            }
            return View(OrderAndCustomerList);
        }

基本上,每当用户在列表视图页面上单击“查看”时,都应将其带到详细信息页面,在该页面上显示发票行项目并在“ DetailsView”页面上显示客户详细信息

liltlz 回答:如何使用ASP.NET MVC将列表表视图链接到另一个表视图以获取详细信息

在显示主数据的第一个表中,第一个表数据的第二个表详细信息 因此您必须在主表内容中获取明细表内容ID,然后将其与主表中的明细ID一起发送到第二页。

,

我设法从下面链接的以下示例中得到了答案。我在模型订购

上使用了 ICollection

https://docs.microsoft.com/en-us/aspnet/mvc/overview/getting-started/getting-started-with-ef-using-mvc/implementing-basic-crud-functionality-with-the-entity-framework-in-asp-net-mvc-application

    **Ordering Model**
    [ForeignKey("order_id")]
    public virtual ICollection<Invoice_Line_Items> Invoice_Line_Item { get; set; }

    **Invoice_Line_Items Model**
    public virtual Ordering Ordering { get; set; }



         **Details Page**
         <table class="table">
            <tr>
                <th>Service</th>
                <th>Department</th>
            </tr>
            @foreach (var item in Model.Invoice_Line_Item)
            {
        <tr>
            <td>
                @Html.DisplayFor(modelItem => item.invoice_number)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.service)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.department)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.item)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.quantity)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.price)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.vat)
            </td>
            <td>
                @Html.DisplayFor(modelItem => item.grandtotal)
            </td>
        </tr>
            }
        </table>
本文链接:https://www.f2er.com/3138215.html

大家都在问