SQL存储过程，使用事务（try catch），游标 C# 接受存储过程返回的值

CREATE proc [dbo].[Sys_Rebate_Equity]
       
AS
declare @fMemberID varchar(50)--用户ID
declare @Rebate decimal(18,2)--总股权数
   

BEGIN
    begin try
     Begin Transaction    --开始事务
        DECLARE  cursor1 CURSOR for        --定义游标cursor1
        select fMemberID,sum(fNumber) as 'fNumber' from BP_Equity where fNumber>0 group by fMemberID    --使用游标的对象
         open cursor1         --打开游标
         fetch next from cursor1 into @fMemberID,@Rebate    --将游标向下移1行，获取的数据放入之前定义的变量@fMemberID,@Rebate中
         while @@FETCH_STATUS=0    --判断是否成功获取数据
             begin
                select 1    --进行相应处理
                fetch next from cursor1 into @id    --将游标向下移1行
            end
        close cursor1    --关闭游标
        deallocate cursor1 --删除游标引用
        select 888
     Commit Transaction    --提交事务
    End Try
    Begin Catch
        if @@trancount > 0 ROLLBACK TRANSACTION --回滚事务
        Select 8888        
    End Catch
    
END

USE [SOFTINFORTMS]
GO
/****** Object:  StoredProcedure [dbo].[proc_ShouLiDan_Allocation]    Script Date: 2020/3/23 11:12:54 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Author,,Name>
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
ALTER PROCEDURE [dbo].[proc_ShouLiDan_Allocation]	
	@S_ChenYunFang nvarchar(30),
	@S_ChengYunContacter nvarchar(30),
	@result int=10 output,
	@Message varchar(1000) output
AS
BEGIN
	----事务1
        BEGIN TRY  
        BEGIN TRAN  
            --循环受理单数据
			DECLARE @r_id varchar(50)
			DECLARE @r_ShouHuoRenOrg nvarchar(100)
			DECLARE @r_Consignee varchar(50)			
			DECLARE My_Cursor CURSOR FOR SELECT S_ShouLiDanId,S_ShouHuoRenOrg,S_Consignee FROM BN_ShouLiDan WHERE S_ShouLiDanId IN(SELECT * FROM fun_Split(@S_ShouLiDanId,','))
			OPEN My_Cursor
			fetch next from My_Cursor into @r_id,@r_ShouHuoRenOrg,@r_Consignee
			while @@fetch_status<>-1
			begin			
				--新增BN_ScheduleContract数据			
				--新增BN_Schedule_ShouLiDan数据				
				--修改BN_ShouLiDan  I_ShouLiDanStateId=30				
				SET @result=1;
				SET @Message='操作成功';
			fetch next from My_Cursor into @r_id,@r_ShouHuoRenOrg,@r_Consignee
			end
			close My_Cursor
			deallocate My_Cursor			
            COMMIT TRAN;  
        END TRY  
        BEGIN CATCH  
			SET @result = 0;
			SET @Message = ERROR_MESSAGE();
            IF @@TRANCOUNT > 0
			--回滚事务
            ROLLBACK TRAN;  
			----执行失败
            ;THROW
        END CATCH 
END

C#接受result、Message

			SqlParameter[] parameters ={                
                new SqlParameter("@result",SqlDbType.Int),
                new SqlParameter("@Message",SqlDbType.VarChar,1000)
            };           
            parameters[0].Direction = ParameterDirection.Output; //result 存储过程返回
            parameters[1].Direction = ParameterDirection.Output; //Message  存储过程返回     
            //执行存储过程                     
            parameters[0].Value;//获取result的值