Package com.commander4j.util

Examples of com.commander4j.util.JExcel.saveAs()

185
186
187
188
189
190
191
192
193
194
195
  private void export() {
    JDBMaterial material = new JDBMaterial(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement temp = buildSQLr();
    export.saveAs("materials.xls", material.getMaterialDataResultSet(temp), Common.mainForm);
  }

  private void print() {
    PreparedStatement temp = buildSQLr();
    JLaunchReport.runReport("RPT_MATERIALS", null, "", temp, "");
View Full Code Here
389
390
391
392
393
394
395
396
397
398
399
        ResultSet rs;

        try
        {
          rs = temp.executeQuery();
          export.saveAs("qm_results.xls", rs, Common.mainForm);
        } catch (Exception e)
        {
          rs = null;

        }
View Full Code Here
148
149
150
151
152
153
154
155
156
157
158
    JDBPalletHistory palletHistory = new JDBPalletHistory(Common.selectedHostID, Common.sessionID);

    JExcel export = new JExcel();
    export.setExcelRowLimit(jCheckBoxLimit, jSpinnerLimit);
    buildSQL();
    export.saveAs("pallet_history.xls", palletHistory.getPalletHistoryDataResultSet(listStatement), Common.mainForm);
  }

  private void filterBy(String fieldname) {
    int row = jTable1.getSelectedRow();
    if (row >= 0)
View Full Code Here
300
301
302
303
304
305
306
307
308
309
310
  private void excel()
  {
    JDBQMDictionary dict = new JDBQMDictionary(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement ps = dict.getDictionaryDataPreparedStatement();
    export.saveAs("qm_dictionary.xls", dict.getDictionaryDataResultSet(ps), Common.mainForm);
    try
    {
      ps.close();
    } catch (SQLException e)
    {
View Full Code Here
196
197
198
199
200
201
202
203
204
205
206
  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);
  }

  private void addRecord() {
    String lmaterial = "";
    String lbatch = "";
View Full Code Here
225
226
227
228
229
230
231
232
233
234
235
  private void excel() {
    JDBProcessOrder processOrder = new JDBProcessOrder(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    export.setExcelRowLimit(jCheckBoxLimit, jSpinnerLimit);
    buildSQL();
    export.saveAs("process_orders.xls", processOrder.getProcessOrderDataResultSet(listStatement), Common.mainForm);
  }

  private void delete() {
    int row = jTable1.getSelectedRow();
    if (row >= 0)
View Full Code Here
936
937
938
939
940
941
942
943
944
945
946
  private void export() {
    JDBLocation location = new JDBLocation(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    PreparedStatement temp = buildSQLr();
    export.saveAs("locations.xls", location.getLocationDataResultSet(temp), Common.mainForm);
  }

  /**
   * WindowBuilder generated method.<br>
   * Please don't remove this method or its invocations.<br>
View Full Code Here
937
938
939
940
941
942
943
944
945
946
947
  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);
  }

  private static void addPopup(Component component, final JPopupMenu popup)
  {
    component.addMouseListener(new MouseAdapter()
View Full Code Here
424
425
426
427
428
429
430
431
432
433
434
    }
    catch (SQLException e)
    {

    }
    export.saveAs("interface_log.xls", rs, Common.mainForm);
  }

  private void buildSQL() {

    JDBQuery.closeStatement(listStatement);
View Full Code Here
145
146
147
148
149
150
151
152
153
154
155
  }

  private void excel() {
    JDBCustomer customer = new JDBCustomer(Common.selectedHostID, Common.sessionID);
    JExcel export = new JExcel();
    export.saveAs("customers.xls", customer.getCustomerDataResultSet(), Common.mainForm);
  }

  public JInternalFrameCustomerAdmin()
  {
    super();
View Full Code Here
TOP
Copyright © 2018 www.massapi.com. 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.