/// <summary>
/// 获取IM好友分组信息(从mysql库获取数据)
/// </summary>
/// <param name="mqId">MQ编号</param>
/// <returns></returns>
private IList <Model.MQStructure.IMGroupList> GetFriendGroups(int mqId)
{
IList <Model.MQStructure.IMGroupList> List = new List <Model.MQStructure.IMGroupList>();
DbCommand dc = base.MySQLStore.GetSqlStringCommand(string.Format(MYSQL_SELECT_GetFriendGroups, mqId));
//base.MySQLStore.AddInParameter(dc, "uid", DbType.Int32, 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.IMGroupList model = null;
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMGroupList();
model.MQId = mqId.ToString();
if (dr[0].ToString() != "")
{
model.GroupName = System.Text.UTF8Encoding.GetEncoding("gbk").GetString(System.Text.Encoding.GetEncoding("latin1").GetBytes(dr[0].ToString()));
}
else
{
model.GroupName = "";
}
if (!dr.IsDBNull(1))
{
model.FriendCount = dr.GetInt32(1);
}
List.Add(model);
}
model = null;
}
return(List);
}
/// <summary>
/// 获取好友分组信息集合
/// </summary>
/// <param name="mqId">MQ编号</param>
/// <returns></returns>
public virtual IList <Model.MQStructure.IMGroupList> GetFriendGroups(int mqId)
{
IList <Model.MQStructure.IMGroupList> friendGroups = new List <Model.MQStructure.IMGroupList>();
DbCommand dc = base.MQStore.GetSqlStringCommand(SQL_SELECT_GetFriendGroups);
base.MQStore.AddInParameter(dc, "MQID", DbType.AnsiStringFixedLength, mqId.ToString());
using (IDataReader dr = DbHelper.ExecuteReader(dc, base.MQStore))
{
Model.MQStructure.IMGroupList model = null;
while (dr.Read())
{
model = new EyouSoft.Model.MQStructure.IMGroupList();
model.MQId = mqId.ToString();
model.GroupName = dr[0].ToString();
if (!dr.IsDBNull(1))
{
model.OnlineFriendCount = dr.GetInt32(1);
}
if (!dr.IsDBNull(2))
{
model.FriendCount = dr.GetInt32(2);
}
if (!dr.IsDBNull(3))
{
model.IssueTime = dr.GetDateTime(3);
}
friendGroups.Add(model);
}
model = null;
}
return(friendGroups);
}
