📄 updateclass.asp
字号:
<!--#include file="inc/inc.asp"-->
<!--#include file="conn.asp"-->
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<!-- saved from url=(0032)http://www.doofan.cn/25175/4400/ -->
<HEAD><TITLE>25175材料网,信息价系统</TITLE>
<%
dim id,fid,title,t,da,zhong
if(request("title")<>"") then
if(request("xiao")<>"") then
fid=request("xiao")
else if(request("zhong")<>"") then
fid=request("zhong")
else if(request("da")<>"") then
fid=request("da")
else
fid=request("sz")
end if
end if
end if
title=request("title")
t=request("sz")
da=request("da")
zhong=request("zhong")
if da=empty then
da=0
end if
if zhong=empty then
zhong=0
end if
sql="update class set title='"&title&"',fid="&fid&",type="&t&",da="&da&",zhong="&zhong&" where id="&request("id")
response.Write(sql)
conn.Execute(sql)
response.write "<script>document.location.href='addclass.asp';</script>"
else
id=trim(request("id"))
set rs=server.createobject("adodb.recordset")
sql="select * from class where id="& id
rs.open sql,conn,1,1
if not rs.eof then
fid=rs("fid")
title=rs("title")
t=rs("type")
zhong=rs("zhong")
da=rs("da")
end if
rs.close
set rs=nothing
end if
%>
<script language="javascript" src="inc/ssq.js"></script>
<SCRIPT language=JavaScript>
var t;
var da;
var zhong;
t=<%=t%>
zhong=<%=zhong%>
da=<%=da%>
//下拉菜单相关代码
var h;
var w;
var l;
var t;
var topMar = 1;
var leftMar = -55;
var space = 1;
var isvisible;
var MENU_SHADOW_COLOR='#BBE0F0'; //定义下拉菜单阴影色
var global = window.document
global.fo_currentMenu = null
global.fo_shadows = new Array
function HideMenu()
{
var mX;
var mY;
var vDiv;
var mDiv;
if (isvisible == true)
{
vDiv = document.all("menuDiv");
mX = window.event.clientX + document.body.scrollLeft;
mY = window.event.clientY + document.body.scrollTop;
if ((mX < parseInt(vDiv.style.left)) || (mX > parseInt(vDiv.style.left)+vDiv.offsetWidth) || (mY < parseInt(vDiv.style.top)-h) || (mY > parseInt(vDiv.style.top)+vDiv.offsetHeight)){
vDiv.style.visibility = "hidden";
isvisible = false;
}
}
}
function ShowMenu(vMnuCode,tWidth) {
vSrc = window.event.srcElement;
vMnuCode = "<table id='submenu' cellspacing=2 cellpadding=2 style='border: 1px #444444 solid;width:"+tWidth+"' onmouseout='HideMenu()'><tr><td nowrap align=right height=20>" + vMnuCode + "</td></tr></table>";
h = vSrc.offsetHeight;
w = vSrc.offsetWidth;
l = vSrc.offsetLeft + leftMar+4;
t = vSrc.offsetTop + topMar + h + space-2;
vParent = vSrc.offsetParent;
while (vParent.tagName.toUpperCase() != "BODY")
{
l += vParent.offsetLeft;
t += vParent.offsetTop;
vParent = vParent.offsetParent;
}
menuDiv.innerHTML = vMnuCode;
menuDiv.style.top = t;
menuDiv.style.left = l;
menuDiv.style.visibility = "visible";
isvisible = true;
makeRectangularDropShadow(submenu, MENU_SHADOW_COLOR, 4)
}
function makeRectangularDropShadow(el, color, size)
{
var i;
for (i=size; i>0; i--)
{
var rect = document.createElement('div');
var rs = rect.style
rs.position = 'absolute';
rs.left = (el.style.posLeft + i) + 'px';
rs.top = (el.style.posTop + i) + 'px';
rs.width = el.offsetWidth + 'px';
rs.height = el.offsetHeight + 'px';
rs.zIndex = el.style.zIndex - i;
rs.backgroundColor = color;
var opacity = 1 - i / (i + 1);
rs.filter = 'alpha(opacity=' + (100 * opacity) + ')';
el.insertAdjacentElement('afterEnd', rect);
global.fo_shadows[global.fo_shadows.length] = rect;
}
}
//读取下拉菜单
var menulists1 = ' '
var rownum=1;
function check(d){
var srt=d.value;
var p=/^[-]?\d+$/;
if (!p.exec(srt)){
alert("请输入有效数字!");
d.focus();
return false;
}
}
function addrow(){
rownum=rownum+1;
document.all.rownum.value=rownum;
var ls_t=document.all("t111");
mynewrow = ls_t.insertRow();
mynewcel4=mynewrow.insertCell();
mynewcel4.innerHTML='<input class=unnamed1_rld id=snum'+rownum+' type=text size=20 name=snum'+rownum+' />';
mynewcell=mynewrow.insertCell();
mynewcell.innerHTML='<input name="data_time'+rownum+'" type="text" value="<%=year(now)%>-<%=month(now)%>-<%=day(now)%>" size="20" id="per_birth" onclick="setday(this)" readonly="true"/>';
mynewcel2=mynewrow.insertCell();
mynewcel2.innerHTML='<input class=unnamed1_rld id=behavior'+rownum+' type=text size=20 name=behavior'+rownum+' />';
mynewcel3=mynewrow.insertCell();
mynewcel3.innerHTML='<input class=unnamed1_rld id=num'+rownum+' onblur="check(this)" type=text size=20 name=num'+rownum+' />';
mynewcel4=mynewrow.insertCell();
mynewcel4.innerHTML='<input class=unnamed1_rld id=bz'+rownum+' type=text size=20 name=bz'+rownum+' />';
}
function delrow(){
var ls_t=document.all("t111");
ls_t.deleteRow(ls_t.rows.length-1);
}
</SCRIPT>
<META http-equiv=Content-Type content="text/html; charset=gb2312"><LINK
href="images/25175css_pro.css" type=text/css rel=stylesheet>
<META content="MSHTML 6.00.2900.3243" name=GENERATOR>
<link rel="stylesheet" href="style.css">
</HEAD>
<BODY onmousemove=HideMenu() bgColor=#fbfdff leftMargin=0 topMargin=0
marginheight="0" marginwidth="0">
<!--#include file="top.asp"-->
<TABLE cellSpacing=0 cellPadding=0 width=970 border=0>
<TBODY>
<TR>
<TD width=10>
<DIV align=center></DIV></TD></TR>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD vAlign=top bgColor=#a5bec6 rowSpan=2>
<TABLE cellSpacing=1 cellPadding=0 width=970 border=0>
<TBODY>
<TR>
<TD bgColor=#e7f3ff>
<TABLE cellSpacing=4 cellPadding=0 width=750 border=0>
<TBODY>
<TR>
<TD vAlign=top bgColor=#004194 height=300>
<TABLE cellSpacing=1 cellPadding=0 width=970 border=0>
<TBODY>
<TR>
<TD vAlign=top bgColor=#ffffff height=400>
<TABLE cellSpacing=0 cellPadding=2 width="100%"
align=center border=0>
<TBODY>
<TR>
<TD align="center"><IMG height=18
src="images/face5.gif" width=18>
<STRONG> <a href="addcl.asp">材料添加</a></STRONG>
<STRONG> <a href="addclass.asp">类别添加</a></STRONG>
<STRONG> <a href="setstatus.asp">设置字段</a></STRONG>
<STRONG> <a href="http://www.25175.com/help/flash/qgzj/1.swf" target="_blank">查询设置</a></STRONG>
<STRONG> <a href="showinfo.asp">综合版</a></STRONG>
<STRONG> <a href="showinfo1.asp">商情版</a></STRONG><STRONG> <a href="http://www.25175.com/help/flash/qgzj/2.swf" target="_blank">导入</a></STRONG> <STRONG> <a href="manageuser.asp">用户管理</a></STRONG>
</TD>
</TR>
<TR>
<TD>
<TABLE cellSpacing=0 cellPadding=0 width="70%"
align=center border=0 height=5>
<TBODY>
<TR>
<TD><FORM id=form3 name=form3 action=updateclass.asp method=post>
<table id="t111" cellspacing=0 cellpadding=2 width="70%"
align=center border=0>
<tbody>
<tr>
<TD height=23 align="right" width="26%" >父类名称：</TD>
<TD height=23 align="left" width="74%" ><select name="sz" onchange="getda(this.value)" >
<option value="">请选择</option>
<option value="2" <%if t=2 then response.write("selected") end if%>>商情版</option>
<option value="1" <%if t=1 then response.write("selected") end if%>>综合版</option>
</select>
<select name="da" onchange="getzhong(this.value)" >
<option value="">请选择</option>
</select>
<select name="zhong" >
<option value="">请选择</option>
</select>
</TD>
</tr>
<tr>
<TD height=23 align="right" width="26%" >子类名称：</TD>
<TD height=23 align="left" width="74%" ><input name="title" type="text" value="<%=title%>" size="40"/></TD>
</tr>
<tr>
<TD height=23 align="right" width="26%" ><input type="hidden" name="id" value="<%=id%>"/></TD>
<TD height=23 align="left" width="74%" ><DIV align="left">
<input name="submit" type="submit" value="修改"/>
<INPUT type="button" value=返回 onclick="javascript:document.location.href='addclass.asp'" name=Submit>
</DIV></TD>
</tr>
</tbody>
</table>
</FORM></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD> </TD>
</TR>
<TR>
<TD> </TD>
</TR>
</TBODY></TABLE></TD></TR></TBODY></TABLE>
</TD>
</TR>
</TBODY>
</TABLE>
</TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD>
<DIV align=center></DIV></TD></TR>
<TR>
<TD width=10>
<DIV align=center></DIV></TD></TR>
<TR>
<TD bgColor=#b1d6e4 height=25>
<TABLE cellSpacing=0 cellPadding=0 width="100%" border=0>
<TBODY>
<TR>
<TD bgColor=#b1d6e4 height=25> Copyright © 2007-2010 25175材料网 All
rights reserved. Powered by <A title=25175你我一起舞
href="http://www.25175.com/"
target=_blank>25175</A></TD></TR></TBODY></TABLE></TD></TR>
<TR>
<TD> </TD></TR></TBODY></TABLE> <script>
function getzhong(did){
var zhong=document.all("zhong");
for(i=zhong.length-1;i>0;i--){
zhong.options.remove(i);
}
var xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async="false" ;
xmlDoc.load("xml/class.xml");
if (xmlDoc.parseError.errorCode!=0)
{
alert("文件不存在");
}
var xmlNodes=xmlDoc.selectNodes("/root/info");
var recordCount=xmlNodes.length;
var i,f,yyt="";
for(i=0;i<recordCount;i++){
var node=xmlNodes[i];
var id=node.selectSingleNode("id").text;
var title=node.selectSingleNode("title").text;
var fid=node.selectSingleNode("fid").text;
if( fid==did)
zhong.options.add(new Option(title,id));
}
}
function getda(did){
var zhong=document.all("zhong");
var da=document.all("da");
for(i=zhong.length-1;i>0;i--){
zhong.options.remove(i);
}
for(i=da.length-1;i>0;i--){
da.options.remove(i);
}
var xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async="false" ;
xmlDoc.load("xml/class.xml");
if (xmlDoc.parseError.errorCode!=0)
{
alert("文件不存在");
}
var xmlNodes=xmlDoc.selectNodes("/root/info");
var recordCount=xmlNodes.length;
var i,f,yyt="";
for(i=0;i<recordCount;i++){
var node=xmlNodes[i];
var id=node.selectSingleNode("id").text;
var title=node.selectSingleNode("title").text;
var fid=node.selectSingleNode("fid").text;
if( fid==did)
da.options.add(new Option(title,id));
}
}
function getxiao(did){
var xiao=document.all("xiao");
for(i=xiao.length-1;i>0;i--){
xiao.options.remove(i);
}
var xmlDoc=new ActiveXObject("Microsoft.XMLDOM");
xmlDoc.async="false" ;
xmlDoc.load("xml/class.xml");
if (xmlDoc.parseError.errorCode!=0)
{
alert("文件不存在");
}
var xmlNodes=xmlDoc.selectNodes("/root/info");
var recordCount=xmlNodes.length;
var i,f,yyt="";
for(i=0;i<recordCount;i++){
var node=xmlNodes[i];
var id=node.selectSingleNode("id").text;
var title=node.selectSingleNode("title").text;
var fid=node.selectSingleNode("fid").text;
if( fid==did)
xiao.options.add(new Option(title,id));
}
}
getda(t);
getzhong(da);
if(da!=0)
document.all("da").value = da;
if(zhong!=0)
document.all("zhong").value = zhong;
</script></BODY></HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -