adminorderlistmanger.aspx

完成一个网上书店系统

<%@ Page Language="C#" MasterPageFile="~/Admin.master" AutoEventWireup="true" CodeFile="AdminOrderListManger.aspx.cs" Inherits="AdminOrderListManger" Title="无标题页" %>

<asp:Content ID="Content1" ContentPlaceHolderID="head" Runat="Server">
    <style type="text/css">
        .style22
        {
            width: 219px;
        }
    </style>
</asp:Content>
<asp:Content ID="Content2" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table style="width:100%;">
        <tr>
            <td>
                &nbsp;</td>
            <td class="style22">
                &nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td class="style22">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
                    AllowSorting="True" AutoGenerateColumns="False" DataKeyNames="OrderID" 
                    DataSourceID="SqlDataSource1" Width="804px" BackColor="White" 
                    BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" 
                    GridLines="Vertical">
                    <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
                    <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
                    <Columns>
                        <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                        <asp:BoundField DataField="OrderID" HeaderText="订单号" InsertVisible="False" 
                            ReadOnly="True" SortExpression="OrderID" />
                        <asp:TemplateField HeaderText="用户ID" SortExpression="UserID">
                            <EditItemTemplate>
                                <asp:TextBox ID="TextBox1" runat="server" Text='<%# Bind("UserID") %>'></asp:TextBox>
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:Label ID="Label1" runat="server" Text='<%# Eval("UserID") %>'></asp:Label>
                            </ItemTemplate>
                        </asp:TemplateField>
                        <asp:BoundField DataField="OrderDate" DataFormatString="{0:d}" 
                            HeaderText="订单日期" SortExpression="OrderDate" />
                        <asp:CheckBoxField DataField="IsCancel" HeaderText="删除" 
                            SortExpression="IsCancel" />
                        <asp:TemplateField HeaderText="审核" SortExpression="ischecked">
                            <EditItemTemplate>
                                <asp:CheckBox ID="CheckBox1" runat="server" 
                                    Checked='<%# Bind("ischecked") %>' />
                            </EditItemTemplate>
                            <ItemTemplate>
                                <asp:CheckBox ID="CheckBox1" runat="server" Checked='<%# Eval("ischecked") %>' 
                                    Enabled="False" oncheckedchanged="CheckBox1_CheckedChanged" />
                            </ItemTemplate>
                        </asp:TemplateField>
                    </Columns>
                    <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
                    <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
                    <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="#DCDCDC" />
                </asp:GridView>
                <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
                    ConnectionString="<%$ ConnectionStrings:BookShopConnectionString %>" 
                    DeleteCommand="DELETE FROM [Orders] WHERE [OrderID] = @OrderID" 
                    InsertCommand="INSERT INTO [Orders] ([UserID], [OrderDate], [IsCancel], [ischecked]) VALUES (@UserID, @OrderDate, @IsCancel, @ischecked)" 
                    SelectCommand="SELECT * FROM [Orders]" 
                    UpdateCommand="UPDATE [Orders] SET [UserID] = @UserID, [OrderDate] = @OrderDate, [IsCancel] = @IsCancel, [ischecked] = @ischecked WHERE [OrderID] = @OrderID">
                    <DeleteParameters>
                        <asp:Parameter Name="OrderID" Type="Int32" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="UserID" Type="Int32" />
                        <asp:Parameter Name="OrderDate" Type="DateTime" />
                        <asp:Parameter Name="IsCancel" Type="Boolean" />
                        <asp:Parameter Name="ischecked" Type="Boolean" />
                        <asp:Parameter Name="OrderID" Type="Int32" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="UserID" Type="Int32" />
                        <asp:Parameter Name="OrderDate" Type="DateTime" />
                        <asp:Parameter Name="IsCancel" Type="Boolean" />
                        <asp:Parameter Name="ischecked" Type="Boolean" />
                    </InsertParameters>
                </asp:SqlDataSource>
                
            </td>
            <td >
                &nbsp;</td>
        </tr>
        <tr>
            <td>
                &nbsp;</td>
            <td  align=center>
                <asp:Button ID="Button1" runat="server" Text="提交更改" onclick="Button1_Click" />&nbsp;</td>
            <td>
                &nbsp;</td>
        </tr>
    </table>
</asp:Content>