/// <summary> /// 电子病历内容 /// </summary> /// <param name="jzxh">就诊序号</param> /// <returns>0-成功 大于0-失败 小于0-异常</returns> public int DB_ElectronicMedicalRecordt(string jzxh, out mzMedicalRecords ri, out string msg) { msg = ""; OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString); OracleDataReader dr = null; int ret = -1; ri = new mzMedicalRecords(); try { bool _flag = false; string findText = _builder.GetElectronicMedicalRecordtSql(jzxh, out _flag, out msg); UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText); if (!_flag) { ret = 10; return(ret); } dr = DbHelperOra.ExecuteReader(findText, connection); if (dr.Read()) { ri.mzzs = !dr.IsDBNull(0) ? dr.GetString(0) : ""; ri.xbs = !dr.IsDBNull(1) ? dr.GetString(1) : ""; ri.jws = !dr.IsDBNull(2) ? dr.GetString(2) : ""; ri.grs = !dr.IsDBNull(3) ? dr.GetString(3) : ""; ri.gms = !dr.IsDBNull(4) ? dr.GetString(4) : ""; ri.hys = !dr.IsDBNull(5) ? dr.GetString(5) : ""; ri.jzs = !dr.IsDBNull(6) ? dr.GetString(6) : ""; ri.tgjc = !dr.IsDBNull(7) ? dr.GetString(7) : ""; ri.fzjc = !dr.IsDBNull(8) ? dr.GetString(8) : ""; ri.clyj = !dr.IsDBNull(9) ? dr.GetString(9) : ""; ret = 0; } else { msg = "医院端未找到,请核对信息后重试"; ret = 10; } dr.Close(); return(ret); } catch (Exception ex) { UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex); msg = GetExceptionInfo(ex); ret = -1; return(ret); } finally { if (null != dr) { dr.Close(); } connection.Close(); } }