/** * Paging query Power Generation assessment longitudinal historical comparison data * * @param condition * @param currentpage * @param pageSize * @return/public Re Sultinfo getallenergymeasuredsummarydatalist (energyexpectedsummarydata condition, int currentpage, int pageSize) {S
Tring sql = null;
pagination<energyexpectedsummarydata> pagination = null; if (condition.getperiodtype () = = 1) {//mysql/*sql = ' Select C.updatetime updatetime, B.yearnum,b.monthnum,b.daynum , "+" round (a.datavalue,2) realdatavalue,round (b.datavalue,2) DataValue, "+" round (c.datavalue,2) deviationdata
Value from Tenergyexpectedsummarydata B "+" left JOIN tenergymeasuredsummarydata A on A.stationid=b.stationid " + "and A.turbineid=b.turbineid and A.yearnum=b.yearnum and A.monthnum=b.monthnum" + "and A.daynum=b.daynum and A.ti Mestamp=b.timestamp "+" left join Tbiasstat C "+" on B.yearnum=c.yearnum and B.monthnum=c.monthnum and B.daynu m = c.daynum "+" and A.timestamp=b.timestamp and C.statItemID = 3 "+" LEFT join Tbiasstatitem D "+" on c.statitemid=d.statitemid and B.stationid = D.stationid " + "and B.schemeid = D.schemeid and B.turbineid = D.parentid and d.typeid=2" + "and d.biastypeid=1 and d.elementid= 3 and c.periodtype= "+ condition.getperiodtype () +" "+" where b.stationid=? and b.turbineid=? and b.schemeid=?
and b.daynum<>0 and b.timestamp>? " + "and b.timestamp<?
ORDER BY B.timestamp "; * *//sqlserver/*sql =" Select C.updatetime updatetime, B.yearnum,b.monthnum,b.daynum, " + "Round (a.datavalue,2) realdatavalue,round (b.datavalue,2) DataValue," + "round (c.datavalue,2) Deviationdatavalue fro M tenergyexpectedsummarydata B "+" left JOIN tenergymeasuredsummarydata A on A.stationid=b.stationid "+" and a . Turbineid=b.turbineid and A.yearnum=b.yearnum and A.monthnum=b.monthnum "+" and A.daynum=b.daynum and A.timestamp=b . Timestamp "+" left join Tbiasstat C "+" on B.yearnum=c.yearnum and b.monthnum=c.monthnum and B.daynum = C.daynum "+" and a.timestamp=b.timestamp and C.statitemid = 3 "+" le FT Join Tbiasstatitem D "+" on c.statitemid=d.statitemid and B.stationid = D.stationid "+" and B.schemeid = d . SchemeId and B.turbineid = D.parentid and d.typeid=2 "+" and d.biastypeid=1 and d.elementid=3 "+ Condition.getperiodtype () + "" + "where b.stationid=" + condition.getstationid () + "" + "and b.turbineid=" + C Ondition.getturbineid () + "" + "and b.schemeid=" + condition.getschemeid () + "and b.daynum<>0" + "and B.timestamp> ' "+ condition.getquerystartdata () +" ' "+" and b.timestamp< ' "+ condition.getqueryenddata () +" ' ORDER BY B.timestamp "; */sql =" Select C.updatetime updatetime, B.yearnum,b.monthnum,b.daynum, "+" round (A.datav alue,2) Realdatavalue,round (b.datavalue,2) DataValue, "+" round (c.datavalue,2) Deviationdatavalue from TEnergyExpecte Dsummarydata B "+"Left JOIN tenergymeasuredsummarydata a" A.stationid=b.stationid "+" and A.turbineid=b.turbineid and A.yearnum=b.y Earnum and A.monthnum=b.monthnum "+" and A.daynum=b.daynum and A.timestamp=b.timestamp "+" left join Tbiasstat C "+" on B.yearnum=c.yearnum and b.monthnum=c.monthnum and B.daynum = C.daynum "+" and A.timestamp=b.timestam P and C.statitemid = 3 "+" LEFT join Tbiasstatitem D "+" on c.statitemid=d.statitemid and B.stationid = D.sta Tionid "+" and B.schemeid = D.schemeid and B.turbineid = D.parentid and d.typeid=2 "+" and d.biastypeid=1 and D.elementid=3 and c.periodtype=? "+" where b.stationid=? and b.turbineid=? and b.schemeid=? and b.daynum<>0 "+" and b.timestamp>=to_date (?, ' Yyyy-mm-dd HH24:MI:SS ') "+" and B.timestamp<to_dat
E (?, ' Yyyy-mm-dd HH24:MI:SS ') Order by B.timestamp "; pagination = new pagination<energyexpectedsummarydata> (sql, CurrentPage, pageSize, JdbcTemplate, nEW daorowmapper<energyexpectedsummarydata> (Energyexpectedsummarydata.class), new OBJECT[]{CONDITION.G Etperiodtype (), Condition.getstationid (), Condition.getturbineid (), Condition.getschemeid (),
Condition.getquerystartdata (), Condition.getqueryenddata ()}); else if (condition.getperiodtype () = = 2) {//mysql/*sql = ' Select C.updatetime updatetime, b.yearnum,b.monthnum,b . Daynum, "+" round (a.datavalue,2) realdatavalue,round (b.datavalue,2) DataValue, "+" round (c.datavalue,2) Deviat Iondatavalue from Tenergyexpectedsummarydata B "+" left JOIN tenergymeasuredsummarydata A on A.stationid=b.stationid "+" and A.turbineid=b.turbineid and A.yearnum=b.yearnum and A.monthnum=b.monthnum "+" and a.daynum=b.daynum A nd A.timestamp=b.timestamp LEFT Join Tbiasstat C "+" on B.yearnum=c.yearnum and b.monthnum=c.monthnum and b.daynum =
C.daynum "+" and a.timestamp=b.timestamp and C.statitemid = 3 left join Tbiasstatitem D "+ "on c.statitemid=d.statitemid and B.stationid = D.stationid" + "and B.schemeid = D.schemeid and B.turbineid = D.P
Arentid and d.typeid=2 "+" and d.biastypeid=1 and d.elementid=3 and c.periodtype=? " + "Where B.stationid =?" and b.turbineid=? and b.schemeid=? and b.daynum=0 "+" and b.timestamp>? and b.timestamp<?
ORDER BY B.timestamp "; * *//sql Server/*sql =" Select C.updatetime updatetime, B.yearnum,b.monthnum,b.daynum, " + "Round (a.datavalue,2) realdatavalue,round (b.datavalue,2) DataValue," + "round (c.datavalue,2) Deviationdatavalue fr Om tenergyexpectedsummarydata B "+" left JOIN tenergymeasuredsummarydata A on A.stationid=b.stationid "+" and A.turbineid=b.turbineid and A.yearnum=b.yearnum and A.monthnum=b.monthnum "+" and A.daynum=b.daynum and a.timestamp=
B.timestamp left Join Tbiasstat C "+" on B.yearnum=c.yearnum and b.monthnum=c.monthnum and b.daynum = C.daynum " + "and A.timestamp=b.timestamp and C.staTitemid = 3 LEFT join Tbiasstatitem D "+" on c.statitemid=d.statitemid and B.stationid = D.stationid "+" and B.schemeid = D.schemeid and B.turbineid = D.parentid and d.typeid=2 "+" and d.biastypeid=1 and D.elementid=3 and C. Periodtype= "+ condition.getperiodtype () +" "+" where B.stationid = "+ Condition.getstationid () +" "+" and
B.turbineid= "+ condition.getturbineid () +" "+" and b.schemeid= "+ condition.getschemeid () +" and b.daynum=0 " + "and b.timestamp> '" + condition.getquerystartdata () + "'" + "and b.timestamp< '" + Condition.getqueryendda TA () + "' ORDER by B.timestamp"; * * sql = "Select C.updatetime updatetime, B.yearnum,b.monthnum,b.daynum," + "Roun D (a.datavalue,2) Realdatavalue,round (b.datavalue,2) DataValue, "+" round (c.datavalue,2) Deviationdatavalue from TEner Gyexpectedsummarydata B "+" left JOIN tenergymeasuredsummarydata A on A.stationid=b.stationid "+" and A.turbin Eid=b.turbineid and A.yeArnum=b.yearnum and A.monthnum=b.monthnum "+" and A.daynum=b.daynum and A.timestamp=b.timestamp left join TBiasStat C "+" on B.yearnum=c.yearnum and b.monthnum=c.monthnum and B.daynum = C.daynum "+" and A.timestamp=b.timestamp
and C.statitemid = 3 left join Tbiasstatitem D "+" on c.statitemid=d.statitemid and B.stationid = D.stationid " + "and B.schemeid = D.schemeid and B.turbineid = D.parentid and d.typeid=2" + "and d.biastypeid=1 and D.element Id=3 and c.periodtype=? "+" where B.stationid =? and b.turbineid=? and b.schemeid=? and b.daynum=0 "+" and b.timestamp>=to_date (?, ' Yyyy-mm-dd HH24:MI:SS ') "+" and b.timestamp<to_date (?, ' YY
YY-MM-DD HH24:MI:SS ') Order by B.timestamp "; pagination = new pagination<energyexpectedsummarydata> (sql, CurrentPage, pageSize, JdbcTemplate, new DAORo Wmapper<energyexpectedsummarydata> (Energyexpectedsummarydata.class), New Object[]{condition.getperiodtype ( ), ConditioN.getstationid (), Condition.getturbineid (), Condition.getschemeid (), Condition.getquerystartdata (),
Condition.getqueryenddata ()});
} pagination.query ();
Resultinfo ri = new Resultinfo (true);
Ri.settotal (Pagination.gettotalrows ());
Ri.setrows (Pagination.getresultlist ());
Return RI; }