Admin/OrderList2.aspx

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

<%@ Page language="c#" Inherits="OrderList2" CodeFile="OrderList2.aspx.cs" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >
<HTML>
	<HEAD>
		<title>OrderList2</title>
		<link rel="stylesheet" type="text/css" href="../css/Admin_STYLE.CSS">
	</HEAD>
	<body>
		<form id="Form1" method="post" runat="server">
            <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:ConnectionString %>"
                DeleteCommand="DELETE FROM [tOrder] WHERE [ID] = @ID" InsertCommand="INSERT INTO [tOrder] ([opid], [opnum], [ouser], [otime], [isdeal]) VALUES (@opid, @opnum, @ouser, @otime, @isdeal)"
                SelectCommand="SELECT * FROM [tOrder] WHERE ([isdeal] = @isdeal)" UpdateCommand="UPDATE [tOrder] SET [opid] = @opid, [opnum] = @opnum, [ouser] = @ouser, [otime] = @otime, [isdeal] = @isdeal WHERE [ID] = @ID">
                <DeleteParameters>
                    <asp:Parameter Name="ID" Type="Int64" />
                </DeleteParameters>
                <UpdateParameters>
                    <asp:Parameter Name="opid" Type="Int32" />
                    <asp:Parameter Name="opnum" Type="Int32" />
                    <asp:Parameter Name="ouser" Type="String" />
                    <asp:Parameter Name="otime" Type="DateTime" />
                    <asp:Parameter Name="isdeal" Type="String" />
                    <asp:Parameter Name="ID" Type="Int64" />
                </UpdateParameters>
                <SelectParameters>
                    <asp:Parameter DefaultValue="否" Name="isdeal" Type="String" />
                </SelectParameters>
                <InsertParameters>
                    <asp:Parameter Name="opid" Type="Int32" />
                    <asp:Parameter Name="opnum" Type="Int32" />
                    <asp:Parameter Name="ouser" Type="String" />
                    <asp:Parameter Name="otime" Type="DateTime" />
                    <asp:Parameter Name="isdeal" Type="String" />
                </InsertParameters>
            </asp:SqlDataSource>
            <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                AutoGenerateColumns="False" BackColor="White" BorderColor="#336666" BorderStyle="Double"
                BorderWidth="3px" CellPadding="4" DataKeyNames="ID" DataSourceID="SqlDataSource1"
                Width="773px">
                <FooterStyle BackColor="White" ForeColor="#333333" />
                <Columns>
                    <asp:BoundField DataField="ID" HeaderText="ID" InsertVisible="False" ReadOnly="True"
                        SortExpression="ID" />
                    <asp:BoundField DataField="opid" HeaderText="商品ID" ReadOnly="True" SortExpression="opid" />
                    <asp:BoundField DataField="opnum" HeaderText="订购数量" ReadOnly="True" SortExpression="opnum" />
                    <asp:BoundField DataField="ouser" HeaderText="订购者" ReadOnly="True" SortExpression="ouser" />
                    <asp:BoundField DataField="otime" HeaderText="订购时间" ReadOnly="True" SortExpression="otime" />
                    <asp:BoundField DataField="isdeal" HeaderText="处理" SortExpression="isdeal" />
                    <asp:CommandField ShowDeleteButton="True" ShowEditButton="True" />
                </Columns>
                <RowStyle BackColor="White" ForeColor="#333333" HorizontalAlign="Center" />
                <SelectedRowStyle BackColor="#339966" Font-Bold="True" ForeColor="White" />
                <PagerStyle BackColor="#336666" ForeColor="White" HorizontalAlign="Center" />
                <HeaderStyle BackColor="#336666" Font-Bold="True" ForeColor="White" />
            </asp:GridView>
		</form>
	</body>
</HTML>