📄 addbook.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="addbook.aspx.cs" Inherits="addbook" %>
<%@ 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; background-color: #ffffff;">
<span style="font-size: 32pt; color: #006600; font-family: 隶书"><strong>
<asp:Image ID="Image1" runat="server" ImageUrl="~/image/logo.JPG" /><span style="font-size: 24pt; color: #0000cc;">图书进库</span></strong></span>
<br />
<hr />
<br />
</div>
<table>
<tr>
<td style="width: 10042px; height: 249px; background-color: #ffffff;">
<uc1:WebUserControl ID="WebUserControl1" runat="server" />
</td>
<td colspan="2" style="height: 249px; background-color: #ffffff;">
<asp:Label ID="Label1" runat="server" Font-Bold="True" Font-Names="隶书" Font-Size="Large"
ForeColor="#0000C0" Height="21px" Text="请在指定地点添加新进图书或删除图书信息" Width="522px"></asp:Label>
<asp:DetailsView ID="DetailsView1" runat="server" AllowPaging="True" AutoGenerateRows="False" DataKeyNames="ID" DataSourceID="AccessDataSource1" Height="50px" Width="525px">
<Fields>
<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 ShowDeleteButton="True" ShowEditButton="True" ShowInsertButton="True" />
</Fields>
</asp:DetailsView>
<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>
<span style="font-size: 10pt; color: red">请正确填写新加图书信息</span></td>
</tr>
<tr>
<td style="width: 10042px; height: 28px; background-color: #ffffff">
</td>
<td colspan="2" style="height: 28px; background-color: #ffffff">
</td>
</tr>
<tr>
<td style="width: 10042px; height: 278px">
<span style="font-size: 10pt; color: red">特别提示：为了消费者权益，网站声誉，请认真填写图书信息</span></td>
<td colspan="2" style="height: 278px">
<asp:Label ID="Label2" runat="server" Font-Bold="True" Font-Names="隶书" Font-Size="Large"
ForeColor="#0000C0" Text="更新后图书信息" Height="14px" Width="231px"></asp:Label><br />
<br />
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataKeyNames="ID" DataSourceID="AccessDataSource2" Width="640px">
<Columns>
<asp:BoundField DataField="BPrince2" HeaderText="BPrince2" SortExpression="BPrince2" />
<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" />
</Columns>
</asp:GridView>
<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/BDB/BookStore.mdb"
DeleteCommand="DELETE FROM [Book] WHERE [ID] = ?" InsertCommand="INSERT INTO [Book] ([BPrince2], [ID], [BName1], [BPress], [BAuthor], [BKind]) VALUES (?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT [BPrince2], [ID], [BName1], [BPress], [BAuthor], [BKind] FROM [Book]" UpdateCommand="UPDATE [Book] SET [BPrince2] = ?, [BName1] = ?, [BPress] = ?, [BAuthor] = ?, [BKind] = ? WHERE [ID] = ?">
<DeleteParameters>
<asp:Parameter Name="ID" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="BPrince2" Type="Decimal" />
<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="ID" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="BPrince2" Type="Decimal" />
<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" />
</InsertParameters>
</asp:AccessDataSource>
</td>
</tr>
<tr>
<td style="width: 10042px; height: 12px">
</td>
<td style="width: 27735px; height: 12px">
</td>
<td style="width: 937px; height: 12px">
<asp:ImageButton ID="ImageButton1" runat="server" ImageUrl="~/back/image/back1.gif" PostBackUrl="~/quite.aspx"
Width="55px" /></td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -