// ********************************************************************
// ********************************************************************
public void GetRodovias(ref int nRod, C_Rodovia objRod)
{
string[] aRod = new string[50];
nRod = 0;
ConectaBanco();
com1 = mysqlCon1.CreateCommand();
com1.CommandText = "select Rodovia from trodovias";
reader1 = com1.ExecuteReader();
while (reader1.Read())
{
nRod++;
objRod.Rodovia[nRod] = reader1["Rodovia"].ToString();
//objRod.MunA[nRod] = reader1["munA"].ToString();
//objRod.MunB[nRod] = reader1["munB"].ToString();
}
reader1.Close();
DesconectaBanco();
}
private void PopulaComboRodovias(int nRod, C_Rodovia objRod)
{
cmbRod.Items.Clear();
int ind1 = 0;
for (ind1 = 1; ind1 <= nRod; ind1++)
{
cmbRod.Items.Add(objRod.Rodovia[ind1]);
}
}
//*******************************************************************
public void TrazKmsPontosFE(ref int nRod, string aRod, C_Rodovia objRod)
{
nRod = 0;
ConectaBanco();
com1 = mysqlCon1.CreateCommand();
// "select kmEdital from ponto_fe where Rodovia= " + "'" + cmbRodovia.Text + "'";
com1.CommandText = "select kmEdital from ponto_fe where Rodovia= " + "'" + aRod + "'";
reader1 = com1.ExecuteReader();
while (reader1.Read())
{
nRod++;
objRod.kms[nRod] = reader1["kmEdital"].ToString();
}
reader1.Close();
DesconectaBanco();
}
