ado.net 执行原生数据库事务

#region 访问数据库,执行赠送操作,并设置返回值

if (!ErrorInfo.Status)
{
DataConnection tempDataConnection = new DataConnection();
try
{
tempDataConnection.OpenSQLConnect();

tempDataConnection.BeginTransaction();

string sqlText = "Update [TRFinanceCCS].dbo.CashCouponInfo Set UserInfoCode = @ReceiverUserInfoCode " +
"WHERE CashCouponInfoCode = @CashCouponInfoCode " +
" " +
"Insert Into [TRFinanceCCS].dbo.CashCouponDonateRecord (CashCouponInfoCode, DonorUserInfoCode, ReceiverUserInfoCode, CreateTime) " +
"values (@CashCouponInfoCode, @DonorUserInfoCode, @ReceiverUserInfoCode, @CreateTime) ";

tempDataConnection.ClearParameter();
tempDataConnection.AppendParameter("@CashCouponInfoCode", cashCouponInfoCode);
tempDataConnection.AppendParameter("@DonorUserInfoCode", userInfoCode);
tempDataConnection.AppendParameter("@ReceiverUserInfoCode", userInfo.UserInfoCode);
tempDataConnection.AppendParameter("@CreateTime", DateTime.Now);

tempDataConnection.CommandType = CommandType.Text;
tempDataConnection.CommandText = sqlText;

tempDataConnection.ExecuteNonQuery();

tempDataConnection.CommitTransaction();

returnValue = true;
}
catch (Exception ex2)
{
tempDataConnection.RollbackTransaction();
returnValue = false;

ErrorInfo.Set(ex2.Message,
MethodBase.GetCurrentMethod(),
EnumErrorCategory.Error);
}
finally
{
tempDataConnection.CloseSQLConnect();
}
}

#endregion