public void TestOrderBy() { QueryParameterSample sample = new QueryParameterSample { Order = "Name" }; _query = new Query <AggregateRootSample>(sample); Assert.Equal("Name", _query.GetOrder()); _query.OrderBy("Age", true); Assert.Equal("Name,Age desc", _query.GetOrder()); _query.OrderBy(t => t.Tel, true); Assert.Equal("Name,Age desc,Tel desc", _query.GetOrder()); }
public void TestOr_Query() { _query.OrderBy(t => t.Name); _query.Where(t => t.Name == "A"); _query.Where(t => t.EnglishName == "A"); var query2 = new Query <AggregateRootSample>(); query2.OrderBy(t => t.Age, true); query2.Where(t => t.Name == "B"); query2.Where(t => t.Age == 1); _query.Or(query2); var query3 = new Query <AggregateRootSample>(); query3.OrderBy(t => t.Tel); query3.Where(t => t.Name == "C"); query3.Where(t => t.Age > 10); _query.And(query3); Expression <Func <AggregateRootSample, bool> > expected = t => ((t.Name == "A" && t.EnglishName == "A") || (t.Name == "B" && t.Age == 1)) && (t.Name == "C" && t.Age > 10); Assert.Equal(expected.ToString(), _query.GetPredicate().ToString()); Assert.Equal("Name,Age desc,Tel", _query.GetOrder()); }
public void TestGetPager() { QueryParameterSample sample = new QueryParameterSample() { Order = "A", Page = 2, PageSize = 30, TotalCount = 40 }; _query = new Query <AggregateRootSample>(sample); _query.OrderBy("B", true); var pager = _query.GetPager(); Assert.Equal(2, pager.Page); Assert.Equal(30, pager.PageSize); Assert.Equal(40, pager.TotalCount); Assert.Equal("A,B desc", pager.Order); }