public void initBus()
{
MysqlUtil mysql = new MysqlUtil();
mysql.GetConnection();
var rdr = mysql.ReadData("SELECT * FROM businfo;");
busLinkList = new LinkList <Bus>();
if (rdr.HasRows)
{
//busList = new List<Bus>();
while (rdr.Read())
{
Console.WriteLine("{0} {1} {2}", rdr.GetInt32(0), rdr.GetInt32(1),
rdr.GetString(2));
Bus bus = new Bus();
bus.ID = rdr.GetInt32(0);
bus.BusNo = rdr.GetInt32(1);
//busList.Add(bus);
busLinkList.Add(bus);
}
}
mysql.Close();
}
public void initManager()
{
MysqlUtil mysql = new MysqlUtil();
mysql.GetConnection();
var rdr = mysql.ReadData("SELECT * FROM manager;");
managerLinkLists = new LinkList <ManagerAccount>();
if (rdr.HasRows)
{
//managerLists = new List<ManagerAccount>();
while (rdr.Read())
{
Console.WriteLine("{0} {1} {2} {3}", rdr.GetInt32(0), rdr.GetString(1),
rdr.GetString(2), rdr.GetString(3));
ManagerAccount manager = new ManagerAccount();
manager.ID = rdr.GetInt32(0);
manager.Username = rdr.GetString(1);
manager.Password = rdr.GetString(2);
manager.Level = rdr.GetInt32(3);
//managerLists.Add(manager);
managerLinkLists.Add(manager);
}
}
mysql.Close();
}
public void initStation()
{
MysqlUtil mysql = new MysqlUtil();
mysql.GetConnection();
var rdr = mysql.ReadData("SELECT * FROM station;");
stationLinkList = new LinkList <Station>();
if (rdr.HasRows)
{
//stationList = new List<Station>();
while (rdr.Read())
{
Console.WriteLine("{0} {1} {2}", rdr.GetInt32(0), rdr.GetString(1),
rdr.GetInt32(2));
Station station = new Station();
station.ID = rdr.GetInt32(0);
station.Name = rdr.GetString(1);
station.Distance = rdr.GetInt32(2);
//stationList.Add(station);
stationLinkList.Add(station);
}
}
mysql.Close();
}
