TalkInfo.aspx.cs

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

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

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;

public partial class TalkInfo : System.Web.UI.Page
{
    public string sql, dID;

    Alert al = new Alert();
    SqlHelper data = new SqlHelper();
    protected void Page_Load(object sender, EventArgs e)
    {
        this.Title = "个人网站";
        dID = Request.QueryString["id"].ToString().Trim();
        if (!IsPostBack)
        {
            data.RunSql("update Talks set [count]=[count]+1 where TalkId=" + dID);
            sql = "select * from Talks where TalkId=" + dID;
            getdata(sql);


        }
        sql = "select * from View_ReTalks where TalksID=" + dID;
        DataList1.DataSource = data.GetDs(sql, "View_ReTalks").Tables[0];
        DataList1.DataBind();

        string uid = Session["UserId"] == null ? "0" : Session["UserId"].ToString();
        hfuserid.Value = uid;


    }
    private void getdata(string sql)
    {
        SqlDataReader dr = data.GetDataReader(sql);
        if (dr.Read())
        {
            //Label1.Text = dr["CreateTime"].ToString();
            //Label2.Text = dr["name"].ToString();
            this.DIV1.InnerHtml = dr["Talkcontent"].ToString();
            this.Label1.Text = "(" + dr["PraiseCount"] + ")";
            this.Label2.Text = "(" + dr["EggCount"] + ")";
        }

    }
    protected void ImageButton9_Click(object sender, ImageClickEventArgs e)
    {
        try
        {
            //if (Session["UserId"] != null)
            //{
            string sql = "insert into ReTalks(TalksID, ReplyContent, UserId, CreateTime) values('" + Request.QueryString["id"] +
                "','" + txtContent.Text.Trim() + "','" + hfuserid.Value + "','" + DateTime.Now + "')";
            data.RunSql(sql);
            txtContent.Text = "";

            //修改帖子回复数