private void buttonPutevoiAdd_Click(object sender, EventArgs e)
{
Putevoi putevoi = new Putevoi();
putevoi.Save(conn);
fillDataGrid();
}
public static List <Putevoi> GetList(SQLiteCommand command)
{
SQLiteDataReader r = command.ExecuteReader();
List <Putevoi> data = new List <Putevoi>();
while (r.Read())
{
Putevoi putevoi = new Putevoi();
putevoi.id = Convert.ToInt32(r["id"].ToString());
putevoi.nomer = getInt("nomer", r);
putevoi.driver_id = getInt("driver_id", r);
putevoi.engine_id = getInt("engine_id", r);
putevoi.car_id = getInt("car_id", r);
putevoi.fuel_start = getInt("fuel_start", r);
putevoi.fuel_end = getInt("fuel_end", r);
putevoi.fuel_zapravka = getInt("fuel_zapravka", r);
putevoi.fuel_karta = getInt("fuel_karta", r);
putevoi.fuel_cash = getInt("fuel_cash", r);
putevoi.fuel_norma = getFloat("fuel_norma", r);
putevoi.probeg_s_gruzom = getInt("probeg_s_gruzom", r);
putevoi.probeg_bez_gruza = getInt("probeg_bez_gruza", r);
putevoi.probeg_start = getInt("probeg_start", r);
putevoi.probeg_end = getInt("probeg_end", r);
putevoi.date_start = getInt("date_start", r);
putevoi.date_end = getInt("date_end", r);
putevoi.created_at = getInt("created_at", r);
putevoi.updated_at = getInt("updated_at", r);
data.Add(putevoi);
}
r.Close();
return(data);
}
public PutevoiSelectorForm(long engine_id)
{
InitializeComponent();
SQLiteConnection conn = new SQLiteConnection("Data Source='db/database.db'; Version=3;");
conn.Open();
label.Text = label.Text + " для автомобиля " + Engine.Find(engine_id, conn).Name();
List <ComboItem> itemlist = new List <ComboItem>();
SQLiteCommand command = new SQLiteCommand("SELECT * FROM putevoi WHERE engine_id=@engine_id ORDER BY date_end DESC;", conn);
command.Parameters.Add(new SQLiteParameter("engine_id", engine_id));
List <Putevoi> list = Putevoi.GetList(command);
foreach (Putevoi putevoi in list)
{
string name = UnixTime.From(putevoi.date_start).ToString("dd.MM.yyyy HH:mm")
+ " - "
+ UnixTime.From(putevoi.date_end).ToString("dd.MM.yyyy HH:mm")
+ " (Водитель: " + Driver.Find(putevoi.driver_id, conn).Name() + ")";
itemlist.Add(new ComboItem(putevoi.id, name));
}
comboBox.DataSource = itemlist;
if (itemlist.Count == 0)
{
comboBox.SelectedText = "Нет данных";
}
}
public static Putevoi Find(long id, SQLiteConnection conn)
{
SQLiteCommand commandSelect = new SQLiteCommand("SELECT * FROM putevoi WHERE id=@id", conn);
commandSelect.Parameters.Add(new SQLiteParameter("id", id));
Putevoi putevoi = new Putevoi(commandSelect);
return(putevoi);
}
public MainForm()
{
InitializeComponent();
System.IO.Directory.CreateDirectory("db");
System.IO.Directory.CreateDirectory("db\\backup");
System.IO.Directory.CreateDirectory("templates");
System.IO.Directory.CreateDirectory("documents");
conn = new SQLiteConnection("Data Source='db/database.db'; Version=3;");
conn.Open();
Driver.CreateDB(conn);
Car.CreateDB(conn);
Engine.CreateDB(conn);
Putevoi.CreateDB(conn);
File.Copy(Application.StartupPath + "\\db\\database.db", Application.StartupPath + "\\db\\backup\\database " + UnixTime.Now.ToString() + ".db");
}
private void buttonPutevoiGetData_Click(object sender, EventArgs e)
{
PutevoiSelectorForm selector = new PutevoiSelectorForm(Convert.ToInt64(comboSelectEngine.SelectedValue));
DialogResult result = selector.ShowDialog(this);
if (result == DialogResult.OK)
{
Putevoi previous = Putevoi.Find(selector.putevoiSelected, conn);
textBoxFuelStart.Text = previous.fuel_end.ToString();
textBoxProbegStart.Text = (previous.probeg_end).ToString();
textBoxFuelZapravka.Text = "0";
textBoxFuelKarta.Text = "0";
textBoxFuelCash.Text = "0";
textBoxFuelEnd.Text = "0";
textBoxProbegSGruzom.Text = "0";
textBoxProbegBezGruza.Text = "0";
recalculateFuelNorm();
}
}
private void fillDataGrid()
{
dataDrivers.Rows.Clear();
var driverlist = Driver.All(conn);
foreach (Driver driver in driverlist)
{
dataDrivers.Rows.Add(
driver.id,
driver.familiya,
driver.imya,
driver.otchestvo,
driver.document,
driver.passport,
UnixTime.From(driver.created_at),
UnixTime.From(driver.updated_at)
);
}
dataEngines.Rows.Clear();
var enginelist = Engine.All(conn);
foreach (Engine engine in enginelist)
{
dataEngines.Rows.Add(
engine.id,
engine.marka,
engine.gosnomer,
engine.rashod,
UnixTime.From(engine.created_at),
UnixTime.From(engine.updated_at)
);
}
dataCars.Rows.Clear();
var carlist = Car.All(conn);
foreach (Car car in carlist)
{
dataCars.Rows.Add(
car.id,
car.marka,
car.gosnomer,
car.weight,
car.rashod,
UnixTime.From(car.created_at),
UnixTime.From(car.updated_at)
);
}
dataPutevoi.Rows.Clear();
var putevoilist = Putevoi.All(conn);
foreach (Putevoi putevoi in putevoilist)
{
dataPutevoi.Rows.Add(
putevoi.id,
putevoi.nomer,
Driver.Find(putevoi.driver_id, conn).Name(),
Engine.Find(putevoi.engine_id, conn).Name(),
Car.Find(putevoi.car_id, conn).Name(),
UnixTime.From(putevoi.date_start),
UnixTime.From(putevoi.date_end),
putevoi.fuel_start,
putevoi.fuel_zapravka,
putevoi.fuel_karta,
putevoi.fuel_cash,
putevoi.fuel_zapravka + putevoi.fuel_karta + putevoi.fuel_cash,
putevoi.fuel_end,
putevoi.fuel_start + putevoi.fuel_zapravka + putevoi.fuel_karta + putevoi.fuel_cash - putevoi.fuel_end,
putevoi.fuel_norma,
putevoi.probeg_start,
putevoi.probeg_s_gruzom,
putevoi.probeg_bez_gruza,
putevoi.probeg_end,
UnixTime.From(putevoi.created_at),
UnixTime.From(putevoi.updated_at)
);
}
}
public static List <Putevoi> All(SQLiteConnection conn)
{
List <Putevoi> putevoi = Putevoi.GetList(new SQLiteCommand("SELECT * FROM putevoi", conn));
return(putevoi);
}
public PutevoiForm(long _putevoi)
{
InitializeComponent();
conn = new SQLiteConnection("Data Source='db/database.db'; Version=3;");
conn.Open();
putevoi = Putevoi.Find(_putevoi, conn);
List <ComboItem> itemlistdrivers = new List <ComboItem>();
var driverlist = Driver.All(conn);
int drivercount = -1;
int driveriterator = 0;
foreach (Driver driver in driverlist)
{
itemlistdrivers.Add(new ComboItem(driver.id, driver.Name()));
if (driver.id != putevoi.driver_id)
{
driveriterator++;
}
else
{
drivercount = driveriterator;
}
}
comboSelectDriver.DataSource = itemlistdrivers;
if (drivercount == -1)
{
comboSelectDriver.SelectedValue = -1;
comboSelectDriver.SelectedText = "Выберите водителя";
}
else
{
comboSelectDriver.SelectedItem = comboSelectDriver.Items[drivercount];
}
List <ComboItem> itemlistengines = new List <ComboItem>();
var enginelist = Engine.All(conn);
int enginecount = -1;
int engineiterator = 0;
foreach (Engine engine in enginelist)
{
itemlistengines.Add(new ComboItem(engine.id, engine.Name()));
if (engine.id != putevoi.engine_id)
{
engineiterator++;
}
else
{
enginecount = engineiterator;
}
}
comboSelectEngine.DataSource = itemlistengines;
if (enginecount == -1)
{
comboSelectEngine.SelectedValue = -1;
comboSelectEngine.SelectedText = "Выберите автомобиль";
}
else
{
comboSelectEngine.SelectedItem = comboSelectEngine.Items[enginecount];
}
List <ComboItem> itemlistcars = new List <ComboItem>();
var carlist = Car.All(conn);
int carcount = -1;
int cariterator = 0;
foreach (Car car in carlist)
{
itemlistcars.Add(new ComboItem(car.id, car.Name()));
if (car.id != putevoi.car_id)
{
cariterator++;
}
else
{
carcount = cariterator;
}
}
comboSelectCar.DataSource = itemlistcars;
if (carcount == -1)
{
comboSelectCar.SelectedValue = -1;
comboSelectCar.SelectedText = "Выберите прицеп";
}
else
{
comboSelectCar.SelectedItem = comboSelectCar.Items[carcount];
}
List <ComboItem> listHw = new List <ComboItem>();
listHw.Add(new ComboItem(130, "Диз. топливо (1.3)"));
listHw.Add(new ComboItem(200, "Бензин (2)"));
listHw.Add(new ComboItem(264, "Нефтяной газ (2.64)"));
listHw.Add(new ComboItem(200, "Природный газ (2)"));
comboBoxHw.DataSource = listHw;
textBoxFuelStart.Text = putevoi.fuel_start.ToString();
textBoxFuelZapravka.Text = putevoi.fuel_zapravka.ToString();
textBoxFuelKarta.Text = putevoi.fuel_karta.ToString();
textBoxFuelCash.Text = putevoi.fuel_cash.ToString();
textBoxFuelEnd.Text = putevoi.fuel_end.ToString();
textBoxFuelNorma.Text = putevoi.fuel_norma.ToString();
textBoxProbegStart.Text = putevoi.probeg_start.ToString();
textBoxProbegSGruzom.Text = putevoi.probeg_s_gruzom.ToString();
textBoxProbegBezGruza.Text = putevoi.probeg_bez_gruza.ToString();
textBoxProbegEnd.Text = putevoi.probeg_end.ToString();
dateTimePutevoiDateStart.Value = UnixTime.From(putevoi.date_start);
dateTimePutevoiDateEnd.Value = UnixTime.From(putevoi.date_end);
recalculateFuelNorm();
}
