private void loadData()
{
comm_list[] send_comm = new comm_list[21];
Series[] DataSeries = new Series[21];
Series[] series3 = new Series[21];
Series BoxPlotSeries = new Series();
System.Data.DataView dv;
System.Data.DataView dv_order_desc; // 2015.02.06 denny
dv = MainModule.AccessDatabasesel("SELECT top 1 format(TestTime, 'YYYY-MM-DD') as tt01 FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' order by TestTime DESC");
if (dv.Count > 0)
{
DateTime setdate = Convert.ToDateTime(dv[0].Row["tt01"]).AddDays(-21);
//dv = MainModule.AccessDatabasesel("SELECT top 21 format(gl.TestTime, 'YYYY-MM-DD') AS TestT, MAX(iif(isnull(a.GD0), 0, CDBL(a.GD0))) AS Expr1, MAX(iif(isnull(a_1.GD1), 0, CDBL(a_1.GD1))) AS Expr2, " +
// " MAX(iif(isnull(a_2.GD2), 0, CDBL(a_2.GD2))) AS Expr3, MAX(iif(isnull(a_3.GD3), 0, CDBL(a_3.GD3))) AS Expr4, MAX(iif(isnull(a_4.GD4), 0, CDBL(a_4.GD4))) " +
// " AS Expr5, MAX(iif(isnull(a_5.GD5), 0, CDBL(a_5.GD5))) AS Expr6, MAX(iif(isnull(a_6.GD6), 0, CDBL(a_6.GD6))) AS Expr7, MAX(iif(isnull(a_7.GD7), " +
// " 0, CDBL(a_7.GD7))) AS Expr8, MAX(iif(isnull(a_8.GD8), 0, CDBL(a_8.GD8))) " +
// " AS Expr9 FROM (((((((((glucose gl LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD0, format(TestTime, 'YYYY-MM-DD') AS TT0 FROM glucose gl_1 " +
// " WHERE (TIME_IDX = 1)) a ON a.TT0 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD1, format(TestTime, 'YYYY-MM-DD') AS TT1 FROM glucose gl_2 " +
// " WHERE (TIME_IDX = 2)) a_1 ON a_1.TT1 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD2, format(TestTime, 'YYYY-MM-DD') AS TT2 FROM glucose gl_3 " +
// " WHERE (TIME_IDX = 3)) a_2 ON a_2.TT2 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD3, format(TestTime, 'YYYY-MM-DD') AS TT3 FROM glucose gl_4 " +
// " WHERE (TIME_IDX = 4)) a_3 ON a_3.TT3 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD4, format(TestTime, 'YYYY-MM-DD') AS TT4 FROM glucose gl_5 " +
// " WHERE (TIME_IDX = 5)) a_4 ON a_4.TT4 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD5, format(TestTime, 'YYYY-MM-DD') AS TT5 FROM glucose gl_6 " +
// " WHERE (TIME_IDX = 6)) a_5 ON a_5.TT5 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD6, format(TestTime, 'YYYY-MM-DD') AS TT6 FROM glucose gl_7 " +
// " WHERE (TIME_IDX = 7)) a_6 ON a_6.TT6 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN (SELECT GlucoseData AS GD7, format(TestTime, 'YYYY-MM-DD') " +
// " AS TT7 FROM glucose gl_8 WHERE (TIME_IDX = 8)) a_7 ON a_7.TT7 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD8, format(TestTime, 'YYYY-MM-DD') AS TT8 FROM glucose gl_9 " +
// " WHERE (TIME_IDX = 9)) a_8 ON a_8.TT8 = format(gl.TestTime, 'YYYY-MM-DD')) where format(gl.TestTime, 'YYYY-MM-DD') >'#"+ setdate + "#' "+
// " GROUP BY format(gl.TestTime, 'YYYY-MM-DD') order by format(gl.TestTime, 'YYYY-MM-DD') ");
dv = MainModule.SetGlucoseToTimeSet();
dv_order_desc = MainModule.AccessDatabasesel("SELECT TestTime, GlucoseData FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC"); // 2015.02.06 denny
int[] count1 = new int[21];
int[] count2 = new int[21];
for (int ii = 0; ii < 21; ii++)
{
DataSeries[ii] = new Series();
send_comm[ii] = new comm_list();
series3[ii] = new Series();
count1[ii] = 0;
}
for (int jj = 0; jj < dv_order_desc.Count; jj++)
{
int after_setdate = 0;
TimeSpan after_setdate1;
after_setdate1 = Convert.ToDateTime(dv_order_desc[jj].Row["TestTime"]) - setdate;
after_setdate = Convert.ToInt16(after_setdate1.Days);
if (after_setdate > -1 && after_setdate < 21)
{
//send_comm[after_setdate].yValues[count1[after_setdate]] = Convert.ToDouble(dv_order_desc[jj].Row["GlucoseData"]);
count1[after_setdate]++;
}
}
for (int jj = 0; jj < 21; jj++)
{
send_comm[jj].yValues = new double[count1[jj]];
}
for (int jj = 0; jj < dv_order_desc.Count; jj++)
{
int after_setdate = 0;
TimeSpan after_setdate1;
after_setdate1 = Convert.ToDateTime(dv_order_desc[jj].Row["TestTime"]) - setdate;
after_setdate = Convert.ToInt16(after_setdate1.Days);
if (after_setdate > -1 && after_setdate < 21)
{
send_comm[after_setdate].yValues[count2[after_setdate]] = Convert.ToDouble(dv_order_desc[jj].Row["GlucoseData"]);
count2[after_setdate]++;
}
}
/* // 2015.02.06 denny
* for (int jj = 0; jj < dv.Count; jj++)
* {
*
* int dafid = 0;
* TimeSpan dafid1;
* dafid1 = Convert.ToDateTime(dv[jj].Row["TestT"]) - setdate;
* dafid = Convert.ToInt16(dafid1.Days);
*
* if (dafid > -1 && dafid < 21)
* {
* for (int ii = 0; ii < 9; ii++)
* {
* string eestr = "Expr" + (ii + 1);
* // send_comm[ii].yValues[count1[ii]] = rand.Next(45, 95);
* if (Convert.ToInt16(dv[jj].Row[eestr]) == 0)
* {
* }
* else
* {
* count1[dafid]++;
* }
* }
* }
* }
*/// 2015.02.06 denny
/* // 2015.02.06 denny
* for (int jj = 0; jj < 21; jj++)
* {
* send_comm[jj].yValues = new double[count1[jj]];
* }
* int[] count2 = new int[21];
*/
// 2015.02.06 denny
/* // 2015.02.06 denny
* for (int jj = 0; jj < dv.Count; jj++)
* {
* int dafid = 0;
* TimeSpan dafid1;
* dafid1 = Convert.ToDateTime(dv[jj].Row["TestT"]) - setdate;
* dafid = Convert.ToInt16(dafid1.Days);
* if (dafid > -1 && dafid < 21)
* {
* for (int ii = 0; ii < 9; ii++)
* {
*
*
* string eestr = "Expr" + (ii + 1);
* // send_comm[ii].yValues[count1[ii]] = rand.Next(45, 95);
* if (Convert.ToInt16(dv[jj].Row[eestr]) == 0)
* {
* }
* else
* {
* send_comm[dafid].yValues[count2[dafid]] = Convert.ToInt16(dv[jj].Row[eestr]);
* count2[dafid]++;
* }
* }
* // send_comm[jj].yValues[ii] = rand.Next(45, 95);
*
* }
* }
*/// 2015.02.06 denny
ChartArea ChartArea2 = new ChartArea();
ChartArea ChartArea3 = new ChartArea();
ChartArea bx1 = new ChartArea();
//Add the charting areas to the chart
chart1.ChartAreas.Clear();
chart1.ChartAreas.Add(ChartArea2);
chart1.ChartAreas.Add(ChartArea3);
ChartArea2.Name = "Data Chart Area";
ChartArea3.Name = "Box Plot Area";
//ChartArea3.AlignWithChartArea = "Data Chart Area"
ChartArea2.Position.X = 0;
ChartArea2.Position.Y = 0;
ChartArea3.Position.X = 0;
ChartArea3.Position.Y = 0;
ChartArea2.Position.Height = 82f;
ChartArea2.Position.Width = 0f;
ChartArea3.Position.Height = 92f;
ChartArea3.Position.Width = 90f;
// ChartArea3.AxisX.IsLabelAutoFit = False
// ChartArea3.AxisX.MajorGrid.Enabled = False
// ChartArea3.AxisX.MajorTickMark.Enabled = False
ChartArea3.AxisX.ScaleBreakStyle.Spacing = .5;
// ChartArea3.AxisX.ScaleBreakStyle.StartFromZero = StartFromZero.No
ChartArea3.AxisX.Minimum = 0.5;
ChartArea3.AxisX.Maximum = 21.5;
// BackGradientStyle = "VerticalCenter"
// ChartArea3.ShadowColor = Drawing.Color.Cyan
// ChartArea3.BackSecondaryColor = Drawing.Color.FromArgb(128, 255, 255)
// ChartArea3.BorderColor = Drawing.Color.Black
for (int jj = 0; jj < 21; jj++)
{
series3[jj].Name = "BoxPlotLabels" + jj;
series3[jj].ChartArea = "Box Plot Area";
series3[jj].ChartType = SeriesChartType.Point;
series3[jj].CustomProperties = "LabelStyle=Center"; // Right// 2015.02.09 denny
series3[jj].Font = new System.Drawing.Font("Microsoft Sans Serif", 8F); // 7F // 2015.02.09 denny
series3[jj].Legend = "Default";
}
for (int jj = 0; jj < 21; jj++)
{
DataPoint dataPoint1 = new DataPoint(1 + jj, 0);
DataPoint dataPoint2 = new DataPoint(1 + jj, 0);
DataPoint dataPoint3 = new DataPoint(1 + jj, 0);
DataPoint dataPoint4 = new DataPoint(1 + jj, 0);
DataPoint dataPoint5 = new DataPoint(1 + jj, 0);
DataPoint dataPoint6 = new DataPoint(1 + jj, 0);
DataPoint dataPoint7 = new DataPoint(1 + jj, 0);
DataPoint dataPoint8 = new DataPoint(1 + jj, 0);
dataPoint1.Color = System.Drawing.Color.Transparent;
dataPoint2.Color = System.Drawing.Color.Transparent;
dataPoint3.Color = System.Drawing.Color.Transparent;
dataPoint4.Color = System.Drawing.Color.Transparent;
dataPoint5.Color = System.Drawing.Color.Transparent;
dataPoint6.Color = System.Drawing.Color.Transparent;
dataPoint7.Color = System.Drawing.Color.Transparent;
dataPoint8.Color = System.Drawing.Color.Transparent;
series3[jj].Points.Add(dataPoint1);
series3[jj].Points.Add(dataPoint2);
series3[jj].Points.Add(dataPoint3);
series3[jj].Points.Add(dataPoint4);
series3[jj].Points.Add(dataPoint5);
series3[jj].Points.Add(dataPoint6);
series3[jj].Points.Add(dataPoint7);
series3[jj].Points.Add(dataPoint8);
series3[jj].SmartLabelStyle.Enabled = false;
}
for (int jj = 0; jj < 21; jj++)
{
DataSeries[jj].Name = "DataSeries" + jj;
DataSeries[jj].ChartType = SeriesChartType.Point;
DataSeries[jj].ChartArea = "Data Chart Area";
DataSeries[jj].IsValueShownAsLabel = false;
DataSeries[jj].IsVisibleInLegend = false;
}
BoxPlotSeries.Name = "BoxPlotSeries";
BoxPlotSeries.ChartType = SeriesChartType.BoxPlot;
BoxPlotSeries.ChartArea = "Box Plot Area";
// BoxPlotSeries.IsValueShownAsLabel = true;
BoxPlotSeries.IsVisibleInLegend = true;
BoxPlotSeries.BackGradientStyle = GradientStyle.VerticalCenter;
BoxPlotSeries.Color = System.Drawing.Color.Cyan;
BoxPlotSeries.BackSecondaryColor = System.Drawing.Color.FromArgb(128, 255, 255);
BoxPlotSeries.BorderColor = System.Drawing.Color.Black;
chart1.Series.Clear();
chart1.Series.Add(BoxPlotSeries);
// Add data to Box Plot Source series.
string datastr = "";
for (int jj = 0; jj < 21; jj++)
{
chart1.Series.Add(series3[jj]);
chart1.Series.Add(DataSeries[jj]);
chart1.Series[DataSeries[jj].Name].Points.DataBindY(send_comm[jj].yValues);
if (jj > 0)
{
datastr = datastr + ";" + DataSeries[jj].Name;
}
else
{
datastr = DataSeries[jj].Name;
}
}
chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart1.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Set whiskers 15th percentile.
//chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";// 2015.02.04 denny
// Show/Hide Average line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart1.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart1.Series["BoxPlotSeries"]["PointWidth"] = "0.5";//0.25;// 2015.02.09 denny
chart1.Series["BoxPlotSeries"].XValueMember = "day of week";
chart1.Series["BoxPlotSeries"].IsValueShownAsLabel = false;//true;// 2015.02.05 denny
for (int jj = 0; jj < 21; jj++)
{
//string dstring; // 2015.02.06 denny
ChartArea3.AxisX.CustomLabels.Add(0, 2 * (jj + 1), Convert.ToString(Convert.ToDateTime(setdate).AddDays(jj).ToString("MM/dd")));
// alu_tp.timgp[t1].time_on = dv1[t1].Row["time_on"].ToString();
// alu_tp.timgp[t1].time_off = dv1[t1].Row["time_off"].ToString();
}
ChartArea3.AxisX.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
ChartArea3.AxisY.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
StripLine s01;
if (alu_tp.main_1.TargetMaxOptionp.ToString().Length > 0 || alu_tp.main_1.TargetMinOptionp.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(248, 199, 213);
s01.IntervalOffset = 0;
s01.StripWidth = 700;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
s01 = new StripLine();
s01.BackColor = Color.FromArgb(245, 250, 189);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOptionp);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOptionp) - s01.IntervalOffset;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
}
if (alu_tp.main_1.TargetMaxOption.ToString().Length > 0 || alu_tp.main_1.TargetMinOption.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(190, 251, 210);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOption);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOption) - s01.IntervalOffset;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
}
for (int jj = 0; jj < 21; jj++)
{
chart1.Series[DataSeries[jj].Name].Enabled = false;
}
}
}
private void loadData()
{
comm_list[] send_comm = new comm_list[7];
Series[] DataSeries = new Series[7];
Series[] series3 = new Series[7];
Series BoxPlotSeries = new Series();
System.Data.DataView dv;
dv = MainModule.AccessDatabasesel("SELECT GlucoseData, DAYOFWEEK from glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ");
int[] count1 = new int[7];
for (int ii = 0; ii < 7; ii++)
{
DataSeries[ii] = new Series();
send_comm[ii] = new comm_list();
series3[ii] = new Series();
count1[ii] = 0;
}
for (int jj = 0; jj < dv.Count; jj++)
{
count1[Convert.ToInt16(dv[jj].Row["DAYOFWEEK"])]++;
}
for (int jj = 0; jj < 7; jj++)
{
send_comm[jj].yValues = new double[count1[jj]];
}
int[] count2 = new int[7];
for (int jj = 0; jj < dv.Count; jj++)
{
send_comm[Convert.ToInt16(dv[jj].Row["DAYOFWEEK"])].yValues[count2[Convert.ToInt16(dv[jj].Row["DAYOFWEEK"])]] = Convert.ToInt16(dv[jj].Row["GlucoseData"]);
count2[Convert.ToInt16(dv[jj].Row["DAYOFWEEK"])]++;
// send_comm[jj].yValues[ii] = rand.Next(45, 95);
}
ChartArea ChartArea2 = new ChartArea();
ChartArea ChartArea3 = new ChartArea();
ChartArea bx1 = new ChartArea();
//Add the charting areas to the chart
chart1.ChartAreas.Clear();
chart1.ChartAreas.Add(ChartArea2);
chart1.ChartAreas.Add(ChartArea3);
ChartArea2.Name = "Data Chart Area";
ChartArea3.Name = "Box Plot Area";
//ChartArea3.AlignWithChartArea = "Data Chart Area"
ChartArea2.Position.X = 0;
ChartArea2.Position.Y = 0;
ChartArea3.Position.X = 0;
ChartArea3.Position.Y = 0;
ChartArea2.Position.Height = 82f;
ChartArea2.Position.Width = 0f;
ChartArea3.Position.Height = 92f;
ChartArea3.Position.Width = 90f;
// ChartArea3.AxisX.IsLabelAutoFit = False
// ChartArea3.AxisX.MajorGrid.Enabled = False
// ChartArea3.AxisX.MajorTickMark.Enabled = False
ChartArea3.AxisX.ScaleBreakStyle.Spacing = .5;
// ChartArea3.AxisX.ScaleBreakStyle.StartFromZero = StartFromZero.No
ChartArea3.AxisX.Minimum = 0.5;
ChartArea3.AxisX.Maximum = 7.5;
// BackGradientStyle = "VerticalCenter"
// ChartArea3.ShadowColor = Drawing.Color.Cyan
// ChartArea3.BackSecondaryColor = Drawing.Color.FromArgb(128, 255, 255)
// ChartArea3.BorderColor = Drawing.Color.Black
for (int jj = 0; jj < 7; jj++)
{
series3[jj].Name = "BoxPlotLabels" + jj;
series3[jj].ChartArea = "Box Plot Area";
series3[jj].ChartType = SeriesChartType.Point;
series3[jj].CustomProperties = "LabelStyle=Center"; // 2015.02.02 denny
series3[jj].Font = new System.Drawing.Font("Microsoft Sans Serif", 10F); // 2015.02.03 denny
series3[jj].Legend = "Default";
}
for (int jj = 0; jj < 7; jj++)
{
DataPoint dataPoint1 = new DataPoint(1 + jj, 0);
DataPoint dataPoint2 = new DataPoint(1 + jj, 0);
DataPoint dataPoint3 = new DataPoint(1 + jj, 0);
DataPoint dataPoint4 = new DataPoint(1 + jj, 0);
DataPoint dataPoint5 = new DataPoint(1 + jj, 0);
DataPoint dataPoint6 = new DataPoint(1 + jj, 0);
DataPoint dataPoint7 = new DataPoint(1 + jj, 0);
DataPoint dataPoint8 = new DataPoint(1 + jj, 0);
dataPoint1.Color = System.Drawing.Color.Transparent;
dataPoint2.Color = System.Drawing.Color.Transparent;
dataPoint3.Color = System.Drawing.Color.Transparent;
dataPoint4.Color = System.Drawing.Color.Transparent;
dataPoint5.Color = System.Drawing.Color.Transparent;
dataPoint6.Color = System.Drawing.Color.Transparent;
dataPoint7.Color = System.Drawing.Color.Transparent;
dataPoint8.Color = System.Drawing.Color.Transparent;
series3[jj].Points.Add(dataPoint1);
series3[jj].Points.Add(dataPoint2);
series3[jj].Points.Add(dataPoint3);
series3[jj].Points.Add(dataPoint4);
series3[jj].Points.Add(dataPoint5);
series3[jj].Points.Add(dataPoint6);
series3[jj].Points.Add(dataPoint7);
series3[jj].Points.Add(dataPoint8);
series3[jj].SmartLabelStyle.Enabled = false;
}
for (int jj = 0; jj < 7; jj++)
{
DataSeries[jj].Name = "DataSeries" + jj;
DataSeries[jj].ChartType = SeriesChartType.Point;
DataSeries[jj].ChartArea = "Data Chart Area";
DataSeries[jj].IsValueShownAsLabel = false;
DataSeries[jj].IsVisibleInLegend = false;
}
BoxPlotSeries.Name = "BoxPlotSeries";
BoxPlotSeries.ChartType = SeriesChartType.BoxPlot;
BoxPlotSeries.ChartArea = "Box Plot Area";
// BoxPlotSeries.IsValueShownAsLabel = true;
BoxPlotSeries.IsVisibleInLegend = true;
BoxPlotSeries.BackGradientStyle = GradientStyle.VerticalCenter;
BoxPlotSeries.Color = System.Drawing.Color.Cyan;
BoxPlotSeries.BackSecondaryColor = System.Drawing.Color.FromArgb(128, 255, 255);
BoxPlotSeries.BorderColor = System.Drawing.Color.Black;
chart1.Series.Clear();
chart1.Series.Add(BoxPlotSeries);
// Add data to Box Plot Source series.
string datastr = "";
for (int jj = 0; jj < 7; jj++)
{
chart1.Series.Add(series3[jj]);
chart1.Series.Add(DataSeries[jj]);
chart1.Series[DataSeries[jj].Name].Points.DataBindY(send_comm[jj].yValues);
if (jj > 0)
{
datastr = datastr + ";" + DataSeries[jj].Name;
}
else
{
datastr = DataSeries[jj].Name;
}
}
chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart1.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Set whiskers 15th percentile.
chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart1.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart1.Series["BoxPlotSeries"]["PointWidth"] = "0.50";// 2015.02.03 denny
chart1.Series["BoxPlotSeries"].XValueMember = "day of week";
// Dim intWeek As Integer = 7 - Convert.ToInt32(CType(2011 & "/1 / 1", Date).DayOfWeek)
// Dim strWeek As Date = CType(CType(Year01 & "/1 / 1", Date).AddDays(intWeek).ToString(), Date)
for (int jj = 0; jj < 7; jj++)
{
ChartArea3.AxisX.CustomLabels.Add(0, 2 * (jj + 1), Convert.ToDateTime("2011/6/12").AddDays(jj).DayOfWeek.ToString());
// alu_tp.timgp[t1].time_on = dv1[t1].Row["time_on"].ToString();
// alu_tp.timgp[t1].time_off = dv1[t1].Row["time_off"].ToString();
}
ChartArea3.AxisX.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
ChartArea3.AxisY.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
StripLine s01;
if (alu_tp.main_1.TargetMaxOptionp.ToString().Length > 0 || alu_tp.main_1.TargetMinOptionp.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(248, 199, 213);
s01.IntervalOffset = 0;
s01.StripWidth = 700;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
s01 = new StripLine();
s01.BackColor = Color.FromArgb(245, 250, 189);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOptionp);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOptionp) - s01.IntervalOffset;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
}
if (alu_tp.main_1.TargetMaxOption.ToString().Length > 0 || alu_tp.main_1.TargetMinOption.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(190, 251, 210);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOption);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOption) - s01.IntervalOffset;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
}
for (int jj = 0; jj < 7; jj++)
{
chart1.Series[DataSeries[jj].Name].Enabled = false;
}
}
private void loadData()
{
comm_list[] send_comm = new comm_list[9];
Series[] DataSeries = new Series[9];
Series[] series3 = new Series[9];
Series BoxPlotSeries = new Series();
System.Data.DataView dv, dv1;
dv = MainModule.SetGlucoseToTimeSet(); // 2015.01.30 denny
dv1 = MainModule.AccessDatabasesel("SELECT format(TestTime, 'YYYY-MM-DD') AS TestT, GlucoseData,m_Event,time_IDX FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC"); // 2015.01.30 denny
//dv = MainModule.AccessDatabasesel("SELECT * FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC"); // 2015.01.30 denny
int[] count1 = new int[9];
for (int ii = 0; ii < 9; ii++)
{
DataSeries[ii] = new Series();
send_comm[ii] = new comm_list();
series3[ii] = new Series();
count1[ii] = 0;
}
// 2015.01.30 denny
for (int jj = 0; jj < dv.Count; jj++)
{
for (int ii = 0; ii < 9; ii++)
{
string eestr = "Expr" + (ii + 1);
if (Convert.ToInt16(dv[jj].Row[eestr]) == 0)
{
}
else
{
count1[ii]++;
}
dv1.RowFilter = "TestT= '" + Convert.ToString(dv[jj].Row[0]) + "' and time_IDX='" + Convert.ToString(ii + 1) + "' and GlucoseData <> '" + Convert.ToInt16(dv[jj].Row[eestr]) + "' and GlucoseData <> '0'";
if (dv1.Count > 0)
{
for (int t1 = 0; t1 < dv1.Count; t1++)
{
count1[ii]++;
}
}
}
}
for (int jj = 0; jj < 9; jj++)
{
send_comm[jj].yValues = new double[count1[jj]];
}
int[] count2 = new int[9];
for (int jj = 0; jj < dv.Count; jj++)
{
for (int ii = 0; ii < 9; ii++)
{
string eestr = "Expr" + (ii + 1);
if (Convert.ToInt16(dv[jj].Row[eestr]) == 0)
{
}
else
{
send_comm[ii].yValues[count2[ii]] = Convert.ToInt16(dv[jj].Row[eestr]);
count2[ii]++;
}
dv1.RowFilter = "TestT= '" + Convert.ToString(dv[jj].Row[0]) + "' and time_IDX='" + Convert.ToString(ii + 1) + "' and GlucoseData <> '" + Convert.ToInt16(dv[jj].Row[eestr]) + "' and GlucoseData <> '0'";
if (dv1.Count > 0)
{
for (int t1 = 0; t1 < dv1.Count; t1++)
{
send_comm[ii].yValues[count2[ii]] = Convert.ToUInt16(dv1[t1].Row["GlucoseData"]);
count2[ii]++;
}
}
}
}
// 2015.01.30 denny
ChartArea ChartArea2 = new ChartArea();
ChartArea ChartArea3 = new ChartArea();
ChartArea bx1 = new ChartArea();
//Add the charting areas to the chart
chart1.ChartAreas.Clear();
chart1.ChartAreas.Add(ChartArea2);
chart1.ChartAreas.Add(ChartArea3);
ChartArea2.Name = "Data Chart Area";
ChartArea3.Name = "Box Plot Area";
//ChartArea3.AlignWithChartArea = "Data Chart Area"
ChartArea2.Position.X = 0;
ChartArea2.Position.Y = 0;
ChartArea3.Position.X = 0;
ChartArea3.Position.Y = 0;
ChartArea2.Position.Height = 82f;
ChartArea2.Position.Width = 0f;
ChartArea3.Position.Height = 92f;
ChartArea3.Position.Width = 90f;
// ChartArea3.AxisX.IsLabelAutoFit = False
// ChartArea3.AxisX.MajorGrid.Enabled = False
// ChartArea3.AxisX.MajorTickMark.Enabled = False
ChartArea3.AxisX.ScaleBreakStyle.Spacing = .5;
// ChartArea3.AxisX.ScaleBreakStyle.StartFromZero = StartFromZero.No
ChartArea3.AxisX.Minimum = 0.5;
ChartArea3.AxisX.Maximum = 9.5;
// BackGradientStyle = "VerticalCenter"
// ChartArea3.ShadowColor = Drawing.Color.Cyan
// ChartArea3.BackSecondaryColor = Drawing.Color.FromArgb(128, 255, 255)
// ChartArea3.BorderColor = Drawing.Color.Black
for (int jj = 0; jj < 9; jj++)
{
series3[jj].Name = "BoxPlotLabels" + jj;
series3[jj].ChartArea = "Box Plot Area";
series3[jj].ChartType = SeriesChartType.Point;
series3[jj].CustomProperties = "LabelStyle=Center"; // 2015.02.02 denny
series3[jj].Font = new System.Drawing.Font("Microsoft Sans Serif", 10F); // 2015.02.02 denny
series3[jj].Legend = "Default";
}
for (int jj = 0; jj < 9; jj++)
{
DataPoint dataPoint1 = new DataPoint(1 + jj, 0);
DataPoint dataPoint2 = new DataPoint(1 + jj, 0);
DataPoint dataPoint3 = new DataPoint(1 + jj, 0);
DataPoint dataPoint4 = new DataPoint(1 + jj, 0);
DataPoint dataPoint5 = new DataPoint(1 + jj, 0);
DataPoint dataPoint6 = new DataPoint(1 + jj, 0);
DataPoint dataPoint7 = new DataPoint(1 + jj, 0);
DataPoint dataPoint8 = new DataPoint(1 + jj, 0);
dataPoint1.Color = System.Drawing.Color.Transparent;
dataPoint2.Color = System.Drawing.Color.Transparent;
dataPoint3.Color = System.Drawing.Color.Transparent;
dataPoint4.Color = System.Drawing.Color.Transparent;
dataPoint5.Color = System.Drawing.Color.Transparent;
dataPoint6.Color = System.Drawing.Color.Transparent;
dataPoint7.Color = System.Drawing.Color.Transparent;
dataPoint8.Color = System.Drawing.Color.Transparent;
series3[jj].Points.Add(dataPoint1);
series3[jj].Points.Add(dataPoint2);
series3[jj].Points.Add(dataPoint3);
series3[jj].Points.Add(dataPoint4);
series3[jj].Points.Add(dataPoint5);
series3[jj].Points.Add(dataPoint6);
series3[jj].Points.Add(dataPoint7);
series3[jj].Points.Add(dataPoint8);
series3[jj].SmartLabelStyle.Enabled = false;
}
for (int jj = 0; jj < 9; jj++)
{
DataSeries[jj].Name = "DataSeries" + jj;
DataSeries[jj].ChartType = SeriesChartType.Point;
DataSeries[jj].ChartArea = "Data Chart Area";
DataSeries[jj].IsValueShownAsLabel = false;
DataSeries[jj].IsVisibleInLegend = false;
}
BoxPlotSeries.Name = "BoxPlotSeries";
BoxPlotSeries.ChartType = SeriesChartType.BoxPlot;
BoxPlotSeries.ChartArea = "Box Plot Area";
// BoxPlotSeries.IsValueShownAsLabel = true;
BoxPlotSeries.IsVisibleInLegend = true;
BoxPlotSeries.BackGradientStyle = GradientStyle.VerticalCenter;
BoxPlotSeries.Color = System.Drawing.Color.Cyan;
BoxPlotSeries.BackSecondaryColor = System.Drawing.Color.FromArgb(128, 255, 255);
BoxPlotSeries.BorderColor = System.Drawing.Color.Black;
chart1.Series.Clear();
chart1.Series.Add(BoxPlotSeries);
// Add data to Box Plot Source series.
string datastr = "";
for (int jj = 0; jj < 9; jj++)
{
chart1.Series.Add(series3[jj]);
chart1.Series.Add(DataSeries[jj]);
chart1.Series[DataSeries[jj].Name].Points.DataBindY(send_comm[jj].yValues);
if (jj > 0)
{
datastr = datastr + ";" + DataSeries[jj].Name;
}
else
{
datastr = DataSeries[jj].Name;
}
}
chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart1.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Set whiskers 15th percentile.
//chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";// 2015.02.04 denny
// Show/Hide Average line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart1.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart1.Series["BoxPlotSeries"]["PointWidth"] = "0.50";//"0.25"; 2015.02.02 denny
chart1.Series["BoxPlotSeries"].XValueMember = "day of week";
for (int jj = 0; jj < 9; jj++)
{
ChartArea3.AxisX.CustomLabels.Add(0, 2 * (jj + 1), alu_tp.timgp[jj].time_on + "-" + alu_tp.timgp[jj].time_off); // 2015.01.30 denny
}
ChartArea3.AxisX.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
ChartArea3.AxisY.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
StripLine s01;
if (alu_tp.main_1.TargetMaxOptionp.ToString().Length > 0 || alu_tp.main_1.TargetMinOptionp.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(248, 199, 213);
s01.IntervalOffset = 0;
s01.StripWidth = 700;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
s01 = new StripLine();
s01.BackColor = Color.FromArgb(245, 250, 189);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOptionp);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOptionp) - s01.IntervalOffset;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
}
if (alu_tp.main_1.TargetMaxOption.ToString().Length > 0 || alu_tp.main_1.TargetMinOption.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(190, 251, 210);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOption);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOption) - s01.IntervalOffset;
// chart1.ChartAreas["ChartArea1"].AxisY.StripLines.Add(s01);
ChartArea3.AxisY.StripLines.Add(s01);
}
for (int jj = 0; jj < 9; jj++)
{
chart1.Series[DataSeries[jj].Name].Enabled = false;
}
}
private void loadData()
{
comm_list[] send_comm = new comm_list[6];
Series[] DataSeries = new Series[6];
Series[] DataSeries2 = new Series[6];
Series[] series3 = new Series[6];
Series[] series4 = new Series[6];
DataPoint[] dataPoint1_1 = new DataPoint[6];
DataPoint[] dataPoint2_1 = new DataPoint[6];
DataPoint[] dataPoint3_1 = new DataPoint[6];
DataPoint[] dataPoint4_1 = new DataPoint[6];
DataPoint[] dataPoint5_1 = new DataPoint[6];
DataPoint[] dataPoint6_1 = new DataPoint[6];
DataPoint[] dataPoint7_1 = new DataPoint[6];
DataPoint[] dataPoint8_1 = new DataPoint[6];
StripLine[] s02 = new StripLine[6];
Series BoxPlotSeries = new Series();
Series[] BoxPlotSeries2 = new Series[6];
//Series BoxPlotSeries3 = new Series();
//Series BoxPlotSeries4 = new Series();
//Series BoxPlotSeries5 = new Series();
//Series BoxPlotSeries6 = new Series();
//Series BoxPlotSeries7 = new Series();
ChartArea[] chart2_3 = new ChartArea[6];
ChartArea[] chart2_2 = new ChartArea[6];
System.Data.DataView dv, dv1;
chart1.ChartAreas.Clear();
chart2.ChartAreas.Clear();
chart3.ChartAreas.Clear();
chart4.ChartAreas.Clear();
chart5.ChartAreas.Clear();
chart6.ChartAreas.Clear();
chart7.ChartAreas.Clear();
chart1.Series.Clear();
chart2.Series.Clear();
chart3.Series.Clear();
chart4.Series.Clear();
chart5.Series.Clear();
chart6.Series.Clear();
chart7.Series.Clear();
//dv = MainModule.AccessDatabasesel("SELECT format(gl.TestTime, 'YYYY-MM-DD') AS TestT, MAX(iif(isnull(a.GD0), 0, CDBL(a.GD0))) AS Expr1, MAX(iif(isnull(a_1.GD1), 0, CDBL(a_1.GD1))) AS Expr2, " +
// " MAX(iif(isnull(a_2.GD2), 0, CDBL(a_2.GD2))) AS Expr3, MAX(iif(isnull(a_3.GD3), 0, CDBL(a_3.GD3))) AS Expr4, MAX(iif(isnull(a_4.GD4), 0, CDBL(a_4.GD4))) " +
// " AS Expr5, MAX(iif(isnull(a_5.GD5), 0, CDBL(a_5.GD5))) AS Expr6, MAX(iif(isnull(a_6.GD6), 0, CDBL(a_6.GD6))) AS Expr7, MAX(iif(isnull(a_7.GD7), " +
// " 0, CDBL(a_7.GD7))) AS Expr8, MAX(iif(isnull(a_8.GD8), 0, CDBL(a_8.GD8))) " +
// " AS Expr9 FROM (((((((((glucose gl LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD0, format(TestTime, 'YYYY-MM-DD') AS TT0 FROM glucose gl_1 " +
// " WHERE (TIME_IDX = 1)) a ON a.TT0 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD1, format(TestTime, 'YYYY-MM-DD') AS TT1 FROM glucose gl_2 " +
// " WHERE (TIME_IDX = 2)) a_1 ON a_1.TT1 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD2, format(TestTime, 'YYYY-MM-DD') AS TT2 FROM glucose gl_3 " +
// " WHERE (TIME_IDX = 3)) a_2 ON a_2.TT2 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD3, format(TestTime, 'YYYY-MM-DD') AS TT3 FROM glucose gl_4 " +
// " WHERE (TIME_IDX = 4)) a_3 ON a_3.TT3 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD4, format(TestTime, 'YYYY-MM-DD') AS TT4 FROM glucose gl_5 " +
// " WHERE (TIME_IDX = 5)) a_4 ON a_4.TT4 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD5, format(TestTime, 'YYYY-MM-DD') AS TT5 FROM glucose gl_6 " +
// " WHERE (TIME_IDX = 6)) a_5 ON a_5.TT5 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD6, format(TestTime, 'YYYY-MM-DD') AS TT6 FROM glucose gl_7 " +
// " WHERE (TIME_IDX = 7)) a_6 ON a_6.TT6 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN (SELECT GlucoseData AS GD7, format(TestTime, 'YYYY-MM-DD') " +
// " AS TT7 FROM glucose gl_8 WHERE (TIME_IDX = 8)) a_7 ON a_7.TT7 = format(gl.TestTime, 'YYYY-MM-DD')) LEFT OUTER JOIN " +
// " (SELECT GlucoseData AS GD8, format(TestTime, 'YYYY-MM-DD') AS TT8 FROM glucose gl_9 " +
// " WHERE (TIME_IDX = 9)) a_8 ON a_8.TT8 = format(gl.TestTime, 'YYYY-MM-DD')) " +
// " GROUP BY format(gl.TestTime, 'YYYY-MM-DD') " +
// " ORDER BY format(gl.TestTime, 'YYYY-MM-DD') DESC ");
dv = MainModule.SetGlucoseToTimeSet();
dv1 = MainModule.AccessDatabasesel("SELECT format(TestTime, 'YYYY-MM-DD') AS TestT, GlucoseData,m_Event,time_IDX FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC");
int TTT1 = dv1.Count;
int[] count1 = new int[6];
for (int ii = 0; ii < 6; ii++)
{
DataSeries[ii] = new Series();
DataSeries2[ii] = new Series();
series3[ii] = new Series();
series4[ii] = new Series();
s02[ii] = new StripLine();
send_comm[ii] = new comm_list();
count1[ii] = 0;
BoxPlotSeries2[ii] = new Series();
chart2_3[ii] = new ChartArea();
chart2_2[ii] = new ChartArea();
}
for (int jj = 0; jj < dv.Count; jj++)
{
for (int ii = 0; ii < 6; ii++)
{
string eestr = "Expr" + (ii + 1);
// send_comm[ii].yValues[count1[ii]] = rand.Next(45, 95);
if (Convert.ToInt16(dv[jj].Row[eestr]) == 0)
{
}
else
{
count1[ii]++;
}
dv1.RowFilter = "TestT= '" + Convert.ToString(dv[jj].Row[0]) + "' and time_IDX='" + Convert.ToString(ii + 1) + "' and GlucoseData <> '" + Convert.ToInt16(dv[jj].Row[eestr]) + "' and GlucoseData <> '0'";
if (dv1.Count > 0)
{
for (int t1 = 0; t1 < dv1.Count; t1++)
{
count1[ii]++;
}
}
}
}
for (int jj = 0; jj < 6; jj++)
{
send_comm[jj].yValues = new double[count1[jj]];
}
int[] count2 = new int[6];
for (int jj = 0; jj < dv.Count; jj++)
{
for (int ii = 0; ii < 6; ii++)
{
string eestr = "Expr" + (ii + 1);
// send_comm[ii].yValues[count1[ii]] = rand.Next(45, 95);
if (Convert.ToInt16(dv[jj].Row[eestr]) == 0)
{
}
else
{
send_comm[ii].yValues[count2[ii]] = Convert.ToInt16(dv[jj].Row[eestr]);
count2[ii]++;
}
// send_comm[jj].yValues[ii] = rand.Next(45, 95);
dv1.RowFilter = "TestT= '" + Convert.ToString(dv[jj].Row[0]) + "' and time_IDX='" + Convert.ToString(ii + 1) + "' and GlucoseData <> '" + Convert.ToInt16(dv[jj].Row[eestr]) + "' and GlucoseData <> '0'";
if (dv1.Count > 0)
{
for (int t1 = 0; t1 < dv1.Count; t1++)
{
send_comm[ii].yValues[count2[ii]] = Convert.ToUInt16(dv1[t1].Row["GlucoseData"]);
count2[ii]++;
}
}
}
}
ChartArea ChartArea3 = new ChartArea();
ChartArea ChartArea2 = new ChartArea();
//ChartArea chart2_3 = new ChartArea();
//ChartArea chart2_2 = new ChartArea();
//Add the charting areas to the chart
chart1.ChartAreas.Add(ChartArea2);
chart1.ChartAreas.Add(ChartArea3);
ChartArea2.Name = "Data Chart Area";
ChartArea3.Name = "Box Plot Area";
//ChartArea3.AlignWithChartArea = "Data Chart Area"
ChartArea2.Position.X = 2;
ChartArea2.Position.Y = 70;
// ChartArea2.AxisX.ScaleBreakStyle.Spacing = .5;
// ChartArea3.AxisX.ScaleBreakStyle.StartFromZero = StartFromZero.No
//ChartArea2.AxisX.Minimum = 0.5;
// ChartArea2.AxisX.Maximum = 7;
ChartArea3.Position.X = 2;
ChartArea3.Position.Y = 3;
// ChartArea2.Position.Height = 92f;
// ChartArea2.Position.Width = 90f;
// ChartArea3.Position.Height = 92f;
// ChartArea3.Position.Width = 90f;
// ChartArea2.BackImageTransparentColor = System.Drawing.Color.White;
ChartArea3.Position.Height = 92f;
ChartArea3.Position.Width = 90f;
ChartArea3.AxisX.ScaleBreakStyle.Spacing = .5;
// ChartArea3.AxisX.ScaleBreakStyle.StartFromZero = StartFromZero.No
ChartArea3.AxisX.Minimum = 0.5;
ChartArea3.AxisX.Maximum = 7;
// BackGradientStyle = "VerticalCenter"
// ChartArea3.ShadowColor = Drawing.Color.Cyan
// ChartArea3.BackSecondaryColor = Drawing.Color.FromArgb(128, 255, 255)
// ChartArea3.BorderColor = Drawing.Color.Black
for (int ii = 0; ii < 6; ii++)
{
if (ii == 0)
{
chart2.ChartAreas.Add(chart2_2[ii]); chart2.ChartAreas.Add(chart2_3[ii]);
}
else if (ii == 1)
{
chart3.ChartAreas.Add(chart2_2[ii]); chart3.ChartAreas.Add(chart2_3[ii]);
}
else if (ii == 2)
{
chart4.ChartAreas.Add(chart2_2[ii]); chart4.ChartAreas.Add(chart2_3[ii]);
}
else if (ii == 3)
{
chart5.ChartAreas.Add(chart2_2[ii]); chart5.ChartAreas.Add(chart2_3[ii]);
}
else if (ii == 4)
{
chart6.ChartAreas.Add(chart2_2[ii]); chart6.ChartAreas.Add(chart2_3[ii]);
}
else if (ii == 5)
{
chart7.ChartAreas.Add(chart2_2[ii]); chart7.ChartAreas.Add(chart2_3[ii]);
}
// chart2.ChartAreas.Add(chart2_2);
// chart2.ChartAreas.Add(chart2_3);
chart2_2[ii].Name = "Data Chart Area" + (ii + 1);
chart2_3[ii].Name = "Box Plot Area" + (ii + 1);
chart2_2[ii].Position.X = 2;
chart2_2[ii].Position.Y = 4;
chart2_3[ii].Position.X = 60;
chart2_3[ii].Position.Y = 4;
chart2_2[ii].Position.Height = 92f;
chart2_2[ii].Position.Width = 55f;
chart2_3[ii].Position.Height = 92f;
chart2_3[ii].Position.Width = 30f;
chart2_3[ii].AxisX.ScaleBreakStyle.Spacing = .5;
chart2_3[ii].AxisX.Minimum = 0.5;
chart2_3[ii].AxisX.Maximum = 1.5;
chart2_2[ii].AxisY.Maximum = 600;
chart2_3[ii].AxisY.Maximum = 600;
}
for (int jj = 0; jj < 6; jj++)
{
series3[jj].Name = "BoxPlotLabels" + jj;
series3[jj].ChartArea = "Box Plot Area";
series3[jj].ChartType = SeriesChartType.Point;
series3[jj].CustomProperties = "LabelStyle=Right";
series3[jj].Font = new System.Drawing.Font("Microsoft Sans Serif", 7F);
series3[jj].Legend = "Default";
series4[jj].Name = "BoxPlotLabel" + jj;
series4[jj].ChartArea = "Box Plot Area" + (jj + 1);
series4[jj].ChartType = SeriesChartType.Point;
series4[jj].CustomProperties = "LabelStyle=Right";
series4[jj].Font = new System.Drawing.Font("Microsoft Sans Serif", 7F);
series4[jj].Legend = "Default";
}
for (int jj = 0; jj < 6; jj++)
{
DataPoint dataPoint1 = new DataPoint(1 + jj, 0);
DataPoint dataPoint2 = new DataPoint(1 + jj, 0);
DataPoint dataPoint3 = new DataPoint(1 + jj, 0);
DataPoint dataPoint4 = new DataPoint(1 + jj, 0);
DataPoint dataPoint5 = new DataPoint(1 + jj, 0);
DataPoint dataPoint6 = new DataPoint(1 + jj, 0);
DataPoint dataPoint7 = new DataPoint(1 + jj, 0);
DataPoint dataPoint8 = new DataPoint(1 + jj, 0);
dataPoint1.Color = System.Drawing.Color.Transparent;
dataPoint2.Color = System.Drawing.Color.Transparent;
dataPoint3.Color = System.Drawing.Color.Transparent;
dataPoint4.Color = System.Drawing.Color.Transparent;
dataPoint5.Color = System.Drawing.Color.Transparent;
dataPoint6.Color = System.Drawing.Color.Transparent;
dataPoint7.Color = System.Drawing.Color.Transparent;
dataPoint8.Color = System.Drawing.Color.Transparent;
series3[jj].Points.Add(dataPoint1);
series3[jj].Points.Add(dataPoint2);
series3[jj].Points.Add(dataPoint3);
series3[jj].Points.Add(dataPoint4);
series3[jj].Points.Add(dataPoint5);
series3[jj].Points.Add(dataPoint6);
series3[jj].Points.Add(dataPoint7);
series3[jj].Points.Add(dataPoint8);
series3[jj].SmartLabelStyle.Enabled = false;
dataPoint1_1[jj] = new DataPoint(1.1, 0);//位置1,0
dataPoint2_1[jj] = new DataPoint(1.1, 0);
dataPoint3_1[jj] = new DataPoint(1.1, 0);
dataPoint4_1[jj] = new DataPoint(1.1, 0);
dataPoint5_1[jj] = new DataPoint(1.1, 0);
dataPoint6_1[jj] = new DataPoint(1.1, 0);
dataPoint7_1[jj] = new DataPoint(1.1, 0);
dataPoint8_1[jj] = new DataPoint(1.1, 0);
dataPoint1_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint2_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint3_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint4_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint5_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint6_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint7_1[jj].Color = System.Drawing.Color.Transparent;
dataPoint8_1[jj].Color = System.Drawing.Color.Transparent;
series4[jj].Points.Add(dataPoint1_1[jj]);
series4[jj].Points.Add(dataPoint2_1[jj]);
series4[jj].Points.Add(dataPoint3_1[jj]);
series4[jj].Points.Add(dataPoint4_1[jj]);
series4[jj].Points.Add(dataPoint5_1[jj]);
series4[jj].Points.Add(dataPoint6_1[jj]);
series4[jj].Points.Add(dataPoint7_1[jj]);
series4[jj].Points.Add(dataPoint8_1[jj]);
series4[jj].SmartLabelStyle.Enabled = false;
}
for (int jj = 0; jj < 6; jj++)
{
DataSeries[jj].Name = "DataSeries" + jj;
DataSeries[jj].ChartType = SeriesChartType.Point;
DataSeries[jj].ChartArea = "Data Chart Area";
// DataSeries[jj].ChartArea = "Box Plot Area";
//// DataSeries[jj].IsValueShownAsLabel = false;
// DataSeries[jj].IsVisibleInLegend = false;
DataSeries2[jj].Name = "DataSeries" + jj;
DataSeries2[jj].ChartType = SeriesChartType.Point;
DataSeries2[jj].ChartArea = "Data Chart Area" + (jj + 1);
}
BoxPlotSeries.Name = "BoxPlotSeries";
BoxPlotSeries.ChartType = SeriesChartType.BoxPlot;
BoxPlotSeries.ChartArea = "Box Plot Area";
// BoxPlotSeries.IsValueShownAsLabel = true;
BoxPlotSeries.IsVisibleInLegend = true;
BoxPlotSeries.BackGradientStyle = GradientStyle.VerticalCenter;
BoxPlotSeries.Color = System.Drawing.Color.Cyan;
BoxPlotSeries.BackSecondaryColor = System.Drawing.Color.FromArgb(128, 255, 255);
BoxPlotSeries.BorderColor = System.Drawing.Color.Black;
chart1.Series.Add(BoxPlotSeries);
// Add data to Box Plot Source series.
string datastr = "";
for (int jj = 0; jj < 6; jj++)
{
chart1.Series.Add(series3[jj]);
chart1.Series.Add(DataSeries[jj]);
chart1.Series[DataSeries[jj].Name].Points.DataBindY(send_comm[jj].yValues);
if (jj > 0)
{
datastr = datastr + ";" + DataSeries[jj].Name;
}
else
{
datastr = DataSeries[jj].Name;
}
}
chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart1.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Set whiskers 15th percentile.
chart1.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart1.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart1.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart1.Series["BoxPlotSeries"]["PointWidth"] = "0.25";
chart1.Series["BoxPlotSeries"].XValueMember = "day of week";
// ChartArea3.AxisX.CustomLabels.Add(0, 2, "Before breakfast");
// ChartArea3.AxisX.CustomLabels.Add(0, 4, "After breakfast");
// ChartArea3.AxisX.CustomLabels.Add(0, 6, "Before lunch");
// ChartArea3.AxisX.CustomLabels.Add(0, 8, "After lunch");
// ChartArea3.AxisX.CustomLabels.Add(0, 10, "Before dinner");
// ChartArea3.AxisX.CustomLabels.Add(0, 12, "After dinner");
ChartArea3.AxisX.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
ChartArea3.AxisY.MajorGrid.LineDashStyle = ChartDashStyle.Dash;
// alu_tp.main_1.TargetMaxOption = int.Parse(alu_tp.main_1.DataTargetMax[i]);
// alu_tp.main_1.TargetMinOption = int.Parse(alu_tp.main_1.DataTargetMin[i]);
// alu_tp.main_1.TargetMaxOptionp = int.Parse(alu_tp.main_1.DataTargetMaxp[i]);
// alu_tp.main_1.TargetMinOptionp = int.Parse(alu_tp.main_1.DataTargetMinp[i]);
StripLine s01;
if (alu_tp.main_1.TargetMaxOptionp.ToString().Length > 0 || alu_tp.main_1.TargetMinOptionp.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(248, 199, 213);
s01.IntervalOffset = 0;
s01.StripWidth = 600;
ChartArea3.AxisY.StripLines.Add(s01);
for (int jj = 0; jj < 6; jj++)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(248, 199, 213);
s01.IntervalOffset = 0;
s01.StripWidth = 600;
s02[jj] = new StripLine();
s02[jj].BackColor = Color.FromArgb(248, 199, 213);
s02[jj].IntervalOffset = 0;
s02[jj].StripWidth = 600;
chart2_2[jj].AxisY.StripLines.Add(s02[jj]);
chart2_3[jj].AxisY.StripLines.Add(s01);
}
s01 = new StripLine();
s01.BackColor = Color.FromArgb(245, 250, 189);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOptionp);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOptionp) - s01.IntervalOffset;
ChartArea3.AxisY.StripLines.Add(s01);
for (int jj = 0; jj < 6; jj++)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(245, 250, 189);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOptionp);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOptionp) - s01.IntervalOffset;
s02[jj] = new StripLine();
s02[jj].BackColor = Color.FromArgb(245, 250, 189);
s02[jj].IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOptionp);
s02[jj].StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOptionp) - s02[jj].IntervalOffset;
chart2_2[jj].AxisY.StripLines.Add(s02[jj]);
chart2_3[jj].AxisY.StripLines.Add(s01);
}
}
if (alu_tp.main_1.TargetMaxOption.ToString().Length > 0 || alu_tp.main_1.TargetMinOption.ToString().Length > 0)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(190, 251, 210);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOption);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOption) - s01.IntervalOffset;
ChartArea3.AxisY.StripLines.Add(s01);
for (int jj = 0; jj < 6; jj++)
{
s01 = new StripLine();
s01.BackColor = Color.FromArgb(190, 251, 210);
s01.IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOption);
s01.StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOption) - s01.IntervalOffset;
s02[jj] = new StripLine();
s02[jj].BackColor = Color.FromArgb(190, 251, 210);
s02[jj].IntervalOffset = Convert.ToInt16(alu_tp.main_1.TargetMinOption);
s02[jj].StripWidth = Convert.ToInt16(alu_tp.main_1.TargetMaxOption) - s02[jj].IntervalOffset;
chart2_2[jj].AxisY.StripLines.Add(s02[jj]);
chart2_3[jj].AxisY.StripLines.Add(s01);
}
}
for (int jj = 0; jj < 6; jj++)
{
chart1.Series[DataSeries[jj].Name].Enabled = false;
}
////////////////////////
for (int jj = 0; jj < 6; jj++)
{
BoxPlotSeries2[jj].Name = "BoxPlotSeries";
BoxPlotSeries2[jj].ChartType = SeriesChartType.BoxPlot;
BoxPlotSeries2[jj].ChartArea = "Box Plot Area" + (jj + 1);
// BoxPlotSeries.IsValueShownAsLabel = true;
BoxPlotSeries2[jj].IsVisibleInLegend = true;
BoxPlotSeries2[jj].BackGradientStyle = GradientStyle.VerticalCenter;
BoxPlotSeries2[jj].Color = System.Drawing.Color.Cyan;
BoxPlotSeries2[jj].BackSecondaryColor = System.Drawing.Color.FromArgb(128, 255, 255);
BoxPlotSeries2[jj].BorderColor = System.Drawing.Color.Black;
if (jj == 0)
{
chart2.Series.Add(BoxPlotSeries2[jj]);
}
else if (jj == 1)
{
chart3.Series.Add(BoxPlotSeries2[jj]);
}
else if (jj == 2)
{
chart4.Series.Add(BoxPlotSeries2[jj]);
}
else if (jj == 3)
{
chart5.Series.Add(BoxPlotSeries2[jj]);
}
else if (jj == 4)
{
chart6.Series.Add(BoxPlotSeries2[jj]);
}
else if (jj == 5)
{
chart7.Series.Add(BoxPlotSeries2[jj]);
}
}
datastr = "";
for (int jj = 0; jj < 1; jj++)
{
chart2.Series.Add(series4[jj]);
chart2.Series.Add(DataSeries2[jj]);
chart2.Series[DataSeries2[jj].Name].Points.DataBindY(send_comm[jj].yValues);
datastr = DataSeries2[jj].Name;
}
chart2.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart2.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Set whiskers 15th percentile.
chart2.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart2.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart2.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart2.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart2.Series["BoxPlotSeries"]["PointWidth"] = "0.15";
chart2.Series["BoxPlotSeries"].XValueMember = "day of week";
datastr = "";
for (int jj = 1; jj < 2; jj++)
{
chart3.Series.Add(series4[jj]);
chart3.Series.Add(DataSeries2[jj]);
chart3.Series[DataSeries2[jj].Name].Points.DataBindY(send_comm[jj].yValues);
datastr = DataSeries2[jj].Name;
}
chart3.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart3.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Se3t whiskers 15th percentile.
chart3.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart3.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart3.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart3.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart3.Series["BoxPlotSeries"]["PointWidth"] = "0.15";
chart3.Series["BoxPlotSeries"].XValueMember = "day of week";
datastr = "";
for (int jj = 2; jj < 3; jj++)
{
chart4.Series.Add(series4[jj]);
chart4.Series.Add(DataSeries2[jj]);
chart4.Series[DataSeries2[jj].Name].Points.DataBindY(send_comm[jj].yValues);
datastr = DataSeries2[jj].Name;
}
chart4.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart4.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Se3t whiskers 15th percentile.
chart4.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart4.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart4.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart4.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart4.Series["BoxPlotSeries"]["PointWidth"] = "0.15";
chart4.Series["BoxPlotSeries"].XValueMember = "day of week";
datastr = "";
for (int jj = 3; jj < 4; jj++)
{
chart5.Series.Add(series4[jj]);
chart5.Series.Add(DataSeries2[jj]);
chart5.Series[DataSeries2[jj].Name].Points.DataBindY(send_comm[jj].yValues);
datastr = DataSeries2[jj].Name;
}
chart5.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart5.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Se3t whiskers 15th percentile.
chart5.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart5.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart5.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart5.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart5.Series["BoxPlotSeries"]["PointWidth"] = "0.15";
chart5.Series["BoxPlotSeries"].XValueMember = "day of week";
datastr = "";
for (int jj = 4; jj < 5; jj++)
{
chart6.Series.Add(series4[jj]);
chart6.Series.Add(DataSeries2[jj]);
chart6.Series[DataSeries2[jj].Name].Points.DataBindY(send_comm[jj].yValues);
datastr = DataSeries2[jj].Name;
}
chart6.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart6.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Se3t whiskers 15th percentile.
chart6.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart6.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart6.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart6.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart6.Series["BoxPlotSeries"]["PointWidth"] = "0.15";
chart6.Series["BoxPlotSeries"].XValueMember = "day of week";
datastr = "";
for (int jj = 5; jj < 6; jj++)
{
chart7.Series.Add(series4[jj]);
chart7.Series.Add(DataSeries2[jj]);
chart7.Series[DataSeries2[jj].Name].Points.DataBindY(send_comm[jj].yValues);
datastr = DataSeries2[jj].Name;
}
chart7.Series["BoxPlotSeries"]["BoxPlotWhiskerPercentile"] = "0";
chart7.Series["BoxPlotSeries"]["BoxPlotSeries"] = datastr;
// Se7t whiskers 15th percentile.
chart7.Series["BoxPlotSeries"]["BoxPlotWhiskerPerc entile"] = "10";
// Show/Hide Average line.
chart7.Series["BoxPlotSeries"]["BoxPlotShowAverage "] = "true";
// Show/Hide Median line.
chart7.Series["BoxPlotSeries"]["BoxPlotShowMedian"] = "true";
// Show/Hide Unusual points.
chart7.Series["BoxPlotSeries"]["BoxPlotShowUnusual Values"] = "true";
// chart1.Series("BoxPlotSeries")("PointWidth") = "0.25"
chart7.Series["BoxPlotSeries"]["PointWidth"] = "0.15";
chart7.Series["BoxPlotSeries"].XValueMember = "day of week";
chart2_3[0].AxisX.CustomLabels.Add(0, 2, "Before breakfast");
chart2_3[1].AxisX.CustomLabels.Add(0, 2, "After breakfast");
chart2_3[2].AxisX.CustomLabels.Add(0, 2, "Before lunch");
chart2_3[3].AxisX.CustomLabels.Add(0, 2, "After lunch");
chart2_3[4].AxisX.CustomLabels.Add(0, 2, "Before dinner");
chart2_3[5].AxisX.CustomLabels.Add(0, 2, "After dinner");
////////////////////////////
}
