📄 m_wage.asp
字号:
<!-- #include File=../../showsort/showsort(man).asp -->
<%if sort<2 then%>
<script language="JavaScript">
alert("对不起，您没有权限！！");
window.history.back();
</script>
<%end if%>
<%
id=request("id")
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 id="&id&""
rs.open sql,source,3,3
truemoney=rs("wage")+rs("pay")+rs("house")+rs("lunch")+rs("outpay")+rs("bonus")-rs("card")-rs("ratal")-rs("safe")-rs("other")
%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>员工管理</title>
<LINK href="../../ls.css" rel=stylesheet type=text/css>
</head>
<body class="L2" topmargin="0">
<div align="center">
<table width="100%" cellspacing cellpadding>
<center>
<tr>
<td width="100%"><img border="0" src="../../images/banner.gif" width="100%" height="79"></td>
</tr>
</center><tr><td width="100%">
<table width="100%" cellspacing cellpadding>
<center>
<tr>
<td width="100%" bgcolor="#FFC600">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%">
<table width="100%" cellspacing cellpadding class="L2">
<tr>
<td width="11%" align="center"> <a href="../../homepage.asp">首
页</a></td>
<td width="11%" align="center"><a href="../../imail/message.asp">个人办公</a></td>
<td width="11%" align="center"><a href="../../workflow/w_waitlist.asp">公文管理</a></td>
<td width="11%" align="center"><a href="../book/b_index.asp">企业资源</a></td>
<td width="11%" align="center" bgcolor="#FFE384"><a href="../dept/d_list.asp">员工管理</a></td>
<td width="11%" align="center"><a href="../../domanage/d_wait.asp">经理事务</a></td>
<td width="11%" align="center"><a href="../../community/forum.asp">企业社区</a></td>
<td width="11%" align="center"><a href="../../manage/user.asp">系统维护</a></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</center><tr><td width="100%">
<table width="100%" cellspacing cellpadding>
<tr>
<center>
<td width="160" bgcolor="#FFC600" valign="top" height="400">
<table width="100%" cellspacing cellpadding class="L2">
<tr>
<td width="100%" height="10" colspan="3"></td>
</tr>
<tr>
<td width="100%" height="10" colspan="3"> </td>
</tr>
<tr>
<td width="100%" height="10" colspan="3"></td>
</tr>
<tr>
<td width="22%" align="center"></td>
<td width="78%" align="left" colspan="2"><a href="#">::::
员工管理</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../dept/d_list.asp">>
部门一览</a></td>
</tr>
<% if sort>1 then %>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../dept/d_input.asp">>
新增部门</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../dept/d_del.asp">>
删除部门 </a><b><a href="gwgl.htm"> </a></b></td>
</tr>
<% end if %>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../man/m_modify.asp">>
员工一览</a></td>
</tr>
<% if sort>1 then %>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../man/m_addnewuser.asp">>
新增员工</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../man/m_del.asp">>
删除员工</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../man/m_leave.asp">>
离职员工</a></td>
</tr>
<%
end if
if sort>2 then %>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../man/m_wagemonth.asp">>
工资报表</a></td>
</tr>
<% end if %>
</table>
</td>
<td width="5"></td>
</center>
<td width="550" class="L2" valign="top" align="center">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr>
<td height="30"> <img src="images/r_m_tb_1.gif" width="503" usemap="#MapMapMap" border="0"><map name="MapMapMap"><area shape="rect" coords="208,17,272,32" href="m_addnewuser.asp"><area shape="rect" coords="274,16,386,32" href="../man/m_modify.asp"><area shape="rect" coords="389,16,500,31" href="m_del.asp"></map>
</td>
</tr><tr>
<td align="center" valign="top">
<table width="100%" border="1" cellspacing="0" cellpadding="0" class="L2" bordercolorlight="#FFFFFF" bordercolordark="#CCCCCC">
<tr>
<td colspan="4">员工管理>>>员工<font color="#CC0000"><%=name%></font><%=year(rs("dotime"))%>年<%=month(rs("dotime"))%>月工资信息表
<a href="m_wageadd.asp?userid=<%=userid%>"><font color="#0000FF">新增</font></a>
<% if datediff("d",date,rs("givetime"))>0 then%><a href="m_wagemodi.asp?id=<%=id%>&userid=<%=userid%>"><font color="#0000FF">编辑</font></a>
<% end if %> <a href="m_wagelist.asp?userid=<%=userid%>"><font color="#0000FF">查询</font></a> <a href="m_wagemonth.asp?mmmm=<%=rs("dotime")%>"><font color="#0000FF">当月工资报表</font></a>
</td>
</tr>
<tr>
<td width="60">基本工资</td>
<td width="150"><%=rs("wage")%> </td>
<td width="60">提成工资</td>
<td width="150"><%=rs("pay")%> </td>
</tr>
<tr align="center">
<td colspan="4"><b>其它应得款</b></td>
</tr>
<tr>
<td width="60">住房补贴</td>
<td width="150"><%=rs("house")%> </td>
<td width="60">餐费补贴</td>
<td width="150"><%=rs("lunch")%> </td>
</tr>
<tr>
<td width="60">出差补贴</td>
<td width="150"><%=rs("outpay")%> </td>
<td width="60">其它</td>
<td width="150"><%=rs("bonus")%> </td>
</tr>
<tr align="center">
<td colspan="4"><b>应扣款项</b></td>
</tr>
<tr>
<td width="60">考勤扣款</td>
<td width="150"><%=rs("card")%> </td>
<td width="60">所得税扣款</td>
<td width="150"><%=rs("ratal")%> </td>
</tr>
<tr>
<td width="60">保险扣款</td>
<td width="150"><%=rs("safe")%> </td>
<td width="60">其它</td>
<td width="150"><%=rs("other")%> </td>
</tr>
<tr>
<td width="60">实发薪资</td>
<td colspan="3"><%=truemoney%> </td>
</tr>
<tr>
<td width="60">备注</td>
<td colspan="3"><%=rs("brief")%> </td>
</tr>
<tr>
<td width="60">发放时间</td>
<td colspan="3"><%=rs("givetime")%> </td>
</tr>
<tr>
<td colspan="4" valign="top" align="center"> <a href="m_look.asp?id=<%=userid%>"><font color="#0000FF">基本信息</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>
<tr>
<td width="100%"></td>
</tr>
</table>
<p>
</td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -