public IHttpActionResult FanList(string user_id) //返回粉丝列表
{
OracleConnection conn = new OracleConnection(DBAccess.connStr);
try
{
conn.Open();
}
catch (Exception ex)
{
throw (ex);
}
OracleCommand cmd = new OracleCommand();
cmd.Connection = conn;
cmd.CommandText = "select USER_ID from Follow_User where FOLLOWING_ID='" + user_id + "'";//找到所有关注此用户的ID
OracleDataReader rd = cmd.ExecuteReader();
List <User_Follow> followed_list = new List <User_Follow>();
if (!rd.HasRows)
{
conn.Close();
return(Ok("Not found"));
}
while (rd.Read())
{
string followed_id = rd["USER_ID"].ToString();
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "select * from Users where ID='" + followed_id + "'";//根据ID查找用户的所有信息
cmd1.Connection = conn;
OracleDataReader rd1 = cmd1.ExecuteReader();
if (rd1.Read())
{
User_Follow temp = new User_Follow();
temp.ID = rd1["ID"].ToString();
temp.Email = rd1["EMAIL"].ToString();
temp.Username = rd1["USERNAME"].ToString();
temp.Bio = rd1["BIO"].ToString();
temp.Photo = rd1["PHOTO"].ToString();
cmd1.CommandText = "select * from Follow_User where USER_ID='" + user_id + "'and FOLLOWING_ID='" + followed_id + "'";
rd1 = cmd1.ExecuteReader();
if (rd1.HasRows)
{
temp.FollowState = "True";
}
else
{
temp.FollowState = "False";
}
followed_list.Add(temp);
}
rd1.Close();
}
rd.Close();
conn.Close();
return(Json <List <User_Follow> >(followed_list));
}
public IHttpActionResult Search_user(string user_id, string keyword)
{
OracleConnection conn = new OracleConnection(DBAccess.connStr);
try
{
conn.Open();
}
catch (Exception ex)
{
throw (ex);
}
OracleCommand cmd = new OracleCommand();
cmd.CommandText = "select * from USERS where USERNAME like'%" + keyword + "%'";//查找匹配的字符串
cmd.Connection = conn;
OracleDataReader rd = cmd.ExecuteReader();
List <User_Follow> User_list = new List <User_Follow>(); //用户列表
if (!rd.HasRows)
{
return(Ok("Not found"));
}
while (rd.Read())
{
User_Follow temp = new User_Follow();
temp.ID = rd["ID"].ToString();
temp.Email = rd["EMAIL"].ToString();
//temp.Password = rd["PASSWORD"].ToString();
temp.Username = rd["USERNAME"].ToString();
temp.Bio = rd["BIO"].ToString();
temp.Photo = rd["PHOTO"].ToString();
OracleCommand cmd1 = new OracleCommand();
cmd1.CommandText = "select * from FOLLOW_USER where USER_ID='" + user_id + "'and FOLLOWING_ID='" + temp.ID + "'";
cmd1.Connection = conn;
OracleDataReader rd1 = cmd1.ExecuteReader();
if (!rd1.HasRows)
{
temp.FollowState = "False";
}
else
{
temp.FollowState = "True";
}
User_list.Add(temp);
}
rd.Close();
conn.Close();
return(Json <List <User_Follow> >(User_list));
}
public IHttpActionResult GetLikeList(string email, string moment_id)
{
//todo:连接数据库
DBAccess dBAccess = new DBAccess();
//执行数据库select操作
OracleDataReader rd = dBAccess.GetDataReader(" select u.* from FAVORITE f, USERS u where f.moment_id = '" + moment_id + "' and f.user_id = u.id ");
//创建Users对象List，并向其中添加读出的数据库信息
List <User_Follow> resultList = new List <User_Follow>();
//创建api对象
GeneralAPI api = new GeneralAPI();
while (rd.Read()) //当数据库能读出一条符合条件的元组，执行循环
{
User_Follow uf = new User_Follow();
uf.ID = rd["ID"].ToString();
uf.Username = rd["USERNAME"].ToString();
uf.Photo = rd["PHOTO"].ToString();
uf.Email = rd["EMAIL"].ToString();
uf.Bio = rd["BIO"].ToString();
string user_id = api.EmailToUserID(email);
int follow_state = api.CheckFollowState(user_id, rd["ID"].ToString());
if (follow_state == 0)//关注
{
uf.FollowState = "true";
}
else//未关注
{
uf.FollowState = "false";
}
resultList.Add(uf);
}
return(Json <List <User_Follow> >(resultList));//返回符合条件的Users列表
}
