k_pdsytj.asp

一个很好的在线购物系统

           ><%=i%></option>                                              
       <%next%>                            
                                      
                                                                                    
      </select>日&nbsp; 　 
  </font> 
  </td> 
 </tr> 
 <tr> 
  <td width="71" bgcolor="#F1E8DA" bordercolor="#F1E8DA" bordercolorlight="#F1E8DA" align="right"> 
 
   
   <font size="2"> 
 
   
   仓库 
   </font> 
  </td> 
   <td width="176" align="right" bgcolor="#F1E8DA" bordercolor="#F1E8DA" bordercolorlight="#F1E8DA" > 
 
    <p align="left"> 
    <font size="2"> 
    <select size="1" name="ckxh" style="width: 131; height: 23"> 
   <option value="">全部</option>        
           <%for i=0 to UBound(storemc) %>        
             <option value="<%=storemc(i)%>" <%if ckxh=storemc(i)  then%> selected <%end if %>><%=storemc(i)%></option>                                                      
           <%next %>                          </select>  
  
  
    </font>  
  
  
  </td>  
   <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">无记录！  
<%if fhbz<>2 then%>  
 <font size="2"><a href="k_pdsybrow.asp">返回</a>  
 <%else%>  
  <font size="2"><a href="k_tjcx.htm">返回</a>  
 <%end if %>  
                              
                          
                              
                                                 
 <%                                
 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="96" height="48" align="center" width="131" bgcolor="#DDD2C4" rowspan="2" valign="middle">                                                                                                                
     仓库名称    
     </td>                                                                                                                              
     <td width="320" height="24" align="center" width="98" bgcolor="#DDD2C4" colspan="3">                                                                                                             
      时间段：&nbsp;<font color="blue"><%if total1<>"" then    
                    response.write total1    
                else    
                    response.write "0000-00-00"    
                end if     
          
      %></font>&nbsp;至&nbsp;<font color="blue"><%if total2<>"" then    
                    response.write total2    
                else    
                    response.write "9999-99-99"    
                end if     
          
      %></font>    
     </td>                                                                                                                              
                                                                                                                                 
  </tr>                                                                                                                        
                                                                                                                        
                                           
  <tr>                                                                                                                                   
                                                                                                                   
     <td width="120" height="24" align="center" width="98" bgcolor="#DDD2C4" valign="middle">                                                                                                             
      <font size="2">商品名称    
      </font>    
     </td>                                                                                                                              
                                                                                                                                 
    <td width="117" height="24" align="center" width="120" bgcolor="#DDD2C4" valign="middle">                                                                                                             
     总损溢量    
     </td>                                                                                                                              
    <td width="83" 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="120" height="23" align="center" width="131" valign="middle"><font size="2"><%=rst("ckxh")%></font></td>                                    
                                                                                                                        
      <td width="120" height="23" align="center" width="98" valign="middle"><font size="2"><%=Sname(rst("prodcode"))%>                                   
       </font>                                   
    </td>                                                                                                                     
      <td width="117" height="23" align="center" width="120" valign="middle"><font size="2"></font><%=rst("total1")%></td>                                                                                                                     
      <td width="83" 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_pdsytj.asp?page=1&year1=<%=year1%>&month1=<%=month1%>&date1=<%=date1%>&year2=<%=year2%>&month2=<%=month2%>&date2=<%=date2%>&ckxh=<%=ckxh%>">首页</a>&nbsp;<%if page>1 then %>                                                                                                                                                
   <a href="k_pdsytj.asp?page=<%=(page-1)%>&year1=<%=year1%>&month1=<%=month1%>&date1=<%=date1%>&year2=<%=year2%>&month2=<%=month2%>&date2=<%=date2%>&ckxh=<%=ckxh%>">上页</a>&nbsp;                                                                                                                                               
   <% else%>                                                                                                                                               
   上页&nbsp;                                                                                                                                               
  <%  end if%>                                                                                                                                               
    <%if page<rst.pagecount then %>                                                                                                                                              
   <a href="k_pdsytj.asp?page=<%=(page+1)%>&year1=<%=year1%>&month1=<%=month1%>&date1=<%=date1%>&year2=<%=year2%>&month2=<%=month2%>&date2=<%=date2%>&ckxh=<%=ckxh%>">下页</a>&nbsp;                                                                                                                                               
   <% else %>                                                                                                                                              
   下页&nbsp;                                                                                                                                               
  <%end if%><a href="k_pdsytj.asp?page=<%=rst.pagecount%>&year1=<%=year1%>&month1=<%=month1%>&date1=<%=date1%>&year2=<%=year2%>&month2=<%=month2%>&date2=<%=date2%>&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="k_pdsybrow.asp?year1=<%=year1%>&month1=<%=month1%>&date1=<%=date1%>&year2=<%=year2%>&month2=<%=month2%>&date2=<%=date2%>&ckxh=<%=ckxh%>&flag=1">明细查询</a>                                                    
&nbsp; <a href="javascript:window.print()">打印</a>  
  
 </form>                                                                                                             
<%                            
rst.close                            
set rst=nothing                            
end if     
  %>                                             
                                          
                                             
                           
                                             
                     
                                    
                                            
 <p>  
 <%if fhbz<>2 then%>  
 <font size="2"><a href="k_pdsybrow.asp">返回</a>  
 <%else%>  
  <font size="2"><a href="k_tjcx.htm">返回</a>  
 <%end if %>                                         
                                             
                           
                                             
                     
                                    
                                            
</body>