按钮js:_g().getWidgetByName('report5').gotoPage(1, { "$fd_agentofpurchaser": "", }, 'T');_g().getWidgetByName('report5_c').gotoPage(1, { "$fd_purchaser": "", }, 'T');_g().getWidgetByName("fd_nian_q").reset();_g().getWidgetByName('fd_xmxz_q').reset();_g().getWidgetByName('fd_xmqy_q').reset(); SQL:SELECT fd_purchaser, COUNT(*) AS projectCount, SUM( fd_contract_amount ) AS zhongbiaojine, ( SELECT SUM( fd_contract_amount ) FROM ekp_database_procurement WHERE 1=1${if(len(fd_agentofpurchaser) == 0, "", "and fd_agentofpurchaser = '" + fd_agentofpurchaser + "'" )} ${if(len(fd_nian_q) == 0, "", "and YEAR ( fd_dateofaward ) = '" + fd_nian_q + "'" )}${if(len(fd_xmxz_q) == 0, "", "and fd_xiangmuxingzhi = '" + fd_xmxz_q + "'" )} ${if(len(fd_xmqy_q) == 0, "", "and fd_region = '" + fd_xmqy_q + "'" )} ) as fd_allFROM ekp_database_procurement WHERE1=1 ${if(len(fd_agentofpurchaser) == 0, "", "and fd_agentofpurchaser = '" + fd_agentofpurchaser + "'" )} ${if(len(fd_nian_q) == 0, "", "and YEAR ( fd_dateofaward ) = '" + fd_nian_q + "'" )}${if(len(fd_xmxz_q) == 0, "", "and fd_xiangmuxingzhi = '" + fd_xmxz_q + "'" )} ${if(len(fd_xmqy_q) == 0, "", "and fd_region = '" + fd_xmqy_q + "'" )}GROUP BY fd_purchaserORDER BY SUM(fd_contract_amount) DESC 点击按钮,重置失败,我感觉我写的没问题