📄 b_return.asp
字号:
<!--#include file="../../showsort/showsort(book).asp"-->
<%if sort<2 then%>
<script language="JavaScript">
alert("对不起，您没有权限！！");
window.history.back();
</script>
<%end if%>
<%sql="select * from book_main where id='"&request("id")&"'"
set rs=server.createobject("ADODB.Recordset")
rs.Open sql,source,3,3 %> <%if request("submit")="确定还书" then%> <%
sql1="select * from book_borrow where id='"&request("id")&"'"
set rs1=server.createobject("ADODB.Recordset")
rs1.Open sql1,source,3,3
sql2="select * from book_main where id='"&request("id")&"'"
set rs2=server.createobject("ADODB.Recordset")
rs2.Open sql2,source,3,3
rs2("borrow")=0
rs2.update
set rs_r=server.createobject("ADODB.Recordset")
rs_r.open "select * from manage_mark where 1>2",source,3,3
rs_r.addnew
rs_r("sourceid")=session("userid")
rs_r("date")=now
rs_r("operationid")=14
rs_r("object")=rs1("borrow_man")
rs_r("object2")=rs("name")
rs_r.update
rs_r.close
rs1.delete
rs1.close
%>
<script language="JavaScript">
alert("您所借的书籍已成功的归还了！！！");
window.location="b_doapply1.asp?id=<%=request("id")%>";
</script>
<%end if%>
<html>
<head>
<meta http-equiv="Content-Language" content="zh-cn">
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<meta name="ProgId" content="FrontPage.Editor.Document">
<title>资源管理</title>
<LINK href="../../ls.css" rel=stylesheet type=text/css>
</head>
<body class="L2" topmargin="0">
<div align="center">
<table width="100%" cellspacing cellpadding>
<center>
<tr>
<td width="100%"><img border="0" src="../../images/banner.gif" width="100%" height="79"></td>
</tr>
</center><tr><td width="100%">
<table width="100%" cellspacing cellpadding>
<center>
<tr>
<td width="100%" bgcolor="#FFC600">
<table width="100%" cellspacing cellpadding>
<tr>
<td width="100%">
<table width="100%" cellspacing cellpadding class="L2">
<tr>
<td width="11%" align="center"> <a href="../../homepage.asp">首
页</a></td>
<td width="11%" align="center"><a href="../../imail/message.asp">个人办公</a></td>
<td width="11%" align="center"><a href="../../workflow/w_waitlist.asp">公文管理</a></td>
<td width="11%" align="center" bgcolor="#FFE384"><a href="../book/b_index.asp">企业资源</a></td>
<td width="11%" align="center"><a href="../dept/d_list.asp">人事管理</a></td>
<td width="11%" align="center"><a href="../../domanage/d_wait.asp">经理事务</a></td>
<td width="11%" align="center"><a href="../../community/forum.asp">企业社区</a></td>
<td width="11%" align="center"><a href="../../manage/user.asp">系统维护</a></td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</center><tr><td width="100%">
<table width="100%" cellspacing cellpadding>
<tr>
<center>
<td width="160" bgcolor="#FFC600" valign="top" height="400">
<table width="100%" cellspacing cellpadding class="L2">
<tr>
<td width="100%" height="10" colspan="3"></td>
</tr>
<tr>
<td width="100%" height="10" colspan="3"> </td>
</tr>
<tr>
<td width="100%" height="10" colspan="3"></td>
</tr>
<tr>
<td width="22%" align="center"></td>
<td width="78%" align="left" colspan="2"><a href="#">::::
企业资源</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../book/b_index.asp">>
图书管理</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../file/f_index.asp">>
文件管理</a></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../meeting/m_list.asp">>
会议管理</a><b><a href="gwgl.htm"> </a></b></td>
</tr>
<tr>
<td width="22%" align="center" bgcolor="#FFE384"> </td>
<td width="19%" align="left" bgcolor="#FFE384"> </td>
<td width="59%" align="left" bgcolor="#FFE384"><a href="../car/c_list.asp">>
车辆管理</a></td>
</tr>
</table>
</td>
<td width="5"></td>
</center>
<td width="550" class="L2" valign="top">
<table width="100%" border="0" cellspacing="0" cellpadding="0" height="100%">
<tr valign="top">
<td>
<table width="504" border="0" cellspacing="0" cellpadding="0" align="center" height="5">
<tr>
<td height="5"></td>
</tr>
</table>
<img src="images/r_tb_1.gif" width="503" height="32" usemap="#Map3" border="0"><map name="Map3"><area shape="rect" coords="315, 17, 365, 31" href="b_index.asp"><area shape="rect" coords="371,17,424,32" href="b_add1.asp"><area shape="rect" coords="427,16,480,33" href="b_doapply1.asp"></map>
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="unnamed1">
<tr align="center">
<td>
<form name="form1" >
<table width="100%" border="1" cellspacing="0" cellpadding="0" align="center" bordercolorlight="#CCCCCC" bordercolordark="#FFFFFF" class="L2">
<tr>
<td width="9%">编号</td>
<td width="35%"> <%=rs("number")%> </td>
<td width="13%">书名</td>
<td width="43%"> <%=rs("name")%> </td>
</tr>
<tr>
<td width="9%">作者</td>
<td width="35%"> <%=rs("author")%> </td>
<td width="13%">单价</td>
<td width="43%"> <%=rs("price")%> </td>
</tr>
<tr>
<td width="9%">出版社</td>
<td width="35%"> <%=rs("book_concern")%>
</td>
<td width="13%">出版时间</td>
<td width="43%"><%=rs("publishment_date")%></td>
</tr>
<tr>
<td width="9%">内容简介</td>
<td colspan="3"> <%=rs("detail")%>
</td>
</tr>
<tr>
<td width="9%">借者</td>
<td width="35%"> <%sql3="select * from book_borrow where id='"&rs("id")&"' "
set rs3=server.createobject("ADODB.Recordset")
rs3.Open sql3,source,3,3%> <%if not rs3.eof then%><%=rs3("borrow_man")%><%else%> <%end if%>
</td>
<td width="13%">借书时间</td>
<td width="43%"><%if not rs3.eof then%><%=rs3("borrow_time")%><%else%> <%end if%></td>
</tr>
</table>
<p align="right">
<input type="hidden" name="submit" value="确定还书">
<input type="hidden" name="book_name" value="<%=rs("name")%>">
<input type="hidden" name="id" value="<%=request("id")%>">
<input type="image" border="0" src="images/r_buttom_3.gif" width="61" height="18" name="image">
</p>
</form>
<%rs.close
rs3.close
%> </td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td width="100%"></td>
</tr>
</table>
<p>
</td>
</tr>
</table>
</div>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -