⭐ 欢迎来到虫虫下载站! | 📦 资源下载 📁 资源专辑 ℹ️ 关于我们
⭐ 虫虫下载站

📄 xy_view_all.asp

📁 培训学员管理系统
💻 ASP
字号:
<%@LANGUAGE="VBSCRIPT" CODEPAGE="936"%>
<% Response.Buffer =True  
Response.ExpiresAbsolute = Now() - 1
Response.Expires = 0  
Response.CacheControl = "no-cache"  
Response.AddHeader "Pragma", "No-Cache" %>
<!--#include file="admin_qx.asp" -->
<% isdl %>
<!--#include file="conn_fj16.asp"-->
<%
requestid=request("id")
set rs=server.createobject("adodb.recordset")
sql="select * from jlzd321 where id="&requestid&""
rs.open sql,conn,1,2
if rs.eof then
 	response.write "<script language=JavaScript>{window.alert('记录不存在或已被删除,请按“确定”返回后“刷新”页面!');window.history.go(-1);}</script>"
  response.end
   end if
%>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312" />
<title>学员:<%=rs("xingming")%>的详细档案</title>
<style type="text/css">
<!--
.STYLE1 {color: #FF0000}
.style5 {color: #000000}
body,td,th {
	font-size: 13px;
}
.STYLE6 {
	font-size: 18px;
	color: #FF0000;
}
table {
	word-break:break-all;
}
body {
	background-color: #d6dff7;
}
.STYLE7 {color: #0000FF}
-->
</style>
</head>

<body>
<form id="form1" name="form1" method="post" action="xy_update_save.asp">
  <p align="center" class="STYLE6">学员:<%=rs("xingming")%> 的详细档案</p>
 <table width="95%" border="1" align="center" cellpadding="2" cellspacing="1" bordercolor="#F3F3F3" style="border-collapse: collapse">
    <tr>
      <td width="158" ><div align="right">学号:</div></td>
      <td width="161" class="STYLE7"><label>
       <%=rs("xuehao")%>
      </label></td>
      <td width="109"><div align="right"><span class="STYLE1">姓名:</span></div></td>
      <td width="213" class="STYLE7"><label>
      <span class="STYLE1"><%=rs("xingming")%></span></label></td>
      <td colspan="2" rowspan="6" align="center"><span class="tdc">
        <%if rs("zhaopian")<>"" then%><a href="<%=rs("zhaopian")%>" target="_blank">
      <%end if%>
      <img src="<%if rs("zhaopian")="" then%>images/tupian.gif<%end if%><%if rs("zhaopian")<>"" then%><%=rs("zhaopian")%><%end if%>" name="img" width="120" height="135" border="0" id="img" /></a></span></td>
    </tr>
    <tr>
      <td><div align="right">性别:</div></td>
      <td class="STYLE7"><%=rs("xingbie")%></td>
      <td><div align="right">身份证号:</div></td>
      <td class="STYLE7"><%=rs("shenfenzhenghao")%></td>
    </tr>
    <tr>
      <td><div align="right">出生年月:</div></td>
      <td class="STYLE7"><%
	if  isdate(rs("chushengnianyue"))then
	byear=year(rs("chushengnianyue"))
	bmonth=month(rs("chushengnianyue"))
	'bday=day(rs("chushengnianyue"))
	end if
	%>
      <%=byear%>年<%=bmonth%>月</td>
      <td><div align="right">年龄:</div></td>
      <td class="STYLE7"><%
	if  isdate(rs("chushengnianyue"))then
	byear=year(rs("chushengnianyue"))
	bmonth=month(rs("chushengnianyue"))
	'bday=day(rs("chushengnianyue"))
	nianling=year(date)-byear
	end if
	%>
      <%=nianling%></td>
    </tr>
    <tr>
      <td><div align="right">民族:</div></td>
      <td class="STYLE7"><%=rs("minzu")%></td>
      <td><div align="right">政治面貌:</div></td>
      <td class="STYLE7"><%=rs("zhengzhimianmao")%></td>
    </tr>
    <tr>
      <td><div align="right">籍贯:</div></td>
      <td class="STYLE7"><%=rs("jiguan")%></td>
      <td><div align="right">文化程度:</div></td>
      <td class="STYLE7"><%=rs("wenhuachengdu")%></td>
    </tr>
    <tr>
      <td><div align="right">住址:</div></td>
      <td colspan="3" class="STYLE7"><%=rs("zhuzhi")%></td>
    </tr>
    <tr>
      <td><div align="right">培训专业:</div></td>
      <td class="STYLE7"><%=rs("peixunzhuanye")%></td>
      <td><div align="right">培训时间:</div></td>
      <td class="STYLE7"><%=rs("peixunshijian")%></td>
      <td width="83"><div align="right">收费标准:</div></td>
      <td width="142" class="STYLE7"><%=rs("shoufeibiaozhun")%></td>
    </tr>
    <tr>
      <td><div align="right">补助金额:</div></td>
      <td class="STYLE7"><%=rs("buzhujine")%></td>
      <td><div align="right">考核:</div></td>
      <td class="STYLE7"><%=rs("kaohe")%></td>
      <td><div align="right">证书编号:</div></td>
      <td class="STYLE7"><%=rs("zhengshubianhao")%></td>
    </tr>
    <tr>
      <td><div align="right">就业去向:</div></td>
      <td class="STYLE7"><%=rs("jiuyequxiang")%></td>
      <td><div align="right">联系电话:</div></td>
      <td colspan="3" class="STYLE7"><%=rs("lianxidianhua")%></td>
    </tr>
    <tr>
      <td colspan="6"><table width="100%" border="1" cellspacing="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#F3F3F3">
        <tr>
          <td width="67" rowspan="2"><p align="center">培 训 <br />
            科 目 </p>            </td>
          <td width="180" rowspan="2"><p align="center">集中培训时间 <br />
            ( 年 月 日— 年 月 日) </p>            </td>
          <td colspan="3"><p align="center">参加学习课时 </p></td>
          <td colspan="2"><p align="center">考试考核成绩 </p></td>
        </tr>
        <tr>
          <td width="69"><p align="center">理论课 </p></td>
          <td width="52"><p align="center">实践课 </p></td>
          <td width="56"><p align="center">自学课 </p></td>
          <td width="77"><p align="center">考 试 </p></td>
          <td width="76"><p align="center">考 核 </p></td>
        </tr>
        <tr>
          <td width="67" valign="top"><p>
            <%=rs("peixunkemu1")%>
          </p></td>
          <td width="180" valign="top"><p class="STYLE7">
            <%=rs("jizhongpeixunshijian1")%>
          </p></td>
          <td width="69" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxkslilunke1")%>
          </p></td>
          <td width="52" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxksshijianke1")%>
          </p></td>
          <td width="56" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxkszixueke1")%>
          </p></td>
          <td width="77" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaoshi1")%>
          </p></td>
          <td width="76" valign="top"><p align="center" class="STYLE7">
           <%=rs("kskhcjkaohe1")%>
          </p></td>
        </tr>
        <tr>
          <td width="67" valign="top"><p>
            <%=rs("peixunkemu2")%>
          </p></td>
          <td width="180" valign="top"><p class="STYLE7">
            <%=rs("jizhongpeixunshijian2")%>
          </p></td>
          <td width="69" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxkslilunke2")%>
          </p></td>
          <td width="52" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxksshijianke2")%>
          </p></td>
          <td width="56" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxkszixueke2")%>
          </p></td>
          <td width="77" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaoshi2")%>
          </p></td>
          <td width="76" valign="top"><p align="center" class="STYLE7">
           <%=rs("kskhcjkaohe2")%>
          </p></td>
        </tr>
        <tr>
          <td width="67" valign="top"><p>
           <%=rs("peixunkemu3")%>
          </p></td>
          <td width="180" valign="top"><p class="STYLE7">
           <%=rs("jizhongpeixunshijian3")%>
          </p></td>
          <td width="69" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxkslilunke3")%>
          </p></td>
          <td width="52" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxksshijianke3")%>
          </p></td>
          <td width="56" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxkszixueke3")%>
          </p></td>
          <td width="77" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaoshi3")%>
          </p></td>
          <td width="76" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaohe3")%>
          </p></td>
        </tr>
        <tr>
          <td width="67" valign="top"><p>
            <%=rs("peixunkemu4")%>
          </p></td>
          <td width="180" valign="top"><p class="STYLE7">
            <%=rs("jizhongpeixunshijian4")%>
          </p></td>
          <td width="69" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxkslilunke4")%>
          </p></td>
          <td width="52" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxksshijianke4")%>
          </p></td>
          <td width="56" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxkszixueke4")%>
          </p></td>
          <td width="77" valign="top"><p align="center" class="STYLE7">
           <%=rs("kskhcjkaoshi4")%>
          </p></td>
          <td width="76" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaohe4")%>
          </p></td>
        </tr>
        <tr>
          <td width="67" valign="top"><p>
            <%=rs("peixunkemu5")%>
          </p></td>
          <td width="180" valign="top"><p class="STYLE7">
           <%=rs("jizhongpeixunshijian5")%>
          </p></td>
          <td width="69" valign="top"><p align="center" class="STYLE7">
           <%=rs("cjxxkslilunke5")%>
          </p></td>
          <td width="52" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxksshijianke5")%>
          </p></td>
          <td width="56" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxkszixueke5")%>
          </p></td>
          <td width="77" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaoshi5")%>
          </p></td>
          <td width="76" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaohe5")%>
          </p></td>
        </tr>
        <tr>
          <td width="67" valign="top"><p>
            <%=rs("peixunkemu6")%>
          </p></td>
          <td width="180" valign="top"><p class="STYLE7">
           <%=rs("jizhongpeixunshijian6")%>
          </p></td>
          <td width="69" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxkslilunke6")%>
          </p></td>
          <td width="52" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxksshijianke6")%>
          </p></td>
          <td width="56" valign="top"><p align="center" class="STYLE7">
            <%=rs("cjxxkszixueke6")%>
          </p></td>
          <td width="77" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaoshi6")%>
          </p></td>
          <td width="76" valign="top"><p align="center" class="STYLE7">
            <%=rs("kskhcjkaohe6")%>
          </p></td>
        </tr>
        <tr>
          <td colspan="7" valign="top">是否取得职业技能鉴定证书:
             <span class="STYLE7"><%=rs("shifouqudezhengshu")%></span></td>
          </tr>
      </table></td>
    </tr>
    <tr>
      <td><div align="center">教学承办<br />
      单位评议</div></td>
      <td colspan="5" class="STYLE7"><%=rs("jiaoxuechengbandanweipingyi")%></td>
    </tr>
    <tr>
      <td colspan="6" >教学承办单位负责人签字:
        <span class="STYLE7"><%=rs("jiaoxuechengbandanweifuzeren")%></span>       承办单位负责人签字年月日:  
	    <span class="STYLE7"><%=rs("jiaoxuechengbandanweiqianzinianyueri")%></span></td>
    </tr>
    <tr>
      <td colspan="6">&nbsp;</td>
    </tr>
    <tr>
      <td><p align="center">上级主管部门<br>
        考核意见 </p></td>
      <td colspan="5" class="STYLE7"><%=rs("shiyangguangbanyijian")%></td>
    </tr>
    <tr>
      <td colspan="6">上级主管部门负责人签字
        <span class="STYLE7"><%=rs("shiyangguangbanfuzeren")%></span> 负责人签字年月日:<span class="STYLE7"><%=rs("shiyangguangbanfuzerenqianzinianyueri")%></span></td>
    </tr>
    <tr>
      <td colspan="6">&nbsp;</td>
    </tr>
    <tr>
      <td><div align="center">学前从业状况:</div></td>
      <td colspan="5" class="STYLE7"><%=rs("xueqiancongyezhuangkuang")%></td>
    </tr>
    <tr>
      <td height="40"><div align="center">学后从业状况:</div></td>
      <td colspan="5" class="STYLE7"><%=rs("xuehoucongyezhuangkuang")%></td>
    </tr>
    <tr>
      <td><div align="center">备注:</div></td>
      <td colspan="5" class="STYLE7"><%=rs("beizhu")%></td>
    </tr>
  </table>
  <label>
  <div align="center"><br />
  <a href="xy_update.asp?ID=<%=rs("ID")%>" target="_self"><img src="images/edit.gif" alt="修改该学员的资料" width="16" height="16" border="0"></a> <a href="xy_delete_view_all.asp?ID=<%=rs("ID")%>" target="_self" onClick="return confirm('确认删除该学员吗?')"><img src="images/delete.gif" alt="删除该学员" width="18" height="18" border="0"></a>
  <input name="ID" type="hidden" id="ID" value="<%=rs("ID")%>">
   
   
  <input name="docorxls" type="hidden" id="docorxls">
   
  <input type="button" value="输出到excel" name="B12" class="put1" onClick="subexcel()" />
</div>
  </label>
</form>
</body>
</html>
<script language="javascript">
//
 
//
function subexcel()
{
form1.action="xy_view_all_we.asp"; 
form1.docorxls.value="xls";
form1.target="_blank";
form1.submit();


}
</script>

⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -