<!--#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="../css/style.css" />
</head>

<body>
    <%
   

'检查权限
       tname=request.cookies("tname") 
       Set MyOAASPObj= Server.CreateObject("YFSchoolOApro.YFSchoolDll")
           if MyOAASPObj.QuanXian(tname,"员工档案")=0 then 	   
		      
		              response.redirect  "../NoPower.asp"
			end if 
	           

'检查权限结束
%>
<%		
			xingbie = TRIM( Request( "xingbie" ) )
			xueli = TRIM( Request( "xueli" ) )
			xuewei = TRIM( Request( "xuewei" ) )
			xueke = TRIM( Request( "xueke" ) )
			zhicheng = TRIM( Request( "zhicheng" ) )
			
			zhengzhi = TRIM( Request( "zhengzhi" ) )
			gangwei = TRIM( Request( "gangwei" ) )
			xinji = TRIM( Request( "xinji" ) )
			pingxin = TRIM( Request( "pingxin" ) )
			pingren = TRIM( Request( "pingren" ) )
			 
		
			%>
 
<form name="form1" method="post" action="FindDangAn.asp">
 <table border="0" align="center" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8">
  <TR>
    <TD nowrap class="STYLE1"><div align="center"><strong>性&nbsp;&nbsp;别</strong></div></TD>
    <TD nowrap class="STYLE1">
      <div align="center">
        <input  name="xingbie" class="text" id="xingbie" size="12"  value=<%=xingbie%>>
        </div></TD>
    <TD nowrap class="STYLE1"><div align="center"><strong>学&nbsp;&nbsp;历</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1">
      <div align="center">
        <input  name="xueli" class="text" id="xueli" size="12" value=<%=xueli%>>
        </div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"><strong>学&nbsp;&nbsp;位</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1">
      <div align="center">
        <input  name="xuewei" class="text" id="xuewei" size="12" value=<%=xuewei%>>
        </div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"><strong>所教学科</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1">
      <div align="center">
        <input  name="xueke" class="text" id="xueke" size="12"  value=<%=xueke%>>
        </div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"><strong>职&nbsp;&nbsp;称</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center">
      <input  name="zhicheng" class="text" id="zhicheng" size="12" value=<%=zhicheng%>>
    </div></TD>
    <TD rowspan="2" valign="middle" nowrap class="STYLE1"><input name=submit1 type=submit class="topanniu" id=submit1 style="LEFT: 393px; TOP: 72px" value=查询></TD>
  </TR>
  <TR>
    <TD nowrap class="STYLE1"><div align="center"><strong>政治面貌</strong></div></TD>
    <TD nowrap class="STYLE1"><div align="center">
      <input  name="zhengzhi" class="text" id="zhengzhi" size="12"  value=<%=zhengzhi%>>
    </div></TD>
    <TD nowrap class="STYLE1"><div align="center"><strong>岗位级别</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center">
      <input  name="gangwei" class="text" id="gangwei" size="12"  value=<%=gangwei%>>
    </div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"><strong>聘任岗位</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center">
      <input  name="pingren" class="text" id="pingren" size="12"  value=<%=pingren%>>
    </div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"><strong>薪&nbsp;&nbsp;级</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center">
      <input  name="xinji" class="text" id="xinji" size="12"  value=<%=xinji%>>
    </div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center"><strong>聘任薪级</strong></div></TD>
    <TD valign="middle" nowrap class="STYLE1"><div align="center">
      <input  name="pingxin" class="text" id="pingxin" size="12" value=<%=pingxin%>>
    </div></TD>
    </TR>
</TABLE> 
 <div align="center">

  </div>
  </div>
  <br>
  <table width="100%" align="center" border="1" cellpadding="3"   cellspacing="0"  bordercolor="#6D8DD8"  class="mtable">
    <tr style="background-color:#D6E4FF"  class="TableHeader">
      <td align="center" nowrap class="STYLE1">编号</td>
      <td height="30" align="center" nowrap class="STYLE1">姓名</td>
      <td   align="center" nowrap class="STYLE1">性别</td>
      <td align="center" nowrap class="STYLE1">年龄</td>
      <td   align="center" nowrap class="STYLE1">学历</td>
      <td   align="center" nowrap class="STYLE1">学位</td>
      <td   align="center" nowrap class="STYLE1">职称</td>
      <td   align="center" nowrap class="STYLE1">任教学科</td>
      <td   align="center" nowrap class="STYLE1">政治面貌</td>
      <td   align="center" nowrap class="STYLE1"><div align="center">岗位级别</div></td>
      <td   align="center" nowrap class="STYLE1"><div align="center">聘任岗位</div></td>
      <td   align="center" nowrap class="STYLE1"><div align="center">薪&nbsp;&nbsp;级</div></td>
      <td   align="center" nowrap class="STYLE1"><div align="center">聘任薪级</div></td>
    </tr>
    <%
   renshu=0
   Set Rslist=Server.CreateObject("Adodb.Recordset")
   
       sqllist="select * from Employee where 是否离职<>'是'  and  性别 like '%"&xingbie& "%'  And 学历 like '%"&xueli& "%'  And 学位 like '%"&xuewei& "%'  And 所教学科 like '%"&xueke& "%'  And 职称 like '%"&zhicheng& "%'  And 政治面貌 like '%"&zhengzhi& "%'  And 岗位级别 like '%"&gangwei& "%'  And 聘任岗位 like '%"&pingren& "%'  And 薪级 like '%"&xinji& "%'  And 聘任薪级 like '%"&pingxin& "%'  order by 姓名" 
	      
   
   Rslist.open sqllist,conn,1,1
   while not Rslist.eof and not Rslist.bof
   renshu=renshu+1
%>
    <tr onMouseOut="this.style.backgroundColor=''" onMouseOver="this.style.backgroundColor='#EFF8FF'">
      <td width="7%" height="27" align="center" nowrap class="STYLE1"><%=Rslist("编号")%></td>
      <td width="7%" align="center" nowrap class="STYLE1">  <%=Rslist("姓名")%> </td>
      <td width="3%" align="center" nowrap class="STYLE1"><%=Rslist("性别")%></td>
      <td width="4%" align="center" nowrap class="STYLE1"><%=year(now())-year(Rslist("出生日期")) %> </td>
      <td width="6%" align="center" nowrap class="STYLE1"><%=Rslist("学历")%> </td>
      <td width="9%" align="center" nowrap class="STYLE1"><%=Rslist("学位")%></td>
      <td width="9%" align="center" nowrap class="STYLE1"><%=Rslist("职称")%></td>
      <td width="9%" align="center" nowrap class="STYLE1"><%=Rslist("所教学科")%> </td>
      <td width="8%" align="center" nowrap class="STYLE1"><%=Rslist("政治面貌")%></td>
      <td width="8%" align="center" nowrap class="STYLE1"><%=Rslist("岗位级别")%></td>
      <td width="8%" align="center" nowrap class="STYLE1"><%=Rslist("聘任岗位")%></td>
      <td width="8%" align="center" nowrap class="STYLE1"><%=Rslist("薪级")%></td>
      <td width="14%" align="center" nowrap class="STYLE1"><%=Rslist("聘任薪级")%></td>
    </tr>
    <%  Rslist.movenext
    wend
%>
  </table>
  <p class="STYLE1"> 一共查询到：<%=renshu%>  人 </p>
</form>
</body>
</html>
