function Exclui() { //Exclui a reuniao if ($this->Existe == 'N') { return; } $db = new BDSMS(); $sql = sprintf("delete from tb_mensagem where id = %d", $this->getID()); $db->Exec($sql); $db->Close(); }
function Inclui() { //Insere nova reunião /* echo ($this->getType())."<br/>"; echo ($this->getRecipient())."<br/>"; echo ($this->getText())."<br/>"; echo ($this->getEncoding())."<br/>"; echo ($this->getStatus_report())."<br/>"; echo ($this->getSent_date())."<br/>"; echo ($this->getRef_no())."<br/>"; echo ($this->getStatus())."<br/>"; echo ($this->geterrors())."<br/>"; */ $db = new BDSMS(); $sql = sprintf("insert into smsserver_out\n\t\t \t\t\t\t (\ttype,\n\t\t\t\t\t \t\trecipient,\n\t\t\t\t\t \t\ttext,\n\t\t\t\t\t \t\tencoding,\n\t\t\t\t\t \t\tstatus_report,\n\t\t\t\t\t \t\tsent_date,\n\t\t\t\t\t \t\tref_no,\n\t\t\t\t\t \t\tstatus,\n\t\t\t\t\t \t\terrors,\n\t\t\t\t\t \t\tcreate_date,\n\t\t\t\t\t \t\tidmsg\n\t\t\t\t\t \t\t)\n\t\t\t\t\t\t values ('%s','%s','%s','%s',%d,'%s','%s','%s',%d,now(),%d)", $this->getType(), $this->getRecipient(), $this->getText(), $this->getEncoding(), $this->getStatus_report(), $this->getSent_date(), $this->getRef_no(), $this->getStatus(), $this->geterrors(), $this->getIDMsg()); $db->Exec($sql); $this->ID = $db->getInsertID(); $db->Close(); }