public async void GetUserAttention(int pageNum) { try { pr_Load.Visibility = Visibility.Visible; IsLoading = true; string results = await WebClientClass.GetResults(new Uri("https://api.bilibili.com/x/relation/followings?vmid=" + Uid + "&ps=20&pn=" + pageNum + "&order=desc&jsonp=json")); //一层 GetUserFollow model1 = JsonConvert.DeserializeObject <GetUserFollow>(results); if (model1.code == 0) { //二层 // GetUserAttention model2 = JsonConvert.DeserializeObject<GetUserAttention>(model1.data.ToString()); // MaxPage = model2.pages; //三层 // List<GetUserAttention> lsModel = JsonConvert.DeserializeObject<List<GetUserAttention>>(model2.list.ToString()); foreach (GetUserFollow item in model1.data.list) { list_AUser.Items.Add(item); } page++; } else { Utils.ShowMessageToast(model1.message, 2000); } } catch (Exception) { if (list_AUser.Items.Count == 0) { Utils.ShowMessageToast("没有关注任何人", 2000); } else { Utils.ShowMessageToast("读取关注失败!", 2000); } //await new MessageDialog("读取关注失败!\r\n" + ex.Message).ShowAsync(); } finally { pr_Load.Visibility = Visibility.Collapsed; IsLoading = false; } }
private GetUserFollow GetGetUserFollow(DataRow dataRow) { GetUserFollow getUserFollow = new GetUserFollow { Qusitonid = Convert.ToInt32(dataRow["Qusitonid"]), Askerid = Convert.ToInt32(dataRow["Askerid"]), AskTime = Convert.ToDateTime(dataRow["AskTime"].ToString()), UpAskTime = Convert.ToDateTime(dataRow["UpAskTime"].ToString()), QusitionTitle = dataRow["QusitonTitle"].ToString(), QusitionContent = dataRow["QusitonContent"].ToString(), Answerednum = Convert.ToInt32(dataRow["Answerednum"]), Followednum = Convert.ToInt32(dataRow["Followednum"]), Qlabel0 = dataRow["QLabel0"].ToString(), Qlabel1 = dataRow["QLabel1"].ToString(), Qlabel2 = dataRow["QLabel2"].ToString(), FollowQTime = Convert.ToDateTime(dataRow["FollowQTime"].ToString()) }; return(getUserFollow); }
/// <summary> /// 得到某个人关注的全部问题 /// </summary> /// <param name="Userid"></param> /// <returns></returns> public string GetUserFQ(int Userid) { SqlConnection sqlConnection = new SqlConnection(connectionstring); sqlConnection.Open(); try { string sql = "select Qusitonid,FollowQTime,UpAskTime," + " Askerid,AskTime,QusitonTitle,QusitonContent,Answerednum,Followednum,QLabel0,QLabel1,QLabel2 " + "from QusitonFollowTable inner join QusitonTable" + " on QusitonFollowTable.Userid=@Userid and QusitonFollowTable.Qusitionid = QusitonTable.Qusitonid and QusitonFollowTable.Qusitionid not in " + "(select Qusitonid from AnswerTable where AnswerTable.Userid = @LUserid) ORDER BY FollowQTime desc"; SqlCommand sqlCommand = sqlConnection.CreateCommand(); sqlCommand.CommandText = sql; sqlCommand.Parameters.AddWithValue("@Userid", Userid); sqlCommand.Parameters.AddWithValue("@LUserid", Userid); SqlDataAdapter sqlDataAdapter = new SqlDataAdapter { SelectCommand = sqlCommand }; DataTable dataTable = new DataTable(); sqlDataAdapter.Fill(dataTable); List <GetUserFollow> qusitions = new List <GetUserFollow>(); GetUserFollow getUserFollow; foreach (DataRow item in dataTable.Rows) { getUserFollow = new GetUserFollow(); getUserFollow = GetGetUserFollow(item); qusitions.Add(getUserFollow); } return(JsonConvert.SerializeObject(qusitions)); } catch (SqlException) { return(string.Empty); } finally { sqlConnection.Close(); } }