private long GetAreaIdByBedId(long bedid)
{
using (var bedDao = new BedDao())
{
var condition = new Dictionary <string, object>();
condition["Id"] = bedid;
var bedlist = bedDao.SelectBed(condition);
if (bedlist.Count == 1)
{
long areaId = bedlist[0].PatientAreaId;
return(areaId);
}
}
return(-1);
}
private bool CheckNameIsExist(string name)
{
using (var bedDao = new BedDao())
{
var condition = new Dictionary <string, object>();
var list = bedDao.SelectBed(condition);
foreach (var pa in list)
{
if (name.Equals(pa.Name))
{
return(false);
}
}
return(true);
}
}
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 ListViewCBed_OnLoaded(object sender, RoutedEventArgs e)
{
//throw new NotImplementedException();
#region refresh data list
try
{
using (var bedDao = new BedDao())
{
Datalist.Clear();
var condition = new Dictionary <string, object>();
var list = bedDao.SelectBed(condition);
foreach (var pa in list)
{
var bedData = new BedData();
bedData.Id = pa.Id;
bedData.Name = pa.Name;
{
using (var patientAreaDao = new PatientAreaDao())
{
condition.Clear();
condition["ID"] = pa.PatientAreaId;
var arealist = patientAreaDao.SelectPatientArea(condition);
if (arealist.Count == 1)
{
bedData.PatientArea = arealist[0].Name;
}
}
}
//{
// using (var machineTypeDao = new MachineTypeDao())
// {
// condition.Clear();
// condition["ID"] = pa.MachineTypeId;
// var arealist = machineTypeDao.SelectMachineType(condition);
// if (arealist.Count == 1)
// {
// bedData.MachineType = arealist[0].Name;
// }
// }
//}
if (pa.MachineTypeId == 0)
{
bedData.MachineType = "单泵机";
}
else if (pa.MachineTypeId == 1)
{
bedData.MachineType = "双泵机";
}
{
using (var treatMethodDao = new TreatTypeDao())
{
condition.Clear();
condition["ID"] = pa.TreatTypeId;
var arealist = treatMethodDao.SelectTreatType(condition);
if (arealist.Count == 1)
{
bedData.TreatType = arealist[0].Name;
}
}
using (var infectTypeDao = new InfectTypeDao())
{
condition.Clear();
condition["ID"] = pa.InfectTypeId;
var arealist = infectTypeDao.SelectInfectType(condition);
if (arealist.Count == 1)
{
bedData.InfectType = arealist[0].Name;
}
}
}
bedData.IsAvailable = pa.IsAvailable;
bedData.IsOccupy = pa.IsOccupy;
bedData.IsTemp = pa.IsTemp;
bedData.Description = pa.Description;
Datalist.Add(bedData);
}
}
}
catch (Exception ex)
{
MainWindow.Log.WriteInfoConsole("In CBed.xaml.cs:ListViewCPatientRoom_OnLoaded 3 exception messsage: " + ex.Message);
}
#endregion
}
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;
}
private void RefreshData()
{
try
{
using (var bedDao = new BedDao())
{
Datalist.Clear();
var condition = new Dictionary <string, object>();
var list = bedDao.SelectBed(condition);
foreach (DAOModule.Bed pa in list)
{
var bedData = new BedData();
bedData.Id = pa.Id;
bedData.Name = pa.Name;
{
/* using (var patientRoomDao = new PatientRoomDao())
* {
* condition.Clear();
* condition["ID"] = pa.PatientRoomId;
* var arealist = patientRoomDao.SelectPatientRoom(condition);
* if (arealist.Count == 1)
* {
* bedData.PatientRoom = arealist[0].Name;
* }
* }*/
using (var patientAreaDao = new PatientAreaDao())
{
condition.Clear();
condition["ID"] = pa.PatientAreaId;
var arealist = patientAreaDao.SelectPatientArea(condition);
if (arealist.Count == 1)
{
bedData.PatientArea = arealist[0].Name;
}
}
using (var infectTypeDao = new InfectTypeDao())
{
condition.Clear();
condition["ID"] = pa.InfectTypeId;
var arealist = infectTypeDao.SelectInfectType(condition);
if (arealist.Count == 1)
{
bedData.InfectType = arealist[0].Name;
}
}
}
//{
// using (var machineTypeDao = new MachineTypeDao())
// {
// condition.Clear();
// condition["ID"] = pa.MachineTypeId;
// var arealist = machineTypeDao.SelectMachineType(condition);
// if (arealist.Count == 1)
// {
// bedData.MachineType = arealist[0].Name;
// }
// }
//}
if (pa.MachineTypeId == 0)
{
bedData.MachineType = "单泵机";
}
else if (pa.MachineTypeId == 1)
{
bedData.MachineType = "双泵机";
}
bedData.IsAvailable = pa.IsAvailable;
bedData.IsOccupy = pa.IsOccupy;
bedData.IsTemp = pa.IsTemp;
bedData.Description = pa.Description;
Datalist.Add(bedData);
}
}
}
catch (Exception ex)
{
MainWindow.Log.WriteInfoConsole("In CBed.xaml.cs:AddButton_OnClick exception messsage: " + ex.Message);
}
}
