| | |
|---|
| | | public List<BatttestdataId> getTdataById(Integer devId, Integer testRecordCount) { |
|---|
| | | String sql="select * from db_batt_testdata.tb_batttestdata_" +devId |
|---|
| | | +" where need_test=1 and test_record_count="+testRecordCount+" "; |
|---|
| | | sql+=" ORDER BY test_starttime asc "; |
|---|
| | | sql+=" ORDER BY record_num asc "; |
|---|
| | | System.out.println(sql); |
|---|
| | | List list = sqlExecuteService.executeQuery_call(sql, new CallBack() { |
|---|
| | | @Override |
|---|
| | |
|---|
| | | 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.setMonState(rs.getString("mon_state")); |
|---|
| | | tdata.setMonFault(rs.getString("mon_fault")); |
|---|
| | | tdata.setNeedTest(rs.getInt("need_test")); |
|---|
| | | list.add(tdata); |
|---|
