第一个报表 以前能正常使用 现在突然报错 第二个报表 最近多加了两列 点击报表什么反应都没了 也没弹错误 sql语句如下： SELECT a.CAR_NO AS CAR_NO, DATE_FORMAT(a.IN_TIME,'%Y-%m-%d %h:%m:%s') AS IN_TIME, DATE_FORMAT(a.OUT_TIME,'%Y-%m-%d %h:%m:%s') AS OUT_TIME, a.COURT_CODE AS COURT_CODE, a.PARKING_FEE AS PARKING_FEE, a.PARKING_PAY AS PARKING_PAY, a.PAY_REASON AS PAY_REASON, a.LOGIN_NAME AS LOGIN_NAME, a.OUT_DOOR_NAME AS OUT_DOOR_NAME FROM YGJ_FAMILY_CAR_HISTORY AS a where 1=1 AND a.COURT_CODE in ${courts} AND if(CHARACTER_LENGTH('${carNo}')>0, trim(a.CAR_NO) LIKE CONCAT('%','${carNo}','%'),1=1) AND if(CHARACTER_LENGTH('${courtCode}')>0, trim(a.COURT_CODE) = '${courtCode}',1=1) AND if(CHARACTER_LENGTH('${year}')>0, SUBSTR(a.OUT_TIME,1,4) = '${year}',1=1) AND if(CHARACTER_LENGTH('${month}')>0, SUBSTR(a.OUT_TIME,5,2) = '${month}',1=1) AND if(CHARACTER_LENGTH('${day}')>0, SUBSTR(a.OUT_TIME,7,2) = '${day}',1=1) 有没有大神帮帮忙 编辑于 2017-8-14 14:35 |
