http://forum.lowyat.net/ Sun, 21 Jun 2026 05:57:00 +0800 FeedCreator 1.7.2 http://forum.lowyat.net/topic/1549457 <!--SPOILER BEGIN--><div class="spoilertop" onClick="openClose('96d36725ea684326c439c2055443f247')" style="font-weight: bold"><u>&raquo; Click to show Spoiler - click again to hide... &laquo;</u></div><div class="spoilermain" id="96d36725ea684326c439c2055443f247" style="display:none"><!--SPOILER END--><br />&lt;%<br />if request.Cookies(&quot;shiwei_username&quot;)=&quot;&quot; then<br />%&gt;<br />&#60;script language=&quot;javascript&quot;&gt;<br />top.location.href=&quot;../index.asp&quot;<br />&lt;/script&gt;<br />&lt;% <br /> response.end<br />end if<br />%&gt;<br />[bad html removed] #include file=&quot;../conn2.asp&quot; --&#62;<br />[bad html removed] #include file=&quot;../const.asp&quot; --&#62; <br />&lt;html&gt;<br />&lt;head&gt;<br />&lt;title&gt;&lt;%=dianming%&gt; - 库存管理&lt;/title&gt;<br />&lt;meta http-equiv=&quot;Content-Type&quot; content=&quot;text/html; charset=gb2312&quot;&gt;<br />&lt;link href=&quot;../style/style.css&quot; rel=&quot;stylesheet&quot; type=&quot;text/css&quot;&gt;<br />&lt;style&gt;<br />body {<br /> background-color:#FFFFFF;<br />}<br />&lt;/style&gt;<br />&#60;script language=javascript&gt;<br />function preview() { <br />bdhtml=window.document.body.innerHTML;<br />sprnstr=&quot;[bad html removed]startprint--&#62;&quot;; <br />eprnstr=&quot;[bad html removed]endprint--&#62;&quot;; <br />prnhtml=bdhtml.substr(bdhtml.indexOf(sprnstr)+17); <br />prnhtml=prnhtml.substring(0,prnhtml.indexOf(eprnstr));<br />window.document.body.innerHTML=prnhtml; <br />window.print();<br />window.document.body.innerHTML=bdhtml; <br /> }<br />&lt;/script&gt;<br />&lt;/HEAD&gt;<br /><br />&lt;BODY&gt;<br />&#60;script&gt;<br />function CheckAll(form) {<br /> for (var i=0;i&lt;form.elements.length;i++) {<br /> var e = form.elements[i];<br /> if (e.name &#33;= &#39;chkall&#39;) e.checked = form.chkall.checked; <br /> }<br /> }<br />&lt;/script&gt;<br />&lt;%<br />if fla13=&quot;0&quot; and request.Cookies(&quot;shiwei_id&quot;)&lt;&gt;&quot;1&quot; then<br />%&gt;<br />&lt;br&gt;&lt;center&gt;&lt;img src=&quot;../images/note.gif&quot; align=&quot;absmiddle&quot;&gt;&amp;nbsp;&lt;font color=&quot;#FF0000&quot;&gt;你不具备此权限，请与管理员联系！&lt;/font&gt;&lt;/center&gt;<br />&lt;% <br /> response.end<br />end if<br /><br />&#39;取得当前页码<br />currentpage=request(&quot;page&quot;)<br />&#39;response.write currentpage<br />&#39;response.end<br />if currentpage&lt;1 or currentpage=&quot;&quot; then<br /> currentpage=&quot;1&quot;<br />end if<br /><br />&#39;取得搜索关键字 <br />nowku=request(&quot;ku&quot;)<br />nowbigclass=request(&quot;bigclass&quot;)<br />nowsmallclass=request(&quot;smallclass&quot;)<br />if nowbigclass=&quot;&quot; then nowsmallclass=&quot;&quot;<br />nowkeyword=request(&quot;keyword&quot;) <br />%&gt;<br />&lt;table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; align=&quot;center&quot;&gt;<br />&lt;form name=&quot;form2&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;form&quot; value=&quot;&lt;%=request(&quot;form&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;field&quot; value=&quot;&lt;%=request(&quot;field&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;field2&quot; value=&quot;&lt;%=request(&quot;field2&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;span1&quot; value=&quot;&lt;%=request(&quot;span1&quot;)%&gt;&quot;&gt;<br /> &lt;tr&gt; <br /> &lt;td width=&quot;50&quot; height=&quot;21&quot;&gt;&amp;nbsp;&lt;img src=&quot;../images/print.jpg&quot; align=&quot;absmiddle&quot; style=&quot;cursor:hand;&quot; onClick=&quot;preview();&quot;&gt;&lt;/td&gt;<br /> &lt;td width=&quot;*&quot; align=&quot;right&quot;&gt;<br /> 搜索：<br /> &lt;%<br /> if request.Cookies(&quot;shiwei_id&quot;)=&quot;1&quot; or fla88=&quot;1&quot; then<br /> sql=&quot;select * from ku order by id&quot;<br /> set rs_ku=conn.execute(sql)<br /> else<br /> sql=&quot;select * from ku where instr(login,&#39;,&quot;&amp;request.Cookies(&quot;shiwei_id&quot;)&amp;&quot;,&#39;)&gt;0 order by id&quot;<br /> set rs_ku=conn.execute(sql)<br /> if rs_ku.eof then<br /> nowku=&quot;0&quot;<br /> elseif request(&quot;ku&quot;)=&quot;&quot; then<br /> nowku=rs_ku(&quot;id&quot;)<br /> end if <br /> end if <br /> %&gt;<br /> &lt;select name=&quot;ku&quot; onChange=&quot;form2.submit()&quot;&gt;<br /> &lt;%if request.Cookies(&quot;shiwei_id&quot;)=&quot;1&quot; or fla88=&quot;1&quot; then%&gt; <br /> &lt;option value=&quot;&quot;&gt;所有仓库&lt;/option&gt;<br /> &lt;%elseif rs_ku.eof then%&gt;<br /> &lt;option value=&quot;0&quot;&gt;没有你管理的仓库&lt;/option&gt; <br /> &lt;%end if%&gt;<br /> &lt;%<br /> do while rs_ku.eof=false<br /> %&gt;<br /> &lt;option value=&quot;&lt;%=rs_ku(&quot;id&quot;)%&gt;&quot;&lt;%if trim(cstr(rs_ku(&quot;id&quot;)))=nowku then%&gt; selected=&quot;selected&quot;&lt;%end if%&gt;&gt;&lt;%=rs_ku(&quot;ku&quot;)%&gt;&lt;/option&gt;<br /> &lt;%<br /> rs_ku.movenext<br /> loop<br /> %&gt;<br /> &lt;/select&gt; <br /> &lt;%<br /> sql=&quot;select * from bigclass order by id&quot;<br /> set rs_bigclass=conn.execute(sql)<br /> %&gt;<br /> &lt;select name=&quot;bigclass&quot; onChange=&quot;form2.submit()&quot;&gt;<br /> &lt;option value=&quot;&quot;&gt;所有大类&lt;/option&gt;<br /> &lt;%<br /> do while rs_bigclass.eof=false<br /> %&gt;<br /> &lt;option value=&quot;&lt;%=rs_bigclass(&quot;id&quot;)%&gt;&quot;&lt;%if trim(cstr(rs_bigclass(&quot;id&quot;)))=nowbigclass then%&gt; selected=&quot;selected&quot;&lt;%end if%&gt;&gt;&lt;%=rs_bigclass(&quot;bigclass&quot;)%&gt;&lt;/option&gt;<br /> &lt;%<br /> rs_bigclass.movenext<br /> loop<br /> %&gt;<br /> &lt;/select&gt;<br /> &lt;%<br /> if nowbigclass=&quot;&quot; then<br /> nowbigclass2=0<br /> else<br /> nowbigclass2=nowbigclass <br /> end if<br /> sql=&quot;select * from smallclass where id_bigclass=&quot;&amp;nowbigclass2&amp;&quot; order by id&quot;<br /> set rs_smallclass=conn.execute(sql)<br /> %&gt;<br /> &lt;select name=&quot;smallclass&quot; onChange=&quot;form2.submit()&quot;&gt;<br /> &lt;option value=&quot;&quot;&gt;所有小类&lt;/option&gt;<br /> &lt;%<br /><b> do while rs_smallclass.eof=false<br /> %&gt;<br /> &lt;option value=&quot;&lt;%=rs_smallclass(&quot;id&quot;)%&gt;&quot;&lt;%if trim(cstr(rs_smallclass(&quot;id&quot;)))=nowsmallclass then%&gt; selected=&quot;selected&quot;&lt;%end if%&gt;&gt;&lt;%=rs_smallclass(&quot;smallclass&quot;)%&gt;&lt;/option&gt;<br /> &lt;%<br /> rs_smallclass.movenext<br /> loop<br /> %&gt;<br /> &lt;/select&gt;<br /> &lt;input type=&quot;text&quot; name=&quot;keyword&quot; size=&quot;20&quot; value=&quot;&lt;%=nowkeyword%&gt;&quot;&gt;<br /> &lt;input type=&quot;submit&quot; value=&quot; 查询 &quot; class=&quot;button&quot;&gt;&amp;nbsp;<br /> &lt;/td&gt;<br /> &lt;/tr&gt;<br />&lt;/form&gt; <br />&lt;/table&gt;<br />&lt;%<br /> sql=&quot;select * from produit where 1=1&quot;<br /> if nowkeyword&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; and (title like &#39;%&quot;&amp;nowkeyword&amp;&quot;%&#39; or huohao like &#39;%&quot;&amp;nowkeyword&amp;&quot;%&#39;)&quot;<br /> end if</b> if nowku&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; and id_ku=&quot;&amp;nowku<br /> end if <br /> if nowbigclass&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; and id_bigclass=&quot;&amp;nowbigclass<br /> end if<br /> if nowsmallclass&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; and id_smallclass=&quot;&amp;nowsmallclass<br /> end if <br /> <br /> if request(&quot;order1&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by photo &quot;&amp;request(&quot;order1&quot;)<br /> elseif request(&quot;order2&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by huohao &quot;&amp;request(&quot;order2&quot;)<br /> elseif request(&quot;order3&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by title &quot;&amp;request(&quot;order3&quot;) <br /> elseif request(&quot;order4&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by guige &quot;&amp;request(&quot;order4&quot;) <br /> elseif request(&quot;order5&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by danwei &quot;&amp;request(&quot;order5&quot;) <br /> elseif request(&quot;order6&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by shulian &quot;&amp;request(&quot;order6&quot;)<br /> elseif request(&quot;order7&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by price2 &quot;&amp;request(&quot;order7&quot;)<br /> elseif request(&quot;order8&quot;)&lt;&gt;&quot;&quot; then<br /> sql=sql&amp;&quot; order by price &quot;&amp;request(&quot;order8&quot;) <br /> else<br /> sql=sql&amp;&quot; order by id desc&quot; <br /> end if<br /> <br />set count_buy = server.createobject(&quot;ADODB.RecordSet&quot;) <br />count_buy.open sql,conn,1,3<br />nowprice2=0<br />do while count_buy.eof=false<br /> nowprice2=nowprice2+count_buy(&quot;shulian&quot;)*count_buy(&quot;price2&quot;) <br /> count_buy.movenext<br />loop<br />%&gt;<br />&lt;table width=&quot;100%&quot; border=&quot;0&quot; cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; bgcolor=&quot;#C4D8ED&quot;&gt;<br />&lt;tr&gt;<br />&lt;td&gt;&lt;img src=&quot;../images/r_1.gif&quot; alt=&quot;&quot; /&gt;&lt;/td&gt;<br />&lt;td width=&quot;100%&quot; background=&quot;../images/r_0.gif&quot;&gt;<br /> &lt;table cellpadding=&quot;0&quot; cellspacing=&quot;0&quot; width=&quot;100%&quot;&gt;<br /> &lt;tr&gt;<br /> &lt;td&gt;&amp;nbsp;&lt;/td&gt;<br /> &lt;td align=&quot;right&quot;&gt;总库存金额：&lt;b&gt;&lt;%=formatnumber(nowprice2,2)%&gt;&lt;/b&gt; 元&amp;nbsp;&lt;/td&gt;<br /> &lt;/tr&gt;<br /> &lt;/table&gt;<br />&lt;/td&gt;<br />&lt;td&gt;&lt;img src=&quot;../images/r_2.gif&quot; alt=&quot;&quot; /&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br />&lt;tr&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;td&gt;<br />[bad html removed]startprint--&#62;<br />&lt;table align=&quot;center&quot; cellpadding=&quot;4&quot; cellspacing=&quot;1&quot; class=&quot;toptable grid&quot; border=&quot;1&quot;&gt;<br />&lt;form name=&quot;form1&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;form&quot; value=&quot;&lt;%=request(&quot;form&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;field&quot; value=&quot;&lt;%=request(&quot;field&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;field2&quot; value=&quot;&lt;%=request(&quot;field2&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;span1&quot; value=&quot;&lt;%=request(&quot;span1&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;ku&quot; value=&quot;&lt;%=nowku%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;bigclass&quot; value=&quot;&lt;%=nowbigclass%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;smallclass&quot; value=&quot;&lt;%=nowsmallclass%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;keyword&quot; value=&quot;&lt;%=nowkeyword%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order1&quot; value=&quot;&lt;%=request(&quot;order1&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order2&quot; value=&quot;&lt;%=request(&quot;order2&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order3&quot; value=&quot;&lt;%=request(&quot;order3&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order4&quot; value=&quot;&lt;%=request(&quot;order4&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order5&quot; value=&quot;&lt;%=request(&quot;order5&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order6&quot; value=&quot;&lt;%=request(&quot;order6&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order7&quot; value=&quot;&lt;%=request(&quot;order7&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order8&quot; value=&quot;&lt;%=request(&quot;order8&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order9&quot; value=&quot;&lt;%=request(&quot;order9&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order10&quot; value=&quot;&lt;%=request(&quot;order10&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order11&quot; value=&quot;&lt;%=request(&quot;order11&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order12&quot; value=&quot;&lt;%=request(&quot;order12&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order13&quot; value=&quot;&lt;%=request(&quot;order13&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order14&quot; value=&quot;&lt;%=request(&quot;order14&quot;)%&gt;&quot;&gt;<br /> &lt;input type=&quot;hidden&quot; name=&quot;order15&quot; value=&quot;&lt;%=request(&quot;order15&quot;)%&gt;&quot;&gt;<br /> &lt;tr align=&quot;center&quot;&gt; <br /> &lt;%if showpic=&quot;yes&quot; then%&gt;<br /> &lt;td class=&quot;category&quot; width=&quot;70&quot;&gt;<br /> &lt;a href=&quot;?order1=&lt;%if request(&quot;order1&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;图片&lt;%if request(&quot;order1&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt; <br /> &lt;/td&gt;<br /> &lt;%end if%&gt;<br /> &lt;td class=&quot;category&quot; height=&quot;30&quot;&gt;<br /> &lt;a href=&quot;?order2=&lt;%if request(&quot;order2&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;货号&lt;%if request(&quot;order2&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt; <br /> &lt;/td&gt;<br /> &lt;td class=&quot;category&quot;&gt;<br /> &lt;a href=&quot;?order3=&lt;%if request(&quot;order3&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;产品名称&lt;%if request(&quot;order3&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt; <br /> &lt;/td&gt;<br /> &lt;td class=&quot;category&quot;&gt;<br /> &lt;a href=&quot;?order4=&lt;%if request(&quot;order4&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;规格&lt;%if request(&quot;order4&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt; <br /> &lt;/td&gt;<br /> &lt;td class=&quot;category&quot;&gt;<br /> &lt;a href=&quot;?order5=&lt;%if request(&quot;order5&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;单位&lt;%if request(&quot;order5&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt; <br /> &lt;/td&gt; <br /> &lt;td class=&quot;category&quot;&gt; <br /> &lt;a href=&quot;?order6=&lt;%if request(&quot;order6&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;库存数量&lt;%if request(&quot;order6&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt;<br /> &lt;/td&gt;<br /> &lt;td class=&quot;category&quot;&gt;<br /> &lt;a href=&quot;?order7=&lt;%if request(&quot;order7&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;进货单价&lt;%if request(&quot;order7&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt;<br /> &lt;/td&gt;<br /> &lt;td class=&quot;category&quot;&gt;<br /> &lt;a href=&quot;?order8=&lt;%if request(&quot;order8&quot;)=&quot;asc&quot; then%&gt;desc&lt;%else%&gt;asc&lt;%end if%&gt;&amp;form=&lt;%=request(&quot;form&quot;)%&gt;&amp;field=&lt;%=request(&quot;field&quot;)%&gt;&amp;field2=&lt;%=request(&quot;field2&quot;)%&gt;&amp;span1=&lt;%=request(&quot;span1&quot;)%&gt;&amp;page=&lt;%=currentpage%&gt;&amp;keyword=&lt;%=nowkeyword%&gt;&amp;ku=&lt;%=nowku%&gt;&amp;bigclass=&lt;%=nowbigclass%&gt;&amp;smallclass=&lt;%=nowsmallclass%&gt;&quot; class=&quot;title&quot;&gt;建议卖价&lt;%if request(&quot;order8&quot;)=&quot;asc&quot; then%&gt;&lt;img src=&quot;../images/up2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%else%&gt;&lt;img src=&quot;../images/down2.gif&quot; border=&quot;0&quot; hspace=&quot;2&quot; align=&quot;absmiddle&quot;&gt;&lt;%end if%&gt;&lt;/a&gt; <br /> &lt;/td&gt;<br /> &lt;/tr&gt;<br /> &lt;%<br /> set rs_produit =server.createobject(&quot;ADODB.RecordSet&quot;) <br /> rs_produit.open sql,conn,1,3<br /> if not rs_produit.eof then<br /> rs_produit.pagesize=maxrecord<br /> rs_produit.absolutepage=currentpage<br /> y=&quot;&quot;<br /> for currentrec=1 to rs_produit.pagesize<br /> if rs_produit.eof then<br /> exit for<br /> end if<br /> <br /> if request(&quot;form&quot;)&lt;&gt;&quot;&quot; then<br /> sql=&quot;select * from produit where huohao=&#39;&quot;&amp;rs_produit(&quot;huohao&quot;)&amp;&quot;&#39;&quot;<br /> set rs_shulian=conn.execute(sql)<br /> nowshulian=0<br /> nowtext=&quot;&quot;<br /> do while rs_shulian.eof=false<br /> nowshulian=nowshulian+rs_shulian(&quot;shulian&quot;)<br /> sql=&quot;select * from ku where id=&quot;&amp;rs_shulian(&quot;id_ku&quot;)<br /> set rs_ku=conn.execute(sql)<br /> nowtext=nowtext+rs_ku(&quot;ku&quot;)&amp;&quot;(&quot;&amp;formatnumber(rs_shulian(&quot;shulian&quot;),2)&amp;&quot;)，&quot;<br /> rs_shulian.movenext<br /> loop <br /> end if<br /> &#39;listy=split(y,&quot;-|-&quot;)<br /> &#39;nowshow=true<br /> &#39;for z=0 to UBound(listy)-1<br /> &#39; if listy(z)=rs_produit(&quot;huohao&quot;) then<br /> &#39; nowshow=false<br /> &#39; exit for<br /> &#39; end if<br /> &#39;next<br /> &#39;if nowshow then<br /> &#39; y=y&amp;rs_produit(&quot;huohao&quot;)&amp;&quot;-|-&quot;<br /> %&gt;<br /> &lt;tr onMouseOver=&quot;this.className=&#39;highlight&#39;&quot; onMouseOut=&quot;this.className=&#39;&#39;&quot; &lt;%if request(&quot;form&quot;)&lt;&gt;&quot;&quot; then%&gt;onDblClick=&quot;window.opener.document.&lt;%=request(&quot;form&quot;)%&gt;.&lt;%=request(&quot;field&quot;)%&gt;.value=&#39;&lt;%=rs_produit(&quot;huohao&quot;)%&gt;&#39;;&lt;%if request(&quot;field2&quot;)&lt;&gt;&quot;&quot; then%&gt;window.opener.document.&lt;%=request(&quot;form&quot;)%&gt;.&lt;%=request(&quot;field2&quot;)%&gt;.value=&#39;&lt;%=rs_produit(&quot;price2&quot;)%&gt;&#39;;&lt;%end if%&gt;&lt;%if request(&quot;span1&quot;)&lt;&gt;&quot;&quot; then%&gt;window.opener.document.all.&lt;%=request(&quot;span1&quot;)%&gt;.innerHTML=&#39;产品名称：&lt;%=rs_produit(&quot;title&quot;)%&gt;，总数量：&lt;%=formatnumber(nowshulian,2)%&gt;，&lt;%=left(nowtext,len(nowtext)-1)%&gt;&#39;;&lt;%end if%&gt;window.close();&quot;&lt;%else%&gt;onDblClick=&quot;javascript:var win=window.open(&#39;produit_show.asp?id=&lt;%=rs_produit(&quot;id&quot;)%&gt;&#39;,&#39;产品详细信息&#39;,&#39;width=895,height=503,top=142,left=115,toolbar=no,location=no,directories=no,status=no,menubar=no,resizable=no,scrollbars=yes&#39;); win.focus()&quot;&lt;%end if%&gt;&gt;<br /> &lt;%if showpic=&quot;yes&quot; then%&gt;&lt;td align=&quot;center&quot;&gt;&lt;%if rs_produit(&quot;photo&quot;)&lt;&gt;&quot;&quot; then%&gt;&lt;a href=&quot;../upload/&lt;%=rs_produit(&quot;photo&quot;)%&gt;&quot; target=&quot;_blank&quot;&gt;&lt;img src=&quot;../upload/&lt;%=rs_produit(&quot;photo&quot;)%&gt;&quot; border=&quot;0&quot; width=&quot;60&quot;&gt;&lt;/a&gt;&lt;%else%&gt;无图&lt;%end if%&gt;&lt;/td&gt;&lt;%end if%&gt;<br /> &lt;td align=&quot;center&quot; height=&quot;25&quot;&gt;&lt;%=rs_produit(&quot;huohao&quot;)%&gt;&lt;/td&gt;<br /> &lt;td align=&quot;center&quot;&gt;&lt;%=rs_produit(&quot;title&quot;)%&gt;&lt;/td&gt; <br /> &lt;td align=&quot;center&quot;&gt;&lt;%=rs_produit(&quot;guige&quot;)%&gt;&lt;/td&gt;<br /> &lt;td align=&quot;center&quot;&gt;<br /> &lt;%if rs_produit.eof=false then%&gt;&lt;%=rs_produit(&quot;danwei&quot;)%&gt;&lt;%end if%&gt;&lt;/td&gt;<br /> &lt;td align=&quot;center&quot;&gt;<br /> &lt;%<br /> sql=&quot;select * from ku where id=&quot;&amp;rs_produit(&quot;id_ku&quot;)<br /> set rs_ku=conn.execute(sql)<br /> sql=&quot;select * from produit where huohao=&#39;&quot;&amp;rs_produit(&quot;huohao&quot;)&amp;&quot;&#39;&quot;<br /> set rs_shulian=conn.execute(sql)<br /> nowshulian=0<br /> do while rs_shulian.eof=false<br /> nowshulian=nowshulian+rs_shulian(&quot;shulian&quot;)<br /> rs_shulian.movenext<br /> loop<br /> nowshulian7=nowshulian<br /> &#39;if request(&quot;ku&quot;)&lt;&gt;&quot;&quot; then<br /> &#39; nowshulian=rs_produit(&quot;shulian&quot;) <br /> &#39;end if<br /> %&gt;<br /> &lt;b&gt;&lt;%if nowshulian7&lt;rs_produit(&quot;baojin&quot;) then%&gt;&lt;font color=&quot;#ff0000&quot;&gt;&lt;%=formatnumber(nowshulian,2)%&gt;&lt;/font&gt;&lt;%else%&gt;&lt;%=formatnumber(nowshulian,2)%&gt;&lt;%end if%&gt;&lt;/b&gt;，&lt;%=rs_ku(&quot;ku&quot;)%&gt;【&lt;%=formatnumber(rs_produit(&quot;shulian&quot;),2)%&gt;】&lt;/td&gt; <br /> &lt;td align=&quot;center&quot;&gt;&lt;%=formatnumber(rs_produit(&quot;price2&quot;),2)%&gt;&lt;/td&gt;<br /> &lt;td align=&quot;center&quot;&gt;&lt;%=formatnumber(rs_produit(&quot;price&quot;),2)%&gt;&lt;/td&gt;<br /> &lt;/tr&gt;<br /> &lt;%<br /> &#39;end if<br /> rs_produit.movenext<br /> next<br /> else<br /> %&gt;<br /> &lt;tr align=&quot;center&quot; onMouseOver=&quot;this.className=&#39;highlight&#39;&quot; onMouseOut=&quot;this.className=&#39;&#39;&quot;&gt;<br /> &lt;td colspan=&quot;12&quot; height=&quot;25&quot; align=&quot;center&quot; style=&quot;color:red&quot;&gt;&lt;b&gt;没有找到记录&lt;/b&gt;&lt;/td&gt;<br /> &lt;/tr&gt;<br /> &lt;%<br /> end if<br /> %&gt;<br /> <br /> <br /> <br /> &lt;%<br /> if rs_produit.recordcount&gt;0 then <br /> %&gt; <br /> &lt;tr&gt;<br /> &lt;td colspan=&quot;12&quot; height=&quot;30&quot; class=&quot;category&quot;&gt;<br /> &lt;table cellpadding=0 cellspacing=0 width=&quot;100%&quot;&gt;<br /> &lt;tr&gt;<br /> &lt;td width=&quot;20%&quot; align=&quot;left&quot; style=&quot;color:#FF0000;&quot;&gt;&amp;nbsp;&lt;%if request(&quot;form&quot;)&lt;&gt;&quot;&quot; then%&gt;双击选择产品&lt;%else%&gt;双击查看产品详细信息&lt;%end if%&gt;&lt;/td&gt; <br /> &lt;td width=&quot;80%&quot; align=&quot;right&quot;&gt;<br /> &amp;nbsp;&amp;nbsp;<br /> &lt;%=rs_produit.recordcount%&gt;&amp;nbsp;条信息&amp;nbsp; 共&amp;nbsp;&lt;%=rs_produit.pagecount%&gt;&amp;nbsp;页&amp;nbsp;<br /> &lt;%<br /> nowstart=currentpage-3<br /> if nowstart&lt;1 then<br /> nowstart=1<br /> end if<br /> nowend=currentpage+3<br /> if nowend&gt;rs_produit.pagecount then<br /> nowend=rs_produit.pagecount<br /> end if<br /> response.write &quot;&amp;nbsp;&lt;a href=&#39;?form=&quot;&amp;request(&quot;form&quot;)&amp;&quot;&amp;field=&quot;&amp;request(&quot;field&quot;)&amp;&quot;&amp;field2=&quot;&amp;request(&quot;field2&quot;)&amp;&quot;&amp;span1=&quot;&amp;request(&quot;span1&quot;)&amp;&quot;&amp;keyword=&quot;&amp;nowkeyword&amp;&quot;&amp;ku=&quot;&amp;nowku&amp;&quot;&amp;bigclass=&quot;&amp;nowbigclass&amp;&quot;&amp;smallclass=&quot;&amp;nowsmallclass&amp;&quot;&amp;page=1&amp;order1=&quot;&amp;request(&quot;order1&quot;)&amp;&quot;&amp;order2=&quot;&amp;request(&quot;order2&quot;)&amp;&quot;&amp;order3=&quot;&amp;request(&quot;order3&quot;)&amp;&quot;&amp;order4=&quot;&amp;request(&quot;order4&quot;)&amp;&quot;&amp;order5=&quot;&amp;request(&quot;order5&quot;)&amp;&quot;&amp;order6=&quot;&amp;request(&quot;order6&quot;)&amp;&quot;&amp;order7=&quot;&amp;request(&quot;order7&quot;)&amp;&quot;&amp;order8=&quot;&amp;request(&quot;order8&quot;)&amp;&quot;&amp;order9=&quot;&amp;request(&quot;order9&quot;)&amp;&quot;&amp;order10=&quot;&amp;request(&quot;order10&quot;)&amp;&quot;&amp;order11=&quot;&amp;request(&quot;order11&quot;)&amp;&quot;&amp;order12=&quot;&amp;request(&quot;order12&quot;)&amp;&quot;&amp;order13=&quot;&amp;request(&quot;order13&quot;)&amp;&quot;&amp;order14=&quot;&amp;request(&quot;order14&quot;)&amp;&quot;&amp;order15=&quot;&amp;request(&quot;order15&quot;)&amp;&quot;&#39; class=&#39;page&#39;&gt;最前页&lt;/a&gt;&amp;nbsp;&quot;<br /> for ipage=nowstart to nowend<br /> if cstr(ipage)=cstr(currentpage) then<br /> response.write &quot;&amp;nbsp;&lt;span style=&#39;font-weight:bold;color:#5858E6&#39;&gt;&quot; &amp; ipage &amp;&quot;&lt;/span&gt;&amp;nbsp;&quot;<br /> else<br /> response.write &quot;&amp;nbsp;[&amp;nbsp;&lt;a href=&#39;?form=&quot;&amp;request(&quot;form&quot;)&amp;&quot;&amp;field=&quot;&amp;request(&quot;field&quot;)&amp;&quot;&amp;field2=&quot;&amp;request(&quot;field2&quot;)&amp;&quot;&amp;span1=&quot;&amp;request(&quot;span1&quot;)&amp;&quot;&amp;keyword=&quot;&amp;nowkeyword&amp;&quot;&amp;ku=&quot;&amp;nowku&amp;&quot;&amp;bigclass=&quot;&amp;nowbigclass&amp;&quot;&amp;smallclass=&quot;&amp;nowsmallclass&amp;&quot;&amp;page=&quot;&amp;ipage&amp;&quot;&amp;order1=&quot;&amp;request(&quot;order1&quot;)&amp;&quot;&amp;order2=&quot;&amp;request(&quot;order2&quot;)&amp;&quot;&amp;order3=&quot;&amp;request(&quot;order3&quot;)&amp;&quot;&amp;order4=&quot;&amp;request(&quot;order4&quot;)&amp;&quot;&amp;order5=&quot;&amp;request(&quot;order5&quot;)&amp;&quot;&amp;order6=&quot;&amp;request(&quot;order6&quot;)&amp;&quot;&amp;order7=&quot;&amp;request(&quot;order7&quot;)&amp;&quot;&amp;order8=&quot;&amp;request(&quot;order8&quot;)&amp;&quot;&amp;order9=&quot;&amp;request(&quot;order9&quot;)&amp;&quot;&amp;order10=&quot;&amp;request(&quot;order10&quot;)&amp;&quot;&amp;order11=&quot;&amp;request(&quot;order11&quot;)&amp;&quot;&amp;order12=&quot;&amp;request(&quot;order12&quot;)&amp;&quot;&amp;order13=&quot;&amp;request(&quot;order13&quot;)&amp;&quot;&amp;order14=&quot;&amp;request(&quot;order14&quot;)&amp;&quot;&amp;order15=&quot;&amp;request(&quot;order15&quot;)&amp;&quot;&#39; class=&#39;page&#39;&gt;&quot; &amp; ipage &amp;&quot;&lt;/a&gt;&amp;nbsp;]&amp;nbsp;&quot;<br /> end if<br /> next<br /> response.write &quot;&amp;nbsp;&lt;a href=&#39;?form=&quot;&amp;request(&quot;form&quot;)&amp;&quot;&amp;field=&quot;&amp;request(&quot;field&quot;)&amp;&quot;&amp;field2=&quot;&amp;request(&quot;field2&quot;)&amp;&quot;&amp;span1=&quot;&amp;request(&quot;span1&quot;)&amp;&quot;&amp;keyword=&quot;&amp;nowkeyword&amp;&quot;&amp;ku=&quot;&amp;nowku&amp;&quot;&amp;bigclass=&quot;&amp;nowbigclass&amp;&quot;&amp;smallclass=&quot;&amp;nowsmallclass&amp;&quot;&amp;page=&quot;&amp;rs_produit.pagecount&amp;&quot;&amp;order1=&quot;&amp;request(&quot;order1&quot;)&amp;&quot;&amp;order2=&quot;&amp;request(&quot;order2&quot;)&amp;&quot;&amp;order3=&quot;&amp;request(&quot;order3&quot;)&amp;&quot;&amp;order4=&quot;&amp;request(&quot;order4&quot;)&amp;&quot;&amp;order5=&quot;&amp;request(&quot;order5&quot;)&amp;&quot;&amp;order6=&quot;&amp;request(&quot;order6&quot;)&amp;&quot;&amp;order7=&quot;&amp;request(&quot;order7&quot;)&amp;&quot;&amp;order8=&quot;&amp;request(&quot;order8&quot;)&amp;&quot;&amp;order9=&quot;&amp;request(&quot;order9&quot;)&amp;&quot;&amp;order10=&quot;&amp;request(&quot;order10&quot;)&amp;&quot;&amp;order11=&quot;&amp;request(&quot;order11&quot;)&amp;&quot;&amp;order12=&quot;&amp;request(&quot;order12&quot;)&amp;&quot;&amp;order13=&quot;&amp;request(&quot;order13&quot;)&amp;&quot;&amp;order14=&quot;&amp;request(&quot;order14&quot;)&amp;&quot;&amp;order15=&quot;&amp;request(&quot;order15&quot;)&amp;&quot;&#39; class=&#39;page&#39;&gt;最后页&lt;/a&gt;&amp;nbsp;&quot;<br />%&gt;<br /> &lt;select name=&quot;page&quot; onChange=&quot;form1.action=&#39;?&#39;;form1.submit();&quot;&gt;<br />&lt;%<br /> for x=1 to rs_produit.pagecount<br />%&gt;<br /> &lt;option value=&quot;&lt;%=x%&gt;&quot;&lt;%if currentpage=trim(cstr(x)) then%&gt; selected=&quot;selected&quot;&lt;%end if%&gt;&gt;&lt;%=x%&gt;&lt;/option&gt;<br />&lt;% <br /> next<br />%&gt;<br /> &lt;/select&gt;<br /> &lt;/td&gt;<br /> &lt;/tr&gt;&lt;/table&gt;&lt;/td&gt;&lt;/tr&gt;<br />&lt;%end if%&gt;<br />&lt;/form&gt; <br />&lt;/table&gt;<br />[bad html removed]endprint--&#62;<br />&lt;/td&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br />&lt;tr&gt;<br />&lt;td&gt;&lt;img src=&quot;../images/r_4.gif&quot; alt=&quot;&quot; /&gt;&lt;/td&gt;<br />&lt;td&gt;&lt;/td&gt;<br />&lt;td&gt;&lt;img src=&quot;../images/r_3.gif&quot; alt=&quot;&quot; /&gt;&lt;/td&gt;<br />&lt;/tr&gt;<br />&lt;/table&gt;<br />&lt;/body&gt;<br />&lt;/html&gt;<br /><!--SPOILER DIV--></div><!--SPOILER DIV--><br /><br />Problem 1 = Error at Line 140 and 154 soiboy Codemasters Fri, 03 Sep 2010 13:57:17 +0800 http://forum.lowyat.net/topic/0 Content Creators, Blogmasters &amp; Webmasters Thu, 01 Jan 1970 07:30:00 +0800 http://forum.lowyat.net/topic/488556 Who know how to find Visual Effect for Party like RnB and Trance ? <br /><br />the effect is like those in window media player Visualisation... but is there anymore better one that can follow the song rythmes ??<br /><br />Better if it&#39;s not in window media player one... soiboy Photography, Digital Imaging &amp; Video Sun, 15 Jul 2007 19:37:20 +0800 http://forum.lowyat.net/topic/323877 soiboy Latest Updates Mon, 07 Aug 2006 19:32:20 +0800 http://forum.lowyat.net/topic/323873 soiboy Latest Updates Mon, 07 Aug 2006 19:26:51 +0800