查询技术规格书

whyclxw

2024-01-11 6b5d76b1d3fe0b211531e9b4522a6487fa538c01

查询技术规格书

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

@@ -53,4 +53,12 @@
        return service.updateLock(id,lockFlag);
    }

    @ApiOperation("查询技术规格书")
    @PostMapping("getInfo")
    public Response getInfo(@RequestParam(required = false) String applyMaterialCode ,@RequestParam(required = false) String applyModel,@RequestParam(required = false) String applyCustomCode
                           ,@RequestParam(required = false) String owner,@RequestParam(required = false) int lockFlaq
                           ,@RequestParam int pageNum,@RequestParam Integer pageSize) {
        return service.getInfo(applyMaterialCode,applyModel,applyCustomCode,owner,lockFlaq,pageNum,pageSize);
    }

}

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

@@ -3,6 +3,8 @@
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.TechnicalSpecificationMapper;
import com.whyc.pojo.TechnicalSpecification;
@@ -18,6 +20,7 @@
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.bind.annotation.RequestParam;
import org.springframework.web.multipart.MultipartFile;

import javax.annotation.Resource;
@@ -26,6 +29,7 @@
import java.io.InputStream;
import java.text.ParseException;
import java.util.Date;
import java.util.List;

@Service
public class TechnicalSpecificationService {
@@ -222,4 +226,30 @@
    private TechnicalSpecification get(int id){
        return mapper.selectById(id);
    }

    //查询技术规格书
    public Response getInfo(String applyMaterialCode, String applyModel, String applyCustomCode, String owner, Integer lockFlaq
                            ,int pageNum, int pageSize) {
        PageHelper.startPage(pageNum,pageSize);
        QueryWrapper<TechnicalSpecification> query = Wrappers.query();
        if(applyMaterialCode!=null&&!applyMaterialCode.isEmpty()){
            query.like("apply_material_code",applyMaterialCode);
        }
        if(applyModel!=null&&!applyModel.isEmpty()){
            query.like("apply_model",applyModel);
        }

        if(applyCustomCode!=null&&!applyCustomCode.isEmpty()){
            query.like("apply_custom_code",applyCustomCode);
        }
        if(owner!=null&&!owner.isEmpty()){
            query.like("owner",owner);
        }
        if(lockFlaq!=null){
            query.eq("lock_flaq",lockFlaq);
        }
        List<TechnicalSpecification> list=mapper.selectList(query);
        PageInfo pageInfo=new PageInfo(list);
        return new Response().setII(1,list!=null,pageInfo,"查询技术规格书");
    }
}