<%
strsql = "SELECT POSNAME, POSID, NEEDNUM,Pubdt,enddt,DWDEP FROM ZP_MEMBERZP WHERE (DWID = N'wukuangessy') AND (ENDDT >= GETDATE()) AND DWDEP= '2015年校园招聘' and status = '1' order by dwdep, disporder , posid"
Set rs_pos = Server.CreateObject("ADODB.Recordset")
rs_pos.open strsql,Application("Connstr"),1,3,1
%>
<%
if rs_pos.eof or rs_pos.bof then
response.Write("| 没有相关职位~！ |
")
response.End()
end if
dim iCount
iCount = 0
do until rs_pos.eof
iCount = iCount+1
t_dwdep = trim(rs_pos("DWDEP"))
if dwdep = "" or dwdep <> t_dwdep then
%>
| <%=t_dwdep%> |
| ◎ " target="_blank" class="j"><%=trim(rs_pos("POSNAME"))%> |
<%
dwdep = t_dwdep
iCount = 1
else
if iCount mod 3 = 1 then
%>
| ◎ " target="_blank"><%=trim(rs_pos("POSNAME"))%> |
<%
else
%>
◎ " target="_blank"><%=trim(rs_pos("POSNAME"))%> |
<%
end if
end if
rs_pos.movenext
iCount = iCount + 1
if not rs_pos.eof then
t_dwdep = trim(rs_pos("DWDEP"))
if dwdep = "" or dwdep <> t_dwdep then
%>
|
| <%=t_dwdep%> |
| ◎" target="_blank"><%=trim(rs_pos("POSNAME"))%> |
<%
dwdep = t_dwdep
iCount = 1
else
if iCount mod 3 = 1 then
%>
| ◎ " target="_blank"><%=trim(rs_pos("POSNAME"))%> |
<%
else
%>
◎ " target="_blank"><%=trim(rs_pos("POSNAME"))%> |
<%
end if
end if
rs_pos.movenext
if rs_pos.eof then
if iCount mod 3 =0 then
%>
<%
end if
if iCount mod 3 =1 then
%>
|
|
<%
end if
if iCount mod 3 =2 then
%>
|
<%
end if
end if
else
%>
|
|
<%
end if
loop
%>
