diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/data/PgAssetInSpectionPlan.java b/src/com/szpg/db/data/PgAssetInSpectionPlan.java new file mode 100644 index 0000000..fd10c61 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetInSpectionPlan.java @@ -0,0 +1,316 @@ +package com.szpg.db.data; + +import java.io.Serializable; + +public class PgAssetInSpectionPlan implements Serializable { + + private String KEY_ID;//唯一键值 + private String PLAN_NAME;//巡检计划名称 + private String INSPECTION_PERSON;//巡检人 + private String START_DATE;//巡检开始时间 + private String END_DATE; + private String FREQUENCY;//巡检频率 + private String STATE;//状态 + private String RESPONSIBLE_DEPT;//负责单位/部门/小组 + private String PLAN_NO;//巡检计划编号 + private String INSPECTION_TYPE;//巡检类型 + private String INSPECTION_MODE;//巡检方式 + private String INSPECTION_ROUTE;//巡检路线 + private String INSPECTION_START_TIME;//巡检开始时间 + private String INSPECTION_END_TIME;//巡检结束时间 + private String INSPECTION_PRACE;//巡检地点 + private String INSPECTION_GROUP;//巡检部门 + private String INSERT_TIME;//插入时间 + private String FREQUENCYDATE;//巡检具体日期 + private String FREQUENCYTIME;//巡检具体时间 + private String CREATEDATE;//创建时间 + private String CREATOR;//创建人 + private String PROJECT;//项目 + private String COMLILE;//编制人 + private String START_TIME;//编制时间 + private String DEVELOP_DEPT;//制定部门 + private String END_TIME;//结束时间 + private String START_PILE_NO;//开始桩号 + private String END_PILE_NO;//结束桩号 + private String BUILD_CABIN;//巡检舱室 + private String MILEAGE; + private String FREQUENCY_TIME;//巡检具体时间 + private String FREQUENCYTIME_END; + private String KETTLE_TS; + private String UPDATEDATE; + + public String getKEY_ID() { + return KEY_ID; + } + + public void setKEY_ID(String KEY_ID) { + this.KEY_ID = KEY_ID; + } + + public String getPLAN_NAME() { + return PLAN_NAME; + } + + public void setPLAN_NAME(String PLAN_NAME) { + this.PLAN_NAME = PLAN_NAME; + } + + public String getINSPECTION_PERSON() { + return INSPECTION_PERSON; + } + + public void setINSPECTION_PERSON(String INSPECTION_PERSON) { + this.INSPECTION_PERSON = INSPECTION_PERSON; + } + + public String getSTART_DATE() { + return START_DATE; + } + + public void setSTART_DATE(String START_DATE) { + this.START_DATE = START_DATE; + } + + public String getEND_DATE() { + return END_DATE; + } + + public void setEND_DATE(String END_DATE) { + this.END_DATE = END_DATE; + } + + public String getFREQUENCY() { + return FREQUENCY; + } + + public void setFREQUENCY(String FREQUENCY) { + this.FREQUENCY = FREQUENCY; + } + + public String getSTATE() { + return STATE; + } + + public void setSTATE(String STATE) { + this.STATE = STATE; + } + + public String getRESPONSIBLE_DEPT() { + return RESPONSIBLE_DEPT; + } + + public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { + this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; + } + + + public String getPLAN_NO() { + return PLAN_NO; + } + + public void setPLAN_NO(String PLAN_NO) { + this.PLAN_NO = PLAN_NO; + } + + public String getINSPECTION_TYPE() { + return INSPECTION_TYPE; + } + + public void setINSPECTION_TYPE(String INSPECTION_TYPE) { + this.INSPECTION_TYPE = INSPECTION_TYPE; + } + + public String getINSPECTION_MODE() { + return INSPECTION_MODE; + } + + public void setINSPECTION_MODE(String INSPECTION_MODE) { + this.INSPECTION_MODE = INSPECTION_MODE; + } + + public String getINSPECTION_ROUTE() { + return INSPECTION_ROUTE; + } + + public void setINSPECTION_ROUTE(String INSPECTION_ROUTE) { + this.INSPECTION_ROUTE = INSPECTION_ROUTE; + } + + public String getINSPECTION_START_TIME() { + return INSPECTION_START_TIME; + } + + public void setINSPECTION_START_TIME(String INSPECTION_START_TIME) { + this.INSPECTION_START_TIME = INSPECTION_START_TIME; + } + + public String getINSPECTION_END_TIME() { + return INSPECTION_END_TIME; + } + + public void setINSPECTION_END_TIME(String INSPECTION_END_TIME) { + this.INSPECTION_END_TIME = INSPECTION_END_TIME; + } + + public String getINSPECTION_PRACE() { + return INSPECTION_PRACE; + } + + public void setINSPECTION_PRACE(String INSPECTION_PRACE) { + this.INSPECTION_PRACE = INSPECTION_PRACE; + } + + public String getINSPECTION_GROUP() { + return INSPECTION_GROUP; + } + + public void setINSPECTION_GROUP(String INSPECTION_GROUP) { + this.INSPECTION_GROUP = INSPECTION_GROUP; + } + + public String getINSERT_TIME() { + return INSERT_TIME; + } + + public void setINSERT_TIME(String INSERT_TIME) { + this.INSERT_TIME = INSERT_TIME; + } + + public String getFREQUENCYDATE() { + return FREQUENCYDATE; + } + + public void setFREQUENCYDATE(String FREQUENCYDATE) { + this.FREQUENCYDATE = FREQUENCYDATE; + } + + public String getFREQUENCYTIME() { + return FREQUENCYTIME; + } + + public void setFREQUENCYTIME(String FREQUENCYTIME) { + this.FREQUENCYTIME = FREQUENCYTIME; + } + + public String getCREATEDATE() { + return CREATEDATE; + } + + public void setCREATEDATE(String CREATEDATE) { + this.CREATEDATE = CREATEDATE; + } + + public String getCREATOR() { + return CREATOR; + } + + public void setCREATOR(String CREATOR) { + this.CREATOR = CREATOR; + } + + public String getPROJECT() { + return PROJECT; + } + + public void setPROJECT(String PROJECT) { + this.PROJECT = PROJECT; + } + + public String getCOMLILE() { + return COMLILE; + } + + public void setCOMLILE(String COMLILE) { + this.COMLILE = COMLILE; + } + + public String getSTART_TIME() { + return START_TIME; + } + + public void setSTART_TIME(String START_TIME) { + this.START_TIME = START_TIME; + } + + public String getDEVELOP_DEPT() { + return DEVELOP_DEPT; + } + + public void setDEVELOP_DEPT(String DEVELOP_DEPT) { + this.DEVELOP_DEPT = DEVELOP_DEPT; + } + + public String getEND_TIME() { + return END_TIME; + } + + public void setEND_TIME(String END_TIME) { + this.END_TIME = END_TIME; + } + + public String getSTART_PILE_NO() { + return START_PILE_NO; + } + + public void setSTART_PILE_NO(String START_PILE_NO) { + this.START_PILE_NO = START_PILE_NO; + } + + public String getEND_PILE_NO() { + return END_PILE_NO; + } + + public void setEND_PILE_NO(String END_PILE_NO) { + this.END_PILE_NO = END_PILE_NO; + } + + public String getBUILD_CABIN() { + return BUILD_CABIN; + } + + public void setBUILD_CABIN(String BUILD_CABIN) { + this.BUILD_CABIN = BUILD_CABIN; + } + + public String getMILEAGE() { + return MILEAGE; + } + + public void setMILEAGE(String MILEAGE) { + this.MILEAGE = MILEAGE; + } + + public String getFREQUENCY_TIME() { + return FREQUENCY_TIME; + } + + public void setFREQUENCY_TIME(String FREQUENCY_TIME) { + this.FREQUENCY_TIME = FREQUENCY_TIME; + } + + public String getFREQUENCYTIME_END() { + return FREQUENCYTIME_END; + } + + public void setFREQUENCYTIME_END(String FREQUENCYTIME_END) { + this.FREQUENCYTIME_END = FREQUENCYTIME_END; + } + + public String getKETTLE_TS() { + return KETTLE_TS; + } + + public void setKETTLE_TS(String KETTLE_TS) { + this.KETTLE_TS = KETTLE_TS; + } + + public String getUPDATEDATE() { + return UPDATEDATE; + } + + public void setUPDATEDATE(String UPDATEDATE) { + this.UPDATEDATE = UPDATEDATE; + } + + +} diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/data/PgAssetInSpectionPlan.java b/src/com/szpg/db/data/PgAssetInSpectionPlan.java new file mode 100644 index 0000000..fd10c61 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetInSpectionPlan.java @@ -0,0 +1,316 @@ +package com.szpg.db.data; + +import java.io.Serializable; + +public class PgAssetInSpectionPlan implements Serializable { + + private String KEY_ID;//唯一键值 + private String PLAN_NAME;//巡检计划名称 + private String INSPECTION_PERSON;//巡检人 + private String START_DATE;//巡检开始时间 + private String END_DATE; + private String FREQUENCY;//巡检频率 + private String STATE;//状态 + private String RESPONSIBLE_DEPT;//负责单位/部门/小组 + private String PLAN_NO;//巡检计划编号 + private String INSPECTION_TYPE;//巡检类型 + private String INSPECTION_MODE;//巡检方式 + private String INSPECTION_ROUTE;//巡检路线 + private String INSPECTION_START_TIME;//巡检开始时间 + private String INSPECTION_END_TIME;//巡检结束时间 + private String INSPECTION_PRACE;//巡检地点 + private String INSPECTION_GROUP;//巡检部门 + private String INSERT_TIME;//插入时间 + private String FREQUENCYDATE;//巡检具体日期 + private String FREQUENCYTIME;//巡检具体时间 + private String CREATEDATE;//创建时间 + private String CREATOR;//创建人 + private String PROJECT;//项目 + private String COMLILE;//编制人 + private String START_TIME;//编制时间 + private String DEVELOP_DEPT;//制定部门 + private String END_TIME;//结束时间 + private String START_PILE_NO;//开始桩号 + private String END_PILE_NO;//结束桩号 + private String BUILD_CABIN;//巡检舱室 + private String MILEAGE; + private String FREQUENCY_TIME;//巡检具体时间 + private String FREQUENCYTIME_END; + private String KETTLE_TS; + private String UPDATEDATE; + + public String getKEY_ID() { + return KEY_ID; + } + + public void setKEY_ID(String KEY_ID) { + this.KEY_ID = KEY_ID; + } + + public String getPLAN_NAME() { + return PLAN_NAME; + } + + public void setPLAN_NAME(String PLAN_NAME) { + this.PLAN_NAME = PLAN_NAME; + } + + public String getINSPECTION_PERSON() { + return INSPECTION_PERSON; + } + + public void setINSPECTION_PERSON(String INSPECTION_PERSON) { + this.INSPECTION_PERSON = INSPECTION_PERSON; + } + + public String getSTART_DATE() { + return START_DATE; + } + + public void setSTART_DATE(String START_DATE) { + this.START_DATE = START_DATE; + } + + public String getEND_DATE() { + return END_DATE; + } + + public void setEND_DATE(String END_DATE) { + this.END_DATE = END_DATE; + } + + public String getFREQUENCY() { + return FREQUENCY; + } + + public void setFREQUENCY(String FREQUENCY) { + this.FREQUENCY = FREQUENCY; + } + + public String getSTATE() { + return STATE; + } + + public void setSTATE(String STATE) { + this.STATE = STATE; + } + + public String getRESPONSIBLE_DEPT() { + return RESPONSIBLE_DEPT; + } + + public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { + this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; + } + + + public String getPLAN_NO() { + return PLAN_NO; + } + + public void setPLAN_NO(String PLAN_NO) { + this.PLAN_NO = PLAN_NO; + } + + public String getINSPECTION_TYPE() { + return INSPECTION_TYPE; + } + + public void setINSPECTION_TYPE(String INSPECTION_TYPE) { + this.INSPECTION_TYPE = INSPECTION_TYPE; + } + + public String getINSPECTION_MODE() { + return INSPECTION_MODE; + } + + public void setINSPECTION_MODE(String INSPECTION_MODE) { + this.INSPECTION_MODE = INSPECTION_MODE; + } + + public String getINSPECTION_ROUTE() { + return INSPECTION_ROUTE; + } + + public void setINSPECTION_ROUTE(String INSPECTION_ROUTE) { + this.INSPECTION_ROUTE = INSPECTION_ROUTE; + } + + public String getINSPECTION_START_TIME() { + return INSPECTION_START_TIME; + } + + public void setINSPECTION_START_TIME(String INSPECTION_START_TIME) { + this.INSPECTION_START_TIME = INSPECTION_START_TIME; + } + + public String getINSPECTION_END_TIME() { + return INSPECTION_END_TIME; + } + + public void setINSPECTION_END_TIME(String INSPECTION_END_TIME) { + this.INSPECTION_END_TIME = INSPECTION_END_TIME; + } + + public String getINSPECTION_PRACE() { + return INSPECTION_PRACE; + } + + public void setINSPECTION_PRACE(String INSPECTION_PRACE) { + this.INSPECTION_PRACE = INSPECTION_PRACE; + } + + public String getINSPECTION_GROUP() { + return INSPECTION_GROUP; + } + + public void setINSPECTION_GROUP(String INSPECTION_GROUP) { + this.INSPECTION_GROUP = INSPECTION_GROUP; + } + + public String getINSERT_TIME() { + return INSERT_TIME; + } + + public void setINSERT_TIME(String INSERT_TIME) { + this.INSERT_TIME = INSERT_TIME; + } + + public String getFREQUENCYDATE() { + return FREQUENCYDATE; + } + + public void setFREQUENCYDATE(String FREQUENCYDATE) { + this.FREQUENCYDATE = FREQUENCYDATE; + } + + public String getFREQUENCYTIME() { + return FREQUENCYTIME; + } + + public void setFREQUENCYTIME(String FREQUENCYTIME) { + this.FREQUENCYTIME = FREQUENCYTIME; + } + + public String getCREATEDATE() { + return CREATEDATE; + } + + public void setCREATEDATE(String CREATEDATE) { + this.CREATEDATE = CREATEDATE; + } + + public String getCREATOR() { + return CREATOR; + } + + public void setCREATOR(String CREATOR) { + this.CREATOR = CREATOR; + } + + public String getPROJECT() { + return PROJECT; + } + + public void setPROJECT(String PROJECT) { + this.PROJECT = PROJECT; + } + + public String getCOMLILE() { + return COMLILE; + } + + public void setCOMLILE(String COMLILE) { + this.COMLILE = COMLILE; + } + + public String getSTART_TIME() { + return START_TIME; + } + + public void setSTART_TIME(String START_TIME) { + this.START_TIME = START_TIME; + } + + public String getDEVELOP_DEPT() { + return DEVELOP_DEPT; + } + + public void setDEVELOP_DEPT(String DEVELOP_DEPT) { + this.DEVELOP_DEPT = DEVELOP_DEPT; + } + + public String getEND_TIME() { + return END_TIME; + } + + public void setEND_TIME(String END_TIME) { + this.END_TIME = END_TIME; + } + + public String getSTART_PILE_NO() { + return START_PILE_NO; + } + + public void setSTART_PILE_NO(String START_PILE_NO) { + this.START_PILE_NO = START_PILE_NO; + } + + public String getEND_PILE_NO() { + return END_PILE_NO; + } + + public void setEND_PILE_NO(String END_PILE_NO) { + this.END_PILE_NO = END_PILE_NO; + } + + public String getBUILD_CABIN() { + return BUILD_CABIN; + } + + public void setBUILD_CABIN(String BUILD_CABIN) { + this.BUILD_CABIN = BUILD_CABIN; + } + + public String getMILEAGE() { + return MILEAGE; + } + + public void setMILEAGE(String MILEAGE) { + this.MILEAGE = MILEAGE; + } + + public String getFREQUENCY_TIME() { + return FREQUENCY_TIME; + } + + public void setFREQUENCY_TIME(String FREQUENCY_TIME) { + this.FREQUENCY_TIME = FREQUENCY_TIME; + } + + public String getFREQUENCYTIME_END() { + return FREQUENCYTIME_END; + } + + public void setFREQUENCYTIME_END(String FREQUENCYTIME_END) { + this.FREQUENCYTIME_END = FREQUENCYTIME_END; + } + + public String getKETTLE_TS() { + return KETTLE_TS; + } + + public void setKETTLE_TS(String KETTLE_TS) { + this.KETTLE_TS = KETTLE_TS; + } + + public String getUPDATEDATE() { + return UPDATEDATE; + } + + public void setUPDATEDATE(String UPDATEDATE) { + this.UPDATEDATE = UPDATEDATE; + } + + +} diff --git a/src/com/szpg/db/data/PgAssetJson.java b/src/com/szpg/db/data/PgAssetJson.java deleted file mode 100644 index b5d6dd6..0000000 --- a/src/com/szpg/db/data/PgAssetJson.java +++ /dev/null @@ -1,53 +0,0 @@ -package com.szpg.db.data; - -import java.util.List; - -public class PgAssetJson { - - private String total; - private String totalRecords; - private String page; - private String records; - private List rows; - - public String getTotal() { - return total; - } - - public void setTotal(String total) { - this.total = total; - } - - public String getTotalRecords() { - return totalRecords; - } - - public void setTotalRecords(String totalRecords) { - this.totalRecords = totalRecords; - } - - public String getPage() { - return page; - } - - public void setPage(String page) { - this.page = page; - } - - public String getRecords() { - return records; - } - - public void setRecords(String records) { - this.records = records; - } - - public List getRows() { - return rows; - } - - public void setRows(List rows) { - this.rows = rows; - } - -} diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/data/PgAssetInSpectionPlan.java b/src/com/szpg/db/data/PgAssetInSpectionPlan.java new file mode 100644 index 0000000..fd10c61 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetInSpectionPlan.java @@ -0,0 +1,316 @@ +package com.szpg.db.data; + +import java.io.Serializable; + +public class PgAssetInSpectionPlan implements Serializable { + + private String KEY_ID;//唯一键值 + private String PLAN_NAME;//巡检计划名称 + private String INSPECTION_PERSON;//巡检人 + private String START_DATE;//巡检开始时间 + private String END_DATE; + private String FREQUENCY;//巡检频率 + private String STATE;//状态 + private String RESPONSIBLE_DEPT;//负责单位/部门/小组 + private String PLAN_NO;//巡检计划编号 + private String INSPECTION_TYPE;//巡检类型 + private String INSPECTION_MODE;//巡检方式 + private String INSPECTION_ROUTE;//巡检路线 + private String INSPECTION_START_TIME;//巡检开始时间 + private String INSPECTION_END_TIME;//巡检结束时间 + private String INSPECTION_PRACE;//巡检地点 + private String INSPECTION_GROUP;//巡检部门 + private String INSERT_TIME;//插入时间 + private String FREQUENCYDATE;//巡检具体日期 + private String FREQUENCYTIME;//巡检具体时间 + private String CREATEDATE;//创建时间 + private String CREATOR;//创建人 + private String PROJECT;//项目 + private String COMLILE;//编制人 + private String START_TIME;//编制时间 + private String DEVELOP_DEPT;//制定部门 + private String END_TIME;//结束时间 + private String START_PILE_NO;//开始桩号 + private String END_PILE_NO;//结束桩号 + private String BUILD_CABIN;//巡检舱室 + private String MILEAGE; + private String FREQUENCY_TIME;//巡检具体时间 + private String FREQUENCYTIME_END; + private String KETTLE_TS; + private String UPDATEDATE; + + public String getKEY_ID() { + return KEY_ID; + } + + public void setKEY_ID(String KEY_ID) { + this.KEY_ID = KEY_ID; + } + + public String getPLAN_NAME() { + return PLAN_NAME; + } + + public void setPLAN_NAME(String PLAN_NAME) { + this.PLAN_NAME = PLAN_NAME; + } + + public String getINSPECTION_PERSON() { + return INSPECTION_PERSON; + } + + public void setINSPECTION_PERSON(String INSPECTION_PERSON) { + this.INSPECTION_PERSON = INSPECTION_PERSON; + } + + public String getSTART_DATE() { + return START_DATE; + } + + public void setSTART_DATE(String START_DATE) { + this.START_DATE = START_DATE; + } + + public String getEND_DATE() { + return END_DATE; + } + + public void setEND_DATE(String END_DATE) { + this.END_DATE = END_DATE; + } + + public String getFREQUENCY() { + return FREQUENCY; + } + + public void setFREQUENCY(String FREQUENCY) { + this.FREQUENCY = FREQUENCY; + } + + public String getSTATE() { + return STATE; + } + + public void setSTATE(String STATE) { + this.STATE = STATE; + } + + public String getRESPONSIBLE_DEPT() { + return RESPONSIBLE_DEPT; + } + + public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { + this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; + } + + + public String getPLAN_NO() { + return PLAN_NO; + } + + public void setPLAN_NO(String PLAN_NO) { + this.PLAN_NO = PLAN_NO; + } + + public String getINSPECTION_TYPE() { + return INSPECTION_TYPE; + } + + public void setINSPECTION_TYPE(String INSPECTION_TYPE) { + this.INSPECTION_TYPE = INSPECTION_TYPE; + } + + public String getINSPECTION_MODE() { + return INSPECTION_MODE; + } + + public void setINSPECTION_MODE(String INSPECTION_MODE) { + this.INSPECTION_MODE = INSPECTION_MODE; + } + + public String getINSPECTION_ROUTE() { + return INSPECTION_ROUTE; + } + + public void setINSPECTION_ROUTE(String INSPECTION_ROUTE) { + this.INSPECTION_ROUTE = INSPECTION_ROUTE; + } + + public String getINSPECTION_START_TIME() { + return INSPECTION_START_TIME; + } + + public void setINSPECTION_START_TIME(String INSPECTION_START_TIME) { + this.INSPECTION_START_TIME = INSPECTION_START_TIME; + } + + public String getINSPECTION_END_TIME() { + return INSPECTION_END_TIME; + } + + public void setINSPECTION_END_TIME(String INSPECTION_END_TIME) { + this.INSPECTION_END_TIME = INSPECTION_END_TIME; + } + + public String getINSPECTION_PRACE() { + return INSPECTION_PRACE; + } + + public void setINSPECTION_PRACE(String INSPECTION_PRACE) { + this.INSPECTION_PRACE = INSPECTION_PRACE; + } + + public String getINSPECTION_GROUP() { + return INSPECTION_GROUP; + } + + public void setINSPECTION_GROUP(String INSPECTION_GROUP) { + this.INSPECTION_GROUP = INSPECTION_GROUP; + } + + public String getINSERT_TIME() { + return INSERT_TIME; + } + + public void setINSERT_TIME(String INSERT_TIME) { + this.INSERT_TIME = INSERT_TIME; + } + + public String getFREQUENCYDATE() { + return FREQUENCYDATE; + } + + public void setFREQUENCYDATE(String FREQUENCYDATE) { + this.FREQUENCYDATE = FREQUENCYDATE; + } + + public String getFREQUENCYTIME() { + return FREQUENCYTIME; + } + + public void setFREQUENCYTIME(String FREQUENCYTIME) { + this.FREQUENCYTIME = FREQUENCYTIME; + } + + public String getCREATEDATE() { + return CREATEDATE; + } + + public void setCREATEDATE(String CREATEDATE) { + this.CREATEDATE = CREATEDATE; + } + + public String getCREATOR() { + return CREATOR; + } + + public void setCREATOR(String CREATOR) { + this.CREATOR = CREATOR; + } + + public String getPROJECT() { + return PROJECT; + } + + public void setPROJECT(String PROJECT) { + this.PROJECT = PROJECT; + } + + public String getCOMLILE() { + return COMLILE; + } + + public void setCOMLILE(String COMLILE) { + this.COMLILE = COMLILE; + } + + public String getSTART_TIME() { + return START_TIME; + } + + public void setSTART_TIME(String START_TIME) { + this.START_TIME = START_TIME; + } + + public String getDEVELOP_DEPT() { + return DEVELOP_DEPT; + } + + public void setDEVELOP_DEPT(String DEVELOP_DEPT) { + this.DEVELOP_DEPT = DEVELOP_DEPT; + } + + public String getEND_TIME() { + return END_TIME; + } + + public void setEND_TIME(String END_TIME) { + this.END_TIME = END_TIME; + } + + public String getSTART_PILE_NO() { + return START_PILE_NO; + } + + public void setSTART_PILE_NO(String START_PILE_NO) { + this.START_PILE_NO = START_PILE_NO; + } + + public String getEND_PILE_NO() { + return END_PILE_NO; + } + + public void setEND_PILE_NO(String END_PILE_NO) { + this.END_PILE_NO = END_PILE_NO; + } + + public String getBUILD_CABIN() { + return BUILD_CABIN; + } + + public void setBUILD_CABIN(String BUILD_CABIN) { + this.BUILD_CABIN = BUILD_CABIN; + } + + public String getMILEAGE() { + return MILEAGE; + } + + public void setMILEAGE(String MILEAGE) { + this.MILEAGE = MILEAGE; + } + + public String getFREQUENCY_TIME() { + return FREQUENCY_TIME; + } + + public void setFREQUENCY_TIME(String FREQUENCY_TIME) { + this.FREQUENCY_TIME = FREQUENCY_TIME; + } + + public String getFREQUENCYTIME_END() { + return FREQUENCYTIME_END; + } + + public void setFREQUENCYTIME_END(String FREQUENCYTIME_END) { + this.FREQUENCYTIME_END = FREQUENCYTIME_END; + } + + public String getKETTLE_TS() { + return KETTLE_TS; + } + + public void setKETTLE_TS(String KETTLE_TS) { + this.KETTLE_TS = KETTLE_TS; + } + + public String getUPDATEDATE() { + return UPDATEDATE; + } + + public void setUPDATEDATE(String UPDATEDATE) { + this.UPDATEDATE = UPDATEDATE; + } + + +} diff --git a/src/com/szpg/db/data/PgAssetJson.java b/src/com/szpg/db/data/PgAssetJson.java deleted file mode 100644 index b5d6dd6..0000000 --- a/src/com/szpg/db/data/PgAssetJson.java +++ /dev/null @@ -1,53 +0,0 @@ -package com.szpg.db.data; - -import java.util.List; - -public class PgAssetJson { - - private String total; - private String totalRecords; - private String page; - private String records; - private List rows; - - public String getTotal() { - return total; - } - - public void setTotal(String total) { - this.total = total; - } - - public String getTotalRecords() { - return totalRecords; - } - - public void setTotalRecords(String totalRecords) { - this.totalRecords = totalRecords; - } - - public String getPage() { - return page; - } - - public void setPage(String page) { - this.page = page; - } - - public String getRecords() { - return records; - } - - public void setRecords(String records) { - this.records = records; - } - - public List getRows() { - return rows; - } - - public void setRows(List rows) { - this.rows = rows; - } - -} diff --git a/src/com/szpg/db/data/PgAssetPlanJson.java b/src/com/szpg/db/data/PgAssetPlanJson.java new file mode 100644 index 0000000..80f25b3 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetPlanJson.java @@ -0,0 +1,53 @@ +package com.szpg.db.data; + +import java.util.List; + +public class PgAssetPlanJson { + + private String total; + private String totalRecords; + private String page; + private String records; + private List rows; + + public String getTotal() { + return total; + } + + public void setTotal(String total) { + this.total = total; + } + + public String getTotalRecords() { + return totalRecords; + } + + public void setTotalRecords(String totalRecords) { + this.totalRecords = totalRecords; + } + + public String getPage() { + return page; + } + + public void setPage(String page) { + this.page = page; + } + + public String getRecords() { + return records; + } + + public void setRecords(String records) { + this.records = records; + } + + public List getRows() { + return rows; + } + + public void setRows(List rows) { + this.rows = rows; + } + +} diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/data/PgAssetInSpectionPlan.java b/src/com/szpg/db/data/PgAssetInSpectionPlan.java new file mode 100644 index 0000000..fd10c61 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetInSpectionPlan.java @@ -0,0 +1,316 @@ +package com.szpg.db.data; + +import java.io.Serializable; + +public class PgAssetInSpectionPlan implements Serializable { + + private String KEY_ID;//唯一键值 + private String PLAN_NAME;//巡检计划名称 + private String INSPECTION_PERSON;//巡检人 + private String START_DATE;//巡检开始时间 + private String END_DATE; + private String FREQUENCY;//巡检频率 + private String STATE;//状态 + private String RESPONSIBLE_DEPT;//负责单位/部门/小组 + private String PLAN_NO;//巡检计划编号 + private String INSPECTION_TYPE;//巡检类型 + private String INSPECTION_MODE;//巡检方式 + private String INSPECTION_ROUTE;//巡检路线 + private String INSPECTION_START_TIME;//巡检开始时间 + private String INSPECTION_END_TIME;//巡检结束时间 + private String INSPECTION_PRACE;//巡检地点 + private String INSPECTION_GROUP;//巡检部门 + private String INSERT_TIME;//插入时间 + private String FREQUENCYDATE;//巡检具体日期 + private String FREQUENCYTIME;//巡检具体时间 + private String CREATEDATE;//创建时间 + private String CREATOR;//创建人 + private String PROJECT;//项目 + private String COMLILE;//编制人 + private String START_TIME;//编制时间 + private String DEVELOP_DEPT;//制定部门 + private String END_TIME;//结束时间 + private String START_PILE_NO;//开始桩号 + private String END_PILE_NO;//结束桩号 + private String BUILD_CABIN;//巡检舱室 + private String MILEAGE; + private String FREQUENCY_TIME;//巡检具体时间 + private String FREQUENCYTIME_END; + private String KETTLE_TS; + private String UPDATEDATE; + + public String getKEY_ID() { + return KEY_ID; + } + + public void setKEY_ID(String KEY_ID) { + this.KEY_ID = KEY_ID; + } + + public String getPLAN_NAME() { + return PLAN_NAME; + } + + public void setPLAN_NAME(String PLAN_NAME) { + this.PLAN_NAME = PLAN_NAME; + } + + public String getINSPECTION_PERSON() { + return INSPECTION_PERSON; + } + + public void setINSPECTION_PERSON(String INSPECTION_PERSON) { + this.INSPECTION_PERSON = INSPECTION_PERSON; + } + + public String getSTART_DATE() { + return START_DATE; + } + + public void setSTART_DATE(String START_DATE) { + this.START_DATE = START_DATE; + } + + public String getEND_DATE() { + return END_DATE; + } + + public void setEND_DATE(String END_DATE) { + this.END_DATE = END_DATE; + } + + public String getFREQUENCY() { + return FREQUENCY; + } + + public void setFREQUENCY(String FREQUENCY) { + this.FREQUENCY = FREQUENCY; + } + + public String getSTATE() { + return STATE; + } + + public void setSTATE(String STATE) { + this.STATE = STATE; + } + + public String getRESPONSIBLE_DEPT() { + return RESPONSIBLE_DEPT; + } + + public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { + this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; + } + + + public String getPLAN_NO() { + return PLAN_NO; + } + + public void setPLAN_NO(String PLAN_NO) { + this.PLAN_NO = PLAN_NO; + } + + public String getINSPECTION_TYPE() { + return INSPECTION_TYPE; + } + + public void setINSPECTION_TYPE(String INSPECTION_TYPE) { + this.INSPECTION_TYPE = INSPECTION_TYPE; + } + + public String getINSPECTION_MODE() { + return INSPECTION_MODE; + } + + public void setINSPECTION_MODE(String INSPECTION_MODE) { + this.INSPECTION_MODE = INSPECTION_MODE; + } + + public String getINSPECTION_ROUTE() { + return INSPECTION_ROUTE; + } + + public void setINSPECTION_ROUTE(String INSPECTION_ROUTE) { + this.INSPECTION_ROUTE = INSPECTION_ROUTE; + } + + public String getINSPECTION_START_TIME() { + return INSPECTION_START_TIME; + } + + public void setINSPECTION_START_TIME(String INSPECTION_START_TIME) { + this.INSPECTION_START_TIME = INSPECTION_START_TIME; + } + + public String getINSPECTION_END_TIME() { + return INSPECTION_END_TIME; + } + + public void setINSPECTION_END_TIME(String INSPECTION_END_TIME) { + this.INSPECTION_END_TIME = INSPECTION_END_TIME; + } + + public String getINSPECTION_PRACE() { + return INSPECTION_PRACE; + } + + public void setINSPECTION_PRACE(String INSPECTION_PRACE) { + this.INSPECTION_PRACE = INSPECTION_PRACE; + } + + public String getINSPECTION_GROUP() { + return INSPECTION_GROUP; + } + + public void setINSPECTION_GROUP(String INSPECTION_GROUP) { + this.INSPECTION_GROUP = INSPECTION_GROUP; + } + + public String getINSERT_TIME() { + return INSERT_TIME; + } + + public void setINSERT_TIME(String INSERT_TIME) { + this.INSERT_TIME = INSERT_TIME; + } + + public String getFREQUENCYDATE() { + return FREQUENCYDATE; + } + + public void setFREQUENCYDATE(String FREQUENCYDATE) { + this.FREQUENCYDATE = FREQUENCYDATE; + } + + public String getFREQUENCYTIME() { + return FREQUENCYTIME; + } + + public void setFREQUENCYTIME(String FREQUENCYTIME) { + this.FREQUENCYTIME = FREQUENCYTIME; + } + + public String getCREATEDATE() { + return CREATEDATE; + } + + public void setCREATEDATE(String CREATEDATE) { + this.CREATEDATE = CREATEDATE; + } + + public String getCREATOR() { + return CREATOR; + } + + public void setCREATOR(String CREATOR) { + this.CREATOR = CREATOR; + } + + public String getPROJECT() { + return PROJECT; + } + + public void setPROJECT(String PROJECT) { + this.PROJECT = PROJECT; + } + + public String getCOMLILE() { + return COMLILE; + } + + public void setCOMLILE(String COMLILE) { + this.COMLILE = COMLILE; + } + + public String getSTART_TIME() { + return START_TIME; + } + + public void setSTART_TIME(String START_TIME) { + this.START_TIME = START_TIME; + } + + public String getDEVELOP_DEPT() { + return DEVELOP_DEPT; + } + + public void setDEVELOP_DEPT(String DEVELOP_DEPT) { + this.DEVELOP_DEPT = DEVELOP_DEPT; + } + + public String getEND_TIME() { + return END_TIME; + } + + public void setEND_TIME(String END_TIME) { + this.END_TIME = END_TIME; + } + + public String getSTART_PILE_NO() { + return START_PILE_NO; + } + + public void setSTART_PILE_NO(String START_PILE_NO) { + this.START_PILE_NO = START_PILE_NO; + } + + public String getEND_PILE_NO() { + return END_PILE_NO; + } + + public void setEND_PILE_NO(String END_PILE_NO) { + this.END_PILE_NO = END_PILE_NO; + } + + public String getBUILD_CABIN() { + return BUILD_CABIN; + } + + public void setBUILD_CABIN(String BUILD_CABIN) { + this.BUILD_CABIN = BUILD_CABIN; + } + + public String getMILEAGE() { + return MILEAGE; + } + + public void setMILEAGE(String MILEAGE) { + this.MILEAGE = MILEAGE; + } + + public String getFREQUENCY_TIME() { + return FREQUENCY_TIME; + } + + public void setFREQUENCY_TIME(String FREQUENCY_TIME) { + this.FREQUENCY_TIME = FREQUENCY_TIME; + } + + public String getFREQUENCYTIME_END() { + return FREQUENCYTIME_END; + } + + public void setFREQUENCYTIME_END(String FREQUENCYTIME_END) { + this.FREQUENCYTIME_END = FREQUENCYTIME_END; + } + + public String getKETTLE_TS() { + return KETTLE_TS; + } + + public void setKETTLE_TS(String KETTLE_TS) { + this.KETTLE_TS = KETTLE_TS; + } + + public String getUPDATEDATE() { + return UPDATEDATE; + } + + public void setUPDATEDATE(String UPDATEDATE) { + this.UPDATEDATE = UPDATEDATE; + } + + +} diff --git a/src/com/szpg/db/data/PgAssetJson.java b/src/com/szpg/db/data/PgAssetJson.java deleted file mode 100644 index b5d6dd6..0000000 --- a/src/com/szpg/db/data/PgAssetJson.java +++ /dev/null @@ -1,53 +0,0 @@ -package com.szpg.db.data; - -import java.util.List; - -public class PgAssetJson { - - private String total; - private String totalRecords; - private String page; - private String records; - private List rows; - - public String getTotal() { - return total; - } - - public void setTotal(String total) { - this.total = total; - } - - public String getTotalRecords() { - return totalRecords; - } - - public void setTotalRecords(String totalRecords) { - this.totalRecords = totalRecords; - } - - public String getPage() { - return page; - } - - public void setPage(String page) { - this.page = page; - } - - public String getRecords() { - return records; - } - - public void setRecords(String records) { - this.records = records; - } - - public List getRows() { - return rows; - } - - public void setRows(List rows) { - this.rows = rows; - } - -} diff --git a/src/com/szpg/db/data/PgAssetPlanJson.java b/src/com/szpg/db/data/PgAssetPlanJson.java new file mode 100644 index 0000000..80f25b3 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetPlanJson.java @@ -0,0 +1,53 @@ +package com.szpg.db.data; + +import java.util.List; + +public class PgAssetPlanJson { + + private String total; + private String totalRecords; + private String page; + private String records; + private List rows; + + public String getTotal() { + return total; + } + + public void setTotal(String total) { + this.total = total; + } + + public String getTotalRecords() { + return totalRecords; + } + + public void setTotalRecords(String totalRecords) { + this.totalRecords = totalRecords; + } + + public String getPage() { + return page; + } + + public void setPage(String page) { + this.page = page; + } + + public String getRecords() { + return records; + } + + public void setRecords(String records) { + this.records = records; + } + + public List getRows() { + return rows; + } + + public void setRows(List rows) { + this.rows = rows; + } + +} diff --git a/src/com/szpg/plc/PGDSCServlet.java b/src/com/szpg/plc/PGDSCServlet.java index 26b49d0..4c57137 100644 --- a/src/com/szpg/plc/PGDSCServlet.java +++ b/src/com/szpg/plc/PGDSCServlet.java @@ -105,7 +105,7 @@ synchAssetInSpection(); //运维数据同步 - synchMaintanceRecord(); + //synchMaintanceRecord(); } /** @@ -269,7 +269,7 @@ */ private void synchAssetInSpection() { ScheduledExecutorService sche = new ScheduledThreadPoolExecutor(1); - sche.scheduleWithFixedDelay(new ReadAssetInSpectionTask(), 60, 600, TimeUnit.SECONDS); + sche.scheduleWithFixedDelay(new ReadAssetInSpectionTask(), 60, 60*60*24, TimeUnit.SECONDS); } /** diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/data/PgAssetInSpectionPlan.java b/src/com/szpg/db/data/PgAssetInSpectionPlan.java new file mode 100644 index 0000000..fd10c61 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetInSpectionPlan.java @@ -0,0 +1,316 @@ +package com.szpg.db.data; + +import java.io.Serializable; + +public class PgAssetInSpectionPlan implements Serializable { + + private String KEY_ID;//唯一键值 + private String PLAN_NAME;//巡检计划名称 + private String INSPECTION_PERSON;//巡检人 + private String START_DATE;//巡检开始时间 + private String END_DATE; + private String FREQUENCY;//巡检频率 + private String STATE;//状态 + private String RESPONSIBLE_DEPT;//负责单位/部门/小组 + private String PLAN_NO;//巡检计划编号 + private String INSPECTION_TYPE;//巡检类型 + private String INSPECTION_MODE;//巡检方式 + private String INSPECTION_ROUTE;//巡检路线 + private String INSPECTION_START_TIME;//巡检开始时间 + private String INSPECTION_END_TIME;//巡检结束时间 + private String INSPECTION_PRACE;//巡检地点 + private String INSPECTION_GROUP;//巡检部门 + private String INSERT_TIME;//插入时间 + private String FREQUENCYDATE;//巡检具体日期 + private String FREQUENCYTIME;//巡检具体时间 + private String CREATEDATE;//创建时间 + private String CREATOR;//创建人 + private String PROJECT;//项目 + private String COMLILE;//编制人 + private String START_TIME;//编制时间 + private String DEVELOP_DEPT;//制定部门 + private String END_TIME;//结束时间 + private String START_PILE_NO;//开始桩号 + private String END_PILE_NO;//结束桩号 + private String BUILD_CABIN;//巡检舱室 + private String MILEAGE; + private String FREQUENCY_TIME;//巡检具体时间 + private String FREQUENCYTIME_END; + private String KETTLE_TS; + private String UPDATEDATE; + + public String getKEY_ID() { + return KEY_ID; + } + + public void setKEY_ID(String KEY_ID) { + this.KEY_ID = KEY_ID; + } + + public String getPLAN_NAME() { + return PLAN_NAME; + } + + public void setPLAN_NAME(String PLAN_NAME) { + this.PLAN_NAME = PLAN_NAME; + } + + public String getINSPECTION_PERSON() { + return INSPECTION_PERSON; + } + + public void setINSPECTION_PERSON(String INSPECTION_PERSON) { + this.INSPECTION_PERSON = INSPECTION_PERSON; + } + + public String getSTART_DATE() { + return START_DATE; + } + + public void setSTART_DATE(String START_DATE) { + this.START_DATE = START_DATE; + } + + public String getEND_DATE() { + return END_DATE; + } + + public void setEND_DATE(String END_DATE) { + this.END_DATE = END_DATE; + } + + public String getFREQUENCY() { + return FREQUENCY; + } + + public void setFREQUENCY(String FREQUENCY) { + this.FREQUENCY = FREQUENCY; + } + + public String getSTATE() { + return STATE; + } + + public void setSTATE(String STATE) { + this.STATE = STATE; + } + + public String getRESPONSIBLE_DEPT() { + return RESPONSIBLE_DEPT; + } + + public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { + this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; + } + + + public String getPLAN_NO() { + return PLAN_NO; + } + + public void setPLAN_NO(String PLAN_NO) { + this.PLAN_NO = PLAN_NO; + } + + public String getINSPECTION_TYPE() { + return INSPECTION_TYPE; + } + + public void setINSPECTION_TYPE(String INSPECTION_TYPE) { + this.INSPECTION_TYPE = INSPECTION_TYPE; + } + + public String getINSPECTION_MODE() { + return INSPECTION_MODE; + } + + public void setINSPECTION_MODE(String INSPECTION_MODE) { + this.INSPECTION_MODE = INSPECTION_MODE; + } + + public String getINSPECTION_ROUTE() { + return INSPECTION_ROUTE; + } + + public void setINSPECTION_ROUTE(String INSPECTION_ROUTE) { + this.INSPECTION_ROUTE = INSPECTION_ROUTE; + } + + public String getINSPECTION_START_TIME() { + return INSPECTION_START_TIME; + } + + public void setINSPECTION_START_TIME(String INSPECTION_START_TIME) { + this.INSPECTION_START_TIME = INSPECTION_START_TIME; + } + + public String getINSPECTION_END_TIME() { + return INSPECTION_END_TIME; + } + + public void setINSPECTION_END_TIME(String INSPECTION_END_TIME) { + this.INSPECTION_END_TIME = INSPECTION_END_TIME; + } + + public String getINSPECTION_PRACE() { + return INSPECTION_PRACE; + } + + public void setINSPECTION_PRACE(String INSPECTION_PRACE) { + this.INSPECTION_PRACE = INSPECTION_PRACE; + } + + public String getINSPECTION_GROUP() { + return INSPECTION_GROUP; + } + + public void setINSPECTION_GROUP(String INSPECTION_GROUP) { + this.INSPECTION_GROUP = INSPECTION_GROUP; + } + + public String getINSERT_TIME() { + return INSERT_TIME; + } + + public void setINSERT_TIME(String INSERT_TIME) { + this.INSERT_TIME = INSERT_TIME; + } + + public String getFREQUENCYDATE() { + return FREQUENCYDATE; + } + + public void setFREQUENCYDATE(String FREQUENCYDATE) { + this.FREQUENCYDATE = FREQUENCYDATE; + } + + public String getFREQUENCYTIME() { + return FREQUENCYTIME; + } + + public void setFREQUENCYTIME(String FREQUENCYTIME) { + this.FREQUENCYTIME = FREQUENCYTIME; + } + + public String getCREATEDATE() { + return CREATEDATE; + } + + public void setCREATEDATE(String CREATEDATE) { + this.CREATEDATE = CREATEDATE; + } + + public String getCREATOR() { + return CREATOR; + } + + public void setCREATOR(String CREATOR) { + this.CREATOR = CREATOR; + } + + public String getPROJECT() { + return PROJECT; + } + + public void setPROJECT(String PROJECT) { + this.PROJECT = PROJECT; + } + + public String getCOMLILE() { + return COMLILE; + } + + public void setCOMLILE(String COMLILE) { + this.COMLILE = COMLILE; + } + + public String getSTART_TIME() { + return START_TIME; + } + + public void setSTART_TIME(String START_TIME) { + this.START_TIME = START_TIME; + } + + public String getDEVELOP_DEPT() { + return DEVELOP_DEPT; + } + + public void setDEVELOP_DEPT(String DEVELOP_DEPT) { + this.DEVELOP_DEPT = DEVELOP_DEPT; + } + + public String getEND_TIME() { + return END_TIME; + } + + public void setEND_TIME(String END_TIME) { + this.END_TIME = END_TIME; + } + + public String getSTART_PILE_NO() { + return START_PILE_NO; + } + + public void setSTART_PILE_NO(String START_PILE_NO) { + this.START_PILE_NO = START_PILE_NO; + } + + public String getEND_PILE_NO() { + return END_PILE_NO; + } + + public void setEND_PILE_NO(String END_PILE_NO) { + this.END_PILE_NO = END_PILE_NO; + } + + public String getBUILD_CABIN() { + return BUILD_CABIN; + } + + public void setBUILD_CABIN(String BUILD_CABIN) { + this.BUILD_CABIN = BUILD_CABIN; + } + + public String getMILEAGE() { + return MILEAGE; + } + + public void setMILEAGE(String MILEAGE) { + this.MILEAGE = MILEAGE; + } + + public String getFREQUENCY_TIME() { + return FREQUENCY_TIME; + } + + public void setFREQUENCY_TIME(String FREQUENCY_TIME) { + this.FREQUENCY_TIME = FREQUENCY_TIME; + } + + public String getFREQUENCYTIME_END() { + return FREQUENCYTIME_END; + } + + public void setFREQUENCYTIME_END(String FREQUENCYTIME_END) { + this.FREQUENCYTIME_END = FREQUENCYTIME_END; + } + + public String getKETTLE_TS() { + return KETTLE_TS; + } + + public void setKETTLE_TS(String KETTLE_TS) { + this.KETTLE_TS = KETTLE_TS; + } + + public String getUPDATEDATE() { + return UPDATEDATE; + } + + public void setUPDATEDATE(String UPDATEDATE) { + this.UPDATEDATE = UPDATEDATE; + } + + +} diff --git a/src/com/szpg/db/data/PgAssetJson.java b/src/com/szpg/db/data/PgAssetJson.java deleted file mode 100644 index b5d6dd6..0000000 --- a/src/com/szpg/db/data/PgAssetJson.java +++ /dev/null @@ -1,53 +0,0 @@ -package com.szpg.db.data; - -import java.util.List; - -public class PgAssetJson { - - private String total; - private String totalRecords; - private String page; - private String records; - private List rows; - - public String getTotal() { - return total; - } - - public void setTotal(String total) { - this.total = total; - } - - public String getTotalRecords() { - return totalRecords; - } - - public void setTotalRecords(String totalRecords) { - this.totalRecords = totalRecords; - } - - public String getPage() { - return page; - } - - public void setPage(String page) { - this.page = page; - } - - public String getRecords() { - return records; - } - - public void setRecords(String records) { - this.records = records; - } - - public List getRows() { - return rows; - } - - public void setRows(List rows) { - this.rows = rows; - } - -} diff --git a/src/com/szpg/db/data/PgAssetPlanJson.java b/src/com/szpg/db/data/PgAssetPlanJson.java new file mode 100644 index 0000000..80f25b3 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetPlanJson.java @@ -0,0 +1,53 @@ +package com.szpg.db.data; + +import java.util.List; + +public class PgAssetPlanJson { + + private String total; + private String totalRecords; + private String page; + private String records; + private List rows; + + public String getTotal() { + return total; + } + + public void setTotal(String total) { + this.total = total; + } + + public String getTotalRecords() { + return totalRecords; + } + + public void setTotalRecords(String totalRecords) { + this.totalRecords = totalRecords; + } + + public String getPage() { + return page; + } + + public void setPage(String page) { + this.page = page; + } + + public String getRecords() { + return records; + } + + public void setRecords(String records) { + this.records = records; + } + + public List getRows() { + return rows; + } + + public void setRows(List rows) { + this.rows = rows; + } + +} diff --git a/src/com/szpg/plc/PGDSCServlet.java b/src/com/szpg/plc/PGDSCServlet.java index 26b49d0..4c57137 100644 --- a/src/com/szpg/plc/PGDSCServlet.java +++ b/src/com/szpg/plc/PGDSCServlet.java @@ -105,7 +105,7 @@ synchAssetInSpection(); //运维数据同步 - synchMaintanceRecord(); + //synchMaintanceRecord(); } /** @@ -269,7 +269,7 @@ */ private void synchAssetInSpection() { ScheduledExecutorService sche = new ScheduledThreadPoolExecutor(1); - sche.scheduleWithFixedDelay(new ReadAssetInSpectionTask(), 60, 600, TimeUnit.SECONDS); + sche.scheduleWithFixedDelay(new ReadAssetInSpectionTask(), 60, 60*60*24, TimeUnit.SECONDS); } /** diff --git a/src/com/szpg/task/ReadAssetInSpectionTask.java b/src/com/szpg/task/ReadAssetInSpectionTask.java index 1389e0d..a95a28a 100644 --- a/src/com/szpg/task/ReadAssetInSpectionTask.java +++ b/src/com/szpg/task/ReadAssetInSpectionTask.java @@ -1,12 +1,15 @@ package com.szpg.task; import com.alibaba.fastjson.JSON; +import com.alibaba.fastjson.JSONObject; import com.alibaba.fastjson.TypeReference; import com.szpg.db.dao.PgAssetInSpectionDao; import com.szpg.db.dao.impl.PgAssetInSpectionImpl; -import com.szpg.db.data.PgAssetInSpection; -import com.szpg.db.data.PgAssetJson; +import com.szpg.db.data.PgAssetInSpectionPlan; +import com.szpg.db.data.PgAssetPlanJson; +import com.szpg.test; import com.szpg.util.HttpRequest; +import org.apache.log4j.Logger; import java.io.FileWriter; import java.io.IOException; @@ -14,13 +17,12 @@ import java.util.Calendar; import java.util.Date; import java.util.List; -import java.util.logging.Logger; public class ReadAssetInSpectionTask implements Runnable{ - private final Logger logger = Logger.getLogger(this.getClass().getName()); - final String tableName="V_ASSET_INSPECTION_RECORD"; + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); + final String tableName="ASSET_INSPECTION_PLAN"; final String url="http://10.10.2.31:9056/GLYW/api/Common/LoadIndexData"; - SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); @Override public void run(){ @@ -33,30 +35,30 @@ startTime=getYestodayStr(); StringBuilder sb = new StringBuilder(); - sb.append("tableName = ").append(tableName); + sb.append("tableName=").append(tableName); sb.append("&page=-1"); - sb.append("&CREATE_DATE=采集时间"); + sb.append("&strWhere= UPDATEDATE"); sb.append(" between '").append(startTime); sb.append("' and '").append(endTime); sb.append("'"); logger.info("开始请求巡检数据"); String jsonStr = HttpRequest.sendPostByHttp(url, sb.toString()); - saveAsFileWriter(jsonStr); if (jsonStr.equals("")) - logger.info("巡检数据请求失败"); + logger.error("巡检数据请求失败"); else { + saveAsFileWriter(jsonStr,"d:\\test.txt"); insertDB(pgAssetInSpectionDao, jsonStr); - logger.info("巡检数据存储成功"); + logger.error("巡检数据存储成功"); } + } - private String savefile = "D:\\test.txt"; - private void saveAsFileWriter(String content) { + private void saveAsFileWriter(String content,String filePath) { FileWriter fwriter = null; try { - fwriter = new FileWriter(savefile); + fwriter = new FileWriter(filePath); fwriter.write(content); } catch (IOException ex) { ex.printStackTrace(); @@ -72,14 +74,23 @@ public void insertDB(PgAssetInSpectionDao pgAssetInSpectionDao,String jsonStr) { - List pgAssetInSpectionList= getAssetByJsonString(jsonStr); - pgAssetInSpectionDao.addAssetInSpectionRecord(pgAssetInSpectionList); + List pgAssetInSpectionPlanList= getAssetByJsonString(jsonStr); + logger.info("同步巡检数据条数："+ String.valueOf(pgAssetInSpectionPlanList.size())); + pgAssetInSpectionDao.addAssetInSpectionPlan(pgAssetInSpectionPlanList); } - private List getAssetByJsonString(String jsonStr){ - PgAssetJson pgAssetJson = JSON.parseObject(jsonStr, new TypeReference() {}); - List pgAssetInSpectionList=pgAssetJson.getRows(); - return pgAssetInSpectionList; + private List getAssetByJsonString(String jsonStr){ + try { + String jsonString=String.valueOf(JSON.parse(jsonStr)); + PgAssetPlanJson pgAssetPlanJson = JSONObject.parseObject(jsonString, new TypeReference() {}); + List pgAssetInSpectionPlanList = pgAssetPlanJson.getRows(); + return pgAssetInSpectionPlanList; + } + catch(Exception ex){ + logger.error(ex.getMessage()); + return null; + } + } public String getYestodayStr() { @@ -93,4 +104,5 @@ return yesToday; } + } \ No newline at end of file diff --git a/src/com/szpg/db/dao/PgAssetInSpectionDao.java b/src/com/szpg/db/dao/PgAssetInSpectionDao.java index 444a551..38cd229 100644 --- a/src/com/szpg/db/dao/PgAssetInSpectionDao.java +++ b/src/com/szpg/db/dao/PgAssetInSpectionDao.java @@ -1,12 +1,12 @@ package com.szpg.db.dao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import java.util.List; public interface PgAssetInSpectionDao { - public void addAssetInSpectionRecord(List pgAssetInSpectionList); + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList); public String findLastRecordTime(); diff --git a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java index 62c4548..2383707 100644 --- a/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java +++ b/src/com/szpg/db/dao/impl/PgAssetInSpectionImpl.java @@ -1,7 +1,7 @@ package com.szpg.db.dao.impl; import com.szpg.db.dao.PgAssetInSpectionDao; -import com.szpg.db.data.PgAssetInSpection; +import com.szpg.db.data.PgAssetInSpectionPlan; import com.szpg.db.util.ConnectionManager; import org.apache.commons.dbutils.DbUtils; import org.apache.commons.dbutils.QueryRunner; @@ -15,40 +15,56 @@ public class PgAssetInSpectionImpl implements PgAssetInSpectionDao { - private final Logger logger = Logger.getLogger(this.getClass().getName()); + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); @Override - public void addAssetInSpectionRecord(List pgAssetInSpectionList){ + public void addAssetInSpectionPlan(List pgAssetInSpectionPlanList){ Connection conn = null; - String insertStr = "INSERT INTO PG_ASSET_INSPECTION_RECORD " + - "(ID,KEY_ID, PLAN_ID, CREATE_DATE, STATE,CREATOR,PLAN_NAME,RECORD_NO,PLAN_NO,RESPONSIBIE_DEPT," + - "INSPECTION_PERSON,PATROL_MAN,OPERATE_DATE,REMARK,BUILD_CABIN,PROJECT,START_PILE_NO,END_PILE_NO," + - "INSPECTION_PRACE,OTHER_PATROL_MAN) " + - "VALUES (SEQ_PG_ASSET_RECORD_ID.nextval,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; + String insertStr = "INSERT INTO PG_ASSET_INSPECTION_PLAN " + + "(KEY_ID, PLAN_NAME, INSPECTION_PERSON,START_DATE,END_DATE,FREQUENCY,STATE,RESPONSIBLE_DEPT,PLAN_NO," + + "INSPECTION_TYPE,INSPECTION_MODE,INSPECTION_ROUTE,INSPECTION_START_TIME,INSPECTION_END_TIME,INSPECTION_PRACE," + + "INSPECTION_GROUP,INSERT_TIME,FREQUENCYDATE,FREQUENCYTIME,CREATEDATE,CREATOR,PROJECT,COMLILE,START_TIME,DEVELOP_DEPT," + + "END_TIME,START_PILE_NO,END_PILE_NO,BUILD_CABIN,MILEAGE,FREQUENCY_TIME,FREQUENCYTIME_END,KETTLE_TS,UPDATEDATE) " + + "VALUES (?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?,?)"; List paramObjectList=new ArrayList(); - for(PgAssetInSpection pgAssetInSpection:pgAssetInSpectionList){ - Object[] params = new Object[19]; - params[0] = pgAssetInSpection.getKEY_ID(); - params[1] = pgAssetInSpection.getPLAN_ID(); - params[2] = pgAssetInSpection.getCREATE_DATE(); - params[3] = pgAssetInSpection.getSTATE(); - params[4]=pgAssetInSpection.getCREATOR(); - params[5]=pgAssetInSpection.getPLAN_NAME(); - params[6]=pgAssetInSpection.getRECORD_NO(); - params[7]=pgAssetInSpection.getPLAN_NO(); - params[8]=pgAssetInSpection.getRESPONSIBLE_DEPT(); - params[9]=pgAssetInSpection.getINSPECTION_PERSON(); - params[10]=pgAssetInSpection.getPATROL_MAN(); - params[11]=pgAssetInSpection.getOPERATE_DATE(); - params[12]=pgAssetInSpection.getREMARK(); - params[13]=pgAssetInSpection.getBUILD_CABIN(); - params[14]=pgAssetInSpection.getPROJECT(); - params[15]=pgAssetInSpection.getSTART_PILE_NO(); - params[16]=pgAssetInSpection.getEND_PILE_NO(); - params[17]=pgAssetInSpection.getINSPECTION_PRACE(); - params[18]=pgAssetInSpection.getOTHER_PATROL_MAN(); + for(PgAssetInSpectionPlan pgAssetInSpectionPlan:pgAssetInSpectionPlanList){ + Object[] params = new Object[34]; + params[0] = pgAssetInSpectionPlan.getKEY_ID(); + params[1] = pgAssetInSpectionPlan.getPLAN_NAME(); + params[2] = pgAssetInSpectionPlan.getINSPECTION_PERSON(); + params[3] = pgAssetInSpectionPlan.getSTART_DATE(); + params[4]=pgAssetInSpectionPlan.getEND_DATE(); + params[5]=pgAssetInSpectionPlan.getFREQUENCY(); + params[6]=pgAssetInSpectionPlan.getSTATE(); + params[7]=pgAssetInSpectionPlan.getRESPONSIBLE_DEPT(); + params[8]=pgAssetInSpectionPlan.getPLAN_NO(); + params[9]=pgAssetInSpectionPlan.getINSPECTION_TYPE(); + params[10]=pgAssetInSpectionPlan.getINSPECTION_MODE(); + params[11]=pgAssetInSpectionPlan.getINSPECTION_ROUTE(); + params[12]=pgAssetInSpectionPlan.getINSPECTION_START_TIME(); + params[13]=pgAssetInSpectionPlan.getINSPECTION_END_TIME(); + params[14]=pgAssetInSpectionPlan.getINSPECTION_PRACE(); + params[15]=pgAssetInSpectionPlan.getINSPECTION_GROUP(); + params[16]=pgAssetInSpectionPlan.getINSERT_TIME(); + params[17]=pgAssetInSpectionPlan.getFREQUENCYDATE(); + params[18]=pgAssetInSpectionPlan.getFREQUENCYTIME(); + params[19]=pgAssetInSpectionPlan.getCREATEDATE(); + params[20]=pgAssetInSpectionPlan.getCREATOR(); + params[21]=pgAssetInSpectionPlan.getPROJECT(); + params[22]=pgAssetInSpectionPlan.getCOMLILE(); + params[23]=pgAssetInSpectionPlan.getSTART_TIME(); + params[24]=pgAssetInSpectionPlan.getDEVELOP_DEPT(); + params[25]=pgAssetInSpectionPlan.getEND_TIME(); + params[26]=pgAssetInSpectionPlan.getSTART_PILE_NO(); + params[27]=pgAssetInSpectionPlan.getEND_PILE_NO(); + params[28]=pgAssetInSpectionPlan.getBUILD_CABIN(); + params[29]=pgAssetInSpectionPlan.getMILEAGE(); + params[30]=pgAssetInSpectionPlan.getFREQUENCY_TIME(); + params[31]=pgAssetInSpectionPlan.getFREQUENCYTIME_END(); + params[32]=pgAssetInSpectionPlan.getKETTLE_TS(); + params[33]=pgAssetInSpectionPlan.getUPDATEDATE(); paramObjectList.add(params); } @@ -61,13 +77,13 @@ for (Object[] params:paramObjectList) { int count = runner.update(conn, insertStr, params); if (count > 0) - logger.debug("巡检数据同步成功" + pgAssetInSpectionList.toString()); + logger.info("巡检数据同步成功" + pgAssetInSpectionPlanList.toString()); else - logger.error("巡检数据同步失败！"); + logger.info("巡检数据同步失败！"); } } catch (Exception ex) { - logger.error("巡检数据同步异常", ex); + logger.info("巡检数据同步异常", ex); } finally { try { DbUtils.commitAndClose(conn); @@ -81,18 +97,18 @@ public String findLastRecordTime(){ Connection conn = null; - String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_RECORD ORDER BY ID DESC"; + String queryStr = "SELECT * FROM PG_ASSET_INSPECTION_PLAN ORDER BY UPDATEDATE DESC"; try { conn = ConnectionManager.getConnectionFromC3P0(); conn.setAutoCommit(false); QueryRunner runner = new QueryRunner(); - List pgAssetInSpectionList = (List) runner.query(conn, - queryStr, new BeanListHandler(PgAssetInSpection.class)); + List pgAssetInSpectionPlanList = (List) runner.query(conn, + queryStr, new BeanListHandler(PgAssetInSpectionPlan.class)); - if (null != pgAssetInSpectionList && pgAssetInSpectionList.isEmpty() == false) { - logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionList + "]"); - return pgAssetInSpectionList.get(0).getCREATE_DATE(); + if (null != pgAssetInSpectionPlanList && pgAssetInSpectionPlanList.isEmpty() == false) { + logger.debug("获取最新巡检记录成功[" + pgAssetInSpectionPlanList + "]"); + return pgAssetInSpectionPlanList.get(0).getUPDATEDATE(); } else return null; diff --git a/src/com/szpg/db/data/PgAssetInSpection.java b/src/com/szpg/db/data/PgAssetInSpection.java deleted file mode 100644 index e37da0a..0000000 --- a/src/com/szpg/db/data/PgAssetInSpection.java +++ /dev/null @@ -1,206 +0,0 @@ -package com.szpg.db.data; - -import java.io.Serializable; - -public class PgAssetInSpection implements Serializable { - - //private Long id; - private String problems; - private String finish; - private String KEY_ID;//巡检记录单id - private String PLAN_ID;//巡检计划ID - private String CREATE_DATE;//创建时间 - private String STATE;//巡检记录状态 - private String CREATOR;//创建人 - private String PLAN_NAME;//计划名称 - private String RECORD_NO;//记录单号 - private String PLAN_NO;//巡检计划编号 - private String RESPONSIBLE_DEPT;//负责单位部门小组 - private String INSPECTION_PERSON;//计划巡检人 - private String PATROL_MAN;//巡检人 - private String OPERATE_DATE;//计划巡检日期 - private String REMARK;//巡检记录 - private String BUILD_CABIN;//舱室 - private String PROJECT;//所属项目 - private String START_PILE_NO;//开始桩号 - private String END_PILE_NO;//结束桩号 - private String INSPECTION_PRACE;//巡检地点 - private String OTHER_PATROL_MAN;//其他巡检人 - private String rowNum; - - public String getProblems() { - return problems; - } - - public void setProblems(String problems) { - this.problems = problems; - } - - public String getFinish() { - return finish; - } - - public void setFinish(String finish) { - this.finish = finish; - } - - public String getKEY_ID() { - return KEY_ID; - } - - public void setKEY_ID(String KEY_ID) { - this.KEY_ID = KEY_ID; - } - - public String getPLAN_ID() { - return PLAN_ID; - } - - public void setPLAN_ID(String PLAN_ID) { - this.PLAN_ID = PLAN_ID; - } - - public String getCREATE_DATE() { - return CREATE_DATE; - } - - public void setCREATE_DATE(String CREATE_DATE) { - this.CREATE_DATE = CREATE_DATE; - } - - public String getSTATE() { - return STATE; - } - - public void setSTATE(String STATE) { - this.STATE = STATE; - } - - public String getCREATOR() { - return CREATOR; - } - - public void setCREATOR(String CREATOR) { - this.CREATOR = CREATOR; - } - - public String getPLAN_NAME() { - return PLAN_NAME; - } - - public void setPLAN_NAME(String PLAN_NAME) { - this.PLAN_NAME = PLAN_NAME; - } - - public String getRECORD_NO() { - return RECORD_NO; - } - - public void setRECORD_NO(String RECORD_NO) { - this.RECORD_NO = RECORD_NO; - } - - public String getPLAN_NO() { - return PLAN_NO; - } - - public void setPLAN_NO(String PLAN_NO) { - this.PLAN_NO = PLAN_NO; - } - - public String getRESPONSIBLE_DEPT() { - return RESPONSIBLE_DEPT; - } - - public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { - this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; - } - - public String getINSPECTION_PERSON() { - return INSPECTION_PERSON; - } - - public void setINSPECTION_PERSON(String INSPECTION_PERSON) { - this.INSPECTION_PERSON = INSPECTION_PERSON; - } - - public String getPATROL_MAN() { - return PATROL_MAN; - } - - public void setPATROL_MAN(String PATROL_MAN) { - this.PATROL_MAN = PATROL_MAN; - } - - public String getOPERATE_DATE() { - return OPERATE_DATE; - } - - public void setOPERATE_DATE(String OPERATE_DATE) { - this.OPERATE_DATE = OPERATE_DATE; - } - - public String getREMARK() { - return REMARK; - } - - public void setREMARK(String REMARK) { - this.REMARK = REMARK; - } - - public String getBUILD_CABIN() { - return BUILD_CABIN; - } - - public void setBUILD_CABIN(String BUILD_CABIN) { - this.BUILD_CABIN = BUILD_CABIN; - } - - public String getPROJECT() { - return PROJECT; - } - - public void setPROJECT(String PROJECT) { - this.PROJECT = PROJECT; - } - - public String getSTART_PILE_NO() { - return START_PILE_NO; - } - - public void setSTART_PILE_NO(String START_PILE_NO) { - this.START_PILE_NO = START_PILE_NO; - } - - public String getEND_PILE_NO() { - return END_PILE_NO; - } - - public void setEND_PILE_NO(String END_PILE_NO) { - this.END_PILE_NO = END_PILE_NO; - } - - public String getINSPECTION_PRACE() { - return INSPECTION_PRACE; - } - - public void setINSPECTION_PRACE(String INSPECTION_PRACE) { - this.INSPECTION_PRACE = INSPECTION_PRACE; - } - - public String getOTHER_PATROL_MAN() { - return OTHER_PATROL_MAN; - } - - public void setOTHER_PATROL_MAN(String OTHER_PATROL_MAN) { - this.OTHER_PATROL_MAN = OTHER_PATROL_MAN; - } - - public String getRowNum() { - return rowNum; - } - - public void setRowNum(String rowNum) { - this.rowNum = rowNum; - } -} \ No newline at end of file diff --git a/src/com/szpg/db/data/PgAssetInSpectionPlan.java b/src/com/szpg/db/data/PgAssetInSpectionPlan.java new file mode 100644 index 0000000..fd10c61 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetInSpectionPlan.java @@ -0,0 +1,316 @@ +package com.szpg.db.data; + +import java.io.Serializable; + +public class PgAssetInSpectionPlan implements Serializable { + + private String KEY_ID;//唯一键值 + private String PLAN_NAME;//巡检计划名称 + private String INSPECTION_PERSON;//巡检人 + private String START_DATE;//巡检开始时间 + private String END_DATE; + private String FREQUENCY;//巡检频率 + private String STATE;//状态 + private String RESPONSIBLE_DEPT;//负责单位/部门/小组 + private String PLAN_NO;//巡检计划编号 + private String INSPECTION_TYPE;//巡检类型 + private String INSPECTION_MODE;//巡检方式 + private String INSPECTION_ROUTE;//巡检路线 + private String INSPECTION_START_TIME;//巡检开始时间 + private String INSPECTION_END_TIME;//巡检结束时间 + private String INSPECTION_PRACE;//巡检地点 + private String INSPECTION_GROUP;//巡检部门 + private String INSERT_TIME;//插入时间 + private String FREQUENCYDATE;//巡检具体日期 + private String FREQUENCYTIME;//巡检具体时间 + private String CREATEDATE;//创建时间 + private String CREATOR;//创建人 + private String PROJECT;//项目 + private String COMLILE;//编制人 + private String START_TIME;//编制时间 + private String DEVELOP_DEPT;//制定部门 + private String END_TIME;//结束时间 + private String START_PILE_NO;//开始桩号 + private String END_PILE_NO;//结束桩号 + private String BUILD_CABIN;//巡检舱室 + private String MILEAGE; + private String FREQUENCY_TIME;//巡检具体时间 + private String FREQUENCYTIME_END; + private String KETTLE_TS; + private String UPDATEDATE; + + public String getKEY_ID() { + return KEY_ID; + } + + public void setKEY_ID(String KEY_ID) { + this.KEY_ID = KEY_ID; + } + + public String getPLAN_NAME() { + return PLAN_NAME; + } + + public void setPLAN_NAME(String PLAN_NAME) { + this.PLAN_NAME = PLAN_NAME; + } + + public String getINSPECTION_PERSON() { + return INSPECTION_PERSON; + } + + public void setINSPECTION_PERSON(String INSPECTION_PERSON) { + this.INSPECTION_PERSON = INSPECTION_PERSON; + } + + public String getSTART_DATE() { + return START_DATE; + } + + public void setSTART_DATE(String START_DATE) { + this.START_DATE = START_DATE; + } + + public String getEND_DATE() { + return END_DATE; + } + + public void setEND_DATE(String END_DATE) { + this.END_DATE = END_DATE; + } + + public String getFREQUENCY() { + return FREQUENCY; + } + + public void setFREQUENCY(String FREQUENCY) { + this.FREQUENCY = FREQUENCY; + } + + public String getSTATE() { + return STATE; + } + + public void setSTATE(String STATE) { + this.STATE = STATE; + } + + public String getRESPONSIBLE_DEPT() { + return RESPONSIBLE_DEPT; + } + + public void setRESPONSIBLE_DEPT(String RESPONSIBLE_DEPT) { + this.RESPONSIBLE_DEPT = RESPONSIBLE_DEPT; + } + + + public String getPLAN_NO() { + return PLAN_NO; + } + + public void setPLAN_NO(String PLAN_NO) { + this.PLAN_NO = PLAN_NO; + } + + public String getINSPECTION_TYPE() { + return INSPECTION_TYPE; + } + + public void setINSPECTION_TYPE(String INSPECTION_TYPE) { + this.INSPECTION_TYPE = INSPECTION_TYPE; + } + + public String getINSPECTION_MODE() { + return INSPECTION_MODE; + } + + public void setINSPECTION_MODE(String INSPECTION_MODE) { + this.INSPECTION_MODE = INSPECTION_MODE; + } + + public String getINSPECTION_ROUTE() { + return INSPECTION_ROUTE; + } + + public void setINSPECTION_ROUTE(String INSPECTION_ROUTE) { + this.INSPECTION_ROUTE = INSPECTION_ROUTE; + } + + public String getINSPECTION_START_TIME() { + return INSPECTION_START_TIME; + } + + public void setINSPECTION_START_TIME(String INSPECTION_START_TIME) { + this.INSPECTION_START_TIME = INSPECTION_START_TIME; + } + + public String getINSPECTION_END_TIME() { + return INSPECTION_END_TIME; + } + + public void setINSPECTION_END_TIME(String INSPECTION_END_TIME) { + this.INSPECTION_END_TIME = INSPECTION_END_TIME; + } + + public String getINSPECTION_PRACE() { + return INSPECTION_PRACE; + } + + public void setINSPECTION_PRACE(String INSPECTION_PRACE) { + this.INSPECTION_PRACE = INSPECTION_PRACE; + } + + public String getINSPECTION_GROUP() { + return INSPECTION_GROUP; + } + + public void setINSPECTION_GROUP(String INSPECTION_GROUP) { + this.INSPECTION_GROUP = INSPECTION_GROUP; + } + + public String getINSERT_TIME() { + return INSERT_TIME; + } + + public void setINSERT_TIME(String INSERT_TIME) { + this.INSERT_TIME = INSERT_TIME; + } + + public String getFREQUENCYDATE() { + return FREQUENCYDATE; + } + + public void setFREQUENCYDATE(String FREQUENCYDATE) { + this.FREQUENCYDATE = FREQUENCYDATE; + } + + public String getFREQUENCYTIME() { + return FREQUENCYTIME; + } + + public void setFREQUENCYTIME(String FREQUENCYTIME) { + this.FREQUENCYTIME = FREQUENCYTIME; + } + + public String getCREATEDATE() { + return CREATEDATE; + } + + public void setCREATEDATE(String CREATEDATE) { + this.CREATEDATE = CREATEDATE; + } + + public String getCREATOR() { + return CREATOR; + } + + public void setCREATOR(String CREATOR) { + this.CREATOR = CREATOR; + } + + public String getPROJECT() { + return PROJECT; + } + + public void setPROJECT(String PROJECT) { + this.PROJECT = PROJECT; + } + + public String getCOMLILE() { + return COMLILE; + } + + public void setCOMLILE(String COMLILE) { + this.COMLILE = COMLILE; + } + + public String getSTART_TIME() { + return START_TIME; + } + + public void setSTART_TIME(String START_TIME) { + this.START_TIME = START_TIME; + } + + public String getDEVELOP_DEPT() { + return DEVELOP_DEPT; + } + + public void setDEVELOP_DEPT(String DEVELOP_DEPT) { + this.DEVELOP_DEPT = DEVELOP_DEPT; + } + + public String getEND_TIME() { + return END_TIME; + } + + public void setEND_TIME(String END_TIME) { + this.END_TIME = END_TIME; + } + + public String getSTART_PILE_NO() { + return START_PILE_NO; + } + + public void setSTART_PILE_NO(String START_PILE_NO) { + this.START_PILE_NO = START_PILE_NO; + } + + public String getEND_PILE_NO() { + return END_PILE_NO; + } + + public void setEND_PILE_NO(String END_PILE_NO) { + this.END_PILE_NO = END_PILE_NO; + } + + public String getBUILD_CABIN() { + return BUILD_CABIN; + } + + public void setBUILD_CABIN(String BUILD_CABIN) { + this.BUILD_CABIN = BUILD_CABIN; + } + + public String getMILEAGE() { + return MILEAGE; + } + + public void setMILEAGE(String MILEAGE) { + this.MILEAGE = MILEAGE; + } + + public String getFREQUENCY_TIME() { + return FREQUENCY_TIME; + } + + public void setFREQUENCY_TIME(String FREQUENCY_TIME) { + this.FREQUENCY_TIME = FREQUENCY_TIME; + } + + public String getFREQUENCYTIME_END() { + return FREQUENCYTIME_END; + } + + public void setFREQUENCYTIME_END(String FREQUENCYTIME_END) { + this.FREQUENCYTIME_END = FREQUENCYTIME_END; + } + + public String getKETTLE_TS() { + return KETTLE_TS; + } + + public void setKETTLE_TS(String KETTLE_TS) { + this.KETTLE_TS = KETTLE_TS; + } + + public String getUPDATEDATE() { + return UPDATEDATE; + } + + public void setUPDATEDATE(String UPDATEDATE) { + this.UPDATEDATE = UPDATEDATE; + } + + +} diff --git a/src/com/szpg/db/data/PgAssetJson.java b/src/com/szpg/db/data/PgAssetJson.java deleted file mode 100644 index b5d6dd6..0000000 --- a/src/com/szpg/db/data/PgAssetJson.java +++ /dev/null @@ -1,53 +0,0 @@ -package com.szpg.db.data; - -import java.util.List; - -public class PgAssetJson { - - private String total; - private String totalRecords; - private String page; - private String records; - private List rows; - - public String getTotal() { - return total; - } - - public void setTotal(String total) { - this.total = total; - } - - public String getTotalRecords() { - return totalRecords; - } - - public void setTotalRecords(String totalRecords) { - this.totalRecords = totalRecords; - } - - public String getPage() { - return page; - } - - public void setPage(String page) { - this.page = page; - } - - public String getRecords() { - return records; - } - - public void setRecords(String records) { - this.records = records; - } - - public List getRows() { - return rows; - } - - public void setRows(List rows) { - this.rows = rows; - } - -} diff --git a/src/com/szpg/db/data/PgAssetPlanJson.java b/src/com/szpg/db/data/PgAssetPlanJson.java new file mode 100644 index 0000000..80f25b3 --- /dev/null +++ b/src/com/szpg/db/data/PgAssetPlanJson.java @@ -0,0 +1,53 @@ +package com.szpg.db.data; + +import java.util.List; + +public class PgAssetPlanJson { + + private String total; + private String totalRecords; + private String page; + private String records; + private List rows; + + public String getTotal() { + return total; + } + + public void setTotal(String total) { + this.total = total; + } + + public String getTotalRecords() { + return totalRecords; + } + + public void setTotalRecords(String totalRecords) { + this.totalRecords = totalRecords; + } + + public String getPage() { + return page; + } + + public void setPage(String page) { + this.page = page; + } + + public String getRecords() { + return records; + } + + public void setRecords(String records) { + this.records = records; + } + + public List getRows() { + return rows; + } + + public void setRows(List rows) { + this.rows = rows; + } + +} diff --git a/src/com/szpg/plc/PGDSCServlet.java b/src/com/szpg/plc/PGDSCServlet.java index 26b49d0..4c57137 100644 --- a/src/com/szpg/plc/PGDSCServlet.java +++ b/src/com/szpg/plc/PGDSCServlet.java @@ -105,7 +105,7 @@ synchAssetInSpection(); //运维数据同步 - synchMaintanceRecord(); + //synchMaintanceRecord(); } /** @@ -269,7 +269,7 @@ */ private void synchAssetInSpection() { ScheduledExecutorService sche = new ScheduledThreadPoolExecutor(1); - sche.scheduleWithFixedDelay(new ReadAssetInSpectionTask(), 60, 600, TimeUnit.SECONDS); + sche.scheduleWithFixedDelay(new ReadAssetInSpectionTask(), 60, 60*60*24, TimeUnit.SECONDS); } /** diff --git a/src/com/szpg/task/ReadAssetInSpectionTask.java b/src/com/szpg/task/ReadAssetInSpectionTask.java index 1389e0d..a95a28a 100644 --- a/src/com/szpg/task/ReadAssetInSpectionTask.java +++ b/src/com/szpg/task/ReadAssetInSpectionTask.java @@ -1,12 +1,15 @@ package com.szpg.task; import com.alibaba.fastjson.JSON; +import com.alibaba.fastjson.JSONObject; import com.alibaba.fastjson.TypeReference; import com.szpg.db.dao.PgAssetInSpectionDao; import com.szpg.db.dao.impl.PgAssetInSpectionImpl; -import com.szpg.db.data.PgAssetInSpection; -import com.szpg.db.data.PgAssetJson; +import com.szpg.db.data.PgAssetInSpectionPlan; +import com.szpg.db.data.PgAssetPlanJson; +import com.szpg.test; import com.szpg.util.HttpRequest; +import org.apache.log4j.Logger; import java.io.FileWriter; import java.io.IOException; @@ -14,13 +17,12 @@ import java.util.Calendar; import java.util.Date; import java.util.List; -import java.util.logging.Logger; public class ReadAssetInSpectionTask implements Runnable{ - private final Logger logger = Logger.getLogger(this.getClass().getName()); - final String tableName="V_ASSET_INSPECTION_RECORD"; + private org.apache.log4j.Logger logger = Logger.getLogger(this.getClass().getName()); + final String tableName="ASSET_INSPECTION_PLAN"; final String url="http://10.10.2.31:9056/GLYW/api/Common/LoadIndexData"; - SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd HH:mm:ss"); + SimpleDateFormat dateFormat = new SimpleDateFormat("yyyy-MM-dd"); @Override public void run(){ @@ -33,30 +35,30 @@ startTime=getYestodayStr(); StringBuilder sb = new StringBuilder(); - sb.append("tableName = ").append(tableName); + sb.append("tableName=").append(tableName); sb.append("&page=-1"); - sb.append("&CREATE_DATE=采集时间"); + sb.append("&strWhere= UPDATEDATE"); sb.append(" between '").append(startTime); sb.append("' and '").append(endTime); sb.append("'"); logger.info("开始请求巡检数据"); String jsonStr = HttpRequest.sendPostByHttp(url, sb.toString()); - saveAsFileWriter(jsonStr); if (jsonStr.equals("")) - logger.info("巡检数据请求失败"); + logger.error("巡检数据请求失败"); else { + saveAsFileWriter(jsonStr,"d:\\test.txt"); insertDB(pgAssetInSpectionDao, jsonStr); - logger.info("巡检数据存储成功"); + logger.error("巡检数据存储成功"); } + } - private String savefile = "D:\\test.txt"; - private void saveAsFileWriter(String content) { + private void saveAsFileWriter(String content,String filePath) { FileWriter fwriter = null; try { - fwriter = new FileWriter(savefile); + fwriter = new FileWriter(filePath); fwriter.write(content); } catch (IOException ex) { ex.printStackTrace(); @@ -72,14 +74,23 @@ public void insertDB(PgAssetInSpectionDao pgAssetInSpectionDao,String jsonStr) { - List pgAssetInSpectionList= getAssetByJsonString(jsonStr); - pgAssetInSpectionDao.addAssetInSpectionRecord(pgAssetInSpectionList); + List pgAssetInSpectionPlanList= getAssetByJsonString(jsonStr); + logger.info("同步巡检数据条数："+ String.valueOf(pgAssetInSpectionPlanList.size())); + pgAssetInSpectionDao.addAssetInSpectionPlan(pgAssetInSpectionPlanList); } - private List getAssetByJsonString(String jsonStr){ - PgAssetJson pgAssetJson = JSON.parseObject(jsonStr, new TypeReference() {}); - List pgAssetInSpectionList=pgAssetJson.getRows(); - return pgAssetInSpectionList; + private List getAssetByJsonString(String jsonStr){ + try { + String jsonString=String.valueOf(JSON.parse(jsonStr)); + PgAssetPlanJson pgAssetPlanJson = JSONObject.parseObject(jsonString, new TypeReference() {}); + List pgAssetInSpectionPlanList = pgAssetPlanJson.getRows(); + return pgAssetInSpectionPlanList; + } + catch(Exception ex){ + logger.error(ex.getMessage()); + return null; + } + } public String getYestodayStr() { @@ -93,4 +104,5 @@ return yesToday; } + } \ No newline at end of file diff --git a/src/com/szpg/test.java b/src/com/szpg/test.java new file mode 100644 index 0000000..456811b --- /dev/null +++ b/src/com/szpg/test.java @@ -0,0 +1,7 @@ +package com.szpg; + +public class test { + +public static String jsonsss= "{\"total\": 1,\"totalRecords\":44,\"page\":1,\"records\":44,\"rows\":[{\"KEY_ID\":\"070b018c-d1df-4d1e-a9e7-e07beda4eec2\",\"PLAN_NAME\":\"澄阳路内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":0,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1231094724\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"澄阳路综合管廊\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"liujun \",\"PROJECT\":\"CYL\",\"COMLILE\":\"刘俊\",\"START_TIME\":\"2019-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":\",D,Z\",\"MILEAGE\":3200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-30 14:25:20.400\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"09bd1be6-522c-4ba7-a7b3-14d406f67e1d\",\"PLAN_NAME\":\"城北路外部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0718180718\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-18\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-01-01\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"0efa578f-3d5e-4b31-a33c-424d6677ef20\",\"PLAN_NAME\":\"城北路支线管廊内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-11-13\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":0,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1113100200\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-11-13\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wuping\",\"PROJECT\":\"CBL\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K0+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":0,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"1218b06e-5bef-4053-9fdb-92caedc8fa35\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划-10KV段\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1220101000\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"龙翔路东太湖路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"22:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K2+000\",\"END_PILE_NO\":\"K3+000\",\"BUILD_CABIN\":\",Z\",\"MILEAGE\":1000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"1705d816-603e-451a-a2b2-1dce3a57d512\",\"PLAN_NAME\":\"澄阳路内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0702122603\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-02\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"caokai\",\"PROJECT\":\"CYL\",\"COMLILE\":\"曹恺\",\"START_TIME\":\"2018-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":null,\"MILEAGE\":3200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"213E2132-E6C3-4616-9AC1-EE80A912FB38\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-10-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0810161146\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"东太湖路旺山路龙翔路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-10\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K6+000\",\"BUILD_CABIN\":\",D,Q,R\",\"MILEAGE\":6000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"246da140-3b01-4fff-af31-5e6864e7c545\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-09-30\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0831103857\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"君益路橘林街挹紫街景周街\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"liangqingsong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K5+000\",\"BUILD_CABIN\":\",D,S,Z\",\"MILEAGE\":5000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"26110153-FAE6-43D7-83EB-ADD51BDB7ED4\",\"PLAN_NAME\":\"给排水设备每周巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820102846\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Tue\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"2DC83287-4E85-4289-BA35-72BB62276270\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划-东太湖路\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0719170252\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"东太湖路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-19\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K2+712\",\"BUILD_CABIN\":\",D,Z\",\"MILEAGE\":2712,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"3E88F473-AA5E-4993-B088-950530017A38\",\"PLAN_NAME\":\"给排水设备每周巡检计划C\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820103357\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Wed\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"3f405d31-1080-4131-a9c8-5bfee481bce4\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1220095739\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"君益路挹紫街橘林街景周街\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K5+000\",\"BUILD_CABIN\":\",D,S\",\"MILEAGE\":5000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"4594572b-122f-4606-a3b5-679a392d50be\",\"PLAN_NAME\":\"澄阳路夜间内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":0,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1231100223\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"澄阳路综合管廊全标段\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"liujun \",\"PROJECT\":\"CYL\",\"COMLILE\":\"刘俊\",\"START_TIME\":\"2019-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":\",D,Z\",\"MILEAGE\":3200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"473ad326-edae-40e8-9f07-dddd76285dd5\",\"PLAN_NAME\":\"澄阳路内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0101212459\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"澄阳路管廊\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2019-01-01\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"jixiaodong\",\"PROJECT\":\"CYL\",\"COMLILE\":\"季晓冬\",\"START_TIME\":\"2019-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":\",D,S\",\"MILEAGE\":3200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"4a3c19b7-a08b-43be-b8c7-f35843675f02\",\"PLAN_NAME\":\"澄阳路夜间内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-08-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0813180832\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-13\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"caokai\",\"PROJECT\":\"CYL\",\"COMLILE\":\"曹恺\",\"START_TIME\":\"2018-08-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+975\",\"BUILD_CABIN\":\",D,S\",\"MILEAGE\":3975,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"4b21a9d8-b7ce-4338-8f72-16515c67fb4b\",\"PLAN_NAME\":\"澄阳路外部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0702121923\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-02\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"caokai\",\"PROJECT\":\"CYL\",\"COMLILE\":\"曹恺\",\"START_TIME\":\"2018-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K10+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":1000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"536ab452-7c55-4e8d-9f6b-d4758f5a8e3b\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-09-30\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0831102623\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"东太湖路旺山路龙翔路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"liangqingsong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K6+000\",\"BUILD_CABIN\":\",D,Q,R\",\"MILEAGE\":6000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"57924e6a-7e36-4599-a08d-2efa346f483d\",\"PLAN_NAME\":\"吴中太湖新城外部巡检计划\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0719095756\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"一，二期全段\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-19\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"jiejianwei\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K11+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":11200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"66FA512B-4EDF-441F-B6EE-ED41816DB0A1\",\"PLAN_NAME\":\"给排水设备巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820101658\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"7367C280-9554-4B30-ADE8-700EF48DB448\",\"PLAN_NAME\":\"通风空调设备每周巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820103858\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Mon\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"80134557-f4da-4fb7-90f0-14e0fdc8f423\",\"PLAN_NAME\":\"澄阳路夜间内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0101211354\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"澄阳路管廊\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2019-01-01\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"jixiaodong\",\"PROJECT\":\"CYL\",\"COMLILE\":\"季晓冬\",\"START_TIME\":\"2019-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":\",D,S\",\"MILEAGE\":3200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"82044C49-4B74-45BC-A71E-2A54AD13E832\",\"PLAN_NAME\":\"通风空调设备每周巡检计划C\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820104519\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Wed\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"82BED482-BDD0-441A-8D41-47CF1F058B87\",\"PLAN_NAME\":\"通风空调设备每日（空调季）巡检计划\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-10-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820104739\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K0+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":0,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"83876f36-5488-4f5a-95be-7ade5166f733\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1220101924\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"东太湖路旺山路龙翔路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K6+000\",\"BUILD_CABIN\":\",D,Q\",\"MILEAGE\":6000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"883875c1-a95b-49d5-bb38-fe2f8d505e7b\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划-龙翔路\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0719165536\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"龙翔路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-19\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K1+964\",\"BUILD_CABIN\":\",D,Q,R,Z\",\"MILEAGE\":1964,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"92945c1a-8ce8-4fc9-a728-d460c9828523\",\"PLAN_NAME\":\"澄阳路外部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":0,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1231093945\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"澄阳路综合管廊\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"liujun \",\"PROJECT\":\"CYL\",\"COMLILE\":\"刘俊\",\"START_TIME\":\"2019-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":\"\",\"MILEAGE\":3200,\"FREQUENCY_TIME\":3,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"9604D46E-8C57-415A-BF45-E5CF8A854977\",\"PLAN_NAME\":\"通风空调设备每周巡检计划D\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820104612\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Thur\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"9939C903-96F8-44C4-A1DF-1AE1497987E7\",\"PLAN_NAME\":\"低压供电设备巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820092241\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"99E27090-73AD-4CD9-9BED-320E20B42DE4\",\"PLAN_NAME\":\"给排水设备每周巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820101316\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Mon\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"a224397e-2e23-4bde-9986-d23e3be91097\",\"PLAN_NAME\":\"城北路内部巡检B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0718180115\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-18\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-01-01\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"A89A3385-60B1-496B-A53C-208E5DEDAC30\",\"PLAN_NAME\":\"城北路内部巡检A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0719092904\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-19\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-01-01\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"aeca090e-980a-43cc-a67e-5f72092d4a34\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划A\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-10-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0810155231\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"君益路橘林街挹紫街景周街\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-10\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K5+000\",\"BUILD_CABIN\":\",D,S,Z\",\"MILEAGE\":5000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"AF0B73D6-4323-43FC-AFAD-8EBF8F0952B8\",\"PLAN_NAME\":\"给排水设备每周巡检计划D\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820103527\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Thur\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"b11207b5-aabf-4e8d-b03c-c51eba547f3a\",\"PLAN_NAME\":\"澄阳路外部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0101211126\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"澄阳路管廊\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2019-01-01\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"jixiaodong\",\"PROJECT\":\"CYL\",\"COMLILE\":\"季晓冬\",\"START_TIME\":\"2019-01-01\",\"DEVELOP_DEPT\":\"澄阳路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+200\",\"BUILD_CABIN\":\"\",\"MILEAGE\":3200,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"b6b021ff-f99c-44eb-bf1f-837acead612d\",\"PLAN_NAME\":\"示范段内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-07-02\",\"END_DATE\":\"2018-07-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0702150733\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-02\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-07-02\",\"DEVELOP_DEPT\":\"城北路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K3+855\",\"END_PILE_NO\":\"K4+980\",\"BUILD_CABIN\":\"\",\"MILEAGE\":1125,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"B6D92CE6-5C61-437A-8C0F-08E285EF8D34\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划-景周街\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-01-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0719170506\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"景周街\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-07-19\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K3+275\",\"BUILD_CABIN\":\",D,Z\",\"MILEAGE\":3275,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"bce7c1cb-9b55-4e34-ba36-eac94dd4c4a0\",\"PLAN_NAME\":\"城北路外部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1231090635\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-12-31\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+075\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":7925,\"FREQUENCY_TIME\":2,\"FREQUENCYTIME_END\":\"12:30\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"BE487759-DF69-4CC4-90C3-F6BDA27A8BCD\",\"PLAN_NAME\":\"通风空调设备每周巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"1\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820104434\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"Tue\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"c8278310-bb79-4fa4-9f36-41dc2ac0decb\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划-10KV段\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-10-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0810161721\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"龙翔路东太湖路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-10\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"22:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K2+000\",\"END_PILE_NO\":\"K3+000\",\"BUILD_CABIN\":\",Z\",\"MILEAGE\":1000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"C8919911-2149-410C-82BF-6E46E3C37CCE\",\"PLAN_NAME\":\"给排水设备巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820102309\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"c97d413c-5d76-4598-a3ff-dd74fdaef398\",\"PLAN_NAME\":\"城北路内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-03-09\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0304134817\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2019-03-04\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:30\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2019-03-04\",\"DEVELOP_DEPT\":\"城北路项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+075\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":7925,\"FREQUENCY_TIME\":2,\"FREQUENCYTIME_END\":\"20:30\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"cf7d3cc9-35cc-4723-acc3-e499abc8fc63\",\"PLAN_NAME\":\"低压供电设备巡检计划B\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-12-31\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0820091100\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"09:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-08-20\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":8000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"d7f1ee70-0bf0-444b-afc2-b26103d930c1\",\"PLAN_NAME\":\"吴中太湖新城内部巡检计划-10kv段\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2018-09-01\",\"END_DATE\":\"2018-09-30\",\"FREQUENCY\":\"0\",\"STATE\":2,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P0831102236\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"龙翔路东太湖路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-08-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"22:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"liangqingsong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K2+000\",\"END_PILE_NO\":\"K3+000\",\"BUILD_CABIN\":\",Z\",\"MILEAGE\":1000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":null,\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"dc250bc4-ed97-485d-8484-8f21d90fdd25\",\"PLAN_NAME\":\"城北路内部巡检\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1231090126\",\"INSPECTION_TYPE\":\"1\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"城北路\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-31\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:00\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"sundoudou\",\"PROJECT\":\"CBL\",\"COMLILE\":\"孙豆豆\",\"START_TIME\":\"2018-12-31\",\"DEVELOP_DEPT\":\"运维项目部\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+075\",\"END_PILE_NO\":\"K8+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":7925,\"FREQUENCY_TIME\":2,\"FREQUENCYTIME_END\":\"08:10\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"},{\"KEY_ID\":\"eec1cfe8-e3f2-40d8-8f85-4e1395c5e79b\",\"PLAN_NAME\":\"吴中太湖新城外部巡检计划\",\"INSPECTION_PERSON\":null,\"START_DATE\":\"2019-01-01\",\"END_DATE\":\"2019-12-31\",\"FREQUENCY\":\"0\",\"STATE\":1,\"RESPONSIBLE_DEPT\":null,\"PLAN_NO\":\"P1220101516\",\"INSPECTION_TYPE\":\"2\",\"INSPECTION_MODE\":null,\"INSPECTION_ROUTE\":null,\"INSPECTION_START_TIME\":null,\"INSPECTION_END_TIME\":null,\"INSPECTION_PRACE\":\"一，二期全段\",\"INSPECTION_GROUP\":null,\"INSERT_TIME\":\"2018-12-20\",\"FREQUENCYDATE\":\"\",\"FREQUENCYTIME\":\"08:45\",\"CREATEDATE\":\"2019-04-28\",\"CREATOR\":\"wudong\",\"PROJECT\":\"THXC\",\"COMLILE\":\"\",\"START_TIME\":null,\"DEVELOP_DEPT\":\"\",\"END_TIME\":null,\"START_PILE_NO\":\"K0+000\",\"END_PILE_NO\":\"K11+000\",\"BUILD_CABIN\":\"\",\"MILEAGE\":11000,\"FREQUENCY_TIME\":1,\"FREQUENCYTIME_END\":\"\",\"KETTLE_TS\":\"2019-04-29 14:25:20.397\",\"UPDATEDATE\":\"2019-05-21\"}]}" + ; +}