//根据用户名查找用户 public SqlDataReader searchFriendByName(string name) { string sqlStr = "select * from [user] where username like '%" + name + "%'"; SqlDataReader result = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, null); return(result); }
//获得g_ID public int get_g_ID(int uId, string name) { int g_ID = 0; string sqlStr = "select [g_id] from [group] where u_id=@UId and name=@Name"; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter UId = new SqlParameter("@UId", SqlDbType.Int); SqlParameter Name = new SqlParameter("@Name", SqlDbType.VarChar); UId.Value = uId; Name.Value = name; parameters.Add(UId); parameters.Add(Name); Console.WriteLine(parameters.ToString() + "------>" + uId); SqlDataReader reader = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, parameters); if (reader.HasRows) { while (reader.Read()) { if (!(reader["g_id"] is System.DBNull)) { g_ID = Convert.ToInt32(reader["g_id"].ToString().Trim()); } } } return(g_ID); }
//搜索群 public SqlDataReader searchChatRoomByName(string Name) { string sqlStr = "select [c_id] as [c_id],[name] as [name],[chatroom].[time] as [time],[limit_num] as [limit_num],[leader_id] as [leader_id],[u_id] as [u_id] from [chatroom],[chatroom_member] where [chatroom].[c_id] = [chatroom_member].chatroom_id and [chatroom].name like '%" + Name + "%'"; SqlDataReader result = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, null); return(result); }
//查询最新插入的chatRoom的端口 public int getLastePort() { string sqlStr = "select top 1 [chatroom_port] as port from [chatRoom] order by time Desc"; int port = 0; SqlDataReader reader = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, null); if (reader.HasRows) { while (reader.Read()) { port = Convert.ToInt32(reader["port"].ToString()); } } return(port); }
//查询最新插入的chatRoom的id public int getLasteID() { string sqlStr = "select top 1 [c_id] as c_id from [chatRoom] order by time Desc"; int id = 0; SqlDataReader reader = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, null); if (reader.HasRows) { while (reader.Read()) { id = Convert.ToInt32(reader["c_id"].ToString()); } } return(id); }
//发起群组聊天,查找群内成员在线人员IP public ArrayList searchIp(int Cid) { string sqlStr = "select last_login_ip from [user] where status=1 and u_id in (select u_id from [chatroom_member] where chatroom_id=@Cid)"; ArrayList onlineIp = new ArrayList(); List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter chatroom_id = new SqlParameter("@Cid", SqlDbType.Int); chatroom_id.Value = Cid; parameters.Add(chatroom_id); SqlDataReader reader = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, parameters); if (reader.HasRows) { while (reader.Read()) { onlineIp.Add(reader["last_login_ip"].ToString()); } } return(onlineIp); }
//添加用户到对应的分组 //获得到用户最大的groupID public int getMax_g_ID(int uId) { int maxID = 0; string sqlStr = "select MAX([g_id]) as g_max_id from [group] where u_id=@UId"; List <SqlParameter> parameters = new List <SqlParameter>(); SqlParameter UId = new SqlParameter("@UId", SqlDbType.Int); UId.Value = uId; parameters.Add(UId); Console.WriteLine(parameters.ToString() + "------>" + uId); SqlDataReader reader = SqlDbHelper.ExecuteReader(sqlStr, CommandType.Text, parameters); if (reader.HasRows) { while (reader.Read()) { if (!(reader["g_max_id"] is System.DBNull)) { maxID = Convert.ToInt32(reader["g_max_id"].ToString().Trim()); } } } return(maxID); }