diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java index 7a338ad..8b3f7ee 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java @@ -61,7 +61,7 @@ public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) { try { - String sql="select * from PG_CH4 where rownum < 2 order by UPTIME"; + String sql="select * from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCh4List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCh4List.get(0); diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java index 7a338ad..8b3f7ee 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java @@ -61,7 +61,7 @@ public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) { try { - String sql="select * from PG_CH4 where rownum < 2 order by UPTIME"; + String sql="select * from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCh4List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCh4List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java index 28f8704..e67a3cb 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java @@ -58,7 +58,7 @@ //获取设备最新数据 public PgCoDto getNewestCoData(PgDevice pgDevice) { try { - String sql="select * from PG_CO where rownum < 2 order by UPTIME"; + String sql="select * from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCoList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCoList.get(0); diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java index 7a338ad..8b3f7ee 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java @@ -61,7 +61,7 @@ public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) { try { - String sql="select * from PG_CH4 where rownum < 2 order by UPTIME"; + String sql="select * from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCh4List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCh4List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java index 28f8704..e67a3cb 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java @@ -58,7 +58,7 @@ //获取设备最新数据 public PgCoDto getNewestCoData(PgDevice pgDevice) { try { - String sql="select * from PG_CO where rownum < 2 order by UPTIME"; + String sql="select * from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCoList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCoList.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java index 7c6b3de..b4445b2 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java @@ -59,7 +59,7 @@ public PgO2Dto getNewestO2Data(PgDevice pgDevice) { try { - String sql="select * from PG_O2 where rownum < 2 order by UPTIME"; + String sql="select * from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgO2List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgO2List.get(0); diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java index 7a338ad..8b3f7ee 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java @@ -61,7 +61,7 @@ public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) { try { - String sql="select * from PG_CH4 where rownum < 2 order by UPTIME"; + String sql="select * from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCh4List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCh4List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java index 28f8704..e67a3cb 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java @@ -58,7 +58,7 @@ //获取设备最新数据 public PgCoDto getNewestCoData(PgDevice pgDevice) { try { - String sql="select * from PG_CO where rownum < 2 order by UPTIME"; + String sql="select * from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCoList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCoList.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java index 7c6b3de..b4445b2 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java @@ -59,7 +59,7 @@ public PgO2Dto getNewestO2Data(PgDevice pgDevice) { try { - String sql="select * from PG_O2 where rownum < 2 order by UPTIME"; + String sql="select * from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgO2List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgO2List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java index 478d8d2..7b3d114 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java @@ -58,7 +58,7 @@ public PgShDto getNewestShData(PgDevice pgDevice) { try { - String sql="select * from PG_Sh where rownum < 2 order by UPTIME"; + String sql="select * from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgShList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgShList.get(0); diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java index 7a338ad..8b3f7ee 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java @@ -61,7 +61,7 @@ public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) { try { - String sql="select * from PG_CH4 where rownum < 2 order by UPTIME"; + String sql="select * from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCh4List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCh4List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java index 28f8704..e67a3cb 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java @@ -58,7 +58,7 @@ //获取设备最新数据 public PgCoDto getNewestCoData(PgDevice pgDevice) { try { - String sql="select * from PG_CO where rownum < 2 order by UPTIME"; + String sql="select * from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCoList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCoList.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java index 7c6b3de..b4445b2 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java @@ -59,7 +59,7 @@ public PgO2Dto getNewestO2Data(PgDevice pgDevice) { try { - String sql="select * from PG_O2 where rownum < 2 order by UPTIME"; + String sql="select * from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgO2List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgO2List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java index 478d8d2..7b3d114 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java @@ -58,7 +58,7 @@ public PgShDto getNewestShData(PgDevice pgDevice) { try { - String sql="select * from PG_Sh where rownum < 2 order by UPTIME"; + String sql="select * from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgShList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgShList.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java index 585db00..1cbc193 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java @@ -60,7 +60,7 @@ public PgTempHumDto getNewestTempHumData(PgDevice pgDevice) { try { - String sql="select * from PG_TEMPHUM where rownum < 2 order by UPTIME"; + String sql="select * from PG_TEMPHUM where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgTempHumList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgTempHumList.get(0); diff --git a/.idea/workspace.xml b/.idea/workspace.xml index ec01dab..a8b1f90 100644 --- a/.idea/workspace.xml +++ b/.idea/workspace.xml @@ -2,13 +2,11 @@ - - @@ -35,12 +33,69 @@ - - + + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + @@ -108,11 +163,11 @@ @@ -489,44 +544,6 @@ - @@ -1289,7 +1310,7 @@ - + @@ -1317,7 +1338,6 @@ - @@ -1342,7 +1362,8 @@ - @@ -1354,70 +1375,6 @@ - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - @@ -1703,23 +1660,6 @@ - - - - - - - - - - - - - - - - - @@ -1736,16 +1676,6 @@ - - - - - - - - - - @@ -1754,16 +1684,6 @@ - - - - - - - - - - @@ -1772,42 +1692,156 @@ - + - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - + + + - + - - + + - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + - - + + - + + + - + - - - + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + + diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java index 7a338ad..8b3f7ee 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java @@ -61,7 +61,7 @@ public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) { try { - String sql="select * from PG_CH4 where rownum < 2 order by UPTIME"; + String sql="select * from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCh4List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCh4List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java index 28f8704..e67a3cb 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java @@ -58,7 +58,7 @@ //获取设备最新数据 public PgCoDto getNewestCoData(PgDevice pgDevice) { try { - String sql="select * from PG_CO where rownum < 2 order by UPTIME"; + String sql="select * from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgCoList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgCoList.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java index 7c6b3de..b4445b2 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java @@ -59,7 +59,7 @@ public PgO2Dto getNewestO2Data(PgDevice pgDevice) { try { - String sql="select * from PG_O2 where rownum < 2 order by UPTIME"; + String sql="select * from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgO2List=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgO2List.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java index 478d8d2..7b3d114 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java @@ -58,7 +58,7 @@ public PgShDto getNewestShData(PgDevice pgDevice) { try { - String sql="select * from PG_Sh where rownum < 2 order by UPTIME"; + String sql="select * from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgShList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgShList.get(0); diff --git a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java index 585db00..1cbc193 100644 --- a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java +++ b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java @@ -60,7 +60,7 @@ public PgTempHumDto getNewestTempHumData(PgDevice pgDevice) { try { - String sql="select * from PG_TEMPHUM where rownum < 2 order by UPTIME"; + String sql="select * from PG_TEMPHUM where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME"; List pgTempHumList=(List)this.getSession().createSQLQuery(sql).list(); Object[] objects = pgTempHumList.get(0); diff --git "a/\346\216\245\345\217\243\350\257\264\346\230\216\346\226\260\351\234\200\346\261\202.docx" "b/\346\216\245\345\217\243\350\257\264\346\230\216\346\226\260\351\234\200\346\261\202.docx" index 4da8803..b66385b 100644 --- "a/\346\216\245\345\217\243\350\257\264\346\230\216\346\226\260\351\234\200\346\261\202.docx" +++ "b/\346\216\245\345\217\243\350\257\264\346\230\216\346\226\260\351\234\200\346\261\202.docx" Binary files differ