员工考勤信息.aspx

人事管理系统

<%@ Page Language="VB" MasterPageFile="~/母版2.master" AutoEventWireup="false" CodeFile="员工考勤信息.aspx.vb" Inherits="员工考勤信息" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    <table border="1" cellpadding="0" cellspacing="0" width= 85%>
        <tr>
            <td style="height: 20px" >
                请输入要查询信息的员工号：</td>
            <td style="height: 20px">
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource1"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
                &nbsp;
            </td>
            <td style="height: 20px; width: 58px;" >
                <asp:Button ID="Button1" runat="server" Text="查询" />
                </td>
        </tr>
    </table>
    <br />
    <br />
    <asp:GridView ID="GridView1" runat="server" width= 85%>
    </asp:GridView>
    <br />
    <asp:GridView ID="GridView2" runat="server" AutoGenerateColumns="False" DataKeyNames="员工号"
        DataSourceID="AccessDataSource2" width= 85% AllowPaging="True" PageSize="5">
        <Columns>
            <asp:BoundField DataField="员工号" HeaderText="员工号" ReadOnly="True" SortExpression="员工号" />
            <asp:BoundField DataField="姓名" HeaderText="姓名" SortExpression="姓名" />
            <asp:BoundField DataField="日期" HeaderText="日期" SortExpression="日期" />
            <asp:BoundField DataField="本月天数" HeaderText="本月天数" SortExpression="本月天数" />
            <asp:BoundField DataField="公休假天数" HeaderText="公休假天数" SortExpression="公休假天数" />
            <asp:BoundField DataField="应出勤天数" HeaderText="应出勤天数" SortExpression="应出勤天数" />
            <asp:BoundField DataField="请假" HeaderText="请假" SortExpression="请假" />
            <asp:BoundField DataField="节假日加班" HeaderText="节假日加班" SortExpression="节假日加班" />
            <asp:BoundField DataField="其它加班" HeaderText="其它加班" SortExpression="其它加班" />
        </Columns>
    </asp:GridView>
    <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT [员工号], [姓名], [日期], [本月天数], [公休假天数], [应出勤天数], [请假], [节假日加班], [其它加班] FROM [员工考勤信息表]">
    </asp:AccessDataSource>


<asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
                    SelectCommand="SELECT [员工号], [姓名], [日期], [本月天数], [公休假天数], [应出勤天数], [请假], [节假日加班], [其它加班] FROM [员工考勤信息表]">
                </asp:AccessDataSource>


</asp:Content>