logpanel.java

SAP这个系统的一个转换器

          if (t!=3)
            sql += " and successflag = " + t;
          t = -1;
      }

      if (store != null && !store.equalsIgnoreCase("")) {
        sql += " and store = '" + store + "'";
      }

      if (direction.equalsIgnoreCase("SAP下传")) {
        sql += " and WayFlag='out'";
      }
      else if (direction.equalsIgnoreCase("上传SAP")) {
        sql += " and WayFlag='in'";

      } else if (direction.equalsIgnoreCase("操作时间")) {
         sql += " and WayFlag='time'";
      }

      if (type.equalsIgnoreCase("商品主数据")) {
        sql += " and operation='material'";
      } else if (type.equalsIgnoreCase("商品价格")) {
        sql += " and operation='price'";
      } else if (type.equalsIgnoreCase("商品EAN码")) {
        sql += " and operation='ean'";
      } else if (type.equalsIgnoreCase("商品类目")) {
        sql += " and operation='catalog'";
      } else if (type.equalsIgnoreCase("商品库存")) {
        sql += " and operation='storage'";
      } else if (type.equalsIgnoreCase("套装商品")) {
        sql += " and operation='set'";
      } else if (type.equalsIgnoreCase("商品版别")) {
        sql += " and operation='publish'";
      } else if (type.equalsIgnoreCase("盘点下传")) {
        sql += " and operation='inventory'";
      } else if (type.equalsIgnoreCase("商品类目折扣下传")) {
        sql += " and operation='discount'";
      } else if (type.equalsIgnoreCase("销售上传")) {
        sql += " and operation='sales'";
      } else if (type.equalsIgnoreCase("盘点上传")) {
        sql += " and operation='upinventory'";
      }

      if (merch != null && !merch.equalsIgnoreCase("")) {
        sql += " and merch_code = '" + merch + "'";
      }

      if (date1 != null && !date1.equalsIgnoreCase("")) {
        try {
          f_date = operate.getDate(date1);
          if (f_date == null) {
            return;
          }
          //System.out.println("f_date : " + f_date);
        }
        catch (Exception ex1) {
          System.out.println("LogPanel's refreshData f_date is Error!");
          return;
        }

        if (date2 != null && !date2.equalsIgnoreCase("")) {
          try {
            t_date = operate.getDate(date2);
            if (t_date == null) {
              return;
            }
            if (f_date.after(t_date)) {
              date1 = format.format(f_date);
              date2 = format.format(t_date);
              dateFrom.setText(date1);
              dateTo.setText(date2);
            }
          }
          catch (Exception ex2) {
          System.out.println("LogPanel's refreshData Date is Error!");
//  System.out.println("ex2 : " + ex2.toString());
          }

          if (date1.equalsIgnoreCase(date2)) {
            sql += " and convert(varchar(10) ,OperTime,112)='" +
                format.format(f_date) + "'";
          }
          else {
            sql += " and convert(varchar(10) ,OperTime,112) between '" +
                format.format(f_date) + "' and '" +
                format.format(t_date) + "'";
          }
        }
        else {
          sql += " and convert(varchar(10) ,OperTime,112) > '" +
              format.format(f_date) + "'";
        }
      }
      else {
        if (date2 != null && !date2.equalsIgnoreCase("")) {
          try {
            t_date = operate.getDate(date2);
          }
          catch (Exception ex3) {
            System.out.println("ex3 : " + ex3.toString());
            JOptionPane.showInternalConfirmDialog(null,
                                                  "请输入有效的日期，确认你的格式！");
          }

          sql += " and convert(varchar(10) ,OperTime,112) < '" +
              format.format(t_date) + "'";
        }
      }
      if (t==-1)
        sql += " group by Operation,convert(varchar(10) ,OperTime,112),successflag,wayflag order by convert(varchar(10) ,OperTime,112) DESC";
      else
        sql += " order by Opertime DESC";

      rowSet = query.Query(sql);

      boolean flag = false;
      if (t!=-1)
        flag = addData(rowSet);
      else
        flag = addSumData(rowSet);

    }
    catch (Exception ex) {
      System.out.println("refreshData : " + ex.toString());
    } finally {
      query.close();
    }

  }

  /**
   * 插入汇总数据
   * @param rowSet
   * @return
   */
  private boolean addSumData(RowSet rowSet) {
    removeAll();
//System.out.println(rowSet.length());
    if (rowSet == null || rowSet.length() < 1) {
      System.out.println("rowSet is null");
      dTableModel.addRow(initObj);
      table.setRowSelectionInterval(0, 0);
      return false;
    }
    //System.out.println("length : " + rowSet.length() + "  hash : " + typeHash.size());
    Row row = new Row();
    Vector vec = null;
    try {
      for (int i = 0; i < rowSet.length(); i++) {
        vec = new Vector();
        row = rowSet.get(i);
        if (row.get("successflag").equalsIgnoreCase("0")) {
          vec.add("失败");
        }
        else {
          vec.add("成功");
        }
        vec.add("");
        vec.add("");
        vec.add(typeHash.get(row.get("Operation").trim()));
        vec.add(operate.formatDate(row.get("Opertime").trim()));
        vec.add("");
        vec.add("");
        //vec.add(operate.convertNull(row.get("TableName")));
        vec.add("");
        vec.add(operate.convertNull(row.get("RecordNum")));
        if (operate.convertNull(row.get("WayFlag").trim()).equalsIgnoreCase("out")) {
          vec.add("SAP下传");
        }
        else if (operate.convertNull(row.get("WayFlag").trim()).equalsIgnoreCase("in")){ // if (operate.convertNull(row.get("WayFlag").trim()).equalsIgnoreCase("in"))
          vec.add("上传SAP");
        }
        vec.add(operate.convertNull(""));
        dTableModel.addRow(vec);
        table.setModel(dTableModel);
        table.setRowSelectionInterval(0, 0);
      }
    }
    catch (Exception ex) {
      System.out.println("addData : " + ex.toString());
      ex.printStackTrace();
      return false;
    }
    return true;
  }

  /**
   * 插入行数据
   * @param rowSet
   * @return
   */
  private boolean addData(RowSet rowSet) {
    removeAll();
//System.out.println(rowSet.length());
    if (rowSet == null || rowSet.length() < 1) {
System.out.println("rowSet is null");
      dTableModel.addRow(initObj);
      table.setRowSelectionInterval(0, 0);
      return false;
    }
    //System.out.println("length : " + rowSet.length() + "  hash : " + typeHash.size());
    Row row = new Row();
    Vector vec = null;
    try {
      for (int i = 0; i < rowSet.length(); i++) {
        vec = new Vector();
        row = rowSet.get(i);
        if (row.get("successflag").equalsIgnoreCase("0")) {
          vec.add("失败");
        }
        else {
          vec.add("成功");
        }
        vec.add(operate.convertNull(row.get("store")));
        vec.add(storeHash.get(operate.convertNull(row.get("store"))));
        vec.add(typeHash.get(row.get("Operation").trim()));
        vec.add(operate.getDateString(row.get("Opertime").trim()));
        vec.add(operate.convertNull(row.get("merch_code")));
        vec.add(operate.convertNull(row.get("FileName")));
        //vec.add(operate.convertNull(row.get("TableName")));
        vec.add(operate.convertNull(row.get("PKeyString")));
        vec.add(operate.convertNull(row.get("RecordNum")));
        if (operate.convertNull(row.get("WayFlag").trim()).equalsIgnoreCase("out")) {
          vec.add("SAP下传");
        }
        else if (operate.convertNull(row.get("WayFlag").trim()).equalsIgnoreCase("in")){ // if (operate.convertNull(row.get("WayFlag").trim()).equalsIgnoreCase("in"))
          vec.add("上传SAP");
        } else {
          vec.add("操作时间");
        }
        vec.add(operate.convertNull(row.get("Memo")));
        dTableModel.addRow(vec);
        table.setModel(dTableModel);
        table.setRowSelectionInterval(0, 0);
      }
    }
    catch (Exception ex) {
      System.out.println("addData : " + ex.toString());
      ex.printStackTrace();
      return false;
    }
    return true;
  }

  /**
   * delete all row
   */
  public void removeAll() {
    int count = dTableModel.getRowCount();
    for (int i = count - 1; i > -1; i--) {
      dTableModel.removeRow(i);
    }
  }

  public void deleteFileList() {
    try {
      URL url = null;
      WriteData del = new WriteData();
      GetProperty get = new GetProperty();
      Operate oper = new Operate();
      int back = get.getBack();
      String date = operate.getDelayDate( -back);
      SimpleDateFormat sdf = new SimpleDateFormat("yyyy-MM-dd");
      Date f_date = null;
      Date b_date = null;
      DelFileFilter delfile = new DelFileFilter();

      try {
        f_date = sdf.parse(date);
      }
      catch (Exception ex) {
        //
      }
//System.out.println("data = " + date) ;
      try {
        url = com.idoc.app.IDOCMain.class.getResource("");

      }
      catch (Exception ex1) {
        //
      }
      File[] t_file = null;
      String fileName = "";
      String dir = url.toString();
      dir = dir.substring(6, 8);
      dir += "/idoc/outbound/bak/";
      String t = "";

      File file = new File(dir + "idoc/outbound/bak/");

      String[] str = new String[] {
          "catalog", "ean", "inventory", "material", "promotion", "publish","set", "storage"};
      for (int i = 0; i < str.length; i++) {
        t = dir + str[i] + "/";

        file = new File(t);
        t_file = file.listFiles(delfile);

        for (int j = 0; j < t_file.length; j++) {
          fileName = t_file[j].getName();

          try {
            b_date = sdf.parse(fileName);
            if (b_date.before(f_date))
              del.recursiveRemoveDir(t_file[j]);
          }
          catch (Exception ex) {
            //
            continue;
          }
        }

      }
    }catch(Exception exx) {
      System.out.println("delete local data is fail！");
      exx.printStackTrace();
    }
  }

  private void exitSystem() {
    com.idoc.util.LogManager log = new com.idoc.util.LogManager();
    Vector log_vec2 = new Vector();
    log_vec2.add(0, "");
    log_vec2.add(1, "");
    log_vec2.add(2, "");
    log_vec2.add(3, "");
    log_vec2.add(4, "");
    log_vec2.add(5, "time");
    log_vec2.add(6,"退出系统操作！");
    log_vec2.add(7, "getDate()");
    log_vec2.add(8, "");
    log_vec2.add(9, "1");
    log_vec2.add(10, "0");
    log.WriteLog(log_vec2);

  }
  //////////////////////////////////////////////////////////////////////
  // ActionListener
  public void actionPerformed(ActionEvent evt) {
    Object obj = evt.getSource();
    // 刷新数据
    if (obj == refreshButton) {
      refreshData();
    }

    // 退出系统
    if (obj == quitButton) {
      if (JOptionPane.showConfirmDialog(null, "您是否确认要退出SAP转换系统？", "退出窗口", 0) ==
          0) {
        deleteFileList();
        System.exit(0);
      }
      else {
        return;
      }
    }
  }

}