Viewing file: clsCorrespondenceletter_Log.php (1.2 KB) -rw-r--r-- Select action/file-type: (+) | (+) | (+) | Code (+) | Session (+) | (+) | SDB (+) | (+) | (+) | (+) | (+) | (+) |
<?php //--Class correspondenceletter_log-------------------------- //--PK of correspondenceletter_log :: // 1. cdl_ID include_once "../link/keyThai.php"; class correspondenceletter_log extends clsDB{
var $result;
var $cdl_ID; var $cdl_Process_Id; var $cdl_Process_Time; var $cdl_Letter_ID; var $cdl_Status;
function correspondenceletter_log(&$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->DtID=$this->GetNextCode(); $sql = "insert into correspondenceletter_log values( '".$this->cdl_ID."', '".$this->cdl_Process_Id."', '".$this->cdl_Process_Time."', '".$this->cdl_Letter_ID."', '".$this->cdl_Status."' )"; }else { $sql = "update correspondenceletter_log set cdl_Process_Id='".$this->cdl_Process_Id."', cdl_Process_Time='".$this->cdl_Process_Time."', cdl_Letter_ID='".$this->cdl_Letter_ID."', cdl_Status='".$this->cdl_Status."' where cdl_ID='".$this->cdl_ID."'"; } return $this->Dml($sql); } function GetNextCode(){ $this->SetQuery("select max(cdl_ID) as num from correspondenceletter_log"); if ($result=$this->GetResult()) { return $result['num']+1; } } } ?>
|