From 2f432f52c1cfb1567dadcf6e040c5d38b0a26a79 Mon Sep 17 00:00:00 2001
From: czt <czt18638530771@163.com>
Date: 星期五, 28 十一月 2025 17:31:49 +0800
Subject: [PATCH] 数量检测配置页面
---
fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DeviceSerRepository.java | 73 ++++++++++++++++++++++++++++++++++++
1 files changed, 73 insertions(+), 0 deletions(-)
diff --git a/fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DeviceSerRepository.java b/fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DeviceSerRepository.java
new file mode 100644
index 0000000..68d6e8d
--- /dev/null
+++ b/fzzy-igdss-core/src/main/java/com/fzzy/igds/repository/DeviceSerRepository.java
@@ -0,0 +1,73 @@
+package com.fzzy.igds.repository;
+
+import com.fzzy.igds.domain.DeviceSer;
+import org.springframework.data.jpa.repository.JpaRepository;
+import org.springframework.data.jpa.repository.Modifying;
+import org.springframework.data.jpa.repository.Query;
+import org.springframework.data.repository.query.Param;
+import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
+
+import java.util.Date;
+import java.util.List;
+
+/**
+ * @Description
+ * @Author CZT
+ * @Date 2025/11/28 13:48
+ */
+@Service
+public interface DeviceSerRepository extends JpaRepository<DeviceSer, String> {
+
+ /**
+ * 鏍规嵁缁勭粐缂栫爜鑾峰彇浠撳簱璐т綅淇℃伅
+ *
+ * @param companyId
+ * @return
+ */
+ @Query("from DeviceSer where companyId =:companyId order by orderNum")
+ List<DeviceSer> getDataByDeptId(@Param("companyId") String companyId);
+
+
+ /**
+ * 鑾峰彇涓嬪睘鍒嗘満淇℃伅
+ *
+ * @param parentId
+ * @return
+ */
+ @Query("from DeviceSer where deptId like:parentId order by orderNum")
+ List<DeviceSer> getDataByParentId(@Param("parentId") String parentId);
+
+
+ /**
+ * 鏍规嵁缁勭粐缂栫爜鑾峰彇浠撳簱璐т綅淇℃伅
+ *
+ * @param companyId
+ * @return
+ */
+ @Query("from DeviceSer where companyId =:companyId and id =:id order by orderNum")
+ DeviceSer getDataById(@Param("companyId") String companyId, @Param("id") String id);
+
+ /**
+ * 鏇存柊鍒嗘満鐘舵��
+ * @param companyId
+ * @param status
+ */
+ @Transactional
+ @Modifying
+ @Query("update DeviceSer set status =:status where companyId =:companyId")
+ void updateSerStatus(@Param("companyId") String companyId, @Param("status") String status);
+
+ /**
+ * 鏍规嵁SN鏇存柊鐘舵��
+ * @param ip
+ * @param port
+ * @param status
+ * @param sn
+ * @param updateTime
+ */
+ @Transactional
+ @Modifying
+ @Query("update DeviceSer set status =:status,ip =:ip,port =:port,updateTime =:updateTime where sn =:sn")
+ void updateBySn(@Param("ip") String ip, @Param("port") Integer port,@Param("status") String status,@Param("sn") String sn,@Param("updateTime") Date updateTime);
+}
--
Gitblit v1.9.3