rtececr

java.lang.Object
- com.rimptec.ecr.rtececr_sql

public class rtececr_sql
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`double`	`actCost`
`int`	`affects_process`
`int`	`affects_tool`
`int`	`affectsPip`
`java.lang.String`	`brief_desc`
`java.lang.String`	`cust_ref`
`java.lang.String`	`customer`
`java.lang.String`	`det_desc`
`java.lang.String`	`EC_Comments`
`java.lang.String`	`EC_Product`
`int`	`EC_Type`
`int`	`ecrnum`
`int`	`ECStatus`
`double`	`estBenefit`
`double`	`estCost`
`double`	`estpcost`
`double`	`estpsaving`
`java.util.Date`	`impl_date`
`java.lang.String`	`irrsnum`
`int`	`is_custpaid`
`int`	`isApproved`
`int`	`isCancelled`
`int`	`isClosed`
`int`	`isReleased`
`int`	`isValidReqd`
`java.util.Date`	`LastUpdated`
`java.lang.String`	`luser`
`mydb`	`mdb`
`java.util.Date`	`orig_date`
`java.util.Date`	`orig_duedate`
`java.lang.String`	`orig_email`
`java.lang.String`	`orig_esttime`
`java.lang.String`	`orig_name`
`java.lang.String`	`orig_phone`
`java.lang.String`	`orig_uid`
`int`	`progid`
`java.lang.String`	`proj_num`
`java.util.Date`	`release_date`
`java.lang.String`	`sReason`

Constructor Summary

Constructors
Constructor and Description

rtececr_sql()

Constructors
Constructor and Description
`rtececr_sql()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int`	`add(rtececr cls)`
`void`	`connect()`
`rtececr`	`createClass(int pid)`
`int`	`ctable()`
`java.lang.String`	`edit(int pid)`
`int`	`runQuery(java.lang.String query)`
`java.sql.ResultSet`	`runQueryS(java.lang.String query)`
`int`	`update(rtececr cls)`

Methods inherited from class java.lang.Object
equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Field Detail

ecrnum
```
public int ecrnum
```

progid
```
public int progid
```

orig_name
```
public java.lang.String orig_name
```

orig_uid
```
public java.lang.String orig_uid
```

orig_phone
```
public java.lang.String orig_phone
```

orig_email
```
public java.lang.String orig_email
```

orig_esttime
```
public java.lang.String orig_esttime
```

orig_date
```
public java.util.Date orig_date
```

orig_duedate
```
public java.util.Date orig_duedate
```

proj_num
```
public java.lang.String proj_num
```

customer
```
public java.lang.String customer
```

cust_ref
```
public java.lang.String cust_ref
```

is_custpaid
```
public int is_custpaid
```

affects_tool
```
public int affects_tool
```

affects_process
```
public int affects_process
```

brief_desc
```
public java.lang.String brief_desc
```

det_desc
```
public java.lang.String det_desc
```

EC_Type
```
public int EC_Type
```

EC_Product
```
public java.lang.String EC_Product
```

irrsnum
```
public java.lang.String irrsnum
```

EC_Comments
```
public java.lang.String EC_Comments
```

sReason
```
public java.lang.String sReason
```

LastUpdated
```
public java.util.Date LastUpdated
```

luser
```
public java.lang.String luser
```

estCost
```
public double estCost
```

estBenefit
```
public double estBenefit
```

actCost
```
public double actCost
```

ECStatus
```
public int ECStatus
```

isReleased
```
public int isReleased
```

isClosed
```
public int isClosed
```

isCancelled
```
public int isCancelled
```

isApproved
```
public int isApproved
```

estpcost
```
public double estpcost
```

estpsaving
```
public double estpsaving
```

release_date
```
public java.util.Date release_date
```

impl_date
```
public java.util.Date impl_date
```

affectsPip
```
public int affectsPip
```

isValidReqd
```
public int isValidReqd
```

mdb
```
public mydb mdb
```

Constructor Detail
- rtececr_sql
```
public rtececr_sql()
```

Method Detail

connect
```
public void connect()
```

add
```
public int add(rtececr cls)
```

edit

public java.lang.String edit(int pid)

update
```
public int update(rtececr cls)
```

createClass
```
public rtececr createClass(int pid)
```

runQuery

public int runQuery(java.lang.String query)

runQueryS

public java.sql.ResultSet runQueryS(java.lang.String query)

ctable
```
public int ctable()
```

Class rtececr_sql

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

ecrnum

progid

orig_name

orig_uid

orig_phone

orig_email

orig_esttime

orig_date

orig_duedate

proj_num

customer

cust_ref

is_custpaid

affects_tool

affects_process

brief_desc

det_desc

EC_Type

EC_Product

irrsnum

EC_Comments

sReason

LastUpdated

luser

estCost

estBenefit

actCost

ECStatus

isReleased

isClosed

isCancelled

isApproved

estpcost

estpsaving

release_date

impl_date

affectsPip

isValidReqd

mdb

Constructor Detail

rtececr_sql

Method Detail

connect

add

edit

update

createClass

runQuery

runQueryS

ctable