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;
}
}