Question

下面这段代码报这个错：C# 此 SqlTransaction 已完成;它再也无法使用.

//转账的方法
public bool zhuanzhang(string outcard,string pass,string incard,decimal money,ref string errormessage)
{
conn.Open();
SqlCommand cmd = conn.CreateCommand();
SqlTransaction transaction= conn.BeginTransaction();
cmd.Transaction = transaction;
try
{
this.getsavemoney("支取", outcard, money, pass, ref errormessage);
this.getsavemoney("存入", incard, money, "", ref errormessage);
transaction.Commit();
return true;
}
catch (Exception ex)
{
errormessage = ex.Message;
transaction.Rollback();
return false;
}
finally
{
conn.Close();
}
}

Answer 1

你的this.getsavemoney("支取", outcard, money, pass, ref errormessage);
this.getsavemoney("存入", incard, money, "", ref errormessage);
这两段，操作是不是也是操作数据库的？
如果是，把那两端写在这个方法里。不然事物处理有问题。