c=$c->c; $this->DB=$c->db; } function AddNew(){ $this->status = 1; } function Edit(){ $this->status = 2; } function Save(){ if ($this->status==1){ //$this->prefixId=$this->GetNextCode(); $sql = "insert into prefix values('$this->prefixId', '$this->prefixName')"; }else { $sql = "update prefix set prefixName='$this->prefixName' where prefixId='$this->prefixId'"; } return $this->Dml($sql); } function Delete(){ return $this->Dml("delete from prefix where prefixId='$this->prefixId'"); } function GetNextCode(){ $this->SetQuery("select max(prefixId) as num from prefix"); if ($result=$this->GetResult()) { return $result['num']+1; } } function GetNextCodeByCond($fieldnameindex="0", $cond="1", $delim="/", $count="1"){ $this->SetQuery("select max(substring_index(".mysql_field_name($this->SetQuery("select * from prefix"), $fieldnameindex).", '$delim', $count)) as num from prefix where $cond"); if ($result=$this->GetResult()) { return $result['num']+1; } } function RSprefix(){ $this->SetQuery("select * from prefix order by prefixId"); } function GetRecord(){ if ($this->result = $this->GetResult()) { $this->prefixId = $this->result['prefixId']; $this->prefixName = $this->result['prefixName']; return 1; }else { return 0; } } function SearchByKey($xKey){ include_once "../global.php"; $dbpeoplename=$GLOBALS['DBNAME_EPERSON']; $q="select * from ".$dbpeoplename.".prefix where prefixId= '$xKey'"; if ($this->SetQuery($q)){ return 1; }else { return 0; } } function SearchByKeydb($xKey,$db){ $q="select * from ".$db.".Prefix where prefixId= '$xKey'"; if ($this->SetQuery($q)){ return 1; }else { return 0; } } function GetCustomRecord($query){ $this->SetQuery($query); $this->result=$this->GetResult(); return $this->result; } function selectHTML($name, $ID=""){ $s="\n"; $s.="---เลือกหน่วยงานย่อยที่สังกัด---\n"; $this->RSprefix(); while($this->GetRecord()){ $s.="prefixId\" "; $s.=($this->prefixId==$ID) ? "Selected" : "" ; $s.=">$this->prefixName\n"; } return $s.="\n"; } } //--End class base_prefix-- ?>