public static void SupplyWindowsillExport(int supplyDocumentId) { FolderBrowserDialog fbDialog = new FolderBrowserDialog(); if (fbDialog.ShowDialog() != DialogResult.OK) { return; } // -- Информация по контрагенту фабрики окон Contractor contractor = Contractor.GetContractor(); // -- Информация по документу string supplyDocName = string.Empty; DateTime supplyDocDate; using (SqlCommand command = new SqlCommand()) using (SqlDataAdapter adapter = new SqlDataAdapter(command)) { command.Connection = dbinit.db; command.CommandText = "SELECT name, dtdoc FROM supplydoc WHERE idsupplydoc = @idsupplydoc"; command.Parameters.AddWithValue("@idsupplydoc", supplyDocumentId); DataTable datatable = new DataTable(); adapter.Fill(datatable); supplyDocName = (string)datatable.Rows[0]["name"]; supplyDocDate = (DateTime)datatable.Rows[0]["dtdoc"]; } List <IDocExporter> exporters = new List <IDocExporter>(); // exporters.Add(new CrystalitSupplyExporter(supplyDocumentId)); // exporters.Add(new TsvetoslavSupplyExporter(supplyDocumentId)); exporters.Add(new TbmSupplyExporter(supplyDocumentId)); foreach (IDocExporter exporter in exporters) { exporter.DocName = supplyDocName; exporter.DocDate = supplyDocDate; exporter.FileDirecoryName = fbDialog.SelectedPath; exporter.Export(); } }
public static void SupplyGlassPackExport(int supplyDocumentId) { FolderBrowserDialog fbDialog = new FolderBrowserDialog(); fbDialog.SelectedPath = "c:\\test"; //if (fbDialog.ShowDialog() != DialogResult.OK) // return; // -- Информация по контрагенту фабрики окон Contractor contractor = Contractor.GetContractor(); // -- Информация по документу string supplyDocName = string.Empty; DateTime supplyDocDate; using (SqlCommand command = new SqlCommand()) using (SqlDataAdapter adapter = new SqlDataAdapter(command)) { command.Connection = dbinit.db; command.CommandText = "SELECT comment, dtdoc FROM supplydoc WHERE idsupplydoc = @idsupplydoc"; command.Parameters.AddWithValue("@idsupplydoc", supplyDocumentId); DataTable datatable = new DataTable(); adapter.Fill(datatable); supplyDocName = (string)datatable.Rows[0]["comment"]; supplyDocDate = (DateTime)datatable.Rows[0]["dtdoc"]; } List <IDocExporter> exporters = new List <IDocExporter>(); exporters.Add(new StisGlassPackStandartExporter(supplyDocumentId)); exporters.Add(new StisGlassPackNonStandartExporter(supplyDocumentId)); exporters.Add(new StisGlasspackNonStandartSketchExporter(supplyDocumentId)); foreach (IDocExporter exporter in exporters) { exporter.DocName = supplyDocName; exporter.DocDate = supplyDocDate; exporter.FileDirecoryName = fbDialog.SelectedPath; exporter.Export(); } }