遥测量及遥信量设置日志查询

whycxzp

2023-12-20 85d2c83e9f6ac71273968a642a798a995a4df376

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
37
38
39
40
41
42
43
44
45
46
47
48
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.dto.Response;
import com.whyc.mapper.CKPowerDevSignalSetLogMapper;
import com.whyc.pojo.db_ckpwrdev_data_rt.CKPowerDevBreakerControlLog;
import com.whyc.pojo.db_ckpwrdev_data_rt.CKPowerDevSignalSetLog;
import org.springframework.stereotype.Service;
 
import javax.annotation.Resource;
import java.util.List;
 
@Service
public class CKPowerDevSignalSetLogService {
 
    @Resource
    private CKPowerDevSignalSetLogMapper mapper;
 
    public void addBatch(List<CKPowerDevSignalSetLog> logList) {
        mapper.insertBatchSomeColumn(logList);
    }
 
    public Response getPage(CKPowerDevSignalSetLog param) {
        Integer pageNum = param.getPageNum();
        Integer pageSize = param.getPageSize();
        PageHelper.startPage(pageNum,pageSize);
        QueryWrapper<CKPowerDevSignalSetLog> query = Wrappers.query();
 
        if(param.getDevType()!=null){
            query.eq("dev_type",param.getDevType());
        }
        if(param.getParamCn()!=null){
            query.eq("param_cn",param.getParamCn());
        }
        if(param.getStartTime()!=null){
            query.ge("create_day",param.getStartTime());
        }
        if(param.getEndTime()!=null){
            query.le("create_day",param.getEndTime());
        }
        List<CKPowerDevSignalSetLog> list = mapper.selectList(query);
        PageInfo<CKPowerDevSignalSetLog> pageInfo = new PageInfo<>(list);
        return new Response().set(1,pageInfo);
    }
}