help!!!!!!!!!!111
<%@ Language ="Jscript"%>
<!--#include file="common_functions.asp"-->
<%
var conn = Server.CreateObject("Adodb.Connection");
var connStr = "driver={SQL Server};SERVER=wei;UID=sa;PWD=065191;DATABASE=jr"
var nameAry = new Array();
var priceAry = new Array();
conn.open (connStr,"sa","065191");
var oprHTML =_getSelectHTML();
var oprHTML2 =_getSelectHTML2();
function _getSelectHTML()
{
var res =""
var rs = getRsBySql("select * from bjinfo");
var curid = parseInt(Request("bujian").Item);
while (!rs.EOF)
{
var SlectedStr="";
if (curid == rs("id").Value) SlectedStr = " selected";
res += "<option value =\"" +rs("id").Value + "\" price=\"" + rs("price").value + "\"" +SlectedStr +">" + rs("bujianming").value +"</option>";
nameAry[nameAry.length]= new Array(rs("id").Value,rs("bujianming").Value);
priceAry[priceAry.length] =new Array(rs("id").Value,rs("price").Value);
rs.MoveNext();
}
rs.Close();
rs = null;
return res;
}
function _getSelectHTML2()
{
var res =""
var rs = getRsBySql("select * from dls");
var curid = parseInt(Request("dls").Item);
while (!rs.EOF)
{
var SlectedStr="";
if (curid == rs("dls_id").Value) SlectedStr = " selected";
res += "<option value =\"" +rs("dls_id").Value + "\"" +SlectedStr +">" + rs("dls_mc").value +"</option>";
nameAry[nameAry.length]= new Array(rs("dls_id").Value,rs("dls_mc").Value);
rs.MoveNext();
}
rs.Close();
rs = null;
return res;
}
%>
<html>
<body bgcolor="#EBEBEB" leftmargin="0" topmargin="10" marginwidth="0" marginheight="0"><head >
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<style>
body {
font-size:12px;
}
Select{
font-size:12px;
}
</style>
</head>
<form name="form1" method="post" action="xuhao.asp?id=<%=request("id")%>">
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="64" height="68" background="image/j1.gif"> </td>
<td width="476" background="image/j2.gif">
<div align="center"> <span style="font-size: 9pt">部件序号列表 </span></div>
</td>
<td width="60" height="68" background="image/j3.gif"> </td>
</tr>
</table>
<table width="600" border="0" align="center" cellpadding="0" cellspacing="0">
<tr>
<td width="18" height="21" background="image/j4.gif"> </td>
<td width="564"><table width="564" border="0" cellpadding="0" cellspacing="0">
<tr bgcolor="68AF77">
<td height="30" bgcolor="#EBEBEB"><span style="font-size: 9pt">
部件:</span><select name="bujian" onchange ="return changeSelect();">
<option value=-1>请选择部件</option>
<%=oprHTML%> </select><span style="font-size: 9pt">
型号:</span><select name="prod" onChange="calc();">
<option value=-1>没有选择</option>
</select><span style="font-size: 9pt">
</td>
</tr>
<tr bgcolor="68AF77">
<td height="30" bgcolor="#EBEBEB"><span style="font-size: 9pt">
<input type=submit style="border-style:solid; border-width:1; BACKGROUND-COLOR: #3F6090; COLOR: #FFFFFF; FONT-SIZE: 9pt; vertical-align:baseline; height:20" value="修改部件" name="Submit" >
</span> </td>
</tr>
<tr bgcolor="68AF77">
<td height="30" bgcolor="#EBEBEB"> <span style="font-size: 9pt"> </span><span style="font-size: 9pt"> </span></td>
</tr>
<tr bgcolor="68AF77">
<td height="25" bgcolor="#EBEBEB"><span style="font-size: 9pt">
</span> </td>
</tr>
<tr bgcolor="68AF77">
<td height="25" bgcolor="#EBEBEB"> </td>
</tr>
<tr bgcolor="68AF77">
<td height="25" bgcolor="#EBEBEB"> </td>
</tr>
<tr bgcolor="68AF77">
<td height="25" bgcolor="#EBEBEB"> </td>
</tr>
<tr bgcolor="68AF77">
<td height="25" bgcolor="#EBEBEB"> </td>
</tr>
<tr bgcolor="68AF77">
<td height="20" bgcolor="#EBEBEB"> </td>
</tr>
<tr bgcolor="68AF77">
<td height="15" bgcolor="#EBEBEB"> </td>
</tr>
</table></td>
<td width="18" height="21" background="image/j5.gif"> </td>
</tr>
<tr>
<td width="18" height="19"><span style="font-size: 9pt"><img src="image/j6.gif" width="18" height="19"></span></td>
<td background="image/j7.gif"> </td>
<td width="18" height="19"><span style="font-size: 9pt"><img src="image/j8.gif" width="18" height="19"></span></td>
</tr>
</table>
</form>
<br>
<span style="font-size: 9pt">
<input type=hidden name=hd value=0>
<input type=hidden name=type value=0>
<input type=hidden name=price value=0>
<script language="javascript">
var ary = new Array()
{
<%
var rs = getRsBySql("select * from product");
while (!rs.EOF)
{
Response.write("ary[ary.length] = new Array(" + rs("id").value +"," + rs("price").value +",\""+rs("pdesc").value+"\"," +rs("type_id").value+ ");\n");
rs.MoveNext();
}
rs.Close();
rs = null;
%>
}
function calc()
{
//changeSelect();
//var price =parseInt(form1.bujian.options[form1.bujian.selectedIndex].price);
var prod_id = parseInt(document.form1.prod.value);
var price =0;
for (var i=0;i<ary.length;i++)
{
if (prod_id== ary[i][0])
{
break;
}
}
}
function changeSelect()
{
calc
var i= parseInt(document.all.bujian.value);
document.form1.prod.length =0;
for (var j=0;j<ary.length;j++)
{
if ( i==parseInt(ary[j][3]))
{
document.form1.prod.options[document.form1.prod.length] = new Option(ary[j][2],ary[j][0]);
}
}
}
</script>
</span>
</body>
</html>