1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
| using CommonUtil;
| using Operater.DbModel;
| using Operater.DTO.System;
| using SqlSugar;
| using System;
| using System.Collections.Generic;
| using System.Text;
|
| namespace Operater.DAL
| {
| public class UserInfoDAL : DbSet<UserInfo>
| {
|
| public List<RoleCountGroup> GetRoleIdCount()
| {
| var list = Db.Queryable<UserInfo>().GroupBy(t => t.RoleId).Select(i => new RoleCountGroup { Sum = SqlFunc.AggregateCount(i.Id), RoleId = i.RoleId }).ToList();
| return list;
| }
| }
| }
|
|
