dutylistmain.aspx

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

<%@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="DutyListMain.aspx.cs" Inherits="DutyListMain" Title="值班表主页面" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    --&gt;值班列表<br />
    <asp:Label ID="Label1" runat="server" Text="还没有任何数据，请添加"></asp:Label><br />
    <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>
    <br />
    <asp:Panel ID="Panel1" runat="server" Height="600px" Width="500px">
        <table width="600">
            <tr>
                <td style="width: 196px">
                    部门</td>
                <td style="width: 200px">
                    <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" OnSelectedIndexChanged="DropDownList1_SelectedIndexChanged">
                    </asp:DropDownList>*</td>
                <td style="width: 300px">
                </td>
            </tr>
            <tr>
                <td style="width: 196px">
                    人员</td>
                <td style="width: 200px">
                    <asp:DropDownList ID="DropDownList2" runat="server">
                    </asp:DropDownList>*</td>
                <td style="width: 300px">
                </td>
            </tr>
            <tr>
                <td style="width: 196px">
                    开始日期</td>
                <td style="width: 200px" valign="top">
                    <asp:TextBox ID="TextBox1" runat="server" Width="200px" ReadOnly="True"></asp:TextBox></td>
                <td align="left" style="width: 300px">
                    <asp:Button ID="Button1" runat="server" OnClick="Button1_Click" Text=".." />
                    *<asp:Calendar ID="Calendar1" runat="server" BackColor="White" BorderColor="White"
                        BorderWidth="1px" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="190px"
                        NextPrevFormat="FullMonth" OnSelectionChanged="Calendar1_SelectionChanged" Visible="False"
                        Width="200px">
                        <SelectedDayStyle BackColor="#333399" ForeColor="White" />
                        <TodayDayStyle BackColor="#CCCCCC" />
                        <OtherMonthDayStyle ForeColor="#999999" />
                        <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
                        <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
                        <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True"
                            Font-Size="12pt" ForeColor="#333399" />
                    </asp:Calendar>
                </td>
            </tr>
            <tr>
                <td style="width: 196px">
                    结束日期</td>
                <td style="width: 200px" valign="top">
                    <asp:TextBox ID="TextBox3" runat="server" ReadOnly="True" Width="200px"></asp:TextBox></td>
                <td align="left" style="width: 300px">
                    <asp:Button ID="Button4" runat="server" OnClick="Button4_Click" Text=".." />
                    *<asp:Calendar ID="Calendar2" runat="server" BackColor="White" BorderColor="White"
                        BorderWidth="1px" Font-Names="Verdana" Font-Size="9pt" ForeColor="Black" Height="190px"
                        NextPrevFormat="FullMonth" OnSelectionChanged="Calendar2_SelectionChanged" Visible="False"
                        Width="200px">
                        <SelectedDayStyle BackColor="#333399" ForeColor="White" />
                        <TodayDayStyle BackColor="#CCCCCC" />
                        <OtherMonthDayStyle ForeColor="#999999" />
                        <NextPrevStyle Font-Bold="True" Font-Size="8pt" ForeColor="#333333" VerticalAlign="Bottom" />
                        <DayHeaderStyle Font-Bold="True" Font-Size="8pt" />
                        <TitleStyle BackColor="White" BorderColor="Black" BorderWidth="4px" Font-Bold="True"
                            Font-Size="12pt" ForeColor="#333399" />
                    </asp:Calendar>
                </td>
            </tr>
            <tr>
                <td style="width: 196px; height: 22px">
                    备注</td>
                <td style="width: 200px; height: 22px">
                    <asp:TextBox ID="TextBox2" runat="server"></asp:TextBox></td>
                <td style="width: 300px; height: 22px">
                </td>
            </tr>
            <tr>
                <td style="width: 196px">
                </td>
                <td style="width: 200px">
                    <asp:Button ID="Button2" runat="server" Text="add" OnClick="Button2_Click" />
                    <asp:Button ID="Button3" runat="server" Text="reset" /></td>
                <td style="width: 300px">
                </td>
            </tr>
        </table>
        <asp:Label ID="Label2" runat="server"></asp:Label></asp:Panel>
</asp:Content>