SQL数据库抽像工厂类，方法参数类的定义

 /// <summary>
    /// 字段模型
    /// </summary>
    public sealed class ColumnModel
    {
        public ColumnModel() { }
        public ColumnModel(string Column, object DbType)
        {
            this.ColumnName = Column;
            this.ColumnValue = 0;
            this.ColumnLen = 0;
            this.Directioin = ParameterDirection.Output;
            this.DbType = DbType;
        }
        public ColumnModel(string Column, object Value, int Len, ParameterDirection Dire, object DbType)
        {
            this.ColumnName = Column;
            this.ColumnValue = Value;
            this.ColumnLen = Value == null ? 0 : Len;
            this.Directioin = Dire;
            this.DbType = DbType;
        }
        public ColumnModel(string Column, object Value, int Len, object DbType)
        {
            this.ColumnName = Column;
            this.ColumnValue = Value;
            this.ColumnLen = this.ColumnLen = Value == null ? 0 : Len;
            this.Directioin = ParameterDirection.Input;
            this.DbType = DbType;
        }
        public ColumnModel(string Column, object Value, object DbType)
        {
            this.ColumnName = Column;
            this.ColumnValue = Value;
            this.ColumnLen = 0;
            this.Directioin = ParameterDirection.Input;
            this.DbType = DbType;
        }
        /// <summary>
        /// 列名
        /// </summary>
        public string ColumnName
        {
            get;
            set;
        }
        /// <summary>
        /// 值
        /// </summary>
        public object ColumnValue
        {
            get;
            set;
        }
        /// <summary>
        /// 长度
        /// </summary>
        public int ColumnLen
        {
            get;
            set;
        }
        public ParameterDirection Directioin
        {
            get;
            set;
        }
        /// <summary>
        /// 类型，SqlDbType or OracleType or other
        /// </summary>
        public object DbType
        {
            get;
            set;
        }
    }
    /// <summary>
    /// 表模型
    /// </summary>
    public sealed class TableModel
    {
        public TableModel()
        {
        }
        /// <summary>
        /// 适用于删除,修改,增加
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="Where"></param>
        /// <param name="CmdType"></param>
        public TableModel(string Name, WhereColModel[] Where, DataCmdType CmdType)
        {
            this.TableName = Name;
            this.Columns = null;
            this.Where = Where;
            this.CmdType = CmdType;
        }
        /// <summary>
        /// 适用删除操作
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="Where"></param>
        public TableModel(string Name, WhereColModel[] Where)
        {
            this.TableName = Name;
            this.Columns = null;
            this.Where = Where;
            this.CmdType = DataCmdType.Delete;
        }
        /// <summary>
        /// 适用增删改
        /// </summary>
        /// <param name="Name"></param>
        /// <param name="Columns"></param>
        /// <param name="Where"></param>
        /// <param name="CmdType"></param>
        public TableModel(string Name, ColumnModel[] Columns, WhereColModel[] Where, DataCmdType CmdType)
        {
            this.TableName = Name;
            this.Columns = Columns;
            this.Where = Where;
            this.CmdType = CmdType;
        }
        /// <summary>
        /// 表名
        /// </summary>
        public string TableName
        {
            get;
            set;
        }
        /// <summary>
        /// 列实体
        /// </summary>
        public ColumnModel[] Columns
        {
            get;
            set;
        }
        /// <summary>
        /// 条件
        /// </summary>
        public WhereColModel[] Where
        {
            get;
            set;
        }

        /// <summary>
        /// 操作类型
        /// </summary>
        public DataCmdType CmdType
        {
            get;
            set;
        }
        /// <summary>
        /// 排序
        /// </summary>
        public OrderByType[] OrderBy { get; set; }
    }
    public enum DataCmdType { Insert, Update, Delete };

    /// <summary>
    /// 排序模型
    /// </summary>
    public sealed class OrderByType
    {
        /// <summary>
        /// 排序列
        /// </summary>
        public string Cols
        {
            get;
            set;
        }
        public OrderBy Orderby
        {
            get;
            set;
        }
    }
    public enum OrderBy { Asc, Desc };

    /// <summary>
    /// 调用存储过程模型
    /// </summary>
    public sealed class SqlProModel
    {
        /// <summary>
        /// 存储过程名称
        /// </summary>
        public string ProName { get; set; }
        /// <summary>
        /// 存储过程参数
        /// </summary>
        public ColumnModel[] DataParamer { get; set; }
    }

    /// <summary>
    /// 查询条件模型
    /// </summary>
    public sealed class WhereColModel
    {
        /// <summary>
        /// 列名
        /// </summary>
        public string ColumnName
        {
            get;
            set;
        }
        /// <summary>
        /// 值
        /// </summary>
        public object ColumnValue
        {
            get;
            set;
        }
        /// <summary>
        /// 是否采用单引号
        /// </summary>
        public bool leftQuotes { get; set; }
        /// <summary>
        /// 是否采用单引号
        /// </summary>
        public bool Quotes { get; set; }
        /// <summary>
        /// and 或者 or
        /// </summary>
        public bool AndOr { get; set; }
        /// <summary>
        /// 比较方式
        /// </summary>
        public WhereCom Com { get; set; }
        /// <summary>
        /// 是否开始括号
        /// </summary>
        public bool BeginBrackets { get; set; }
        /// <summary>
        /// 是否结束括号
        /// </summary>
        public bool EndBrackets { get; set; }
    }
    public enum WhereCom
    {
        /// <summary>
        /// =
        /// </summary>
        [Description("=")]
        Equal,
        /// <summary>
        /// !=
        /// </summary>
        [Description("!=")]
        NotEqual,
        /// <summary>
        /// <
        /// </summary>
        [Description("<")]
        Less,
        /// <summary>
        /// >
        /// </summary>
        [Description(">")]
        Greater,
        /// <summary>
        /// >=
        /// </summary>
        [Description(">=")]
        GreaterEqual,
        /// <summary>
        /// <=
        /// </summary>
        [Description("<=")]
        LessEqual,
        /// <summary>
        /// like %str%
        /// </summary>
        [Description("like %str%")]
        Like,
        /// <summary>
        /// like %str
        /// </summary>
        [Description("like %str")]
        LeftLike,
        /// <summary>
        /// like str%
        /// </summary>
        [Description("like str%")]
        RightLike,
         /// <summary>
        /// in
        /// </summary>
        [Description("in(str)")]
        IN,
        /// <summary>
        /// in
        /// </summary>
        [Description("not in(str)")]
        NOTIN
    };
    /// <summary>
    /// 条件符号
    /// </summary>
    public struct ComSymbol
    {
        public Hashtable Symbol()
        {
            Hashtable Tb = new Hashtable();
            Tb.Add("Equal", "{0}{1}{2}={3}{4}{5}");
            Tb.Add("NotEqual", "{0}{1}{2}!={3}{4}{5}");
            Tb.Add("Less", "{0}{1}{2}<{3}{4}{5}");
            Tb.Add("Greater", "{0}{1}{2}>{3}{4}{5}");
            Tb.Add("GreaterEqual", "{0}{1}{2}>={3}{4}{5}");
            Tb.Add("LessEqual", "{0}{1}{2}<={3}{4}{5}");
            Tb.Add("Like", "{0}{1}{2} like %{3}{4}{5}%");
            Tb.Add("LeftLike", "{0}{1}{2} like %{3}{4}{5}");
            Tb.Add("RightLike", "{0}{1}{2} like {3}{4}{5}%");
            Tb.Add("IN", "{0}{1}{2} in({3}{4}{5})");
            Tb.Add("NOTIN", "{0}{1}{2} not in({3}{4}{5})");
            return Tb;
        }
    }
    /// <summary>
    /// 数据查询模型
    /// </summary>
    public sealed class SelectModel
    {
        /// <summary>
        /// 表名
        /// </summary>
        public string TableName
        {
            get;
            set;
        }
        /// <summary>
        /// 要返回的列
        /// </summary>
        public string Cols
        {
            get;
            set;
        }
        /// <summary>
        /// 条件
        /// </summary>
        public WhereColModel[] Where
        {
            get;
            set;
        }
        public OrderByType[] OrderBy { get; set; }
    }

    public sealed class UrlCommand
    {
        public string CmdDist
        {
            get;
            set;
        }
        public string CmdStr
        {
            get;
            set;
        }
    }