private static SelectStatementBuilder DeserializeFromXml(ExportItem exportItem) { StringReader reader = new StringReader(exportItem.ExportItemData); XmlSerializer xmlSerializer = new XmlSerializer(typeof(SelectStatementBuilder)); SelectStatementBuilder ssb = (SelectStatementBuilder)xmlSerializer.Deserialize(reader); return(ssb); }
public void Export(ReportLogger reportLogger) { if (SelectStatementBuilder == null) { SelectStatementBuilder = new SelectStatementBuilder(); SelectStatementBuilder = SelectStatementBuilder.LoadSelectStatementBuilder(ExportItemName); } _exporter.Export(reportLogger); }
public void Save() { ExportItem exportItem = Get.GetExportItem(ExportItemName); if (exportItem == null) { Insert.AddExportItem(ExportItemName, SelectStatementBuilder.SerializeToXml(), ExportItemFtpId, ExportItemRunTime, ExportEnabled, ExportType); } else { Update.UpdateExportItem(this); } }
public CsvDataExporter(ExportItem exportItem) { PropertyExporterLogger = new ReportLogger(exportItem.ExportItemName); if (!CoreDataLib.IsLive()) { ServerPath = @"\\SVRsql4\E$\CoreData\ExportFiles\Test\"; ExportServerTemp = @"E:\CoreData\ExportFiles\Test\Temp\"; TempServerPath = ServerPath + @"Temp\"; } else { ServerPath = "E:\\CoreData\\ExportFiles\\"; ExportServerTemp = @"E:\CoreData\ExportFiles\Temp\"; TempServerPath = ServerPath + @"Temp\"; } ExportItem = exportItem; m_pathAndFileName = TempServerPath + exportItem.ExportItemName + ".csv"; m_selectClause = exportItem.SelectStatementBuilder.SelectStatement(); m_selectStatementBuilder = exportItem.SelectStatementBuilder; }