📄 invest_title_edit.asp

📁 ASP网页
💻 ASP
字号:
<%@ Language=VBScript%>
<%
Response.Buffer=false
Response.Expires=0

if Session("userqx")="1" or Session("userqx")="9" then
else
	Response.Redirect "../warn.asp"
end if

keyno=Request.QueryString("keyno")
parentno=Request.QueryString("parentno")

if keyno="" then keyno="0"

htmlname="invest_title_edit.asp?keyno="+keyno+"&parentno="+parentno
backhtml="invest_title_admin.asp?parentno="+parentno

%>
<!-- #include file="../dsn.asp" -->
<html>
<head>
<title></title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style type="text/css">
<!--
body {font-size: 12px; color: #000; font-family: 宋体}
td {font-size: 12px; color: #000; font-family: 宋体;line-height:130%}

.t1 {font:12px 宋体;color=000000} 
.t2 {font:12px 宋体;color:ffffff} 
.t3 {font:12px 宋体;color:336699} 
.t4 {font:12px 宋体;color:ff0000} 
.bt1 {font:14px 宋体;color=000000} 
.bt2 {font:14px 宋体;color:ffffff} 
.bt3 {font:14px 宋体;color:336699} 
.bt4 {font:bold 16px 宋体;color:maroon} 

.td1 {font-size:12px;line-height:24px;text-align:right;background-color:#efefef;color:#000000}
.td2 {font-size:12px;line-height:24px;text-align:left;background-color:#ffffff;color:#000000;}
.td3 {font-size:12px;line-height:24px;text-align:left;background-color:#ffffff;color:#000000;}

A:link {color: #000077}
A:visited {color: #000077}
A:hover {color: #ff0000}

A.title1:link {text-decoration:none;color:#000000;}
A.title1:visited {text-decoration:none;color:#000000;}
A.title1:active {text-decoration:none;color:#ff0000;}
A.title1:hover {font-size:13px;text-decoration:none;color:#ff0000;}
-->
</style>
</head>

<body bgcolor=#ffffff topmargin=10>
<form action="<%=htmlname%>" method=post name=form1 onsubmit="return checkform()" autocomplete = "off">
<%
bz=1
set cn = Server.CreateObject("ADODB.Connection")
cn.Open(mycnstr)
set rs = Server.CreateObject("ADODB.Recordset")
set rs2 = Server.CreateObject("ADODB.Recordset")

if Request.ServerVariables("REQUEST_METHOD")="POST" then
	bz=0
	title=trim(Request.Form("title"))
	sortnum=Request.Form("sortnum")
	
	if bz=0 then
		if keyno="0" then
			sqltext="select top 1 keyno from investigate order by keyno desc"
			rs.Open sqltext,cn,1,1
			if rs.EOF then
				keyno=1
			else
				keyno=rs(0)+1
			end if
			rs.Close
			if sortnum="" or not isnumeric(sortnum) then
				sqltext="select top 1 sortnum from investigate where parentno="&parentno&" order by sortnum desc"
				rs.Open sqltext,cn,1,1
				if rs.EOF then
					sortnum=1	
				else
					sortnum=rs(0)+1
				end if
				rs.Close
			end if
			rs.Open "investigate",cn,3,3
			rs.AddNew
			rs("keyno")=keyno
			rs("flag")="1"
			rs("parentno")=parentno
		else	
			rs.Open "select * from investigate where keyno="&keyno,cn,3,3
		end if	
		if isnumeric(sortnum) then	rs("sortnum")=sortnum
		rs("title")=title
		
		rs.Update()
		Response.Write("<script language=Javascript>")
		Response.Write("window.location.href='"+backhtml+"'")
		Response.Write("</script>")
	end if
else
	if keyno="0" then
	else
		sqltext="select * from investigate where keyno="&keyno
		rs.Open sqltext,cn,1,1
		title=trim(rs("title"))
		sortnum=rs("sortnum")
	end if
end if	
if bz=1 or bz=2 or bz=3 then
 %>
 <table width="100%" border="0" cellspacing="0" cellpadding="0" align="center">
	<tr>
	<td>&nbsp;<b>网上调查表题目维护</b>&nbsp;←&nbsp;<a href="<%=backhtml%>">返回列表</a>
	</td></tr>
 </table>
 
 <table width="100%" border="0" cellspacing="1" cellpadding="3" align="center">
	<tr></td>
	<tr bgcolor=ffdfbf><td colspan=2><font class=t1>具体内容</font><br>
	</td></tr>
	<tr><td class=td1 width=90>序号</td>
		<td class=td2><INPUT type="text" value="<%=sortnum%>" name=sortnum maxlength=10 size=10>
		<font class=td3>根据此序号由小到大排序</font>
		</td></tr>
	<tr><td class=td1>题目名称</td>
		<td class=td2><INPUT type="text" value="<%=title%>" name=title maxlength=80 size=50><font color=red>*</font>
		</td></tr>
	<tr><td class=td2 bgcolor=ffffff ></td><td class=td2 bgcolor=ffffff align=middle><br>
	&nbsp;&nbsp;&nbsp;&nbsp;<input type="submit" name="submit" value="确认提交" onclick="checkinput(form1)">&nbsp;&nbsp;&nbsp;&nbsp;
	</td></tr>
	</table>
</td></tr>
</table>	
	<script language=Javascript>
		form1.title.focus()
	</script>
<%
end if
%>
</form>
<body>
</html>
<script language=Javascript>
	var flag=true;
	function checkform()
	{
		return flag;
	}
	
	function checkinput(form)
	{

		if(form("title").value=="")
			{alert("请输入题目名称!");form("title").focus();flag=false;return}else{flag=true}	
	}
	
</script>
⌨️ 快捷键说明

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