📄 o_deptover.asp
字号:
<!--#include file="../../showsort/showsort(bangong).asp"-->
<%
if request("id")="" then
%>
<script language="javascript">
alert("操作有误，请重填!");
window.location="o_adddept.asp";
</script>
<%
response.end
end if
if request("pagename")="doadddept" then
set rs=server.createobject("ADODB.Recordset")
set rsd=server.createobject("ADODB.Recordset")
set rsu=server.createobject("ADODB.Recordset")
set rsa=server.createobject("ADODB.Recordset")
'-------------更改部门用品申请辅表
rs.open "select * from office_deptdo where state=2 and main_id="&request("id"),source,3,3
rs("retime")=now
rs("pass")=3
rs.update
rs.close
rs.open "select okname from office_deptdo where main_id="&request("id")&" and state=3",source,3,3
okname=rs("okname")
rs.close
'--------------更改部门用品申请主表
rsa.open "select deptid,state,brief from office_deptmain where id="&request("id"),source,3,3
rsa("state")=3
deptcode=rsa("deptid")
rsa("brief")=request("brief")
rsa.update
rsa.close
'--------------更改部门用品申请明细表
rs.open "select * from office_deptlist where main_id="&request("id"),source,3,3
maxcount=rs.recordcount
for i=1 to maxcount
rsa.open "select * from office_deptsome where deptid='"&deptcode&"' and setup_id="&rs("setup_id"),source,3,3
if not rsa.eof then
rsa("quantity")=rsa("quantity")+request(rs("setup_id"))
else
rsa.addnew
rsa("deptid")=deptcode
rsa("setup_id")=rs("setup_id")
rsa("quantity")=request(rs("setup_id"))
end if
rsa.update
rsa.close
rs("d_quantity")=request(rs("setup_id"))
if i<maxcount then
rs.movenext
end if
next
rs.update
rs.close
%>
<script language="javascript">
alert("已成功批准，该申请已发往<%=okname%>!");
window.location="o_deptwait.asp";
</script>
<%
response.end
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 je_onchange(a,b,c)
{
oldamount=a.value;
a.value=b*c;
document.form1.allamount.value=parseFloat(document.form1.allamount.value)+b*c-oldamount;
}
function amsub(form)
{
if(form.allamount.value=="0"||form.allamount.value=="")
{
alert("操作有误,请重填!");
return false;
}
return true;
}
</script>
</head>
<body topmargin="0" leftmargin="0">
<div align="center">
<!-- #include File=../../include/title2.asp -->
<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> <a href="#"><font color="#FFFFFF">办公用品</font></a></td>
</tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../office/o_index.asp"><font color="#FFFFFF">>
办公用品列表</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../office/o_pathlist.asp"><font color="#FFFFFF">>
申请流程设定</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../office/o_deptwait.asp"><font color="#FFFFFF">>
待批办公用品</font></a></td>
</tr> <tr class="bgcolor2"> <td></td> <td></td> <td><a href="../office/o_deptlist.asp"><font color="#FFFFFF">> 部门办公用品</font></a></td> </tr> <tr class="bgcolor4"> <td width="18%"></td> <td width="82%" colspan="2"><font color="#FFFFFF">::::</font> <a href="#"><font color="#FFFFFF">文档管理</font></a></td> </tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../file/f_index.asp"><font color="#FFFFFF">>
查看文档</font></a><a href="allforums.asp?action=all"></a><a href="../schedule/s_menu_wait.asp"></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../file/f_adddept.asp"><font color="#FFFFFF">> 新建文档</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td align="left"><a href="../file/f_setsort.asp"><font color="#FFFFFF">>
设置文档</font></a><font color="#FFFFFF"></font></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../file/f_search.asp"><font color="#FFFFFF">> 检索文档</font></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font> <a href="#"><font color="#FFFFFF">图书管理</font></a></td>
</tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../book/b_index.asp"><font color="#FFFFFF">>
查看图书</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../book/b_add1.asp"><font color="#FFFFFF">> 添加图书</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td align="left"><a href="../book/b_doapply1.asp"><font color="#FFFFFF">>
管理图书</font></a><a href="findplacard.asp"></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font> <a href="#"><font color="#FFFFFF">车辆管理</font></a></td>
</tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../car/c_list.asp"><font color="#FFFFFF">>
查看车辆</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../car/c_add.asp"><font color="#FFFFFF">> 添加车辆</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td align="left"><a href="../car/c_manage.asp"><font color="#FFFFFF">>
管理车辆</font></a></td>
</tr>
<tr class="bgcolor4">
<td width="18%"></td>
<td width="82%" colspan="2"><font color="#FFFFFF">::::</font> <a href="#"><font color="#FFFFFF">会议室管理</font></a></td>
</tr>
<tr class="bgcolor2">
<td width="18%"></td>
<td width="16%"></td>
<td width="66%"><a href="../meeting/m_list.asp"><font color="#FFFFFF">>
查看会议室</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td><a href="../meeting/m_add.asp"><font color="#FFFFFF">> 添加会议室</font></a></td>
</tr>
<tr class="bgcolor2">
<td></td>
<td></td>
<td align="left"><a href="../meeting/m_manage.asp"><font color="#FFFFFF">>
管理会议室</font></a></td>
</tr>
<tr class="bgcolor4">
<td colspan="3" height="80"></td>
</tr>
</table>
</td>
<td width="1%" bgcolor="#FFFFFF"></td>
<td width="79%" bgcolor="#FFFFFF" valign="top">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%" height="10"></td>
</tr>
<tr>
<td width="100%">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%" height="25" style="background-image: url('../../images/<%=session("color")%>/resource.gif'); background-repeat: no-repeat">
<font color="#000080"> 企业资源</font>
办公用品审批</td>
</tr>
<tr>
<td width="100%" height="10"></td>
</tr>
<tr>
<td width="100%" height="10">
<%
set rs1=server.createobject("ADODB.Recordset")
rs1.open "select * from office_deptmain where id="&request("id"),source,3,3
brief=rs1("brief")
doname=rs1("doman")
%>
<form name="form1" action="o_deptover.asp">
<table border="1" cellspacing="0" cellpadding="0" bordercolorlight="#CCCCCC" bordercolordark="#ffffff" width="98%" align="center">
<tr>
<td colspan="7">
<div align="center"><%=request("deptname")%>
<%=left(rs1("dodate"),4)%>年<%=right(rs1("dodate"),2)%>月公用文具用品申请计划</div>
</td>
</tr>
<%
dodate=rs1("dodate")
rs1.close
%>
<tr>
<td width="30%">
<div align="center">名称及规划</div>
</td>
<td width="10%">
<div align="center">单位</div>
</td>
<td width="10%">
<div align="center">参考单价</div>
</td>
<td width="10%">
<div align="center">申请数量</div>
</td>
<td width="10%">
<div align="center">申请金额</div>
</td>
<td width="10%">
<div align="center">审核数量</div>
</td>
<td width="10%">
<div align="center">审核金额</div>
</td>
</tr>
<%
set rs=server.createobject("ADODB.Recordset")
rs.Open "select a.name,a.unit,a.price,b.s_quantity,b.setup_id from office_setup as a,office_deptlist as b where a.id=b.setup_id and b.main_id="&request("id"),source,3,3
while not rs.eof
allamount=allamount+rs("price")*rs("s_quantity")
%>
<tr>
<td width="30%" align="center" ><%=rs("name")%></td>
<td align="center" width="10%"><%=rs("unit")%></td>
<td align="center" width="10%"><%=rs("price")%>
</td>
<td align="center" width="10%">
<%=rs("s_quantity")%>
</td>
<td align="center" width="10%">
<%=(rs("price")*rs("s_quantity"))%>
</td>
<td width="10%">
<div align="center">
<input type="hidden" name="price<%=rs("setup_id")%>" size="5" maxlength="5" value="<%=rs("price")%>">
<input type="text" name="<%=rs("setup_id")%>" size="5" maxlength="5" onChange="return je_onchange(document.form1.amount<%=rs("setup_id")%>,document.form1.price<%=rs("setup_id")%>.value,this.value)" value="<%=rs("s_quantity")%>">
</div>
</td>
<td width="10%">
<div align="center">
<input type="text" name="amount<%=rs("setup_id")%>" size="5" maxlength="10" value="<%=(rs("price")*rs("s_quantity"))%>">
</div>
</td>
</tr>
<%
rs.movenext
wend
rs.close
%>
<tr>
<td colspan="4" align="right"> 申请金额：</td>
<td width="10%">
<div align="center">
<%=allamount%>
</div>
</td>
<td align="right"> 审核金额：</td>
<td align="center">
<input type="text" name="allamount" size="5" maxlength="10" value="<%=allamount%>">
</td>
</tr>
<tr align="center">
<td colspan="7"> 备注 <br>
<textarea name="brief" cols="50" rows="5"><%=brief%></textarea>
</td>
</tr>
<tr align="center">
<td colspan="7"> 经办人：<%=doname%> 部门经理：<%=request("manager")%></td>
</tr>
<tr align="center">
<td colspan="7">
<input type="hidden" name="pagename" size="5" maxlength="5" value="doadddept">
<input type="hidden" name="id" size="5" maxlength="5" value="<%=request("id")%>">
<input type="hidden" name="dodate" size="5" maxlength="5" value="<%=dodate%>">
<input type="submit" name="Submit" value="审核申请">
<input type="reset" name="redo" value="重填">
<input type="reset" name="redo2" value="删除申请" onClick="window.location='o_deptwait.asp?delid=<%=request("id")%>'">
</td>
</tr>
</table>
</form>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<!-- #include File=../../include/last2.asp -->
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -