public class Project extends DBPersist
Project
Modifier and Type | Field and Description |
---|---|
static short |
ClassId |
Constructor and Description |
---|
Project()
Create empty an Project
|
Project(JDCConnection oConn,
java.lang.String sPrjId) |
Project(java.lang.String sPrjId)
Create empty an Project and set gu_project.
|
Modifier and Type | Method and Description |
---|---|
java.lang.String |
clone(JDCConnection oConn)
Clone Project
When a project is cloned all its subprojects, duites and bugs are also cloned.
|
float |
cost(JDCConnection oConn)
Compute total project cost
Total project cost is the sum of costs of all duties from the project
This method call stored procedure k_sp_prj_cost |
boolean |
delete(JDCConnection oConn)
Delete Project.
|
static boolean |
delete(JDCConnection oConn,
java.lang.String sProjectGUID)
Delete Project.
|
void |
expand(JDCConnection oConn)
Expand Project childs.
|
DBSubset |
getAllChilds(JDCConnection oConn)
Get all Project Childs as a DBSubset.
|
boolean |
load(JDCConnection oConn,
java.lang.Object[] PKVals)
Load Project.
|
boolean |
load(JDCConnection oConn,
java.lang.String sGuProject)
Load Project.
|
static void |
setEndDate(JDCConnection oConn,
java.lang.String sProjectGUID,
java.util.Date oDt)
Set end date for a project.
|
ProjectSnapshot |
snapshot(JDCConnection oConn)
Get snapshot view of the whole project
|
boolean |
store(JDCConnection oConn)
Store Project
If gu_project is null a new GUID is automatically assigned.
|
java.lang.String |
topParent(JDCConnection oConn)
Get Project Top Parent.
|
java.lang.String |
toXML(JDCConnection oConn,
java.lang.String sIdent,
java.lang.String sDelim,
java.util.HashMap oAttrs) |
allcaps, allcaps, clear, clone, columns, containsKey, containsValue, entrySet, exists, get, get, getAuditClassName, getCreationDate, getDate, getDate, getDateFormated, getDateShort, getDateTime, getDateTime24, getDecimal, getDecimalFormated, getDecimalFormated, getDouble, getDoubleFormated, getFloat, getFloatFormated, getInt, getIntArray, getInteger, getIntegerArray, getIntervalPart, getItemMap, getItems, getMoney, getPrimaryKey, getShort, getSQLDate, getSQLTime, getString, getStringHtml, getStringNull, getTable, getTable, getTime, getTimeOfDay, getTimestamp, isEmpty, isNull, iterator, keySet, parseXML, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, put, putAll, putAll, remove, remove, replace, replace, replace, replace, replace, replace, replace, replace, setAuditTransact, setAuditUser, setCreationDate, setPrimaryKey, size, toLowerCase, toUpperCase, toXML, toXML, toXML, values
public static final short ClassId
public Project()
public Project(java.lang.String sPrjId)
sPrjId
- Project Unique Identifier.public Project(JDCConnection oConn, java.lang.String sPrjId) throws java.sql.SQLException
java.sql.SQLException
public java.lang.String topParent(JDCConnection oConn) throws java.sql.SQLException
oConn
- Database Connectionjava.sql.SQLException
public java.lang.String clone(JDCConnection oConn) throws java.sql.SQLException, java.lang.IllegalAccessException
Clone Project
When a project is cloned all its subprojects, duites and bugs are also cloned.oConn
- Database Connectionjava.sql.SQLException
java.lang.IllegalAccessException
public boolean load(JDCConnection oConn, java.lang.Object[] PKVals) throws java.sql.SQLException
public boolean load(JDCConnection oConn, java.lang.String sGuProject) throws java.sql.SQLException
public boolean delete(JDCConnection oConn) throws java.sql.SQLException
Delete Project.
Calls k_sp_del_project stored procedure.public boolean store(JDCConnection oConn) throws java.sql.SQLException
public float cost(JDCConnection oConn) throws java.sql.SQLException, java.lang.NumberFormatException
Compute total project cost
Total project cost is the sum of costs of all duties from the projectoConn
- Database Connectionjava.sql.SQLException
java.lang.NumberFormatException
public DBSubset getAllChilds(JDCConnection oConn) throws java.sql.SQLException
Get all Project Childs as a DBSubset.
oConn
- Database Connectiongu_project | nm_project | od_level | od_walk | id_parent |
Project GUID | Project Name | Depth Level | Walk order within level | Inmediate Parent |
java.sql.SQLException
public void expand(JDCConnection oConn) throws java.sql.SQLException
Expand Project childs.
Calls k_sp_prj_expand stored procedure.oConn
- Database Connectionjava.sql.SQLException
public java.lang.String toXML(JDCConnection oConn, java.lang.String sIdent, java.lang.String sDelim, java.util.HashMap oAttrs) throws java.sql.SQLException
java.sql.SQLException
public ProjectSnapshot snapshot(JDCConnection oConn) throws java.sql.SQLException
Get snapshot view of the whole project
oConn
- Database Connectionjava.sql.SQLException
public static boolean delete(JDCConnection oConn, java.lang.String sProjectGUID) throws java.sql.SQLException, java.lang.NullPointerException
Delete Project.
Calls k_sp_del_project stored procedure.oConn
- Database ConnectionsProjectGUID
- GUID of project to be deleted.java.lang.NullPointerException
- if sProjectGUID is nulljava.sql.SQLException
public static void setEndDate(JDCConnection oConn, java.lang.String sProjectGUID, java.util.Date oDt) throws java.sql.SQLException
Set end date for a project.
This method updates the end date of a project and also the end date of all its parent projects which end date is prior to the one specified.oConn
- Database ConnectionsProjectGUID
- GUID of project to be deleted.sDt
- End Date.java.sql.SQLException