Admin.cs

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

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

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Windows.Forms;

using MySql.Data.MySqlClient;

namespace BBS
{
    public partial class Admin : Form
    {
        public Admin()
        {
            InitializeComponent();
        }

        private void linkLabel_user_MouseHover(object sender, EventArgs e)
        {
            // 设置鼠标悬浮事件
            linkLabel_user.LinkColor = Color.Red;
        }

        private void linkLabel_user_MouseLeave(object sender, EventArgs e)
        {
            // 设置鼠标离开事件
            linkLabel_user.LinkColor = Color.MediumBlue;
        }

        private void Admin_Load(object sender, EventArgs e)
        {
            // 初始化配置
            string linkstr = "Server=127.0.0.1;User ID=root;Password=51aspx;Database=bbs_csharp;";
            MySqlConnection coon = new MySqlConnection(linkstr);
            coon.Open();
            string sqlstr = "SELECT article.id '文章ID',title '标题',abstract '摘要',content '内容',create_time '发布时间',up_num '点赞数',down_num '点踩数',name '分类' FROM article RIGHT JOIN category ON category_id = category.id WHERE article.user_id = '" + DataShare.LoginUserId +"';";
            MySqlCommand cmd = new MySqlCommand(sqlstr, coon);
            MySqlDataAdapter ada = new MySqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            ada.Fill(ds);//查询结果填充数据集
            dataGridView.DataSource = ds.Tables[0];
            coon.Close();
            // 刷新按钮不可用
            button_refresh.Enabled = false;
            // 隐藏提示
            label_back_home.Visible = false;
            // 用户名
            string sqlconf = "Server=127.0.0.1;User ID=root;Password=51aspx;Database=bbs_csharp;";
            MySqlConnection sqlConnection = new MySqlConnection(sqlconf);
            sqlConnection.Open();
            string sql1 = "select name from user where id = '" + DataShare.LoginUserId + "';";
            MySqlCommand sqlCommand1 = new MySqlCommand(sql1, sqlConnection);
            MySqlDataReader sqlDataReader1 = sqlCommand1.ExecuteReader();
            bool isUserExit = sqlDataReader1.HasRows;
            sqlDataReader1.Read(); // 必须先Read()
            linkLabel_user.Text = sqlDataReader1["name"].ToString();
            sqlDataReader1.Close();