c#执行sqlserver带返回参数的存储过程

一、在sqlserver中建立存储过程

CREATE PROCEDURE PROC_SELECT_REFUNDID
(
  @Refund_ID NVARCHAR(100) OUT//返回参数
)
AS
BEGIN
    DECLARE @COUNT int  
    declare @zero NVARCHAR(100)
    set @zero='0';  
    select top 1 @Refund_ID=id from [Test].[dbo].[CMB_Re_FileID] order by id desc;
    if(@Refund_ID is null)
begin
set @Refund_ID='01';
end
    else
begin
if(@Refund_ID<9)
begin  
set @COUNT=convert(int, @Refund_ID)+1;
set @Refund_ID=convert(nvarchar,@COUNT)