private void loadData() { DataView dv1 = new DataView(); dv1 = MainModule.AccessDatabasesel("SELECT '' as snno,glucosedata,m_event,TestTime FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' order by TestTime"); DataTable dt1 = new DataTable(); dt1 = dv1.Table; for (int i = 0; i < dt1.Rows.Count; i++) { dt1.Rows[i].BeginEdit(); dt1.Rows[i]["snno"] = i + 1; dt1.Rows[i].EndEdit(); dt1.AcceptChanges(); } dataGridViewMenu.DataSource = dt1; /*if (alu_tp.main_1.Total >= 1 && alu_tp.main_1.MDataDA[1] != 0) * { * for (int i = 1; i <= alu_tp.main_1.Total; i++) * { * DataGridViewRowCollection rows = dataGridViewMenu.Rows; * rows.Add(new Object[] { i, alu_tp.main_1.MDataGL[i], alu_tp.main_1.MDataACPC[i], alu_tp.main_1.MDataYRDA[i] }); * //rows.Add(new Object[] { "綠茶", 25, 55, 789 }); * } * }*/ }
public static void readOldData() { System.Data.DataView dv0; dv0 = MainModule.AccessDatabasesel("SELECT MeterID,TestTime,GlucoseData,m_Event,format(TestTime, 'YYYY') AS yy ,format(TestTime, 'MM') AS mm ,format(TestTime, 'DD') AS dd ,format(TestTime, 'HH') AS hh,format(TestTime, 'mm') AS mi,format(TestTime, 'ss') AS se FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' order by TestTime"); if (dv0 != null) { if (dv0.Count > 0) { for (int s = 1; s <= dv0.Count; s++) { alu_tp.main_1.DataGL[s] = Convert.ToInt16(dv0[s - 1].Row["GlucoseData"].ToString()); alu_tp.main_1.DataMO[s] = Convert.ToInt16(dv0[s - 1].Row["mm"].ToString()); alu_tp.main_1.DataDA[s] = Convert.ToInt16(dv0[s - 1].Row["dd"].ToString()); alu_tp.main_1.DataHR[s] = Convert.ToInt16(dv0[s - 1].Row["hh"].ToString()); alu_tp.main_1.DataMI[s] = Convert.ToInt16(dv0[s - 1].Row["mi"].ToString()); alu_tp.main_1.DataYR[s] = Convert.ToInt16(dv0[s - 1].Row["yy"].ToString()); alu_tp.main_1.DataSE[s] = Convert.ToInt16(dv0[s - 1].Row["se"].ToString()); alu_tp.main_1.DataACPC[s] = dv0[s - 1].Row["m_Event"].ToString(); alu_tp.main_1.MDataGL[s] = Convert.ToInt16(dv0[s - 1].Row["GlucoseData"].ToString()); alu_tp.main_1.MDataMO[s] = Convert.ToInt16(dv0[s - 1].Row["mm"].ToString()); alu_tp.main_1.MDataDA[s] = Convert.ToInt16(dv0[s - 1].Row["dd"].ToString()); alu_tp.main_1.MDataHR[s] = Convert.ToInt16(dv0[s - 1].Row["hh"].ToString()); alu_tp.main_1.MDataMI[s] = Convert.ToInt16(dv0[s - 1].Row["mi"].ToString()); alu_tp.main_1.MDataYR[s] = Convert.ToInt16(dv0[s - 1].Row["yy"].ToString()); alu_tp.main_1.MDataSE[s] = Convert.ToInt16(dv0[s - 1].Row["se"].ToString()); alu_tp.main_1.MDataACPC[s] = dv0[s - 1].Row["m_Event"].ToString(); alu_tp.main_1.MDataYRDA[s] = dv0[s - 1].Row["TestTime"].ToString(); } } } alu_tp.main_1.Total = dv0.Count; }
private void loadData() { DataView dv1 = null; dv1 = MainModule.AccessDatabasesel("SELECT idx,mid,id,Max1,Min1,Maxp,Minp FROM HmdRegister order by id,mid"); dataGridView1.DataSource = dv1; }
private void loginForm_Load(object sender, EventArgs e) { InitControls(); //this.skinEngine1.SkinFile = @System.AppDomain.CurrentDomain.BaseDirectory.Replace('\\', '/') + "Skins/Calmness.ssk"; try { MainModule.OpenAccessDatabase("HMDgms.mdb", "HmdRegister"); MainModule.get_time_set(); } catch (Exception err) { } // string FILE_NAME = alu_tp.main_1.MAIN_PATH + "\\HMDregister.txt"; System.Data.DataView dv1; dv1 = MainModule.AccessDatabasesel("SELECT UserNo FROM ho_user "); comboBox1.Items.Add("guest"); if (dv1.Count > 0) { for (int i = 0; i < dv1.Count; i++) { comboBox1.Items.Add(dv1[i].Row["UserNo"]); } } timerLoad.Enabled = true; }
//public static DataView AccessDatabasesel(string select_str) //{ // System.Data.DataView dv; // try // { // alu_tp.main_1.lo_con = new AccessDataSource(alu_tp.main_1.accdb_PATH, select_str); // dv = (System.Data.DataView)alu_tp.main_1.lo_con.Select(new DataSourceSelectArguments()); // // alu_tp.main_1.serialPort1.PortName = dv[0].Row["RS-232port"].ToString(); // } // catch (Exception E) // { // return null; // } // return dv; //} public static DataView GetMeteridWithUser() { DataView dv1 = new DataView(); dv1 = MainModule.AccessDatabasesel("SELECT mid,mid&'[' &id&']' as miduid FROM HmdRegister order by mid desc,id asc"); return(dv1); }
public static void get_time_set() { System.Data.DataView dv1; dv1 = MainModule.AccessDatabasesel("SELECT * FROM time_set where user_idx=0 order by idx"); alu_tp.timgp = new time_gp[dv1.Count]; int t1; for (t1 = 0; t1 < dv1.Count; t1++) { alu_tp.timgp[t1] = new time_gp(); alu_tp.timgp[t1].time_name = dv1[t1].Row["time_name"].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(); alu_tp.timgp[t1].on_off = dv1[t1].Row["on_off"].ToString(); alu_tp.timgp[t1].time_name = dv1[t1].Row["time_name"].ToString(); } // return "OK"; }
private void loadData() { //* 2015.01.21 denny this.dataGridView1.Columns[0].HeaderText = "Date"; //DataView dv = MainModule.SetGlucoseToTimeSet(); 2015.01.21 denny DataView dv = MainModule.AccessDatabasesel("SELECT * FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC"); //this.dataGridView1.DataSource = dv; // 2015.01.21 denny //*/ //*/ 2015.01.21 denny if (alu_tp.timgp.Length > 0) { for (int jj = 0; jj < alu_tp.timgp.Length; jj++) { int colindex; //Label LB1 = new Label();// 2015.01.22 denny //LB1.Text = alu_tp.timgp[jj].time_on + "\n" + alu_tp.timgp[jj].time_off;// 2015.01.22 denny colindex = jj + 2; //((GridView)sender).HeaderRow.Cells[2].Text = LB1.Text; //((GridView)sender).HeaderRow.Cells[jj + 2].Controls.Add(LB1); this.dataGridView1.ColumnCount = colindex + 1; this.dataGridView1.Columns[colindex].HeaderText = alu_tp.timgp[jj].time_on + "\n" + alu_tp.timgp[jj].time_off;// 2015.01.22 denny // e.Row.Cells.Item(17).Controls.Add(LB1) } } //*/ this.dataGridView1.Location = new Point(this.dataGridView1.Location.X, 25); for (int rowindex = 0; rowindex < dv.Count; rowindex++) { this.dataGridView1.RowCount = rowindex + 1; this.dataGridView1.Rows[rowindex].Cells[0].Value = Convert.ToDateTime(dv.Table.Rows[rowindex].ItemArray[dv.Table.Columns.IndexOf("TestTime")]).DayOfWeek; this.dataGridView1.Rows[rowindex].Cells[1].Value = DateTime.Parse(dv.Table.Rows[rowindex].ItemArray[dv.Table.Columns.IndexOf("TestTime")].ToString()).ToString("yyyy-MM-dd HH:mm:ss"); this.dataGridView1.Rows[rowindex].Cells[((int)dv.Table.Rows[rowindex].ItemArray[dv.Table.Columns.IndexOf("TIME_IDX")] - 1) + 2].Value = (int)dv.Table.Rows[rowindex].ItemArray[dv.Table.Columns.IndexOf("GlucoseData")]; } }
public static void SettingInitUserData() { System.Data.DataView dv1; dv1 = MainModule.AccessDatabasesel("SELECT * FROM HmdRegister where mid='" + alu_tp.main_1.MeterIDNo + "'"); if (dv1 != null) { if (dv1.Count > 0) { alu_tp.main_1.FileName = dv1[0].Row["idx"].ToString(); alu_tp.main_1.ReportName = dv1[0].Row["id"].ToString(); alu_tp.main_1.MeterIDNo = dv1[0].Row["mid"].ToString(); alu_tp.main_1.CPortOption = 1; alu_tp.main_1.serialPort1 = new SerialPort(); alu_tp.main_1.serialPort1.PortName = Convert.ToString(dv1[0].Row["RS_232"]); alu_tp.main_1.UnitOption = Convert.ToInt16(dv1[0].Row["Unit1"]); alu_tp.main_1.TimeOption = Convert.ToInt16(dv1[0].Row["Time1"]); alu_tp.main_1.TargetMaxOption = Convert.ToInt16(dv1[0].Row["Max1"]); alu_tp.main_1.TargetMinOption = Convert.ToInt16(dv1[0].Row["Min1"]); alu_tp.main_1.TargetMaxOptionp = Convert.ToInt16(dv1[0].Row["Maxp"]); alu_tp.main_1.TargetMinOptionp = Convert.ToInt16(dv1[0].Row["Minp"]); } } }
private void loadData() { System.Data.DataView dv; chart1.Series.Clear(); chart1.Series.Add(alu_tp.main_1.rm_txt.GetString("ChartNormal")); chart1.Series.Add(alu_tp.main_1.rm_txt.GetString("OutTheNormal")); chart1.Series.Add(alu_tp.main_1.rm_txt.GetString("OutTheLimit")); chart1.Series[alu_tp.main_1.rm_txt.GetString("ChartNormal")].ChartType = SeriesChartType.StackedColumn100; chart1.Series[alu_tp.main_1.rm_txt.GetString("OutTheNormal")].ChartType = SeriesChartType.StackedColumn100; chart1.Series[alu_tp.main_1.rm_txt.GetString("OutTheLimit")].ChartType = SeriesChartType.StackedColumn100; //dv = MainModule.SetGlucoseToTimeSet(); 2015.01.29 denny //DataView 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.29 denny dv = MainModule.AccessDatabasesel("SELECT * FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC"); // 2015.01.29 denny for (int jj = 0; jj < 9; jj++) { drange[jj] = new range1(); drange[jj].below = 0; drange[jj].within = 0; drange[jj].above = 0; } for (int data_count = 0; data_count < dv.Count; data_count++) { if ((int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("GlucoseData")] == 0) { } else if ((int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("GlucoseData")] < alu_tp.main_1.TargetMinOptionp) { drange[(int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("TIME_IDX")] - 1].below++; } else if ((int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("GlucoseData")] < alu_tp.main_1.TargetMinOption) { drange[(int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("TIME_IDX")] - 1].above++; } else if ((int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("GlucoseData")] > alu_tp.main_1.TargetMaxOptionp) { drange[(int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("TIME_IDX")] - 1].below++; } else if ((int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("GlucoseData")] > alu_tp.main_1.TargetMaxOption) { drange[(int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("TIME_IDX")] - 1].above++; } else { drange[(int)dv.Table.Rows[data_count].ItemArray[dv.Table.Columns.IndexOf("TIME_IDX")] - 1].within++; } } /*// 2015.01.29 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 if (Convert.ToInt16(dv[jj].Row[eestr]) < alu_tp.main_1.TargetMinOptionp) drange[ii].below++; * else if (Convert.ToInt16(dv[jj].Row[eestr]) < alu_tp.main_1.TargetMinOption) drange[ii].above++; * else if (Convert.ToInt16(dv[jj].Row[eestr]) > alu_tp.main_1.TargetMaxOptionp) drange[ii].below++; * else if (Convert.ToInt16(dv[jj].Row[eestr]) > alu_tp.main_1.TargetMaxOption) drange[ii].above++; * else drange[ii].within++; * * * 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++) * { * if (dv1[t1].Row["GlucoseData"].ToString().Length == 0) { } * else if (Convert.ToInt16(dv1[t1].Row["GlucoseData"]) < alu_tp.main_1.TargetMinOptionp) drange[ii].below++; * else if (Convert.ToInt16(dv1[t1].Row["GlucoseData"]) < alu_tp.main_1.TargetMinOption) drange[ii].above++; * else if (Convert.ToInt16(dv1[t1].Row["GlucoseData"]) > alu_tp.main_1.TargetMaxOptionp) drange[ii].below++; * else if (Convert.ToInt16(dv1[t1].Row["GlucoseData"]) > alu_tp.main_1.TargetMaxOption) drange[ii].above++; * else drange[ii].within++; * } * } * } * } *///2015.01.29 denny for (int jj = 0; jj < 9; jj++) { chart1.Series[alu_tp.main_1.rm_txt.GetString("OutTheLimit")].Points.AddY((double)drange[jj].below); chart1.Series[alu_tp.main_1.rm_txt.GetString("OutTheNormal")].Points.AddY((double)drange[jj].above); chart1.Series[alu_tp.main_1.rm_txt.GetString("ChartNormal")].Points.AddY((double)drange[jj].within); } for (int jj = 0; jj < 9; jj++) { this.chart1.ChartAreas["ChartArea1"].AxisX.CustomLabels.Add(0, 2 * (jj + 1), alu_tp.timgp[jj].time_on + "-" + alu_tp.timgp[jj].time_off); } chart1.Series[alu_tp.main_1.rm_txt.GetString("OutTheLimit")].IsValueShownAsLabel = true; chart1.Series[alu_tp.main_1.rm_txt.GetString("OutTheNormal")].IsValueShownAsLabel = true; chart1.Series[alu_tp.main_1.rm_txt.GetString("ChartNormal")].IsValueShownAsLabel = true; }
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 loginButton1_Click(object sender, EventArgs e) { // MessageBox.Show("1"); //string FileName; string CheckName = comboBox1.Text; string CheckPassword = TextPasswd.Text; // string FILE_NAME = alu_tp.main_1.MAIN_PATH + "\\HMDregister.txt"; System.Data.DataView dv1; if (CheckName == "guest") { alu_tp.main_1.FileName = "guest"; alu_tp.main_1.ReportName = alu_tp.main_1.FileName; TextPasswd.Text = ""; dv1 = MainModule.AccessDatabasesel("SELECT * FROM HmdRegister where id='" + CheckName + "'"); if (dv1.Count > 0) { alu_tp.main_1.FileName = dv1[0].Row["idx"].ToString(); alu_tp.main_1.CPortOption = 1; alu_tp.main_1.serialPort1.PortName = Convert.ToString(dv1[0].Row["RS_232"]); alu_tp.main_1.UnitOption = Convert.ToInt16(dv1[0].Row["Unit1"]); alu_tp.main_1.TimeOption = Convert.ToInt16(dv1[0].Row["Time1"]); alu_tp.main_1.TargetMaxOption = Convert.ToInt16(dv1[0].Row["Max1"]); alu_tp.main_1.TargetMinOption = Convert.ToInt16(dv1[0].Row["Min1"]); alu_tp.main_1.TargetMaxOptionp = Convert.ToInt16(dv1[0].Row["Maxp"]); alu_tp.main_1.TargetMinOptionp = Convert.ToInt16(dv1[0].Row["Minp"]); } else { alu_tp.main_1.serialPort1.PortName = "COM1"; alu_tp.main_1.UnitOption = 1; alu_tp.main_1.TimeOption = 1; alu_tp.main_1.TargetMaxOption = 180; alu_tp.main_1.TargetMinOption = 50; alu_tp.main_1.TargetMaxOptionp = 300; alu_tp.main_1.TargetMinOptionp = 30; } } else { if (CheckPassword == "") { MessageBox.Show("ID OR PASSWORD ERROR!!", "LOGIN ERROR", MessageBoxButtons.OK, MessageBoxIcon.Error); goto EndAndAgain; } dv1 = MainModule.AccessDatabasesel("SELECT * FROM HmdRegister where id='" + CheckName + "' and Passwd='" + CheckPassword + "'"); if (dv1.Count == 0) { MessageBox.Show("ID [" + CheckName + "] ! PASSWORD ERROR !", "Glucose Management Software", MessageBoxButtons.OK, MessageBoxIcon.Error); TextPasswd.Text = ""; goto EndAndAgain; } else { alu_tp.main_1.FileName = dv1[0].Row["idx"].ToString(); alu_tp.main_1.ReportName = CheckName; alu_tp.main_1.CPortOption = 1; alu_tp.main_1.serialPort1.PortName = Convert.ToString(dv1[0].Row["RS_232"]); alu_tp.main_1.UnitOption = Convert.ToInt16(dv1[0].Row["Unit1"]); alu_tp.main_1.TimeOption = Convert.ToInt16(dv1[0].Row["Time1"]); alu_tp.main_1.TargetMaxOption = Convert.ToInt16(dv1[0].Row["Max1"]); alu_tp.main_1.TargetMinOption = Convert.ToInt16(dv1[0].Row["Min1"]); alu_tp.main_1.TargetMaxOptionp = Convert.ToInt16(dv1[0].Row["Maxp"]); alu_tp.main_1.TargetMinOptionp = Convert.ToInt16(dv1[0].Row["Minp"]); } // MessageBox.Show("4"); //for (int i = 1; i < alu_tp.main_1.oldtotal; i++) //{ // if (alu_tp.main_1.DataName[i] == CheckName) // { // if (alu_tp.main_1.DataPswd[i] == CheckPassword) // { // alu_tp.main_1.FileName = alu_tp.main_1.DataName[i]; // alu_tp.main_1.ReportName = alu_tp.main_1.FileName; // //if (!File.Exists(alu_tp.main_1.MAIN_PATH + "\\" + alu_tp.main_1.FileName + ".txt")) // //{ // // FileInfo f = new FileInfo(alu_tp.main_1.MAIN_PATH + "\\" + alu_tp.main_1.FileName + ".txt"); // // StreamWriter sw = f.CreateText(); // // sw.WriteLine("Test_No,Glucose,Month,Day,Hour,Minute,Event,Glucose_mmol,Year,Date & Time"); // 寫入文字 // // sw.WriteLine("T0000,00000,00,00,00,00,0000,00000,0000,000000000000000000"); // // sw.Flush(); // // sw.Close(); // //} // } // else // { //} //} } // MessageBox.Show("5"); ////for (int i = 0; i < alu_tp.main_1.oldtotal; i++) ////{ //// if (alu_tp.main_1.DataName[i] == CheckName) //// { //// alu_tp.main_1.CPortOption = int.Parse(alu_tp.main_1.DataPortType[i]); //// alu_tp.main_1.serialPort1.PortName ="COM"+ Convert.ToString( int.Parse(alu_tp.main_1.DataPortType[i])); //// alu_tp.main_1.UnitOption = int.Parse(alu_tp.main_1.DataUnitType[i]); //// alu_tp.main_1.TimeOption = int.Parse(alu_tp.main_1.DataTimeType[i]); //// //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]); //// } ////} //{ // FileName = "c:\\guest.txt"; // if (!File.Exists(FileName)) // { // FileInfo f = new FileInfo(FileName); // StreamWriter sw = f.CreateText(); // sw.WriteLine("Test_No,Glucose,Month,Day,Hour,Minute,Event,Glucose_mmol,Year,Date & Time"); // 寫入文字 // sw.WriteLine("T0000,00000,00,00,00,00,0000,00000,0000,000000000000000000"); // sw.Flush(); // sw.Close(); // } //} // MessageBox.Show("1"); // readOldDataFrom fg1 = new readOldDataFrom(); // fg1.Show(); MainModule.readOldData(); // this.Hide(); mainForm fg = new mainForm(); fg.Show(); this.Hide(); EndAndAgain :; }
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[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; } }
static void Main() { Application.EnableVisualStyles(); Application.SetCompatibleTextRenderingDefault(false); SplashForm gg = new SplashForm(); gg.Show(); System.Threading.Thread.Sleep(1000); gg.Hide(); //Application.Run(new loginForm()); try { MainModule.OpenAccessDatabase("HMDgms.mdb", "HmdRegister"); MainModule.get_time_set(); } catch (Exception err) { } System.Data.DataView dv1; dv1 = MainModule.AccessDatabasesel("SELECT top 1 * FROM HmdRegister"); if (dv1 != null) { /********************2015.01.20 denny for no meter ID********************/ if (dv1.Count >= 0) { if (dv1.Count == 0) { alu_tp.main_1.FileName = ""; alu_tp.main_1.ReportName = ""; alu_tp.main_1.MeterIDNo = ""; alu_tp.main_1.CPortOption = 0; alu_tp.main_1.serialPort1 = new SerialPort(); alu_tp.main_1.serialPort1.PortName = "0"; alu_tp.main_1.UnitOption = 1; alu_tp.main_1.TimeOption = 1; alu_tp.main_1.TargetMaxOption = 999; alu_tp.main_1.TargetMinOption = 0; alu_tp.main_1.TargetMaxOptionp = 999; alu_tp.main_1.TargetMinOptionp = 0; } else { alu_tp.main_1.FileName = dv1[0].Row["idx"].ToString(); alu_tp.main_1.ReportName = dv1[0].Row["id"].ToString(); alu_tp.main_1.MeterIDNo = dv1[0].Row["mid"].ToString(); alu_tp.main_1.CPortOption = 1; alu_tp.main_1.serialPort1 = new SerialPort(); alu_tp.main_1.serialPort1.PortName = Convert.ToString(dv1[0].Row["RS_232"]); alu_tp.main_1.UnitOption = Convert.ToInt16(dv1[0].Row["Unit1"]); alu_tp.main_1.TimeOption = Convert.ToInt16(dv1[0].Row["Time1"]); alu_tp.main_1.TargetMaxOption = Convert.ToInt16(dv1[0].Row["Max1"]); alu_tp.main_1.TargetMinOption = Convert.ToInt16(dv1[0].Row["Min1"]); alu_tp.main_1.TargetMaxOptionp = Convert.ToInt16(dv1[0].Row["Maxp"]); alu_tp.main_1.TargetMinOptionp = Convert.ToInt16(dv1[0].Row["Minp"]); } /********************2015.01.20 denny for no meter ID********************/ Application.Run(new mainForm()); } else { MessageBox.Show("Sem conta padrão", "Programa de Monitoramento de Glicemia V2.4 [Bem vindo!]", MessageBoxButtons.OK, MessageBoxIcon.Error); Application.Exit(); } } }
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"); //////////////////////////// }
public static DataView SetGlucoseToTimeSet() { DataView dvglucose = MainModule.AccessDatabasesel("SELECT * FROM glucose where MeterID='" + alu_tp.main_1.MeterIDNo + "' ORDER BY TestTime DESC"); DataTable dt = new DataTable(); dt.Columns.Add("TestT", typeof(string)); dt.Columns.Add("TestTime", typeof(DateTime)); dt.Columns.Add("Expr1", typeof(string)); dt.Columns.Add("Expr2", typeof(string)); dt.Columns.Add("Expr3", typeof(string)); dt.Columns.Add("Expr4", typeof(string)); dt.Columns.Add("Expr5", typeof(string)); dt.Columns.Add("Expr6", typeof(string)); dt.Columns.Add("Expr7", typeof(string)); dt.Columns.Add("Expr8", typeof(string)); dt.Columns.Add("Expr9", typeof(string)); DataView dv = dt.DefaultView; dv.Sort = "TestTime"; string _timeTmp = string.Empty; string columnName = ""; bool _addData = false; foreach (DataRowView item in dvglucose) { DateTime _date = Convert.ToDateTime(item["TestTime"]); string _testTime = _date.ToString("yyyy/MM/dd"); string _time_idx = item["time_idx"].ToString(); string _glucoseData = item["glucoseData"].ToString(); int rowIndex = dv.Find(_testTime); columnName = "Expr" + _time_idx; _addData = (rowIndex < 0); if (_addData) { DataRow _drNew = dt.NewRow(); DataRow _newRow = dt.NewRow(); _newRow["TestT"] = string.Format("{0}-{1}-{2}", _date.Year, _date.Month.ToString().PadLeft(2, '0'), _date.Day.ToString().PadLeft(2, '0')); _newRow["TestTime"] = _testTime; _newRow["Expr1"] = 0; _newRow["Expr2"] = 0; _newRow["Expr3"] = 0; _newRow["Expr4"] = 0; _newRow["Expr5"] = 0; _newRow["Expr6"] = 0; _newRow["Expr7"] = 0; _newRow["Expr8"] = 0; _newRow["Expr9"] = 0; _newRow[columnName] = _glucoseData; dt.Rows.Add(_newRow); } else { if (dv[rowIndex][columnName].ToString().Length > 0) { string _value = dv[rowIndex][columnName].ToString(); if (Convert.ToInt16(_glucoseData) < Convert.ToInt16(_value)) { _glucoseData = _value.ToString(); } } dv[rowIndex][columnName] = _glucoseData; } } return(dv); }