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

📄 jiesuan.asp

📁 一个小型ASP做的工资管理系统,这也是别人做的,我觉得他很地干静.
💻 ASP
📖 第 1 页 / 共 2 页
字号:
🔍
12 
<!--#include file="ked.asp"-->
<!--#include file="conn.asp"-->
<%
user=Request.Cookies("user")
menu=request("menu")
ad=request("ad")
set rsf=server.createobject("adodb.recordset")
sqlf="select * from [user] where name='"&user&"'" 
rsf.open sqlf,conn,1,3
lei2=rsf("zhiwei")
name=rsf("name")

set rs3=server.createobject("adodb.recordset")
sql3="select * from [zhiwei] where lei='"&lei2&"'" 
rs3.open sql3,conn,1,3
suan=rs3("suan")
jiage=rs3("jiage")

if menu="" then
if suan="月" then
response.Redirect("?menu=yue")
response.end
elseif suan="日" then
response.Redirect("?menu=ri")
response.end
elseif suan="年" then
response.Redirect("?menu=nian")
response.end
elseif suan="周" then
response.Redirect("?menu=zhou")
elseif suan="季" then
response.Redirect("?menu=ji")
response.end
end if
end if
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>工资结算</title>
<LINK href="css.css" rel=stylesheet type=text/css>
<style type="text/css">
<!--
body {
	background-color: #9EB6D8;
}
.STYLE1 {
	color: #FFFFFF;
	font-weight: bold;
}
.STYLE2 {color: #FFFFFF}
-->
</style></head>

<body>
<!--按月计算 -->
<%
if menu="yue" then
set rsb=server.createobject("adodb.recordset")
sqlb="select * from [qiandao] where name='"&user&"'" 
rsb.open sqlb,conn,1,3
ri=rsb.recordcount

tian=jiage/30
tian = Round(tian,2)
yue=ri*tian
yue=Round(yue,2) 
if ad="save" then
set rse=server.createobject("adodb.recordset")
sqle="select * from [jiesuan]" 
rse.open sqle,conn,1,3
rse.addnew
rse("name")=name
rse("riqi")=date()
rse("jiage")=jiage
rse("time")=ri
rse("zong")=yue
rse("lei")=suan
rse("ok")="no"
rse.update
rse.close
response.write "<script>alert('已经提交结算信息。');location.href='?menu=yue'</script>"
end if

set rs=conn.execute("select * from [jiesuan] where name='"&name&"' and riqi='"&date()&"'")
if rs.bof and rs.eof then
ok="no"
else
ok="yes"
end if
%>
<table width="95%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#B5CCD6">
<form name="form1" method="post" action="jiesuan.asp?menu=yue&ad=save">
  <tr>
    <td colspan="6" bgcolor="#698CC3"><div align="center" class="STYLE1">按月工资结算</div></td>
  </tr>
  <tr>
    <td width="81" bgcolor="#F9F9F9">姓名：</td>
    <td width="177" bgcolor="#F9F9F9"><%=name%></td>
    <td width="83" bgcolor="#F9F9F9">工作职位：</td>
    <td width="185" bgcolor="#F9F9F9"><%=lei2%></td>
    <td width="79" bgcolor="#F9F9F9">工资：</td>
    <td width="295" bgcolor="#F9F9F9"><%=jiage%></span>元/<%=suan%></td>
  </tr>
        <tr>
      <td bgcolor="#F9F9F9">上班天数：</td>
      <td bgcolor="#F9F9F9"><%=ri%>天</td>
      <td bgcolor="#F9F9F9">每日工资：</td>
      <td bgcolor="#F9F9F9"><%=tian%>元</td>
      <td bgcolor="#F9F9F9">总额：</td>
      <td bgcolor="#F9F9F9"><%=yue%>元</td>
    </tr>
  <tr>
    <td colspan="6" bgcolor="#F9F9F9">
    由于你是按月结算的，那么你的结算方式如下：</td>
  </tr>
  <tr>
    <td colspan="6" bgcolor="#F9F9F9">你一共上班<%=ri%>天，每天的工资是<%=tian%>元(每个月按30天计算)，那么你本月得到的工资是<%=yue%>元。（上班天数 X 每天的工资 = 工资）</td>
  </tr>
  <tr>
    <td colspan="6" bgcolor="#F9F9F9"><div align="center">
      <%if ok="no" then%><input type="submit" name="Submit" value="马上结算工资"><%else%>你已经提交结算信息，请耐心等候。<%end if%>
    </div></td>
  </tr>
  </form>
</table>
<%end if%>
<!--按日计算 -->
<%
if menu="ri" then
set rsb=server.createobject("adodb.recordset")
sqlb="select * from [qiandao] where name='"&user&"'" 
rsb.open sqlb,conn,1,3
ri=rsb.recordcount

zong=ri*jiage
zong=Round(zong, 2) 
if ad="save" then
set rse=server.createobject("adodb.recordset")
sqle="select * from [jiesuan]" 
rse.open sqle,conn,1,3
rse.addnew
rse("name")=name
rse("riqi")=date()
rse("jiage")=jiage
rse("time")=ri
rse("zong")=zong
rse("lei")=suan
rse("ok")="no"
rse.update
rse.close
response.write "<script>alert('已经提交结算信息。');location.href='?menu=ri'</script>"
end if

set rs=conn.execute("select * from [jiesuan] where name='"&name&"' and riqi='"&date()&"'")
if rs.bof and rs.eof then
ok="no"
else
ok="yes"
end if
%>
<table width="95%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#B5CCD6">
  <form name="form1" method="post" action="jiesuan.asp?menu=ri&ad=save">
    <tr>
      <td colspan="6" bgcolor="#698CC3"><div align="center" class="STYLE2"><strong>按日工资结算</strong></div></td>
    </tr>
    <tr>
      <td width="81" bgcolor="#F9F9F9">姓名：</td>
      <td width="177" bgcolor="#F9F9F9"><%=name%></td>
      <td width="83" bgcolor="#F9F9F9">工作职位：</td>
      <td width="185" bgcolor="#F9F9F9"><%=lei2%></td>
      <td width="79" bgcolor="#F9F9F9">工资：</td>
      <td width="295" bgcolor="#F9F9F9"><%=jiage%></span>元/<%=suan%></td>
    </tr>
		    <tr>
      <td bgcolor="#F9F9F9">上班天数：</td>
      <td bgcolor="#F9F9F9"><%=ri%>天</td>
      <td bgcolor="#F9F9F9">每日工资：</td>
      <td bgcolor="#F9F9F9"><%=jiage%>元</td>
      <td bgcolor="#F9F9F9">总额：</td>
      <td bgcolor="#F9F9F9"><%=zong%>元</td>
    </tr>
    <tr>
      <td colspan="6" bgcolor="#F9F9F9"> 由于你是按日结算的，那么你的结算方式如下：</td>
    </tr>
    <tr>
      <td colspan="6" bgcolor="#F9F9F9">你一共上班<%=ri%>天，每天的工资是<%=jiage%>元，那么你现在得到的工资是<%=zong%>元（上班天数 X 每天的工资 = 工资）</td>
    </tr>
    <tr>
      <td colspan="6" bgcolor="#F9F9F9"><div align="center">
        <%if ok="no" then%>
        <input type="submit" name="Submit2" value="马上结算工资">
        <%else%>
        你已经提交结算信息，请耐心等候。
        <%end if%>
      </div></td>
    </tr>
  </form>
</table>
<%end if%>
<!--按年计算 -->
<%
if menu="nian" then
set rsb=server.createobject("adodb.recordset")
sqlb="select * from [qiandao] where name='"&user&"'" 
rsb.open sqlb,conn,1,3
ri=rsb.recordcount

tian2=jiage/365
tian2=Round(tian2, 2) 
zong=ri*tian2
zong=Round(zong, 2) 
if ad="save" then
set rse=server.createobject("adodb.recordset")
sqle="select * from [jiesuan]" 
rse.open sqle,conn,1,3
rse.addnew
rse("name")=name
rse("riqi")=date()
rse("jiage")=jiage
rse("time")=ri
rse("zong")=zong
rse("lei")=suan
rse("ok")="no"
rse.update
rse.close
response.write "<script>alert('已经提交结算信息。');location.href='?menu=nian'</script>"
end if

set rs=conn.execute("select * from [jiesuan] where name='"&name&"' and riqi='"&date()&"'")
if rs.bof and rs.eof then
ok="no"
else
ok="yes"
end if
%>
<table width="95%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#B5CCD6">
  <form name="form1" method="post" action="jiesuan.asp?menu=nian&ad=save">
    <tr>
      <td colspan="6" bgcolor="#698CC3"><div align="center" class="STYLE2"><strong>按<%=suan%>工资结算</strong></div></td>
    </tr>
    <tr>
      <td width="81" bgcolor="#F9F9F9">姓名：</td>
      <td width="177" bgcolor="#F9F9F9"><%=name%></td>
      <td width="83" bgcolor="#F9F9F9">工作职位：</td>
      <td width="185" bgcolor="#F9F9F9"><%=lei2%></td>
      <td width="79" bgcolor="#F9F9F9">工资：</td>
      <td width="295" bgcolor="#F9F9F9"><%=jiage%></span>元/<%=suan%></td>
    </tr>
	    <tr>
12

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -