Viewing file: clstypeaword.php (2.6 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class base_typeaword--------------------------
//--PK of base_typeaword ::
// 1. typeawordId
class TypeAword extends clsDB{
var $result;
var $typeawordId;
var $typeawordNameE;
var $typeawordNameT;
function TypeAword(&$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){
$sql = "insert into TypeAword values('$this->typeawordId', '$this->typeawordNameE', '$this->typeawordNameT')";
}else {
$sql = "update TypeAword set typeawordNameE='$this->typeawordNameE',typeawordNameT='$this->typeawordNameT' where typeawordId='$this->typeawordId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from TypeAword where typeawordId='$this->typeawordId'");
}
function GetNextCode(){
$this->SetQuery("select max(typeawordId) as num from TypeAword");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSTypeAword(){
$this->SetQuery("select * from TypeAword order by typeawordId");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->typeawordId = $this->result['typeawordId'];
$this->typeawordNameE = $this->result['typeawordNameE'];
$this->typeawordNameT = $this->result['typeawordNameT'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from TypeAword where typeawordId= '$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->RSTypeAword();
while($this->GetRecord()){
$s.="<option value=\"$this->typeawordId\" ";
$s.=($this->typeawordId==$ID) ? "Selected" : "" ;
$s.=">$this->typeawordNameT\n";
}
return $s.="</select>\n";
}
function RSTypeAwordNameId($xKey){
$this->SetQuery("select * from TypeAword where typeawordNameT like '%$xKey%'order by typeawordId ");
}
function RSTypeAwordId($xKey){
if($xKey == 0)
$this->SetQuery("select * from TypeAword order by typeawordId ");
else
$this->SetQuery("select * from TypeAword where typeawordId = '$xKey' ");
}
function NextPage($pg=1){
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 base_typeaword--
?>
|