/// <summary>
/// 医生信息列表_按医生代码查
/// </summary>
/// <param name="code">医生代码</param>
/// <param name="values">医生信息</param>
/// <param name="msg">出错信息</param>
/// <returns>0：成功 大于0：出错 小于0：异常</returns>
public int DB_DoctorInfoDaiMa(string code, out ArrayList values, out string msg)
{
msg = "";
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
bool flag = false;
int ret = -99;
string findId1 = _builder.DoctorInfoByCodeSql(code, out flag, out msg);
dr = DbHelperOra.ExecuteReader(findId1, connection);
if (dr.HasRows)
{
values = new ArrayList();
while (dr.Read())
{
AlipayDoctorInfo pd = new AlipayDoctorInfo();
pd.code = !dr.IsDBNull(0) ? dr.GetString(0) : "";
pd.name = !dr.IsDBNull(1) ? dr.GetString(1) : "";
pd.sex = !dr.IsDBNull(2) ? dr.GetString(2) : "";
pd.pictureurl = !dr.IsDBNull(3) ? dr.GetString(3) : "";
pd.level = !dr.IsDBNull(4) ? dr.GetString(4) : "";
pd.recommend = !dr.IsDBNull(5) ? dr.GetString(5) : "";
pd.adept = !dr.IsDBNull(6) ? dr.GetString(6) : "";
pd.departcode = !dr.IsDBNull(7) ? dr.GetString(7) : "";
pd.departname = !dr.IsDBNull(8) ? dr.GetString(8) : "";
values.Add(pd);
}
ret = 0;
}
else
{
msg = "亲，没有记录";
values = null;
ret = 16;
}
dr.Close();
return(ret);
}
catch (Exception ex)
{
msg = GetExceptionInfo(ex);
values = null;
return(-99);
}
finally
{
if (null != dr)
{
dr.Close();
}
connection.Close();
}
}