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