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