public function alterar(ContaBancaria $obj)
{
$strSQL = "UPDATE FIN_COB_CONTAS_BANCARIAS SET ";
$strSQL .= "BAN_ID = " . $obj->getBanco()->getId() . ", ";
$strSQL .= "COB_Descricao = '" . $obj->getDescricao() . "', ";
$strSQL .= "COB_DataAbertura = '" . $obj->getDataAbertura() . "', ";
$strSQL .= "COB_Agencia = '" . $obj->getAgencia() . "', ";
$strSQL .= "COB_Conta = '" . $obj->getConta() . "', ";
$strSQL .= "COB_SaldoInicial = " . $obj->getSaldoInicial() . ", ";
$strSQL .= "COB_Observacao = '" . $obj->getObservacao() . "', ";
$strSQL .= "COB_DataHoraAlteracao = '" . date("Y-m-d H:i:s") . "', ";
$strSQL .= "USU_Alteracao_ID = " . $_SESSION["USUARIO_ID"] . ", ";
$strSQL .= "COB_Status = '" . $obj->getStatus() . "' ";
$strSQL .= "WHERE COB_ID = " . $obj->getId();
return Db::getInstance()->executar($strSQL);
}