Queryable_SortAndPage_Test.cs 1.9 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566
  1. using Vit.Extensions;
  2. using System.Linq;
  3. using Microsoft.VisualStudio.TestTools.UnitTesting;
  4. using Vit.Core.Util.ComponentModel.Data;
  5. using Vit.Core.Util.ComponentModel.Query;
  6. namespace Vit.Linq.MsTest
  7. {
  8. [TestClass]
  9. public class Queryable_SortAndPage_Test
  10. {
  11. #region (x.3)TestSortAndPage
  12. [TestMethod]
  13. public void TestSortAndPage()
  14. {
  15. var query = DataSource.GetQueryable();
  16. #region (x.1)
  17. {
  18. var result = query
  19. .Sort(new[] {
  20. new SortItem { field = "b1.pid", asc = false },
  21. new SortItem { field = "id", asc = true }
  22. })
  23. .Page(new PageInfo { pageIndex = 1, pageSize = 10 })
  24. .ToList();
  25. Assert.AreEqual(result.Count, 10);
  26. Assert.AreEqual(result[0].id, 990);
  27. }
  28. #endregion
  29. #region (x.2)
  30. {
  31. var result = query
  32. .Sort("id",false)
  33. .Page(2,10)
  34. .ToList();
  35. Assert.AreEqual(result.Count, 10);
  36. Assert.AreEqual(result[0].id, 989);
  37. }
  38. #endregion
  39. #region (x.3)
  40. {
  41. var result = query
  42. .Sort(new[] {
  43. new SortItem { field = "b1.pid", asc = false },
  44. new SortItem { field = "id", asc = true }
  45. })
  46. .ToPageData(new PageInfo { pageIndex = 1, pageSize = 10 });
  47. Assert.AreEqual(result.totalCount, 1000);
  48. Assert.AreEqual(result.rows.Count, 10);
  49. Assert.AreEqual(result.rows[0].id, 990);
  50. }
  51. #endregion
  52. }
  53. #endregion
  54. }
  55. }