Viewing file: clsalumniqn.php (3.15 KB) -rwxr-xr-x Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php
//--Class AlumniQn--------------------------
//--PK of AlumniQn ::
// 1. qnId
class AlumniQn extends clsDB{
var $result;
var $qnId;
var $alumniId;
var $checkwork;
var $checkedu;
var $startDateWork;
var $workPosition;
var $workSalary;
var $leveleduId;
var $majoreduId;
var $educationId;
var $investiture;
var $updateByPerson;
var $writeDate;
function AlumniQn(&$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->qnId=$this->GetNextCode();
$sql = "insert into AlumniQn values(
'$this->qnId',
'$this->alumniId',
'$this->checkwork',
'$this->checkedu',
'$this->startDateWork',
'$this->workPosition',
'$this->workSalary',
'$this->leveleduId',
'$this->majoreduId',
'$this->educationId',
'$this->investiture',
'$this->updateByPerson',
'$this->writeDate'
)";
}else {
$sql = "update AlumniQn set
alumniId='$this->alumniId',
checkwork='$this->checkwork',
checkedu='$this->checkedu',
startDateWork='$this->startDateWork',
workPosition='$this->workPosition',
workSalary='$this->workSalary',
leveleduId='$this->leveleduId',
majoreduId='$this->majoreduId',
educationId='$this->educationId',
investiture='$this->investiture',
updateByPerson='$this->updateByPerson',
writeDate='$this->writeDate'
where qnId='$this->qnId'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from AlumniQn where qnId='$this->qnId'");
}
function GetNextCode(){
$this->SetQuery("select max(qnId) as num from AlumniQn");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSAlumniQn(){
$this->SetQuery("select * from AlumniQn order by qnId");
}
function GetRecord(){
if ($this->result = $this->GetResult()) {
$this->qnId = $this->result['qnId'];
$this->alumniId = $this->result['alumniId'];
$this->checkwork = $this->result['checkwork'];
$this->checkedu = $this->result['checkedu'];
$this->startDateWork = $this->result['startDateWork'];
$this->workPosition = $this->result['workPosition'];
$this->workSalary = $this->result['workSalary'];
$this->leveleduId = $this->result['leveleduId'];
$this->majoreduId = $this->result['majoreduId'];
$this->educationId = $this->result['educationId'];
$this->investiture = $this->result['investiture'];
$this->updateByPerson = $this->result['updateByPerson'];
$this->writeDate = $this->result['writeDate'];
return 1;
}else {
return 0;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from AlumniQn where qnId= '$xKey'")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
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 AlumniQn--
?>
|