<%if Version=empty then%>
|
您的位置:首页 -> <%=PSort%> <%=Range%>
<%else%>
| Your Location: >Homepage -> <%=ESort%> <%=ERange%>
<%end if%>
|
|
|
<%
dim n,i,j,t,q
dim conn,rs
if Version=empty then
n=6
else
n=5
end if
set conn=Server.CreateObject("ADODB.Connection")
conn.Open connString
set rs=Server.CreateObject("ADODB.RecordSet")
rs.open sSQLString,conn,3,3
if rs.recordcount=0 then
%>
| > <%
if Version=empty then
response.write "对不起,没有找到相关信息。"
else
response.write "Sorry, no information has been found."
end if%>
|
<% else
'response.write ColumnName
if ColumnName="people" then %>
<% FOR i=0 TO 7 %>
| >
<%
if Version=empty then
response.write inst(i)
else
response.write insten(i)
end if%>
|
|
|
<% rs.movefirst %>
<% NEXT %>
<% else %>
<% If ColumnName="scholar" and version=empty then
sql="select body from " & NewsTableName & " where newsid=379"
set rs1=Server.CreateObject("ADODB.RecordSet")
rs1.open sql,conn,3,3
response.write rs1("body")
End if
%>
| 学者姓名"
else
response.write " class=en>Name"
end if
%>
|
<%if ColumnName="scholar" then %>
访问时间"
else
response.write "class=en>Visiting Period"
end if
%>
|
<%end if%>
工作单位"
else
response.write "class=en>Workplace"
end if
%>
|
研究方向"
else
response.write "class=en>Research Areas"
end if
%>
|
<% a=0
tempDate="1900-1-1"
While not rs.eof %>
Year(tempDate) and ColumnName="scholar" then
a=a+1
if a mod 2=0 then
response.write "bgcolor=#E1F7E8"
else
response.write "bgcolor=#F6DDFE"
end if
else
if a mod 2=0 then
response.write "bgcolor=#E1F7E8"
else
response.write "bgcolor=#F6DDFE"
end if
end if
%>
>
| &Version=<%=Version%>" class=linkto<%=left(Version,2)%> target=_blank><%
if Version=empty then
Response.write getName(rs("UserName")," ")
else
if rs("UserNameEn")<>empty then
Response.write rs("UserNameEn")
else
Response.write getName(rs("UserName"),"english")
end if
end if%> |
<%if ColumnName="scholar" then %>
empty then response.write "class=en"%>><%
if Version=empty then
if (rs("startdate")<>empty or rs("enddate")<>empty) then
response.write rs("startdate") & "至" & rs("enddate")
else
response.write " "
end if
end if
if Version<>empty then
if (rs("startdate")<>empty or rs("enddate")<>empty) then
response.write rs("startdate") & " To " & rs("enddate")
else
response.write " "
end if
end if
%> |
<%end if%>
<%
if Version=empty then
Response.write ""&rs("Workplace")
else
Response.write " | "
if rs("WorkPlaceEn")<>empty then
Response.write rs("WorkPlaceEn")
else
if rs("WorkPlace")<>empty then
Response.write getName(rs("WorkPlace"),"")
end if
end if
end if%>
| <%
if Version = empty then %>
<% =rs("ResearchAreas") %> | <%
else %>
<% =rs("ResearchAreasEn") %> | <%
end if %>
<% tempDate=rs("startdate")
rs.movenext%>
<% Wend %>
|
|
|
<% end if %>
<% end if %>
|