//给病人分配护士护理
public string contributenurse(string nurse_ID, string patient_ID)
{
using (MyContext ctx = new MyContext())
{
foreach (var item in ctx.Patient_cares)
{
if (item.nur_ID == nurse_ID && item.patient_ID == patient_ID)
{
return("当前的护士已经分配护理该病人");
}
}
var nurse = ctx.Nurses.AsNoTracking().SingleOrDefault(e => e.nurse_ID == nurse_ID);
if (nurse == null)
{
return("没有找到该护士");
}
Patient_care s = new Patient_care();
s.nur_ID = nurse_ID;
s.patient_ID = patient_ID;
var patient = ctx.Patients.AsNoTracking().SingleOrDefault(e => e.patient_ID == patient_ID);
s.ward_ID = patient.patient_ward;
ctx.Patient_cares.Add(s);
ctx.SaveChanges();
return("分配成功");
}
}
public string AddNew(string patient_ID, string nur_ID, string name, string content, string ward_ID, DateTime date)
{
using (MyContext ctx = new MyContext())
{
var pat1 = ctx.Nurses.SingleOrDefault(pp => pp.nurse_ID == nur_ID);
if (pat1 == null)
{
return("NO1");
}
var pat2 = ctx.Patients.SingleOrDefault(pp => pp.patient_ID == patient_ID);
if (pat2 == null)
{
return("NO2");
}
var pat3 = ctx.Wards.SingleOrDefault(pp => pp.ward_ID == ward_ID);
if (pat3 == null)
{
return("NO3");
}
Patient_care p = new Patient_care();
p.patient_ID = patient_ID;
p.nur_ID = nur_ID;
p.name = name;
p.content = content;
p.ward_ID = ward_ID;
p.start_time = date;
ctx.Patient_cares.Add(p);
ctx.SaveChanges();
}
return("YES");
}
private Patient_careDTO CareToDTO(Patient_care s)
{
Patient_careDTO dto = new Patient_careDTO();
dto.patient_ID = s.patient_ID;
dto.nur_ID = s.nur_ID;
dto.ward_ID = s.ward_ID;
dto.name = s.name;
dto.content = s.content;
dto.start_time = s.start_time.ToString();
return(dto);
}
public string Change(string opatient_ID, string onur_ID, DateTime ostart_time, string patient_ID, string nur_ID, DateTime start_time, string name, string content, string ward_ID)
{
using (MyContext ctx = new MyContext())
{
var pat1 = ctx.Nurses.SingleOrDefault(pp => pp.nurse_ID == nur_ID);
if (pat1 == null)
{
return("NO1");
}
var pat2 = ctx.Patients.SingleOrDefault(pp => pp.patient_ID == patient_ID);
if (pat2 == null)
{
return("NO2");
}
var pat3 = ctx.Wards.SingleOrDefault(pp => pp.ward_ID == ward_ID);
if (pat3 == null)
{
return("NO3");
}
var pat = ctx.Patient_cares.SingleOrDefault(pp => pp.patient_ID == opatient_ID && pp.nur_ID == onur_ID && pp.start_time == ostart_time);
ctx.Patient_cares.Remove(pat);
ctx.SaveChanges();
//patient p = new patient();
Patient_care p = new Patient_care();
//pat.date = date;
//pat.ap_dept = ap_dept;
//pat.ap_patient = ap_patient;
p.patient_ID = patient_ID;
p.nur_ID = nur_ID;
p.start_time = start_time;
p.ward_ID = ward_ID;
p.name = name;
p.content = content;
ctx.Patient_cares.Add(p);
ctx.SaveChanges();
return("YES");
}
}
