📄 summary.aspx
字号:
<%@ Page Language="C#" AutoEventWireup="true" CodeFile="Summary.aspx.cs" Inherits="web_Salary_Summary" %>
<%@ Register Src="left.ascx" TagName="left" TagPrefix="uc2" %>
<%@ Register Src="../Common/header.ascx" TagName="header" TagPrefix="uc1" %>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>无标题页</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<font face="宋体">
<table id="Table1" border="0" cellpadding="0" cellspacing="0" height="100%" style="z-index: 101;
left: 8px; position: absolute; top: 8px" width="100%">
<tr height="100" valign="top">
<td colspan="2">
<uc1:header id="Header1" runat="server">
</uc1:header></td>
</tr>
<tr valign="top">
<td align="left" width="130" bgcolor="#b0bccf">
<uc2:left ID="Left1" runat="server" />
</td>
<td align="center" valign="top">
<asp:Panel ID="pnlPageFix" runat="server" Height="10px" Width="700px">
</asp:Panel>
<asp:Panel ID="pnlBody" runat="server" Height="10px" HorizontalAlign="Left" Width="700px">
<asp:Panel ID="pnlOption" runat="server" Height="36px">
<p>
<asp:Label ID="Label1" runat="server">开始时间：</asp:Label>
<asp:TextBox ID="txtStartTime" runat="server" Width="80px"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator1" runat="server" ControlToValidate="txtStartTime"
Display="Dynamic" ErrorMessage="请输入正确的日期格式：(YYYY/MM/DD)" Font-Size="Small"
Operator="DataTypeCheck" Type="Date"></asp:CompareValidator>
<asp:RequiredFieldValidator ID="RequiredFieldValidator1" runat="server" ControlToValidate="txtStartTime"
Display="Dynamic" ErrorMessage="该项不能为空！" Font-Size="Small"></asp:RequiredFieldValidator>
<asp:Label ID="Label2" runat="server">结束时间：</asp:Label>
<asp:TextBox ID="txtEndTime" runat="server" Width="80px"></asp:TextBox>
<asp:CompareValidator ID="CompareValidator2" runat="server" ControlToValidate="txtEndTime"
Display="Dynamic" ErrorMessage="请输入正确的日期格式：(YYYY/MM/DD)" Font-Size="Small"
Operator="DataTypeCheck" Type="Date"></asp:CompareValidator>
<asp:RequiredFieldValidator ID="RequiredFieldValidator2" runat="server" ControlToValidate="txtEndTime"
Display="Dynamic" ErrorMessage="该项不能为空！" Font-Size="Small"></asp:RequiredFieldValidator></p>
<asp:CheckBox ID="chkSort" runat="server" AutoPostBack="True" OnCheckedChanged="chkSort_CheckedChanged"
Text="按工资排序" />
<asp:RadioButtonList ID="rdoAscendList" runat="server" Enabled="False" RepeatDirection="Horizontal"
Width="128px" Visible="False">
<asp:ListItem Selected="True" Value="1">降序</asp:ListItem>
<asp:ListItem Value="2">升序</asp:ListItem>
</asp:RadioButtonList>
</asp:Panel>
<asp:Panel ID="pnlChooseDept" runat="server" BorderWidth="0px" Height="32px">
<asp:Label ID="lblDept" runat="server" Width="151px">选择要查看的部门：</asp:Label>
<asp:DropDownList ID="cmbDeptList" runat="server" OnSelectedIndexChanged="cmbDeptList_SelectedIndexChanged" Width="91px">
</asp:DropDownList>
<asp:Label ID="lblDeptID" runat="server" Visible="False"></asp:Label>
</asp:Panel>
<p>
</p>
<asp:Button ID="btnSearch" runat="server" OnClick="btnSearch_Click" Text="显示结果" Width="128px" />
<p align="left">
<asp:Label ID="lblMessage" runat="server"></asp:Label>
<asp:DataGrid ID="grdResult" runat="server" AutoGenerateColumns="False" BackColor="White"
BorderColor="#CCCCCC" BorderStyle="None" BorderWidth="1px" CellPadding="3" Font-Size="Small"
Width="500px" DataSourceID="SqlDataSource1">
<SelectedItemStyle BackColor="LemonChiffon" Font-Bold="True" />
<ItemStyle ForeColor="#000066" Wrap="False" />
<HeaderStyle BackColor="#006699" Font-Bold="True" ForeColor="White" />
<FooterStyle BackColor="White" ForeColor="#000066" />
<Columns>
<asp:BoundColumn DataField="员工编号" HeaderText="ID" Visible="False"></asp:BoundColumn>
<asp:BoundColumn DataField="员工姓名" HeaderText="员工姓名">
<ItemStyle Wrap="False" />
</asp:BoundColumn>
<asp:BoundColumn DataField="员工基本薪资" HeaderText="基本工资">
<ItemStyle Wrap="False" />
</asp:BoundColumn>
<asp:BoundColumn DataField="加班薪资" HeaderText="加班工资">
<ItemStyle Wrap="False" />
</asp:BoundColumn>
<asp:BoundColumn DataField="缺勤扣除" HeaderText="考勤扣除"></asp:BoundColumn>
<asp:BoundColumn DataField="其他薪资" HeaderText="其他增减"></asp:BoundColumn>
<asp:ButtonColumn CommandName="Detail" Text="详细情况..." Visible="False"></asp:ButtonColumn>
</Columns>
<PagerStyle BackColor="White" ForeColor="#000066" HorizontalAlign="Left" Mode="NumericPages" />
</asp:DataGrid><asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:BlueHillManagementConnectionString2 %>"
SelectCommand="SELECT [员工编号], [薪资发放时间], [加班薪资], [缺勤扣除], [其他薪资], [员工姓名], [员工基本薪资], [薪资编号] FROM [查看员工薪资历史信息] WHERE (([薪资发放时间] <= @薪资发放时间) AND ([薪资发放时间] >= @薪资发放时间2) AND ([员工所属部门编号] = @员工所属部门编号))">
<SelectParameters>
<asp:ControlParameter ControlID="txtEndTime" Name="薪资发放时间" PropertyName="Text" Type="DateTime" />
<asp:ControlParameter ControlID="txtStartTime" Name="薪资发放时间2" PropertyName="Text"
Type="DateTime" />
<asp:ControlParameter ControlID="cmbDeptList" Name="员工所属部门编号" PropertyName="SelectedValue"
Type="Int32" />
</SelectParameters>
</asp:SqlDataSource>
</p>
</asp:Panel>
</td>
</tr>
</table>
</font>
</div>
</form>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -