From b09e1a8b036553d1e161d127aa738a504593490a Mon Sep 17 00:00:00 2001
From: mrzcc <121184950@qq.com>
Date: 星期三, 19 二月 2020 12:14:55 +0800
Subject: [PATCH] 优化巡检路线查询sql
---
CommunityService/src/main/java/com/java110/community/dao/IUnitServiceDao.java | 41 +++++++++++++++++++++++++++++++++++------
1 files changed, 35 insertions(+), 6 deletions(-)
diff --git a/CommunityService/src/main/java/com/java110/community/dao/IUnitServiceDao.java b/CommunityService/src/main/java/com/java110/community/dao/IUnitServiceDao.java
index c0b6d37..cd8745e 100644
--- a/CommunityService/src/main/java/com/java110/community/dao/IUnitServiceDao.java
+++ b/CommunityService/src/main/java/com/java110/community/dao/IUnitServiceDao.java
@@ -1,7 +1,7 @@
package com.java110.community.dao;
-import com.java110.common.exception.DAOException;
+import com.java110.utils.exception.DAOException;
import java.util.List;
import java.util.Map;
@@ -21,7 +21,7 @@
* @param businessUnitInfo 灏忓尯鍗曞厓淇℃伅 灏佽
* @throws DAOException 鎿嶄綔鏁版嵁搴撳紓甯�
*/
- void saveBusinessUnitInfo(Map businessUnitInfo) throws DAOException;
+ public void saveBusinessUnitInfo(Map businessUnitInfo) throws DAOException;
/**
@@ -32,7 +32,7 @@
* @return 灏忓尯鍗曞厓淇℃伅
* @throws DAOException
*/
- List<Map> getBusinessUnitInfo(Map info) throws DAOException;
+ public List<Map> getBusinessUnitInfo(Map info) throws DAOException;
/**
@@ -41,7 +41,7 @@
* @param info
* @throws DAOException
*/
- void saveUnitInfoInstance(Map info) throws DAOException;
+ public void saveUnitInfoInstance(Map info) throws DAOException;
/**
@@ -52,7 +52,7 @@
* @return 灏忓尯鍗曞厓淇℃伅
* @throws DAOException
*/
- List<Map> getUnitInfo(Map info) throws DAOException;
+ public List<Map> getUnitInfo(Map info) throws DAOException;
/**
@@ -61,6 +61,35 @@
* @param info 淇敼淇℃伅
* @throws DAOException
*/
- void updateUnitInfoInstance(Map info) throws DAOException;
+ public void updateUnitInfoInstance(Map info) throws DAOException;
+
+
+ /**
+ * 鏌ヨ灏忓尯鍗曞厓鎬绘暟
+ *
+ * @param info 灏忓尯鍗曞厓淇℃伅
+ * @return 灏忓尯鍗曞厓鏁伴噺
+ */
+ int queryUnitsCount(Map info);
+
+
+ /**
+ * 鏍规嵁灏忓尯ID鏌ヨ鍗曞厓淇℃伅
+ *
+ * @param info 灏忓尯鍗曞厓淇℃伅
+ * @return 灏忓尯鍗曞厓
+ */
+ List<Map> queryUnitsByCommunityId(Map info);
+
+
+ /**
+ * 鏌ヨ灏忓尯鍗曞厓淇℃伅锛坕nstance杩囩▼锛�
+ * 鏍规嵁bId 鏌ヨ灏忓尯鍗曞厓淇℃伅
+ *
+ * @param info bId 淇℃伅
+ * @return 灏忓尯鍗曞厓淇℃伅
+ * @throws DAOException
+ */
+ public List<Map> getFloorAndUnitInfo(Map info) throws DAOException;
}
--
Gitblit v1.8.0