1<%...--文件名:QuerySalaryForm.aspx--%>
 2<%...@ Page Language="C#" MasterPageFile="~/MasterPage.master" AutoEventWireup="true" CodeFile="QuerySalaryForm.aspx.cs" Inherits="QueryManage_QuerySalaryForm" Title="当前位置：查询管理->查询工资信息" %>
 3<asp:Content ID="Content1" ContentPlaceHolderID="ContentPlaceHolder1" Runat="Server">
 4    <table style="width: 556px; height: 161px">
 5        <tr>
 6            <td align="center" style="font-size: 0.8em; width: 2232px; font-family: 宋体; height: 16px;
 7                background-color: teal">
 8                &nbsp;发放年份：<asp:DropDownList ID="DropDownList1" runat="server" Width="90px">
 9                    <asp:ListItem>2006</asp:ListItem>
10                    <asp:ListItem>2007</asp:ListItem>
11                    <asp:ListItem>2008</asp:ListItem>
12                    <asp:ListItem>2009</asp:ListItem>
13                    <asp:ListItem>2010</asp:ListItem>
14                    <asp:ListItem>2011</asp:ListItem>
15                    <asp:ListItem>2012</asp:ListItem>
16                    <asp:ListItem>2013</asp:ListItem>
17                    <asp:ListItem>2014</asp:ListItem>
18                    <asp:ListItem>2015</asp:ListItem>
19                    <asp:ListItem>2016</asp:ListItem>
20                    <asp:ListItem>2017</asp:ListItem>
21                    <asp:ListItem>2018</asp:ListItem>
22                    <asp:ListItem>2019</asp:ListItem>
23                    <asp:ListItem>2020</asp:ListItem>
24                </asp:DropDownList>
25                发放月份：<asp:DropDownList ID="DropDownList2" runat="server" Width="80px">
26                    <asp:ListItem>1</asp:ListItem>
27                    <asp:ListItem>2</asp:ListItem>
28                    <asp:ListItem>3</asp:ListItem>
29                    <asp:ListItem>4</asp:ListItem>
30                    <asp:ListItem>5</asp:ListItem>
31                    <asp:ListItem>6</asp:ListItem>
32                    <asp:ListItem>7</asp:ListItem>
33                    <asp:ListItem>8</asp:ListItem>
34                    <asp:ListItem>9</asp:ListItem>
35                    <asp:ListItem>10</asp:ListItem>
36                    <asp:ListItem>11</asp:ListItem>
37                    <asp:ListItem>12</asp:ListItem>
38                </asp:DropDownList>&nbsp;<asp:Button ID="Button1" runat="server" Text="查询" Width="90px" />
39                <asp:Button ID="Button2" runat="server" Text="打印全部工资信息" Width="129px" OnClick="Button2_Click" />
40                <asp:Button ID="Button3" runat="server" Text="打印银行入账单" Width="129px" OnClick="Button3_Click" />
41                <asp:Button ID="Button4" runat="server" Text="打印养老险入账单" Width="129px" OnClick="Button4_Click" />
42                <asp:Button ID="Button5" runat="server" Text="打印医疗险入账单" Width="129px" OnClick="Button5_Click" />
43                <asp:Button ID="Button6" runat="server" Text="打印住房基金入账单" Width="141px" OnClick="Button6_Click" /></td>
44        </tr>
45        <tr>
46            <td style="width: 2232px; height: 100px; background-color: gainsboro">
47                <asp:Panel ID="Panel1" runat="server" Height="220px" ScrollBars="Auto" Width="553px">
48                    <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:MyPersonnelDBConnectionString %>"
49                        SelectCommand="SELECT [员工编号], [员工姓名], [基本工资], [津贴], [奖金], [工龄工资], [岗位工资], [其他应增项], [应发合计], [所得税], [养老险], [医疗险], [住房基金], [其他应减项], [应减合计], [实发金额], [银行账号], [养老保险账号], [医疗保险账号], [住房基金账号], [身份证号码], [发放年份], [发放月份] FROM [工资发放表] WHERE (([发放年份] = @发放年份) AND ([发放月份] = @发放月份))">
50                        <SelectParameters>
51                            <asp:ControlParameter ControlID="DropDownList1" Name="发放年份" PropertyName="SelectedValue"
52                                Type="Int32" />
53                            <asp:ControlParameter ControlID="DropDownList2" Name="发放月份" PropertyName="SelectedValue"
54                                Type="Int32" />
55                        </SelectParameters>
56                    </asp:SqlDataSource>
57                    <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="False" BackColor="White"
58                        BorderColor="#999999" BorderStyle="None" BorderWidth="1px" CellPadding="3" DataSourceID="SqlDataSource1"
59                        Font-Names="宋体" Font-Size="Small" GridLines="Vertical" Width="1800px">
60                        <FooterStyle BackColor="#CCCCCC" ForeColor="Black" />
61                        <Columns>
62                            <asp:BoundField DataField="员工编号" HeaderText="员工编号" SortExpression="员工编号" />
63                            <asp:BoundField DataField="员工姓名" HeaderText="员工姓名" SortExpression="员工姓名" />
64                            <asp:BoundField DataField="基本工资" HeaderText="基本工资" SortExpression="基本工资" />
65                            <asp:BoundField DataField="津贴" HeaderText="津贴" SortExpression="津贴" />
66                            <asp:BoundField DataField="奖金" HeaderText="奖金" SortExpression="奖金" />
67                            <asp:BoundField DataField="工龄工资" HeaderText="工龄工资" SortExpression="工龄工资" />
68                            <asp:BoundField DataField="岗位工资" HeaderText="岗位工资" SortExpression="岗位工资" />
69                            <asp:BoundField DataField="其他应增项" HeaderText="其他应增项" SortExpression="其他应增项" />
70                            <asp:BoundField DataField="应发合计" HeaderText="应发合计" ReadOnly="True" SortExpression="应发合计" />
71                            <asp:BoundField DataField="所得税" HeaderText="所得税" SortExpression="所得税" />
72                            <asp:BoundField DataField="养老险" HeaderText="养老险" SortExpression="养老险" />
73                            <asp:BoundField DataField="医疗险" HeaderText="医疗险" SortExpression="医疗险" />
74                            <asp:BoundField DataField="住房基金" HeaderText="住房基金" SortExpression="住房基金" />
75                            <asp:BoundField DataField="其他应减项" HeaderText="其他应减项" SortExpression="其他应减项" />
76                            <asp:BoundField DataField="应减合计" HeaderText="应减合计" ReadOnly="True" SortExpression="应减合计" />
77                            <asp:BoundField DataField="实发金额" HeaderText="实发金额" ReadOnly="True" SortExpression="实发金额" />
78                            <asp:BoundField DataField="银行账号" HeaderText="银行账号" SortExpression="银行账号" />
79                            <asp:BoundField DataField="养老保险账号" HeaderText="养老保险账号" SortExpression="养老保险账号" />
80                            <asp:BoundField DataField="医疗保险账号" HeaderText="医疗保险账号" SortExpression="医疗保险账号" />
81                            <asp:BoundField DataField="住房基金账号" HeaderText="住房基金账号" SortExpression="住房基金账号" />
82                            <asp:BoundField DataField="身份证号码" HeaderText="身份证号码" SortExpression="身份证号码" />
83                            <asp:BoundField DataField="发放年份" HeaderText="发放年份" SortExpression="发放年份" />
84                            <asp:BoundField DataField="发放月份" HeaderText="发放月份" SortExpression="发放月份" />
85                        </Columns>
86                        <RowStyle BackColor="#EEEEEE" ForeColor="Black" />
87                        <SelectedRowStyle BackColor="#008A8C" Font-Bold="True" ForeColor="White" />
88                        <PagerStyle BackColor="#999999" ForeColor="Black" HorizontalAlign="Center" />
89                        <HeaderStyle BackColor="#000084" Font-Bold="True" ForeColor="White" HorizontalAlign="Center" />
90                        <AlternatingRowStyle BackColor="Gainsboro" />
91                    </asp:GridView>
92                </asp:Panel>
93            </td>
94        </tr>
95    </table>
96</asp:Content>
97
98