MVC4制作網(wǎng)站教程第四章 部分欄目功能實現(xiàn)代碼

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個字符")]
 [Required(ErrorMessage="×")]
 [StringLength(20,MinimumLength=2,ErrorMessage="×")]
 public string Name { get; set; }
 /// <summary>
 /// 父欄目編號
 /// </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)容模型【僅在欄目為普通欄目時有效】
 /// </summary>
 [Display(Name="內(nèi)容模型")]
 public string Model { get; set; }
 /// <summary>
 /// 欄目視圖
 /// </summary>
 [Display(Name = "欄目視圖", Description = "欄目頁的視圖，最多255個字符。")]
 [StringLength(255, ErrorMessage = "×")]
 public string CategoryView { get; set; }
 /// <summary>
 /// 內(nèi)容頁視圖
 /// </summary>
 [Display(Name = "內(nèi)容視圖", Description = "內(nèi)容頁視圖，最多255個字符。")]
 [StringLength(255, ErrorMessage = "×")]
 public string ContentView { get; set; }
 /// <summary>
 /// 鏈接地址
 /// </summary>
 [Display(Name="鏈接地址",Description="點擊欄目時跳轉到的鏈接地址,最多255個字符。")]
 [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);
 }
 }
}