private void FindMismatch(TestAppointedMedication ta) { if (this.document.AnatomicTherapeuticChemicalClassification != ta.document.AnatomicTherapeuticChemicalClassification) { Global.errors3.Add("несовпадение AnatomicTherapeuticChemicalClassification TestAppointedMedication"); } if (Global.GetLength(this.courseDose) != Global.GetLength(ta.courseDose)) { Global.errors3.Add("несовпадение длины CourseDose TestAppointedMedication"); } if (Global.GetLength(this.dayDose) != Global.GetLength(ta.dayDose)) { Global.errors3.Add("несовпадение длины DayDose TestAppointedMedication"); } if (this.document.DaysCount != ta.document.DaysCount) { Global.errors3.Add("несовпадение DaysCount TestAppointedMedication"); } if (this.document.IssuedDate != ta.document.IssuedDate) { Global.errors3.Add("несовпадение IssuedDate TestAppointedMedication"); } if (this.document.MedicineIssueType != ta.document.MedicineIssueType) { Global.errors3.Add("несовпадение MedicineIssueType TestAppointedMedication"); } if (this.document.MedicineName != ta.document.MedicineName) { Global.errors3.Add("несовпадение MedicineName TestAppointedMedication"); } if (this.document.MedicineType != ta.document.MedicineType) { Global.errors3.Add("несовпадение MedicineType TestAppointedMedication"); } if (this.document.MedicineUseWay != ta.document.MedicineUseWay) { Global.errors3.Add("несовпадение MedicineUseWay TestAppointedMedication"); } if (this.document.Number != ta.document.Number) { Global.errors3.Add("несовпадение Number TestAppointedMedication"); } if (Global.GetLength(this.oneTimeDose) != Global.GetLength(ta.oneTimeDose)) { Global.errors3.Add("несовпадение длины OneTimeDose TestAppointedMedication"); } if (this.document.Seria != ta.document.Seria) { Global.errors3.Add("несовпадение Seria TestAppointedMedication"); } if (Global.GetLength(this.doctor) != Global.GetLength(ta.doctor)) { Global.errors3.Add("несовпадение длины doctor TestAppointedMedication"); } }
public override bool Equals(Object obj) { TestAppointedMedication p = obj as TestAppointedMedication; if ((object)p == null) { return(false); } if (this.document == p.document) { return(true); } if ((this.document == null) || (p.document == null)) { return(false); } if ((this.document.AnatomicTherapeuticChemicalClassification == p.document.AnatomicTherapeuticChemicalClassification) && (Global.IsEqual(this.courseDose, p.courseDose)) && (Global.IsEqual(this.dayDose, p.dayDose)) && (this.document.DaysCount == p.document.DaysCount) && (this.document.IssuedDate == p.document.IssuedDate) && (this.document.MedicineIssueType == p.document.MedicineIssueType) && (this.document.MedicineName == p.document.MedicineName) && (this.document.MedicineType == p.document.MedicineType) && (this.document.MedicineUseWay == p.document.MedicineUseWay) && (this.document.Number == p.document.Number) && (Global.IsEqual(this.oneTimeDose, p.oneTimeDose)) && (this.document.Seria == p.document.Seria) && Global.IsEqual(this.doctor, p.doctor)) { return(true); } else { this.FindMismatch(p); Global.errors3.Add("несовпадение TestAppointedMedication"); return(false); } }
public static TestMasterCase BuildTestMasterCase(string guid, string idlpu, string patientIdmis, string mis = "") { if ((guid != string.Empty) && (idlpu != string.Empty) && (patientIdmis != string.Empty)) { string patientId = TestPerson.GetPersonId(guid, idlpu, patientIdmis); string caseId = TestCaseBase.GetCaseId(guid, idlpu, mis, patientId); if (caseId != null) { TestMasterCase mcase = new TestMasterCase(); mcase.caseBase = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idlpu, mis, patientId); List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(caseId, idlpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { mcase.defaultStep = i; } } if (!Global.IsEqual(mcase.defaultStep, null)) { mcase.records = new List <TestMedRecord>(); List <TestService> serv = TestService.BuildServiseFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(serv, null)) { mcase.records.AddRange(serv); } TestTfomsInfo forms = TestTfomsInfo.BuildTfomsInfoFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(forms, null)) { mcase.records.Add(forms); } TestDeathInfo tdi = TestDeathInfo.BuildDeathInfoFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(tdi, null)) { mcase.records.Add(tdi); } List <TestDiagnosis> td = TestDiagnosis.BuildDiagnosisFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(td, null)) { mcase.records.AddRange(td); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(acdm, null)) { mcase.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(trl, null)) { mcase.records.AddRange(trl); } List <TestSickList> tsl = TestSickList.BuildSickListFromDataBaseData(mcase.defaultStep.idStep, patientId); if (!Global.IsEqual(tsl, null)) { mcase.records.AddRange(tsl); } TestDischargeSummary tds = TestDischargeSummary.BuildSickListFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(tds, null)) { mcase.records.Add(tds); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(tlr, null)) { mcase.records.AddRange(tlr); } TestConsultNote tcn = TestConsultNote.BuildSickListFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(tcn, null)) { mcase.records.Add(tcn); } TestDispensaryOne d1 = TestDispensaryOne.BuildSickListFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(d1, null)) { mcase.records.Add(d1); } List <TestAppointedMedication> ap = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(mcase.defaultStep.idStep); if (!Global.IsEqual(ap, null)) { mcase.records.AddRange(ap); } List <TestForm027U> form = TestForm027U.BuildForm027UFromDataBaseData(mcase.defaultStep.idStep); if (!Global.IsEqual(form, null)) { mcase.records.AddRange(form); } } } return(mcase); } } return(null); }
public bool CheckDocumentInCase(MedRecord i, string idLpu) { TestMedRecord doc = null; Service serv = i as Service; if (serv != null) { doc = new TestService(serv); } TfomsInfo tfi = i as TfomsInfo; if (tfi != null) { doc = new TestTfomsInfo(tfi); } DeathInfo di = i as DeathInfo; if (di != null) { doc = new TestDeathInfo(di); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestDiagnosis(diag, idLpu); } ClinicMainDiagnosis cmd = i as ClinicMainDiagnosis; if ((cmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestClinicMainDiagnosis(cmd, idLpu); } AnatomopathologicalClinicMainDiagnosis acmd = i as AnatomopathologicalClinicMainDiagnosis; if ((acmd != null) && (cmd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { doc = new TestClinicMainDiagnosis(acmd, idLpu); } Referral r = i as Referral; if (r != null) { doc = new TestReferral(r, idLpu); } SickList sl = i as SickList; if (sl != null) { doc = new TestSickList(sl, idLpu); } DischargeSummary ds = i as DischargeSummary; if (ds != null) { doc = new TestDischargeSummary(ds, idLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { doc = new TestLaboratoryReport(lr, idLpu); } ConsultNote cn = i as ConsultNote; if (cn != null) { doc = new TestConsultNote(cn, idLpu); } DispensaryOne d1 = i as DispensaryOne; if ((d1 != null) && (caseBase.idCaseType == dispensaryId)) { doc = new TestDispensaryOne(d1, idLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { doc = new TestAppointedMedication(ap, idLpu); } Form027U form = i as Form027U; if (form != null) { doc = new TestForm027U(form, idLpu); } if (Global.IsEqual(doc, null)) { Global.errors1.Add("Документ не найден"); return(true); } foreach (TestMedRecord document in this.medRecords) { if (Global.IsEqual(doc, document)) { return(true); } } return(false); }
public void ChangeUpdateAmbCase(string guid, CaseAmb ca) { GUID = guid.ToLower(); if (ca != null) { this.caseAmb.IsActive = ca.IsActive; if (ca.IdAmbResult != 0) { this.caseAmb.IdAmbResult = ca.IdAmbResult; } if (ca.IdCasePurpose != 0) { this.caseAmb.IdCasePurpose = ca.IdCasePurpose; } caseBase.UpdateCaseBase(guid, ca); if (ca.MedRecords != null) { List <TestMedRecord> newMedRecords = new List <TestMedRecord>(); TestTfomsInfo tfi = null; TestClinicMainDiagnosis cmd = null; TestDischargeSummary ds = null; TestConsultNote cn = null; TestDispensaryOne d1 = null; foreach (object i in ca.MedRecords) { Service ser = i as Service; if (ser != null) { newMedRecords.Add(new TestService(ser, ca.IdLpu)); } TfomsInfo tf = i as TfomsInfo; if (tf != null) { tfi = new TestTfomsInfo(tf); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { newMedRecords.Add(new TestDiagnosis(diag, ca.IdLpu)); } ClinicMainDiagnosis cm = i as ClinicMainDiagnosis; if ((cm != null) && (cm.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(cm, ca.IdLpu); } Referral r = i as Referral; if (r != null) { newMedRecords.Add(new TestReferral(r, ca.IdLpu)); } SickList sl = i as SickList; if (sl != null) { newMedRecords.Add(new TestSickList(sl, ca.IdLpu)); } DischargeSummary pds = i as DischargeSummary; if (pds != null) { ds = new TestDischargeSummary(pds, ca.IdLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { newMedRecords.Add(new TestLaboratoryReport(lr, ca.IdLpu)); } ConsultNote pcn = i as ConsultNote; if (pcn != null) { cn = new TestConsultNote(pcn, ca.IdLpu); } DispensaryOne d = i as DispensaryOne; if (d != null) { d1 = new TestDispensaryOne(d, ca.IdLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { newMedRecords.Add(new TestAppointedMedication(ap, ca.IdLpu)); } } if (Global.GetLength(this.medRecords) != 0) { foreach (object i in this.medRecords) { TestService ser = i as TestService; if (!Global.IsEqual(ser, null)) { newMedRecords.Add(ser); } TestTfomsInfo tf = i as TestTfomsInfo; if (!Global.IsEqual(tfi, null) && !Global.IsEqual(tf, null)) { newMedRecords.Add(tf); } else if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } TestDiagnosis diag = i as TestDiagnosis; if (!Global.IsEqual(diag, null)) { newMedRecords.Add(diag); } TestClinicMainDiagnosis cm = i as TestClinicMainDiagnosis; if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } else if (!Global.IsEqual(cm, null)) { newMedRecords.Add(cm); } TestReferral r = i as TestReferral; if (!Global.IsEqual(r, null)) { newMedRecords.Add(r); } TestSickList sl = i as TestSickList; if (!Global.IsEqual(sl, null)) { newMedRecords.Add(sl); } TestDischargeSummary pds = i as TestDischargeSummary; if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } else if (!Global.IsEqual(pds, null)) { newMedRecords.Add(pds); } TestLaboratoryReport lr = i as TestLaboratoryReport; if (!Global.IsEqual(lr, null)) { newMedRecords.Add(lr); } TestConsultNote pcn = i as TestConsultNote; if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } else if (!Global.IsEqual(pcn, null)) { newMedRecords.Add(pcn); } TestDispensaryOne d = i as TestDispensaryOne; if (!Global.IsEqual(d1, null)) { newMedRecords.Add(d1); } else if (!Global.IsEqual(d, null)) { newMedRecords.Add(d); } TestAppointedMedication ap = i as TestAppointedMedication; if (!Global.IsEqual(ap, null)) { newMedRecords.Add(ap); } } } else { if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } } this.records = newMedRecords; } } }
static public TestAmbCase BuildAmbCaseFromDataBaseData(string guid, string idlpu, string mis, string patientId) { if ((guid != string.Empty) && (idlpu != string.Empty) && (mis != string.Empty) && (patientId != string.Empty)) { string caseId = TestCaseBase.GetCaseId(guid, idlpu, mis, patientId); if (caseId != null) { CaseAmb ca = new CaseAmb(); using (SqlConnection connection = Global.GetSqlConnection()) { string findCase = "SELECT TOP(1) * FROM AmbCase WHERE IdCase = '" + caseId + "'"; SqlCommand caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { if (caseReader["IdCasePurpose"].ToString() != "") { ca.IdCasePurpose = Convert.ToByte(caseReader["IdCasePurpose"]); } if (caseReader["IdAmbResult"].ToString() != "") { ca.IdAmbResult = Convert.ToByte(caseReader["IdAmbResult"]); } if (caseReader["IsActive"].ToString() != "") { ca.IsActive = Convert.ToBoolean(caseReader["IsActive"]); } TestAmbCase ambcase = new TestAmbCase(guid, ca); ambcase.caseBase = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idlpu, mis, patientId); ambcase.ambSteps = TestAmbStep.BuildAmbTestStepsFromDataBase(caseId, ca.IdLpu); List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(caseId, ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.step.IdStepMis, null)) { ambcase.defaultStep = i; } } if (!Global.IsEqual(ambcase.defaultStep, null)) { ambcase.records = new List <TestMedRecord>(); List <TestService> ser = TestService.BuildServiseFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(ser, null)) { ambcase.records.AddRange(ser); } TestTfomsInfo forms = TestTfomsInfo.BuildTfomsInfoFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(forms, null)) { ambcase.records.Add(forms); } TestDeathInfo tdi = TestDeathInfo.BuildDeathInfoFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(tdi, null)) { ambcase.records.Add(tdi); } List <TestDiagnosis> td = TestDiagnosis.BuildDiagnosisFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(td, null)) { ambcase.records.AddRange(td); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(acdm, null)) { ambcase.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(trl, null)) { ambcase.records.AddRange(trl); } List <TestSickList> tsl = TestSickList.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep, patientId); if (!Global.IsEqual(tsl, null)) { ambcase.records.AddRange(tsl); } TestDischargeSummary tds = TestDischargeSummary.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(tds, null)) { ambcase.records.Add(tds); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(tlr, null)) { ambcase.records.AddRange(tlr); } TestConsultNote tcn = TestConsultNote.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(tcn, null)) { ambcase.records.Add(tcn); } TestDispensaryOne d1 = TestDispensaryOne.BuildSickListFromDataBaseData(ambcase.defaultStep.idStep); if (!Global.IsEqual(d1, null)) { ambcase.records.Add(d1); } List <TestAppointedMedication> ap = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(ambcase.defaultStep.idStep); if (!Global.IsEqual(ap, null)) { ambcase.records.AddRange(ap); } if (ambcase.records.Count == 0) { ambcase.records = null; } } } return(ambcase); } } } } } return(null); }
static public List <TestAmbStep> BuildAmbTestStepsFromDataBase(string idCase, string caseLpu) { List <TestAmbStep> ambSteps = new List <TestAmbStep>(); if (idCase != string.Empty) { List <TestStepBase> steps = TestStepBase.BuildTestStepsFromDataBase(idCase, caseLpu); using (SqlConnection connection = Global.GetSqlConnection()) { foreach (TestStepBase i in steps) { string findSteps = "SELECT * FROM AmbStep WHERE IdStep = '" + i.idStep + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepAmb sa = new StepAmb(); if (stepsReader["IdVisitPlace"].ToString() != "") { sa.IdVisitPlace = Convert.ToByte(stepsReader["IdVisitPlace"]); } else { sa.IdVisitPlace = 0; } if (stepsReader["IdVisitPurpose"].ToString() != "") { sa.IdVisitPurpose = Convert.ToByte(stepsReader["IdVisitPurpose"]); } else { sa.IdVisitPurpose = 0; } TestAmbStep st = new TestAmbStep(sa, caseLpu); st.step = i; st.records = new List <TestMedRecord>(); List <TestService> s = TestService.BuildServiseFromDataBaseData(i.idStep); if (!Global.IsEqual(s, null)) { st.records.AddRange(s); } List <TestAppointedMedication> am = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(i.idStep); if (!Global.IsEqual(am, null)) { st.records.AddRange(am); } List <TestDiagnosis> diag = TestDiagnosis.BuildDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(diag, null)) { st.records.AddRange(diag); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(acdm, null)) { st.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(i.idStep); if (!Global.IsEqual(trl, null)) { st.records.AddRange(trl); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(i.idStep); if (!Global.IsEqual(tlr, null)) { st.records.AddRange(tlr); } if (st.records.Count == 0) { st.records = null; } ambSteps.Add(st); } } } } } if (ambSteps.Count != 0) { return(ambSteps); } else { return(null); } }
static public List <TestStatStep> BuildStatStepsFromDataBase(string idCase, string caseLpu) { List <TestStatStep> statSteps = new List <TestStatStep>(); if (idCase != string.Empty) { List <TestStepBase> steps = TestStepBase.BuildTestStepsFromDataBase(idCase, caseLpu); using (SqlConnection connection = Global.GetSqlConnection()) { foreach (TestStepBase i in steps) { string findSteps = "SELECT * FROM HospStep WHERE IdStep = '" + i.idStep + "'"; SqlCommand stepsCommand = new SqlCommand(findSteps, connection); using (SqlDataReader stepsReader = stepsCommand.ExecuteReader()) { while (stepsReader.Read()) { StepStat sa = new StepStat(); if (stepsReader["BedNo"].ToString() != "") { sa.BedNumber = Convert.ToString(stepsReader["BedNo"]); } else { sa.BedNumber = null; } if (stepsReader["IdBedProfile"].ToString() != "") { sa.BedProfile = Convert.ToByte(stepsReader["IdBedProfile"]); } else { sa.BedProfile = 0; } if (stepsReader["DaySpend"].ToString() != "") { sa.DaySpend = Convert.ToUInt16(stepsReader["DaySpend"]); } else { sa.DaySpend = 0; } if (stepsReader["HospitalDepartment"].ToString() != "") { sa.HospitalDepartmentName = Convert.ToString(stepsReader["HospitalDepartment"]); } else { sa.HospitalDepartmentName = null; } if (stepsReader["IdHospitalDepartment"].ToString() != "") { sa.IdHospitalDepartment = Convert.ToString(stepsReader["IdHospitalDepartment"]); } else { sa.IdHospitalDepartment = null; } if (stepsReader["IdRegimenType"].ToString() != "") { sa.IdRegimen = Convert.ToByte(stepsReader["IdRegimenType"]); } else { sa.IdRegimen = 0; } if (stepsReader["WardNumber"].ToString() != "") { sa.WardNumber = Convert.ToString(stepsReader["WardNumber"]); } else { sa.WardNumber = null; } TestStatStep st = new TestStatStep(sa, caseLpu); st.step = i; st.records = new List <TestMedRecord>(); List <TestService> s = TestService.BuildServiseFromDataBaseData(i.idStep); if (!Global.IsEqual(s, null)) { st.records.AddRange(s); } List <TestAppointedMedication> am = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(i.idStep); if (!Global.IsEqual(am, null)) { st.records.AddRange(am); } List <TestDiagnosis> diag = TestDiagnosis.BuildDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(diag, null)) { st.records.AddRange(diag); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(i.idStep); if (!Global.IsEqual(acdm, null)) { st.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(i.idStep); if (!Global.IsEqual(trl, null)) { st.records.AddRange(trl); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(i.idStep); if (!Global.IsEqual(tlr, null)) { st.records.AddRange(tlr); } if (st.records.Count == 0) { st.records = null; } statSteps.Add(st); } } } } } if (statSteps.Count != 0) { return(statSteps); } else { return(null); } }
static public List <TestAppointedMedication> BuildAppointedMedicationFromDataBaseDate(string idStep) { List <TestAppointedMedication> amList = new List <TestAppointedMedication>(); if (idStep != "") { using (SqlConnection connection = Global.GetSqlConnection()) { string findAM = "SELECT * FROM PrescribedMedication WHERE PrescribedMedication.IdStep = '" + idStep + "'"; SqlCommand AMcommand = new SqlCommand(findAM, connection); using (SqlDataReader AMReader = AMcommand.ExecuteReader()) { while (AMReader.Read()) { AppointedMedication a = new AppointedMedication(); if (AMReader["PrescriptionNo"].ToString() != "") { a.Number = AMReader["PrescriptionNo"].ToString(); } if (AMReader["PrescriptionSeries"].ToString() != "") { a.Seria = AMReader["PrescriptionSeries"].ToString(); } if (AMReader["IdRMedicineIssueType"].ToString() != "") { a.MedicineIssueType = Convert.ToString(AMReader["IdRMedicineIssueType"]); } if (AMReader["MedicineIssueTypeDate"].ToString() != "") { a.IssuedDate = Convert.ToDateTime(AMReader["MedicineIssueTypeDate"]); } if (AMReader["IdRMedicineType"].ToString() != "") { a.MedicineType = Convert.ToUInt16(AMReader["IdRMedicineType"]); } if (AMReader["IdRAnatomicTherapeuticChemicalClassification"].ToString() != "") { using (SqlConnection connection2 = Global.GetSqlConnection()) { string findCode = "SELECT * FROM nsi.RAnatomicTherapeuticChemicalClassification WHERE IdRAnatomicTherapeuticChemicalClassification = '" + AMReader["IdRAnatomicTherapeuticChemicalClassification"].ToString() + "'"; SqlCommand codeCommand = new SqlCommand(findCode, connection2); using (SqlDataReader codeReader = codeCommand.ExecuteReader()) { while (codeReader.Read()) { if (codeReader["code"].ToString() != "") { a.AnatomicTherapeuticChemicalClassification = Convert.ToString(codeReader["code"]); } } } } } if (AMReader["IdRMedicineUseWay"].ToString() != "") { a.MedicineUseWay = Convert.ToByte(AMReader["IdRMedicineUseWay"]); } if (AMReader["TreatmentDays"].ToString() != "") { a.DaysCount = Convert.ToUInt16(AMReader["TreatmentDays"]); } if (AMReader["MedecineName"].ToString() != "") { a.MedicineName = AMReader["MedecineName"].ToString(); } TestAppointedMedication ta = new TestAppointedMedication(a); if (AMReader["CourseDose"].ToString() != "") { ta.courseDose = TestQuantity.BuildQuantityFromDataBaseData(AMReader["CourseDose"].ToString()); } if (AMReader["DayDose"].ToString() != "") { ta.dayDose = TestQuantity.BuildQuantityFromDataBaseData(AMReader["DayDose"].ToString()); } if (AMReader["SingleDose"].ToString() != "") { ta.oneTimeDose = TestQuantity.BuildQuantityFromDataBaseData(AMReader["SingleDose"].ToString()); } if (AMReader["IdDoctor"].ToString() != "") { ta.doctor = TestDoctor.BuildTestDoctorFromDataBase(AMReader["IdDoctor"].ToString()); } amList.Add(ta); } } } } if (amList.Count == 0) { return(null); } else { return(amList); } }
public void ChangeUpdateStatCase(string guid, CaseStat cs) { GUID = guid.ToLower(); if (cs != null) { if (cs.DeliveryCode != null) { this.caseStat.DeliveryCode = cs.DeliveryCode; } if (cs.IdIntoxicationType != 0) { this.caseStat.IdIntoxicationType = cs.IdIntoxicationType; } if (cs.IdPatientConditionOnAdmission != 0) { this.caseStat.IdPatientConditionOnAdmission = cs.IdPatientConditionOnAdmission; } if (cs.IdTypeFromDiseaseStart != 0) { this.caseStat.IdTypeFromDiseaseStart = cs.IdTypeFromDiseaseStart; } if (cs.IdTransportIntern != 0) { this.caseStat.IdTransportIntern = cs.IdTransportIntern; } if (cs.IdHospChannel != 0) { this.caseStat.IdHospChannel = cs.IdHospChannel; } this.caseStat.RW1Mark = cs.RW1Mark; this.caseStat.AIDSMark = cs.AIDSMark; caseBase.UpdateCaseBase(guid, cs); if (cs.MedRecords != null) { List <TestMedRecord> newMedRecords = new List <TestMedRecord>(); TestTfomsInfo tfi = null; TestClinicMainDiagnosis cmd = null; TestDischargeSummary ds = null; TestConsultNote cn = null; TestDeathInfo tdi = null; foreach (object i in cs.MedRecords) { Service ser = i as Service; if (ser != null) { newMedRecords.Add(new TestService(ser, cs.IdLpu)); } TfomsInfo tf = i as TfomsInfo; if (tf != null) { tfi = new TestTfomsInfo(tf); } Diagnosis diag = i as Diagnosis; if ((diag != null) && (diag.DiagnosisInfo.IdDiagnosisType != TestDiagnosis.IdClinicMainDiagnosis)) { newMedRecords.Add(new TestDiagnosis(diag, cs.IdLpu)); } ClinicMainDiagnosis cd = i as ClinicMainDiagnosis; if ((cd != null) && (cs.HospResult != IdDeath) && (cd.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(cd, cs.IdLpu); } ClinicMainDiagnosis ca = i as ClinicMainDiagnosis; if ((ca != null) && (cs.HospResult == IdDeath) && (ca.DiagnosisInfo.IdDiagnosisType == TestDiagnosis.IdClinicMainDiagnosis)) { cmd = new TestClinicMainDiagnosis(ca, cs.IdLpu); } Referral r = i as Referral; if (r != null) { newMedRecords.Add(new TestReferral(r, cs.IdLpu)); } SickList sl = i as SickList; if (sl != null) { newMedRecords.Add(new TestSickList(sl, cs.IdLpu)); } DischargeSummary pds = i as DischargeSummary; if (pds != null) { ds = new TestDischargeSummary(pds, cs.IdLpu); } LaboratoryReport lr = i as LaboratoryReport; if (lr != null) { newMedRecords.Add(new TestLaboratoryReport(lr, cs.IdLpu)); } ConsultNote pcn = i as ConsultNote; if (pcn != null) { cn = new TestConsultNote(pcn, cs.IdLpu); } AppointedMedication ap = i as AppointedMedication; if (ap != null) { newMedRecords.Add(new TestAppointedMedication(ap, cs.IdLpu)); } DeathInfo di = i as DeathInfo; if (di != null) { tdi = new TestDeathInfo(di); } Form027U form = i as Form027U; if (form != null) { newMedRecords.Add(new TestForm027U(form, cs.IdLpu)); //? } } if (Global.GetLength(this.medRecords) != 0) { foreach (object i in this.medRecords) { TestService ser = i as TestService; if (!Global.IsEqual(ser, null)) { newMedRecords.Add(ser); } TestTfomsInfo tf = i as TestTfomsInfo; if (!Global.IsEqual(tfi, null) && (!Global.IsEqual(tf, null))) { newMedRecords.Add(tf); } else if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } TestDiagnosis diag = i as TestDiagnosis; if (!Global.IsEqual(diag, null)) { newMedRecords.Add(diag); } TestClinicMainDiagnosis cm = i as TestClinicMainDiagnosis; if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } else if (!Global.IsEqual(cm, null)) { newMedRecords.Add(cm); } TestReferral r = i as TestReferral; if (!Global.IsEqual(r, null)) { newMedRecords.Add(r); } TestSickList sl = i as TestSickList; if (!Global.IsEqual(sl, null)) { newMedRecords.Add(sl); } TestDischargeSummary pds = i as TestDischargeSummary; if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } else if (!Global.IsEqual(pds, null)) { newMedRecords.Add(pds); } TestLaboratoryReport lr = i as TestLaboratoryReport; if (!Global.IsEqual(lr, null)) { newMedRecords.Add(lr); } TestConsultNote pcn = i as TestConsultNote; if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } else if (!Global.IsEqual(pcn, null)) { newMedRecords.Add(pcn); } TestAppointedMedication ap = i as TestAppointedMedication; if (!Global.IsEqual(ap, null)) { newMedRecords.Add(ap); } TestDeathInfo di = i as TestDeathInfo; if (!Global.IsEqual(tdi, null) && (!Global.IsEqual(di, null))) { newMedRecords.Add(di); } else if (!Global.IsEqual(tdi, null)) { newMedRecords.Add(tdi); } TestForm027U form = i as TestForm027U; if (!Global.IsEqual(form, null)) { newMedRecords.Add(form); } } } else { if (!Global.IsEqual(tfi, null)) { newMedRecords.Add(tfi); } if (!Global.IsEqual(cmd, null)) { newMedRecords.Add(cmd); } if (!Global.IsEqual(ds, null)) { newMedRecords.Add(ds); } if (!Global.IsEqual(cn, null)) { newMedRecords.Add(cn); } if (!Global.IsEqual(tdi, null)) { newMedRecords.Add(tdi); } } this.records = newMedRecords; } } }
static public TestStatCase BuildAmbCaseFromDataBaseData(string guid, string idlpu, string mis, string patientId) { if ((guid != string.Empty) && (idlpu != string.Empty) && (mis != string.Empty)) { string caseId = TestCaseBase.GetCaseId(guid, idlpu, mis, patientId); if (caseId != null) { CaseStat ca = new CaseStat(); using (SqlConnection connection = Global.GetSqlConnection()) { string findCase = "SELECT TOP(1) * FROM HospCase WHERE IdCase = '" + caseId + "'"; SqlCommand caseCommand = new SqlCommand(findCase, connection); using (SqlDataReader caseReader = caseCommand.ExecuteReader()) { while (caseReader.Read()) { if (caseReader["DeliveredCode"].ToString() != "") { ca.DeliveryCode = Convert.ToString(caseReader["DeliveredCode"]); } if (caseReader["IdIntoxicationType"].ToString() != "") { ca.IdIntoxicationType = Convert.ToByte(caseReader["IdIntoxicationType"]); } if (caseReader["IdPatientConditionOnAdmission"].ToString() != "") { ca.IdPatientConditionOnAdmission = Convert.ToByte(caseReader["IdPatientConditionOnAdmission"]); } if (caseReader["IdTypeFromDiseaseStart"].ToString() != "") { ca.IdTypeFromDiseaseStart = Convert.ToByte(caseReader["IdTypeFromDiseaseStart"]); } if (caseReader["IdTransportIntern"].ToString() != "") { ca.IdTransportIntern = Convert.ToByte(caseReader["IdTransportIntern"]); } if (caseReader["IdHospChannel"].ToString() != "") { ca.IdHospChannel = Convert.ToByte(caseReader["IdHospChannel"]); } if (caseReader["RW1Mark"].ToString() != "") { ca.RW1Mark = Convert.ToBoolean(caseReader["RW1Mark"]); } if (caseReader["AIDSMark"].ToString() != "") { ca.AIDSMark = Convert.ToBoolean(caseReader["AIDSMark"]); } TestStatCase statcase = new TestStatCase(guid, ca); statcase.caseBase = TestCaseBase.BuildBaseCaseFromDataBaseData(guid, idlpu, mis, patientId); statcase.statSteps = TestStatStep.BuildStatStepsFromDataBase(caseId, ca.IdLpu); List <TestStepBase> st = TestStepBase.BuildTestStepsFromDataBase(caseId, ca.IdLpu); if (st != null) { foreach (TestStepBase i in st) { if (Global.IsEqual(i.doctor, null)) { statcase.defaultStep = i; } } if (!Global.IsEqual(statcase.defaultStep, null)) { statcase.records = new List <TestMedRecord>(); List <TestService> serv = TestService.BuildServiseFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(serv, null)) { statcase.records.AddRange(serv); } TestTfomsInfo forms = TestTfomsInfo.BuildTfomsInfoFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(forms, null)) { statcase.records.Add(forms); } TestDeathInfo tdi = TestDeathInfo.BuildDeathInfoFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(tdi, null)) { statcase.records.Add(tdi); } List <TestDiagnosis> td = TestDiagnosis.BuildDiagnosisFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(td, null)) { statcase.records.AddRange(td); } TestClinicMainDiagnosis acdm = TestClinicMainDiagnosis.BuildTestClinicMainDiagnosisFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(acdm, null)) { statcase.records.Add(acdm); } List <TestReferral> trl = TestReferral.BuildReferralFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(trl, null)) { statcase.records.AddRange(trl); } List <TestSickList> tsl = TestSickList.BuildSickListFromDataBaseData(statcase.defaultStep.idStep, patientId); if (!Global.IsEqual(tsl, null)) { statcase.records.AddRange(tsl); } TestDischargeSummary tds = TestDischargeSummary.BuildSickListFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(tds, null)) { statcase.records.Add(tds); } List <TestLaboratoryReport> tlr = TestLaboratoryReport.BuildLaboratoryReportFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(tlr, null)) { statcase.records.AddRange(tlr); } TestConsultNote tcn = TestConsultNote.BuildSickListFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(tcn, null)) { statcase.records.Add(tcn); } List <TestAppointedMedication> ap = TestAppointedMedication.BuildAppointedMedicationFromDataBaseDate(statcase.defaultStep.idStep); if (!Global.IsEqual(ap, null)) { statcase.records.AddRange(ap); } List <TestForm027U> form = TestForm027U.BuildForm027UFromDataBaseData(statcase.defaultStep.idStep); if (!Global.IsEqual(form, null)) { statcase.records.AddRange(form); } if (statcase.records.Count == 0) { statcase.records = null; } } } return(statcase); } } } } } return(null); }