⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 dingdan2.aspx

📁 visual stdio 2005
💻 ASPX
字号:
🔍 
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="dingdan2.aspx.cs" Inherits="dingdan2" %>

<%@ 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: #660066; font-family: 华文行楷"><strong>
                    <asp:Image ID="Image1" runat="server" ImageUrl="~/image/logo.JPG" Width="116px" /><span
                        style="font-size: 24pt; color: #0000cc; font-family: 隶书">订单处理</span></strong></span>
        <hr />
    
    </div>
        <table>
            <tr>
                <td rowspan="2" style="width: 24px">
                </td>
                <td rowspan="2" style="width: 183px">
                    </td>
                <td colspan="2" style="width: 713px">
                    <strong><span style="font-size: 16pt; color: #3300cc; font-family: 隶书;">
                        <br />
                        显示所有未处理的订单：</span></strong></td>
            </tr>
            <tr>
                <td colspan="2" rowspan="2" style="width: 713px">
                    &nbsp;&nbsp;
                    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                        BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
                        CellPadding="4" DataKeyNames="编号" DataSourceID="AccessDataSource1"
                        Width="701px">
                        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
                        <RowStyle BackColor="White" ForeColor="#003399" />
                        <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>
                        <PagerStyle ForeColor="#003399" HorizontalAlign="Left" BackColor="#99CCCC" />
                        <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 [BookOrder] WHERE [编号] = ?" InsertCommand="INSERT INTO [BookOrder] ([编号], [PName], [Country], [Pre], [Shi], [Qu], [PAddress], [PANum], [PTel], [PGTel], [Sfs], [Pay], [Zt]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)"
                        SelectCommand="SELECT * FROM [BookOrder] WHERE ([Zt] = ?)" UpdateCommand="UPDATE [BookOrder] SET [PName] = ?, [Country] = ?, [Pre] = ?, [Shi] = ?, [Qu] = ?, [PAddress] = ?, [PANum] = ?, [PTel] = ?, [PGTel] = ?, [Sfs] = ?, [Pay] = ?, [Zt] = ? WHERE [编号] = ?">
                        <SelectParameters>
                            <asp:Parameter DefaultValue="未处理" Name="Zt" 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>
                    <span style="font-size: 8pt; color: red">请尽快对未处理订单进行处理！</span></td>
            </tr>
            <tr>
                <td colspan="2" style="height: 417px">
                    <uc1:WebUserControl ID="WebUserControl1" runat="server" />
                    &nbsp;&nbsp;
                </td>
            </tr>
            <tr>
                <td style="width: 24px; height: 42px">
                </td>
                <td style="width: 183px; height: 42px">
                    <asp:Image ID="Image2" runat="server" Height="23px" ImageUrl="~/back/image/箭头019.gif"
                        Width="30px" />
                    <asp:HyperLink ID="HyperLink1" runat="server" NavigateUrl="~/quite.aspx" Height="25px">退出</asp:HyperLink></td>
                <td colspan="2" style="height: 42px; width: 713px;">
                    <span style="font-size: 16pt; color: #0000cc; font-family: 隶书;"><strong>显示所有已处理的订单：</strong></span></td>
            </tr>
            <tr>
                <td style="height: 21px" colspan="2">
                </td>
                <td colspan="2" style="height: 21px; width: 713px;">
                    &nbsp;
                    <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                        BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px"
                        CellPadding="4" DataKeyNames="编号" DataSourceID="AccessDataSource2"
                        Width="711px">
                        <FooterStyle BackColor="#99CCCC" ForeColor="#003399" />
                        <RowStyle BackColor="White" ForeColor="#003399" />
                        <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>
                        <PagerStyle ForeColor="#003399" HorizontalAlign="Left" BackColor="#99CCCC" />
                        <SelectedRowStyle BackColor="#009999" Font-Bold="True" ForeColor="#CCFF99" />
                        <HeaderStyle BackColor="#003399" Font-Bold="True" ForeColor="#CCCCFF" />
                    </asp:GridView>
                    <asp:AccessDataSource ID="AccessDataSource2" 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 ([Zt] = ?)" UpdateCommand="UPDATE [BookOrder] SET [PName] = ?, [Country] = ?, [Pre] = ?, [Shi] = ?, [Qu] = ?, [PAddress] = ?, [PANum] = ?, [PTel] = ?, [PGTel] = ?, [Sfs] = ?, [Pay] = ?, [Zt] = ? WHERE [编号] = ?">
                        <SelectParameters>
                            <asp:Parameter DefaultValue="已处理" Name="Zt" 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>
        </table>
    </form>
</body>
</html>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -