/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static List <VModel.SyRole.Grid> GetGrid(VModel.SyRole.Index m)
{
using (var db = new fz_basicEntities())
{
IQueryable <sy_role> query = db.sy_role.Where(w => w.Id != 1);
if (m.Type != null)
{
query = query.Where(w => w.Type == m.Type);
}
if (!string.IsNullOrWhiteSpace(m.Name))
{
query = query.Where(w => w.Name.Contains(m.Name));
}
return(query.Select(s => new VModel.SyRole.Grid
{
Id = s.Id,
Name = s.Name,
Type = s.Type,
UserNumber = db.sy_user_and_role.Where(w => w.sy_user.Id == w.UserId && w.sy_role.Id == s.Id && w.sy_user.IsEnabled).Count(),
APNumber = s.sy_nav.Count,
IsSystem = s.IsSystem,
IsEnabled = s.IsEnabled,
Remark = s.Remark
}).ToList());
}
}
public ActionResult Index(VModel.SyRole.Index m)
{
m.Grid = Bll.SyRoleBll.GetGrid(m);
return(View(m));
}
