?? allarticle.jsp
字號:
<%@page language="java" contentType="text/html;charset=GBK"%>
<%@page import="java.util.*,java.io.*,oa.main.DealString"%>
<%
oa.bean.ArticleBean myBean = null;
oa.bean.RightBean myRitBean = null;
oa.bean.MenuBean menuBean = null;
try{
myBean = new oa.bean.ArticleBean();
myRitBean = new oa.bean.RightBean();
menuBean = new oa.bean.MenuBean();
DealString ds = new DealString();
//取得菜單類別
String strType = ds.toString((String)request.getParameter("txt_type"));
if(strType.equals(""))strType = "1";
//那個分頁
String strId = ds.toString((String)request.getParameter("t"));
//操作權限 0:瀏覽 1：增刪改
String czqx = "0";
//文章搜索條件
String select1 = ds.toString((String)request.getParameter("sel1"));
String select2 = ds.toString((String)request.getParameter("sel2"));
String select3 = ds.toString((String)request.getParameter("sel3"));
String currentBM = ds.toString((String)request.getParameter("menuid"));//分版面管理
//權限控制
String uid = (String)session.getAttribute("zgbh");
//Hashtable htbmqx = (Hashtable)myBean.getbmqx(uid);
menuBean.setUID(uid);
myRitBean.setUID(uid);
Hashtable htbmqx = (Hashtable)menuBean.getqx(uid,currentBM);
String showqx1 = (String)htbmqx.get("SHOW1");//所有可審批的位于menu表中的版面
if(showqx1.equals(""))
showqx1="-1";
String showqx2 = "";//(String)htbmqx.get("SHOW2");//所有可審批的位于menuchild表中的版面
if(showqx2.equals(""))
showqx2="-1";
String imgqx1 = (String)htbmqx.get("IMG1");//所有可審批圖片的位于menu表中的版面
if(imgqx1.equals(""))
imgqx1="-1";
String imgqx2 ="";// (String)htbmqx.get("IMG2");//所有可審批圖片的位于menuchild表中的版面
if(imgqx2.equals(""))
imgqx2="-1";
String headqx1 = (String)htbmqx.get("HEAD1");//所有可審批首頁的位于menu表中的版面
if(headqx1.equals(""))
headqx1="-1";
String headqx2 = "";//(String)htbmqx.get("HEAD2");//所有可審批首頁的位于menuchild表中的版面
if(headqx2.equals(""))
headqx2="-1";
String goodqx1 = (String)htbmqx.get("GOOD1");//所有可審批焦點的位于menu表中的版面
if(goodqx1.equals(""))
goodqx1="-1";
String goodqx2 ="";// (String)htbmqx.get("GOOD2");//所有可審批焦點的位于menuchild表中的版面
if(goodqx2.equals(""))
goodqx2="-1";
String admin_menus = menuBean.getAdminDown(currentBM);
String menus = menuBean.getDown(currentBM);
// Hashtable htorgqx = (Hashtable)myBean.getorgqx(uid);
// String orgqx = (String)htorgqx.get("GL");
/// if(orgqx.equals(""))
// orgqx="-1";
//查詢語句
String sel = "";
if(strId.equals("1"))
{
sel = "where article.organid='00000000000000000000' order by article.organid,article.addtime desc";
}
if(select3.equals("1"))
{
sel = ds.toString((String)request.getParameter("txt_sel"));
}
String bm = (String)request.getParameter("bm");
if(bm==null) bm = "1";
if(bm.equals(""))bm = "1";
int cur = Integer.parseInt(bm);
Vector vect = (Vector)myBean.getOnePage(sel,cur,5);
int sum = Integer.parseInt((String)vect.get(0));
int i = 0;
int j = 0;
%>
<table width="95%" cellspacing="1" cellpadding="5" bgcolor=#999999 align=center>
<tr bgColor=#dbcfff >
<td colspan=20 align=right>
文章搜索： 
<select name="select1">
<option value="0" selected>模糊查詢</option>
<option value="1">文章標題</option>
<%if(!strId.equals("1")){%><option value="2">錄入員</option><%}%>
<option value="3">文章關鍵字</option>
</select>
 
<input type=text name=select2 size=20>
 
<input type=button value="搜索" onclick="selectart();" style="cursor:hand;background-color:#ffffff;">
</td>
</tr>
<tr bgColor=#ffffff >
<td colspan=20><center>
<b>文章列表</b></center></td>
</tr>
<tr bgcolor=#ffcc00 align=center >
<td width=20> </td>
<td ><b>編號</b></td>
<td ><b>文章標題</b></td>
<td ><b>錄入</b></td>
<td ><b>發表時間</b></td>
<%if(strId.equals("1")||strId.equals("2")){%>
<td ><b>所屬版面</b></td>
<%}%>
<td><b>焦點</b></td>
<td><b>首頁</b></td>
<td><b>圖片</b></td>
<td><b>審閱</b></td>
<td width=60><b>操作</b></td>
</tr>
<%
for(i=1;i<vect.size();i++)
{
Hashtable hash = (Hashtable)vect.get(i);
String[] str = new String[13];
str[0]=(String)hash.get("ID");
str[1]=(String)hash.get("TITLE");
str[2]=(String)hash.get("WRITER");
str[3]=(String)hash.get("ADDTIME");
str[4]=(String)hash.get("IFGOOD");
str[5]=(String)hash.get("IFHEAD");
str[6]=(String)hash.get("IFIMG");
str[7]=(String)hash.get("IFSHOW");
str[8]=(String)hash.get("ORGANID");
str[9]=(String)hash.get("MENUID");
//System.out.println("---"+str[8]);
str[11] = (String)hash.get("EDITER");
str[12] = (String)hash.get("EDITTIME");
if(str[4].equals("1"))
str[4] = "是";
else
str[4] = "否";
if(str[5].equals("1"))
str[5] = "是";
else
str[5] = "否";
if(str[6].equals("1"))
str[6] = "是";
else
str[6] = "否";
if(str[7].equals("1"))
str[7] = "是";
else
str[7] = "否";
menuBean.setID(Integer.parseInt(str[9]));
boolean isadmin = ((","+admin_menus+",").indexOf(","+str[9]+",")!=-1);
str[10] = menuBean.toname();
str[9] = myBean.toName("MENU","ID","MENU1",str[9]);
if(!str[11].equals(""))
str[11] ="審批人："+ myBean.toName("ZZ_ZGB","ZGBH","XM",str[11])+" 審批時間："+str[12];
%>
<TR bgColor=#ffffff height="22">
<td><%if(!(strType.equals("1")&&str[7].equals("是"))&&(isadmin)){j++;%><input type=checkbox name=checkboxid value="<%=str[0]%>"><%}%></td>
<TD align=center><%=i%></TD>
<TD align=left><a onclick="see('<%=str[0]%>')" style="cursor:hand" title="<%=str[11]%>"><font color=#CC0000><%=str[1]%></font></a></TD>
<TD align=center><%=(String)myBean.toName("zz_zgb","zgbh","xm",str[2])%></TD>
<TD align=center ><%=str[3]%></TD>
<%if(strId.equals("1")||strId.equals("2")){%>
<td align=center title="<%=str[10]%>"><%=str[9]%></td>
<%}%>
<TD align=center><%=str[4]%></TD>
<TD align=center><%=str[5]%></TD>
<TD align=center><%=str[6]%></TD>
<TD align=center><%=str[7]%></TD>
<TD align=center>
<FONT color="#99cc00">
<%if(strType.equals("1")){%>
<%if(str[7].equals("否")){%>
<a onclick="mod('<%=str[0]%>','1');" style="cursor:hand;">修改</a>
<%}else{%>
<a onclick="see('<%=str[0]%>');" style="cursor:hand;">瀏覽</a>
<%}%>
<%}%>
<%if(!(strType.equals("1")||strType.equals("6"))){%>
<a onclick="see('<%=str[0]%>');" style="cursor:hand;">瀏覽</a>
<%}%>
<%if(strType.equals("6")){%>
<a onclick="mod('<%=str[0]%>','6');" style="cursor:hand;">修改</a><!-- |
<a onclick="see('<%=str[0]%>');" style="cursor:hand;">瀏覽</a>-->
<a onclick="showart('<%=str[0]%>');" style="cursor:hand;">審批</a>
<%}%>
<%if(strType.equals("2")){
Vector v=myBean.getDataBySql("select * from news.commentb where articleid="+str[0]+" order by time desc");
%>
<a onclick="javascript:window.open('comment.jsp?id=<%=str[0]%>&title=<%=str[1]%>','評論管理','height=350,width=600,scrollbars=yes,resizable=yes,left=200,top=200');" style="cursor:hand;"><%if(v.size()>0) out.print("評論");%></a>
<%}%>
</FONT>
</TD>
</TR>
<%
}
%>
<input type=hidden name="txt_leixing">
<input type=hidden name="txt_value">
<input type=hidden name="txt_sel" value="<%=sel%>">
<%if(j>=1){%>
<tr>
<TD align=left colspan=20>
<%if(j>=2){%>
<input type=button value="全選" name=selall onclick="selectall();" style="cursor:hand;">   
<%}%>
<input type=button value="刪除" onclick="return del();" style="cursor:hand;"></td>
</tr>
<%}%>
<TR>
<TD align=right bgColor=#dbcfff colspan=20>當前<%=cur%>/<%=sum%>頁   <a onclick="gotopage('1')" style="cursor:hand;">第一頁    </a>
<%if(cur>1){int t=cur-1;%><a onclick="gotopage('<%=t%>')" style="cursor:hand;">上一頁    </a><%}%>
<%if(cur<sum){int s=cur+1;%><a onclick="gotopage('<%=s%>')" style="cursor:hand;">下一頁   </a><%}%>
<a onclick="gotopage('<%=sum%>')" style="cursor:hand;">最后頁    </a>
直接<input type=image src="../images/hand.gif" name="gotof" onclick="return checkdata();">
<input type=text size=2 name=bm class=formcolor>頁</TD>
</TR>
</TABLE>
<script>
var czqx = "<%=czqx%>";
var uid = "<%=uid%>";
function selectall()
{
var num = document.all.checkboxid.length;
if(document.all.selall.value == "全選")
{
for(var i=0;i<num;i++)
{
document.all.checkboxid[i].checked = true;
}
document.all.selall.value = "取消全選";
}
else
{
for(var i=0;i<num;i++)
{
document.all.checkboxid[i].checked = false;
}
document.all.selall.value = "全選";
}
}
function gotopage(id)
{
document.all.txt_type.value = "<%=strType%>";
document.all.form1.action = "index.jsp?bm="+id+"&sel3=1";
document.all.form1.submit();
}
function selectart()
{
document.all.select2.value = trim(document.all.select2.value);
if(document.all.select2.value==""){
alert("請輸入查詢內容");
return false;
}
document.all.txt_type.value = "<%=strType%>";
document.all.form1.action = "index.jsp?sel1="+document.all.select1.value+"&sel2="+document.all.select2.value;
document.all.form1.submit();
}
function change(articleid,type,value,uid1)
{
if(uid!=uid1&&czqx=="0")
{
alert("您無權修改本文章！");
return false;
}
if(uid==uid1&&czqx=="0"&&type=="4")
{
alert("您無權審批文章！");
return false;
}
document.all.txt_type.value = "<%=strType%>";
document.all.txt_id.value = articleid;
document.all.txt_leixing.value = type;
document.all.txt_value.value = value;
document.all.txt_edit.value = "1";
document.all.form1.action = "../../manageservlet";
document.all.form1.submit();
}
function mod(id,wh)
{
document.all.txt_type.value = "11";
document.all.txt_id.value = id;
document.all.txt_edit.value = "2";
document.all.form1.action = "index.jsp?where="+wh;
document.all.form1.submit();
}
function showart(id)
{
var oawin = window.open("view.jsp?show=1&id="+id,"_blank","height=500,width=730,scrollbars=yes,resizable=yes,left=30,top=30");
oawin.focus();
oawin.opener=window;
}
function see(id)
{
var oawin = window.open("view.jsp?id="+id,"_blank","height=500,width=730,scrollbars=yes,resizable=yes,left=30,top=30");
oawin.focus();
oawin.opener=window;
}
function del()
{
var delid = "";
var num = <%=j%>;
if(num==1)
{
if(document.all.checkboxid.checked==true)
delid = document.all.checkboxid.value;
}
if(num>=2)
{
var numid = document.all.checkboxid.length;
for(var i=0;i<numid;i++)
{
if(document.all.checkboxid[i].checked == true)
{
if(delid == "")
{
delid = document.all.checkboxid[i].value;
}
else
{
delid = delid+","+document.all.checkboxid[i].value;
}
}
}
}
if(delid=="")
{
alert("請選擇要刪除的文章！");
return false;
}
if(!confirm("是否真的要刪除？"))
{
return false;
}
document.all.txt_type.value = "<%=strType%>";
document.all.txt_id.value = delid;
document.all.txt_edit.value = "3";
document.all.form1.action = "../../manageservlet";
document.all.form1.submit();
}
function isDigit(str)
{
var bool = true;
for(var i=0;i<str.length;i++)
{
if(!(str.charAt(i)>=0&&str.charAt(i)<=9))
{
bool = false;
break;
}
}
return bool;
}
function checkdata()
{
if(!isDigit(document.all.bm.value))
{
alert("輸入的頁碼不是數字!");
document.all.bm.value="";
return false;
}
if(document.all.bm.value=="")
{
alert("請輸入頁碼!");
document.all.bm.value="";
return false;
}
else
{
var t = document.all.bm.value;
var cur = "<%=cur%>";
var sum = "<%=sum%>";
while(t.length>cur.length)
{
alert("請跳至1和"+sum+"之間!");
document.all.bm.value="";
return false;
}
if(t==cur){return false;}
while(t.length>sum.length)
{
alert("請跳至1和"+sum+"之間!");
document.all.bm.value="";
return false;
}
if(t<1||t>sum)
{
alert("請跳至1和"+sum+"之間!");
document.all.bm.value="";
return false;
}
}
document.all.txt_type.value = "<%=strType%>";
document.all.form1.action = "index.jsp?bm="+document.all.bm.value+"&sel3=1";
document.all.form1.submit();
}
function trim(str){
var i,j;
for(i=0;i<str.length;i++){
if(str.charAt(i)!=' ')
break;
}
for(j=str.length;j>0;j--){
if(str.charAt(i)!=' ')
break;
}
if(i<=j)
return str.substring(i,j);
else
return "";
}
</script>
<%}
finally{
if(myBean!=null)myBean.closeConn();
if(myRitBean!=null)myRitBean.closeConn();
if(menuBean!=null)menuBean.closeConn();
}%>?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -