帆软报表相关操作

1.条件语句的添加

SELECT * FROM [dbo].[t_MesCheckLog] 
where mesBtnStation='False' and oid!='003976' 
${if(len(meterId) == 0,"","and meterId = '"+meterId+"'")}
${if(len(date1) == 0,"","and processDate >= '"+date1+"'")}
${if(len(date2) == 0,"","and processDate <= '"+date2+"'")}
order by processDate