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