jg_view.asp

这个系统是企业管理系统

    <tr>
      <td align="right" bgcolor="#F1FCFA">第一学历：</td>
      <td colspan="5" bgcolor="#F1FCFA"><span class="ValueArea">程度：
        
        <span class="STYLE13"><%=rs("xueli1")%></span>　</span>方式<span class="style1"><span class="ValueArea">：
          
        <span class="STYLE13"><%=rs("xueliqudefangshi1")%>　</span></span></span><span class="ValueArea">学制： <span class="time style5"><span class="STYLE13"><%=rs("xuelixuezhi1")%></span>　</span></span>学位:<span class="ValueArea"><span class="STYLE13"><%=rs("xuewei1")%></span><span class="time style5"> 　</span></span>毕业时间<span class="ValueArea">：</span><span class="STYLE13"><%=rs("xuelisj1")%></span>　毕业学校：
        
        <span class="STYLE13"><%=rs("xuelixuexiao1")%></span><span class="time style5">　</span>专业:
        
        <span class="STYLE13"><%=rs("xuelizhuanye1")%></span></td>
    </tr>
    <tr>
      <td align="right" bgcolor="#F1FCFA">最高学历：</td>
      <td colspan="5" bgcolor="#F1FCFA"><span class="ValueArea">程度：        </span><span class="STYLE13"><%=rs("xueli2")%></span><span class="ValueArea"></span>　方式<span class="style1"><span class="ValueArea">：
          
          <span class="STYLE13"><%=rs("xueliqudefangshi2")%></span></span></span><span class="ValueArea">　学制： <span class="time style5"><span class="STYLE13"><%=rs("xuelixuezhi2")%></span></span></span><span class="ValueArea"><span class="time style5"> </span></span>　学位:<span class="STYLE13"><%=rs("xuewei2")%></span><span class="ValueArea"><span class="time style5"> 　</span></span>毕业时间：<span class="STYLE13"><%=rs("xuelisj2")%></span><span class="ValueArea">　</span>毕业学校：
        
        <span class="STYLE13"><%=rs("xuelixuexiao2")%></span><span class="ValueArea">　</span>专业:
        
        <span class="STYLE13"><%=rs("xuelizhuanye2")%></span></td>
    </tr>
    
    <tr>
      <td bgcolor="#F1FCFA"><div align="right">年度考核：</div></td>
      <td colspan="5" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs("zhiyeshengya")%></span></td>
    </tr>
    <tr>
      <td bgcolor="#F1FCFA"><div align="right">备注：</div></td>
      <td colspan="5" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs("remark")%></span></td>
    </tr>
  </table>
  <table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#009966" id="xuexijingli_table">
    <tr>
      <td align="center" bgcolor="#DDF9F3" width="12%">学习经历</td>
      <td width="14%" align="center" bgcolor="#DDF9F3" >时间</td>
      <td width="15%" align="center" bgcolor="#DDF9F3">就读学校</td>
      <td width="59%" align="center" bgcolor="#DDF9F3" >学习层次专业进修内容等</td>
    </tr>
    <%       '获取学籍记录 
 set rs_xuexijingli=server.createobject("adodb.recordset")
sql_xuexijingli="select * from xuexijingli where xingming_id="&requestid&" order by id asc"
rs_xuexijingli.open sql_xuexijingli,conn,1,2%>
    <% do while not rs_xuexijingli.eof %>
    <tr>
      <td align="center" bgcolor="#F1FCFA"><span class="style5"></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_xuexijingli("xuexijingli_shijian")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_xuexijingli("xuexijingli_jiuduxuexiao")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_xuexijingli("xuexijingli_xuexicengci")%></span></td>
    </tr>
    <% rs_xuexijingli.movenext
		   loop
		    %>
  </table>
  <table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#009966" id="gongzuojingli_table">
    <tr  >
      <td align="center" bgcolor="#DDF9F3"  width="12%">工作经历</td>
      <td width="19%" align="center" bgcolor="#DDF9F3" >时间</td>
      <td width="18%" align="center" bgcolor="#DDF9F3" >工作单位</td>
      <td width="51%" align="center" bgcolor="#DDF9F3" >职务或工种岗位等</td>
    </tr>
    <%       '工作经历 
 set rs_gongzuojingli=server.createobject("adodb.recordset")
