<%=areaName%>招標網
<%@ include file="top_newpage.jsp"%>
beplay网页版本
更多>>
<%
Statement stmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet rsgg=zhaobiao(conn,stmt,areaId,10,43,0);
while(rsgg.next()){
String title=rsgg.getString("title");
if(title.length()>31){
title=title.substring(0,31);
}
String url1 = rsgg.getString("url").replace("www.qianlima.com","www.acssig.com");
out.println(" ");
}
%>
中標通知 更多>>
<%
Statement zstmt = conn.createStatement(ResultSet.TYPE_SCROLL_SENSITIVE,ResultSet.CONCUR_UPDATABLE);
ResultSet zrsgg=zhaobiao(conn,zstmt,areaId,10,43,3);
while(zrsgg.next()){
String title=zrsgg.getString("title");
if(title.length()>31){
title=title.substring(0,31);
}
String url1 = zrsgg.getString("url").replace("www.qianlima.com","www.acssig.com");
out.println(" ");
}
%>
beplay网址更新
<%
TransQuerys tq = new TransQuerys(1001, 0, 100);
QueryEntry qe = new QueryEntry();
qe.addCatId(101, -1);
qe.addArea(areaId);
tq.add(qe);
TCPLink.QueryTo qt = null;
TransResult res = null;
qt = zhiNengSearch();//new TCPLink.QueryTo("192.168.1.116",50016);
res = TCPLink.getQueryResult(tq,qt);
ArrayList lst = (res==null)?null:res.ids;
String IDS_ = lst==null?"":lst.toString().replace('[',' ').replace(']', ' ');
if(IDS_!=null&&IDS_.trim().length()!=0){
String sqlzj="select p.contentid,p.url,p.updatetime,p.title,z.tze,z.jzjd from phpcms_content p,zdy_xm_all z where p.contentid=z.id and p.status=99 and contentid in ( "+IDS_+" ) order by p.updatetime desc;";
ResultSet rszj=conn.createStatement().executeQuery(sqlzj);
int jdcount = 0;
while(rszj.next()){
String jieduan=rszj.getString("z.jzjd");
if(jieduan.trim().length()==0){
continue;
}
String zijin=rszj.getString("z.tze");
if("0".equals(zijin)){
continue;
}
if(jdcount==10){
break;
}
jdcount++;
String title=rszj.getString("p.title");
if(title.length()>35){
title=title.substring(0,35);
}
String url1 = rszj.getString("p.url").replace("www.qianlima.com","www.acssig.com");;
out.println("");
}
}
%>
招標機構 更多>>
<%
PreparedStatement pps ;
//sql組合查詢,通過phpcms_area表.areaid=zdy_agents.proviceid匹配, 取出phpcms_area的地區名稱。
String sql="select id,name,proviceid,(select name from phpcms_area where parentid=0 and areaid =proviceid) as dqname from zdy_agents where 1>0 and proviceid="+areaId;
sql = String.format(sql+" and inuse=1 order by id desc limit 10");
pps = conn.prepareStatement(sql);
ResultSet rs2 = pps.executeQuery();
while(rs2.next()){
String dqname = rs2.getString("dqname");
%>
<%
}
%>
beplay让球
<%
int vipcount=0;
String ids_vip=xiangmu(conn,stmt,areaId,201);
if(ids_vip.length()>2){
String sqlvip="select p.contentid,p.url,p.title,x.jzjd,x.tze,p.updatetime from zdy_xm_extenddetails a,phpcms_content p,zdy_xm_all x where p.contentid=a.xmid and p.contentid=x.id and p.contentid in ("+ids_vip+") and p.status = 99 order by p.updatetime desc";
ResultSet rsvip=conn.createStatement().executeQuery(sqlvip);
while(rsvip.next()){
if(vipcount==8){
break;
}
vipcount++;
String title=rsvip.getString("p.title");
if(title.length()>35){
title=title.substring(0,35);
}
String url1 = rsvip.getString("p.url").replace("www.qianlima.com","www.acssig.com");;
out.println("");
}
}
%>