数据操作DataBaseCtrl

public class DataBaseCtrl
{
 protected string strconn = System.Configuration.ConfigurationManager.AppSettings["database"].ToString();
    public DataBaseCtrl()
 {
  //
  // TODO: 在此处添加构造函数逻辑
  //
 }
    /// <summary>
    /// 执行命令并输出SqlDataReader
    /// </summary>
    /// <param name="para">命令参数</param>
    /// <param name="strsqlcmd">执行命令名称</param>
    /// <returns>执行后得到的SqlDataReader</returns>
    public SqlDataReader returndatader(SqlParameter[] para, string strsqlcmd)
    {
        SqlConnection conn = new SqlConnection(strconn);
        SqlCommand cmd = new SqlCommand(strsqlcmd, conn);
        cmd.CommandType = CommandType.StoredProcedure;
        for (int i = 0; i < para.Length; i++)
        {
            cmd.Parameters.Add(para[i]);
        }
        conn.Open();
        SqlDataReader dr = cmd.ExecuteReader(CommandBehavior.CloseConnection);
        return dr;
    }
    /// <summary>
    /// 执行命令并返回BOOl结果
    /// </summary>
    /// <param name="para">要执行的命令参数</param>
    /// <param name="strsqlcom">命令名称</param>
    /// <returns>执行后得到的Bool结果</returns>
    public bool exebool(SqlParameter[] para, string strsqlcom)
    {
        bool jg = false;
        using (SqlConnection conn = new SqlConnection(strconn))
        {
            SqlCommand cmd = new SqlCommand(strsqlcom, conn);
            cmd.CommandType = CommandType.StoredProcedure;
            for (int i = 0; i < para.Length; i++)
            {
                cmd.Parameters.Add(para[i]);
            }

            conn.Open();
            try
            {
                cmd.ExecuteNonQuery();
                jg = true;
            }
            catch
            {
                jg = false;
            }
            finally
            {
                conn.Close();
            }
        }
        return jg;
    }
    /// <summary>
    /// 执行命令并输出DataSet
    /// </summary>
    /// <param name="para">命令参数</param>
    /// <param name="strsqlcmd">执行的命令名称</param>
    /// <returns>执行后得到结果DataSet信息</returns>
    public DataSet returndataset(SqlParameter[] para, string strsqlcmd)
    {
        DataSet ds = new DataSet();
        using (SqlConnection conn = new SqlConnection(strconn))
        {
            SqlDataAdapter sda = new SqlDataAdapter(strsqlcmd, conn);
            sda.SelectCommand.CommandType = CommandType.StoredProcedure;
            for (int i = 0; i < para.Length; i++)
            {
                sda.SelectCommand.Parameters.Add(para[i]);
            }
            sda.Fill(ds);
        }
        return ds;
    }
    /// <summary>
    /// 执行命令并输出object
    /// </summary>
    /// <param name="para">命令参数</param>
    /// <param name="strsqlcmd">要执行命令的名称</param>
    /// <returns>执行后得到的object结果</returns>
    public object retuntobject(SqlParameter[] para, string strsqlcmd)
    {
        object jg = "";
        using (SqlConnection conn = new SqlConnection(strconn))
        {
            SqlCommand cmd = new SqlCommand(strsqlcmd, conn);
            cmd.CommandType = CommandType.StoredProcedure;
            for (int i = 0; i < para.Length; i++)
            {
                cmd.Parameters.Add(para[i]);
            }
            conn.Open();
            jg = cmd.ExecuteScalar();
            conn.Close();
        }
        return jg;
    }
}