protected void Page_Load(object sender, EventArgs e)
{
Dao dao = new Dao();
string cmd = ("select * from companies");
MySqlDataReader reader = dao.consultarLer(cmd);
string aux;
string aux2;
while (reader.Read())
{
lblId.Text = reader[0].ToString();
lblNome.Text = reader[1].ToString();
lblCnpj.Text = reader[2].ToString();
}
aux = reader[3].ToString();
aux2 = reader[4].ToString();
reader.Close();
cmd = ("select * from addresses where address_id=" + aux);
MySqlDataReader reader2 = dao.consultarLer2(cmd);
while (reader2.Read())
{
lblLogra.Text = reader2[1].ToString();
lblNum.Text = reader2[2].ToString();
lblCep.Text = reader2[3].ToString();
lblBairro.Text = reader2[4].ToString();
lblCidade.Text = reader2[5].ToString();
lblEstado.Text = reader2[6].ToString();
lblPais.Text = reader2[7].ToString();
}
reader2.Close();
cmd = ("select * from phones where phone_id=" + aux2);
MySqlDataReader reader3 = dao.consultarLer2(cmd);
while (reader3.Read())
{
lblTel.Text = reader3[1].ToString();
lblRamal.Text = reader3[2].ToString();
}
reader3.Close();
}
protected void Page_Load(object sender, EventArgs e)
{
string field1 = (string)(Session["field1"]);
lblNumOs.Text = field1;
Dao dao = new Dao();
string cmd = ("select * From estimates Where (estimate_id LIKE '" + field1 + "')");
MySqlDataReader reader = dao.consultarLer(cmd);
string comp_id;
string user_id;
string end_id;
string tel_id;
while (reader.Read())
{
lblDescri.Text = reader[3].ToString();
lblData.Text = reader[4].ToString();
comp_id = reader[1].ToString();
user_id = reader[2].ToString();
}
comp_id = reader[1].ToString();
user_id = reader[2].ToString();
reader.Close();
cmd = ("select * From users Where (user_id LIKE '" + user_id + "')");
MySqlDataReader reader2 = dao.consultarLer2(cmd);
while (reader2.Read())
{
lblUser.Text = reader2[1].ToString();
}
reader2.Close();
cmd = ("select * From companies Where (company_id LIKE '" + comp_id + "')");
MySqlDataReader reader3 = dao.consultarLer2(cmd);
while (reader3.Read())
{
lblEmpresa.Text = reader3[1].ToString();
end_id = reader3[3].ToString();
tel_id = reader3[4].ToString();
}
end_id = reader3[3].ToString();
tel_id = reader3[4].ToString();
reader3.Close();
cmd = ("select * From addresses Where (address_id LIKE '" + end_id + "')");
MySqlDataReader reader4 = dao.consultarLer2(cmd);
while (reader4.Read())
{
lblRua.Text = reader4[1].ToString();
lblNum.Text = reader4[2].ToString();
lblBairro.Text = reader4[4].ToString();
lblCidade.Text = reader4[5].ToString();
lblEstado.Text = reader4[6].ToString();
lblPais.Text = reader4[7].ToString();
}
reader4.Close();
cmd = ("select * From phones Where (phone_id LIKE '" + tel_id + "')");
MySqlDataReader reader5 = dao.consultarLer2(cmd);
while (reader5.Read())
{
lblTel.Text = reader5[1].ToString();
lblRamal.Text = reader5[2].ToString();
}
reader4.Close();
}