Examples of LazyDynaBean


Examples of org.apache.commons.beanutils.LazyDynaBean

    int size  = uploads.size();
    if(size==0){
      resultInfo.setFailed(FILE_UPLOAD_NO_FILE);
    }else{
      for(int i=0;i<uploads.size();i++){
        LazyDynaBean bean = new LazyDynaBean();
        File f = uploads.get(i);
//        String fileName = f.getName();
        String fileName = null;
        if(uploadFileNames.size()>i){
          fileName = uploadFileNames.get(i);
        }
        if(fileName!=null){
          bean.set("fileName", fileName);
          int index = fileName.lastIndexOf(".");
          if(index>=0){
            String post = fileName.substring(index);
            String originName = fileName.substring(0,index);
            String uuid = MyUUIDGen.getUUID();
            String targetFileName = upPath+"/"+uuid+post;
            File targetFile = new File(targetFileName);
            try {
              /**!
               * 1.文件拷贝到指定目录
               */
              FileUtils.moveFile(f, targetFile);
              bean.set("saveName", targetFile.getName());
              /**!
               * 2.对指定文件生成表格并进行存储
               */
//              OperResult convertResult = DocumentConverter.convert2HTMLTableStringWithOpenOffice(targetFile);             
              OperResult convertResult = DocumentConverter.convert2HTMLTableStringWithPOI(targetFile);
              if(convertResult.isSUCCEED()){
                /**!
                 * 进行存档
                 */
                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", "");
                        bean.set("status", true);
                       
                    }
                  }
                  } catch (IllegalAccessException e) {
                    // TODO Auto-generated catch block
                    e.printStackTrace();
                    targetFile.delete();
                    bean.set("message", e.getMessage());
                    bean.set("status", false);
                  } catch (Exception e) {
                    // TODO Auto-generated catch block
                    targetFile.delete();
                    bean.set("message", e.getMessage());
                    bean.set("status", false);
                  }
                 
                }else{
                  targetFile.delete();
                  bean.set("message", XLS_CONVERT_NULL_STRING);
                  bean.set("status", false);
                }
              }else{
                /**!
                 * 转换失败,删除目标文件,跳出
                 */
                targetFile.delete();
                bean.set("message", convertResult.getInfoMSG());
                bean.set("status", false);
              }
            } catch (IOException e) {
              // TODO Auto-generated catch block
              e.printStackTrace();
              bean.set("saveName", "");
              bean.set("message", FILE_UPLOAD_HAS_NO_POSTFIX);
              bean.set("status", false);
            }
          }else{
            bean.set("saveName", "");
            bean.set("message", FILE_UPLOAD_HAS_NO_POSTFIX);
            bean.set("status", false);
          }
        }else{
          bean.set("fileName", "");
          bean.set("saveName", "");
          bean.set("message", FILE_UPLOAD_NO_NAME);
          bean.set("status", false);
        }
        beans.add(bean);
      }
      resultInfo.setSucceed();
    }
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

        {
          @Override
          public LazyDynaBean mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            // TODO Auto-generated method stub
            LazyDynaBean bean = new LazyDynaBean();
            String id = rs.getString(1);
            String name = rs.getString(2);
            bean.set("id", id);
            bean.set("name", name);
            return bean;
          }     
        });
    result.setSucceed();
    result.setData(beans);
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

//    rootBeans用于存放最终返回结果
    List<LazyDynaBean> rootBeans = new ArrayList<LazyDynaBean>();
   
    for(TemplateCat root:roots)
    {
      LazyDynaBean bean = new LazyDynaBean();
      bean.set("id",root.getId());
      bean.set("text",root.getName());
      bean.set("leaf", false);
      bean.set("children", getChildrenBeans(root));
      rootBeans.add(bean);
    }
    result.setData(rootBeans);
    result.setSucceed();
    return result;
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

    {
      Iterator<TemplateCat> iter = subCategory.iterator();
      while(iter.hasNext())
      {
        TemplateCat category = iter.next();
        LazyDynaBean bean = new LazyDynaBean();
        bean.set("id",category.getId());
        bean.set("text",category.getName());
        bean.set("leaf", false);
        bean.set("children", getChildrenBeans(category));
        beans.add(bean);
      }
    }
    /**
     * 将模板目录下的具体模板加到children
     * */
    String sql = "select id,name,report_type from report_template where parent_id=?";
    List<LazyDynaBean> templateBeans = jdbcTemplate.query(sql, new RowMapper<LazyDynaBean>()
        {
          @Override
          public LazyDynaBean mapRow(ResultSet rs, int rowNum)
              throws SQLException {
            // TODO Auto-generated method stub
            LazyDynaBean bean = new LazyDynaBean();
            String id = rs.getString(1);
            String name = rs.getString(2);
            String type = rs.getString(3);
            bean.set("id", id);
            bean.set("text", name);
            bean.set("leaf",true);
            bean.set("type", type);
            return bean;
          }     
        },root.getId());
    beans.addAll(templateBeans)
   
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

    if(cell==null)
    {
      result.setFailed(REPORT_CELL_NOT_EXIST);
      return result;
    }
    LazyDynaBean bean = new LazyDynaBean();
    bean = ObjectListConvert2DynaBeanList.convert(cell);
    if(cell.getQueryType().equalsIgnoreCase("single")||cell.getQueryType().equalsIgnoreCase("serial"))
    {
      //历史查询时,需要返回计量点path供前台显示
      String measureID = cell.getMeasureId();
      if(measureID!=null)
      {
        WinccMeasure measure = winccMeasureDAO.findById(measureID);
        if(measure!=null) bean.set("path", measure.getPath());
      }     
    }
