?? ser2.asp
字號:
<!--#include file="conn.asp"-->
<!--#include file="qx.asp"-->
<%
name=request.form("name")
ym=request.form("ym")
exec="select * from sa where name='"+name+"' and ym="+ym
set rs=server.createobject("adodb.recordset")
rs.open exec,conn,1,1
%>
<html>
<head>
<link href="style.css" rel="stylesheet" type="text/css">
<%
if rs.eof then
response.write("<script language=JavaScript>{window.alert('數據庫沒有您在這個月的數據,查詢頁面即將關閉，請查證后再撥：）^_^!');window.close();}</script>")
else
do while not rs.eof
%>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
-->
</style>
</head>
<body background="image/bg.gif">
<p align="center"><font size="2">中國水電基礎局有限公司一公司工資查詢系統
V1.1</font></p>
<div align="left">
<table border="0" width="307" height="37">
<tr>
<td width="297" height="7" align="right" colspan="2">
<p align="left"><font size="2">基本信息</font></p>
</td>
</tr>
<tr>
<td width="97" height="7" align="right"><font size="2">姓名：</font></td>
<td width="193" height="7" align="right">
<p align="left" class=main font ><%=rs("name")%></td>
</tr>
<tr>
<td width="97" height="11" align="right"><font size="2">身份證號碼：</font></td>
<td width="194" height="11" align="right">
<p align="left" class=main><%=rs("ic")%></td>
</tr>
<tr>
<td width="97" height="3" align="right"><font size="2">查詢月份：</font></td>
<td width="194" height="3" align="right">
<p align="left" class=main color=red><%=rs("ym")%></td>
</tr>
</table>
</div>
<font size="2"> </font>
<div align="left">
<table border="0" width="311" height="18">
<tr>
<td width="133" height="18"><font size="2">工資信息：</font></td>
<td width="162" height="18"><center><input name="button" type="button" style="font-family: 新細明體, 宋體, Arial; font-size: 9pt; height: 20px; background-color: #D4D0C8; color: #FF0000" onClick="window.location='xg.asp?id=<%=rs("id")%>'" onMouseOver="this.style.backgroundColor='#FFC864'" onMouseOut="this.style.backgroundColor='#D4D0C8'" value="修改">
<input type="button" value="刪除" onClick="if (confirm('確實要刪除（<%=rs("Name")%>）在（<%=rs("ym")%> ）的工資記錄嗎？不可恢復！')) window.location='ndel.asp?id=<%=rs("id")%>'" style="font-family: 新細明體, 宋體, Arial; font-size: 9pt; height: 20px; background-color: #D4D0C8; color: #FF0000" onMouseOver="this.style.backgroundColor='#FFC864'" onMouseOut="this.style.backgroundColor='#D4D0C8'">
<script language="JavaScript">
<!--
function CloseWin()
{
var ua=navigator.userAgent
var ie=navigator.appName=="Microsoft Internet Explorer"?true:false
if(ie){
var IEversion=parseFloat(ua.substring(ua.indexOf("MSIE ")+5,ua.indexOf(";",ua.indexOf("MSIE "))))
if(IEversion< 5.5){
var str = '<object id=noTipClose classid="clsid:ADB880A6-D8FF-11CF-9377-00AA003B7A11">'
str += '<param name="Command" value="Close"></object>';
document.body.insertAdjacentHTML("beforeEnd", str);
document.all.noTipClose.Click();
}
else{
window.opener =null;
window.close();
}
}
else{
window.close()
}
}
//-->
</script>
<input type=button value=關閉 onclick="CloseWin()">
</center></td>
</tr>
</table>
</div>
<br>
<table bordercolor="#008080" border="1" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; margin-left: 14.4pt" width="832" height="123">
<col width="53" style="mso-width-source:userset;mso-width-alt:1696;width:40pt">
<col width="45" span="6" style="mso-width-source:userset;mso-width-alt:1440;
width:34pt">
<col width="42" >
<col width="45" >
<col width="42" >
<col width="45" >
<col width="25">
<col width="42">
<col width="25">
<col width="53" >
<col width="25" >
<col width="53" >
<col width="25" >
<col width="53" >
<col width="53" >
<col width="71" >
<col width="53" >
<col width="25" >
<col width="85">
<col width="53" >
<tr height="26">
<td rowspan="2" class="xl24" width="16" valign="top" height="69">
<p><font size="2">崗位 工資</font></p>
</td>
<td rowspan="2" class="xl24" width="1" valign="top" height="69">
<p class="MsoNormal"><font size="2">技能工資</font></p>
</td>
<td rowspan="2" class="xl24" width="14" valign="top" height="69">
<p class="MsoNormal"><font size="2">年功工資</font></p>
</td>
<td rowspan="2" class="xl24" width="1" valign="top" height="69">
<p class="MsoNormal"><font size="2">降溫費</font></p>
</td>
<td rowspan="2" class="xl24" width="17" valign="top" height="69">
<p class="MsoNormal"><font size="2">職務津貼</font></p>
</td>
<td rowspan="2" class="xl24" width="12" valign="top" height="69">
<p class="MsoNormal"><font size="2">民族補貼</font></p>
</td>
<td rowspan="2" class="xl24" width="23" valign="top" ">
<p class="MsoNormal"><font size="2" >勞保折算</font></p>
</td>
<td rowspan="2" class="xl24" width="12" height="69" valign="top"><font size="2">其他津貼</font></td>
<td rowspan="2" class="xl24" width="25" height="69" valign="top"><font size="2">其他補貼</font></td>
<td rowspan="2" class="xl24" width="25" height="69" valign="top"><font size="2">存假結算</font></td>
<td rowspan="2" class="xl24" width="1" height="69" valign="top"><font size="2">加班工資</font></td>
<td colspan="2" class="xl24" width="65" style="border-left-style: none; border-left-width: medium" align="center" height="13">
<p align="center"><font size="2">工作餐</font></p>
</td>
<td colspan="2" class="xl24" width="52" style="border-left-style: none; border-left-width: medium" align="center" height="13"><font size="2">施工津貼</font></td>
<td colspan="2" class="xl24" width="78" style="border-left-style: none; border-left-width: medium" align="center" height="13"><font size="2">夜餐津貼</font></td>
<td colspan="2" class="xl24" width="67" style="border-left-style: none; border-left-width: medium" align="center" height="13"><font size="2">保健津貼</font></td>
</tr>
<tr height="34" style="mso-height-source:userset;height:26.1pt">
<td height="50" class="xl24" width="31" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium"><font size="2">工日</font></td>
<td class="xl24" width="29" height="50" ><font size="2">金額</font></td>
<td class="xl24" width="35" height="50" ><font size="2">工日</font></td>
<td class="xl24" width="39" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">金額</font></td>
<td class="xl24" width="36" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">工日</font></td>
<td class="xl24" width="37" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">金額</font></td>
<td class="xl24" width="25" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">工日</font></td>
<td class="xl24" width="37" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">金額</font></td>
</tr>
<tr height="33" style="mso-height-source:userset;height:24.95pt">
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_a")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_b")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_c")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_d")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_e")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_f")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_g")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_h")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_i")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_j")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_k")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_l")%></font></td>
<td class="xl25" width="15" x:num="0" height="42"><font size="2"><%=rs("fec_m")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_n")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_o")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_p")%></font></td>
<td class="xl27" width="15" x:num height="42"><font size="2"><%=rs("fec_q")%></font></td>
<td class="xl25" width="15" x:num height="42"><font size="2"><%=rs("fec_r")%></font></td>
<td class="xl27" width="15" x:num height="42"><font size="2"><%=rs("fec_s")%></font></td>
</tr>
</table>
<table bordercolor="#008080" border="1" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; margin-left: 14.4pt" width="656" height="123">
<tr height="26">
<td colspan="5" class="xl24" width="102" style="border-left-style: none; border-left-width: medium" height="13">
<p align="right"><font size="2">扣款</font></p>
</td>
</tr>
<tr height="34" style="mso-height-source:userset;height:26.1pt">
<td class="xl24" width="130" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">公積金</font></td>
<td class="xl24" width="130" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">儲蓄金</font></td>
<td class="xl24" width="130" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">養老金</font></td>
<td class="xl24" width="131" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2">醫療金</font></td>
<td class="xl24" width="131" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" height="50"><font size="2"> </font></td>
</tr>
<tr height="33" style="mso-height-source:userset;height:24.95pt">
<td class="xl25" width="130" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" x:num height="42"><font size="2"><%=rs("fec_u")%></font></td>
<td class="xl25" width="130" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" x:num height="42"><font size="2"><%=rs("fec_v")%></font></td>
<td class="xl26" width="130" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" x:num height="42"><font size="2"><%=rs("fec_w")%></font></td>
<td class="xl26" width="131" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" x:num="0" height="42"><font size="2"><%=rs("fec_x")%> </font></td>
<td class="xl26" width="131" style="border-left-style: none; border-left-width: medium; border-top-style: none; border-top-width: medium" x:num="0" height="42"><font size="2"><%=rs("fec_y")%></font></td>
</tr>
</table>
<table bordercolor="#008080" border="1" style="border-collapse: collapse; mso-border-alt: solid windowtext .5pt; mso-padding-alt: 0cm 5.4pt 0cm 5.4pt; margin-left: 14.4pt" width="384" height="39">
<tr height="26">
<td class="xl24" width="173" height="13" align="center"><font size="2">應發工資總額</font></td>
<td class="xl24" width="182" height="13" align="center"><font size="2">實發工資總額</font></td>
</tr>
<tr height="33" style="mso-height-source:userset;height:24.95pt">
<td class="xl24" width="173" height="14" align="center"><font size="2"><%=rs("fec_t")%></font></td>
<td class="xl24" width="182" height="14" align="center"><font size="2"><%=rs("fec_z")%></font></td>
</tr>
</table>
<p><font size="2">備注說明：<%=rs("others")%></font></p>
<%
rs.movenext
loop
end if
%>
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -