/// <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);
}
}
