MESProductionWeb/AntORM/Ant.ORM/Eunm/SqlEnum.cs

using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace Ant.ORM
{
    /// <summary>
    /// 
    /// </summary>
    public enum JoinTypes
    {
        Inner,
        Outer,
        LeftInner,
        LeftJoin,
        LeftOuter,
        RightInner,
        RightJoin,
        RightOuter,
        Cross,
        NotEqual
    }


    /// <summary>
    /// SQL Comparison Operators
    /// </summary>
    public enum Comparison
    {
        /// <summary>
        /// 等于
        /// </summary>
        Equals,
        /// <summary>
        /// 不等于
        /// </summary>
        NotEquals,
        /// <summary>
        /// 模糊查询
        /// </summary>
        Like,
        /// <summary>
        /// 不包含
        /// </summary>
        NotLike,
        /// <summary>
        /// 
        /// </summary>
        GreaterThan,
        /// <summary>
        /// 
        /// </summary>
        GreaterOrEquals,
        /// <summary>
        /// 
        /// </summary>
        LessThan,
        /// <summary>
        /// 
        /// </summary>
        LessOrEquals,
        /// <summary>
        /// 
        /// </summary>
        Blank,
        /// <summary>
        /// 
        /// </summary>
        Is,
        /// <summary>
        /// 
        /// </summary>
        IsNot,
        /// <summary>
        /// 
        /// </summary>
        In,
        /// <summary>
        /// 
        /// </summary>
        NotIn,
        /// <summary>
        /// 
        /// </summary>
        OpenParentheses,
        /// <summary>
        /// 
        /// </summary>
        CloseParentheses,
        /// <summary>
        /// 
        /// </summary>
        BetweenAnd
    }

    /// <summary>
    /// 查询操作符枚举
    /// </summary>
    public enum Operator
    {
        /// <summary>
        /// 等于
        /// </summary>
        Equal,
        /// <summary>
        /// 大于
        /// </summary>
        Larger,
        /// <summary>
        /// 小于
        /// </summary>
        Smaller,
        /// <summary>
        /// 大于等于
        /// </summary>
        EqualLarger,
        /// <summary>
        /// 小于等于
        /// </summary>
        EqualSmaller,
        /// <summary>
        /// 不等于
        /// </summary>
        NotEqual,
        /// <summary>
        /// 模糊查询
        /// </summary>
        Like,
        /// <summary>
        /// 包含查询
        /// </summary>
        In,
        /// <summary>
        /// 
        /// </summary>
        AddSql
    }

    /// <summary>
    /// Summary for the SqlFragment class
    /// </summary>
    public class SqlFragment
    {
        public const string AND = " AND ";
        public const string AS = " AS ";
        public const string ASC = " ASC";
        public const string BETWEEN = " BETWEEN ";
        public const string CROSS_JOIN = " CROSS JOIN ";
        public const string DELETE_FROM = "DELETE FROM ";
        public const string DESC = " DESC";
        public const string DISTINCT = "DISTINCT ";
        public const string EQUAL_TO = " = ";
        public const string FROM = " FROM ";
        public const string GROUP_BY = " GROUP BY ";
        public const string HAVING = " HAVING ";
        public const string IN = " IN ";
        public const string INNER_JOIN = " INNER JOIN ";
        public const string INSERT_INTO = "INSERT INTO ";
        public const string JOIN_PREFIX = "J";
        public const string LEFT_INNER_JOIN = " LEFT INNER JOIN ";
        public const string LEFT_JOIN = " LEFT JOIN ";
        public const string LEFT_OUTER_JOIN = " LEFT OUTER JOIN ";
        public const string NOT_EQUAL_TO = " <> ";
        public const string NOT_IN = " NOT IN ";
        public const string ON = " ON ";
        public const string OR = " OR ";
        public const string ORDER_BY = " ORDER BY ";
        public const string OUTER_JOIN = " OUTER JOIN ";
        public const string RIGHT_INNER_JOIN = " RIGHT INNER JOIN ";
        public const string RIGHT_JOIN = " RIGHT JOIN ";
        public const string RIGHT_OUTER_JOIN = " RIGHT OUTER JOIN ";
        public const string SELECT = "SELECT ";
        public const string SET = " SET ";
        public const string SPACE = " ";
        public const string TOP = "TOP ";
        public const string UNEQUAL_JOIN = " JOIN ";
        public const string UPDATE = "UPDATE ";
        public const string WHERE = " WHERE ";
    }
}