select 辅助参数 - SqlSelectAssist

2017-02-19 11:31:28 访问(1573) 赞(0) 踩(0)

using System;
using System.Collections.Generic;
using System.Text;
using SlowX.Core.ICoreClasses;
using System.Data;
using SlowX.Core.Classes;

namespace SlowX.Core.CoreClasses
{
    /// <summary>
    /// select 辅助参数 - SqlSelectAssist
    /// </summary>
    [Serializable]
    public class SqlSelectAssist
    {
        /// <summary>
        /// 默认的辅助参数
        /// </summary>
        public readonly static SqlSelectAssist instance 
            = 
            new SqlSelectAssist();

        /// <summary>
        /// select 辅助参数
        /// </summary>
        public SqlSelectAssist()
        {

        }


        /// <summary>
        /// select 辅助参数
        /// </summary>
        /// <param name="_selectName"></param>
        /// <param name="_isFillBaseEntityPrePostName"></param>
        public SqlSelectAssist(string _selectName, bool  _isFillBaseEntityPrePostName)
        {
            m_selectName = _selectName;

            m_isFillBaseEntityPrePostName 
                = 
                _isFillBaseEntityPrePostName;
        }

        /// <summary>
        /// select 辅助参数
        /// </summary>
        /// <param name="_selectName"></param>
        /// <param name="_isFillBaseEntityPrePostName"></param>
        /// <param name="_baseSqlFunctionValue"></param>
        public SqlSelectAssist
            (
                string _selectName, 
                bool _isFillBaseEntityPrePostName,
                BaseSqlFunction _baseSqlFunctionValue
            )
        {
            m_selectName = _selectName;

            m_isFillBaseEntityPrePostName = _isFillBaseEntityPrePostName;

            m_listBaseSqlFunction.Add(_baseSqlFunctionValue);
        }


        /// <summary>
        /// selectName 语句
        /// </summary>
        protected string m_selectName = string.Empty;


        /// <summary>
        /// selectName 语句
        /// </summary>
        public string selectName
        {
            get
            {
                return m_selectName;
            }
            set
            {
                m_selectName = value;
            }
        }

        /// <summary>
        /// 是否填充前后缀值
        /// </summary>
        protected bool m_isFillBaseEntityPrePostName = true;

        /// <summary>
        /// 是否填充前后缀值
        /// </summary>
        public bool isFillBaseEntityPrePostName
        {
            get
            {
                return m_isFillBaseEntityPrePostName;
            }
            set
            {
                m_isFillBaseEntityPrePostName = value;
            }
        }

        /// <summary>
        /// SQL方法
        /// </summary>
        protected List<BaseSqlFunction> m_listBaseSqlFunction 
            = 
            new List<BaseSqlFunction>();

        /// <summary>
        /// 获得SQL方法
        /// </summary>
        /// <returns></returns>
        public List<BaseSqlFunction> GetListBaseSqlFunction()
        {
            return m_listBaseSqlFunction;
        }


        /// <summary>
        /// SQL方法添加
        /// </summary>
        /// <param name="_BaseSqlFunctionValue"></param>
        public void AddBaseSqlFunction(BaseSqlFunction _BaseSqlFunctionValue)
        {
            m_listBaseSqlFunction.Add(_BaseSqlFunctionValue);
        }

        /// <summary>
        /// SQL方法添加
        /// </summary>
        /// <param name="idx"></param>
        /// <param name="_BaseSqlFunctionValue"></param>
        public void InsertBaseSqlFunction(int idx, BaseSqlFunction _BaseSqlFunctionValue)
        {
            if (idx <= 0)
            {
                m_listBaseSqlFunction.Insert(0, _BaseSqlFunctionValue);
            }
            else
            {
                if (idx >= m_listBaseSqlFunction.Count)
                    m_listBaseSqlFunction.Add(_BaseSqlFunctionValue);
                else
                    m_listBaseSqlFunction.Insert(idx, _BaseSqlFunctionValue);
            }
        }

       
    }
}