📄 jsgl1.asp
字号:
<!--#include file="pwd.asp" -->
<!--#include file="tsgl_conn.inc" -->
<%
cxh=session("sxh")
cbh=request.form("tbh")
cfl=left(cbh,2)
ccs=request.form("tcs")
crq=request.form("trq")
txm=session("sxm")
tbjmc=session("sbjmc")
sql="select * from flk where fldm='"&cfl&"'"
Set RS = Server.CreateObject("ADODB.RecordSet")
RS.Open sql, tsgl_Conn
if rs.eof then
rs.close
set rs=nothing
response.write("图书分类代码：“"&cfl&"”错误！")
%>
<p align=center>
<a href="jsgl0.asp">返回</a></p>
<%
response.end
else
tmc=rs("flmc")
end if
rs.close
sql="select * from "&cfl&" where bh='"&cbh&"'"
RS.Open sql, tsgl_Conn
if rs.eof then
rs.close
set rs=nothing
response.write ("<font color=""#FF0000"">“"&tmc&"("&cfl&")”分类图书中的编号“"&cbh&"”不存在！</font>")
%>
<p align=center>
<a href="jsgl0.asp">返回</a></p>
<%
response.end
else
tsm=rs("sm") '返回书名
if cint(rs("kcs"))<cint(ccs) or cint(ccs)<=0 then
rs.close
set rs=nothing
response.write ("<font color=""#FF0000"">图书《"&tsm&"》("&cbh&")已被借完或库存数不够！</font>")
%>
<p align=center>
<a href="jsgl0.asp">返回</a></p>
<%
response.end
end if
rs.close
end if
sql="select * from jsk where xh='"&cxh&"' and bh='"&cbh&"' and cs>0"
RS.Open sql, tsgl_Conn
if not rs.eof then
response.write("<font color=""#FF0000"">学生“"&txm&"("&cxh&")”借书《"&tsm&"》("&cbh&")未还，不能重复借!</font>")
rs.close
set rs=nothing
%>
<p>
<a href="jsgl0.asp">返回</a><p>
<%
response.end
end if
rs.close
set rs=nothing
%>
<HTML>
<HEAD><TITLE>借书管理</TITLE></HEAD>
<BODY BGCOLOR=#FFFFFF>
<h3>借书管理</h3>
班级名称:<font color="#0000FF"><%=tbjmc%></font><P>
姓名:<font color="#0000FF"><%=txm%>(<%=cxh%>)</font><P>
书名:<font color="#0000FF">《<%=tsm%>》(<%=cbh%>)</font><P>
册数:<font color="#0000FF"><%=ccs%></font><P>
<br>
<form action="jsgl2.asp" method="POST">
<input type="hidden" name="tbh" value=<%=cbh%>>
<input type="hidden" name="tcs" value=<%=ccs%>>
<input type="hidden" name="trq" value=<%=crq%>>
<p align="center">
<input type="submit" name="cmd1" value="确定">
</p>
</form>
<a href="jsgl0.asp">返回</a>
</BODY>
</HTML>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -