diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgCh4List=(List)this.getSession().createSQLQuery(sql).list();
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 aa5662a..1da3e93 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
@@ -46,7 +46,8 @@
//获取设备最新数据
public PgCoDto getNewestCoData(PgDevice pgDevice) {
try {
- String sql="select id,CO,LOGTIME,UPTIME from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr= "( select * from PG_CO where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,CO,LOGTIME,UPTIME from "+sqlStr+" where rownum =1";
List pgCoList=(List)this.getSession().createSQLQuery(sql).list();
if(pgCoList.size()==0) return null;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgCh4List=(List)this.getSession().createSQLQuery(sql).list();
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 aa5662a..1da3e93 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
@@ -46,7 +46,8 @@
//获取设备最新数据
public PgCoDto getNewestCoData(PgDevice pgDevice) {
try {
- String sql="select id,CO,LOGTIME,UPTIME from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr= "( select * from PG_CO where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,CO,LOGTIME,UPTIME from "+sqlStr+" where rownum =1";
List pgCoList=(List)this.getSession().createSQLQuery(sql).list();
if(pgCoList.size()==0) return null;
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 0eab502..e9be355 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
@@ -48,7 +48,8 @@
public PgO2Dto getNewestO2Data(PgDevice pgDevice) {
try {
- String sql="select id,O2,LOGTIME,UPTIME from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_O2 where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc)";
+ String sql="select id,O2,LOGTIME,UPTIME from "+sqlStr+ " where rownum = 1";
List pgO2List=(List)this.getSession().createSQLQuery(sql).list();
if(pgO2List.size()==0) return null;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgCh4List=(List)this.getSession().createSQLQuery(sql).list();
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 aa5662a..1da3e93 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
@@ -46,7 +46,8 @@
//获取设备最新数据
public PgCoDto getNewestCoData(PgDevice pgDevice) {
try {
- String sql="select id,CO,LOGTIME,UPTIME from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr= "( select * from PG_CO where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,CO,LOGTIME,UPTIME from "+sqlStr+" where rownum =1";
List pgCoList=(List)this.getSession().createSQLQuery(sql).list();
if(pgCoList.size()==0) return null;
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 0eab502..e9be355 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
@@ -48,7 +48,8 @@
public PgO2Dto getNewestO2Data(PgDevice pgDevice) {
try {
- String sql="select id,O2,LOGTIME,UPTIME from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_O2 where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc)";
+ String sql="select id,O2,LOGTIME,UPTIME from "+sqlStr+ " where rownum = 1";
List pgO2List=(List)this.getSession().createSQLQuery(sql).list();
if(pgO2List.size()==0) return null;
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 5cab7b6..880adbb 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
@@ -48,7 +48,8 @@
public PgShDto getNewestShData(PgDevice pgDevice) {
try {
- String sql="select id,SH,LOGTIME,UPTIME from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_SH t where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,SH,LOGTIME,UPTIME from " + sqlStr + " where rownum = 1";
List pgShList=(List)this.getSession().createSQLQuery(sql).list();
if(pgShList.size()==0) return null;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgCh4List=(List)this.getSession().createSQLQuery(sql).list();
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 aa5662a..1da3e93 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
@@ -46,7 +46,8 @@
//获取设备最新数据
public PgCoDto getNewestCoData(PgDevice pgDevice) {
try {
- String sql="select id,CO,LOGTIME,UPTIME from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr= "( select * from PG_CO where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,CO,LOGTIME,UPTIME from "+sqlStr+" where rownum =1";
List pgCoList=(List)this.getSession().createSQLQuery(sql).list();
if(pgCoList.size()==0) return null;
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 0eab502..e9be355 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
@@ -48,7 +48,8 @@
public PgO2Dto getNewestO2Data(PgDevice pgDevice) {
try {
- String sql="select id,O2,LOGTIME,UPTIME from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_O2 where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc)";
+ String sql="select id,O2,LOGTIME,UPTIME from "+sqlStr+ " where rownum = 1";
List pgO2List=(List)this.getSession().createSQLQuery(sql).list();
if(pgO2List.size()==0) return null;
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 5cab7b6..880adbb 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
@@ -48,7 +48,8 @@
public PgShDto getNewestShData(PgDevice pgDevice) {
try {
- String sql="select id,SH,LOGTIME,UPTIME from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_SH t where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,SH,LOGTIME,UPTIME from " + sqlStr + " where rownum = 1";
List pgShList=(List)this.getSession().createSQLQuery(sql).list();
if(pgShList.size()==0) return null;
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 314f417..1a025f4 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java
@@ -50,7 +50,8 @@
public PgTempHumDto getNewestTempHumData(PgDevice pgDevice) {
try {
- String sql="select id,TEMP,HUM,LOGTIME,UPTIME from PG_TEMPHUM where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_TEMPHUM where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,TEMP,HUM,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgTempHumList=(List)this.getSession().createSQLQuery(sql).list();
if(pgTempHumList.size()==0) return null;
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgCh4List=(List)this.getSession().createSQLQuery(sql).list();
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 aa5662a..1da3e93 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
@@ -46,7 +46,8 @@
//获取设备最新数据
public PgCoDto getNewestCoData(PgDevice pgDevice) {
try {
- String sql="select id,CO,LOGTIME,UPTIME from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr= "( select * from PG_CO where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,CO,LOGTIME,UPTIME from "+sqlStr+" where rownum =1";
List pgCoList=(List)this.getSession().createSQLQuery(sql).list();
if(pgCoList.size()==0) return null;
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 0eab502..e9be355 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
@@ -48,7 +48,8 @@
public PgO2Dto getNewestO2Data(PgDevice pgDevice) {
try {
- String sql="select id,O2,LOGTIME,UPTIME from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_O2 where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc)";
+ String sql="select id,O2,LOGTIME,UPTIME from "+sqlStr+ " where rownum = 1";
List pgO2List=(List)this.getSession().createSQLQuery(sql).list();
if(pgO2List.size()==0) return null;
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 5cab7b6..880adbb 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
@@ -48,7 +48,8 @@
public PgShDto getNewestShData(PgDevice pgDevice) {
try {
- String sql="select id,SH,LOGTIME,UPTIME from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_SH t where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,SH,LOGTIME,UPTIME from " + sqlStr + " where rownum = 1";
List pgShList=(List)this.getSession().createSQLQuery(sql).list();
if(pgShList.size()==0) return null;
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 314f417..1a025f4 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java
@@ -50,7 +50,8 @@
public PgTempHumDto getNewestTempHumData(PgDevice pgDevice) {
try {
- String sql="select id,TEMP,HUM,LOGTIME,UPTIME from PG_TEMPHUM where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_TEMPHUM where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,TEMP,HUM,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgTempHumList=(List)this.getSession().createSQLQuery(sql).list();
if(pgTempHumList.size()==0) return null;
diff --git a/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java b/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java
index 3c6f5cc..9c26d9c 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java
@@ -123,15 +123,27 @@
pgAssetPlanDto.setId(pgAssetPlan.getId());
pgAssetPlanDto.setPLAN_NO(pgAssetPlan.getPLAN_NO());
pgAssetPlanDto.setPLAN_NAME(pgAssetPlan.getPLAN_NAME());
- pgAssetPlanDto.setINSPECTION_TYPE(pgAssetPlan.getINSPECTION_TYPE());
- pgAssetPlanDto.setINSPECTION_START_TIME(pgAssetPlan.getINSPECTION_START_TIME());
- pgAssetPlanDto.setINSPECTION_END_TIME(pgAssetPlan.getINSPECTION_END_TIME());
+
+ if(pgAssetPlan.getINSPECTION_TYPE().equals(""))
+ pgAssetPlanDto.setINSPECTION_TYPE("");
+ else if(pgAssetPlan.getINSPECTION_TYPE().equals("1"))
+ pgAssetPlanDto.setINSPECTION_TYPE("廊内巡检");
+ else if(pgAssetPlan.getINSPECTION_TYPE().equals("2"))
+ pgAssetPlanDto.setINSPECTION_TYPE("廊外巡检");
+
+ pgAssetPlanDto.setINSPECTION_START_TIME(pgAssetPlan.getSTART_DATE());
+ pgAssetPlanDto.setINSPECTION_END_TIME(pgAssetPlan.getEND_DATE());
pgAssetPlanDto.setINSPECTION_PRACE(pgAssetPlan.getINSPECTION_PRACE());
pgAssetPlanDto.setFREQUENCY(pgAssetPlan.getFREQUENCY());
pgAssetPlanDto.setCREATOR(pgAssetPlan.getCREATOR());
pgAssetPlanDto.setDEVELOP_DEPT(pgAssetPlan.getDEVELOP_DEPT());
pgAssetPlanDto.setPROJECT(pgAssetPlan.getPROJECT());
- pgAssetPlanDto.setSTATE(pgAssetPlan.getSTATE().equals("0")?"执行结束":"执行中");
+ if(pgAssetPlan.getSTATE().equals("0"))
+ pgAssetPlanDto.setSTATE("待执行");
+ else if(pgAssetPlan.getSTATE().equals("1"))
+ pgAssetPlanDto.setSTATE("执行中");
+ else if(pgAssetPlan.getSTATE().equals("2"))
+ pgAssetPlanDto.setSTATE("执行结束");
return pgAssetPlanDto;
}
diff --git a/.idea/workspace.xml b/.idea/workspace.xml
index 566613a..8c23384 100644
--- a/.idea/workspace.xml
+++ b/.idea/workspace.xml
@@ -7,16 +7,14 @@
-
-
-
+
+
+
+
+
+
-
-
-
-
-
@@ -46,7 +44,7 @@
-
+
@@ -55,7 +53,7 @@
-
+
@@ -63,7 +61,7 @@
-
+
@@ -71,7 +69,7 @@
-
+
@@ -79,11 +77,13 @@
-
+
+
+
@@ -97,27 +97,74 @@
-
+
+
-
-
-
+
+
+
-
+
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -145,11 +192,6 @@
-
-
-
-
-
@@ -186,7 +228,6 @@
-
@@ -195,7 +236,13 @@
+
+
+
+
+
+
@@ -231,17 +278,16 @@
-
-
-
-
+
+
+
+
-
@@ -276,10 +322,30 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
@@ -439,7 +505,14 @@
-
+
+
+
+
+
+
+
+
1564361618083
@@ -518,11 +591,18 @@
1568086635507
-
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
-
+
@@ -535,8 +615,9 @@
+
-
+
@@ -547,7 +628,7 @@
-
+
@@ -558,7 +639,7 @@
-
+
@@ -656,48 +737,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -712,13 +751,6 @@
-
-
-
-
-
-
-
@@ -782,20 +814,6 @@
-
-
-
-
-
-
-
-
-
-
-
-
-
-
@@ -930,13 +948,6 @@
-
-
-
-
-
-
-
@@ -951,31 +962,110 @@
-
+
-
-
+
+
-
+
-
-
+
+
+
+
+
+
+
+
+
-
-
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
-
+
+
+
+
+
+
+
+
diff --git a/.idea/workspace.xml___jb_tmp___ b/.idea/workspace.xml___jb_tmp___
new file mode 100644
index 0000000..8b77bb2
--- /dev/null
+++ b/.idea/workspace.xml___jb_tmp___
@@ -0,0 +1,1094 @@
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ getMonthAlarmNum
+ getAlarmList
+ compositeFilter
+ alarmTypeId
+ getPipeGalleryByPgName
+ getPgDeviceByDevType
+ message
+ getConstructionByType
+ getPgCameraListByPosition
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ true
+ DEFINITION_ORDER
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1559274313127
+
+
+ 1559274313127
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1564361618083
+
+
+
+ 1564361618083
+
+
+ 1566216937991
+
+
+
+ 1566216937991
+
+
+ 1566349743252
+
+
+
+ 1566349743252
+
+
+ 1566382083034
+
+
+
+ 1566382083035
+
+
+ 1566553388171
+
+
+
+ 1566553388171
+
+
+ 1566620046627
+
+
+
+ 1566620046627
+
+
+ 1566781001910
+
+
+
+ 1566781001910
+
+
+ 1566963831930
+
+
+
+ 1566963831930
+
+
+ 1566972146710
+
+
+
+ 1566972146710
+
+
+ 1567126525554
+
+
+
+ 1567126525554
+
+
+ 1568086635507
+
+
+
+ 1568086635507
+
+
+ 1568768749481
+
+
+
+ 1568768749481
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ file://$PROJECT_DIR$/src/main/java/com/casic/PgInterface/overtimeInPG/web/PGInOutRecController.java
+ 40
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ PgInterface
+
+
+
+
+
+
+
+
+
+
+
+
+ Spring
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+
+ 1.8
+
+
+
+
+
+
+
+
+
+
+
+ Web|PgInterface
+
+
+
+
+
+
+
+
+
+
+
+ Maven: antlr:antlr:2.7.7
+
+
+
+
+
+
+
+
+
+
+
+
\ No newline at end of file
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 8404d85..d7e9606 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCh4Manager.java
@@ -48,7 +48,8 @@
public PgCh4Dto getNewestCH4Data(PgDevice pgDevice) {
try {
- String sql="select id,CH4,LOGTIME,UPTIME from PG_CH4 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_CH4 where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,CH4,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgCh4List=(List)this.getSession().createSQLQuery(sql).list();
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 aa5662a..1da3e93 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgCoManager.java
@@ -46,7 +46,8 @@
//获取设备最新数据
public PgCoDto getNewestCoData(PgDevice pgDevice) {
try {
- String sql="select id,CO,LOGTIME,UPTIME from PG_CO where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr= "( select * from PG_CO where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,CO,LOGTIME,UPTIME from "+sqlStr+" where rownum =1";
List pgCoList=(List)this.getSession().createSQLQuery(sql).list();
if(pgCoList.size()==0) return null;
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 0eab502..e9be355 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgO2Manager.java
@@ -48,7 +48,8 @@
public PgO2Dto getNewestO2Data(PgDevice pgDevice) {
try {
- String sql="select id,O2,LOGTIME,UPTIME from PG_O2 where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_O2 where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc)";
+ String sql="select id,O2,LOGTIME,UPTIME from "+sqlStr+ " where rownum = 1";
List pgO2List=(List)this.getSession().createSQLQuery(sql).list();
if(pgO2List.size()==0) return null;
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 5cab7b6..880adbb 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgShManager.java
@@ -48,7 +48,8 @@
public PgShDto getNewestShData(PgDevice pgDevice) {
try {
- String sql="select id,SH,LOGTIME,UPTIME from PG_Sh where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr="( select * from PG_SH t where PGDEVICEID = "+pgDevice.getId()+" order by UPTIME desc )";
+ String sql="select id,SH,LOGTIME,UPTIME from " + sqlStr + " where rownum = 1";
List pgShList=(List)this.getSession().createSQLQuery(sql).list();
if(pgShList.size()==0) return null;
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 314f417..1a025f4 100644
--- a/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java
+++ b/src/main/java/com/casic/PgInterface/devData/manager/PgTempHumManager.java
@@ -50,7 +50,8 @@
public PgTempHumDto getNewestTempHumData(PgDevice pgDevice) {
try {
- String sql="select id,TEMP,HUM,LOGTIME,UPTIME from PG_TEMPHUM where PGDEVICEID = '"+pgDevice.getId()+"' AND rownum < 2 order by UPTIME";
+ String sqlStr = "( select * from PG_TEMPHUM where PGDEVICEID = "+pgDevice.getId()+" order by uptime desc )";
+ String sql="select id,TEMP,HUM,LOGTIME,UPTIME from "+sqlStr+" where rownum = 1";
List pgTempHumList=(List)this.getSession().createSQLQuery(sql).list();
if(pgTempHumList.size()==0) return null;
diff --git a/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java b/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java
index 3c6f5cc..9c26d9c 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/dto/PgAssetPlanDto.java
@@ -123,15 +123,27 @@
pgAssetPlanDto.setId(pgAssetPlan.getId());
pgAssetPlanDto.setPLAN_NO(pgAssetPlan.getPLAN_NO());
pgAssetPlanDto.setPLAN_NAME(pgAssetPlan.getPLAN_NAME());
- pgAssetPlanDto.setINSPECTION_TYPE(pgAssetPlan.getINSPECTION_TYPE());
- pgAssetPlanDto.setINSPECTION_START_TIME(pgAssetPlan.getINSPECTION_START_TIME());
- pgAssetPlanDto.setINSPECTION_END_TIME(pgAssetPlan.getINSPECTION_END_TIME());
+
+ if(pgAssetPlan.getINSPECTION_TYPE().equals(""))
+ pgAssetPlanDto.setINSPECTION_TYPE("");
+ else if(pgAssetPlan.getINSPECTION_TYPE().equals("1"))
+ pgAssetPlanDto.setINSPECTION_TYPE("廊内巡检");
+ else if(pgAssetPlan.getINSPECTION_TYPE().equals("2"))
+ pgAssetPlanDto.setINSPECTION_TYPE("廊外巡检");
+
+ pgAssetPlanDto.setINSPECTION_START_TIME(pgAssetPlan.getSTART_DATE());
+ pgAssetPlanDto.setINSPECTION_END_TIME(pgAssetPlan.getEND_DATE());
pgAssetPlanDto.setINSPECTION_PRACE(pgAssetPlan.getINSPECTION_PRACE());
pgAssetPlanDto.setFREQUENCY(pgAssetPlan.getFREQUENCY());
pgAssetPlanDto.setCREATOR(pgAssetPlan.getCREATOR());
pgAssetPlanDto.setDEVELOP_DEPT(pgAssetPlan.getDEVELOP_DEPT());
pgAssetPlanDto.setPROJECT(pgAssetPlan.getPROJECT());
- pgAssetPlanDto.setSTATE(pgAssetPlan.getSTATE().equals("0")?"执行结束":"执行中");
+ if(pgAssetPlan.getSTATE().equals("0"))
+ pgAssetPlanDto.setSTATE("待执行");
+ else if(pgAssetPlan.getSTATE().equals("1"))
+ pgAssetPlanDto.setSTATE("执行中");
+ else if(pgAssetPlan.getSTATE().equals("2"))
+ pgAssetPlanDto.setSTATE("执行结束");
return pgAssetPlanDto;
}
diff --git a/src/main/java/com/casic/PgInterface/maintenance/manager/PgAssetPlanManager.java b/src/main/java/com/casic/PgInterface/maintenance/manager/PgAssetPlanManager.java
index 4f98571..bf7d1ea 100644
--- a/src/main/java/com/casic/PgInterface/maintenance/manager/PgAssetPlanManager.java
+++ b/src/main/java/com/casic/PgInterface/maintenance/manager/PgAssetPlanManager.java
@@ -33,7 +33,7 @@
criteria.add(Restrictions.le("FREQUENCYDATE", calendar.getTime()));
}
- criteria.addOrder(Order.desc("id"));
+ criteria.addOrder(Order.desc("PLAN_NO"));
List pgAssetPlanList = criteria.list();