index1.asp

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

<%
dim conn,sql,rs,page
Set conn = Server.CreateObject("ADODB.Connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database/rsxt.mdb") 
sql="select * from [rsxt] order by id desc"

set rs=server.createobject("adodb.recordset")
rs.open sql,conn,1,1
%>
<script language="JavaScript" type="text/JavaScript">
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" -->
<form name="form1" method="post" action="rstjs.asp">
  <table width="600" border="1" align="center" cellpadding="1" cellspacing="1" bordercolor="#CCCCCC" bgcolor="#E8F8F9" class="style3">
    <tr bordercolor="#ECE9D8">
      <td width="20%" bgcolor="#B9EAEC"><div align="left" class="style3">
        <div align="right">员工工号:</div>
      </div></td>
      <td width="30%"><input name="textfield" type="text" size="12"></td>
      <td width="20%" bgcolor="#B9EAEC"><div align="right"><span class="style4">姓&nbsp;&nbsp;&nbsp;&nbsp;名:</span></div></td>
      <td width="30%"><input name="textfield2" type="text" size="12"></td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="left" class="style3">
        <div align="right">出生日期:</div>
      </div></td>
      <td><input name="textfield3" type="text" size="12"></td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">民&nbsp;&nbsp;&nbsp;&nbsp;族:</span></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>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="left" class="style3">
        <div align="right">政治面貌:</div>
      </div></td>
      <td><select name="select" size="1">
        <option>请选择选项</option>
        <option value="群众">群众</option>
        <option value="共青团员">共青团员</option>
        <option value="中共党员">中共党员</option>
      </select></td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">学&nbsp;&nbsp;&nbsp;&nbsp;历:</span></div></td>
      <td><select name="select2"> 
	    <option>请选择学历</option>
        <option value="小学"> 小学</option>
        <option value="初中">初中</option>
        <option value="高中">高中</option>
        <option value="中专">中专</option>
        <option value="大专">大专</option>
        <option value="大学">大学</option>
       
      </select></td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="left" class="style3">
        <div align="right">所属部门:</div>
      </div></td>
      <td><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 bgcolor="#B9EAEC"><div align="right"><span class="style4">职&nbsp;&nbsp;&nbsp;&nbsp;务:</span></div></td>
      <td><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 bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">身份证号:</div></td>
      <td><input name="textfield4" type="text" size="18" maxlength="18"></td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">职&nbsp;&nbsp;&nbsp;&nbsp;称:</span></div></td>
      <td><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></td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">最高学历:</div></td>
      <td><select name="zgxl">
        <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("zgxl")%>"><%=rs("zgxl")%></option>
        <% rs.movenext
				do while not rs.eof%>
        <option value="<%=rs("zgxl")%>"><%=rs("zgxl")%></option>
        <%
			    	rs.movenext
				loop
			end if
	        rs.close
			%>
      </select></td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">工&nbsp;&nbsp;&nbsp;&nbsp;种:</span></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>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">毕业院校:</div></td>
      <td>&nbsp;</td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">入职时间:</span></div></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">毕业证号:</div></td>
      <td>&nbsp;</td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">婚姻状况:</span></div></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">所学专业:</div></td>
      <td>&nbsp;</td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">配偶姓名:</span></div></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">手机号码:</div></td>
      <td>&nbsp;</td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">配偶单位:</span></div></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">电话号码:</div></td>
      <td>&nbsp;</td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">家庭住址:</span></div></td>
      <td>&nbsp;</td>
    </tr>
    <tr>
      <td bordercolor="#ECE9D8" bgcolor="#B9EAEC"><div align="right">证书复印件:</div></td>
      <td>&nbsp;</td>
      <td bgcolor="#B9EAEC"><div align="right"><span class="style4">合同类型:</span></div></td>
      <td><select name="select3">
        <option>请选择类型</option>
        <option value="正式工">正式工</option>
        <option value="非正式工">非正式工</option>
      </select></td>
    </tr>
  </table>
</form>
<!-- #include file="Inc/foot.asp" -->