From cf25cda454a645ea47ce6135184c3df6afd09ddc Mon Sep 17 00:00:00 2001
From: Administrator <zhubaomin>
Date: 星期六, 20 一月 2024 10:40:41 +0800
Subject: [PATCH] 2024-01-20 朱宝民 删除不存在用户提示信息，用户名字段改名，Long型字段转字符串
---
pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java | 101 +++++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 98 insertions(+), 3 deletions(-)
diff --git a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java
index ee1e40d..9c3b551 100644
--- a/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java
+++ b/pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSe/SeClientMapper.java
@@ -1,7 +1,11 @@
package com.dy.pipIrrGlobal.daoSe;
+import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoSe.SeClient;
import com.dy.pipIrrGlobal.voSe.VoClient;
+import com.dy.pipIrrGlobal.voSe.VoOperate;
+import com.dy.pipIrrGlobal.voSe.VoStatistics;
+import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import java.util.List;
@@ -9,11 +13,13 @@
/**
* @author ZhuBaoMin
- * @date 2023/12/22 9:50
- * @LastEditTime 2023/12/22 9:50
+ * @date 2023-12-26 10:32
+ * @LastEditTime 2023-12-26 10:32
* @Description
*/
-public interface SeClientMapper {
+
+@Mapper
+public interface SeClientMapper extends BaseMapper<SeClient> {
int deleteByPrimaryKey(Long id);
int insert(SeClient record);
@@ -34,6 +40,27 @@
String getClientNumOfMax(@Param("district8") String district8);
/**
+ * 鏍规嵁鍐滄埛缂栧彿鑾峰彇5绾ц鏀垮尯鍒掍唬鐮�
+ * @param clientNum 鍐滄埛缂栧彿
+ * @return 5绾ц鏀垮尯鍒掍唬鐮�
+ */
+ Long getAreaCodeByNum(@Param("clientNum") String clientNum);
+
+ /**
+ * 鏍规嵁鍐滄埛缂栧彿鑾峰彇5绾ц鏀垮尯鍒掍覆areaCode锛岃ˉ鍗¤繃绋嬩腑寮�鏂板崱浣跨敤
+ * @param clientId
+ * @return
+ */
+ Long getAreaCodeById(@Param("clientId") Long clientId);
+
+ /**
+ * 鏍规嵁鍐滄埛缂栧彿鑾峰彇鍐滄埛ID
+ * @param clientNum
+ * @return
+ */
+ Long getClientIdByNum(@Param("clientNum") String clientNum);
+
+ /**
* 鏍规嵁鎸囧畾鏉′欢鑾峰彇鍐滄埛璁板綍鏁�
* @param params
* @return
@@ -46,4 +73,72 @@
* @return
*/
List<VoClient> getClients(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鍐滄埛ID閫昏緫鍒犻櫎鍐滄埛
+ * @param id 鍐滄埛ID
+ * @return 閫昏緫鍒犻櫎璁板綍鏁�
+ */
+ Integer deleteClientById(@Param("id") Long id);
+
+ /**
+ * 鏍规嵁涓婚敭鑾峰彇鏉慖D
+ * @param id 鍐滄埛ID
+ * @return 鏉戜富閿�
+ */
+ Long getVillageIdById(@Param("id") Long id);
+
+ /**
+ * 鑾峰彇铏氭嫙鍗″彿鏈�澶у��
+ * @return
+ */
+ Long getMa1xVirtualId();
+
+ /**
+ * 鑾峰彇鐢ㄦ按鏂瑰紡鍒楄〃
+ * @return
+ */
+ List<Map<String, Object>> getWaterTypes();
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇璐按姹囨�诲拰璐崱姹囨��
+ * @param params 缁熻鏉′欢
+ * @return 璐按閲戦銆佽喘鍗￠噾棰�
+ */
+ Map getSums(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鎿嶄綔璁板綍鏁�
+ * @param params 鏌ヨ鏉′欢
+ * @return 绗﹀悎鏉′欢鐨勮褰曟暟
+ */
+ Long getOperateRecordCount(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇鎿嶄綔璁板綍
+ * @param params 鏌ヨ鏉′欢
+ * @return 绗﹀悎鏉′欢鐨勪氦鏄撹褰�
+ */
+ List<VoOperate> getOperates(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇浜ゆ槗绗旀暟姹囨�诲拰浜ゆ槗閲戦姹囨��
+ * @param params
+ * @return
+ */
+ Map getStatisticSums(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇姹囨�昏褰曟暟
+ * @param params
+ * @return
+ */
+ Long getStatisticRecordCount(Map<?, ?> params);
+
+ /**
+ * 鏍规嵁鎸囧畾鏉′欢鑾峰彇缁熻璁板綍
+ * @param params
+ * @return
+ */
+ List<VoStatistics> getStatistics(Map<?, ?> params);
}
\ No newline at end of file
--
Gitblit v1.8.0