order_search_control.ascx

这是一个订单管理系统

<%@ Control Language="VB" AutoEventWireup="false" CodeFile="Order_Search_Control.ascx.vb" Inherits="Order_Search_Control" %>
<link href="Default/CSS/Sta_Page.css" rel="stylesheet" type="text/css" />
<table class="Order_table">
    <tr>
        <td colspan="5" class="Order_Table_TopLine">
            <asp:Label ID="Label1" runat="server" Text="专项搜索"></asp:Label></td>
    </tr>
    <tr>
        <td style="width: 27px">
        </td>
        <td style="width: 47px">
            <asp:Label ID="Label2" runat="server" Text="搜索类型" Height="8px" Width="64px"></asp:Label></td>
        <td style="width: 74px">
            <asp:DropDownList ID="DropDownList1" runat="server">
                <asp:ListItem Value="0">客户单价查询</asp:ListItem>
                <asp:ListItem Value="1">本月各客户订单平均预期利润</asp:ListItem>
                <asp:ListItem Value="2">每个客户的订单总金额</asp:ListItem>
            </asp:DropDownList></td>
        <td style="width: 24px">
            <asp:Button ID="Button1" runat="server" Text="搜索" /></td>
        <td>
        </td>
    </tr>
    <tr>
        <td rowspan="7" style="width: 27px">
        </td>
        <td colspan="4" rowspan="1">
            <asp:Label ID="Label3" runat="server" Text="订单金额超过平均值的客户数"></asp:Label></td>
    </tr>
    <tr>
        <%--<td colspan="4" rowspan="1">
            <asp:Label ID="Label4" runat="server" Text="本月所签订单的预期利润高于1万元的客户数"></asp:Label></td>--%>
    </tr>
    <tr>
        <td colspan="4" rowspan="5">
            &nbsp;<asp:Panel ID="Panel0" runat="server" Height="50px" Visible="False" Width="125px">
                <asp:GridView ID="GridView0" runat="server" AllowPaging="True" AllowSorting="True"
                    CellPadding="4" GridLines="None" Width="704px" ForeColor="#333333" AutoGenerateColumns="False">
                    <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
                    <Columns>
                        <asp:BoundField HeaderText="客户ID" DataField="ClientId" />
                        <asp:BoundField HeaderText="当年订单均值" DataField="avgValue" />
                        <asp:BoundField HeaderText="当年订单最高值" DataField="maxValue" />
                        <asp:BoundField HeaderText="当年订单最低值" DataField="minValue" />
                    </Columns>
                    <RowStyle BackColor="#EFF3FB" />
                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" />
                    <EditRowStyle BackColor="#2461BF" />
                </asp:GridView>
            </asp:Panel>
            <asp:Panel ID="Panel1" runat="server" Height="50px" Visible="False" Width="125px">
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
                    CellPadding="4" GridLines="None" Width="704px" ForeColor="#333333" AutoGenerateColumns="False">
                    <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
                    <Columns>
                        <asp:BoundField HeaderText="客户ID" DataField="clientid"/>
                        <asp:BoundField HeaderText="客户预期均利/月" DataField="result"/>
                    </Columns>
                    <RowStyle BackColor="#EFF3FB" />
                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" />
                    <EditRowStyle BackColor="#2461BF" />
                </asp:GridView>
            </asp:Panel>
            <asp:Panel ID="Panel2" runat="server" Height="50px" Visible="False" Width="125px">
                <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AllowSorting="True"
                    CellPadding="4" GridLines="None" Width="704px" ForeColor="#333333" AutoGenerateColumns="False">
                    <FooterStyle BackColor="#507CD1" ForeColor="White" Font-Bold="True" />
                    <Columns>
                        <asp:BoundField HeaderText="客户ID" DataField="clientid"/>
                        <asp:BoundField HeaderText="订单总金额" DataField="sumnumber"/>
                    </Columns>
                    <RowStyle BackColor="#EFF3FB" />
                    <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
                    <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
                    <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
                    <AlternatingRowStyle BackColor="White" />
                    <EditRowStyle BackColor="#2461BF" />
                </asp:GridView>
            </asp:Panel>
        </td>
    </tr>
    <tr>
    </tr>
    <tr>
    </tr>
    <tr>
    </tr>
    <tr>
    </tr>
    <tr>
        <td style="width: 27px">
        </td>
        <td colspan="4">
        </td>
    </tr>
</table>