From 6ff51cb81fe0e48db554f5f7ebde0d167650cef3 Mon Sep 17 00:00:00 2001
From: wuxw <928255095@qq.com>
Date: 星期四, 14 十一月 2019 20:05:55 +0800
Subject: [PATCH] 优化业主查询
---
UserService/src/main/java/com/java110/user/dao/IOwnerServiceDao.java | 52 +++++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 51 insertions(+), 1 deletions(-)
diff --git a/UserService/src/main/java/com/java110/user/dao/IOwnerServiceDao.java b/UserService/src/main/java/com/java110/user/dao/IOwnerServiceDao.java
index db680d4..7c0663d 100644
--- a/UserService/src/main/java/com/java110/user/dao/IOwnerServiceDao.java
+++ b/UserService/src/main/java/com/java110/user/dao/IOwnerServiceDao.java
@@ -1,7 +1,7 @@
package com.java110.user.dao;
-import com.java110.common.exception.DAOException;
+import com.java110.utils.exception.DAOException;
import java.util.List;
import java.util.Map;
@@ -55,6 +55,15 @@
*/
List<Map> getOwnerInfo(Map info) throws DAOException;
+ /**
+ * 鏌ヨ涓氫富淇℃伅锛坕nstance杩囩▼锛�
+ * 鏍规嵁bId 鏌ヨ涓氫富淇℃伅
+ * @param info bId 淇℃伅
+ * @return 涓氫富淇℃伅
+ * @throws DAOException DAO寮傚父
+ */
+ int getOwnerInfoCount(Map info) throws DAOException;
+
/**
@@ -73,4 +82,45 @@
*/
int queryOwnersCount(Map info);
+
+ /**
+ * 鏌ヨ涓氫富鎬绘暟
+ *
+ * @param info 涓氫富淇℃伅
+ * @return 涓氫富鏁伴噺
+ */
+ int queryOwnersCountByCondition(Map info);
+
+ /**
+ * 鏌ヨ涓氫富淇℃伅锛坕nstance锛�
+ *
+ * @param info bId 淇℃伅
+ * @return List<Map>
+ * @throws DAOException DAO寮傚父
+ */
+ List<Map> getOwnerInfoByCondition(Map info) throws DAOException;
+
+ /**
+ * 鏌ヨ娌℃湁鍏ラ┗鐨� 涓氫富鏁伴噺
+ * @param info 淇℃伅
+ * @return 鏈叆椹讳笟涓绘暟閲�
+ */
+ int queryNoEnterRoomOwnerCount(Map info);
+
+ /**
+ * 鏍规嵁鎴垮眿鏌ヨ涓氫富淇℃伅
+ * @param info 鎴垮眿淇℃伅
+ * @return 涓氫富淇℃伅
+ * @throws DAOException 寮傚父淇℃伅
+ */
+ List<Map> queryOwnersByRoom(Map info) throws DAOException;
+
+ /**
+ * 鏍规嵁鍋滆溅浣嶆煡璇笟涓讳俊鎭�
+ * @param info 鏌ヨ鏉′欢
+ * @return 涓氫富淇℃伅
+ * @throws DAOException 寮傚父淇℃伅
+ */
+ List<Map> queryOwnersByParkingSpace(Map info) throws DAOException;
+
}
--
Gitblit v1.8.0