public async Task <UserIndexViewModel> GetUserPageAsync(UserIndexSearch search)
{
var uri = API.SysUser.GetUserPageAsync(_baseUrl, search);
var responseString = await _apiClient.GetStringAsync(uri);
return(responseString.ToObject <UserIndexViewModel>());
}
public async Task <Page <SysUser> > GetPageAsync(UserIndexSearch search)
{
Page <SysUser> page = new Page <SysUser>()
{
PageIndex = search.PageIndex,
PageSize = search.PageSize
};
string sqlWhere = " WHERE 1=1 ";
if (!search.UserName.IsNullOrEmpty())
{
sqlWhere += $@" AND username LIKE '%{search.UserName.TrimBlank()}%' ";
}
if (search.IsDel != -1)
{
sqlWhere += $@" AND IsDel = {search.IsDel} ";
}
string sql = $"SELECT * FROM sys_user {sqlWhere} LIMIT {search.OffSet()},{search.PageSize}";
page.Items = await this.QueryAsync(sql);
page.TotalItems = await this.ExecuteScalarAsync <int>($"SELECT COUNT(1) FROM sys_user {sqlWhere} ");
return(page);
}
/// <summary>
/// 获取用户列表
/// </summary>
/// <param name="search"></param>
/// <returns></returns>
public async Task <UserIndexViewModel> GetUserPageAsync(UserIndexSearch search)
{
UserIndexViewModel model = new UserIndexViewModel()
{
Users = await _databaseFixture.Db.SysUser.GetPageAsync(search),
Search = search
};
return(model);
}
public async Task <IActionResult> Index([FromQuery] UserIndexSearch search)
{
if (search.PageIndex.IsDefault())
{
search.PageIndex = 1;
}
if (search.PageSize.IsDefault())
{
search.PageSize = 10;
}
var res = await _userService.GetUserPageAsync(search);
return(View(res));
}
/// <summary>
/// 用户选择插件
/// </summary>
/// <returns></returns>
public new async Task <IActionResult> User([FromQuery] UserIndexSearch search)
{
if (search.PageIndex.IsDefault())
{
search.PageIndex = 1;
}
if (search.PageSize.IsDefault())
{
search.PageSize = 5;
}
var res = await _userService.GetUserPageAsync(search);
ViewBag.More = search.More;
return(View(res));
}
public static string GetUserPageAsync(string baseUri, UserIndexSearch search) => $"{baseUri}/User/GetUserPageAsync?{search.ToUrlParam()}";
public async Task <UserIndexViewModel> GetUserPageAsync([FromQuery] UserIndexSearch search)
{
return(await _userService.GetUserPageAsync(search));
}
