📄 addbook.asp

📁 晴和教务管理系统
💻 ASP
字号:
<!--#include file="../inc/conn.asp"-->
<!--#include file="../inc/function.asp"-->
<%
dim action
action=request.QueryString("action")
select case action
case ""
%>
<html><head><title>教务管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="../css.css" rel="stylesheet" type="text/css">
</head>
<body style="background-color: #799AE1">
<table class="tableBorder" width="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr> 
<td colspan="2" align="center" background="images/admin_bg_1.gif" height="25"><b><font color="#ffffff">教务管理—添加教材</font></b></td>
</tr>
<form name="bookinfo" method="post" action="addbook.asp?action=save">
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">书　名：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="bookname" type="text" id="Topic" size="40">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">主　编：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="zb" type="text" id="Topic" size="20">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">出版社：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="cbs" type="text" id="Topic" size="40">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">经　销：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="jx" type="text" id="Topic" size="40">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">印　刷：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="ys" type="text" id="Topic" size="40">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">定　价：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="dj" type="text" id="Topic" size="10">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">库　存：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="kc" type="text" id="Topic" size="10">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">类　型：</td>
    <td width="80%" bgcolor="#E8F1FF">
    <select size="1" name="lx">
	<option selected value="教材">教材</option>
	<option value="选修课教材">选修课教材</option>
	<option value="辅导资料">辅导资料</option>
	<option value="课外书">课外书</option>
    </select>
    </td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">ISBN：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="isbn" type="text" id="Topic" size="20">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">内容提要：</td>
    <td width="80%" bgcolor="#E8F1FF">
<textarea class="wenbenkuang" name="ty" cols="80" rows="20" id="Body">
</textarea>
</td>
</tr>
<tr>
<td bgcolor="#E8F1FF"></td>
<td bgcolor="#E8F1FF"> 
<input class="go-wenbenkuang" name="submit" value=确认添加 type=submit onClick="return checkup();">
</td>
</tr>
</form>
</table>
<%
case "edit"
bookid=request.QueryString("bookid")
session("bookid")=request.QueryString("bookid")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_book where bookid="&bookid,conn,1,3
%>
<html><head><title>教务管理系统</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link href="/css.css" rel="stylesheet" type="text/css">
</head>
<body style="background-color: #799AE1">
<table class="tableBorder" width="90%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#FFFFFF">
<tr> 
<td colspan="2" align="center" background="images/admin_bg_1.gif" height="25"><b><font color="#ffffff">教务管理—添加教材</font></b></td>
</tr>
<form name="bookinfo" method="post" action="addbook.asp?action=editsave&bookid=<% =rs("bookid")%>">
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">书　名：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="bookname" type="text" id="Topic" size="40" value="<% =rs("bookname")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">主　编：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="zb" type="text" id="Topic" size="20" value="<% =rs("zb")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">出版社：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="cbs" type="text" id="Topic" size="40" value="<% =rs("cbs")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">经　销：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="jx" type="text" id="Topic" size="40" value="<% =rs("jx")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">印　刷：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="ys" type="text" id="Topic" size="40" value="<% =rs("ys")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">定　价：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="dj" type="text" id="Topic" size="10" value="<% =rs("dj")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">库　存：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="kc" type="text" id="Topic" size="10" value="<% =rs("kc")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">类　型：</td>
    <td width="80%" bgcolor="#E8F1FF">
    <select size="1" name="lx">
	<option value="教材" <% If rs("lx") = "教材" Then response.write "selected"%>>教材</option>
	<option value="选修课教材" <% If rs("lx") = "选修课教材" Then response.write "selected"%>>选修课教材</option>
	<option value="学习资料" <% If rs("lx") = "学习资料" Then response.write "selected"%>>学习资料</option>
	<option value="课外书" <% If rs("lx") = "课外书" Then response.write "selected"%>>课外书</option>
    </select>
    </td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">ISBN：</td>
    <td width="80%" bgcolor="#E8F1FF">
	<input class="wenbenkuang" name="isbn" type="text" id="Topic" size="20" value="<% =rs("isbn")%>">
</td>
</tr>
<tr> 
<td width="20%" bgcolor="#E8F1FF" align="center">内容提要：</td>
    <td width="80%" bgcolor="#E8F1FF">
<script language="javascript">
document.write ('<iframe src="textbox.asp?action=addbook" id="message" width="500" height="300"></iframe>')
frames.message.document.designMode = "On";
</script>
</td>
</tr>
<tr>
<td bgcolor="#E8F1FF"></td>
<td bgcolor="#E8F1FF"> 
<input class="wenbenkuang" name="ty" type="hidden" value="">
<input class="go-wenbenkuang" name="submit" value=确认修改 type=submit OnClick="document.bookinfo.ty.value = frames.message.document.body.innerHTML;">
</td>
</tr>
</form>
</table>
<%
rs.close
set rs=nothing

