从数据库查数,存储到list对象里

public List<HashMap<String, Object>> selectorderDetails(String date, String province, String city, String vendor,
            String scene, int limitcount, int pagecount) {
        List<HashMap<String, Object>> retorderList=new ArrayList<HashMap<String,Object>>();
        List<HashMap<String, Object>> orderDetailsList=new ArrayList<HashMap<String,Object>>();
        HashMap<String, Object> param=new HashMap<String, Object>();
        param.put("date", date);
        param.put("province", province);
        param.put("city", city);
        param.put("vendor", vendor);
        param.put("scene", scene);
        param.put("limitcount", limitcount);
        param.put("number", pagecount);
        orderDetailsList=groupOrderDao.selectorderDetails(param);
        int totalsumorder=Convert.toIntValue(groupOrderDao.selectorderTotalTask(param).get(0).get("totlesumtask"));
        if(orderDetailsList.size()>0)
        {
            for(HashMap<String, Object> itemMap:orderDetailsList)
            {
                HashMap<String, Object> orderMap=new HashMap<String, Object>();
                orderMap.put("date", itemMap.get("date"));
                orderMap.put("province", itemMap.get("province"));
                orderMap.put("city", itemMap.get("city"));
                orderMap.put("vendor", itemMap.get("vendor"));
                orderMap.put("scene", itemMap.get("scene"));
                orderMap.put("cate", itemMap.get("cate"));
                orderMap.put("task_type", itemMap.get("task_type"));
                orderMap.put("issue_type", itemMap.get("issue_type"));
                orderMap.put("orderprocesstime", StringUtil.getFormatNumber(Convert.toFloatValue(itemMap.get("orderprocesstime")),2));            
                orderMap.put("ordercloserate", StringUtil.getFormatNumber(Convert.toFloatValue(itemMap.get("ordercloserate")),2)+"%");
                orderMap.put("totle_hang_up_task", itemMap.get("totle_hang_up_task"));
                orderMap.put("ordershouldrate", StringUtil.getFormatNumber(Convert.toFloatValue(itemMap.get("ordershouldrate")),2)+"%");
                orderMap.put("ordertimeoutrate",StringUtil.getFormatNumber(Convert.toFloatValue(itemMap.get("ordertimeoutrate")),2)+"%");
                orderMap.put("ordertyperate",StringUtil.getFormatNumber(Convert.toIntValue(itemMap.get("totle_task"))*100/totalsumorder,2)+"%");
                retorderList.add(orderMap);
            }
        }
        return retorderList;
    }

 

posted on 2019-08-20 16:03  tanada  阅读(1332)  评论(0编辑  收藏  举报