/// <summary> /// 医生停诊信息列表 /// </summary> /// <param name="pageindex">所在页数</param> /// <param name="pagesize">每页显示条数</param> /// <param name="values">医生信息</param> /// <param name="msg">出错信息</param> /// <returns>0:成功 大于0:出错 小于0:异常</returns> public int DB_DoctorInfoTingZhen(int pageindex, int pagesize, out ArrayList values, out string msg) { msg = ""; OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString); OracleDataReader dr = null; int ret = -1; try { bool flag = false; long maxrow; long minrow; General.CalculatePage(pageindex, pagesize, out maxrow, out minrow); string findId1 = _builder.DoctorInfoTingZhenSql(maxrow, minrow, out flag, out msg); dr = DbHelperOra.ExecuteReader(findId1, connection); if (dr.HasRows) { values = new ArrayList(); while (dr.Read()) { AlipayDoctorInfoTingZhen pd = new AlipayDoctorInfoTingZhen(); pd.code = !dr.IsDBNull(0) ? dr.GetString(0) : ""; pd.name = !dr.IsDBNull(1) ? dr.GetString(1) : ""; pd.pictureurl = !dr.IsDBNull(2) ? dr.GetString(2) : ""; pd.departcode = !dr.IsDBNull(3) ? dr.GetString(3) : ""; pd.departname = !dr.IsDBNull(4) ? dr.GetString(4) : ""; pd.stopdate = !dr.IsDBNull(5) ? dr.GetString(5) : ""; pd.stopshift = !dr.IsDBNull(6) ? dr.GetString(6) : ""; values.Add(pd); } ret = 0; } else { msg = "亲,没有记录"; values = null; ret = 16; } dr.Close(); return(ret); } catch (Exception ex) { UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, ex); msg = GetExceptionInfo(ex); values = null; return(-99); } finally { if (null != dr) { dr.Close(); } connection.Close(); } }