/// <summary>
        /// 取消对评论的不赞同
        /// </summary>
        /// <param name="Qusitionid"></param>
        /// <param name="Userid"></param>
        /// <param name="CmdUserid"></param>
        /// <param name="CmtedUserid"></param>
        /// <returns></returns>
        public bool DelPutDisLike(CommentPlus commentPlus)
        {
            SqlConnection sqlConnection = new SqlConnection(connectionstring);

            sqlConnection.Open();
            using (SqlCommand sqlCommand = sqlConnection.CreateCommand())
            {
                SqlTransaction sqlTransaction = sqlConnection.BeginTransaction();
                try
                {
                    string sql = "update CommentTable set DownCmtnum=DownCmtnum-1 where Qusitonid=@Qusitionid and Userid=@Userid and CmtUserid=@CmtUserid and CmtedUserid=@CmtedUserid and CmtTime=@datetime";
                    sqlCommand.CommandText = sql;
                    sqlCommand.Parameters.AddWithValue("@Qusitionid", commentPlus.Qusitionid);
                    sqlCommand.Parameters.AddWithValue("@Userid", commentPlus.Userid);
                    sqlCommand.Parameters.AddWithValue("@CmtUserid", commentPlus.CmtedUserid);
                    sqlCommand.Parameters.AddWithValue("@CmtedUserid", commentPlus.CmtedUserid);
                    sqlCommand.Parameters.AddWithValue("@datetime", commentPlus.Datetime);
                    sqlCommand.Transaction = sqlTransaction;
                    sqlCommand.ExecuteNonQuery();
                    sqlTransaction.Commit();
                    return(true);
                }
                catch (SqlException)
                {
                    sqlTransaction.Rollback();
                    return(false);
                }
                finally
                {
                    sqlConnection.Close();
                }
            }
        }
        /// <summary>
        /// 得到listviewitem中的子空间
        /// </summary>
        /// <param name="listViewItem"></param>
        /// <returns></returns>
        private CommentPlus GetCmtInfor(ListViewItem listViewItem)
        {
            int       CmtedUserid, CmdUserid;
            string    dateTime;
            TextBlock CmtUseridBlock = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("CmtUseridBlock") as TextBlock;

            CmdUserid = Convert.ToInt32(CmtUseridBlock.Text);
            TextBlock CmtedUseridBlock = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("CmtedUseridBlock") as TextBlock;

            CmtedUserid = Convert.ToInt32(CmtedUseridBlock.Text);
            var CmtTime = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("CmtTime") as TextBlock;

            dateTime = (CmtTime.Text);
            CommentPlus comment = new CommentPlus
            {
                Qusitionid  = Qusitionid,
                Userid      = Userid,
                CmdUserid   = CmdUserid,
                CmtedUserid = CmtedUserid,
                Datetime    = dateTime,
                Myid        = Myid
            };

            return(comment);
        }
        private async void CAcceptButton_Click(object sender, RoutedEventArgs e)
        {
            AppBarButton appBarButton = (AppBarButton)sender;
            ListViewItem listViewItem = FindParent <ListViewItem>(appBarButton);
            CommentPlus  commentp     = GetCmtInfor(listViewItem);
            var          box          = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("Commentadd") as TextBox;
            var          CmdName      = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("CmdName") as Button;
            var          CmdsName     = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("CmtUseridNameBlock") as TextBlock;
            var          cmtedName    = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("CmtedName") as Button;

            string  Text    = box.Text;
            Comment comment = new Comment
            {
                Qusitionid      = Comments.Qusitionid,
                Userid          = Comments.Userid,
                CmtContent      = Text,
                CmdUserid       = Myid,
                CmtedUserid     = Comments.CmtedUserid,
                CmtTime         = DateTime.Now,
                CmtedUseridName = CmdName.Content.ToString(),
                CmdUseridName   = people.Name,
                UseridName      = CmdsName.Text,
            };

            await PostComment(comment);

            if ((listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("AddCmdGrid") is Grid AddCmdGrid)
            {
                AddCmdGrid.Visibility = Visibility.Collapsed;
            }
        }
        /// <summary>
        /// 赞同按钮被点击
        /// </summary>
        /// <param name="sender"></param>
        /// <param name="e"></param>
        private async void LikeButton_Click(object sender, RoutedEventArgs e)
        {
            AppBarButton appBarButton = (AppBarButton)sender;
            ListViewItem listViewItem = FindParent <ListViewItem>(appBarButton);
            CommentPlus  commentPlus  = GetCmtInfor(listViewItem);
            var          fore         = appBarButton.Foreground as SolidColorBrush;

            if (fore.Color == Colors.Blue)
            {
                await DelPutCmdLike(commentPlus, listViewItem);
            }
            else
            {
                await PutCmdLike(commentPlus, listViewItem);
            }
        }
        private async Task DelPutCmdDislike(CommentPlus commentPlus, ListViewItem listViewItem)
        {
            int        Myid       = (HomePage.Current.myStruct.id);
            HttpClient httpClient = new HttpClient();

            httpClient.DefaultRequestHeaders.Clear();
            httpClient.DefaultRequestHeaders.Accept.Add(new System.Net.Http.Headers.MediaTypeWithQualityHeaderValue("application/json"));
            var content = new StringContent(JsonConvert.SerializeObject(commentPlus), Encoding.UTF8, "application/json");
            HttpResponseMessage httpResponseMessage = await httpClient.PutAsync($"http://localhost:60671/api/comment/delputdislike", content);

            var res = await httpResponseMessage.Content.ReadAsAsync <bool>();

            if (res == true)
            {
                Modifyinf(listViewItem, 1, commentPlus);
            }
        }
        /// <summary>
        /// 修改按钮的颜色
        /// </summary>
        /// <param name="listViewItem"></param>
        /// <param name="option"></param>
        /// <param name="CmdUserid"></param>
        /// <param name="CmtedUserid"></param>
        private void Modifyinf(ListViewItem listViewItem, int option, CommentPlus commentP)
        {
            var comment = commentPlus.Where(p => p.CmdUserid == commentP.CmdUserid && p.CmtedUserid == commentP.CmtedUserid).FirstOrDefault();

            if (listViewItem != null)
            {
                AppBarButton LikeButton    = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("LikeButton") as AppBarButton;
                AppBarButton DisLikeButton = (listViewItem.ContentTemplateRoot as FrameworkElement)?.FindName("DislikeButton") as AppBarButton;
                ///点击like按钮,根据颜色来判断
                if (option == 0)
                {
                    var fore = LikeButton.Foreground as SolidColorBrush;
                    if (fore.Color == Colors.Black)
                    {
                        comment.UpCmtnum++;
                        LikeButton.Foreground = new SolidColorBrush(Colors.Blue);
                        NameMap.UPAnswerCmt.Add($"{commentP.Qusitionid} {commentP.Userid} {commentP.Datetime} {Myid} {commentP.CmdUserid} {commentP.CmtedUserid}");
                    }
                    else if (fore.Color == Colors.Blue)
                    {
                        comment.UpCmtnum--;
                        LikeButton.Foreground = new SolidColorBrush(Colors.Black);
                        NameMap.UPAnswerCmt.Remove($"{commentP.Qusitionid} {commentP.Userid} {commentP.Datetime} {Myid} {commentP.CmdUserid} {commentP.CmtedUserid}");
                    }
                    LikeButton.Label = (comment.UpCmtnum).ToString();
                }
                else///点击dislike按钮,根据颜色来判断
                {
                    var fore = DisLikeButton.Foreground as SolidColorBrush;
                    if (fore.Color == Colors.Black)
                    {
                        comment.DownCmtnum++;
                        DisLikeButton.Foreground = new SolidColorBrush(Colors.Blue);
                        NameMap.DNAnswerCmt.Add($"{commentP.Qusitionid} {commentP.Userid} {commentP.Datetime} {Myid} {commentP.CmdUserid} {commentP.CmtedUserid}");
                    }
                    else if (fore.Color == Colors.Blue)
                    {
                        comment.DownCmtnum--;
                        DisLikeButton.Foreground = new SolidColorBrush(Colors.Black);
                        NameMap.DNAnswerCmt.Remove($"{commentP.Qusitionid} {commentP.Userid} {commentP.Datetime} {Myid} {commentP.CmdUserid} {commentP.CmtedUserid}");
                    }
                    DisLikeButton.Label = (comment.DownCmtnum).ToString();
                }
            }
        }
        public bool DelPutdislike([FromBody] CommentPlus commentPlus)
        {
            CommentAccess commentAccess = new CommentAccess();

            return(commentAccess.DelPutDisLike(commentPlus));
        }
        public bool PutLike([FromBody] CommentPlus commentPlus)
        {
            CommentAccess comment = new CommentAccess();

            return(comment.PutLike(commentPlus));
        }