public void ExecutePagingDataTableByQueryTest(int pageIndex, int pageSize, double discount)
{
var parameters = new[] { new AdoParameter("Discount", discount) };
using (
new OperationTimer(string.Format("ExecutePagingDataTableByQuery(pageIndex=[{0}], pageSize=[{1}])", pageIndex, pageSize))
) {
using (
var pagingTable = NorthwindAdoRepository.ExecutePagingDataTable(GetOrderDetailsSql + " WHERE Discount > @Discount",
pageIndex,
pageSize,
parameters)) {
Assert.AreEqual(pageIndex, pagingTable.PageIndex);
Assert.AreEqual(pageSize, pagingTable.PageSize);
Assert.IsTrue(pagingTable.TotalPageCount > 0);
Assert.IsTrue(pagingTable.TotalItemCount > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count > 0);
Assert.IsTrue(pagingTable.Table.Rows.Count <= pageSize);
var table = pagingTable.Table;
Assert.IsNotNull(table);
Assert.IsFalse(table.HasErrors);
Assert.IsTrue(table.Rows.Count > 0);
}
}
}
