LineServiceImpl.java
3.27 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
package com.bsth.service.impl;
import com.bsth.common.ResponseCode;
import com.bsth.entity.Line;
import com.bsth.repository.LineRepository;
import com.bsth.service.LineService;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.jdbc.core.JdbcTemplate;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.HashMap;
import java.util.Map;
/**
*
* @ClassName: LineServiceImpl(线路service业务层实现类)
*
* @Extends : BaseService
*
* @Description: TODO(线路service业务层)
*
* @Author bsth@lq
*
* @Date 2016年4月28日 上午9:21:17
*
* @Version 公交调度系统BS版 0.1
*
*/
@Service
public class LineServiceImpl extends BaseServiceImpl<Line, Integer> implements LineService {
@Autowired
private LineRepository repository;
@Autowired
JdbcTemplate jdbcTemplate;
/**
* 获取线路编码
*
* @return int <lineCode：线路编码>
*/
public long selectMaxIdToLineCode() {
// TODO Auto-generated method stub
return repository.selectMaxIdToLineCode();
}
@Override
public Line findByLineCode(String lineCode) {
return repository.findByLineCode(lineCode);
}
@Override
public Line findById(Integer id) {
// TODO Auto-generated method stub
return repository.findOne(id);
}
@Override
public String lineCodeVerification(String lineCode) {
String state = "true";
Line line = repository.findByLineCode(lineCode);
if (line != null) {
state = "false";
}
return state;
}
@Transactional
@Override
public Map<String, Object> update(Line l) {
Map<String, Object> map = new HashMap<>();
int status = repository.update(l.getName(), l.getCompany(), l.getBrancheCompany(), l.getLevel(), l.getNature(),
l.getStartStationName(), l.getEndStationName(), l.getStartStationFirstTime(),
l.getStartStationEndTime(), l.getEndStationFirstTime(), l.getEndStationEndTime(), l.getLinePlayType(),
l.getOpenDate(), l.getEs(), l.getShortName(), l.getShanghaiLinecode(), l.getEqLinecode(),
l.getStartPhone(), l.getEndPhone(), l.getCarSumNumber(), l.getHvacCarNumber(), l.getOrdCarNumber(),
l.getHistory(), l.getDescriptions(), l.getDestroy(), l.getSupperLine(), l.getSpacGrade(),
l.getWarrantCar(), l.getLineCode(), l.getRegion());
if (status==1) {
map.put("status", ResponseCode.SUCCESS);
} else {
map.put("status", ResponseCode.ERROR);
}
return map;
}
@Override
public Map<String, Object> remove(Integer id) {
Map<String, Object> map = new HashMap<>();
try{
if(null == id){
map.put("status", ResponseCode.ERROR);
map.put("msg", "参数异常");
return map;
}
int destroy = jdbcTemplate.queryForObject("select destroy from bsth_c_line where id=" + id, Integer.class);
if(destroy==0){
map.put("status", ResponseCode.ERROR);
map.put("msg", "你只能删除已撤销的线路！");
return map;
}
jdbcTemplate.update("update bsth_c_line set `remove`=1 where id=?", id);
map.put("status", ResponseCode.SUCCESS);
}catch (Exception e){
logger.error("", e);
map.put("status", ResponseCode.ERROR);
map.put("msg", e.getMessage());
}
return map;
}
}