case "save"
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_book",conn,1,3
rs.addnew
rs("bookname")=trim(request("bookname"))
rs("zb")=request("zb")
rs("cbs")=request("cbs")
rs("jx")=request("jx")
rs("ys")=request("ys")
rs("dj")=request("dj")
rs("isbn")=request("isbn")
rs("kc")=request("kc")
rs("lx")=request("lx")
rs("ty")=htmlencode(trim(request("ty")))
rs("adddate")=now()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "ok.asp?ok=添加书籍"


case "editsave"
bookid=request("bookid")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_book where bookid="&bookid,conn,1,3
rs("bookname")=trim(request("bookname"))
rs("zb")=request("zb")
rs("cbs")=request("cbs")
rs("jx")=request("jx")
rs("ys")=request("ys")
rs("dj")=request("dj")
rs("isbn")=request("isbn")
rs("kc")=request("kc")
rs("lx")=request("lx")
rs("ty")=htmlencode(trim(request("ty")))
rs("adddate")=now()
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "ok.asp?ok=修改书籍"


case "lock"
bookid=request("bookid")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_book where bookid="&bookid,conn,1,3
rs("lock")=1
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "ok.asp?ok=隐藏书籍"


case "unlock"
bookid=request("bookid")
set rs=server.CreateObject("adodb.recordset")
rs.open "select * from Jw_book where bookid="&bookid,conn,1,3
rs("lock")=0
rs.update
rs.close
set rs=nothing
conn.close
set conn=nothing
response.redirect "ok.asp?ok=显示隐藏书籍"


case "del"
bookid=request("bookid")
conn.execute "delete from Jw_book where bookid="&bookid
conn.close
set conn=nothing
response.redirect "ok.asp?ok=删除书籍"

end select
%>

<SCRIPT LANGUAGE="JavaScript">
function checkspace(checkstr) {
  var str = '';
  for(i = 0; i < checkstr.length; i++) {
    str = str + ' ';
  }
  return (str == checkstr);
}

function checkup()
{
   if(checkspace(document.newsinfo.newsname.value)) {
	document.newsinfo.newsname.focus();
    alert("新闻标题不能为空！");
	return false;
  }
   if(checkspace(document.newsinfo.newscontent.value)) {
	document.newsinfo.newscontent.focus();
    alert("新闻内容不能为空！");
	return false;
  }
}

function MM_goToURL() { //v3.0
  var i, args=MM_goToURL.arguments; document.MM_returnValue = false;
  for (i=0; i<(args.length-1); i+=2) eval(args[i]+".location='"+args[i+1]+"'");
}

function MM_openBrWindow(theURL,winName,features) { //v2.0
  window.open(theURL,winName,features);
}
//-->
</script>
<script  language="JavaScript">
<!-- Hide from older browsers...

//Function to format text in the text box
function FormatText(command, option){
	
  	frames.message.document.execCommand(command, true, option);
  	frames.message.focus();
}

//Function to add image
function AddImage(){	
	imagePath = prompt('请输入图片地址', 'http://');				
	
	if ((imagePath != null) && (imagePath != "")){					
		frames.message.document.execCommand('InsertImage', false, imagePath);
  		frames.message.focus();
	}
	frames.message.focus();			
}

//Function to clear form
function ResetForm(){

	if (window.confirm('确认要清空对话框内容?')){
	 	frames.message.document.body.innerHTML = ''; 
	 	return true;
	 } 
	 return false;		
}

//Function to open pop up window
function openWin(theURL,winName,features) {
  	window.open(theURL,winName,features);
}

function setMode(newMode)
{
  bTextMode = newMode;
  var cont;
  if (bTextMode) {
    cleanHtml();
    cleanHtml();

    cont=message.document.body.innerHTML;
    message.document.body.innerText=cont;
  } else {
    cont=message.document.body.innerText;
    message.document.body.innerHTML=cont;
  }
  message.focus();
}

function cleanHtml()
{
  var fonts = message.document.body.all.tags("FONT");
  var curr;
  for (var i = fonts.length - 1; i >= 0; i--) {
    curr = fonts[i];
    if (curr.style.backgroundColor == "#ffffff") curr.outerHTML	= curr.innerHTML;
  }

}

// -->
</script>
<script language="JavaScript">

function help()
{
    var helpmess;
    helpmess="---------------填写帮助---------------\r\n\r\n"+
         "1.请不要发表有危险性的脚本。\r\n\r\n"+
         "2.如果要书写源代码，请选中\r\n\r\n"+
         "　查看HTML源代码书写.\r\n\r\n"+
         "3.需要你自己运行,才能看效果.\r\n\r\n"+
         "4.如果书写js，尽量不要在这儿书写.\r\n\r\n";
    alert(helpmess);
}
⌨️ 快捷键说明

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