<!--#include file="../checkLogin.asp"-->
<!--#include file="../SQLconn.asp"-->

<html>
<head><title></title><meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<link rel="stylesheet" type="text/css" href="../images/<%=request.cookies("imgdir")%>/css/style.css" media="all"/>

<style type="text/css">
<!--
.STYLE3 {color: #990033}
-->
</style>
<body>
<table width="100%" height="495" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr>
    <td height="27">
	<div class="header">
	<div class="nav">
        <ul>
          
            <li><a href="shenqing.asp" target="_self">申请印刷资料</a></li>
		
            <li><a href="main.asp" target="_self">印刷资料审批</a></li>	
			<li class="on">印刷资料统计</li>
        </ul>
    </div>	
	</td>
  </tr>
 
  <tr>
    <td height="470" valign="top"   class="NemuMainBox">
	 <br>
	
	 
	 <FORM ACTION="jiketongji.asp" METHOD="GET" enctype="multipart/form-data" NAME="ftype">

     <div align="center">
    <div align="center">
      <% 
	
	years=request.cookies("nowxueqi")
	%>
       
				<% 
			 
				Set RS = Conn.Execute("select grade,subject,guige,danshuangmian,sum(banzhishu) as banzhishuliang,sum(yinjuanshu) as shuliang  FROM yinshua where (xueqi='"&years& "')  and (beikezuzhang<>'')  and    (jiaodaochu<>'不同意印刷')   group by grade,subject,guige,danshuangmian order by  danshuangmian desc, grade,shuliang  desc")
				%>
			    <br>
  </div>
    <table width="95%" align="center" border="1" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">   
<tr style="background-color:#D6E4FF"  class="TableHeader">
  <td height="23" colspan="6" class="STYLE1" ><div align="center">级科统计</div></td>
  <tr style="background-color:#D6E4FF"  class="TableHeader">
				
	  <td width="321" height="23" class="STYLE1" ><div align="center">年级</div></td>  
				 <td width="344" class="STYLE1" ><div align="center">科组</div></td>
				 <td width="344" class="STYLE1" ><div align="center">规格</div></td>
				 <td width="344" class="STYLE1" ><div align="center">单双面</div></td>
				 <td width="344" class="STYLE1" ><div align="center">板纸数</div></td>
				 <td width="344" height="23" class="STYLE1" ><div align="center">试卷张数</div></td> 
				<% While NOT RS.EOF %>
      <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
	     <td width="321" height="26" class="STYLE1" ><div align="center"><%=rs("grade")%></div></td>  
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("subject")%></div></td>
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("guige")%></div></td>
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("danshuangmian")%></div></td>
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("banzhishuliang")%></div></td>
				    <td width="344" height="26" class="STYLE1" ><div align="center"><%=rs("shuliang")%></div></td>  
      </tr>
				<% RS.MoveNext 
				  Wend
				  RS.Close%>
  </table>
    <% 
			 
				Set RS = Conn.Execute("select grade,danshuangmian,sum(banzhishu) as banzhishuliang,sum(yinjuanshu) as shuliang  FROM yinshua where xueqi='"&years& "' and beikezuzhang<>''  and  jiaodaochu<>'不同意印刷'  group by grade,danshuangmian order by  danshuangmian desc, shuliang  desc")
				%>
			    <br>
  </div>
    <table width="95%" align="center" border="1" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">   
<tr style="background-color:#D6E4FF"  class="TableHeader">
  <td height="23" colspan="6" class="STYLE1" ><div align="center">级部统计</div></td>
  <tr style="background-color:#D6E4FF"  class="TableHeader">
				
	  <td width="321" height="23" class="STYLE1" ><div align="center">年级</div></td>  
		
				 <td width="344" class="STYLE1" ><div align="center">单双面</div></td>
				 <td width="344" class="STYLE1" ><div align="center">板纸数</div></td>
				 <td width="344" height="23" class="STYLE1" ><div align="center">试卷张数</div></td> 
				<% While NOT RS.EOF %>
      <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
	     <td width="321" height="26" class="STYLE1" ><div align="center"><%=rs("grade")%></div></td>  
				
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("danshuangmian")%></div></td>
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("banzhishuliang")%></div></td>
				    <td width="344" height="26" class="STYLE1" ><div align="center"><%=rs("shuliang")%></div></td>  
      </tr>
				<% RS.MoveNext 
				  Wend
				  RS.Close%>
  </table>
	
	
	
	
    <% 
			 
				Set RS = Conn.Execute("select subject,danshuangmian,sum(banzhishu) as banzhishuliang,sum(yinjuanshu) as shuliang  FROM yinshua where xueqi='"&years& "'  and beikezuzhang<>'' and  jiaodaochu<>'不同意印刷'  group by subject,danshuangmian order by danshuangmian desc,  shuliang  desc")
				%>
			    <br>
  </div>
    <table width="95%" align="center" border="1" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">   
<tr style="background-color:#D6E4FF"  class="TableHeader">
  <td height="23" colspan="6" class="STYLE1" ><div align="center">科组统计</div></td>
  <tr style="background-color:#D6E4FF"  class="TableHeader">
				
	    
				 <td width="344" class="STYLE1" ><div align="center">科组</div></td>
				
				 <td width="344" class="STYLE1" ><div align="center">单双面</div></td>
				 <td width="344" class="STYLE1" ><div align="center">板纸数</div></td>
				 <td width="344" height="23" class="STYLE1" ><div align="center">试卷张数</div></td> 
				<% While NOT RS.EOF %>
      <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
	    
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("subject")%></div></td>
				 
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("danshuangmian")%></div></td>
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("banzhishuliang")%></div></td>
				    <td width="344" height="26" class="STYLE1" ><div align="center"><%=rs("shuliang")%></div></td>  
      </tr>
				<% RS.MoveNext 
				  Wend
				  RS.Close%>
  </table>
	
	
	
	
	
	 <% '个人统计个人统计个人统计个人统计个人统计个人统计个人统计个人统计
			 
				Set RS = Conn.Execute("select danshuangmian,sum(banzhishu) as banzhishuliang,sum(yinjuanshu) as shuliang,teacher  FROM yinshua where xueqi='"&years& "'  and  beikezuzhang<>''  and  jiaodaochu<>'不同意印刷' group by danshuangmian ,danshuangmian,teacher  order by  danshuangmian desc, shuliang desc")
				%>
			    <br>
  </div>
    <table width="95%" align="center" border="1" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">   
<tr style="background-color:#D6E4FF"  class="TableHeader">
  <td height="23" colspan="6" class="STYLE1" ><div align="center">教师统计</div></td>
  <tr style="background-color:#D6E4FF"  class="TableHeader">
				
	             
				 <td width="344" class="STYLE1" ><div align="center">教师</div></td>
				
				 <td width="344" class="STYLE1" ><div align="center">单双面</div></td>
				 <td width="344" class="STYLE1" ><div align="center">板纸数</div></td>
				 <td width="344" height="23" class="STYLE1" ><div align="center">试卷张数</div></td> 
				<% While NOT RS.EOF %>
      <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
	    
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("teacher")%></div></td>
				 
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("danshuangmian")%></div></td>
				    <td width="344" class="STYLE1" ><div align="center"><%=rs("banzhishuliang")%></div></td>
				    <td width="344" height="26" class="STYLE1" ><div align="center"><%=rs("shuliang")%></div></td>  
      </tr>
				<% RS.MoveNext 
				  Wend
				  RS.Close%>
  </table>
	
	
	
	
    <p>&nbsp;</p>
</FORM>	  </td>
  </tr>
</table>
</body>
</html>
