}
public static int createCurrencyEvaluationReg(java.sql.Date date) {
int r = 0;
RegClass reg = (RegClass)ClassManager.createClass(510);
Row newRegRow = new Row(reg.getRowType());
newRegRow.setAdd(true);
ObjectUtil.findNewCell(newRegRow, "R", "R").setColumnValue(RegClass.getMaxR() + 1);
r = RegClass.getMaxR() + 1;
ObjectUtil.findNewCell(newRegRow, "R", "AT").setColumnValue(GlobalValueManager.getValue("APPLICATION.AT"));
ObjectUtil.findNewCell(newRegRow, "R", "RDATE").setColumnValue(date);
java.sql.Date now = new java.sql.Date(System.currentTimeMillis());
ObjectUtil.findNewCell(newRegRow, "R", "CREATED").setColumnValue(now);
ObjectUtil.findNewCell(newRegRow, "R", "CREATEDBY").setColumnValue(GlobalValueManager.getValue("SESSION.LOGINUSER"));
ObjectUtil.findNewCell(newRegRow, "R", "LASTCHANGED").setColumnValue(now);
ObjectUtil.findNewCell(newRegRow, "R", "LASTCHANGEDBY").setColumnValue(GlobalValueManager.getValue("SESSION.LOGINUSER"));
ObjectUtil.findNewCell(newRegRow, "R", "TXT256").setColumnValue(TxtManager.getTxt("VIEW.CURRENCYEVALUATION.TITLE"));
DAO dao = DAO.getInstance();
dao.query(Resources.SELECT_RI_XR_INFO_SQL);
ResultSet rs = dao.executeQuery();
try {
int i = 1;
double sum = 0.0;
while (rs.next()) {
if (rs.getDouble("LAMT") != 0.0) {
Row regItemRow = ObjectUtil.addnewChildRow(reg, newRegRow);
regItemRow.setAdd(true);
ObjectUtil.findNewCell(regItemRow, "RI", "RI").setColumnValue(i);
ObjectUtil.findNewCell(regItemRow, "RI", "TXT256").setColumnValue(TxtManager.getTxt("VIEW.CURRENCYEVALUATION.TITLE"));
ObjectUtil.findNewCell(regItemRow, "RI", "LD").setColumnValue(rs.getString("LD"));
ObjectUtil.findNewCell(regItemRow, "RI", "TC").setColumnValue(rs.getString("TC"));
ObjectUtil.findNewCell(regItemRow, "RI", "LC").setColumnValue(rs.getString("LC"));
ObjectUtil.findNewCell(regItemRow, "RI", "TAMT").setColumnValue(0);
ObjectUtil.findNewCell(regItemRow, "RI", "XR").setColumnValue(rs.getDouble("XR"));
ObjectUtil.findNewCell(regItemRow, "RI", "LAMT").setColumnValue(rs.getDouble("LAMT"));
newRegRow.getRowSet().getRows().add(regItemRow);
sum+=rs.getDouble("LAMT");
i++;
}
}
if(sum>0.000001){ //balance
Row regItemRow = ObjectUtil.addnewChildRow(reg, newRegRow);
regItemRow.setAdd(true);
ObjectUtil.findNewCell(regItemRow, "RI", "RI").setColumnValue(i);
ObjectUtil.findNewCell(regItemRow, "RI", "TXT256").setColumnValue(TxtManager.getTxt("VIEW.CURRENCYEVALUATION.BALANCE"));
ObjectUtil.findNewCell(regItemRow, "RI", "LD").setColumnValue(LedgerTypeClass.getDefLD("XVC"));
ObjectUtil.findNewCell(regItemRow, "RI", "TC").setColumnValue(FamilyClass.getLocalCurrency());
ObjectUtil.findNewCell(regItemRow, "RI", "XR").setColumnValue(1.0);