c# 三层 SQLDBHelper

public class SQLDBHelper
    {
        string strCon = ConfigurationManager.ConnectionStrings["Company_AdminConnectionString"].ToString();
        SqlConnection conServer = null;
        public SQLDBHelper()
        {
            conServer = new SqlConnection(strCon);
        }
        //打开数据库连接
        public SqlConnection Open()
        {
            if (conServer.State == ConnectionState.Closed)
            {
                conServer.Open();

            }
            return conServer;
        }
        //关闭数据库俩连接
        public void Close()
        {
            if (conServer.State == ConnectionState.Open)
            {
                conServer.Close();
            }
        }

      /// <summary>
      /// 页面显示
      /// </summary>
      /// <param name="cmdName">存储过程名</param>
      /// <param name="tableName">虚拟表名</param>
      /// <param name="parame">参数</param>
      /// <returns></returns>
        public DataSet ShowMessage(string cmdName , string tableName , SqlParameter[] parame )
        {
          
            SqlDataAdapter adapter = new SqlDataAdapter(cmdName,conServer);
            adapter.SelectCommand.CommandType = CommandType.StoredProcedure;

            foreach (SqlParameter p in parame)
            {
                adapter.SelectCommand.Parameters.Add(p);
            }

            DataSet set = new DataSet();
            try
            {
                adapter.Fill(set, tableName);
            }
            catch (SqlException ex)
            {
                string error = ex.ToString();
            }
            return set;
           
        }
        /// <summary>
        /// 返回受影响行数 用于增删改 返回受影响行数
        /// </summary>
        /// <param name="cmdName"></param>
        /// <param name="parame"></param>
        /// <returns></returns>
        public int SqlCmd(string cmdName , SqlParameter[] parame)
        {
            if (conServer.State == ConnectionState.Closed)
            {
                Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdName;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = conServer;

            foreach ( SqlParameter p in parame)
            {
               cmd.Parameters.Add(p);
            }
            int n = 0;
            try
            {
                n = Convert.ToInt32(cmd.ExecuteNonQuery());
            }
            catch (SqlException ex)
            {
                string error = ex.ToString();
            }
            finally
            {
                if (conServer.State == ConnectionState.Open)
                {
                    Close();
                }
            }
            return n;
        }
        /// <summary>
        /// 用于查询 返回第一行第一列
        /// </summary>
        /// <param name="cmdName"></param>
        /// <param name="parame"></param>
        /// <returns></returns>
        public int SqlCmd1(string cmdName, SqlParameter[] parame)
        {
            if (conServer.State == ConnectionState.Closed)
            {
                Open();
            }
            SqlCommand cmd = new SqlCommand();
            cmd.CommandText = cmdName;
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Connection = conServer;

            foreach (SqlParameter p in parame)
            {
                cmd.Parameters.Add(p);
            }
            int n = 0;
            try
            {
                n = Convert.ToInt32(cmd.ExecuteScalar());
            }
            catch (SqlException ex)
            {
                string error = ex.ToString();
                return 0;
            }
            finally
            {
                if (conServer.State == ConnectionState.Open)
                {
                    Close();
                }
            }
            return n;
        }
    }

适合初学者用。留到现在分享下~