C# 调用SQL中的存储过程中有output参数，存储过程执行过程中返回信息

CREATE PROCEDURE sp_AccountRole_Create
@CategoryID int,@Rolename nvarchar(10),@Description nvarchar(50),@RolEID int output
AS
DECLARE @Count int
-- 查找是否有相同名称的记录
SELECT @Count = Count(RolEID) FROM account_Role WHERE
Rolename = @Rolename
IF @Count = 0
INSERT INTO account_Role 
(CategoryID,Rolename,Description) valueS
(@CategoryID,@Rolename,@Description)
SET @RolEID = @@IDENTITY
RETURN 1
GO

sqlConnection DbConnection = new sqlConnection(mConnectionString);
sqlCommand command = new sqlCommand( "sp_AccountRole_Create",DbConnection );
DbConnection.open(connectString);
// 废置sqlCommand的属性为存储过程
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@CategoryID",sqlDbType.Int,4);
command.Parameters.Add("@Rolename",sqlDbType.NVarChar,10);
command.Parameters.Add("@Description",50);
command.Parameters.Add("@RolEID",4);
// 返回值
command.Parameters.Add("Returnvalue",4,// Size
ParameterDirection.Returnvalue,false,// is nullable 
0,// byte precision
0,// byte scale
String.Empty,Da@R_135_2301@wVersion.Default,null );
command.parameters["@CategoryID"].value = permission.CategoryID;
command.parameters["@Rolename"].value = permission.PermissionName;
command.parameters["@Description"].value = permission.Description;
// 可以返回新的ID值
command.parameters["@RolEID"].Direction = ParameterDirection.output;
int rowsAffected = command.ExecuteNonQuery();
int result = command.parameters["Returnvalue"].value;
int newID = command.parameters["@RolEID"].value;