//删除回访记录 public void DeleteCustomerReturnVisit(int id) { CustomerReturnVisit customerReturnVisit = db.CustomerReturnVisit.Find(id); db.CustomerReturnVisit.Remove(customerReturnVisit); db.SaveChanges(); }
//删除预约信息 public void DeleteCustomerAppointment(int id) { //删除预约表 List <CustomerAppointment> customerAppointment = db.CustomerAppointment.Where(p => p.CustomerAppointmentID == id).ToList(); if (customerAppointment.Count > 0) { foreach (var item in customerAppointment) { //利用所有的预约id去查有没有体检信息,有则删除体检信息 ClientMdicalIformation clientMdicalIformation = db.ClientMdicalIformation.Where(p => p.CustomerAppointmentID == item.CustomerAppointmentID).ToList().FirstOrDefault(); if (clientMdicalIformation != null) { //删除客户回访信息 List <CustomerReturnVisit> customerReturnVisit = db.CustomerReturnVisit.Where(p => p.ConclusionID == clientMdicalIformation.ConclusionID).ToList(); if (customerReturnVisit.Count > 0) { foreach (var item1 in customerReturnVisit) { CustomerReturnVisit customerReturnVisit1 = db.CustomerReturnVisit.Where(p => p.ConclusionID == item1.ConclusionID).ToList().FirstOrDefault(); db.CustomerReturnVisit.Remove(customerReturnVisit1); db.SaveChanges(); } } //删除客户关怀信息 List <CustomerCare> customerCare = db.CustomerCare.Where(p => p.ConclusionID == clientMdicalIformation.ConclusionID).ToList(); if (customerCare.Count() > 0) { foreach (var item2 in customerCare) { int customerCareid = item2.CustomerCareID; CustomerCare customerCare1 = db.CustomerCare.Where(p => p.ConclusionID == item2.ConclusionID).ToList().FirstOrDefault(); db.CustomerCare.Remove(customerCare1); db.SaveChanges(); } } //删除体检信息之后才能删除内外科 db.ClientMdicalIformation.Remove(clientMdicalIformation); db.SaveChanges(); //删除外科体检信息 int SurgicalExaminationID = clientMdicalIformation.SurgicalExaminationID; SurgicalExamination surgicalExamination = db.SurgicalExamination.Find(SurgicalExaminationID); db.SurgicalExamination.Remove(surgicalExamination); db.SaveChanges(); //删除内科体检信息 int MedicalExaminationID = clientMdicalIformation.MedicalExaminationID; MedicalExamination medicalExamination = db.MedicalExamination.Find(MedicalExaminationID); db.MedicalExamination.Remove(medicalExamination); db.SaveChanges(); //删除预约记录 CustomerAppointment customerAppointment1 = db.CustomerAppointment.Find(item.CustomerAppointmentID); db.CustomerAppointment.Remove(customerAppointment1); db.SaveChanges(); } } } }
//修改户回访 public ActionResult EditCustomerReturnVisit(int id) { ViewBag.UserDoctorList = Bll.selectUserDoctorList(); ViewBag.ClientMdicalIformation = Bll.SelectClientMdicalIformation(); CustomerReturnVisit customerReturnVisit = Bll.SelectCustomerReturnVisit(id); return(View(customerReturnVisit)); }
//修改户回访 public ActionResult EditCustomerReturnVisit(CustomerReturnVisit customerReturnVisit) { Bll.EditCustomerReturnVisit(customerReturnVisit); return(RedirectToAction("CustomerReturnVisit")); }
//修改回访记录 public void EditCustomerReturnVisit(CustomerReturnVisit customerReturnVisit) { Dal.EditCustomerReturnVisit(customerReturnVisit); }
//增加回访记录 public void AddCustomerReturnVisit(CustomerReturnVisit customerReturnVisit) { Dal.AddCustomerReturnVisit(customerReturnVisit); }
//增加回访记录 public void AddCustomerReturnVisit(CustomerReturnVisit customerReturnVisit) { db.CustomerReturnVisit.Add(customerReturnVisit); db.SaveChanges(); }
//修改回访记录 public void EditCustomerReturnVisit(CustomerReturnVisit customerReturnVisit) { db.Entry(customerReturnVisit).State = System.Data.Entity.EntityState.Modified; db.SaveChanges(); }