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