[阅读: 418] 2006-04-14 08:54:48
String QuerySQL = " select (TJ.AYFZ-JB.DYKHSX)/JB.DYKHSX asrate,(TJ.AYGZ-JB.DYKHXX)/JB.DYKHXX axrate,"
+"(TJ.BYFZ-JB.DYKHSX)/JB.DYKHSX bsrate,(TJ.BYGZ-JB.DYKHXX)/JB.DYKHXX bxrate,"
+"(TJ.CYFZ-JB.DYKHSX)/JB.DYKHSX csrate,(TJ.CYGZ-JB.DYKHXX)/JB.DYKHXX cxrate"
+"from YH_YH YH, ZC_ZDZC ZC, TJ_DYHGLRMX TJ,JB_DYDJ JB"
+"where YH.YHID=ZC.YHID and"
+"ZC.ZDLJDZ=TJ.ZDLJDZ and "
+"JB.JZZ=YH.GDDY and "
+"trunc(TJ.RQ,'mm')=to_date('voltageLimiteValue.getMonth()','yyyy-mm')"
+ " and yh.yhid='"
+ userId
+ "'";