private void getDataFromDB() { pDao = new PlanTaskDao(DiXianActivity.this); if (pDao != null) { lastDixianCount = pDao.getLastDixian(tid); counts = new int[lastDixianCount]; mContentCount = new int[lastDixianCount]; list.clear(); mList.clear(); mUploadList.clear(); for (int i = 0; i < lastDixianCount; i++) { // 判断每个条目里面是否有内容 list.add("第" + (i + 1) + "组"); } for (int i = 0; i < lastDixianCount; i++) { List<Map<String, Object>> mItem = new ArrayList<Map<String, Object>>(); mList.add(mItem); } for (int i = 0; i < lastDixianCount; i++) { List<Map<String, Object>> mItem = new ArrayList<Map<String, Object>>(); mUploadList.add(mItem); } } adapter.notifyDataSetChanged(); // 修正第二级目录id chenqiang data = AttachmentDatabase.instance(this) // 数据库中的url为文件名 .query( "SELECT * from tb_task_attachment where task_id = " + tid + " AND (url LIKE '" + tid + "/" + (secondId) + "/" + 3 + "%' or url LIKE '" + tid + "\\" + (secondId) + "/" + 3 + "%' or url LIKE '" + tid + "//" + (secondId) + "/" + 3 + "%' or url LIKE '" + tid + "\\\\" + (secondId) + "/" + 3 + "%')"); if (data != null) { // String fileCount = data.get("records_num"); for (int i = 0; i < Integer.parseInt(data.get("records_num")); i++) { Log.v( "login", data.get("id_" + i) + ":" + data.get("url_" + i) + ":" + data.get("status_" + i) + ":" + data.get("task_id_" + i) + ":" + data.get("dixian_" + i)); // String standard = data.get("standard_" + i); GpsDao gpsDao = new GpsDao(this); GPS gps = gpsDao.getHistory(data.get("historygps_" + i)); // 从数据库中获取gps信息 MyGPS mGPS = new MyGPS( gps.getOllectionTime(), Double.valueOf(gps.getLongitude()), Double.valueOf(gps.getLatitude()), Float.valueOf(gps.getAccuracy()), Double.valueOf(gps.getHeight()), Float.valueOf(gps.getSpeed()), gps.getCoordinate()); String name = data.get("url_" + i); String mediaName1 = name.replace("\\", File.separator); // 把所有的\替换成/ String mediaName = mediaName1.substring(mediaName1.lastIndexOf("/") + 1); String filePath = XianChangAdd.DownloadfileFolder + mediaName; // 附件信息 Map<String, Object> mMap1 = new HashMap<String, Object>(); mMap1.put("gps", mGPS); mMap1.put("path", filePath); mMap1.put("time", gps.getOllectionTime()); // 传递附件的时间 mMap1.put("pathContainsTid", XianChangAdd.DownloadfileFolder + mediaName1); String path1 = (String) mMap1.get( "pathContainsTid"); // storage/emulated/0/nercms-Schedule/DownloadAttachments/356/4/aq2016_06_03_143336.jpg String path = path1.replace("//", File.separator); int itemId = path.lastIndexOf("/"); String name1 = path.substring(itemId + 1); String tmp[] = name1.split("-"); String attId = tmp[0].substring(1); int attId1 = Integer.parseInt(attId); mMap1.put("index", counts[attId1 - 1] + ""); counts[attId1 - 1]++; mList.get(attId1 - 1).add(mMap1); mUploadList.get(attId1 - 1).add(mMap1); } } }