⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 admin_itemclassdo.asp

📁 本人仅业余学习一些基础的ASP知识以供系统设计之用,并非专业人员,相关服务器设置、MSSQL/MySQL数据库方面的专业问题请自行解决。 本人仅提供本系统相关的一些技术问题的解释、解答。
💻 ASP
字号:
<!-- #include file="../conn.asp" -->
<!--#include file="../inc/config.asp"-->
<!-- #include file="session.asp" -->
<html>

<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="css.css">
</head>

<body leftmargin="0" topmargin="0" marginwidth="0" marginheight="0">

<div id="topmomo">
	长篇采集系统项目管理</div>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="tborder">
	<tr align="center">
		<td height="30"><a href="Admin_ItemManage.asp">管理首页</a> |
		<a href="Admin_ItemAddNew.asp">添加新项目</a></td>
	</tr>
</table>
<%
Select Case request.querystring("info")
	Case "list"
		Call list()
	Case "save"
		Call save()
	Case "del"
		Call del()
end select 
Sub list()%>
<table width="100%" border="0" align="center" cellpadding="0" cellspacing="1" class="tborder">
	<tr align="center">
		<td colspan="8" height="25" class="thead">采 集 站 点 分 类 映 射 本 地 管 理</td>
	</tr>
	<tr align="center">
		<td height="22" colspan="8" height="25" class="alt2">
		<a href="Admin_Itemclassdo.asp?info=del&ItemID=<%=request.querystring("ItemID")%>">
		删除当前采集站所有分类映射</a></td>
	</tr>
	<tr align="center">
		<td height="22" colspan="8" height="25" class=alt1>说明:获取到的分类名称——试采一部作品,显示的分类名为可以获取到的分类名称(一般为目标站资料页显示的大类或小类名称)</td>
	</tr>
	<tr style="padding: 0px 2px;" align="center" height="22">
		<td width="40%" class="tcat">获取到的分类名称</td>
		<td width="20%" class="tcat">映射到</td>
		<td width="40%" class="tcat">本地分类名称</td>
	</tr>
	<form action="Admin_Itemclassdo.asp?info=save" method="post" name="addform">
		<%
ItemID=request.querystring("ItemID")
set rs=server.createobject("adodb.recordset")
	sql="select list_classid,list_classname,list_typeid from [list_class] order by list_typeid"
	rs.open sql,conn,1,1
	Do while not rs.eof
%><tr height="25">
			<td align="right" class="alt2">
			<input name="name" type="text" value="<%set rsend=connItem.execute("select cname from [classdo] where classid="&rs("list_classid")&" and ItemID="&request.querystring("ItemID")&"")
	    if not(rsend.eof) then%><%=rsend("cname")%><% end if%>" size="25" class="form"></td>
			<td align="center" class=alt1>映射为 → </td>
			<td class=alt2>
			<input name="classname" type="text" value="<%=rs("list_classname")%>" size="25" class="form" disabled>
			<input name="typeid" type="hidden" value="<%=rs("list_typeid")%>">
			<input name="classid" type="hidden" value="<%=rs("list_classid")%>">
			</td>
		</tr>
		<%
	rs.MoveNext
	Loop
	rs.close
%><tr>
			<td height="25" align="center" colspan="8" class=alt3>
			<input type="hidden" name="classdo" value="classdo" size="20">
			<input type="hidden" name="ItemID" value="<%=request.querystring("ItemID")%>" size="20">
			<input type="submit" value="确 定" name="B1" class="button"></td>
		</tr>
	</form>
</table>

</body>

</html>
<%end sub%>
<!-------------------------------------------------------------------------------------->
<%Sub save()

ItemID=request("ItemID")
if ItemID="" Or ItemID=null then
	Response.Write ("<SCRIPT language=JavaScript>alert('错误!\n\n数据传递错误!');javascript:window.close();</SCRIPT>")
	Response.end
End If
cname=trim(request("name"))
nameArray=Split(cname, ",")

typeid=request("typeid")
typeidArray=Split(typeid, ",")

classid=request("classid")
classidArray=Split(classid, ",")

Num = UBound(nameArray)
For i=0 To Num
set rsco=server.createobject("adodb.recordset")
sql="select * from [classdo] where ItemID="&ItemID&" and classid="&classidArray(i)&""
rsco.open sql,connItem,1,3
if rsco.eof and rsco.bof then 
	rsco.addnew
	rsco("ItemID")=ItemID
end if
	rsco("cname")=trim(nameArray(i))
	rsco("typeid")=typeidArray(i)
	rsco("classid")=classidArray(i)
	rsco.Update
rsco.close
set rsco=nothing
Next

	Response.Write ("<SCRIPT language=JavaScript>alert('操作成功!');javascript:window.close();</SCRIPT>")
	Response.end
end sub%>
<!-------------------------------------------------------------------------------------->
<%Sub del()
ItemID=request("ItemID")
if ItemID="" Or ItemID=null then
	Response.Write ("<SCRIPT language=JavaScript>alert('错误!\n\n数据传递错误!');javascript:window.close();</SCRIPT>")
	Response.end
End If
connItem.execute "delete from [classdo] where id in ("&ItemID&") "

	Response.Write ("<SCRIPT language=JavaScript>alert('操作成功!');javascript:window.close();</SCRIPT>")
	Response.end
end sub%>

⌨️ 快捷键说明

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