[求助]时代商城后台数据库写入问题.请懂的朋友指教一二
各位老大..帮帮忙啊,,我改了几天了,都没法解决这个问题..<BR><BR>我用的时代商城....<BR><BR>在后台里,我每次改价格,,都需要点开产品名字才能修改价格.如图1<BR>[attach]27086[/attach]<BR>修改会员价,,<BR>而我99%的时候,都只是修改价格,不改其他参数,,所以我想把它改成这样.<BR><BR>[attach]27087[/attach]<BR>不打开商品,直接在商品列表里填入数据,点修改.<BR><BR>这样一来.要省很多事..<BR><BR>我估计是我数据库写入哪个地方错了,可是改了几天,都没搞定....求大虾些,帮帮忙啊....<BR>我的QQ19792901,可以联系我.谢谢了.<P>dim id<BR>id=SafeRequest("id",1)<BR>%><BR><title>编辑商品属性</title><BR><link href="../include/css.css" rel="stylesheet" type="text/css"><BR><%<BR>dim count<BR>set rs=server.createobject("adodb.recordset")<BR>rs.open "select * from sorts order by sortsorder ",conn,1,1%><BR><script language = "JavaScript"><BR>var onecount;<BR>onecount=0;<BR>subcat = new Array();<BR><%<BR> count = 0<BR> do while not rs.eof <BR>%><BR>subcat[<%=count%>] = new Array("<%= trim(rs("sorts"))%>","<%= rs("categoryid")%>","<%= rs("sortsid")%>");<BR><%<BR> count = count + 1<BR> rs.movenext<BR> loop<BR> rs.close<BR>%><BR> <BR>onecount=<%=count%>;</P>
<P>function changelocation(locationid)<BR> {<BR> document.myform.sortsid.length = 0; </P>
<P> var locationid=locationid;<BR> var i;<BR> for (i=0;i < onecount; i++)<BR> {<BR> if (subcat[i][1] == locationid)<BR> { <BR> document.myform.sortsid.options[document.myform.sortsid.length] = new Option(subcat[i][0], subcat[i][2]);<BR> } <BR> }<BR> <BR> } <BR></script><BR><body><BR><table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6B8FC8"><BR> <tr> <BR> <td bgcolor="#6B8FC8" align="center"><font color="#FFFFFF">编辑商品属性</font></td><BR> </tr><BR> <tr><form name="myform" method="post" action="saveaddpro.asp?action=edit&id=<%=id%>"><BR> <td bgcolor="#FFFFFF"><BR> <table width="98%" border="0" align="center" cellpadding="2" cellspacing="0"><BR> <tr> <BR> <td width="5%">选择分类:</td><BR> <td> <BR> <%<BR> rs.open "select * from category order by categoryorder",conn,1,1<BR> if rs.eof and rs.bof then<BR> response.write "请先添加栏目。"<BR> response.end<BR> else<BR>%><BR> <%dim rs1<BR>set rs1=server.CreateObject("adodb.recordset")<BR>rs1.open "select * from product where id="&id,conn,1,1<BR>%><BR> <select name="categoryid" size="1" id="categoryid" onChange="changelocation(document.myform.categoryid.options[document.myform.categoryid.selectedIndex].value)"><BR> <option selected value="<%=rs("categoryid")%>"><%=trim(rs("category"))%></option><BR> <% dim selclass<BR> selclass=rs1("categoryid")<BR> rs.movenext<BR> do while not rs.eof</P>
<P> response.write "<option value="&rs("categoryid")<BR> if rs1("categoryid")=rs("categoryid") then response.write " selected "<BR> response.write ">"&trim(rs("category"))&"</option>" <BR> rs.movenext<BR> loop<BR> end if<BR> rs.close<BR>%><BR> </select><BR> 小类: <BR> <select name="sortsid"><BR> <%rs.open "select * from sorts where categoryid="&selclass ,conn,1,1<BR>if not(rs.eof and rs.bof) then<BR>%><BR> <option selected value="<%=rs("sortsid")%>"><%=rs("sorts")%></option><BR> <% rs.movenext<BR>do while not rs.eof<BR> response.write "<option value="&rs("sortsid")<BR> if rs1("sortsid")=rs("sortsid") then response.write " selected "<BR> response.write ">"&trim(rs("sorts"))&"</option>" <BR>rs.movenext<BR>loop<BR>end if<BR> rs.close<BR> set rs = nothing<BR> <BR>%><BR> </select> <font color="#FF0000">&nbsp; </font></td><BR> </tr><BR> <tr> <BR> <td> <input name="prename" type="text" id="prename" size="12" value="<%=trim(rs1("prename"))%>"> <BR> </td><BR> <td><input name="name" type="text" id="name" size="30" value="<%=trim(rs1("name"))%>"></td><BR> </tr><BR> <tr> <BR> <td> <input name="company" type="text" id="company" size="12" value="<%=trim(rs1("company"))%>"> <BR> </td><BR> <td><input name="mark" type="text" id="mark" size="30" value="<%=trim(rs1("mark"))%>"></td><BR> </tr><BR> <tr> <BR> <td><input name="intro" type="text" id="intro" size="12" value="<%=trim(rs1("intro"))%>"> <BR> </td><BR> <td><input name="introduce" type="text" id="introduce" size="30" value="<%=trim(rs1("introduce"))%>"></td><BR> </tr><BR> <tr> <BR> <td> <input name="predate" type="text" id="predate" size="12" value="<%=trim(rs1("predate"))%>"> <BR> </td><BR> <td><select name="productdateyear" id="productdateyear"><BR> <%dim i<BR> for i=1980 to 2010 <BR> response.write "<option value="&i<BR> if int(left(rs1("productdate"),4))=i then response.write " selected "<BR> response.write ">"&i&"</option>" <BR> next<BR> %><BR> </select><BR> 年 <BR> <select name="productdatemonth" id="productdatemonth"><BR> <option value="01" <% if int(right(left(rs1("productdate"),7),2))=1 Then Response.write("Selected") %>>1</option><BR> <option value="02" <% if int(right(left(rs1("productdate"),7),2))=2 Then Response.write("Selected") %>>2</option><BR> <option value="03" <% if int(right(left(rs1("productdate"),7),2))=3 Then Response.write("Selected") %>>3</option><BR> <option value="04" <% if int(right(left(rs1("productdate"),7),2))=4 Then Response.write("Selected") %>>4</option><BR> <option value="05" <% if int(right(left(rs1("productdate"),7),2))=5 Then Response.write("Selected") %>>5</option><BR> <option value="06" <% if int(right(left(rs1("productdate"),7),2))=6 Then Response.write("Selected") %>>6</option><BR> <option value="07" <% if int(right(left(rs1("productdate"),7),2))=7 Then Response.write("Selected") %>>7</option><BR> <option value="08" <% if int(right(left(rs1("productdate"),7),2))=8 Then Response.write("Selected") %>>8</option><BR> <option value="09" <% if int(right(left(rs1("productdate"),7),2))=9 Then Response.write("Selected") %>>9</option><BR> <option value="10" <% if int(right(left(rs1("productdate"),7),2))=10 Then Response.write("Selected") %>>10</option><BR> <option value="11" <% if int(right(left(rs1("productdate"),7),2))=11 Then Response.write("Selected") %>>11</option><BR> <option value="12" <% if int(right(left(rs1("productdate"),7),2))=12 Then Response.write("Selected") %>>12</option><BR> </select><BR> 月<select name="productdateday" id="productdateday"><BR> <option value="01" <% if int(right(left(rs1("productdate"),10),2))=1 Then Response.write("Selected") %>>1</option><BR> <option value="02" <% if int(right(left(rs1("productdate"),10),2))=2 Then Response.write("Selected") %>>2</option><BR> <option value="03" <% if int(right(left(rs1("productdate"),10),2))=3 Then Response.write("Selected") %>>3</option><BR> <option value="04" <% if int(right(left(rs1("productdate"),10),2))=4 Then Response.write("Selected") %>>4</option><BR> <option value="05" <% if int(right(left(rs1("productdate"),10),2))=5 Then Response.write("Selected") %>>5</option><BR> <option value="06" <% if int(right(left(rs1("productdate"),10),2))=6 Then Response.write("Selected") %>>6</option><BR> <option value="07" <% if int(right(left(rs1("productdate"),10),2))=7 Then Response.write("Selected") %>>7</option><BR> <option value="08" <% if int(right(left(rs1("productdate"),10),2))=8 Then Response.write("Selected") %>>8</option><BR> <option value="09" <% if int(right(left(rs1("productdate"),10),2))=9 Then Response.write("Selected") %>>9</option><BR> <option value="10" <% if int(right(left(rs1("productdate"),10),2))=10 Then Response.write("Selected") %>>10</option><BR> <option value="11" <% if int(right(left(rs1("productdate"),10),2))=11 Then Response.write("Selected") %>>11</option><BR> <option value="12" <% if int(right(left(rs1("productdate"),10),2))=12 Then Response.write("Selected") %>>12</option><BR> <option value="13" <% if int(right(left(rs1("productdate"),10),2))=13 Then Response.write("Selected") %>>13</option><BR> <option value="14" <% if int(right(left(rs1("productdate"),10),2))=14 Then Response.write("Selected") %>>14</option><BR> <option value="15" <% if int(right(left(rs1("productdate"),10),2))=15 Then Response.write("Selected") %>>15</option><BR> <option value="16" <% if int(right(left(rs1("productdate"),10),2))=16 Then Response.write("Selected") %>>16</option><BR> <option value="17" <% if int(right(left(rs1("productdate"),10),2))=17 Then Response.write("Selected") %>>17</option><BR> <option value="18" <% if int(right(left(rs1("productdate"),10),2))=18 Then Response.write("Selected") %>>18</option><BR> <option value="19" <% if int(right(left(rs1("productdate"),10),2))=19 Then Response.write("Selected") %>>19</option><BR> <option value="20" <% if int(right(left(rs1("productdate"),10),2))=20 Then Response.write("Selected") %>>20</option><BR> <option value="21" <% if int(right(left(rs1("productdate"),10),2))=21 Then Response.write("Selected") %>>21</option><BR> <option value="22" <% if int(right(left(rs1("productdate"),10),2))=22 Then Response.write("Selected") %>>22</option><BR> <option value="23" <% if int(right(left(rs1("productdate"),10),2))=23 Then Response.write("Selected") %>>23</option><BR> <option value="24" <% if int(right(left(rs1("productdate"),10),2))=24 Then Response.write("Selected") %>>24</option><BR> <option value="25" <% if int(right(left(rs1("productdate"),10),2))=25 Then Response.write("Selected") %>>25</option><BR> <option value="26" <% if int(right(left(rs1("productdate"),10),2))=26 Then Response.write("Selected") %>>26</option><BR> <option value="27" <% if int(right(left(rs1("productdate"),10),2))=27 Then Response.write("Selected") %>>27</option><BR> <option value="28" <% if int(right(left(rs1("productdate"),10),2))=28 Then Response.write("Selected") %>>28</option><BR> <option value="29" <% if int(right(left(rs1("productdate"),10),2))=29 Then Response.write("Selected") %>>29</option><BR> <option value="30" <% if int(right(left(rs1("productdate"),10),2))=30 Then Response.write("Selected") %>>30</option><BR> <option value="31" <% if int(right(left(rs1("productdate"),10),2))=31 Then Response.write("Selected") %>>31</option><BR> </select><BR> 日</td><BR> </tr><BR> <tr> <BR> <td><input name="price" type="text" id="price" size="12" value="<%=trim(rs1("price"))%>"></td><BR> <td>市场价: <BR> <input name="price1" type="text" id="price1" size="6" onkeypress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))" <BR> onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"<BR> ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=rs1("price1")%>"><BR> 元,会员价: <BR> <input name="price2" type="text" id="price2" size="6" onkeypress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))" <BR> onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"<BR> ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=rs1("price2")%>"><BR> 元, VIP会员价: <BR> <input name="vipprice" type="text" id="vipprice" size="6" onkeypress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))" <BR> onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"<BR> ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=rs1("vipprice")%>"><BR> 元,赠送积分: <BR></P> <P> <INPUT NAME="score" VALUE="<%=trim(rs1("score"))%>" SIZE="4" TYPE="text" ONKEYPRESS = "return regInput(this, /^[0-9]*$/, String.fromCharCode(event.keyCode))"<br> ONPASTE = "return regInput(this, /^[0-9]*$/, window.clipboardData.getData('Text'))"<br> ONDROP = "return regInput(this, /^[0-9]*$/, event.dataTransfer.getData('Text'))"><br> 分</td><br> </tr><br> <tr> <br> <td><input name="prestock" type="text" id="prestock" size="12" value="<%=trim(rs1("prestock"))%>"></td><br> <td>共 上: <br> <input name="amount" type="text" id="amount" size="6" onkeypress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))" <br> onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"<br> ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=trim(rs1("amount"))%>"><br> 件,库 存: <br> <input name="stock" type="text" id="stock" size="6" onkeypress = "return regInput(this, /^\d*\.?\d{0,2}$/, String.fromCharCode(event.keyCode))" <br> onpaste = "return regInput(this, /^\d*\.?\d{0,2}$/, window.clipboardData.getData('Text'))"<br> ondrop = "return regInput(this, /^\d*\.?\d{0,2}$/, event.dataTransfer.getData('Text'))" value="<%=trim(rs1("stock"))%>"><br> 件</td><br> </tr><br> <tr> <br> <td><input name="other" type="text" id="other" size="12" value="<%=trim(rs1("other"))%>"></td><br> <td><input name="grade" type="text" id="grade" size="12" value="<%=trim(rs1("grade"))%>"></td><br> </tr><br> <tr> <br> <td><input name="pretype" type="text" id="pretype" size="12" value="<%=trim(rs1("pretype"))%>"></td><br> <td><input name="type" type="text" id="type2" value="<%=trim(rs1("type"))%>" size="30"> <br> </td><br> </tr><br> <tr> <br> <td><input name="graph" type="text" id="graph" size="12" value="<%=trim(rs1("graph"))%>"> <br> </td><br> <td><input name="pic" type="text" id="pic" size="30" value="<%=trim(rs1("pic"))%>"><br> <input type="button" name="Submit11" value="上传图片" onClick="window.open('upfile.asp?formname=myform&editname=pic&uppath=images/upfile&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"></td><br> </tr><br> <tr> <br> <td><input name="graph2" type="text" id="graph2" size="12" value="<%=trim(rs1("graph2"))%>"> <br> </td><br> <td><input name="photo" type="text" id="photo" size="30" value="<%=trim(rs1("photo"))%>"><br> <input type="button" name="Submit12" value="上传图片" onClick="window.open('upfile.asp?formname=myform&editname=photo&uppath=images/upfile&filelx=jpg','','status=no,scrollbars=no,top=20,left=110,width=420,height=165')"></td><br> </tr><br> <tr> <br> <td><input name="link" type="text" id="link" size="12" value="<%=trim(rs1("link"))%>"></td><br> <td><input name="addlink" type="text" id="addlink" value="<%=trim(rs1("addlink"))%>" size="30"></td><br> </tr><br> <tr> <br> <td valign="top"> <input name="description" type="text" id="description2" size="12" value="<%=trim(rs1("description"))%>"><br><br> </td><br> <td><br> <INPUT type="hidden" name="detail" value="<% = Server.HtmlEncode(rs1("detail")) %>"> <br> <iframe ID="detail" src="htmledit/ewebeditor.asp?id=detail&style=standard" frameborder="0" scrolling="no" width="550" HEIGHT="350"></iframe> <br> </td></tr><br> <tr> <br> <td valign="top"> <input name="remarks" type="text" id="remarks" size="12" value="<%=trim(rs1("remarks"))%>"> <br> </td><br> <td><br> <INPUT type="hidden" name="content" value="<% = Server.HtmlEncode(rs1("content")) %>"> <br> <iframe ID="content" src="htmledit/ewebeditor.asp?id=content&style=standard" frameborder="0" scrolling="no" width="550" HEIGHT="350"></iframe> <br> </td><br> </tr><br> <tr> <br> <td></td><br> <td><br> 商品类别<select name="recommend" id="recommend"><br> <option value="0" <% if rs1("recommend")=0 Then Response.write("Selected") %>>普通商品</option><br> <option value="1" <% if rs1("recommend")=1 Then Response.write("Selected") %>>推荐商品</option><br> <option value="2" <% if rs1("recommend")=2 Then Response.write("Selected") %>>特价商品</option><br> <option value="3" <% if rs1("recommend")=3 Then Response.write("Selected") %>>新品上架</option><br> <option value="4" <% if rs1("recommend")=4 Then Response.write("Selected") %>>推荐特价</option><br> <option value="5" <% if rs1("recommend")=5 Then Response.write("Selected") %>>推荐新品</option><br> <option value="6" <% if rs1("recommend")=6 Then Response.write("Selected") %>>新品特价</option><br> <option value="7" <% if rs1("recommend")=7 Then Response.write("Selected") %>>赠送礼品</option><br> </select><br> <input type="submit" name="Submit" value="修 改" onClick="return check();"><br> </td><br> </tr><br> </table><br> </td></form><br> </tr><br></table><%rs1.close<br>set rs1=nothing<br>conn.close<br>set conn=nothing%><br><!--#include file="footer.asp"--><br><SCRIPT LANGUAGE="JavaScript"><br><!--<br>function check()<br>{<br> if(checkspace(document.myform.name.value)) {<br> document.myform.name.focus();<br> alert("请输入商品名称!");<br> return false;<br> }<br> if(checkspace(document.myform.price1.value)) {<br> document.myform.price1.focus();<br> alert("请输入市场价!");<br> return false;<br> }<br> if(checkspace(document.myform.price2.value)) {<br> document.myform.putongjia.focus();<br> alert("请输入普通会员价!");<br> return false;<br> }<br> if(checkspace(document.myform.vipprice.value)) {<br> document.myform.price2.focus();<br> alert("请输入VIP会员价!");<br> return false;<br> }<br> <br>}<br>function checkspace(checkstr) {<br> var str = '';<br> for(i = 0; i < checkstr.length; i++) {<br> str = str + ' ';<br> }<br> return (str == checkstr);<br>}<br>//--><br></script><br><script><br> function regInput(obj, reg, inputStr)<br> {<br> var docSel = document.selection.createRange()<br> if (docSel.parentElement().tagName != "INPUT") return false<br> oSel = docSel.duplicate()<br> oSel.text = ""<br> var srcRange = obj.createTextRange()<br> oSel.setEndPoint("StartToStart", srcRange)<br> var str = oSel.text + inputStr + srcRange.text.substr(oSel.text.length)<br> return reg.test(str)<br> }<br></script></P>
[align=right][color=#000066][此贴子已经被作者于2007-9-5 16:29:37编辑过][/color][/align]
<P>这是我准备修改后的<BR><BR><!--#include file="conn.asp"--><BR><%<BR>if session("admin")="" then<BR>conn.close<BR>set conn = nothing<BR>response.Write "<script language='javascript'>alert('请先登录!');history.go(-1);</script>"<BR>response.End<BR>else<BR>if request.cookies("timesshop")("admin")="" then<BR>conn.close<BR>set conn = nothing<BR>response.Write "<script language='javascript'>alert('请先登录!');history.go(-1);</script>"<BR>response.End<BR>end if<BR>end if<BR>%><BR><title>管理商品</title><BR><%<BR>dim selectm,selectkey,selectid<BR>selectkey=trim(request.form(trim("selectkey")))<BR>selectm=trim(request.form("selectm"))<BR>selectid=request.form("selectid")<BR>if selectid<>"" then<BR>if session("rank")>2 then<BR>conn.close<BR>set conn = nothing<BR>response.Write "<script language='javascript'>alert('你无权管理商品!');history.go(-1);</script>"<BR>response.End<BR>end if<BR>conn.execute "delete from product where id in ("&selectid&")"<BR>response.Redirect "chkpro.asp"<BR>response.End<BR>end if<BR>%><BR><table width="98%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#6699cc"><BR> <tr> <BR> <td align="center"><font color="#FFFFFF">商品查询</font></td><BR> </tr><BR> <tr bgcolor="#FFFFFF"> <BR> <form name="form2" method="post" action="chkpro.asp"><BR> <td><BR> <table width="80%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC"><BR> <tr bgcolor="#FFFFFF" align="center"> <BR> <td width="35%"> <input name="selectkey" type="text" id="selectkey" onFocus="this.value=''" value="请输入关健字"> <BR> </td><BR> <td width="45%"> <select name="selectm" id="select"><BR> <OPTION VALUE="name">按商品名称</OPTION><BR> <OPTION VALUE="zuozhe">按商品品牌</OPTION><BR> <OPTION VALUE="chubanshe">按商品简介</OPTION><BR> </select> </td><BR> <td width="20%"><input type="submit" name="Submit" value="查 询" onClick="return chkkey();"></td><BR> </tr><BR> </table></td><BR> </form><BR> </tr><BR></table><br></P>
<P><table width="98%" border="0" align="center" cellpadding="0" cellspacing="1" bgcolor="#6699cc"><BR> <tr> <BR> <td height="20" align="center"><font color="#FFFFFF">商品查看与修改</font></td><BR> </tr><BR> <tr> <BR> <form name="form1" method="post" action=""><BR> <td height="100" bgcolor="#FFFFFF"> <BR> <%<BR> Const MaxPerPage=20 <BR> dim totalPut <BR> dim CurrentPage<BR> dim TotalPages<BR> dim j<BR> dim sql<BR> if Not isempty(SafeRequest("page",1)) then<BR> currentPage=Cint(SafeRequest("page",1))<BR> else<BR> currentPage=1<BR> end if <BR> set rs=server.CreateObject("adodb.recordset")<BR> select case selectm<BR> case ""<BR> rs.open "select id,name,adddate,price2,type,mark,introduce from product order by name desc",conn,1,1<BR> case "0"<BR> response.write "<center>请返回选择您要查询的方式!<br><br><a href=javascript:history.go(-1)>点击返回上一页</a></center>"<BR> response.End<BR> case "name"<BR> rs.open "select id,name,adddate,price2,type,mark,introduce from product where name like '%"&selectkey&"%' order by name desc",conn,1,1<BR> case "zuozhe"<BR> rs.open "select id,name,adddate,price2,type,mark,introduce from product where mark like '%"&selectkey&"%' order by name desc",conn,1,1<BR> case "chubanshe"<BR> rs.open "select id,name,adddate,price2,type,mark,introduce from product where introduce like '%"&selectkey&"%' order by name desc",conn,1,1<BR> end select<BR> if err.number<>0 then<BR> response.write "数据库中暂时无数据"<BR> end if<BR> <BR> if rs.eof And rs.bof then<BR> Response.Write "<p align='center' class='contents'> 数据库中暂时无数据!</p>"<BR> else<BR> totalPut=rs.recordcount</P>
<P> if currentpage<1 then<BR> currentpage=1<BR> end if</P>
<P> if (currentpage-1)*MaxPerPage>totalput then<BR> if (totalPut mod MaxPerPage)=0 then<BR> currentpage= totalPut \ MaxPerPage<BR> else<BR> currentpage= totalPut \ MaxPerPage + 1<BR> end if<BR> end if</P>
<P> if currentPage=1 then<BR> showContent<BR> showpage totalput,MaxPerPage,"chkpro.asp"<BR> else<BR> if (currentPage-1)*MaxPerPage<totalPut then<BR> rs.move (currentPage-1)*MaxPerPage<BR> dim bookmark<BR> bookmark=rs.bookmark<BR> showContent<BR> showpage totalput,MaxPerPage,"chkpro.asp"<BR> else<BR> currentPage=1<BR> showContent<BR> showpage totalput,MaxPerPage,"chkpro.asp"<BR> end if<BR> end if<BR> end if</P>
<P> sub showContent<BR> dim i<BR> i=0%><BR> <table width="95%" border="0" align="center" cellpadding="1" cellspacing="1" bgcolor="#CCCCCC"><BR> <tr bgcolor="#FFFFFF" align="center" height="20"> <BR> <td width="25%">商品名称</td><BR> <td colspan="2">商品价格</td><BR> <td width="32%">配置</td><BR> <td width="13%">货源</td><BR> <td width="13%">加入时间</td><BR> <td width="5%">选 择</td><BR> </tr><BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <%<BR> do while not rs.eof%><BR> <tr bgcolor="#FFFFFF" align="center"> <BR> <td align="left">&nbsp;<a href=editpro.asp?id=<%=rs("id")%>> <BR> <% if len(trim(rs("name")))>20 then<BR> response.write left(trim(rs("name")),18)&"..."<BR> else<BR> response.write trim(rs("name"))<BR> end if%><BR> </a></td><BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <BR> <td width="7%" align="left"><BR> <BR> <BR> </P>
<P> <BR> <input name="price2" type="text" id="price2" size="6" value="<%=trim(rs("price2"))%>"></td><BR> <td width="5%" align="left"><input type="submit" name="Submit2" value="修改"></td><BR> <td nowrap><% if len(trim(rs("type")))>20 then<BR> response.write left(trim(rs("type")),18)&"..."<BR> else<BR> response.write trim(rs("type"))<BR> end if%>&nbsp;</td><BR> <td nowrap><%=trim(rs("mark"))%>&nbsp;</td><BR> <td nowrap><%=rs("adddate")%></td><BR> <td align="center"><input name="selectid" type="checkbox" id="selectid" value="<%=rs("id")%>"></td><BR> </tr><BR> <%i=i+1<BR> if i>=MaxPerPage then Exit Do<BR> rs.movenext<BR> loop<BR> rs.close<BR> set rs=nothing%><BR> <tr bgcolor="#FFFFFF"> <BR> <td height="30" colspan="7" align="right">全选 <input type="checkbox" name="checkbox2" value="Check All" onClick="mm()">&nbsp;<input type="submit" name="Submit" value="删 除" onClick="return test();"><BR> &nbsp;&nbsp; </td><BR> </tr><BR> </table><BR> <% <BR> End Sub <BR> <BR> Function showpage(totalnumber,maxperpage,filename) <BR> Dim n<BR> <BR> If totalnumber Mod maxperpage=0 Then <BR> n= totalnumber \ maxperpage <BR> Else<BR> n= totalnumber \ maxperpage+1 <BR> End If<BR> <BR> Response.Write "<form method=Post action="&filename&"?selectm="&selectm&"&selectkey="&selectkey&" >" <BR> Response.Write "<p align='center' class='contents'> " <BR> If CurrentPage<2 Then <BR> Response.Write "<font class='contents'>首 页 上一页</font> " <BR> Else <BR> Response.Write "<a href="&filename&"?page=1&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>首 页</a> " <BR> Response.Write "<a href="&filename&"?page="&CurrentPage-1&"&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>上一页</a> " <BR> End If<BR> <BR> If n-currentpage<1 Then <BR> Response.Write "<font class='contents'>下一页 末 页</font>" <BR> Else <BR> Response.Write "<a href="&filename&"?page="&(CurrentPage+1)&"&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>" <BR> Response.Write "下一页</a> <a href="&filename&"?page="&n&"&selectm="&selectm&"&selectkey="&selectkey&" class='contents'>末 页</a>" <BR> End If <BR> Response.Write "<font class='contents'> 页次:</font><font class='contents'>"&CurrentPage&"</font><font class='contents'>/"&n&"页</font> " <BR> Response.Write "<font class='contents'> 共有"&totalnumber&"种商品 " <BR> Response.Write "<font class='contents'>转到第:</font><input type='text' name='page' size=2 maxlength=10 class=smallInput value="&currentpage&">页" <BR> Response.Write "&nbsp;<input type='submit' class='contents' value='跳转' name='cndok' ></form>" <BR> End Function <BR> %></td><BR> </form><BR> </tr><BR></table><BR><br><BR><!--#include file="footer.asp"--><BR><script language=javascript><BR>function test()<BR>{<BR> if(!confirm('确认删除吗?')) return false;<BR>}</P>
<P>function chkkey()<BR>{<BR> if(checkspace(document.form2.selectkey.value.length=0)){<BR> document.form2.selectkey.focus();<BR> alert("请输入查询关键字")<BR> return false;<BR> }<BR>}<BR> <BR>function mm()<BR>{<BR> var a = document.getElementsByTagName("input");<BR> if(a[0].checked==true){<BR> for (var i=0; i<a.length; i++)<BR> if (a[i].type == "checkbox") a[i].checked = false;<BR> }<BR> else<BR> {<BR> for (var i=0; i<a.length; i++)<BR> if (a[i].type == "checkbox") a[i].checked = true;<BR> }<BR>}<BR></script><BR> <BR></P> 2~4楼打包文件[attach]27089[/attach]<BR><BR><BR>请各位朋友,一定帮帮忙啊..跪谢了. <P>人气差啊....自己顶一火<BR></P>
页:
[1]
