多表增删改查模板

最新推荐文章于 2024-07-22 14:15:06 发布

R-sz

最新推荐文章于 2024-07-22 14:15:06 发布

阅读量35

点赞数

文章标签： java sqlserver 数学建模

本文链接：https://blog.csdn.net/weixin_42759398/article/details/131353744

版权

【代码】多表增删改查模板。

摘要由CSDN通过智能技术生成

@Slf4j
@Service
public class InspectPlanServiceImpl implements InspectPlanService {

    @Resource
    private InspectPlanMapper inspectPlanMapper;

    @Resource
    private QualityInspectPlanMapper qualityInspectPlanMapper;
    @Resource
    private QualityInspectPlanInfoMapper qualityInspectPlanInfoMapper;
    @Override
    public Page<InspectPlanListVO> getPage(InspectPlanListDTO dto){
        //return inspectPlanMapper.getPage(dto);
        if (ObjectUtil.isNotEmpty(dto.getWriteTimeEnd())) {
            dto.setWriteTimeEnd(dto.getWriteTimeEnd().plusDays(1L));
        }
        if (ObjectUtil.isNotEmpty(dto.getPlanDateEnd())) {
            dto.setPlanDateEnd(dto.getPlanDateEnd().plusDays(1L));
        }
        Page<InspectPlanListVO> page = inspectPlanMapper.getPage(dto);
        return page;
    }
    @Override
    public List<InspectPlanListVO> getList(InspectPlanListDTO dto){
        List<InspectPlanListVO> list = inspectPlanMapper.getList(dto);
        return list;
    }


    /**
    * 详情
    * @param dto 入参
    * @return
    */
    @SneakyThrows
    @Override
    public InspectPlanDetailVO getInfo(InspectPlanDetailDTO dto){
        if (Objects.isNull(dto)) {
            new IllegalStateException("参数异常");
        }
        Long mainColumn = dto.getId();
        if(Objects.isNull(mainColumn)){
            new IllegalStateException("参数异常");
        }
        InspectPlanDetailVO mainTableVO = new InspectPlanDetailVO();
        QualityInspectPlan mainTableEntity = qualityInspectPlanMapper.selectOne(Wrappers.<QualityInspectPlan>lambdaQuery().eq(QualityInspectPlan::getId,mainColumn));
        if(Objects.isNull(mainTableEntity)) return null;
        BeanUtil.copyProperties(mainTableEntity,mainTableVO);
        List<QualityInspectPlanInfo> qualityInspectPlanInfo = qualityInspectPlanInfoMapper.selectList(Wrappers.<QualityInspectPlanInfo>lambdaQuery().eq(QualityInspectPlanInfo::getInspectPlanId,mainTableEntity.getId() ).eq(QualityInspectPlanInfo::getInspectPlanNum,mainTableEntity.getInspectPlanNum() ));
        List<QualityInspectPlanInfoVO> qualityInspectPlanInfoList = new ArrayList<>();
        for (QualityInspectPlanInfo iterm : qualityInspectPlanInfo) {
            QualityInspectPlanInfoVO tem