Package com.commander4j.db

Examples of com.commander4j.db.JDBMaterialBatch

465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
      String temp = "";
      Date d = jSpinnerProductionDate.getDate();
      Calendar caldate = Calendar.getInstance();
      caldate.setTime(d);

      JDBMaterialBatch mb = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
      temp = mb.getDefaultBatchNumber(batchFormat, caldate, processorder);

      if (temp.equalsIgnoreCase(jTextFieldBatch.getText()) == false)
      {
        if (jCheckBoxBatch.isSelected() == false)
        {
          jTextFieldBatch.setText(mb.getDefaultBatchNumber(batchFormat, caldate, processorder));
        }
      }

      if (jCheckBoxExpiry.isSelected() == false)
      {
View Full Code Here
193
194
195
196
197
198
199
200
201
202
    buildSQL();
    populateList();
  }

  private void excel() {
    JDBMaterialBatch materialBatch = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("material_batch.xls", materialBatch.getMaterialBatchDataResultSet(listStatement), Common.mainForm);
  }
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
226
          lbatch = JOptionPane.showInputDialog(Common.mainForm, lang.get("dlg_Material_Batch_Input"));
          if (lbatch != null)
          {
            if (lbatch.equals("") == false)
            {
              JDBMaterialBatch matbat = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
              if (matbat.isValidMaterialBatch(lmaterial, lbatch) == false)
              {
                JLaunchMenu.runForm("FRM_ADMIN_MATERIAL_BATCH_EDIT", lmaterial, lbatch);
              }
              else
              {
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
306
    query.bindParams();
    listStatement = query.getPreparedStatement();
  }

  private void populateList() {
    JDBMaterialBatch materialBatch = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
    JDBMaterialBatchTableModel materialBatchTable = new JDBMaterialBatchTableModel(materialBatch.getMaterialBatchDataResultSet(listStatement));
    TableRowSorter<JDBMaterialBatchTableModel> sorter = new TableRowSorter<JDBMaterialBatchTableModel>(materialBatchTable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(materialBatchTable);
View Full Code Here
193
194
195
196
197
198
199
200
201
202
    buildSQL();
    populateList();
  }

  private void excel() {
    JDBMaterialBatch materialBatch = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    buildSQL();
    export.saveAs("material_batch.xls", materialBatch.getMaterialBatchDataResultSet(listStatement), Common.mainForm);
  }
View Full Code Here
215
216
217
218
219
220
221
222
223
224
225
226
          lbatch = JOptionPane.showInputDialog(Common.mainForm, lang.get("dlg_Material_Batch_Input"));
          if (lbatch != null)
          {
            if (lbatch.equals("") == false)
            {
              JDBMaterialBatch matbat = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
              if (matbat.isValidMaterialBatch(lmaterial, lbatch) == false)
              {
                JLaunchMenu.runForm("FRM_ADMIN_MATERIAL_BATCH_EDIT", lmaterial, lbatch);
              }
              else
              {
View Full Code Here
295
296
297
298
299
300
301
302
303
304
305
306
    query.bindParams();
    listStatement = query.getPreparedStatement();
  }

  private void populateList() {
    JDBMaterialBatch materialBatch = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
    JDBMaterialBatchTableModel materialBatchTable = new JDBMaterialBatchTableModel(materialBatch.getMaterialBatchDataResultSet(listStatement));
    TableRowSorter<JDBMaterialBatchTableModel> sorter = new TableRowSorter<JDBMaterialBatchTableModel>(materialBatchTable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(materialBatchTable);
View Full Code Here
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
      String temp = "";
      Date d = jSpinnerProductionDate.getDate();
      Calendar caldate = Calendar.getInstance();
      caldate.setTime(d);

      JDBMaterialBatch mb = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
      temp = mb.getDefaultBatchNumber(batchFormat, caldate, processorder);

      if (temp.equalsIgnoreCase(jTextFieldBatchPrefix.getText()) == false)
      {
        if (jCheckBoxBatchPrefixOverride.isSelected() == false)
        {
          jTextFieldBatchPrefix.setText(mb.getDefaultBatchNumber(batchFormat, caldate, processorder));
        }
      }

      if (jCheckBoxExpiryOverride.isSelected() == false)
      {
View Full Code Here
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
      String temp = "";
      Date d = jSpinnerProductionDate.getDate();
      Calendar caldate = Calendar.getInstance();
      caldate.setTime(d);

      JDBMaterialBatch mb = new JDBMaterialBatch(Common.selectedHostID, Common.sessionID);
      temp = mb.getDefaultBatchNumber(batchFormat, caldate, processorder);

      if (temp.equalsIgnoreCase(jTextFieldBatch.getText()) == false)
      {
        if (jCheckBoxBatch.isSelected() == false)
        {
          jTextFieldBatch.setText(mb.getDefaultBatchNumber(batchFormat, caldate, processorder));
        }
      }

      if (jCheckBoxExpiry.isSelected() == false)
      {
View Full Code Here
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
  }

  public Boolean processMessage(GenericMessageHeader gmh) {
    Boolean result = false;

    JDBMaterialBatch batch = new JDBMaterialBatch(getHostID(), getSessionID());
    String material = "12345";
    String batchStr = "";
    String status = "";
    int occur = 1;

    while (material.length() > 0)

    {
      material = JUtility.replaceNullStringwithBlank(gmh.getXMLDocument().findXPath("//message/messageData/batchStatusChange/material[" + String.valueOf(occur) + "]").trim());
      batchStr = JUtility.replaceNullStringwithBlank(gmh.getXMLDocument().findXPath("//message/messageData/batchStatusChange/batch[" + String.valueOf(occur) + "]").trim());
      status = JUtility.replaceNullStringwithBlank(gmh.getXMLDocument().findXPath("//message/messageData/batchStatusChange/status[" + String.valueOf(occur) + "]").trim());

      if (material.length() > 0)
      {

        if (batch.getMaterialBatchProperties(material, batchStr) == true)
        {
          batch.setStatus(status);
          batch.update();
          result = true;
          setErrorMessage(String.valueOf(occur) + " Batch(s) updated");
        }
        else
        {
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBMaterialBatch

  • com.commander4j.app.JInternalFrameMaterialBatchAdmin
  • com.commander4j.app.JInternalFramePackLabelPrint
  • com.commander4j.app.JInternalFrameProductionDeclaration
  • com.commander4j.messages.IncommingBatchStatusChange
  • com.commander4j.tablemodel.JDBMaterialBatchTableModel
  • java.sql.Timestamp
  • java.sql.ResultSet
  • java.sql.PreparedStatement
    • 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.