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);
}
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 SetStatoPatrimonialeSettings(StampaExcelSettings settings)
{
_settings = settings;
}
