Package realcix20.utils

Examples of realcix20.utils.DAO.update()

272
273
274
275
276
277
278
279
280
281
282
            //addDisplayColumns
            for (int i = 0; i < cdModel.getRowCount(); i++) {
               
                Column column = (Column)cdModel.getValueAt(i, 0);
               
                dao.update(Resources.INSERT_CLFIELDS_SQL);
                dao.setInt(1, clsId);
                dao.setInt(2, layout);
                dao.setString(3, column.getTableName());
                dao.setString(4, column.getColumnName());
                dao.setInt(5, i + 1);
View Full Code Here
330
331
332
333
334
335
336
337
338
339
340
                        rs.close();
                    } catch (Exception e) {
                        e.printStackTrace();
                    }
                    if (!displayed) {
                        dao.update(Resources.INSERT_CLFIELDS_SQL);
                        dao.setInt(1, clsId);
                        dao.setInt(2, layout);
                        dao.setString(3, column.getTableName());
                        dao.setString(4, column.getColumnName());
                        dao.setInt(5, 0);
View Full Code Here
385
386
387
388
389
390
391
392
393
394
395
        String txtId = "CL." + container.getObject().getClsId() + "." + container.getLayout_C();
        String lang = Resources.getLanguage();
        String long_c = TxtManager.getTxt("CLS." + container.getObject().getClsId()) + " " +
                TxtManager.getTxt("CL") + " " + container.getLayout_C();
       
        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
398
399
400
401
402
403
404
405
406
407
408
    private boolean validate() {
            boolean result = true;
            String sql = getSQL();
//            System.err.println("sql = " + sql);
            DAO dao = DAO.getInstance();
            dao.update(sql);
            try {
                dao.executeUpdate();
            } catch (Exception e) {
                result = false;
            }
View Full Code Here
417
418
419
420
421
422
423
424
425
426
427
    if ((sql!= null) && (!sql.trim().equals(""))) {
      // add CSQL
      sql=CSQLUtil.add(sql, csql);             
        }
        DAO dao = DAO.getInstance();
        dao.update(sql);
        try {
            dao.executeUpdate();
        } catch (Exception e) {
            result = false;
        }
View Full Code Here
339
340
341
342
343
344
345
346
347
348
349
                String lastchangedby = createdby;
                Cell txt256Cell = ObjectUtil.findNewCell(mainRow, "T", "TXT256");
                String txt256 = (String)txt256Cell.getColumnValue();
               
                DAO dao = DAO.getInstance();
                dao.update(Resources.INSERT_R_SQL);
                dao.setObject(1, r);
                dao.setObject(2, at);
                dao.setObject(3, rdate);
                dao.setObject(4, created);
                dao.setObject(5, createdby);
View Full Code Here
408
409
410
411
412
413
414
415
416
417
418
                        double ipprice = 0.0;
                        if (ippriceCell.getColumnValue() != null) {
                            ipprice = ((Number)ippriceCell.getColumnValue()).doubleValue();
                        }
                       
                        dao.update(Resources.INSERT_RI_SQL);
                        dao.setObject(1, r);
                        dao.setObject(2, currentRi);
                        dao.setObject(3, txt256);
                        dao.setObject(4, ld);
                        dao.setObject(5, tc);
View Full Code Here
488
489
490
491
492
493
494
495
496
497
498
                double ipprice = 0.0;
                if (ippriceCell.getColumnValue() != null) {
                    ipprice = ((Number)ippriceCell.getColumnValue()).doubleValue();
                }
                currentRi++;
                dao.update(Resources.INSERT_RI_SQL);
                dao.setObject(1, r);
                dao.setObject(2, currentRi);
                dao.setObject(3, txt256);
                dao.setObject(4, ld);
                dao.setObject(5, tc);
View Full Code Here
293
294
295
296
297
298
299
300
301
302
303
    }
   

  protected void setDefault(int layout) {
      DAO dao = DAO.getInstance();
      dao.update(Resources.UPDATE_CLS_DEFCL_SQL);
      dao.setInt(1,layout);
      dao.setInt(2,getContainer().getCurrentObject().getClsId());
      dao.executeUpdate();
      layoutId=layout;
  }
View Full Code Here
739
740
741
742
743
744
745
746
747
748
749
        public static void insertri_balance(Row correspondenceRow, int r, int ri, String ld, String txt256, String tc, double tamt, String rDate) {
                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);
                dao.setObject(1, r);
                dao.setObject(2, ri);
                dao.setObject(3, txt256);
                dao.setObject(4, ld);
                dao.setObject(5, tc);
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.