Viewing file: clstimeqn.php (1.78 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class TimeQn--------------------------
//--PK of TimeQn ::
// 1. seqId
class TimeQn extends clsDB{
var $result;
var $seqId;
var $startDate;
var $endDate;
function TimeQn(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
//uncomment a line below if your table use ID as running number
//$this->seqId=$this->GetNextCode();
$sql = "insert into TimeQn values(
'$this->seqId',
'$this->startDate',
'$this->endDate'
)";
}else {
$sql = "update TimeQn set
startDate='$this->startDate',
endDate='$this->endDate'
where seqId='$this->seqId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from TimeQn where seqId='$this->seqId'");
}
function GetNextCode(){
$this->SetQuery("select max(seqId) as num from TimeQn");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSTimeQn(){
$this->SetQuery("select * from TimeQn order by seqId");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->seqId = $this->result['seqId'];
$this->startDate = $this->result['startDate'];
$this->endDate = $this->result['endDate'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from TimeQn where seqId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function NextPage($pg){
if ($this->lastSql<>""){
$this->frRowNum=($pg-1)*$GLOBALS["rowPerPage"];
$sql = $this->lastSql." limit $this->frRowNum,".$GLOBALS["rowPerPage"];
$this->SetQueryPage($sql);
}
}
function NumPage() {
return ceil($this->numRows/$GLOBALS["rowPerPage"]);
}
} //--End class TimeQn--
?>
|