/// <summary>
/// 获取缴费或退费联系人列表 （FY030101）
/// </summary>
/// <param name="openid"></param>
/// <param name="values"></param>
/// <param name="msg"></param>
/// <returns>1=获取成功、其他代表失败</returns>
public int QueryConnectPerson(string openid, out ArrayList values, out string msg)
{
int ret = -1;
values = new ArrayList();
msg = "";
string sqlQuery = string.Format("select linkmanid, label, name from ZFB_TIANJIACYLXR " +
"where openid = '{0}'", openid);
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
dr = DbHelperOra.ExecuteReader(sqlQuery, connection);
if (dr.HasRows)
{
ConnectPerson entity = new ConnectPerson();
entity.brid = !dr.IsDBNull(0) ? dr.GetString(0) : "";
entity.label = !dr.IsDBNull(1) ? dr.GetString(1) : "";
entity.name = !dr.IsDBNull(2) ? dr.GetString(2) : "";
values.Add(entity);
}
}
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();
}
return(1);
}
/// <summary>
///
/// </summary>
/// <param name="id"></param>
/// <param name="type"></param>
/// <param name="values"></param>
/// <param name="msg"></param>
/// <returns></returns>
public int QueryPatientInfo(string id, string type, out ArrayList values, out string msg)
{
values = new ArrayList();
msg = "";
int ret = -1;
string sqlQuery = string.Format(" select * from FY030102 where id={0} and type={1} ", id, type);
OracleConnection connection = new OracleConnection(WebConfigParameter.ConnectionHisString);
OracleDataReader dr = null;
try
{
dr = DbHelperOra.ExecuteReader(sqlQuery, connection);
if (dr.HasRows)
{
ConnectPerson entity = new ConnectPerson();
entity.brid = !dr.IsDBNull(0) ? dr.GetString(0) : "";
entity.label = !dr.IsDBNull(1) ? dr.GetString(1) : "";
entity.name = !dr.IsDBNull(2) ? dr.GetString(2) : "";
values.Add(entity);
}
}
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();
}
return(1);
}
