public async Task <IActionResult> UpdateCharactor(UpdateCharactorDto updateCharactor) { ServiceResponse <GetCharactorDto> response = await _charactorService.UpdateCharactor(updateCharactor); if (response.Data == null) { return(NotFound(response)); } return(Ok(response)); }
public async Task <ServiceResponse <GetCharactorDto> > UpdateCharactor(UpdateCharactorDto updateCharactorDto) { ServiceResponse <GetCharactorDto> serviceResponse = new ServiceResponse <GetCharactorDto>(); string cls = string.Format("{0:d2}", Convert.ToInt64(updateCharactorDto.Class)); string updateSql = $@"update charactor set name = '{updateCharactorDto.Name}', hitpoints = {updateCharactorDto.HitPoints}, strength = {updateCharactorDto.Strength}, defense = {updateCharactorDto.Defense}, intelligence = {updateCharactorDto.Intelligence}, class = '{cls}' where id = {updateCharactorDto.Id}"; OracleConnection conn = await OpenConnAsync(); int affectRows = 0; try { affectRows = await ExecuteSqlAsync(updateSql, null, conn); if (affectRows < 1) { throw new Exception($@"更新失败,未找到id为{updateCharactorDto.Id}的记录!"); } serviceResponse = await GetCharactorById(updateCharactorDto.Id); // Charactor charactor = charactors.FirstOrDefault(c => c.Id == updateCharactorDto.Id); // charactor.Name = updateCharactorDto.Name; // charactor.HitPoints = updateCharactorDto.HitPoints; // charactor.Strength = updateCharactorDto.Strength; // charactor.Defense = updateCharactorDto.Defense; // charactor.Intelligence = updateCharactorDto.Intelligence; // charactor.Class = updateCharactorDto.Class; //serviceResponse.Data = _mapper.Map<GetCharactorDto>(charactor); } catch (Exception ex) { serviceResponse.Success = false; serviceResponse.Message = ex.Message; } finally { conn.Close(); } return(serviceResponse); }