管理考勤信息.aspx

人事管理系统

<%@ Page Language="VB" MasterPageFile="~/母版1.master" AutoEventWireup="false" CodeFile="管理考勤信息.aspx.vb" Inherits="考勤信息" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="1">
        <tr>
            <td style="height: 23px" colspan="4">
                <strong><span style="font-size: 16pt"><span style="font-family: 华文新魏"><span style="color: #ff00ff">
                    员工考勤<img src="image/nc_2.gif" /></span><span style="color: #ff00ff">信息表
</span></span></span></strong></td>  
        </tr>
       
    </table>
    <table border="1" Width=70%>
        <tr>
            <td style="width: 20%; height: 23px;">
                员工号：</td><td style="width: 30%; height: 23px;">
                <asp:TextBox ID="TextBox1" runat="server" Width="147px" Height="19px"></asp:TextBox>
                    </td> <td style="width: 20%; height: 23px;">
                    <asp:Label ID="Label2" runat="server" Text="Label" Width="154px"></asp:Label>
                        <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                            Display="Dynamic" ErrorMessage="员工号不能为空，且为数值型" ValidationGroup="a">数字型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                姓名：</td><td style="width:30%">
                <asp:TextBox ID="TextBox2" runat="server" Visible="true"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
                        Display="Dynamic" ErrorMessage="姓名不能为空，且为文本型！" ValidationGroup="a">文本型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                日期：</td>
            <td style="width: 30%">
                <asp:TextBox ID="TextBox3" runat="server"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3"
                        Display="Dynamic" ErrorMessage="日期不能为空！" ValidationGroup="a">数字型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                本月天数：</td>
            <td style="width: 30%">
                <asp:TextBox ID="TextBox4" runat="server"></asp:TextBox></td> <td style="width:20%; height: 23px;">
                    <asp:RangeValidator ID="RangeValidator1" runat="server" ControlToValidate="TextBox4"
                        Display="Dynamic" ErrorMessage="本月天数在0-31之间" MaximumValue="31" MinimumValue="0">数字型</asp:RangeValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                公休假天数：</td>
            <td style="width: 30%">
                <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox5"
                        Display="Dynamic" ErrorMessage="公休假天数为数字型" ValidationGroup="a">数字型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                应出勤天数：</td>
            <td style="width: 30%">
                <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox6"
                        Display="Dynamic" ErrorMessage="请输入数字型！" ValidationGroup="a">数字型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                请假：</td>
            <td style="width: 30%">
                <asp:TextBox ID="TextBox7" runat="server"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox7"
                        Display="Dynamic" ErrorMessage="请输入整型数字" ValidationGroup="a">数字型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%">
                节假日加班：</td>
            <td style="width: 30%">
                <asp:TextBox ID="TextBox8" runat="server"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="TextBox8"
                        Display="Dynamic" ErrorMessage="请输入文本型！" ValidationGroup="a">文本型</asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td style="width: 20%; height: 25px">
                其他加班：</td>
            <td style="width: 30%; height: 25px">
                <asp:TextBox ID="TextBox9" runat="server"></asp:TextBox></td> <td style="width: 20%; height: 23px;">
                    <asp:RequiredFieldValidator ID="RequiredFieldValidator8" runat="server" ControlToValidate="TextBox9"
                        Display="Dynamic" ErrorMessage="请输入文本型" ValidationGroup="a">文本型</asp:RequiredFieldValidator></td>
        </tr>
    </table>
    <asp:ValidationSummary ID="ValidationSummary1" runat="server" ValidationGroup="a" />
    &nbsp;<asp:Label ID="Label1" runat="server" Text="Label" Width="202px"></asp:Label>
    <table border="1" width =70%>
        <tr>
            <td style="width: 100px; height: 23px">
                <asp:Button ID="Button3" runat="server" Text="考勤查询" /></td>
            <td style="width: 100px; height: 23px">
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource1"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList></td>
            <td style="width: 100px; height: 23px">
                <asp:Button ID="Button1" runat="server" Text="考勤登记" ValidationGroup="a" Width="86px" /></td> <td style="width: 100px; height: 23px">
                    <asp:Button ID="Button4" runat="server" Text="取消登记" /></td>
        </tr>
        <tr>
            <td style="width: 100px; height: 23px">
            </td>
            <td style="width: 100px; height: 23px">
                <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource2"
        DataTextField="员工号" DataValueField="员工号">
    </asp:DropDownList></td>
            <td style="width: 100px; height: 23px">
    <asp:Button ID="Button2" runat="server" Text="考勤更新" ValidationGroup="a" Width="94px" /></td>
            <td style="width: 100px; height: 23px">
            </td>
        </tr>
        <tr>
            <td style="width: 100px; height: 23px">
            </td>
            <td style="width: 100px; height: 23px">
                <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource3"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
            </td>
            <td style="width: 100px; height: 23px">
                    <asp:Button ID="Button6" runat="server" Text="删除" Width="97px" /></td>
            <td style="width: 100px; height: 23px">
            </td>
        </tr>
    </table>
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<asp:GridView ID="GridView2" runat="server" Width=70%>
    </asp:GridView>
    <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataSourceID="AccessDataSource1" PageSize="5" Width=70% DataKeyNames="员工号">
        <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="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT * FROM [员工考勤信息表]"></asp:AccessDataSource>
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp;&nbsp;<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT [员工号] FROM [员工考勤信息表]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource3" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT [员工号] FROM [员工考勤信息表]"></asp:AccessDataSource>
    &nbsp; &nbsp; &nbsp;&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;
    <br />
</asp:Content>