(基类)初学者

using  System;
using  System.Collections.Generic;
using  System.Text;
// 引用
using  System.Data;
using  System.Data.SqlClient;
using  System.Configuration;

namespace  mediaDB
... {
    /**//// <summary>
    /// 基类
    /// </summary>
    public class DataBaseAccess
    ...{
        /**//// <summary>
        /// 创建数据库连接
        /// </summary>
        /// <returns></returns>
        protected string ConnectionString()
        ...{
            string strCon = ConfigurationManager.ConnectionStrings["GuankunConnectionString"].ConnectionString;
            return strCon;
        }
        /**//// <summary>
        /// 查询数据库 
        /// </summary>
        /// <param name="strSql">sql语句或存储过程名</param>
        /// <param name="procname">true为存储过程,false是SQL语句</param>
        /// <param name="tableName">表名</param>
        /// <param name="para">存储过程参数</param>
        /// <returns>返回数据集dataset</returns>
        protected DataSet GetDataAdapter(string strSql,bool procname,string tableName, params SqlParameter[] para)
        ...{
            SqlConnection conn = new SqlConnection(ConnectionString());
            SqlCommand cmd = new SqlCommand(strSql,conn);
            if (procname)
            ...{
                cmd.CommandType = CommandType.StoredProcedure;
            }
            cmd.Parameters.AddRange(para);
            SqlDataAdapter adapter = new SqlDataAdapter();
            adapter.SelectCommand = cmd;
            DataSet ds = new DataSet();
            adapter.Fill(ds, tableName);
            return ds;
        }
        /**//// <summary>
        /// 处理数据(增、删、改)
        /// </summary>
        /// <param name="strSql">SQL语句或储存过程名称</param>
        /// <param name="procname">true为存储过程,false是SQL语句</param>
        /// <param name="para">存储过程参数</param>
        /// <returns>返回值</returns>
        protected int DisposeData(string strSql, bool procname, params SqlParameter[] para)
        ...{
            SqlConnection conn = new SqlConnection(ConnectionString());         
            SqlCommand cmd = new SqlCommand(strSql, conn);
            if (procname)
            ...{
                cmd.CommandType = CommandType.StoredProcedure;
            }
            cmd.Parameters.AddRange(para);
            conn.Open();
            int resault = cmd.ExecuteNonQuery();
            conn.Close();
            return resault;          
        }
        /**//// <summary>
        /// 使用 SqlDataReader的ExecuteReader获取数据
        /// </summary>
        /// <param name="sql">sql语句或存储过程名</param>
        /// <param name="procname">true是存储过程false是sql语句</param>
        /// <param name="para">存储过程参数</param>
        /// <returns>返回值</returns>
        protected SqlDataReader ExeReader(string sql, bool procname, params SqlParameter[] para)
        ...{
            SqlConnection conn = new SqlConnection(ConnectionString());
            SqlCommand cmd = new SqlCommand(sql, conn);
            if (procname)
            ...{
                 cmd.CommandType = CommandType.StoredProcedure;
            }
            cmd.Parameters.AddRange(para);
            conn.Open();
            SqlDataReader reder = cmd.ExecuteReader(CommandBehavior.CloseConnection);
            return reder;
        }
        /**//// <summary>
        /// 使用 SqlCommand的ExecuteScalar获取一个值
        /// </summary>
        /// <param name="sql">sql 语句或存储过程名</param>
        /// <param name="procname">true是存储过程false是sql语句</param>
        /// <param name="para">存储过程参数</param>
        /// <returns>返回值</returns>
        protected string ExeScalar(string sql, bool procname, params SqlParameter[] para)
        ...{
            SqlConnection conn = new SqlConnection(ConnectionString());
            SqlCommand cmd = new SqlCommand(sql, conn);
            if (procname)
            ...{
                cmd.CommandType = CommandType.StoredProcedure;
            }
            cmd.Parameters.AddRange(para);
            conn.Open();
            string single = cmd.ExecuteScalar().ToString();
            conn.Close();
            return single;
        }
    }
}