/// <summary> /// 添加一个病历 /// </summary> /// <param name="templateInfo"></param> /// <returns></returns> /// <summary> public bool AddHisDetail(string strHisGid, string strTitle, string strDesc, string strDoctorGid, List <String> lstPic) { DataBaseHelper.BeginTransaction(); try { TMedicalHisDetail detail = new TMedicalHisDetail(); detail.DetailGid = Guid.NewGuid().ToString(); detail.HisID = strHisGid; detail.DetailTitle = strTitle; detail.DetailDescribe = strDesc; detail.CreateUser = strDoctorGid; List <TMedicalHisDetailPic> lstDetailPic = new List <TMedicalHisDetailPic>(); foreach (string strImgUrl in lstPic) { TMedicalHisDetailPic detailPic = new TMedicalHisDetailPic(); detailPic.DetailGid = detail.DetailGid; detailPic.PicUrl = strImgUrl; lstDetailPic.Add(detailPic); } Save(lstDetailPic); Save <TMedicalHisDetail>(detail); DataBaseHelper.CommitTransaction(); return(true); } catch { //事务回滚 DataBaseHelper.RollbackTransaction(); return(false); } }
/// <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> /// 添加一个病历 /// </summary> /// <param name="templateInfo"></param> /// <returns></returns> /// <summary> public bool UpdateHisDetail(string strDetailGid, string strTitle, string strDesc, string strDoctorGid, List <String> lstPic) { //开启事务 DataBaseHelper.BeginTransaction(); try { 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) { detail.DetailTitle = strTitle != null ? strTitle : detail.DetailTitle; detail.DetailDescribe = strDesc != null ? strDesc : detail.DetailDescribe; detail.CreateUser = strDoctorGid != null?strDoctorGid:detail.CreateUser; String strSql1 = "select * from T_Medical_HisDetailPic where Detail_Gid=@Detail_Gid and status =1"; ParamMap paramDetail = ParamMap.newMap(); paramDetail.setParameter("Detail_Gid", strDetailGid); List <TMedicalHisDetailPic> lstDetailPic = DataBaseHelper.FindBySql <TMedicalHisDetailPic>(strSql1, paramDetail); if (lstDetailPic != null && lstDetailPic.Count > 0) { List <String> lstDeletePic = new List <string>(); String strPicUrl = ""; foreach (TMedicalHisDetailPic mhp in lstDetailPic) { strPicUrl = ""; strPicUrl = mhp.PicUrl; if (strPicUrl.Trim() != "") { lstDeletePic.Add(strPicUrl.Trim()); } } Zelo.Common.Common.ImageSave.DeletePic(lstDeletePic); } //Update(ttem); DataBaseHelper.Remove(lstDetailPic); lstDetailPic = new List <TMedicalHisDetailPic>(); ///提交模版下的每个动作 foreach (string strImgUrl in lstPic) { TMedicalHisDetailPic detailPic = new TMedicalHisDetailPic(); detailPic.DetailGid = detail.DetailGid; detailPic.PicUrl = strImgUrl; lstDetailPic.Add(detailPic); } Update <TMedicalHisDetail>(detail); Save(lstDetailPic); //提交事务 DataBaseHelper.CommitTransaction(); return(true); } else { return(false); } } catch { //事务回滚 DataBaseHelper.RollbackTransaction(); return(false); } }