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