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