k_intj.asp

一个很好的在线购物系统

                                                                                                               
                                                                                                                                   
<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="5">                                                                                                                     
      时间段：&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">                                                                                                                    
     <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>                                                                                                                                
                                                                                                                                  
    <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="117" height="23" align="center" width="120" valign="middle"><font size="2"></font><%=rstj("total2")%></td>                                                                                                                       
      <td width="83" height="23" align="center" width="146" valign="middle"><%=rstj("total3")%></td>                                                                                                                        
                                                                                                       
                                                                                                                            
            <%
            hjsl=cdbl(rstj("total1"))+cdbl(rstj("total2"))+cdbl(rstj("total3"))
            %>                                                                                                
                                                                                                          
                                                                                                                       
                                                                                                                       
      <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_intj.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_intj.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_intj.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_intj.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">                                      
                                        
  &nbsp; <a href="javascript:window.print()">打印</a>
                               
                                                                
 </form>                                        
 
<script language="vbscript">
sub mxcx1()
    
   year1=document.theform.year1.value
   month1=document.theform.month1.value
   date1=document.theform.date1.value
   year2=document.theform.year2.value
   month2=document.theform.month2.value
   date2=document.theform.date2.value
   ckxh=document.theform.ckxh.value

   ckxh=document.theform.ckxh.value
   
   window.open "k_intjdetail.asp?year1="+year1+"&month1="+month1+"&date1="+date1+"&year2="+year2+"&month2="+month2+"&date2="+date2+"&ckxh="+ckxh,"明细查询","menubar=no,status=no,width=750,height=500,scrollbars=yes" 
end sub 
</script>    


   <form action="" name="theform" method="post">
       <input type="hidden" name="year1" value="<%=year1%>">   
       <input type="hidden" name="month1" value="<%=month1%>"> 
       <input type="hidden" name="date1" value="<%=date1%>"> 
        <input type="hidden" name="year2" value="<%=year2%>">   
       <input type="hidden" name="month2" value="<%=month2%>"> 
       <input type="hidden" name="date2" value="<%=date2%>">
       <input type="hidden" name="ckxh" value="<%=ckxh%>"> 
                       
                        
 &nbsp;    <a href="#" onclick="mxcx1()">明细查询</a>                                                  
</form>                                                                                                                                                              
<%                                      
rstj.close                                      
set rstj=nothing                                      
end if               
  %>                                                       
<p>         
<font size="2"><a href="k_tjcx.htm">返回</a>                                                    
                                              
                                                      
                                             
                               
                                              
                                                      
</font>    
                                              
                                                      
                                             
                               
                                              
                                                      
</body>