员工基本信息.aspx

人事管理系统

<%@ Page Language="VB" MasterPageFile="~/母版2.master" AutoEventWireup="false" CodeFile="员工基本信息.aspx.vb" Inherits="员工基本信息" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <table border="1" style="width: 514px">
        <tr>
            <td align="center" colspan="3">
                <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 align="center" style="width: 286px">
                &nbsp;请输入你要查询的员工号：</td>
            <td align="center" style="width: 100px">
                &nbsp;<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource1"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList></td>
            <td align="center" style="width: 100px">
                <asp:Button ID="Button2" runat="server" Text="查看" />&nbsp;</td>
        </tr>
        <tr>
            <td align="center" style="height: 142px" valign="baseline" colspan="3">
                <br />
                <asp:GridView ID="GridView1" runat="server" AllowPaging="True" AutoGenerateColumns="False" DataKeyNames="员工号" DataSourceID="AccessDataSource2" AllowSorting="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>
                <br />
                <asp:GridView ID="GridView2" runat="server" Width =100%>
                </asp:GridView>
                &nbsp;&nbsp;<br />
                &nbsp; &nbsp;&nbsp;
                <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
                    DeleteCommand="DELETE FROM [员工基本信息表] WHERE [员工号] = ?" InsertCommand="INSERT INTO [员工基本信息表] ([员工号]) VALUES (?)"
                    SelectCommand="SELECT [员工号] FROM [员工基本信息表]">
                    <DeleteParameters>
                        <asp:Parameter Name="员工号" Type="String" />
                    </DeleteParameters>
                    <InsertParameters>
                        <asp:Parameter Name="员工号" Type="String" />
                    </InsertParameters>
                </asp:AccessDataSource>
                <asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
                    DeleteCommand="DELETE FROM [员工基本信息表] WHERE [员工号] = ?" InsertCommand="INSERT INTO [员工基本信息表] ([员工号], [姓名], [性别], [婚姻状况], [健康状况], [政治面貌], [开始工作时间], [家庭地址], [电话]) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?)"
                    SelectCommand="SELECT [员工号], [姓名], [性别], [婚姻状况], [健康状况], [政治面貌], [开始工作时间], [家庭地址], [电话] FROM [员工基本信息表]"
                    UpdateCommand="UPDATE [员工基本信息表] SET [姓名] = ?, [性别] = ?, [婚姻状况] = ?, [健康状况] = ?, [政治面貌] = ?, [开始工作时间] = ?, [家庭地址] = ?, [电话] = ? WHERE [员工号] = ?">
                    <DeleteParameters>
                        <asp:Parameter Name="员工号" Type="String" />
                    </DeleteParameters>
                    <UpdateParameters>
                        <asp:Parameter Name="姓名" Type="String" />
                        <asp:Parameter Name="性别" Type="String" />
                        <asp:Parameter Name="婚姻状况" Type="String" />
                        <asp:Parameter Name="健康状况" Type="String" />
                        <asp:Parameter Name="政治面貌" Type="String" />
                        <asp:Parameter Name="开始工作时间" Type="String" />
                        <asp:Parameter Name="家庭地址" Type="String" />
                        <asp:Parameter Name="电话" Type="String" />
                        <asp:Parameter Name="员工号" Type="String" />
                    </UpdateParameters>
                    <InsertParameters>
                        <asp:Parameter Name="员工号" Type="String" />
                        <asp:Parameter Name="姓名" Type="String" />
                        <asp:Parameter Name="性别" Type="String" />
                        <asp:Parameter Name="婚姻状况" Type="String" />
                        <asp:Parameter Name="健康状况" Type="String" />
                        <asp:Parameter Name="政治面貌" Type="String" />
                        <asp:Parameter Name="开始工作时间" Type="String" />
                        <asp:Parameter Name="家庭地址" Type="String" />
                        <asp:Parameter Name="电话" Type="String" />
                    </InsertParameters>
                </asp:AccessDataSource>
            </td>
        </tr>
    </table>
  
</asp:Content>