管理学历信息.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: 24px;" colspan="6">
                <span style="font-size: 14pt; color: #cc66ff; font-family: 华文行楷"><strong>员工<img src="image/nc_2.gif" />学历信息</strong></span></td>
            
        </tr>
        <tr>
            <td style="width: 100px; height: 64px;">
                员工号：</td>
            <td style="width: 94px; height: 64px;">
                <asp:TextBox ID="TextBox1" runat="server" Width="87px" Height="28px"></asp:TextBox>
                <asp:Label ID="Label2" runat="server" Text="Label" Width="44px"></asp:Label>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ErrorMessage="不能为空"
                    ValidationGroup="1" ControlToValidate="TextBox1"></asp:RequiredFieldValidator></td>
            <td style="width: 100px; height: 64px;">
                学历：</td>
            <td style="width: 88px; height: 64px;">
                <asp:TextBox ID="TextBox2" runat="server" Width="89px" Height="26px"></asp:TextBox></td>
            <td style="width: 122px; height: 64px;">
                专业：</td>
            <td style="width: 100px; height: 64px;">
                <asp:TextBox ID="TextBox3" runat="server" Width="99px" Height="25px"></asp:TextBox></td>
        </tr>
        <tr>
            <td style="width: 100px">
                毕业时间:</td>
            <td style="width: 94px">
                <asp:TextBox ID="TextBox4" runat="server" Width="85px" Height="24px"></asp:TextBox></td>
            <td style="width: 100px">
                毕业学校:</td>
            <td style="width: 88px">
                <asp:TextBox ID="TextBox5" runat="server" Width="87px" Height="22px"></asp:TextBox></td>
            <td style="width: 122px">
                语种：</td>
            <td style="width: 100px">
                <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource2"
                    DataTextField="名称" DataValueField="名称">
                </asp:DropDownList>
                &nbsp;&nbsp;
            </td>
        </tr>
        <tr>
            <td colspan="6">
                <asp:Button ID="Button2" runat="server" Text="查询员工学历信息" />
                &nbsp;
                <asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource1"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
                &nbsp;<asp:Button ID="Button5" runat="server" Text="登记学历信息" ValidationGroup="1" />
                <asp:Button ID="Button1" runat="server" Text="取消学历登记" /></td>
        </tr>
        <tr>
            <td colspan="6">
                &nbsp; 请选择您要更新的员工号：<asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource3"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
                <asp:Button ID="Button6" runat="server" Text="更新学历信息" />
                <asp:Label ID="Label1" runat="server" Text="Label" Width="110px"></asp:Label>&nbsp;&nbsp;
                &nbsp;
                &nbsp; &nbsp;&nbsp;
            </td>
        </tr>
        <tr>
            <td colspan="6">
                请选择您要删除的员工号：<asp:DropDownList ID="DropDownList4" runat="server" AutoPostBack="True"
                    DataSourceID="AccessDataSource5" DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
                <asp:Button ID="Button4" runat="server" Text="删除学历信息" />
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
                &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;
            </td>
        </tr>
        <tr>
            <td colspan="6">
                &nbsp;<asp:GridView ID="GridView1" runat="server"  Width =100%>
                </asp:GridView>
                &nbsp; &nbsp;
                <asp:GridView ID="GridView2" runat="server" AllowPaging="True" AutoGenerateColumns="False"
                    DataKeyNames="员工号" DataSourceID="AccessDataSource4" PageSize="5" Width =100%>
                    <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="语种" />
                    </Columns>
                </asp:GridView>
                <asp:AccessDataSource ID="AccessDataSource4" 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="AccessDataSource1" 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="AccessDataSource5" runat="server" DataFile="~/App_Data/db1.mdb"
                    SelectCommand="SELECT [员工号] FROM [员工学历信息表]"></asp:AccessDataSource>
            </td>
        </tr>
    </table>
    &nbsp; &nbsp; &nbsp; &nbsp;<br />
    &nbsp; &nbsp; &nbsp; &nbsp;
    &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;<br />
    <br />
    <br />
    &nbsp;
</asp:Content>