TpPEqpHostDaoImpl.java
3.83 KB
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
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
package com.zteits.park.dao.impl;
import com.zteits.park.domain.TpPEqpHost;
import com.zteits.park.domain.TpPEqpHostExample;
import com.zteits.park.domain.TpPEqpHostExample.Criteria;
import org.apache.commons.collections4.CollectionUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.clouds.api.dto.park.param.TpPEqpHostRequest;
import com.zteits.park.dao.TpPEqpHostDao;
import com.zteits.park.mapper.TpPEqpHostMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@Component
public class TpPEqpHostDaoImpl implements TpPEqpHostDao {
@Autowired
private TpPEqpHostMapper tpPEqpHostMapper;
@Override
public int deleteTpPEqpHostByPrimaryKey(Long id, String opId, String opName) {
TpPEqpHost record = new TpPEqpHost();
record.setId(id);
record.setModfiyEmpId(opId);
record.setModfiyEmpName(opName);
record.setModfiyDate(new Date());
return tpPEqpHostMapper.updateByPrimaryKeySelective(record);
}
@Override
public int saveTpPEqpHost(TpPEqpHost tpPEqpHost) {
if(tpPEqpHost.getCreateDate()==null){
tpPEqpHost.setCreateDate(new Date());
}
if(tpPEqpHost.getModfiyDate()==null){
tpPEqpHost.setModfiyDate(new Date());
}
return tpPEqpHostMapper.insertSelective(tpPEqpHost);
}
@Override
public int updateByExampleSelective(TpPEqpHost record, TpPEqpHostExample example) {
return tpPEqpHostMapper.updateByExampleSelective(record,example);
}
@Override
public int updateByPrimaryKeySelective(TpPEqpHost record) {
return tpPEqpHostMapper.updateByPrimaryKeySelective(record);
}
@Override
public List<TpPEqpHost> selectByExample(TpPEqpHostExample example) {
return tpPEqpHostMapper.selectByExample(example);
}
@Override
public TpPEqpHost queryByPrimaryKey(Long id) {
return tpPEqpHostMapper.selectByPrimaryKey(id);
}
@Override
public List<TpPEqpHost> queryTpPEqpHost(TpPEqpHostRequest request) {
TpPEqpHostExample example = new TpPEqpHostExample();
Criteria criteria = example.createCriteria();
if(request.getHostNo() != null){
criteria.andHostNoLike("%"+request.getHostNo()+"%");
}
if(request.getEqpModel() != null){
criteria.andEqpModelEqualTo(request.getHostNo());
}
return tpPEqpHostMapper.selectByExample(example);
}
@Override
public int batchDeleteTpPEqpHostByPrimaryKey(List<Long> ids, String opId, String opName) {
TpPEqpHost record = new TpPEqpHost();
record.setModfiyEmpId(opId);
record.setModfiyEmpName(opName);
record.setModfiyDate(new Date());
//where条件
TpPEqpHostExample example = new TpPEqpHostExample();
example.createCriteria().andIdIn(ids);
return tpPEqpHostMapper.updateByExampleSelective(record,example);
}
@Override
public PageInfo<TpPEqpHost> queryTpPEqpHostForPage(TpPEqpHostRequest request) {
PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());
TpPEqpHostExample example = new TpPEqpHostExample();
Criteria criteria = example.createCriteria();
if(request.getHostNo() != null){
criteria.andHostNoLike("%"+request.getHostNo()+"%");
}
if(request.getEqpModel() != null){
criteria.andEqpModelEqualTo(request.getHostNo());
}
List<TpPEqpHost> list = tpPEqpHostMapper.selectByExample(example);
if (CollectionUtils.isNotEmpty(list)) {
return new PageInfo<TpPEqpHost>(list);
}
return new PageInfo<TpPEqpHost>(new ArrayList<TpPEqpHost>());
}
}