📄 m_wagelist.asp
字号:
<!-- #include File=../../showsort/showsort(man).asp -->
<%if sort<2 then%>
<script language="JavaScript">
alert("对不起，您没有权限！！");
window.history.back();
</script>
<%end if%>
<%
if request("yyyy")<>"" then
yyyy=request("yyyy")
else
yyyy=year(date)
end if
userid=request("userid")
'-----------获取用户姓名
set rs=server.createobject("adodb.recordset")
rs.open "select name from manage_user where id="&userid,source,3,3
name=rs("name")
rs.close
'-----------查看员工工资信息
set rs=server.createobject("adodb.recordset")
sql="select * from m_wage where datepart(yyyy,dotime)="&yyyy&" and userid="&userid&" order by dotime"
rs.open sql,source,3,3
%>
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="GENERATOR" content="Microsoft FrontPage 4.0">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>PMIS</title>
<LINK href="../../<%=session("color")%>.css" rel=stylesheet type=text/css>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<center>
<!-- #include File=../../include/title2.asp -->
</center>
</div>
<div align="center">
<center>
<table width="100%" cellspacing cellpadding>
<tr>
<td width="20%" class="Titletd1" height="365" valign="top">
<table width="158" cellspacing cellpadding class="L2">
<tr>
<td height="10" colspan="3" class="bgcolor4"></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font><font color="#FFFFFF">部门管理</font></td>
</tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../dept/d_list.asp"><font color="#FFFFFF">>
部门一览</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../dept/d_input.asp"><font color="#FFFFFF">> 新增部门</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../dept/d_del.asp"><font color="#FFFFFF">> 删除部门</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../dept/d_list4.asp"><font color="#FFFFFF">> 部门人员</font></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font><font color="#FFFFFF">员工管理</font></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_modify.asp"><font color="#FFFFFF">> 员工一览</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_addnewuser.asp"><font color="#FFFFFF">>
新增员工</font></a></td>
</tr> <tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_del.asp"><font color="#FFFFFF">> 删除员工</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_leave.asp"><font color="#FFFFFF">> 离职员工</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../man/m_wagemonth.asp"><font color="#FFFFFF">>
工资报表</font></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::日常人事管理</font></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="d_list-tj.asp"><font color="#FFFFFF">> 添加申请</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="d_list-sp.asp"><font color="#FFFFFF">> 人事审批</font></a></td>
</tr>
<tr class="bgcolor2"> <td></td> <td></td> <td><a href="d_list-pz.asp"><font color="#FFFFFF">> 人事配置</font></a></td> </tr> <tr class="bgcolor2"> <td></td> <td></td> <td><a href="d_list-lcsz.asp"><font color="#FFFFFF">> 人事流程设置</font></a></td> </tr>
<tr class="bgcolor4">
<td colspan="3" height="200"></td>
</tr>
</table>
</td>
<td width="1%" bgcolor="#FFFFFF"></td>
<td width="79%" bgcolor="#FFFFFF" valign="top">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%" height="10"></td>
</tr>
<tr>
<td width="100%">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%" height="25" style="background-image: url('../../images/<%=session("color")%>/hrm.gif'); background-repeat: no-repeat">
<font color="#000080"> 员工管理</font>
工资信息</td>
</tr>
<tr>
<td width="100%" height="10"></td>
</tr>
<tr>
<td width="100%" height="10">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td valign="top" class="L2"> <span class="L2">员工管理>>>员工<font color="#CC0000"><%=name%></font>
<select name="yy" onChange="window.location='m_wagelist.asp?userid=<%=userid%>&yyyy='+this.value">
<%for i=year(date)-20 to year(date)+1%>
<option value="<%=i%>"<%if i=cint(yyyy) then%> selected<%end if%>><%=i%></option>
<%next%>
</select>
年工资信息表 <a href="m_wageadd.asp?userid=<%=userid%>"><font color="#0000FF">新增</font></a>
<a href="m_wagelist.asp?userid=<%=userid%>"><font color="#0000FF">查询</font></a>
</span> <%
if not rs.eof then
%>
<table width="100%" border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" class="L2">
<tr>
<td>月份</td>
<td>基本薪资</td>
<td>提成工资</td>
<td colspan="4">其它应得款</td>
<td colspan="4">应扣款项</td>
<td>实发薪资</td>
</tr>
<tr>
<td> </td>
<td> </td>
<td> </td>
<td>住房补贴</td>
<td>餐费补贴</td>
<td>出差补贴</td>
<td>其它</td>
<td>考勤扣款</td>
<td>所得税</td>
<td>保险扣款</td>
<td>其它</td>
<td> </td>
</tr>
<%
while not rs.eof
truemoney=rs("wage")+rs("pay")+rs("house")+rs("lunch")+rs("outpay")+rs("bonus")-rs("card")-rs("ratal")-rs("safe")-rs("other")
%>
<tr bgcolor="#FFFFFF">
<td><span class="L2"><a href="m_wage.asp?id=<%=rs("id")%>&userid=<%=userid%>"><b><font color="#0000FF"><%=month(rs("dotime"))%></font></b></a></span></td>
<td><%=rs("wage")%></td>
<td><%=rs("pay")%></td>
<td><%=rs("house")%></td>
<td><%=rs("lunch")%></td>
<td><%=rs("outpay")%></td>
<td><%=rs("bonus")%></td>
<td><%=rs("card")%></td>
<td><%=rs("ratal")%></td>
<td><%=rs("safe")%></td>
<td><%=rs("other")%></td>
<td><%=truemoney%></td>
</tr>
<%
rs.movenext
wend
%>
</table>
<%
rs.close
else
%> 暂无该员工工资信息，您要<a href="m_wageadd.asp?userid=<%=userid%>">添加</a>吗？ <%
end if
%> </td>
</tr>
<tr>
<td class="L2"><a href="m_look.asp?id=<%=userid%>"><font color="#0000FF"><br>
<br>
基本信息</font></a> <a href="m_compact.asp?id=<%=userid%>"><font color="#0000FF">合同信息</font></a> <a href="m_wagelist.asp?userid=<%=userid%>"><font color="#0000FF">工资信息</font></a>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</center>
</div>
<div align="center">
<!-- #include File=../../include/last2.asp -->
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -