internal override object[] GetRow()
{
MedicalCertList medicalCertList = MedicalCertList.getInstance();
MedicalCert medicalCert = medicalCertList.getItem(this);
string medicalCertStatus = ((medicalCert == null) || (!medicalCert.IsActual())) ? "нет" : "есть";
LicenseList licenseList = LicenseList.getInstance();
DriverLicense license = licenseList.getItem(this);
string licenseStatus = ((license == null) || (!license.IsActual())) ? "нет" : "есть";
DriverCarList driverCarList = DriverCarList.getInstance();
Car car = driverCarList.GetCar(this);
return(new object[]
{
Id,
0,
GetName(NameType.Full),
licenseStatus,
medicalCertStatus,
(car == null) ? "нет автомобиля" : car.ToString(),
Region.Name,
CompanyName,
Status
});
}
private void ReadFile(string filename)
{
try
{
using (ExcelDoc excelDoc = new ExcelDoc(filename))
{
try
{
excelDoc.SetList("Расходы по а-м");
string grz = (excelDoc.getValue("B4") != null) ? excelDoc.getValue("B4").ToString() : string.Empty;
Car car = GetCar(grz);
if (car == null)
{
string driverFIO = (excelDoc.getValue("B5") != null) ? excelDoc.getValue("B5").ToString() : string.Empty;
DriverList driverList = DriverList.getInstance();
Driver driver = driverList.getItemByFIO(driverFIO);
if (driver != null)
{
DriverCarList driverCarList = DriverCarList.getInstance();
car = driverCarList.GetCar(driver);
}
if (car == null)
{
_mileageReportList.Add(new MileageReport(null, string.Concat("Не найден автомобиль: ", grz, " сотрудник: ", driverFIO, ". Файл: ", filename)));
}
}
if (car != null)
{
string value = (excelDoc.getValue("C8") != null) ? excelDoc.getValue("C8").ToString() : string.Empty;
SetMileage(car, value);
}
}
catch (IndexOutOfRangeException)
{
_mileageReportList.Add(new MileageReport(null, string.Concat("Ошибка при чтении файла: ", filename)));
}
catch (OverflowException)
{
_mileageReportList.Add(new MileageReport(null, string.Concat("Указан слишком большой пробег в файле: ", filename)));
}
}
}
catch
{
_mileageReportList.Add(new MileageReport(null, string.Concat("Ошибка при чтении файла: ", filename)));
}
}
private void FillCar()
{
DriverCarList driverCarList = DriverCarList.getInstance();
Car car = driverCarList.GetCar(_driver);
if (car != null)
{
carInfo.Text = car.ToString();
}
}
