messagedetails.aspx.cs

贸易有限公司项目管理系统(C#.NET2003),供学习参考！

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;
using System.Data.SqlClient;
public partial class MessageDetails : System.Web.UI.Page
{
    /// <summary>
    /// 加载时显示短信内容
    /// </summary>
    /// <param name="sender"></param>
    /// <param name="e"></param>
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["Name"] == null)
        {
            JS.Alert("您还未登陆或登陆超时！");
            Response.Redirect("Default.aspx");
        }
        int ID =Convert.ToInt32(Request.QueryString["ID"].ToString());
        
        SqlConnection con = DB.createCon();
        con.Open();
        SqlCommand cmd = new SqlCommand("select Content from Message where ID='" + ID + "'", con);
        SqlDataReader dr = cmd.ExecuteReader();
        if (dr.Read())
        {
            txtMessage.Text = dr["Content"].ToString();
        }
        dr.Close();
        SqlCommand SetRead=new SqlCommand("update Message set IfRead='已经阅读' where ID='" + ID + "'", con);
        SetRead.ExecuteNonQuery();


    }
    protected void txtMessage_TextChanged(object sender, EventArgs e)
    {

    }
}