|
发表于 2016-1-8 16:32:56
|
显示全部楼层
1.在报表设计器中,选中要显示图片的单元格,设置属性display-type为image
2.table中如下处理
- Table table = KSQL.select("select tp,tp.fName,tp.fCode,tp.fFJ as fTP from AP_AttachmentSample tp", null, "/appdemo/test/data", null);
- Iterator<Row> it = table.iterator();
- while (it.hasNext()) {
- Row r = it.next();
- String v = r.getString("fTP");//
- String ownerID = r.getString("tp");
- if (!Utils.isEmptyString(v)) {
- JSONArray ja = JSONArray.parseArray(v);
- JSONObject jsonObject = ja.getJSONObject(0);
- String realFileName = jsonObject.getString("realFileName");
- String storeFileName = jsonObject.getString("storeFileName");
- String operateType = "browse";
-
- String url = "/UI2/system/service/doc/common/simpleFileStore.j?realFileName=" + realFileName + "&storeFileName=" + storeFileName + "&ownerID=" + ownerID + "&operateType=" + operateType;
- r.setString("fTP", url);
- }
- }
- return table;
复制代码 |
|