private TCollection InnerQuery(int startRowIndex, int maximumRows, string where, string orderBy, ref int totalCount) { QueryCondition qc = new QueryCondition(startRowIndex, maximumRows, "*", GetMappingInfo().TableName, orderBy, where); OnBuildQueryCondition(qc); TSqlCommonAdapter adapter = new TSqlCommonAdapter(GetConnectionName()); TCollection result = adapter.SplitPageQuery <T, TCollection>(qc, this.OnDataRowToObject, ref totalCount); ObjectContextCache.Instance[ContextCacheKey] = totalCount; return(result); }
private DataView InnerQuery(int startRowIndex, int maximumRows, string where, string orderBy, ref int totalCount) { QueryCondition qc = new QueryCondition(startRowIndex, maximumRows, "*", this._DefaultTableName, orderBy, where); OnBuildQueryCondition(qc); TSqlCommonAdapter adapter = new TSqlCommonAdapter(GetConnectionName()); DataView result = adapter.SplitPageQuery(qc, ref totalCount); ObjectContextCache.Instance[ContextCacheKey] = totalCount; return(result); }
private PagedQueryResult <T, TCollection> InnerQuery(int startRowIndex, int maximumRows, int top, string select, string from, string where, string orderBy, int totalCount) { if (select.IsNullOrEmpty()) { select = "*"; } if (from.IsNullOrEmpty()) { from = GetMappingInfo().GetQueryTableName(); } QueryCondition qc = new QueryCondition(startRowIndex, maximumRows, select, from, orderBy, where); qc.Top = top; OnBuildQueryCondition(qc); TSqlCommonAdapter adapter = new TSqlCommonAdapter(GetConnectionName()); TCollection list = adapter.SplitPageQuery <T, TCollection>(qc, this.OnDataRowToObject, ref totalCount); ObjectContextCache.Instance[ContextCacheKey] = totalCount; PagedQueryResult <T, TCollection> result = new PagedQueryResult <T, TCollection>(); if (maximumRows > 0) { result.PageIndex = (qc.RowIndex / maximumRows) + 1; } else { result.PageIndex = 1; } result.PageSize = maximumRows; result.TotalCount = totalCount; result.PagedData = list; return(result); }