TdCPoliceCarInfoDaoImpl.java
5 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
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
package com.zteits.pay.dao.impl;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
import org.apache.commons.collections4.CollectionUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.clouds.api.apibase.constants.DataStatusEnum;
import com.zteits.clouds.api.dto.pay.param.TdCPoliceCarInfoRequest;
import com.zteits.pay.dao.TdCPoliceCarInfoDao;
import com.zteits.pay.domain.TdCPoliceCarInfo;
import com.zteits.pay.domain.TdCPoliceCarInfoExample;
import com.zteits.pay.domain.TdCPoliceCarInfoExample.Criteria;
import com.zteits.pay.mapper.TdCPoliceCarInfoMapper;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
@Component
public class TdCPoliceCarInfoDaoImpl implements TdCPoliceCarInfoDao {
@Autowired
private TdCPoliceCarInfoMapper tdCPoliceCarInfoMapper;
@Override
public int saveTdCPoliceCarInfo(TdCPoliceCarInfo tdCPoliceCarInfo) {
if (tdCPoliceCarInfo.getCreateDate() == null) {
tdCPoliceCarInfo.setCreateDate(new Date());
}
return tdCPoliceCarInfoMapper.insertSelective(tdCPoliceCarInfo);
}
@Override
public int deleteTdCPoliceCarInfo(String carNumber) {
TdCPoliceCarInfo record = new TdCPoliceCarInfo();
record.setDataState(DataStatusEnum.DATA_STATUS_NO_VALID.value());
record.setModifyDate(new Date());
TdCPoliceCarInfoExample example = new TdCPoliceCarInfoExample();
example.createCriteria().andCarNumberEqualTo(carNumber).andDataStateEqualTo(
DataStatusEnum.DATA_STATUS_VALID.value());
return tdCPoliceCarInfoMapper.updateByExampleSelective(record, example);
}
@Override
public int updateByExampleSelective(TdCPoliceCarInfo record, TdCPoliceCarInfoExample example) {
return tdCPoliceCarInfoMapper.updateByExampleSelective(record, example);
}
@Override
public int updateByPrimaryKeySelective(TdCPoliceCarInfo record) {
return tdCPoliceCarInfoMapper.updateByPrimaryKeySelective(record);
}
@Override
public List<TdCPoliceCarInfo> selectByExample(TdCPoliceCarInfoExample example) {
return tdCPoliceCarInfoMapper.selectByExample(example);
}
@Override
public TdCPoliceCarInfo queryByPrimaryKey(Long id) {
return tdCPoliceCarInfoMapper.selectByPrimaryKey(id);
}
@Override
public List<TdCPoliceCarInfo> queryTdCPoliceCarInfo(TdCPoliceCarInfoRequest request) {
TdCPoliceCarInfoExample example = new TdCPoliceCarInfoExample();
Criteria sql = example.createCriteria();
sql.andDataStateEqualTo(DataStatusEnum.DATA_STATUS_VALID.value());
if (null != request.getCarNumber()) {
sql.andCarNumberLike(request.getCarNumber());
}
if (null != request.getPhoneNumber()) {
sql.andPhoneNumberLike(request.getPhoneNumber());
}
if (null != request.getCheckStatus()) {
sql.andCheckStatusEqualTo(request.getCheckStatus());
}
if (CollectionUtils.isNotEmpty(request.getCarNumbers())) {
sql.andCarNumberIn(request.getCarNumbers());
}
example.setOrderByClause("id desc");
List<TdCPoliceCarInfo> list = tdCPoliceCarInfoMapper.selectByExample(example);
return list;
}
@Override
public int batchDeleteTdCPoliceCarInfoByPrimaryKey(List<Long> ids, String opId, String opName) {
TdCPoliceCarInfo record = new TdCPoliceCarInfo();
record.setModifyEmpid(opId);
record.setModifyDate(new Date());
record.setDataState(DataStatusEnum.DATA_STATUS_NO_VALID.value());
TdCPoliceCarInfoExample example = new TdCPoliceCarInfoExample();
example.createCriteria().andIdIn(ids);
return tdCPoliceCarInfoMapper.updateByExampleSelective(record, example);
}
@Override
public PageInfo<TdCPoliceCarInfo> queryTdCPoliceCarInfoForPage(TdCPoliceCarInfoRequest request) {
PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());
TdCPoliceCarInfoExample example = new TdCPoliceCarInfoExample();
Criteria sql = example.createCriteria();
sql.andDataStateEqualTo(DataStatusEnum.DATA_STATUS_VALID.value());
if (null != request.getCarNumber()) {
sql.andCarNumberLike(request.getCarNumber());
}
if (null != request.getPhoneNumber()) {
sql.andPhoneNumberLike(request.getPhoneNumber());
}
if (null != request.getCheckStatus()) {
sql.andCheckStatusEqualTo(request.getCheckStatus());
}
if (CollectionUtils.isNotEmpty(request.getCarNumbers())) {
sql.andCarNumberIn(request.getCarNumbers());
}
example.setOrderByClause("id desc");
List<TdCPoliceCarInfo> list = tdCPoliceCarInfoMapper.selectByExample(example);
if (CollectionUtils.isNotEmpty(list)) {
return new PageInfo<>(list);
}
return new PageInfo<>(new ArrayList<>());
}
}