コード例 #1
0
        public void TestToStringNot()
        {
            EqualToString condition1 = new EqualToString()
            {
                Field = "VENDORID",
                Value = "V1234",
            };
            EqualToString condition2 = new EqualToString()
            {
                Field = "STATUS",
                Value = "T",
            };

            OrCondition or = new OrCondition()
            {
                Negate     = true,
                Conditions = new List <ICondition>
                {
                    condition1,
                    condition2
                }
            };

            Assert.Equal("NOT (VENDORID = 'V1234' OR STATUS = 'T')", or.ToString());
        }
コード例 #2
0
        public void ToStringEscapeQuotesTest()
        {
            EqualToString condition = new EqualToString()
            {
                Field = "VENDORNAME",
                Value = "Bob's Pizza, Inc.",
            };

            Assert.Equal("VENDORNAME = 'Bob\'s Pizza, Inc.'", condition.ToString());
        }
コード例 #3
0
        public void ToStringTest()
        {
            EqualToString condition = new EqualToString()
            {
                Field = "VENDORID",
                Value = "V1234",
            };

            Assert.Equal("VENDORID = 'V1234'", condition.ToString());
        }
コード例 #4
0
        public void ToStringNotTest()
        {
            EqualToString condition = new EqualToString()
            {
                Negate = true,
                Field  = "VENDORID",
                Value  = "V1234",
            };

            Assert.Equal("NOT VENDORID = 'V1234'", condition.ToString());
        }
コード例 #5
0
        public void TestNestConditionsToString()
        {
            EqualToString condition1 = new EqualToString()
            {
                Field = "VENDORTYPE",
                Value = "Software",
            };
            EqualToString condition2 = new EqualToString()
            {
                Field = "VENDORID",
                Value = "V1234",
            };
            EqualToString condition3 = new EqualToString()
            {
                Field = "VENDORID",
                Value = "V5678",
            };

            OrCondition nested = new OrCondition()
            {
                Conditions = new List <ICondition>
                {
                    condition2,
                    condition3,
                }
            };

            OrCondition or = new OrCondition()
            {
                Conditions = new List <ICondition>
                {
                    condition1,
                    nested
                }
            };

            Assert.Equal("(VENDORTYPE = 'Software' OR (VENDORID = 'V1234' OR VENDORID = 'V5678'))", or.ToString());
        }
コード例 #6
0
        public void TestToString()
        {
            EqualToString condition1 = new EqualToString()
            {
                Field = "VENDORID",
                Value = "V1234",
            };
            EqualToString condition2 = new EqualToString()
            {
                Field = "STATUS",
                Value = "T",
            };

            AndCondition and = new AndCondition()
            {
                Conditions = new List <ICondition>
                {
                    condition1,
                    condition2
                }
            };

            Assert.Equal("(VENDORID = 'V1234' AND STATUS = 'T')", and.ToString());
        }