Viewing file:  clshisaword.php (2.89 KB) -rwxr-xr-x
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class HisAword--------------------------
//--PK of HisAword ::
// 1. seqId
class HisAword extends clsDB{
var $result;
var $seqId;
var $alumniId;
var $awordNameT;
var $awordNameE;
var $awordCompany;
var $typeawordId;
var $levelawordId;
var $awordYear;
function HisAword(&$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 HisAword values(
'$this->seqId',
'$this->alumniId',
'$this->awordNameT',
'$this->awordNameE',
'$this->awordCompany',
'$this->typeawordId',
'$this->levelawordId',
'$this->awordYear'
)";
}else {
$sql = "update HisAword set
alumniId='$this->alumniId',
awordNameT='$this->awordNameT',
awordNameE='$this->awordNameE',
awordCompany='$this->awordCompany',
typeawordId='$this->typeawordId',
levelawordId='$this->levelawordId',
awordYear='$this->awordYear'
where seqId='$this->seqId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from HisAword where seqId='$this->seqId'");
}
function GetNextCode(){
$this->SetQuery("select max(seqId) as num from HisAword");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSHisAword(){
$this->SetQuery("select * from HisAword order by seqId");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->seqId = $this->result['seqId'];
$this->alumniId = $this->result['alumniId'];
$this->awordNameT = $this->result['awordNameT'];
$this->awordNameE = $this->result['awordNameE'];
$this->awordCompany = $this->result['awordCompany'];
$this->typeawordId = $this->result['typeawordId'];
$this->levelawordId = $this->result['levelawordId'];
$this->awordYear = $this->result['awordYear'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from HisAword where seqId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function RSHisAwordByAlumni($xKey){
$this->SetQuery("select * from HisAword where alumniId= '$xKey' order by awordYear");
}
function RSHisAwordByTypeaword($xKey,$yKey){
if($yKey == 0)
$this->SetQuery("select * from HisAword where typeawordId= '$xKey' order by awordYear");
else
$this->SetQuery("select * from HisAword where typeawordId= '$xKey' and levelawordId= '$xKey' order by awordYear");
}
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 HisAword--
?>
|