Package com.commander4j.db

Examples of com.commander4j.db.JDBMHN

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, "Create New Master Hold ?", "Confirm", JOptionPane.YES_NO_OPTION);
    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, "Delete MHN " + lMHN + " ?", "Confirm", JOptionPane.YES_NO_OPTION);
      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
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
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
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
    JDBPalletHistory palhistfrom = new JDBPalletHistory(getHostID(), getSessionID());
    JDBPalletHistory palhistto = new JDBPalletHistory(getHostID(), getSessionID());
    JDBControl ctrl = new JDBControl(getHostID(), getSessionID());
   
    String origin = ctrl.getKeyValue("DEFAULT_LOCATION");
    JDBMHN mhn = new JDBMHN(getHostID(), getSessionID());
    JDBMHNReasons mhnReasons = new JDBMHNReasons(getHostID(), getSessionID());

    ResultSet rsFrom = palhistfrom.getInterfacingData(transactionRef, "STATUS CHANGE", "FROM", Long.valueOf(1), "SSCC", "asc");

    ResultSet rsTo = palhistfrom.getInterfacingData(transactionRef, "STATUS CHANGE", "TO", Long.valueOf(1), "SSCC", "asc");

    try
    {
      if (rsFrom.next())
      {
        if (rsTo.next())
        {
          palhistfrom.getPropertiesfromResultSet(rsFrom);
          palhistto.getPropertiesfromResultSet(rsTo);

          String mhnNumber = palhistto.getPallet().getMHNNumber();
          String initiator = "";
          String recorder = "";
          String authorisor = "";
          String decision = "";
          String reason1 = "";
          String reason2 = "";
          String reason3 = "";
          String dateCreated = "";
          String dateExpected = "";
          String dateResolved = "";
          String comment = "";
          String status = "";
          String locn = "";
          if (palhistto.getPallet().getMHNNumber().equals("") == false)
          {
            if (mhn.getMHNProperties(palhistto.getPallet().getMHNNumber()))
            {
              initiator = mhn.getInitiator();
              recorder = mhn.getRecorder();
              authorisor = mhn.getAuthorisor();
              reason1 = mhn.getReason1();
              reason2 = mhn.getReason2();
              reason3 = mhn.getReason3();
              dateCreated = JUtility.getISOTimeStampStringFormat(mhn.getDateCreated());
              if (dateCreated.equals("Error"))
                dateCreated = "";
              dateExpected = JUtility.getISOTimeStampStringFormat(mhn.getDateExpected());
              if (dateExpected.equals("Error"))
                dateExpected = "";
              dateResolved = JUtility.getISOTimeStampStringFormat(mhn.getDateResolved());
              if (dateResolved.equals("Error"))
                dateResolved = "";
              comment = mhn.getComments();
              status = mhn.getStatus();
            }
          }

          try
          {
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 DefComboBoxMod = new DefaultComboBoxModel();

    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
934
935
936
937
938
939
940
941
942
943
    }
  }

  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
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.