一个方法同时操作多表异常时无法正常进行事务回滚（任有数据添加到数据库），尝试手动事务db.Ado.BeginTran()与，不知如何处理才能正常使用多表回滚操作.

调试时发现Furion.DatabaseAccessor.UnitOfWorkAttribute里的回滚代码已运行，但数据库数据没效果。

```

/// <summary>

/// aaa

/// </summary>

[Route("pm/[controller]")]

[ApiDescriptionSettings("Service", Name = "TaskService", Order = 1)]

public class SimsTestTaskInfoService : IDynamicApiController, ITransient

{

/// <summary>

/// 存储内容

/// </summary>

SqlSugarRepository<s1> _sqlSugarRepository;

/// <summary>

/// 测试用例

/// </summary>

SqlSugarRepository<s2> _simsTestCase;

/// <summary>

/// 循环控制

/// </summary>

SqlSugarRepository<s3> _simsTestCycleControl;

/// <summary>

/// 数据指令

/// </summary>

SqlSugarRepository<s4> _simsTestDataCmd;

/// <summary>

/// 条件判断

/// </summary>

SqlSugarRepository<s5> _simsTestConditionJudge;

/// <summary>

/// 任务管理器

/// </summary>

ISchedulerFactory _schedulerFactory;

....代码略...............................

/// <summary>

/// 创建任务

/// </summary>

[ApiDescriptionSettings(Name = "CreateTask")]

[DisplayName("创建任务")]

[UnitOfWorkAttribute]

public void CreateTask(TaskInfo simsTest)

{

//var db = _simsTestConditionJudge.Context;

//db.Ado.BeginTran();

var taskinfo = simsTest.Taskinfo;

var info = simsTest.CaseInfos;

if (info.TestCase != null)

{

info.TestCase.ForEach(p => { p.TaskID = taskinfo.Id; p.SlnID = taskinfo.SlnID; p.SimsTestNodeID = taskinfo.SimsTestNodeID; });

_simsTestDataCmd.Context.Insertable(info.TestCase).ExecuteCommand();

}

if (info.CycleControl != null)

{

info.CycleControl.ForEach(p => { p.TaskID = taskinfo.Id; p.SlnID = taskinfo.SlnID; });

_simsTestDataCmd.Context.Insertable(info.CycleControl).ExecuteCommand();

}

if (info.ConditionJudge != null)

{

info.ConditionJudge.ForEach(p => { p.TaskID = taskinfo.Id; p.SlnID = taskinfo.SlnID; });

_simsTestDataCmd.Context.Insertable(info.ConditionJudge).ExecuteCommand();

}

if (info.DataCmd != null)

{

info.DataCmd.ForEach(p => { p.TaskID = taskinfo.Id; p.SlnID = taskinfo.SlnID; });

_simsTestDataCmd.Context.Insertable(info.DataCmd).ExecuteCommand();

}

//创建测试任务

_dispatcher.AddJob(taskinfo.Id, taskinfo.SlnID.Value, id.ToString());

taskinfo.JobID = id.ToString();

_simsTestDataCmd.Context.Insertable(simsTest.Taskinfo).ExecuteCommand();

//添加触发器

if (simsTest.sysJobTriggerTrigger != null)

{

simsTest.sysJobTriggerTrigger.JobId = taskinfo.JobID;

//simsTest.sysJobTriggerTrigger.Args = "[" + simsTest.sysJobTriggerTrigger.Args + "]";

var scheduler = _schedulerFactory.GetJob(taskinfo.JobID);

scheduler?.AddTrigger(Triggers.Create(simsTest.sysJobTriggerTrigger.AssemblyName, simsTest.sysJobTriggerTrigger.TriggerType).LoadFrom(simsTest.sysJobTriggerTrigger));

_sysJobTriggerRep.Insert(simsTest.sysJobTriggerTrigger);

}

//db.Ado.CommitTran();

}}

```