Viewing file:  clsprefix.php (2.73 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class Prefix--------------------------
//--PK of Prefix ::
// 1. prefixId
include_once "clsDB.php";
class Prefix extends db{
var $result;
var $prefixId;
var $prefixName;
var $prefixNameEng;
var $defaultSex;
var $pbriId;
function Prefix(&$c){
$this->c=$c;
}
function AddNew(){
$this->status = 1;
}
function Edit(){
$this->status = 2;
}
function Save(){
//--1 เป็นข้อมูลใหม่ 2 เป็นข้อมูลเดิม
//$this->prefixId = ($this->prefixId =='') ? "NULL" : "'".$this->prefixId"'"; $this->prefixName = ($this->prefixName =='') ? "NULL" : "'".$this->prefixName"'"; $this->prefixNameEng = ($this->prefixNameEng =='') ? "NULL" : "'".$this->prefixNameEng"'"; $this->defaultSex = ($this->defaultSex =='') ? "NULL" : "'".$this->defaultSex"'";
if ($this->status==1){
//$this->prefixId=$this->GetNextCode();
$sql = "insert into Prefix values('$this->prefixId', '$this->prefixName', '$this->prefixNameEng', '$this->defaultSex', '$this->pbriId')";
}else {
$sql = "update Prefix set prefixName='$this->prefixName', prefixNameEng='$this->prefixNameEng', defaultSex='$this->defaultSex', pbriId='$this->pbriId' 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 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'];
$this->prefixNameEng = $this->result['prefixNameEng'];
$this->defaultSex = $this->result['defaultSex'];
$this->pbriId = $this->result['pbriId'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from Prefix where prefixId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function selectHTML($name, $ID=""){
$s="<select name=\"$name\">\n";
$s.="<option value=\"0\">---เลือกคำนำหน้าชื่อ---\n";
$this->RSPrefix();
while($this->GetRecord()){
$s.="<option value=\"$this->prefixId\" ";
$s.=($this->prefixId==$ID) ? "Selected" : "" ;
$s.=">$this->prefixName\n";
}
return $s.="</select>\n";
}
function RSprefixName($xKey){
$this->SetQuery("select * from Prefix where prefixName like '%$xKey%'order by prefixName ");
}
function RSprefixNameId($xKey){
$this->SetQuery("select * from Prefix where prefixName like '%$xKey%'order by prefixId ");
}
} //--End class base_Prefix--
?>
|