using System;
using System.Collections.Generic;
using System.Text;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
namespace yjgl
{
    /// <summary>   
    /// 數(shù)據(jù)訪問(wèn)基礎(chǔ)類(SQL)   
    /// </summary>
    class BaseOperate
    {
        #region  建立數(shù)據(jù)庫(kù)連接
        /// <summary>
        /// 建立數(shù)據(jù)庫(kù)連接.
        /// </summary>
        /// <returns>返回SqlConnection對(duì)象</returns>
        public SqlConnection getcon()
        {
            string M_str_sqlcon = "Data Source=PC-200201010009 ;Database=db_yjzl;User ID=sa;PWD=123";//連接字符串
            SqlConnection mycon = new SqlConnection(M_str_sqlcon);      //創(chuàng)建連接對(duì)象
            return mycon;
        }
        #endregion
        #region  執(zhí)行SqlCommand命令
        /// <summary>
        /// 執(zhí)行SqlCommand
        /// </summary>
        /// <param name="M_str_sqlstr">SQL語(yǔ)句</param>
        public void getcom(string M_str_sqlstr)
        {
            SqlConnection sqlcon = this.getcon();   //獲取連接字符串
            sqlcon.Open();       //打開(kāi)連接
            try
            {
                SqlCommand sqlcom = new SqlCommand(M_str_sqlstr, sqlcon);  //通過(guò)SQL語(yǔ)句和連接對(duì)象創(chuàng)建命令對(duì)象
                sqlcom.ExecuteNonQuery();     //對(duì)sqlcon執(zhí)行SQL語(yǔ)句并返回受影響的行數(shù)
                sqlcom.Dispose();           //釋放sqlcom'
            }
            catch (SqlException e)
            {
                MessageBox.Show(e.ToString(), "信息提示", MessageBoxButtons.OK, MessageBoxIcon.Information);
            }
            finally
            {
                sqlcon.Close();
                sqlcon.Dispose();
            }
        }
        #endregion
        #region  創(chuàng)建DataSet對(duì)象
        /// <summary>
        /// 創(chuàng)建一個(gè)DataSet對(duì)象
        /// </summary>
        /// <param name="M_str_sqlstr">SQL語(yǔ)句</param>
        /// <param name="M_str_table">表名</param>
        /// <returns>返回DataSet對(duì)象</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  創(chuàng)建SqlDataReader對(duì)象
         /// <summary>
         /// 創(chuàng)建一個(gè)SqlDataReader對(duì)象
         /// </summary>
         /// <param name="M_str_sqlstr">SQL語(yǔ)句</param>
         /// <returns>返回SqlDataReader對(duì)象</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
    }
}