/// <summary>
/// Получение точек
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
public void btn_GetNewPoints_Click(object sender, EventArgs e)
{
presenter = new MapPresenter(this);
presenter.GetDataFromForm();
presenter.ShowMap();
UpdateStat();
}
/// <summary>
/// Загрузить последний сценарий
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void загрузитьToolStripMenuItem_Click(object sender, EventArgs e)
{
presenter = new MapPresenter(this);
SqlConnectionStringBuilder bldr = CreateConnection();
using (SqlConnection conn = new SqlConnection(bldr.ConnectionString))
{
conn.Open();
SqlCommand cmdGames = new SqlCommand();
cmdGames.Connection = conn;
cmdGames.CommandText = "Select Iterations, CurIteration, QCargo, QTruck FROM Games";
using (DbDataReader reader = cmdGames.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
presenter.Map.NumIterations = Convert.ToInt32(reader.GetValue(0));
presenter.Map.NumCargoes = Convert.ToInt32(reader.GetValue(2));
presenter.Map.NumTrucks = Convert.ToInt32(reader.GetValue(3));
presenter.Map.CurIteration = Convert.ToInt32(reader.GetValue(1));
}
}
}
SqlCommand cmdTrucks = new SqlCommand();
cmdTrucks.Connection = conn;
cmdTrucks.CommandText = "Select TypeName, Nametruck, PositionX, PositionY, Status, FuelBalance, StepOfRoute FROM Trucks";
using (DbDataReader reader = cmdTrucks.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Coordinate coord = new Coordinate();
coord.X = Convert.ToInt32(reader.GetValue(2));
coord.Y = Convert.ToInt32(reader.GetValue(3));
ITruck truck;
if ((Convert.ToString(reader.GetValue(0))) == "Truck ")
{
truck = new Truck(coord);
}
else
{
truck = new User(coord);
}
((Point)truck).Name = Convert.ToString(reader.GetValue(1));
truck.Status = Convert.ToBoolean(reader.GetValue(4));
truck.Fuelbalance = Convert.ToInt32(reader.GetValue(5));
truck.StepOfRoute = Convert.ToInt32(reader.GetValue(6));
presenter.Map.Points.Add(truck);
}
}
}
SqlCommand cmdCargoes = new SqlCommand();
cmdCargoes.Connection = conn;
cmdCargoes.CommandText = "Select NameCargo, PositionX, PositionY, Status FROM Cargoes";
using (DbDataReader reader = cmdCargoes.ExecuteReader())
{
if (reader.HasRows)
{
while (reader.Read())
{
Coordinate coord = new Coordinate();
coord.X = Convert.ToInt32(reader.GetValue(1));
coord.Y = Convert.ToInt32(reader.GetValue(2));
Cargo cargo = new Cargo(coord);
((Point)cargo).Name = Convert.ToString(reader.GetValue(0));
cargo.StatusCargo = Convert.ToBoolean(reader.GetValue(3));
if (cargo.StatusCargo == false)
{
cargo.Pen = new Pen(Color.RosyBrown);
cargo.TextColor = Brushes.RosyBrown;
}
presenter.Map.Points.Add(cargo);
}
}
}
}
presenter.ShowMap();
}
