📄 payqurey.asp
字号:
<%
dim a,b
a=session("id")
b=session("password")
if a=""and b="" then
session("login")="1"
response.redirect"index.asp"
else
set conn=server.createobject("adodb.connection")
conn.open "driver={microsoft access driver (*.mdb)};dbq="&server.mappath("db/gzglxt.mdb")
exec="select 姓名,时间,基本工资,工时工资,奖金,加班工资,福利津贴,其他金额,出差补贴,扣发总额,基本工资+工时工资+奖金+加班工资+福利津贴+其他金额+出差补贴-扣发总额 as 应发总额 from 月度扣发查询 where 员工编号='"&a&"' "
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,0,1
end if
%>
<TITLE>工资查询</TITLE>
<META http-equiv=Content-Type content="text/html; charset=gb2312">
<META content="MSHTML 6.00.2600.0" Name=GENERATOR>
<link href="home.css" rel="stylesheet" type="text/css">
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_reloadPage(init) { //reloads the window if Nav4 resized
if (init==true) with (navigator) {if ((appName=="Netscape")&&(parseInt(appVersion)==4)) {
document.MM_pgW=innerWidth; document.MM_pgH=innerHeight; onresize=MM_reloadPage; }}
else if (innerWidth!=document.MM_pgW || innerHeight!=document.MM_pgH) location.reload();
}
MM_reloadPage(true);
//-->
</script>
</HEAD>
<BODY text=#000000 bgColor=#ffffff leftMargin=0 topMargin=0>
<!--#include file="indextop.asp"-->
<TABLE width=760 border=0 align="center" cellPadding=0 cellSpacing=0>
<TR>
<TD>您现在的位置：<a href="Index.asp"> 工资管理系统 </a>>>> <a href="#">工资管理</a></TD>
<TD width="150" align="right" valign="middle"> <script language=JavaScript src="images/date.js"></script>
</TD>
<TD width="26"><IMG height=16 src="images/wan.gif" width=26></TD>
<TD width="170" bgColor=#e2e2e1></TD>
</TR>
</TABLE>
<table width="760" height="290" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<TD width=7 rowspan="3" background="images/dotLine_h.gif"><IMG src="images/shim(1).gif" width=1></TD>
<td width="79" rowspan="3" valign="top" bgcolor="#EFEFEF"><img src="images/payqurey.gif" width="100" height="530"></td>
<td width="650" valign="top">
<TD width=34 rowspan="3" background="images/dotLine_h.gif"><IMG src="images/shim(1).gif" width=8 height="9"></TD>
</tr>
<tr>
<td valign="top">
</tr>
<tr>
<td valign="top"><table width="660" height="414" border="1" cellpadding="0"cellspacing="0" bordercolor='#006699'>
<tr>
<td height="40" colspan="11"><div align="center">
<p>以下是您在本公司的工资情况:</p>
</div></td>
</tr>
<tr>
<td width="55" height="50"><div align="center">员工姓名</div></td>
<td width="55" height="50"><div align="center">时间</div></td>
<td width="55" height="50"><div align="center">基本工资</div></td>
<td width="55" height="50"><div align="center">工时工资</div></td>
<td width="55" height="50"><div align="center">奖金</div></td>
<td width="55" height="50"><div align="center">加班工资</div></td>
<td width="55" height="50"><div align="center">福利津贴</div></td>
<td width="55" height="50"><div align="center">出差补助</div></td>
<td width="55" height="50"><div align="center">其他总额</div></td>
<td width="55" height="50"><div align="center">扣罚总额</div></td>
<td width="55" height="50"><div align="center">应发总额</div></td>
</tr>
<%do while not rs.eof%>
<tr>
<td width="55" height="50"><div align="center"><%=rs("姓名")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("时间")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("基本工资")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("工时工资")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("奖金")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("加班工资")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("福利津贴")%></div></td>
<td width="55" height="50" ><div align="center"><%=rs("其他金额")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("出差补贴")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("扣发总额")%></div></td>
<td width="55" height="50"><div align="center"><%=rs("应发总额")%></td>
</tr>
<%
rs.movenext
loop
%>
<tr align="center" valign="middle">
<td height="41" colspan="11"><div align="left"></div>
<div align="center"></div>
<div align="left">
<%
a=request.form("1")
b=request.form("2")
c=request.form("3")
d=request.form("4")
e=request.form("5")
f=request.form("6")
g=request.form("7")
h=request.form("8")
i=cint(a)+cint(b)+cint(c)+cint(d)+cint(e)+cint(f)+cint(g)-cint(h)
%>
<table width="645" height="235" border="0" align="center" cellpadding="0" cellspacing="0"bordercolor='#006699'>
<tr>
<td width="240" valign="top"><p> </p>
<p> <marquee><b>欢迎光临！</b></marquee></p>
<p> <font size="4">本页提供员工工资的主要工资模块查询，分为基本工资、工时工资、奖金、加班工资、福利津贴、出差补贴、扣罚总额、其他总额以及应发总额等模块,工资计算为您提供应发金额的核算！</font></p>
<p> </p>
</td>
<td width="370" align="center" valign="middle"><form name="form2" method="post" action="jsq.asp ">
<table width="280" height="172" border="1" align="center" cellpadding="0" cellspacing="0" bordercolor='#006699'>
<tr>
<td colspan="2"><div align="center">工资计算</div></td>
</tr>
<tr>
<td width="100" height="15"> <div align="center">工资项目</div></td>
<td width="160"><div align="center">金额 </div></td>
</tr>
<tr>
<td><div align="center">基本工资</div></td>
<td><input name="基本工资" type="text" id="13" size="20"></td>
</tr>
<tr>
<td><div align="center">工时工资</div></td>
<td><input name="工时工资" type="text" id="24" size="20"></td>
</tr>
<tr>
<td><div align="center">奖金</div></td>
<td><input name="奖金" type="text" id="33" size="20"></td>
</tr>
<tr>
<td><div align="center">加班工资</div></td>
<td><input name="加班工资" type="text" id="43" size="20"></td>
</tr>
<tr>
<td><div align="center">福利津贴</div></td>
<td> <input name="福利津贴" type="text" id="53" size="20"></td>
</tr>
<tr>
<td><div align="center">出差补助</div></td>
<td><input name="出差补助" type="text" id="63" size="20"></td>
</tr>
<tr>
<td><div align="center">其他总额</div></td>
<td><input name="其他总额" type="text" id="73" size="20"></td>
</tr>
<tr>
<td><div align="center">扣罚总额</div></td>
<td><input name="扣罚总额" type="text" id="83" size="20"></td>
</tr>
<tr>
<td> </td>
<td><input type="submit" name="Submit" value="提交"></td>
</tr>
</table>
</form>
</td>
</tr>
</table>
<form name="form1" method="post" action="">
<div align="center"></div>
<div align="center"></div>
</form>
</div></td>
</tr>
</table> </tr>
<tr>
<TD height="2" colspan="5" background="images/dotLine_w.gif"><IMG height=1 src="images/shim(1).gif" width=100></TD>
</tr>
</table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td>
<Iframe src="CopyRight.asp" width="760" height="200" marginheight="0" marginwidth="0" scrolling="NO" frameborder="0" name="CopyRight"></iframe>
</td>
</tr>
</table></BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -