线路突增突减 - 0409 - 副本.cpt
不选择查询条件时,显示全部。选择参数p1时,显示该单位所有时间的结果;选择p1和p2时,显示该单位某一天的结果。
and呢??
where 1=1 ${if(len(p1)=0,"","and orgName = '"+p1+"'")}
${if(len(p2)=0,"","and statdate >= '"+DATEDELTA(p2,-1)+"' and statdate <= '"+p2+"'")}
where 1=1${if(len(p1)==0,"","and orgName='"+p1+"'")}${if(len(p2)==0,"","and statDate>=datedelta('"+p2+"',-1) and statDate<='"+p2+"'")}
where 1=1${if(len(p1)==0,"","and orgName='"+p1+"'")}${if(len(p2)==0,"","and statDate>=datedelta('"+p2+"',-1)and statDate<='"+p2+"'")}
这样应该没有问题啊