private void LoadGraphBasicMeasurement() { if (Program.CurrentRegis != null) { DataTable dt = new DataTable(); dt.Columns.AddRange(new DataColumn[12] { new DataColumn("ObservationItem"), new DataColumn("BodyWeight"), new DataColumn("Bmi"), new DataColumn("Diastolic"), new DataColumn("Systolic"), new DataColumn("RR"), new DataColumn("Height"), new DataColumn("Pluse"), new DataColumn("Waist"), new DataColumn("Temp"), new DataColumn("Vision_lt"), new DataColumn("Vision_rt") }); string HN_No = dbc.trn_patients.Where(c => c.tpt_id == Program.CurrentRegis.tpt_id).Single().tpt_hn_no; var BindDataAll = dbc.pw_Get_Basic_measureTopFive(HN_No).ToList(); foreach (var element in BindDataAll) { var row = dt.NewRow(); row["BodyWeight"] = element.tbd_weight; row["Bmi"] = element.tbd_bmi; row["Diastolic"] = element.tbd_diastolic; row["Systolic"] = element.tbd_systolic; row["RR"] = element.tbd_rr; row["ObservationItem"] = Convert.ToDateTime(element.tbd_date).ToString("dd/MM/yyy", new CultureInfo("en-US")); row["Height"] = element.tbd_height; row["Pluse"] = element.tbd_pulse; row["Waist"] = element.tbd_waist; row["Temp"] = element.tbd_temp; row["Vision_lt"] = element.tbd_vision_lt; row["Vision_rt"] = element.tbd_vision_rt; dt.Rows.Add(row); } string str_value1, str_value2, str_value3, str_value4, str_value5, str_value6, str_value7, str_value8, str_value9, str_value10, str_value11; List <pw_Get_Basic_measureTopFiveResult> getBasic = new List <pw_Get_Basic_measureTopFiveResult>(); getBasic = dbc.pw_Get_Basic_measureTopFive(HN_No).ToList(); for (int i = 0; i <= getBasic.Count - 1; i++) { str_value1 = IsFloatOrInt(getBasic[i].tbd_vision_lt).ToString(); str_value2 = IsFloatOrInt(getBasic[i].tbd_vision_rt).ToString(); str_value3 = IsFloatOrInt(getBasic[i].tbd_bmi).ToString(); str_value4 = IsFloatOrInt(getBasic[i].tbd_diastolic).ToString(); str_value5 = IsFloatOrInt(getBasic[i].tbd_systolic).ToString(); str_value6 = IsFloatOrInt(getBasic[i].tbd_temp).ToString(); str_value7 = IsFloatOrInt(getBasic[i].tbd_waist).ToString(); str_value8 = IsFloatOrInt(getBasic[i].tbd_weight).ToString(); str_value9 = IsFloatOrInt(getBasic[i].tbd_rr).ToString(); str_value10 = IsFloatOrInt(getBasic[i].tbd_pulse).ToString(); str_value11 = IsFloatOrInt(getBasic[i].tbd_height).ToString(); if (str_value3 == "True") { displaychart1.Series["BMI"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_bmi) ? 0 : Convert.ToDouble(getBasic[i].tbd_bmi)); } if (str_value4 == "True") { displaychart1.Series["BP1(mmHg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_diastolic) ? 0 : Convert.ToDouble(getBasic[i].tbd_diastolic)); } if (str_value5 == "True") { displaychart1.Series["BP2(mmHg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_systolic) ? 0 : Convert.ToDouble(getBasic[i].tbd_systolic)); } if (str_value8 == "True") { displaychart1.Series["BW(kg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_weight) ? 0 : Convert.ToDouble(getBasic[i].tbd_weight)); } if (str_value9 == "True") { displaychart1.Series["RR(/min)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_rr) ? 0 : Convert.ToDouble(getBasic[i].tbd_rr)); } } } }
private void frmCumulativeVitalSigns_Load(object sender, EventArgs e) { this.Text = Program.GetRoomName("Cumulative Vital Signs"); try { if (Program.CurrentRegis != null) { panel3.Visible = true; //int tpr_id = 805;//370; //string str_HN = "01-10-054361";//"01-07-058653"; int tpr_id = string.IsNullOrEmpty(Program.CurrentRegis.tpr_id.ToString()) ? int.MinValue : Convert.ToInt32(Program.CurrentRegis.tpr_id); string str_HN = dbc.trn_patients.Where(a => a.tpt_id == Program.CurrentRegis.tpt_id).Select(s => s.tpt_hn_no).FirstOrDefault(); uiProfileHorizontal1.Loaddata(); dt.Columns.AddRange(new DataColumn[12] { new DataColumn("ObservationItem"), new DataColumn("BodyWeight"), new DataColumn("Bmi"), new DataColumn("Diastolic"), new DataColumn("Systolic"), new DataColumn("RR"), new DataColumn("Height"), new DataColumn("Pluse"), new DataColumn("Waist"), new DataColumn("Temp"), new DataColumn("Vision_lt"), new DataColumn("Vision_rt") }); cmbValue.SelectedIndex = 1; var BindDataAll = dbc.pw_Get_Basic_measureTopFive(str_HN).ToList(); foreach (var element in BindDataAll) { var row = dt.NewRow(); row["BodyWeight"] = element.tbd_weight; row["Bmi"] = element.tbd_bmi; row["Diastolic"] = element.tbd_diastolic; row["Systolic"] = element.tbd_systolic; row["RR"] = element.tbd_rr; row["ObservationItem"] = Convert.ToDateTime(element.tbd_date).ToString("dd/MM/yyy", new CultureInfo("en-US")); row["Height"] = element.tbd_height; row["Pluse"] = element.tbd_pulse; row["Waist"] = element.tbd_waist; row["Temp"] = element.tbd_temp; row["Vision_lt"] = element.tbd_vision_lt; row["Vision_rt"] = element.tbd_vision_rt; dt.Rows.Add(row); } DataTable dtReturn = GetInversedDataTable(dt, "ObservationItem"); dgvData.DataSource = AutoNumber(dtReturn); //getBasic = dbc.pw_Get_Basic_measure("01-07-058653", 370, "all").ToList(); getBasic = dbc.pw_Get_Basic_measureTopFive(str_HN).ToList(); string str_value1, str_value2, str_value3, str_value4, str_value5, str_value6, str_value7, str_value8, str_value9, str_value10, str_value11; for (int i = 0; i <= getBasic.Count - 1; i++) { str_value1 = IsFloatOrInt(getBasic[i].tbd_vision_lt).ToString(); str_value2 = IsFloatOrInt(getBasic[i].tbd_vision_rt).ToString(); str_value3 = IsFloatOrInt(getBasic[i].tbd_bmi).ToString(); str_value4 = IsFloatOrInt(getBasic[i].tbd_diastolic).ToString(); str_value5 = IsFloatOrInt(getBasic[i].tbd_systolic).ToString(); str_value6 = IsFloatOrInt(getBasic[i].tbd_temp).ToString(); str_value7 = IsFloatOrInt(getBasic[i].tbd_waist).ToString(); str_value8 = IsFloatOrInt(getBasic[i].tbd_weight).ToString(); str_value9 = IsFloatOrInt(getBasic[i].tbd_rr).ToString(); str_value10 = IsFloatOrInt(getBasic[i].tbd_pulse).ToString(); str_value11 = IsFloatOrInt(getBasic[i].tbd_height).ToString(); if (str_value1 == "True") { //displaychart_vision_lt.Series.Clear(); displaychart_vision_lt.Series["lt"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_vision_lt) ? 0 : Convert.ToDouble(getBasic[i].tbd_vision_lt)); } if (str_value2 == "True") { displaychart_vision_rt.Series["rt"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_vision_rt) ? 0 : Convert.ToDouble(getBasic[i].tbd_vision_rt)); } if (str_value3 == "True") { displaychart_bmi.Series["BMI"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_bmi) ? 0 : Convert.ToDouble(getBasic[i].tbd_bmi)); displaychart1.Series["BMI"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_bmi) ? 0 : Convert.ToDouble(getBasic[i].tbd_bmi)); } if (str_value4 == "True") { displaychart_bp.Series["Bp1"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_diastolic) ? 0 : Convert.ToDouble(getBasic[i].tbd_diastolic)); displaychart1.Series["BP1(mmHg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_diastolic) ? 0 : Convert.ToDouble(getBasic[i].tbd_diastolic)); } if (str_value5 == "True") { displaychart_bp.Series["Bp2"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_systolic) ? 0 : Convert.ToDouble(getBasic[i].tbd_systolic)); displaychart1.Series["BP2(mmHg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_systolic) ? 0 : Convert.ToDouble(getBasic[i].tbd_systolic)); } if (str_value6 == "True") { displaychart_temp.Series["temp"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_temp) ? 0 : Convert.ToDouble(getBasic[i].tbd_temp)); } if (str_value7 == "True") { displaychart_waist.Series["waist"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_waist) ? 0 : Convert.ToDouble(getBasic[i].tbd_waist)); } if (str_value8 == "True") { displaychart_bodyweight.Series["BW(kg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_weight) ? 0 : Convert.ToDouble(getBasic[i].tbd_weight)); displaychart1.Series["BW(kg)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_weight) ? 0 : Convert.ToDouble(getBasic[i].tbd_weight)); } if (str_value9 == "True") { displaychart_rr.Series["RR(/min)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_rr) ? 0 : Convert.ToDouble(getBasic[i].tbd_rr)); displaychart1.Series["RR(/min)"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_rr) ? 0 : Convert.ToDouble(getBasic[i].tbd_rr)); } if (str_value10 == "True") { displaychart_pluse.Series["pluse"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_pulse) ? 0 : Convert.ToDouble(getBasic[i].tbd_pulse)); } if (str_value11 == "True") { displaychart_height.Series["height"].Points.AddXY(Convert.ToDateTime(getBasic[i].tbd_date).ToString("dd/MM/yyy"), string.IsNullOrEmpty(getBasic[i].tbd_height) ? 0 : Convert.ToDouble(getBasic[i].tbd_height)); } } } else { lblwarning.Visible = true; lblwarning.Text = "No Data to Display"; panel3.Visible = false; } } catch { MessageBox.Show("Cannot display value !", "Information", MessageBoxButtons.OK, MessageBoxIcon.Exclamation); } }