ordering.aspx

简介：功能描述：商品的分类显示、浏览商品、用户登录、选购和调整购物车、集中结算、存储订单、查看订单

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="ordering.aspx.cs" Inherits="ordering" Title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder2" Runat="Server">
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="orderid"
        DataSourceID="SqlDataSource1" BackColor="White" BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" GridLines="Vertical">
        <Columns>
            <asp:CommandField ShowDeleteButton="True" />
            <asp:BoundField DataField="customid" HeaderText="customid" SortExpression="customid" />
            <asp:BoundField DataField="orderid" HeaderText="orderid" InsertVisible="False" ReadOnly="True"
                SortExpression="orderid" />
            <asp:BoundField DataField="productid" HeaderText="productid" SortExpression="productid" />
            <asp:BoundField DataField="productname" HeaderText="productname" SortExpression="productname" />
            <asp:BoundField DataField="quantityperunit" HeaderText="quantityperunit" SortExpression="quantityperunit" />
            <asp:BoundField DataField="unitprice" HeaderText="unitprice" SortExpression="unitprice" />
            <asp:BoundField DataField="ordernum" HeaderText="ordernum" SortExpression="ordernum" />
            <asp:BoundField DataField="orderdatetime" HeaderText="orderdatetime" SortExpression="orderdatetime" />
        </Columns>
        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
        <AlternatingRowStyle BackColor="#DCDCDC" />
    </asp:GridView>
    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConflictDetection="CompareAllValues"
        ConnectionString="<%$ ConnectionStrings:shoppingConnectionString %>" DeleteCommand="DELETE FROM [order] WHERE [orderid] = @original_orderid"
        OldValuesParameterFormatString="original_{0}" SelectCommand="SELECT [customid], [orderid], [productid], [productname], [quantityperunit], [unitprice], [ordernum], [orderdatetime] FROM [order] WHERE (([customid] = @customid) AND ([orderdatetime] = @orderdatetime))">
        <DeleteParameters>
            <asp:Parameter Name="original_orderid" Type="Int32" />
        </DeleteParameters>
        <SelectParameters>
            <asp:SessionParameter Name="customid" SessionField="khbz" Type="String" />
            <asp:SessionParameter Name="orderdatetime" SessionField="ccsj" Type="DateTime" />
        </SelectParameters>
    </asp:SqlDataSource>
</asp:Content>