<%@ include file="/sof_intercept_norefer.jsp" %>
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%@page import="com.ucap.system.db.*,com.ucap.gecs.base.dao.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>门户网站</title>
<link href="/sofpro/gecs/styles/page.css" type="text/css" rel="stylesheet" />
<link href="/sofpro/gecs/styles/cngzlistsytle.css" rel="stylesheet" type="text/css" />
<link href="styles/cngzlistsytle.css" rel="stylesheet" type="text/css" />
<link href="styles/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
<link href="\publicfiles\model\htmltemplate\gzgov\css\cngzs_new.css" rel="stylesheet" type="text/css" />
<script>
function init(){
var tab = document.getElementById("tbody");
for (var i = 0, len = tab.rows.length; i < len; i++){
if(i%2==0){
tab.rows[i].style.backgroundColor='#fff';
}
if(i%2==1){
tab.rows[i].style.backgroundColor='#f1f1f1';
}
}
}
function cTb(val){
for(i =0 ; i < 9; i++){
document.getElementById("ctd"+i).style.backgroundImage="url(images/div_1_td02.gif)";
}
var obj = document.getElementById("ctd"+val);
obj.style.backgroundImage="url(images/column_bg.gif)";
obj.style.color="#ffffff";
}
</script>
<style type="text/css">
#tb21 td{
width:85px;
}
#tab21 th{
font-size:12px;
background-color:#E7D5BD
}
#tab21 td{
font-size:12px;
}
.style1 {font-size: 12px}
.style2 {color: #FF6600}
</style>
</head>
<body onLoad="init()">
<div id="top"><iframe height="160px" src="/publicfiles//business/htmlfiles/xixiu/smdb/index.html" frameborder=0 width="100%" scrolling=no></iframe></div>
<table width="980" height="22" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="22" align="left"><span class="style1"><img src="list_red_07.jpg" width="14" height="14"> </span></td>
<td width="958"><span class="style1"> 您的当前位置: <a href="../../../../business/htmlfiles/gzgov/index.html">首页 </a> > <a href="/publicfiles//business/htmlfiles/gzgov/index.html">政府服务 </a> > <a href="../../../../business/htmlfiles/gzgov/s2301/index.html">互动交流 </a> > <a href="../../../../business/htmlfiles/gzgov/s2301/list.html">百姓热线 </a> > 热点问题 </span></td>
</tr>
</table><br>
<div class="listcenter" id="content">
<%
DataBase dataBase = null;
com.ucap.system.db.RecordSet rs=null;
response.setCharacterEncoding("utf-8");
String oper = request.getParameter("oper") == null?"0":request.getParameter("oper");
try{
dataBase = SysDataFactory.getDataBase();
%><TABLE align="center" cellSpacing=0 width="950" cellPadding=0 style="font-size:14px; background-image:url(images/title_1_bg_02.gif); background-repeat:repeat-x; " id="tb21" border=0>
<tr align=center>
<td align="left"><strong> <span class="style2">热点问题 </span></strong></td>
<td id="ctd0" height="24px" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=0" onClick="cTb('0')">户籍</a></td>
<td id="ctd1" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=1" onClick="cTb('1')">交通</a></td>
<td id="ctd2" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=2" onClick="cTb('2')">人事</a></td>
<td id="ctd3" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=3" onClick="cTb('3')">劳动保障</a></td>
<td id="ctd4" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=4" onClick="cTb('4')">住房</a></td>
<td id="ctd5" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=5" onClick="cTb('5')">人口计划</a></v>
<td id="ctd6"style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=6" onClick="cTb('6')" >物价</a></td>
<td id="ctd7" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=7" onClick="cTb('7')">教育</a></td>
<td id="ctd8" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=8" onClick="cTb('8')">其他</a></td>
<td> </td>
</TR>
</TABLE>
<br/>
<TABLE cellSpacing=0 align="center" width="940" cellPadding=2 id="tab21" border=0> <tr>
<Th align="center" width="92" height="24px" nowrap>受理编号</Th>
<Th align="center" width="350" nowrap>主题 </Th>
<Th align="center" nowrap >作者</Th>
<Th align="center" nowrap >发布时间</Th>
<Th align="center" nowrap>状态</Th>
<Th align="center" nowrap>访问量</Th>
<Th align="center" nowrap>满意度</Th>
</TR>
<TBODY id="tbody">
<%
String sql = "SELECT HOTLINE_SEQ,HOTLINE_BH_SEQ,HOTLINE_SLBH_SEQ,ZZXBH,CATEGORY,SECRECY,SUBJECT,MAKE_CONTENT,DSG_DEPT_ID,DSG_DEPT_NAME,ATCH_1,ATCH_2,ATCH_3,MAKE_NAME,MAKE_SEX,MAKE_IP,MAKE_PHONE,MAKE_MPHONE,MAKE_MAIL,MAKE_ADD,to_char(MAKE_DATE,'mm-dd') MAKE_DATE,ACCESS_AMOUNT,SAT_TIME,SAT_CONTENT,DIS_DEPT_ID,DIS_DEPT_NAME,DIS_STATUS,STATUS,PEPLY_DEPT_ID,PEPLY_DEPT_NAME,STIPULATE_PEPLY_DATE,PEPLY_DATE,PEPLY_NAME,PEPLY_CONTENT,PEPLY_ATCH,PEPLY_OPERATE,FAQ,COMMENT_STATE,PARENT_ID,HOTLINE_EXP1,HOTLINE_EXP2,HOTLINE_EXP3,SORT,USER_ID,USER_CODE,STATUS_DESCRIPTION,REPLY_NUMBER,POINT,APPELLATION,DATE_TRANSMITTED,SECRECY_MESSAGE FROM GECS_PEOPLE_HOTLINE where HOTLINE_SEQ in( select t.hotline_seq from gecs_people_hotline_cate t where t.category='"+oper+"') order by to_number(ACCESS_AMOUNT) desc";
//out.println(sql);
rs = dataBase.execSelect(sql);
while(rs.next()){
%>
<TR>
<TD height=24 width=92 align="left" nowrap><IMG height=9 alt="" src="images/dot03.gif" width=12 align=absMiddle><%=rs.getString("HOTLINE_SLBH_SEQ")==null?"":rs.getString("HOTLINE_SLBH_SEQ")%></TD>
<TD align="left" ><a href="<%="/sofpro/gecs/webview_hotline.gecs?hotline.hotlineSeq="+rs.getString("HOTLINE_SEQ")+"&flag=view"%>" target="_blank"><%=rs.getString("SUBJECT")==null?"":rs.getString("SUBJECT")%></a></TD>
<TD align="middle" nowrap><%=rs.getString("USER_CODE")==null?"":rs.getString("USER_CODE")%></TD>
<TD align="middle" nowrap><%=rs.getString("MAKE_DATE")==null?"":rs.getString("MAKE_DATE")%></TD>
<TD align="middle" nowrap>
<%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("0")?"":"处理中")%>
<%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("1")?"":"已答复")%>
<%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("2")?"":"逾期未处理")%>
</TD>
<TD align="middle" nowrap title="访问量">
<%=rs.getString("ACCESS_AMOUNT")==null?"暂无":rs.getString("ACCESS_AMOUNT")%>
</TD>
<TD align="middle" nowrap title="内容满意度">
<%=rs.getString("SAT_CONTENT")==null?"暂无":rs.getString("SAT_CONTENT")%>
</TD>
</TR>
<%}
%></TBODY>
</TABLE>
<%
}catch(Exception e){
e.printStackTrace();
out.println(e);}finally{
try{
if(rs!=null) rs.close();
if(dataBase!=null){
dataBase.close();
}
}catch(Exception e){
// logger.debug(e.toString());
throw e;
}
//out.println("<script>history.go(-1)</script>");
}
%>
</div>
<br/>
<div id="bottom"><IFRAME height="150px" src="/publicfiles//business/htmlfiles/xixiu/wzdb/index.html"
frameBorder=0 width="100%" scrolling=no></IFRAME></div>
<script>
var val = "<%=oper%>";
document.getElementById("ctd"+val).style.backgroundImage="url(images/column_bg.gif)";
//document.getElementById("ctd"+val).getElementsById("a")[0].style.color="#FFFFFF";
var obj3 = document.getElementById("content");
//alert(obj3.clientHeight);
/*if(obj3.clientHeight <=320){
obj3.style.height=230px;
}*/
//alert(document.getElementById("ctd"+val));
</script>
</body>
</html>
<%@ page language="java" import="java.util.*,java.sql.*" pageEncoding="UTF-8"%>
<%@page import="com.ucap.system.db.*,com.ucap.gecs.base.dao.*"%><!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
<title>门户网站</title>
<link href="/sofpro/gecs/styles/page.css" type="text/css" rel="stylesheet" />
<link href="/sofpro/gecs/styles/cngzlistsytle.css" rel="stylesheet" type="text/css" />
<link href="styles/cngzlistsytle.css" rel="stylesheet" type="text/css" />
<link href="styles/SpryTabbedPanels.css" rel="stylesheet" type="text/css" />
<link href="\publicfiles\model\htmltemplate\gzgov\css\cngzs_new.css" rel="stylesheet" type="text/css" />
<script>
function init(){
var tab = document.getElementById("tbody");
for (var i = 0, len = tab.rows.length; i < len; i++){
if(i%2==0){
tab.rows[i].style.backgroundColor='#fff';
}
if(i%2==1){
tab.rows[i].style.backgroundColor='#f1f1f1';
}
}
}
function cTb(val){
for(i =0 ; i < 9; i++){
document.getElementById("ctd"+i).style.backgroundImage="url(images/div_1_td02.gif)";
}
var obj = document.getElementById("ctd"+val);
obj.style.backgroundImage="url(images/column_bg.gif)";
obj.style.color="#ffffff";
}
</script>
<style type="text/css">
#tb21 td{
width:85px;
}
#tab21 th{
font-size:12px;
background-color:#E7D5BD
}
#tab21 td{
font-size:12px;
}
.style1 {font-size: 12px}
.style2 {color: #FF6600}
</style>
</head>
<body onLoad="init()">
<div id="top"><iframe height="160px" src="/publicfiles//business/htmlfiles/xixiu/smdb/index.html" frameborder=0 width="100%" scrolling=no></iframe></div>
<table width="980" height="22" border="0" cellpadding="0" cellspacing="0">
<tr>
<td width="22" align="left"><span class="style1"><img src="list_red_07.jpg" width="14" height="14"> </span></td>
<td width="958"><span class="style1"> 您的当前位置: <a href="../../../../business/htmlfiles/gzgov/index.html">首页 </a> > <a href="/publicfiles//business/htmlfiles/gzgov/index.html">政府服务 </a> > <a href="../../../../business/htmlfiles/gzgov/s2301/index.html">互动交流 </a> > <a href="../../../../business/htmlfiles/gzgov/s2301/list.html">百姓热线 </a> > 热点问题 </span></td>
</tr>
</table><br>
<div class="listcenter" id="content">
<%
DataBase dataBase = null;
com.ucap.system.db.RecordSet rs=null;
response.setCharacterEncoding("utf-8");
String oper = request.getParameter("oper") == null?"0":request.getParameter("oper");
try{
dataBase = SysDataFactory.getDataBase();
%><TABLE align="center" cellSpacing=0 width="950" cellPadding=0 style="font-size:14px; background-image:url(images/title_1_bg_02.gif); background-repeat:repeat-x; " id="tb21" border=0>
<tr align=center>
<td align="left"><strong> <span class="style2">热点问题 </span></strong></td>
<td id="ctd0" height="24px" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=0" onClick="cTb('0')">户籍</a></td>
<td id="ctd1" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=1" onClick="cTb('1')">交通</a></td>
<td id="ctd2" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=2" onClick="cTb('2')">人事</a></td>
<td id="ctd3" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=3" onClick="cTb('3')">劳动保障</a></td>
<td id="ctd4" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=4" onClick="cTb('4')">住房</a></td>
<td id="ctd5" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=5" onClick="cTb('5')">人口计划</a></v>
<td id="ctd6"style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=6" onClick="cTb('6')" >物价</a></td>
<td id="ctd7" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=7" onClick="cTb('7')">教育</a></td>
<td id="ctd8" style="background-image:url(images/div_1_td02.gif); background-repeat:no-repeat; background-position:left; "><a href="/sofpro/gecs/hotline/hotdotlist.jsp?oper=8" onClick="cTb('8')">其他</a></td>
<td> </td>
</TR>
</TABLE>
<br/>
<TABLE cellSpacing=0 align="center" width="940" cellPadding=2 id="tab21" border=0> <tr>
<Th align="center" width="92" height="24px" nowrap>受理编号</Th>
<Th align="center" width="350" nowrap>主题 </Th>
<Th align="center" nowrap >作者</Th>
<Th align="center" nowrap >发布时间</Th>
<Th align="center" nowrap>状态</Th>
<Th align="center" nowrap>访问量</Th>
<Th align="center" nowrap>满意度</Th>
</TR>
<TBODY id="tbody">
<%
String sql = "SELECT HOTLINE_SEQ,HOTLINE_BH_SEQ,HOTLINE_SLBH_SEQ,ZZXBH,CATEGORY,SECRECY,SUBJECT,MAKE_CONTENT,DSG_DEPT_ID,DSG_DEPT_NAME,ATCH_1,ATCH_2,ATCH_3,MAKE_NAME,MAKE_SEX,MAKE_IP,MAKE_PHONE,MAKE_MPHONE,MAKE_MAIL,MAKE_ADD,to_char(MAKE_DATE,'mm-dd') MAKE_DATE,ACCESS_AMOUNT,SAT_TIME,SAT_CONTENT,DIS_DEPT_ID,DIS_DEPT_NAME,DIS_STATUS,STATUS,PEPLY_DEPT_ID,PEPLY_DEPT_NAME,STIPULATE_PEPLY_DATE,PEPLY_DATE,PEPLY_NAME,PEPLY_CONTENT,PEPLY_ATCH,PEPLY_OPERATE,FAQ,COMMENT_STATE,PARENT_ID,HOTLINE_EXP1,HOTLINE_EXP2,HOTLINE_EXP3,SORT,USER_ID,USER_CODE,STATUS_DESCRIPTION,REPLY_NUMBER,POINT,APPELLATION,DATE_TRANSMITTED,SECRECY_MESSAGE FROM GECS_PEOPLE_HOTLINE where HOTLINE_SEQ in( select t.hotline_seq from gecs_people_hotline_cate t where t.category='"+oper+"') order by to_number(ACCESS_AMOUNT) desc";
//out.println(sql);
rs = dataBase.execSelect(sql);
while(rs.next()){
%>
<TR>
<TD height=24 width=92 align="left" nowrap><IMG height=9 alt="" src="images/dot03.gif" width=12 align=absMiddle><%=rs.getString("HOTLINE_SLBH_SEQ")==null?"":rs.getString("HOTLINE_SLBH_SEQ")%></TD>
<TD align="left" ><a href="<%="/sofpro/gecs/webview_hotline.gecs?hotline.hotlineSeq="+rs.getString("HOTLINE_SEQ")+"&flag=view"%>" target="_blank"><%=rs.getString("SUBJECT")==null?"":rs.getString("SUBJECT")%></a></TD>
<TD align="middle" nowrap><%=rs.getString("USER_CODE")==null?"":rs.getString("USER_CODE")%></TD>
<TD align="middle" nowrap><%=rs.getString("MAKE_DATE")==null?"":rs.getString("MAKE_DATE")%></TD>
<TD align="middle" nowrap>
<%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("0")?"":"处理中")%>
<%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("1")?"":"已答复")%>
<%=rs.getString("STATUS")==null?"":(!rs.getString("STATUS").equals("2")?"":"逾期未处理")%>
</TD>
<TD align="middle" nowrap title="访问量">
<%=rs.getString("ACCESS_AMOUNT")==null?"暂无":rs.getString("ACCESS_AMOUNT")%>
</TD>
<TD align="middle" nowrap title="内容满意度">
<%=rs.getString("SAT_CONTENT")==null?"暂无":rs.getString("SAT_CONTENT")%>
</TD>
</TR>
<%}
%></TBODY>
</TABLE>
<%
}catch(Exception e){
e.printStackTrace();
out.println(e);}finally{
try{
if(rs!=null) rs.close();
if(dataBase!=null){
dataBase.close();
}
}catch(Exception e){
// logger.debug(e.toString());
throw e;
}
//out.println("<script>history.go(-1)</script>");
}
%>
</div>
<br/>
<div id="bottom"><IFRAME height="150px" src="/publicfiles//business/htmlfiles/xixiu/wzdb/index.html"
frameBorder=0 width="100%" scrolling=no></IFRAME></div>
<script>
var val = "<%=oper%>";
document.getElementById("ctd"+val).style.backgroundImage="url(images/column_bg.gif)";
//document.getElementById("ctd"+val).getElementsById("a")[0].style.color="#FFFFFF";
var obj3 = document.getElementById("content");
//alert(obj3.clientHeight);
/*if(obj3.clientHeight <=320){
obj3.style.height=230px;
}*/
//alert(document.getElementById("ctd"+val));
</script>
</body>
</html>
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货