Package realcix20.classes.basic

Examples of realcix20.classes.basic.Cell


        private void initTablesData() {
           
                DefaultTableModel aModel = (DefaultTableModel)assignedTable.getModel();
                DefaultTableModel naModel = (DefaultTableModel)notAssignedTable.getModel();                           
               
                Cell cell = ObjectUtil.findNewCell(selectedRow, "RI", "LAMT");
                double r_lamt = 0.0;
                if (cell.getColumnValue() instanceof Number)
                    r_lamt = ((Number)cell.getColumnValue()).doubleValue();
                else
                    r_lamt = Double.parseDouble((String)cell.getColumnValue());
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_ALL_B_SQL);
                ResultSet rs = dao.executeQuery();
                try {
View Full Code Here


        private boolean isBudgetAssigned(BudgetObject budget) {
           
                boolean result = false;
           
                Cell cell = ObjectUtil.findNewCell(selectedRow, "RI", "R");
                Integer r = 0;
                if (cell.getColumnValue() instanceof Number)
                    r = ((Number)cell.getColumnValue()).intValue();
                else
                    r = Integer.parseInt((String)cell.getColumnValue());
               
                cell = ObjectUtil.findNewCell(selectedRow, "RI", "RI");
                Integer ri = 0;
                if (cell.getColumnValue() instanceof Number)
                    ri = ((Number)cell.getColumnValue()).intValue();
                else
                    ri = Integer.parseInt((String)cell.getColumnValue());
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_BI_BY_ALLPK_SQL);
                dao.setObject(1, r);
                dao.setObject(2, ri);
View Full Code Here

           
        }
       
        private void averageRegLamt() {
           
                Cell cell = ObjectUtil.findNewCell(selectedRow, "RI", "LAMT");
                double r_lamt = 0.0;
                if (cell.getColumnValue() instanceof Number)
                    r_lamt = ((Number)cell.getColumnValue()).doubleValue();
                else
                    r_lamt = Double.parseDouble((String)cell.getColumnValue());
               
                if ( (currentLt.equals("X")) || (currentLt.equals("V")) || (currentLt.equals("XVC")) ) {
                    r_lamt = 0 - r_lamt;
                }
               
View Full Code Here

        }
       
        private void setOldLamt(Vector rowData) {
                           
                int r = 0;
                Cell cell = ObjectUtil.findNewCell(selectedRow, "RI", "R");
                if (cell.getColumnValue() instanceof Number)
                    r = ((Number)cell.getColumnValue()).intValue();
                else
                    r = Integer.parseInt((String)cell.getColumnValue());
               
                int ri = 0;
                cell = ObjectUtil.findNewCell(selectedRow, "RI", "RI");
                if (cell.getColumnValue() instanceof Number)
                    ri = ((Number)cell.getColumnValue()).intValue();
                else
                    ri = Integer.parseInt((String)cell.getColumnValue());
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_BI_BY_ALLPK_SQL);
                dao.setObject(1, r);
                dao.setObject(2, ri);
