userControl/shenheProduct.ascx

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

<%@ Control Language="C#" AutoEventWireup="true" CodeBehind="shenheProduct.ascx.cs" Inherits="MyPetShop.userControl.shenheProduct" %>
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" 
    AutoGenerateColumns="False" DataKeyNames="OrderId"  PageSize='5'
    DataSourceID="SqlDataSource1" Font-Size="Large" Width="100%" 
    Height="54px">
    <Columns>
        <asp:TemplateField>
            <ItemTemplate>
                <asp:CheckBox ID="chkItem" runat="server" />
            </ItemTemplate>
            <HeaderTemplate>
                <asp:CheckBox ID="chkAll" runat="server" AutoPostBack="true" 
                    OnCheckedChanged="chkAll_checkedChanged" Text="全选" />
            </HeaderTemplate>
        </asp:TemplateField>
        <asp:BoundField DataField="OrderId" HeaderText="订单ID" InsertVisible="False" 
            ReadOnly="True" SortExpression="OrderId" />
        <asp:BoundField DataField="UserName" HeaderText="顾客姓名" 
            SortExpression="UserName" />
        <asp:BoundField DataField="OrderDate" HeaderText="订单日期" 
            SortExpression="OrderDate" />
        <asp:BoundField DataField="ProductName" HeaderText="商品名" 
            SortExpression="ProductName" />
        <asp:BoundField DataField="ProductNum" HeaderText="商品数量" 
            SortExpression="ProductNum" />
        <asp:BoundField DataField="TotalPrice" HeaderText="总花费" 
            SortExpression="TotalPrice" />
        <asp:BoundField DataField="Addr" HeaderText="地址" SortExpression="Addr" />
        <asp:BoundField DataField="Phone" HeaderText="电话" SortExpression="Phone" />
        <asp:BoundField DataField="Status" HeaderText="状态" SortExpression="Status" />
        <asp:CommandField ShowDeleteButton="True" />
    </Columns>
</asp:GridView>
<asp:Button ID="Button1" runat="server" onclick="Button1_Click" Text="审核商品" />
&nbsp;&nbsp;
<asp:Button ID="Button2" runat="server" PostBackUrl="~/SysMessage.aspx" 
    Text="返回" Width="51px" />
<asp:SqlDataSource ID="SqlDataSource1" runat="server" 
    ConflictDetection="CompareAllValues" 
    ConnectionString="<%$ ConnectionStrings:ConnectionString %>" 
    DeleteCommand="DELETE FROM [Order] WHERE [OrderId] = @original_OrderId AND (([UserName] = @original_UserName) OR ([UserName] IS NULL AND @original_UserName IS NULL)) AND (([OrderDate] = @original_OrderDate) OR ([OrderDate] IS NULL AND @original_OrderDate IS NULL)) AND (([ProductName] = @original_ProductName) OR ([ProductName] IS NULL AND @original_ProductName IS NULL)) AND (([ProductNum] = @original_ProductNum) OR ([ProductNum] IS NULL AND @original_ProductNum IS NULL)) AND (([TotalPrice] = @original_TotalPrice) OR ([TotalPrice] IS NULL AND @original_TotalPrice IS NULL)) AND (([Addr] = @original_Addr) OR ([Addr] IS NULL AND @original_Addr IS NULL)) AND (([Phone] = @original_Phone) OR ([Phone] IS NULL AND @original_Phone IS NULL)) AND (([Status] = @original_Status) OR ([Status] IS NULL AND @original_Status IS NULL))" 
    InsertCommand="INSERT INTO [Order] ([UserName], [OrderDate], [ProductName], [ProductNum], [TotalPrice], [Addr], [Phone], [Status]) VALUES (@UserName, @OrderDate, @ProductName, @ProductNum, @TotalPrice, @Addr, @Phone, @Status)" 
    OldValuesParameterFormatString="original_{0}" 
    SelectCommand="SELECT [OrderId], [UserName], [OrderDate], [ProductName], [ProductNum], [TotalPrice], [Addr], [Phone], [Status] FROM [Order]" 
    
    UpdateCommand="UPDATE [Order] SET [UserName] = @UserName, [OrderDate] = @OrderDate, [ProductName] = @ProductName, [ProductNum] = @ProductNum, [TotalPrice] = @TotalPrice, [Addr] = @Addr, [Phone] = @Phone, [Status] = @Status WHERE [OrderId] = @original_OrderId AND (([UserName] = @original_UserName) OR ([UserName] IS NULL AND @original_UserName IS NULL)) AND (([OrderDate] = @original_OrderDate) OR ([OrderDate] IS NULL AND @original_OrderDate IS NULL)) AND (([ProductName] = @original_ProductName) OR ([ProductName] IS NULL AND @original_ProductName IS NULL)) AND (([ProductNum] = @original_ProductNum) OR ([ProductNum] IS NULL AND @original_ProductNum IS NULL)) AND (([TotalPrice] = @original_TotalPrice) OR ([TotalPrice] IS NULL AND @original_TotalPrice IS NULL)) AND (([Addr] = @original_Addr) OR ([Addr] IS NULL AND @original_Addr IS NULL)) AND (([Phone] = @original_Phone) OR ([Phone] IS NULL AND @original_Phone IS NULL)) AND (([Status] = @original_Status) OR ([Status] IS NULL AND @original_Status IS NULL))">
    <DeleteParameters>
        <asp:Parameter Name="original_OrderId" Type="Int32" />
        <asp:Parameter Name="original_UserName" Type="String" />
        <asp:Parameter Name="original_OrderDate" Type="DateTime" />
        <asp:Parameter Name="original_ProductName" Type="String" />
        <asp:Parameter Name="original_ProductNum" Type="Int32" />
        <asp:Parameter Name="original_TotalPrice" Type="Decimal" />
        <asp:Parameter Name="original_Addr" Type="String" />
        <asp:Parameter Name="original_Phone" Type="String" />
        <asp:Parameter Name="original_Status" Type="String" />
    </DeleteParameters>
    <InsertParameters>
        <asp:Parameter Name="UserName" Type="String" />
        <asp:Parameter Name="OrderDate" Type="DateTime" />