/// <summary>
/// 添加配置表信息
/// </summary>
/// <param name="approvalConfiguration"></param>
/// <returns></returns>
public int AddApprovalConfiguration(List <ApprovalConfiguration> approvalConfiguration)
{
var result = 0;
var oneId = 0;
var twoId = 0;
using (var tr = _context.Database.BeginTransaction())
{
try
{ //进行循环这个集合
foreach (var configuration in approvalConfiguration)
{
//进行一个添加操作
_context.ApprovalConfiguration.Add(configuration);
//进入保存一个操作
_context.SaveChanges();
//先进行把TwoId赋值给OneId
oneId = twoId;
//再把twoId赋值为当前的Id
twoId = configuration.Id;
//去配置表中查询是否有这个活动而且下一步Id为0的数据
var queryable = _context.ApprovalConfiguration.FirstOrDefault(p => p.Id == oneId);
if (queryable == null)
{
continue;
}
queryable.DownId = twoId;
//如果为空那么返回自增长Id
result = _context.SaveChanges();
//不为空则修改为当前自增长Id
}
tr.Commit();
return(1);
}
catch (Exception e)
{
tr.Rollback();
Console.WriteLine(e);
return(result);
}
finally
{
_context.Dispose();
}
}
//var result = _context.SaveChanges();
//return result;
}
