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