📄 showdetailinformation.aspx
字号:
<%@ Import namespace="System.Data.SqlClient"%>
<%@ Import namespace="System.Data"%>
<%@ Page Language="C#" ContentType="text/html" ResponseEncoding="gb2312" %>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<HTML>
<HEAD>
<title>详细信息</title>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<%
string cmdtext="";
SqlConnection sqlconn;
SqlCommand cmd;
SqlDataReader reader;
if(int.Parse(Request.QueryString["Type"])==0)
{
cmdtext="SELECT * FROM RegisterPerson WHERE ID="+Request.QueryString["ID"];
}else if(int.Parse(Request.QueryString["Type"])==1)
{
cmdtext="SELECT * FROM EnterPerson WHERE NewID='"+Request.QueryString["NewID"]+"'";
}else if(int.Parse(Request.QueryString["Type"])==2)
{
cmdtext="SELECT * FROM EnterPerson WHERE ID="+Request.QueryString["ID"];
}
sqlconn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
cmd=new SqlCommand(cmdtext,sqlconn);
sqlconn.Open();
reader=cmd.ExecuteReader();
reader.Read();
%>
</HEAD>
<body bgColor="#6699cc">
<table width="720" border="1" align="center">
<tr>
<td width="193">编号:<%if(int.Parse(Request.QueryString["Type"])==0)
{
Response.Write(reader.GetInt32(0));
}else if(int.Parse(Request.QueryString["Type"])==1)
{
Response.Write(reader.GetString(0));
}
%></td>
<td width="279">姓名:<%Response.Write(reader.GetString(1));%></td>
<td width="226">性别:<%Response.Write(reader.GetString(4).Equals("M")?"男":"女");%></td>
</tr>
<tr>
<td>院系班级:<%Response.Write(reader.GetString(2));%></td>
<td>籍贯:<%Response.Write(reader.GetString(6));%></td>
<td>是否本科:<%Response.Write(reader.GetString(3).Equals("T")?"是":"否");%></td>
</tr>
<tr>
<td>宿舍:<%Response.Write(reader.GetString(18));%></td>
<td>联系电话:<%Response.Write(reader.GetString(5));%></td>
<td> </td>
</tr>
<tr>
<td>现在是否有勤工助学岗位:<%Response.Write(reader.GetString(9).Equals("T")?"是":"否");%></td>
<td>是否有家教经验:<%Response.Write(reader.GetString(3).Equals("T")?"是":"否");%></td>
<td>是否有贫困证明:<%Response.Write(reader.GetString(7).Equals("T")?"是":"否");%></td>
</tr>
<tr>
<td colspan="3">教学科目:<%
string [] Course={"初中全面","英语口语","高中理综","高中文综"};
Response.Write(Course[reader.GetByte(10)]);
%></td>
</tr>
<tr>
<td colspan="3">过级情况:<%
cmdtext="";
cmdtext+=(reader.GetString(12).Equals("T"))?"英语四级 ":"";
cmdtext+=(reader.GetString(11).Equals("T"))?"英语六级 ":"";
cmdtext+=(reader.GetString(13).Equals("T"))?"计算机二级 ":"";
cmdtext+=(reader.GetString(14).Equals("T"))?"计算机三级 ":"";
Response.Write(cmdtext);
%></td>
</tr>
<tr>
<td colspan="3">擅长科目:
</td>
</tr>
<tr>
<td colspan="3" height="160">个人简介:<%Response.Write("<div style=\"position:relative; width:500px; height:115px; left: 100px;background-color: #FFFFFF;border: 1px inset #FFFFFF;\">"+reader.GetString(16)+"</div>"); %></td>
</tr>
<tr>
<td colspan="3" height="160">获奖情况:<%Response.Write("<div style=\"position:relative; width:500px; height:115px; left: 100px;background-color: #FFFFFF;border: 1px inset #FFFFFF;\">"+reader.GetString(17)+"</div>"); %></td>
</tr>
</table>
</body>
</HTML>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -