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

//参数
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;

 

posted @ 2018-11-19 09:50  tommy~hi  阅读(344)  评论(0编辑  收藏  举报