editsn.asp

这是惠州城市超市购物管理系统的源代码

        rs.close
%>
              </select>
              小类： 
              <select name="Nclassid" class="wenbenkuang">
                <%rs.open "select * from shop_Nclass 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 width="15%"> <div align="center"> 
                <input type="text" name="mch" size="12" value="<%=rs1("mch")%>" class="wenbenkuang">
              </div></td>
            <td colspan="2"> <input name="shopname" class="wenbenkuang" type="text" id="shopname" size="30" value="<%=trim(rs1("shopname"))%>">
              　浮动价 
              <select name="fudongjia" size=1 class="wenbenkuang">
                <%set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * from shop_fudong 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 width="15%"> <div align="center"> 
                <input type="text" name="pp" size="12" value="<%=rs1("pp")%>" class="wenbenkuang">
              </div></td>
            <td colspan="2"> <input name="pingpai" type="text" id="pingpai" class="wenbenkuang" size="20" value="<%=trim(rs1("pingpai"))%>"> 
              <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_pingpai order by pingpaiorder ",conn,1,1
%>
              <select name="select" class="wenbenkuang" 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 width="15%"> <div align="center"> 
                <input type="text" name="isbn1" class="wenbenkuang" size="12" value="<%=rs1("isbn1")%>">
              </div></td>
            <td colspan="2"> <input name="isbn" type="text" class="wenbenkuang" id="isbn" size="30" value="<%=trim(rs1("isbn"))%>"> 
            </td>
          </tr>
          <tr> 
            <td width="15%"> <div align="center"> 
                <input type="text" name="jj" class="wenbenkuang" size="12" value="<%=rs1("jj")%>">
              </div></td>
            <td colspan="2"> <input name="shopchuban" class="wenbenkuang" type="text" id="shopchuban" size="10" value="<%=trim(rs1("shopchuban"))%>"> 
              <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_danwei order by danweiorder ",conn,1,1
%>
              <select name="select2" class="wenbenkuang" onChange="(document.myform.shopchuban.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 valign="top" width="15%"> <div align="center"> 
                <input type="text" class="wenbenkuang" name="jg" size="12" value="<%=rs1("jg")%>">
              </div></td>
            <td colspan="2">市场价 
              <input name="shichangjia" class="wenbenkuang" 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" class="wenbenkuang" 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" class="wenbenkuang" 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 width="15%"> <div align="center"> 
                <input type="text" name="zl" size="12" value="<%=rs1("zl")%>" class="wenbenkuang">
              </div></td>
            <td colspan="2">库存： 
              <input name="kucun" type="text" class="wenbenkuang" id="kucun" value="<%=rs1("kucun")%>" size="8" 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" class="wenbenkuang" id="chengjiaocount" value="<%=rs1("chengjiaocount")%>" size="8" 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" class="wenbenkuang" value="<%=rs1("yeshu")%>" 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'))" > 
            </td>
          </tr>
          <tr> 
                <tr> 
                <td width="15%"> <div align="center"> 
                 <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_ziduan where ziduanorder=11",conn,1,1
%>
           <input type="text"  size="12" value="<%=rs_s("ziduanname")%>" class="wenbenkuang">  
              </div></td>
			<td colspan="2"> <input name="sftc" type="text" id="sftc" size="30" class="wenbenkuang" value="<%=trim(rs1("sftc"))%>">
              <select name="select11" class="wenbenkuang" onChange="(document.myform.sftc.value=this.options[this.selectedIndex].value)">
                < <option selected>请选择是否弹出</option>
                <option value="_blank">弹出</option>
                <option value="">不弹出</option>
              </select>
              （默认为不弹出） </td>
          </tr>
			 <tr> 
             <td width="15%"> <div align="center"> 
                 <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_ziduan where ziduanorder=9 ",conn,1,1
%>
           <input type="text"  size="12" value="<%=rs_s("ziduanname")%>" class="wenbenkuang">  
              </div></td>
			 <td colspan="2"> <input name="sx" type="text" id="sx" size="10" class="wenbenkuang" value="<%=trim(rs1("sx"))%>">
              （升序＊默认为当前数据中最高升序） </td>
          </tr>
			<tr> 
             <td width="15%"> <div align="center"> 
                 <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_ziduan where ziduanorder=10",conn,1,1
%>
           <input type="text"  size="12" value="<%=rs_s("ziduanname")%>" class="wenbenkuang">  
              </div></td>
			 <td colspan="2"> <input name="lj" type="text" id="lj" size="30" class="wenbenkuang" value="<%=trim(rs1("lj"))%>">
              （不填写可为空，如转移请输入完整路径如http://你的路径） </td>
          </tr>
			<td height="18" width="15%"> <div align="center"> 
                <input type="text" name="tp" size="12" value="<%=rs1("tp")%>" class="wenbenkuang">
              </div></td>
            <td height="18" colspan="2"> <input name="shoppic" class="wenbenkuang" type="text" id="shoppic" size="30" value="<%=trim(rs1("shoppic"))%>"> 
              &nbsp;&nbsp; <input type="button" class="go-wenbenkuang" name="Submit2" value="上传小图片" onClick="window.open('../upload_flash.asp?formname=myform&editname=shoppic&uppath=shoppic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')">