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