TdCCustBusinessParkDaoImpl.java
6.18 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
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
package com.zteits.business.dao.impl;
import org.apache.commons.collections4.CollectionUtils;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
import com.zteits.business.dao.TdCCustBusinessParkDao;
import com.zteits.business.domain.TdCCustBusinessPark;
import com.zteits.business.domain.TdCCustBusinessParkExample;
import com.zteits.business.mapper.TdCCustBusinessParkMapper;
import com.zteits.clouds.api.apibase.constants.DataStatusEnum;
import com.zteits.clouds.api.dto.business.param.TdCCustBusinessParkRequest;
import com.zteits.clouds.api.dto.business.param.TdCCustBusinessParkSaveRequest;
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Component;
import org.springframework.util.StringUtils;
import java.util.ArrayList;
import java.util.Date;
import java.util.List;
@Component
public class TdCCustBusinessParkDaoImpl implements TdCCustBusinessParkDao {
@Autowired
private TdCCustBusinessParkMapper tdCCustBusinessParkMapper;
@Override
public int saveTdCCustBusinessPark(TdCCustBusinessParkSaveRequest request) {
if(request.getCreateDate()==null){
request.setCreateDate(new Date());
}
int num = 0;
if(CollectionUtils.isNotEmpty(request.getPlNos())){
for(String plNo : request.getPlNos()){
TdCCustBusinessPark tdCCustBusinessPark = new TdCCustBusinessPark();
BeanUtils.copyProperties(request,tdCCustBusinessPark);
tdCCustBusinessPark.setPlNo(plNo);
//商户ID+车场ID查询是否重复添加，重复则忽略
TdCCustBusinessParkExample example = new TdCCustBusinessParkExample();
TdCCustBusinessParkExample.Criteria sql = example.createCriteria();
sql.andBusinessIdEqualTo(tdCCustBusinessPark.getBusinessId());
sql.andPlNoEqualTo(tdCCustBusinessPark.getPlNo());
sql.andDataStateEqualTo(1);
List list = tdCCustBusinessParkMapper.selectByExample(example);
if(CollectionUtils.isNotEmpty(list)){
continue;
}
int i = tdCCustBusinessParkMapper.insertSelective(tdCCustBusinessPark);
if (i > 0) {
num++;
}
}
}
return num;
}
@Override
public int updateByExampleSelective(TdCCustBusinessPark record, TdCCustBusinessParkExample example) {
return tdCCustBusinessParkMapper.updateByExampleSelective(record,example);
}
@Override
public int updateByPrimaryKeySelective(TdCCustBusinessPark record) {
return tdCCustBusinessParkMapper.updateByPrimaryKeySelective(record);
}
@Override
public List<TdCCustBusinessPark> selectByExample(TdCCustBusinessParkExample example) {
return tdCCustBusinessParkMapper.selectByExample(example);
}
@Override
public TdCCustBusinessPark queryByPrimaryKey(Long id) {
return tdCCustBusinessParkMapper.selectByPrimaryKey(id);
}
@Override
public List<TdCCustBusinessPark> queryTdCCustBusinessPark(TdCCustBusinessParkRequest request) {
return null;
}
// @Override
// public List<TdCCustBusiness> queryTdCCustBusinessPark(TdCCustBusinessParkRequest request) {
// TdCCustBusinessExample example = new TdCCustBusinessExample();
// TdCCustBusinessExample.Criteria sql = example.createCriteria();
// if(!StringUtils.isEmpty(request.getCustId())){
// sql.andCustIdEqualTo(request.getCustId());
// }
//
// if(!StringUtils.isEmpty(request.getBusinessName())){
// sql.andBusinessNameEqualTo(request.getBusinessName());
// }
//
// if(!StringUtils.isEmpty(request.getOrgId())){
// sql.andOrgIdEqualTo(request.getOrgId());
// }
// sql.andDataStateEqualTo(DataStatusEnum.DATA_STATUS_VALID.value());
// return tdCCustBusinessParkMapper.selectByExample(example);
// }
@Override
public int batchDeleteTdCCustBusinessParkByPrimaryKey(List<Long> ids, String opId, String opName) {
TdCCustBusinessPark record = new TdCCustBusinessPark();
record.setModifyEmpid(opId);
record.setModifyDate(new Date());
record.setDataState(DataStatusEnum.DATA_STATUS_NO_VALID.value());
TdCCustBusinessParkExample example = new TdCCustBusinessParkExample();
example.createCriteria().andIdIn(ids);
return tdCCustBusinessParkMapper.updateByExampleSelective(record,example);
}
@Override
public int deleteTdCCustBusinessParkByBusinessId(String businessId,Long orgId){
TdCCustBusinessParkExample example = new TdCCustBusinessParkExample();
TdCCustBusinessParkExample.Criteria sql = example.createCriteria();
if (!StringUtils.isEmpty(orgId)) {
sql.andOrgIdEqualTo(orgId);
}
sql.andBusinessIdEqualTo(businessId);
int num = tdCCustBusinessParkMapper.deleteByExample(example);
return num;
}
// @Override
public PageInfo<TdCCustBusinessPark> queryTdCCustBusinessParkForPage(TdCCustBusinessParkRequest request) {
PageHelper.startPage(request.getBaseRequest().getPageNum(), request.getBaseRequest().getPageSize());
TdCCustBusinessParkExample example = new TdCCustBusinessParkExample();
TdCCustBusinessParkExample.Criteria sql = example.createCriteria();
if(!StringUtils.isEmpty(request.getBusinessId())){
sql.andBusinessIdEqualTo(request.getBusinessId());
}
if(!StringUtils.isEmpty(request.getBusinessName())){
sql.andBusinessNameLike("%"+request.getBusinessName()+"%");
}
if(!StringUtils.isEmpty(request.getPlNo())){
sql.andPlNoEqualTo(request.getPlNo());
}
if(!StringUtils.isEmpty(request.getOrgId())){
sql.andOrgIdEqualTo(request.getOrgId());
}
sql.andDataStateEqualTo(1);
List<TdCCustBusinessPark> list = tdCCustBusinessParkMapper.selectByExample(example);
if (CollectionUtils.isNotEmpty(list)) {
return new PageInfo<>(list);
}
return new PageInfo<>(new ArrayList<>());
}
}