显示 3 个表数据值

本文关键字：数据 显示 | 更新日期: 2023-09-27 17:56:50

我的MSSQL数据库中有三个表。我已经创建了三个类文件。我需要做什么MVC C#索引.chtml文件显示所有数据结果报告。在我的这 3 个表下面，类只显示区域名称，但不显示交货日。它应该在周一、周五的任何一天显示。谁能告诉我如何显示一天？

public class DeliveryTime
{
    [Key]
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    public int DeliveryAuto { get; set; }
    [Required]
    public int DeliveryTimeId { get; set; }
    [Required]
    public int DeliveryPeriodID { get; set; }
    [Required]
    [Display(Name = "Delivery Day:")]
    public string DeliveryDay { get; set; }
}
public class SubRegion
{   
    [DatabaseGeneratedAttribute(DatabaseGeneratedOption.Identity)]
    [Key]
    public int SubregionID { get; set; }
    [Required]
    [Display(Name = "Sub Region Name:")]
    public string SubregionName { get; set; }
    // [Display(Name = "Region Name:")]
    public int RegionID { get; set; }
    [Display(Name = "Region Name:")]
    public virtual Region ReName { get; set; }
    [Required]
    public int DeliveryTimeId { get; set; }
    [Display(Name = "Delivery Day(s):")]
    public virtual DeliveryTime deliveryDay { get; set; } 
    public virtual IEnumerable<DeliveryTime> deliveryTime { get; set; }
    public virtual IEnumerable<Region> region { get; set; }
}
public class Region
{
    [Key]
    [DatabaseGenerated(DatabaseGeneratedOption.Identity)]
    public int RegionID { get; set; }
    [Required]
    [Display(Name = "Region Name:")]
    public string ReName { get; set; }
    public virtual IEnumerable<SubRegion> subRegion { get; set; }
  }

这是我的控制器

public ActionResult Index(int? page) 
{       
    var tLCSubRegion = db.TLCSubRegion.Include(s => s.ReName).ToList();
    if (Request.HttpMethod != "GET")
    {
        page = 1;
    }
    int pageSize = 20;
    int pageNumber = (page ?? 1);
    return View(tLCSubRegion.ToPagedList(pageNumber, pageSize));  
}

这是我的索引.chtml页面

@model PagedList.IPagedList<WebVer5.Models.SubRegion>
@foreach (var item in Model)
{
    @Html.DisplayFor(modelItem => item.ReName.ReName)
    @Html.DisplayFor(modelItem => item.deliveryDay.DeliveryDay) 
}

显示 3 个表数据值

目前您只加载区域。将控制器操作中的线路更改为 

var tLCSubRegion = db.TLCSubRegion.Include(s => s.ReName).Include(x => x.deliveryDay).ToList();

从 

var tLCSubRegion = db.TLCSubRegion.Include(s => s.ReName).ToList();
相关文章：