tjry.asp

人事管理系统 人事管理系统 人事管理系统 人事管理系统

<!--#include file="inc/Conndb.asp"-->
<%
dim rs
dim sql
dim count
set rs=server.createobject("adodb.recordset")
sql = "select * from rsxt order by id asc"
rs.open sql,conn,1,1
%>
<script language = "JavaScript">
var onecount;
subcat = new Array();
        <%
        count = 0
        do while not rs.eof 
        %>
subcat[<%=count%>] = new Array("<%= trim(rs("zw"))%>","<%= trim(rs("bm"))%>");
        <%
        count = count + 1
        rs.movenext
        loop
        rs.close
        %>
onecount=<%=count%>;

</script>
<!-- #include file="Inc/Head.asp" -->
<table width="100%" height="500" border="0" cellpadding="0" cellspacing="0">
  <tr> 
    <td width="150" align="center" valign="top"><table width="150" height="100%" border="0" cellpadding="0" cellspacing="0" class="HeaderTdStyle">
      <tr>
        <td align="center" valign="top"><table width="100%" height="24" border="0" cellpadding="0" cellspacing="0">
            <tr>
              <td align="center">功能菜单</td>
            </tr>
          </table>
            <table width="100%" height="530" border="0" cellpadding="0" cellspacing="0" class="MenuBg">
              <tr>
                <td align="center" valign="top"><br>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="16%"><img src="Img/Left_1.gif" width="28" height="11"></td>
                        <td width="84%" height="20"><font color="#FFFF00">人事记录管理</font></td>
                      </tr>
                    </table>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="34%" height="20" align="right"><img src="Img/Left_1_1.gif" width="29" height="16"></td>
                        <td width="66%" valign="bottom"><a href="tjry.asp"><font color="#FFFF00">添加员工</font></a></td>
                      </tr>
                    </table>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="34%" height="20" align="right"><img src="Img/Left_1_1.gif" width="29" height="16"></td>
                        <td width="66%" valign="bottom"><a href="xz.asp"><font color="#FFFF00">查询信息</font></a></td>
                      </tr>
                    </table>
                    <table width="90%" border="0" cellpadding="0" cellspacing="0">
                      <tr>
                        <td width="34%" height="20" align="right"><img src="Img/Left_1_1.gif" width="29" height="16"></td>
                        <td width="66%" valign="bottom"><a href="ztcx.asp"><font color="#FFFF00">总体显示</font></a></td>
                      </tr>
                  </table></td>
              </tr>
          </table></td>
      </tr>
    </table></td>
    <td align="center" valign="top"> 
      <div align="center">

       
        <form action="rstjs.asp" method="post"   name="form1">
  <table width="778" height="300" border="0" align="center">
    <tr>
      <td width="20%"><div align="right">员工工号:</div></td>
      <td width="30%"><input type="text" name="gh"></td>
      <td width="20%"><div align="right">员工姓名:</div></td>
      <td width="30%"><input type="text" name="name"></td>
    </tr>
    <tr>
      <td width="20%"><div align="right">员工性别:</div></td>
      <td width="30%"><p>
        <label>
        <select name="xb" size="1">
          <option value="男">男</option>
          <option value="女">女</option>
        </select>
</label>
        <br>
      </p>        </td>
      <td width="20%"><div align="right">身份证号:</div></td>
      <td width="30%"><input name="sfzh" type="text" maxlength="18"></td>
    </tr>
    <tr>
      <td width="20%"><div align="right">入职时间:</div></td>
      <td width="30%"><input name="rzsj" type="text" value="<%=date%>" ></td>
      <td width="20%"><div align="right">最高学历:</div></td>
      <td width="30%"><select name="xl">
        <option value="" selected>指定学历</option>
        <%
			sql="select * from xlda order by id"
			rs.open sql,conn,1,1
			if not(rs.eof and rs.bof) then
			%>
        <option value="<%=rs("xl")%>"><%=rs("xl")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("xl")%>"><%=rs("xl")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select></td>
    </tr>
    <tr>
      <td width="20%"><div align="right">学历证书号:</div></td>
      <td width="30%"><input type="text" name="zsh"></td>
      <td width="20%"><div align="right">现任职务:</div></td>
      <td width="30%"><select name="zw">
        <option value="" selected>指定职务</option>
        <%
			sql="select * from zwda order by id"
			rs.open sql,conn,1,1
			if not(rs.eof and rs.bof) then
			%>
        <option value="<%=rs("zw")%>"><%=rs("zw")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("zw")%>"><%=rs("zw")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select>
      </td>
    </tr>
    <tr>
      <td width="20%"><div align="right">入职部门:</div></td>
      <td width="30%"><select name="bm">
        <option value="" selected>指定部门</option>
        <%
			sql="select * from bmda order by id"
			rs.open sql,conn,1,1
			if not(rs.eof and rs.bof) then
			%>
        <option value="<%=rs("bm")%>"><%=rs("bm")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("bm")%>"><%=rs("bm")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select></td>
      <td width="20%"><div align="right">近期照片:</div></td>
      <td width="30%"><input type="file" name="zp"></td>
    </tr>
    <tr>
      <td width="20%"><div align="right">证书复印件:</div></td>
      <td width="30%"><input type="file" name="zsf"></td>
      <td width="20%"><div align="right">员工职称:</div></td>
      <td width="30%"><select name="ygzc">
        <option value="" selected>指定职称</option>
        <%
			sql="select * from zcda order by id"
			rs.open sql,conn,1,1
			if not(rs.eof and rs.bof) then
			%>
        <option value="<%=rs("ygzc")%>"><%=rs("ygzc")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("ygzc")%>"><%=rs("ygzc")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select>&nbsp;</td>
    </tr>
    <tr>
      <td><div align="right">员工工种:</div></td>
      <td><select name="yggz">
        <option value="" selected>指定工种</option>
        <%
			sql="select * from gzda order by id"
			rs.open sql,conn,1,1
			if not(rs.eof and rs.bof) then
			%>
        <option value="<%=rs("yggz")%>"><%=rs("yggz")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("yggz")%>"><%=rs("yggz")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select></td>
      <td><div align="right">民族:</div></td>
      <td><select name="mz">
        <option value="" selected>指定民族</option>
        <%
			sql="select * from mzda order by id"
			rs.open sql,conn,1,1
			if not(rs.eof and rs.bof) then
			%>
        <option value="<%=rs("mz")%>"><%=rs("mz")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("mz")%>"><%=rs("mz")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select></td>
    </tr>
  </table>
  <table width="777" border="0" align="center">
    <tr>
      <td ><div align="right">自存信:</div></td>
      <td width="80%"><div align="center">
        <textarea  name="zjx" cols="80" rows="10"></textarea>
      </div></td>
    </tr>
  </table>
  <p align="center">
    <input type="submit" name="Submit" value="提&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;交">
	&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;
	<input type="reset" name="Submit2" value="重&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;置">
  </p>
</form>
        <p><br>
        </p>
      </div></td>
  </tr>
</table>




<!-- #include file="Inc/foot.asp" -->