friendmanage.cs

来自「一个 用Ajax实现聊天室的简单例子 不全的地方指点」· CS 代码 · 共 38 行

using System;
using System.Collections.Generic;
using System.Text;
using System.Data.SqlClient;
using ChatModel;

namespace ChatDAL
{
    public class FriendManage
    {
        DBHelper db = new DBHelper();

        /// <summary>
        /// 找出好友头像及昵称
        /// </summary>
        /// <param name="userID"></param>
        /// <param name="typeID"></param>
        /// <returns></returns>
        public List<User> searchMyFridens(int userID, int typeID)
        {
            List<User> list = new List<User>();
            int ID = 0;
            string sql = "select friendID from friends where userID=" 
                + userID + " and friendType=" + typeID + "";
            SqlDataReader rs = db.getRead(sql);
            UserManage um = new UserManage();
            while (rs.Read())
            {
                ID = Convert.ToInt32(rs[0]);
                list.Add(um.getFace(ID));
            }
            rs.Close();
            db.closeCon();
            return list;
        }
    }
}