ShowArticle.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 ShowArticle : Form
    {
        // 声明全局变量，存放点赞点踩数
        public int up_num;
        public int down_num;

        public ShowArticle()
        {
            InitializeComponent();
        }

        private void ShowArticle_Load(object sender, EventArgs e)
        {
            // 窗口初始化设置
            // 焦点重定向
            button_search.Focus();
            // 页面清空
            label_title.Text = "";
            label_author.Text = "";
            richTextBox_content.Text = "";
            button_up_num.Text = "0";
            button_down_num.Text = "0";
            // 页面内数据展示
            if (DataShare.ArticleId == null || DataShare.ArticleId == "")
            {
                MessageBox.Show("未知错误！可能未声明文章ID~");
                this.Close();
            }
            else 
            {
                // 渲染页面
                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 title,content,name,up_num,down_num FROM article RIGHT JOIN user ON article.user_id = user.id WHERE article.id = '" + DataShare.ArticleId + "';";
                MySqlCommand sqlCommand1 = new MySqlCommand(sql1, sqlConnection);
                MySqlDataReader sqlDataReader1 = sqlCommand1.ExecuteReader();
                bool isExit = sqlDataReader1.HasRows;
                if (isExit)
                {
                    sqlDataReader1.Read(); // 必须先Read()
                    label_title.Text = sqlDataReader1["title"].ToString();
                    label_author.Text = sqlDataReader1["name"].ToString();
                    richTextBox_content.Text = sqlDataReader1["content"].ToString();
                    up_num = Convert.ToInt32(sqlDataReader1["up_num"]);
                    button_up_num.Text = up_num.ToString();
                    down_num = Convert.ToInt32(sqlDataReader1["down_num"]);