From 6cec4ab006f861ef8bdcadd1e1f6806f5241e9c5 Mon Sep 17 00:00:00 2001
From: lxw <810412026@qq.com>
Date: 星期五, 19 八月 2022 10:15:35 +0800
Subject: [PATCH] 查询出所有的产品信息(分页加模糊查询<产品的编码，型号，名字，定制表编号>)
---
src/main/java/com/whyc/service/ProductService.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/ProductService.java b/src/main/java/com/whyc/service/ProductService.java
index bc82b74..f6a7b00 100644
--- a/src/main/java/com/whyc/service/ProductService.java
+++ b/src/main/java/com/whyc/service/ProductService.java
@@ -1,5 +1,8 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
import com.whyc.dto.Response;
import com.whyc.mapper.ProductMapper;
import org.springframework.beans.factory.annotation.Autowired;
@@ -16,4 +19,25 @@
List list=mapper.getProductByMaterial(subCode);
return new Response().setII(1,list.size()>0?true:false,list,"");
}
+ //鏌ヨ鍑烘墍鏈夌殑浜у搧淇℃伅(鍒嗛〉鍔犳ā绯婃煡璇�<浜у搧鐨勭紪鐮侊紝鍨嬪彿锛屽悕瀛楋紝瀹氬埗琛ㄧ紪鍙�>
+ public Response getAllProduct(String parentCode, String parentName, String parentModel, String customCode, int pageCurr, int pageSize) {
+ PageHelper.startPage(pageCurr,pageSize);
+ QueryWrapper wrapper=new QueryWrapper();
+ if(parentCode!=null&&!parentCode.isEmpty()){
+ wrapper.like("parent_code",parentCode);
+ }
+ if(parentName!=null&&!parentName.isEmpty()){
+ wrapper.like("parent_name",parentName);
+ }
+ if(parentModel!=null&&!parentModel.isEmpty()){
+ wrapper.like("parent_model",parentModel);
+ }
+ if(customCode!=null&&!customCode.isEmpty()){
+ wrapper.like("custom_code",customCode);
+ }
+ wrapper.orderByAsc("id");
+ List list=mapper.selectList(wrapper);
+ PageInfo pageInfo=new PageInfo(list);
+ return new Response().setII(1,list.size()>0?true:false,pageInfo,"杩斿洖浜у搧淇℃伅");
+ }
}
--
Gitblit v1.9.1