public ActionResult Users(VModel.SyRole.RUser m)
{
if (m.Grid == null)
{
m.Grid = new Common.Model.PList <VModel.SyRole.UserGrid>();
m.Grid.Pager = new Common.Model.Pager();
m.Grid = Bll.SyRoleBll.GetUsers(m);
}
else
{
m.Grid = Bll.SyRoleBll.GetUsers(m);
if (Request.IsAjaxRequest())
{
return(PartialView("_UsersGrid", m));
}
}
return(View(m));
}
/// <summary>
/// 根据角色ID获取用户
/// </summary>
/// <returns></returns>
public static Common.Model.PList <VModel.SyRole.UserGrid> GetUsers(VModel.SyRole.RUser m)
{
Common.Model.PList <VModel.SyRole.UserGrid> pl = new Common.Model.PList <VModel.SyRole.UserGrid>();
pl.Data = new List <VModel.SyRole.UserGrid>();
using (var db = new fz_basicEntities())
{
var query = db.sy_user.OrderBy(o => o.Account).Where(w => w.sy_user_and_role.Where(w1 => w1.RoleId == m.id).Select(s2 => s2.UserId).Contains(w.Id) && w.IsEnabled).AsQueryable();
pl.Pager = new Common.Model.Pager(m.Grid.Pager.PageIndex, m.Grid.Pager.PageSize, query.Count());
pl.Data = query.Skip((m.Grid.Pager.PageIndex - 1) * m.Grid.Pager.PageSize).Take(m.Grid.Pager.PageSize).Select(s => new VModel.SyRole.UserGrid
{
Account = s.Account,
Name = s.Name,
RoleNames = s.sy_user_and_role.Select(s1 => s1.sy_role.Name).ToList(),
Time = s.sy_user_and_role.Select(s1 => s1.Time).FirstOrDefault()
}).ToList();
}
return(pl);
}