<!--#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"/>

<body>
<script Language="JavaScript">
function form_check(){
if(document.form3.sendto.value.length<1){window.alert("请选择收短信人");document.form3.sendto.focus();return (false);}
if(document.form3.CONTENT.value.length<1){window.alert("请输入内容");document.form3.CONTENT.focus();return (false);}
if(document.form3.CONTENT.value.length>100){window.alert("短信内容超过100字了，请您移步到内部邮件发送！");document.form3.CONTENT.focus();return (false);}
}

function inputname(strname)
{
form3.sendto.value=strname;	
document.form3.CONTENT.focus();return (false);		
}



</script>
<%
'检查权限
 set RsPowder=Conn.Execute("select p.powderdetail  from teachers t,teacherpowder p  where t.powdergroup=p.powdergroup and tname='"&request.cookies("tname")&"' and powderdetail='员工档案'")
	 if  RsPowder.eof and  RsPowder.bof then
		response.redirect  "../NoPower.asp"
	 end if 
sPowder.close
'检查权限结束
%>
<%
	    xingming=request("xingming")
		 leibie=request("leibie")	
		  jibie=request("jibie")		 
		 xingming=request("xingming")	    
		
				 
		
	%>
<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="ZhengShuAdd.asp?xingming=<%=xingming%>">新增证书</a></li>
            <li><a href="ZhengShuList.asp?xingming=<%=xingming%>">证书列表</a></li>
			<li class="on">证书查询</li>
			<li><a href="ZhengShuTotal.asp?xingming=<%=xingming%>">证书汇总</a></li>
        </ul>
    </div>	
	</td>
  </tr>
  <tr>
   <td height="400" valign="top"   class="NemuMainBox">
	 <br>
	 <FORM ACTION="ZhengSHuFind.asp" METHOD="get" enctype="multipart/form-data" NAME="form1"><div align="center">
  <table width="95%" border="1" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtablehui">
     <tr style="background-color:#D6E4FF"  class="TableHeader">
   <td height="30" colspan="3" align="center" nowrap="nowrap" class="NemuNot"><span class="STYLE1 STYLE2">
  
  <table width="535" border="0" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8" >   
      <tr>
        <td width="48" nowrap class="STYLE1"><div align="right">类别：</div></td>
        <td width="55" class="STYLE1"><div align="center">
            <select name="leibie" id="leibie"  >
              <option><%=leibie%></option>
              <option></option>
              <% Set RSsel = Conn.Execute("select vname from  varset where name='zhengshutype'")
								   While NOT RSsel.EOF %>
              <OPTION value=<%=RSsel( "vname" )%>><%=RSsel( "vname" )%></OPTION>
              <% RSsel.MoveNext
								  Wend
								  RSsel.Close%>
            </select>
        </div></td>
       
        <td width="57" class="STYLE1"><div align="right">级别：</div></td>
        <td width="3" class="STYLE1">
		<select name="jibie" id="jibie">
					  <option><%=jibie%></option>  
					  <option></option>
					   <% Set RSsel = Conn.Execute("select vname,shuoming from  varset where name='zhengshujibie'")
								   While NOT RSsel.EOF %>
						
						<OPTION><%=RSsel( "vname" )%></OPTION>
						<% RSsel.MoveNext
								  Wend
								  RSsel.Close%>
		  </select>
		
		
		</td>
        <td width="159" class="STYLE1"><div align="right">姓名：</div></td>
        <td width="89" class="STYLE1"><div align="center">
          <input name="xingming" class="text" id="xingming"  size=10 maxlength="30" value=<%=xingming%>>
        </div></td>
        <td width="18" class="STYLE1">&nbsp;</td>
        <td width="58" class="STYLE1"><div align="center">
          <input name="submit" type="submit" class="topanniu" value="查询">
        </div></td>
      </tr>
    </table></td>
      </tr>
    </table>
	
    </div>
  <br>
			



<%		
		Id=request("id")
		 
	%>

 			  <table width="95%" border="1" align="center" cellspacing="0"  class="mtable">
<tr>          <td align="center" valign="middle" class="STYLE1" >序号</td> 
		      <td align="center" valign="middle" class="STYLE1" >发证日期</td>
			  <td align="center" valign="middle" class="STYLE1" >教师姓名</td> 				  
		      <td height="30" align="center" valign="middle" class="STYLE1" >证书类别</td>
			  <td align="center" valign="middle" class="STYLE1" >证书级别</td>			  
			  <td align="center" valign="middle" class="STYLE1" >发证机关</td>
			  <td align="center" valign="middle" class="STYLE1" >内容说明</td>
		      <td align="center" valign="middle" class="STYLE1" >图片文件</td> 
			  <td align="center" valign="middle" class="STYLE1" >登记日期</td> 
			  <td align="center" valign="middle" class="STYLE1" >登记人</td> 
			    </tr>
				<% 
			 	sql="select  *  from  EmployeeZhengshu   where   (leibie like  '%"&leibie&"%')    AND (jibie like  '%"&jibie&"%')   AND (tname like  '%"&xingming&"%')    order by  datetime desc"
			    Set rs=Server.CreateObject("Adodb.Recordset")
			    rs.open sql,conn,1,1
				j=0
			    while not rs.eof and not rs.bof
				 							
				    j=j+1
				 %>
				
				<tr>  
				  <td width="5%" align="center" valign="middle" class="STYLE1" ><%=j%></td>
				  <td width="10%" align="center" valign="middle" class="STYLE1" ><%=rs("datetime")%></td>
				  <td width="8%" height="30" align="center" valign="middle" class="STYLE1" ><%=rs("tname")%> </td>  				
		
                  <td width="8%" align="center" valign="middle" class="STYLE1" ><%=rs("leibie")%></td>
			      <td width="8%" align="center" valign="middle" class="STYLE1" ><%=rs("jibie")%></td>
			    
				  <td width="15%" align="center" valign="middle" class="STYLE1" ><%=rs("发证机关")%></td>
				  <td width="15%" align="center" valign="middle" class="STYLE1" ><%=rs("shuoming")%></td>
				  <td width="8%" align="center" valign="middle" class="STYLE1" ><a href="showBigimg.asp?id=<%=rs("id")%>" target="_blank">
				图片</a></td>  
				<td width="10%" align="center" valign="middle" class="STYLE1" ><%=rs("登记日期")%></td>
				<td width="10%" align="center" valign="middle" class="STYLE1" ><%=rs("登记人")%></td>
			    </tr>
				 <%  rs.movenext
    wend
%>
  </table>
	 
	 
	 
	
	




</FORM>
 
	 
	
	
    </td>
  </tr>
</table>
</body>
</html>
