Subsonic的复杂查询

最新推荐文章于 2025-05-21 00:04:32 发布

zjq2008141049

最新推荐文章于 2025-05-21 00:04:32 发布

阅读量450

点赞数

分类专栏： subsnoic 复用编码规范分页文章标签： list

本文链接：https://blog.youkuaiyun.com/zjq2008141049/article/details/7077238

版权

复用同时被 3 个专栏收录

3 篇文章

订阅专栏

编码规范

3 篇文章

订阅专栏

分页

2 篇文章

订阅专栏

此博客提供了一种方法，通过指定分类ID、每页数据条数和页码来获取文章列表，实现文章的分页展示。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

/// <summary>
        /// 取得分类中的最新数据（带分页）
        /// </summary>
        /// <param name="categoryid">分类ID</param>
        /// <param name="iPageCount">每页数据条数</param>
        /// <param name="iPage">页码（从0开始）</param>
        /// <returns>文章列表</returns>
        public static List<EArticle> GetArticleModel(int categoryid, int iPageCount, int iPage)
        {
            // 取得所有子分类
            List<int> catids = new List<int>();
            catids.Add(categoryid);
            GetAllSubCatIds(categoryid, catids);

            List<EArticle> model = new List<EArticle>();
            foreach (article item in article.Find(p => catids.ToArray().Contains(p.categoryid) && p.deleteflag == false).OrderByDescending(a => a.createdate).Skip(iPage * iPageCount).Take(iPageCount))
            {
                EArticle ea = new EArticle();
                ea.id = item.id;
                ea.categoryid = item.categoryid;
                ea.title = item.title;
                ea.author = item.author;
                ea.titlepic = item.titlepic;
                ea.createDate = item.createdate;
                ea.deleteflag = item.deleteflag;
                model.Add(ea);
            }
            return model;
        }

        //获得所有Aarticle
        public static List<EArticle> GetAllArticle(int iPageCount, int iPage)
        {
            List<EArticle> model = new List<EArticle>();
            foreach (article item in article.All().OrderByDescending(a => a.createdate  ).Skip(iPage * iPageCount).Take(iPageCount))
            {
                EArticle ea = new EArticle();
                ea.categoryid = item.categoryid;
                ea.id = item.id;
                ea.title = item.title;
                ea.author = item.author;
                ea.createDate = item.createdate;
                ea.deleteflag = item.deleteflag;
                model.Add(ea);
            }
            return model;
        }
        public static int GetPageCount(int categoryid, int iPageCount)
        {
            List<int> catids = new List<int>();
            catids.Add(categoryid);
            GetAllSubCatIds(categoryid, catids);

            List<EArticle> list = new List<EArticle>();

            foreach (article item in article.Find(p => catids.ToArray().Contains(p.categoryid) && p.deleteflag == false).OrderByDescending(a => a.createdate))
            {
                EArticle ea = new EArticle();
                ea.id = item.id;
                ea.title = item.title;
                ea.author = item.author;
                ea.deleteflag = item.deleteflag;
                list.Add(ea);
            }
            int count = list.Count();
            int PageCount = (int)Math.Ceiling(count / (double)iPageCount);
            return PageCount;
        }