<!--#include file="../checkLogin.asp"-->
<!--#include file="../SQLconn.asp"-->
<!doctype html>
<html>
<head><title></title><meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<script src="../laydate/laydate.js"></script>
<link rel="stylesheet" type="text/css" href="../images/001huang/css/style.css" media="all"/>
<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.leibie.value.length<1){window.alert("请选择证书类别");document.form3.leibie.focus();return (false);}
	if(document.form3.file1.value.length<1){window.alert("请选择文件");document.form3.file1.focus();return (false);}
    if(document.form3.datetime.value.length<1){window.alert("请选择 证书的日期");document.form3.datetime.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
'检查权限结束
%>

<FORM ACTION="saveZhengShu.asp" METHOD="post" enctype="multipart/form-data" NAME="form3"  onSubmit="return form_check();">
  <div align="center">
    <p>
      <%
		
		
		Id=request("id")
		Set RsImggonggao=Server.CreateObject("Adodb.Recordset")
		sqlgonggao="Select * from Employee where  ID='"&id& "'"
		RsImggonggao.open sqlgonggao,conn,1,1
		
	%>
    </p>
    <p class="STYLETITLE2"><%=RsImggonggao("姓名")%>   的证书管理</p>
    
	  <table width="700" border="1" align="center" cellpadding="3" cellspacing="0" style="border-collapse:collapse">  
      <tr>
        <td height="30" class="STYLE1"><div align="right">证书类别</div></td>
        <td class="STYLE1">
					<select name="leibie" id="leibie"  >
					    
					  <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>
		  <input name="TID" type="hidden" id="TID" value=<%=id%>>		</td>
      </tr>
      <tr>
        <td height="30" class="STYLE1"><div align="right">证书级别</div></td>
        <td class="STYLE1">
		           <select name="jibie" id="jibie">
					  
					  <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>
      </tr>
     
      <tr>
        <td height="30" class="STYLE1"><div align="right">发证日期</div></td>
        <td class="STYLE1">
		<input name=datetime  placeholder="请输入日期"  style="width:90px"    class="laydate-icon" onClick="laydate()">
		 		</td>
      </tr>
	   <tr>
        <td height="30" class="STYLE1"><div align="right">发证机关</div></td>
        <td class="STYLE1"><input name="fazhengjiguan" class="text" id="fazhengjiguan" size=50 maxlength="20" ></td>
      </tr>
      <tr>
        <td width="165" height="30" class="STYLE1"><div align="right">内容说明</div></td>
        <td width="519" class="STYLE1"><input name="shuoming" class="text" id="shuoming" size=50 maxlength="30" ></td>
      </tr>
      <tr>
        <td height="28" class="STYLE1"><div align="right">图片文件</div></td>
        <td class="STYLE1"><input name="file1" type="file" class="text" size=50   ></td>		
      </tr>
	  <tr>
        <td height="30" class="STYLE1"><div align="right">登记日期</div></td>
        <td class="STYLE1">
		
		 <input name=dengjidate class="text" onClick="javascript:window.open('day.asp?form=form3&field=dengjidate&oldDate='+this.value,'','directorys=no,toolbar=no,status=no,menubar=no,scrollbars=no,resizable=no,width=250,height=200,top=220,left=250');"  size="20" readonly>		</td>
      </tr>
    </table>
	<input type="hidden" name="fid" value=<%=strid%>>
    <p>
      <input name="button" type="button" class="topanniu" onClick="location='dangan.asp'" value="返回">
      &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
      <input name="submit" type="submit" class="topanniu" value="保存"> 
    </p>
  </div>
				
			  <br>
			  <table width="95%" border="1" align="center" cellspacing="0"  class="mtable">
<tr>
				  <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>
				  <td align="center" valign="middle" class="STYLE1" >操作</td>
				</tr>
				<% 
			 	Set RsImg = Conn.Execute("select * from  EmployeeZhengshu where Tid='"&id& "'")
				While NOT RsImg.EOF %>
				
				<tr> 
				  <td width="10%" height="30" align="center" valign="middle" class="STYLE1" ><%=RsImg("leibie")%> </td>   
				
				  

			      <td width="10%" align="center" valign="middle" class="STYLE1" ><%=RsImg("jibie")%></td>
			      <td width="10%" align="center" valign="middle" class="STYLE1" ><%=RsImg("datetime")%></td>
				  <td width="20%" align="center" valign="middle" class="STYLE1" ><%=RsImg("发证机关")%></td>
				  <td width="20%" align="center" valign="middle" class="STYLE1" ><%=RsImg("shuoming")%></td>
				  <td width="10%" align="center" valign="middle" class="STYLE1" ><a href="showBigimg.asp?id=<%=RsImg("id")%>" target="_blank">
				图片</a></td>
			      <td width="10%" align="center" valign="middle" class="STYLE1" ><%=RsImg("登记日期")%></td>
				  <td width="10%" align="center" valign="middle" class="STYLE1" ><a href="delzhengshu.asp?tid=<%=id%>&id=<%=RsImg("id")%>"  target="main" class="STYLE1"> 删除</a></td>
				</tr>
				
				<% RsImg.MoveNext 
				  Wend
				  RsImg.Close
				  %>
  </table>
</FORM>
 
</body>
</html>
