Viewing file:  clsDocCommentPropose.php (2.66 KB) -rw-r--r--
Select action/file-type:
 (+) |  (+) |  (+) | Code (+) | Session (+) |  (+) | SDB (+) |  (+) |  (+) |  (+) |  (+) |  (+) |
<?php
//--Class doccommentpropose--------------------------
//--PK of doccommentpropose ::
// 1. dCpID
include_once "../link/keyThai.php";
class doccommentpropose extends clsDB{
var $result;
var $dCpID;
var $commentP;
var $orderP;
var $commentUse;
function doccommentpropose(&$c){
$this->c=$c->c;
$this->DB=$c->db;
}
function Save(){
if ($this->status==1){
$sql = "insert into doccommentpropose values(
'".th2a($this->dCpID)."',
'".th2a($this->commentP)."',
'".th2a($this->orderP)."',
'".th2a($this->commentUse)."'
)";
}else {
$sql = "update doccommentpropose set
commentP='".th2a($this->commentP)."',
orderP='".th2a($this->orderP)."',
commentUse='".th2a($this->commentUse)."'
where dCpID='".th2a($this->dCpID)."'";
}
return $this->Dml($sql);
}
function Delete(){
return $this->Dml("delete from doccommentpropose where dCpID='$this->dCpID'");
}
function GetNextCode(){
$this->SetQuery("select max(dCpID) as num from doccommentpropose");
if ($result=$this->GetResult()) {
return $result['num']+1;
}
}
function RSdoccommentpropose(){
$this->SetQuery("select * from doccommentpropose where commentUse='Y' order by orderP asc");
}
function NumRow(){
return $this->GetRowSelected();
}
function GetRecord(){
$numFields = $this->NumField();
$row = $this->GetResult();
if ($row){
for ($i=0; $i<$numFields; $i++){
eval("\$this->".mysql_field_name($this->rs, $i)."=\$row['".mysql_field_name($this->rs, $i)."'];");
}
return true;
}else{ // clear value of Member;
for ($i=0; $i<$numFields; $i++){
eval("\$this->".mysql_field_name($this->rs, $i)."='';");
}
return false;
}
}
function SearchByKey($xKey){
if ($this->SetQuery("select * from doccommentpropose where dCpID= '$xKey'")){
return 1;
}else {
return 0;
}
}
function GetMinOrderP(){
$this->SetQuery("select min(orderP) as num from doccommentpropose");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function GetMaxOrderP(){
$this->SetQuery("select max(orderP) as num from doccommentpropose");
if ($result=$this->GetResult()) {
return $result['num'];
}
}
function RSdoccommentproposeAll(){
$this->SetQuery("select * from doccommentpropose order by orderP asc");
}
function SearchBydCpIDlimitPreSeq($yKey){
if ($this->SetQuery("select * from doccommentpropose where orderP < '$yKey' order by orderP desc limit 1")){
return 1;
}else {
return 0;
}
}
function SearchBydCpIDlimitNextSeq($yKey){
if ($this->SetQuery("select * from doccommentpropose where orderP > '$yKey' order by orderP asc limit 1")){
return 1;
}else {
return 0;
}
}
//****************** You can add new functions below **********************//
} //--End class doccommentpropose--
?>
|