public bool SaveRecord(string PatID, VisitData VData) { try { VisitData vdata = DataPreprocess(VData); PatBasicInfor pt = context.PatBasicInforSet.Find(PatID); pt.HeadacheFamilyMember = vdata.HFamilyMember;//个人信息相关保存 pt.OtherFamilyDisease = vdata.OFamilyDisease; ObjectMapper.CopyProperties(vdata.lifestyle, pt.Lifestyle); pt.PreviousDrug = vdata.PDrug; foreach (PreviousDrug pg in pt.PreviousDrug) { pg.PatBasicInforId = PatID; if (pg.DrugCategory != null && (pg.DayAmoutnPerM == null || pg.MonthTotalAmount == null)) { } } if (vdata.Similarfamily == "有") { pt.SimilarFamily = true; } else { pt.SimilarFamily = false; } pt.PreviousExam = vdata.PExam; if (vdata.visitrecord != null) { VisitRecord vr = new VisitRecord();//问诊记录信息保存 vr = vdata.visitrecord; vr.MedicationAdvice = vdata.MAdvice; vr.VisitDate = System.DateTime.Now; // vr.VisitDate = DateTime.Now.Date; vr.PrimaryHeadachaOverView = vdata.PHeadacheOverview; vr.GADQuestionaire = vdata.GADquestionaire; vr.DisabilityEvaluation = vdata.Disabilityevaluation; vr.PHQuestionaire = vdata.PHquestionaire; vr.SleepStatus = vdata.Sleepstatus; vr.PatBasicInforId = PatID; pt.VisitRecord.Add(vr); } context.SaveChanges(); return(true); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(false); } }
public bool UpdateRecord(string PatID, string VisitID, VisitData VData) { try { VisitData vdata = DataPreprocess(VData); PatBasicInfor pt = context.PatBasicInforSet.Find(PatID); pt.HeadacheFamilyMember = vdata.HFamilyMember;//个人信息相关保存 pt.OtherFamilyDisease = vdata.OFamilyDisease; ObjectMapper.CopyProperties(vdata.lifestyle, pt.Lifestyle); pt.PreviousDrug = vdata.PDrug; pt.PreviousExam = vdata.PExam; if (vdata.Similarfamily == "有") { pt.SimilarFamily = true; } else { pt.SimilarFamily = false; } if (vdata.visitrecord != null) { IEnumerable <VisitRecord> record = from p in context.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == PatID) && (p.Id == int.Parse(VisitID)) select p; VisitRecord vr = record.First(); ObjectMapper.CopyProperties(vdata.visitrecord, vr); ObjectMapper.CopyProperties(vdata.PHeadacheOverview, vr.PrimaryHeadachaOverView); ObjectMapper.CopyProperties(vdata.GADquestionaire, vr.GADQuestionaire); ObjectMapper.CopyProperties(vdata.PHquestionaire, vr.PHQuestionaire); ObjectMapper.CopyProperties(vdata.Disabilityevaluation, vr.DisabilityEvaluation); ObjectMapper.CopyProperties(vdata.Sleepstatus, vr.SleepStatus); vr.PrimaryHeadachaOverView.VisitRecord = vr; vr.GADQuestionaire.VisitRecord = vr; vr.PHQuestionaire.VisitRecord = vr; vr.DisabilityEvaluation.VisitRecord = vr; vr.SleepStatus.VisitRecord = vr; vr.PatBasicInforId = PatID; vr.VisitDate = DateTime.Now.Date; context.Entry(vr).State = System.Data.EntityState.Modified; } context.SaveChanges(); return(true); } catch (Exception e) { return(false); } }
public List <tableData> GetPatforView(List <PatBasicInfor> Patlist) { List <tableData> dataset = new List <tableData>(); var count = Patlist.Count; for (int i = 0; i < count; i++) { tableData rd = new tableData(); rd.Name = Patlist[i].Name; rd.Sex = Patlist[i].Sex; rd.Age = Patlist[i].Age; rd.ListID = Convert.ToString(i + 1); rd.PatBasicInforId = Patlist[i].Id; var record = from p in container.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == Patlist[i].Id) select p; var num = record.Count(); if (num != 0) { VisitRecord vt = record.First(); rd.Date = vt.VisitDate.ToString("yyyy-MM-dd"); if (vt.DiagnosisResult1 != null || vt.DiagnosisResult2 != null || vt.DiagnosisResult3 != null) { if (vt.DiagnosisResult1.Contains("慢性每日头痛")) { var style = vt.DiagnosisResult1.Split(new Char[] { ':' }); if (style.Length > 1) { rd.HeadacheStyle = style[1]; } else { rd.HeadacheStyle = vt.DiagnosisResult1 + vt.DiagnosisResult2 + vt.DiagnosisResult3; } } else { rd.HeadacheStyle = vt.DiagnosisResult1 + vt.DiagnosisResult2 + vt.DiagnosisResult3; } } } dataset.Add(rd); } return(dataset); }
public tableData GetPatinfo(PatBasicInfor pat) { tableData rd = new tableData(); rd.Name = pat.Name; rd.Sex = pat.Sex; rd.Age = pat.Age; //rd.ListID = Convert.ToString(i + 1); rd.PatBasicInforId = pat.Id; var record = from p in container.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == pat.Id) select p; var num = record.Count(); if (num != 0) { VisitRecord vt = record.First(); rd.Date = vt.VisitDate.ToString("yyyy-MM-dd"); if (vt.DiagnosisResult1 != null || vt.DiagnosisResult2 != null || vt.DiagnosisResult3 != null) { if (vt.DiagnosisResult1.Contains("慢性每日头痛")) { var style = vt.DiagnosisResult1.Split(new Char[] { ':' }); if (style.Length > 1) { rd.HeadacheStyle = style[1]; } else { rd.HeadacheStyle = vt.DiagnosisResult1 + vt.DiagnosisResult2 + vt.DiagnosisResult3; } } else { rd.HeadacheStyle = vt.DiagnosisResult1 + vt.DiagnosisResult2 + vt.DiagnosisResult3; } } } return(rd); }
public ReportData ViewDetail(string PatID, string RecordID) { ReportData rdata = new ReportData(); PatBasicInfor pt = context.PatBasicInforSet.Find(PatID); rdata.Name = pt.Name; rdata.Age = pt.Age; rdata.Sex = pt.Sex; rdata.Address = pt.Address; rdata.Education = pt.Education; rdata.Job = pt.Job; rdata.Phone = pt.Phone; rdata.Weight = pt.Weight; rdata.Height = pt.Height; if (pt.SimilarFamily != null) { if (pt.SimilarFamily == true) { rdata.SimilarFamily = true; } else { rdata.SimilarFamily = false; } } if (pt.Lifestyle != null) { rdata.patlifestyle.SmokeState = pt.Lifestyle.SmokeState; rdata.patlifestyle.SmokeYear = pt.Lifestyle.SmokeYear; rdata.patlifestyle.DrinkState = pt.Lifestyle.DrinkState; rdata.patlifestyle.DrinkYear = pt.Lifestyle.DrinkYear; rdata.patlifestyle.TeaPerDay = pt.Lifestyle.TeaPerDay; rdata.patlifestyle.CoffePerDay = pt.Lifestyle.CoffePerDay; rdata.patlifestyle.ExerciseOften = pt.Lifestyle.ExerciseOften; } //if (pt.SimilarFamily!=null) //{ // rdata.SimilarFamily = pt.SimilarFamily; //} foreach (HeadacheFamilyMember hfmember in pt.HeadacheFamilyMember) { rdata.Hfamilymember.Add(hfmember.Person); } foreach (OtherFamilyDisease ofdisease in pt.OtherFamilyDisease) { rdata.Ofamilydisease.Add(ofdisease.DiseaseName); } foreach (PreviousDrug pdrug in pt.PreviousDrug) { PDrug pd = new PDrug(); ObjectMapper.CopyProperties(pdrug, pd); rdata.previousdrug.Add(pd); } foreach (PreviousExam pexam in pt.PreviousExam) { Exam exam = new Exam(); ObjectMapper.CopyProperties(pexam, exam); rdata.previousexam.Add(exam); } if (RecordID != "") { var record = from p in context.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == PatID) && (p.Id == int.Parse(RecordID)) select p; VisitRecord vr = record.First(); if (vr != null) { rdata.VisitDate = vr.VisitDate; rdata.CDSSDiagnosis1 = vr.CDSSDiagnosis1; rdata.CDSSDiagnosis2 = vr.CDSSDiagnosis2; rdata.CDSSDiagnosis3 = vr.CDSSDiagnosis3; rdata.DiagnosisResult1 = vr.DiagnosisResult1; rdata.DiagnosisResult2 = vr.DiagnosisResult2; rdata.DiagnosisResult3 = vr.DiagnosisResult3; rdata.Prescription = vr.Prescription; rdata.ChiefComplaint = vr.ChiefComplaint; rdata.PreviousDiagnosis = vr.PreviousDiagnosis; rdata.PrescriptionNote = vr.PrescriptionNote; foreach (SecondaryHeadacheSymptom ss in vr.SecondaryHeadacheSymptom) { rdata.secondaryheadachesymptom.Add(ss.Symptom); } foreach (MedicationAdvice madvice in vr.MedicationAdvice) { HMedicine hmedicine = new HMedicine(); hmedicine.DrugApplication = madvice.DrugApplication; hmedicine.DrugCategory = madvice.DrugCategory; hmedicine.DrugName = madvice.DrugName; hmedicine.DrugDose = madvice.DrugDose; hmedicine.DrugDoseUnit = madvice.DrugDoseUnit; rdata.medicationadvice.Add(hmedicine); } if (vr.PrimaryHeadachaOverView != null) { rdata.headacheoverview.HeadacheType = vr.PrimaryHeadachaOverView.HeadacheType; rdata.headacheoverview.HeadacheDegree = vr.PrimaryHeadachaOverView.HeadacheDegree; rdata.headacheoverview.HeadcheTime = vr.PrimaryHeadachaOverView.HeadcheTime; rdata.headacheoverview.HeacheTimeUnit = vr.PrimaryHeadachaOverView.HeacheTimeUnit; rdata.headacheoverview.FrequencyPerMonth = vr.PrimaryHeadachaOverView.FrequencyPerMonth; rdata.headacheoverview.OnsetFixedPeriod = vr.PrimaryHeadachaOverView.OnsetFixedPeriod; rdata.headacheoverview.OnsetDate = vr.PrimaryHeadachaOverView.OnsetDate; rdata.headacheoverview.OnsetAmount = vr.PrimaryHeadachaOverView.OnsetAmount; rdata.headacheoverview.DailyAggravation = vr.PrimaryHeadachaOverView.DailyAggravation; rdata.headacheoverview.FirstOnsetContinue = vr.PrimaryHeadachaOverView.FirstOnsetContinue; foreach (HeadachePlace hp in vr.PrimaryHeadachaOverView.HeadachePlace) { string strPlace = hp.Position + hp.SpecificPlace; rdata.headacheplace.Add(strPlace); } foreach (HeadacheProdrome hprodrome in vr.PrimaryHeadachaOverView.HeadacheProdrome) { rdata.headacheprodrome.Add(hprodrome.Prodrome); } foreach (MitigatingFactors mfactors in vr.PrimaryHeadachaOverView.MitigatingFactors) { rdata.mitigatingfactors.Add(mfactors.FactorName); } foreach (HeadacheAccompany haccompay in vr.PrimaryHeadachaOverView.HeadacheAccompany) { rdata.headacheaccompany.Add(haccompay.Symptom); } foreach (PrecipitatingFactor pfactor in vr.PrimaryHeadachaOverView.PrecipitatingFactor) { Factor f = new Factor(); f.FName = pfactor.FactorName; f.FDetail = pfactor.FactorDetail; rdata.precipitatingfactor.Add(f); } foreach (PremonitorySymptom psymptom in vr.PrimaryHeadachaOverView.PremonitorySymptom) { rdata.premonitorsymptom.Add(psymptom.Symptom); } } //add 2013/7/23 if (vr.GADQuestionaire != null) { ObjectMapper.CopyProperties(vr.GADQuestionaire, rdata.gdaquestionaire); } if (vr.PHQuestionaire != null) { ObjectMapper.CopyProperties(vr.PHQuestionaire, rdata.phquestionaire); } if (vr.SleepStatus != null) { ObjectMapper.CopyProperties(vr.SleepStatus, rdata.sleepconditon); } if (vr.DisabilityEvaluation != null) { ObjectMapper.CopyProperties(vr.DisabilityEvaluation, rdata.disablityevaluation); } } } else { rdata.VisitDate = DateTime.Now.Date; rdata.headacheoverview.OnsetDate = DateTime.Now.Date; } return(rdata); }
public bool DeleteRecord(string PatID, string RecordID) { try { var record = from p in context.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == PatID) && (p.Id == int.Parse(RecordID)) select p; VisitRecord r = record.First(); if (r.PrimaryHeadachaOverView != null) { while (r.PrimaryHeadachaOverView.HeadachePlace.Count != 0) { context.HeadachePlaceSet.Remove(r.PrimaryHeadachaOverView.HeadachePlace.First()); } while (r.PrimaryHeadachaOverView.HeadacheAccompany.Count != 0) { context.HeadacheAccompanySet.Remove(r.PrimaryHeadachaOverView.HeadacheAccompany.First()); } while (r.PrimaryHeadachaOverView.HeadacheProdrome.Count != 0) { context.HeadacheProdromeSet.Remove(r.PrimaryHeadachaOverView.HeadacheProdrome.First()); } while (r.PrimaryHeadachaOverView.PrecipitatingFactor.Count != 0) { context.PrecipitatingFactorSet.Remove(r.PrimaryHeadachaOverView.PrecipitatingFactor.First()); } while (r.PrimaryHeadachaOverView.MitigatingFactors.Count != 0) { context.MitigatingFactorsSet.Remove(r.PrimaryHeadachaOverView.MitigatingFactors.First()); } context.PrimaryHeadacheOverViewSet.Remove(r.PrimaryHeadachaOverView); } while (r.MedicationAdvice.Count != 0) { context.MedicationAdviceSet.Remove(r.MedicationAdvice.FirstOrDefault()); } while (r.SecondaryHeadacheSymptom.Count != 0) { context.SecondaryHeadacheSymptomSet.Remove(r.SecondaryHeadacheSymptom.FirstOrDefault()); } //add 2013/7/23 if (r.GADQuestionaire != null) { context.GADQuestionaireSet.Remove(r.GADQuestionaire); } if (r.GADQuestionaire != null) { context.GADQuestionaireSet.Remove(r.GADQuestionaire); } if (r.PHQuestionaire != null) { context.PHQuestionaireSet.Remove(r.PHQuestionaire); } if (r.SleepStatus != null) { context.SleepStatusSet.Remove(r.SleepStatus); } if (r.DisabilityEvaluation != null) { context.DisabilityEvaluationSet.Remove(r.DisabilityEvaluation); } // visitrecord 内容删除 context.VisitRecordSet.Remove(r); context.SaveChanges(); return(true); } catch (System.Exception e) { return(false); } }
public bool SaveRecord(string PatID, VisitData VData) { try { VisitData vdata = DataPreprocess(VData); PatBasicInfor pt = context.PatBasicInforSet.Find(PatID); pt.HeadacheFamilyMember = vdata.HFamilyMember;//个人信息相关保存 pt.OtherFamilyDisease = vdata.OFamilyDisease; ObjectMapper.CopyProperties(vdata.lifestyle, pt.Lifestyle); pt.PreviousDrug = vdata.PDrug; if (vdata.Similarfamily == "有") { pt.SimilarFamily = true; } else { pt.SimilarFamily = false; } pt.PreviousExam = vdata.PExam; if (vdata.visitrecord != null) { VisitRecord vr = new VisitRecord();//问诊记录信息保存 vr = vdata.visitrecord; vr.VisitDate = DateTime.Now.Date; vr.PrimaryHeadachaOverView = vdata.PHeadacheOverview; vr.PatBasicInforId = PatID; pt.VisitRecord.Add(vr); } context.SaveChanges(); return true; } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return false; } }
public bool DeleteRecord(string PatID, string RecordID) { try { var record = from p in context.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == PatID) && (p.Id == int.Parse(RecordID)) select p; VisitRecord r = record.First(); if (r.PrimaryHeadachaOverView != null) { while (r.PrimaryHeadachaOverView.HeadachePlace.Count != 0) { context.HeadachePlaceSet.Remove(r.PrimaryHeadachaOverView.HeadachePlace.First()); } while (r.PrimaryHeadachaOverView.HeadacheAccompany.Count != 0) { context.HeadacheAccompanySet.Remove(r.PrimaryHeadachaOverView.HeadacheAccompany.First()); } while (r.PrimaryHeadachaOverView.HeadacheProdrome.Count != 0) { context.HeadacheProdromeSet.Remove(r.PrimaryHeadachaOverView.HeadacheProdrome.First()); } while (r.PrimaryHeadachaOverView.PrecipitatingFactor.Count != 0) { context.PrecipitatingFactorSet.Remove(r.PrimaryHeadachaOverView.PrecipitatingFactor.First()); } while (r.PrimaryHeadachaOverView.MitigatingFactors.Count != 0) { context.MitigatingFactorsSet.Remove(r.PrimaryHeadachaOverView.MitigatingFactors.First()); } while (r.PrimaryHeadachaOverView.PremonitorySymptom.Count != 0) { context.PremonitorySymptom集.Remove(r.PrimaryHeadachaOverView.PremonitorySymptom.First()); } context.PrimaryHeadacheOverViewSet.Remove(r.PrimaryHeadachaOverView); } while (r.MedicationAdvice.Count != 0) { context.MedicationAdviceSet.Remove(r.MedicationAdvice.FirstOrDefault()); } while (r.SecondaryHeadacheSymptom.Count != 0) { context.SecondaryHeadacheSymptomSet.Remove(r.SecondaryHeadacheSymptom.FirstOrDefault()); } //add 2013/7/23 if (r.GADQuestionaire != null) { context.GADQuestionaireSet.Remove(r.GADQuestionaire); } if (r.GADQuestionaire != null) { context.GADQuestionaireSet.Remove(r.GADQuestionaire); } if (r.PHQuestionaire != null) { context.PHQuestionaireSet.Remove(r.PHQuestionaire); } if (r.SleepStatus != null) { context.SleepStatusSet.Remove(r.SleepStatus); } if (r.DisabilityEvaluation != null) { context.DisabilityEvaluationSet.Remove(r.DisabilityEvaluation); } // visitrecord 内容删除 context.VisitRecordSet.Remove(r); context.SaveChanges(); return(true); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(false); } }
public bool UpdateRecord(string PatID, string VisitID, VisitData VData) { try { VisitData vdata = DataPreprocess(VData); PatBasicInfor pt = context.PatBasicInforSet.Find(PatID); pt.HeadacheFamilyMember = vdata.HFamilyMember;//个人信息相关保存 pt.OtherFamilyDisease = vdata.OFamilyDisease; ObjectMapper.CopyProperties(vdata.lifestyle, pt.Lifestyle); pt.PreviousDrug = vdata.PDrug;//需要看一下,这里的Pdrug有没有数据 foreach (PreviousDrug pg in pt.PreviousDrug) { pg.PatBasicInforId = PatID; } pt.PreviousExam = vdata.PExam; if (vdata.Similarfamily == "有") { pt.SimilarFamily = true; } else { pt.SimilarFamily = false; } if (vdata.visitrecord != null) { IEnumerable <VisitRecord> record = from p in context.VisitRecordSet.ToList() where (p.PatBasicInfor.Id == PatID) && (p.Id == int.Parse(VisitID)) select p; VisitRecord vr = record.First(); ObjectMapper.CopyProperties(vdata.visitrecord, vr); ObjectMapper.CopyProperties(vdata.PHeadacheOverview, vr.PrimaryHeadachaOverView); ObjectMapper.CopyProperties(vdata.GADquestionaire, vr.GADQuestionaire); ObjectMapper.CopyProperties(vdata.PHquestionaire, vr.PHQuestionaire); ObjectMapper.CopyProperties(vdata.Disabilityevaluation, vr.DisabilityEvaluation); ObjectMapper.CopyProperties(vdata.Sleepstatus, vr.SleepStatus); vr.PrimaryHeadachaOverView.VisitRecord = vr; vr.GADQuestionaire.VisitRecord = vr; vr.PHQuestionaire.VisitRecord = vr; vr.DisabilityEvaluation.VisitRecord = vr; vr.SleepStatus.VisitRecord = vr; vr.PatBasicInforId = PatID; vr.VisitDate = System.DateTime.Now; //vr.VisitDate = DateTime.Now.Date; //System.DateTime.Now.ToString("G"); context.Entry(vr).State = System.Data.EntityState.Modified; } context.SaveChanges(); return(true); } catch (DbEntityValidationException dbEx) { foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { Trace.TraceInformation("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage); } } return(false); } //catch (Exception e) //{ // return false; //} }