//删除预约信息
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();
}
}
}
}
//利用体检表id查到对应外科并返回
public SurgicalExamination SelectSurgical(int id)
{
ClientMdicalIformation clientMdicalIformation = db.ClientMdicalIformation.Find(id);
var SurgicalExaminationID = clientMdicalIformation.SurgicalExaminationID;
SurgicalExamination surgicalExamination = db.SurgicalExamination.Find(SurgicalExaminationID);
return(surgicalExamination);
}
//监控内外科表和体检信息表的变化并且保存
public void Monitor(ClientMdicalIformation clientMdicalIformation, SurgicalExamination surgicalExamination, MedicalExamination medicalExamination)
{
db.Entry(clientMdicalIformation).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Entry(surgicalExamination).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
db.Entry(medicalExamination).State = System.Data.Entity.EntityState.Modified;
db.SaveChanges();
}
//删除客户体检信息，外科也一并删除
public void DeleteSurgicalExamination(int id)
{
ClientMdicalIformation clientMdicalIformation = db.ClientMdicalIformation.Find(id);
var SurgicalExamination = clientMdicalIformation.SurgicalExaminationID;
SurgicalExamination surgicalExamination = db.SurgicalExamination.Find(SurgicalExamination);
db.SurgicalExamination.Remove(surgicalExamination);
db.SaveChanges();
}
//新增外科信息
public int AddSurgicalExamination(SurgicalExamination surgicalExamination)
{
db.SurgicalExamination.Add(surgicalExamination);
db.SaveChanges();
//利用方法查询到外科表的最后一条信息（上面新增的那条）
SurgicalExamination surgicalExamination1 = db.SurgicalExamination.ToList().LastOrDefault();
//拿到新增那条外科信息返回id
int SurgicalExaminationID = surgicalExamination1.SurgicalExaminationID;
return(SurgicalExaminationID);
}
//监控内外科表和体检信息表的变化并且保存
public void Monitor(ClientMdicalIformation clientMdicalIformation, SurgicalExamination surgicalExamination, MedicalExamination medicalExamination)
{
Dal.Monitor(clientMdicalIformation, surgicalExamination, medicalExamination);
}
//新增外科信息
public int AddSurgicalExamination(SurgicalExamination surgicalExamination)
{
return(Dal.AddSurgicalExamination(surgicalExamination));
}
public ActionResult AddClientMdicalIfor(ClientMdicalIformation clientMdicalIformation, SurgicalExamination surgicalExamination, MedicalExamination medicalExamination)
{
//新建外科，拿到新建信息的id
int SurgicalExaminationID = Bll.AddSurgicalExamination(surgicalExamination);
//新建内科，拿到新建信息的id
int MedicalExaminationID = Bll.AddMedicalExamination(medicalExamination);
//以上拿到的三个id都是体检信息表的外键字段，将他们放入体检信息
clientMdicalIformation.SurgicalExaminationID = SurgicalExaminationID;
clientMdicalIformation.MedicalExaminationID = MedicalExaminationID;
//新建体检信息
Bll.AddMdicalIformation(clientMdicalIformation);
return(RedirectToAction("ClientMdical"));
}
public ActionResult ClientMdicalIformation(ClientMdicalIformation clientMdicalIformation, SurgicalExamination surgicalExamination, MedicalExamination medicalExamination)
{
Bll.Monitor(clientMdicalIformation, surgicalExamination, medicalExamination);
return(RedirectToAction("ClientMdical"));
}
