addsn.asp

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

              <%
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"> 
              <%
rs_s.close
set rs_s=nothing
%>
            </td>
            <td colspan="2"> 
              <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select max(sx) as max_jl from shop_snsn",conn,1,1
sx=rs_s("max_jl")
%>
              <input name="sx" type="text" class="wenbenkuang" id="sx" value="<%=sx+1%>" size="20"> 
              <%
rs_s.close
set rs_s=nothing
%>
              （升序＊默认为当前数据中最高升序） </td>
          </tr>
          <tr > 
            <td width="13%"> 
              <%
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"> 
              <%
rs_s.close
set rs_s=nothing
%>
            </td>
            <td colspan="2"> <input name="lj" type="text" id="lj" size="20" class="wenbenkuang">
              （不填写可为空，如转移请输入完整路径如http://你的路径） </td>
          </tr>
          <tr> 
            <td height="18" width="13%"> 
              <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_ziduan where ziduanorder=7 ",conn,1,1
%>
              <input type="text" name="tp" size="12" value="<%=rs_s("ziduanname")%>" class="wenbenkuang"> 
              <%
rs_s.close
set rs_s=nothing
%>
            </td>
            <td height="18" colspan="2"> <input name="shoppic" type="text" id="shoppic" size="30" class="wenbenkuang"> 
              &nbsp; <input type="button" name="Submit2" class="go-wenbenkuang" 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')"> 
            </td>
          </tr>
          <tr> 
            <td height="18" width="13%">&nbsp; </td>
            <td height="18" colspan="2"> <input name="zhuang" type="text" id="zhuang" size="30" class="wenbenkuang"> 
              &nbsp; <input type="button" name="Submit2" class="go-wenbenkuang" value="上传大图片" onClick="window.open('../upload_flash.asp?formname=myform&editname=zhuang&uppath=shoppic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"> 
            </td>
          </tr>
          <tr> 
            <td height="4">配置图片上传：</td>
            <td height="4" colspan="2"><input name="p1" type="text" id="p1" size="30" class="wenbenkuang"> 
              &nbsp; <input type="button" name="Submit22" class="go-wenbenkuang" value="上传配置图片一" onClick="window.open('../upload_flash.asp?formname=myform&editname=p1&uppath=shoppic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"> 
            </td>
          </tr>
          <tr> 
            <td rowspan="3">注： 商品配置图片共四张，上传后显示在商品介绍内，如不上传即不显示</td>
            <td height="2" colspan="2"><input name="p2" type="text" id="p2" size="30" class="wenbenkuang"> 
              &nbsp; <input type="button" name="Submit23" class="go-wenbenkuang" value="上传配置图片二" onClick="window.open('../upload_flash.asp?formname=myform&editname=p2&uppath=shoppic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"></td>
          </tr>
          <tr> 
            <td colspan="2"> <input name="p3" type="text" id="p3" size="30" class="wenbenkuang"> 
              &nbsp; <input type="button" name="Submit24" class="go-wenbenkuang" value="上传配置图片三" onClick="window.open('../upload_flash.asp?formname=myform&editname=p3&uppath=shoppic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"> 
            </td>
          </tr>
          <tr> 
            <td height="5" colspan="2"><input name="p4" type="text" id="zhuang52" size="30" class="wenbenkuang"> 
              &nbsp; <input type="button" name="Submit25" class="go-wenbenkuang" value="上传配置图片四" onClick="window.open('../upload_flash.asp?formname=myform&editname=p4&uppath=shoppic&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"></td>
          </tr>
          <tr> 
            <td valign="top" width="13%"> 
              <%
set rs_s=server.createobject("adodb.recordset")
rs_s.open "select * From shop_ziduan where ziduanorder=8 ",conn,1,1
%>
              <input type="text" name="nr" size="12" value="<%=rs_s("ziduanname")%>" class="wenbenkuang"> 
              <%
