//检查化验等信息 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();
}
}