//    bean.set("queryType", cell.getQueryType());
//    bean.set("timeVar", cell.getTimeVar());
//    if(cell.getQueryType().equalsIgnoreCase("single")||cell.getQueryType().equalsIgnoreCase("serial"))
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

          result.setFailed(HAS_NO_REPORT_QUERY_AUTHENTICATION);
          return result;
        }
      }
    }
    LazyDynaBean bean = new LazyDynaBean();
    try {
      BeanUtils.populate(bean, properties);
      bean.set("view","view");
    } catch (IllegalAccessException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    } catch (InvocationTargetException e) {
      // TODO Auto-generated catch block
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

      }
    }
   
    Object heightObject = properties.get("height");
    Object widthObject = properties.get("width");
    LazyDynaBean bean = new LazyDynaBean();//bean用来存储最终返回的html code
    bean.set("name", template.getName());
    bean.set("id", template.getId());
    bean.set("time", queryDateParString);//要将时间返回前台
    if(heightObject!=null)
      bean.set("height", stringValue(heightObject));
    if(widthObject!=null)
      bean.set("width", stringValue(widthObject));
   
    Object queryStyleObj = properties.get("action");
    String queryStyle = null;
    if(queryStyleObj==null)//如果前台不传刷新与否,默认不刷新
      queryStyle = "unrefresh";
    else queryStyle = stringValue(queryStyleObj);
    DayReport dayReport = null;
    MonthReport monthReport = null;
    YearReport yearReport = null;
    OtherReport otherReport = null;

    //不是以刷新方式查询,则优先查找报表库***_report中是否有
    //如有,则直接返回      
    String reportType = template.getReportType();
    if(reportType==null||reportType.equals(""))
    {
      reportType="other";//默认以other处理
    }
    if(reportType.equalsIgnoreCase("day"))//日报表
    {
      DayReportId reportID = new DayReportId(template.getId(),new Timestamp(queryDatePar.getTime()));
      dayReport = dayReportDAO.findById(reportID);
      if(dayReport!=null&&!queryStyle.equalsIgnoreCase("refresh"))//说明在报表库中找到了该报表,直接返回
      {
        //不是刷新模式,则直接返回离线库中的值
        bean.set("code", dayReport.getCode());
        result.setData(bean);
        result.setSucceed();
        return result;
      }
    }
    else if(reportType.equalsIgnoreCase("month"))//月报表
    {
      SimpleDateFormat sdfm = new SimpleDateFormat("yyyy-MM");
      try {
        String mDateString = sdfm.format(queryDatePar);
        Date mDate = sdfm.parse(mDateString);//得到的日期是yyyy-MM-1
        MonthReportId reportID = new MonthReportId(template.getId(), new Timestamp(mDate.getTime()));
        monthReport = monthReportDAO.findById(reportID);
        if(monthReport!=null&&!queryStyle.equalsIgnoreCase("refresh"))
        {
          //不是刷新模式,则直接返回离线库中的值
          bean.set("code", monthReport.getCode());
          result.setData(bean);
          result.setSucceed();
          return result;
        }
      } catch (ParseException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
        result.setFailed("Time Format Error!");
        return result;
      }
    }
    else if(reportType.equalsIgnoreCase("year"))//年报表
    {
      SimpleDateFormat sdfy = new SimpleDateFormat("yyyy");//得到的日期是yyyy-1-1
      try {
        String yDateString = sdfy.format(queryDatePar);
        Date yDate = sdfy.parse(stringValue(yDateString));
        YearReportId reportID = new YearReportId(template.getId(), new Timestamp(yDate.getTime()));
        yearReport = yearReportDAO.findById(reportID);
        if(yearReport!=null&&!queryStyle.equalsIgnoreCase("refresh"))
        {
          //不是刷新模式,则直接返回离线库中的值
          bean.set("code", yearReport.getCode());
          result.setData(bean);
          result.setSucceed();
          return result;
        }
      } catch (ParseException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
        result.setFailed("Time Format Error!");
        return result;
      }       
    }
    else //其它类型(other)的报表
    {
      otherReport = otherReportDAO.findById(templateID);
      if(otherReport!=null&&!queryStyle.equalsIgnoreCase("refresh"))
      {
        bean.set("code", otherReport.getCode());
        result.setData(bean);
        result.setSucceed();
        return result;
      }
    }
   
    //通过模板中所有单元格的查询条件,查询数据并组织报表    
    String code = getReport(template, queryDatePar);
    if(code!=null)
    {
      bean.set("code", code);
      //以下用来更新离线库
      if(reportType.equalsIgnoreCase("other"))
      {
        //其它类型报表,在此处需要更新离线库
        //如果离线库中报表存在,则直接覆盖;否则新建报表后覆盖
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

        if(queryType.equalsIgnoreCase("single")||queryType.equalsIgnoreCase("serial"))//商用库查询
        {         
          String measureID = cell.getMeasureId();
          String timeVar = cell.getTimeVar();
          String target = cell.getQueryTarget();
          LazyDynaBean bean = QueryTimeUtility.getHisQueryDate(timeVar, time);
          if(bean==null)
          {
            htmlTable.setCellValue(sheetNum, rowNum,colNum,"");//将单元格值设为空,原来是*/#
            continue;
          }
          Date startTime = (Date)bean.get("startTime");
//          Date endTime = (Date)bean.get("endTime");
//          int interval = (Integer)bean.get("interval");
          if(queryType.equalsIgnoreCase("single"))//单点
          {

View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

   * */
  public OperResult queryReportAuthority(String id)
  {
    // TODO Auto-generated method stub
    OperResult result = new OperResult();
    LazyDynaBean resultBean = new LazyDynaBean();
    resultBean.set("nodeType", "report");//告诉前台节点是报表
    List<LazyDynaBean>operations = getOperationList();
    resultBean.set("operations", operations);
    if(id==null)
    {
      result.setFailed(REPORT_TEMPLATE_ID_IS_NULL);
      resultBean.set("roles", null);
      result.setData(resultBean);
      return result;
    }
    ReportTemplate template = reportTemplateDAO.findById(id);
    if(template==null)
    {
      result.setFailed(REPORT_TEMPLATE_NOT_EXIST);
      resultBean.set("roles", null);
      result.setData(resultBean);
      return result;
    }
    List<Srole>tmpRoles = sroleDAO.findAll();
    List<LazyDynaBean>roles = new ArrayList<LazyDynaBean>();
    String addExp = template.getOperAdd();
    String deleteExp = template.getOperDelete();
    String editExp = template.getOperEdit();
    String modifyExp = template.getOperModify();
    String queryExp = template.getOperQuery();
    String setExp = template.getOperSet();
    for(Srole role:tmpRoles)
    {
      LazyDynaBean bean = ObjectListConvert2DynaBeanList.convert(role);     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), addExp))
        bean.set("add", true);
      else bean.set("add", false);   
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), deleteExp))
        bean.set("delete", true);
      else bean.set("delete", false);     
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), editExp))
        bean.set("edit", true);
      else bean.set("edit", false);     
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), modifyExp))
        bean.set("modify", true);
      else bean.set("modify", false);     
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), queryExp))
        bean.set("query", true);
      else bean.set("query", false);     
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), setExp))
        bean.set("set", true);
      else bean.set("set", false);
     
      roles.add(bean);
    }   
    resultBean.set("roles", roles);
    result.setSucceed();
