📄 bookshow.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="bookshow.aspx.cs" Inherits="bookshow" %>
<%@ Register Src="WebUserControl.ascx" TagName="WebUserControl" TagPrefix="uc1" %>
<!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>
</head>
<body bgcolor="#ffffff">
<form id="form1" runat="server">
<div style="text-align: left">
<strong><span style="font-size: 32pt; color: #0000ff; font-family: 华文琥珀">
<asp:Image ID="Image1" runat="server" ImageUrl="~/image/logo.JPG" /><span style="font-size: 24pt;
font-family: 隶书; color: #0000cc;">库存图书展示</span></span></strong>
<hr />
</div>
<table>
<tr>
<td style="width: 211px; height: 287px">
<uc1:WebUserControl ID="WebUserControl1" runat="server" />
</td>
<td style="width: 274px; height: 287px">
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="隶书" Font-Size="X-Large"
ForeColor="#0000C0" Height="33px" Text="库存已有图书处理：" Width="290px"></asp:Label><br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
DataKeyNames="ID" DataSourceID="AccessDataSource1" Height="162px" Width="701px" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" PageSize="5">
<Columns>
<asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
SortExpression="ID" />
<asp:BoundField DataField="BName1" HeaderText="BName1" SortExpression="BName1" />
<asp:BoundField DataField="BPress" HeaderText="BPress" SortExpression="BPress" />
<asp:BoundField DataField="BAuthor" HeaderText="BAuthor" SortExpression="BAuthor" />
<asp:BoundField DataField="BKind" HeaderText="BKind" SortExpression="BKind" />
<asp:BoundField DataField="BPrince2" HeaderText="BPrince2" SortExpression="BPrince2" />
<asp:CommandField ShowEditButton="True" />
<asp:CommandField ShowDeleteButton="True" />
</Columns>
<FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
<RowStyle BackColor="White" ForeColor="#003399" />
<PagerStyle BackColor="#99CCCC" ForeColor="#003399" HorizontalAlign="Left" />
<SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
<HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/BDB/BookStore.mdb"
DeleteCommand="DELETE FROM [Book] WHERE [ID] = ?" InsertCommand="INSERT INTO [Book] ([ID], [BName1], [BPress], [BAuthor], [BKind], [BPrince2]) VALUES (?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT [ID], [BName1], [BPress], [BAuthor], [BKind], [BPrince2] FROM [Book]" UpdateCommand="UPDATE [Book] SET [BName1] = ?, [BPress] = ?, [BAuthor] = ?, [BKind] = ?, [BPrince2] = ? WHERE [ID] = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="BName1" Type="String" />
<asp:Parameter Name="BPress" Type="String" />
<asp:Parameter Name="BAuthor" Type="String" />
<asp:Parameter Name="BKind" Type="String" />
<asp:Parameter Name="BPrince2" Type="Decimal" />
<asp:Parameter Name="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="ID" Type="Int32" />
<asp:Parameter Name="BName1" Type="String" />
<asp:Parameter Name="BPress" Type="String" />
<asp:Parameter Name="BAuthor" Type="String" />
<asp:Parameter Name="BKind" Type="String" />
<asp:Parameter Name="BPrince2" Type="Decimal" />
</InsertParameters>
</asp:AccessDataSource>
</td>
</tr>
<tr>
<td style="width: 211px">
<span style="font-size: 8pt; color: red"><strong>提示：图书展示中的图书封面可能与原图书不符，请与实际图书为准</strong></span></td>
<td style="width: 274px">
<table style="width: 703px">
<tr>
<td colspan="3" style="height: 21px">
<asp:Label ID="Label2" runat="server" Font-Bold="True" Font-Size="Large" ForeColor="DarkBlue"
Text="图书展示：" Font-Names="隶书" Font-Overline="False" Font-Strikeout="False" Height="35px"></asp:Label></td>
</tr>
<tr>
<td style="height: 21px" colspan="3">
<asp:DataList ID="DataList1" runat="server" DataSourceID="AccessDataSource2" RepeatColumns="3">
<ItemTemplate>
<table>
<tr>
<td rowspan="3" style="width: 47px">
<asp:Image ID="Image2" runat="server" AlternateText="暂无图像" ImageUrl='<%# Eval("Bimage") %>' /></td>
<td colspan="2" style="width: 175px; height: 35px">
<span style="font-size: 8pt">名称：</span><asp:Label ID="Label3" runat="server" Font-Size="Smaller"
Text='<%# Eval("BName1") %>'></asp:Label></td>
</tr>
<tr>
<td colspan="2" style="width: 175px; height: 39px">
<span style="font-size: 8pt">分类：</span><asp:Label ID="Label4" runat="server" Font-Size="Smaller"
Text='<%# Eval("BKind") %>'></asp:Label></td>
</tr>
<tr>
<td colspan="2" style="width: 175px; height: 43px">
<span style="font-size: 8pt">作者：</span><asp:Label ID="Label5" runat="server" Font-Size="Smaller"
Text='<%# Eval("BAuthor") %>'></asp:Label></td>
</tr>
</table>
</ItemTemplate>
</asp:DataList><asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/BDB/BookStore.mdb"
SelectCommand="SELECT [BName1], [BAuthor], [BKind], [Bimage] FROM [Book]"></asp:AccessDataSource>
</td>
</tr>
</table>
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -