public FuncResult Bind(List <SysUserDataCondition> model, string currentUserId)
{
//检查是否重复绑定
foreach (SysUserDataCondition obj in model)
{
SysUserDataCondition entity = _context.SysUserDataCondition.
FirstOrDefault(e => ((!string.IsNullOrWhiteSpace(obj.UserGroupId) && e.UserGroupId == obj.UserGroupId) || (e.UserId == obj.UserId)) &&
e.ConditionId == obj.ConditionId && e.ConditionValue == obj.ConditionValue &&
e.ControllerId == obj.ControllerId);
if (entity != null)
{
return(new FuncResult()
{
IsSuccess = false, Message = $"[{obj.ConditionValue}] 已经绑定请勿重复操作!"
});
}
entity = new SysUserDataCondition()
{
Id = Guid.NewGuid().ToString("N"),
UserId = obj.UserId,
UserGroupId = obj.UserGroupId,
ConditionName = obj.ConditionName,
ConditionId = obj.ConditionId,
ConditionValue = obj.ConditionValue,
ControllerId = obj.ControllerId,
SortValue = obj.SortValue,
CreatedBy = currentUserId,
CreationDate = DateTime.Now,
LastUpdatedBy = currentUserId,
LastUpdateDate = DateTime.Now
};
_context.SysUserDataCondition.Add(entity);
}
using (Microsoft.EntityFrameworkCore.Storage.IDbContextTransaction trans = _context.Database.BeginTransaction())
{
try
{
_context.SaveChanges();
trans.Commit();
}
catch (Exception ex)
{
LogService.WriteError(ex);
trans.Rollback();
return(new FuncResult()
{
IsSuccess = false, Message = "添加数据时发生了预料之外的错误,请稍后重试"
});
}
}
return(new FuncResult()
{
IsSuccess = true
});
}
public FuncResult Unbind(string id, string currentUserId)
{
SysUserDataCondition entity = _context.SysUserDataCondition.Find(id);
if (entity == null)
{
return(new FuncResult()
{
IsSuccess = false, Message = "id错误"
});
}
entity.DeleteFlag = 1;
entity.DeleteBy = currentUserId;
entity.DeleteTime = DateTime.Now;
_context.SysUserDataCondition.Update(entity);
_context.SaveChanges();
return(new FuncResult()
{
IsSuccess = true
});
}
