SectionRepository.java
4.59 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.repository;
import org.springframework.data.jpa.repository.Modifying;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;
import org.springframework.transaction.annotation.Transactional;
import com.bsth.entity.Section;
import java.util.List;
/**
*
* @Interface: SectionRepository(路段Repository数据持久层接口)
*
* @Extends : BaseRepository
*
* @Description: TODO(路段Repository数据持久层接口)
*
* @Author bsth@lq
*
* @Date 2016年05月03日 上午9:21:17
*
* @Version 公交调度系统BS版 0.1
*
*/
@Repository
public interface SectionRepository extends BaseRepository<Section, Integer> {
// 查询最大ID
@Query(value = "SELECT IFNULL(num,0) as maxId from (SELECT MAX(id) as num FROM bsth_c_section) k"
, nativeQuery=true)
public long sectionMaxId();
/**
* @Description :TODO(系统规划路段保存)
*
* @param map <sectionCode: 路段编码；sectionName：路段名称；crosesRoad：交叉路；endNode：终止节点；startNode：起始节点；
*
* middleNode：线路ID；gsectionVector：路段矢量(空间坐标点集合)WGS坐标点；bsectionVector：路段矢量(空间坐标点集合)--百度原始坐标坐标点；
*
* sectionType：路段类型 ；csectionVector：路段矢量(空间坐标点集合)--城建坐标点；roadCoding：路段编码；sectionDistance：路段距离；
*
* sectionTime：路段时间；dbType： 经纬坐标类型；speedLimit：限速；descriptions：描述；versions：版本号>
*/
@Transactional
@Modifying
@Query(value="INSERT INTO bsth_c_section "+
"(section_code , section_name , croses_road , end_node, start_node ,"+
"middle_node , gsection_vector, bsection_vector , section_type , csection_vector,"+
"road_coding , section_distance , section_time , db_type, speed_limit ,"+
"descriptions , versions,id) "+
"VALUES (?1 , ?2 , ?3 , ?4 , ?5 , "+
"?6 , ST_GeomFromText(?7) , ST_GeomFromText(?8) , ?9 , ?10 ,"+
"?11 , ?12 , ?13 , ?14 , ?15 ,"+
"?16 , ?17, ?18"+
")", nativeQuery=true)
public void systemSave(String sectionCode, String sectionName, String crosesRoad, String endNode, String startNode,
String middleNode, String gsectionVector, String bsectionVector, String sectionType, String csectionVector,
String roadCoding, double sectionDistance, double sectionTime, String dbType, double speedLimit,
String descriptions, int versions, int id);
/**
* @Description :TODO(编辑线路走向)
*
* @param map <sectionId:路段ID； gsectionVector：折线WGS坐标；bsectionVector：折线百度坐标>
*
* @return Map<String, Object> <SUCCESS ; ERROR>
*/
@Transactional
@Modifying
@Query(value="UPDATE bsth_c_section SET " +
" gsection_vector = ST_GeomFromText(?2) , " +
" bsection_vector = ST_GeomFromText(?3)," +
" section_code = ?4," +
" section_name = ?5," +
" croses_road = ?6," +
" end_node = ?7," +
" start_node = ?8," +
" middle_node = ?9," +
" section_type = ?10," +
" road_coding = ?11," +
" section_distance = ?12," +
" section_time = ?13," +
" db_type = ?14," +
" speed_limit = ?15," +
" descriptions = ?16," +
" versions = ?17," +
" create_by = ?18," +
" create_date = str_to_date(?19,'%Y-%m-%d %H:%i:%s')," +
" update_by = ?20," +
" update_date = str_to_date(?21,'%Y-%m-%d %H:%i:%s')" +
" WHERE id = ?1", nativeQuery=true)
public void sectionUpdate(Integer sectionId, String gsectionVector, String bsectionVector, String sectionCode, String sectionName,
String crosesRoad, String endNode, String startNode, String middleNode, String sectionType,
String roadCoding, Double sectionDistance, Double sectionTime, String dbType,
Double speedLimit, String descriptions, Integer version, Integer createBy, String createDate,
Integer updateBy, String updateDate);
@Query(value = "SELECT AsText(s.bsection_vector) as section,r.directions as dir FROM bsth_c_section s left join bsth_c_sectionroute r on s.section_code = r.section_code " +
"where r.line = ?1 and directions = ?2 ORDER BY r.directions,r.sectionroute_code ",nativeQuery = true)
List<Object[]> getSectionDirByLineId(Integer lineId, Integer directions);
}