?? 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();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -