lehal_cwr

java.lang.Object
- com.rimptec.cwr.lehal_cwr_sql

public class lehal_cwr_sql
extends java.lang.Object

Field Summary

Fields
Modifier and Type	Field and Description
`java.lang.String[]`	`activity`
`java.lang.String`	`cadsys`
`java.lang.String`	`changelog`
`java.sql.Date`	`ck_cdate`
`java.lang.String`	`ck_comment`
`java.lang.String`	`ck_name`
`java.sql.Date`	`ck_rdate`
`java.lang.String`	`customer`
`java.lang.String`	`cwrno`
`java.lang.String`	`des_acttime`
`java.sql.Date`	`des_cdate`
`java.lang.String`	`des_comment`
`java.lang.String`	`des_esttime`
`java.lang.String`	`des_name`
`java.sql.Date`	`des_rdate`
`java.lang.String`	`des_sch_cdate`
`java.lang.String`	`detail`
`java.lang.String`	`ecrnum`
`java.lang.String`	`informat`
`boolean`	`isCancelled`
`boolean`	`isCkComplete`
`boolean`	`isCkWaived`
`boolean`	`isClosed`
`boolean`	`isDesComplete`
`boolean`	`isEngrApproved`
`boolean`	`isRecCk`
`boolean`	`isRecDes`
`boolean`	`isScheduled`
`mydb`	`mdb`
`java.lang.String`	`orig_comment`
`java.sql.Date`	`orig_date`
`java.lang.String`	`orig_duedate`
`java.lang.String`	`orig_duetime`
`java.lang.String`	`orig_email`
`java.lang.String`	`orig_esttime`
`java.lang.String`	`orig_name`
`java.lang.String`	`orig_phone`
`java.lang.String`	`outformat`
`java.lang.String`	`proj_num`
`java.sql.Date`	`sched_adate`
`java.lang.String`	`sched_auth_ot`
`java.lang.String`	`sched_comment`
`java.sql.Date`	`sched_duedate`
`java.sql.Date`	`sched_duedated`
`java.lang.String`	`sched_esttime`
`java.lang.String`	`sched_name`
`java.sql.Date`	`sched_rdate`
`int`	`workcomp`

Constructor Summary

Constructors
Constructor and Description

lehal_cwr_sql()

Constructors
Constructor and Description
`lehal_cwr_sql()`

Method Summary

All Methods Instance Methods Concrete Methods
Modifier and Type	Method and Description
`int`	`addCWR(lehal_cwr cls)`
`void`	`connect()`
`int`	`createTable()`
`java.lang.String`	`edit(int pid)`
`lehal_cwr`	`getCWR(java.lang.String pid)`
`java.lang.String`	`getZeroDate()`
`int`	`runQueryE(java.lang.String query)`
`java.sql.ResultSet`	`runQueryS(java.lang.String query)`
`java.lang.String`	`td(java.util.Date date)`
`int`	`update(lehal_cwr cls)`

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

Field Detail

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

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

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

orig_date
```
public java.sql.Date orig_date
```

orig_duedate
```
public java.lang.String orig_duedate
```

orig_duetime
```
public java.lang.String orig_duetime
```

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

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

cadsys
```
public java.lang.String cadsys
```

ecrnum
```
public java.lang.String ecrnum
```

cwrno
```
public java.lang.String cwrno
```

sched_name
```
public java.lang.String sched_name
```

sched_rdate
```
public java.sql.Date sched_rdate
```

sched_adate
```
public java.sql.Date sched_adate
```

sched_duedate
```
public java.sql.Date sched_duedate
```

sched_duedated
```
public java.sql.Date sched_duedated
```

sched_auth_ot
```
public java.lang.String sched_auth_ot
```

activity
```
public java.lang.String[] activity
```

informat
```
public java.lang.String informat
```

outformat
```
public java.lang.String outformat
```

des_name
```
public java.lang.String des_name
```

des_rdate
```
public java.sql.Date des_rdate
```

des_cdate
```
public java.sql.Date des_cdate
```

des_esttime
```
public java.lang.String des_esttime
```

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

sched_esttime
```
public java.lang.String sched_esttime
```

des_acttime
```
public java.lang.String des_acttime
```

des_sch_cdate
```
public java.lang.String des_sch_cdate
```

ck_name
```
public java.lang.String ck_name
```

ck_rdate
```
public java.sql.Date ck_rdate
```

ck_cdate
```
public java.sql.Date ck_cdate
```

detail
```
public java.lang.String detail
```

orig_comment
```
public java.lang.String orig_comment
```

sched_comment
```
public java.lang.String sched_comment
```

des_comment
```
public java.lang.String des_comment
```

ck_comment
```
public java.lang.String ck_comment
```

isScheduled
```
public boolean isScheduled
```

isRecDes
```
public boolean isRecDes
```

isRecCk
```
public boolean isRecCk
```

isCkWaived
```
public boolean isCkWaived
```

isDesComplete
```
public boolean isDesComplete
```

isCkComplete
```
public boolean isCkComplete
```

isEngrApproved
```
public boolean isEngrApproved
```

isClosed
```
public boolean isClosed
```

isCancelled
```
public boolean isCancelled
```

changelog
```
public java.lang.String changelog
```

workcomp
```
public int workcomp
```

mdb
```
public mydb mdb
```

Constructor Detail
- lehal_cwr_sql
```
public lehal_cwr_sql()
```

Method Detail

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

createTable
```
public int createTable()
```

addCWR
```
public int addCWR(lehal_cwr cls)
```

edit

public java.lang.String edit(int pid)

update
```
public int update(lehal_cwr cls)
```

getCWR

public lehal_cwr getCWR(java.lang.String pid)

runQueryE

public int runQueryE(java.lang.String query)

runQueryS

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

td

public java.lang.String td(java.util.Date date)

getZeroDate
```
public java.lang.String getZeroDate()
```

Class lehal_cwr_sql

Field Summary

Constructor Summary

Method Summary

Methods inherited from class java.lang.Object

Field Detail

orig_name

orig_phone

orig_email

orig_date

orig_duedate

orig_duetime

proj_num

customer

cadsys

ecrnum

cwrno

sched_name

sched_rdate

sched_adate

sched_duedate

sched_duedated

sched_auth_ot

activity

informat

outformat

des_name

des_rdate

des_cdate

des_esttime

orig_esttime

sched_esttime

des_acttime

des_sch_cdate

ck_name

ck_rdate

ck_cdate

detail

orig_comment

sched_comment

des_comment

ck_comment

isScheduled

isRecDes

isRecCk

isCkWaived

isDesComplete

isCkComplete

isEngrApproved

isClosed

isCancelled

changelog

workcomp

mdb

Constructor Detail

lehal_cwr_sql

Method Detail

connect

createTable

addCWR

edit

update

getCWR

runQueryE

runQueryS

td

getZeroDate