Package com.commander4j.db

Examples of com.commander4j.db.JDBMHN

80
81
82
83
84
85
86
87
88
89
90
91
    try
    {
      if (cache.containsKey(row)==false)
      {
        mResultSet.absolute(row + 1);
        final JDBMHN prow = new JDBMHN(Common.selectedHostID, Common.sessionID);
        prow.getPropertiesfromResultSet(mResultSet);
        cache.put(row, prow);
      }

      switch (col)
      {
View Full Code Here
1341
1342
1343
1344
1345
1346
1347
1348
1349
1350
1351
1352
1353
    }
  }

  private void populateList()
  {
    JDBMHN mhn = new JDBMHN(Common.selectedHostID, Common.sessionID);

    JDBMHNPalletTableModelAssign mhntable = new JDBMHNPalletTableModelAssign(mhn.getMHNDataResultSet(listStatement));

    TableRowSorter<JDBMHNPalletTableModelAssign> sorter = new TableRowSorter<JDBMHNPalletTableModelAssign>(mhntable);

    jTable1.setRowSorter(sorter);
View Full Code Here
131
132
133
134
135
136
137
138
139
140
141
142
    JLaunchMenu.runForm(me, "FRM_ADMIN_MHN_ASSIGN", jTextFieldMHN.getText());
  }

  private void populateList()
  {
    JDBMHN mhnTemp = new JDBMHN(Common.selectedHostID, Common.sessionID);
    JDBMHNPalletTableModelProperties mhntable = new JDBMHNPalletTableModelProperties(mhnTemp.getMHNDataResultSet(listStatement));
    TableRowSorter<JDBMHNPalletTableModelProperties> sorter = new TableRowSorter<JDBMHNPalletTableModelProperties>(mhntable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(mhntable);
    jScrollPane1.setViewportView(jTable1);
View Full Code Here
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
  }

  private void populateSummary()
  {

    JDBMHN mhnTemp = new JDBMHN(Common.selectedHostID, Common.sessionID);
    mhnTemp.getPalletDecisionSummmary(masterHoldNoticeNumber);

    DefaultComboBoxModel<String> DefComboBoxMod = new DefaultComboBoxModel<String>();

    LinkedList<String> tempTypeList = mhnTemp.getPalletDecisionSummmary(masterHoldNoticeNumber);
    int sel = -1;
    for (int j = 0; j < tempTypeList.size(); j++)
    {
      String t = tempTypeList.get(j);
      DefComboBoxMod.addElement(t);
View Full Code Here
912
913
914
915
916
917
918
919
920
921
    }
  }

  private void export()
  {
    JDBMHN mhn = new JDBMHN(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement temp = buildSQLr();
    export.saveAs("mhn_" + masterHoldNoticeNumber + ".xls", mhn.getMHNDataResultSet(temp), Common.mainForm);
  }
View Full Code Here
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
    populateList();
  }

  private void create()
  {
    JDBMHN lmhn= new JDBMHN(Common.selectedHostID, Common.sessionID);
    int n = JOptionPane.showConfirmDialog(Common.mainForm, lang.get("dlg_MHN_Create"), lang.get("dlg_Confirm"), JOptionPane.YES_NO_OPTION, 0, Common.icon_confirm);
    if (n == 0)
    {
      String newMHN = lmhn.generateNewMHNNumber().toUpperCase();

      lmhn.setMHNNumber(newMHN);
      lmhn.setStatus("Active");
      lmhn.create();
      JLaunchMenu.runForm("FRM_ADMIN_MHN_EDIT", newMHN);
      buildSQL();
      populateList();
    }
  }
View Full Code Here
211
212
213
214
215
216
217
218
219
220
221
222
    }
  }

  private void populateList()
  {
    JDBMHN mhn = new JDBMHN(Common.selectedHostID, Common.sessionID);
    JDBMHNTableModel mhntable = new JDBMHNTableModel(mhn.getMHNDataResultSet(listStatement));
    TableRowSorter<JDBMHNTableModel> sorter = new TableRowSorter<JDBMHNTableModel>(mhntable);

    jTable1.setRowSorter(sorter);
    jTable1.setModel(mhntable);
View Full Code Here
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
    {
      String lMHN = jTable1.getValueAt(row, JDBMHNTableModel.MHN_Number_Col).toString();
      int n = JOptionPane.showConfirmDialog(Common.mainForm, lang.get("dlg_MHN_Delete") + " " + lMHN + " ?", lang.get("dlg_Confirm"), JOptionPane.YES_NO_OPTION, 0, Common.icon_confirm);
      if (n == 0)
      {
        JDBMHN l = new JDBMHN(Common.selectedHostID, Common.sessionID);
        l.setMHNNumber(lMHN);
        boolean result = l.delete();
        if (result == false)
        {
          JUtility.errorBeep();
          JOptionPane.showMessageDialog(Common.mainForm, l.getErrorMessage(), "Delete error (" + lMHN + ")", JOptionPane.WARNING_MESSAGE);
        }
        else
        {
          buildSQL();
          populateList();
View Full Code Here
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
    }
  }

  private void export()
  {
    JDBMHN mhn = new JDBMHN(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement temp = buildSQLr();
    export.saveAs("mhn_list.xls", mhn.getMHNDataResultSet(temp), Common.mainForm);
  }
View Full Code Here
TOP

Related Classes of com.commander4j.db.JDBMHN

  • com.commander4j.app.JInternalFrameMHNAdmin
  • com.commander4j.app.JInternalFrameMHNAssign
  • com.commander4j.app.JInternalFrameMHNProperties
  • com.commander4j.messages.OutgoingPalletStatusChange
  • com.commander4j.tablemodel.JDBMHNTableModel
  • 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.