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(); }