public List <CategoriaNivelTres> RetornoCategoriaNivelTres(string Id_T022) { List <CategoriaNivelTres> RetornoList = new List <CategoriaNivelTres>(); if (string.IsNullOrEmpty(Id_T022)) { return(RetornoList); } try { SqlConnection con = new SqlConnection(new CriptografiaDAO().Decrypt(ConfigurationManager.ConnectionStrings["EntidadesContext"].ConnectionString)); StringBuilder sSQL = new StringBuilder(); StringBuilder sClausula = new StringBuilder(); string[] Parametros = Id_T022.Split(';'); sClausula.Append(" WHERE TB022_id = "); sClausula.Append(Parametros[0]); if (Parametros.Length > 1) { for (int i = 1; i < Parametros.Length; i++) { sClausula.Append(" or TB022_id = "); sClausula.Append(Parametros[i]); } } sSQL.Append("SELECT TB022_id, TB023_id, TB023_Descricao "); sSQL.Append("FROM dbo.TB023_CategoriaNivel3 "); sSQL.Append(sClausula); sSQL.Append("ORDER BY TB022_id,TB023_Descricao "); SqlCommand command = new SqlCommand(sSQL.ToString(), con); con.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CategoriaNivelTres obj = new CategoriaNivelTres(); obj.Id_T022 = Convert.ToInt64(reader["TB022_id"]); obj.Id_T023 = Convert.ToInt64(reader["TB023_id"]); obj.Descricao = Convert.ToString(reader["TB023_Descricao"]).TrimEnd(); RetornoList.Add(obj); } con.Close(); } catch (Exception ex) { throw ex; } return(RetornoList); }
public List <CategoriaNivelTres> ParceiroAreasNivel3(long Id_T020, long Id_T022) { List <CategoriaNivelTres> Retorno_L = new List <CategoriaNivelTres>(); 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.TB023_CategoriaNivel3.TB022_id, dbo.TB023_CategoriaNivel3.TB023_id, dbo.TB023_CategoriaNivel3.TB023_Descricao "); sSQL.Append(" FROM dbo.TB020_Unidades INNER JOIN "); sSQL.Append(" dbo.TB023_TB012 ON dbo.TB020_Unidades.TB012_id = dbo.TB023_TB012.TB012_id INNER JOIN "); sSQL.Append(" dbo.TB023_CategoriaNivel3 ON dbo.TB023_TB012.TB023_id = dbo.TB023_CategoriaNivel3.TB023_id "); sSQL.Append(" GROUP BY dbo.TB020_Unidades.TB020_id, dbo.TB023_CategoriaNivel3.TB023_id, dbo.TB023_CategoriaNivel3.TB023_Descricao, dbo.TB023_CategoriaNivel3.TB022_id "); sSQL.Append(" HAVING dbo.TB020_Unidades.TB020_id = "); sSQL.Append(Id_T020); sSQL.Append(" AND dbo.TB023_CategoriaNivel3.TB022_id = "); sSQL.Append(Id_T022); sSQL.Append(" ORDER BY dbo.TB023_CategoriaNivel3.TB023_Descricao "); SqlCommand command = new SqlCommand(sSQL.ToString(), con); con.Open(); SqlDataReader reader = command.ExecuteReader(); while (reader.Read()) { CategoriaNivelTres obj = new CategoriaNivelTres(); obj.Id_T023 = Convert.ToInt64(reader["TB023_id"]); obj.Descricao = reader["TB023_Descricao"].ToString().TrimEnd(); Retorno_L.Add(obj); } con.Close(); } catch (Exception ex) { throw ex; } return(Retorno_L); }