com.aspc.Layers.aspc_app.Task

Class CreateSalesCycleCommand

java.lang.Object

com.aspc.commander.Command

com.aspc.commander.sql.SQLCommand

com.aspc.Layers.aspc_app.Task.CreateSalesCycleCommand

All Implemented Interfaces:

CommandBuildResultsPlugin

public class CreateSalesCycleCommand
extends SQLCommand

Generates a sales cycle
Syntax

  CREATES_SALES_CYCLE [QUOTE quote_key] |
                      [SUBSCRIPTION invoice_key] |
                      [ FIRST_NAME sc_first_name
                        LAST_NAME sc_last_name
                        [EMAIL sc_email]
                        [AREA_CODE sc_area_code]
                        [PHONE sc_phone]
                        [COUNTRY sc_country]                      
                        [SUBURB_CITY sc_suburb_city]
                        [COMPANY sc_company]
                        [POSITION sc_position]
                        [SUMMARY sc_summary]
                        [DESCRIPTION sc_description]
                        [PRODUCT sc_product]
                        [ENQUIRY_SOURCE sc_source]
                      ]
  

Usage

  /* generates a SalesCycle*/
  
  /*
   * generates a renewal cycle from an invoice
   */
  CREATES_SALES_CYCLE SUBSCRIPTION invoice_key
  

THREAD MODE: SINGLE THREADED command

Since:

Sept 21, 2006

Author:

njeychandra

Field Summary

Fields

Modifier and Type	Field and Description
static java.lang.String	PARAM_KEY

Fields inherited from class com.aspc.commander.sql.SQLCommand

CURSOR_SIZE

Constructor Summary

Constructors

Constructor and Description
CreateSalesCycleCommand(Connection connection, Pattern pattern) Creates a new instance of CreateSalesCycleCommand

Method Summary

Modifier and Type	Method and Description
protected void	execute(Parser p) Execute the JOB command.
java.lang.String	getColumnName(int col) The column name
java.lang.String	getColumnType(int col) The column type
java.lang.String	getRecordID(int row) The record ID for this row
java.lang.Object	getValue(int row, int col) The value for this row/col

Methods inherited from class com.aspc.commander.sql.SQLCommand

appendResult, appendResult, getCursorName, getRecordKey, isExecuteOnly

Methods inherited from class com.aspc.commander.Command

execute, extMakeThreadName, getConnection, getPattern, getRawTitle, getTitle, makeThreadName, recordCall, setTitle

Methods inherited from class java.lang.Object

clone, equals, finalize, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Methods inherited from interface com.aspc.commander.sql.results.CommandBuildResultsPlugin

getRawTitle

Field Detail

PARAM_KEY

public static final java.lang.String PARAM_KEY

See Also:

Constant Field Values

Constructor Detail

CreateSalesCycleCommand

public CreateSalesCycleCommand(Connection connection,
                               Pattern pattern)

Creates a new instance of CreateSalesCycleCommand

Method Detail

execute

protected void execute(Parser p)
                throws java.lang.Exception

Execute the JOB command.

Specified by:

execute in class Command

Parameters:

p - the parameters

Throws:

java.lang.Exception - a serious problem

getColumnName

public java.lang.String getColumnName(int col)

The column name

Parameters:

col - offset from 1

Returns:

The name

getColumnType

public java.lang.String getColumnType(int col)
                               throws java.lang.Exception

The column type

Parameters:

col - offset from 1

Returns:

The column type

Throws:

java.lang.Exception - a serious problem

getValue

public java.lang.Object getValue(int row,
                                 int col)
                          throws java.lang.Exception

The value for this row/col

Parameters:

row - offset from 1

col - offset from 1

Returns:

The value

Throws:

java.lang.Exception - a serious problem

getRecordID

public java.lang.String getRecordID(int row)

The record ID for this row

Parameters:

row - offset from 1

Returns:

The record ID