/// <summary> /// 一个化验报告单详细列表信息 /// </summary> /// <param name="doctadviseno">条码号</param> /// <param name="msg">出错信息</param> /// <returns>0:成功 大于0:出错 小于0:异常</returns> public int DB_LaboratoryTestsReportDetailedListInformation(string doctadviseno, out ArrayList values, out string msg) { msg = ""; values = new ArrayList(); OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString); OracleDataReader dr = null; try { bool _flag = false; double number = Convert.ToDouble(doctadviseno); string findText = _builder.GetLaboratoryTestsReportDetailedListInformation(number, out _flag, out msg); if (!_flag) { return(10); } int ret = -1; msg = ""; dr = DbHelperOra.ExecuteReader(findText, connection); if (null != dr && dr.HasRows) { while (dr.Read()) { AlipayReportdetailInfo ri = new AlipayReportdetailInfo(); ri.jylx = !dr.IsDBNull(0) ? dr.GetString(0) : ""; ri.xmmc = !dr.IsDBNull(1) ? dr.GetString(1) : ""; ri.result = !dr.IsDBNull(2) ? dr.GetString(2) : ""; ri.hint = !dr.IsDBNull(3) ? dr.GetString(3) : ""; ri.jkfw = !dr.IsDBNull(4) ? dr.GetString(4) : ""; ri.xmdw = !dr.IsDBNull(5) ? dr.GetString(5) : ""; values.Add(ri); } ret = 0; } else { values = null; msg = "未能找到报告单"; ret = 17; } return(ret); } catch (Exception ex) { UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex); values = null; msg = GetExceptionInfo(ex); return(AppUtils.Default_Exception_Code); } finally { if (null != dr) { dr.Close(); } connection.Close(); } }