员工工资信息.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 =70%>
        <tr>
            <td style="height: 11px"  width =30%>
                请选择你要查询的员工号</td>
            <td style="height: 11px"  width =10%>
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource2" DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
            </td>
            <td style="height: 11px; width: 10%; text-align: center;" valign="bottom" >
                &nbsp;&nbsp;
                <asp:Button ID="Button1" runat="server" Text="提交 " />                &nbsp;&nbsp;
                </td>   
        </tr>
    </table>
    <br />
    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" DataKeyNames="员工号"
        DataSourceID="AccessDataSource1" Width =70% 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="实发工资" />
        </Columns>
    </asp:GridView>
    &nbsp;
    <asp:GridView ID="GridView2" runat="server" Width =70%  />
    <asp:AccessDataSource ID="AccessDataSource1" runat="server" DataFile="~/App_Data/db1.mdb"
        SelectCommand="SELECT DISTINCT [员工号], [姓名], [底薪], [补贴], [奖金], [加班费], [实发工资] FROM [员工工资信息表]">
    </asp:AccessDataSource>
    <br />
   

<asp:AccessDataSource ID="AccessDataSource2" runat="server" DataFile="~/App_Data/db1.mdb"
                    SelectCommand="SELECT [员工号], [姓名], [底薪], [补贴], [奖金], [加班费], [实发工资] FROM [员工工资信息表]">
                </asp:AccessDataSource>
   

</asp:Content>