inspection-server/src/main/java/com/yuanchu/limslaboratory/controller/LinkBasicInformationController.java
@@ -73,6 +73,12 @@ return Result.success(map); } @ApiOperation("根据id查询Specifications表的Name") @GetMapping("/getSpecificationsName") public Result<?> getSpecificationsName(String id){ return Result.success(linkBasicInformationService.getSpecificationsName(id)); } @ApiOperation("删除") @ApiImplicitParams(value = { @ApiImplicitParam(name = "id", value = "委托样品id", dataTypeClass = Integer.class, required = true) inspection-server/src/main/java/com/yuanchu/limslaboratory/service/LinkBasicInformationService.java
@@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.limslaboratory.pojo.LinkBasicInformation; import com.baomidou.mybatisplus.extension.service.IService; import com.yuanchu.limslaboratory.pojo.Specifications; import com.yuanchu.limslaboratory.pojo.vo.InspectionVo; import org.springframework.transaction.annotation.Transactional; @@ -41,4 +42,6 @@ //根据委托样品id删除 void delLink(Integer id); Specifications getSpecificationsName(String id); } inspection-server/src/main/java/com/yuanchu/limslaboratory/service/impl/LinkBasicInformationServiceImpl.java
@@ -4,9 +4,11 @@ import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.limslaboratory.mapper.LinkDetectionMapper; import com.yuanchu.limslaboratory.mapper.SpecificationsMapper; import com.yuanchu.limslaboratory.pojo.LinkBasicInformation; import com.yuanchu.limslaboratory.mapper.LinkBasicInformationMapper; import com.yuanchu.limslaboratory.pojo.LinkDetection; import com.yuanchu.limslaboratory.pojo.Specifications; import com.yuanchu.limslaboratory.service.LinkBasicInformationService; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import com.yuanchu.limslaboratory.service.LinkDetectionService; @@ -38,6 +40,9 @@ @Autowired private LinkDetectionService linkDetectionService; @Autowired private SpecificationsMapper specificationsMapperOn; @Override @Transactional(rollbackFor = Exception.class) @@ -114,5 +119,14 @@ linkDetectionService.updateById(linkDetection); } @Override public Specifications getSpecificationsName(String id) { QueryWrapper<Specifications>queryWrapper=new QueryWrapper<>(); queryWrapper.lambda().select(Specifications::getName) .eq(Specifications::getId,id) .eq(Specifications::getState,1); return specificationsMapperOn.selectOne(queryWrapper); } } standard-server/src/main/java/com/yuanchu/limslaboratory/mapper/SpecificationsMapper.java
@@ -4,6 +4,7 @@ import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.yuanchu.limslaboratory.pojo.Specifications; import com.baomidou.mybatisplus.core.mapper.BaseMapper; import org.springframework.stereotype.Repository; import java.util.Map; import java.util.Objects; @@ -16,6 +17,7 @@ * @author 江苏鵷雏网络科技有限公司 * @since 2023-07-11 */ @Repository public interface SpecificationsMapper extends BaseMapper<Specifications> { Map<String, Object> selectSNameSNName(int materialId);