Package realcix20.utils

Examples of realcix20.utils.DAO.update()

761
762
763
764
765
766
767
768
769
770
771
           
                DAO dao = DAO.getInstance();
                String lc = FamilyClass.getLocalCurrency();
                double xr = TaxClass.getXR(lc, tc, rDate);//USE TaxClass
                double lamt = tamt * xr;
                dao.update(Resources.INSERT_RI_VALUE_SQL_CORR);
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, txt256);
                dao.setObject(4, ld);
                dao.setObject(5, tc);
View Full Code Here
16
17
18
19
20
21
22
23
24
25
26
        String at = ObjectUtil.findNewCell(anaTypeRow, "AT", "AT").getColumnValue().toString();
        AnaProfileClass anaProfile = (AnaProfileClass)ClassManager.createClass(130);       
        StringBuffer sb = new StringBuffer("DELETE FROM " + anaProfile.getChildTableName() + " WHERE AT=?");
        String sql = sb.toString();
        DAO dao = DAO.getInstance();     
        dao.update(sql);
        dao.setObject(1, at);
        dao.executeUpdate();  
        sb = new StringBuffer("DELETE FROM " + anaProfile.getMainTableName() + "" +
                " WHERE APF NOT IN (SELECT APF FROM " + anaProfile.getChildTableName() + ")");
        sql = sb.toString();
View Full Code Here
23
24
25
26
27
28
29
30
31
32
33
        dao.executeUpdate();  
        sb = new StringBuffer("DELETE FROM " + anaProfile.getMainTableName() + "" +
                " WHERE APF NOT IN (SELECT APF FROM " + anaProfile.getChildTableName() + ")");
        sql = sb.toString();
//        System.out.println(sql);
        dao.update(sql);
        dao.executeUpdate();
    }
   
    public static boolean validateDelete(Row anaTypeRow, MainView container) {       
        boolean result = true;
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
                dao.setString(1, txtId);
                dao.setString(2, lang);
                ResultSet rs = dao.executeQuery();
                try {
                    if (rs.next()) {
                        dao.update(Resources.UPDATE_TXT_SQL);
                        dao.setString(1, long_c);
                        dao.setString(2, txtId);
                        dao.setString(3, lang);
                        dao.executeUpdate();
                    } else {
View Full Code Here
81
82
83
84
85
86
87
88
89
90
91
                        dao.setString(1, long_c);
                        dao.setString(2, txtId);
                        dao.setString(3, lang);
                        dao.executeUpdate();
                    } else {
                        dao.update(Resources.INSERT_TXT_SQL);                           
                        dao.setString(1, txtId);
                        dao.setString(2, lang);
                        dao.setString(3, long_c);
                        dao.executeUpdate();
                    }
View Full Code Here
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
                        try {

                            if (rs.next()) {
                                if (rs.getBoolean("ISFAVORITE") == !favorite) {

                                    dao.update(Resources.UPDATE_CL_ISFAVORITE_SQL);
                                    dao.setBoolean(1, favorite);
                                    dao.setInt(2, getContainer().getCurrentObject().getClsId());
                                    dao.setInt(3, oj.layout);
                                    dao.executeUpdate();
                                    getContainer().updateTree();
View Full Code Here
21
22
23
24
25
26
27
28
29
30
31
        String ns = "TAX";
        String co = ObjectUtil.findNewCell(taxDepRow, "TAXDEP", "CO").getColumnValue().toString();
        String taxDep = ObjectUtil.findNewCell(taxDepRow, "TAXDEP", "TAXDEP").getColumnValue().toString();
        String p = co + "." + taxDep;
        DAO dao = DAO.getInstance();
        dao.update(Resources.INSERT_P_SQL);
        dao.setString(1, ns);
        dao.setString(2, p);
        dao.setObject(3, null);
        dao.setObject(4, null);
        dao.setObject(5, null);
View Full Code Here
46
47
48
49
50
51
52
53
54
55
56
            pubkey = key.getPublic();
        } catch (Exception e) {
            e.printStackTrace();
        }               
        boolean block = false;
        dao.update(Resources.INSERT_PA_SQL);
        dao.setObject(1, ns);
        dao.setObject(2, p);
        dao.setObject(3, defpa);
        dao.setObject(4, ownername);
        dao.setObject(5, null);
View Full Code Here
69
70
71
72
73
74
75
76
77
78
79
        PartnerClass partner = (PartnerClass)ClassManager.createClass(250);
        StringBuffer sb = new StringBuffer("DELETE FROM " + partner.getMainTableName() + " WHERE NS='TAX' AND P=?");
        String sql = sb.toString();
        DAO dao = DAO.getInstance();
        dao.setAutoCommit(false);
        dao.update(sql);
        dao.setObject(1, p);
        dao.executeUpdate();

        sb = new StringBuffer("DELETE FROM " + partner.getChildTableName() + " WHERE NS='TAX' AND P=?");
        sql = sb.toString();
View Full Code Here
75
76
77
78
79
80
81
82
83
84
85
        dao.setObject(1, p);
        dao.executeUpdate();

        sb = new StringBuffer("DELETE FROM " + partner.getChildTableName() + " WHERE NS='TAX' AND P=?");
        sql = sb.toString();
        dao.update(sql);
        dao.setObject(1, p);
        dao.executeUpdate();
        dao.commit();
        dao.setAutoCommit(true);
    }
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.