📄 com_search_works.asp
字号:
<!--#include file="../Include/Class_Conn.asp" -->
<!--#include file="../Include/Class_Main.asp" -->
<%
Dim SQL,Rs
Dim JobClass,Area,PublishDate,Key,KeyClass
Dim JobId,Comid,JobName,Work_Area,Work_City,Edus,Deal,LastUpdate_Time
SQL = "Select Id,Title,AddDate,UserType,UserId,Users,Province,City From [pH_WorkInfo] Where i_Flag=1 And Zt=1 Order By Adddate Desc"
Set Rs = Server.CreateObject("ADODB.Recordset")
Rs.open SQL,Conn,1,1
Rs.Pagesize = 20
Psize = Rs.PageSize
PCount = Rs.PageCount
RCount = Rs.RecordCount
PageNo = Cint(Request.QueryString("PageNo"))
If PageNo < 1 Then
PageNo = 1
Elseif PageNo > PCount Then
PageNo = PCount
End if
If Not Rs.Eof Then Rs.AbsolutePage = PageNo
%>
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<script language="JavaScript" src="../js/Company_Basicinfo.js"></script>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../Css/Style.css" type=text/css rel=stylesheet>
<title><%= Cls_WebName %> -- 劳务信息</title>
<script language="JavaScript" type="text/JavaScript">
<!--
function MM_jumpMenu(targ,selObj,restore){ //v3.0
eval(targ+".location='"+selObj.options[selObj.selectedIndex].value+"'");
if (restore) selObj.selectedIndex=0;
}
//-->
</script>
</head>
<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td><!--#include file="../Include/Header.asp" --></td>
</tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td align="center">
<table width="760" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="50%" height="25">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页</td>
<td width="50%" align="right">
<%
If PageNo > 1 Then
Response.write "<a href=""?PageNo=1"">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&""">上页</a> "
Else
Response.write "首页 "
Response.write "上页 "
End if
%>
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)" style="width:40px;">
<% For i = 1 to PCount %>
<option value="?PageNo=<%= i %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&""">尾页</a>"
Else
Response.write "下页 "
Response.write "尾页"
End if
%>
</td>
</tr>
</table>
<table width="760" border="0" cellpadding="2" cellspacing="1" bgcolor="eeeeee">
<tr>
<td valign="top" bgcolor="#FFFFFF"> <table width="100%" border="0" align="center" cellpadding="4" cellspacing="1" bgcolor="eeeeee" class="text01" >
<tr align="center" bgcolor="f5f5f5">
<td width="39" height="27" > 编 号</td>
<td width="222" height="27" >标 题</td>
<td width="221" height="27" > 信息来源</td>
<td width="69" height="27" >需求人数</td>
<td width="95" height="27">工作地区</td>
<td width="103" height="27" >发布时间</td>
</tr>
<%
For i=1 to Psize
If Rs.eof Then Exit For
Id = Rs("Id")
Title = Rs("Title")
AddDate = FormatDateTime(Rs("AddDate"),2)
UserType = Rs("UserType")
UserId = Rs("UserId")
Users = Rs("Users")
Province = Rs("Province")
City = Rs("City")
'//会员类型和名称
Select Case UserType
Case "Com"
UserStr = "企业"
UserName = ""
ReSQL = "Select CompanyName From [pH_Company_Base] Where Comid='"&UserId&"'"
Set Re = Conn.Execute(ReSQL)
If Not Re.Eof Then UserName = Re(0)
Re.Close
UserUrl = "<a href=Info/Com_View.asp?Param="&UserId&" target=_blank><u>"&UserName&"</u></a>"
End Select
%>
<tr bgcolor="#FFFFFF" >
<td width="39" height="25" align="center" bordercolor="#E0E0E0"><font color="#384249"><%= thepage+i%></font></td>
<td width="222" height="25" align="left" bordercolor="#E0E0E0"><a href="../Company/Info/View_Work.asp?Param=<%= Rs("Id") %>&Comid=<%= Rs("Userid") %>" target="_blank"><u><%= Title %></u></a></td>
<td width="221" height="25" align="left" bordercolor="#E0E0E0"><%= UserUrl %></td>
<td height="25" align="center" bordercolor="#E0E0E0"><%= Users %></td>
<td height="25" align="center" bordercolor="#E0E0E0" ><%= Province&City %></td>
<td height="25" align="center" bordercolor="#E0E0E0" ><%= AddDate %></td>
</tr>
<%
Rs.movenext
Next
%>
</table></td>
</tr>
</table>
<table width="760" border="0" cellspacing="0" cellpadding="4">
<tr>
<td width="50%" height="25">共<Font color="#FF0000"><%= RCount %></Font>条 分<Font color="#FF0000"><%= PCount %></Font>页 | 当前第<Font color="#FF0000"><%= PageNo %></Font>页</td>
<td width="50%" align="right">
<%
If PageNo > 1 Then
Response.write "<a href=""?PageNo=1"">首页</a> "
Response.write "<a href=""?PageNo="&PageNo-1&""">上页</a> "
Else
Response.write "首页 "
Response.write "上页 "
End if
%>
<select name="menu1" onChange="MM_jumpMenu('parent',this,0)" style="width:40px;">
<% For i = 1 to PCount %>
<option value="?PageNo=<%= i %>" <% If i = PageNo Then Response.write "Selected"%>><%=i%></option>
<% Next %>
</select>
<%
If PageNo < PCount Then
Response.write "<a href=""?PageNo="&PageNo+1&""">下页</a> "
Response.write "<a href=""?PageNo="&PCount&""">尾页</a>"
Else
Response.write "下页 "
Response.write "尾页"
End if
%>
</td>
</tr>
</table>
</td>
</tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
<tr>
<td>
<!--#include file="../Include/Footer.asp" -->
</td>
</tr>
</table>
</body>
</html>
<%
Rs.Close
Set Rs = Nothing
Call CloseDB
%>⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -