Viewing file: clshiswork.php (2.58 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class HisWork--------------------------
//--PK of HisWork ::
// 1. seqId
class HisWork extends clsDB{
var $result;
var $seqId;
var $alumniId;
var $companyNameT;
var $companyNameE;
var $companyAddr;
var $companyPosition;
var $companyAdmidPosYear;
function HisWork(&$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 HisWork values(
'$this->seqId',
'$this->alumniId',
'$this->companyNameT',
'$this->companyNameE',
'$this->companyAddr',
'$this->companyPosition',
'$this->companyAdmidPosYear'
)";
}else {
$sql = "update HisWork set
alumniId='$this->alumniId',
companyNameT='$this->companyNameT',
companyNameE='$this->companyNameE',
companyAddr='$this->companyAddr',
companyPosition='$this->companyPosition',
companyAdmidPosYear='$this->companyAdmidPosYear'
where seqId='$this->seqId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from HisWork where seqId='$this->seqId'");
}
function GetNextCode(){
$this->SetQuery("select max(seqId) as num from HisWork");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSHisWork(){
$this->SetQuery("select * from HisWork order by seqId");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->seqId = $this->result['seqId'];
$this->alumniId = $this->result['alumniId'];
$this->companyNameT = $this->result['companyNameT'];
$this->companyNameE = $this->result['companyNameE'];
$this->companyAddr = $this->result['companyAddr'];
$this->companyPosition = $this->result['companyPosition'];
$this->companyAdmidPosYear = $this->result['companyAdmidPosYear'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from HisWork where seqId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
function RSHisWorkByAlumni($xKey){
$this->SetQuery("select * from HisWork where alumniId= '$xKey' order by companyAdmidPosYear");
}
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 HisWork--
?>
|