public Task<vpostinfo> Task_info_query(a_articles article) { return Task<vpostinfo>.Run(() => { return (from pi in db.vpostinfoes where pi.pi_postID == article.a_p_id select pi).Distinct().ToList().First(); }); }
private async void builderArticleInfo (a_articles article) { if(article == null) { articleid.Text = "-"; articledate.Text = "-"; articleauthor.Text = "-"; articletitle.Text = "-"; articlecontent.Text = "-"; } else { list.IsEnabled = false; articles.IsEnabled = false; var info = await controller.Task_info_query(article); list.IsEnabled = true; articles.IsEnabled = true; articleid.Text = info.pi_postID.ToString(); articledate.Text = info.pi_postDate.ToString(); articleauthor.Text = info.pi_user; articletitle.Text = info.pi_postTitle.Length > 20 ? info.pi_postTitle.Substring(0, 20) + " ..." : info.pi_postTitle; articlecontent.Text = info.pi_postContent.Length > 20 ? info.pi_postContent.Substring(0, 20)+" ..." : info.pi_postContent; } }
private async void submitArticle_Click(object sender, RoutedEventArgs e) { string author = newArticleAuthor.Text; string title = newArticleTitle.Text; string content = newArticleContent.Text; p_posts post = new p_posts(); post.p_id = ((from p in db.p_posts select p.p_id).Max()) + 1; post.p_content = content; post.p_date = DateTime.Now; post.p_u_username = author; a_articles article = new a_articles(); article.a_p_id = post.p_id; article.a_title = title; article.a_c_clove = ((vcloveinfo)list.SelectedItem).ci_cloveID; article.a_r_rank = null; db.p_posts.Add(post); db.a_articles.Add(article); db.SaveChanges(); articles.ItemsSource = await controller.Task_articles_ItemsSource((vcloveinfo)list.SelectedItem); articles.DisplayMemberPath = "a_title"; newArticleAuthor.Text = ""; newArticleTitle.Text = ""; newArticleContent.Text = ""; }