public bool valida_login(cUsuario user) { try { #region QUERY cGlobal.query = "SELECT TB1.LOGIN, TB2.SETOR FROM USUARIO_TB TB1, SETOR_TB TB2 " + "WHERE TB2.ID_SETOR = TB1.ID_SETOR " + "AND TB1.LOGIN = '******' " + "AND TB1.PWD = '" + user.senha + "' "; using (DataTable dt = dao.retorna_datatable(cGlobal.query)) { if (dt.Rows.Count == 0) { return(false); } else { cGlobal.userlogado = (dt.Rows[0]).ItemArray[0].ToString(); cGlobal.userSetor = (dt.Rows[0]).ItemArray[1].ToString(); return(true); } } #endregion } catch (OleDbException ex) { throw ex; } }
public DataTable preenche_lista_setor() { try { #region QUERY cGlobal.query = "SELECT * FROM SETOR_TB WHERE ID_SETOR <> 1 ORDER BY ID_SETOR DESC"; using (DataTable dt = dao.retorna_datatable(cGlobal.query)) { return(dt); } #endregion } catch (OleDbException ex) { throw ex; } }
public DataTable preenche_lista_fundo() { try { #region QUERY cGlobal.query = "SELECT * FROM FUNDO_TB "; using (DataTable dt = dao.retorna_datatable(cGlobal.query, "cnn")) { return(dt); } #endregion } catch (Exception ex) { throw ex; } }
public DataTable conexoes() { try { #region QUERY cDAO dao = new cDAO(); cGlobal.query = "SELECT * FROM CONEXAO_TB "; using (DataTable dt = dao.retorna_datatable(cGlobal.query)) { return(dt); } #endregion } catch (Exception ex) { throw ex; } }
public DataTable arquivos(string campos) { try { #region QUERY cDAO dao = new cDAO(); cGlobal.query = string.Format("SELECT {0} FROM DIRETORIO_TB WHERE ID_SETOR = {1}", campos, cGlobal.userSetor); using (DataTable dt = dao.retorna_datatable(cGlobal.query, "cnn")) { return(dt); } #endregion } catch (Exception ex) { throw ex; } }
public DataTable diretorios(cConfiguracao cf) { try { #region QUERY cDAO dao = new cDAO(); if (cf.setor.Equals("PROCESSAMENTO")) { cGlobal.query = "SELECT SAC,DI8 FROM DIRETORIO_TB " + "INNER JOIN SETOR_TB ON SETOR_TB.ID_SETOR = DIRETORIO_TB.ID_SETOR " + "WHERE SETOR_TB.SETOR = '" + cf.setor + "' "; } using (DataTable dt = dao.retorna_datatable(cGlobal.query)) { return(dt); } #endregion } catch (Exception ex) { throw ex; } }