dutysearchmain.aspx

值班管理系统源码 net2005+sqlserver2005 ,三层模式

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="DutySearchMain.aspx.cs" Inherits="DutySearchMain" Title="值班搜索页面" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    --&gt;值班表查询<br />
    <asp:Label ID="Label1" runat="server"></asp:Label><br />
    <asp:Label ID="Label2" runat="server" Height="25px" Text="没有匹配数据！" Visible="False"
        Width="150px"></asp:Label><br />
    <asp:Panel ID="Panel1" runat="server" Height="50px" Width="600px">
        <table>
            <tr>
                <td style="width: 100px">
                    开始日期</td>
                <td style="width: 100px">
                    <asp:TextBox ID="TextBox1" runat="server"></asp:TextBox></td>
                <td style="width: 100px">
                    结束时间</td>
                <td style="width: 100px">
                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
                <td style="width: 100px">
                    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text="search" /></td>
            </tr>
        </table>
        日期格式 yyyy-mm-dd<br />
        <br />
    </asp:Panel>
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" CellPadding="4"
        ForeColor="#333333" GridLines="None" Width="600px">
        <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
        <Columns>
            <asp:BoundField DataField="id" HeaderText="ID" />
            <asp:BoundField DataField="L_KS_KSMC" HeaderText="部门" />
            <asp:BoundField DataField="L_user_name" HeaderText="姓名" />
            <asp:BoundField DataField="L_ZBB_dateBegin" DataFormatString="{0:yyyy-MM-dd}" HeaderText="开始日期"
                HtmlEncode="False" />
            <asp:BoundField DataField="L_ZBB_dateEnd" DataFormatString="{0:yyyy-MM-dd}" HeaderText="结束日期"
                HtmlEncode="False" />
            <asp:BoundField DataField="L_ZBB_BZ" HeaderText="备注" />
        </Columns>
        <RowStyle BackColor="#EFF3FB" />
        <EditRowStyle BackColor="#2461BF" />
        <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" />
    </asp:GridView>
</asp:Content>