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

📄 view_work.asp

📁 直接附加数据库! 修改 Include/ Class_Main.asp 为自己信息 后台admin admin 绍兴人才网程序
💻 ASP
字号:
<!--#include file="../../Include/Class_Conn.asp" -->
<!--#include file="../../Include/Class_Main.asp" -->
<%
Dim Param
Dim Comid,Username,Cmd,Rs,SQL,i
Dim Locid,Sortid,CompanyName,JobName,Require,Place,Valid,InviteDate

Ncid     = Replace_Text(Request.QueryString("Param"))
Comid    = Replace_Text(Request.QueryString("Comid"))

SQL = "Select UserType,UserID,Title,AdBody,WorkType,Users,AddDate,EndValids,Province,City,ViewClicks,HfClicks From [pH_WorkInfo] Where Userid='"&Comid&"' And Id="&Cstr(Ncid)&" And i_Flag=1 And Zt=1"
Set Rs = Conn.Execute(SQL)
If Rs.Eof Then
 Rs.Close
 CloseDB
 Response.write "没有找到该劳务信息!"
 Response.End()
End if
Tmp = Rs.GetRows()
Rs.Close : Set Rs = Nothing
Conn.Execute("Update [pH_WorkInfo] Set ViewClicks=ViewClicks+1 Where Id="&Cstr(Ncid))
UserType = Tmp(0,0)
UserId = Tmp(1,0)
AddDate = Tmp(6,0)

'//截止时间
Select Case Tmp(7,0)
 Case 0
  EndDate = "长期有效"
 Case 1
  EndDate = DateAdd("d",7,AddDate)
 Case 2
  EndDate = DateAdd("d",15,AddDate)
 Case 3
  EndDate = DateAdd("m",1,AddDate)
 Case 4
  EndDate = DateAdd("m",3,AddDate)
 Case 5
  EndDate = DateAdd("m",6,AddDate)
 Case 6
  EndDate = DateAdd("m",12,AddDate)
End Select

%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=gb2312">
<LINK href="../../Css/Style.css" type=text/css rel=stylesheet>
<title><%= Cls_WebName %> -- 劳务信息</title>
</head>

