rstjs.asp

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

<%
dim gh,name,xb,sfzh,rzsj,xl,zsh,zw,bm,zp,zsf,zjx
gh=request("gh")
name=request("name")
xb=request("xb")
sfzh=request("sfzh")
rzsj=request("rzsj")
xl=request("xl")
zsh=request("zsh")
zw=request("zw")
bm=request("bm")
zp=request("zp")
zsf=request("zsf")
zjx=request("zjx")
yggz=request("yggz")
ygzc=request("ygzc")
mz=request("mz")

set conn=Server.CreateObject("adodb.connection")
conn.Open "DRIVER={Microsoft Access Driver (*.mdb)}; DBQ=" & Server.MapPath("database/rsxt.mdb") 
set rs=Server.CreateObject("adodb.recordset")
sql="select * from [rsxt]"
rs.open sql,conn,1,3
rs.addnew
rs("gh")=gh
rs("name")=name
rs("xb")=xb
rs("sfzh")=sfzh
rs("rzsj")=rzsj
rs("xl")=xl
rs("zsh")=zsh
rs("zw")=zw
rs("bm")=bm
rs("zp")=zp
rs("zsf")=zsf
rs("zjx")=zjx
rs("yggz")=yggz
rs("ygzc")=ygzc
rs("mz")=mz
rs.update
rs.close
set rs=nothing
%>
<!-- #include file="Inc/Head.asp" -->
   <div align="center" class="style1"><br>
 员工基本信息添加确认<br>
  <br><br></div>
   <table width="600" border="0" align="center" cellspacing="0">
     <tr>
       <td width="50%"><table width="100%" height="100" border="0.1">
         <tr>
           <td width="40%">工号</td>
           <td width="60%"><%=gh%></td>
         </tr>
         <tr>
           <td width="40%">姓名</td>
           <td width="60%"><%=name%></td>
       </tr>       </table></td>
       <td width="50%"><table width="100%" height="100" border="0">
         <tr>
           <td width="40%">照片</td>
           <td width="60%">
             <div align="left">
               <input name="imageField2" type="image" src="<%=zp%>" width="100" height="100" border="0">
               </div></td>
         </tr>
       </table></td>
     </tr>
     <tr>
       <td width="50%"><table width="100%" height="100" border="0">
         <tr>
           <td width="40%">性别</td>
           <td width="60%"><%=xb%></td>
         </tr>
         <tr>
           <td width="40%">身份证号</td>
           <td width="60%"><%=sfzh%></td>
       </tr>       </table></td>
       <td width="50%"><table width="100%" height="100" border="0">
         <tr>
           <td width="40%">学历</td>
           <td width="60%"><%=xl%></td>
         </tr>
         <tr>
           <td width="40%">证书编号</td>
           <td width="60%"><%=zsh%></td>
       </tr>       </table></td>
     </tr>
     <tr>
       <td width="50%"><table width="100%" height="100" border="0">
         <tr>
           <td width="40%">入职时间</td>
           <td width="60%"><%=rzsj%></td>
         </tr>
         <tr>
           <td width="40%">入职部门</td>
           <td width="60%"><%=bm%></td>
         </tr>       </table></td>
       <td width="50%"><table width="100%" height="100" border="0">
         <tr>
           <td width="40%">员工职务</td>
           <td width="60%"><%=zw%></td>
         </tr>
         <tr>
           <td width="40%">员工职称</td>
           <td width="60%"><%=ygzc%></td>
         </tr>       </table></td>
</tr>
     <tr>
       <td><table width="300" height="50" border="0">
         <tr>
           <td width="40%">员工工种</td>
           <td width="60%"><%=yggz%></td>
         </tr>
       </table></td>
       <td><table width="300" height="50" border="0">
         <tr>
           <td width="40%">民族</td>
           <td width="60%"><%=mz%></td>
         </tr>
       </table></td>
     </tr>
</table>
   <table width="600" border="0" align="center">
     <tr>
       <td><div align="center">自存书</div></td>
     </tr>
   </table>
   <table width="600" border="0" align="center">
     <tr>
       <td><%=zjx%></td>
     </tr>
   </table>
   <br><br><br><br><br><br>
   <div align="center">
     <input name="imageField" type="image" src="<%=zsf%>"  width="600" height="800" border="0">
   </div>
</body>
</html>