|
作者：http://www.aspcn.com 飛刀
上一節(jié)中，由于XML文件占了很大的篇幅，只好把源程序貼在這一頁了。
也是很長(zhǎng)的喲，大家有性子看才行：）
<% @ Page Language="C#" ResponseEncoding="gb2312" %>
<% @ Import Namespace="System.Data" %>
<% @ Import Namespace="System.Xml" %>
<% @ Import Namespace="System.IO" %>
<Script Language="C#" Runat="Server">
DataSet ds;//定義公用的DataSet
DataView dv;//定義公用的DataView
string SortField;
string sPath;
public void Page_Load(Object src,EventArgs e)
{
if(State["adxml"]==null)
{
sPath = Server.MapPath(".") + "\\AdBanners\\ad_gb.xml";
ds = new DataSet();
ds.ReadXml(sPath);
State["adxml"] = ds;
}
else
{
ds = (DataSet)State["adxml"];
}
dv = ds.Tables[0].DefaultView;
dv.Sort = "ImageUrl";
if(!Page.IsPostBack)
{
CreateTable();
}
}
//捆綁Binder
public void CreateTable()
{
dgXML.DataSource = dv;
dgXML.DataBind();
}
//翻頁時(shí)
public void dgXML_Changed(Object sender,DataGridPageChangedEventArgs e)
{
CreateTable();
}
//刪除
public void DelItem(Object sender,DataGridCommandEventArgs e)
{
if(((LinkButton)e.CommandSource).CommandName == "del")
{
//首先取得當(dāng)前更新頁的行數(shù)與CurrentPageIndex
int CPI = (int)dgXML.CurrentPageIndex;
int EII = (int)e.Item.ItemIndex;
int row = CPI*5+EII;
lb.Text = row.ToString();
//刪除
dv.Delete(row);
dgXML.EditItemIndex = -1;
ds.WriteXml(sPath);
CreateTable();
}
}
//取消
public void dgXML_Cancel(Object sender,DataGridCommandEventArgs e)
{
dgXML.EditItemIndex = -1;
CreateTable();
}
//編輯
public void dgXML_Edit(Object sender,DataGridCommandEventArgs e)
{
dgXML.EditItemIndex = (int)e.Item.ItemIndex;
CreateTable();
}
//更新
public void dgXML_Update(Object sender, DataGridCommandEventArgs e)
{
try
{
//首先取得當(dāng)前更新頁的行數(shù)與CurrentPageIndex
int CPI = (int)dgXML.CurrentPageIndex;
int EII = (int)e.Item.ItemIndex;
int row = CPI*5+EII;
//lb.Text = row.ToString();
//取得各項(xiàng)值
string ImageUrl= ((TextBox)e.Item.Cells[2].Controls[0]).Text;
string NavigateUrl= ((TextBox)e.Item.Cells[3].Controls[0]).Text;
string AlternateText= ((TextBox)e.Item.Cells[4].Controls[0]).Text;
string Keyword= ((TextBox)e.Item.Cells[5].Controls[0]).Text;
string Impressions= ((TextBox)e.Item.Cells[6].Controls[0]).Text;
dv.Delete(row);
DataRow dr = ds.Tables[0].NewRow();
dr[0]=ImageUrl;
dr[1]=NavigateUrl;
dr[2]=AlternateText;
dr[3]=Keyword;
dr[4]=Impressions;
ds.Tables[0].Rows.Add(dr);
ds.WriteXml(sPath);
}
catch(Exception ee)
{
lb.Text = ee.ToString();
}
dgXML.EditItemIndex = -1;
CreateTable();
}
public void PanelShow(Object sender,EventArgs e)
{
AddItem.Visible = true;
}
public void AddItem_Click(Object sender,EventArgs e)
{
DataRow dr = ds.Tables[0].NewRow();
dr[0]=mUrl.Text;
dr[1]=aUrl.Text;
dr[2]=mText.Text;
dr[3]=aKey.Text;
dr[4]=aTime.Text;
ds.Tables[0].Rows.Add(dr);
ds.WriteXml(sPath);
CreateTable();
AddItem.Visible=false;
}
</script>
<html>
<head>
<title></title>
</head>
<body>
<form id="form1" runat="server">
<asp:DataGrid id="dgXML" runat="server"
AllowPaging="True"
PageSize="10"
BorderColor="black"
BorderWidth="1"
CellPadding="3"
Font-Name="Verdana"
Font-Size="8pt"
HeaderStyle-BackColor="#aaaadd"
PagerStyle-Mode="NumericPages"
PagerStyle-HorizontalAlign="Right"
PagerStyle-PrevPageText="前頁"
PagerStyle-NextPageText="后頁"
OnPageIndexChanged="dgXML_Changed"
OnEditCommand="dgXML_Edit"
OnCancelCommand="dgXML_Cancel"
OnUpdateCommand="dgXML_Update"
OnItemCommand="DelItem"
AutoGenerateColumns="false"
>
<property name="Columns">
<asp:ButtonColumn HeaderText="刪除"Text="刪除" CommandName="del" />
<asp:EditCommandColumnEditText="修改"CancelText="取消" UpdateText="更新" ItemStyle-Wrap="false" HeaderText="操作區(qū)" HeaderStyle-Wrap="false" />
<asp:BoundColumn HeaderText="圖片地址(相對(duì))" SortField="ImageUrl" DataField="ImageUrl" />
<asp:BoundColumn HeaderText="鏈接URL" SortField="NavigateUrl" DataField="NavigateUrl" />
<asp:BoundColumn HeaderText="圖片說明" SortField="AlternateText" DataField="AlternateText" />
<asp:BoundColumn HeaderText="類別" SortField="Keyword" DataField="Keyword" />
<asp:BoundColumn HeaderText="顯示時(shí)間" SortField="Impressions" DataField="Impressions" />
</property>
</asp:DataGrid>
<hr>
<asp:Button id="vi" Text="添加新項(xiàng)" OnClick="PanelShow"runat="server"/>
<br>
<asp:Panel id="AddItem" runat="server" Visible="false">
<table>
<tr Bgcolor="#aaaadd"><td colspan=2>添加新的廣告頁面</td></tr>
<tr>
<td>廣告圖片URL:</td>
<td><asp:TextBox id="mUrl" runat="server" Text="http://" /></td>
</tr>
<tr>
<td>廣告鏈接地址:</td>
<td><asp:TextBox id="aUrl" runat="server" Text="http://" /></td>
</tr>
<tr>
<td>圖片說明：</td>
<td><asp:TextBox id="mText" runat="server" /></td>
</tr>
<tr>
<td>廣告所屬類別:</td>
<td><asp:TextBox id="aKey" runat="server" /></td>
</tr>
<tr>
<td>顯示時(shí)間</td>
<td><asp:TextBox id="aTime" runat="server" /></td>
</tr>
<tr><td>
<asp:Button id="submit" Text="提交" OnClick="AddItem_Click" runat="server" /></td></tr>
</asp:Panel>
<asp:Label id="lb" runat="server" />
</form>
</body>
</html>
|
溫馨提示：喜歡本站的話，請(qǐng)收藏一下本站！
