[阅读: 559] 2006-04-17 10:52:03
String QuerySQL = " select (TJ.ayfz-JB.dykhsx)/JB.dykhsx,(TJ.aygz-JB.dykhxx)/JB.dykhxx ,"
+"(TJ.byfz-JB.dykhsx)/JB.dykhsx,(TJ.bygz-JB.dykhxx)/JB.dykhxx,"
+"(TJ.cyfz-JB.dykhsx)/JB.dykhsx,(TJ.cygz-JB.dykhxx)/JB.dykhxx"
+" from Customer YH, TerminalCapital ZC, VoltageUp2gradeRateDetail TJ,BasicVoltageLevel JB"
+" where YH.yhid=ZC.yhid and"
+" ZC.zdljdz=TJ.zdljdz and"
+" JB.jzz=YH.gddy and"
+" trunc(TJ.rq,'mm')=to_date('"+monthValue.getMonth()+"','yyyy-mm')"
+" and YH.yhid='"
+ userId
+ "'";