From 43ded7d2ae74356ff8a53a7805d20b7dbfa6a729 Mon Sep 17 00:00:00 2001 From: lxw <810412026@qq.com> Date: 星期三, 17 八月 2022 16:05:04 +0800 Subject: [PATCH] component/getMaterialLimit 查询所有物料(分页,模糊查询) --- src/main/java/com/whyc/service/ComponentService.java | 18 ++++++++++++++++++ 1 files changed, 18 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/whyc/service/ComponentService.java b/src/main/java/com/whyc/service/ComponentService.java index dd780dd..6e55d32 100644 --- a/src/main/java/com/whyc/service/ComponentService.java +++ b/src/main/java/com/whyc/service/ComponentService.java @@ -53,4 +53,22 @@ public void deleteBatch(List<Integer> componentIdList) { mapper.deleteBatchIds(componentIdList); } + + //鏌ヨ鎵�鏈夌墿鏂�(鍒嗛〉锛屾ā绯婃煡璇�) + public Response getMaterialLimit(String subCode, String subName, String subModel, int pageCurr, int pageSize) { + PageHelper.startPage(pageCurr,pageSize); + QueryWrapper wrapper=new QueryWrapper(); + if(subCode!=null&&!subCode.isEmpty()){ + wrapper.like("sub_code",subCode); + } + if(subName!=null&&!subName.isEmpty()){ + wrapper.like("sub_name",subName); + } + if(subModel!=null&&!subModel.isEmpty()){ + wrapper.like("sub_model",subModel); + } + List<Component> list=mapper.selectList(wrapper); + PageInfo pageInfo=new PageInfo(list); + return new Response().setII(1,list.size()>0?true:false,pageInfo,"鏌ヨ鎵�鏈夌墿鏂�(鍒嗛〉锛屾ā绯婃煡璇�)"); + } } -- Gitblit v1.9.1