* 进行存档
*/
if(convertResult.getData()!=null){
try {
if(id==null){
ReportTemplate rt = new ReportTemplate();
BeanUtils.populate(rt, properties);
rt.setId(MyUUIDGen.getUUID());
rt.setCode(convertResult.getData().toString());
rt.setFileName(targetFile.getName());
rt.setTimeStamp(new Timestamp(new Date().getTime()));
if(rt.getName()==null){
rt.setName(originName);
}
reportTemplateDAO.merge(rt);
ObjectListConvert2DynaBeanList.convert(bean, rt);
bean.set("code", "");
bean.set("status", true);
}else{
ReportTemplate rt = reportTemplateDAO.findById(id);
if(rt==null){
rt = new ReportTemplate();
BeanUtils.populate(rt, properties);
rt.setId(MyUUIDGen.getUUID());
rt.setCode(convertResult.getData().toString());
rt.setFileName(targetFile.getName());
rt.setTimeStamp(new Timestamp(new Date().getTime()));
if(rt.getName()==null){
rt.setName(originName);
}
reportTemplateDAO.merge(rt);
ObjectListConvert2DynaBeanList.convert(bean, rt);
bean.set("code", "");
bean.set("status", true);
}else{
BeanUtils.populate(rt, properties);
Set<Cell> cells = rt.getCells();
// List<Cell> cells = cellDAO.findByProperty("reportTemplate.id", "id");
if(cells.size()>0){
HTMLTableManipulator htm = new HTMLTableManipulator(convertResult.getData().toString());
for(Cell cell:cells){
if("olap".equalsIgnoreCase(cell.getQueryType())){
htm.setCellValue(cell.getId().getSheetNum().intValue(), cell.getId().getRowNum().intValue(), cell.getId().getColNum().intValue(), "*");
}else{
htm.setCellValue(cell.getId().getSheetNum().intValue(), cell.getId().getRowNum().intValue(), cell.getId().getColNum().intValue(), "#");
}
}
rt.setCode(htm.getResult());
}else{
rt.setCode(convertResult.getData().toString());
}
rt.setFileName(targetFile.getName());
rt.setTimeStamp(new Timestamp(new Date().getTime()));
if(rt.getName()==null){
rt.setName(originName);
}
reportTemplateDAO.merge(rt);
ObjectListConvert2DynaBeanList.convert(bean, rt);
bean.set("code", "");