columnlist.ascx

用vs2005写的一个生产任务管理系统。数据的统计和综合查询是主要功能

<%@ Control Language="c#" Inherits="RWSB.columnlist" CodeFile="columnlist.ascx.cs" %>

<table id="Table3" cellSpacing="0" cellPadding="0" width="100%" bgColor="#FFFFFF" border="0" >
<tr>
    <td align="center" bgcolor="#6699ff" style="width: 208px; height: 19px">
        <asp:Label ID="Label1" runat="server" Font-Names="宋体" ForeColor="White" Text="开　始　时　间"
            Width="176px"></asp:Label></td>
    <td align="center" bgcolor="#6699ff" style="width: 207px; height: 19px">
        <asp:Label ID="Label2" runat="server" Font-Names="宋体" ForeColor="White" Text="截　止　时　间"
            Width="195px"></asp:Label></td>
    <td align="center" bgcolor="#6699ff" style="width: 224px; height: 19px">
        <asp:Label ID="Label3" runat="server" Font-Names="宋体" ForeColor="White" Text="作　业　车　间"
            Width="202px"></asp:Label></td>
<td style="height: 19px" bgcolor="#6699ff"></td>
</tr>
</table>　　
　　<table id="Table2" cellSpacing="0" cellPadding="0" width="100%" bgColor="#FFFFFF" border="0" >
    <tr>
        <td style="width: 323px" align="center" valign="middle" >
            <asp:DropDownList ID="syDDL" runat="server" AutoPostBack="True" OnSelectedIndexChanged="syDDL_SelectedIndexChanged">
                <asp:ListItem>请选择</asp:ListItem>
            </asp:DropDownList>年<asp:DropDownList ID="smDDL" runat="server" AutoPostBack="True" OnSelectedIndexChanged="smDDL_SelectedIndexChanged">
                <asp:ListItem>请选择</asp:ListItem>
            </asp:DropDownList>月<asp:DropDownList ID="sdDDL" runat="server">
                <asp:ListItem>请选择</asp:ListItem>
            </asp:DropDownList>日</td>
        <td style="width: 335px" align="center" valign="middle" >
            <asp:DropDownList ID="eyDDL" runat="server" AutoPostBack="True" OnSelectedIndexChanged="eyDDL_SelectedIndexChanged" >
                <asp:ListItem>请选择</asp:ListItem>
            </asp:DropDownList>年<asp:DropDownList ID="emDDL" runat="server" AutoPostBack="True" OnSelectedIndexChanged="emDDL_SelectedIndexChanged">
                <asp:ListItem>请选择</asp:ListItem>
            </asp:DropDownList>月<asp:DropDownList ID="edDDL" runat="server">
                <asp:ListItem>请选择</asp:ListItem>
            </asp:DropDownList>日</td>
       <td style="width: 231px" align="center">
           <asp:DropDownList ID="zycjDDL" runat="server" Width="180px">
           </asp:DropDownList>
       </td>
       <td>
           <asp:Button ID="tjBT" runat="server" Text="统  计" OnClick="tjBT_Click" />
       </td>
    </tr>
      <tr>
          <td align="center" colspan="4" style="height: 19px" valign="middle">
          </td>
      </tr>
</table>
<TABLE id="Table4" cellSpacing="0" cellPadding="0" width="100%" bgColor="#a0bce7" border="0">
	<TR>
		<TD bgColor="#ffffff">
            <asp:GridView ID="tjGV" runat="server" Font-Size="X-Small" Width="100%" AllowPaging="True">
            <HeaderStyle BackColor="LightGoldenrodYellow" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" Font-Names="宋体" Font-Size="X-Small"></HeaderStyle>
                <Columns>
                    <asp:BoundField DataField="zycjorder" HeaderText="序号" Visible="False">
                        <ItemStyle Width="1%" />
                        <HeaderStyle BackColor="LightGoldenrodYellow" Font-Bold="False" Font-Italic="False" Font-Overline="False" Font-Strikeout="False" Font-Underline="False" HorizontalAlign="Center" Font-Names="宋体" Font-Size="XX-Small"></HeaderStyle>
                    </asp:BoundField>
                    <asp:BoundField DataField="sbsj" HeaderText="上报时间" Visible="False" />
                </Columns>
            </asp:GridView>
        </TD>
	</TR>
</TABLE>