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

📄 updateattribute2.asp

📁 投资管理系统, asp+ mssql server
💻 ASP
字号:
<%
response.expires=-1
dim ThisKey
ThisKey = "c"
%>
<!--#include file="../inc/permission.asp"-->
<!--#include file="../inc/conn.asp"-->
<html>
<head>
<title>修改类别</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel=stylesheet href="../css/main.css" type="text/css">
</head>
<%
ID=trim(request("ID"))
ID2=trim(request("ID2"))
if request("submit")<>"" then
	Attribute=replace(trim(request("Attribute")),"'","''")
	set rs=server.createobject("adodb.recordset")
	sql="select * from tblAttribute2 where Attribute='"&Attribute&"' and ID<>"&ID2
	rs.open sql,conn
	if not rs.eof then
		bFind=true
	else
		bFind=false
	end if
	rs.close

	if bFind then
		response.write "该属性已经存在 <a href=""javascript:history.back(-1);"">[返回]</a>"
		conn.close
		set conn=nothing
		response.end
	else
		conn.execute "Update tblAttribute2 set Attribute='"&Attribute&"' where ID="&ID2
		conn.close
		set conn=nothing
%>
		<form name="returnform" action="Attribute2.asp" method="post" target="FrmRight">
		<INPUT TYPE="hidden" name="ID" value="<%=ID%>">
	    <Script language="JavaScript">
	      returnform.submit();
	    </Script>
	    </form>
<%
		response.write "修改成功!<a href=# onclick=""javascript:window.close();"">[关闭窗口]</a>"
	end if
else
	set rs=server.createobject("adodb.recordset")
	sql="select * from tblAttribute2 where ID="&ID2
	rs.open sql,conn,1,2
	Attribute=trim(rs("Attribute"))
	Daihao=trim(rs("Daihao"))
	rs.close

%>
<BODY BGCOLOR="#FFFFCC">
<form name="SubmitForm" method="post" action="">
属性名称:<INPUT TYPE="text" NAME="Attribute" value="<%=Attribute%>" class="input" size=30 maxlength=100> 
<br>属性编号:<%=Daihao%> 
<BR>
<div align=center><INPUT TYPE="submit" name="submit" value="修 改" onclick="return CheckData();" class="font9boldwhite">
<input type="button" name="exit" value="退 出" class="font9boldwhite" onclick="javascript:window.close();"></div>
<INPUT TYPE="hidden" name="ID" value="<%=ID%>">
<INPUT TYPE="hidden" name="ID2" value="<%=ID2%>">
</form>
</BODY>
<%end if%>
</HTML>

<script language=javascript>
function CheckData()
{	
	if(jtrim(document.SubmitForm.Attribute.value)==""){
		alert("请输入属性名称!");
		document.SubmitForm.Attribute.focus();
		return false;
	}
}
</script>
<script language=javascript src="../inc/jtrim.js"></script>

⌨️ 快捷键说明

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