110,567
社区成员
发帖
与我相关
我的任务
分享
public bool UpdateCellDataConfig(List<RPEDCellDataConfigInfo> cellDataConfigInfoList, string reportID, string organizationID, string strConnection)
{
using (TransactionScope scope = new TransactionScope(TransactionScopeOption.Required))
{
try
{
using (var context = new RPEDDbContext(strConnection))
{
var dcList = from o in context.RPEDCellDataConfigInfo
where o.ReportID == reportID
select o;
List<RPEDCellDataConfigInfo> p = (List<RPEDCellDataConfigInfo>)dcList.ToList();
foreach (RPEDCellDataConfigInfo item in p)
{
context.RPEDCellDataConfigInfo.Remove(item);
}
context.SaveChanges();
if (cellDataConfigInfoList != null && cellDataConfigInfoList.Count > 0)
{
foreach (RPEDCellDataConfigInfo iteminfo in cellDataConfigInfoList)
{
context.RPEDCellDataConfigInfo.Add(iteminfo);
}
}
context.SaveChanges();
}
scope.Complete();
return true;
}
catch (Exception e)
{
return false;
throw new Exception("配置信息提交失败." + e.Message);
}
finally
{
scope.Dispose();
}
}
}