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); }