SQLHelper 如何获取存储过程返回的值

C#代码

public int insertEntity(CreditLeafEntity entity)
        {
            int iResult=0;
            SqlParameter[] paramater = new SqlParameter[]{
                        new SqlParameter("@CreditLeaf_name" , entity.CreditLeaf_name),
                        new SqlParameter("@CreditLeaf_upId" , entity.CreditLeaf_upId),
                        new SqlParameter("@CreditLeaf_enable" , entity.CreditLeaf_enable),
                        new SqlParameter("num", "")};
            paramater[3].Direction = ParameterDirection.ReturnValue;
            try
            {
                iResult = SqlHelper.ExecuteNonQuery(SqlHelper.strDBConnString
                    , CommandType.StoredProcedure
                    , "creditLeaf_insert"
                    , paramater);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            String str = paramater[3].Value.ToString();
            return Convert.ToInt32(paramater[3].Value);
        }

存储过程：

ALTER PROCEDURE [dbo].[creditLeaf_insert]
(
 @CreditLeaf_name varchar(20),
 @CreditLeaf_upId int,
 @CreditLeaf_enable bit
)
AS
BEGIN
 insert into tb_creditLeaf values
 (
 @CreditLeaf_name,
 @CreditLeaf_upId,
 @CreditLeaf_enable
 )
 RETURN @@identity
END