Tup.Cobar4Net.Parser.Ast.Stmt.Dml.DmlSelectUnionStatement.SetOrderBy C# (CSharp) Method

SetOrderBy() public method

public SetOrderBy ( OrderBy orderBy ) : DmlSelectUnionStatement
orderBy Tup.Cobar4Net.Parser.Ast.Fragment.OrderBy
return DmlSelectUnionStatement
        public virtual DmlSelectUnionStatement SetOrderBy(OrderBy orderBy)
        {
            this.orderBy = orderBy;
            return this;
        }

Usage Example

Esempio n. 1
0
        /// <returns>argument itself if there is no union</returns>
        /// <exception cref="System.SqlSyntaxErrorException" />
        protected virtual DmlQueryStatement BuildUnionSelect(DmlSelectStatement select)
        {
            if (lexer.Token() != MySqlToken.KwUnion)
            {
                return select;
            }
            var union = new DmlSelectUnionStatement(select);
            for (; lexer.Token() == MySqlToken.KwUnion;)
            {
                lexer.NextToken();
                var isAll = false;
                switch (lexer.Token())
                {
                    case MySqlToken.KwAll:
                    {
                        isAll = true;
                        goto case MySqlToken.KwDistinct;
                    }

                    case MySqlToken.KwDistinct:
                    {
                        lexer.NextToken();
                        break;
                    }
                }
                select = SelectPrimary();
                union.AddSelect(select, isAll);
            }
            union.SetOrderBy(OrderBy()).SetLimit(Limit());
            return union;
        }