public List <CategoriaNivelUm> RetornoCategoriaNivelUm(long Id_T024)
        {
            List <CategoriaNivelUm> RetornoList = new List <CategoriaNivelUm>();

            try
            {
                SqlConnection con  = new SqlConnection(new CriptografiaDAO().Decrypt(ConfigurationManager.ConnectionStrings["EntidadesContext"].ConnectionString));
                StringBuilder sSQL = new StringBuilder();

                sSQL.Append("SELECT dbo.TB024_Sessao.TB024_Status, dbo.TB024_Sessao.TB024_Id, dbo.TB024_Sessao.TB024_Sessao, dbo.TB021_CategoriaNivel1.TB021_id,  ");
                sSQL.Append("dbo.TB021_CategoriaNivel1.TB021_Descricao ");
                sSQL.Append("FROM dbo.TB024_Sessao INNER JOIN ");
                sSQL.Append(" dbo.TB021_TB024 ON dbo.TB024_Sessao.TB024_Id = dbo.TB021_TB024.TB024_Id INNER JOIN ");
                sSQL.Append(" dbo.TB021_CategoriaNivel1 ON dbo.TB021_TB024.TB021_id = dbo.TB021_CategoriaNivel1.TB021_id ");
                sSQL.Append("WHERE dbo.TB024_Sessao.TB024_Id =  ");
                sSQL.Append(Id_T024);
                sSQL.Append("AND dbo.TB024_Sessao.TB024_Status = 1 ");
                sSQL.Append("ORDER BY dbo.TB021_CategoriaNivel1.TB021_Descricao ");

                SqlCommand command = new SqlCommand(sSQL.ToString(), con);

                con.Open();
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    CategoriaNivelUm obj = new CategoriaNivelUm();

                    obj.Id        = Convert.ToInt64(reader["TB021_id"]);
                    obj.Descricao = Convert.ToString(reader["TB021_Descricao"]).TrimEnd();
                    RetornoList.Add(obj);
                }

                con.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(RetornoList);
        }
Exemple #2
0
        public List <CategoriaNivelUm> ParceiroAreasNivel1(long Id_T020)
        {
            List <CategoriaNivelUm> Retorno_L = new List <CategoriaNivelUm>();

            try
            {
                SqlConnection con  = new SqlConnection(new CriptografiaDAO().Decrypt(ConfigurationManager.ConnectionStrings["EntidadesContext"].ConnectionString));
                StringBuilder sSQL = new StringBuilder();

                sSQL.Append(" SELECT dbo.TB020_Unidades.TB020_id, dbo.TB021_CategoriaNivel1.TB021_id, dbo.TB021_CategoriaNivel1.TB021_Descricao ");
                sSQL.Append(" FROM dbo.TB021_TB012 INNER JOIN ");
                sSQL.Append(" dbo.TB021_CategoriaNivel1 ON dbo.TB021_TB012.TB021_id = dbo.TB021_CategoriaNivel1.TB021_id INNER JOIN ");
                sSQL.Append(" dbo.TB020_Unidades ON dbo.TB021_TB012.TB012_id = dbo.TB020_Unidades.TB012_id ");
                sSQL.Append(" GROUP BY dbo.TB020_Unidades.TB020_id, dbo.TB021_CategoriaNivel1.TB021_id, dbo.TB021_CategoriaNivel1.TB021_Descricao ");
                sSQL.Append(" HAVING dbo.TB020_Unidades.TB020_id = ");
                sSQL.Append(Id_T020);

                SqlCommand command = new SqlCommand(sSQL.ToString(), con);

                con.Open();
                SqlDataReader reader = command.ExecuteReader();

                while (reader.Read())
                {
                    CategoriaNivelUm obj = new CategoriaNivelUm();
                    obj.Id        = Convert.ToInt64(reader["TB021_id"]);
                    obj.Descricao = reader["TB021_Descricao"].ToString().TrimEnd().Trim();
                    Retorno_L.Add(obj);
                }

                con.Close();
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(Retorno_L);
        }