InspectionTaskV1ServiceDaoImpl.java
5.07 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
/*
* Copyright 2017-2020 吴学文 and java110 team.
*
* Licensed under the Apache License, Version 2.0 (the "License");
* you may not use this file except in compliance with the License.
* You may obtain a copy of the License at
*
* http://www.apache.org/licenses/LICENSE-2.0
*
* Unless required by applicable law or agreed to in writing, software
* distributed under the License is distributed on an "AS IS" BASIS,
* WITHOUT WARRANTIES OR CONDITIONS OF ANY KIND, either express or implied.
* See the License for the specific language governing permissions and
* limitations under the License.
*/
package com.java110.community.dao.impl;
import com.alibaba.fastjson.JSONObject;
import com.java110.utils.constant.ResponseConstant;
import com.java110.utils.exception.DAOException;
import com.java110.utils.util.DateUtil;
import com.java110.core.base.dao.BaseServiceDao;
import com.java110.community.dao.IInspectionTaskV1ServiceDao;
import org.slf4j.Logger;
import org.slf4j.LoggerFactory;
import org.springframework.stereotype.Service;
import org.springframework.transaction.annotation.Transactional;
import java.util.List;
import java.util.Map;
/**
* 类表述：
* add by 吴学文 at 2022-03-16 09:35:12 mail: 928255095@qq.com
* open source address: https://gitee.com/wuxw7/MicroCommunity
* 官网：http://www.homecommunity.cn
* 温馨提示：如果您对此文件进行修改 请不要删除原有作者及注释信息，请补充您的 修改的原因以及联系邮箱如下
* // modify by 张三 at 2021-09-12 第10行在某种场景下存在某种bug 需要修复，注释10至20行 加入 20行至30行
*/
@Service("inspectionTaskV1ServiceDaoImpl")
public class InspectionTaskV1ServiceDaoImpl extends BaseServiceDao implements IInspectionTaskV1ServiceDao {
private static Logger logger = LoggerFactory.getLogger(InspectionTaskV1ServiceDaoImpl.class);
/**
* 保存巡检任务信息 到 instance
* @param info bId 信息
* @throws DAOException DAO异常
*/
@Override
public int saveInspectionTaskInfo(Map info) throws DAOException {
logger.debug("保存 saveInspectionTaskInfo 入参 info : {}",info);
int saveFlag = sqlSessionTemplate.insert("inspectionTaskV1ServiceDaoImpl.saveInspectionTaskInfo",info);
return saveFlag;
}
/**
* 查询巡检任务信息（instance）
* @param info bId 信息
* @return List<Map>
* @throws DAOException DAO异常
*/
@Override
public List<Map> getInspectionTaskInfo(Map info) throws DAOException {
logger.debug("查询 getInspectionTaskInfo 入参 info : {}",info);
List<Map> businessInspectionTaskInfos = sqlSessionTemplate.selectList("inspectionTaskV1ServiceDaoImpl.getInspectionTaskInfo",info);
return businessInspectionTaskInfos;
}
/**
* 修改巡检任务信息
* @param info 修改信息
* @throws DAOException DAO异常
*/
@Override
public int updateInspectionTaskInfo(Map info) throws DAOException {
logger.debug("修改 updateInspectionTaskInfo 入参 info : {}",info);
int saveFlag = sqlSessionTemplate.update("inspectionTaskV1ServiceDaoImpl.updateInspectionTaskInfo",info);
return saveFlag;
}
/**
* 查询巡检任务数量
* @param info 巡检任务信息
* @return 巡检任务数量
*/
@Override
public int queryInspectionTasksCount(Map info) {
logger.debug("查询 queryInspectionTasksCount 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("inspectionTaskV1ServiceDaoImpl.queryInspectionTasksCount", info);
if (infos.size() < 1) {
return 0;
}
return Integer.parseInt(infos.get(0).get("count").toString());
}
@Override
public int queryPointInspectionTasksCount(Map info) {
logger.debug("查询 queryInspectionTasksCount 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("inspectionTaskV1ServiceDaoImpl.queryPointInspectionTasksCount", info);
if (infos.size() < 1) {
return 0;
}
return Integer.parseInt(infos.get(0).get("count").toString());
}
@Override
public List<Map> queryPointInspectionTasks(Map info) {
logger.debug("查询 getInspectionTaskInfo 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("inspectionTaskV1ServiceDaoImpl.queryPointInspectionTasks",info);
return infos;
}
@Override
public int queryRouteInspectionTasksCount(Map info) {
List<Map> infos = sqlSessionTemplate.selectList("inspectionTaskV1ServiceDaoImpl.queryRouteInspectionTasksCount", info);
if (infos.size() < 1) {
return 0;
}
return Integer.parseInt(infos.get(0).get("count").toString()); }
@Override
public List<Map> queryRouteInspectionTasks(Map info) {
logger.debug("查询 getInspectionTaskInfo 入参 info : {}",info);
List<Map> infos = sqlSessionTemplate.selectList("inspectionTaskV1ServiceDaoImpl.queryRouteInspectionTasks",info);
return infos;
}
}