ECR

lxw

2023-02-22 893b9ee88501f092683d855709d2aeb0a8f0273c

ECR

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

@@ -49,7 +49,9 @@

    @ApiOperation("分页查询ECR记录")
    @GetMapping("searchEcr")
    public Response searchEcr(@RequestParam String number, @RequestParam String subCode, @RequestParam String subModel,
    public Response searchEcr(@RequestParam(required = false) String number,
                              @RequestParam(required = false) String subCode,
                              @RequestParam(required = false) String subModel,
                              @RequestParam String createTime, @RequestParam String createTime1,
                              @RequestParam int pageCurr, @RequestParam int pageSize){
        Date testTime1= null;

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

@@ -237,9 +237,15 @@
    public Response searchEcr(String number, String subCode, String subModel, Date createTime, Date createTime1, int pageCurr, int pageSize) {
        PageHelper.startPage(pageCurr,pageSize);
        QueryWrapper wrapper=new QueryWrapper();
        wrapper.like("number",number);
        wrapper.like("sub_code",subCode);
        wrapper.like("sub_model",subModel);
        if(number!=null){
            wrapper.like("number",number);
        }
        if(subCode!=null){
            wrapper.like("sub_code",subCode);
        }
        if(subModel!=null){
            wrapper.like("sub_model",subModel);
        }
        wrapper.ge("create_time",createTime);
        wrapper.le("create_time",createTime1);
        wrapper.orderByAsc("number");