执行存储过程时,返回参数示例代码

//参数
SqlParameter[] fparams = new SqlParameter[7];
fparams[0] = new SqlParameter("@ID", ID);
fparams[1] = new SqlParameter("@VoucherAmt", VoucherAmt);
fparams[2] = new SqlParameter("@ItemId", ItemId);
fparams[3] = new SqlParameter("@AmortizeType", AmortizeType);
fparams[4] = new SqlParameter("@AmortizeDate", AmortizeDate);
fparams[5] = new SqlParameter("@AmortizeCount", AmortizeCount);
fparams[6] = new SqlParameter("@returnVal", SqlDbType.NVarChar, 2000);
fparams[6].Direction = ParameterDirection.Output;
//执行存储过程
_unitOfWork.ExcuteSql("EXEC [PROC_AMORTIZE] @ID,@VoucherAmt,@ItemId,@AmortizeType,@AmortizeDate,@AmortizeCount,@returnVal OUTPUT", fparams);
string IdList = fparams[6].Value.ToString();
return IdList;
原文地址:https://www.cnblogs.com/nayilvyangguang/p/9981523.html