Package com.commander4j.db

Examples of com.commander4j.db.JDBPrinters


  }

  private void populateList(String printerid, String groupid)
  {

    JDBPrinters prn = new JDBPrinters(Common.selectedHostID, Common.sessionID);
    buildSQL();
    JDBPrintersTableModel printertable = new JDBPrintersTableModel(prn.getPrintersResultSet(listStatement));
    TableRowSorter<JDBPrintersTableModel> sorter = new TableRowSorter<JDBPrintersTableModel>(printertable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(printertable);
View Full Code Here


        jButtonAdd.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_PRINTER_ADD"));
        jButtonAdd.addActionListener(new ActionListener()
        {
          public void actionPerformed(ActionEvent evt)
          {
            JDBPrinters prn = new JDBPrinters(Common.selectedHostID, Common.sessionID);

            printerID = JOptionPane.showInputDialog(Common.mainForm, lang.get("dlg_Printer_Create"));
            if (printerID != null)
            {
              if (printerID.equals("") == false)
              {
                Object[] printerGroups = Common.printerGroup;
                String groupId = (String) JOptionPane.showInputDialog(Common.mainForm, lang.get("lbl_Group_ID"), lang.get("lbl_Group_ID"), JOptionPane.PLAIN_MESSAGE, Common.icon_confirm, printerGroups, "Pack");

                // If a string was returned, say so.
                if ((groupId != null) && (groupId.length() > 0))
                {

                  printerID = printerID.toUpperCase();
                  if (prn.create(printerID, groupId) == false)
                  {
                    JUtility.errorBeep();
                    JOptionPane.showMessageDialog(Common.mainForm, prn.getErrorMessage(), lang.get("err_Error"), JOptionPane.ERROR_MESSAGE);
                  } else
                  {

                    populateList("", "");
                    JLaunchMenu.runDialog("FRM_ADMIN_PRINTER_EDIT", printerID, groupId);
                    populateList("", "");
                  }
                }
              }
            }

          }
        });
      }
      {
        jButtonDelete = new JButton4j(Common.icon_delete);
        this.getContentPane().add(jButtonDelete);
        jButtonDelete.setText(lang.get("btn_Delete"));
        jButtonDelete.setBounds(288, 328, 128, 32);
        jButtonDelete.setMnemonic(lang.getMnemonicChar());
        jButtonDelete.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_PRINTER_DELETE"));
        jButtonDelete.addActionListener(new ActionListener()
        {
          public void actionPerformed(ActionEvent evt)
          {
            int row = jTable1.getSelectedRow();
            if (row >= 0)
            {
              printerID = jTable1.getValueAt(row, JDBPrintersTableModel.PrinterID_Col).toString();
              groupID = jTable1.getValueAt(row, JDBPrintersTableModel.Group_Col).toString();

              int n = JOptionPane.showConfirmDialog(Common.mainForm, lang.get("dlg_Printer_Delete") + " " + printerID + " ?", lang.get("dlg_Confirm"), JOptionPane.YES_NO_OPTION, 0, Common.icon_confirm);
              if (n == 0)
              {
                JDBPrinters c = new JDBPrinters(Common.selectedHostID, Common.sessionID);
                c.setPrinterID(printerID);
                c.setGroupID(groupID);
                if (c.delete())
                {
                  JDBPrinterLineMembership plm = new JDBPrinterLineMembership(Common.selectedHostID, Common.sessionID);
                  plm.removePrinterfromAllLines(printerID,groupID);
                }

                populateList("", "");
              }
            }
          }
        });
      }
      {
        jButtonPrint = new JButton4j(Common.icon_report);
        this.getContentPane().add(jButtonPrint);
        jButtonPrint.setText(lang.get("btn_Print"));
        jButtonPrint.setBounds(566, 328, 128, 32);
        jButtonPrint.setMnemonic(lang.getMnemonicChar());
        jButtonPrint.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("RPT_PRINTERS"));
        jButtonPrint.addActionListener(new ActionListener()
        {
          public void actionPerformed(ActionEvent evt)
          {
            JLaunchReport.runReport("RPT_PRINTERS", null, "", null, "");
          }
        });
      }
      {
        jButtonHelp = new JButton4j(Common.icon_help);
        this.getContentPane().add(jButtonHelp);
        jButtonHelp.setText(lang.get("btn_Help"));
        jButtonHelp.setBounds(705, 328, 128, 32);
        jButtonHelp.setMnemonic(lang.getMnemonicChar());

      }

      {
        jButtonExcel = new JButton4j(Common.icon_XLS);
        jButtonExcel.addActionListener(new ActionListener()
        {
          public void actionPerformed(final ActionEvent e)
          {
            JDBPrinters printers = new JDBPrinters(Common.selectedHostID, Common.sessionID);

            JExcel export = new JExcel();
            buildSQL();
            export.saveAs("printers.xls", printers.getPrintersResultSet(listStatement), Common.mainForm);
          }
        });
        jButtonExcel.setText(lang.get("btn_Excel"));
        jButtonExcel.setMnemonic(lang.getMnemonicChar());
        jButtonExcel.setBounds(427, 328, 128, 32);
View Full Code Here

    {
      jButtonExcel = new JButton4j(Common.icon_XLS);
      jButtonExcel.addActionListener(new ActionListener() {
        public void actionPerformed(final ActionEvent e) {
          JDBPrinters printers = new JDBPrinters(Common.selectedHostID, Common.sessionID);

          JExcel export = new JExcel();
          buildSQL();
          export.saveAs("printers.xls", printers.getPrintersResultSet(listStatement), Common.mainForm);
        }
      });
      jButtonExcel.setText(lang.get("btn_Excel"));
      jButtonExcel.setMnemonic(lang.getMnemonicChar());
      jButtonExcel.setBounds(331, 275, 106, 30);
View Full Code Here

    listStatement = query.getPreparedStatement();
  }

  private void populateList(String defaultitem) {

    JDBPrinters prn = new JDBPrinters(Common.selectedHostID, Common.sessionID);
    buildSQL();
    JDBPrintersTableModel printertable = new JDBPrintersTableModel(prn.getPrintersResultSet(listStatement));
    TableRowSorter<JDBPrintersTableModel> sorter = new TableRowSorter<JDBPrintersTableModel>(printertable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(printertable);
View Full Code Here

        jButtonAdd.setBounds(7, 275, 106, 30);
        jButtonAdd.setMnemonic(lang.getMnemonicChar());
        jButtonAdd.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_PRINTER_ADD"));
        jButtonAdd.addActionListener(new ActionListener() {
          public void actionPerformed(ActionEvent evt) {
            JDBPrinters prn = new JDBPrinters(Common.selectedHostID, Common.sessionID);

            printerID = JOptionPane.showInputDialog(Common.mainForm, "Enter new Printer ID");
            if (printerID != null)
            {
              if (printerID.equals("") == false)
              {
                printerID = printerID.toUpperCase();
                if (prn.create(printerID) == false)
                {
                  JUtility.errorBeep();
                  JOptionPane.showMessageDialog(Common.mainForm, prn.getErrorMessage(), "Error", JOptionPane.ERROR_MESSAGE);
                }
                else
                {

                  populateList("");
                  JLaunchMenu.runDialog("FRM_ADMIN_PRINTER_EDIT", printerID);
                  populateList("");
                }
              }
            }

          }
        });
      }
      {
        jButtonDelete = new JButton4j(Common.icon_delete);
        this.getContentPane().add(jButtonDelete);
        jButtonDelete.setText(lang.get("btn_Delete"));
        jButtonDelete.setBounds(223, 275, 106, 30);
        jButtonDelete.setMnemonic(lang.getMnemonicChar());
        jButtonDelete.setEnabled(Common.userList.getUser(Common.sessionID).isModuleAllowed("FRM_PRINTER_DELETE"));
        jButtonDelete.addActionListener(new ActionListener() {
          public void actionPerformed(ActionEvent evt) {
            int row = jTable1.getSelectedRow();
            if (row >= 0)
            {
              printerID = jTable1.getValueAt(row, 0).toString();

              int n = JOptionPane.showConfirmDialog(Common.mainForm, "Delete Printer ID " + printerID + " ?", "Confirm", JOptionPane.YES_NO_OPTION);
              if (n == 0)
              {
                JDBPrinters c = new JDBPrinters(Common.selectedHostID, Common.sessionID);
                c.setPrinterID(printerID);
                if (c.delete())
                {
                  JDBPrinterLineMembership plm = new JDBPrinterLineMembership(Common.selectedHostID,Common.sessionID);
                  plm.removePrinterfromAllLines(printerID);
                }
               
View Full Code Here

    try
    {
      if (cache.containsKey(row)==false)
      {
        mResultSet.absolute(row + 1);
        final JDBPrinters prow = new JDBPrinters(Common.selectedHostID, Common.sessionID);
        prow.getPropertiesfromResultSet(mResultSet);
        cache.put(row, prow);
      }
      switch (col)
      {
      case PrinterID_Col:
View Full Code Here

    try
    {
      if (cache.containsKey(row)==false)
      {
        mResultSet.absolute(row + 1);
        final JDBPrinters prow = new JDBPrinters(Common.selectedHostID, Common.sessionID);
        prow.getPropertiesfromResultSet(mResultSet);
        cache.put(row, prow);
      }
      switch (col)
      {
      case PrinterID_Col:
View Full Code Here

TOP

Related Classes of com.commander4j.db.JDBPrinters

Copyright © 2018 www.massapicom. 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.