NET程序调用带返回值存储过程代码

SqlParameter[] paras = new SqlParameter[]
{
new SqlParameter("@rx",SqlDbType.VarChar,50),
new SqlParameter("@shopCode",shopCode),
new SqlParameter("@type",type),
new SqlParameter("@actionBy",actionBy),
new SqlParameter("@amount",amount)
};
paras[0].Value = "";
paras[0].Direction = ParameterDirection.Output;

SqlHelper.ExecuteNonQueryByStore("Proc_TransferAccounts", paras);
string result = paras[0].Value.ToString();

return result;

原文地址:https://www.cnblogs.com/kavilee/p/2825070.html