📄 classmanage.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="ClassManage.aspx.cs" Inherits="NewsClassManage_ClassManage" %>
<!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>
<script language="javascript" type="text/javascript">
// <!CDATA[
// ]]>
</script>
</head>
<body>
<form id="form1" runat="server">
<div>
<table style="width: 742px">
<tr>
<td style="width: 634px; background-color: #507cd1; height: 14px;">
分类管理</td>
</tr>
</table>
<asp:GridView ID="GrdClassManage" runat="server" AllowPaging="True" AutoGenerateColumns="False"
CellPadding="4" DataKeyNames="CLASSID,ITEMID1" DataSourceID="SqlDataSource1"
ForeColor="#333333" GridLines="None" PageSize="5" Width="740px" Height="139px" OnRowDataBound="GrdClassManage_RowDataBound" >
<FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<Columns>
<asp:BoundField DataField="CLASSID" HeaderText="编号" InsertVisible="False" ReadOnly="True"
SortExpression="CLASSID" >
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:BoundField>
<asp:BoundField DataField="CLASSNAME" HeaderText="分类名称" SortExpression="CLASSNAME" >
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:BoundField>
<asp:TemplateField HeaderText="所属栏目" SortExpression="ITEMNAME">
<EditItemTemplate>
<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="SqlDataSource1"
DataTextField="ITEMNAME" DataValueField="ITEMID" Width="105px" SelectedValue='<%# Bind("ITEMID") %>'>
</asp:DropDownList><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:news_manageConnectionString %>"
SelectCommand="SELECT [ITEMID], [ITEMNAME] FROM [t_Item]" DeleteCommand="DELETE FROM [t_Item] WHERE [ITEMID] = @ITEMID" InsertCommand="INSERT INTO [t_Item] ([ITEMNAME]) VALUES (@ITEMNAME)" UpdateCommand="UPDATE [t_Item] SET [ITEMNAME] = @ITEMNAME WHERE [ITEMID] = @ITEMID">
<DeleteParameters>
<asp:Parameter Name="ITEMID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ITEMNAME" Type="String" />
<asp:Parameter Name="ITEMID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ITEMNAME" Type="String" />
</InsertParameters>
</asp:SqlDataSource>
</EditItemTemplate>
<ItemTemplate>
<asp:Label ID="Label1" runat="server" Text='<%# Bind("ITEMNAME") %>'></asp:Label>
</ItemTemplate>
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:TemplateField>
<asp:BoundField DataField="CLASSDESC" HeaderText="描述" SortExpression="CLASSDESC" >
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:BoundField>
<asp:BoundField DataField="CLASSORDER" HeaderText="类别顺序" SortExpression="CLASSORDER" >
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:BoundField>
<asp:CommandField CancelImageUrl="~/Image/cancel.png" CancelText="<img src='../Image/cancel.png'border='0' alt='取消'>"
EditImageUrl="~/Image/edit.gif" EditText="<img src='../Image/edit.gif' border='0' alt='修改'>"
HeaderText="修改" ShowEditButton="True" UpdateImageUrl="~/Image/update.png" UpdateText="<img src='../Image/update.png' border='0' alt='更新'>" >
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:CommandField>
<asp:CommandField DeleteImageUrl="~/Image/icon_del.gif" DeleteText="<img src='../Image/icon_del.gif' border='0' alt='删除'>"
HeaderText="删除" ShowDeleteButton="True" >
<HeaderStyle HorizontalAlign="Center" VerticalAlign="Middle" />
</asp:CommandField>
</Columns>
<RowStyle BackColor="#EFF3FB" />
<EditRowStyle BackColor="#2461BF" />
<SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
<PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
<HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
<AlternatingRowStyle BackColor="White" />
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:news_manageConnectionString %>"
DeleteCommand="DELETE FROM t_Class WHERE CLASSID=@CLASSID"
SelectCommand="SELECT t_Class.*, t_Item.ITEMID, t_Item.ITEMNAME FROM t_Class INNER JOIN t_Item ON t_Class.ITEMID = t_Item.ITEMID"
UpdateCommand="UPDATE t_Class SET ITEMID = @ITEMID, CLASSORDER = @CLASSORDER, CLASSDESC = @CLASSDESC, CLASSNAME = @CLASSNAME where CLASSID=@CLASSID">
<DeleteParameters>
<asp:Parameter Name="CLASSID" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="ITEMID" />
<asp:Parameter Name="CLASSORDER" />
<asp:Parameter Name="CLASSDESC" />
<asp:Parameter Name="CLASSNAME" />
<asp:Parameter Name="CLASSID" />
</UpdateParameters>
</asp:SqlDataSource>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -