public override void OnInitialized()
{
var rMasterInfo = KanColleGame.Current.MasterInfo;
using (var rCommand = CreateCommand())
{
rCommand.CommandText = "SELECT DISTINCT equipment FROM development WHERE equipment IS NOT NULL ORDER BY equipment;";
using (var rReader = rCommand.ExecuteReader())
{
var rEquipment = new List <EquipmentInfo>(rReader.VisibleFieldCount);
while (rReader.Read())
{
rEquipment.Add(rMasterInfo.Equipment[rReader.GetInt32(0)]);
}
Equipment.AddRange(rEquipment);
}
rCommand.CommandText = "SELECT DISTINCT flagship FROM development WHERE equipment IS NOT NULL ORDER BY flagship;";
using (var rReader = rCommand.ExecuteReader())
{
var rSecretaryShips = new List <ShipInfo>(rReader.VisibleFieldCount);
while (rReader.Read())
{
rSecretaryShips.Add(rMasterInfo.Ships[rReader.GetInt32(0)]);
}
SecretaryShips.AddRange(rSecretaryShips);
}
}
}
