📄 m_wagemonth.asp
字号:
<!-- #include File=../../showsort/showsort(man).asp -->
<%if sort<2 then%>
<script language="JavaScript">
alert("对不起，您没有权限！！");
window.history.back();
</script>
<%end if%>
<%
if request("mmmm")<>"" then
yyyy=year(request("mmmm"))
mmmm=month(request("mmmm"))
else
if request("yy")<>"" then
yyyy=request("yy")
mmmm=request("mm")
else
yyyy=year(date)
mmmm=month(date)
end if
end if
userid=request("userid")
'-----------查看员工工资信息
set rs=server.createobject("adodb.recordset")
sql="select * from m_wage where datepart(mm,dotime)="&mmmm&" 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">
<form method="post" action="m_wagemonth.asp" name="form1">
<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">
<%for i=year(date)-20 to year(date)+1%>
<option value="<%=i%>"<%if i=cint(yyyy) then%> selected<%end if%>><%=i%></option>
<%next%>
</select>
年
<select name="mm" onchange="form1.submit()">
<%for i=1 to 12%>
<option value="<%=i%>"<%if i=cint(mmmm) then%> selected<%end if%>><%=i%></option>
<%next%>
</select>
月 工资表 </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 height="18"> </td>
<td height="18"> </td>
<td height="18"> </td>
<td height="18">住房补贴</td>
<td height="18">餐费补贴</td>
<td height="18">出差补贴</td>
<td height="18">其它</td>
<td height="18">考勤扣款</td>
<td height="18">所得税</td>
<td height="18">保险扣款</td>
<td height="18">其它</td>
<td height="18"> </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")
set rss=server.createobject("adodb.recordset")
rss.open "select name from manage_user where id="&rs("userid"),source,3,3
name=rss("name")
rss.close
%>
<tr bgcolor="#FFFFFF">
<td><span class="L2"><a href="m_wagelist.asp?userid=<%=rs("userid")%>"><b><font color="#0000FF"><%=name%></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
%>
暂无该月员工工资信息!
<%
end if
%>
</td>
</tr>
</table>
</form>
</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 + -