Package realcix20.utils

Examples of realcix20.utils.DAO.update()

67
68
69
70
71
72
73
74
75
76
77
            dao.update(Resources.DELETE_RPN_BY_R_RI_SQL);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            dao.executeUpdate();
            //next,delete budgets(BI)
            dao.update(Resources.DELETE_BI_BY_R_RI_SQL);
            dao.setInt(1, r);
            dao.setInt(2, ri);
            dao.executeUpdate();
        }
       
View Full Code Here
135
136
137
138
139
140
141
142
143
144
145
    }
   
    public void clearRITAXI(String taxt, int tax) {
       
            DAO dao = DAO.getInstance();
            dao.update(Resources.CLEAR_RITAXI_BY_TAXT_TAX_SQL);
            dao.setString(1, taxt);
            dao.setInt(2, tax);
            dao.executeUpdate();
       
    }
View Full Code Here
767
768
769
770
771
772
773
774
775
776
777
                           
                            hasNewRow = true;
                            //insert r table
                            if (firstNewRow) {
                                firstNewRow = false;
                                dao.update(Resources.INSERT_R_SQL);
                                dao.setObject(1, r);
                                dao.setObject(2, "REAL");
                                dao.setObject(3, tdate);
                                String now = TimeManager.getTime(System.currentTimeMillis());
                                dao.setObject(4, now);                              
View Full Code Here
782
783
784
785
786
787
788
789
790
791
792
                                dao.executeUpdate();
                            }
                           
                            //insert ri tables
                            Vector values = getNSAndPAndPA(row);
                            dao.update(Resources.INSERT_RI_SQL);                           
                            dao.setObject(1, r);
                            dao.setObject(2, ri);
                            dao.setObject(3, "TAX");
                            dao.setObject(4, ld);
                            dao.setObject(5, tc);
View Full Code Here
870
871
872
873
874
875
876
877
878
879
880
                        double lamt = -sumLamt;
                       
                        //TAMT
                        double tamt = lamt / xr;
                       
                        dao.update(Resources.INSERT_RI_SQL);
                        dao.setObject(1, newR);
                        dao.setObject(2, newRi);
                        dao.setObject(3, "TAX X");
                        dao.setObject(4, ld);
                        dao.setObject(5, tc);
View Full Code Here
201
202
203
204
205
206
207
208
209
210
211
        return result;
    }
   
    private void updateRPN() {
        DAO dao = DAO.getInstance();
        dao.update(Resources.DELETE_ALL_RPN_SQL);
        dao.executeUpdate();
        ClearRegsManagerTableModel model = (ClearRegsManagerTableModel)table.getModel();
        Vector datas = model.getDataVector();
        Iterator rowDatasIter = datas.iterator();
        while (rowDatasIter.hasNext()) {
View Full Code Here
213
214
215
216
217
218
219
220
221
222
223
            Item cleared = (Item)rowDatas.get(0);
            if (cleared.getFactValue().equals("Close")) {
                Row regRow = (Row)rowDatas.get(rowDatas.size() - 1);
                int r = (Integer)ObjectUtil.findNewCell(regRow, "RI", "R").getColumnValue();
                int ri = (Integer)ObjectUtil.findNewCell(regRow, "RI", "RI").getColumnValue();
                dao.update(Resources.INSERT_RPN_SQL);
                dao.setInt(1, r);
                dao.setInt(2, ri);
                dao.executeUpdate();
            }
        }
View Full Code Here
246
247
248
249
250
251
252
253
254
255
256
    return container;
  }

  private void insertTMPFC(java.sql.Date evaluationDate) {
    DAO dao = DAO.getInstance();
    dao.update(Resources.INSERT_TMPFC_SQL);
    dao.setObject(1, evaluationDate);
    dao.executeUpdate();
  }

  private void insertTMPXR(java.sql.Date evaluationDate) {
View Full Code Here
253
254
255
256
257
258
259
260
261
262
263
    dao.executeUpdate();
  }

  private void insertTMPXR(java.sql.Date evaluationDate) {
    DAO dao = DAO.getInstance();
    dao.update(Resources.INSERT_TMPXR_SQL);
    dao.setObject(1, evaluationDate);
    dao.executeUpdate();
  }

  private void deleteTMPXR_TMPFC() {
View Full Code Here
260
261
262
263
264
265
266
267
268
269
270
    dao.executeUpdate();
  }

  private void deleteTMPXR_TMPFC() {
    DAO dao = DAO.getInstance();
    dao.update(Resources.DELETE_TMPXR_SQL);
    dao.executeUpdate();
    dao.update(Resources.DELETE_TMPFC_SQL);
    dao.executeUpdate();
  }
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.