Admin/relay.aspx.cs

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

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

public partial class Admin_relay : System.Web.UI.Page
{
    DataSet dt = new DataSet();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!this.IsPostBack)
        {
            this.Bind();
        }
    }
    private void Bind()
    {
        int mid = int.Parse(this.Request.QueryString["mid"].ToString());

        string sql = "Select Messages_ID, Messages_Name,Messages_Content,Messages_Time from Message where IsDelete=0 and Messages_ID="+mid;
        dt = HouseSystem.SQLDAL.SQLHelper.ExecuteDataset(sql.ToString());

         this.msglabel.Text =dt.Tables[0].Rows[0]["Messages_Content"].ToString();
    }

    protected void relaybt_Click(object sender, EventArgs e)
    {
        string sql = "Insert into Relay (Relay_Content,Messages_ID,MUser_ID) values('" + relaycontent.Text + "','" + Request.QueryString["mid"].ToString() + "','" + Session["name"] + "')";

        if (HouseSystem.SQLDAL.SQLHelper.ExecuteNonQuery(sql) == 1)
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('回复留言成功')</script>", false);
        }
        else
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('回复留言失败')</script>", false);
        }
    }

    protected void updaterelaybt_Click(object sender, EventArgs e)
    {
        if (1== 1)
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('修改留言成功')</script>", false);
            this.relaybt.Visible = false;
            this.updaterelaybt.Visible = true;
        }
        else
        {
            Page.ClientScript.RegisterClientScriptBlock(this.GetType(), "alert", "<script>alert('修改留言失败')</script>", false);
        }
    }
}