c#调用存储过程输出参数

来源：互联网发布：c4d r17 for mac 编辑：程序博客网时间：2024/04/29 22:27

存储过程中参数使用@BorrowSum int output

create procedure usp_BorrowSum@ReadingCard varchar(20),@BorrowSum int outputasselect @BorrowSum=sum(NonReturnCount) from BorrowDetail inner join BorrowInfo on BorrowInfo .BorrowId=BorrowDetail.BorrowIdinner join Readers on readers.ReaderId =BorrowInfo .ReaderId where NonReturnCount >0 and ReadingCard=@ReadingCardif (@BorrowSum is null)  select @BorrowSum=0 go

SQL调用方法

declare @BorrowSum intexec usp_BorrowSum '0006417240',@BorrowSum outputselect @BorrowSum

C#调用方法

public int GetReaderSum(string readingCard )        {            SqlParameter outBorrowsum = new SqlParameter("@BorrowSum", SqlDbType.Int);            outBorrowsum.Direction = ParameterDirection.Output;            SqlParameter[] param = new SqlParameter[]{                      new SqlParameter("@ReadingCard",readingCard ),                      outBorrowsum                       };              Convert.ToInt32(SQLHelper.GetSingleResultByProcedure("usp_BorrowSum", param));             return   Convert.ToInt32(outBorrowsum.Value );       }

0 0