/// <summary>
/// 根据MQ用户ID获取该用户的所有的好友信息
/// </summary>
/// <param name="MQId">MQ用户ID</param>
/// <returns>IM中用户好友实体集合</returns>
public virtual IList <EyouSoft.Model.MQStructure.IMFriendList> GetFriendList(int MQId)
{
IList <Model.MQStructure.IMFriendList> List = new List <Model.MQStructure.IMFriendList>();
DbCommand dc = base.MQStore.GetSqlStringCommand(Sql_Select_GetFriendsById);
base.MQStore.AddInParameter(dc, "MQID", DbType.AnsiStringFixedLength, MQId.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MQStore))
{
Model.MQStructure.IMFriendList model = null;
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMFriendList();
model.MQId = MQId.ToString();
model.FriendMQId = dr["friendid"].ToString();
model.GroupName = dr["groupname"].ToString();
if (!dr.IsDBNull(dr.GetOrdinal("issuetime")))
{
model.IssueTime = DateTime.Parse(dr["issuetime"].ToString());
}
model.IsOnline = dr.GetInt16(dr.GetOrdinal("OnlineStatus")) > 11 ? true : false;
model.FriendName = dr["im_displayname"].ToString();
List.Add(model);
}
model = null;
}
return(List);
}
/// <summary>
/// 获取好友信息集合
/// </summary>
/// <param name="mqId">MQ编号</param>
/// <param name="groupName">分组名称 为空时返回不在任何分组里的好友</param>
/// <returns></returns>
public virtual IList <Model.MQStructure.IMFriendList> GetFriends(int mqId, string groupName)
{
if (mqId <= 0)
{
return(null);
}
IList <Model.MQStructure.IMFriendList> List = new List <Model.MQStructure.IMFriendList>();
DbCommand dc = base.MQStore.GetSqlStringCommand(SQL_SELECT_GetFriends);
base.MQStore.AddInParameter(dc, "MQID", DbType.AnsiStringFixedLength, mqId.ToString());
base.MQStore.AddInParameter(dc, "GROUPNAME", DbType.String, groupName);
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MQStore))
{
Model.MQStructure.IMFriendList model = null;
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMFriendList();
model.MQId = mqId.ToString();
model.FriendMQId = dr["FriendId"].ToString();
model.GroupName = groupName;
model.IsOnline = dr.GetInt16(dr.GetOrdinal("OnlineStatus")) > 11 ? true : false;
model.FriendName = dr["FriendName"].ToString();
List.Add(model);
}
model = null;
}
return(List);
}
/// <summary>
/// 获取IM好友信息(从mysql库获取数据)
/// </summary>
/// <param name="mqId">MQ编号</param>
/// <returns></returns>
private IList <Model.MQStructure.IMFriendList> GetFriends(int mqId)
{
IList <Model.MQStructure.IMFriendList> List = new List <Model.MQStructure.IMFriendList>();
DbCommand dc = base.MySQLStore.GetSqlStringCommand(string.Format(MYSQL_SELECT_GetFriends, mqId));
//MySql.Data.MySqlClient.MySqlParameter parm = new MySql.Data.MySqlClient.MySqlParameter("@MQID", MySql.Data.MySqlClient.MySqlDbType.Int32, 4);
//parm.Value = mqId;
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MySQLStore))
{
Model.MQStructure.IMFriendList model = null;
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMFriendList();
model.MQId = mqId.ToString();
model.FriendMQId = dr[0].ToString();
if (dr[1].ToString() != "")
{
model.GroupName = System.Text.UTF8Encoding.GetEncoding("gbk").GetString(System.Text.Encoding.GetEncoding("latin1").GetBytes(dr[1].ToString()));
}
else
{
model.GroupName = "";
}
List.Add(model);
}
model = null;
}
return(List);
}
