Demo/ProjectListLike.aspx.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Demo.Helper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace Demo
{
    public partial class ProjectListLike : Page
    {
        private string LoginId = CookieHelper.GetCookie("Aid", "LoginId");
        private bool IsAdmin = false;
        protected void Page_Load(object sender, EventArgs e)
        {
            if(string.IsNullOrEmpty(LoginId))
            {
                Response.Write("<script>alert('请您先登录再操作!');window.location.href='Login.aspx';</script>");
                Response.End();
            }
            if (!IsPostBack)
            {
                bind();
            }
        }
        //绑定数据
        public void bind()
        {
            DataSet datauser = DBHelper.GetDataTable($"select * from UserInfo where id='{LoginId}'").DataSet;
            if (Convert.ToString(datauser.Tables[0].Rows[0][1]) == "1")
            {
                IsAdmin = true;
            }
            DataTable data = DBHelper.GetDataTable($"select * from [Project]");
            GridViewbook.DataSource = data.DataSet;
            GridViewbook.DataBind();
        }

        protected void GridViewbook_RowDeleting(object sender, GridViewDeleteEventArgs e)
        {
            int id = Convert.ToInt32(this.GridViewbook.DataKeys[e.RowIndex].Value);
            DataSet datapri = DBHelper.GetDataTable($"select * from [Project] where pid='{id}'").DataSet;
            int IsScore = Convert.ToInt32(datapri.Tables[0].Rows[0][10]);
            if (IsScore > 0)
            {
                Response.Write("<script>alert('该计划你已经点赞!');window.location.href='ProjectListLike.aspx';</script>");
                Response.End();
            }

            string str = $"update [Project] set [Score]+= 5,IsScore=1 where Pid=" + id;
            int num = DBHelper.ExecuteNonQuery(str);
            string sqluser = string.Format("update UserInfo set score+=5 where id={0}", LoginId);
            DBHelper.ExecuteNonQuery(sqluser);
            if (num > 0)
            {
                Response.Write("<script>alert('点赞成功!')</script>");
            }
            else