Ejemplo n.º 1
0
        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());
        }
Ejemplo n.º 2
0
        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());
        }
Ejemplo n.º 3
0
        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);
        }