revertmessage.aspx.cs

内容管理 内容管理 内容管理 内容管理 内容管理

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 WebPage_RevertMessage : System.Web.UI.Page
{
    private string oid = "", VirtualPath="";

    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            if (Request["ID"] != null)
            {
                oid = Request["ID"].ToString();
            }

            if (oid != "")
            {
                getMessage(oid);
            }
        }
    }



    private void getMessage(string oid)
    {
        DataSet ds = new DataSet();
        DAL.boBusiness bo = new DAL.boBusiness();
        DAL.MakeConnection Conn = new DAL.MakeConnection();
        DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
        ConnKey = bo.loadkey();//得到config数据库连接	

        string sql = "";
        try
        {
            
            if (oid != "")
            {
                sql = "Select ID,Title,LeavewordTime,Email,Content,IP,RevertContent,WebUser,IsNominate "
                    + ",(select Title from Article Where Article.ID=MessageBoard.ArticleID ) as ArticleTitle "
                    + " from MessageBoard where ID=" + oid + " order by leavewordtime desc";
            }
            else
            {
                sql = "Select ID,Title,LeavewordTime,Email,Content,IP,RevertContent,WebUser,IsNominate "
                    + ",(select Title from Article Where Article.ID=MessageBoard.ArticleID ) as ArticleTitle "
                    + " from MessageBoard order by leavewordtime desc";
            }
            ds = (DataSet)Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_DataSet, DAL.
                EnumDBType.Sql, VirtualPath);

            if (ds.Tables[0].Rows.Count > 0)
            {
                switch (ds.Tables[0].Rows[0]["IsNominate"].ToString().ToLower())
                {
                    case "true": this.VisibleMessage.Items[0].Selected=true; break;
                    case "false": this.VisibleMessage.Items[1].Selected=true; break;

                }


                seachNum.Text = ds.Tables[0].Rows[0]["ID"].ToString();
                Name.Text = ds.Tables[0].Rows[0]["WebUser"].ToString();
                Email.Text = ds.Tables[0].Rows[0]["Email"].ToString();
                ip.Text = ds.Tables[0].Rows[0]["IP"].ToString();
                Content.Text = ds.Tables[0].Rows[0]["Content"].ToString();
                this.LeavewordTime.Text = ds.Tables[0].Rows[0]["LeavewordTime"].ToString();
                ArticleTitle.Text = ds.Tables[0].Rows[0]["ArticleTitle"].ToString();
                oldRevert.Text = ds.Tables[0].Rows[0]["RevertContent"].ToString();

                Title.Text = ds.Tables[0].Rows[0]["Title"].ToString();

                if (Title.Text != "")
                {
                    labFunState.Text = "回复 <font color='gray'>『" + ds.Tables[0].Rows[0]["title"].ToString() + "』</font>";
                }
                else
                {

                    labFunState.Text = "回复";
                }

                if (ds.Tables[0].Rows[0]["RevertContent"] != System.DBNull.Value)
                {
                    oldRevert.Text = ds.Tables[0].Rows[0]["RevertContent"].ToString();
                }
                else
                {
                    oldRevert.Visible = false;
                    Label1.Visible = false;
                    Label2.Text = "回复留言:";
                }


            }
        }
        catch (System.Exception ex)
        {
            throw ex;
        }
    }




    protected void Revert_Click(object sender, EventArgs e)
    {
        bool blnSaveState = true;
        string strErrMsg = "";
        DataSet ds = new DataSet();
        DAL.boBusiness bo = new DAL.boBusiness();
        DAL.MakeConnection Conn = new DAL.MakeConnection();
        DAL.clsDBConnkey ConnKey = new DAL.clsDBConnkey();
        ConnKey = bo.loadkey();//得到config数据库连接	

        try
        {
            string ip = "", sql = "", uid = "", UserName = "";
            ip = Request.ServerVariables["REMOTE_ADDR"];
       

            HttpCookie Cookie = CheckLogin();
            if (Cookie != null)
            {
                uid = Cookie["User_ID"].ToString();
                UserName = Cookie["UserName"].ToString();
            }


            string content = newRevert.Text;
            string ID = this.seachNum.Text;

            int isnominate = 1;
            switch (this.VisibleMessage.SelectedValue)
            {
                case "IsVisible": isnominate = 1; break;
                case "NoVisible": isnominate = 0; break;

            }

            System.DateTime myReverTime = System.DateTime.Now;
            if (ID != "")
            {
                sql = "update messageboard set RevertContent='" + content + "',WebUser='" + UserName + "',RevertTime='" + myReverTime + "',IsRevert=1,IsNominate=" + isnominate + " where id=" + ID;
            }
            else
            {
                Response.Write("<script language='javascript'> alert('未获得留言ID号，请重新选择！')</script>");
                Response.Redirect("MessageInfo.aspx"); //这里要跳转到哪里？
            }

            Conn.MakeConnectionMethod(sql, ConnKey, DAL.executeMethod.execute_NoneQuery, DAL.
            EnumDBType.Sql, VirtualPath);


            oid = "";
        }
        catch (System.Exception ex)
        {
            blnSaveState = false;
            strErrMsg = ex.Message;
        }
        finally
        {
            if (blnSaveState)
            {
                Response.Write("<script language='javascript'> alert('回复留言成功！')</script>");
                Response.Redirect("MessageList.aspx"); //这里要跳转到哪里？					

            }
            else
            {
                Response.Write("<script language='javascript'>window.setTimeout(\" alert('回复留言失败！')\",100)</script>");
            }
        }
    }



    protected void Button2_Click(object sender, EventArgs e)
    {
        Response.Redirect("MessageInfo.aspx?FID=" + Session["CurrFunID"].ToString(), true);
    }


    
    protected void Button1_Click(object sender, EventArgs e)
    {
        this.oldRevert.Text = "";
        this.newRevert.Text = "";
    }


    #region CheckLogin()//个人用户是否登录<返回一个HttpCookie>
    /// <summary>
    /// 是否登录
    /// </summary>
    /// <returns></returns>
    private HttpCookie CheckLogin()
    {

        HttpCookie Cookie = Request.Cookies["Message"];
        HttpCookie retCookie = null;
        if (Cookie == null || Cookie.ToString() == "")
        {
            return retCookie;
        }
        else
        {
            retCookie = Request.Cookies["Message"];
            return retCookie;
        }

    }
    #endregion

}