/// <summary> /// 流程业务记录分页方法 /// </summary> /// <param name="query"></param> /// <param name="count"></param> /// <returns></returns> public List<AppFlowEntity> GetPaged(AppFlowQuery query, out int count) { List<AppFlowEntity> list = null; var conn = SessionFactory.CreateConnection(); try { var sortList = new List<DapperExtensions.ISort>(); sortList.Add(new DapperExtensions.Sort { PropertyName = "ID", Ascending = false }); IFieldPredicate predicate = null; if (!string.IsNullOrEmpty(query.AppInstanceID)) predicate = Predicates.Field<AppFlowEntity>(f => f.AppInstanceID, Operator.Eq, query.AppInstanceID); count = DBHelper.Count<AppFlowEntity>(conn, predicate); list = DBHelper.GetPaged<AppFlowEntity>(conn, query.PageIndex, query.PageSize, predicate, sortList, false).ToList(); return list; } catch (System.Exception) { throw; } finally { conn.Close(); } }
public ResponseResult<List<AppFlowEntity>> QueryPaged(AppFlowQuery query) { var result = ResponseResult<List<AppFlowEntity>>.Default(); var conn = SessionFactory.CreateConnection(); try { var count = 0; var list = AppFlowService.GetPaged(query, out count); result = ResponseResult<List<AppFlowEntity>>.Success(list); result.TotalRowsCount = count; result.TotalPages = (count + query.PageSize - 1) / query.PageSize; } catch (System.Exception ex) { result = ResponseResult<List<AppFlowEntity>>.Error( string.Format("获取{0}分页数据失败,错误{1}", "AppFlow", ex.Message) ); } return result; }