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

namespace HPSocketCS.Extended
{
    /// <summary>
    /// SQL请求语句命令
    /// </summary>
    [Serializable]
    public class SerSqlCommandItme
    {
        public SerSqlCommandItme() { 
        
        }
        public SerSqlCommandItme(string sql, List<SerSqlParameter> ssParList = null)
        {
            if (ssParList != null)
            {
                this.serSqlParameterList = ssParList;
            }
            this.sqlCommandText = sql;
        }

        List<SerSqlParameter> serSqlParameterList = new List<SerSqlParameter>();

        public List<SerSqlParameter> SerSqlParameterList
        {
            get { return serSqlParameterList; }
            set { serSqlParameterList = value; }
        }

        public System.Data.SqlClient.SqlParameter[] ToSqlParameters()
        {
            List<System.Data.SqlClient.SqlParameter> parameterList = new List<System.Data.SqlClient.SqlParameter>();
            foreach (SerSqlParameter serPar in serSqlParameterList)
            {
                parameterList.Add(serPar.ToSqlParameter());
            }
           
            return parameterList.ToArray();
        }

        private string sqlCommandText = "";
        /// <summary>
        /// sql语句
        /// </summary>
        public string SqlCommandText
        {
            get { return sqlCommandText; }
            set { sqlCommandText = value; }
        }

        private string dataConnString = "";
        /// <summary>
        /// 指定的数据库连接串 可以为空 为空时连接服器端默认数据库
        /// </summary>
        public string DataConnString
        {
            get { return dataConnString; }
            set { dataConnString = value; }
        }

        int _CommandTimeout = 0;
        /// <summary>
        /// 查询超时设置
        /// </summary>
        public int CommandTimeout
        {
            get { return _CommandTimeout; }
            set { _CommandTimeout = value; }
        }

        string _AdditionalInfo = "";
        /// <summary>
        /// 附加信息
        /// </summary>
        public string AdditionalInfo
        {
            get { return _AdditionalInfo; }
            set { _AdditionalInfo = value; }
        }

        int _EffentNextType = 0;
        /// <summary>
        /// 事务回滚事务类型
        /// </summary>
        public int EffentNextType
        {
            get { return _EffentNextType; }
            set { _EffentNextType = value; }
        }


    }
}