messageboard.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.Xml;
using System.IO;

public partial class WebPages_MessageBoard : System.Web.UI.Page
{
    protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
            //BindToDataListMsg();
            BindToDataListMsgXML();
            LabelPageNo.Text = "1";
            if (Session["UserNo"].ToString() == "")
            {
                TBMsgAuthor.Value = "匿名";
                TBMsgAuthor.Disabled = true;
            }
            else
            {
                string userid = Session["UserNo"].ToString();
                DataSet ds = new DataSet();
                string sRet = "";
                UserControl con = new UserControl();

                sRet = con.GetUserDetail(userid, ref ds, "user");
                if (sRet == "")
                {
                    TBMsgAuthor.Value = ds.Tables["user"].Rows[0]["UserName"].ToString();
                    TBMsgAuthor.Disabled = true;
                }
            }
        }
    }

    protected void BtnMsgSend_ServerClick(object sender, EventArgs e)
    {
        //发表留言
        string msgAuthor = LxEnCode.EnCode(TBMsgAuthor.Value.ToString());
        string msgText = LxEnCode.EnCode(TBMsgContext.Text.ToString());

        //存XML
        int MBID = 0;
        XmlDocument xdoc = new XmlDocument();
        xdoc.Load(Server.MapPath("msg.xml"));
        XmlNode xn = xdoc.SelectSingleNode("MessageBoard");
        if (xn.ChildNodes.Count == 0)
        {
            MBID = 1;
        }
        else
        {
            MBID = Convert.ToInt32(xn.LastChild.ChildNodes[0].InnerText) + 1;
        }
        string addstr = "<message>";
        addstr += "<MBID>" + MBID + "</MBID>";
        addstr += "<MBAuthor>" + msgAuthor + "</MBAuthor>";
        addstr += "<MBDate>" + DateTime.Now.ToString() + "</MBDate>";
        addstr += "<MBContext>" + msgText + "</MBContext>";
        addstr += "<MBIP>" + Request.UserHostAddress.ToString() + "</MBIP>";
        addstr += "</message>";
        XmlDocumentFragment xdf = xdoc.CreateDocumentFragment();
        xdf.InnerXml = addstr;
        xdoc.DocumentElement.InsertAfter(xdf, xdoc.DocumentElement.LastChild);
        xdoc.Save(Server.MapPath("msg.xml"));
        if (Session["UserNo"].ToString() == "")
        {
            TBMsgAuthor.Value = "匿名";
            TBMsgAuthor.Disabled = true;
        }
        TBMsgContext.Text = "";
        BindToDataListMsgXML();

        //存数据库
        //string sRet = "";
        //InfoOperate info = new InfoOperate();
        //sRet = info.addNewMsg(msgAuthor, msgText, 0, Request.UserHostAddress.ToString());
        //if(sRet == "")
        //{
        //    Response.Write("<script>alert('留言成功！'); location.replace('MessageBoard.aspx');</script>");
        //}

    }

    private void BindToDataListMsgXML()
    {
        //绑定数据到DataListMsg  XML版本
        //创建文件注并打开xml数据库
        FileStream stream = new FileStream(MapPath("msg.xml"), FileMode.Open);
        try
        {
            XmlDataDocument doc = new XmlDataDocument();
            //把xml流读入dataset中
            doc.DataSet.ReadXml(new StreamReader(stream));
            if (doc.DataSet.Tables.Count == 0)
            {
                Response.Write("xml数据文件没有内容");
            }
            else
            {
                DataView dv = new DataView(doc.DataSet.Tables[0]);
                dv.Sort = "MBDate desc";
                //翻页功能
                PagedDataSource ps = new PagedDataSource();

                ps.DataSource = dv; ;

                int PageNo = Convert.ToInt32(LabelPageNo.Text.ToString());

                ps.AllowPaging = true;
                ps.PageSize = 6;
                ps.CurrentPageIndex = PageNo - 1;

                LBFinalPage.Enabled = true;
                LBFirstPage.Enabled = true;
                LBNextPage.Enabled = true;
                LBPrePage.Enabled = true;

                if (ps.IsFirstPage)
                {
                    //判断是否为首页
                    LBFirstPage.Enabled = false;
                    LBPrePage.Enabled = false;
                    if (ps.PageCount == 1)
                    {
                        LBFinalPage.Enabled = false;
                        LBNextPage.Enabled = false;
                    }
                }
                if (ps.IsLastPage)
                {
                    //判断是否为末页
                    LBFinalPage.Enabled = false;
                    LBNextPage.Enabled = false;
                }

                DataListMsg.DataSource = ps;
                DataListMsg.DataBind();

                LabelTotalPage.Text = ps.PageCount.ToString();

                if (doc.DataSet.Tables.Count != 0 && doc.DataSet.Tables[0].Rows.Count != 0)
                {
                    DataListMsg.DataSource = ps;
                    DataListMsg.DataBind();
                }
            }
            stream.Close();
        }
        catch (Exception ding)
        {
            Response.Write(ding.Message);
        }
        finally
        {
            stream.Close();
        }
    }

    protected void BindToDataListMsg()
    {
        //绑定数据到DataListMsg
        DataSet ds = new DataSet();
        string sRet = "";
        InfoOperate msg = new InfoOperate();
        sRet = msg.getInfoList("messageboard", "MBID", ref ds, "msg", "all");
        if (sRet == "")
        {
            //如果获取成功，则进行分页
            PagedDataSource ps = new PagedDataSource();
            int PageNo = Convert.ToInt32(LabelPageNo.Text.ToString());

            ps.DataSource = ds.Tables["msg"].DefaultView;
            ps.AllowPaging = true;
            ps.PageSize = 6;
            ps.CurrentPageIndex = PageNo - 1;

            LBFinalPage.Enabled = true;
            LBFirstPage.Enabled = true;
            LBNextPage.Enabled = true;
            LBPrePage.Enabled = true;

            if (ps.IsFirstPage)
            {
                //判断是否为首页
                LBFirstPage.Enabled = false;
                LBPrePage.Enabled = false;
                if (ps.PageCount == 1)
                {
                    LBFinalPage.Enabled = false;
                    LBNextPage.Enabled = false;
                }
            }
            if (ps.IsLastPage)
            {
                //判断是否为末页
                LBFinalPage.Enabled = false;
                LBNextPage.Enabled = false;
            }

            DataListMsg.DataSource = ps;

            DataListMsg.DataKeyField = "MBID";
            DataListMsg.DataBind();

            LabelTotalPage.Text = ps.PageCount.ToString();
        }
    }

    protected void LBFirstPage_Click(object sender, EventArgs e)
    {
        //显示首页
        LabelPageNo.Text = "1";
        //BindToDataListMsg();
        BindToDataListMsgXML();
    }
    protected void LBPrePage_Click(object sender, EventArgs e)
    {
        //显示上一页
        LabelPageNo.Text = Convert.ToString(Convert.ToInt32(LabelPageNo.Text.ToString()) - 1);
        //BindToDataListMsg();
        BindToDataListMsgXML();
    }
    protected void LBNextPage_Click(object sender, EventArgs e)
    {
        //显示下一页
        LabelPageNo.Text = Convert.ToString(Convert.ToInt32(LabelPageNo.Text.ToString()) + 1);
        //BindToDataListMsg();
        BindToDataListMsgXML();
    }
    protected void LBFinalPage_Click(object sender, EventArgs e)
    {
        //显示末页
        LabelPageNo.Text = LabelTotalPage.Text;
        //BindToDataListMsg();
        BindToDataListMsgXML();
    }
}