/**
* ************************************************************************ Lineas de Remesa
*
* @param whereClause where clause or null (starting with AND)
* @return lines
*/
public MRemesaLine[] getLines(String whereClause, String orderClause) {
ArrayList list = new ArrayList();
StringBuffer sql = new StringBuffer("SELECT * FROM C_RemesaLine WHERE C_Remesa_ID=? ");
if (whereClause != null) sql.append(whereClause);
if (orderClause != null) sql.append(" ").append(orderClause);
PreparedStatement pstmt = null;
try {
pstmt = DB.prepareStatement(sql.toString(), get_TrxName());
pstmt.setInt(1, getC_Remesa_ID());
ResultSet rs = pstmt.executeQuery();
while (rs.next()) list.add(new MRemesaLine(getCtx(), rs));
rs.close();
pstmt.close();
pstmt = null;
} catch (Exception e) {
log.saveError("getLines - " + sql, e);
} finally {
try {
if (pstmt != null) pstmt.close();
} catch (Exception e) {
}
pstmt = null;
}
//
MRemesaLine[] lines = new MRemesaLine[list.size()];
list.toArray(lines);
return lines;
} // getLines
/**
* ************************************************************************ String Representation
*
* @return info
*/
public String toString() {
StringBuffer sb =
new StringBuffer("MRemesa[")
.append(getID())
.append("-")
.append(getDescription())
.append(",Norma=")
.append(getC_Norma_ID())
.append(",TotalAmt=")
.append(getTotalAmt())
.append(",ExecuteDate=")
.append(getExecuteDate())
.append("]");
return sb.toString();
} // toString
public String toString() {
StringBuffer sb = new StringBuffer("X_T_ReportStatement[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_AD_ComponentVersion[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_GL_JournalBatch[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_MPC_Schedule[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_AD_WF_NextCondition[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_M_IncotermCode[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_AD_PrintFormatItem[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_C_Tax[").append(getID()).append("]");
return sb.toString();
}
public String toString() {
StringBuffer sb = new StringBuffer("X_T_Acct_Balance[").append(getID()).append("]");
return sb.toString();
}