コード例 #1
0
  public void saveJobDetails() {
    // TODO Auto-generated method stub
    if (job == null) {
      commonUTIL.showAlertMessage("Select Template");
      return;
    }

    int rowCount = searchPanel.table.getRowCount();
    Vector<UserJobsDetails> jobdets = new Vector<UserJobsDetails>();
    for (int i = 0; i < searchPanel.getFilterBeanData().size(); i++) {
      FilterBean filterBean = searchPanel.getFilterBeanData().get(i);
      UserJobsDetails ud = new UserJobsDetails();
      ud.setJobId(job.getId());
      ud.setColumnName(filterBean.getColumnName());
      ud.setCriteria(filterBean.getSearchCriteria());
      ud.setValues(filterBean.getColumnValues());
      ud.setFilterValues(filterBean.getIdSelected());
      ud.setAnd_or(filterBean.getAnd_or());

      ud.setRowid(i);
      jobdets.add(ud);
    }
    try {

      if (!reportPanel.getColumnSQL().equalsIgnoreCase(job.getSql())) {
        job.setSql(reportPanel.getColumnSQL());
        reportPanel.getRemoteTask().updateJob(job);
      }
      reportPanel.getRemoteTask().saveUserJobsDetails(jobdets, job.getId());
    } catch (RemoteException e) {
      // TODO Auto-generated catch block
      e.printStackTrace();
    }
  }
コード例 #2
0
  private void loadJobs(Vector<UserJobsDetails> jobdetails) {
    // TODO Auto-generated method stub
    if (!commonUTIL.isEmpty(jobdetails)) {
      searchPanel.clearllCriterial();
      for (int i = 0; i < jobdetails.size(); i++) {
        UserJobsDetails jd = jobdetails.get(i);
        FilterBean bean = new FilterBean();

        bean.setSearchCriteria(jd.getCriteria());
        bean.setColumnName(jd.getColumnName());
        bean.setColumnValues(jd.getValues());
        bean.setAnd_or(jd.getAnd_or());
        bean.setIdSelected(jd.getFilterValues());
        searchPanel.addNewRow(bean);
        int rowCount = searchPanel.getTableRowCount();
        String criteria[] = null;
        criteria = getFilterValues().convertVectortoSringArray(searchCriteria, "SearchCriteria");
        if (bean.getColumnName().endsWith("Date")) {
          criteria = getFilterValues().getDateSearchCriteria();
          searchPanel.addRowEditor(
              rowCount - 1, 1, getDateCriteriaJComboxBox(criteria), "Criteria");
          searchPanel.addRowEditor(rowCount - 1, 2, getDateCellEditor("Values"), "Values");
          searchPanel.addRowEditor(rowCount - 1, 3, getDateCellEditor("And/Or"), "And/Or");
        } else {
          searchPanel.addRowEditor(rowCount - 1, 1, getJComboxBox(criteria), "Criteria");
          Vector dataValues = getFilterValues().getValuesonColumn(bean.getColumnName(), null);
          if (dataValues == null || dataValues.isEmpty()) {
            String mvalues[] =
                getFilterValues().convertVectortoSringArray(dataValues, bean.getColumnName(), 0);
            searchPanel.addRowEditor(
                rowCount - 1, 2, getMultiSelectListExComboBox(mvalues), "Values");
          }
        }

        // bean.setIdSelected(jd.);
      }
    }
  }