Package com.commander4j.db

Examples of com.commander4j.db.JDBInterfaceRequest

480
481
482
483
484
485
486
487
488
489
490
491
  public void submit(long dbTransactionRef) {
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    inter.getInterfaceProperties("Despatch Confirmation", "Output");
    if (inter.isEnabled() == true)
    {
      JDBInterfaceRequest ir = new JDBInterfaceRequest(getHostID(), getSessionID());
      ir.write(dbTransactionRef, "Despatch Confirmation");
    }
    else
    {
      logger.debug("Interface Despatch Confirmation - Output is DISABLED");
    }
View Full Code Here
272
273
274
275
276
277
278
279
280
281
282
283
  {
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    inter.getInterfaceProperties("Equipment Tracking", "Output");
    if (inter.isEnabled() == true)
    {
      JDBInterfaceRequest ir = new JDBInterfaceRequest(getHostID(), getSessionID());
      ir.write(dbTransactionRef, "Equipment Tracking");
    }
    else
    {
      logger.debug("Interface Equipment Tracking - Output is DISABLED");
    }
View Full Code Here
355
356
357
358
359
360
361
362
363
364
365
366
  {
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    inter.getInterfaceProperties("Pallet Status Change", "Output");
    if (inter.isEnabled() == true)
    {
      JDBInterfaceRequest ir = new JDBInterfaceRequest(getHostID(), getSessionID());
      ir.write(dbTransactionRef, "Pallet Status Change");
    }
    else
    {
      logger.debug("Interface Pallet Status Change - Output is DISABLED");
    }
View Full Code Here
147
148
149
150
151
152
153
154
155
156
    buildSQL();
    populateList();
  }

  private void excel() {
    JDBInterfaceRequest interfaceRequest = new JDBInterfaceRequest(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("interface_requests.xls", interfaceRequest.getInterfaceRequestResultSet(listStatement), Common.mainForm);
  }
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
      int n = JOptionPane.showConfirmDialog(Common.mainForm, "Delete Interface Request [" + interfaceRequestID.toString() + "] ?", "Confirm", JOptionPane.YES_NO_OPTION);
      if (n == 0)
      {

        JDBInterfaceRequest ir = new JDBInterfaceRequest(Common.selectedHostID, Common.sessionID);
        ir.delete(interfaceRequestID);

      }
    }
  }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
    query.bindParams();
    listStatement = query.getPreparedStatement();
  }

  private void populateList() {
    JDBInterfaceRequest interfaceRequest = new JDBInterfaceRequest(Common.selectedHostID, Common.sessionID);
    JDBInterfaceRequestTableModel interfaceRequestTable = new JDBInterfaceRequestTableModel(interfaceRequest.getInterfaceRequestResultSet(listStatement));
    TableRowSorter<JDBInterfaceRequestTableModel> sorter = new TableRowSorter<JDBInterfaceRequestTableModel>(interfaceRequestTable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(interfaceRequestTable);
View Full Code Here
244
245
246
247
248
249
250
251
252
253
254
255
256
257
  private void updateRecord(String newStatus) {
    int row = jTable1.getSelectedRow();
    if (row >= 0)
    {
      interfaceRequestID = Long.valueOf(jTable1.getValueAt(row, 1).toString());
      JDBInterfaceRequest ir = new JDBInterfaceRequest(Common.selectedHostID, Common.sessionID);
      if (ir.getInterfaceRequestProperties(interfaceRequestID))
      {
        ir.setStatus(newStatus);
        ir.update();
      }
    }

  }
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
224
  {
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    inter.getInterfaceProperties("Pallet Delete", "Output");
    if (inter.isEnabled() == true)
    {
      JDBInterfaceRequest ir = new JDBInterfaceRequest(getHostID(), getSessionID());
      ir.write(dbTransactionRef, "Pallet Delete");
    } else
    {
      logger.debug("Interface Pallet Delete - Output is DISABLED");
    }
View Full Code Here
288
289
290
291
292
293
294
295
296
297
298
299
  public void submit(long dbTransactionRef) {
    JDBInterface inter = new JDBInterface(getHostID(), getSessionID());
    inter.getInterfaceProperties("Despatch Pre Advice", "Output");
    if (inter.isEnabled() == true)
    {
      JDBInterfaceRequest ir = new JDBInterfaceRequest(getHostID(), getSessionID());
      ir.write(dbTransactionRef, "Despatch Pre Advice");
    }
    else
    {
      logger.debug("Interface Despatch Despatch Pre Advice - Output is DISABLED");
    }
View Full Code Here
147
148
149
150
151
152
153
154
155
156
    buildSQL();
    populateList();
  }

  private void excel() {
    JDBInterfaceRequest interfaceRequest = new JDBInterfaceRequest(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("interface_requests.xls", interfaceRequest.getInterfaceRequestResultSet(listStatement), Common.mainForm);
  }
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBInterfaceRequest

  • com.commander4j.interfaces.JInternalFrameInterfaceLog
  • com.commander4j.interfaces.JInternalFrameInterfaceRequestAdmin
  • com.commander4j.messages.OutgoingDespatchConfirmation
  • com.commander4j.messages.OutgoingDespatchPreAdvice
  • com.commander4j.messages.OutgoingEquipmentTracking
  • com.commander4j.messages.OutgoingLabelData
  • com.commander4j.messages.OutgoingPalletDelete
  • com.commander4j.messages.OutgoingPalletSplit
  • com.commander4j.messages.OutgoingPalletStatusChange
  • com.commander4j.messages.OutgoingProductionDeclarationConfirmation
    • 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.