#region 带output参数的存储过程

        public string   getStoredProcedure2(string storedProcedureName)
        {
            getcon();
            string strReturnRows = "";
            string sql = String.Format("EXECUTE " + storedProcedureName + " @allRows OUTPUT"); //执行的T-SQL串
            SqlCommand cmd = new SqlCommand(sql, My_con);
            cmd.Parameters.Add(new SqlParameter("@allRows", SqlDbType.Int));
            cmd.Parameters["@allRows"].Direction = ParameterDirection.Output;
            cmd.CommandTimeout = 1000;

            cmd.ExecuteNonQuery();

            //worker.ReportProgress((int) cmd.Parameters["@allRows"].Value);
            strReturnRows = cmd.Parameters["@allRows"].Value.ToString();
            con_close();
            return strReturnRows;
            
        }

        #endregion