private List <Patient> GetPatientsInFixedDay(List <Patient> srcList, long areaid) { List <Patient> patients = new List <Patient>(); using (var scheduleTemplateDao = new ScheduleTemplateDao()) { var condition = new Dictionary <string, object>(); 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; } bool bExist = true; foreach (var patient in patients) { if (patient.PatientId != type.PatientId.ToString()) { bExist = false; break; } } if (!bExist) { long areaid1 = GetAreaIdByBedId(type.BedId); if (areaid == areaid1) { using (PatientDao patientDao1 = new PatientDao()) { var condition2 = new Dictionary <string, object>(); condition2["ID"] = type.PatientId; var list2 = patientDao1.SelectPatient(condition2); patients.Add(list2[0]); } } } } } foreach (var patient in srcList) { if (!patients.Contains(patient)) { patients.Add(patient); } } return(patients); }
private void ButtonDelete_OnClick(object sender, RoutedEventArgs e) { var messageBox2 = new RemindMessageBox2(); messageBox2.textBlock1.Text = "您确认删除当前病人记录吗?"; messageBox2.ShowDialog(); if (messageBox2.remindflag != 1) { return; } //if (ListViewBed.SelectedIndex == -1) return; if (Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex == -1) { return; } //throw new NotImplementedException(); using (var patientDao = new PatientDao()) { patientDao.DeletePatient((int)(Basewindow.patientGroupPanel.Datalist[Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex].Id)); try { using (MedicalOrderDao medicalOrderDao = new MedicalOrderDao()) { medicalOrderDao.DeleteMedicalOrder2((int)(Basewindow.patientGroupPanel.Datalist[Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex].Id)); } using (ScheduleTemplateDao scheduleDao = new ScheduleTemplateDao()) { scheduleDao.DeleteScheduleTemplate2( (int) (Basewindow.patientGroupPanel.Datalist[ Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex].Id)); } } catch (Exception ex) { MainWindow.Log.WriteErrorLog("Init.cs-ButtonDelete_OnClick", ex); } Basewindow.patientGroupPanel.RemoveData(Basewindow.patientGroupPanel.Datalist[Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex].Id); } this.ButtonDelete.IsEnabled = false; this.ButtonApply.IsEnabled = false; this.ButtonCancel.IsEnabled = false; }
private void ButtonDelete_OnClick(object sender, RoutedEventArgs e) { if (ListViewBed.SelectedIndex == -1) { return; } //throw new NotImplementedException(); using (var bedDao = new BedDao()) { bedDao.DeleteBed(Datalist[ListViewBed.SelectedIndex].Id); using (ScheduleTemplateDao scheduleDao = new ScheduleTemplateDao()) { scheduleDao.UpdateScheduleTemplate1("-1", Datalist[ListViewBed.SelectedIndex].Id.ToString(), DateTime.Now.Date); } RefreshData(); } this.ButtonDelete.IsEnabled = false; this.ButtonApply.IsEnabled = false; this.ButtonCancel.IsEnabled = false; isNew = false; }
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); } }
private void QueryPatientsByArea(string areaName) { string areaid = ""; using (var patientAreaDao = new PatientAreaDao()) { var condition = new Dictionary <string, object>(); condition["Name"] = areaName; var arealist = patientAreaDao.SelectPatientArea(condition); areaid = arealist[0].Id.ToString(); } using (BedDao bedDao = new BedDao()) { Dictionary <string, object> condition = new Dictionary <string, object>(); condition["PatientAreaId"] = areaid; var list = bedDao.SelectBed(condition); foreach (DAOModule.Bed bed in list) { using (var scheduleTemplateDao = new ScheduleTemplateDao()) { condition.Clear(); condition = new Dictionary <string, object>(); condition["BedId"] = bed.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 bedDao1 = new BedDao()) { condition.Clear(); condition["Id"] = type.BedId; var bedlist = bedDao1.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; } } } } Datalist.Add(rReportData); } } } } UpdateGroupCount(); }
private void ButtonApply_OnClick(object sender, RoutedEventArgs e) { if (isNew) { try { if (this.NameTextBox.Text.Equals("") || !CheckNameIsExist(this.NameTextBox.Text)) { var a = new RemindMessageBox1(); a.remindText.Text = (string)FindResource("Message1001");; a.ShowDialog(); return; } using (var bedDao = new BedDao()) { var bed = new DAOModule.Bed(); bed.Name = this.NameTextBox.Text; var condition = new Dictionary <string, object>(); //using (var machianTypeDao = new MachineTypeDao()) //{ // condition.Clear(); // condition["Name"] = MachineTypeComboBox.Text; // var arealist = machianTypeDao.SelectMachineType(condition); // if (arealist.Count == 1) // { // bed.MachineTypeId = arealist[0].Id; // } //} if ((bool)(this.RadioButton1.IsChecked)) { bed.MachineTypeId = 0; } else if ((bool)(this.RadioButton2.IsChecked)) { bed.MachineTypeId = 1; } using (var patientAreaDao = new PatientAreaDao()) { condition.Clear(); condition["Name"] = ComboBoxPatientArea.Text; var arealist = patientAreaDao.SelectPatientArea(condition); if (arealist.Count == 1) { bed.PatientAreaId = arealist[0].Id; } } if ((bool)(RadioButton3.IsChecked)) { bed.IsAvailable = true; } else if ((bool)(RadioButton4.IsChecked)) { bed.IsAvailable = false; } if ((bool)(RadioButton5.IsChecked)) { bed.IsTemp = true; } else if ((bool)(RadioButton6.IsChecked)) { bed.IsTemp = false; } bed.IsOccupy = false; bed.Description = this.DescriptionTextBox.Text; int lastInsertId = -1; bedDao.InsertBed(bed, ref lastInsertId); //UI BedData bedData = new BedData(); bedData.Id = lastInsertId; bedData.Name = bed.Name; bedData.PatientArea = ComboBoxPatientArea.Text; bedData.TreatType = ""; bedData.IsTemp = bed.IsTemp; if (bed.MachineTypeId == 0) { bedData.MachineType = "单泵机"; } else if (bed.MachineTypeId == 1) { bedData.MachineType = "双泵机"; } bedData.InfectType = ""; bedData.IsAvailable = bed.IsAvailable; bedData.IsOccupy = bed.IsOccupy; bedData.Description = bed.Description; int temp = this.ListViewBed.SelectedIndex; RefreshData(); this.ListViewBed.SelectedIndex = temp; } } catch (Exception ex) { MainWindow.Log.WriteInfoConsole("In CBed.xaml.cs:AddButton_OnClick exception messsage: " + ex.Message); } this.ButtonNew.IsEnabled = true; this.ButtonDelete.IsEnabled = true; this.ButtonApply.IsEnabled = true; this.ButtonCancel.IsEnabled = true; } else { if (ListViewBed.SelectedIndex == -1) { return; } if (this.NameTextBox.Text.Equals("")) { var a = new RemindMessageBox1(); a.remindText.Text = (string)FindResource("Message1001");; a.ShowDialog(); return; } //throw new NotImplementedException(); using (var bedDao = new BedDao()) { var condition = new Dictionary <string, object>(); condition["ID"] = Datalist[ListViewBed.SelectedIndex].Id; var fileds = new Dictionary <string, object>(); fileds["NAME"] = NameTextBox.Text; var condition2 = new Dictionary <string, object>(); //using (var machianTypeDao = new MachineTypeDao()) //{ // condition2.Clear(); // condition2["Name"] = MachineTypeComboBox.Text; // var arealist = machianTypeDao.SelectMachineType(condition2); // if (arealist.Count == 1) // { // fileds["MachineTypeId"] = arealist[0].Id; // } //} if ((bool)(this.RadioButton1.IsChecked)) { fileds["MachineTypeId"] = 0; } else if ((bool)(this.RadioButton2.IsChecked)) { fileds["MachineTypeId"] = 1; } using (var patientAreaDao = new PatientAreaDao()) { condition2.Clear(); condition2["Name"] = ComboBoxPatientArea.Text; var arealist = patientAreaDao.SelectPatientArea(condition2); if (arealist.Count == 1) { fileds["PATIENTAREAID"] = arealist[0].Id; } } if ((bool)(this.RadioButton3.IsChecked)) { fileds["ISAVAILABLE"] = true; } else if ((bool)(this.RadioButton4.IsChecked)) { fileds["ISAVAILABLE"] = false; } if ((bool)(this.RadioButton5.IsChecked)) { fileds["ISTEMP"] = true; } else if ((bool)(this.RadioButton6.IsChecked)) { fileds["ISTEMP"] = false; } //fileds["ISOCCUPY"] = CheckBoxIsOccupy.IsChecked; fileds["DESCRIPTION"] = DescriptionTextBox.Text; bedDao.UpdateBed(fileds, condition); if ((bool)(this.RadioButton4.IsChecked)) { using (ScheduleTemplateDao scheduleDao = new ScheduleTemplateDao()) { scheduleDao.UpdateScheduleTemplate1("-1", Datalist[ListViewBed.SelectedIndex].Id.ToString(), DateTime.Now.Date); } } int temp = this.ListViewBed.SelectedIndex; RefreshData(); this.ListViewBed.SelectedIndex = temp; } isNew = false; } this.ButtonApply.IsEnabled = false; }