C# 怎么调用存储过程 经典写法

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using ty.BLL;
using ty.Model;
using System.Data;
using System.Data.OracleClient;

namespace TransmissionLine
{
    public partial class SMidHistoryDel : Form
    {
        private OracleConnection conn = null;
        private OracleCommand cmd = null;

        public SMidHistoryDel()
        {
            InitializeComponent();
        }

        private void button2_Click(object sender, EventArgs e)
        {//关闭窗体
            this.Close();
        }

        private void button1_Click(object sender, EventArgs e)
        {//删除
            string mConn = "Data Source=zxjc;User ID=tsmdlr;Password=tsmdlr;Unicode=True";  //连接数据库
            conn = new OracleConnection(mConn);
            try
            {
                conn.Open();
                cmd = new OracleCommand();
                cmd.Connection = conn;
            }
            catch
            {
                MessageBox.Show("连接失败!");
            }

            //存储过程的参数声明
            OracleParameter[] parameters ={
                                 new OracleParameter("startTime",OracleType.VarChar,50),
                                new OracleParameter("endTime",OracleType.VarChar,50),
                            
                                                };
            parameters[0].Value = dtpStartTime.Value.ToString();
            parameters[1].Value = dtpEndTime.Value.ToString();

            try
            {
                int message = RunProcedure("prohistoryData", parameters);
                if (message == 0)
                    MessageBox.Show("删除失败!");
                else
                {
                    MessageBox.Show("删除成功!");
                    this.Close();
                }

            }
            catch
            {
                MessageBox.Show("操作失败!");
            }

        }

        private int RunProcedure(string storedProcName, OracleParameter[] parameters)
        {
            cmd.CommandText = storedProcName;//声明存储过程名
            cmd.CommandType = CommandType.StoredProcedure;
            foreach (OracleParameter parameter in parameters)
            {
                cmd.Parameters.Add(parameter);
            }
            int var = cmd.ExecuteNonQuery();//执行存储过程
            return var;
        }

    }
}