ASP.NET MVC 5で並べ替え、検索、ページングが可能なリストを作る#2

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24

public class Article
    {
        public int Id { get; set; }

        [DisplayName("URL")]
        [DataType(DataType.Url)]
        public string Url { get; set; }

        [DisplayName("タイトル")]
        public string Title { get; set; }

        [DisplayName("概要")]
        [DataType(DataType.MultilineText)]
        public string Description { get; set; }

        [DisplayName("ビュー数")]
        public int Viewcount { get; set; }

        [DisplayName("公開日")]
        [DisplayFormat(DataFormatString = "{0:yyyy年MM月dd日}")]
        public DateTime Published { get; set; }

        [DisplayName("公開済")]
        public bool Released { get; set; }

1
2
3
4
5

// GET: Articles
        public ActionResult Index()
        {
            return View(db.Articles.ToList());
        }

1
2
3
4
5

SortFieldDefinition<Article,*****>[] sort_fields = new[] { //フィールドの型が必要
                article.DefineSort(a=>a.Url),
                article.DefineSort(a=>a.Title),
                ....
            };

1
2
3
4
5
6

[TestMethod]
        public void SortDefInterface_New_Test1() {
            Article article = null;
            ISortFieldDefinition<Article> sortdef = article.DefineSort(obj => obj.Title);  //interfaceです
            Assert.AreEqual("Title", sortdef.SortKey);
        }

1
2
3
4
5
6
7

public interface ISortFieldDefinition<TModel>
    {
        string SortKey { get; }

        IQueryable<TModel> AddOrderBy(IQueryable<TModel> aQuery, string aCurrentSortKey);
        string GetNextSortKey(string aCurrentSortKey);
    }

1
2
3
4
5
6

public static class SortFieldDefinitionExtention
    {
        public static ISortFieldDefinition<TModel> DefineSort<TModel, TKey>(this TModel aModel, Expression<Func<TModel, TKey>> aKeySelector) {
            return new SortFieldDefinition<TModel, TKey>(aKeySelector);
        }
    }

 1
 2
 3
 4
 5
 6
 7
 8
 9
10
11
12
13
14
15
16
17
18
19
20
21

// GET: Articles
        public ActionResult Index(string sort)
        {
            var query = db.Articles.AsQueryable();  //データソース

            Article article = null;
            ISortFieldDefinition<Article>[] sort_fields = new[] {   //ソートフィールド定義
                article.DefineSort(a=>a.Url),
                article.DefineSort(a=>a.Title),
                article.DefineSort(a=>a.Description),
                article.DefineSort(a=>a.Viewcount),
                article.DefineSort(a=>a.Published),
                article.DefineSort(a=>a.Released),
            };

            foreach(var field in sort_fields) { //ソート適用
                query=field.AddOrderBy(query, sort);
            }

            return View(query.ToList());    //ソート済み結果をViewに返す。
        }