管理基本信息.aspx

人事管理系统

<%@ Page Language="VB" MasterPageFile="~/母版1.master" AutoEventWireup="false" CodeFile="管理基本信息.aspx.vb" Inherits="管理基本信息" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    &nbsp;&nbsp; &nbsp;&nbsp;<br />
    <table border="1" cellpadding="0" cellspacing="0" style="height: 26px; width: 100%;">
        <tr>
            <td align="center" colspan="6" style="height: 37px">
                <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>
        <tr>
            <td style="height: 37px; width: 14%;" align="center">
                员工号：</td>
            <td style="height: 37px; width: 10%;">
                <asp:TextBox ID="TextBox1" runat="server" Width="72px" Height="21px"></asp:TextBox>
                <asp:Label ID="Label2" runat="server" Visible="False" Width="70px"></asp:Label>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                    ErrorMessage="不能为空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
            <td width="16%" style="height: 37px" align="center">
                姓名：</td>
            <td style="height: 37px; width: 16%;">
                <asp:TextBox ID="TextBox2" runat="server" Width="95px" Height="24px"></asp:TextBox></td>
            <td style="width: 16%; height: 37px" align="center">
                性别：</td>
            <td style="width: 12%; height: 37px">
                <asp:TextBox ID="TextBox8" runat="server" Height="26px" Width="81px"></asp:TextBox>&nbsp;
            </td>
           
            
           
        </tr>
        <tr>
            <td align="center" style="width: 14%; height: 4px">
                婚姻状况：</td>
            <td style="width: 10%; height: 4px">
                <asp:TextBox ID="TextBox9" runat="server" Height="24px" Width="73px"></asp:TextBox>&nbsp;
            </td>
            <td align="center" style="height: 4px" width="16%">
                健康状况:</td>
            <td style="width: 16%; height: 4px">
                &nbsp;<asp:TextBox ID="TextBox3" runat="server" Height="23px" Width="91px"></asp:TextBox></td>
            <td align="center" style="width: 16%; height: 4px">
                政治面貌：</td>
            <td style="width: 12%; height: 4px">
                <asp:TextBox ID="TextBox4" runat="server" Height="21px" Width="82px"></asp:TextBox></td>
        </tr>
        <tr>
            <td align="center" style="width: 14%; height: 8px">
                开始工作时间:</td>
            <td width= 10% >
                <asp:TextBox ID="TextBox5" runat="server" Height="23px" Width="75px"></asp:TextBox></td>
            <td align="center" style="height: 8px" width="16%">
                家庭地址：</td>
            <td style="width: 16%; height: 8px">
                <asp:TextBox ID="TextBox6" runat="server" Height="25px" Width="94px"></asp:TextBox></td>
            <td align="center" style="width: 16%; height: 8px">
                电话：</td>
            <td style="width: 12%; height: 8px">
                <asp:TextBox ID="TextBox7" runat="server" Height="25px" Width="81px"></asp:TextBox></td>
        </tr>
        <tr>
            <td align="center" style="height: 12px" colspan="6">
                <asp:Button ID="Button1" runat="server" Text="员工信息查询" />&nbsp;<asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource2"
        DataTextField="员工号" DataValueField="员工号">
    </asp:DropDownList><asp:Button ID="Button2" runat="server" Text="员工信息登记" ValidationGroup="1" />&nbsp;<asp:Button
                    ID="Button5" runat="server" Text="取消信息登记" />
    <asp:Label ID="Label1" runat="server" Text="Label"></asp:Label></td>
        </tr>
        <tr>
            <td align="center" colspan="6" style="height: 12px">
                请选择您要更新的员工号：&nbsp;<asp:DropDownList ID="DropDownList2"
                    runat="server" AutoPostBack="True" DataSourceID="AccessDataSource3" DataTextField="员工号"
                    DataValueField="员工号">
                </asp:DropDownList>
                <asp:Button ID="Button4" runat="server" Text="更新员工信息" />&nbsp;
            </td>
        </tr>
        <tr>
            <td align="center" colspan="6" style="height: 12px">
                请选择您要删除的员工号：<asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True"
                    DataSourceID="AccessDataSource4" DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
                <asp:Button ID="Button3" runat="server" Text="员工信息删除" />
            </td>
        </tr>
        
    </table>
    &nbsp;&nbsp;<asp:GridView ID="GridView1" runat="server" Width="643px">
    </asp:GridView>
    &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp;<asp:GridView ID="GridView2" runat="server"
        AutoGenerateColumns="False" DataKeyNames="员工号" DataSourceID="AccessDataSource1" 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="AccessDataSource1" 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>
    <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT [员工号] FROM [员工基本信息表]"></asp:AccessDataSource>
    <asp:AccessDataSource ID="AccessDataSource4" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT [员工号] FROM [员工基本信息表]"></asp:AccessDataSource>
    <br />
    <br />
    <br />
    &nbsp;
</asp:Content>