k_outtj.asp

一个很好的在线购物系统

   if page<1 then                                                                                                                            
      page=1                                                                                                                            
   end if                                                                                                                            
end if                                                                                                                            
rstj.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="4">                                                                                                                        
      时间段：&nbsp;<font  color="blue"><%if total1<>"" then               
                    response.write total1               
                else               
                    response.write "0000-00-00"               
                end if                
                     
      %></font>至&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">                                                                                                                       
     <font size="2">销售出库数量</font>   
     </td>                                                                                                                                    
                                                                                                                                         
    <td width="83" height="24" align="center" width="146" bgcolor="#DDD2C4" valign="middle">                                                                                                                   
     <font size="2">盘点报亏数量     
     </font>     
     </td>                                                                                                                                  
                                                                                                                                    
    <td width="83" height="24" align="center" width="146" bgcolor="#DDD2C4" valign="middle">                                                                                                                   
     合计数量    
     </td>                                                                                                                                 
                                                                                                                                   
  </tr>                                                                                                                            
                                                                                                                            
<font size="2">                                                                                                                            
                                                                                                                            
   <% for n=1  to rstj.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"><%=rstj("ckxh")%></font></td>                                        
        <%  
          set rssp=Server.Createobject("ADODB.recordset")  
          sql="select *  from A_ProductInfo where ProdCode='"&rstj("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="120" height="23" align="center" width="98" valign="middle"><font size="2"><%=spmc%>/<%=ggxh%>                                       
       </font>                                       
    </td>                                                                                                                         
      <td width="117" height="23" align="center" width="120" valign="middle"><%=rstj("total1")%></td>                                                                                                                         
      <td width="83" height="23" align="center" width="146" valign="middle"><%=abs(rstj("total2"))%></td>                                                                                                                          
                                                                                                         
                                                                                                                              
            <%  
            hjsl=cdbl(rstj("total1"))+abs(cdbl(rstj("total2")))  
            %>                                                                                                  
                                                                                                            
                                                                                                                         
                                                                                                                         
      <td width="83" height="23" align="center" width="146" valign="middle"><%=hjsl%></td>                                                                                                                          
                                                                                                         
                                                                                                                              
                                                                                                              
                                                                                                            
                                                                                                                         
                                                                                                                         
  </tr>                                                                                                             
  <%                                                                                                          
     rstj.movenext                                                                                                             
     if rstj.eof then exit for                                                                                                             
  next                                                                                                             
  %>                                                                                                                            
 </table>                                                                                                                            
                                                                                                           
</div>                                     
                                                                                                           
<p align="center">                                                                                                          
<font size="2">                                                                                                                           
   共<%=rstj.pagecount%>页&nbsp; 第<%=page%>页&nbsp;&nbsp;&nbsp;&nbsp; <a href="k_outtj.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_outtj.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<rstj.pagecount then %>                                                                                                                                                    
   <a href="k_outtj.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_outtj.asp?page=<%=rstj.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 rstj.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">                                         
      <a href="k_outtjdetail.htm?year1=<%=year1%>&month1=<%=month1%>&date1=<%=date1%>&year2=<%=year2%>&month2=<%=month2%>&date2=<%=date2%>&ckxh=<%=ckxh%>">明细查询</a>                                    
                                                        
                                             
   &nbsp; <a href="javascript:window.print()">打印</a>
                                 
                                                                   
 </form>                                           
                                                                                                                                      
<%                                         
rstj.close                                         
set rstj=nothing                                         
end if                  
  %>                                                          
<p>            
<font size="2"><a href="k_tjcx.htm">返回</a>                                                       
                                                 
                                         
                                  
                                                 
                                                         
</font>       
                                                 
                                                         
                                                
                                  
                                                 
                                                         
</body>