/// <summary>
/// 获得列表
/// </summary>
/// <param name="parm">PageParm</param>
/// <returns></returns>
public async Task <ApiResult <List <T> > > GetListAsync(Expression <Func <T, bool> > where,
Expression <Func <T, object> > order, DbOrderEnum orderEnum)
{
var res = new ApiResult <List <T> >();
try
{
var query = Db.Queryable <T>()
.Where(where)
.OrderByIF((int)orderEnum == 1, order, SqlSugar.OrderByType.Asc)
.OrderByIF((int)orderEnum == 2, order, SqlSugar.OrderByType.Desc)
.ToList();
res.success = true;
res.message = "获取成功！";
res.data = query;
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
}
return(await Task.Run(() => res));
}
/// <summary>
/// 获得列表
/// </summary>
/// <param name="parm">PageParm</param>
/// <returns></returns>
public async Task <ApiResult <List <T> > > GetListAsync(Expression <Func <T, bool> > where,
Expression <Func <T, object> > order, DbOrderEnum orderEnum, bool Async = true)
{
var res = new ApiResult <List <T> >();
try
{
var query = Db.Queryable <T>()
.Where(where)
.OrderByIF((int)orderEnum == 1, order, SqlSugar.OrderByType.Asc)
.OrderByIF((int)orderEnum == 2, order, SqlSugar.OrderByType.Desc);
res.data = Async ? await query.ToListAsync() : query.ToList();
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(res);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="parm">分页参数</param>
/// <param name="where">条件</param>
/// <param name="order">排序值</param>
/// <param name="orderEnum">排序方式OrderByType</param>
/// <returns></returns>
public async Task <ApiResult <Page <T> > > GetPagesAsync(PageParm parm, Expression <Func <T, bool> > where,
Expression <Func <T, object> > order, DbOrderEnum orderEnum, bool Async = true)
{
var res = new ApiResult <Page <T> >();
try
{
var query = Db.Queryable <T>()
.Where(where)
.OrderByIF((int)orderEnum == 1, order, SqlSugar.OrderByType.Asc)
.OrderByIF((int)orderEnum == 2, order, SqlSugar.OrderByType.Desc);
res.data = Async ? await query.ToPageAsync(parm.page, parm.limit) : query.ToPage(parm.page, parm.limit);
}
catch (Exception ex)
{
res.message = ex.Message;
res.statusCode = (int)HttpStatusCode.InternalServerError;
//Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(res);
}
/// <summary>
/// 分页
/// </summary>
/// <param name="parm">分页参数</param>
/// <param name="where">条件</param>
/// <param name="order">排序值</param>
/// <param name="orderEnum">排序方式OrderByType</param>
/// <returns></returns>
public async Task <ApiResult <Page <T> > > GetPagesAsync(PageParm parm, Expression <Func <T, bool> > where,
Expression <Func <T, object> > order, DbOrderEnum orderEnum)
{
var res = new ApiResult <Page <T> >();
try
{
var query = Db.Queryable <T>()
.Where(where)
.OrderByIF((int)orderEnum == 1, order, SqlSugar.OrderByType.Asc)
.OrderByIF((int)orderEnum == 2, order, SqlSugar.OrderByType.Desc)
.ToPageAsync(parm.page, parm.limit);
res.success = true;
res.message = "获取成功！";
res.data = await query;
}
catch (Exception ex)
{
res.message = ApiEnum.Error.GetEnumText() + ex.Message;
res.statusCode = (int)ApiEnum.Error;
Logger.Default.ProcessError((int)ApiEnum.Error, ex.Message);
}
return(await Task.Run(() => res));
}
public Task <ApiResult <Page <bma_onlineusers> > > GetPagesAsync(PageParm parm, Expression <Func <bma_onlineusers, bool> > where, Expression <Func <bma_onlineusers, object> > order, DbOrderEnum orderEnum)
{
throw new NotImplementedException();
}
public Task <ApiResult <List <bma_onlineusers> > > GetListAsync(Expression <Func <bma_onlineusers, bool> > where, Expression <Func <bma_onlineusers, object> > order, DbOrderEnum orderEnum)
{
throw new NotImplementedException();
}
public Task <ApiResult <Page <SysUserInfo> > > GetPagesAsync(PageParm parm, Expression <Func <SysUserInfo, bool> > where, Expression <Func <SysUserInfo, object> > order, DbOrderEnum orderEnum)
{
throw new NotImplementedException();
}
public Task <ApiResult <List <SysUserInfo> > > GetListAsync(Expression <Func <SysUserInfo, bool> > where, Expression <Func <SysUserInfo, object> > order, DbOrderEnum orderEnum)
{
throw new NotImplementedException();
}
public async Task <ApiResult <List <sysmenu> > > GetListAsync(Expression <Func <sysmenu, bool> > where, Expression <Func <sysmenu, object> > order, DbOrderEnum orderEnum)
{
throw new NotImplementedException();
}
