public PatientMedicamentsReportBuilder(ConnectionFactory factory, Config config, Patient patient) : base(ReportBuilderId.PatientMedicaments) { AddDataSource("ReportsDataSet_PatientMedicaments", GetPatientMedicamentsTable(factory, patient.Id)); Insurance insurance; string insuranceCompanyName = ""; using (GmConnection conn = factory.CreateConnection()) { AddParameter("PatientName", patient.GetPatientName(conn)); AddParameter("DoctorName", patient.GetDoctorName(conn)); AddParameter("ChiefName", patient.GetChiefName(conn)); AddParameter("Age", patient.GetAgeStr(conn)); insurance = patient.GetInsurance(conn); if (insurance != null) { insuranceCompanyName = insurance.GetInsuranceCompanyName(conn); } } AddParameter("HeadDoctor", config.departmentConfig.headDoctor); AddParameter("DepartmentName", config.departmentConfig.departmentName); AddParameter("HospitalName", config.departmentConfig.hospitalName); DiagnosisInfo di = patient.patientDiagnoses.LatestDiagnosisInfo; AddParameter("Diagnosis", di.text); AddParameter("DiagnosisCode", di.code); AddParameter("AdmissionDate", patient.admissionDate); AddParameter("DischargeDate", patient.DischargeDateStr); AddParameter("Duration", patient.Duration); AddParameter("CaseHistoryNumber", patient.patientData); AddParameter("InsuranceNumber", insurance != null?insurance.number:""); AddParameter("InsuranceCompany", insuranceCompanyName); }
private EMKServise.DiagnosisInfo ConvertDiagnosisInfo(DiagnosisInfo c) { if ((object)c != null) { EMKServise.DiagnosisInfo edi = new EMKServise.DiagnosisInfo(); if (c.Comment != "") { edi.Comment = c.Comment; } if (c.DiagnosedDate != DateTime.MinValue) { edi.DiagnosedDate = c.DiagnosedDate; } edi.DiagnosisChangeReason = c.DiagnosisChangeReason; edi.DiagnosisStage = c.DiagnosisStage; edi.IdDiagnosisType = c.IdDiagnosisType; edi.IdDiseaseType = c.IdDiseaseType; edi.IdDispensaryState = c.IdDispensaryState; edi.IdTraumaType = c.IdTraumaType; edi.MedicalStandard = c.MedicalStandard; edi.MESImplementationFeature = c.MESImplementationFeature; edi.MkbCode = c.MkbCode; return(edi); } else { return(null); } }
public TestDiagnosisInfo(DiagnosisInfo d) { if (d != null) { info = d; } }
static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral) { using (NpgsqlConnection connection = Global.GetSqlConnection()) { //опять DiagnosedDateSpecified, что с этим делать? //ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType? string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')"; NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection); using (NpgsqlDataReader diagnosisReader = person.ExecuteReader()) { while (diagnosisReader.Read()) { DiagnosisInfo diag = new DiagnosisInfo(); if (diagnosisReader["comment"] != DBNull.Value) { diag.Comment = Convert.ToString(diagnosisReader["comment"]); } if (diagnosisReader["diagnosis_date"] != DBNull.Value) { diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]); } TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag); if (diagnosisReader["id_mkb_code"] != DBNull.Value) { tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"])); } return(tDiag); } } } return(null); }
public static List<TestDiagnosisInfo> BuildTestComplicationDiagnosisInfoFromDataBaseData(string idReferral) { List<TestDiagnosisInfo> diagnosis = new List<TestDiagnosisInfo>(); using (NpgsqlConnection connection = Global.GetSqlConnection()) { //опять DiagnosedDateSpecified, что с этим делать? //ещё есть какой-то idDiagnosisStatus и idLpu, так же idDiagnosisContainer - это не diagnosisType? string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "')"; NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection); using (NpgsqlDataReader diagnosisReader = person.ExecuteReader()) { while (diagnosisReader.Read()) { DiagnosisInfo diag = new DiagnosisInfo(); if (diagnosisReader["comment"].ToString() != "") diag.Comment = Convert.ToString(diagnosisReader["comment"]); if (diagnosisReader["diagnosis_date"].ToString() != "") diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]); TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag); if (diagnosisReader["id_mkb_code"].ToString() != "") tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData(Convert.ToString(diagnosisReader["id_mkb_code"])); diagnosis.Add(tDiag); } } } if (diagnosis.Count != 0) return diagnosis; else return null; }
public TestDiagnosisInfo(DiagnosisInfo r) { diagnosisInfo = r; if (diagnosisInfo.DiagnosisType != null) diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType); if (diagnosisInfo.MkbCode != null) mkbCode = new TestCoding(diagnosisInfo.MkbCode); }
public void Init(DiagnosisInfo diagnosisInfo) { bool idChanged = this.diagnosisInfo.id != diagnosisInfo.id; this.diagnosisInfo = diagnosisInfo; textBox.Text = diagnosisInfo; lblCode.Text = CodeStr(); if (idChanged && OnDiagnosisIdChanged != null) { OnDiagnosisIdChanged(null, null); } }
public TestDiagnosisInfo(DiagnosisInfo r) { diagnosisInfo = r; if (diagnosisInfo.DiagnosisType != null) { diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType); } if (diagnosisInfo.MkbCode != null) { mkbCode = new TestCoding(diagnosisInfo.MkbCode); } }
public void OnSelected() { DiagnosisInfo di = patient.LatestDiagnosisInfo; if (diagnosisId != di.id) { using (GmConnection conn = App.CreateConnection()) { Diagnosis d = di.GetDiagnosis(conn); if (d != null) { hospitalStay = App.DepartmentConfig.GetRecommendedHospitalStay(d); } } diagnosisId = di.id; } lblHospitalStay.Text = string.Format("ќриентировочный срок пребывани¤ больного в стационаре {0} койкодней", hospitalStay); }
static public TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral, string idLpu) { if (idLpu != "") { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "' AND id_lpu = '" + idLpu + "'"; NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection); using (NpgsqlDataReader diagnosisReader = person.ExecuteReader()) { while (diagnosisReader.Read()) { DiagnosisInfo diag = new DiagnosisInfo(); if (diagnosisReader["comment"] != DBNull.Value) { diag.Comment = Convert.ToString(diagnosisReader["comment"]); } if (diagnosisReader["diagnosis_date"] != DBNull.Value) { diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]); } TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag); if (diagnosisReader["id_diagnosis_status"] != DBNull.Value) { tDiag.diagnosisType = TestCoding.BuildCodingFromDataBaseData( diagnosisReader["id_diagnosis_status"].ToString()); } if (diagnosisReader["id_mkb_code"] != DBNull.Value) { tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData( Convert.ToString(diagnosisReader["id_mkb_code"])); } return(tDiag); } } } } return(null); }
public static TestDiagnosisInfo BuildDiagnosisFromDataBaseDate(string idDiagnosis) { using (SqlConnection connection = Global.GetSqlConnection()) { string findTD = "SELECT * FROM Diagnosis WHERE IdDiagnosis = '" + idDiagnosis + "'"; SqlCommand TDcommand = new SqlCommand(findTD, connection); using (SqlDataReader TDReader = TDcommand.ExecuteReader()) { while (TDReader.Read()) { DiagnosisInfo d = new DiagnosisInfo(); if (TDReader["Comment"].ToString() != "") d.Comment = Convert.ToString(TDReader["Comment"]); if (TDReader["DiagnosedDate"].ToString() != "") d.DiagnosedDate = Convert.ToDateTime(TDReader["DiagnosedDate"]); if (TDReader["IdRDiagnosisChangeReason"].ToString() != "") d.DiagnosisChangeReason = Convert.ToByte(TDReader["IdRDiagnosisChangeReason"]); if (TDReader["IdDiagnoseStage"].ToString() != "") d.DiagnosisStage = Convert.ToByte(TDReader["IdDiagnoseStage"]); if (TDReader["IdDiagnosisType"].ToString() != "") d.IdDiagnosisType = Convert.ToByte(TDReader["IdDiagnosisType"]); if (TDReader["IdDiseaseType"].ToString() != "") d.IdDiseaseType = Convert.ToByte(TDReader["IdDiseaseType"]); if (TDReader["IdRDispensaryState"].ToString() != "") d.IdDispensaryState = Convert.ToByte(TDReader["IdRDispensaryState"]); if (TDReader["IdTraumaType"].ToString() != "") d.IdTraumaType = Convert.ToByte(TDReader["IdTraumaType"]); if (TDReader["IdRMedicalStandard"].ToString() != "") d.MedicalStandard = Convert.ToInt32(TDReader["IdRMedicalStandard"]); if (TDReader["IdRMESImplementationFeature"].ToString() != "") d.MESImplementationFeature = Convert.ToByte(TDReader["IdRMESImplementationFeature"]); if (TDReader["MkbCode"].ToString() != "") d.MkbCode = Convert.ToString(TDReader["MkbCode"]); return (new TestDiagnosisInfo(d)); } } } return null; }
public TestDiagnosisInfo(DiagnosisInfo d) { if (d != null) info = d; }
public SelectDiagnosisForm(DiagnosisInfo diagnosisInfo) { InitializeComponent(); this.diagnosisInfo = diagnosisInfo; FormUtils.Init(this); }
public TestDiagnosisInfo(DiagnosisInfo r) { diagnosisInfo = r; diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType); mkbCode = new TestCoding(diagnosisInfo.MkbCode); }
public static TestDiagnosisInfo BuildTestMainDiagnosisInfoFromDataBaseData(string idReferral, string idLpu) { if (idLpu != "") { using (NpgsqlConnection connection = Global.GetSqlConnection()) { string finddiagnosis = "SELECT * FROM public.diagnosis WHERE id_referral = '" + idReferral + "' AND id_diagnosis_container = '" + complication + "' AND id_lpu = '" + idLpu + "'"; NpgsqlCommand person = new NpgsqlCommand(finddiagnosis, connection); using (NpgsqlDataReader diagnosisReader = person.ExecuteReader()) { while (diagnosisReader.Read()) { DiagnosisInfo diag = new DiagnosisInfo(); if (diagnosisReader["comment"] != DBNull.Value) diag.Comment = Convert.ToString(diagnosisReader["comment"]); if (diagnosisReader["diagnosis_date"] != DBNull.Value) diag.DiagnosedDate = Convert.ToDateTime(diagnosisReader["diagnosis_date"]); TestDiagnosisInfo tDiag = new TestDiagnosisInfo(diag); if (diagnosisReader["id_diagnosis_status"] != DBNull.Value) tDiag.diagnosisType = TestCoding.BuildCodingFromDataBaseData( diagnosisReader["id_diagnosis_status"].ToString()); if (diagnosisReader["id_mkb_code"] != DBNull.Value) tDiag.mkbCode = TestCoding.BuildCodingFromDataBaseData( Convert.ToString(diagnosisReader["id_mkb_code"])); return tDiag; } } } } return null; }
public static void Seed(this ModelBuilder modelBuilder) { var user1 = new User() { UserId = 1, Name = "Andrey", Surname = "Solovyev", BornDate = new DateTime(2000, 04, 03), PassportData = "2020445765", Snills = "1234" }; var user2 = new User() { UserId = 2, Name = "Vasiliy", Surname = "Sychev", BornDate = new DateTime(2000, 10, 10), PassportData = "2020123987", Snills = "2345" }; var user3 = new User() { UserId = 3, Name = "Ivan", Surname = "Tkachenko", BornDate = new DateTime(2000, 04, 07), PassportData = "2020234765", Snills = "3456" }; var user4 = new User() { UserId = 4, Name = "Ivan", Surname = "Menshih", BornDate = new DateTime(2001, 8, 14), PassportData = "2014456765", Snills = "4567" }; var user5 = new User() { UserId = 5, Name = "Lev", Surname = "Makeev", BornDate = new DateTime(2000, 07, 24), PassportData = "2020567123", Snills = "6789" }; modelBuilder.Entity <User>().HasData(user1, user2, user3, user4, user5); var specialty1 = new Specialty() { SpecialtyId = 1, Name = "Endocrinologist" }; var specilaty2 = new Specialty() { SpecialtyId = 2, Name = "Сardiologist" }; var specialty3 = new Specialty() { SpecialtyId = 3, Name = "Therapist" }; var specilaty4 = new Specialty() { SpecialtyId = 4, Name = "Neurologist" }; modelBuilder.Entity <Specialty>().HasData(specialty1, specilaty2, specialty3, specilaty4); var doctor1 = new Doctor() { DoctorId = 1, UserId = user1.UserId, SpecialtyId = specialty1.SpecialtyId, LicenseNumber = "1111" }; var doctor2 = new Doctor() { DoctorId = 2, UserId = user2.UserId, SpecialtyId = specilaty2.SpecialtyId, LicenseNumber = "2222" }; var doctor3 = new Doctor() { DoctorId = 3, UserId = user3.UserId, SpecialtyId = specialty3.SpecialtyId, LicenseNumber = "3333" }; modelBuilder.Entity <Doctor>().HasData(doctor1, doctor2, doctor3); var patient1 = new Patient() { PatientId = 1, Policy = "12321", UserId = user4.UserId }; var patient2 = new Patient() { PatientId = 2, Policy = "213214", UserId = user5.UserId }; modelBuilder.Entity <Patient>().HasData(patient1, patient2); var visit1 = new Visit() { VisitId = 1, PatientId = patient1.PatientId, DoctorId = doctor1.DoctorId, DateVisit = new DateTime(2021, 02, 02), Price = 1300 }; var visit2 = new Visit() { VisitId = 2, PatientId = patient1.PatientId, DoctorId = doctor2.DoctorId, DateVisit = new DateTime(2021, 01, 20), Complaint = "Too expensive", Price = 1000 }; var visit3 = new Visit() { VisitId = 3, PatientId = patient2.PatientId, DoctorId = doctor1.DoctorId, DateVisit = new DateTime(2021, 03, 25), Price = 1200 }; modelBuilder.Entity <Visit>().HasData(visit1, visit2, visit3); var diagnosis1 = new Diagnosis() { DiagnosisId = 1, Name = "Diabetes", Description = "Needs careful treatment" }; var diagnosis2 = new Diagnosis() { DiagnosisId = 2, Name = "Tachycardia", Description = "Nothing serious, just avoid much coffee" }; var diagnosis3 = new Diagnosis() { DiagnosisId = 3, Name = "Headache", Description = "Outflow of blood from the head is disturbed" }; modelBuilder.Entity <Diagnosis>().HasData(diagnosis1, diagnosis2, diagnosis3); var diagnosisInfo1 = new DiagnosisInfo() { DiagnosisInfoId = 1, DiagnosisId = diagnosis1.DiagnosisId, PatientId = patient1.PatientId }; var diagnosisInfo2 = new DiagnosisInfo() { DiagnosisInfoId = 2, PatientId = patient2.PatientId, DiagnosisId = diagnosis2.DiagnosisId }; modelBuilder.Entity <DiagnosisInfo>().HasData(diagnosisInfo1, diagnosisInfo2); var cabinet1 = new Cabinet() { CabinetId = 1, CabinetNumber = 228 }; var cabinet2 = new Cabinet() { CabinetId = 2, CabinetNumber = 320 }; var cabinet3 = new Cabinet() { CabinetId = 3, CabinetNumber = 223 }; modelBuilder.Entity <Cabinet>().HasData(cabinet1, cabinet2, cabinet3); var cabinetInfo1 = new CabinetInfo() { CabinetInfoId = 1, CabinetId = cabinet1.CabinetId, DoctorId = doctor1.DoctorId, DateStart = new DateTime(2019, 3, 23)/*, * DateEnd = default*/ }; var cabinetInfo2 = new CabinetInfo() { CabinetInfoId = 2, CabinetId = cabinet2.CabinetId, DoctorId = doctor2.DoctorId, DateStart = new DateTime(2015, 6, 12), DateEnd = new DateTime(2018, 3, 21) }; var cabinetInfo3 = new CabinetInfo() { CabinetInfoId = 3, CabinetId = cabinet3.CabinetId, DoctorId = doctor2.DoctorId, DateStart = new DateTime(2018, 3, 21)/*, * DateEnd = default*/ }; var cabinetInfo4 = new CabinetInfo() { CabinetInfoId = 4, CabinetId = cabinet2.CabinetId, DoctorId = doctor3.DoctorId, DateStart = new DateTime(2018, 3, 21) }; modelBuilder.Entity <CabinetInfo>().HasData(cabinetInfo1, cabinetInfo2, cabinetInfo3, cabinetInfo4); }
static public TestDiagnosisInfo BuildDiagnosisFromDataBaseDate(string idDiagnosis) { using (SqlConnection connection = Global.GetSqlConnection()) { string findTD = "SELECT * FROM Diagnosis WHERE IdDiagnosis = '" + idDiagnosis + "'"; SqlCommand TDcommand = new SqlCommand(findTD, connection); using (SqlDataReader TDReader = TDcommand.ExecuteReader()) { while (TDReader.Read()) { DiagnosisInfo d = new DiagnosisInfo(); if (TDReader["Comment"].ToString() != "") { d.Comment = Convert.ToString(TDReader["Comment"]); } if (TDReader["DiagnosedDate"].ToString() != "") { d.DiagnosedDate = Convert.ToDateTime(TDReader["DiagnosedDate"]); } if (TDReader["IdRDiagnosisChangeReason"].ToString() != "") { d.DiagnosisChangeReason = Convert.ToByte(TDReader["IdRDiagnosisChangeReason"]); } if (TDReader["IdDiagnoseStage"].ToString() != "") { d.DiagnosisStage = Convert.ToByte(TDReader["IdDiagnoseStage"]); } if (TDReader["IdDiagnosisType"].ToString() != "") { d.IdDiagnosisType = Convert.ToByte(TDReader["IdDiagnosisType"]); } if (TDReader["IdDiseaseType"].ToString() != "") { d.IdDiseaseType = Convert.ToByte(TDReader["IdDiseaseType"]); } if (TDReader["IdRDispensaryState"].ToString() != "") { d.IdDispensaryState = Convert.ToByte(TDReader["IdRDispensaryState"]); } if (TDReader["IdTraumaType"].ToString() != "") { d.IdTraumaType = Convert.ToByte(TDReader["IdTraumaType"]); } if (TDReader["IdRMedicalStandard"].ToString() != "") { d.MedicalStandard = Convert.ToInt32(TDReader["IdRMedicalStandard"]); } if (TDReader["IdRMESImplementationFeature"].ToString() != "") { d.MESImplementationFeature = Convert.ToByte(TDReader["IdRMESImplementationFeature"]); } if (TDReader["MkbCode"].ToString() != "") { d.MkbCode = Convert.ToString(TDReader["MkbCode"]); } return(new TestDiagnosisInfo(d)); } } } return(null); }
private EMKServise.DiagnosisInfo ConvertDiagnosisInfo(DiagnosisInfo c) { if ((object)c != null) { EMKServise.DiagnosisInfo edi = new EMKServise.DiagnosisInfo(); if (c.Comment != "") edi.Comment = c.Comment; if (c.DiagnosedDate != DateTime.MinValue) edi.DiagnosedDate = c.DiagnosedDate; edi.DiagnosisChangeReason = c.DiagnosisChangeReason; edi.DiagnosisStage = c.DiagnosisStage; edi.IdDiagnosisType = c.IdDiagnosisType; edi.IdDiseaseType = c.IdDiseaseType; edi.IdDispensaryState = c.IdDispensaryState; edi.IdTraumaType = c.IdTraumaType; edi.MedicalStandard = c.MedicalStandard; edi.MESImplementationFeature = c.MESImplementationFeature; edi.MkbCode = c.MkbCode; return edi; } else return null; }
//得到诊断信息 LY 2015-10-10 public List <DiagnosisInfo> PsDiagnosisGetDiagnosisInfo(DataConnection pclsCache, string UserId, string VisitId) { List <DiagnosisInfo> list = new List <DiagnosisInfo>(); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { return(null); } cmd = new CacheCommand(); cmd = Ps.Diagnosis.GetDiagnosisInfo(pclsCache.CacheConnectionObject); cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId; cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId; cdr = cmd.ExecuteReader(); while (cdr.Read()) { string RecordDateShow = ""; string str1 = cdr["RecordDate"].ToString(); if (str1 != "") { RecordDateShow = str1.Substring(0, 4) + "-" + str1.Substring(4, 2) + "-" + str1.Substring(6, 2); } DiagnosisInfo NewLine = new DiagnosisInfo(); NewLine.VisitId = cdr["VisitId"].ToString(); NewLine.DiagnosisType = cdr["DiagnosisType"].ToString(); NewLine.DiagnosisTypeName = cdr["DiagnosisTypeName"].ToString(); NewLine.DiagnosisNo = cdr["DiagnosisNo"].ToString(); NewLine.Type = cdr["Type"].ToString(); NewLine.TypeName = cdr["TypeName"].ToString(); NewLine.DiagnosisCode = cdr["DiagnosisCode"].ToString(); NewLine.DiagnosisName = cdr["DiagnosisName"].ToString(); NewLine.Description = cdr["Description"].ToString(); NewLine.RecordDate = cdr["RecordDate"].ToString(); NewLine.RecordDateShow = RecordDateShow; NewLine.Creator = cdr["Creator"].ToString(); NewLine.RecordDateCom = Convert.ToDateTime(cdr["RecordDate"]).ToString("yyyy-MM-dd HH:mm:ss"); list.Add(NewLine); } return(list); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "Ps.Diagnosis.GetDiagnosisInfo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(null); } finally { if ((cdr != null)) { cdr.Close(); cdr.Dispose(true); cdr = null; } if ((cmd != null)) { cmd.Parameters.Clear(); cmd.Dispose(); cmd = null; } pclsCache.DisConnect(); } }
public TestDiagnosisInfo(DiagnosisInfo r) { diagnosisInfo = r; diagnosisType = new TestCoding(diagnosisInfo.DiagnosisType); mkbCode = new TestCoding(diagnosisInfo.MkbCode); }