如何使用C# 操作存储过程，执行sql语句？

闲话不多说，直接上代码：

    /// <summary>
    /// Sql通用类
    /// </summary>
    public class SqlHelper
    {

       首先配置连接字符串
        public static string connStr = ConfigurationManager.ConnectionStrings["ConnString"].ConnectionString;//ConnString表示webconfig中的连接字符串

 

       执行存储过程不设置超时时间
        /// <summary>
        /// 调用存储过程
        /// </summary>
        /// <param name="connStr">连接字符串</param>
        /// <param name="storedProcedureName">存储过程名称</param>
        /// <param name="ResponseBool">存储过程执行状态</param>
        /// <param name="ResponseMsg">执行存储过程状态描述</param>
        /// <param name="paramsObject">存储过程输入参数</param>
        /// <returns></returns>
        public static DataSet Sql_GetStoredProcedureFunction(string connStr, string storedProcedureName, out bool ResponseBool, out string ResponseMsg, params ParameterKeyValuesEntity[] paramsObject)
        {
            DataSet ResponseDs = new DataSet();
            ResponseBool = true;
            ResponseMsg = "获取成功！";
            try
            {
                using (SqlConnection sqlConn = new SqlConnection(connStr))
                {
                    sqlConn.Open();
                    using (SqlCommand sqlCmd = new SqlCommand(storedProcedureName, sqlConn))
                    {
                        sqlCmd.CommandType = CommandType.StoredProcedure;
                        if (paramsObject.Count() > 0)
       &nb