sql_gongzuojingli="select * from gongzuojingli where xingming_id="&requestid&" order by id asc"
rs_gongzuojingli.open sql_gongzuojingli,conn,1,2%>
    <% do while not rs_gongzuojingli.eof %>
    <tr>
      <td align="center" bgcolor="#F1FCFA"><span class="style5"></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_gongzuojingli("gongzuojingli_shijian")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_gongzuojingli("gongzuojingli_gongzuodanwei")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_gongzuojingli("gongzuojingli_zhiwu")%></span></td>
    </tr>
    <% rs_gongzuojingli.movenext
		   loop
		    %>
  </table>
  <table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#009966" id="jiaoyanqingkuang_table">
    <tr  >
      <td align="center" bgcolor="#DDF9F3" width="11%">教研情况</td>
      <td width="36%" align="center" bgcolor="#DDF9F3" >论文、论著、课题名称</td>
      <td width="19%" align="center" bgcolor="#DDF9F3">发表或立项时间</td>
      <td width="34%" align="center" bgcolor="#DDF9F3" >发表或立项载体名称</td>
    </tr>
    <%       '职称或专业技术情况 
 set rs_jiaoyanqingkuang=server.createobject("adodb.recordset")
sql_jiaoyanqingkuang="select * from jiaoyanqingkuang where xingming_id="&requestid&" order by id asc"
rs_jiaoyanqingkuang.open sql_jiaoyanqingkuang,conn,1,2%>
    <% do while not rs_jiaoyanqingkuang.eof %>
    <tr>
      <td align="center" bgcolor="#F1FCFA"><span class="style5"></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiaoyanqingkuang("jiaoyan_lunwenmingcheng")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiaoyanqingkuang("jiaoyan_shijian")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiaoyanqingkuang("jiaoyan_zaitimingcheng")%></span></td>
    </tr>
    <% rs_jiaoyanqingkuang.movenext
		   loop
		    %>
  </table>
  <table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#009966" id="jiangcheng_table">
    <tr>
      <td width="12%" align="center" bgcolor="#DDF9F3">工作奖惩</td>
      <td width="16%" align="center" bgcolor="#DDF9F3">奖惩时间</td>
      <td width="20%" align="center" bgcolor="#DDF9F3">奖惩单位</td>
      <td width="52%" align="center" bgcolor="#DDF9F3" >奖惩事项</td>
    </tr>
    <%       '工作以来奖惩情况 
 set rs_jiangcheng=server.createobject("adodb.recordset")
sql_jiangcheng="select * from jiangcheng where xingming_id="&requestid&" order by id asc"
rs_jiangcheng.open sql_jiangcheng,conn,1,2%>
    <% do while not rs_jiangcheng.eof %>
    <tr>
      <td align="center" bgcolor="#F1FCFA"><span class="style5"></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiangcheng("jiangcheng_shijian")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiangcheng("jiangcheng_danwei")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiangcheng("jiangcheng_shixiang")%></span></td>
    </tr>
    <% rs_jiangcheng.movenext
		   loop
		    %>
  </table>
  <table width="99%" border="0" align="center" cellpadding="2" cellspacing="1" bgcolor="#009966" id="jiating_table">
    <tr  >
      <td align="center" bgcolor="#DDF9F3" width="10%">家庭成员</td>
      <td width="14%" align="center" bgcolor="#DDF9F3">姓名</td>
      <td width="18%" align="center" bgcolor="#DDF9F3" >出生时间</td>
      <td width="22%" align="center" bgcolor="#DDF9F3" >与本人关系</td>
      <td width="18%" align="center" bgcolor="#DDF9F3" >联系电话</td>
      <td width="18%" align="center" bgcolor="#DDF9F3">工作单位</td>
    </tr>
    <%       '家庭主要成员 
 set rs_jiating=server.createobject("adodb.recordset")
