public virtual PageListDto <UserInfoDto> GetPageList(UserInfoPageParamDto vm)
{
PageListDto <UserInfoDto> page = null;
if (this.Client.IsLogin)
{
page = this.Client.Request <PageListDto <UserInfoDto>, UserInfoPageParamDto>(MsgCmd.GetUserPageList, vm);
}
return(page);
}
public virtual PageListDto <UserInfoDto> GetPageList(UserInfoPageParamDto vm)
{
PageListDto <UserInfoDto> result = null;
if (vm != null && vm.Index > 0 && vm.Size > 0)
{
var repository = this.GetRepository <IUserRepository>();
result = repository.GetPageList(vm);
}
return(result);
}
public ActionResult GetPageList(UserInfoPageParamDto vm)
{
if (vm != null && vm.Index > 0 && vm.Size > 0)
{
var userService = this.GetService <IUserService>();
var result = userService.GetPageList(vm);
if (result != null)
{
return(Success(result));
}
}
return(Error());
}
public virtual PageListDto <UserInfoDto> GetPageList(UserInfoPageParamDto vm)
{
PageListDto <UserInfoDto> pageList = new PageListDto <UserInfoDto>();
using (var db = this.CreateDbContext())
{
var query = from q in db.User
join a in db.Role on q.RoleId equals a.Id into b
from c in b.DefaultIfEmpty()
where q.IsDelete == false
select new UserInfoDto
{
Id = q.Id,
Name = q.Name,
Account = q.Account,
RoleId = q.RoleId,
UpdateTime = q.UpdateTime,
IsSystem = q.IsSystem,
RoleName = c.Name
};
if (!string.IsNullOrEmpty(vm.Keyword))
{
query = query.Where(q => q.Account.Contains(vm.Keyword.ToLower()) || q.Name.Contains(vm.Keyword) || q.RoleName.Contains(vm.Keyword));
}
pageList.TotalCount = query.Count();
switch (vm.Orderby)
{
case "Name":
query = vm.IsDesc ? query.OrderByDescending(q => q.Name) :
query.OrderBy(q => q.Name);
break;
case "Account":
query = vm.IsDesc ? query.OrderByDescending(q => q.Account) :
query.OrderBy(q => q.Account);
break;
case "RoleName":
query = vm.IsDesc ? query.OrderByDescending(q => q.RoleName) :
query.OrderBy(q => q.RoleName);
break;
case "UpdateTime":
query = vm.IsDesc ? query.OrderByDescending(q => q.UpdateTime) :
query.OrderBy(q => q.UpdateTime);
break;
case "Id":
default:
query = vm.IsDesc ? query.OrderByDescending(q => q.Id) :
query.OrderBy(q => q.Id);
break;
}
this.GetPage(pageList, query, vm.Index, vm.Size);
}
return(pageList);
}
