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