管理工资信息.aspx

人事管理系统

<%@ Page Language="VB" MasterPageFile="~/母版1.master" AutoEventWireup="false" CodeFile="管理工资信息.aspx.vb" Inherits="Default2" title="Untitled Page" %>
<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
    <br />
    <br />
    <br />
    <table width=60%>
        <tr>
            <td colspan="4">
            </td>
        </tr>
        <tr>
            <td >
                请输入要查询的员工号</td>
            <td >
                <asp:DropDownList ID="DropDownList1" runat="server" DataSourceID="AccessDataSource2"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
            </td>
            <td ><asp:Button ID="Button3" runat="server" Text="提交" /></td> 
        </tr>
        <tr>
            <td>
                请输入要修改的员工号
            </td>
            <td>
                <asp:DropDownList ID="DropDownList2" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource3"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
            </td>
            <td colspan="2">
                <asp:Button ID="Button4" runat="server" Text="修改" />
            </td>
        </tr>
        <tr>
            <td>
                请输入要删除的员工号</td>
            <td>
                <asp:DropDownList ID="DropDownList3" runat="server" AutoPostBack="True" DataSourceID="AccessDataSource4"
                    DataTextField="员工号" DataValueField="员工号">
                </asp:DropDownList>
            </td>
            <td colspan="2">
                <asp:Button ID="Button5" runat="server" Text="删除" /></td>
        </tr>
    </table>
    &nbsp; &nbsp;
 
    <table border="1" cellpadding="0" cellspacing="0" width =70%>
     <tr>
      <td colspan =2>
          <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 >
           员工号</td>
        <td  align=left style="width: 363px">
            <asp:TextBox ID="TextBox1" runat="server" ></asp:TextBox>
            <asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="TextBox1"
                    ErrorMessage="不能为空" ValidationGroup="1"></asp:RequiredFieldValidator>
                <asp:Label ID="Label1" runat="server" Text="Label" Visible="False" ></asp:Label></td>
        </tr>
        <tr>
            <td>
                姓名</td>
            <td align=left style="width: 363px">
                <asp:TextBox ID="TextBox2" runat="server" ></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="TextBox2"
                    ErrorMessage="不能为空" ValidationGroup="1" ></asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td>
                底 薪</td>
            <td align=left style="width: 363px">
                <asp:TextBox ID="TextBox3" runat="server" ></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator3" runat="server" ControlToValidate="TextBox3"
                    ErrorMessage="不能为空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td>
                补 贴</td>
            <td align=left style="width: 363px">
                <asp:TextBox ID="TextBox4" runat="server" ></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator4" runat="server" ControlToValidate="TextBox4"
                    ErrorMessage="不能为空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td>
                奖  金</td>
            <td align=left style="width: 363px">
                <asp:TextBox ID="TextBox5" runat="server"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator5" runat="server" ControlToValidate="TextBox5"
                    ErrorMessage="不能为空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td>
                加 班费</td>
            <td align=left style="width: 363px">
                <asp:TextBox ID="TextBox6" runat="server"></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator6" runat="server" ControlToValidate="TextBox6"
                     ErrorMessage="不能为空" ValidationGroup="1"></asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td>
                实发工资</td>
            <td align=left style="width: 363px">
                <asp:TextBox ID="TextBox7" runat="server" ></asp:TextBox>
                <asp:RequiredFieldValidator ID="RequiredFieldValidator7" runat="server" ControlToValidate="TextBox7"
                   ErrorMessage="不能为空" ValidationGroup="1" ></asp:RequiredFieldValidator></td>
        </tr>
        <tr>
            <td>
            </td>
            <td style="width: 363px">
                <asp:Button ID="Button1" runat="server" Text="插入" ValidationGroup="1" />
                &nbsp; &nbsp; &nbsp;&nbsp;
                <asp:Button ID="Button2" runat="server" Text="取消" />
                <asp:Label ID="Label2" runat="server" Text="Label" Width="144px" Visible="False"></asp:Label></td>
        </tr>
    </table>
    <asp:GridView ID="GridView2" runat="server" Width="463px" >
    </asp:GridView>
    <br />
    
    
    <asp:GridView ID="GridView1" 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="实发工资" />
        </Columns>
    </asp:GridView>
    <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="AccessDataSource3" 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 />
</asp:Content>