查询技术规格书

whyclxw

2024-01-12 aef6ef7e8d4c20f93a6daeacbc1188a028a19133

 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,"查询指定技术规格书的所有版本");
    }
}