Package realcix20.classes.basic

Examples of realcix20.classes.basic.Column

414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
    DefaultTableModel model = new DefaultTableModel();
    Vector columnNames = new Vector();

    RegClass regObject = (RegClass) ClassManager.createClass(510);
    Column column = ObjectUtil.findColumn(regObject, "RI", "R");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "RI");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "TXT256");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "LD");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "LC");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "LAMT");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "TC");
    columnNames.add(column.toString());
    column = ObjectUtil.findColumn(regObject, "RI", "TAMT");
    columnNames.add(column.toString());
    columnNames.add("");
   
    model.setDataVector(new Vector(), columnNames);
    DefaultTableModel cloneModel = new DefaultTableModel();
    cloneModel.setDataVector(new Vector(), columnNames);
View Full Code Here
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
                    model = (DefaultTableModel)getColumnTable().getModel();
                    Iterator columnIter = object.getColumns().iterator();
                    while (columnIter.hasNext()) {
                        Vector rowData = new Vector();
                        Column column = (Column)columnIter.next();
                        rowData.add(column);
                        model.addRow(rowData);
                    }     
                   
                    model = (DefaultTableModel)getColumnAllTable().getModel();
                    columnIter = object.getColumns().iterator();
                    while (columnIter.hasNext()) {
                        Column column = (Column)columnIter.next();
                        Vector rowData = new Vector();
                        rowData.add("AND");
                        rowData.add(column);
                        rowData.add("");
                        model.addRow(rowData);
                    }

                } else if (getCommand().equals("EDIT")||getCommand().equals("COPY")) {
                   
                    model = (DefaultTableModel)getColumnTable().getModel();
                    Iterator columnIter = object.getColumns().iterator();
                    while (columnIter.hasNext()) {
                        Vector rowData = new Vector();
                        Column column = (Column)columnIter.next();
                        rowData.add(column);
                        model.addRow(rowData);
                    }
                    DAO dao = DAO.getInstance();
                    dao.query(Resources.SELECT_CLFIELDS_BY_CLSID_AND_LAYOUT_FOR_DISPLAY);
                    dao.setInt(1, object.getClsId());
                    dao.setInt(2, layout);
                    ResultSet rs = dao.executeQuery();
                    try {
                       
                        while (rs.next()) {
                            String tableName = rs.getString("TABLENAME");
                            String columnName = rs.getString("COLUMNNAME");
                            int disordinal = rs.getInt("DISORDINAL");
                            for (int i = 0 ; i <= model.getRowCount(); i++) {
                                Column column = (Column)model.getValueAt(i, 0);
                                if ( (column.getTableName().equals(tableName)) && (column.getColumnName().equals(columnName)) && (disordinal > 0) ) {
                                    model.removeRow(i);
                                    break;
                                }
                            }
                        }
                       
                        rs.close();
                    } catch (Exception e) {
                       
                    }
                   
                    model = (DefaultTableModel)getColumnDisplayTable().getModel();
                    dao.query(Resources.SELECT_CLFIELDS_BY_CLSID_AND_LAYOUT_FOR_DISPLAY);
                    dao.setInt(1, object.getClsId());
                    dao.setInt(2, layout);
                    rs = dao.executeQuery();
                    try {
                       
                        while (rs.next()) {
                            String tableName = rs.getString("TABLENAME");
                            String columnName = rs.getString("COLUMNNAME");
                            int disordinal = rs.getInt("DISORDINAL");
                            columnIter = object.getColumns().iterator();
                            while (columnIter.hasNext()) {
                                Column column = (Column)columnIter.next();
                                if ( (column.getTableName().equals(tableName)) && (column.getColumnName().equals(columnName)) && (disordinal > 0) ) {
                                    Vector rowData = new Vector();
                                    rowData.add(column);
                                    if (column.isCountble())
                                        rowData.add(rs.getBoolean("ISCOUNT"));
                                    else
                                        rowData.add(null);
                                    if (column.isSumble())
                                        rowData.add(rs.getBoolean("ISSUMMARY"));
                                    else
                                        rowData.add(null);
                                    model.addRow(rowData);
                                    break;
                                }                                           
                            }                             
                        }
                       
                        rs.close();
                    } catch (Exception e) {
                       
                    }
                   
                    model = (DefaultTableModel)getColumnOrderSourceTable().getModel();
                    dao.query(Resources.SELECT_CLFIELDS_BY_CLSID_AND_LAYOUT_ORDERBY_ORDERBYORDINAL);
                    dao.setInt(1, object.getClsId());
                    dao.setInt(2, layout);
                    rs = dao.executeQuery();
                    try {
                       
                        while (rs.next()) {
                            String tableName = rs.getString("TABLENAME");
                            String columnName = rs.getString("COLUMNNAME");
                            columnIter = object.getColumns().iterator();
                            while (columnIter.hasNext()) {
                                Column column = (Column)columnIter.next();
                                if ( (column.getTableName().equals(tableName)) && (column.getColumnName().equals(columnName)) ) {
                                    Vector rowData = new Vector();
                                    rowData.add(column);
                                    model.addRow(rowData);
                                    break;
                                }                                           
                            }                             
                        }
                       
                        rs.close();
                    } catch (Exception e) {
                       
                    }
                   
                model = (DefaultTableModel)getColumnOrderTable().getModel();
                dao.query(Resources.SELECT_CLFIELDS_BY_CLSID_AND_LAYOUT_ORDERBY_ORDERBYORDINAL_FOR_ORDERBY);
                dao.setInt(1, object.getClsId());
                dao.setInt(2, layout);
                rs = dao.executeQuery();
                try {
                       
                    while (rs.next()) {
                        String tableName = rs.getString("TABLENAME");
                        String columnName = rs.getString("COLUMNNAME");
                        columnIter = object.getColumns().iterator();
                        while (columnIter.hasNext()) {
                            Column column = (Column)columnIter.next();
                            if ( (column.getTableName().equals(tableName)) && (column.getColumnName().equals(columnName)) ) {
                                Vector rowData = new Vector();
                                rowData.add(column);
                                if (rs.getObject("ORDERBYASCDES") == null)
                                    rowData.add(new Boolean(false));
                                else
                                    rowData.add(rs.getBoolean("ORDERBYASCDES"));
                                model.addRow(rowData);
                                break;
                            }                                           
                        }                             
                    }

                    rs.close();
                } catch (Exception e) {

                }
               
                model = (DefaultTableModel)getColumnAllTable().getModel();
                columnIter = object.getColumns().iterator();
                while (columnIter.hasNext()) {
                    Column column = (Column)columnIter.next();
                    Vector rowData = new Vector();                   

                    dao.query(Resources.SELECT_CLFIELDS_BY_CLSID_AND_LAYOUT_AND_TABLENAME_AND_COLUMNNAME);
                    dao.setInt(1, object.getClsId());
                    dao.setInt(2, layout);
                    dao.setString(3, column.getTableName());
                    dao.setString(4, column.getColumnName());
                    rs = dao.executeQuery();
                    try {

                        if (rs.next()) {                           
                            if (rs.getBoolean("ANDOR") == true)
View Full Code Here
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
        public void updateDisplayColumnTable() {
           
                getColumnDisplayTable().setCellEditorModel(new CellEditorModel());
                DefaultTableModel cdModel = (DefaultTableModel)getColumnDisplayTable().getModel();               
                for (int i = 0; i < getColumnDisplayTable().getRowCount(); i++) {                                           
                    Column column = (Column)cdModel.getValueAt(i, 0);
                    if (column.isCountble()) {
                        JCheckBox checkBox = new JCheckBox();               
                        DefaultCellEditor ed = new DefaultCellEditor(checkBox);
                        getColumnDisplayTable().getCellEditorModel().addEditorForCell(i, 1, ed);                       
                    }
                    if (column.isSumble()) {
                        JCheckBox checkBox = new JCheckBox();               
                        DefaultCellEditor ed = new DefaultCellEditor(checkBox);
                        getColumnDisplayTable().getCellEditorModel().addEditorForCell(i, 2, ed);
                    }
                }
View Full Code Here
1628
1629
1630
1631
1632
1633
1634
1635
1636
1637
1638
1639
                   
                    names = new Vector();
                    dataValues = new Vector();
                    Iterator columnIter = object.getColumns().iterator();
                    while (columnIter.hasNext()) {
                        Column column = (Column)columnIter.next();
                        if (column.isIndexField())
                            names.add(column);
                    }
                   
                    this.setDataVector(dataValues, names);
                   
View Full Code Here
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
                Row row = (Row)rowDatas.get(rowDatas.size() - 1);               
                Iterator columnIter = getCurrentObject().getColumns().iterator();               
                Vector cells = row.getNewCells();
                StringBuffer sb = new StringBuffer();
                while (columnIter.hasNext()) {
                    Column column = (Column)columnIter.next();
                    if (column.isHeadField()) {
                        sb.append(column.toString() + " --- ");
                        for (int k = 0; k < cells.size(); k++) {
                            Cell cell = (Cell)cells.get(k);
                            if ((cell.getColumnName().equals(column.getColumnName())) && (cell.getTableName().equals(column.getTableName()))) {
                                if (cell.getColumnValue() != null)
                                    sb.append(cell.getColumnValue());
                                sb.append("\n");
                                break;
                            }
                        }
                    }
                }
                sb.append("\n");
                boolean hasItemTableField = false;
                columnIter = getCurrentObject().getColumns().iterator();
                while (columnIter.hasNext()) {
                    Column column = (Column)columnIter.next();
                    if (column.isItemTableField()) {
                        hasItemTableField = true;
                        sb.append(column.toString() + "\t");
                    }
                }
                sb.append("\n");
                if (hasItemTableField) {
                    RowSet rowSet = row.getRowSet();
                    Iterator rowIter = rowSet.getRows().iterator();
                    while (rowIter.hasNext()) {
                        Row tempRow = (Row)rowIter.next();
                        Iterator cellIter = tempRow.getNewCells().iterator();
                        while (cellIter.hasNext()) {
                            Cell cell = (Cell)cellIter.next();
                            columnIter = getCurrentObject().getColumns().iterator();
                            while (columnIter.hasNext()) {
                                Column column = (Column)columnIter.next();
                                if ( (column.isItemTableField()) && (column.getTableName().equals(cell.getTableName()))
                                    && (column.getColumnName().equals(cell.getColumnName())) ) {
                                    if (cell.getColumnValue() != null) {
                                        sb.append(cell.getColumnValue() + "\t");
                                    }
                                }
                            }
View Full Code Here
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
            closeValues=new Vector();
            openValues=new Vector();
            Iterator columnIter = object.getColumns().iterator();
            names.add("");
            while (columnIter.hasNext()) {
                Column column = (Column)columnIter.next();
                if (column.isIndexField())
                    names.add(column);
                  //add combox
                  searchField.addItem(new Item(column.getColumnName(),column.toString()));
            }
            names.add("row");
            Iterator rowIter = object.getRows().iterator();
            while (rowIter.hasNext()) {
                Row row = (Row)rowIter.next();               
                String ld = (String)ObjectUtil.findNewCell(row, "RI", "LD").getColumnValue();
                String lt = "";
                if (ld != null)
                    lt = LedgerClass.getLTByLD(ld);
                if ( (ld !=null) && ( (lt.equals("AP")) || (lt.equals("AR")) ) ) {                   
                    Vector rowDatas = new Vector();
                    if (isRegCleared(row)) {                       
                        Item item2 = new Item("Close", TxtManager.getTxt("VIEW.CLEARREGMANAGER.TABLE.COLUMN1VALUE2"));
                        rowDatas.add(item2);
                    } else {
                        Item item1 = new Item("Open", TxtManager.getTxt("VIEW.CLEARREGMANAGER.TABLE.COLUMN1VALUE1"));
                        rowDatas.add(item1);
                    }
                    columnIter = object.getColumns().iterator();               
                    while (columnIter.hasNext()) {
                        Column column = (Column)columnIter.next();
                        if (column.isIndexField()) {                       
                            Cell newCell = ObjectUtil.findNewCell(row, column.getTableName(), column.getColumnName());
                            if (column.getInputType() == 4) {
                                rowDatas.add("*****");
                            }
                            else if (column.isI18N()) {
                                String i18nString = null;
                                if (newCell.getColumnValue() != null)
                                    i18nString = I18NManager.getI18NString(column.getI18nPrefix(), newCell.getColumnValue());
                                if (i18nString != null) {
                                    if (GlobalValueManager.getValue("APPLICATION.ZIC").equals("1")) {
                                        rowDatas.add(i18nString);
                                    } else if (GlobalValueManager.getValue("APPLICATION.ZIC").equals("2")) {
                                        rowDatas.add(newCell.getColumnValue());
View Full Code Here
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
                names.add(TxtManager.getTxt("VIEW.I18NMAINTAINDIALOG.TABLE.I18NID"));
                names.add(TxtManager.getTxt("VIEW.I18NMAINTAINDIALOG.TABLE.REFLANGTXT"));
                names.add(TxtManager.getTxt("VIEW.I18NMAINTAINDIALOG.TABLE.WORKLANGTXT"));
                Vector dataValues = new Vector();
                BaseClass object = container.getCurrentObject();
                Column pkColumn = (Column)object.getPkColumns().get(0);
                Iterator rowsIter = object.getRows().iterator();
                while (rowsIter.hasNext()) {
                    Vector rowDatas = new Vector();
                    Row row = (Row)rowsIter.next();
                    String i18nID = ObjectUtil.findNewCell(row, pkColumn.getTableName(), pkColumn.getColumnName()).getColumnValue().toString();
                    if (!isI18NIDAdded(i18nID, dataValues)) {
                        rowDatas.add(i18nID);
                        rowDatas.add(TxtManager.getTxt("." + pkColumn.getColumnName() + "." + i18nID, refLangChooser.getSelectedLang()));
                        rowDatas.add(TxtManager.getTxt("." + pkColumn.getColumnName() + "." + i18nID, workLangChooser.getSelectedLang()));
                        dataValues.add(rowDatas);
                    }
                }
                model.setDataVector(dataValues, names);
                table.setModel(model);
View Full Code Here
254
255
256
257
258
259
260
261
262
263
264
265
           
        }
       
        private void updateI18NText(String i18nID, String workText) {
           
                Column pkColumn = (Column)container.getCurrentObject().getPkColumns().get(0);
                String id = "." + pkColumn.getColumnName() + "." + i18nID;               
                DAO dao = DAO.getInstance();
                dao.update(Resources.DELETE_TXT_SQL);
                dao.setString(1, id);
                dao.setString(2, workLang);
                dao.executeUpdate();
View Full Code Here
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
        private void setAllComponentValue() {                                                                                
               
                Iterator componentExtIter = getComponentExts().iterator();
                while (componentExtIter.hasNext()) {                   
                    ComponentExt componentExt = (ComponentExt)componentExtIter.next();
                    Column column = componentExt.getColumn();                   
                    Row row = componentExt.getRow();
                    JComponent component = componentExt.getComponent();
                    if ( (action.equals("Edit")) || (getStat().equals("Add")) || (getStat().equals("PartnerAdd")) ) {
//                        System.out.println(column.getTableName() + "." + column.getColumnName());
                        ComponentManager.setValue(getValue(column, row), component);
                    } else if (action.equals("Add")) {
                        Vector parameters = getRelationManager().getParameters_Defvalue(componentExt);
                        if (parameters != null) {
                            String sql = getRelationManager().getSQL_Defvalue(componentExt, parameters);
                            DAO dao = DAO.getInstance();
                            dao.query(sql);
                            for (int i = 0; i < parameters.size(); i++) {
                                String parameter = (String)parameters.get(i);
                                StringTokenizer st = new StringTokenizer(parameter, ".");
                                String tableName = (String)st.nextElement();
                                String columnName = (String)st.nextElement();
                                ComponentExt tempComponentExt = getRelationManager().findComponentExt(tableName, columnName);
                                JComponent tempComponent = tempComponentExt.getComponent();                                   
                                dao.setObject(i+1, ComponentManager.getValue(tempComponent));
                            }
                            ResultSet rs = dao.executeQuery();
                            try {
                                if (rs.next()) {
                                    ResultSetMetaData rsmd = rs.getMetaData();
                                    for (int i = 1; i <= rsmd.getColumnCount(); i++) {
                                        ComponentExt tempComponentExt = getRelationManager().findComponentExt(column.getTableName(), rsmd.getColumnName(i));
                                        boolean isThisObjectColumn = (tempComponentExt != null);
                                        if (isThisObjectColumn) {
                                            if (rs.getObject(i) != null) {
                                                ComponentManager.setValue(rs.getObject(i), tempComponentExt.getComponent());
                                            }
View Full Code Here
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
           
            Iterator columnIter = object.getColumns().iterator();
            while (columnIter.hasNext()) {
               
               
                Column column = (Column)columnIter.next();
                if (column.isHeadField()) {
                    ComponentExt componentExt = new ComponentExt(ComponentManager.getComponent(column), column, currentRow);
                    headComponentExts.add(componentExt);
                }
                else if (column.isItemField()) {
                    ComponentExt componentExt = new ComponentExt(ComponentManager.getComponent(column), column, currentRow);
                    getItemComponentExts().add(componentExt);
                }
            }
           
View Full Code Here
TOP

Related Classes of realcix20.classes.basic.Column

  • com.jgoodies.forms.factories.DefaultComponentFactory
  • com.jgoodies.forms.layout.CellConstraints
  • com.jgoodies.forms.layout.ColumnSpec
  • com.jgoodies.forms.layout.FormLayout
  • com.jgoodies.forms.layout.RowSpec
  • info.clearthought.layout.TableLayout
  • org.jdesktop.swingx.decorator.AlternateRowHighlighter
  • org.jdesktop.swingx.decorator.HighlighterPipeline
  • org.jdesktop.swingx.decorator.RolloverHighlighter
  • org.jdesktop.swingx.JXTable
    • 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.