调用有返回参数的存储过程

  public object[] store(string sqlstring, SqlParameter[] intoparameter, SqlParameter[] outputparameter, int i)
        {
            int lenght = outputparameter.Length;
            object[] o = new object[lenght];

            using (SqlConnection conn = new SqlConnection(connstring))
            {
                conn.Open();
                using (SqlCommand cmd = new SqlCommand(sqlstring, conn))
                {
                    cmd.CommandType = CommandType.StoredProcedure;
                    if (i == 0)
                    {
                        if (outputparameter != null)
                        {
                            foreach (SqlParameter parameter in outputparameter)
                            {
                                cmd.Parameters.Add(parameter).Direction = ParameterDirection.Output;

                            }
                        }

                        if (intoparameter != null)
                        {
                            foreach (SqlParameter parameter in intoparameter)
                            {
                                cmd.Parameters.Add(parameter);
                            }
                        }

                        cmd.ExecuteNonQuery();
                        for (int c = 0; c < outputparameter.Length; c++)
                        {

                            o[c] = (object)cmd.Parameters[c].Value;

                        }

                    }
                    else
                    {
                        if (outputparameter != null)
                        {
                            foreach (SqlParameter parameter in outputparameter)
                            {
                                cmd.Parameters.Add(parameter).Direction = ParameterDirection.ReturnValue;
                            }
                        }
                        if (intoparameter != null)
                        {
                            foreach (SqlParameter parameter in intoparameter)
                            {
                                cmd.Parameters.Add(parameter);
                            }
                        }

                        cmd.ExecuteNonQuery().ToString();

                        for (int c = 0; c < outputparameter.Length; c++)
                        {

                            o[c] = (object)cmd.Parameters[c].Value;

                        }

 

                    }
                    return o;
                }
            }
        }