k_dqkctj.asp

一个很好的在线购物系统

   <td width="283" align="right" bgcolor="#F1E8DA" bordercolor="#F1E8DA" bordercolorlight="#F1E8DA" >      
      
        
   <p align="left">     
   <font size="2"><input type="submit" value="查询" class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1" >     
   </font>     
  </td>     
 </tr>     
</table>                                                                                           
                                                                                          
<p align="center">     
                                                                                          
<%                                
 if rst.eof then%>                                
                        
<font size="2">无记录！<font size="2"><a href="k_tjcx.htm">返回</a>                                    
                                 
                                     
                                                        
 <%                                       
 response.end                                       
 else                                                                                                                          
   if request.querystring("page")<>"" then                                                                                                                         
      page=cint(request.querystring("page"))                                                                                                                        
   else                                                                                                                        
      page=1                                                                                                                        
   end if                                                                                                                        
                                                                                                                        
rst.pagesize=10                                                                                                                       
if page>=rst.pagecount then                                                                                                                        
   page=rst.pagecount                                                                                                                        
else                                                                                                                        
   if page<1 then                                                                                                                        
      page=1                                                                                                                        
   end if                                                                                                                        
end if                                                                                                                        
rst.absolutepage=page                                                                                                                        
                                                                                                                         
%>                                                                                     
                                                                                            
<div align="center" style="width: 655; height: 62">                                                
                                                                                                              
                                                                                                                                  
<table border="1" cellspacing="0" width="616" height="30" width="100%" width="100%">                                                                                                                          
             
 </font>                             
                                               
                                                  
  <tr>                                                                                                                                          
                                                                                                                          
    <td width="70" height="24" align="center" width="131" bgcolor="#DDD2C4" valign="middle">                                                                                                                       
     仓库名称           
     </td>                                                                                                                                     
                                                                                                                          
     <td width="123" height="24" align="center" width="98" bgcolor="#DDD2C4" valign="middle">                                                                                                                    
      <font size="2">品名规格</font>          
     </td>                                                                                                                                    
                                                                                                                                       
    <td width="108" height="24" align="center" width="120" bgcolor="#DDD2C4" valign="middle">                                                                                                                   
     当前库存货数量         
     </td>                                                                                                                                   
    <td width="115" height="24" align="center" width="146" bgcolor="#DDD2C4" valign="middle">                                                                                                                  
     <font size="2">当前可开单数量
     </font>
     </td>                                                                                                                                  
                                                                                                                                    
  </tr>                                                                                                                             
                                                                                                                             
<font size="2">                                                                                                                             
                                                                                                                             
   <% for n=1  to rst.pagesize%>                                                 
        <%if  n mod 2=1 then                                                       
            bg="#f7f7f7"                                                         
       else                                                       
            bg="#EDEBEC"                                                        
       end if%>                                                                                                                           
                                                                                                                               
  <tr bgcolor="<%=bg%>">                                                                                           
                                                                                                    
                                                                                                                                                                              
      <td width="94" height="23" align="center" width="131" valign="middle"><font size="2"><%=rst("ckxh")%></font></td>                                         
         <%
          set rssp=Server.Createobject("ADODB.recordset")
          sql="select *  from A_ProductInfo where ProdCode='"&rst("spxh")&"'"
          rssp.open sql,Pubconn,1
         if not rssp.eof then
             spmc=rssp("ProdName")
             ggxh=rssp("Model")+"-"+rssp("stanDard")
        end if 
        rssp.close
        set rssp=nothing
        
        %>                                                                                                                                         
      <td width="123" height="23" align="center" width="98" valign="middle"><font size="2"><%=spmc%>/<%=ggxh%>                                        
       </font>                                        
    </td>                                                                                                                          
      <td width="108" height="23" align="center" width="120" valign="middle"><font size="2"></font><%=rst("total1")%></td>                                                                                                                          
      <td width="115" height="23" align="center" width="146" valign="middle"><%=rst("total2")%></td>                                                                                                                           
                                                                                                          
                                                                                                                               
                                                                                                               
                                                                                                             
                                                                                                                          
                                                                                                                          
  </tr>                                                                                                              
  <%                                                                                                           
     rst.movenext                                                                                                              
     if rst.eof then exit for                                                                                                              
  next                                                                                                              
  %>                                                                                                                             
 </table>                                                                                                                             
                                                                                                            
</div>                                      
                                                                                                            
<p align="center">                                                                                                           
<font size="2">                                                                                                                            
   共<%=rst.pagecount%>页&nbsp; 第<%=page%>页&nbsp;&nbsp;&nbsp;&nbsp; <a href="k_dqkctj.asp?page=1&spxh=<%=spxh%>&ckxh=<%=ckxh%>">首页</a>&nbsp;<%if page>1 then %>                                                                                                                                                       
   <a href="k_dqkctj.asp?page=<%=(page-1)%>&spxh=<%=spxh%>&ckxh=<%=ckxh%>">上页</a>&nbsp;                                                                                                                                                      
   <% else%>                                                                                                                                                      
   上页&nbsp;                                                                                                                                                      
  <%  end if%>                                                                                                                                                      
    <%if page<rst.pagecount then %>                                                                                                                                                     
   <a href="k_dqkctj.asp?page=<%=(page+1)%>&spxh=<%=spxh%>&ckxh=<%=ckxh%>">下页</a>&nbsp;                                                                                                                                                      
   <% else %>                                                                                                                                                     
   下页&nbsp;                                                                                                                                                      
  <%end if%><a href="k_dqkctj.asp?page=<%=rst.pagecount%>&spxh=<%=spxh%>&ckxh=<%=ckxh%>">尾页</a>&nbsp;&nbsp;</font>                                                           
                                                            
                                                           
                                                                                                                                                   
      <select  name="page1" style="width:80" size="1">                                                                      
                                                                             
                                                             
       <% for count=1 to rst.pagecount%>                                                                                              
         <option value="<%=count%>">第<%=count%>页</option>                                                 
       <%next%>                                                                       
                                                                               
      </select><input type="button" value="GO" onclick="Gopage()"  class="hand" style="background-color: #D1D1D1; border-style: solid; border-width: 1">                                    
                                      
   &nbsp; <a href="javascript:window.print()">打印</a>
                            
                                                              
 </form>                                      
                                                                                                                                 
<%                                    
rst.close                                    
set rst=nothing                                    
end if             
  %>                                                     
<p>       
<font size="2"><a href="k_tjcx.htm">返回</a>                                                  
                                            
                                                    
                                           
                             
                                            
                                                    
</font>     
                                            
                                                    
                                           
                             
                                            
                                                    
</font> 
                                            
                                                    
                                           
                             
                                            
                                                    
</body>