📄 updatecl.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 url,t,fid,id,city1,city2,city3,cl_bh,cl_title,cl_xh,cl_dw,cl_zhj,cl_ajg,cl_bjg,cl_cjg,cl_djg,cl_ejg,cl_fjg,cl_cd,cl_dj,cl_pp,cl_yj,cl_bz1,cl_bz2,cl_bz3,classid,provinceid,cityid,areaid,addtime
if(request("cl_bh")<>"") 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
classid=fid
city1=request("city1")
city2=request("city2")
city3=request("city3")
cl_bh=request("cl_bh")
cl_title=request("cl_title")
cl_xh=request("cl_xh")
cl_dw=request("cl_dw")
cl_zhj=request("cl_zhj")
cl_ajg=request("cl_ajg")
cl_bjg=request("cl_bjg")
cl_cjg=request("cl_cjg")
cl_djg=request("cl_djg")
cl_ejg=request("cl_ejg")
cl_fjg=request("cl_fjg")
cl_cd=request("cl_cd")
cl_dj=request("cl_dj")
cl_pp=request("cl_pp")
cl_yj=request("cl_yj")
cl_bz1=request("cl_bz1")
cl_bz2=request("cl_bz2")
cl_bz3=request("cl_bz3")
sql="update cl set cl_bh='"&cl_bh&"',cl_title='"&cl_title&"',cl_xh='"&cl_xh&"',cl_dw='"&cl_dw&"',cl_zhj='"&cl_zhj&"',cl_ajg='"&cl_ajg&"',cl_bjg='"&cl_bjg&"',cl_cjg='"&cl_cjg&"',cl_djg='"&cl_djg&"',cl_ejg='"&cl_ejg&"',cl_fjg='"&cl_fjg&"',cl_cd='"&cl_cd&"',cl_dj='"&cl_dj&"',cl_pp='"&cl_pp&"',cl_yj='"&cl_yj&"',cl_bz1='"&cl_bz1&"',cl_bz2='"&cl_bz2&"',cl_bz3='"&cl_bz3&"',classid="&classid&",provinceid='"&city1&"',cityid='"&city2&"',areaid='"&city3&"'where id="&request("id")
if(request("type")=1) then
url="showinfo.asp"
else
url="showinfo1.asp"
end if
conn.Execute(sql)
response.write "<script>document.location.href='"&url&"';</script>"
else
id=trim(request("id"))
set rs=server.createobject("adodb.recordset")
sql="select * from cl where id="& id
rs.open sql,conn,1,1
if not rs.eof then
classid=rs("classid")
areaid=rs("areaid")
cl_bh=rs("cl_bh")
cl_title=rs("cl_title")
cl_xh=rs("cl_xh")
cl_dw=rs("cl_dw")
cl_zhj=rs("cl_zhj")
cl_ajg=rs("cl_ajg")
cl_bjg=rs("cl_bjg")
cl_cjg=rs("cl_cjg")
cl_djg=rs("cl_djg")
cl_ejg=rs("cl_ejg")
cl_fjg=rs("cl_fjg")
cl_cd=rs("cl_cd")
cl_dj=rs("cl_dj")
cl_pp=rs("cl_pp")
cl_yj=rs("cl_yj")
cl_bz1=rs("cl_bz1")
cl_bz2=rs("cl_bz2")
cl_bz3=rs("cl_bz3")
t=request("type")
end if
rs.close
set rs=nothing
end if
%>
<script language="javascript" src="inc/ssq.js"></script>
<SCRIPT language=JavaScript>
//下拉菜单相关代码
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>
<FORM id=form3 name=form3 action=updatecl.asp method=post>
<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>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -