internal override object[] getRow() { Regions regions = Regions.getInstance(); DriverList driverList = DriverList.getInstance(); Driver driverFrom = driverList.getItem(_idDriverFrom); Driver driverTo = driverList.getItem(_idDriverTo); return(new object[] { ID, Car.ID, Car.BBNumber, Car.Grz, Number, regions.getItem(_idRegionFrom), driverFrom.GetName(NameType.Full), regions.getItem(_idRegionTo), driverTo.GetName(NameType.Full), Date, _dateMove }); }
private void btnSave_Click(object sender, EventArgs e) { if (_workWithForm.IsEditMode()) { _invoice.DriverFromID = cbDriverFrom.SelectedValue.ToString(); _invoice.DriverToID = cbDriverTo.SelectedValue.ToString(); _invoice.RegionFromID = cbRegionFrom.SelectedValue.ToString(); _invoice.RegionToID = cbRegionTo.SelectedValue.ToString(); _invoice.Date = dtpDate.Value; _invoice.DateMove = mtbDateMove.Text; TextBox tbFile = ucFile.Controls["tbFile"] as TextBox; _invoice.File = tbFile.Text; _invoice.Save(); if (_check.Checked) { DriverList driverList = DriverList.getInstance(); Driver driver = driverList.getItem(Convert.ToInt32(cbDriverFrom.SelectedValue.ToString())); driver.IsDriver = false; driver.Save(); } DialogResult = System.Windows.Forms.DialogResult.OK; } else { _workWithForm.SetEditMode(true); } }
private CreateDocument CreateWayBill(Car car, DateTime date, int idInvoice = 0) { CreateDocument waybill = new CreateDocument(car); Driver driver = null; if (idInvoice != 0) { InvoiceList invoiceList = InvoiceList.getInstance(); Invoice invoice = invoiceList.getItem(idInvoice); DriverList driverList = DriverList.getInstance(); driver = driverList.getItem(Convert.ToInt32(invoice.DriverToID)); } waybill.CreateWaybill(date, driver); try { if (_type == WayBillType.Day) { waybill.AddRouteInWayBill(date, Fields.All); } } catch (NullReferenceException ex) { MessageBox.Show(ex.Message, "Предупреждение", MessageBoxButtons.OK, MessageBoxIcon.Information); waybill.Exit(); throw; } return(waybill); }
private ToolStripMenuItem CreateDeleteDriver() { ToolStripMenuItem item = CreateItem("Удалить водителя"); item.Click += delegate { if (MessageBox.Show("Вы действительно хотите удалить водителя из списка?", "Удаление", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == System.Windows.Forms.DialogResult.Yes) { DriverList driverList = DriverList.getInstance(); Driver driver = driverList.getItem(_dgvMain.GetID()); DriverCarList driverCarList = DriverCarList.getInstance(); if (driverCarList.IsDriverHaveCar(driver)) { MessageBox.Show("За водителем закреплён автомобиль, удаление невозможно", "Удаление", MessageBoxButtons.OK, MessageBoxIcon.Warning); } else { driver.IsDriver = false; driver.Save(); _mainStatus.Set(_mainStatus.Get()); } } }; return(item); }
//НЕПРАВИЛЬНО!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!! //По 2 раза отправляются письма, тем, у кого нет справки (кого нет в list2) private List <INotification> GetListOverdue(DateTime date) { var list = _list.ToList(); /* select driver_fio, max(MedicalCert_dateEnd) from [dbo].[MedicalCert] mc * join Driver d on d.driver_id = mc.driver_id * where MedicalCert_dateEnd < date//'2017-10-24' * group by driver_fio * order by driver_fio */ var temp = (from item in list group item by item.Driver.Id into t orderby t.Key select t.OrderByDescending(y => y.DateEnd).FirstOrDefault()).ToList(); /* тут будет несколько прошлогодних справок */ //var list1 = (list.Where(item => (item.DateEnd < date))).ToList(); var list2 = (list.Where(item => (item.DateEnd >= date))).ToList(); DriverList driverList = DriverList.getInstance(); return((from item1 in temp join item2 in list2 on item1.Driver.Id equals item2.Driver.Id into table1 from item3 in table1.DefaultIfEmpty() where item3 == null && (!driverList.getItem(item1.Driver.Id).NotificationStop) select item1).ToList()); }
private void SetFormatDriver() { DriverList driverList = DriverList.getInstance(); foreach (DataGridViewRow row in _dgv.Rows) { if ((row.Cells["Скан водительского удостоверения"].Value.ToString() == "нет") || (row.Cells["Скан медицинской справки"].Value.ToString() == "нет")) { row.DefaultCellStyle.BackColor = Color.LightYellow; } int idDriver = 0; int.TryParse(row.Cells[0].Value.ToString(), out idDriver); Driver driver = driverList.getItem(idDriver); if (driver.Fired) { row.DefaultCellStyle.ForeColor = Color.Red; } if (((driver.OwnerID < 3) && (string.IsNullOrEmpty(driver.Number))) || (driver.Decret)) { row.DefaultCellStyle.ForeColor = Color.Blue; } if (driver.OwnerID > 2) { row.DefaultCellStyle.ForeColor = BBColors.bbGreen1; } } }
public void ShowInvoice() { _excelDoc = openDocumentExcel("Накладная"); _excelDoc.setValue(7, 2, _car.info.Owner); _excelDoc.setValue(16, 82, _invoice.Number); _excelDoc.setValue(16, 98, _invoice.Date.ToShortDateString()); string fullNameAuto = string.Concat("Автомобиль ", _car.Mark.Name, " ", _car.info.Model, ", ", _car.Grz); _excelDoc.setValue(22, 10, fullNameAuto); _excelDoc.setValue(22, 53, _car.dateGet.ToShortDateString()); var grades = GradeList.getInstance(); var grade = grades.getItem(Convert.ToInt32(_car.GradeID)); var ptsList = PTSList.getInstance(); var pts = ptsList.getItem(_car); var fullDetailAuto = string.Concat("VIN ", _car.vin, ", Двигатель ", _car.eNumber, ", № кузова ", _car.bodyNumber, ", Год выпуска ", _car.Year, " г., Паспорт ", pts.Number, " от ", pts.Date.ToShortDateString(), ", мощность двигателя ", grade.EPower, " л.с."); _excelDoc.setValue(47, 2, fullDetailAuto); Driver driver1 = _driverList.getItem(Convert.ToInt32(_invoice.DriverFromID)); Driver driver2 = _driverList.getItem(Convert.ToInt32(_invoice.DriverToID)); _excelDoc.setValue(9, 10, driver1.Dept); _excelDoc.setValue(56, 11, driver1.Position); _excelDoc.setValue(56, 63, driver1.GetName(NameType.Full)); _excelDoc.setValue(11, 13, driver2.Dept); _excelDoc.setValue(60, 11, driver2.Position); _excelDoc.setValue(60, 63, driver2.GetName(NameType.Full)); _excelDoc.Show(); }
private void formatDGV() { _dgvDrivers.Columns[0].Visible = false; ResizeDGV(); foreach (DataGridViewRow row in _dgvDrivers.Rows) { int idDriver = 0; int.TryParse(row.Cells[0].Value.ToString(), out idDriver); Driver driver = driverList.getItem(idDriver); LicenseList licenseList = LicenseList.getInstance(); DriverLicense license = licenseList.getItem(driver); MedicalCertList medicalCertList = MedicalCertList.getInstance(); MedicalCert medicalCert = medicalCertList.getItem(driver); if (!license.IsActual() || !medicalCert.IsActual()) { row.DefaultCellStyle.BackColor = Color.LightYellow; } if (driver.Fired) { row.DefaultCellStyle.ForeColor = Color.Red; } if (((driver.OwnerID < 3) && (string.IsNullOrEmpty(driver.Number))) || (driver.Decret)) { row.DefaultCellStyle.ForeColor = Color.Blue; } if (driver.OwnerID > 2) { row.DefaultCellStyle.ForeColor = BBColors.bbGreen1; } } }
private void DoubleClickDriver(Point point) { if (_dgvMain.GetID() == 0) { return; } DriverList driverList = DriverList.getInstance(); Driver_AddEdit driverAddEdit = new Driver_AddEdit(driverList.getItem(_dgvMain.GetID())); if (driverAddEdit.ShowDialog() == DialogResult.OK) { loadCars(); } }
public static bool Login() { string login = WindowsIdentity.GetCurrent().Name.Replace("\\", "-"); String[] s2 = login.Split('-'); login = s2[1]; //login = "******"; //login = "******"; //login = "******"; //login = "******"; DriverList driverList = DriverList.getInstance(); _driver = driverList.getItem(login); return((_driver != null) && (User.GetRole() != RolesList.Employee)); }
private void cbDriverTo_SelectedIndexChanged(object sender, EventArgs e) { DriverList driverList = DriverList.getInstance(); if (cbDriverTo.SelectedValue == null) { return; } int idDriver; if (int.TryParse(cbDriverTo.SelectedValue.ToString(), out idDriver)) { Driver driver = driverList.getItem(idDriver); cbRegionTo.SelectedValue = driver.Region.Id; } }
private void cbDriver_SelectedIndexChanged(object sender, EventArgs e) { if (cbDriver.SelectedValue == null) { lbLogin.Text = string.Empty; } else { DriverList driverList = DriverList.getInstance(); int idDriver; int.TryParse(cbDriver.SelectedValue.ToString(), out idDriver); Driver driver = driverList.getItem(idDriver); lbLogin.Text = driver.Login; } }
public WayBillDay(DataRow row) { ID = Convert.ToInt32(row[0]); int idCar; int.TryParse(row[1].ToString(), out idCar); CarList carList = CarList.getInstance(); _car = carList.getItem(idCar); int idDriver; int.TryParse(row[2].ToString(), out idDriver); DriverList driverList = DriverList.getInstance(); _driver = driverList.getItem(idDriver); DateTime.TryParse(row[3].ToString(), out _date); }
private void btnNext_Click(object sender, EventArgs e) { Driver driver; if (cbFio.DataSource != null) { DriverList driverList = DriverList.getInstance(); driver = driverList.getItem(Convert.ToInt32(cbFio.SelectedValue)); } else { driver = new Driver(); driver.From1C = false; } driver.OwnerID = (rbBraun.Checked) ? 1 : (rbGematek.Checked) ? 2 : 3; Driver_AddEdit dAE = new Driver_AddEdit(driver); dAE.ShowDialog(); }