📄 editbook.asp
字号:
<!--#include file="conn.inc"-->
<%if session("admin")="" then
response.Write "<script language='javascript'>alert('网络超时或您还没有登陆！');window.location.href='login.asp';</script>"
response.End
end if
dim bookid
bookid=request.QueryString("id")
%>
<script language="Javascript">
function openScript(url, width, height){
var Win = window.open(url,"openScript",'width=' + width + ',height=' + height + ',resizable=1,scrollbars=yes,menubar=no,status=yes' );
}
function openem()
{
openScript('../upload.asp',350,200);
}
function openem1()
{
openScript('../upload1.asp',350,200);
}
</script>
<html>
<head>
<title>Untitled Document</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../images/css.css" rel="stylesheet" type="text/css">
<style>
td{font-size:9pt;line-height:120%;color:#353535}
body{font-size:9pt;line-height:120%}
a:link { color: #000000; text-decoration: none }
a:visited { color: #000000; text-decoration: none }
a:active { color: #000000; text-decoration: none }
a:hover { color: #336699; text-decoration: none; position: relative; right: 0px; top: 1px }
</style>
</head>
<body bgcolor="#D9E6FF">
<table width="95%" border="0" cellspacing="0" cellpadding="0" align="center">
<tr>
<td>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td rowspan="2">
<table width="100%" border="0" cellspacing="0" cellpadding="0" class="12v">
<tr>
<td class="12v" >
<table border="0" cellpadding="0" cellspacing="0" style="border-collapse: collapse" id="AutoNumber3" height="0" width="100%">
<tr>
<td>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td height="20">
<div align="center"><font color="#000000">修改图书</font></div>
</td>
</tr>
<tr>
<form name="form" method="post" action="saveaddbook.asp?action=edit&id=<%=bookid%>">
<td height="126">
<table width="88%" border="0" align="center" cellpadding="2" cellspacing="0">
<!--DWLayoutTable-->
<tr>
<td width="116"> <div align="center">选择分类：</div></td>
<td colspan="2"> <%dim rs1
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from shop_books where bookid="&bookid,conn,1,1
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_anclass order by anclassid",conn,1,1
if rs.eof and rs.bof then
response.write "请先添加栏目。"
response.end
else
%> <select name="anclassid" size="1" id="anclassid" onChange="changelocation(document.myform.anclassid.options[document.myform.anclassid.selectedIndex].value)">
<%
do while not rs.eof
%>
<option value="<%=rs("anclassid")%>" <%if rs1("anclassid")=rs("anclassid") then%>selected<%end if%>><%=trim(rs("anclass"))%></option>
<%
rs.movenext
loop
end if
rs.close
%>
</select>
</td>
<td width="4"></td>
</tr>
<tr>
<td> <div align="center">选择系列：</div></td>
<td colspan="2"> <%
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from shop_nclass order by anclassid",conn,1,1
if rs.eof and rs.bof then
response.write "请先添加栏目。"
response.end
else
%> <select name="nclassid" size="1" id="nclassid" onChange="changelocation(document.myform.anclassid.options[document.myform.anclassid.selectedIndex].value)">
<%
do while not rs.eof
%>
<option value="<%=rs("anclassid")%>" <%if rs1("xilieid")=rs("anclassid") then%>selected<%end if%>><%=trim(rs("anclass"))%></option>
<%
rs.movenext
loop
end if
rs.close
%>
</select>
</td>
<td></td>
</tr>
<tr>
<td> <div align="center">
书名：</div></td>
<td colspan="2"> <input name="bookname" type="text" id="bookname" size="30" value="<%=trim(rs1("bookname"))%>"> </td>
<td></td>
</tr>
<tr>
<td><div align="center">
出版社：</div></td>
<td colspan="2"><input name="press" type="text" id="press" value="<%=trim(rs1("press"))%>" size="16"></td>
<td></td>
</tr>
<tr>
<td> <div align="center">
作者：</div></td>
<td colspan="2"> <input name="bookzz" type="text" id="bookzz" size="20" value="<%=trim(rs1("bookzz"))%>"> </td>
<td></td>
</tr>
<tr>
<td><div align="center">
出版日期：
</div></td>
<td colspan="2"><select name="bookdateyear" id="bookdateyear">
<%dim i
for i=1996 to 2006
response.write "<option value="&i&">"&i&"</option>"
next
%>
</select>
年
<select name="bookdatemonth" id="bookdatemonth">
<%for i=1 to 12
response.write "<option value="&i&">"&i&"</option>"
next%>
</select>
月
<select name="bookdateday" id="bookdateday">
<%for i=1 to 31
response.write "<option value="&i&">"&i&"</option>"
next%>
</select>
日 <font color="#FF0000"> 原日期：<%=trim(rs1("bookdate"))%></font></td>
<td></td>
</tr>
<tr>
<td> <div align="center">
ISBN：
</div></td>
<td colspan="2"> <input name="isbn" type="text" id="isbn" size="30" value="<%=trim(rs1("isbn"))%>">
</td>
<td></td>
</tr>
<tr>
<td height="20" valign="top"> <div align="center">
价格：</div></td>
<td colspan="2" valign="top">市场价
<input name="price" type="text" id="price" size="6" onKeyPress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))"
onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"
ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=rs1("price")%>">
元 会员价
<input name="huiyuanjia" type="text" id="price2" size="6" onKeyPress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))"
onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"
ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=rs1("huiyuanjia")%>">
元</td>
<td></td>
</tr>
<tr>
<td height="20" valign="top"> <div align="center">
其他：
</div></td>
<td height="20" colspan="2" rowspan="2" valign="top">字数：
<input name="zishu" type="text" id="zishu" value="<%=rs1("wordcount")%>" size="8">
版 次：
<input name="banci" value="<%=rs1("banci")%>" size="8" type="text">
页数：
<input name="yeshu2" type="text" id="yeshu2" value="<%=rs1("pagecount")%>" size="6">
库存：
<select name="kucun" value="">
<option value="有" <%if rs1("kucun")="有" then%>selected<%end if%>>有</option>
<option value="无" <%if rs1("kucun")="无" then%>selected<%end if%>>无</option>
</select></td>
<td></td>
</tr>
<tr>
<td rowspan="2" valign="top"> <div align="center">
小图片：
</div></td>
<td height="1"></td>
</tr>
<tr>
<td colspan="2" rowspan="2" valign="top"> <input name="pic" type="text" id="bookpic" size="50" value="<%=pic%>">
[<a href="JavaScript:openem()">上传</a>] </td>
<td height="24"></td>
</tr>
<tr>
<td rowspan="2" valign="top"> <div align="center">
大图片：
</div></td>
<td height="1"></td>
</tr>
<tr>
<td colspan="2" rowspan="2" valign="top"> <input name="pic1" type="text" id="bookpic" size="30" value="<%=pic1%>">
[<a href="JavaScript:openem1()">上传</a>] </td>
<td height="24"></td>
</tr>
<tr>
<td rowspan="2" valign="top"> <div align="center">
备注：</div></td>
<td height="1"></td>
</tr>
<tr>
<td height="137" colspan="2" valign="top"> <textarea name="bookcontent" cols="46" rows="8" id="textarea"><%=rs1("bookcontent")%></textarea></td>
<td></td>
</tr>
<tr>
<td height="32" valign="top"> <div align="center">
</div></td>
<td width="504" valign="top"> <div align="center">
<input name="newsbook" type="checkbox" id="newsbook" value="1" <%if rs1("newsbook")=1 then%>checked<%end if%>>
新书
<input name="bestbook" type="checkbox" id="bestbook" value="1" <%if rs1("bestbook")=1 then%>checked<%end if%>>
推荐</div></td>
<td width="173" align="center" valign="top"> <input type="submit" name="Submit" value="修 改" onClick="return check();"> </td>
<td></td>
</tr>
<tr>
<td height="206"> </td>
<td> </td>
<td> </td>
<td></td>
</tr>
</table>
</td>
</form>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
</td>
</tr>
</table>
<%rs1.close
set rs1=nothing
conn.close
set conn=nothing%>
<br>
</body>
</html>
<SCRIPT LANGUAGE="JavaScript">
<!--
function check()
{
if(checkspace(document.myform.bookname.value)) {
document.myform.bookname.focus();
alert("请输入图书名称！");
return false;
}
}
function checkspace(checkstr) {
var str = '';
for(i = 0; i < checkstr.length; i++) {
str = str + ' ';
}
return (str == checkstr);
}
//-->
</script>
<script>
function regInput(obj, reg, inputStr)
{
var docSel = document.selection.createRange()
if (docSel.parentElement().tagName != "INPUT") return false
oSel = docSel.duplicate()
oSel.text = ""
var srcRange = obj.createTextRange()
oSel.setEndPoint("StartToStart", srcRange)
var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)
return reg.test(str)
}
</script>
<%
function HTMLEncode(fString)
fString = Replace(fString, "</P><P>", CHR(10) & CHR(10))
fString = Replace(fString, "<BR>", CHR(10))
HTMLEncode = fString
end function
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -