📄 reaserch.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="reaserch.aspx.cs" Inherits="reaserch" %>
<%@ 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>
<span style="font-size: 32pt; color: #336633; font-family: 黑体"><strong>
<asp:Image ID="Image4" runat="server" ImageUrl="~/image/logo.JPG" /><span style="font-size: 24pt;
color: #0000cc; font-family: 隶书">订单查询</span></strong></span>
<hr />
</div>
<table>
<tr>
<td rowspan="3" style="width: 305px">
<uc1:WebUserControl ID="WebUserControl1" runat="server" />
</td>
<td rowspan="3">
</td>
</tr>
<tr>
<td style="height: 3px" colspan="2">
</td>
</tr>
<tr>
<td colspan="2" style="height: 2px">
<asp:Label ID="Label3" runat="server" Font-Bold="True" ForeColor="#0000C0" Text="根据送货方式查询"></asp:Label>
<br />
<asp:Label ID="Label4" runat="server" Font-Bold="True" ForeColor="Blue" Text="请输入要查询订单中所购书籍所需送货方式名称："></asp:Label>
<asp:ListBox ID="ListBox1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource1"
DataTextField="sfs" DataValueField="sfs"></asp:ListBox><asp:AccessDataSource
ID="AccessDataSource1" runat="server" DataFile="~/BDB/BookStore.mdb" SelectCommand="SELECT [Sfs] FROM [BookOrder]">
</asp:AccessDataSource>
</td>
</tr>
<tr>
<td style="width: 305px; height: 7px">
<asp:Image ID="Image3" runat="server" Height="104px" ImageUrl="~/back/image/卡通人物156.gif"
Width="96px" /></td>
<td style="height: 7px">
</td>
<td colspan="2" style="height: 7px">
<asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="编号"
DataSourceID="AccessDataSource3" Height="36px" Width="731px" AllowPaging="True" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4" PageSize="3">
<Columns>
<asp:BoundField DataField="编号" HeaderText="编号" InsertVisible="False" ReadOnly="True"
SortExpression="编号" />
<asp:BoundField DataField="PName" HeaderText="PName" SortExpression="PName" />
<asp:BoundField DataField="PAddress" HeaderText="PAddress" SortExpression="PAddress" />
<asp:BoundField DataField="PANum" HeaderText="PANum" SortExpression="PANum" />
<asp:BoundField DataField="PTel" HeaderText="PTel" SortExpression="PTel" />
<asp:BoundField DataField="PGTel" HeaderText="PGTel" SortExpression="PGTel" />
<asp:BoundField DataField="Sfs" HeaderText="Sfs" SortExpression="Sfs" />
<asp:BoundField DataField="Pay" HeaderText="Pay" SortExpression="Pay" />
<asp:BoundField DataField="Zt" HeaderText="Zt" SortExpression="Zt" />
</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="AccessDataSource3" runat="server" DataFile="~/BDB/BookStore.mdb"
DeleteCommand="DELETE FROM [BookOrder] WHERE [编号] = ?" InsertCommand="INSERT INTO [BookOrder] ([编号], [PName], [Country], [Pre], [Shi], [Qu], [PAddress], [PANum], [PTel], [PGTel], [Sfs], [Pay], [Zt]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT * FROM [BookOrder] WHERE ([Sfs] = ?)" UpdateCommand="UPDATE [BookOrder] SET [PName] = ?, [Country] = ?, [Pre] = ?, [Shi] = ?, [Qu] = ?, [PAddress] = ?, [PANum] = ?, [PTel] = ?, [PGTel] = ?, [Sfs] = ?, [Pay] = ?, [Zt] = ? WHERE [编号] = ?">
<SelectParameters>
<asp:ControlParameter ControlID="ListBox1" Name="Sfs" PropertyName="SelectedValue"
Type="String" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="编号" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PName" Type="String" />
<asp:Parameter Name="Country" Type="String" />
<asp:Parameter Name="Pre" Type="String" />
<asp:Parameter Name="Shi" Type="String" />
<asp:Parameter Name="Qu" Type="String" />
<asp:Parameter Name="PAddress" Type="String" />
<asp:Parameter Name="PANum" Type="String" />
<asp:Parameter Name="PTel" Type="String" />
<asp:Parameter Name="PGTel" Type="String" />
<asp:Parameter Name="Sfs" Type="String" />
<asp:Parameter Name="Pay" Type="String" />
<asp:Parameter Name="Zt" Type="String" />
<asp:Parameter Name="编号" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="编号" Type="Int32" />
<asp:Parameter Name="PName" Type="String" />
<asp:Parameter Name="Country" Type="String" />
<asp:Parameter Name="Pre" Type="String" />
<asp:Parameter Name="Shi" Type="String" />
<asp:Parameter Name="Qu" Type="String" />
<asp:Parameter Name="PAddress" Type="String" />
<asp:Parameter Name="PANum" Type="String" />
<asp:Parameter Name="PTel" Type="String" />
<asp:Parameter Name="PGTel" Type="String" />
<asp:Parameter Name="Sfs" Type="String" />
<asp:Parameter Name="Pay" Type="String" />
<asp:Parameter Name="Zt" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</td>
</tr>
<tr>
<td style="width: 305px; height: 7px">
</td>
<td style="height: 7px">
</td>
<td colspan="2" style="height: 7px">
</td>
</tr>
<tr>
<td style="width: 305px; height: 7px">
</td>
<td style="height: 7px">
</td>
<td colspan="2" style="height: 7px">
</td>
</tr>
<tr>
<td style="width: 305px; height: 39px">
</td>
<td style="height: 39px">
</td>
<td colspan="2" style="height: 39px">
<asp:Label ID="Label5" runat="server" Font-Bold="True" ForeColor="#0000C0" Text="根据订单号查询"></asp:Label></td>
</tr>
<tr>
<td style="width: 305px; height: 7px">
</td>
<td style="height: 7px">
</td>
<td colspan="2" style="height: 7px">
<asp:Label ID="Label6" runat="server" Font-Bold="True" ForeColor="#0000C0" Text="请输入要查询的订单号："></asp:Label>
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource5"
DataTextField="编号" DataValueField="编号">
</asp:DropDownList><asp:AccessDataSource ID="AccessDataSource5" runat="server" DataFile="~/BDB/BookStore.mdb"
SelectCommand="SELECT [编号] FROM [BookOrder]"></asp:AccessDataSource>
</td>
</tr>
<tr>
<td style="width: 305px; height: 7px">
</td>
<td style="height: 7px">
</td>
<td colspan="2" style="height: 7px">
<asp:GridView ID="GridView3" runat="server" AutoGenerateColumns="False" DataKeyNames="编号"
DataSourceID="AccessDataSource4" Width="737px" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4">
<Columns>
<asp:BoundField DataField="编号" HeaderText="编号" InsertVisible="False" ReadOnly="True"
SortExpression="编号" />
<asp:BoundField DataField="PName" HeaderText="PName" SortExpression="PName" />
<asp:BoundField DataField="PAddress" HeaderText="PAddress" SortExpression="PAddress" />
<asp:BoundField DataField="PANum" HeaderText="PANum" SortExpression="PANum" />
<asp:BoundField DataField="PTel" HeaderText="PTel" SortExpression="PTel" />
<asp:BoundField DataField="PGTel" HeaderText="PGTel" SortExpression="PGTel" />
<asp:BoundField DataField="Sfs" HeaderText="Sfs" SortExpression="Sfs" />
<asp:BoundField DataField="Pay" HeaderText="Pay" SortExpression="Pay" />
<asp:BoundField DataField="Zt" HeaderText="Zt" SortExpression="Zt" />
</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="AccessDataSource4" runat="server" DataFile="~/BDB/BookStore.mdb"
DeleteCommand="DELETE FROM [BookOrder] WHERE [编号] = ?" InsertCommand="INSERT INTO [BookOrder] ([编号], [PName], [Country], [Pre], [Shi], [Qu], [PAddress], [PANum], [PTel], [PGTel], [Sfs], [Pay], [Zt]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
SelectCommand="SELECT * FROM [BookOrder] WHERE ([编号] = ?)" UpdateCommand="UPDATE [BookOrder] SET [PName] = ?, [Country] = ?, [Pre] = ?, [Shi] = ?, [Qu] = ?, [PAddress] = ?, [PANum] = ?, [PTel] = ?, [PGTel] = ?, [Sfs] = ?, [Pay] = ?, [Zt] = ? WHERE [编号] = ?">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="编号" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
<DeleteParameters>
<asp:Parameter Name="编号" Type="Int32" />
</DeleteParameters>
<UpdateParameters>
<asp:Parameter Name="PName" Type="String" />
<asp:Parameter Name="Country" Type="String" />
<asp:Parameter Name="Pre" Type="String" />
<asp:Parameter Name="Shi" Type="String" />
<asp:Parameter Name="Qu" Type="String" />
<asp:Parameter Name="PAddress" Type="String" />
<asp:Parameter Name="PANum" Type="String" />
<asp:Parameter Name="PTel" Type="String" />
<asp:Parameter Name="PGTel" Type="String" />
<asp:Parameter Name="Sfs" Type="String" />
<asp:Parameter Name="Pay" Type="String" />
<asp:Parameter Name="Zt" Type="String" />
<asp:Parameter Name="编号" Type="Int32" />
</UpdateParameters>
<InsertParameters>
<asp:Parameter Name="编号" Type="Int32" />
<asp:Parameter Name="PName" Type="String" />
<asp:Parameter Name="Country" Type="String" />
<asp:Parameter Name="Pre" Type="String" />
<asp:Parameter Name="Shi" Type="String" />
<asp:Parameter Name="Qu" Type="String" />
<asp:Parameter Name="PAddress" Type="String" />
<asp:Parameter Name="PANum" Type="String" />
<asp:Parameter Name="PTel" Type="String" />
<asp:Parameter Name="PGTel" Type="String" />
<asp:Parameter Name="Sfs" Type="String" />
<asp:Parameter Name="Pay" Type="String" />
<asp:Parameter Name="Zt" Type="String" />
</InsertParameters>
</asp:AccessDataSource>
</td>
</tr>
</table>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -