/// <summary> /// Calculates record and page count for the specified query /// </summary> private VirtualRecordCount CalculateVirtualRecordCount() { var count = new VirtualRecordCount { RecordCount = IsQueryTotalCount ? GetQueryVirtualCount() : TotalCount, RecordsInLastPage = ItemsPerPage }; // Calculate the virtual number of records from the query // Calculate the correspondent number of pages var lastPage = count.RecordCount / ItemsPerPage; var remainder = count.RecordCount % ItemsPerPage; if (remainder > 0) { lastPage++; } count.PageCount = lastPage; // Calculate the number of items in the last page if (remainder > 0) { count.RecordsInLastPage = remainder; } return(count); }
/// <summary> /// Prepares and returns the command object for the reader-based query /// </summary> private IDbCommand PrepareCommand(VirtualRecordCount countInfo) { // Determines how many records are to be retrieved. // The last page could require less than other pages var recsToRetrieve = ItemsPerPage; if (CurrentPageIndex == countInfo.PageCount - 1) { recsToRetrieve = countInfo.RecordsInLastPage; } var cmdText = GetQueryPageCommandText(recsToRetrieve); var conn = Main.Instance.DataApi.GetConnection(Main.Instance.ConnectionString); var cmd = Main.Instance.DataApi.GetCommand(); cmd.Connection = conn; cmd.CommandText = cmdText; return(cmd); }