public async Task <FuncResult> Delete(string id, string currentUserId)
{
try
{
SysDataCondition entity = await _context.SysDataCondition.FindAsync(id);
if (entity == null)
{
return(new FuncResult()
{
IsSuccess = false, Message = "id错误"
});
}
entity.DeleteFlag = 1;
entity.DeleteTime = DateTime.Now;
entity.LastUpdatedBy = currentUserId;
_context.Update(entity);
_context.SaveChanges();
return(new FuncResult()
{
IsSuccess = true, Message = "删除成功"
});
}
catch (Exception)
{
return(new FuncResult()
{
IsSuccess = false, Message = "删除失败"
});
}
}
public async Task <FuncResult> Add(DataConditionModel model, string currentUserId)
{
if (_context.SysDataCondition.FirstOrDefault(e => e.TableName.ToUpper() == model.TableName.ToUpper()) != null)
{
return(new FuncResult()
{
IsSuccess = false, Message = "数据维度表名不能重复"
});
}
SysDataCondition entity = new SysDataCondition
{
SysDataConditionId = Guid.NewGuid().ToString("N"),
ConditionName = model.ConditionName,
ParentId = model.ParentId,
SortValue = model.SortValue,
ConditionDesc = model.ConditionDesc,
ConditionValue = model.ConditionValue,
TableName = model.TableName,
ParentColumn = model.ParentColumn,
ConditionValueDesc = model.ConditionValueDesc,
ChildColumn = model.ChildColumn,
MasterSlaveFlag = model.MasterSlaveFlag == true?1:0,
CreationDate = DateTime.Now,
CreatedBy = currentUserId,
LastUpdateDate = DateTime.Now,
LastUpdatedBy = currentUserId
};
await _context.SysDataCondition.AddAsync(entity);
using (Microsoft.EntityFrameworkCore.Storage.IDbContextTransaction trans = _context.Database.BeginTransaction())
{
try
{
await _context.SaveChangesAsync();
trans.Commit();
return(new FuncResult()
{
IsSuccess = true, Content = entity, Message = "添加成功"
});
}
catch (Exception ex)
{
trans.Rollback();
return(new FuncResult()
{
IsSuccess = false, Content = ex.Message, Message = "添加失败"
});
}
}
}
