⭐ 欢迎来到虫虫下载站！ | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站
📤 上传资源

📄 ser.asp

📁 使用源码注意项： 1、Windows2000 Professional SP3、DELPHI 6.0、SQL Server2000的开发环境； 2、开发目录为：D:PieceRate
💻 ASP
字号:
🔍 
<!--#include file="conn.asp"-->
<%
ic=request.form("ic")
ym=request.form("ym")
exec="select * from sa where ic='"+ic+"' 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.history.go(-1);}</script>")
else
do while not rs.eof
%>
</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>
<p><font size="2">&nbsp;工资信息：</font></p>
<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">岗位&nbsp; 工资</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 + -