public void InitPatientGroupComboBox() { try { PatientGroupComboBoxItems.Clear(); using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); var list = patientGroupDao.SelectPatientGroup(condition); foreach (var type in list) { var patientGroupData = new PatientGroupData { Id = type.Id, Name = type.Name, Description = type.Description }; PatientGroupComboBoxItems.Add(patientGroupData.Name); } } if (PatientGroupComboBoxItems.Count != 0) { PatientGroupComboBox.SelectedIndex = 0; } /*if (PatientGroupComboBoxItems.Count != 0) * this.PatientGroupComboBox.SelectedValue = Basewindow.patientGroupPanel.ComboBoxPatientGroup.SelectedValue;*/ } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In Init.xaml.cs:ComboBoxPatientGroup_OnInitialized exception messsage: " + ex.Message); } }
private void RefreshData() { try { using (var patientGroupDao = new PatientGroupDao()) { Datalist.Clear(); var condition = new Dictionary <string, object>(); var list = patientGroupDao.SelectPatientGroup(condition); foreach (var pa in list) { var patientGroupData = new PatientGroupData(); patientGroupData.Id = pa.Id; patientGroupData.Name = pa.Name; patientGroupData.Description = pa.Description; Datalist.Add(patientGroupData); } } Basewindow.patientGroupPanel.RefreshPatientGroupCombobox(); Basewindow.sheduleContent.InitPatientGroupComboBox(); } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In CPatientGroup.xaml.cs:RefreshData exception messsage: " + ex.Message); } }
private void ListViewPatientGroup_OnLoaded(object sender, RoutedEventArgs e) { //throw new NotImplementedException(); try { using (var patientGroupDao = new PatientGroupDao()) { Datalist.Clear(); var condition = new Dictionary <string, object>(); var list = patientGroupDao.SelectPatientGroup(condition); foreach (var type in list) { var patientGroupData = new PatientGroupData { Id = type.Id, Name = type.Name, Description = type.Description }; Datalist.Add(patientGroupData); } } } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In CPatient.xaml.cs:ListViewPatientGroup_OnLoaded exception messsage: " + ex.Message); } }
private void ComboBoxPatientGroup_OnInitialized(object sender, EventArgs e) { try { ComboBoxPatientGroup.Items.Clear(); using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); var list = patientGroupDao.SelectPatientGroup(condition); foreach (var type in list) { var patientGroupData = new PatientGroupData { Id = type.Id, Name = type.Name, Description = type.Description }; ComboBoxPatientGroup.Items.Add(patientGroupData.Name); } } } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In Init.xaml.cs:ComboBoxPatientGroup_OnInitialized exception messsage: " + ex.Message); } }
public void RefreshPatientGroupCombobox() { try { ComboBoxPatientGroup.Items.Clear(); using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); var list = patientGroupDao.SelectPatientGroup(condition); foreach (var type in list) { var patientGroupData = new PatientGroupData { Id = type.Id, Name = type.Name, Description = type.Description }; ComboBoxPatientGroup.Items.Add(patientGroupData.Name); } } } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In Init.xaml.cs:RefreshPatientGroupCombobox exception messsage: " + ex.Message); } }
private bool CheckNameIsExist(string name) { using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); var list = patientGroupDao.SelectPatientGroup(condition); foreach (var pa in list) { if (name.Equals(pa.Name)) { return(false); } } return(true); } }
public void RefreshData() { MainWindow.ComboBoxPatientGroupIndex = this.ComboBoxPatientGroup.SelectedIndex; Datalist.Clear(); using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); condition["NAME"] = this.ComboBoxPatientGroup.SelectedItem; var list = patientGroupDao.SelectPatientGroup(condition); if (list.Count > 0) { using (var patientGroupParaDao = new PatientGroupParaDao()) { var conditionpara = new Dictionary <string, object>(); conditionpara["GROUPID"] = list[0].Id; var listpara = patientGroupParaDao.SelectPatientGroupPara(conditionpara); if (listpara.Count > 0) { using (var patientDao = new PatientDao()) { var patientlist = patientDao.SelectPatientSpecial(listpara); foreach (var patient in patientlist) { var patientData = new PatientData(); patientData.Id = patient.Id; patientData.Name = patient.Name; Datalist.Add(patientData); } } } } } if (Datalist.Count > 0) { this.ListBoxPatient.SelectedIndex = 0; } } UpdateGroupCount(); }
private void ComboBoxPatientGroup_OnSelectionChanged(object sender, SelectionChangedEventArgs e) { MainWindow.ComboBoxPatientGroupIndex = this.ComboBoxPatientGroup.SelectedIndex; Datalist.Clear(); using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); condition["NAME"] = this.ComboBoxPatientGroup.SelectedItem; var list = patientGroupDao.SelectPatientGroup(condition); if (list.Count > 0) { using (var patientGroupParaDao = new PatientGroupParaDao()) { var conditionpara = new Dictionary <string, object>(); conditionpara["GROUPID"] = list[0].Id; var listpara = patientGroupParaDao.SelectPatientGroupPara(conditionpara); if (listpara.Count > 0) { using (var patientDao = new PatientDao()) { var patientlist = patientDao.SelectPatientSpecial(listpara); foreach (var patient in patientlist) { var patientData = new PatientData(); patientData.Id = patient.Id; patientData.Name = patient.Name; Datalist.Add(patientData); } } } } } } UpdateGroupCount(); //ListBoxPatient.SelectedIndex = Datalist.Count > 0 ? 1 : -1; }
private void QueryPatients() { try { int index = PatientGroupComboBox.SelectedIndex; if (index == -1) { return; } using (var patientGroupDao = new PatientGroupDao()) { var condition = new Dictionary <string, object>(); condition["NAME"] = PatientGroupComboBoxItems[index]; var list = patientGroupDao.SelectPatientGroup(condition); if (list.Count > 0) { using (var patientGroupParaDao = new PatientGroupParaDao()) { var conditionpara = new Dictionary <string, object>(); conditionpara["GROUPID"] = list[0].Id; var listpara = patientGroupParaDao.SelectPatientGroupPara(conditionpara); if (listpara.Count > 0) { using (var patientDao = new PatientDao()) { var patientlist = patientDao.SelectPatientSpecial(listpara); string areaid = GetPatientArea(listpara); if (!areaid.Equals("")) { Datalist.Clear(); QueryPatientsByArea(areaid); return; } Datalist.Clear(); foreach (var patient in patientlist) { using (var scheduleTemplateDao = new ScheduleTemplateDao()) { condition.Clear(); condition = new Dictionary <string, object>(); condition["PatientId"] = patient.Id; condition["DATE"] = DatePicker1.SelectedDate.Value.ToString("yyyy-MM-dd");// DateTime.Now.ToString("yyyy-MM-dd"); var list22 = scheduleTemplateDao.SelectScheduleTemplate(condition); foreach (var type in list22) { if (type.BedId == -1) { continue; } var rReportData = new ReportData(); rReportData.Id = type.Id; using (PatientDao patientDao1 = new PatientDao()) { var condition2 = new Dictionary <string, object>(); condition2["ID"] = type.PatientId; var list2 = patientDao1.SelectPatient(condition2); if ((list2 != null) && (list.Count > 0)) { rReportData.PatientName = list2[0].Name; rReportData.Description = list2[0].Description; } } rReportData.ShiftWork = type.AmPmE; rReportData.Method = type.Method; /*if (type.BedId == -1) * rReportData.BedId = ""; * else * { * rReportData.BedId = type.BedId.ToString(); * }*/ using (var bedDao = new BedDao()) { condition.Clear(); condition["Id"] = type.BedId; var bedlist = bedDao.SelectBed(condition); if (bedlist.Count == 1) { long areaId = bedlist[0].PatientAreaId; rReportData.BedId = bedlist[0].Name; using (var patientAreaDao = new PatientAreaDao()) { condition.Clear(); condition["Id"] = areaId; var arealist = patientAreaDao.SelectPatientArea(condition); if (arealist.Count == 1) { rReportData.Area = arealist[0].Name; } } } } //rReportData.Description = patient.Description; Datalist.Add(rReportData); } } } } } } } } UpdateGroupCount(); } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In Init.xaml.cs:Init_OnLoaded select patient exception messsage: " + ex.Message); } }