/** 查询驾驶员的信息 */ @SuppressWarnings({"rawtypes", "unchecked"}) public DataGrid load(PageParam param, VmDrivertable vt) { DataGrid data = new DataGrid(); StringBuffer sb = new StringBuffer(" from VmDrivertable d where 1=1"); List list = new ArrayList(); if (StringUtils.isNotBlank(vt.getDrivingname())) { sb.append(" and d.drivingname like ?"); list.add("%" + vt.getDrivingname() + "%"); } if (StringUtils.isNotBlank(vt.getGender())) { sb.append(" and d.gender=?"); list.add(vt.getGender()); } if (StringUtils.isNotBlank(vt.getDrivingno())) { sb.append(" and d.drivingno=?"); list.add(vt.getDrivingno()); } data.setTotal((Long) dao.findOne("select count(*)" + sb.toString(), list)); if (StringUtils.isNotBlank(param.getSort())) { param.appendOrderBy(sb); // 排序 } else { sb.append(" order by d.createdate desc "); } List<Map<String, Object>> rows = dao.findPage( "select new Map(d.id as id,d.drivingno as drivingno,d.drivingname as drivingname,d.gender as gender,d.papervaliddate as papervaliddate,d.drivingage as drivingage,d.allowdriving as allowdriving,d.address as address,d.phone as phone,d.promulgator as promulgator,d.createdate as createdate)" + sb.toString(), param.getPage(), param.getRows(), list); for (Map<String, Object> map : rows) { map.put( "userName", MyCache.getInstance().getTrueName((String) map.get("promulgator"))); // 创建人 // map.put("allowdriving",MyCache.getInstance().getSelectValue((String) // map.get("allowdriving")));//准驾车型 } data.setRows(rows); return data; }