📄 wagegesearch.asp
字号:
<!--#include file=DataBase/conn.asp-->
<!--#include file=yan.asp-->
<!--#include file=purview.asp-->
<%
call gerenxinchou
set rsr=server.CreateObject("adodb.recordset")
sqlr="SELECT dbo.tb_Employee.name,dbo.tb_Employee.id FROM dbo.tb_User INNER JOIN dbo.tb_Employee ON dbo.tb_User.name = dbo.tb_Employee.id WHERE (dbo.tb_User.username = '"&session("admin_name")&"')"
rsr.open sqlr,conn,1,1
nameid=rsr("id")
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<title>无标题文档</title>
<link href="CSS/css.css" rel="stylesheet" type="text/css">
<style type="text/css">
<!--
body,td,th {
font-size: 12px;
}
.style2 {color: #0000FF}
.style3 {color: #FF0000}
-->
</style></head>
<body topmargin="0">
<form name="form1" method="post" action="">
<table width="550" border="0" align="center">
<tr>
<td width="55%" height="30"> - <span class="style3">个人管理</span>→<span class="style2">信息检索</span>→<font color="#FF0000">个人薪酬信息</font></td>
</tr>
</table>
<table width="550" border="0" align="center" cellspacing="1" bgcolor="#000000">
<tr>
<td bgcolor="#FFFFFF"><table width="438" height="67" border="0" align="center" cellspacing="0">
<tr>
<td width="180" height="36" align="right">日 期：</td>
<td width="254">
<select name="year" id="year">
<%for i=2005 to 2050%>
<option value="<%=i%>" <%if i=clng(request("year")) then%>selected<%end if%>><%=i%></option>
<%next%>
</select>
年
<select name="month" id="month">
<%for i=1 to 12%>
<option value="<%=i%>" <%if i=clng(request("month")) then%>selected<%end if%>><%=i%></option>
<%next%>
</select>
月
<input name="post" type="hidden" id="post" value="true"></td>
</tr>
<tr>
<td height="23" colspan="2" align="center"><input name="Submit" type="submit" class="botton" value=" 查 找 ">
</td>
</tr>
</table></td>
</tr>
</table>
</form>
<%
if request("post")<>"" then
set rsx=server.CreateObject("adodb.recordset")
sqlx="select * from tb_Wage where year="&request("year")&" and month="&request("month")&" and name="&nameid
rsx.open sqlx,conn,1,1
if not rsx.eof then
%>
<form name="form2" method="post" action="">
<table width="550" border="0" align="center" cellspacing="1" bgcolor="#000000">
<tr>
<td bgcolor="#FFFFFF"><table width="550" border="0" align="center" cellspacing="0">
<tr>
<td height="28" background="images/index_24.gif"> </td>
</tr>
</table>
<table width="550" height="374" border="0" align="center" cellspacing="0" >
<tr>
<td width="277" align="center">工作日数：</td>
<td width="269"> <%=rsx("gongzuo")%> 天 </td>
</tr>
<tr>
<td align="center">日 薪：</td>
<td> <%=rsx("rixin")%> 元</td>
</tr>
<tr>
<td align="center">本 薪：</td>
<td> <%=rsx("benxin")%> 元</td>
</tr>
<tr>
<td align="center">奖 金：</td>
<td> <%=rsx("jiangjin")%> 元</td>
</tr>
<tr>
<td align="center">假日津贴：</td>
<td> <%=rsx("jiari")%> 元</td>
</tr>
<tr>
<td align="center">全勤奖金：</td>
<td> <%=rsx("quanqin")%> 元</td>
</tr>
<tr>
<td align="center">加班津贴：</td>
<td> <%=rsx("jiaban")%> 元</td>
</tr>
<tr>
<td align="center">本期工资：</td>
<td> <%=rsx("benqi")%> 元</td>
</tr>
<tr>
<td align="center">福 利 金：</td>
<td> <%=rsx("fuli")%> 元</td>
</tr>
<tr>
<td align="center">伙 食 费：</td>
<td> <%=rsx("huoshi")%> 元</td>
</tr>
<tr>
<td align="center">所 得 税：</td>
<td> <%=rsx("suode")%> 元</td>
</tr>
<tr>
<td align="center">借 支：</td>
<td> <%=rsx("jiezhi")%> 元</td>
</tr>
<tr>
<td align="center">实发工资：</td>
<td> <%=rsx("shifa")%> 元</td>
</tr>
<tr align="center">
<td colspan="2"> </td>
</tr>
</table></td>
</tr>
</table>
</form>
<%
else
response.Write("<div align=center>没有相关信息</div>")
end if
end if
%>
</body>
</html>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -