From 11a814e836495cb0de25eaa670c75338d85e5e42 Mon Sep 17 00:00:00 2001
From: DELL <1525436766@qq.com>
Date: 星期四, 13 三月 2025 21:07:01 +0800
Subject: [PATCH] V1.111 edit by lijun 2025-03-13 1.新增锁具工作模式读取 2.新增根据平台锁具模式设置当前所有锁具的模式
---
ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java | 33 +++++++++++++++++++++++++++++++++
1 files changed, 33 insertions(+), 0 deletions(-)
diff --git a/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java b/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java
index 60a357a..d19961c 100644
--- a/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java
+++ b/ElectLock_Monitor/src/com/dev/lock/comm/Lock_Task_SQL.java
@@ -89,6 +89,7 @@
" ,lock_online = " + state.getLock_online() +
" ,lock_mac = '" + state.getLockMacAddr() + "'" +
" ,lock_open_count = " + state.getLock_open_count() +
+ " ,model = " + state.getWorkmodel() +
" ,last_update_time = '" + Com.getDateTimeFormat(state.getLast_update_time(), Com.DTF_YMDhms) + "'" +
" WHERE lock_id = " + inf.getLock_id();
Sql_Mysql sql = new Sql_Mysql(pool.getConn());
@@ -399,6 +400,38 @@
}
+
+ /**
+ * 褰撳钩鍙伴攣鍏锋ā寮忔湭閰嶇疆鏃惰繑鍥�-1
+ * 杩斿洖0-绂荤嚎妯″紡 1-鍦ㄧ嚎妯″紡
+ * @param pool
+ * @return
+ */
+ public static int querySystemLockMode(MysqlConnPool pool) {
+ int sys_model = -1;
+ String sql_str_sel = "SELECT plate_model FROM " + Sql_Mysql.Plate_Info_Table;
+ Sql_Mysql sql = new Sql_Mysql(pool.getConn());
+ ResultSet res = null;
+ try {
+ res = sql.sqlMysqlQuery(sql_str_sel);
+ if(res.next()) {
+ sys_model = res.getInt("plate_model");
+ }
+ } catch (SQLException e) {
+ sql.logger.error(e.toString(),e);
+ } finally {
+ if(null != res) {
+ try {
+ res.close();
+ } catch (SQLException e) {
+ sql.logger.error(e.toString(),e);
+ }
+ }
+ sql.close_con();
+ }
+ return sys_model;
+ }
+
/**
* 鎻掑叆杩滅▼寮�閿佸け璐ヨ褰�
*/
--
Gitblit v1.9.1