public class Quotation extends AbstractOrder
Constructor and Description |
---|
Quotation()
Default Constructor
|
Modifier and Type | Method and Description |
---|---|
Order |
createOrder(JDCConnection oConn)
Create an Order for this Quotation
The new Order is given the same GUID as the current Quotation
|
boolean |
delete(JDCConnection oConn)
Delete Quotation
|
QuotationLine |
getLine(JDCConnection oConn,
int iPgLine)
Get quotation line by number
|
DBSubset |
getLines(JDCConnection oConn)
Get Quotation lines as a DBSubset
|
boolean |
load(JDCConnection oConn,
java.lang.Object[] PKVals)
Load Quotation with its associated Address
|
static int |
nextVal(JDCConnection oConn,
java.lang.String sGuWorkArea)
Get next value for field pg_quotation in a given WorkArea
|
boolean |
store(JDCConnection oConn)
Store Quotation
If no value for gu_quotation is specified then a new one is automatically assigned.
|
addProduct, addProduct, addProduct, computeSubtotal, computeSubtotal, computeTaxes, computeTaxes, computeTotal, computeTotal, getBillAddress, getCurrencyFormat, getLines, getLocale, removeAllProducts, removeProduct, setCurrencyFormat, setLocale, setLocale, setLocale
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, load, 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 QuotationLine getLine(JDCConnection oConn, int iPgLine) throws java.sql.SQLException
oConn
- JDCConnectioniPgLine
- int Line number [1..n] as as at k_order_lines.pg_linejava.sql.SQLException
public DBSubset getLines(JDCConnection oConn) throws java.sql.SQLException
getLines
in class AbstractOrder
oConn
- Database Connectiongu_quotation | pg_line | gu_product | nm_product | pr_sale | nu_quantity | id_unit | pr_total | pct_tax_rate | is_tax_included | tx_promotion | tx_options | gu_item | id_ref |
Quotation GUID | Line Number | Product GUID | Product Name | Sale Price | Quantity Ordered | Unit for quantity | Total Price | % of Tax Rate | 1 if tax included | Promotion Text | Additional Options | GUID of ordered item |
java.sql.SQLException
public boolean load(JDCConnection oConn, java.lang.Object[] PKVals) throws java.sql.SQLException
load
in class AbstractOrder
oConn
- JDCConnectionPKVals
- Array with a single element Object[1]{(String)gu_quotation}java.sql.SQLException
public boolean store(JDCConnection oConn) throws java.sql.SQLException
Store Quotation
If no value for gu_quotation is specified then a new one is automatically assigned.public boolean delete(JDCConnection oConn) throws java.sql.SQLException
Delete Quotation
public static int nextVal(JDCConnection oConn, java.lang.String sGuWorkArea) throws java.sql.SQLException
oConn
- JDCConnection JDBC ConnectionsGuWorkArea
- String WorkArea GUIDjava.sql.SQLException
public Order createOrder(JDCConnection oConn) throws java.sql.SQLException
Create an Order for this Quotation
The new Order is given the same GUID as the current QuotationoConn
- JDCConnectionjava.sql.SQLException