List＜Map＞

useResourceLogService.queryUseResourceLogsByPid(id,"equipment")

 @Transactional(readOnly = true)
    public List<Map> queryUseResourceLogsByPid(String pid,String type){
        if(StringFacs.isEmpty(pid)||StringFacs.isEmpty(type)){
            return null;
        }
        return useResourceLogDao.queryUseResourceLogsByPid(pid,type);
    }

   public List<Map> queryUseResourceLogsByPid(String pid, String type){
        if("equipment".equals(type)){
            //关联设备表
            String sql="select rl.id,rl.type,eq.name,eq.model,eq.unit,rl.num,rl.addtime from useResourceLog rl " +
                    "left join equipment eq on rl.typeid=eq.id " +
                    "where rl.pid='"+pid+"' and type='equipment' order by rl.addtime desc";
            return jdbcTemplate.queryDatas(sql);
        }else if("material".equals(type)){
            //关联材料表
            String sql="select rl.id,rl.type,ma.name,ma.model,ma.unit,rl.num,rl.addtime from useResourceLog rl " +
                    "left join material ma on rl.typeid=ma.id " +
                    "where rl.pid='"+pid+"' and type='material' order by rl.addtime";
            return jdbcTemplate.queryDatas(sql);
        }else{
            return null;
        }
    }