public ActionResult Index(VModel.SyUserManager.Index m, int id = 1)
{
m.Type = id;
ViewBag.Type = id;
if (m.Grid == null)
{
m.Grid = new Common.Model.PList <VModel.SyUserManager.Grid>();
m.Grid.Pager = new Common.Model.Pager();
}
m.Grid = Bll.SyUserBll.GetGrid(m);
return(View(m));
}
/// <summary>
/// 获取列表
/// </summary>
/// <returns></returns>
public static Common.Model.PList <VModel.SyUserManager.Grid> GetGrid(VModel.SyUserManager.Index m)
{
Common.Model.PList <VModel.SyUserManager.Grid> pl = new Common.Model.PList <VModel.SyUserManager.Grid>();
pl.Data = new List <VModel.SyUserManager.Grid>();
using (var db = new fz_basicEntities())
{
IQueryable <sy_user> dbList = db.sy_user.Where(w => w.Type == 4 && w.Id != "92E0AF7A-4C21-456C-82E8-B27E51CC3EDB").OrderBy(o => o.Account);
switch (m.Type)
{
case 1:
dbList = dbList.Where(w => w.IsExpires == false && w.IsEnabled == true);
break;
case 2:
dbList = dbList.Where(w => w.IsExpires == true || w.IsEnabled == false);
break;
}
if (!string.IsNullOrWhiteSpace(m.Key))
{
dbList = dbList.Where(w => w.Account.Contains(m.Key) || w.Name.Contains(m.Key));
}
pl.Pager = new Common.Model.Pager(m.Grid.Pager.PageIndex, m.Grid.Pager.PageSize, dbList.Count());
pl.Data = dbList.Skip((m.Grid.Pager.PageIndex - 1) * m.Grid.Pager.PageSize).Take(m.Grid.Pager.PageSize).Select(s => new VModel.SyUserManager.Grid
{
Id = s.Id,
Account = s.Account,
Name = s.Name,
IsSystem = s.IsSystem,
ExpiresTime = s.ExpiresTime,
IsExpires = s.IsExpires,
IsEnabled = s.IsEnabled,
RoleNames = s.sy_user_and_role.Where(w1 => w1.sy_role.IsEnabled == true).Select(s1 => s1.sy_role.Name).ToList()
}).ToList();
}
return(pl);
}
