public DataSet retorna_setor() { try { #region QUERY cGlobal.query = "SELECT * FROM SETOR_TB WHERE ID_SETOR <> 1 ORDER BY ID_SETOR DESC"; using (DataSet ds = dao.retorna_dataset(cGlobal.query)) { return(ds); } #endregion } catch (OleDbException ex) { throw ex; } }
public DataSet retorna_log(bool flag) { try { #region QUERY if (flag) { cGlobal.query = "SELECT * FROM LOG_TB WHERE FLAG = TRUE ORDER BY ID_LOG ASC"; } else { cGlobal.query = "SELECT * FROM LOG_TB WHERE FLAG = FALSE ORDER BY ID_LOG ASC"; } using (DataSet dst = dao.retorna_dataset(cGlobal.query, "cnn")) { return(dst); } #endregion } catch (OleDbException ex) { throw ex; } }