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 = "添加失败" }); } } }