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();
}
}
internal static Contractor GetContractor()
{
if (_instance == null)
{
SqlConnection connection = dbinit.db;
using (SqlCommand command = new SqlCommand("SELECT name, inn, address FROM customer WHERE idcustomer = 40860", connection))
using (SqlDataAdapter adapter = new SqlDataAdapter(command))
{
DataTable dataTable = new DataTable();
adapter.Fill(dataTable);
DataRow row = dataTable.Rows[0];
_instance = new Contractor((string)row["name"], (string)row["inn"], (string)row["address"]);
}
}
return(_instance);
}
