userfriendsservice.cs

简单聊天系统,自己做的,有数据库.多多支持,做的不好,请大家原谅.

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

namespace NewChartDAL
{
   public  class UserFriendsService
    {
       public static IList<FriendsTypeInfo> GetFriendsType()
       {
           List<FriendsTypeInfo> list = new List<FriendsTypeInfo>();

           string sql = "select * from FriendsTypeInfo";
           FriendsTypeInfo friendType = null;
           using(SqlDataReader reader = DBHelper.GetReader(sql))
           {
               while (reader.Read())
               {
                   friendType = new FriendsTypeInfo();
                   friendType.Id =(int)reader["Id"];
                   friendType.TypeName = reader["TypeName"].ToString();
                   list.Add(friendType);
               }
           }
           return list;
       }


       public static IList<UserFriendsInfo> GetFriendsByUserIdAddTypeId(int userId,int typeId)
       {
           List<UserFriendsInfo> friendsInfo = new List<UserFriendsInfo>();
           string sql = "select FriendUserId from UserFriends where UserId=@UserId and FriendType=@FriendType";
           UserFriendsInfo info = null;
           
           SqlParameter[] p=new SqlParameter[]
           {
                new SqlParameter("@UserId",userId),
                new SqlParameter("@FriendType",typeId)
           };

           using (SqlDataReader reader = DBHelper.GetReader(sql, p))
           {
               while(reader.Read())
               {
               info = new UserFriendsInfo();
               UsersInfo ui = new UsersInfo();
               ui.Id=(int)reader["FriendUserId"];
               info.Friend = ui;
               friendsInfo.Add(info);
              }
          }

          return friendsInfo;
       }
   

    }
}