sql_jiating="select * from jiating where xingming_id="&requestid&" order by id asc"
rs_jiating.open sql_jiating,conn,1,2%>
    <% do while not rs_jiating.eof %>
    <tr>
      <td align="center" bgcolor="#F1FCFA"><span class="style5"></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiating("jiating_xingming")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiating("jiating_chushengsj")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiating("jiating_yubenrenguanxi")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiating("jiating_tel")%></span></td>
      <td align="center" bgcolor="#F1FCFA"><span class="STYLE13"><%=rs_jiating("jiating_danwei")%></span></td>
    </tr>
    <% rs_jiating.movenext
		   loop
		    %>
  </table>
  <div align="center"><span class="STYLE6"><br>
    本记录录入时间：<%=rs("lurudate")%>　录入人：<%=rs("luruname")%>　最后修改日期：
    <%
			  if not isdate(rs("lastupddate")) then
			   response.write"（此记录没有被修改过）" 
			   else
			   response.write rs("lastupddate")&"　修改人："&rs("lastupdname")
			   end if%>
    </span><span class="STYLE11">上次登录时间：<%=rs("shangcilogintime")%></span><br>
    <br>
  </div>
  <%if request("add")<>"T" then%> <p align="center" class="STYLE6">第<%=reccurrent%>/<%=recall%>条记录 转到第
    <%
qian5=noredcord-8 '前5条顺序号,把5改成其他数字则显示前条数
if qian5<0 then '是否超出数组最小值0
qian5=0
end if

hou5=noredcord+8 '后5条顺序号,把5改成其他数字则显示后条数
if hou5>allidcount then '是否超出数组最大值
hou5=allidcount
end if

'ff= session("selectid")
for kk=qian5 to hou5
requestid=selectid(kk)
if reccurrent<>kk+1 then%>
    <a href="helpfiles/xzview.asp"><%=kk+1%></a>
    <%else
response.write kk+1&" "
end if
next
%>
条　
<select name="select" id="select2" onChange="javascript:window.location.href('helpfiles/xzview.asp')">
  <% for iii=1 to allidcount+1%>
  <option value="<%=selectid(iii-1)%>" <%if reccurrent=iii then response.write"selected"%>><%=iii%></option>
  <% next%>
</select>
<%if currentfirstrec<>"yes" and nofirstrec<>""then%>
<a href="helpfiles/xzview.asp">第一条</a>
<%end if%>
<%if currentfirstrec<>"yes"then%>
<a href="helpfiles/xzview.asp">上一条</a>
<%end if%>
<%if currentlastrec<>"yes"then%>
<a href="helpfiles/xzview.asp">下一条</a>
<%end if%>
<%if currentlastrec<>"yes" and nolastrec<>""then%>
<a href="helpfiles/xzview.asp">最后一条</a>
<%end if%>
<span class="STYLE11">
<%end if%>
</span><br>
  </p>
  <p align="center" class="STYLE6"><a href="jg_view_print.asp?requestid=<%=rs("id")%>" target="_blank"><img src="images/dayin.gif" border="0"></a><span class="STYLE11"> 　　 </span>
    <%if session("admu_jb") = "T" then%>
    </span><a href="jg_update.asp?id=<%=rs("id")%>" target="_self"><span class="STYLE11"></span><img src="images/editview.gif" alt="修改的资料" border="0"></a> <span class="STYLE11">
    <%end if%>
    </span>　　
    <%if session("admd_jb")="T" then%>
    <a href="funoperate.asp?delmdid=<%=rs("id")%>&operate=del_jglistall_one_view" target="_self" class="style1" onClick="return confirm('确认删除记录吗？')"><img src="images/deleteview.gif" alt="删除记录" width="62" height="19" border="0"></a> 
    <%end if%>
  </p>
  <p align="center" class="STYLE6">
    <input name="rcid" type="hidden" id="rcid" value="<%=rs("id")%>" />
  </p>
  <p align="center" class="STYLE6">&nbsp;</p>
</form>
</body>
</html>