验收报告查询修改

whyclxw

2 天以前 12154b62b42df29173cdc54d7fd35d02d9a6422b

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
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;
 
import javax.annotation.Resource;
import java.util.List;
 
@Service
public class MaterialCodeDictionaryService {
 
    @Resource
    private MaterialCodeDictionaryMapper mapper;
 
 
    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);
    }
}