rs_s.close
set rs_s=nothing
%>
            </td>
            <td colspan="2"> 
              <!--<textarea name="shopcontent" cols="46" rows="8" id="shopcontent" class="wenbenkuang"></textarea> -->
              <select name="selectFont" class="wenbenkuang" onChange="FormatText('fontname', selectFont.options[selectFont.selectedIndex].value);document.myform.selectFont.options[0].selected = true;"  style="font-family: 宋体; font-size: 9pt" onMouseOver="window.status='选择选定文字的字体。';return true;" onMouseOut="window.status='';return true;">
                <option selected>选择字体</option>
                <option value="宋体">宋体</option>
                <option value="楷体_GB2312">楷体</option>
                <option value="新宋体">新宋体</option>
                <option value="黑体">黑体</option>
                <option value="隶书">隶书</option>
                <option value="幼圆">幼圆</option>
                <option value="Andale Mono">Andale Mono</option>
                <option value=Arial>Arial</option>
                <option value="Arial Black">Arial Black</option>
                <option value="shop Antiqua">shop Antiqua</option>
                <option value="Century Gothic">Century Gothic</option>
                <option value="Comic Sans MS">Comic Sans MS</option>
                <option value="Courier New">Courier New</option>
                <option value=Georgia>Georgia</option>
                <option value=Impact>Impact</option>
                <option value=Tahoma>Tahoma</option>
                <option value="Times New Roman" >Times New Roman</option>
                <option value="Trebuchet MS">Trebuchet MS</option>
                <option value="Script MT Bold">Script MT Bold</option>
                <option value=Stencil>Stencil</option>
                <option value=Verdana>Verdana</option>
                <option value="Lucida Console">Lucida Console</option>
              </select> <select name="selectColour" class="wenbenkuang" onChange="FormatText('ForeColor',selectColour.options[selectColour.selectedIndex].value);document.myform.selectColour.options[0].selected = true;" onMouseOver="window.status='选择选定文字的颜色。';return true;" onMouseOut="window.status='';return true;">
                <option value="0" selected>选择文字颜色</option>
                <option style="background-color:#F0F8FF;color: #F0F8FF" value="#F0F8FF">#F0F8FF</option>
                <option style="background-color:#FAEBD7;color: #FAEBD7" value="#FAEBD7">#FAEBD7</option>
                <option style="background-color:#00FFFF;color: #00FFFF" value="#00FFFF">#00FFFF</option>
                <option style="background-color:#7FFFD4;color: #7FFFD4" value="#7FFFD4">#7FFFD4</option>
                <option style="background-color:#F0FFFF;color: #F0FFFF" value="#F0FFFF">#F0FFFF</option>
                <option style="background-color:#F5F5DC;color: #F5F5DC" value="#F5F5DC">#F5F5DC</option>
                <option style="background-color:#FFE4C4;color: #FFE4C4" value="#FFE4C4">#FFE4C4</option>
                <option style="background-color:#000000;color: #000000" value="#000000">#000000</option>
                <option style="background-color:#FFEBCD;color: #FFEBCD" value="#FFEBCD">#FFEBCD</option>
                <option style="background-color:#0000FF;color: #0000FF" value="#0000FF">#0000FF</option>
                <option style="background-color:#8A2BE2;color: #8A2BE2" value="#8A2BE2">#8A2BE2</option>
                <option style="background-color:#A52A2A;color: #A52A2A" value="#A52A2A">#A52A2A</option>
                <option style="background-color:#DEB887;color: #DEB887" value="#DEB887">#DEB887</option>
                <option style="background-color:#5F9EA0;color: #5F9EA0" value="#5F9EA0">#5F9EA0</option>
                <option style="background-color:#7FFF00;color: #7FFF00" value="#7FFF00">#7FFF00</option>
                <option style="background-color:#D2691E;color: #D2691E" value="#D2691E">#D2691E</option>
                <option style="background-color:#FF7F50;color: #FF7F50" value="#FF7F50">#FF7F50</option>
                <option style="background-color:#6495ED;color: #6495ED" value="#6495ED">#6495ED</option>
                <option style="background-color:#FFF8DC;color: #FFF8DC" value="#FFF8DC">#FFF8DC</option>
                <option style="background-color:#DC143C;color: #DC143C" value="#DC143C">#DC143C</option>
                <option style="background-color:#00FFFF;color: #00FFFF" value="#00FFFF">#00FFFF</option>
                <option style="background-color:#00008B;color: #00008B" value="#00008B">#00008B</option>
                <option style="background-color:#008B8B;color: #008B8B" value="#008B8B">#008B8B</option>
                <option style="background-color:#B8860B;color: #B8860B" value="#B8860B">#B8860B</option>
                <option style="background-color:#A9A9A9;color: #A9A9A9" value="#A9A9A9">#A9A9A9</option>
                <option style="background-color:#006400;color: #006400" value="#006400">#006400</option>
                <option style="background-color:#BDB76B;color: #BDB76B" value="#BDB76B">#BDB76B</option>
                <option style="background-color:#8B008B;color: #8B008B" value="#8B008B">#8B008B</option>
                <option style="background-color:#556B2F;color: #556B2F" value="#556B2F">#556B2F</option>
                <option style="background-color:#FF8C00;color: #FF8C00" value="#FF8C00">#FF8C00</option>
                <option style="background-color:#9932CC;color: #9932CC" value="#9932CC">#9932CC</option>
                <option style="background-color:#8B0000;color: #8B0000" value="#8B0000">#8B0000</option>
                <option style="background-color:#E9967A;color: #E9967A" value="#E9967A">#E9967A</option>
                <option style="background-color:#8FBC8F;color: #8FBC8F" value="#8FBC8F">#8FBC8F</option>
                <option style="background-color:#483D8B;color: #483D8B" value="#483D8B">#483D8B</option>
                <option style="background-color:#2F4F4F;color: #2F4F4F" value="#2F4F4F">#2F4F4F</option>
                <option style="background-color:#00CED1;color: #00CED1" value="#00CED1">#00CED1</option>
                <option style="background-color:#9400D3;color: #9400D3" value="#9400D3">#9400D3</option>
                <option style="background-color:#FF1493;color: #FF1493" value="#FF1493">#FF1493</option>
                <option style="background-color:#00BFFF;color: #00BFFF" value="#00BFFF">#00BFFF</option>
                <option style="background-color:#696969;color: #696969" value="#696969">#696969</option>
                <option style="background-color:#1E90FF;color: #1E90FF" value="#1E90FF">#1E90FF</option>
                <option style="background-color:#B22222;color: #B22222" value="#B22222">#B22222</option>
                <option style="background-color:#FFFAF0;color: #FFFAF0" value="#FFFAF0">#FFFAF0</option>
                <option style="background-color:#228B22;color: #228B22" value="#228B22">#228B22</option>
                <option style="background-color:#FF00FF;color: #FF00FF" value="#FF00FF">#FF00FF</option>
                <option style="background-color:#DCDCDC;color: #DCDCDC" value="#DCDCDC">#DCDCDC</option>
                <option style="background-color:#F8F8FF;color: #F8F8FF" value="#F8F8FF">#F8F8FF</option>
                <option style="background-color:#FFD700;color: #FFD700" value="#FFD700">#FFD700</option>
                <option style="background-color:#DAA520;color: #DAA520" value="#DAA520">#DAA520</option>
                <option style="background-color:#808080;color: #808080" value="#808080">#808080</option>
                <option style="background-color:#008000;color: #008000" value="#008000">#008000</option>
                <option style="background-color:#ADFF2F;color: #ADFF2F" value="#ADFF2F">#ADFF2F</option>
                <option style="background-color:#F0FFF0;color: #F0FFF0" value="#F0FFF0">#F0FFF0</option>
                <option style="background-color:#FF69B4;color: #FF69B4" value="#FF69B4">#FF69B4</option>
                <option style="background-color:#CD5C5C;color: #CD5C5C" value="#CD5C5C">#CD5C5C</option>
                <option style="background-color:#4B0082;color: #4B0082" value="#4B0082">#4B0082</option>
                <option style="background-color:#FFFFF0;color: #FFFFF0" value="#FFFFF0">#FFFFF0</option>
                <option style="background-color:#F0E68C;color: #F0E68C" value="#F0E68C">#F0E68C</option>
                <option style="background-color:#E6E6FA;color: #E6E6FA" value="#E6E6FA">#E6E6FA</option>
                <option style="background-color:#FFF0F5;color: #FFF0F5" value="#FFF0F5">#FFF0F5</option>
                <option style="background-color:#7CFC00;color: #7CFC00" value="#7CFC00">#7CFC00</option>
                <option style="background-color:#FFFACD;color: #FFFACD" value="#FFFACD">#FFFACD</option>
                <option style="background-color:#ADD8E6;color: #ADD8E6" value="#ADD8E6">#ADD8E6</option>
                <option style="background-color:#F08080;color: #F08080" value="#F08080">#F08080</option>
                <option style="background-color:#E0FFFF;color: #E0FFFF" value="#E0FFFF">#E0FFFF</option>
                <option style="background-color:#FAFAD2;color: #FAFAD2" value="#FAFAD2">#FAFAD2</option>
                <option style="background-color:#90EE90;color: #90EE90" value="#90EE90">#90EE90</option>
                <option style="background-color:#D3D3D3;color: #D3D3D3" value="#D3D3D3">#D3D3D3</option>
                <option style="background-color:#FFB6C1;color: #FFB6C1" value="#FFB6C1">#FFB6C1</option>