protected void PreencheTabella(string Buscar, int Inicio, int Procedure, long totalRegistros)
{
try
{
DataTable dt = new DataTable();
dt = bll.PesquisaListaBem(Buscar, Inicio, Procedure);
for (int i = 0; i <= totalRegistros; i++)
{
if (dt.Rows[i]["Ativo"].ToString() == "1")
{
//Cabecalho - linha 1
TableRow linha1 = new TableRow();
TableCell cel1 = new TableCell();
if (!string.IsNullOrEmpty(dt.Rows[i]["Site"].ToString()))
{
cel1.Text = "<a href=http://" + dt.Rows[i]["Site"].ToString() + " target=_blank/>"
+ dt.Rows[i]["NomePrimario"].ToString() +
" " + dt.Rows[i]["NomeSecundario"].ToString() + "</a>";
}
else
{
cel1.Text = "<a href=sem_representacao.aspx target=_blank/>"
+ dt.Rows[i]["NomePrimario"].ToString() +
" " + dt.Rows[i]["NomeSecundario"].ToString() + "</a>";
}
cel1.ForeColor = Color.Blue;
cel1.Font.Size = 11;
linha1.Cells.Add(cel1);
tblPesquisa.Rows.Add(linha1);
//linha2
TableRow linha2 = new TableRow();
TableCell cel2 = new TableCell();
if (!string.IsNullOrEmpty(dt.Rows[i]["Site"].ToString()) &&
!string.IsNullOrEmpty(dt.Rows[i]["Email"].ToString()))
{
cel2.Text = dt.Rows[i]["Site"].ToString().ToLower() + " - " +
dt.Rows[i]["Email"].ToString().ToLower();
}
else
{
if (!string.IsNullOrEmpty(dt.Rows[i]["Site"].ToString()))
{
cel2.Text = dt.Rows[i]["Site"].ToString().ToLower();
}
if (!string.IsNullOrEmpty(dt.Rows[i]["Email"].ToString()))
{
cel2.Text = dt.Rows[i]["Email"].ToString().ToLower();
}
}
cel2.ForeColor = Color.Green;
cel2.Font.Size = 9;
linha2.Cells.Add(cel2);
tblPesquisa.Rows.Add(linha2);
//linha3
TableRow linha3 = new TableRow();
TableCell cel3 = new TableCell();
cel3.Text = dt.Rows[i]["Endereco"].ToString() +
" " + dt.Rows[i]["Bairro"].ToString() +
" CEP: " + dt.Rows[i]["CEP"].ToString();
cel3.ForeColor = ColorTranslator.FromHtml("#444444");
cel3.Font.Size = 8;
linha3.Cells.Add(cel3);
tblPesquisa.Rows.Add(linha3);
//linha4
TableRow linha4 = new TableRow();
TableCell cel4 = new TableCell();
cel4.Text = dt.Rows[i]["Telefone1"].ToString() +
" . " + dt.Rows[i]["Telefone2"].ToString() +
" . " + dt.Rows[i]["Telefone3"].ToString() +
" . " + dt.Rows[i]["Telefone4"].ToString();
cel4.ForeColor = ColorTranslator.FromHtml("#444444");
cel4.Font.Size = 8;
linha4.Cells.Add(cel4);
tblPesquisa.Rows.Add(linha4);
//Banners
STR.clsString str = new STR.clsString();// para remover o "~/" do caminho das imagens
string Banners = string.Empty;
string Banner1 = str.Right(dt.Rows[i]["Banner1"].ToString(), 2);
string Banner2 = str.Right(dt.Rows[i]["Banner2"].ToString(), 2);
string Banner3 = str.Right(dt.Rows[i]["Banner3"].ToString(), 2);
string Banner4 = str.Right(dt.Rows[i]["Banner4"].ToString(), 2);
int Alt = int.Parse(ConfigurationManager.AppSettings["AlturaBannerListagem"].ToString());
int Larg = int.Parse(ConfigurationManager.AppSettings["LarguraBannerListagem"].ToString());
string ModoTransicaoBanners = ConfigurationManager.AppSettings["TransicaoBanners"].ToString();
if (str.rRight(Banner1, 4) == ".jpg")
{
Banners += "<a " + ModoTransicaoBanners + " href=../" + Banner1 + "><img src=../" + Banner1 + " height=" + Alt + " width= " + Larg + "></a>";
}
if (str.rRight(Banner2, 4) == ".jpg")
{
Banners += "<a " + ModoTransicaoBanners + " href=../" + Banner2 + "><img src=../" + Banner2 + " height=" + Alt + " width= " + Larg + "></a>";
}
if (str.rRight(Banner3, 4) == ".jpg")
{
Banners += "<a " + ModoTransicaoBanners + " href=../" + Banner3 + "><img src=../" + Banner3 + " height=" + Alt + " width= " + Larg + "></a>";
}
if (str.rRight(Banner4, 4) == ".jpg")
{
Banners += "<a " + ModoTransicaoBanners + " href=../" + Banner4 + "><img src=../" + Banner4 + " height=" + Alt + " width= " + Larg + "></a>";
}
TableRow rowBanner = new TableRow();
TableCell cellBanner1 = new TableCell();
cellBanner1.Text = Banners;
rowBanner.Cells.Add(cellBanner1);
tblPesquisa.Rows.Add(rowBanner);
//SubDivisoes
TableRow linhaSbD = new TableRow();
TableCell CelSbD = new TableCell();
CelSbD.ForeColor = ColorTranslator.FromHtml("#444444");
CelSbD.Font.Size = 9;
CelSbD.Text = "<table>" +
//linha1 - Cabecalho
"<tr style=font-size:14px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao1"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["SiteSubDivisao1"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=http://" + dt.Rows[i]["SiteSubDivisao1"].ToString() + " target=_blank>"
+ dt.Rows[i]["SubDivisao1"].ToString() + "</a></td>";
}
else
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=sem_representacao.aspx target=_blank >"
+ dt.Rows[i]["SubDivisao1"].ToString() + "</a></td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao2"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["SiteSubDivisao2"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=http://" + dt.Rows[i]["SiteSubDivisao2"].ToString() + " target=_blank>"
+ dt.Rows[i]["SubDivisao2"].ToString() + "</a></td>";
}
else
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=sem_representacao.aspx target=_blank>"
+ dt.Rows[i]["SubDivisao2"].ToString() + "</a></td>";
}
}
CelSbD.Text += "</tr>" +
//Atividades
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao1"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AtividadesSubDivisao1"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td>" + dt.Rows[i]["AtividadesSubDivisao1"].ToString() + "</td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao2"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AtividadesSubDivisao2"].ToString()))
{
CelSbD.Text += "<td>           </td>" +
"<td>" + dt.Rows[i]["AtividadesSubDivisao2"].ToString() + "</td>";
}
}
CelSbD.Text += "</tr>" +
//Telefone
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao1"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["TelefoneSubDivisao1"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td>" + dt.Rows[i]["TelefoneSubDivisao1"].ToString() + "</td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao2"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["TelefoneSubDivisao2"].ToString()))
{
CelSbD.Text += "<td>           </td>" +
"<td>" + dt.Rows[i]["TelefoneSubDivisao2"].ToString() + "</td>";
}
}
CelSbD.Text += "</tr>" +
//Cabecalho
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao3"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["SiteSubDivisao3"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=http://" + dt.Rows[i]["SiteSubDivisao3"].ToString() + " target=_blank>"
+ dt.Rows[i]["SubDivisao3"].ToString() + "</a></td>";
}
else
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=sem_representacao.aspx target=_blank>"
+ dt.Rows[i]["SubDivisao3"].ToString() + "</a></td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao4"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["SiteSubDivisao4"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=http://" + dt.Rows[i]["SiteSubDivisao4"].ToString() + ">"
+ dt.Rows[i]["SubDivisao4"].ToString() + "</a></td>";
}
else
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=sem_representacao.aspx>"
+ dt.Rows[i]["SubDivisao4"].ToString() + "</a></td>";
}
}
CelSbD.Text += "</tr>" +
//Atividades
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao3"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AtividadesSubDivisao3"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td>" + dt.Rows[i]["AtividadesSubDivisao3"].ToString() + "</td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao4"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AtividadesSubDivisao4"].ToString()))
{
CelSbD.Text += "<td>           </td>" +
"<td>" + dt.Rows[i]["AtividadesSubDivisao4"].ToString() + "</td>";
}
}
CelSbD.Text += "</tr>" +
//Telefone
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao3"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["TelefoneSubDivisao3"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td>" + dt.Rows[i]["TelefoneSubDivisao3"].ToString() + "</td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao4"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["TelefoneSubDivisao4"].ToString()))
{
CelSbD.Text += "<td>           </td>" +
"<td>" + dt.Rows[i]["TelefoneSubDivisao4"].ToString() + "</td>";
}
}
CelSbD.Text += "</tr>" +
//Cabecalho
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao5"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["SiteSubDivisao5"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=http://" + dt.Rows[i]["SiteSubDivisao5"].ToString() + " target=_blank>"
+ dt.Rows[i]["SubDivisao5"].ToString() + "</a></td>";
}
else
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=sem_representacao.aspx target=_blank>"
+ dt.Rows[i]["SubDivisao5"].ToString() + "</a></td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao6"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["SiteSubDivisao6"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=http://" + dt.Rows[i]["SiteSubDivisao6"].ToString() + " target=_blank>"
+ dt.Rows[i]["SubDivisao6"].ToString() + "</a></td>";
}
else
{
CelSbD.Text += "<td>       </td>" +
"<td><a href=sem_representacao.aspx target=_blank>"
+ dt.Rows[i]["SubDivisao6"].ToString() + "</a></td>";
}
}
CelSbD.Text += "</tr>" +
//Atividades
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao5"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AtividadesSubDivisao5"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td>" + dt.Rows[i]["AtividadesSubDivisao5"].ToString() + "</td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao6"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["AtividadesSubDivisao6"].ToString()))
{
CelSbD.Text += "<td>           </td>" +
"<td>" + dt.Rows[i]["AtividadesSubDivisao6"].ToString() + "</td>";
}
}
CelSbD.Text += "</tr>" +
//Telefone
"<tr style=font-size:12px;>";
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao5"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["TelefoneSubDivisao5"].ToString()))
{
CelSbD.Text += "<td>       </td>" +
"<td>" + dt.Rows[i]["TelefoneSubDivisao5"].ToString() + "</td>";
}
}
if (!string.IsNullOrEmpty(dt.Rows[i]["SubDivisao6"].ToString()))
{
if (!string.IsNullOrEmpty(dt.Rows[i]["TelefoneSubDivisao6"].ToString()))
{
CelSbD.Text += "<td>           </td>" +
"<td>" + dt.Rows[i]["TelefoneSubDivisao6"].ToString() + "</td>";
}
}
CelSbD.Text += "</tr>" +
"</table>" +
"<br/>";
linhaSbD.Cells.Add(CelSbD);
tblPesquisa.Rows.Add(linhaSbD);
}
else
{
//Cabecalho - linha 1
TableRow nlinha1 = new TableRow();
TableCell ncel1 = new TableCell();
ncel1.Text = "<a href=sem_representacao.aspx" + dt.Rows[i]["Site"].ToString() + " target=_blank/>"
+ dt.Rows[i]["NomePrimario"].ToString() +
" " + dt.Rows[i]["NomeSecundario"].ToString() + "</a>";
ncel1.ForeColor = Color.Blue;
ncel1.Font.Size = 13;
nlinha1.Cells.Add(ncel1);
tblPesquisa.Rows.Add(nlinha1);
//linha2
TableRow nlinha2 = new TableRow();
TableCell ncel2 = new TableCell();
ncel2.Text = dt.Rows[i]["Telefone1"].ToString() + "</br></br>";
ncel2.ForeColor = ColorTranslator.FromHtml("#444444");
ncel2.Font.Size = 10;
nlinha2.Cells.Add(ncel2);
tblPesquisa.Rows.Add(nlinha2);
}
}
}
catch (Exception ex)
{
throw ex;
}
}
