editbook.asp

asp的网上卖东西的..看看还可以的吧

<form name="myform" method="post" action="saveaddgood.asp?action=edit&id=<%=bookid%>">
<td> 
                                <table width="100%" border="0" align="center" cellpadding="5" cellspacing="1" bgcolor="#FFFFFF">
                                  <tr > 
                                    <td width="30%" align="right">选择分类：</td>
                                    <td>大类：
									<%dim rs1
set rs1=server.CreateObject("adodb.recordset")
rs1.open "select * from BJX_goods where bookid="&bookid,conn,1,1

    rs.open "select * FROM BJX_class1 order by anclassidorder",conn,1,1
	if rs.eof and rs.bof then
	response.write "请先添加栏目。"
	response.end
	else
%>
                                      <select name="anclassid" size="1" id="anclassid" onChange="changelocation(document.myform.anclassid.options[document.myform.anclassid.selectedIndex].value)">
<% 
        do while not rs.eof
%>
                                        <option value="<%=rs("anclassid")%>" <%if rs1("anclassid")=rs("anclassid") then%>selected<%end if%>><%=trim(rs("anclass"))%></option>
                                        <%
        rs.movenext
        loop
		end if
        rs.close
%>
                                      </select>
                                      小类： 
                                      <select name="Nclassid">
                                        <%rs.open "select * FROM BJX_class2 where anclassid="&rs1("anclassid") ,conn,1,1
do while not rs.eof%>
                                        <option value="<%=rs("NclassID")%>" <%if rs1("nclassid")=rs("nclassid") then%>selected<%end if%>><%=rs("Nclass")%></option>
                                        <% rs.movenext
loop
        rs.close
        set rs = nothing
        
%>
                                      </select>
                                      </td>
                                  </tr>
                                  <tr > 
                                    <td align="right"><input type="text" name="mch" size="12" value="<%=rs1("mch")%>"></td>
                                    <td> 
                                      <input name="bookname" type="text" id="bookname" size="30" value="<%=trim(rs1("bookname"))%>"> 浮动价 
                                      <select name="fudongjia" size=1>
                                        <%set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from BJX_postcost order by id ",conn,1,1
if rs_s.recordcount=0 then
response.write "请先添加浮动价"
else
while not rs_s.eof
%>
                                        <option value=<%=rs_s("id")%><%if rs1("banci")=rs_s("id") then%> selected<%end if%>><%=rs_s("shuoming")%></option>
                                        <%
rs_s.movenext
wend
end if
rs_s.close
set rs_s=nothing%>
                                      </select>
                                    </td>
                                  </tr>
                                  <tr > 
                                    <td align="right"><input type="text" name="pp" size="12" value="<%=rs1("pp")%>"></td>
                                    <td>
									<input name="pingpai" type="text" id="pingpai" value="<%=trim(rs1("pingpai"))%>">
                                      <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from BJX_pingpai order by pingpaiorder ",conn,1,1
%>
                                      <select name="select" onChange="(document.myform.pingpai.value=this.options[this.selectedIndex].value)">
                                        <option selected>请选择品牌</option>
                                        <%
while not rs_s.eof
%>
                                        <option value="<%=rs_s("pingpainame")%>"><%=rs_s("pingpainame")%></option>
                                        <%
rs_s.movenext
wend
rs_s.close
set rs_s=nothing
%>
                                      </select>
                                    </td>
                                  </tr>
                                  <tr > 
                                  <td align="right"><input type="text" name="isbn1" size="12" value="<%=rs1("isbn1")%>"></td>
								  <td>
								  <input name="isbn" type="text" id="isbn" value="<%=trim(rs1("isbn"))%>"></td>
                                  </tr>
                                  <tr > 
                                  <td align="right"><input type="text" name="jj" size="12" value="<%=rs1("jj")%>"></td>
								  <td>
								  <input name="bookchuban" type="text" id="bookchuban" size="8" value="<%=trim(rs1("bookchuban"))%>">
                                      <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from BJX_danwei order by danweiorder ",conn,1,1
%>
                                      <select name="select2" onChange="(document.myform.bookchuban.value=this.options[this.selectedIndex].value)">
                                        <option selected>请选择单位</option>
                                        <%
while not rs_s.eof
%>
                                        <option value="<%=rs_s("danweiname")%>"><%=rs_s("danweiname")%></option>
                                        <%
rs_s.movenext
wend
rs_s.close
set rs_s=nothing
%>
                                      </select>
                                    </td>
                                  </tr>
                                  <tr > 
                                  <td align="right">
								  <input type="text" name="jg" size="12" value="<%=rs1("jg")%>">
                                    </td>
                                    <td>
		市场价：<input name="shichangjia" type="text" id="shichangjia" size="6" onKeyPress	= "return regInput(this,	/^\d*\.?\d{0,2}$/,		String.fromCharCode(event.keyCode))" 
		onpaste		= "return regInput(this,	/^\d*\.?\d{0,2}$/,		window.clipboardData.getData('Text'))"
		ondrop		= "return regInput(this,	/^\d*\.?\d{0,2}$/,		event.dataTransfer.getData('Text'))" value="<%=rs1("shichangjia")%>">
		会员价：<input name="huiyuanjia" type="text" id="huiyuanjia" size="6" onKeyPress	= "return regInput(this,	/^\d*\.?\d{0,2}$/,		String.fromCharCode(event.keyCode))" 
		onpaste		= "return regInput(this,	/^\d*\.?\d{0,2}$/,		window.clipboardData.getData('Text'))"
		ondrop		= "return regInput(this,	/^\d*\.?\d{0,2}$/,		event.dataTransfer.getData('Text'))" value="<%=rs1("huiyuanjia")%>">
		VIP价：<input name="vipjia" type="text" id="vipjia" size="6" onKeyPress	= "return regInput(this,	/^\d*\.?\d{0,2}$/,		String.fromCharCode(event.keyCode))" 
		onpaste		= "return regInput(this,	/^\d*\.?\d{0,2}$/,		window.clipboardData.getData('Text'))"
		ondrop		= "return regInput(this,	/^\d*\.?\d{0,2}$/,		event.dataTransfer.getData('Text'))" value="<%=rs1("vipjia")%>"></td>
                                  </tr>
                                  <tr > 
                                    <td align="right">
									<input type="text" name="zl" size="12" value="<%=rs1("zl")%>"></td>
                                    <td>
		库 存： <input name="kucun" type="text" id="kucun" value="<%=rs1("kucun")%>" size="6" onKeyPress	= "return regInput(this,	/^[0-9]*$/,		String.fromCharCode(event.keyCode))"
		onpaste		= "return regInput(this,	/^[0-9]*$/,		window.clipboardData.getData('Text'))"
		ondrop		= "return regInput(this,	/^[0-9]*$/,		event.dataTransfer.getData('Text'))" >
		已销售：<input name="chengjiaocount" type="text" id="chengjiaocount" value="<%=rs1("chengjiaocount")%>" size="6" onKeyPress	= "return regInput(this,	/^[0-9]*$/,		String.fromCharCode(event.keyCode))"
		onpaste		= "return regInput(this,	/^[0-9]*$/,		window.clipboardData.getData('Text'))"
		ondrop		= "return regInput(this,	/^[0-9]*$/,		event.dataTransfer.getData('Text'))" readonly>
		积 分：<input name="yeshu" type="text" id="yeshu" value="<%=rs1("yeshu")%>" size="6" onKeyPress	= "return regInput(this,	/^[0-9]*$/,		String.fromCharCode(event.keyCode))"