<body>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr>
    <td>
      <!--#include file="../../Include/Info/Header.asp" -->
    </td>
  </tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr> 
    <td><table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td height="4"></td>
        </tr>
      </table>
      <table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
        <tr> 
          <td width="164" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td><img src="../../Images/Company/toplogo.gif" width="164" height="34"></td>
              </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <% 
		SQL = "Select Top 10 * From [pH_Web_Ad] Where WebName=10 And ad_Width=148 And ad_Height=60 And DateDiff(d,BeginDate,GetDate())>=0 And DateDiff(d,EndDate,GetDate())<=0 And Websub='"&Cls_Websub&"' Order By ad_Sort Asc"
		Set Rs_s = Conn.Execute(SQL)
		While Not Rs_s.Eof
		 If Rs_s("AdClass") = 1 Then
		 %>
              <tr> 
                <td height="68" align="center"> <a href="<%= "http://"&Rs_s("AdUrl") %>" target="_blank"><img src="../../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>" width="<%= Rs_s("ad_Width") %>" height="<%= Rs_s("ad_Height") %>" border="0"></a> 
                </td>
              </tr>
              <% Else %>
              <tr> 
                <td height="68" align="center"> <object classid="clsid:D27CDB6E-AE6D-11cf-96B8-444553540000" codebase="http://download.macromedia.com/pub/shockwave/cabs/flash/swflash.cab#version=6,0,29,0" width="<%= Rs_s("ad_Width") %>" height="<%= Rs_s("ad_Height") %>">
                    <param name="movie" value="../../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>">
                    <param name=quality value=high>
                    <embed src="../../Uploadfiles/AdFile/<%= Rs_s("AdFile") %>" quality=high pluginspage="http://www.macromedia.com/shockwave/download/index.cgi?P1_Prod_Version=ShockwaveFlash" type="application/x-shockwave-flash" width="435" height="75"></embed> 
                  </object> </td>
              </tr>
              <% 
		 End if
		 Rs_s.Movenext
		Wend
		Rs_s.Close 
		 %>
            </table></td>
          <td width="1" bgcolor="#eeeeee"></td>
          <td width="3"></td>
          <td width="592" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="28%" align="left"><img src="../../Images/Company/welcome.gif" width="149" height="43"></td>
                <td style="font-size:15px;color:#3333CC;font-weight:bold"></td>
              </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="147" height="21">&nbsp;</td>
                <td width="21" rowspan="2"><img src="../../Images/Company/yleft.gif" width="21" height="22"></td>
                <td width="78" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_ybg.gif"><a href="Com_View.asp?Param-<%= Comid %>.html">企业简介</a></td>
                <td width="28" rowspan="2"><img src="../../Images/Company/middle.gif" width="28" height="22"></td>
                <td width="80" rowspan="2" align="center" valign="bottom" background="../../Images/Company/company_wbg.gif"><strong>劳务信息</strong></td>
                <td width="24" rowspan="2"><img src="../../Images/Company/person_wright.gif" width="24" height="22"></td>
                <td width="214">&nbsp;</td>
              </tr>
              <tr> 
                <td height=1 bgcolor=#ddddda></td>
                <td height=1 bgcolor=#ddddda></td>
              </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td width="1" bgcolor="#ddddda"></td>
                <td width="145" align="center" valign="top" bgcolor="#FBFBFB"> 
                  <table width="90%" border="0" cellspacing="0" cellpadding="0">
                    <tr> 
                      <td height="10"></td>
                    </tr>
                    <tr> 
                      <td>正在...</td>
                    </tr>
                   
                    <tr> 
                      <td height="10"></td>
                    </tr>
                  </table></td>
                <td align="center" valign="top"> <table width="98%" border="0" align="center" cellpadding="0" cellspacing="0">
                    <tr> 
                      <td height="5"></td>
                    </tr>
                  </table>
                  <table width="98%" border="0" cellspacing="0" cellpadding="0">
				   <Form action="" method="post" name="theForm">
                    <tr> 
                      <td><table width="100%" border="0" cellpadding="0" cellspacing="1" bgcolor="f1f1f1">
                          <tr> 
                            <td height="23" bgcolor="f6f6f6"> &nbsp;<img src="../../Images/icon3.gif" width="12" height="16"> 
                              <Font color="#0000ff"><%= Tmp(2,0) %></Font> </td>
                          </tr>
                        </table>
                          <table width="100%" border="0" cellspacing="1" cellpadding="0">
                            <tr> 
                              <td width="15%" height="23" align="right">信息标题:</td>
                              <td width="85%" height="23"><%= Tmp(2,0) %></td>
                            </tr>
                            <tr> 
                              <td height="23" align="right" bgcolor="f9f9f9">发布时间:</td>
                              <td height="23" bgcolor="f9f9f9"><%= FormatDateTime(AddDate,2) %></td>
                            </tr>
                            <tr> 
                              <td height="23" align="right">截止时间:</td>
                              <td height="23"><%= FormatDateTime(EndDate,2) %></td>
                            </tr>
                            <tr bgcolor="f9f9f9"> 
                              <td height="23" align="right">人 数:</td>
                              <td height="23"><%= Tmp(5,0) %></td>
                            </tr>
                            <tr>
                              <td height="23" align="right">所在地区:</td>
                              <td height="23"><%= Tmp(8,0)&Tmp(9,0) %></td>
                            </tr>
                            <tr bgcolor="f9f9f9"> 
                              <td height="23" align="right">具体要求:</td>
                              <td height="23"><table width="100%" border="0" cellspacing="0" cellpadding="0">
                                  <tr> 
                                    <td height="5"></td>
                                  </tr>
                                  <tr> 
                                    <td><%= Tmp(3,0) %></td>
                                  </tr>
                                  <tr> 
                                    <td height="5"></td>
                                  </tr>
                                </table></td>
                            </tr>
                          </table>
                        <table width="100%" border="0" cellspacing="1" cellpadding="0">
                          <tr> 
                            <td height="10"></td>
                          </tr>
                        </table></td>
                    </tr>
                  </Form>
				  </table>
				  </td>
                <td width="1" bgcolor="#ddddda"></td>
              </tr>
              <tr> 
                <td colspan="4" height="1"  bgcolor="#ddddda"></td>
              </tr>
            </table>
            <table width="100%" border="0" cellspacing="0" cellpadding="0">
              <tr> 
                <td height="5"></td>
              </tr>
            </table></td>
        </tr>
      </table>
<table width="760" border="0" align="center" cellpadding="0" cellspacing="0">
  <tr> 
    <td height="1" bgcolor="#eeeeee"></td>
  </tr>
</table>
	  </td>
  </tr>
</table>
<table width="768" border="0" align="center" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF">
  <tr> 
    <td>
      <!--#include file="../../Include/Info/Footer.asp" -->
    </td>
  </tr>
</table>

</body>
</html>
<% 

'//关闭数据库连接
Set Rs = Nothing
CloseDB
 %>

⌨️ 快捷键说明

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