//TODO
private void Export2Shp_Clicked(object sender, EventArgs e)
{
var dc = DataContext as IDendritiRecord <ObservationSeries>;
if (dc != null)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "csv file|*.csv";
dlg.FileName = dc.Name + ".csv";
if (dlg.ShowDialog() == DialogResult.OK)
{
if (dc.Tag is Heiflow.Core.Data.ODM.Variable)
{
CSVFileStream csv = new CSVFileStream(dlg.FileName);
string content = "SiteName,SiteID,Longitude,Latitude,Max,Min,Average,NoDataValue,StandardDeviation,Count\n";
foreach (var record in dc.Children)
{
var site = record.Value.Site;
var statinfo = ODMSource.GetValueStatistics(record.Value);
content += string.Format("{0},{1},{2},{3},{4}\n", site.Name, site.ID, site.Longitude, site.Latitude, statinfo.ToString());
}
content.Trim(TypeConverterEx.Enter);
csv.Save(content);
}
}
}
}
public override void CustomExport(DataTable source)
{
if (source != null)
{
var sites = GetSites(source);
var setting = _ExportSetting as SiteExportSetting;
foreach (var site in sites)
{
var series = new ObservationSeries()
{
SiteID = site.ID,
VariableID = setting.VariableID
};
var ts = ODM.GetTimeSereis(series);
if (ts != null)
{
var filename = Path.Combine(setting.Directory, site.Name + ".csv");
var var_odm = ODM.GetVariable(setting.VariableID);
ts.Name = var_odm.Name;
CSVFileStream csv = new CSVFileStream(filename);
csv.Save(ts);
}
}
}
}
//TODO
private void Export2Excel_Clicked(object sender, EventArgs e)
{
var dc = DataContext as IDendritiRecord <ObservationSeries>;
if (dc != null && dc.Children.Count == 0)
{
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "csv file|*.csv";
dlg.FileName = dc.Name + ".csv";
if (dlg.ShowDialog() == DialogResult.OK)
{
var qc = new QueryCriteria()
{
SiteID = dc.Value.SiteID,
VariableID = dc.Value.VariableID,
AllTime = true
};
var ts = ODMSource.GetTimeSeries(qc);
if (ts != null)
{
CSVFileStream csvf = new CSVFileStream(dlg.FileName);
csvf.Save(ts);
}
}
}
}
public virtual void Export(string filename, System.Data.DataTable source)
{
if (source != null)
{
CSVFileStream csv = new CSVFileStream(filename);
csv.Save(source);
}
}
private void btnSave2Excel_Click(object sender, EventArgs e)
{
var dt = this.bindingSource1.DataSource as DataTable;
if (dt != null)
{
SaveFileDialog sd = new SaveFileDialog();
sd.Filter = "csv file|*.csv";
sd.FileName = "table.csv";
if (sd.ShowDialog() == DialogResult.OK)
{
CSVFileStream csv = new CSVFileStream(sd.FileName);
csv.Save(dt);
}
}
}
private void btnExport_Click(object sender, EventArgs e)
{
if (_SelectedDataCubeMeta == null)
{
return;
}
SaveFileDialog dlg = new SaveFileDialog();
dlg.Filter = "csv file|*.csv";
dlg.FileName = _SelectedDataCubeMeta.Mat.Name + ".csv";
if (dlg.ShowDialog() == DialogResult.OK)
{
CSVFileStream csv = new CSVFileStream(dlg.FileName);
csv.Save(arrayGrid.DataSource, _SelectedDataCubeMeta.Mat.Variables);
}
}
private void btnExport_Click(object sender, EventArgs e)
{
var dt = dataGridEx1.DataTable;
if (dt == null)
{
return;
}
SaveFileDialog sd = new SaveFileDialog();
sd.Filter = "csv file|*.csv";
sd.FileName = "table.csv";
if (sd.ShowDialog() == DialogResult.OK)
{
CSVFileStream csv = new CSVFileStream(sd.FileName);
csv.Save(dt);
}
}
