MESProductionWeb/AntORM/Ant.ORM/Services/QueryCommand.cs

using System;
using System.Collections.Generic;
using System.Text;
using Ant.Frame;
using Ant.Data;

namespace Ant.ORM
{
    /// <summary>
    /// 查询命令
    /// </summary>
    public class QueryCommand
    {
        private static volatile QueryCommand instance = null;
        private static object lockHelper = new object();
        /// <summary>
        /// 默认构造函数
        /// </summary>
        public QueryCommand()
        {
            _parameters = new QueryParameterCollection();
        }

        /// <summary>
        /// 申明对象
        /// </summary>
        public static QueryCommand Instance
        {
            get
            {
                if (instance == null)
                {
                    lock (lockHelper)
                    {
                        if (instance == null)
                        {
                            instance = new QueryCommand();
                        }
                    }
                }
                return instance;
            }
        }
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="commandText">命令文本</param>
        /// <param name="parameters">命令参数</param>
        public QueryCommand(string commandText, QueryParameterCollection parameters)
        {
            this._commandText = commandText;
            this._parameters = parameters;
        }
        /// <summary>
        /// 构造函数
        /// </summary>
        /// <param name="sqlString">SQL语句</param>
        public QueryCommand(string sqlString)
        {
            this._Key = string.Empty;
            this._moduleName = string.Empty;
            this._parameters = null;
            this._SqlType = SqlEnum.MainSql;
            this._SqlString = sqlString;
        }

        #region property
        private QueryParameterCollection _parameters;
        /// <summary>
        /// 命令参数集合
        /// </summary>
        public QueryParameterCollection Parameters
        {
            get { return _parameters; }
            set { _parameters = value; }
        }


        private List<string> _wherecolumn;
        /// <summary>
        /// 查询条件
        /// </summary>
        public List<string> WhereColumn
        {
            get { return _wherecolumn; }
            set { _wherecolumn = value; }
        }

        private string _moduleName;
        /// <summary>
        /// 模块
        /// </summary>
        public string ModuleName
        {
            get { return this._moduleName; }
            set { this._moduleName = value; }
        }

        private string _Key;
        /// <summary>
        /// 关键字
        /// </summary>
        public string Key
        {
            get { return this._Key; }
            set { this._Key = value; }
        }

        /// <summary>
        /// 参数符号
        /// </summary>
        public string DbParmChar
        { get; set; }

        private SqlEnum _SqlType;
        /// <summary>
        /// SqlStruct类型
        /// </summary>
        public SqlEnum SqlType
        {
            get { return this._SqlType; }
            set { this._SqlType = value; }
        }

        private string _commandText;
        /// <summary>
        /// 命令语句
        /// </summary>
        public string CommandText
        {
            get { return _commandText; }
            set { _commandText = value; }
        }

        private string _SqlString;
        /// <summary>
        /// 拼接Sql语句
        /// </summary>
        public string SqlString
        {
            get { return this._SqlString; }
            set { this._SqlString = value; }
        }

        private int _startRecord = 0;
        /// <summary>
        /// 开始记录数
        /// </summary>
        public int StartRecord
        {
            get { return _startRecord; }
            set { _startRecord = value; }
        }

        private int _maxRecords = 0;
        /// <summary>
        /// 最大记录类
        /// </summary>
        public int MaxRecords
        {
            get { return _maxRecords; }
            set { _maxRecords = value; }
        }

        private StringExtension.SqlComment sqlnotes;
        /// <summary>
        /// 添加SQL注释
        /// </summary>
        public StringExtension.SqlComment SqlNotes
        {
            get { return sqlnotes; }
            set { sqlnotes = value; }
        }

        #endregion
    }
}