public IActionResult UserIndex(SysUserSearchArg arg, int page = 1, int size = 20) { var pageList = _sysUserService.SearchUser(arg, page, size); var dataSource = pageList.ToDataSourceResult <SysUser, SysUserSearchArg>("userIndex", arg); return(View(dataSource)); }
/// <summary> /// 搜索数据 /// </summary> /// <param name="arg"></param> /// <param name="page"></param> /// <param name="size"></param> /// <returns></returns> public IPagedList <Entities.SysUser> searchUser(SysUserSearchArg arg, int page, int size) { var query = _sysUserRepository.Table.Where(o => !o.IsDeleted); if (arg != null) { if (!string.IsNullOrEmpty(arg.q)) { query = query.Where(o => o.Account.Contains(arg.q) || o.MobilePhone.Contains(arg.q) || o.Email.Contains(arg.q) || o.Name.Contains(arg.q)); } if (arg.enabled.HasValue) { query = query.Where(o => o.Enabled == arg.enabled); } if (arg.unlock.HasValue) { query = query.Where(o => o.LoginLock == arg.unlock); } if (arg.roleId.HasValue) { query = query.Where(o => o.SysUserRoles.Any(r => r.RoleId == arg.roleId)); } } query = query.OrderBy(o => o.Account).ThenBy(o => o.Name).ThenByDescending(o => o.CreationTime); return(new PagedList <Entities.SysUser>(query, page, size)); }
public IActionResult UserIndex(SysUserSearchArg arg, int page = 1, int size = 20) { var pageList = _sysUserService.searchUser(arg, page, size); ViewBag.Arg = arg;//传参数 var dataSource = pageList.toDataSourceResult <Entities.SysUser, SysUserSearchArg>("userIndex", arg); return(View(dataSource)); }
public IActionResult UserData(SysUserSearchArg arg) { var parms = Request.QueryString.ToTableParms(); var pageList = _sysUserService.AdminSearch(arg, parms); if (pageList.Any()) { foreach (var user in pageList) { user.SysRoles = _sysRoleService.GetUserRoles(user.Id); } } var data = pageList.ToAjax(); return(Json(data)); }
/// <summary> /// /// </summary> /// <param name="arg"></param> /// <returns></returns> public IPagedList <Sys_UserMapping> AdminSearch(SysUserSearchArg arg, DataTablesParameters parmas) { var query = _dbContext.Sys_User.Where(o => !o.IsDeleted); if (arg != null) { if (!String.IsNullOrEmpty(arg.q)) { arg.q = arg.q.Trim(); query = query.Where(o => o.Account.Contains(arg.q) || o.Name.Contains(arg.q) || o.MobilePhone.Contains(arg.q) || o.Email.Contains(arg.q)); } } #region 排序 if (!String.IsNullOrEmpty(parmas.OrderName)) { switch (parmas.OrderName) { case "Account": if (parmas.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.Account); } else { query = query.OrderBy(o => o.Account); } break; case "Name": if (parmas.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.Name); } else { query = query.OrderBy(o => o.Name); } break; case "CreationTime": if (parmas.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.CreationTime); } else { query = query.OrderBy(o => o.CreationTime); } break; case "LastActivityTime": if (parmas.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.LastActivityTime); } else { query = query.OrderBy(o => o.LastActivityTime); } break; case "MobilePhone": if (parmas.OrderDir.Equals("desc", StringComparison.InvariantCultureIgnoreCase)) { query = query.OrderByDescending(o => o.MobilePhone); } else { query = query.OrderBy(o => o.MobilePhone); } break; default: query = query.OrderBy(o => o.Id); break; } } else { query = query.OrderBy(o => o.Id); } #endregion return(PagedList <Sys_UserMapping> .Create <Entities.Sys_User>(query, parmas.PageIndex, parmas.Length, _mapper)); }