Viewing file: clsProposeType.php (1.68 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php //--Class base_ProposeType-------------------------- //--PK of base_ProposeType :: // 1. PtID
include_once "../link/keyThai.php"; class ProposeType extends clsDB{
var $result;
var $PtID; var $PtName;
function ProposeType(&$c){ $this->c=$c->c; $this->DB=$c->db; } function AddNew(){ $this->status = 1; }
function Edit(){ $this->status = 2; }
function Save(){ if ($this->status==1){ //$this->PtID=$this->GetNextCode(); $sql = "insert into ProposeType values('".th2a($this->PtID)."', '".th2a($this->PtName)."')"; }else { $sql = "update ProposeType set PtName='".th2a($this->PtName)."' where PtID='".th2a($this->PtID)."'"; } return $this->Dml($sql); }
function Delete(){ return $this->Dml("delete from ProposeType where PtID='$this->PtID'"); }
function GetNextCode(){ $this->SetQuery("select max(PtID) as num from ProposeType"); if ($result=$this->GetResult()) { return $result['num']+1; } }
function RSProposeType(){ $this->SetQuery("select * from ProposeType order by PtID"); }
function GetRecord(){ $numFields = $this->NumField(); $row = $this->GetResult(); if ($row){ for ($i=0; $i<$numFields; $i++){ eval("\$this->".mysql_field_name($this->rs, $i)."=\$row['".mysql_field_name($this->rs, $i)."'];"); $this->PtName=a2th($this->PtName); } return true; }else{ // clear value of Member; for ($i=0; $i<$numFields; $i++){ eval("\$this->".mysql_field_name($this->rs, $i)."='';"); } return false; } } function SearchByKey($xKey){ if ($this->SetQuery("select * from ProposeType where PtID= '$xKey'")){ return 1; }else { return 0; } }
//****************** You can add new functions below **********************//
} //--End class base_DocSpeedLevel--
?>
|