/// <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();
}
}
