C# (CSharp) DateTimeEntityFilter.GetSqlCondition示例

示例#1

文件： DateTimeEntityFilter_.cs 项目： anupvarghese/Ilaro.Admin

        public void arguments_should_match()
        {
            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
            var args = new List <object>();

            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(2, args.Count);
            Assert.Equal("2015.07.20 00:00", args[0]);
            Assert.Equal("2015.07.20 23:59", args[1]);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
            args    = new List <object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(2, args.Count);
            Assert.Equal("2015.07.13 00:00", args[0]);
            Assert.Equal("2015.07.20 23:59", args[1]);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "-2015.07.20");
            args    = new List <object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(1, args.Count);
            Assert.Equal("2015.07.20 23:59", args[0]);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-");
            args    = new List <object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(1, args.Count);
            Assert.Equal("2015.07.13 00:00", args[0]);
        }

示例#2

文件： DateTimeEntityFilter_.cs 项目： rgonek/Ilaro.Admin

        public void sql_condition_should_match()
        {
            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
            var args = new List<object>();
            var sql = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("(t0[DateAdd] >= @0 AND t0[DateAdd] <= @1)", sql);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
            args = new List<object>();
            sql = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("(t0[DateAdd] >= @0 AND t0[DateAdd] <= @1)", sql);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "-2015.07.20");
            args = new List<object>();
            sql = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("t0[DateAdd] <= @0", sql);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-");
            args = new List<object>();
            sql = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("t0[DateAdd] >= @0", sql);
        }

示例#3

文件： DateTimeEntityFilter_.cs 项目： anupvarghese/Ilaro.Admin

        public void sql_condition_should_match()
        {
            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
            var args = new List <object>();
            var sql  = _filter.GetSqlCondition("t0", ref args);

            Assert.Equal("(t0[DateAdd] >= @0 AND t0[DateAdd] <= @1)", sql);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
            args    = new List <object>();
            sql     = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("(t0[DateAdd] >= @0 AND t0[DateAdd] <= @1)", sql);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "-2015.07.20");
            args    = new List <object>();
            sql     = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("t0[DateAdd] <= @0", sql);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-");
            args    = new List <object>();
            sql     = _filter.GetSqlCondition("t0", ref args);
            Assert.Equal("t0[DateAdd] >= @0", sql);
        }

示例#4

文件： DateTimeEntityFilter_.cs 项目： rgonek/Ilaro.Admin

        public void arguments_should_match()
        {
            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.20");
            var args = new List<object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(2, args.Count);
            Assert.Equal("2015.07.20 00:00", args[0]);
            Assert.Equal("2015.07.20 23:59", args[1]);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-2015.07.20");
            args = new List<object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(2, args.Count);
            Assert.Equal("2015.07.13 00:00", args[0]);
            Assert.Equal("2015.07.20 23:59", args[1]);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "-2015.07.20");
            args = new List<object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(1, args.Count);
            Assert.Equal("2015.07.20 23:59", args[0]);

            _filter = new DateTimeEntityFilter(_fakeClock, _property, "2015.07.13-");
            args = new List<object>();
            _filter.GetSqlCondition("t0", ref args);
            Assert.Equal(1, args.Count);
            Assert.Equal("2015.07.13 00:00", args[0]);
        }