//检查化验等信息 LY 2015-10-10 public List <ClinicalTrans> PsClinicalInfoGetOtherTable(DataConnection pclsCache, string UserId, string VisitId) { //输出表 List <ClinicalTrans> List_Trans = new List <ClinicalTrans>(); try { //诊断 List <DiagnosisInfo> List_Diagnosis = new List <DiagnosisInfo>(); List_Diagnosis = PsDiagnosisGetDiagnosisInfo(pclsCache, UserId, VisitId); for (int i = 0; i < List_Diagnosis.Count; i++) { ClinicalTrans NewLine = new ClinicalTrans(); NewLine.精确时间 = Convert.ToDateTime(List_Diagnosis[i].RecordDate); NewLine.类型 = "诊断"; NewLine.VisitId = VisitId; NewLine.事件 = "诊断:" + List_Diagnosis[i].TypeName; NewLine.关键属性 = "DiagnosisInfo" + "|" + VisitId + "|" + Convert.ToDateTime(List_Diagnosis[i].RecordDate).ToString("yyyy-MM-ddHH:mm:ss"); List_Trans.Add(NewLine); } //检查 List <ExamInfo> List_Examination = new List <ExamInfo>(); List_Examination = PsExaminationGetExaminationList(pclsCache, UserId, VisitId); for (int i = 0; i < List_Examination.Count; i++) { ClinicalTrans NewLine = new ClinicalTrans(); NewLine.精确时间 = Convert.ToDateTime(List_Examination[i].ExamDate); NewLine.类型 = "检查"; NewLine.VisitId = VisitId; NewLine.事件 = "检查:" + List_Examination[i].ExamTypeName; NewLine.关键属性 = "ExaminationInfo" + "|" + VisitId + "|" + Convert.ToDateTime(List_Examination[i].ExamDate).ToString("yyyy-MM-ddHH:mm:ss"); List_Trans.Add(NewLine); } //化验 List <LabTestList> List_LabTest = new List <LabTestList>(); List_LabTest = GetLabTestList(pclsCache, UserId, VisitId); for (int i = 0; i < List_LabTest.Count; i++) { ClinicalTrans NewLine = new ClinicalTrans(); NewLine.精确时间 = Convert.ToDateTime(List_LabTest[i].LabTestDate); NewLine.类型 = "化验"; NewLine.VisitId = VisitId; NewLine.事件 = "化验:" + List_LabTest[i].LabItemName; NewLine.关键属性 = "LabTestInfo" + "|" + VisitId + "|" + Convert.ToDateTime(List_LabTest[i].LabTestDate).ToString("yyyy-MM-ddHH:mm:ss"); List_Trans.Add(NewLine); } //用药 这部分要等syf写完GetDrugRecord才行 //List<DrugRecordList> List_DrugRecord = new List<DrugRecordList>(); //List_DrugRecord = GetDrugRecordList(pclsCache, UserId, VisitId); //for (int i = 0; i < List_DrugRecord.Count; i++) //{ // ClinicalTrans NewLine = new ClinicalTrans(); // NewLine.精确时间 = Convert.ToDateTime(List_DrugRecord[i].StartDateTime); // NewLine.类型 = "用药"; // NewLine.VisitId = VisitId; // NewLine.事件 = "用药:" + List_DrugRecord[i].HistoryContent; // NewLine.关键属性 = "DrugRecord" + "|" + VisitId + "|" + Convert.ToDateTime(List_DrugRecord[i].StartDateTime).ToString("yyyy-MM-ddHH:mm:ss"); // List_Trans.Add(NewLine); //} return(List_Trans); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsClinicalInfo.GetClinicalInfo", "数据库操作异常! error information : " + ex.Message + Environment.NewLine + ex.StackTrace); return(null); } finally { } }
//住院-转科处理 LY 2015-10-10 public List <ClinicalTrans> PsClinicalInfoGetTransClinicalInfo(DataConnection pclsCache, string UserId, string VisitId) { //最终输出 List <ClinicalTrans> List_Trans = new List <ClinicalTrans>(); CacheCommand cmd = null; CacheDataReader cdr = null; try { if (!pclsCache.Connect()) { return(null); } //取出原始数据 List <ClinicalTemp> List_Temp = new List <ClinicalTemp>(); cmd = new CacheCommand(); cmd = Ps.InPatientInfo.GetInfobyVisitId(pclsCache.CacheConnectionObject); cmd.Parameters.Add("UserId", CacheDbType.NVarChar).Value = UserId; cmd.Parameters.Add("VisitId", CacheDbType.NVarChar).Value = VisitId; cdr = cmd.ExecuteReader(); while (cdr.Read()) { ClinicalTemp NewLine = new ClinicalTemp(); NewLine.SortNo = Convert.ToInt32(cdr["SortNo"]); NewLine.AdmissionDate = Convert.ToDateTime(cdr["AdmissionDate"]); NewLine.DisChargeDate = Convert.ToDateTime(cdr["DischargeDate"]); NewLine.HospitalName = cdr["HospitalName"].ToString(); NewLine.DepartmentName = cdr["DepartmentName"].ToString(); List_Temp.Add(NewLine); } //有转科 //转科处理 转科内容:什么时候从哪里转出,什么时候转到哪 if (List_Temp.Count > 1) { for (int n = 0; n < List_Temp.Count - 1; n++) { //只科室 string things = List_Temp[n].DepartmentName + "(转出)" + " "; things += List_Temp[n + 1].DepartmentName + "(转入)"; ClinicalTrans NewLine = new ClinicalTrans(); NewLine.精确时间 = List_Temp[n + 1].AdmissionDate; NewLine.类型 = "转科"; NewLine.VisitId = VisitId; NewLine.事件 = things; List_Trans.Add(NewLine); } } return(List_Trans); } catch (Exception ex) { HygeiaComUtility.WriteClientLog(HygeiaEnum.LogType.ErrorLog, "PsClinicalInfo.GetClinicalInfo", "数据库操作异常! 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(); } }