private void DoExport() { try { dateToExport = DateTime.MinValue; //dateToExport = new DateTime(2016, 3, 14); ExcelSearchCriteria c = _view.CriteriaSettings; StampaExcelSettings settings = new StampaExcelSettings(_view.InventarioScriviTipoInventario, _view.InventarioScriviIntestazioniTipoInventario, _view.InventarioRigheFraTipiInventario, _view.InventarioRigaIniziale, _view.InventarioDisegnaOrizzontalmente, _view.InventarioColonnaIniziale, _view.InventarioFeneal, _view.VisibilityTabPreventivo, _view.VisibilityTabStatoPatrimoniale, dateToExport); if (_view.IsFreeTemplate) { _service.ExportToExcel(_view.ModelloStampa(), c, settings, "Rendiconto" + _view.MainHeader); } else { _service.ExportToExcel(_view.ModelloStampa(_service.RendicontoHeader.IsRegionale), c, settings, "Rendiconto" + _view.MainHeader); } } catch (Exception ex) { _view.GetSimpleMessageNotificator().Show(ex.Message, "Errore", MessageType.Error); } finally { SimpleDelegate d = _view.HidePanel; _view.Invoke(d); } }
public void ExportToExcel(string model, ExcelSearchCriteria criteria, StampaExcelSettings settings, string name) { Exporter ex = new Exporter(model); ex.SetStatoPatrimonialeSettings(settings); ex.BeginExportBilancio += new EventHandler(ex_BeginExportBilancio); ex.BeginExportPreventivo += new EventHandler(ex_BeginExportPreventivo); ex.BeginExportStatoPatrimoniale += new EventHandler(ex_BeginExportStatoPatrimoniale); ex.Export(_current, criteria); string file = name; string path = Environment.GetFolderPath(Environment.SpecialFolder.DesktopDirectory); string filename = Path.Combine(path, file + ".xls"); int i = 0; while (System.IO.File.Exists(filename)) { i++; filename = Path.Combine(path, file + i.ToString() + ".xls"); } //string path = Environment.GetFolderPath (Environment.SpecialFolder.DesktopDirectory ); //string file = Path.Combine(path,nomeFileDaSalvare); ex.SaveAs(filename); Process.Start(filename); }