using System;
using System.Collections.Generic;
using System.Configuration;
using System.Data;
using System.Data.SqlClient;
using System.Linq;
using System.Text;
using System.Threading.Tasks;

namespace HH.AMS.Ex.MSSQLServices
{
    public enum DataBaseType
    {
        SqlServer,
        MySql,
        Oracle,
        Aceess
    }

    public class Connections
    {
        //public  string MsSqlConnetctionString;

        //public  string MySqlConnetctionString;

        //public  string OracleSqlConnetctionString;

        private static readonly Connections instance = new Connections();

        /// <summary>
        /// 获取单实例
        /// </summary>
        public static Connections Instance
        {
            get
            {
                return instance;
            }
        }

        

        /// <summary>
        /// 连接MSSQL
        /// </summary>
        /// <returns></returns>
        public IDbConnection GetConnection(string MsSqlConnetctionString)
        {
            //获取sql数据库连接，这边你可以用MySql、SQLlite等五种数据库Connection
            SqlConnection conn = new SqlConnection(MsSqlConnetctionString);
            if (conn.State == ConnectionState.Closed)
                conn.Open();
            return conn;
        }

        /// <summary>
        /// 连接MYSQL
        /// </summary>
        /// <returns></returns>
        //public MySqlConnection GetMySQLConnection(string MySqlConnetctionString)
        //{
        //    //获取sql数据库连接，这边你可以用MySql、SQLlite等五种数据库Connection
        //    MySqlConnection conn = new MySqlConnection(MySqlConnetctionString);
        //    if (conn.State == ConnectionState.Closed)
        //        conn.Open();
        //    return conn;
        //}

        /// <summary>
        /// 连接ORACLE
        /// </summary>
        /// <returns></returns>
        //public  OracleConnection GetOracleConnection()
        //{
        //    //获取sql数据库连接，这边你可以用MySql、SQLlite等五种数据库Connection
        //    OracleConnection conn = new OracleConnection(OracleSqlConnetctionString);
        //    if (conn.State == ConnectionState.Closed)
        //        conn.Open();
        //    return conn;
        //}
    }
}