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;

posted @ 2012-12-19 15:50  无主之城  阅读(155)  评论(0编辑  收藏  举报