查询技术规格书

whyclxw

2024-01-12 aef6ef7e8d4c20f93a6daeacbc1188a028a19133

查询技术规格书

 src/main/java/com/whyc/controller/TechnicalSpecificationController.java

@@ -61,4 +61,9 @@
        return service.getInfo(applyMaterialCode,applyModel,applyCustomCode,owner,lockFlag,pageNum,pageSize);
    }

    @ApiOperation("查询指定技术规格书的所有版本")
    @PostMapping("getVersionByInfo")
    public Response getVersionByInfo(@RequestParam(required = false) String applyMaterialCode ,@RequestParam(required = false) String applyModel,@RequestParam(required = false) String applyCustomCode) {
        return service.getVersionByInfo(applyMaterialCode,applyModel,applyCustomCode);
    }
}

 src/main/java/com/whyc/service/TechnicalSpecificationService.java

@@ -238,9 +238,12 @@
        if(applyModel!=null&&!applyModel.isEmpty()){
            query.like("apply_model",applyModel);
        }

        if(applyCustomCode!=null&&!applyCustomCode.isEmpty()){
        if(applyCustomCode!=null){
            if(applyCustomCode.equals("")){
                query.eq("apply_custom_code",applyCustomCode);
            }else{
            query.like("apply_custom_code",applyCustomCode);
            }
        }
        if(owner!=null&&!owner.isEmpty()){
            query.like("owner",owner);
@@ -252,4 +255,19 @@
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null,pageInfo,"查询技术规格书");
    }
   //查询指定技术规格书的所有版本
    public Response getVersionByInfo(String applyMaterialCode, String applyModel, String applyCustomCode) {
        QueryWrapper<TechnicalSpecification> query = Wrappers.query();
        if(applyMaterialCode!=null&&!applyMaterialCode.isEmpty()){
            query.eq("apply_material_code",applyMaterialCode);
        }
        if(applyModel!=null&&!applyModel.isEmpty()){
            query.eq("apply_model",applyModel);
        }
        if(applyCustomCode!=null){
            query.eq("apply_custom_code",applyCustomCode);
        }
        List<TechnicalSpecification> list=mapper.selectList(query);
        return new Response().setII(1,list!=null,list,"查询指定技术规格书的所有版本");
    }
}