From 264536ddf21ec750a6c9914daba8c17969b6c592 Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期一, 09 九月 2024 11:31:41 +0800
Subject: [PATCH] 获取设备某次记录详细的单体放电过程
---
src/main/java/com/whyc/service/SubTablePageInfoService.java | 42 ++++++++++++++++++++++++++++++++++++++++++
1 files changed, 42 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SubTablePageInfoService.java b/src/main/java/com/whyc/service/SubTablePageInfoService.java
index 7949239..eba0704 100644
--- a/src/main/java/com/whyc/service/SubTablePageInfoService.java
+++ b/src/main/java/com/whyc/service/SubTablePageInfoService.java
@@ -1,6 +1,7 @@
package com.whyc.service;
import com.whyc.mapper.CallBack;
+import com.whyc.pojo.db_batt_testdata.BatttestdataId;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
@@ -14,6 +15,47 @@
public class SubTablePageInfoService {
@Autowired
private MybatisSqlExecuteService sqlExecuteService;
+ //鑾峰彇璁惧鏌愭璁板綍璇︾粏鐨勫崟浣撴斁鐢佃繃绋�
+ public List<BatttestdataId> getTinfById(Integer devId, Integer testRecordCount, Integer record_num) {
+ String sql="select * from db_batt_testdata.tb_batttestdata_" +devId
+ +" where test_record_count="+testRecordCount+" and record_num="+record_num;
+ sql+=" ORDER BY test_starttime asc ";
+ System.out.println(sql);
+ List list = sqlExecuteService.executeQuery_call(sql, new CallBack() {
+ @Override
+ public List getResults(ResultSet rs) throws SQLException {
+ List<BatttestdataId> list=new ArrayList<>();
+ while (rs.next()){
+ BatttestdataId tdata=new BatttestdataId();
+ tdata.setNum(rs.getInt("num"));
+ tdata.setDevId(rs.getInt("dev_id"));
+ tdata.setBattIdx(rs.getInt("batt_idx"));
+ tdata.setTestRecordCount(rs.getInt("test_record_count"));
+ tdata.setTestType(rs.getInt("test_type"));
+ tdata.setRecordNum(rs.getInt("record_num"));
+ tdata.setTestStarttime(rs.getTimestamp("test_starttime"));
+ tdata.setRecordTime(rs.getTimestamp("record_time"));
+ tdata.setTestTimelong(rs.getInt("test_timelong"));
+ tdata.setGroupVol(rs.getDouble("group_vol"));
+ tdata.setTestCurr(rs.getDouble("test_curr"));
+ tdata.setTestCap(rs.getDouble("test_cap"));
+ tdata.setMonNum(rs.getInt("mon_num"));
+ tdata.setMonVol(rs.getDouble("mon_vol"));
+ tdata.setMonTmp(rs.getDouble("mon_tmp"));
+ tdata.setMonCurr(rs.getDouble("mon_curr"));
+ tdata.setMonCap(rs.getDouble("mon_cap"));
+ tdata.setMonWh(rs.getDouble("mon_wh"));
+ tdata.setMonState(rs.getInt("mon_state"));
+ tdata.setMonFault(rs.getInt("mon_fault"));
+ list.add(tdata);
+ }
+ return list;
+ }
+ });
+ return list;
+ }
+
+
/*//鏌ヨDevAlm鍘嗗彶鍛婅鏁伴噺
public int getCountForDevAlm(DevAlarmHisDto alm) {
String sql="select count(distinct num) as number from db_ckpwrdev_alarm." +alm.getRecordYear()
--
Gitblit v1.9.1