invoice

java.lang.Object
- com.rimptec.invoice.invoice_sql

public class invoice_sql
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`java.lang.String`	`currency`
`java.lang.String`	`custAdd1`
`java.lang.String`	`custAdd2`
`java.lang.String`	`customer`
`java.lang.String`	`empName`
`java.lang.String`	`errorMessage`
`double`	`gst`
`double`	`gTotal`
`java.lang.String`	`infoMessage1`
`java.lang.String`	`infoMessage2`
`java.util.Date`	`invDate`
`int`	`invoiceID`
`java.util.Date`	`ldate`
`java.lang.String`	`luser`
`java.lang.String`	`payTerm`
`java.lang.String`	`poRef`
`double`	`pst`
`java.lang.String`	`remarks`
`int`	`status`
`double`	`totalAmount`

Constructor Summary

Constructors
Constructor and Description

invoice_sql()

Constructors
Constructor and Description
`invoice_sql()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int`	`add(invoice cls)`
`void`	`connect()`
`invoice`	`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(invoice cls)`

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

Field Detail

errorMessage
```
public java.lang.String errorMessage
```

infoMessage1
```
public java.lang.String infoMessage1
```

infoMessage2
```
public java.lang.String infoMessage2
```

invoiceID
```
public int invoiceID
```

invDate
```
public java.util.Date invDate
```

totalAmount
```
public double totalAmount
```

pst
```
public double pst
```

gst
```
public double gst
```

gTotal
```
public double gTotal
```

poRef
```
public java.lang.String poRef
```

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

custAdd1
```
public java.lang.String custAdd1
```

custAdd2
```
public java.lang.String custAdd2
```

payTerm
```
public java.lang.String payTerm
```

currency
```
public java.lang.String currency
```

empName
```
public java.lang.String empName
```

remarks
```
public java.lang.String remarks
```

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

ldate
```
public java.util.Date ldate
```

status
```
public int status
```

Constructor Detail
- invoice_sql
```
public invoice_sql()
```

Method Detail

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

add
```
public int add(invoice cls)
```

edit

public java.lang.String edit(int pid)

update
```
public int update(invoice cls)
```

createClass
```
public invoice 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 invoice_sql

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

errorMessage

infoMessage1

infoMessage2

invoiceID

invDate

totalAmount

pst

gst

gTotal

poRef

customer

custAdd1

custAdd2

payTerm

currency

empName

remarks

luser

ldate

status

Constructor Detail

invoice_sql

Method Detail

connect

add

edit

update

createClass

runQuery

runQueryS

ctable