public void grava_acesso(cUsuario user) { try { #region QUERY cGlobal.query = "INSERT INTO USUARIO_TB (USUARIO," + "EMAIL," + "LOGIN," + "PWD," + "DTCAD," + "RESET_PWD," + "ADM," + "ATIVO," + "ID_SETOR)" + "VALUES('" + user.usuario + "', " + "'" + user.email + "', " + "'" + user.login + "', " + "'" + user.senha + "', " + "'" + user.dtcad + "'," + "0," + "0," + "0," + "1)"; dao.executa_query(cGlobal.query); #endregion } catch (OleDbException ex) { throw ex; } }
public void grava_setor(cSetor cst) { try { #region QUERY cGlobal.query = "INSERT INTO SETOR_TB (SETOR, USERCAD, DTCAD) " + "VALUES('" + cst.setor + "', '" + cGlobal.userlogado + "', '" + DateTime.Now + "') "; dao.executa_query(cGlobal.query); #endregion } catch (OleDbException ex) { throw ex; } }
public bool exclui_fundo(cFundo cfun) { try { #region QUERY cGlobal.query = "DELETE FROM FUNDO_TB WHERE ID_SETOR = " + cfun.codfundo + " "; dao.executa_query(cGlobal.query, "cnn"); return(false); #endregion } catch (Exception ex) { throw ex; } }
public void grava_log(cLog log) { try { #region QUERY cGlobal.query = "INSERT INTO LOG_TB(LOG,FORM,METODO,DT,USER_SISTEMA,USER_REDE,TERMINAL,FLAG) VALUES('" + log.log + "','" + log.form + "', '" + log.metodo + "', '" + log.dt + "','" + log.usersistema + "','" + log.userRede + "','" + log.terminal + "', " + log.tp_flag + ")"; dao.executa_query(cGlobal.query); #endregion } catch (OleDbException ex) { throw ex; } }
public void update_conexao(cConfiguracao cf) { try { #region QUERY cDAO dao = new cDAO(); cGlobal.query = "UPDATE CONEXAO_TB SET DIRETORIO = '" + cf.diretorio + "', TAMANHO = '" + cf.tamanho + "' WHERE BANCO = '" + cf.banco + "' "; dao.executa_query(cGlobal.query); #endregion } catch (Exception ex) { throw ex; } }
public void update_diretorios(cConfiguracao cf) { try { #region QUERY cDAO dao = new cDAO(); if (cf.setor.Equals("PROCESSAMENTO")) { cGlobal.query = "UPDATE DIRETORIO_TB SET " + "SAC = '" + cf.sac + "', " + "DI8 = '" + cf.di8 + "' " + "WHERE ID_SETOR = (SELECT ID_SETOR FROM SETOR_TB WHERE SETOR = '" + cf.setor + "')"; } dao.executa_query(cGlobal.query); #endregion } catch (Exception ex) { throw ex; } }