using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;

namespace CRM.BaseClass
{
    class BaseOperate
    {
        #region  建立數據庫連接
        /// <summary>
        /// 建立數據庫連接.
        /// </summary>
        /// <returns>返回SqlConnection對象</returns>
        public SqlConnection getcon()
        {
            string M_str_sqlcon = "Data Source=mrlx\\mr;Database=db_CRM;User id=sa;PWD=";
            SqlConnection myCon = new SqlConnection(M_str_sqlcon);
            return myCon;
        }
        #endregion

        #region  執行SqlCommand命令
        /// <summary>
        /// 執行SqlCommand
        /// </summary>
        /// <param name="M_str_sqlstr">SQL語句</param>
        public void getcom(string M_str_sqlstr)
        {
            SqlConnection sqlcon = this.getcon();
            sqlcon.Open();
            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
            sqlcom.ExecuteNonQuery();
            sqlcom.Dispose();
            sqlcon.Close();
            sqlcon.Dispose();
        }
        #endregion

        #region  創建DataSet對象
        /// <summary>
        /// 創建一個DataSet對象
        /// </summary>
        /// <param name="M_str_sqlstr">SQL語句</param>
        /// <param name="M_str_table">表名</param>
        /// <returns>返回DataSet對象</returns>
        public DataSet getds(string M_str_sqlstr, string M_str_table)
        {
            SqlConnection sqlcon = this.getcon();
            SqlDataAdapter sqlda = new SqlDataAdapter(M_str_sqlstr, sqlcon);
            DataSet myds = new DataSet();
            sqlda.Fill(myds, M_str_table);
            return myds;
        }
        #endregion

        #region  創建SqlDataReader對象
        /// <summary>
        /// 創建一個SqlDataReader對象
        /// </summary>
        /// <param name="M_str_sqlstr">SQL語句</param>
        /// <returns>返回SqlDataReader對象</returns>
        public SqlDataReader getread(string M_str_sqlstr)
        {
            SqlConnection sqlcon = this.getcon();
            SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);
            sqlcon.Open();
            SqlDataReader sqlread = sqlcom.ExecuteReader(CommandBehavior.CloseConnection);
            return sqlread;
        }
        #endregion
    }
}