public virtual void Generate(ref ZedGraph.ZedGraphControl graph)
{
GraphPane myPane = graph.GraphPane;
myPane.Fill = new Fill(Color.FromArgb(210, 210, 210), Color.FromArgb(240, 250, 240));
myPane.Chart.Fill = new Fill(Color.White,
Color.FromArgb(255, 255, 210), -45F);
myPane.Legend.Position = ZedGraph.LegendPos.Right;
myPane.Legend.FontSpec.Size = 7;
myPane.Title.Text = title;
myPane.XAxis.Title.Text = xtitle;
myPane.YAxis.Title.Text = ytitle;
graph.AxisChange();
IList <E_Label_Value> List = E_Label_Value.LoadFromQuery(query);
double[] y = new double[List.Count];
string[] x = new string[List.Count];
int i = 0;
foreach (E_Label_Value val in List)
{
x[i] = val.Label;
y[i] = (double)val.Value;
i++;
}
BarItem myCurve = myPane.AddBar("Curve 1", null, y, Color.White);
myPane.XAxis.Scale.TextLabels = x;
myPane.XAxis.Scale.FontSpec.Angle = angle;
myPane.XAxis.Scale.FontSpec.Size = fontsize;
myCurve.Bar.Fill = new Fill(Color.Orange, Color.Red, 45.0f);
// Draw the X tics between the labels instead of at the labels
myPane.XAxis.MajorTic.IsBetweenLabels = true;
myPane.Legend.IsVisible = false;
// Set the XAxis to Text type
myPane.XAxis.Type = AxisType.Text;
graph.AxisChange();
}
public void Generate(ref ZedGraph.ZedGraphControl graph)
{
GraphPane myPane = graph.GraphPane;
myPane.Fill = new Fill(Color.FromArgb(210, 210, 210), Color.FromArgb(240, 250, 240));
myPane.Chart.Fill = new Fill(Color.White,
Color.FromArgb(255, 255, 210), -45F);
myPane.Legend.Position = ZedGraph.LegendPos.Right;
myPane.Legend.FontSpec.Size = 7;
myPane.Title.Text = "DB Size report";
myPane.XAxis.Title.Text = "Table";
myPane.YAxis.Title.Text = "Size in MB";
graph.AxisChange();
IList <E_Label_Value> List = E_Label_Value.LoadFromQuery("SELECT left([TableName],cast((CHARINDEX('_',[TableName],0)-1) as bigint)) as Label ,sum([TotalSpaceMB]) as Value FROM [SYNAPSE].[dbo].[V_Synapse_DB_USAGE] group by left([TableName],cast((CHARINDEX('_',[TableName],0)-1) as bigint)) order by Label");
double[] y = new double[List.Count];
string[] x = new string[List.Count];
int i = 0;
foreach (E_Label_Value val in List)
{
x[i] = val.Label;
y[i] = (double)val.Value;
i++;
}
BarItem myCurve = myPane.AddBar("Curve 1", null, y, Color.White);
myPane.XAxis.Scale.TextLabels = x;
myPane.XAxis.Scale.FontSpec.Angle = 45;
myPane.XAxis.Scale.FontSpec.Size = 6;
myCurve.Bar.Fill = new Fill(Color.White, Color.SteelBlue, 45.0f);
// Draw the X tics between the labels instead of at the labels
myPane.XAxis.MajorTic.IsBetweenLabels = true;
myPane.Legend.IsVisible = false;
// Set the XAxis to Text type
myPane.XAxis.Type = AxisType.Text;
graph.AxisChange();
}
