public Result <String> UpdateMedicalInfo(UpdateMedicalHisParams medicalHis) { if (IsAuthrized) { Result <String> result = Result <String> .CreateInstance(ResultCode.Fail); TMedicalHis medicalHisInfo = GetService <MedicalHisService>().GetMedicalHisInfo(medicalHis.HisGid); if (medicalHisInfo != null) { medicalHisInfo.DoctorID = medicalHis.user_id != null ? medicalHis.user_id : medicalHisInfo.DoctorID; medicalHisInfo.PatientID = medicalHis.patient_id != null ? medicalHis.patient_id : medicalHisInfo.PatientID; medicalHisInfo.Sickness = medicalHis.SickNess != null ? medicalHis.SickNess : medicalHisInfo.Sickness; medicalHisInfo.UpdateTime = DateTime.Now; if ((new MedicalHisService()).UpdateMedicalHis(medicalHisInfo)) { result.SetSuccess(); result.message = "更新成功"; } else { result.message = "服务器错误:更新失败"; } } else { result.message = "没有查询到对应病历夹"; } return(result); } return(GetAuthFilterResult <String>()); }
/// <summary> /// 添加病例夹 /// </summary> /// <param name="strDoctorGid"></param> /// <param name="strPatientGid"></param> /// <param name="strSickness"></param> /// <returns></returns> public Boolean AddMedicalHis(String strDoctorGid, String strPatientGid, String strSickness) { TMedicalHis medicalHis = new TMedicalHis(); medicalHis.DoctorID = strDoctorGid; medicalHis.PatientID = strPatientGid; medicalHis.Sickness = strSickness; return(DataBaseHelper.Save <TMedicalHis>(medicalHis) > 0 ? true : false); }
/// <summary> /// 修改病例夹 /// </summary> /// <param name="strDoctorGid"></param> /// <param name="strPatientGid"></param> /// <param name="strSickness"></param> /// <returns></returns> public Boolean UpdateMedicalHis(TMedicalHis medicalHis) { return(DataBaseHelper.Update <TMedicalHis>(medicalHis) > 0 ? true : 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); }