/// <summary> /// 获得常用联系人信息列表 /// </summary> /// <param name="openid">用户标识</param> /// <param name="linkmanid">联系人ID</param> /// <returns>0-成功 大于0-失败 小于0-异常</returns> public int DB_FavoriteContactsListStr(string openid, string linkmanid, out ArrayList list, out string msg) { msg = ""; list = new ArrayList(); OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString); OracleDataReader dr = null; int ret = -1; try { bool _flag = false; string findText = _builder.GetFavoriteContactsListSql(openid, linkmanid, out _flag, out msg); UtilLog.GetInstance().WriteProgramLog(System.Reflection.MethodBase.GetCurrentMethod().Name, findText); if (!_flag) { ret = 10; return(ret); } dr = DbHelperOra.ExecuteReader(findText, connection); while (dr.Read()) { UserInfo info = new UserInfo(); info.linkmanid = !dr.IsDBNull(0) ? dr.GetString(0) : ""; info.label = !dr.IsDBNull(1) ? dr.GetString(1) : ""; info.name = !dr.IsDBNull(2) ? dr.GetString(2) : ""; info.phone = !dr.IsDBNull(3) ? dr.GetString(3) : ""; info.idcardno = !dr.IsDBNull(4) ? dr.GetString(4) : ""; info.address = !dr.IsDBNull(5) ? dr.GetString(5) : ""; int bindcardfalag = dr.GetInt32(6); if (bindcardfalag == 1) { info.bindcardfalg = "已绑卡"; } else { info.bindcardfalg = "未绑卡"; } info.patientid = !dr.IsDBNull(7) ? dr.GetString(7) : ""; info.cardno = !dr.IsDBNull(8) ? dr.GetString(8) : ""; if (new HospitaPaymentService.wzszhjk.DAL.Database.Wzsdqrmyy.QueryInfoDal().HasPatientInfo(info.patientid, info.cardno) == 0) { info.patientid = ""; } //如果已绑卡判断绑卡是否失效 if (bindcardfalag == 1) { if (!IsCardnoValid(info.patientid, info.cardno, out msg)) { info.bindcardfalg = "未绑卡"; } } if (IsZYBrxxValid(info.idcardno, info.name, out msg)) { info.inpatentflag = "1"; } else { info.inpatentflag = "0"; } list.Add(info); } if (list.Count > 0) { msg = "找到联系人信息"; ret = 00; } else { msg = "没有联系人信息,请添加联系人!"; list = null; ret = 03; } 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(); } }