linq lambda group count 创建新实体

最新推荐文章于 2024-08-29 13:58:23 发布

hejisan

最新推荐文章于 2024-08-29 13:58:23 发布

阅读量1.1k

点赞数

分类专栏： c# linq 文章标签： linq lambda group co

本文链接：https://blog.csdn.net/hejisan/article/details/52232111

版权

c# 同时被 2 个专栏收录

16 篇文章 2 订阅

订阅专栏

linq

2 篇文章 0 订阅

订阅专栏

 public List<GameRoomStatPDK> GetGameRoomStatPDKList(int pageIndex, int pageSize, out int totalCount)
        {
            using (AWEntites db = new AWEntites())
            {
                var query = from tb in db.GameOnLineUserPDK select tb;
                var q = from p in query
                        group p by new
                        {
                            p.WID,
                            p.RoomName
                        }
                        into g
                        select new GameRoomStatPDK
                        {
                            WID=g.Key.WID??0,
                            RoomName = String.IsNullOrEmpty(g.Key.RoomName) ? "大厅" : g.Key.RoomName,
                            usersum = g.Count()
                        };
                totalCount = query.Count();
                q = q.OrderByDescending(a => a.usersum);
                return q.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
            }
        }