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 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))); } }
public void Create() { ExcelDoc doc = new ExcelDoc(); try { int i = 1; foreach (MileageReport item in _mileageReportList) { if (item.IsFailed) { doc.setValue(i, 1, item.ToString()); i++; } } doc.SetList(2); i = 1; foreach (MileageReport item in _mileageReportList) { if (!(item.IsFailed)) { doc.setValue(i, 1, item.ToString()); i++; } } doc.Show(); } catch { doc.Dispose(); } }
public void Create() { ExcelDoc doc = new ExcelDoc(); try { int i = 1; foreach (MileageReport item in _mileageReportList) { if (item.IsFailed) { doc.setValue(i, 1, item.ToString()); i++; } } doc.SetList(2); i = 1; foreach (MileageReport item in _mileageReportList) { if (!(item.IsFailed)) { doc.setValue(i, 1, item.ToString()); i++; } } doc.Show(); } catch { doc.Dispose(); } }