📄 order.jsp
字号:
<%@ page contentType="text/html; charset=GBK" %>
<%@ include file="/inc/pv/admin.jsp"%>
<%@ include file="/inc/public/msg.jsp"%>
<%
%>
<%
igec.site.base.bean.SysObj info = new igec.site.base.bean.SysObj();
info.setStrValue1(igec.util.Tool.getStr(request.getParameter("table")));
if(igec.util.Tool.IsEmpty(info.getStrValue1())){
showError("没有输入待排序的表名!",out);
return;
}
info.setStrValue2(igec.util.Tool.getStr(request.getParameter("xh")));
if(igec.util.Tool.IsEmpty(info.getStrValue2())) info.setStrValue2("XH");
info.setStrValue3(igec.util.Tool.getStr(request.getParameter("id")));
if(igec.util.Tool.IsEmpty(info.getStrValue3())) info.setStrValue3("ID");
info.setStrValue4(igec.util.Tool.getStr(request.getParameter("limit")));
String strPosType=request.getParameter("PosType");
String strPosId=request.getParameter("PosId");
/***************************在此处增加对应的表搜索字符串***************************/
if("TAB_IGECMODELT".equals(info.getStrValue1())){
info.setStrValue4("WHERE TYPE='" + request.getParameter("type") + "'");
}else if("TAB_SPECIALTYPE".equals(info.getStrValue1())){
info.setStrValue4("WHERE PARENTID='" + request.getParameter("pid") + "'");
}else if("TAB_WEBLINK".equals(info.getStrValue1())){
info.setStrValue4("WHERE TYPE=" + igec.util.Tool.getStr(request.getParameter("type")));
}else if("TAB_INTROTYPE".equals(info.getStrValue1())){
info.setStrValue4("WHERE PARENTID='" + igec.util.Tool.getStr(request.getParameter("pid")) + "'");
}else if("TAB_SOFTINFO".equals(info.getStrValue1())){
info.setStrValue4("WHERE ITEMID='" + request.getParameter("iid") + "' and POSTYPE='"+strPosType+"' and POSID='"+strPosId+"'");
}else if("TAB_IGECSMSINFO".equals(info.getStrValue1())){
info.setStrValue4("WHERE PID='" + request.getParameter("pid") + "'");
}else if("TAB_IGECDEPT".equals(info.getStrValue1())){
info.setStrValue4("WHERE PID='" + request.getParameter("pid") + "'");
}else if("TAB_SYSHELP".equals(info.getStrValue1())){
info.setStrValue4("WHERE TYPEID IN (SELECT ID FROM TAB_INDEXTYPE WHERE FULLPATH LIKE '%," + request.getParameter("pid") + ",%' AND TYPE=13)");
}else if("TAB_TJINFO".equals(info.getStrValue1())){
info.setStrValue4("WHERE TYPEID IN (SELECT ID FROM TAB_INDEXTYPE WHERE FULLPATH LIKE '%," + request.getParameter("pid") + ",%' AND TYPE=14)");
}else if("TAB_IGECINDTYPE".equals(info.getStrValue1())){
info.setStrValue4("WHERE PARENTID='" + igec.util.Tool.getStr(request.getParameter("pid")) + "'");
}else if("TAB_WEBVOTE".equals(info.getStrValue1())){
info.setStrValue4("WHERE PARENTID='" + igec.util.Tool.getStr(request.getParameter("pid")) + "'");
}else if("TAB_WEBVOTEINFO".equals(info.getStrValue1())){
info.setStrValue4("WHERE VOTEID='" + igec.util.Tool.getStr(request.getParameter("vid")) + "'");
}else if("TAB_UPFILEINFO".equals(info.getStrValue1())){
info.setStrValue4("WHERE TYPE=" + igec.util.Tool.getStr(request.getParameter("type")));
}
/**********************************************************************************/
info.setStrValue5(igec.util.Tool.getStr(request.getParameter("title")));
if(igec.util.Tool.IsEmpty(info.getStrValue5())) info.setStrValue5("TITLE");
java.util.ArrayList lists = new java.util.ArrayList();
int iFlag = igec.site.base.business.MOrderBusiness.getOrderRs(lists,info);
if(iFlag<0){
showError(out);
return;
}
%>
<html>
<head>
<title>排序管理</title>
<meta http-equiv="Content-Type" content="text/html; charset=GBK">
<link rel="stylesheet" type="text/css" href="<%=strCssPath%>">
<script language="javascript" src="<%=site.bean.SitePara.strVirtualName%>/js/public.js"></script>
<script language="javascript" src="<%=site.bean.SitePara.strVirtualName%>/js/order.js"></script>
<script language="javascript" src="<%=site.bean.SitePara.strVirtualName%>/js/xmlhttp.js"></script>
<script language="javascript">
<!--
function sendForm(loForm){
MakeResult();
try{
aJax_SendForm(loForm,"");
}catch(eee){
alert(eee.description);
}
}
//-->
</script>
</head>
<body class="bodycolor" topmargin="5" onload="resizeWin('objBody');">
<table name="objBody" id="objBody" width="500" border="1" cellspacing="0" cellpadding="3" align="center" bordercolorlight="#000000" bordercolordark="#FFFFFF" class="big">
<form action="<%=site.bean.SitePara.strVirtualName + site.bean.SitePara.strManageFolder%>/order.do?action=save&iid=<%=strMenuId%>" onsubmit="javascript:sendForm(this);return false;" method="post">
<input type="hidden" name="table" id="table" value="<%=info.getStrValue1()%>">
<input type="hidden" name="xh" id="xh" value="<%=info.getStrValue2()%>">
<input type="hidden" name="id" id="id" value="<%=info.getStrValue3()%>">
<input type="hidden" name="limit" id="limit" value="">
<input type="hidden" name="title" id="title" value="<%=info.getStrValue5()%>">
<tr bgcolor="#CCCCCC">
<td align="center"><b>排序结果</b></td>
<td align="center">排序</td>
</tr>
<tr>
<td valign="top" align="center" bgcolor="#CCCCCC">
<select name="SELIST" style="width:400;height:300" size="15">
<%
for(int i=0;i<lists.size();i++){
igec.site.base.bean.SysObj so = (igec.site.base.bean.SysObj)lists.get(i);
%>
<option value="<%=so.getStrValue1()%>"><%=so.getStrValue2()%></option>
<%
}
%>
</select>
</td>
<td align="center" bgcolor="#999999">
<input type="button" class="SmallInput" value=" TOP " onclick="UpToTop();" title="移动至顶部">
<br>
<input type="button" class="SmallInput" value=" ↑ " onclick="UpOneStep();" title="上移一位">
<br><br>
<input type="button" class="SmallInput" value=" ↓ " onclick="DownOneStep();" title="下移一位">
<br><br>
<input type="button" class="SmallInput" value=" BOT " onclick="DownToBottom();" title="移动至底部">
</td>
</tr>
<tr bgcolor="#CCCCCC">
<td align="center" valign="top" colspan="4">
<input type="submit" class="BigButton" value="保 存">
<input type="button" value="关闭" class="BigButton" onClick="window.close();">
</td>
</tr>
<%
for(int i=0;i<lists.size();i++){
igec.site.base.bean.SysObj so = (igec.site.base.bean.SysObj)lists.get(i);
%>
<input type="hidden" name="LIST<%=so.getStrValue1()%>" id="LIST<%=so.getStrValue1()%>" value="<%=i%>">
<%
}
%>
</form>
</table>
</body>
</html>
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -