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->DlpId=$this->GetNextCode(); $sql = "insert into DocLinePosition values( '".th2a($this->DlpID)."', '".th2a($this->DlpName)."', '".th2a($this->GpID)."', '".th2a($this->DlpPID)."', '".th2a($this->DlpSeq)."', '".th2a($this->DlpPropose)."', '".th2a($this->DlpSign)."', '".th2a($this->DlpByPass)."', '".th2a($this->DlpSend)."', '".th2a($this->DlpView)."' )"; }else { $sql = "update DocLinePosition set DlpName='".th2a($this->DlpName)."' GpID='".th2a($this->GpID)."' DlpPID='".th2a($this->DlpPID)."' DlpSeq='".th2a($this->DlpSeq)."' where DlpID='".th2a($this->DlpID)."'"; } return $this->Dml($sql); } function Delete(){ return $this->Dml("delete from DocLinePosition where DlpID='$this->DlpID'"); } function GetNextCode(){ $this->SetQuery("select max(DlpId) as num from DocLinePosition"); if ($result=$this->GetResult()) { return $result['num']+1; } } function RSdocLinePosition(){ $this->SetQuery("select * from DocLinePosition order by DlpID"); } 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)."'];"); $this->DlpName=a2th($this->DlpName); } 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 DocLinePosition where DlpID= '$xKey'")){ return 1; }else { return 0; } } //****************** You can add new functions below **********************// function SearchByGpID($xKey){ if ($this->SetQuery("select * from DocLinePosition where GpID= '$xKey'")){ return 1; }else { return 0; } } function SearchDlpIDByGpID($xKey){ if ($this->SetQuery("select DlpID from DocLinePosition where GpID= '$xKey'")){ return 1; }else { return 0; } } function RSdocLinePositionParent(){ $this->SetQuery("select * from DocLinePosition where DlpPID = 0 order by DlpSeq asc ,DlpID"); } function RSdocLinePositionParentorderByDlpOrder(){ $this->SetQuery("select * from DocLinePosition where DlpPID = 0 order by DlpOrder asc"); } function SearchDlpPIDByDlpID($xKey){ //echo "select * from DocLinePosition where DlpPID = '$xKey'
"; if ($this->SetQuery("select * from DocLinePosition where DlpPID = '$xKey'")){ return 1; }else { return 0; } } function SearchByDlpID($xKey){ if ($this->SetQuery("select DlpName from DocLinePosition where DlpID= '$xKey'")){ return 1; }else { return 0; } } } //--End class person-- ?>