private void loadData()
{
MainModule.readOldData();
if (alu_tp.main_1.Total != 0)
{
dateTimePicker1.Value = DateTime.Parse("#" + alu_tp.main_1.MDataMO[1] + "/" + alu_tp.main_1.MDataDA[1] + "/" + alu_tp.main_1.MDataYR[1] + "#");
dateTimePicker2.Value = DateTime.Parse("#" + alu_tp.main_1.MDataMO[alu_tp.main_1.Total] + "/" + alu_tp.main_1.MDataDA[alu_tp.main_1.Total] + "/" + alu_tp.main_1.MDataYR[alu_tp.main_1.Total] + "#");
}
print_chart();
}
private void loadData()
{
MainModule.readOldData();
if (alu_tp.main_1.Total == 1 && alu_tp.main_1.DataDA[1] == 0)
{
MessageBox.Show("nenhum dado !! faça o download!!", "gerente metros", MessageBoxButtons.OK, MessageBoxIcon.Error);
}
else
{
GLMax = 0; // '歸零
GLMin = 0;
GLAvg = 0;
GLAdd = 0;
GLMaxac = 0; // '歸零
GLMinac = 0;
GLAvgac = 0;
GLAddac = 0;
GLMaxpc = 0; // '歸零
GLMinpc = 0;
GLAvgpc = 0;
GLAddpc = 0;
nnn = 0;
nnnac = 0;
Total_pcR = 0;
Total_acR = 0;
//For I = 1 To 7 '設定啟始統計次數陣列各列為0
// Data(I, 2) = 0
// Data(I, 3) = 0
//Next
GLAdd = 0;
GLAddac = 0;
GLAddpc = 0;
//'判斷此血糖值為ac or pc----------------------------------------------
for (I = 1; I <= alu_tp.main_1.Total; I++)
{
if (alu_tp.main_1.DataACPC[I] == "PC" || alu_tp.main_1.DataACPC[I] == "1")
{
Total_pcR++;
DataMO_pcR[Total_pcR] = alu_tp.main_1.DataMO[I];
DataDA_pcR[Total_pcR] = alu_tp.main_1.DataDA[I];
DataHR_pcR[Total_pcR] = alu_tp.main_1.DataHR[I];
DataMI_pcR[Total_pcR] = alu_tp.main_1.DataMI[I];
DataGL_pcR[Total_pcR] = alu_tp.main_1.DataGL[I];
DataYR_pcR[Total_pcR] = alu_tp.main_1.DataYR[I];
}
else
{
Total_acR++;
DataMO_acR[Total_acR] = alu_tp.main_1.DataMO[I];
DataDA_acR[Total_acR] = alu_tp.main_1.DataDA[I];
DataHR_acR[Total_acR] = alu_tp.main_1.DataHR[I];
DataMI_acR[Total_acR] = alu_tp.main_1.DataMI[I];
DataGL_acR[Total_acR] = alu_tp.main_1.DataGL[I];
DataYR_acR[Total_acR] = alu_tp.main_1.DataYR[I];
}
}
#region 算pc
//'--------------------------------------------------------------------
P0 = 0;
P1 = 0;
P2 = 0;
P3 = 0;
P4 = 0;
P5 = 0;
P6 = 0;
for (I = 1; I <= Total_pcR; I++) // '隨著PC總筆數的增加
{
tmppc = DataGL_pcR[I]; // '將每一筆血糖值
//switch (tmppc)
//Select Case tmppc
if (tmppc < 70)
{
P0 = P0 + 1; // '統計該值區段的人數
}
else if (tmppc >= 70 && tmppc < 100)
{
P1 = P1 + 1; // '統計該值區段的人數
}
else if (tmppc >= 100 && tmppc < 140)
{
P2 = P2 + 1; // '統計該值區段的人數
}
else if (tmppc >= 140 && tmppc < 180)
{
P3 = P3 + 1; // '統計該值區段的人數
}
else if (tmppc >= 180 && tmppc < 220)
{
P4 = P4 + 1; // '統計該值區段的人數
}
else if (tmppc >= 220 & tmppc < 280)
{
P5 = P5 + 1; // '統計該值區段的人數
}
else
{
P6 = P6 + 1; // '統計該值區段的人數
}
nnn++;
int rrr = DataHR_pcR[I]; // '將HR GL 資料抓回
int minmin = DataMI_pcR[I];
ggg = DataGL_pcR[I];
GLAddpc = GLAddpc + ggg;
if (nnn == 1)
{
GLMaxpc = ggg;
GLMinpc = ggg;
}
if (ggg > GLMaxpc)
{
GLMaxpc = ggg;
}
if (ggg < GLMinpc)
{
GLMinpc = ggg;
}
}
#endregion
#region 算AC
// '--------------------------------------------------------------------------------------------------
A0 = 0;
A1 = 0;
A2 = 0;
A3 = 0;
A4 = 0;
A5 = 0;
A6 = 0;
for (I = 1; I <= Total_acR; I++) // '隨著AC總筆數的增加
{
tmpac = DataGL_acR[I]; // '將每一筆血糖值
//Select Case tmpac
if (tmpac < 70)
{
A0 = A0 + 1; // '統計該值區段的人數
}
else if (tmpac >= 70 && tmpac < 100)
{
A1 = A1 + 1; // '統計該值區段的人數
}
else if (tmpac >= 100 && tmpac < 140)
{
A2 = A2 + 1; // '統計該值區段的人數
}
else if (tmpac >= 140 && tmpac < 180)
{
A3 = A3 + 1; // '統計該值區段的人數
}
else if (tmpac >= 180 && tmpac < 220)
{
A4 = A4 + 1; // '統計該值區段的人數
}
else if (tmpac >= 220 && tmpac < 280)
{
A5 = A5 + 1; // '統計該值區段的人數
}
else
{
A6 = A6 + 1; // '統計該值區段的人數
}
nnnac = nnnac + 1;
int rrr = DataHR_acR[I]; // '將HR GL 資料抓回
int minmin = DataMI_acR[I];
gggac = DataGL_acR[I];
GLAddac = GLAddac + gggac;
if (nnnac == 1)
{
GLMaxac = gggac;
GLMinac = gggac;
}
if (gggac > GLMaxac)
{
GLMaxac = gggac;
}
if (gggac < GLMinac)
{
GLMinac = gggac;
}
}
#endregion
//'--------------------------------------------------------------------------------------------------
if (P0 != 0)
{
Pn0 = (P0 * 100) / nnn; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
Pn0 = 0;
}
if (P1 != 0)
{
Pn1 = (P1 * 100) / nnn; // '計算PC-血糖值 70-100 該區段的百分比
}
else
{
Pn1 = 0;
}
if (P2 != 0)
{
Pn2 = (P2 * 100) / nnn; // '計算PC-血糖值 100-140 該區段的百分比
}
else
{
Pn2 = 0;
}
if (P3 != 0)
{
Pn3 = (P3 * 100) / nnn; // '計算PC-血糖值 100-140 該區段的百分比
}
else
{
Pn3 = 0;
}
if (P4 != 0)
{
Pn4 = (P4 * 100) / nnn; // '計算PC-血糖值 100-140 該區段的百分比
}
else
{
Pn4 = 0;
}
if (P5 != 0)
{
Pn5 = (P5 * 100) / nnn; // '計算PC-血糖值 100-140 該區段的百分比
}
else
{
Pn5 = 0;
}
if (P6 != 0)
{
Pn6 = (P6 * 100) / nnn; // '計算PC-血糖值 100-140 該區段的百分比
}
else
{
Pn6 = 0;
}
if (A0 != 0)
{
An0 = (A0 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An0 = 0;
}
if (A1 != 0)
{
An1 = (A1 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An1 = 0;
}
if (A2 != 0)
{
An2 = (A2 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An2 = 0;
}
if (A3 != 0)
{
An3 = (A3 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An3 = 0;
}
if (A4 != 0)
{
An4 = (A4 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An4 = 0;
}
if (A5 != 0)
{
An5 = (A5 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An5 = 0;
}
if (A6 != 0)
{
An6 = (A6 * 100) / nnnac; // '計算PC-血糖值 小於70 該區段的百分比
}
else
{
An6 = 0;
}
if (nnn != 0)
{
GLAvgpc = (int)(GLAddpc / nnn); // '計算PC的平均值
}
else
{
GLAvgpc = 0;
}
if (nnnac != 0)
{
GLAvgac = (int)(GLAddac / nnnac); // '計算AC的平均值
}
else
{
GLAvgac = 0;
}
//MsgBox "總筆數為：" & nnn & "這些資料的血糖值總和為：" & GLAdd & "平均值為：" & GLAvg & "最大值為：" & GLMax & "最小值為：" & GLMin
label11.Text = nnn.ToString();
label12.Text = nnnac.ToString();
//'If TimeOption = 1 Then
label7.Text = DataYR_pcR[1] + "/" + DataMO_pcR[1] + "/" + DataDA_pcR[1] + " ~ " + DataYR_pcR[nnn] + "/" + DataMO_pcR[nnn] + "/" + DataDA_pcR[nnn];
label2.Text = DataYR_acR[1] + "/" + DataMO_acR[1] + "/" + DataDA_acR[1] + " ~ " + DataYR_acR[nnnac] + "/" + DataMO_acR[nnnac] + "/" + DataDA_acR[nnnac];
//'ElseIf TimeOption = 2 Then
//'Label15.Caption = DataDA(1) & "/" & DataMO(1) & "/" & DataYR(1) & " ~ " & DataDA(nnn) & "/" & DataMO(nnn) & "/" & DataYR(nnn)
//'End If
//'If UnitOption = 1 Then
// 'MsgBox "目前的單位為mg/dL"
label18.Text = GLMaxac.ToString();
label17.Text = GLMinac.ToString();
label16.Text = GLAvgac.ToString();
label27.Text = GLMaxpc.ToString();
label26.Text = GLMinpc.ToString();
label25.Text = GLAvgpc.ToString();
//Data(1, 1) = "<70" '填寫X軸標籤名
//Data(2, 1) = "70-100"
//Data(3, 1) = "100-140"
//Data(4, 1) = "140-180"
//Data(5, 1) = "180-220"
//Data(6, 1) = "220-280"
//Data(7, 1) = ">=280"
//MSChart1.ChartData = Data '將Data陣列中的資料載入圖形的資料方格
//for (int pointInde = 1; pointInde <= 7; pointInde++)
//{
chart1.ChartAreas["ChartArea1"].Axes[0].Title = alu_tp.main_1.rm_txt.GetString("ChartXaxis2");
//chart1.Titles.Clear();
//chart1.Titles.Add("NewTitle");
chart1.Titles["title1"].Text = alu_tp.main_1.rm_txt.GetString("ChartTitle2");
chart1.Series.Clear();
chart1.Series.Add("AC");
chart1.Series.Add("PC");
chart1.Series["AC"].Points.AddY(Pn0);
chart1.Series["PC"].Points.AddY(An0);
chart1.Series["AC"].Points.AddY(Pn1);
chart1.Series["PC"].Points.AddY(An1);
chart1.Series["AC"].Points.AddY(Pn2);
chart1.Series["PC"].Points.AddY(An2);
chart1.Series["AC"].Points.AddY(Pn3);
chart1.Series["PC"].Points.AddY(An3);
chart1.Series["AC"].Points.AddY(Pn4);
chart1.Series["PC"].Points.AddY(An4);
chart1.Series["AC"].Points.AddY(Pn5);
chart1.Series["PC"].Points.AddY(An5);
chart1.Series["AC"].Points.AddY(Pn6);
chart1.Series["PC"].Points.AddY(An6);
chart1.Series["AC"].IsValueShownAsLabel = true;
chart1.Series["PC"].IsValueShownAsLabel = true;
chart1.Series["AC"]["LabelStyle"] = "Top";
chart1.Series["PC"]["LabelStyle"] = "Top";
}
}
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 :;
}
