public FuncResult Update(DataConditionModel model, string currentUserId)
{
if (_context.SysDataCondition.FirstOrDefault(e => e.TableName.ToUpper() == model.TableName.ToUpper() && e.SysDataConditionId != model.Id) != null)
{
return(new FuncResult()
{
IsSuccess = false, Message = "数据维度表名不能重复"
});
}
var entity = _context.SysDataCondition.FirstOrDefault(e => e.SysDataConditionId == model.Id);
if (entity == null)
{
return(new FuncResult()
{
IsSuccess = false, Message = "id错误"
});
}
entity.SysDataConditionId = model.Id;
entity.ConditionName = model.ConditionName;
entity.ParentId = model.ParentId;
entity.SortValue = model.SortValue;
entity.ConditionDesc = model.ConditionDesc;
entity.ConditionValue = model.ConditionValue;
entity.TableName = model.TableName;
entity.ParentColumn = model.ParentColumn;
entity.ConditionValueDesc = model.ConditionValueDesc;
entity.MasterSlaveFlag = model.MasterSlaveFlag?1:0;
entity.ChildColumn = "";
entity.LastUpdateDate = DateTime.Now;
entity.LastUpdatedBy = currentUserId;
if (entity.MasterSlaveFlag == 1)
{
if (string.IsNullOrWhiteSpace(model.ChildColumn))
{
return(new FuncResult()
{
IsSuccess = false, Message = "数据权限具有从属关系时,数据子级值所在列名不能为空"
});
}
entity.ChildColumn = model.ChildColumn;
}
_context.SysDataCondition.Update(entity);
_context.SaveChanges();
return(new FuncResult()
{
IsSuccess = true, Content = entity, 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 = "添加失败"
});
}
}
}
public async Task <FuncResult> Add([FromBody] DataConditionModel model)
{
if (!ModelState.IsValid)
{
return(new FuncResult()
{
IsSuccess = false, Message = "参数错误"
});
}
return(await storeService.Add(model, HttpContext.CurrentUser(cache).Id));
}
public FuncResult Update([FromBody] DataConditionModel model)
{
FuncResult data = storeService.Update(model, HttpContext.CurrentUser(cache).Id);
return(data);
}
