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;
}
