62,046
社区成员
发帖
与我相关
我的任务
分享
public class ItemInfo
{
public ItemInfo()
{
this.ItemTimes = new HashSet<ItemTime>();
this.Comments = new HashSet<Comment>();
}
[Key]
[HiddenInput(DisplayValue = false)]
public int ItemId { get; set; }
public string ItemCnName { get; set; }
public string ItemEnName { get; set; }
public string ItemDescription { get; set; }
public virtual ICollection<ItemTime> ItemTimes { get; set; }
public virtual ICollection<Comment> Comments { get; set; }
}
public class ItemTime
{
public ItemTime()
{
UserItemTimes = new HashSet<UserItemTime>();
}
[Key]
public int ItemTimeId { get; set; }
public DateTime Time { get; set; }
public int ItemId { get; set; }
public virtual ItemInfo ItemInfo { get; set; }
public virtual ICollection<UserItemTime> UserItemTimes { get; set; }
}
public class EFDbContext : DbContext
{
public EFDbContext() : base("EFDbContext")
{
Database.SetInitializer<EFDbContext>(null);
}
public DbSet<ItemInfo> ItemInfoes { get; set; }
public DbSet<ItemTime> ItemTimes { get; set; }
}
public class ItemUserViewModel
{
public ItemInfo ItemInfo { get; set; }
public IQueryable<ItemTime> ItemTime { get; set; }
}
public ActionResult Test()
{
using (var context = new EFDbContext())
{
var itemuser = new ItemUserViewModel
{
ItemInfo = context.ItemInfoes.FirstOrDefault(a => a.ItemId == 1),
ItemTime = context.ItemTimes
.Where(a => a.ItemInfo.ItemId == 1)
.TakeWhile(a => a.Time > System.DateTime.Now)
};
return View(itemuser);
}
}
@model WebConan.Models.ItemUserViewModel
<p>@Model.ItemInfo.ItemCnName</p>
@foreach (var p in Model.ItemTime)
{
<p>@p.Time</p>
}