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;
        }
    }
}