From 7ae1c7638e3d7707d710dcd1406582891b47853b Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期一, 15 八月 2022 15:26:38 +0800
Subject: [PATCH] 物料编码字典查询
---
src/main/java/com/whyc/service/MaterialCodeDictionaryService.java | 16 ++++++++++++++++
1 files changed, 16 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/MaterialCodeDictionaryService.java b/src/main/java/com/whyc/service/MaterialCodeDictionaryService.java
index 2053bc0..51ae823 100644
--- a/src/main/java/com/whyc/service/MaterialCodeDictionaryService.java
+++ b/src/main/java/com/whyc/service/MaterialCodeDictionaryService.java
@@ -1,5 +1,9 @@
package com.whyc.service;
+import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.toolkit.Wrappers;
+import com.github.pagehelper.PageHelper;
+import com.github.pagehelper.PageInfo;
import com.whyc.mapper.MaterialCodeDictionaryMapper;
import com.whyc.pojo.MaterialCodeDictionary;
import org.springframework.stereotype.Service;
@@ -17,4 +21,16 @@
public void insertBatch(List<MaterialCodeDictionary> list) {
mapper.insertBatchSomeColumn(list);
}
+
+ public PageInfo<MaterialCodeDictionary> getCodeList(int pageNum, int pageSize, int level) {
+ PageHelper.startPage(pageNum,pageSize);
+ QueryWrapper<MaterialCodeDictionary> query = Wrappers.query();
+ if(level==1){
+ query.eq("parent_code","0");
+ }else if(level==2){
+ query.ne("parent_code","0");
+ }
+ List<MaterialCodeDictionary> materialCodeDictionaries = mapper.selectList(query);
+ return new PageInfo<MaterialCodeDictionary>(materialCodeDictionaries);
+ }
}
--
Gitblit v1.9.1