public decimal CreateOrder(string orderId, int userId, string address)

        {

            SqlParameter[] parameters = new SqlParameter[] {

                 new SqlParameter("@orderId",SqlDbType.NVarChar,),

                 new SqlParameter("@userId",SqlDbType.Int,),

                new SqlParameter("@address",SqlDbType.NVarChar,),

                 new SqlParameter("@totalPrice",SqlDbType.Money)

            };

            parameters[].Value = orderId;

            parameters[].Value = userId;

            parameters[].Value = address;

            //设置参数为输出参数，默认是InPut(输入参数)

            parameters[].Direction = ParameterDirection.Output;

            //调用执行存储过程的方法                     DBUtility.DBHelperSQL.ExecuteNonQueryProc("usp_CreateOrder", parameters);

            return Convert.ToDecimal(parameters[].Value);

        }

public static decimal ExecuteNonQueryProc(string cmdtext, params SqlParameter[] parameters)

        {

            using (SqlConnection conn = new SqlConnection(connstr))

            {

                conn.Open();

                using (SqlCommand cmd = conn.CreateCommand())

                {

                    //设置SqlCommand的类型为存储过程--StoredProcedure

                    cmd.CommandType = CommandType.StoredProcedure;

                    //这个的cmdText是存储过程名

                    cmd.CommandText = cmdtext;

                    //给这个存储过程传变量

                    cmd.Parameters.AddRange(parameters);

                    return cmd.ExecuteNonQuery();

                }

            }

        }