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