📄 m_wageadd.asp

📁 房地产信息管理平台
💻 ASP
📖 第 1 页 / 共 2 页
字号:
12 下一页
<!-- #include File=../../showsort/showsort(man).asp -->
<%if sort<2 then%>
<script language="JavaScript">
alert("对不起，您没有权限！！");
window.history.back();
</script>
<%end if%>
<%
userid=request("userid")
yy=request("yy")
mm=request("mm")
'-----------获取用户姓名
set rs=server.createobject("adodb.recordset")
rs.open "select name from manage_user where id="&userid,source,3,3
name=rs("name")
rs.close
'-----------获取上月相关值
sql="select * from m_wage where userid="&userid&" order by dotime desc"
rs.open sql,source,3,3
if not rs.eof then
wage=rs("wage")
pay=rs("pay")
house=rs("house")
lunch=rs("lunch")
outpay=rs("outpay")
bonus=rs("bonus")
card=0
ratal=rs("ratal")
safe=rs("safe")
other=rs("other")
rs.close
else
wage=0
pay=0
house=0
lunch=0
outpay=0
bonus=0
card=0
ratal=0
safe=0
other=0
end if
lastmoney=wage+pay+house+lunch+outpay+bonus-card-ratal-safe-other
'-----------判断是否为提交状态
if request("pagename")="wageadd" then
xxxx=request("yy")&"-"&request("mm")&"-"&"15"
set rss=server.createobject("adodb.recordset")
sqls="select * from m_wage where dotime='"&xxxx&"' and userid="&userid
rss.open sqls,source,3,3
if not rss.eof then
%>
<script language="JavaScript">
alert("已有该月工资信息!");
window.history.back();
</script>
<%
response.end
end if
rss.addnew
rss("dotime")=xxxx
rss("wage")=request("wage")
rss("pay")=request("pay")
if request("house")<>"" then
rss("house")=request("house")
end if
if request("lunch")<>"" then
rss("lunch")=request("lunch")
end if
if request("outpay")<>"" then
rss("outpay")=request("outpay")
end if
if request("bonus")<>"" then
rss("bonus")=request("bonus")
end if
if request("card")<>"" then
rss("card")=request("card")
end if
if request("ratal")<>"" then
rss("ratal")=request("ratal")
end if
if request("safe")<>"" then
rss("safe")=request("safe")
end if
if request("other")<>"" then
rss("other")=request("other")
end if
if request("brief")<>"" then
rss("brief")=request("brief")
end if
rss("givetime")=request("yy")&"-"&request("bmm")&"-"&request("bdd")
'request("yy")&"-"&request("bmm")&"-"&
rss("userid")=userid
rss.update
rss.close
%>
<script language="JavaScript">
alert("添加成功!");
window.location="m_wagelist.asp?userid=<%=userid%>";
</script>
<%
end if
%>
<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>
<script language="JavaScript">
<!--
function jg_onchange(){
jgnum=0;
if(document.form1.wage.value==""||isNaN(document.form1.wage.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum+parseFloat(document.form1.wage.value);
}
if(document.form1.pay.value=="")document.form1.pay.value=0
if(isNaN(document.form1.pay.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum+parseFloat(document.form1.pay.value);
}
if(document.form1.house.value=="")document.form1.house.value=0
if(isNaN(document.form1.house.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum+parseFloat(document.form1.house.value);
}
if(document.form1.lunch.value=="")document.form1.lunch.value=0
if(isNaN(document.form1.lunch.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum+parseFloat(document.form1.lunch.value);
}
if(document.form1.outpay.value=="")document.form1.outpay.value=0
if(isNaN(document.form1.outpay.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum+parseFloat(document.form1.outpay.value);
}
if(document.form1.bonus.value=="")document.form1.bonus.value=0
if(isNaN(document.form1.bonus.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum+parseFloat(document.form1.bonus.value);
}
if(document.form1.card.value=="")document.form1.card.value=0
if(isNaN(document.form1.card.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum-parseFloat(document.form1.card.value);
}
if(document.form1.ratal.value=="")document.form1.ratal.value=0
if(isNaN(document.form1.ratal.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum-parseFloat(document.form1.ratal.value);
}
if(document.form1.safe.value=="")document.form1.safe.value=0
if(isNaN(document.form1.safe.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum-parseFloat(document.form1.safe.value);
}
if(document.form1.other.value=="")document.form1.other.value=0
if(isNaN(document.form1.other.value))
{
alert("只能输入数字")
}
else
{
jgnum=jgnum-parseFloat(document.form1.other.value);
document.form1.lastmoney.value=eval("jgnum");
}
}
//-->
</script>
</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">&gt; 
                部门一览</font></a></td>
            </tr>
            <tr class="bgcolor2"> 
              <td></td>
              <td></td>
              <td><a href="../dept/d_input.asp"><font color="#FFFFFF">&gt; 新增部门</font></a></td>
            </tr>
12 下一页
⌨️ 快捷键说明

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