protected void btPesq_Click(object sender, EventArgs e)
{
string _rh = txbRh.Text;
using (OdbcConnection cnn = new OdbcConnection(ConfigurationManager.ConnectionStrings["HospubConn"].ToString()))
{
OdbcCommand cmm = cnn.CreateCommand();
cmm.CommandText = "Select ib6prontuar, ib6pnome, ib6compos, ib6municip, ib6telef, ib6dtnasc, ib6lograd, ib6numero, ib6complem, ib6bairro from intb6 where ib6regist = " + _rh;
cnn.Open();
OdbcDataReader dr = cmm.ExecuteReader();
if (dr.Read())
{
lbRF.Text = dr.GetString(0);
lbNome.Text = dr.GetString(1) + dr.GetString(2);
lbProcedencia.Text = Procedencia.getProcedencia(dr.GetString(3));
string tel = dr.GetString(4).TrimStart('0');
if (tel != "")
{
if (tel.Length.Equals(8))
{
tel = tel.Substring(0, 4) + "-" + tel.Substring(4, 4);
}
else if (tel.Length.Equals(9))
{
tel = tel.Substring(0, 5) + "-" + tel.Substring(5, 4);
}
}
lbTel.Text = tel;
lbIdade.Text = calcidade.getIdade(dr.GetString(5)).ToString() + " anos";;
lblograd.Text = dr.GetString(6);
lbnumero.Text = dr.GetString(7);
lbcomplem.Text = dr.GetString(8);
lbbairro.Text = dr.GetString(9);
dr.Close();
}
}
//////////////////////
////Pesquisa Histórico de Consultas
//GridView1.DataSource = AgendaPass1.gridCarregaAgendaPass(_rh);
//GridView1.DataBind();
GridView2.DataSource = Requis.gridRequis(_rh);
GridView2.DataBind();
}
protected void GridView2_SelectedIndexChanged(object sender, EventArgs e)
{
string requisicao = GridView2.SelectedRow.Cells[1].Text;
string anoped = "";
string areped = "";
string priped = "";
string secped = "";
anoped = requisicao.Substring(0, 2);
areped = requisicao.Substring(2, 2);
priped = requisicao.Substring(4, 1);
secped = requisicao.Substring(5, 6);
lbSel.Text = anoped + "." + areped + "." + priped + "." + secped;
GridView3.DataSource = Requis.gridExames(anoped, areped, priped, secped);
GridView3.DataBind();
}
