using System.ComponentModel.DataAnnotations;

namespace Ninesky.Models
{
  /// <summary>
  /// 欄目模型
  /// </summary>
  public class Category
  {
    [Key]
    public int CategoryId { get; set; }
    /// <summary>
    /// 欄目名稱
    /// </summary>
    [Display(Name="欄目名稱",Description="2-20個(gè)字符")]
    [Required(ErrorMessage="×")]
    [StringLength(20,MinimumLength=2,ErrorMessage="×")]
    public string Name { get; set; }
    /// <summary>
    /// 父欄目編號(hào)
    /// </summary>
    [Display(Name="父欄目")]
    [Required(ErrorMessage="×")]
    public int ParentId { get; set; }
    /// <summary>
    /// 欄目類型【0-普通欄目；1-單頁欄目；2-外部鏈接】
    /// </summary>
    [Display(Name="欄目類型")]
    [Required(ErrorMessage = "×")]
    public int Type { get; set; }
    /// <summary>
    /// 內(nèi)容模型【僅在欄目為普通欄目時(shí)有效】
    /// </summary>
    [Display(Name="內(nèi)容模型")]
    public string Model { get; set; }
    /// <summary>
    /// 欄目視圖
    /// </summary>
    [Display(Name = "欄目視圖", Description = "欄目頁的視圖，最多255個(gè)字符。。")]
    [StringLength(255, ErrorMessage = "×")]
    public string CategoryView { get; set; }
    /// <summary>
    /// 內(nèi)容頁視圖
    /// </summary>
    [Display(Name = "內(nèi)容視圖", Description = "內(nèi)容頁視圖，最多255個(gè)字符。。")]
    [StringLength(255, ErrorMessage = "×")]
    public string ContentView { get; set; }
    /// <summary>
    /// 鏈接地址
    /// </summary>
    [Display(Name="鏈接地址",Description="點(diǎn)擊欄目時(shí)跳轉(zhuǎn)到的鏈接地址,最多255個(gè)字符。")]
    [StringLength(255,ErrorMessage = "×")]
    public string Navigation { get; set; }
    /// <summary>
    /// 欄目排序
    /// </summary>
    [Display(Name="欄目排序",Description="數(shù)字越小順序越靠前。")]
    public int Order { get; set; }
  }
}

 public enum CategoryType
  {
    一般欄目, 單頁欄目, 外部鏈接
  } 

using Ninesky.Models;
using System.Data.Entity;

namespace Ninesky.Repository
{
  public class NineskyContext:DbContext
  {
    public DbSet<User> Users { get; set; }
    public DbSet<UserGroup> UserGroups { get; set; }
    public DbSet<Category> Categorys { get; set; }
    public NineskyContext()
      : base()
    {
      Database.CreateIfNotExists();
    }
  }
}

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using Ninesky.Models;

namespace Ninesky.Repository
{
  public class CategoryRepository:RepositoryBase<Category>
  {
    /// <summary>
    /// 添加欄目
    /// </summary>
    /// <param name="category">欄目</param>
    /// <returns></returns>
    public override bool Add(Category category)
    {
      dbContext.Categorys.Add(category);
      if (dbContext.SaveChanges() > 0) return true;
      else return false;
    }
    /// <summary>
    /// 更新欄目
    /// </summary>
    /// <param name="category">欄目</param>
    /// <returns></returns>
    public override bool Update(Category category)
    {
      dbContext.Categorys.Attach(category);
      dbContext.Entry<Category>(category).State = System.Data.EntityState.Modified;
      if (dbContext.SaveChanges() > 0) return true;
      else return false;
    }

    /// <summary>
    /// 刪除欄目
    /// </summary>
    /// <param name="category">欄目</param>
    /// <returns></returns>
    public bool Delete(Category category)
    {
      dbContext.Categorys.Remove(category);
      if (dbContext.SaveChanges() > 0) return true;
      else return false;
    }
    /// <summary>
    /// 刪除欄目
    /// </summary>
    /// <param name="CategoryId">欄目Id</param>
    /// <returns></returns>
    public override bool Delete(int CategoryId)
    {
      var _category = dbContext.Categorys.SingleOrDefault(c => c.CategoryId == CategoryId);
      if (_category == null) return false;
      else return Delete(_category);
    }

    /// <summary>
    /// 查找制定欄目
    /// </summary>
    /// <param name="CategoryId">欄目id</param>
    /// <returns></returns>
    public override Category Find(int CategoryId)
    {
      return dbContext.Categorys.SingleOrDefault(c => c.CategoryId == CategoryId);
    }
    /// <summary>
    /// 獲取跟欄目
    /// </summary>
    /// <returns></returns>
    public IQueryable<Category> Root()
    {
      return Children(0);
    }
    /// <summary>
    /// 獲取子欄目
    /// </summary>
    /// <param name="CategoryId">欄目Id</param>
    /// <returns></returns>
    public IQueryable<Category> Children(int CategoryId)
    {
      return dbContext.Categorys.Where(c => c.ParentId == CategoryId).OrderBy(c => c.Order);
    }
    /// <summary>
    /// 欄目列表
    /// </summary>
    /// <param name="model">模型名稱</param>
    /// <returns></returns>
    public IQueryable<Category> List(string model)
    {
      return dbContext.Categorys.Where(c => c.Model == model).OrderBy(c => c.Order);
    }
  }
}