public JsonResult SaveExcelData()
{
List <Patient> lstPatient = new List <Patient>();
List <Gender> lstGender = new GenderDao().GetAllGender().ToList();
lstPatient = HttpContext.Session.GetObjectFromJson <List <Patient> >("patient");
ReturnMessage returnMessage = new ReturnMessage();
for (int i = 0; i < lstPatient.Count; i++)
{
lstPatient[i].GenderID = (from x in lstGender
where x.GenderName == lstPatient[i].GenderName
select x.GenderID).FirstOrDefault();
lstPatient[i].Created_By = 1;
lstPatient[i].Created_On = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
lstPatient[i].Modified_By = 1;
lstPatient[i].Modified_On = new DateTime(DateTime.Now.Year, DateTime.Now.Month, DateTime.Now.Day);
lstPatient[i].Active = true;
}
returnMessage = new PatientDao().Import(lstPatient);
return(Json(lstPatient));
}
public async Task <JsonResult> UpdatePatient(ImportClass tempData)
{
dynamic jsData = JsonConvert.DeserializeObject(tempData.receive);
var fileID = HttpContext.Session.GetInt32(SessionFile);
string DateOfBirth = jsData.DOB;
Patient patient = new Patient();
patient.PatientID = jsData.Patient_ID;
patient.PatientCode = jsData.Patient_Code;
patient.PatientName = jsData.Patient_Name;
patient.Address = jsData.Address;
patient.GenderID = jsData.GenderID;
//patient.FileID = Convert.ToInt32(fileID);
if (!string.IsNullOrEmpty(DateOfBirth))
{
string[] datePart = DateOfBirth.Split('/');
patient.DOB = new DateTime(Convert.ToInt32(datePart[2]), Convert.ToInt32(datePart[1]), Convert.ToInt32(datePart[0]));
}
int message = new PatientDao().EditPatient(patient);
return(Json(new
{
status = message
}));
}
public SignUP(MainWindow mainWindow)
{
InitializeComponent();
Basewindow = mainWindow;
using (PatientDao patientDao = new PatientDao())
{
var condition = new Dictionary <string, object>();
var list = patientDao.SelectPatient(condition);
tbUid.Text = (list.Count + 1).ToString();
}
}
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);
}
public IActionResult PatientList()
{
//if (!IsAllowed(1,2))
//{
// return RedirectToAction("NoPermission", "AppBase");
//}
List <Patient> lstPatient = new PatientDao().GetAllPatient().ToList();
ViewBag.patientList = lstPatient;
return(View());
}
//GET: Get patients list
public ActionResult Index()
{
int doctor = User.Identity.GetUserId <int>();
if (doctor < 1)
{
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
var model = new PatientDao().GetPatientsDetail(doctor);
//return Json(model, JsonRequestBehavior.AllowGet);
return(View(model));
}
// GET: Get Patient detail
public ActionResult Detail(int id)
{
int doctor = User.Identity.GetUserId <int>();
if (doctor < 1)
{
return(RedirectToAction("Login", "Account", new { Area = "" }));
}
ViewBag.PatientList = new SelectList(new PatientDao().GetDoctorPatientsId(doctor), id);
var model = new PatientDao().GetPatientDetail(id);
//return Json(model,JsonRequestBehavior.AllowGet);
return(View(model));
}
public IActionResult EditPatient(string patientId)
{
Patient patient = new PatientDao().GetAllPatient().Where(x => x.PatientID == Convert.ToInt32(patientId)).ToList()[0];
List <Gender> lstGender = new GenderDao().GetAllGender().ToList();
lstGender.Insert(0, new Gender()
{
GenderID = 0, GenderName = "Select Gender Name"
});
ViewBag.GenderList = new SelectList(lstGender, "GenderID", "GenderName");
List <Attachments> lstAttachments = new AttachmentDao().GetAllTmpAttachmentsByIssueId(Convert.ToInt32(patientId)).ToList();
ViewBag.AttachmentsList = lstAttachments;
return(View(patient));
}
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;
}
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 ListBoxPatient_OnSelectionChanged(object sender, SelectionChangedEventArgs e)
{
if (this.ListBoxPatient.SelectedIndex != -1)
{
using (PatientDao patientDao = new PatientDao())
{
var condition = new Dictionary <string, object>();
condition["ID"] = Datalist[this.ListBoxPatient.SelectedIndex].Id;
var list = patientDao.SelectPatient(condition);
if ((list != null) && (list.Count > 0))
{
Patient patient = list[0];
Basewindow.initContent.IDTextBox.Text = patient.PatientId.ToString();
Basewindow.initContent.NameTextBox.Text = patient.Name;
if (patient.Gender.Equals("男"))
{
Basewindow.initContent.RadioButton1.IsChecked = true;
}
else if (patient.Gender.Equals("女"))
{
Basewindow.initContent.RadioButton2.IsChecked = true;
}
try
{
Basewindow.initContent.DatePicker1.Text = DateTime.Parse(patient.Dob).ToString();
}
catch (Exception)
{
Basewindow.initContent.DatePicker1.Text = "";
}
Basewindow.initContent.NationalityTextBox.Text = patient.Nationality;
if (patient.Gender.Equals("未婚"))
{
Basewindow.initContent.MarriageComboBox.SelectedIndex = 0;
}
else if (patient.Gender.Equals("已婚"))
{
Basewindow.initContent.MarriageComboBox.SelectedIndex = 1;
}
Basewindow.initContent.HeightTextBox.Text = patient.Height;
Basewindow.initContent.BloodTypeTextBox.Text = patient.BloodType;
if (patient.InfectTypeId == 0)
{
Basewindow.initContent.RadioButton5.IsChecked = true;
}
else
{
Basewindow.initContent.RadioButton6.IsChecked = true;
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
var condition1 = new Dictionary <string, object>();
condition1["ID"] = patient.InfectTypeId;
var list1 = infectTypeDao.SelectInfectType(condition1);
if ((list1 != null) && (list1.Count > 0))
{
Basewindow.initContent.InfectTypeComboBox.Text = list1[0].Name;
}
}
}
if (patient.TreatStatusId == 0)
{
Basewindow.initContent.rbTreatStatus1.IsChecked = true;
}
else
{
Basewindow.initContent.rbTreatStatus2.IsChecked = true;
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
var condition1 = new Dictionary <string, object>();
condition1["ID"] = patient.TreatStatusId;
var list1 = treatStatusDao.SelectTreatStatus(condition1);
if ((list1 != null) && (list1.Count > 0))
{
Basewindow.initContent.StatusComboBox.Text = list1[0].Name;
}
}
}
if (patient.IsFixedBed)
{
Basewindow.initContent.RadioButton3.IsChecked = true;
}
else
{
Basewindow.initContent.RadioButton4.IsChecked = true;
}
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
var condition1 = new Dictionary <string, object>();
condition1["ID"] = patient.AreaId;
var list1 = patientAreaDao.SelectPatientArea(condition1);
if ((list1 != null) && (list1.Count > 0))
{
Basewindow.initContent.AreaComboBox.Text = list1[0].Name;
}
}
Basewindow.initContent.PatientIDTextBox.Text = patient.Id.ToString();
Basewindow.initContent.MobileTextBox.Text = patient.Mobile;
Basewindow.initContent.WeixinhaoTextBox.Text = patient.WeiXinHao;
Basewindow.initContent.PaymentTextBox.Text = patient.Payment;
Basewindow.initContent.Discription.Text = patient.Description;
Basewindow.initContent.ButtonApply.IsEnabled = false;
Basewindow.initContent.ButtonCancel.IsEnabled = false;
Basewindow.initContent.ButtonDelete.IsEnabled = true;
#region orderContent
Basewindow.orderContent.IDTextBox.Text = patient.PatientId.ToString();
Basewindow.orderContent.NameTextBox.Text = patient.Name;
if (patient.Gender.Equals("男"))
{
Basewindow.orderContent.RadioButton1.IsChecked = true;
}
else if (patient.Gender.Equals("女"))
{
Basewindow.orderContent.RadioButton2.IsChecked = true;
}
try
{
Basewindow.orderContent.DatePicker1.Text = DateTime.Parse(patient.Dob).ToString();
}
catch (Exception)
{
Basewindow.orderContent.DatePicker1.Text = "";
}
Basewindow.orderContent.NationalityTextBox.Text = patient.Nationality;
if (patient.Gender.Equals("未婚"))
{
Basewindow.orderContent.MarriageComboBox.SelectedIndex = 0;
}
else if (patient.Gender.Equals("已婚"))
{
Basewindow.orderContent.MarriageComboBox.SelectedIndex = 1;
}
Basewindow.orderContent.HeightTextBox.Text = patient.Height;
Basewindow.orderContent.BloodTypeTextBox.Text = patient.BloodType;
if (patient.InfectTypeId == 0)
{
Basewindow.orderContent.RadioButton5.IsChecked = true;
}
else
{
Basewindow.orderContent.RadioButton6.IsChecked = true;
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
var condition1 = new Dictionary <string, object>();
condition1["ID"] = patient.InfectTypeId;
var list1 = infectTypeDao.SelectInfectType(condition1);
if ((list1 != null) && (list1.Count > 0))
{
Basewindow.orderContent.InfectTypeComboBox.Text = list1[0].Name;
}
}
}
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
var condition1 = new Dictionary <string, object>();
condition1["ID"] = patient.TreatStatusId;
var list1 = treatStatusDao.SelectTreatStatus(condition1);
if ((list1 != null) && (list1.Count > 0))
{
Basewindow.orderContent.StatusComboBox.Text = list1[0].Name;
}
}
if (patient.IsFixedBed)
{
Basewindow.orderContent.RadioButton3.IsChecked = true;
}
else
{
Basewindow.orderContent.RadioButton4.IsChecked = true;
}
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
var condition1 = new Dictionary <string, object>();
condition1["ID"] = patient.AreaId;
var list1 = patientAreaDao.SelectPatientArea(condition1);
if ((list1 != null) && (list1.Count > 0))
{
Basewindow.orderContent.AreaComboBox.Text = list1[0].Name;
}
}
Basewindow.orderContent.RefreshData();
Basewindow.orderContent.PatientIDTextBox.Text = patient.PatientId;
Basewindow.orderContent.MobileTextBox.Text = patient.Mobile;
Basewindow.orderContent.WeixinhaoTextBox.Text = patient.WeiXinHao;
Basewindow.orderContent.PaymentTextBox.Text = patient.Payment;
#endregion
}
}
}
}
public ActionResult Update(PatientProfile model, IList <AddressDetail> addr)
{
if (addr != null)
{
model.Addresses = addr; // Assign AddressDetail list to PatientProfile model
}
else
{
model.Addresses = null;
}
if (ModelState.IsValid)
{
int userid = User.Identity.GetUserId <int>();
ApplicationUser user = UserManager.FindById(userid);
if (user == null)
{
ViewBag.Errors = "Không thấy lễ tân này này";
return(RedirectToAction("Detail", "ReceptionProfile", new { Message = ProfileMessageId.Error }));
}
// Update account data
user.Email = model.Email;
user.DateOfBirth = model.DoB;
user.FullName = model.FullName;
user.PhoneNumber = model.PhoneNumber;
user.Gender = model.Gender;
var updateacc = UserManager.Update(user);
if (!updateacc.Succeeded)
{
ViewBag.Errors = "Không cập nhật được account";
return(View("Detail", model));
}
// Update profile data
TM_Patient patient = new PatientDao().FindByUserId(userid);
if (patient == null)
{
patient = new TM_Patient();
patient.UserId = userid;
patient.AssuranceCard = model.AssuranceCard;
patient.IdentityCard = model.IdentityCard;
if (new PatientDao().Insert(patient) < 1)
{
ViewBag.Errors = "Không thêm được profile";
return(View("Detail", model));
}
}
else
{
patient.AssuranceCard = model.AssuranceCard;
patient.IdentityCard = model.IdentityCard;
if (!new PatientDao().Update(patient))
{
ViewBag.Errors = "Không cập nhật được profile";
return(View("Detail", model));
}
}
return(RedirectToAction("Detail", new { message = ProfileMessageId.ChangeAccountSuccess }));
}
return(View("Detail", model));
}
public JsonResult GetPatient()
{
List <Patient> lstPatient = new PatientDao().GetAllPatient();
return(Json(lstPatient));
}
private void Button_Click_1(object sender, RoutedEventArgs e)
{
if (tbName.Text.Equals("") || tbUid.Text.Equals(""))
{
var a = new RemindMessageBox1();
a.remindText.Text = "患者名称和唯一识别码不能为空.";
a.ShowDialog();
return;
}
name = tbName.Text;
if (rbM.IsChecked == true)
{
sex = "男";
}
else
{
sex = "女";
}
birthday = dpBirthday.Text;
if ((bool)this.rbNegative1.IsChecked)
{
infectionTypeId = 0;
}
else if ((bool)this.rbNegative2.IsChecked)
{
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
var condition = new Dictionary <string, object>();
condition["Name"] = InfectTypeComboBox.Text;
infectionName = InfectTypeComboBox.Text;
var list = infectTypeDao.SelectInfectType(condition);
if (list != null)
{
infectionTypeId = list[0].Id;
}
}
}
if ((bool)this.rbTreatStatus1.IsChecked)
{
treatmentStatus = 0;
treatmentStausName = "在治";
}
else if ((bool)this.rbTreatStatus2.IsChecked)
{
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
var condition = new Dictionary <string, object>();
condition["Name"] = StatusComboBox.Text;
treatmentStausName = StatusComboBox.Text;
var list = treatStatusDao.SelectTreatStatus(condition);
if (list != null)
{
treatmentStatus = list[0].Id;
}
}
}
if ((bool)this.rbFixBed1.IsChecked)
{
isFixBed = true;
}
else if ((bool)this.rbFixBed2.IsChecked)
{
isFixBed = false;
}
uid = tbUid.Text;
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
var condition = new Dictionary <string, object>();
condition["Name"] = AreaComboBox.Text;
areaName = AreaComboBox.Text;
var list = patientAreaDao.SelectPatientArea(condition);
if (list != null)
{
areaId = list[0].Id;
}
}
result = System.Windows.Forms.DialogResult.OK;
using (PatientDao patientDao = new PatientDao())
{
Patient patient = new Patient();
patient.Name = name;
patient.Gender = sex;
patient.Dob = birthday;
patient.InfectTypeId = infectionTypeId;
patient.TreatStatusId = treatmentStatus;
patient.IsFixedBed = isFixBed;
patient.PatientId = uid;
patient.AreaId = areaId;
patient.BedId = -1;
int lastInsertId = -1;
patientDao.InsertPatient(patient, ref lastInsertId);
InitMedicalOrderData(lastInsertId);
Basewindow.initContent.IDTextBox.Text = lastInsertId.ToString();
Basewindow.initContent.NameTextBox.Text = patient.Name;
if (patient.Gender.Equals("男"))
{
Basewindow.initContent.RadioButton1.IsChecked = true;
}
else if (patient.Gender.Equals("女"))
{
Basewindow.initContent.RadioButton2.IsChecked = true;
}
Basewindow.initContent.DatePicker1.Text = DateTime.Parse(patient.Dob).ToString();
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
var condition = new Dictionary <string, object>();
condition["ID"] = patient.InfectTypeId;
var list = infectTypeDao.SelectInfectType(condition);
if ((list != null) && (list.Count > 0))
{
Basewindow.initContent.InfectTypeComboBox.Text = list[0].Name;
}
}
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
var condition = new Dictionary <string, object>();
condition["ID"] = patient.TreatStatusId;
var list = treatStatusDao.SelectTreatStatus(condition);
if ((list != null) && (list.Count > 0))
{
Basewindow.initContent.StatusComboBox.Text = list[0].Name;
}
}
Basewindow.initContent.IDTextBox.Text = patient.PatientId;
if (patient.IsFixedBed)
{
Basewindow.initContent.RadioButton3.IsChecked = true;
}
else
{
Basewindow.initContent.RadioButton4.IsChecked = true;
}
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
var condition = new Dictionary <string, object>();
condition["ID"] = patient.AreaId;
var list = patientAreaDao.SelectPatientArea(condition);
if ((list != null) && (list.Count > 0))
{
Basewindow.initContent.AreaComboBox.Text = list[0].Name;
}
}
}
//TODO:判断一下当前添加的患者是否满足当前患者组条件，如果满足需要刷新患者列表
Basewindow.patientGroupPanel.RefreshData();
Basewindow.initContent.ButtonNew.IsEnabled = true;
Basewindow.initContent.ButtonDelete.IsEnabled = true;
Basewindow.initContent.ButtonApply.IsEnabled = false;
Basewindow.initContent.ButtonCancel.IsEnabled = false;
this.Close();
}
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 FillValues(string key)
{
IsEditabel = false;
using (var patientDao = new PatientDao())
{
var condition = new Dictionary <string, object>();
List <Patient> patientslist = patientDao.SelectPatient(condition);
switch (key)
{
case "姓名":
IsEditabel = true;
/*_details.Clear();
* foreach (var patient in patientslist)
* {
* _details.Add(patient.Name);
* }*/
break;
case "性别":
_details.Clear();
_details.Add("男");
_details.Add("女");
break;
case "血型":
_details.Clear();
_details.Add("O");
_details.Add("A");
_details.Add("B");
_details.Add("AB");
break;
case "婚姻状况":
_details.Clear();
_details.Add("已婚");
_details.Add("未婚");
break;
case "感染情况":
_details.Clear();
using (var infectTypeDao = new InfectTypeDao())
{
condition.Clear();
var arealist = infectTypeDao.SelectInfectType(condition);
foreach (var infectType in arealist)
{
_details.Add(infectType.Name);
}
_details.Add("阴性");
}
break;
case "治疗状态":
_details.Clear();
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
var condition1 = new Dictionary <string, object>();
var list1 = treatStatusDao.SelectTreatStatus(condition1);
foreach (var treatStatuse in list1)
{
_details.Add(treatStatuse.Name);
}
_details.Add("在治");
}
break;
case "固定床位":
_details.Clear();
_details.Add("FALSE");
_details.Add("TRUE");
break;
case "所属分区":
_details.Clear();
using (var patientAreaDao = new PatientAreaDao())
{
condition.Clear();
var list = patientAreaDao.SelectPatientArea(condition);
foreach (var type in list)
{
_details.Add(type.Name);
}
}
break;
}
}
}
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 AddNewPatient()
//{
// using (PatientDao patientDao = new PatientDao())
// {
// Patient patient = new Patient();
// patient.Name = NameTextBox.Text;
// if ((bool)RadioButton1.IsChecked)
// patient.Gender = "男";
// else if ((bool)RadioButton2.IsChecked)
// patient.Gender = "女";
// patient.Dob = DatePicker1.Text;
// patient.Nationality= NationalityTextBox.Text;
// patient.Marriage = MarriageComboBox.Text;
// patient.Height = HeightTextBox.Text;
// patient.BloodType = BloodTypeTextBox.Text;
// if ((bool)RadioButton5.IsChecked)
// {
// patient.InfectTypeId = 0;
// }
// else if ((bool)RadioButton6.IsChecked)
// {
// using (InfectTypeDao infectTypeDao = new InfectTypeDao())
// {
// var condition1 = new Dictionary<string, object>();
// condition1["NAME"] = InfectTypeComboBox.Text;
// var list1 = infectTypeDao.SelectInfectType(condition1);
// if ((list1 != null) && (list1.Count > 0))
// {
// patient.InfectTypeId = list1[0].Id;
// }
// }
// }
// using (TreatStatusDao treatStatusDao = new TreatStatusDao())
// {
// var condition1 = new Dictionary<string, object>();
// condition1["NAME"] = StatusComboBox.Text;
// var list1 = treatStatusDao.SelectTreatStatus(condition1);
// if ((list1 != null) && (list1.Count > 0))
// {
// patient.TreatStatusId = list1[0].Id;
// }
// }
// if ((bool)RadioButton3.IsChecked)
// patient.IsFixedBed = true;
// else if ((bool)RadioButton4.IsChecked)
// patient.IsFixedBed = false;
// using (PatientAreaDao patientAreaDao = new PatientAreaDao())
// {
// var condition1 = new Dictionary<string, object>();
// condition1["NAME"] = AreaComboBox.Text;
// var list1 = patientAreaDao.SelectPatientArea(condition1);
// if ((list1 != null) && (list1.Count > 0))
// {
// patient.AreaId = list1[0].Id;
// }
// }
// patient.PatientId = PatientIDTextBox.Text;
// patient.Mobile = MobileTextBox.Text;
// patient.WeiXinHao = WeixinhaoTextBox.Text;
// patient.Payment = PaymentTextBox.Text;
// int lastInsertId = -1;
// patientDao.InsertPatient(patient, ref lastInsertId);
// }
//}
//private bool CheckInfo()
//{
// if (
// MobileTextBox.Text == ""
// )
// return false;
// else return true;
//}
private void ButtonApply_OnClick(object sender, RoutedEventArgs e)
{
//if (CheckInfo() == false)
//{
// System.Windows.Forms.MessageBox.Show("请完善信息，*必填!");
// return;
//}
//if (isNewAdded == true)
//{
// AddNewPatient();
// isNewAdded = false;
// return;
//}
if (Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex == -1)
{
return;
}
this.ButtonNew.IsEnabled = true;
this.ButtonDelete.IsEnabled = true;
this.ButtonApply.IsEnabled = false;
using (PatientDao patientDao = new PatientDao())
{
var condition = new Dictionary <string, object>();
condition["ID"] = Basewindow.patientGroupPanel.Datalist[Basewindow.patientGroupPanel.ListBoxPatient.SelectedIndex].Id;
var fileds = new Dictionary <string, object>();
fileds["NAME"] = NameTextBox.Text;
if ((bool)RadioButton1.IsChecked)
{
fileds["GENDER"] = "男";
}
else if ((bool)RadioButton2.IsChecked)
{
fileds["GENDER"] = "女";
}
fileds["DOB"] = DatePicker1.Text;
fileds["NATIONALITY"] = NationalityTextBox.Text;
fileds["MARRIAGE"] = MarriageComboBox.Text;
fileds["HEIGHT"] = HeightTextBox.Text;
fileds["BLOODTYPE"] = BloodTypeTextBox.Text;
if ((bool)RadioButton5.IsChecked)
{
fileds["INFECTTYPEID"] = 0;
}
else if ((bool)RadioButton6.IsChecked)
{
using (InfectTypeDao infectTypeDao = new InfectTypeDao())
{
var condition1 = new Dictionary <string, object>();
condition1["NAME"] = InfectTypeComboBox.Text;
var list1 = infectTypeDao.SelectInfectType(condition1);
if ((list1 != null) && (list1.Count > 0))
{
fileds["INFECTTYPEID"] = list1[0].Id;
}
}
}
if ((bool)rbTreatStatus1.IsChecked)
{
fileds["TREATSTATUSID"] = 0;
}
else if ((bool)rbTreatStatus2.IsChecked)
{
using (TreatStatusDao treatStatusDao = new TreatStatusDao())
{
var condition1 = new Dictionary <string, object>();
condition1["NAME"] = StatusComboBox.Text;
var list1 = treatStatusDao.SelectTreatStatus(condition1);
if ((list1 != null) && (list1.Count > 0))
{
fileds["TREATSTATUSID"] = list1[0].Id;
}
}
}
if ((bool)RadioButton3.IsChecked)
{
fileds["ISFIXEDBED"] = true;
}
else if ((bool)RadioButton4.IsChecked)
{
fileds["ISFIXEDBED"] = false;
}
using (PatientAreaDao patientAreaDao = new PatientAreaDao())
{
var condition1 = new Dictionary <string, object>();
condition1["NAME"] = AreaComboBox.Text;
var list1 = patientAreaDao.SelectPatientArea(condition1);
if ((list1 != null) && (list1.Count > 0))
{
fileds["AREAID"] = list1[0].Id;
}
}
fileds["PATIENTID"] = IDTextBox.Text;
fileds["MOBILE"] = MobileTextBox.Text;
fileds["WEIXINHAO"] = WeixinhaoTextBox.Text;
fileds["PAYMENT"] = PaymentTextBox.Text;
fileds["DESCRIPTION"] = Discription.Text;
patientDao.UpdatePatient(fileds, condition);
}
}
