// DELETE: api/Permission/5 public async Task <HandleResult> Delete(string id) { var command = new ChangePermission(id, (int)UseFlag.Disabled); var result = await ExecuteCommandAsync(command); if (result.IsSuccess()) { return(HandleResult.FromSuccess("删除成功")); } return(HandleResult.FromFail(result.GetErrorMessage())); }
/// <summary> /// Changes permission /// </summary> /// <param name="changePermission"><see cref="ChangePermission"/></param> public void AlterPermissions(ChangePermission changePermission) { using (MySqlConnection connection = WebApiConfig.Connection()) using (MySqlCommand command = new MySqlCommand($"DELETE FROM `tbPermissions` WHERE `IdAdmin` = {changePermission.AdminId}", connection)) { connection.Open(); command.ExecuteNonQuery(); foreach (int item in changePermission.Permissions) { command.CommandText = $"INSERT INTO `tbPermissions`(`Id`, `Permission`, `IdAdmin`) VALUES (null,{item},{changePermission.AdminId})"; command.ExecuteNonQuery(); } } }
/// <summary>删除权限 /// </summary> public void Handle(ICommandContext context, ChangePermission command) { context.Get <Permission>(command.AggregateRootId).Change(command.UseFlag); }