View Full Code Here

       
            //DialogManager dialogManager = DialogManager.getInstance();
       
            if (action.equals("ADD")) {
              
                Cell cell = findCell(getRow(), "P", "NS");
                if ( (cell != null) && (!cell.getColumnValue().equals("ME")) ) {
                   
                    try {
                        String type = "Confirm Add Account";
                        Iterator rowIter = getRow().getRowSet().getRows().iterator();
                        Cell pCell = findCell(getRow(), "P", "DEFPA");
                        while (rowIter.hasNext()) {
                            Row childRow = (Row)rowIter.next();                           
                            Cell cCell = findCell(childRow, "PA", "PA");
                            if ( (childRow != getRow()) && (cCell.getColumnValue().equals(pCell.getColumnValue())) ) {
                                CIXFileData data = new CIXFileData(type, getPrivateKey(), childRow);
                                CIXFile cixFile = new CIXFile(getPublicKey(), data);   
                                Random random = new Random();
                                String fileName = "confirm_add_account_" + random.nextInt(25000);
                                cixFile.exportFile(fileName);          
                                String str = TxtManager.getTxt("PARTNER.IMPORT.ADDPARTNER");
                                str = str.replaceAll("%", fileName);
                                DialogManager.showMessageDialog(getWindow(), str);
                                break;
                            }
                        }
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                   
                } else if ( (cell != null) && (cell.getColumnValue().equals("ME")) ) {
                   
                    try {
                        KeyPairGenerator keyGen = KeyPairGenerator.getInstance("RSA");
                        keyGen.initialize(1024);
                        KeyPair key = keyGen.generateKeyPair();
                       
                        Iterator rowIter = getRow().getRowSet().getRows().iterator();
                        while (rowIter.hasNext()) {
                            Row childRow = (Row)rowIter.next();
                            if (childRow != getRow()) {
                                Cell publicKeyCell = findCell(childRow, "PA", "PUBKEY");
                                Cell privateKeyCell = findCell(childRow, "PA", "PRIKEY");
                                publicKeyCell.setColumnValue(key.getPublic());
                                privateKeyCell.setColumnValue(key.getPrivate());   
                            }
                        }                                          
                       
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                   
                }

            } else if (action.equals("Confirm Add Account Request")) {                              
               
                Cell cell = findCell(getRow(), "P", "NS");
                if ( (cell != null) && (!cell.getColumnValue().equals("ME")) ) {
                   
                    try {                       
                        Iterator rowIter = getRow().getRowSet().getRows().iterator();
                        while (rowIter.hasNext()) {
                            Row childRow = (Row)rowIter.next();
                            if (childRow != getRow()) {
                                Cell publicKeyCell = findCell(childRow, "PA", "PUBKEY");
                                publicKeyCell.setColumnValue(getCixFile().getPublicKey());
                            }
                        }
                       
                        String type = "Re Confirm Add Account";
                        rowIter = getRow().getRowSet().getRows().iterator();                                               
                        Cell pCell = findCell(getRow(), "P", "DEFPA");
                        while (rowIter.hasNext()) {
                            Row childRow = (Row)rowIter.next();                           
                            Cell cCell = findCell(childRow, "PA", "PA");
                            if ( (childRow != getRow()) && (cCell.getColumnValue().equals(pCell.getColumnValue())) ) {
                                CIXFileData data = new CIXFileData(type, getPrivateKey(), childRow);
                                CIXFile cixFile = new CIXFile(getPublicKey(), data);   
                                Random random = new Random();
                                String fileName = "re_confirm_add_account_"+ random.nextInt(25000);                               
                                cixFile.exportFile(fileName);
                                String str = TxtManager.getTxt("PARTNER.IMPORT.CONFIRMADDPARTNER");
                                str = str.replaceAll("%", fileName);
                                DialogManager.showMessageDialog(getWindow(), str);
                               
                                this.cixFile.getData().setType("Used");
                                this.cixFile.exportFile("used_" + getFile().getName().substring(0, getFile().getName().length() - 2));
                                file.delete();
                                break;
                            }
                        }
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                   
                }
               
            } else if (action.equals("Re Confirm Add Account")) {
               
                MainView container = (MainView)window;
               
                JTree tree = container.getTree();
               
                Row tRow = cixFile.getData().getRow(cixFile.getPublicKey());
                Cell cell1 = findCell(tRow, "P", "NS");
                Cell cell2 = findCell(tRow, "P", "P");
                Cell cell3 = findCell(tRow, "P", "URNS");
                Cell cell4 = findCell(tRow, "P", "URP");
               
                for (int i = 1; i <= tree.getRowCount(); i++) {
                                                        
                    DefaultMutableTreeNode node = (DefaultMutableTreeNode)tree.getPathForRow(i).getLastPathComponent();
                    if (node != null) {
                        ObjectInfo oj = (ObjectInfo)node.getUserObject();
                        //It's partner class
                        if ( (oj.flag.equals("object")) && (oj.clsId == 250) ) {                           
                            tree.setSelectionPath(tree.getPathForRow(i));
                            //This will be updated
                            Iterator rowIter = container.getCurrentObject().getRows().iterator();
                            boolean findRow = false;
                            while (rowIter.hasNext()) {
                               
                                Row cRow = (Row)rowIter.next();        
                                Cell ccell1 = findCell(cRow, "P", "NS");
                                Cell ccell2 = findCell(cRow, "P", "P");   
                               
                                if ( (ccell1.getColumnValue().equals(cell3.getColumnValue())) && (ccell2.getColumnValue().equals(cell4.getColumnValue())) ) {                                   
                                   
                                    findRow = true;
                                    Iterator childRowIter = cRow.getRowSet().getRows().iterator();
                                    while (childRowIter.hasNext()) {
                                        Row childRow = (Row)childRowIter.next();
                                        childRow.setModify(true);
                                        Cell ccell3 = findCell(childRow, "P", "URNS");
                                        Cell ccell4 = findCell(childRow, "P", "URP");
                                        Cell publicKeyCell = findCell(childRow, "PA", "PUBKEY");
                                        ccell3.setColumnValue(cell1.getColumnValue());
                                        ccell4.setColumnValue(cell2.getColumnValue());
                                        publicKeyCell.setColumnValue(cixFile.getPublicKey());                                   
                                    }
                                   
                                    container.getCurrentObject().classUpdate_WholeObject(cRow, false);
                                    break;
                                   
View Full Code Here

       
    }
   
    private Cell findCell(Row row, String tableName, String columnName) {
       
            Cell tCell = null;
       
            Iterator cellIter = row.getNewCells().iterator();
            while (cellIter.hasNext()) {
                Cell cell = (Cell)cellIter.next();
                if ( (cell.getTableName().equals(tableName)) && (cell.getColumnName().equals(columnName)) ) {
                    tCell = cell;
                    break;
                }
            }
           
View Full Code Here

        public boolean isEqual(Row regRow1, Row regRow2) {
           
                boolean result = false;
           
                int r1 = 0;
                Cell cell = ObjectUtil.findNewCell(regRow1, "RI", "R");
                if (cell.getColumnValue() instanceof Number)
                    r1 = ((Number)cell.getColumnValue()).intValue();
                else
                    r1 = Integer.parseInt((String)cell.getColumnValue());
               
                int ri1 = 0;
                cell = ObjectUtil.findNewCell(regRow1, "RI", "RI");
                if (cell.getColumnValue() instanceof Number)
                    ri1 = ((Number)cell.getColumnValue()).intValue();
                else
                    ri1 = Integer.parseInt((String)cell.getColumnValue());
               
                int r2 = 0;
                cell = ObjectUtil.findNewCell(regRow2, "RI", "R");
                if (cell.getColumnValue() instanceof Number)
                    r2 = ((Number)cell.getColumnValue()).intValue();
                else
                    r2 = Integer.parseInt((String)cell.getColumnValue());
               
                int ri2 = 0;
                cell = ObjectUtil.findNewCell(regRow2, "RI", "RI");
                if (cell.getColumnValue() instanceof Number)
                    ri2 = ((Number)cell.getColumnValue()).intValue();
                else
                    ri2 = Integer.parseInt((String)cell.getColumnValue());

                result = ( (r1 == r2) && (ri1 == ri2) );
               
                return result;
           
View Full Code Here

       
        public boolean isCleared(Row row) {
           
                boolean flag = false;
               
                Cell cell1 = ObjectUtil.findOldCell(row, "RI", "R");
                Cell cell2 = ObjectUtil.findOldCell(row, "RI", "RI");
               
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_CLEARED_REG_SQL);
                dao.setObject(1, cell1.getColumnValue());
                dao.setObject(2, cell2.getColumnValue());
                ResultSet rs = dao.executeQuery();
                try {                                       
                    if (rs.next()) {
                        flag = true;
                    }
View Full Code Here

       
        public boolean isApOrAr(Row row) {
           
                boolean flag = false;
               
                Cell cell1 = ObjectUtil.findOldCell(row, "RI", "LD");
                Cell cell2 = ObjectUtil.findOldCell(row, "R", "AT");
                DAO dao = DAO.getInstance();
                dao.query(Resources.SELECT_LT_FROM_LD);
                dao.setObject(1, cell1.getColumnValue());
                ResultSet rs = dao.executeQuery();
                try {                   
                    if (rs.next()) {
                        String lt = rs.getString("LT");
                        if ( ( (lt.equals("AP")) || (lt.equals("AR")) ) && (cell2.getColumnValue().equals("REAL")) ) {
                            flag = true;
                        }
                    }                    
                    rs.close();
                } catch (Exception e) {
View Full Code Here

                boolean result = false;
               
                Iterator rowIter = rows.iterator();
                while (rowIter.hasNext()) {
                    Row row = (Row)rowIter.next();
                    Cell cell1 = ObjectUtil.findOldCell(row, "RI", "R");
                    Cell cell2 = ObjectUtil.findOldCell(row, "RI", "RI");
                    DAO dao = DAO.getInstance();
                    dao.update(Resources.INSERT_RPN_SQL);
                    dao.setObject(1, cell1.getColumnValue());
                    dao.setObject(2, cell2.getColumnValue());
                    if (dao.executeUpdate())
                        result = true;
                }
               
                return result;
View Full Code Here

TOP

Related Classes of realcix20.classes.basic.Cell

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.