📄 article.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.MenuBean menuBean = null;
try{
myBean = new oa.bean.ArticleBean();
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);
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 news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
if(!select2.equals("null"))
{
select2 = ds.toGBK(select2);
if(select1.equals("0"))
sel = "where news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and (news.article.title like '%"+select2+"%' or news.article.keyword like '"+select2+"') and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
if(select1.equals("1"))
sel = "where news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and news.article.title like '%"+select2+"%' and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
if(select1.equals("3"))
sel = "where news.article.writer='"+uid+"' and news.article.organid='00000000000000000000' and news.article.menuid in("+menus+") and news.article.keyword like '%"+select2+"%' and news.article.writer=news.zz_zgb.zgbh order by news.article.organid,news.article.addtime desc";
}
}
if(strId.equals("2"))
{
//sel = "where "/*(organid in ("+orgqx+")) or */
//+"(ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) and menuid in("+menus+") order by organid,addtime desc";
sel = "where ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(!select2.equals("null"))
{
select2 = ds.toGBK(select2);
if(select1.equals("0"))
//sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ( "/*(organid in ("+orgqx+")) or */+"(ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("1"))
//sel = "where title like '%"+select2+"%' and ("/*(organid in ("+orgqx+")) or */+"(ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
sel = "where title like '%"+select2+"%' and ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("2"))
//sel = "where XM like '%"+select2+"%' and ("/*(organid in ("+orgqx+")) or*/+" (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
sel = "where XM like '%"+select2+"%' and ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("3"))
//sel = "where keyword like '%"+select2+"%' and ((ifshow='1' and ifimg='0' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='0' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='0' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='0' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='1' and ifimg='1' and ifhead='1' and ifgood='1' and organid='00000000000000000000' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") order by organid,addtime desc";
sel = "where keyword like '%"+select2+"%' and ifshow='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
}
}
if(strId.equals("3"))
{
//sel = "where ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
sel = "where ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(!select2.equals("null"))
{
select2 = ds.toGBK(select2);
if(select1.equals("0"))
//sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("1"))
//sel = "where title like '%"+select2+"%' and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
sel = "where title like '%"+select2+"%' and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("2"))
//sel = "where XM like '%"+select2+"%' and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
sel = "where XM like '%"+select2+"%' and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("3"))
//sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+goodqx1+") and whichtable='1') order by organid,addtime desc";
sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifgood='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
}
}
if(strId.equals("4"))
{
//sel = "where ifshow='1' and ifhead='1' and organid='00000000000000000000' and menuid in("+menus+") and (menuid in ("+headqx1+") and whichtable='1') order by organid,addtime desc";
sel = "where ifshow='1' and ifhead='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(!select2.equals("null"))
{
select2 = ds.toGBK(select2);
if(select1.equals("0"))
//sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("1"))
//sel = "where title like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where title like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("2"))
//sel = "where XM like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where XM like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("3"))
//sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifhead='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
}
}
if(strId.equals("5"))
{
//sel = "where ifshow='1' and ifimg='1' and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where ifshow='1' and ifimg='1' and organid='00000000000000000000' and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(!select2.equals("null"))
{
select2 = ds.toGBK(select2);
if(select1.equals("0"))
//sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("1"))
//sel = "where title like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where title like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("2"))
//sel = "where XM like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where XM like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("3"))
//sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2')) order by organid,addtime desc";
sel = "where keyword like '%"+select2+"%' and ifshow='1' and ifimg='1' and menuid in("+menus+") and organid='00000000000000000000' and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
}
}
if(strId.equals("6"))
{
sel = "where organid='00000000000000000000' and (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(!select2.equals("null"))
{
select2 = ds.toGBK(select2);
if(select1.equals("0"))
sel = "where organid='00000000000000000000' and (XM like '%"+select2+"%' or title like '%"+select2+"%' or keyword like '%"+select2+"%') and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("1"))
sel = "where organid='00000000000000000000' and title like '%"+select2+"%' and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("2"))
sel = "where organid='00000000000000000000' and XM like '%"+select2+"%' and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
if(select1.equals("3"))
sel = "where organid='00000000000000000000' and keyword like '%"+select2+"%' and ((ifshow='0' and ifimg='0' and ifhead='0' and ifgood='0' and ((menuid in ("+showqx1+") and whichtable='1') or (menuid in ("+showqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='0' and ((menuid in ("+imgqx1+") and whichtable='1') or (menuid in ("+imgqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='0' and ifgood='1' and ((menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='0' and ((menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='0' and ifgood='1' and ((menuid in ("+imgqx1+") and menuid in ("+goodqx1+") and whichtable='1') or (menuid in ("+goodqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='0' and ((menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='0' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+goodqx2+")and whichtable='2'))) or (ifshow='0' and ifimg='1' and ifhead='1' and ifgood='1' and ((menuid in ("+goodqx1+") and menuid in ("+imgqx1+") and menuid in ("+headqx1+") and whichtable='1') or (menuid in ("+headqx2+") and menuid in ("+imgqx2+") and menuid in ("+goodqx2+")and whichtable='2')))) and menuid in("+menus+") and news.article.writer=news.zz_zgb.zgbh order by organid,addtime desc";
}
}
if(select3.equals("1"))
{
sel = ds.toString((String)request.getParameter("txt_sel"));
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -