/// <summary> /// 根据病历ID获取病历信息 /// </summary> /// <param name="strDoctorGid"></param> /// <param name="strPatientGid"></param> /// <param name="strSickness"></param> /// <returns></returns> public TMedicHisDetailInfo GetMedicalHisDetail(String strDetailGid) { TMedicHisDetailInfo info = new TMedicHisDetailInfo(); String strSql = "SELECT * FROM T_Medical_HisDetail WHERE DETAIL_GID = @DETAIL_GID AND STATUS =1 "; ParamMap param = ParamMap.newMap(); param.setParameter("DETAIL_GID", strDetailGid); TMedicalHisDetail detail = DataBaseHelper.FindOne <TMedicalHisDetail>(strSql, param); if (detail != null) { info.DetailGid = detail.DetailGid; info.HisID = detail.HisID; info.DetailTitle = detail.DetailTitle; info.DetailDescribe = detail.DetailDescribe; info.CreateUser = detail.CreateUser; info.CreateTime = detail.CreateTime; info.UpdateTime = detail.UpdateTime; info.Status = detail.Status; strSql = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1"; ParamMap paramDetail = ParamMap.newMap(); param.setParameter("Detail_Gid", strDetailGid); info.PicList = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql, paramDetail); return(info); } else { return(null); } }
/// <summary> /// 根据病历ID获取病历信息 /// </summary> /// <param name="strDoctorGid"></param> /// <param name="strPatientGid"></param> /// <param name="strSickness"></param> /// <returns></returns> public List <TMedicHisDetailInfo> GetMedicalHisDetailByHisgid(String strHisGid) { List <TMedicHisDetailInfo> lstDetailInfo = new List <TMedicHisDetailInfo>(); String strSql = "SELECT * FROM T_Medical_HisDetail WHERE HIS_ID = @HIS_ID AND STATUS =1 "; ParamMap param = ParamMap.newMap(); param.setParameter("HIS_ID", strHisGid); List <TMedicalHisDetail> lstdetail = DataBaseHelper.FindBySql <TMedicalHisDetail>(strSql, param); if (lstdetail != null && lstdetail.Count > 0) { foreach (TMedicalHisDetail detail in lstdetail) { TMedicHisDetailInfo info = new TMedicHisDetailInfo(); info.DetailGid = detail.DetailGid; info.HisID = detail.HisID; info.DetailTitle = detail.DetailTitle; info.DetailDescribe = detail.DetailDescribe; info.CreateUser = detail.CreateUser; info.CreateTime = detail.CreateTime; info.UpdateTime = detail.UpdateTime; info.Status = detail.Status; strSql = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1"; ParamMap paramDetail = ParamMap.newMap(); param.setParameter("Detail_Gid", detail.DetailGid); info.PicList = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql, paramDetail); lstDetailInfo.Add(info); } return(lstDetailInfo); } else { return(null); } }