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