jeecg datagrid自定义查询方法，关联多表查询

String sql = "select a.*,c.*,d.*,f.* "
+ " from car_route a "
+ " left join ld_order b on a.cr_orderno=b.order_code "
+ " left join ldc_order c on c.order_code=b.order_code "
+ " left join car_info d on (a.cr_to_carno = d.id) "
+ " left join car_driver f on (a.cr_From_Carno = f.id)"
+ " where b.order_iszonghe='2' and c.order_busname='环际益' and a.bpm_status!='-1' "+tiaojian;

List<Map<String, Object>> map=jdbcTemplate.queryForList(sql);
dataGrid.setTotal(map.size());　　　　//赋值总条数

List<Map<String,Object>> maplist=systemService.findForJdbc("select a.*,c.* from car_route a LEFT JOIN ld_order b on a.cr_orderno=b.order_code LEFT JOIN ldc_order c on c.order_code=b.order_code where b.order_iszonghe='2' and c.order_busname='1' and a.bpm_status!='-1' "+tiaojian+" limit "+(dataGrid.getPage()-1)*dataGrid.getRows()+","+dataGrid.getRows(), null);

dataGrid.setResults(maplist);