private static ReportDataDefinition PackReportResponse(QueryResult results) { DataTable table = results.DataTable; var data = new ReportDataDefinition( ); ResultColumn idCol = results.Columns.FirstOrDefault(c => c.RequestColumn.ColumnName == "_Id"); data.ReportTitle = "Query"; data.ReportStyle = "Simple"; data.Columns = new List <ReportColumn>( results.Columns.Select(c => new ReportColumn { Title = !string.IsNullOrEmpty(c.DisplayName) ? c.DisplayName : c.RequestColumn.ColumnName, DataType = c.ColumnType.GetDisplayName( ) })); data.ReportDataRows = new List <ReportData>( table.Rows.OfType <DataRow>( ).Select(r => new ReportData { Id = idCol != null ? ( long )r[idCol.RequestColumn.ColumnName] : 99, LineItems = new List <ReportDataItem>(table.Columns.OfType <DataColumn>( ) .Select(c => new ReportDataItem { Value = r[c.ColumnName].ToString( ) })) })); return(data); }
private void chartListBox1_SelectedIndexChanged(object sender, EventArgs e) { if (chartListBox1.SelectedSeries == null) { return; } if (chartListBox1.SelectedSeries.Tag == null) { chartListBox1.SelectedSeries.Tag = Guid.NewGuid().ToString(); } string SeriesIndex = chartListBox1.SelectedSeries.Tag.ToString(); ChartAxisAtt AxisAtt; if (_ChartPainter._AxisInfoList.ContainsKey(SeriesIndex)) { AxisAtt = _ChartPainter._AxisInfoList[SeriesIndex]; } else { AxisAtt = new ChartAxisAtt(); _ChartPainter._AxisInfoList.Add(SeriesIndex, AxisAtt); } rButton_BindData.Checked = AxisAtt.DataDefinition is ChartDataDefinition; rButton_BindArea.Checked = AxisAtt.DataDefinition is ReportDataDefinition; if (rButton_BindData.Checked) { ChartDataDefinition chartDataDefinition = AxisAtt.DataDefinition as ChartDataDefinition; TextBox_CatlogAxis.Text = string.Join("\n", chartDataDefinition.CatlogAxises.ToArray()); TextBox_SeriesAxis.Text = chartDataDefinition.SeriesAxis; ComboBox_Functions.SelectedIndex = ComboBox_Functions.Items.IndexOf(chartDataDefinition.FunctionInfo); checkBox1.Checked = chartDataDefinition.DistinctCatlog; } else { ReportDataDefinition reportDataDefinition = AxisAtt.DataDefinition as ReportDataDefinition; TextBox_CatlogAxis1.Text = reportDataDefinition.CatlogArea; TextBox_SeriesAxis1.Text = reportDataDefinition.SeriesArea; TextBox_NameAxis1.Text = reportDataDefinition.SeriesNameArea; } }
private void TextBox_TextChanged(object sender, EventArgs e) { if (chartListBox1.SelectedSeries != null) { if (chartListBox1.SelectedSeries.Tag == null) { chartListBox1.SelectedSeries.Tag = Guid.NewGuid().ToString(); } string SeriesIndex = chartListBox1.SelectedSeries.Tag.ToString(); if (_ChartPainter._AxisInfoList.ContainsKey(SeriesIndex)) { ChartAxisAtt AxisAtt = _ChartPainter._AxisInfoList[SeriesIndex]; ChartDataDefinition chartDataDefinition = AxisAtt.DataDefinition as ChartDataDefinition; ReportDataDefinition reportDataDefinition = AxisAtt.DataDefinition as ReportDataDefinition; if (sender == TextBox_CatlogAxis) { chartDataDefinition.CatlogAxises.Clear(); chartDataDefinition.CatlogAxises.AddRange(TextBox_CatlogAxis.Lines); } else if (sender == TextBox_SeriesAxis) { chartDataDefinition.SeriesAxis = TextBox_SeriesAxis.Text; } else if (sender == TextBox_CatlogAxis1) { reportDataDefinition.CatlogArea = TextBox_CatlogAxis1.Text; } else if (sender == TextBox_SeriesAxis1) { reportDataDefinition.SeriesArea = TextBox_SeriesAxis1.Text; } else if (sender == TextBox_NameAxis1) { reportDataDefinition.SeriesNameArea = TextBox_NameAxis1.Text; } } } }