View Full Code Here

Examples of org.apache.commons.beanutils.LazyDynaBean

   * */
  public OperResult queryCategoryAuthority(String id)
  {
    // TODO Auto-generated method stub
    OperResult result = new OperResult();
    LazyDynaBean resultBean = new LazyDynaBean();
    resultBean.set("nodeType", "category");//告诉前台节点是报表
    List<LazyDynaBean>operations = getOperationList();   
    resultBean.set("operations", operations);
    if(id==null)
    {
      result.setFailed(REPORT_TEMPCAT_ID_IS_NULL);
      resultBean.set("roles", null);
      result.setData(resultBean);
      return result;
    }
    TemplateCat category = templateCatDAO.findById(id);
    if(category==null)
    {
      result.setFailed(REPORT_TEMPCAT_NOT_EXIST);
      resultBean.set("roles", null);
      result.setData(resultBean);
      return result;
    }
    List<Srole>tmpRoles = sroleDAO.findAll();
    List<LazyDynaBean>roles = new ArrayList<LazyDynaBean>();
    String addExp = category.getOperAdd();
    String deleteExp = category.getOperDelete();
    String editExp = category.getOperEdit();
    String modifyExp = category.getOperModify();
    String queryExp = category.getOperQuery();
    String setExp = category.getOperSet();
    for(Srole role:tmpRoles)
    {
      LazyDynaBean bean = ObjectListConvert2DynaBeanList.convert(role);
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), addExp))
        bean.set("add", true);
      else bean.set("add", false);
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), deleteExp))
        bean.set("delete", true);
      else bean.set("delete", false);
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), editExp))
        bean.set("edit", true);
      else bean.set("edit", false);
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), modifyExp))
        bean.set("modify", true);
      else bean.set("modify", false);
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), queryExp))
        bean.set("query", true);
      else bean.set("query", false);
     
      if(AuthorityExpUtility.isRoleInResExpression(role.getAuthority(), setExp))
        bean.set("set", true);
      else bean.set("set", false);
     
      roles.add(bean);
    }
    resultBean.set("roles", roles);
    result.setSucceed();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. All rights reserved.
All source code are property of their respective owners. Java is a trademark of Sun Microsystems, Inc and owned by ORACLE Inc. Contact coftware#gmail.com.