有以下存储过程:
Create procedure sp_sales
asDeclare @TransName varchar(50),
@Reason varchar(50)if not exists(select HeadID from table1)
begin
set
set @Reason='没有销售分项不能过帐'
Select '1' as result, @Reason as Reason
Return 1
endSet @TransName = 'SalesTransferAccount'
begin Transaction @TransName-- 更改客户的应收金额,总发票金额,发票金额
update erpCustomer set ARAmount=ARAmount+100
Begin
Set @Reason = '更新客户出错,请重新操作'
Goto Failcase
End-- 更改订单的状态 9-->完成
update erpSale set status=9 where ID=@id
Begin
Set @Reason = '更新订单状态时出错,请重新操作'
Goto Failcase
EndCommit Transaction @TransName
Set @Reason = ''
Select '0' as result , @Reason as Reason
Return 0Failcase:
Rollback Transaction @TransName
Select '1' as result, @Reason as Reason
Return 1在C#中如何获取存储过程的返回值,并且当返回值为1时输出@Reason中的信息?请大家帮忙看看,谢谢
Create procedure sp_sales
asDeclare @TransName varchar(50),
@Reason varchar(50)if not exists(select HeadID from table1)
begin
set
set @Reason='没有销售分项不能过帐'
Select '1' as result, @Reason as Reason
Return 1
endSet @TransName = 'SalesTransferAccount'
begin Transaction @TransName-- 更改客户的应收金额,总发票金额,发票金额
update erpCustomer set ARAmount=ARAmount+100
Begin
Set @Reason = '更新客户出错,请重新操作'
Goto Failcase
End-- 更改订单的状态 9-->完成
update erpSale set status=9 where ID=@id
Begin
Set @Reason = '更新订单状态时出错,请重新操作'
Goto Failcase
EndCommit Transaction @TransName
Set @Reason = ''
Select '0' as result , @Reason as Reason
Return 0Failcase:
Rollback Transaction @TransName
Select '1' as result, @Reason as Reason
Return 1在C#中如何获取存储过程的返回值,并且当返回值为1时输出@Reason中的信息?请大家帮忙看看,谢谢
解决方案 »
- 数据库中一个表中的数据变化了,我Client端想得到数据
- c# 数据库中姓名按拼音排序 提示错误
- datatable复制
- ~~~~急,c#中大于127的ASCII码如何转换为字符
- 不用显示准确季度的进度条
- System.Data.SqlClient.SqlException: 无法打开登录 'ou-hua' 中请求的数据库。登录失败。
- C#有没有使Pc的喇叭发声的方法?象VB中的Beep函数?
- 两个窗体内容类似,其中一个窗体已经做好了,另外一个窗体用什么方法做方便一些?
- VS2012无法添加应用
- C# for循环执行异步操作asyncMethod方法回调问题
- 我在程序窗体中调用外部程序,如何使外部程序界面窗体显示在本窗体内?(高分求救)
- 怎么实现一个用户帐号只能一个人登录.
int result;
string reason;
if(dr.Read())
{
result=dr.GetInt32(0);
reason = dr.GetString(1);
}
dr.Close();
if(result==1)
{
//显示reason就可以了
}
...SqlParameter rtnVal=cmd.Parameters.Add("rval",SqlDbType.Int);
rtnVal.Direction=ParameterDirection.ReturnValue;
SqlDataReader reader=cmd.ExecuteReader();
m_info.Text =rtnVal.Value.ToString();运行时系统提示:异常详细信息: System.NullReferenceException: 未将对象引用设置到对象的实例。请问是怎么回事?该如何做?