📄 news_manage.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="news_manage.aspx.cs" Inherits="admin_news_manage" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>新闻管理页面</title>
<link id="Link1" href="css/shangdu.css" runat="server" rel="stylesheet" type="text/css"/>
</head>
<body>
<form id="form1" runat="server">
<div>
<div style="text-align: left">
<table style="width: 100%">
<tr>
<td style="width: 100%">
新闻分类(<% string fileclass = Request.QueryString["bigclassname"]; Response.Write(fileclass); %>)管理:
<img src="../admin/images/newsitem_icon.gif" alt="发布新闻" />
<a href="news_add.aspx">添加新闻</a> </td>
</tr>
<tr>
<td style="border-right: #ead9b9 1px solid; border-top: #ead9b9 1px solid; border-left: #ead9b9 1px solid;
width: 100%; border-bottom: #ead9b9 1px solid; background-color: #fffdee; font-size: 12px; color: #c18945;">
ShangduNT提示:选择上面添加新闻可转到添加新闻页面<br />
选择下面的新闻分类,即可查看相关分类下的新闻,你可以点击<strong>分类编号</strong>,或者<strong>新闻编号</strong>来排序控件.<br />
直接点击新闻标题可转到新闻页面.</td>
</tr>
<tr>
<td style="width: 100%">
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataSourceID="SqlDataSource1" Width="100%" style="font-size: 12px; text-align: left" AlternatingRowStyle-BackColor="#f5f5f5">
<Columns>
<asp:BoundField DataField="bh" HeaderText="分类编号" SortExpression="bh" />
<asp:HyperLinkField DataNavigateUrlFields="bigclassname" DataNavigateUrlFormatString="news_manage.aspx?bigclassname={0}"
DataTextField="bigclassname" DataTextFormatString="{0}" HeaderText="新闻分类" />
<asp:BoundField DataField="admin_name" HeaderText="分类管理员名称" SortExpression="admin_name" />
<asp:BoundField DataField="admin_pic" HeaderText="分类管理员图片" SortExpression="admin_pic" />
<asp:BoundField DataField="admin_infor" HeaderText="分类管理员简介" SortExpression="admin_infor" />
<asp:BoundField DataField="admin_website" HeaderText="分类管理员网址" SortExpression="admin_website" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td style="width: 100%">
选择以上新闻分类查看该分类的新闻,点击下面的标题行,可按标题行排序.</td>
</tr>
<tr>
<td style="width: 100%">
<asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="SqlDataSource2" Width="100%" PageSize="16" AlternatingRowStyle-BackColor="#f5f5f5">
<Columns>
<asp:BoundField DataField="bh" HeaderText="新闻编号" SortExpression="bh" />
<asp:HyperLinkField DataNavigateUrlFields="bh,bigclassname" DataNavigateUrlFormatString="../articls/{1}/{0}.aspx"
DataTextField="title" DataTextFormatString="{0}" HeaderText="新闻标题" />
<asp:BoundField DataField="time" HeaderText="发布时间" SortExpression="time" />
<asp:BoundField DataField="bigclassname" HeaderText="新闻分类" SortExpression="bigclassname" />
<asp:BoundField DataField="hits" HeaderText="浏览次数" SortExpression="hits" />
<asp:BoundField DataField="color" HeaderText="标题颜色" SortExpression="color" />
<asp:HyperLinkField DataNavigateUrlFields="bh" DataNavigateUrlFormatString="news_modi.aspx?bh={0}"
HeaderText="修改" Text="修改" />
<asp:HyperLinkField DataNavigateUrlFields="bh,bigclassname" DataNavigateUrlFormatString="news_del.aspx?bh={0}&bigclassname={1}"
HeaderText="删除" Text="删除" />
</Columns>
</asp:GridView>
</td>
</tr>
<tr>
<td style="width: 100%">
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:shangduConnectionString %>"
SelectCommand="SELECT * FROM [bigclass]"></asp:SqlDataSource>
<asp:SqlDataSource ID="SqlDataSource2" runat="server" ConnectionString="<%$ ConnectionStrings:shangduConnectionString %>"
SelectCommand="SELECT * FROM [news] WHERE ([bigclassname] = @bigclassname) ORDER BY BH DESC" DeleteCommandType="StoredProcedure" DeleteCommand="DELETE FROM [news] WHERE ([bh]=@bh)">
<SelectParameters>
<asp:QueryStringParameter Name="bigclassname" QueryStringField="bigclassname" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
</td>
</tr>
</table>
</div>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -