public Prognozuj(UprawyGUI UprawyGUI)
{
this.UprawyGUI = UprawyGUI;
InitializeComponent();
IleLat = Convert.ToInt32(UprawyGUI.comboBox10.Text);
zarzadzanieUprawami = new zarzadzanieUprawami2Entities1();
list = ReceiveDBlist();
dataGridView1.ColumnCount = 7;
dataGridView1.Columns[0].Name = "Rok";
dataGridView1.Columns[1].Name = "Pole";
dataGridView1.Columns[2].Name = "Gleba";
dataGridView1.Columns[3].Name = "Roślina";
dataGridView1.Columns[4].Name = "Przychody";
dataGridView1.Columns[5].Name = "Koszty";
dataGridView1.Columns[6].Name = "Zysk";
dataGridView1.Columns[4].DefaultCellStyle.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dataGridView1.Columns[5].DefaultCellStyle.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dataGridView1.Columns[6].DefaultCellStyle.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
dataGridView1.Columns[4].DefaultCellStyle.BackColor = Color.Cyan;
dataGridView1.Columns[5].DefaultCellStyle.BackColor = Color.Red;
dataGridView1.Columns[6].DefaultCellStyle.BackColor = Color.LightGreen;
dataGridView1.Columns[0].ValueType = Type.GetType("System.Int32");
foreach (DataGridViewColumn col in dataGridView1.Columns)
{
col.HeaderCell.Style.Alignment = DataGridViewContentAlignment.MiddleCenter;
col.HeaderCell.Style.Font = new Font("Arial", 12F, FontStyle.Bold, GraphicsUnit.Pixel);
col.DefaultCellStyle.Alignment = DataGridViewContentAlignment.TopCenter;
col.SortMode = DataGridViewColumnSortMode.NotSortable;
}
UprawyGUI.progressBar1.Refresh();
inicjalizujPola();
wyswietlGleby();
}
public PoleGUI()
{
InitializeComponent();
zarzadzanieUprawami = new zarzadzanieUprawami2Entities1();
inicjujSortowania();
ustawBazeDanych();
aktualizujComboBoxy();
}
public ObszaryGUI()
{
InitializeComponent();
zarzadzanieUprawami = new zarzadzanieUprawami2Entities1();
inicjujSortowania();
ustawBazeDanych();
aktualizujTabele();
}
public UprawyGUI()
{
filtrCzasowy = false;
InitializeComponent();
zarzadzanieUprawami = new zarzadzanieUprawami2Entities1();
inicjujSortowania();
ustawBazeDanych();
comboBox10.SelectedIndex = 0;
// wyswietlRosliny();
}
private void generujRaport()
{
try
{
if (comboBox9.SelectedItem.ToString() == "Suma dotacji")
{
var baza = new zarzadzanieUprawami2Entities1();
cmd = new SqlCommand {
Connection = con,
CommandType = CommandType.Text,
CommandText = (@"SELECT SUM(Obszary.powierzchniaHa * Rosliny.doplatyHa) as 'Suma doplat [zł]'
FROM Uprawy
INNER JOIN Pola
ON Uprawy.idPole = Pola.idPole
INNER JOIN Obszary
ON Pola.idObszar = Obszary.idObszar
INNER JOIN Rosliny
ON Uprawy.idRoslina = Rosliny.idRoslina")
};
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
}
else if (comboBox9.SelectedItem.ToString() == "Średnia powierzchnia pól")
{
var baza = new zarzadzanieUprawami2Entities1();
cmd = new SqlCommand {
Connection = con,
CommandType = CommandType.Text,
CommandText = ("select AVG(powierzchniaHa)as 'Średnia powierzchnia pół [Ha]' from Obszary")
};
SqlDataAdapter adap = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
adap.Fill(dt);
dataGridView2.DataSource = dt;
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
