|
发表于 2014-5-6 10:13:30
|
显示全部楼层
public static Table pzwtcscx(String tbyear,String tbmonth){
String mssql = "select AO_YYFX.fWTLX as fWTLX,AO_YYFX.fWTZL as fWTZL,AO_YYFX.fZRBM as fZRBM,AO_YYFX.fZRGW as fZRGW,AO_YYFX.fZRR as fZRR,AO_WTK.fWTBH as fWTBH,AO_WTK.fTBRQ as fTBRQ,AO_WTK.fDDH as fDDH,AO_WTK.fKHBH as fKHBH,AO_WTK.fBPBH as fBPBH,AO_WTK.fBPMC as fBPMC,AO_WTK.fCPBH as fCPBH,AO_WTK.fCPMC as fCPMC,AO_YYFX.fYZCD as fYZCD,(getYear(AO_WTK.fTBRQ)) as tbyear,(getMonth(AO_WTK.fTBRQ)) as tbmonth from AO_YYFX AO_YYFX optional join AO_WTK AO_WTK on AO_YYFX.fMasterID = AO_WTK";
mssql += " WHERE 1=1 ";
if(!"".equals(tbyear)){
mssql += "and getYear(AO_WTK.fTBRQ) = +tbyear;
}
if(!"".equals(tbmonth)){
mssql += " AND getMonth(AO_WTK.fTBRQ) = +tbmonth";
}
return KSQL.select(mssql ,null,"/AOZESYSTEM/pzwtgl/data",null);
}
这样就可以,不用楼上发的那么复杂 |
|