/// <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> /// 删除病历 /// </summary> /// <param name="templateId"></param> /// <returns></returns> public Boolean DeleteDetailByGId(String strDetailGid) { //开启事务 DataBaseHelper.BeginTransaction(); try { //查询模版动作信息 String strSql1 = "select * from T_Medical_HisDetail where Detail_Gid=@Detail_Gid and status = 1"; ParamMap param = ParamMap.newMap(); param.setParameter("Detail_Gid", strDetailGid); List <TMedicalHisDetail> ttem = DataBaseHelper.FindBySql <TMedicalHisDetail>(strSql1, param); 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); //Update(ttem); DataBaseHelper.Remove(ttem); //提交事务 DataBaseHelper.CommitTransaction(); return(true); } catch { //事务回滚 DataBaseHelper.RollbackTransaction(); return(false); } }
/// <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); } }
/// <summary> /// 删除病历夹 /// </summary> /// <param name="strDoctorGid"></param> /// <param name="strPatientGid"></param> /// <param name="strSickness"></param> /// <returns></returns> public Boolean DeleteHisByGid(String strMedicalHisGid) { String strSql = "select * from T_Medical_His where HIS_GID=@HIS_GID and status = 1"; ParamMap param = ParamMap.newMap(); param.setParameter("HIS_GID", strMedicalHisGid); TMedicalHis mh = DataBaseHelper.FindOne <TMedicalHis>(strSql, param); if (mh != null) { //开启事务 DataBaseHelper.BeginTransaction(); try { String strSql1 = "select * from T_Medical_HisDetail where His_ID=@His_ID and status = 1"; param = ParamMap.newMap(); param.setParameter("His_ID", mh.HisGid); List <TMedicalHisDetail> mht = DataBaseHelper.FindBySql <TMedicalHisDetail>(strSql1, param); strSql1 = "select * from T_Medical_HisDetailPic where Detail_Gid IN (SELECT DETAIL_GID FROM T_Medical_HisDetail where His_ID=@His_ID and status = 1) and status =1"; ParamMap paramDetail = ParamMap.newMap(); paramDetail.setParameter("His_ID", mh.HisGid); 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); } //new MedicalHisDetailService().DeleteDetailByGId(tem.HisGid) if (lstDetailPic != null && lstDetailPic.Count > 0) { DataBaseHelper.Remove(lstDetailPic); } if (mht != null && mht.Count > 0) { DataBaseHelper.Remove(mht); } DataBaseHelper.Remove(mh); //Update(ttem); //Update<TTemplate>(tem); //提交事务 DataBaseHelper.CommitTransaction(); return(true); } catch { //事务回滚 DataBaseHelper.RollbackTransaction(); return(false); } } return(false); }