//给病人分配护士护理 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"); } }